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
  311697
  390935
  775159
  524218
  567037
  392544
  533485
  781365
  397807
  542887
  629319
  519375
  601169
  643455
  581278
  437854
  445014
  525752
  540227
  542910
  586919
  454930
  409919
  540230
  545783
  493546
  518877
  548140
  548086
  583944
  554064
  656304
  422813
  450258
  567798
  529952
  475683
  440635
  464840
  466911
  467101
  468301
  575302
  545788
  647495
  461088
  498551
  545829
  81734
  548128
  596147
  529956
  605266
  529954
  486476
  545800
  552623
  619651
  545834
  532604
  544012
  545833
  545839
  532531
  537487
  656303
  434601
  605521
  541830
  632701
  573212
]

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 (311697, 390935, 775159, 524218, 567037, 392544, 533485, 781365, 397807, 542887, 629319, 519375, 601169, 643455, 581278, 437854, 445014, 525752, 540227, 542910, 586919, 454930, 409919, 540230, 545783, 493546, 518877, 548140, 548086, 583944, 554064, 656304, 422813, 450258, 567798, 529952, 475683, 440635, 464840, 466911, 467101, 468301, 575302, 545788, 647495, 461088, 498551, 545829, 81734, 548128, 596147, 529956, 605266, 529954, 486476, 545800, 552623, 619651, 545834, 532604, 544012, 545833, 545839, 532531, 537487, 656303, 434601, 605521, 541830, 632701, 573212);

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
  81734
  311697
  390935
  392544
  397807
  409919
  422813
  434601
  437854
  440635
  445014
  450258
  454930
  461088
  464840
  466911
  467101
  468301
  475683
  486476
  493546
  498551
  518877
  519375
  524218
  525752
  529952
  529954
  529956
  532531
  532604
  533485
  537487
  540227
  540230
  541830
  542887
  542910
  544012
  545783
  545788
  545800
  545829
  545833
  545834
  545839
  548086
  548128
  548140
  552623
  554064
  567037
  567798
  573212
  575302
  581278
  583944
  586919
  596147
  601169
  605266
  605521
  619651
  629319
  632701
  643455
  647495
  656303
  656304
  775159
  781365
]

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 (81734, 311697, 390935, 392544, 397807, 409919, 422813, 434601, 437854, 440635, 445014, 450258, 454930, 461088, 464840, 466911, 467101, 468301, 475683, 486476, 493546, 498551, 518877, 519375, 524218, 525752, 529952, 529954, 529956, 532531, 532604, 533485, 537487, 540227, 540230, 541830, 542887, 542910, 544012, 545783, 545788, 545800, 545829, 545833, 545834, 545839, 548086, 548128, 548140, 552623, 554064, 567037, 567798, 573212, 575302, 581278, 583944, 586919, 596147, 601169, 605266, 605521, 619651, 629319, 632701, 643455, 647495, 656303, 656304, 775159, 781365);

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
  81734
  311697
  390935
  392544
  397807
  409919
  422813
  434601
  437854
  440635
  445014
  450258
  454930
  461088
  464840
  466911
  467101
  468301
  475683
  486476
  493546
  498551
  518877
  519375
  524218
  525752
  529952
  529954
  529956
  532531
  532604
  533485
  537487
  540227
  540230
  541830
  542887
  542910
  544012
  545783
  545788
  545800
  545829
  545833
  545834
  545839
  548086
  548128
  548140
  552623
  554064
  567037
  567798
  573212
  575302
  581278
  583944
  586919
  596147
  601169
  605266
  605521
  619651
  629319
  632701
  643455
  647495
  656303
  656304
  775159
  781365
]

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 (81734, 311697, 390935, 392544, 397807, 409919, 422813, 434601, 437854, 440635, 445014, 450258, 454930, 461088, 464840, 466911, 467101, 468301, 475683, 486476, 493546, 498551, 518877, 519375, 524218, 525752, 529952, 529954, 529956, 532531, 532604, 533485, 537487, 540227, 540230, 541830, 542887, 542910, 544012, 545783, 545788, 545800, 545829, 545833, 545834, 545839, 548086, 548128, 548140, 552623, 554064, 567037, 567798, 573212, 575302, 581278, 583944, 586919, 596147, 601169, 605266, 605521, 619651, 629319, 632701, 643455, 647495, 656303, 656304, 775159, 781365);

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
        ;