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
  658457
  503262
  415827
  719572
  419854
  707383
  692136
  713008
  803702
  577662
  736167
  653788
  648619
  732155
  708513
  789082
  796757
  759141
  404193
  552769
  700898
  788502
  600508
  613664
  809060
  784090
  742099
  732148
  728372
  617861
  723820
  522217
  579806
  753972
  724033
  716527
  771819
  559744
  564490
  606150
  725411
  550487
  550494
  594448
  763519
  806684
  416905
  618593
  811054
  776773
  483358
  503739
  532114
  459357
  583689
  715365
  442754
  607058
  592153
  515629
  588494
  486419
  559173
  513593
  506167
  602508
  495326
  607226
]

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 (658457, 503262, 415827, 719572, 419854, 707383, 692136, 713008, 803702, 577662, 736167, 653788, 648619, 732155, 708513, 789082, 796757, 759141, 404193, 552769, 700898, 788502, 600508, 613664, 809060, 784090, 742099, 732148, 728372, 617861, 723820, 522217, 579806, 753972, 724033, 716527, 771819, 559744, 564490, 606150, 725411, 550487, 550494, 594448, 763519, 806684, 416905, 618593, 811054, 776773, 483358, 503739, 532114, 459357, 583689, 715365, 442754, 607058, 592153, 515629, 588494, 486419, 559173, 513593, 506167, 602508, 495326, 607226);

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
  404193
  415827
  416905
  419854
  442754
  459357
  483358
  486419
  495326
  503262
  503739
  506167
  513593
  515629
  522217
  532114
  550487
  550494
  552769
  559173
  559744
  564490
  577662
  579806
  583689
  588494
  592153
  594448
  600508
  602508
  606150
  607058
  607226
  613664
  617861
  618593
  648619
  653788
  658457
  692136
  700898
  707383
  708513
  713008
  715365
  716527
  719572
  723820
  724033
  725411
  728372
  732148
  732155
  736167
  742099
  753972
  763519
  771819
  776773
  784090
  788502
  789082
  796757
  803702
  806684
  809060
  811054
]

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 (404193, 415827, 416905, 419854, 442754, 459357, 483358, 486419, 495326, 503262, 503739, 506167, 513593, 515629, 522217, 532114, 550487, 550494, 552769, 559173, 559744, 564490, 577662, 579806, 583689, 588494, 592153, 594448, 600508, 602508, 606150, 607058, 607226, 613664, 617861, 618593, 648619, 653788, 658457, 692136, 700898, 707383, 708513, 713008, 715365, 716527, 719572, 723820, 724033, 725411, 728372, 732148, 732155, 736167, 742099, 753972, 763519, 771819, 776773, 784090, 788502, 789082, 796757, 803702, 806684, 809060, 811054);

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
  404193
  415827
  416905
  419854
  442754
  459357
  483358
  486419
  495326
  503262
  503739
  506167
  513593
  515629
  522217
  532114
  550487
  550494
  552769
  559173
  559744
  564490
  577662
  579806
  583689
  588494
  592153
  594448
  600508
  602508
  606150
  607058
  607226
  613664
  617861
  618593
  648619
  653788
  658457
  692136
  700898
  707383
  708513
  713008
  715365
  716527
  719572
  723820
  724033
  725411
  728372
  732148
  732155
  736167
  742099
  753972
  763519
  771819
  776773
  784090
  788502
  789082
  796757
  803702
  806684
  809060
  811054
]

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 (404193, 415827, 416905, 419854, 442754, 459357, 483358, 486419, 495326, 503262, 503739, 506167, 513593, 515629, 522217, 532114, 550487, 550494, 552769, 559173, 559744, 564490, 577662, 579806, 583689, 588494, 592153, 594448, 600508, 602508, 606150, 607058, 607226, 613664, 617861, 618593, 648619, 653788, 658457, 692136, 700898, 707383, 708513, 713008, 715365, 716527, 719572, 723820, 724033, 725411, 728372, 732148, 732155, 736167, 742099, 753972, 763519, 771819, 776773, 784090, 788502, 789082, 796757, 803702, 806684, 809060, 811054);

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
        ;