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
  471434
  582680
  709524
  421673
  492571
  452170
  476184
  492942
  469327
  479752
  422832
  494786
  540748
  465933
  463409
  459242
  493234
  448083
  468860
  474611
  422565
  425206
  499830
  624204
  527742
  466987
  468482
  643112
  470458
  480373
  428605
  540794
  485678
  442573
  422587
  455861
  501529
  585550
  644276
  446105
  501797
  414344
  468599
  471495
  699610
  680200
  513603
  530384
  592770
  703833
  443796
  457446
  522618
  535023
  493222
  425260
  516025
  554833
  538473
  488515
  457884
  473066
  474710
  624201
  503934
  440569
  523908
  448094
  525441
  477079
  557259
  624030
  590910
  516684
  566688
  500581
  580646
  622938
  589671
  529794
  493204
  506612
  526005
  520763
  541770
  504718
  642662
  562825
]

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 (471434, 582680, 709524, 421673, 492571, 452170, 476184, 492942, 469327, 479752, 422832, 494786, 540748, 465933, 463409, 459242, 493234, 448083, 468860, 474611, 422565, 425206, 499830, 624204, 527742, 466987, 468482, 643112, 470458, 480373, 428605, 540794, 485678, 442573, 422587, 455861, 501529, 585550, 644276, 446105, 501797, 414344, 468599, 471495, 699610, 680200, 513603, 530384, 592770, 703833, 443796, 457446, 522618, 535023, 493222, 425260, 516025, 554833, 538473, 488515, 457884, 473066, 474710, 624201, 503934, 440569, 523908, 448094, 525441, 477079, 557259, 624030, 590910, 516684, 566688, 500581, 580646, 622938, 589671, 529794, 493204, 506612, 526005, 520763, 541770, 504718, 642662, 562825);

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
  414344
  421673
  422565
  422587
  422832
  425206
  425260
  428605
  440569
  442573
  443796
  446105
  448083
  448094
  452170
  455861
  457446
  457884
  459242
  463409
  465933
  466987
  468482
  468599
  468860
  469327
  470458
  471434
  471495
  473066
  474611
  474710
  476184
  477079
  479752
  480373
  485678
  488515
  492571
  492942
  493204
  493222
  493234
  494786
  499830
  500581
  501529
  501797
  503934
  504718
  506612
  513603
  516025
  516684
  520763
  522618
  523908
  525441
  526005
  527742
  529794
  530384
  535023
  538473
  540748
  540794
  541770
  554833
  557259
  562825
  566688
  580646
  582680
  585550
  589671
  590910
  592770
  622938
  624030
  624201
  624204
  642662
  643112
  644276
  680200
  699610
  703833
  709524
]

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 (414344, 421673, 422565, 422587, 422832, 425206, 425260, 428605, 440569, 442573, 443796, 446105, 448083, 448094, 452170, 455861, 457446, 457884, 459242, 463409, 465933, 466987, 468482, 468599, 468860, 469327, 470458, 471434, 471495, 473066, 474611, 474710, 476184, 477079, 479752, 480373, 485678, 488515, 492571, 492942, 493204, 493222, 493234, 494786, 499830, 500581, 501529, 501797, 503934, 504718, 506612, 513603, 516025, 516684, 520763, 522618, 523908, 525441, 526005, 527742, 529794, 530384, 535023, 538473, 540748, 540794, 541770, 554833, 557259, 562825, 566688, 580646, 582680, 585550, 589671, 590910, 592770, 622938, 624030, 624201, 624204, 642662, 643112, 644276, 680200, 699610, 703833, 709524);

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
  414344
  421673
  422565
  422587
  422832
  425206
  425260
  428605
  440569
  442573
  443796
  446105
  448083
  448094
  452170
  455861
  457446
  457884
  459242
  463409
  465933
  466987
  468482
  468599
  468860
  469327
  470458
  471434
  471495
  473066
  474611
  474710
  476184
  477079
  479752
  480373
  485678
  488515
  492571
  492942
  493204
  493222
  493234
  494786
  499830
  500581
  501529
  501797
  503934
  504718
  506612
  513603
  516025
  516684
  520763
  522618
  523908
  525441
  526005
  527742
  529794
  530384
  535023
  538473
  540748
  540794
  541770
  554833
  557259
  562825
  566688
  580646
  582680
  585550
  589671
  590910
  592770
  622938
  624030
  624201
  624204
  642662
  643112
  644276
  680200
  699610
  703833
  709524
]

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 (414344, 421673, 422565, 422587, 422832, 425206, 425260, 428605, 440569, 442573, 443796, 446105, 448083, 448094, 452170, 455861, 457446, 457884, 459242, 463409, 465933, 466987, 468482, 468599, 468860, 469327, 470458, 471434, 471495, 473066, 474611, 474710, 476184, 477079, 479752, 480373, 485678, 488515, 492571, 492942, 493204, 493222, 493234, 494786, 499830, 500581, 501529, 501797, 503934, 504718, 506612, 513603, 516025, 516684, 520763, 522618, 523908, 525441, 526005, 527742, 529794, 530384, 535023, 538473, 540748, 540794, 541770, 554833, 557259, 562825, 566688, 580646, 582680, 585550, 589671, 590910, 592770, 622938, 624030, 624201, 624204, 642662, 643112, 644276, 680200, 699610, 703833, 709524);

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` = 'секс высокие';