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
  294932
  568353
  443166
  516424
  493796
  764888
  571401
  764757
  504072
  761018
  575780
  723209
  574567
  609669
  607363
  728393
  814700
  694580
  788033
  788575
  737453
  802064
  783104
  517834
  660831
  761584
  799746
  810316
  688093
  731851
  776662
  707089
  761162
  704915
  604181
  755332
  800321
  555170
  766107
  713845
  709622
  695337
  788830
  810302
  517069
  490111
  530893
  566829
  759900
  473992
  485456
  523849
  564401
  563415
  778607
  651913
  513495
  730599
  801258
  744939
  528499
  466018
  503381
  526152
  473180
  592412
  526570
  604640
  451042
  535411
  583148
  591217
  601963
]

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 (294932, 568353, 443166, 516424, 493796, 764888, 571401, 764757, 504072, 761018, 575780, 723209, 574567, 609669, 607363, 728393, 814700, 694580, 788033, 788575, 737453, 802064, 783104, 517834, 660831, 761584, 799746, 810316, 688093, 731851, 776662, 707089, 761162, 704915, 604181, 755332, 800321, 555170, 766107, 713845, 709622, 695337, 788830, 810302, 517069, 490111, 530893, 566829, 759900, 473992, 485456, 523849, 564401, 563415, 778607, 651913, 513495, 730599, 801258, 744939, 528499, 466018, 503381, 526152, 473180, 592412, 526570, 604640, 451042, 535411, 583148, 591217, 601963);

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
  294932
  443166
  451042
  466018
  473180
  473992
  485456
  490111
  493796
  503381
  504072
  513495
  516424
  517069
  517834
  523849
  526152
  526570
  528499
  530893
  535411
  555170
  563415
  564401
  566829
  568353
  571401
  574567
  575780
  583148
  591217
  592412
  601963
  604181
  604640
  607363
  609669
  651913
  660831
  688093
  694580
  695337
  704915
  707089
  709622
  713845
  723209
  728393
  730599
  731851
  737453
  744939
  755332
  759900
  761018
  761162
  761584
  764757
  764888
  766107
  776662
  778607
  783104
  788033
  788575
  788830
  799746
  800321
  801258
  802064
  810302
  810316
  814700
]

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 (294932, 443166, 451042, 466018, 473180, 473992, 485456, 490111, 493796, 503381, 504072, 513495, 516424, 517069, 517834, 523849, 526152, 526570, 528499, 530893, 535411, 555170, 563415, 564401, 566829, 568353, 571401, 574567, 575780, 583148, 591217, 592412, 601963, 604181, 604640, 607363, 609669, 651913, 660831, 688093, 694580, 695337, 704915, 707089, 709622, 713845, 723209, 728393, 730599, 731851, 737453, 744939, 755332, 759900, 761018, 761162, 761584, 764757, 764888, 766107, 776662, 778607, 783104, 788033, 788575, 788830, 799746, 800321, 801258, 802064, 810302, 810316, 814700);

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
  294932
  443166
  451042
  466018
  473180
  473992
  485456
  490111
  493796
  503381
  504072
  513495
  516424
  517069
  517834
  523849
  526152
  526570
  528499
  530893
  535411
  555170
  563415
  564401
  566829
  568353
  571401
  574567
  575780
  583148
  591217
  592412
  601963
  604181
  604640
  607363
  609669
  651913
  660831
  688093
  694580
  695337
  704915
  707089
  709622
  713845
  723209
  728393
  730599
  731851
  737453
  744939
  755332
  759900
  761018
  761162
  761584
  764757
  764888
  766107
  776662
  778607
  783104
  788033
  788575
  788830
  799746
  800321
  801258
  802064
  810302
  810316
  814700
]

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 (294932, 443166, 451042, 466018, 473180, 473992, 485456, 490111, 493796, 503381, 504072, 513495, 516424, 517069, 517834, 523849, 526152, 526570, 528499, 530893, 535411, 555170, 563415, 564401, 566829, 568353, 571401, 574567, 575780, 583148, 591217, 592412, 601963, 604181, 604640, 607363, 609669, 651913, 660831, 688093, 694580, 695337, 704915, 707089, 709622, 713845, 723209, 728393, 730599, 731851, 737453, 744939, 755332, 759900, 761018, 761162, 761584, 764757, 764888, 766107, 776662, 778607, 783104, 788033, 788575, 788830, 799746, 800321, 801258, 802064, 810302, 810316, 814700);

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
        ;