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

[
  "small teenagers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'small teenagers' 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
  824426
  619042
  573855
  685516
  687833
  573875
  573078
  573716
  573583
  573083
  573632
  573093
  573008
  573590
  573623
  573665
  715409
  571646
  730031
  733651
  573634
  573712
  573119
  573619
  573622
  573714
  573857
  469813
  573077
  573959
  573614
  573692
  573840
  503771
  397683
  578390
  573057
  573961
  573964
  573970
  545993
  538230
  538386
  499233
  478264
  475542
  573017
  573709
  573644
  573127
  661253
  573817
  394240
  497536
  476419
  534172
  538203
  573810
  573125
  476420
  385292
  565273
  548754
  622761
  601471
  490208
  538190
  524725
  504137
  516429
  680159
  629021
]

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 (824426, 619042, 573855, 685516, 687833, 573875, 573078, 573716, 573583, 573083, 573632, 573093, 573008, 573590, 573623, 573665, 715409, 571646, 730031, 733651, 573634, 573712, 573119, 573619, 573622, 573714, 573857, 469813, 573077, 573959, 573614, 573692, 573840, 503771, 397683, 578390, 573057, 573961, 573964, 573970, 545993, 538230, 538386, 499233, 478264, 475542, 573017, 573709, 573644, 573127, 661253, 573817, 394240, 497536, 476419, 534172, 538203, 573810, 573125, 476420, 385292, 565273, 548754, 622761, 601471, 490208, 538190, 524725, 504137, 516429, 680159, 629021);

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
  385292
  394240
  397683
  469813
  475542
  476419
  476420
  478264
  490208
  497536
  499233
  503771
  504137
  516429
  524725
  534172
  538190
  538203
  538230
  538386
  545993
  548754
  565273
  571646
  573008
  573017
  573057
  573077
  573078
  573083
  573093
  573119
  573125
  573127
  573583
  573590
  573614
  573619
  573622
  573623
  573632
  573634
  573644
  573665
  573692
  573709
  573712
  573714
  573716
  573810
  573817
  573840
  573855
  573857
  573875
  573959
  573961
  573964
  573970
  578390
  601471
  619042
  622761
  629021
  661253
  680159
  685516
  687833
  715409
  730031
  733651
  824426
]

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 (385292, 394240, 397683, 469813, 475542, 476419, 476420, 478264, 490208, 497536, 499233, 503771, 504137, 516429, 524725, 534172, 538190, 538203, 538230, 538386, 545993, 548754, 565273, 571646, 573008, 573017, 573057, 573077, 573078, 573083, 573093, 573119, 573125, 573127, 573583, 573590, 573614, 573619, 573622, 573623, 573632, 573634, 573644, 573665, 573692, 573709, 573712, 573714, 573716, 573810, 573817, 573840, 573855, 573857, 573875, 573959, 573961, 573964, 573970, 578390, 601471, 619042, 622761, 629021, 661253, 680159, 685516, 687833, 715409, 730031, 733651, 824426);

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
  385292
  394240
  397683
  469813
  475542
  476419
  476420
  478264
  490208
  497536
  499233
  503771
  504137
  516429
  524725
  534172
  538190
  538203
  538230
  538386
  545993
  548754
  565273
  571646
  573008
  573017
  573057
  573077
  573078
  573083
  573093
  573119
  573125
  573127
  573583
  573590
  573614
  573619
  573622
  573623
  573632
  573634
  573644
  573665
  573692
  573709
  573712
  573714
  573716
  573810
  573817
  573840
  573855
  573857
  573875
  573959
  573961
  573964
  573970
  578390
  601471
  619042
  622761
  629021
  661253
  680159
  685516
  687833
  715409
  730031
  733651
  824426
]

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 (385292, 394240, 397683, 469813, 475542, 476419, 476420, 478264, 490208, 497536, 499233, 503771, 504137, 516429, 524725, 534172, 538190, 538203, 538230, 538386, 545993, 548754, 565273, 571646, 573008, 573017, 573057, 573077, 573078, 573083, 573093, 573119, 573125, 573127, 573583, 573590, 573614, 573619, 573622, 573623, 573632, 573634, 573644, 573665, 573692, 573709, 573712, 573714, 573716, 573810, 573817, 573840, 573855, 573857, 573875, 573959, 573961, 573964, 573970, 578390, 601471, 619042, 622761, 629021, 661253, 680159, 685516, 687833, 715409, 730031, 733651, 824426);

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

[
  "маленькая teenagers"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'маленькая teenagers';

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

[
  "маленькая teenagers"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'маленькая teenagers';

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 ?

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