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
  567220
  561178
  568382
  590482
  594074
  601911
  601944
  619999
  591119
  599450
  521446
  523720
  513137
  486938
  532975
  522976
  514594
  548340
  575747
  543479
  570998
  656792
  582468
  620674
  598838
  603873
  604381
  607256
  642686
  603159
  605500
  620085
  620216
  620559
  590859
  597112
  621559
  436074
  407597
  465219
  509164
  523780
  524544
  492169
  570765
  647656
  684305
  559796
  603923
  614074
  615444
  622187
  587896
  617205
  623727
  476147
  479872
  502741
  538669
  485630
  504411
  507681
  527087
  548870
  562814
  586575
  593366
  606697
  617212
  475630
  512554
  486904
]

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 (567220, 561178, 568382, 590482, 594074, 601911, 601944, 619999, 591119, 599450, 521446, 523720, 513137, 486938, 532975, 522976, 514594, 548340, 575747, 543479, 570998, 656792, 582468, 620674, 598838, 603873, 604381, 607256, 642686, 603159, 605500, 620085, 620216, 620559, 590859, 597112, 621559, 436074, 407597, 465219, 509164, 523780, 524544, 492169, 570765, 647656, 684305, 559796, 603923, 614074, 615444, 622187, 587896, 617205, 623727, 476147, 479872, 502741, 538669, 485630, 504411, 507681, 527087, 548870, 562814, 586575, 593366, 606697, 617212, 475630, 512554, 486904);

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
  407597
  436074
  465219
  475630
  476147
  479872
  485630
  486904
  486938
  492169
  502741
  504411
  507681
  509164
  512554
  513137
  514594
  521446
  522976
  523720
  523780
  524544
  527087
  532975
  538669
  543479
  548340
  548870
  559796
  561178
  562814
  567220
  568382
  570765
  570998
  575747
  582468
  586575
  587896
  590482
  590859
  591119
  593366
  594074
  597112
  598838
  599450
  601911
  601944
  603159
  603873
  603923
  604381
  605500
  606697
  607256
  614074
  615444
  617205
  617212
  619999
  620085
  620216
  620559
  620674
  621559
  622187
  623727
  642686
  647656
  656792
  684305
]

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 (407597, 436074, 465219, 475630, 476147, 479872, 485630, 486904, 486938, 492169, 502741, 504411, 507681, 509164, 512554, 513137, 514594, 521446, 522976, 523720, 523780, 524544, 527087, 532975, 538669, 543479, 548340, 548870, 559796, 561178, 562814, 567220, 568382, 570765, 570998, 575747, 582468, 586575, 587896, 590482, 590859, 591119, 593366, 594074, 597112, 598838, 599450, 601911, 601944, 603159, 603873, 603923, 604381, 605500, 606697, 607256, 614074, 615444, 617205, 617212, 619999, 620085, 620216, 620559, 620674, 621559, 622187, 623727, 642686, 647656, 656792, 684305);

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
  407597
  436074
  465219
  475630
  476147
  479872
  485630
  486904
  486938
  492169
  502741
  504411
  507681
  509164
  512554
  513137
  514594
  521446
  522976
  523720
  523780
  524544
  527087
  532975
  538669
  543479
  548340
  548870
  559796
  561178
  562814
  567220
  568382
  570765
  570998
  575747
  582468
  586575
  587896
  590482
  590859
  591119
  593366
  594074
  597112
  598838
  599450
  601911
  601944
  603159
  603873
  603923
  604381
  605500
  606697
  607256
  614074
  615444
  617205
  617212
  619999
  620085
  620216
  620559
  620674
  621559
  622187
  623727
  642686
  647656
  656792
  684305
]

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 (407597, 436074, 465219, 475630, 476147, 479872, 485630, 486904, 486938, 492169, 502741, 504411, 507681, 509164, 512554, 513137, 514594, 521446, 522976, 523720, 523780, 524544, 527087, 532975, 538669, 543479, 548340, 548870, 559796, 561178, 562814, 567220, 568382, 570765, 570998, 575747, 582468, 586575, 587896, 590482, 590859, 591119, 593366, 594074, 597112, 598838, 599450, 601911, 601944, 603159, 603873, 603923, 604381, 605500, 606697, 607256, 614074, 615444, 617205, 617212, 619999, 620085, 620216, 620559, 620674, 621559, 622187, 623727, 642686, 647656, 656792, 684305);

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
        ;