Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 6
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

[]

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1

[
  "fuck his mom"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fuck his mom' LIMIT 1;

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=? LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=? WHERE p.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  502816
  689379
  586400
  511160
  521077
  526454
  567855
  520681
  600843
  563875
  523650
  683902
  815935
  518940
  505811
  589036
  522215
  630475
  462477
  489646
  606806
  601147
  603713
  463614
  523840
  512733
  514832
  526545
  488132
  512377
  510301
  510177
  483569
  517369
  712891
  586554
  716220
  497447
  573234
  455206
  518858
  671395
  524142
  459513
  494231
  564824
  449881
  563218
  556027
  566110
  513050
  447679
  516103
  532499
  517386
  528089
  606948
  605496
  535344
  562894
  608376
  621489
  619107
  617167
  486536
  535511
  512952
  563441
  570765
  591415
  532255
  573754
  473499
  502741
  516227
  520803
  617212
  542914
  519023
  586484
]

SELECT
  p.post_id,
  p.user_id,
  p.content_id,
  p.public_key,
  p.search_field,
  p.cover,
  p.type,
  p.sexual_orientation,
  p.orientation,
  p.quality,
  p.noindex,
  p.nofollow,
  p.contents_num,
  p.duration,
  p.likes,
  p.dislikes,
  p.views,
  p.vote_rating,
  p.params,
  p.published_at,
  IFNULL(`r`.`title`, `f`.`title`) as `title`,
  IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`,
  IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2`
FROM
  post p
  LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`
  AND `f`.`lang_id` = ?
  LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`
  AND `r`.`lang_id` = ?
WHERE
  p.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT p.post_id, p.user_id, p.content_id, p.public_key, p.search_field, p.cover, p.type, p.sexual_orientation, p.orientation, p.quality, p.noindex, p.nofollow, p.contents_num, p.duration, p.likes, p.dislikes, p.views, p.vote_rating, p.params, p.published_at, IFNULL(`r`.`title`, `f`.`title`) as `title`, IFNULL(`r`.`custom1`, `f`.`custom1`) as `custom1`, IFNULL(`r`.`custom2`, `f`.`custom2`) as `custom2` FROM post p LEFT JOIN post_translation f ON `p`.`post_id` = `f`.`post_id`  AND  `f`.`lang_id`=1 LEFT JOIN post_translation r ON `p`.`post_id` = `r`.`post_id`  AND  `r`.`lang_id`=2 WHERE p.post_id IN (502816, 689379, 586400, 511160, 521077, 526454, 567855, 520681, 600843, 563875, 523650, 683902, 815935, 518940, 505811, 589036, 522215, 630475, 462477, 489646, 606806, 601147, 603713, 463614, 523840, 512733, 514832, 526545, 488132, 512377, 510301, 510177, 483569, 517369, 712891, 586554, 716220, 497447, 573234, 455206, 518858, 671395, 524142, 459513, 494231, 564824, 449881, 563218, 556027, 566110, 513050, 447679, 516103, 532499, 517386, 528089, 606948, 605496, 535344, 562894, 608376, 621489, 619107, 617167, 486536, 535511, 512952, 563441, 570765, 591415, 532255, 573754, 473499, 502741, 516227, 520803, 617212, 542914, 519023, 586484);

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=? LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=? WHERE pht.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  447679
  449881
  455206
  459513
  462477
  463614
  473499
  483569
  486536
  488132
  489646
  494231
  497447
  502741
  502816
  505811
  510177
  510301
  511160
  512377
  512733
  512952
  513050
  514832
  516103
  516227
  517369
  517386
  518858
  518940
  519023
  520681
  520803
  521077
  522215
  523650
  523840
  524142
  526454
  526545
  528089
  532255
  532499
  535344
  535511
  542914
  556027
  562894
  563218
  563441
  563875
  564824
  566110
  567855
  570765
  573234
  573754
  586400
  586484
  586554
  589036
  591415
  600843
  601147
  603713
  605496
  606806
  606948
  608376
  617167
  617212
  619107
  621489
  630475
  671395
  683902
  689379
  712891
  716220
  815935
]

