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
  398877
  554519
  566304
  584415
  656768
  632298
  508860
  615717
  487514
  653464
  521495
  532943
  654479
  594819
  515262
  564981
  564327
  658564
  568796
  652869
  630596
  659487
  601933
  660520
  570612
  643595
  567743
  578084
  596515
  597550
  625322
  548340
  581117
  604776
  595448
  462415
  504610
  654518
  605111
  620667
  625185
  564224
  580334
  655609
  572019
  591197
  601329
  485371
  467428
  547241
  608200
  588751
  618743
  535511
  560924
  561458
  513965
  561704
  600913
  505015
  598711
  548518
  502695
  589048
  502328
  561304
  624911
  516308
  626042
  457981
  493249
  593689
  524256
  419628
  418686
  631957
  513047
  613396
  624226
  550599
]

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 (398877, 554519, 566304, 584415, 656768, 632298, 508860, 615717, 487514, 653464, 521495, 532943, 654479, 594819, 515262, 564981, 564327, 658564, 568796, 652869, 630596, 659487, 601933, 660520, 570612, 643595, 567743, 578084, 596515, 597550, 625322, 548340, 581117, 604776, 595448, 462415, 504610, 654518, 605111, 620667, 625185, 564224, 580334, 655609, 572019, 591197, 601329, 485371, 467428, 547241, 608200, 588751, 618743, 535511, 560924, 561458, 513965, 561704, 600913, 505015, 598711, 548518, 502695, 589048, 502328, 561304, 624911, 516308, 626042, 457981, 493249, 593689, 524256, 419628, 418686, 631957, 513047, 613396, 624226, 550599);

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
  398877
  418686
  419628
  457981
  462415
  467428
  485371
  487514
  493249
  502328
  502695
  504610
  505015
  508860
  513047
  513965
  515262
  516308
  521495
  524256
  532943
  535511
  547241
  548340
  548518
  550599
  554519
  560924
  561304
  561458
  561704
  564224
  564327
  564981
  566304
  567743
  568796
  570612
  572019
  578084
  580334
  581117
  584415
  588751
  589048
  591197
  593689
  594819
  595448
  596515
  597550
  598711
  600913
  601329
  601933
  604776
  605111
  608200
  613396
  615717
  618743
  620667
  624226
  624911
  625185
  625322
  626042
  630596
  631957
  632298
  643595
  652869
  653464
  654479
  654518
  655609
  656768
  658564
  659487
  660520
]

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 (398877, 418686, 419628, 457981, 462415, 467428, 485371, 487514, 493249, 502328, 502695, 504610, 505015, 508860, 513047, 513965, 515262, 516308, 521495, 524256, 532943, 535511, 547241, 548340, 548518, 550599, 554519, 560924, 561304, 561458, 561704, 564224, 564327, 564981, 566304, 567743, 568796, 570612, 572019, 578084, 580334, 581117, 584415, 588751, 589048, 591197, 593689, 594819, 595448, 596515, 597550, 598711, 600913, 601329, 601933, 604776, 605111, 608200, 613396, 615717, 618743, 620667, 624226, 624911, 625185, 625322, 626042, 630596, 631957, 632298, 643595, 652869, 653464, 654479, 654518, 655609, 656768, 658564, 659487, 660520);

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
  398877
  418686
  419628
  457981
  462415
  467428
  485371
  487514
  493249
  502328
  502695
  504610
  505015
  508860
  513047
  513965
  515262
  516308
  521495
  524256
  532943
  535511
  547241
  548340
  548518
  550599
  554519
  560924
  561304
  561458
  561704
  564224
  564327
  564981
  566304
  567743
  568796
  570612
  572019
  578084
  580334
  581117
  584415
  588751
  589048
  591197
  593689
  594819
  595448
  596515
  597550
  598711
  600913
  601329
  601933
  604776
  605111
  608200
  613396
  615717
  618743
  620667
  624226
  624911
  625185
  625322
  626042
  630596
  631957
  632298
  643595
  652869
  653464
  654479
  654518
  655609
  656768
  658564
  659487
  660520
]

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 (398877, 418686, 419628, 457981, 462415, 467428, 485371, 487514, 493249, 502328, 502695, 504610, 505015, 508860, 513047, 513965, 515262, 516308, 521495, 524256, 532943, 535511, 547241, 548340, 548518, 550599, 554519, 560924, 561304, 561458, 561704, 564224, 564327, 564981, 566304, 567743, 568796, 570612, 572019, 578084, 580334, 581117, 584415, 588751, 589048, 591197, 593689, 594819, 595448, 596515, 597550, 598711, 600913, 601329, 601933, 604776, 605111, 608200, 613396, 615717, 618743, 620667, 624226, 624911, 625185, 625322, 626042, 630596, 631957, 632298, 643595, 652869, 653464, 654479, 654518, 655609, 656768, 658564, 659487, 660520);

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` = 'так секс';