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

[
  "возраст 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'возраст 18' 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
  476709
  477721
  563218
  566304
  448812
  462279
  469885
  466097
  490182
  581663
  581797
  601538
  495022
  504208
  657402
  484519
  484673
  563440
  419546
  464564
  459857
  506803
  578396
  601846
  614717
  480808
  474663
  520731
  546913
  564256
  590966
  599342
  619065
  626855
  620243
  601851
  609652
  482321
  495218
  518865
  520881
  491854
  492682
  580775
  550442
  624215
  489112
  554639
  577378
  565169
  586628
  618874
  609929
  615444
  568327
  609196
  528075
  560391
  563420
  590404
  591284
  591314
  620098
  586564
  621340
  613413
  523929
  484632
  502741
  516472
  526736
  515119
  549225
  619527
]

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 (476709, 477721, 563218, 566304, 448812, 462279, 469885, 466097, 490182, 581663, 581797, 601538, 495022, 504208, 657402, 484519, 484673, 563440, 419546, 464564, 459857, 506803, 578396, 601846, 614717, 480808, 474663, 520731, 546913, 564256, 590966, 599342, 619065, 626855, 620243, 601851, 609652, 482321, 495218, 518865, 520881, 491854, 492682, 580775, 550442, 624215, 489112, 554639, 577378, 565169, 586628, 618874, 609929, 615444, 568327, 609196, 528075, 560391, 563420, 590404, 591284, 591314, 620098, 586564, 621340, 613413, 523929, 484632, 502741, 516472, 526736, 515119, 549225, 619527);

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
  419546
  448812
  459857
  462279
  464564
  466097
  469885
  474663
  476709
  477721
  480808
  482321
  484519
  484632
  484673
  489112
  490182
  491854
  492682
  495022
  495218
  502741
  504208
  506803
  515119
  516472
  518865
  520731
  520881
  523929
  526736
  528075
  546913
  549225
  550442
  554639
  560391
  563218
  563420
  563440
  564256
  565169
  566304
  568327
  577378
  578396
  580775
  581663
  581797
  586564
  586628
  590404
  590966
  591284
  591314
  599342
  601538
  601846
  601851
  609196
  609652
  609929
  613413
  614717
  615444
  618874
  619065
  619527
  620098
  620243
  621340
  624215
  626855
  657402
]

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 (419546, 448812, 459857, 462279, 464564, 466097, 469885, 474663, 476709, 477721, 480808, 482321, 484519, 484632, 484673, 489112, 490182, 491854, 492682, 495022, 495218, 502741, 504208, 506803, 515119, 516472, 518865, 520731, 520881, 523929, 526736, 528075, 546913, 549225, 550442, 554639, 560391, 563218, 563420, 563440, 564256, 565169, 566304, 568327, 577378, 578396, 580775, 581663, 581797, 586564, 586628, 590404, 590966, 591284, 591314, 599342, 601538, 601846, 601851, 609196, 609652, 609929, 613413, 614717, 615444, 618874, 619065, 619527, 620098, 620243, 621340, 624215, 626855, 657402);

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
  419546
  448812
  459857
  462279
  464564
  466097
  469885
  474663
  476709
  477721
  480808
  482321
  484519
  484632
  484673
  489112
  490182
  491854
  492682
  495022
  495218
  502741
  504208
  506803
  515119
  516472
  518865
  520731
  520881
  523929
  526736
  528075
  546913
  549225
  550442
  554639
  560391
  563218
  563420
  563440
  564256
  565169
  566304
  568327
  577378
  578396
  580775
  581663
  581797
  586564
  586628
  590404
  590966
  591284
  591314
  599342
  601538
  601846
  601851
  609196
  609652
  609929
  613413
  614717
  615444
  618874
  619065
  619527
  620098
  620243
  621340
  624215
  626855
  657402
]

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 (419546, 448812, 459857, 462279, 464564, 466097, 469885, 474663, 476709, 477721, 480808, 482321, 484519, 484632, 484673, 489112, 490182, 491854, 492682, 495022, 495218, 502741, 504208, 506803, 515119, 516472, 518865, 520731, 520881, 523929, 526736, 528075, 546913, 549225, 550442, 554639, 560391, 563218, 563420, 563440, 564256, 565169, 566304, 568327, 577378, 578396, 580775, 581663, 581797, 586564, 586628, 590404, 590966, 591284, 591314, 599342, 601538, 601846, 601851, 609196, 609652, 609929, 613413, 614717, 615444, 618874, 619065, 619527, 620098, 620243, 621340, 624215, 626855, 657402);

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

[
  "возраст 18"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'возраст 18';

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

[
  "возраст 18"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'возраст 18';

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 ?

[
  "возраст 18"
  "возраст 18"
  "возраст 18"
  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 ('возраст 18') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('возраст 18')
              AND `query` <> 'возраст 18'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;