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
  510392
  452079
  535024
  415697
  465080
  456663
  499103
  523125
  518491
  566081
  458172
  419222
  527600
  525485
  560845
  621179
  435922
  466757
  500058
  517913
  486304
  422834
  521520
  518134
  517010
  524189
  455608
  426323
  484223
  523863
  604095
  436314
  528939
  536586
  525259
  568538
  454995
  528208
  519982
  503151
  509970
  541275
  525398
  499498
  535006
  428476
  568399
  610255
  567829
  401805
  542089
  586573
  652592
  476773
  416415
  523033
  551153
  575007
  589060
  604541
  503310
  679801
  569686
  518256
  621454
  460249
  519686
  564705
  618804
  609230
  621449
  614853
  532773
  569837
  606011
  588897
  622805
  556405
  504912
  522562
]

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 (510392, 452079, 535024, 415697, 465080, 456663, 499103, 523125, 518491, 566081, 458172, 419222, 527600, 525485, 560845, 621179, 435922, 466757, 500058, 517913, 486304, 422834, 521520, 518134, 517010, 524189, 455608, 426323, 484223, 523863, 604095, 436314, 528939, 536586, 525259, 568538, 454995, 528208, 519982, 503151, 509970, 541275, 525398, 499498, 535006, 428476, 568399, 610255, 567829, 401805, 542089, 586573, 652592, 476773, 416415, 523033, 551153, 575007, 589060, 604541, 503310, 679801, 569686, 518256, 621454, 460249, 519686, 564705, 618804, 609230, 621449, 614853, 532773, 569837, 606011, 588897, 622805, 556405, 504912, 522562);

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
  401805
  415697
  416415
  419222
  422834
  426323
  428476
  435922
  436314
  452079
  454995
  455608
  456663
  458172
  460249
  465080
  466757
  476773
  484223
  486304
  499103
  499498
  500058
  503151
  503310
  504912
  509970
  510392
  517010
  517913
  518134
  518256
  518491
  519686
  519982
  521520
  522562
  523033
  523125
  523863
  524189
  525259
  525398
  525485
  527600
  528208
  528939
  532773
  535006
  535024
  536586
  541275
  542089
  551153
  556405
  560845
  564705
  566081
  567829
  568399
  568538
  569686
  569837
  575007
  586573
  588897
  589060
  604095
  604541
  606011
  609230
  610255
  614853
  618804
  621179
  621449
  621454
  622805
  652592
  679801
]

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 (401805, 415697, 416415, 419222, 422834, 426323, 428476, 435922, 436314, 452079, 454995, 455608, 456663, 458172, 460249, 465080, 466757, 476773, 484223, 486304, 499103, 499498, 500058, 503151, 503310, 504912, 509970, 510392, 517010, 517913, 518134, 518256, 518491, 519686, 519982, 521520, 522562, 523033, 523125, 523863, 524189, 525259, 525398, 525485, 527600, 528208, 528939, 532773, 535006, 535024, 536586, 541275, 542089, 551153, 556405, 560845, 564705, 566081, 567829, 568399, 568538, 569686, 569837, 575007, 586573, 588897, 589060, 604095, 604541, 606011, 609230, 610255, 614853, 618804, 621179, 621449, 621454, 622805, 652592, 679801);

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
  401805
  415697
  416415
  419222
  422834
  426323
  428476
  435922
  436314
  452079
  454995
  455608
  456663
  458172
  460249
  465080
  466757
  476773
  484223
  486304
  499103
  499498
  500058
  503151
  503310
  504912
  509970
  510392
  517010
  517913
  518134
  518256
  518491
  519686
  519982
  521520
  522562
  523033
  523125
  523863
  524189
  525259
  525398
  525485
  527600
  528208
  528939
  532773
  535006
  535024
  536586
  541275
  542089
  551153
  556405
  560845
  564705
  566081
  567829
  568399
  568538
  569686
  569837
  575007
  586573
  588897
  589060
  604095
  604541
  606011
  609230
  610255
  614853
  618804
  621179
  621449
  621454
  622805
  652592
  679801
]

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 (401805, 415697, 416415, 419222, 422834, 426323, 428476, 435922, 436314, 452079, 454995, 455608, 456663, 458172, 460249, 465080, 466757, 476773, 484223, 486304, 499103, 499498, 500058, 503151, 503310, 504912, 509970, 510392, 517010, 517913, 518134, 518256, 518491, 519686, 519982, 521520, 522562, 523033, 523125, 523863, 524189, 525259, 525398, 525485, 527600, 528208, 528939, 532773, 535006, 535024, 536586, 541275, 542089, 551153, 556405, 560845, 564705, 566081, 567829, 568399, 568538, 569686, 569837, 575007, 586573, 588897, 589060, 604095, 604541, 606011, 609230, 610255, 614853, 618804, 621179, 621449, 621454, 622805, 652592, 679801);

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