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
  661253
  477114
  507873
  562136
  427435
  476590
  421853
  464136
  561488
  600093
  442913
  449866
  465544
  521140
  579389
  549831
  603704
  457461
  427138
  546594
  467066
  526384
  511902
  512991
  622003
  439773
  537207
  478608
  528327
  462348
  537265
  567502
  481628
  421922
  466112
  532597
  511827
  494118
  498786
  619598
  517076
  599498
  599109
  551259
  595755
  563852
  405272
  424682
  604375
  404766
  606002
  604456
  439518
  553411
  565927
  653471
  519285
  492736
  516784
  553056
  569448
  543508
  595885
  568328
  574715
  601834
  517326
  591378
  536910
  609842
  540153
  532766
]

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 (661253, 477114, 507873, 562136, 427435, 476590, 421853, 464136, 561488, 600093, 442913, 449866, 465544, 521140, 579389, 549831, 603704, 457461, 427138, 546594, 467066, 526384, 511902, 512991, 622003, 439773, 537207, 478608, 528327, 462348, 537265, 567502, 481628, 421922, 466112, 532597, 511827, 494118, 498786, 619598, 517076, 599498, 599109, 551259, 595755, 563852, 405272, 424682, 604375, 404766, 606002, 604456, 439518, 553411, 565927, 653471, 519285, 492736, 516784, 553056, 569448, 543508, 595885, 568328, 574715, 601834, 517326, 591378, 536910, 609842, 540153, 532766);

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
  404766
  405272
  421853
  421922
  424682
  427138
  427435
  439518
  439773
  442913
  449866
  457461
  462348
  464136
  465544
  466112
  467066
  476590
  477114
  478608
  481628
  492736
  494118
  498786
  507873
  511827
  511902
  512991
  516784
  517076
  517326
  519285
  521140
  526384
  528327
  532597
  532766
  536910
  537207
  537265
  540153
  543508
  546594
  549831
  551259
  553056
  553411
  561488
  562136
  563852
  565927
  567502
  568328
  569448
  574715
  579389
  591378
  595755
  595885
  599109
  599498
  600093
  601834
  603704
  604375
  604456
  606002
  609842
  619598
  622003
  653471
  661253
]

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 (404766, 405272, 421853, 421922, 424682, 427138, 427435, 439518, 439773, 442913, 449866, 457461, 462348, 464136, 465544, 466112, 467066, 476590, 477114, 478608, 481628, 492736, 494118, 498786, 507873, 511827, 511902, 512991, 516784, 517076, 517326, 519285, 521140, 526384, 528327, 532597, 532766, 536910, 537207, 537265, 540153, 543508, 546594, 549831, 551259, 553056, 553411, 561488, 562136, 563852, 565927, 567502, 568328, 569448, 574715, 579389, 591378, 595755, 595885, 599109, 599498, 600093, 601834, 603704, 604375, 604456, 606002, 609842, 619598, 622003, 653471, 661253);

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
  404766
  405272
  421853
  421922
  424682
  427138
  427435
  439518
  439773
  442913
  449866
  457461
  462348
  464136
  465544
  466112
  467066
  476590
  477114
  478608
  481628
  492736
  494118
  498786
  507873
  511827
  511902
  512991
  516784
  517076
  517326
  519285
  521140
  526384
  528327
  532597
  532766
  536910
  537207
  537265
  540153
  543508
  546594
  549831
  551259
  553056
  553411
  561488
  562136
  563852
  565927
  567502
  568328
  569448
  574715
  579389
  591378
  595755
  595885
  599109
  599498
  600093
  601834
  603704
  604375
  604456
  606002
  609842
  619598
  622003
  653471
  661253
]

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 (404766, 405272, 421853, 421922, 424682, 427138, 427435, 439518, 439773, 442913, 449866, 457461, 462348, 464136, 465544, 466112, 467066, 476590, 477114, 478608, 481628, 492736, 494118, 498786, 507873, 511827, 511902, 512991, 516784, 517076, 517326, 519285, 521140, 526384, 528327, 532597, 532766, 536910, 537207, 537265, 540153, 543508, 546594, 549831, 551259, 553056, 553411, 561488, 562136, 563852, 565927, 567502, 568328, 569448, 574715, 579389, 591378, 595755, 595885, 599109, 599498, 600093, 601834, 603704, 604375, 604456, 606002, 609842, 619598, 622003, 653471, 661253);

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` = 'минет оральн секс окн';