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

[
  "с музыкой"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'с музыкой' 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
  518877
  514020
  529954
  462373
  475683
  545800
  577031
  559430
  565077
  548140
  551246
  596360
  438807
  495970
  516922
  529952
  81734
  395701
  404939
  511561
  532604
  548128
  567798
  544012
  545833
  545834
  596147
  484850
  532531
  513850
  537487
  530582
  545839
  656303
  670745
  545829
  554529
  601511
  601717
  602594
  524855
  492221
  521074
  529956
  578703
  593965
  592005
  637030
  436186
  467967
  461954
  533137
  498551
  524836
  486501
  541830
  566597
  591169
  594105
  515947
  545300
  541683
  552623
  593989
  588991
  601933
  619651
  624165
  632701
  441404
  449925
  516839
  573212
  574700
  605521
  504718
  434601
]

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 (518877, 514020, 529954, 462373, 475683, 545800, 577031, 559430, 565077, 548140, 551246, 596360, 438807, 495970, 516922, 529952, 81734, 395701, 404939, 511561, 532604, 548128, 567798, 544012, 545833, 545834, 596147, 484850, 532531, 513850, 537487, 530582, 545839, 656303, 670745, 545829, 554529, 601511, 601717, 602594, 524855, 492221, 521074, 529956, 578703, 593965, 592005, 637030, 436186, 467967, 461954, 533137, 498551, 524836, 486501, 541830, 566597, 591169, 594105, 515947, 545300, 541683, 552623, 593989, 588991, 601933, 619651, 624165, 632701, 441404, 449925, 516839, 573212, 574700, 605521, 504718, 434601);

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
  81734
  395701
  404939
  434601
  436186
  438807
  441404
  449925
  461954
  462373
  467967
  475683
  484850
  486501
  492221
  495970
  498551
  504718
  511561
  513850
  514020
  515947
  516839
  516922
  518877
  521074
  524836
  524855
  529952
  529954
  529956
  530582
  532531
  532604
  533137
  537487
  541683
  541830
  544012
  545300
  545800
  545829
  545833
  545834
  545839
  548128
  548140
  551246
  552623
  554529
  559430
  565077
  566597
  567798
  573212
  574700
  577031
  578703
  588991
  591169
  592005
  593965
  593989
  594105
  596147
  596360
  601511
  601717
  601933
  602594
  605521
  619651
  624165
  632701
  637030
  656303
  670745
]

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 (81734, 395701, 404939, 434601, 436186, 438807, 441404, 449925, 461954, 462373, 467967, 475683, 484850, 486501, 492221, 495970, 498551, 504718, 511561, 513850, 514020, 515947, 516839, 516922, 518877, 521074, 524836, 524855, 529952, 529954, 529956, 530582, 532531, 532604, 533137, 537487, 541683, 541830, 544012, 545300, 545800, 545829, 545833, 545834, 545839, 548128, 548140, 551246, 552623, 554529, 559430, 565077, 566597, 567798, 573212, 574700, 577031, 578703, 588991, 591169, 592005, 593965, 593989, 594105, 596147, 596360, 601511, 601717, 601933, 602594, 605521, 619651, 624165, 632701, 637030, 656303, 670745);

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
  81734
  395701
  404939
  434601
  436186
  438807
  441404
  449925
  461954
  462373
  467967
  475683
  484850
  486501
  492221
  495970
  498551
  504718
  511561
  513850
  514020
  515947
  516839
  516922
  518877
  521074
  524836
  524855
  529952
  529954
  529956
  530582
  532531
  532604
  533137
  537487
  541683
  541830
  544012
  545300
  545800
  545829
  545833
  545834
  545839
  548128
  548140
  551246
  552623
  554529
  559430
  565077
  566597
  567798
  573212
  574700
  577031
  578703
  588991
  591169
  592005
  593965
  593989
  594105
  596147
  596360
  601511
  601717
  601933
  602594
  605521
  619651
  624165
  632701
  637030
  656303
  670745
]

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 (81734, 395701, 404939, 434601, 436186, 438807, 441404, 449925, 461954, 462373, 467967, 475683, 484850, 486501, 492221, 495970, 498551, 504718, 511561, 513850, 514020, 515947, 516839, 516922, 518877, 521074, 524836, 524855, 529952, 529954, 529956, 530582, 532531, 532604, 533137, 537487, 541683, 541830, 544012, 545300, 545800, 545829, 545833, 545834, 545839, 548128, 548140, 551246, 552623, 554529, 559430, 565077, 566597, 567798, 573212, 574700, 577031, 578703, 588991, 591169, 592005, 593965, 593989, 594105, 596147, 596360, 601511, 601717, 601933, 602594, 605521, 619651, 624165, 632701, 637030, 656303, 670745);

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

[
  "музык"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'музык';

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

[
  "музык"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'музык';