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 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
  715190
  592663
  783913
  591512
  468266
  782471
  577262
  357845
  568625
  141512
  597922
  301402
  573226
  553921
  810762
  644119
  670794
  783946
  471963
  462369
  405716
  536432
  537022
  560064
  545820
  601224
  606084
  616551
  773063
  477927
  505530
  591545
  456098
  548213
  569043
  682618
  625262
  523226
  576192
  596360
  604901
  497426
  601322
  489729
  656050
  531943
  533707
]

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 (715190, 592663, 783913, 591512, 468266, 782471, 577262, 357845, 568625, 141512, 597922, 301402, 573226, 553921, 810762, 644119, 670794, 783946, 471963, 462369, 405716, 536432, 537022, 560064, 545820, 601224, 606084, 616551, 773063, 477927, 505530, 591545, 456098, 548213, 569043, 682618, 625262, 523226, 576192, 596360, 604901, 497426, 601322, 489729, 656050, 531943, 533707);

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
  141512
  301402
  357845
  405716
  456098
  462369
  468266
  471963
  477927
  489729
  497426
  505530
  523226
  531943
  533707
  536432
  537022
  545820
  548213
  553921
  560064
  568625
  569043
  573226
  576192
  577262
  591512
  591545
  592663
  596360
  597922
  601224
  601322
  604901
  606084
  616551
  625262
  644119
  656050
  670794
  682618
  715190
  773063
  782471
  783913
  783946
  810762
]

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 (141512, 301402, 357845, 405716, 456098, 462369, 468266, 471963, 477927, 489729, 497426, 505530, 523226, 531943, 533707, 536432, 537022, 545820, 548213, 553921, 560064, 568625, 569043, 573226, 576192, 577262, 591512, 591545, 592663, 596360, 597922, 601224, 601322, 604901, 606084, 616551, 625262, 644119, 656050, 670794, 682618, 715190, 773063, 782471, 783913, 783946, 810762);

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
  141512
  301402
  357845
  405716
  456098
  462369
  468266
  471963
  477927
  489729
  497426
  505530
  523226
  531943
  533707
  536432
  537022
  545820
  548213
  553921
  560064
  568625
  569043
  573226
  576192
  577262
  591512
  591545
  592663
  596360
  597922
  601224
  601322
  604901
  606084
  616551
  625262
  644119
  656050
  670794
  682618
  715190
  773063
  782471
  783913
  783946
  810762
]

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 (141512, 301402, 357845, 405716, 456098, 462369, 468266, 471963, 477927, 489729, 497426, 505530, 523226, 531943, 533707, 536432, 537022, 545820, 548213, 553921, 560064, 568625, 569043, 573226, 576192, 577262, 591512, 591545, 592663, 596360, 597922, 601224, 601322, 604901, 606084, 616551, 625262, 644119, 656050, 670794, 682618, 715190, 773063, 782471, 783913, 783946, 810762);

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
        ;