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
  399668
  637178
  579521
  803303
  750161
  792768
  677916
  706587
  794931
  691459
  597870
  588822
  809057
  778784
  763336
  404193
  539513
  616392
  382429
  424042
  541948
  579661
  678260
  715395
  599213
  635621
  399710
  505375
  470437
  535986
  619734
  393845
  413948
  418141
  512821
  525918
  453229
  468190
  630328
  471811
  520191
  488623
  443093
  419854
  458305
  517428
  525171
  557571
  571983
  464714
  418359
  496864
  499783
  552253
  452256
  501258
  519239
  518493
  495608
  453069
  623975
  514674
  567220
  405156
  543387
  593008
  608336
  520346
  565169
  621520
  485449
  610606
  594231
  624226
]

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 (399668, 637178, 579521, 803303, 750161, 792768, 677916, 706587, 794931, 691459, 597870, 588822, 809057, 778784, 763336, 404193, 539513, 616392, 382429, 424042, 541948, 579661, 678260, 715395, 599213, 635621, 399710, 505375, 470437, 535986, 619734, 393845, 413948, 418141, 512821, 525918, 453229, 468190, 630328, 471811, 520191, 488623, 443093, 419854, 458305, 517428, 525171, 557571, 571983, 464714, 418359, 496864, 499783, 552253, 452256, 501258, 519239, 518493, 495608, 453069, 623975, 514674, 567220, 405156, 543387, 593008, 608336, 520346, 565169, 621520, 485449, 610606, 594231, 624226);

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
  382429
  393845
  399668
  399710
  404193
  405156
  413948
  418141
  418359
  419854
  424042
  443093
  452256
  453069
  453229
  458305
  464714
  468190
  470437
  471811
  485449
  488623
  495608
  496864
  499783
  501258
  505375
  512821
  514674
  517428
  518493
  519239
  520191
  520346
  525171
  525918
  535986
  539513
  541948
  543387
  552253
  557571
  565169
  567220
  571983
  579521
  579661
  588822
  593008
  594231
  597870
  599213
  608336
  610606
  616392
  619734
  621520
  623975
  624226
  630328
  635621
  637178
  677916
  678260
  691459
  706587
  715395
  750161
  763336
  778784
  792768
  794931
  803303
  809057
]

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 (382429, 393845, 399668, 399710, 404193, 405156, 413948, 418141, 418359, 419854, 424042, 443093, 452256, 453069, 453229, 458305, 464714, 468190, 470437, 471811, 485449, 488623, 495608, 496864, 499783, 501258, 505375, 512821, 514674, 517428, 518493, 519239, 520191, 520346, 525171, 525918, 535986, 539513, 541948, 543387, 552253, 557571, 565169, 567220, 571983, 579521, 579661, 588822, 593008, 594231, 597870, 599213, 608336, 610606, 616392, 619734, 621520, 623975, 624226, 630328, 635621, 637178, 677916, 678260, 691459, 706587, 715395, 750161, 763336, 778784, 792768, 794931, 803303, 809057);

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
  382429
  393845
  399668
  399710
  404193
  405156
  413948
  418141
  418359
  419854
  424042
  443093
  452256
  453069
  453229
  458305
  464714
  468190
  470437
  471811
  485449
  488623
  495608
  496864
  499783
  501258
  505375
  512821
  514674
  517428
  518493
  519239
  520191
  520346
  525171
  525918
  535986
  539513
  541948
  543387
  552253
  557571
  565169
  567220
  571983
  579521
  579661
  588822
  593008
  594231
  597870
  599213
  608336
  610606
  616392
  619734
  621520
  623975
  624226
  630328
  635621
  637178
  677916
  678260
  691459
  706587
  715395
  750161
  763336
  778784
  792768
  794931
  803303
  809057
]

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 (382429, 393845, 399668, 399710, 404193, 405156, 413948, 418141, 418359, 419854, 424042, 443093, 452256, 453069, 453229, 458305, 464714, 468190, 470437, 471811, 485449, 488623, 495608, 496864, 499783, 501258, 505375, 512821, 514674, 517428, 518493, 519239, 520191, 520346, 525171, 525918, 535986, 539513, 541948, 543387, 552253, 557571, 565169, 567220, 571983, 579521, 579661, 588822, 593008, 594231, 597870, 599213, 608336, 610606, 616392, 619734, 621520, 623975, 624226, 630328, 635621, 637178, 677916, 678260, 691459, 706587, 715395, 750161, 763336, 778784, 792768, 794931, 803303, 809057);

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
        ;