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

[
  "bottom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bottom' 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
  827358
  828478
  595030
  781160
  539674
  535852
  795380
  747065
  824842
  828589
  533070
  554700
  671653
  796748
  493561
  716250
  545780
  687852
  722644
  694720
  769149
  507510
  511630
  546177
  725493
  813940
  514887
  460857
  461425
  712539
  797948
  760881
  737186
  740054
  777902
  799407
  740847
  725473
  514860
  525905
  694925
  802419
  794384
  508900
  523382
  527279
  809649
  725440
  382251
  447213
  815617
  671625
  707470
  427308
  511282
  422671
  563391
  586026
  528143
  426805
  428261
  422633
  507169
  422638
  457438
  515969
  525669
  515454
  540398
  584521
  500714
  526951
  529367
  560205
]

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 (827358, 828478, 595030, 781160, 539674, 535852, 795380, 747065, 824842, 828589, 533070, 554700, 671653, 796748, 493561, 716250, 545780, 687852, 722644, 694720, 769149, 507510, 511630, 546177, 725493, 813940, 514887, 460857, 461425, 712539, 797948, 760881, 737186, 740054, 777902, 799407, 740847, 725473, 514860, 525905, 694925, 802419, 794384, 508900, 523382, 527279, 809649, 725440, 382251, 447213, 815617, 671625, 707470, 427308, 511282, 422671, 563391, 586026, 528143, 426805, 428261, 422633, 507169, 422638, 457438, 515969, 525669, 515454, 540398, 584521, 500714, 526951, 529367, 560205);

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
  382251
  422633
  422638
  422671
  426805
  427308
  428261
  447213
  457438
  460857
  461425
  493561
  500714
  507169
  507510
  508900
  511282
  511630
  514860
  514887
  515454
  515969
  523382
  525669
  525905
  526951
  527279
  528143
  529367
  533070
  535852
  539674
  540398
  545780
  546177
  554700
  560205
  563391
  584521
  586026
  595030
  671625
  671653
  687852
  694720
  694925
  707470
  712539
  716250
  722644
  725440
  725473
  725493
  737186
  740054
  740847
  747065
  760881
  769149
  777902
  781160
  794384
  795380
  796748
  797948
  799407
  802419
  809649
  813940
  815617
  824842
  827358
  828478
  828589
]

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 (382251, 422633, 422638, 422671, 426805, 427308, 428261, 447213, 457438, 460857, 461425, 493561, 500714, 507169, 507510, 508900, 511282, 511630, 514860, 514887, 515454, 515969, 523382, 525669, 525905, 526951, 527279, 528143, 529367, 533070, 535852, 539674, 540398, 545780, 546177, 554700, 560205, 563391, 584521, 586026, 595030, 671625, 671653, 687852, 694720, 694925, 707470, 712539, 716250, 722644, 725440, 725473, 725493, 737186, 740054, 740847, 747065, 760881, 769149, 777902, 781160, 794384, 795380, 796748, 797948, 799407, 802419, 809649, 813940, 815617, 824842, 827358, 828478, 828589);

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
  382251
  422633
  422638
  422671
  426805
  427308
  428261
  447213
  457438
  460857
  461425
  493561
  500714
  507169
  507510
  508900
  511282
  511630
  514860
  514887
  515454
  515969
  523382
  525669
  525905
  526951
  527279
  528143
  529367
  533070
  535852
  539674
  540398
  545780
  546177
  554700
  560205
  563391
  584521
  586026
  595030
  671625
  671653
  687852
  694720
  694925
  707470
  712539
  716250
  722644
  725440
  725473
  725493
  737186
  740054
  740847
  747065
  760881
  769149
  777902
  781160
  794384
  795380
  796748
  797948
  799407
  802419
  809649
  813940
  815617
  824842
  827358
  828478
  828589
]

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 (382251, 422633, 422638, 422671, 426805, 427308, 428261, 447213, 457438, 460857, 461425, 493561, 500714, 507169, 507510, 508900, 511282, 511630, 514860, 514887, 515454, 515969, 523382, 525669, 525905, 526951, 527279, 528143, 529367, 533070, 535852, 539674, 540398, 545780, 546177, 554700, 560205, 563391, 584521, 586026, 595030, 671625, 671653, 687852, 694720, 694925, 707470, 712539, 716250, 722644, 725440, 725473, 725493, 737186, 740054, 740847, 747065, 760881, 769149, 777902, 781160, 794384, 795380, 796748, 797948, 799407, 802419, 809649, 813940, 815617, 824842, 827358, 828478, 828589);

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

[
  "bottom"
]

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

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

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

[
  "bottom"
]

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

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

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 ?

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