SELECT
  pht.post_id,
  pht.tag_id,
  t.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_tag pht
  INNER JOIN tag t ON pht.tag_id = t.tag_id
  AND t.enabled = 1
  LEFT JOIN tag_translation f ON t.tag_id = f.tag_id
  AND f.lang_id = ?
  LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id`
  AND `r`.`lang_id` = ?
WHERE
  pht.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT pht.post_id, pht.tag_id, t.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_tag pht INNER JOIN tag t ON pht.tag_id = t.tag_id AND t.enabled = 1 LEFT JOIN tag_translation f ON t.tag_id = f.tag_id AND f.lang_id=1 LEFT JOIN tag_translation r ON `t`.`tag_id` = `r`.`tag_id` AND `r`.`lang_id`=2 WHERE pht.post_id IN (447679, 449881, 455206, 459513, 462477, 463614, 473499, 483569, 486536, 488132, 489646, 494231, 497447, 502741, 502816, 505811, 510177, 510301, 511160, 512377, 512733, 512952, 513050, 514832, 516103, 516227, 517369, 517386, 518858, 518940, 519023, 520681, 520803, 521077, 522215, 523650, 523840, 524142, 526454, 526545, 528089, 532255, 532499, 535344, 535511, 542914, 556027, 562894, 563218, 563441, 563875, 564824, 566110, 567855, 570765, 573234, 573754, 586400, 586484, 586554, 589036, 591415, 600843, 601147, 603713, 605496, 606806, 606948, 608376, 617167, 617212, 619107, 621489, 630475, 671395, 683902, 689379, 712891, 716220, 815935);

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=? LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=? WHERE phc.post_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  1
  2
  447679
  449881
  455206
  459513
  462477
  463614
  473499
  483569
  486536
  488132
  489646
  494231
  497447
  502741
  502816
  505811
  510177
  510301
  511160
  512377
  512733
  512952
  513050
  514832
  516103
  516227
  517369
  517386
  518858
  518940
  519023
  520681
  520803
  521077
  522215
  523650
  523840
  524142
  526454
  526545
  528089
  532255
  532499
  535344
  535511
  542914
  556027
  562894
  563218
  563441
  563875
  564824
  566110
  567855
  570765
  573234
  573754
  586400
  586484
  586554
  589036
  591415
  600843
  601147
  603713
  605496
  606806
  606948
  608376
  617167
  617212
  619107
  621489
  630475
  671395
  683902
  689379
  712891
  716220
  815935
]

SELECT
  phc.post_id,
  phc.category_id,
  c.slug,
  IFNULL(`r`.`name`, `f`.`name`) as `name`
FROM
  post_has_category phc
  INNER JOIN category c ON phc.category_id = c.category_id
  AND c.enabled = 1
  LEFT JOIN category_translation f ON c.category_id = f.category_id
  AND f.lang_id = ?
  LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`
  AND `r`.`lang_id` = ?
WHERE
  phc.post_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT phc.post_id, phc.category_id, c.slug, IFNULL(`r`.`name`, `f`.`name`) as `name` FROM post_has_category phc INNER JOIN category c ON phc.category_id = c.category_id AND c.enabled = 1 LEFT JOIN category_translation f ON c.category_id = f.category_id  AND  f.lang_id=1 LEFT JOIN category_translation r ON `c`.`category_id` = `r`.`category_id`  AND  `r`.`lang_id`=2 WHERE phc.post_id IN (447679, 449881, 455206, 459513, 462477, 463614, 473499, 483569, 486536, 488132, 489646, 494231, 497447, 502741, 502816, 505811, 510177, 510301, 511160, 512377, 512733, 512952, 513050, 514832, 516103, 516227, 517369, 517386, 518858, 518940, 519023, 520681, 520803, 521077, 522215, 523650, 523840, 524142, 526454, 526545, 528089, 532255, 532499, 535344, 535511, 542914, 556027, 562894, 563218, 563441, 563875, 564824, 566110, 567855, 570765, 573234, 573754, 586400, 586484, 586554, 589036, 591415, 600843, 601147, 603713, 605496, 606806, 606948, 608376, 617167, 617212, 619107, 621489, 630475, 671395, 683902, 689379, 712891, 716220, 815935);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "секс his mom"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс his mom';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "секс his mom"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс his mom';