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
  483826
  429027
  663832
  653393
  362958
  142491
  772204
  381770
  96468
  698140
  233446
  393684
  453587
  455016
  461918
  130089
  501893
  393778
  408443
  526528
  523452
  471593
  451565
  620779
  443752
  510748
  442987
  396450
  469917
  513106
  563399
  453089
  446344
  482938
  575437
  437678
  410430
  429181
  389124
  510617
  400719
  517853
  454293
  420769
  515226
  549371
  501255
  391262
  511938
  506143
  551243
  610255
  453329
  583640
  601478
  460731
  484472
  557387
  417212
  443099
  430081
  462209
  554301
  591882
  599361
  459857
  467611
  545015
  567208
  627652
  613179
  543881
  652281
  475630
  554392
]

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 (483826, 429027, 663832, 653393, 362958, 142491, 772204, 381770, 96468, 698140, 233446, 393684, 453587, 455016, 461918, 130089, 501893, 393778, 408443, 526528, 523452, 471593, 451565, 620779, 443752, 510748, 442987, 396450, 469917, 513106, 563399, 453089, 446344, 482938, 575437, 437678, 410430, 429181, 389124, 510617, 400719, 517853, 454293, 420769, 515226, 549371, 501255, 391262, 511938, 506143, 551243, 610255, 453329, 583640, 601478, 460731, 484472, 557387, 417212, 443099, 430081, 462209, 554301, 591882, 599361, 459857, 467611, 545015, 567208, 627652, 613179, 543881, 652281, 475630, 554392);

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
  96468
  130089
  142491
  233446
  362958
  381770
  389124
  391262
  393684
  393778
  396450
  400719
  408443
  410430
  417212
  420769
  429027
  429181
  430081
  437678
  442987
  443099
  443752
  446344
  451565
  453089
  453329
  453587
  454293
  455016
  459857
  460731
  461918
  462209
  467611
  469917
  471593
  475630
  482938
  483826
  484472
  501255
  501893
  506143
  510617
  510748
  511938
  513106
  515226
  517853
  523452
  526528
  543881
  545015
  549371
  551243
  554301
  554392
  557387
  563399
  567208
  575437
  583640
  591882
  599361
  601478
  610255
  613179
  620779
  627652
  652281
  653393
  663832
  698140
  772204
]

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 (96468, 130089, 142491, 233446, 362958, 381770, 389124, 391262, 393684, 393778, 396450, 400719, 408443, 410430, 417212, 420769, 429027, 429181, 430081, 437678, 442987, 443099, 443752, 446344, 451565, 453089, 453329, 453587, 454293, 455016, 459857, 460731, 461918, 462209, 467611, 469917, 471593, 475630, 482938, 483826, 484472, 501255, 501893, 506143, 510617, 510748, 511938, 513106, 515226, 517853, 523452, 526528, 543881, 545015, 549371, 551243, 554301, 554392, 557387, 563399, 567208, 575437, 583640, 591882, 599361, 601478, 610255, 613179, 620779, 627652, 652281, 653393, 663832, 698140, 772204);

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
  96468
  130089
  142491
  233446
  362958
  381770
  389124
  391262
  393684
  393778
  396450
  400719
  408443
  410430
  417212
  420769
  429027
  429181
  430081
  437678
  442987
  443099
  443752
  446344
  451565
  453089
  453329
  453587
  454293
  455016
  459857
  460731
  461918
  462209
  467611
  469917
  471593
  475630
  482938
  483826
  484472
  501255
  501893
  506143
  510617
  510748
  511938
  513106
  515226
  517853
  523452
  526528
  543881
  545015
  549371
  551243
  554301
  554392
  557387
  563399
  567208
  575437
  583640
  591882
  599361
  601478
  610255
  613179
  620779
  627652
  652281
  653393
  663832
  698140
  772204
]

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 (96468, 130089, 142491, 233446, 362958, 381770, 389124, 391262, 393684, 393778, 396450, 400719, 408443, 410430, 417212, 420769, 429027, 429181, 430081, 437678, 442987, 443099, 443752, 446344, 451565, 453089, 453329, 453587, 454293, 455016, 459857, 460731, 461918, 462209, 467611, 469917, 471593, 475630, 482938, 483826, 484472, 501255, 501893, 506143, 510617, 510748, 511938, 513106, 515226, 517853, 523452, 526528, 543881, 545015, 549371, 551243, 554301, 554392, 557387, 563399, 567208, 575437, 583640, 591882, 599361, 601478, 610255, 613179, 620779, 627652, 652281, 653393, 663832, 698140, 772204);

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
        ;