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
  420042
  443202
  462350
  468548
  469432
  454248
  454263
  468773
  526390
  484811
  491398
  492133
  483739
  484652
  491194
  492672
  498212
  432639
  523547
  563473
  432180
  462840
  482355
  466074
  400479
  480929
  467523
  510887
  511160
  484566
  513041
  523830
  526777
  484711
  485777
  517556
  520876
  528459
  500551
  515914
  517558
  451372
  564758
  541690
  603900
  618146
  601655
  466897
  469193
  511595
  484649
  504651
  515761
  527090
  484432
  485276
  485702
  508156
  523493
  483474
  506729
  547932
  597256
  597012
  458224
  485703
  678569
  604298
  601956
  484299
  494492
  516000
  524555
  625991
  541688
]

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 (420042, 443202, 462350, 468548, 469432, 454248, 454263, 468773, 526390, 484811, 491398, 492133, 483739, 484652, 491194, 492672, 498212, 432639, 523547, 563473, 432180, 462840, 482355, 466074, 400479, 480929, 467523, 510887, 511160, 484566, 513041, 523830, 526777, 484711, 485777, 517556, 520876, 528459, 500551, 515914, 517558, 451372, 564758, 541690, 603900, 618146, 601655, 466897, 469193, 511595, 484649, 504651, 515761, 527090, 484432, 485276, 485702, 508156, 523493, 483474, 506729, 547932, 597256, 597012, 458224, 485703, 678569, 604298, 601956, 484299, 494492, 516000, 524555, 625991, 541688);

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
  400479
  420042
  432180
  432639
  443202
  451372
  454248
  454263
  458224
  462350
  462840
  466074
  466897
  467523
  468548
  468773
  469193
  469432
  480929
  482355
  483474
  483739
  484299
  484432
  484566
  484649
  484652
  484711
  484811
  485276
  485702
  485703
  485777
  491194
  491398
  492133
  492672
  494492
  498212
  500551
  504651
  506729
  508156
  510887
  511160
  511595
  513041
  515761
  515914
  516000
  517556
  517558
  520876
  523493
  523547
  523830
  524555
  526390
  526777
  527090
  528459
  541688
  541690
  547932
  563473
  564758
  597012
  597256
  601655
  601956
  603900
  604298
  618146
  625991
  678569
]

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 (400479, 420042, 432180, 432639, 443202, 451372, 454248, 454263, 458224, 462350, 462840, 466074, 466897, 467523, 468548, 468773, 469193, 469432, 480929, 482355, 483474, 483739, 484299, 484432, 484566, 484649, 484652, 484711, 484811, 485276, 485702, 485703, 485777, 491194, 491398, 492133, 492672, 494492, 498212, 500551, 504651, 506729, 508156, 510887, 511160, 511595, 513041, 515761, 515914, 516000, 517556, 517558, 520876, 523493, 523547, 523830, 524555, 526390, 526777, 527090, 528459, 541688, 541690, 547932, 563473, 564758, 597012, 597256, 601655, 601956, 603900, 604298, 618146, 625991, 678569);

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
  400479
  420042
  432180
  432639
  443202
  451372
  454248
  454263
  458224
  462350
  462840
  466074
  466897
  467523
  468548
  468773
  469193
  469432
  480929
  482355
  483474
  483739
  484299
  484432
  484566
  484649
  484652
  484711
  484811
  485276
  485702
  485703
  485777
  491194
  491398
  492133
  492672
  494492
  498212
  500551
  504651
  506729
  508156
  510887
  511160
  511595
  513041
  515761
  515914
  516000
  517556
  517558
  520876
  523493
  523547
  523830
  524555
  526390
  526777
  527090
  528459
  541688
  541690
  547932
  563473
  564758
  597012
  597256
  601655
  601956
  603900
  604298
  618146
  625991
  678569
]

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 (400479, 420042, 432180, 432639, 443202, 451372, 454248, 454263, 458224, 462350, 462840, 466074, 466897, 467523, 468548, 468773, 469193, 469432, 480929, 482355, 483474, 483739, 484299, 484432, 484566, 484649, 484652, 484711, 484811, 485276, 485702, 485703, 485777, 491194, 491398, 492133, 492672, 494492, 498212, 500551, 504651, 506729, 508156, 510887, 511160, 511595, 513041, 515761, 515914, 516000, 517556, 517558, 520876, 523493, 523547, 523830, 524555, 526390, 526777, 527090, 528459, 541688, 541690, 547932, 563473, 564758, 597012, 597256, 601655, 601956, 603900, 604298, 618146, 625991, 678569);

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` = 'кудрявые';