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

[
  "melody 2023"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'melody 2023' 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
  278236
  785429
  722178
  651117
  785638
  789728
  802016
  522783
  780249
  775939
  797335
  714710
  687524
  630277
  682510
  622210
  592256
  800454
  519273
  675479
  785624
  537492
  537669
  725565
  807744
  601755
  447138
  468805
  714743
  828305
  521424
  591867
  517716
  528329
  476767
  490608
  739514
  819635
  475661
  420363
  822828
  729538
  744204
  770702
  614710
  784525
  447129
  534778
  525251
  390701
  418228
  428426
  445712
  456398
  451825
  528326
  528328
  663349
  476729
  478011
  445037
  525204
  460082
  455859
  447828
  512551
  525190
  447614
  528327
  520422
  452626
  436186
  650413
  486284
  523139
]

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 (278236, 785429, 722178, 651117, 785638, 789728, 802016, 522783, 780249, 775939, 797335, 714710, 687524, 630277, 682510, 622210, 592256, 800454, 519273, 675479, 785624, 537492, 537669, 725565, 807744, 601755, 447138, 468805, 714743, 828305, 521424, 591867, 517716, 528329, 476767, 490608, 739514, 819635, 475661, 420363, 822828, 729538, 744204, 770702, 614710, 784525, 447129, 534778, 525251, 390701, 418228, 428426, 445712, 456398, 451825, 528326, 528328, 663349, 476729, 478011, 445037, 525204, 460082, 455859, 447828, 512551, 525190, 447614, 528327, 520422, 452626, 436186, 650413, 486284, 523139);

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
  278236
  390701
  418228
  420363
  428426
  436186
  445037
  445712
  447129
  447138
  447614
  447828
  451825
  452626
  455859
  456398
  460082
  468805
  475661
  476729
  476767
  478011
  486284
  490608
  512551
  517716
  519273
  520422
  521424
  522783
  523139
  525190
  525204
  525251
  528326
  528327
  528328
  528329
  534778
  537492
  537669
  591867
  592256
  601755
  614710
  622210
  630277
  650413
  651117
  663349
  675479
  682510
  687524
  714710
  714743
  722178
  725565
  729538
  739514
  744204
  775939
  780249
  784525
  785429
  785624
  785638
  789728
  797335
  800454
  802016
  807744
  819635
  822828
]

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 (278236, 390701, 418228, 420363, 428426, 436186, 445037, 445712, 447129, 447138, 447614, 447828, 451825, 452626, 455859, 456398, 460082, 468805, 475661, 476729, 476767, 478011, 486284, 490608, 512551, 517716, 519273, 520422, 521424, 522783, 523139, 525190, 525204, 525251, 528326, 528327, 528328, 528329, 534778, 537492, 537669, 591867, 592256, 601755, 614710, 622210, 630277, 650413, 651117, 663349, 675479, 682510, 687524, 714710, 714743, 722178, 725565, 729538, 739514, 744204, 775939, 780249, 784525, 785429, 785624, 785638, 789728, 797335, 800454, 802016, 807744, 819635, 822828);

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
  278236
  390701
  418228
  420363
  428426
  436186
  445037
  445712
  447129
  447138
  447614
  447828
  451825
  452626
  455859
  456398
  460082
  468805
  475661
  476729
  476767
  478011
  486284
  490608
  512551
  517716
  519273
  520422
  521424
  522783
  523139
  525190
  525204
  525251
  528326
  528327
  528328
  528329
  534778
  537492
  537669
  591867
  592256
  601755
  614710
  622210
  630277
  650413
  651117
  663349
  675479
  682510
  687524
  714710
  714743
  722178
  725565
  729538
  739514
  744204
  775939
  780249
  784525
  785429
  785624
  785638
  789728
  797335
  800454
  802016
  807744
  819635
  822828
]

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 (278236, 390701, 418228, 420363, 428426, 436186, 445037, 445712, 447129, 447138, 447614, 447828, 451825, 452626, 455859, 456398, 460082, 468805, 475661, 476729, 476767, 478011, 486284, 490608, 512551, 517716, 519273, 520422, 521424, 522783, 523139, 525190, 525204, 525251, 528326, 528327, 528328, 528329, 534778, 537492, 537669, 591867, 592256, 601755, 614710, 622210, 630277, 650413, 651117, 663349, 675479, 682510, 687524, 714710, 714743, 722178, 725565, 729538, 739514, 744204, 775939, 780249, 784525, 785429, 785624, 785638, 789728, 797335, 800454, 802016, 807744, 819635, 822828);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "melody"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'melody';

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

[
  "melody"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'melody';

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 ?

[
  "melody 2023"
  "melody 2023"
  "melody 2023"
  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 ('melody 2023') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('melody 2023')
              AND `query` <> 'melody 2023'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;