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