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

[
  b"ð▓ ð╝ð░Ðêð©ð¢ðÁ Ðéð¥ð╗ÐüÐéÐâÐêð║ð░ ð©ðÀðÔǪ"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B220D0BCD0B0D188D0B8D0BDD0B520D182D0BED0BBD181D182D183D188D0BAD0B020D0B8D0B7D0E280A6 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
  552967
  672742
  601204
  638631
  638658
  740647
  751470
  724415
  413529
  398209
  407454
  473829
  486432
  492447
  506596
  520755
  528568
  573463
  546447
  565505
  649523
  624874
  589718
  749488
  397413
  479989
  473479
  523046
  603551
  748255
  505390
  560340
  659216
  503863
  511925
  525859
  540247
  543605
  543612
  588309
  516313
  606533
  546446
  725491
  487758
  550788
  505812
  461008
  552948
  558089
  641115
  504774
  601538
  445641
  532482
  549708
  448313
  526633
  412083
  453321
  495275
  519387
  475181
  452182
  453340
  657775
  550475
  623692
]

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 (552967, 672742, 601204, 638631, 638658, 740647, 751470, 724415, 413529, 398209, 407454, 473829, 486432, 492447, 506596, 520755, 528568, 573463, 546447, 565505, 649523, 624874, 589718, 749488, 397413, 479989, 473479, 523046, 603551, 748255, 505390, 560340, 659216, 503863, 511925, 525859, 540247, 543605, 543612, 588309, 516313, 606533, 546446, 725491, 487758, 550788, 505812, 461008, 552948, 558089, 641115, 504774, 601538, 445641, 532482, 549708, 448313, 526633, 412083, 453321, 495275, 519387, 475181, 452182, 453340, 657775, 550475, 623692);

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
  397413
  398209
  407454
  412083
  413529
  445641
  448313
  452182
  453321
  453340
  461008
  473479
  473829
  475181
  479989
  486432
  487758
  492447
  495275
  503863
  504774
  505390
  505812
  506596
  511925
  516313
  519387
  520755
  523046
  525859
  526633
  528568
  532482
  540247
  543605
  543612
  546446
  546447
  549708
  550475
  550788
  552948
  552967
  558089
  560340
  565505
  573463
  588309
  589718
  601204
  601538
  603551
  606533
  623692
  624874
  638631
  638658
  641115
  649523
  657775
  659216
  672742
  724415
  725491
  740647
  748255
  749488
  751470
]

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 (397413, 398209, 407454, 412083, 413529, 445641, 448313, 452182, 453321, 453340, 461008, 473479, 473829, 475181, 479989, 486432, 487758, 492447, 495275, 503863, 504774, 505390, 505812, 506596, 511925, 516313, 519387, 520755, 523046, 525859, 526633, 528568, 532482, 540247, 543605, 543612, 546446, 546447, 549708, 550475, 550788, 552948, 552967, 558089, 560340, 565505, 573463, 588309, 589718, 601204, 601538, 603551, 606533, 623692, 624874, 638631, 638658, 641115, 649523, 657775, 659216, 672742, 724415, 725491, 740647, 748255, 749488, 751470);

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
  397413
  398209
  407454
  412083
  413529
  445641
  448313
  452182
  453321
  453340
  461008
  473479
  473829
  475181
  479989
  486432
  487758
  492447
  495275
  503863
  504774
  505390
  505812
  506596
  511925
  516313
  519387
  520755
  523046
  525859
  526633
  528568
  532482
  540247
  543605
  543612
  546446
  546447
  549708
  550475
  550788
  552948
  552967
  558089
  560340
  565505
  573463
  588309
  589718
  601204
  601538
  603551
  606533
  623692
  624874
  638631
  638658
  641115
  649523
  657775
  659216
  672742
  724415
  725491
  740647
  748255
  749488
  751470
]

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 (397413, 398209, 407454, 412083, 413529, 445641, 448313, 452182, 453321, 453340, 461008, 473479, 473829, 475181, 479989, 486432, 487758, 492447, 495275, 503863, 504774, 505390, 505812, 506596, 511925, 516313, 519387, 520755, 523046, 525859, 526633, 528568, 532482, 540247, 543605, 543612, 546446, 546447, 549708, 550475, 550788, 552948, 552967, 558089, 560340, 565505, 573463, 588309, 589718, 601204, 601538, 603551, 606533, 623692, 624874, 638631, 638658, 641115, 649523, 657775, 659216, 672742, 724415, 725491, 740647, 748255, 749488, 751470);

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` = 'вмашин полная';