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
  758806
  727824
  783364
  740849
  684904
  729231
  670296
  592187
  605725
  805230
  769915
  743716
  763839
  586935
  711948
  794457
  728337
  583594
  627512
  795689
  812231
  610141
  803152
  803243
  728355
  577026
  583410
  577034
  583539
  783355
  792556
  783374
  555035
  783376
  493424
  699519
  712140
  734822
  734829
  741121
  530426
  581974
  469437
  592255
  804230
  761779
  765353
  770522
  658819
  605737
  728342
  791840
  583206
  649130
  769959
  765357
  777509
  513511
  530149
  785813
  433152
  483731
  777577
  546044
  605219
  755030
  604545
  786461
  530110
  517724
  604426
  602183
  602092
  603612
]

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 (758806, 727824, 783364, 740849, 684904, 729231, 670296, 592187, 605725, 805230, 769915, 743716, 763839, 586935, 711948, 794457, 728337, 583594, 627512, 795689, 812231, 610141, 803152, 803243, 728355, 577026, 583410, 577034, 583539, 783355, 792556, 783374, 555035, 783376, 493424, 699519, 712140, 734822, 734829, 741121, 530426, 581974, 469437, 592255, 804230, 761779, 765353, 770522, 658819, 605737, 728342, 791840, 583206, 649130, 769959, 765357, 777509, 513511, 530149, 785813, 433152, 483731, 777577, 546044, 605219, 755030, 604545, 786461, 530110, 517724, 604426, 602183, 602092, 603612);

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
  433152
  469437
  483731
  493424
  513511
  517724
  530110
  530149
  530426
  546044
  555035
  577026
  577034
  581974
  583206
  583410
  583539
  583594
  586935
  592187
  592255
  602092
  602183
  603612
  604426
  604545
  605219
  605725
  605737
  610141
  627512
  649130
  658819
  670296
  684904
  699519
  711948
  712140
  727824
  728337
  728342
  728355
  729231
  734822
  734829
  740849
  741121
  743716
  755030
  758806
  761779
  763839
  765353
  765357
  769915
  769959
  770522
  777509
  777577
  783355
  783364
  783374
  783376
  785813
  786461
  791840
  792556
  794457
  795689
  803152
  803243
  804230
  805230
  812231
]

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 (433152, 469437, 483731, 493424, 513511, 517724, 530110, 530149, 530426, 546044, 555035, 577026, 577034, 581974, 583206, 583410, 583539, 583594, 586935, 592187, 592255, 602092, 602183, 603612, 604426, 604545, 605219, 605725, 605737, 610141, 627512, 649130, 658819, 670296, 684904, 699519, 711948, 712140, 727824, 728337, 728342, 728355, 729231, 734822, 734829, 740849, 741121, 743716, 755030, 758806, 761779, 763839, 765353, 765357, 769915, 769959, 770522, 777509, 777577, 783355, 783364, 783374, 783376, 785813, 786461, 791840, 792556, 794457, 795689, 803152, 803243, 804230, 805230, 812231);

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
  433152
  469437
  483731
  493424
  513511
  517724
  530110
  530149
  530426
  546044
  555035
  577026
  577034
  581974
  583206
  583410
  583539
  583594
  586935
  592187
  592255
  602092
  602183
  603612
  604426
  604545
  605219
  605725
  605737
  610141
  627512
  649130
  658819
  670296
  684904
  699519
  711948
  712140
  727824
  728337
  728342
  728355
  729231
  734822
  734829
  740849
  741121
  743716
  755030
  758806
  761779
  763839
  765353
  765357
  769915
  769959
  770522
  777509
  777577
  783355
  783364
  783374
  783376
  785813
  786461
  791840
  792556
  794457
  795689
  803152
  803243
  804230
  805230
  812231
]

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 (433152, 469437, 483731, 493424, 513511, 517724, 530110, 530149, 530426, 546044, 555035, 577026, 577034, 581974, 583206, 583410, 583539, 583594, 586935, 592187, 592255, 602092, 602183, 603612, 604426, 604545, 605219, 605725, 605737, 610141, 627512, 649130, 658819, 670296, 684904, 699519, 711948, 712140, 727824, 728337, 728342, 728355, 729231, 734822, 734829, 740849, 741121, 743716, 755030, 758806, 761779, 763839, 765353, 765357, 769915, 769959, 770522, 777509, 777577, 783355, 783364, 783374, 783376, 785813, 786461, 791840, 792556, 794457, 795689, 803152, 803243, 804230, 805230, 812231);

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
        ;