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

[
  b"ð▒ÐïÐüÐéÐÇð░ÐÅ ð┐ð¥ÐÇð¢ð¥ Ðü 18ð╗ðÁÐéð¢ð%2ÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B1D18BD181D182D180D0B0D18F20D0BFD0BED180D0BDD0BE20D181203138D0BBD0B5D182D0BDD02532E280A6 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
  675798
  659905
  634532
  491802
  570601
  572070
  655698
  660964
  661272
  572077
  590669
  595704
  622386
  596658
  610618
  541095
  600069
  605996
  568610
  580151
  572164
  655056
  658269
  658599
  671104
  596608
  596677
  618806
  618924
  614991
  618926
  474744
  605586
  569667
  657402
  530232
  617060
  560646
  654399
  600531
  604247
  469601
  525688
  565322
  656782
  657046
  590596
  602655
  598785
  532246
  535338
  537198
  548719
  609842
  485313
  562258
  596423
  561478
  545667
  654740
  657438
  654474
  563441
  603813
  606015
  602923
  625701
  629445
  517345
  519617
]

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 (675798, 659905, 634532, 491802, 570601, 572070, 655698, 660964, 661272, 572077, 590669, 595704, 622386, 596658, 610618, 541095, 600069, 605996, 568610, 580151, 572164, 655056, 658269, 658599, 671104, 596608, 596677, 618806, 618924, 614991, 618926, 474744, 605586, 569667, 657402, 530232, 617060, 560646, 654399, 600531, 604247, 469601, 525688, 565322, 656782, 657046, 590596, 602655, 598785, 532246, 535338, 537198, 548719, 609842, 485313, 562258, 596423, 561478, 545667, 654740, 657438, 654474, 563441, 603813, 606015, 602923, 625701, 629445, 517345, 519617);

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
  469601
  474744
  485313
  491802
  517345
  519617
  525688
  530232
  532246
  535338
  537198
  541095
  545667
  548719
  560646
  561478
  562258
  563441
  565322
  568610
  569667
  570601
  572070
  572077
  572164
  580151
  590596
  590669
  595704
  596423
  596608
  596658
  596677
  598785
  600069
  600531
  602655
  602923
  603813
  604247
  605586
  605996
  606015
  609842
  610618
  614991
  617060
  618806
  618924
  618926
  622386
  625701
  629445
  634532
  654399
  654474
  654740
  655056
  655698
  656782
  657046
  657402
  657438
  658269
  658599
  659905
  660964
  661272
  671104
  675798
]

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 (469601, 474744, 485313, 491802, 517345, 519617, 525688, 530232, 532246, 535338, 537198, 541095, 545667, 548719, 560646, 561478, 562258, 563441, 565322, 568610, 569667, 570601, 572070, 572077, 572164, 580151, 590596, 590669, 595704, 596423, 596608, 596658, 596677, 598785, 600069, 600531, 602655, 602923, 603813, 604247, 605586, 605996, 606015, 609842, 610618, 614991, 617060, 618806, 618924, 618926, 622386, 625701, 629445, 634532, 654399, 654474, 654740, 655056, 655698, 656782, 657046, 657402, 657438, 658269, 658599, 659905, 660964, 661272, 671104, 675798);

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
  469601
  474744
  485313
  491802
  517345
  519617
  525688
  530232
  532246
  535338
  537198
  541095
  545667
  548719
  560646
  561478
  562258
  563441
  565322
  568610
  569667
  570601
  572070
  572077
  572164
  580151
  590596
  590669
  595704
  596423
  596608
  596658
  596677
  598785
  600069
  600531
  602655
  602923
  603813
  604247
  605586
  605996
  606015
  609842
  610618
  614991
  617060
  618806
  618924
  618926
  622386
  625701
  629445
  634532
  654399
  654474
  654740
  655056
  655698
  656782
  657046
  657402
  657438
  658269
  658599
  659905
  660964
  661272
  671104
  675798
]

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 (469601, 474744, 485313, 491802, 517345, 519617, 525688, 530232, 532246, 535338, 537198, 541095, 545667, 548719, 560646, 561478, 562258, 563441, 565322, 568610, 569667, 570601, 572070, 572077, 572164, 580151, 590596, 590669, 595704, 596423, 596608, 596658, 596677, 598785, 600069, 600531, 602655, 602923, 603813, 604247, 605586, 605996, 606015, 609842, 610618, 614991, 617060, 618806, 618924, 618926, 622386, 625701, 629445, 634532, 654399, 654474, 654740, 655056, 655698, 656782, 657046, 657402, 657438, 658269, 658599, 659905, 660964, 661272, 671104, 675798);

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

[
  "быстр порн 18 19 два лет"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'быстр порн 18 19 два лет';

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

[
  "быстр порн 18 19 два лет"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'быстр порн 18 19 два лет';