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
  781616
  760512
  787165
  498803
  695660
  792006
  778372
  811241
  787602
  802536
  742886
  498830
  813945
  540161
  533717
  716568
  786174
  755975
  815046
  815099
  534020
  721537
  587605
  599474
  468011
  543720
  550282
  630493
  620575
  527850
  604103
  572189
  695962
  609608
  499731
  518072
  643411
  736881
  787547
  512260
  512269
  460328
  575212
  786178
  647964
  451266
  452017
  827680
  662382
  393417
  249470
  820542
  820417
  449316
  483336
  341889
  413346
  460058
  431026
  512273
  575767
  452070
  512270
  525634
  478781
  512261
  512265
  574776
  478969
  512263
  496771
  541923
  596168
  536400
]

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 (781616, 760512, 787165, 498803, 695660, 792006, 778372, 811241, 787602, 802536, 742886, 498830, 813945, 540161, 533717, 716568, 786174, 755975, 815046, 815099, 534020, 721537, 587605, 599474, 468011, 543720, 550282, 630493, 620575, 527850, 604103, 572189, 695962, 609608, 499731, 518072, 643411, 736881, 787547, 512260, 512269, 460328, 575212, 786178, 647964, 451266, 452017, 827680, 662382, 393417, 249470, 820542, 820417, 449316, 483336, 341889, 413346, 460058, 431026, 512273, 575767, 452070, 512270, 525634, 478781, 512261, 512265, 574776, 478969, 512263, 496771, 541923, 596168, 536400);

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
  249470
  341889
  393417
  413346
  431026
  449316
  451266
  452017
  452070
  460058
  460328
  468011
  478781
  478969
  483336
  496771
  498803
  498830
  499731
  512260
  512261
  512263
  512265
  512269
  512270
  512273
  518072
  525634
  527850
  533717
  534020
  536400
  540161
  541923
  543720
  550282
  572189
  574776
  575212
  575767
  587605
  596168
  599474
  604103
  609608
  620575
  630493
  643411
  647964
  662382
  695660
  695962
  716568
  721537
  736881
  742886
  755975
  760512
  778372
  781616
  786174
  786178
  787165
  787547
  787602
  792006
  802536
  811241
  813945
  815046
  815099
  820417
  820542
  827680
]

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 (249470, 341889, 393417, 413346, 431026, 449316, 451266, 452017, 452070, 460058, 460328, 468011, 478781, 478969, 483336, 496771, 498803, 498830, 499731, 512260, 512261, 512263, 512265, 512269, 512270, 512273, 518072, 525634, 527850, 533717, 534020, 536400, 540161, 541923, 543720, 550282, 572189, 574776, 575212, 575767, 587605, 596168, 599474, 604103, 609608, 620575, 630493, 643411, 647964, 662382, 695660, 695962, 716568, 721537, 736881, 742886, 755975, 760512, 778372, 781616, 786174, 786178, 787165, 787547, 787602, 792006, 802536, 811241, 813945, 815046, 815099, 820417, 820542, 827680);

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
  249470
  341889
  393417
  413346
  431026
  449316
  451266
  452017
  452070
  460058
  460328
  468011
  478781
  478969
  483336
  496771
  498803
  498830
  499731
  512260
  512261
  512263
  512265
  512269
  512270
  512273
  518072
  525634
  527850
  533717
  534020
  536400
  540161
  541923
  543720
  550282
  572189
  574776
  575212
  575767
  587605
  596168
  599474
  604103
  609608
  620575
  630493
  643411
  647964
  662382
  695660
  695962
  716568
  721537
  736881
  742886
  755975
  760512
  778372
  781616
  786174
  786178
  787165
  787547
  787602
  792006
  802536
  811241
  813945
  815046
  815099
  820417
  820542
  827680
]

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 (249470, 341889, 393417, 413346, 431026, 449316, 451266, 452017, 452070, 460058, 460328, 468011, 478781, 478969, 483336, 496771, 498803, 498830, 499731, 512260, 512261, 512263, 512265, 512269, 512270, 512273, 518072, 525634, 527850, 533717, 534020, 536400, 540161, 541923, 543720, 550282, 572189, 574776, 575212, 575767, 587605, 596168, 599474, 604103, 609608, 620575, 630493, 643411, 647964, 662382, 695660, 695962, 716568, 721537, 736881, 742886, 755975, 760512, 778372, 781616, 786174, 786178, 787165, 787547, 787602, 792006, 802536, 811241, 813945, 815046, 815099, 820417, 820542, 827680);

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

[
  "sasharose"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'sasharose';

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

[
  "sasharose"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sasharose';

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
        ;