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 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ôW.ÓÎrC┤':ÄØK7Ê"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193572EE0D77243B4273A8E9D4B37D2 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
  798209
  790762
  229160
  783806
  636561
  654431
  798342
  618375
  794513
  750074
  774434
  479533
  800012
  808217
  761626
  777089
  681093
  521444
  656268
  809444
  514261
  536341
  660729
  673990
  681020
  590147
  593336
  607037
  586168
  606831
  737910
  770823
  802128
  802868
  407603
  571838
  680623
  653511
  589211
  592914
  586791
  782626
  781787
  812658
  560865
  688069
  574364
  574870
  443653
  567209
  610290
  797468
  536655
  687529
  596556
  443103
  814031
  676026
  540486
  535344
  675000
]

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 (798209, 790762, 229160, 783806, 636561, 654431, 798342, 618375, 794513, 750074, 774434, 479533, 800012, 808217, 761626, 777089, 681093, 521444, 656268, 809444, 514261, 536341, 660729, 673990, 681020, 590147, 593336, 607037, 586168, 606831, 737910, 770823, 802128, 802868, 407603, 571838, 680623, 653511, 589211, 592914, 586791, 782626, 781787, 812658, 560865, 688069, 574364, 574870, 443653, 567209, 610290, 797468, 536655, 687529, 596556, 443103, 814031, 676026, 540486, 535344, 675000);

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
  229160
  407603
  443103
  443653
  479533
  514261
  521444
  535344
  536341
  536655
  540486
  560865
  567209
  571838
  574364
  574870
  586168
  586791
  589211
  590147
  592914
  593336
  596556
  606831
  607037
  610290
  618375
  636561
  653511
  654431
  656268
  660729
  673990
  675000
  676026
  680623
  681020
  681093
  687529
  688069
  737910
  750074
  761626
  770823
  774434
  777089
  781787
  782626
  783806
  790762
  794513
  797468
  798209
  798342
  800012
  802128
  802868
  808217
  809444
  812658
  814031
]

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 (229160, 407603, 443103, 443653, 479533, 514261, 521444, 535344, 536341, 536655, 540486, 560865, 567209, 571838, 574364, 574870, 586168, 586791, 589211, 590147, 592914, 593336, 596556, 606831, 607037, 610290, 618375, 636561, 653511, 654431, 656268, 660729, 673990, 675000, 676026, 680623, 681020, 681093, 687529, 688069, 737910, 750074, 761626, 770823, 774434, 777089, 781787, 782626, 783806, 790762, 794513, 797468, 798209, 798342, 800012, 802128, 802868, 808217, 809444, 812658, 814031);

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
  229160
  407603
  443103
  443653
  479533
  514261
  521444
  535344
  536341
  536655
  540486
  560865
  567209
  571838
  574364
  574870
  586168
  586791
  589211
  590147
  592914
  593336
  596556
  606831
  607037
  610290
  618375
  636561
  653511
  654431
  656268
  660729
  673990
  675000
  676026
  680623
  681020
  681093
  687529
  688069
  737910
  750074
  761626
  770823
  774434
  777089
  781787
  782626
  783806
  790762
  794513
  797468
  798209
  798342
  800012
  802128
  802868
  808217
  809444
  812658
  814031
]

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 (229160, 407603, 443103, 443653, 479533, 514261, 521444, 535344, 536341, 536655, 540486, 560865, 567209, 571838, 574364, 574870, 586168, 586791, 589211, 590147, 592914, 593336, 596556, 606831, 607037, 610290, 618375, 636561, 653511, 654431, 656268, 660729, 673990, 675000, 676026, 680623, 681020, 681093, 687529, 688069, 737910, 750074, 761626, 770823, 774434, 777089, 781787, 782626, 783806, 790762, 794513, 797468, 798209, 798342, 800012, 802128, 802868, 808217, 809444, 812658, 814031);

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

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "под коксом"
  "под коксом"
  "под коксом"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('под коксом') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('под коксом')
              AND `query` <> 'под коксом'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;