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

[
  "drop"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'drop' LIMIT 1;

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

[
  b"\x01“&ýÍJsîž+=ÐŒ›„â"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019326FDCD4A73EE9E2B3DD08C9B84E2 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
  537322
  502706
  540250
  556585
  550526
  561627
  568216
  652773
  710771
  554026
  638181
  607117
  774716
  795989
  745805
  810643
  434583
  449825
  496472
  516733
  484014
  520873
  449322
  453322
  538062
  538751
  505344
  556518
  543393
  576510
  596763
  798071
  791368
  765040
  636449
  418971
  451238
  516507
  198179
  465295
  559564
  584438
  707693
  545676
  766096
  389608
  436091
  437896
  486859
  446872
  714468
  525369
  529952
  516884
  541388
  617214
  482409
  501714
  489262
  507733
  675798
]

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 (537322, 502706, 540250, 556585, 550526, 561627, 568216, 652773, 710771, 554026, 638181, 607117, 774716, 795989, 745805, 810643, 434583, 449825, 496472, 516733, 484014, 520873, 449322, 453322, 538062, 538751, 505344, 556518, 543393, 576510, 596763, 798071, 791368, 765040, 636449, 418971, 451238, 516507, 198179, 465295, 559564, 584438, 707693, 545676, 766096, 389608, 436091, 437896, 486859, 446872, 714468, 525369, 529952, 516884, 541388, 617214, 482409, 501714, 489262, 507733, 675798);

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
  198179
  389608
  418971
  434583
  436091
  437896
  446872
  449322
  449825
  451238
  453322
  465295
  482409
  484014
  486859
  489262
  496472
  501714
  502706
  505344
  507733
  516507
  516733
  516884
  520873
  525369
  529952
  537322
  538062
  538751
  540250
  541388
  543393
  545676
  550526
  554026
  556518
  556585
  559564
  561627
  568216
  576510
  584438
  596763
  607117
  617214
  636449
  638181
  652773
  675798
  707693
  710771
  714468
  745805
  765040
  766096
  774716
  791368
  795989
  798071
  810643
]

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 (198179, 389608, 418971, 434583, 436091, 437896, 446872, 449322, 449825, 451238, 453322, 465295, 482409, 484014, 486859, 489262, 496472, 501714, 502706, 505344, 507733, 516507, 516733, 516884, 520873, 525369, 529952, 537322, 538062, 538751, 540250, 541388, 543393, 545676, 550526, 554026, 556518, 556585, 559564, 561627, 568216, 576510, 584438, 596763, 607117, 617214, 636449, 638181, 652773, 675798, 707693, 710771, 714468, 745805, 765040, 766096, 774716, 791368, 795989, 798071, 810643);

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
  198179
  389608
  418971
  434583
  436091
  437896
  446872
  449322
  449825
  451238
  453322
  465295
  482409
  484014
  486859
  489262
  496472
  501714
  502706
  505344
  507733
  516507
  516733
  516884
  520873
  525369
  529952
  537322
  538062
  538751
  540250
  541388
  543393
  545676
  550526
  554026
  556518
  556585
  559564
  561627
  568216
  576510
  584438
  596763
  607117
  617214
  636449
  638181
  652773
  675798
  707693
  710771
  714468
  745805
  765040
  766096
  774716
  791368
  795989
  798071
  810643
]

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 (198179, 389608, 418971, 434583, 436091, 437896, 446872, 449322, 449825, 451238, 453322, 465295, 482409, 484014, 486859, 489262, 496472, 501714, 502706, 505344, 507733, 516507, 516733, 516884, 520873, 525369, 529952, 537322, 538062, 538751, 540250, 541388, 543393, 545676, 550526, 554026, 556518, 556585, 559564, 561627, 568216, 576510, 584438, 596763, 607117, 617214, 636449, 638181, 652773, 675798, 707693, 710771, 714468, 745805, 765040, 766096, 774716, 791368, 795989, 798071, 810643);

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

[
  "drop"
]

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

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

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

[
  "drop"
]

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

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

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 ?

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