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
  797650
  497230
  655539
  590266
  578109
  534462
  763624
  524965
  567293
  810548
  813461
  810660
  777212
  788093
  777560
  510565
  522521
  794983
  728655
  543209
  592062
  589026
  813347
  761789
  543428
  578217
  477968
  559139
  540338
  540656
  589034
  492341
  540286
  522239
  807335
  620597
  666892
  520325
  543148
  581989
  534032
  666895
  534378
  516998
  632611
  551564
  600382
  602439
  520989
  608541
  545409
  540559
  481143
  666903
  570736
  535597
  550124
  561115
  592645
  545418
  540518
  552984
  514120
  582323
  545341
  526003
  429797
  599961
  676428
  630531
  616996
]

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 (797650, 497230, 655539, 590266, 578109, 534462, 763624, 524965, 567293, 810548, 813461, 810660, 777212, 788093, 777560, 510565, 522521, 794983, 728655, 543209, 592062, 589026, 813347, 761789, 543428, 578217, 477968, 559139, 540338, 540656, 589034, 492341, 540286, 522239, 807335, 620597, 666892, 520325, 543148, 581989, 534032, 666895, 534378, 516998, 632611, 551564, 600382, 602439, 520989, 608541, 545409, 540559, 481143, 666903, 570736, 535597, 550124, 561115, 592645, 545418, 540518, 552984, 514120, 582323, 545341, 526003, 429797, 599961, 676428, 630531, 616996);

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
  429797
  477968
  481143
  492341
  497230
  510565
  514120
  516998
  520325
  520989
  522239
  522521
  524965
  526003
  534032
  534378
  534462
  535597
  540286
  540338
  540518
  540559
  540656
  543148
  543209
  543428
  545341
  545409
  545418
  550124
  551564
  552984
  559139
  561115
  567293
  570736
  578109
  578217
  581989
  582323
  589026
  589034
  590266
  592062
  592645
  599961
  600382
  602439
  608541
  616996
  620597
  630531
  632611
  655539
  666892
  666895
  666903
  676428
  728655
  761789
  763624
  777212
  788093
  794983
  797650
  807335
  810548
  810660
  813347
  813461
]

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 (429797, 477968, 481143, 492341, 497230, 510565, 514120, 516998, 520325, 520989, 522239, 522521, 524965, 526003, 534032, 534378, 534462, 535597, 540286, 540338, 540518, 540559, 540656, 543148, 543209, 543428, 545341, 545409, 545418, 550124, 551564, 552984, 559139, 561115, 567293, 570736, 578109, 578217, 581989, 582323, 589026, 589034, 590266, 592062, 592645, 599961, 600382, 602439, 608541, 616996, 620597, 630531, 632611, 655539, 666892, 666895, 666903, 676428, 728655, 761789, 763624, 777212, 788093, 794983, 797650, 807335, 810548, 810660, 813347, 813461);

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
  429797
  477968
  481143
  492341
  497230
  510565
  514120
  516998
  520325
  520989
  522239
  522521
  524965
  526003
  534032
  534378
  534462
  535597
  540286
  540338
  540518
  540559
  540656
  543148
  543209
  543428
  545341
  545409
  545418
  550124
  551564
  552984
  559139
  561115
  567293
  570736
  578109
  578217
  581989
  582323
  589026
  589034
  590266
  592062
  592645
  599961
  600382
  602439
  608541
  616996
  620597
  630531
  632611
  655539
  666892
  666895
  666903
  676428
  728655
  761789
  763624
  777212
  788093
  794983
  797650
  807335
  810548
  810660
  813347
  813461
]

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 (429797, 477968, 481143, 492341, 497230, 510565, 514120, 516998, 520325, 520989, 522239, 522521, 524965, 526003, 534032, 534378, 534462, 535597, 540286, 540338, 540518, 540559, 540656, 543148, 543209, 543428, 545341, 545409, 545418, 550124, 551564, 552984, 559139, 561115, 567293, 570736, 578109, 578217, 581989, 582323, 589026, 589034, 590266, 592062, 592645, 599961, 600382, 602439, 608541, 616996, 620597, 630531, 632611, 655539, 666892, 666895, 666903, 676428, 728655, 761789, 763624, 777212, 788093, 794983, 797650, 807335, 810548, 810660, 813347, 813461);

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
        ;