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
  727927
  791202
  795543
  782564
  581937
  704178
  732774
  810297
  524097
  728446
  579483
  518918
  663715
  654355
  759796
  781107
  758576
  753668
  802036
  786993
  735462
  789824
  366053
  721884
  780986
  728259
  721426
  764208
  813932
  815058
  418058
  777250
  759543
  744006
  766992
  705829
  780243
  720207
  791844
  765451
  732852
  793948
  720707
  666886
  814768
  677015
  798671
  770141
  780637
  795750
  761047
  619531
  717944
  591995
  464696
  491061
  756506
  628116
  538520
  678943
  635974
  775784
  639809
  643100
  517571
  608828
  552267
  605576
  662000
  678962
  642063
  679032
  621683
]

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 (727927, 791202, 795543, 782564, 581937, 704178, 732774, 810297, 524097, 728446, 579483, 518918, 663715, 654355, 759796, 781107, 758576, 753668, 802036, 786993, 735462, 789824, 366053, 721884, 780986, 728259, 721426, 764208, 813932, 815058, 418058, 777250, 759543, 744006, 766992, 705829, 780243, 720207, 791844, 765451, 732852, 793948, 720707, 666886, 814768, 677015, 798671, 770141, 780637, 795750, 761047, 619531, 717944, 591995, 464696, 491061, 756506, 628116, 538520, 678943, 635974, 775784, 639809, 643100, 517571, 608828, 552267, 605576, 662000, 678962, 642063, 679032, 621683);

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
  366053
  418058
  464696
  491061
  517571
  518918
  524097
  538520
  552267
  579483
  581937
  591995
  605576
  608828
  619531
  621683
  628116
  635974
  639809
  642063
  643100
  654355
  662000
  663715
  666886
  677015
  678943
  678962
  679032
  704178
  705829
  717944
  720207
  720707
  721426
  721884
  727927
  728259
  728446
  732774
  732852
  735462
  744006
  753668
  756506
  758576
  759543
  759796
  761047
  764208
  765451
  766992
  770141
  775784
  777250
  780243
  780637
  780986
  781107
  782564
  786993
  789824
  791202
  791844
  793948
  795543
  795750
  798671
  802036
  810297
  813932
  814768
  815058
]

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 (366053, 418058, 464696, 491061, 517571, 518918, 524097, 538520, 552267, 579483, 581937, 591995, 605576, 608828, 619531, 621683, 628116, 635974, 639809, 642063, 643100, 654355, 662000, 663715, 666886, 677015, 678943, 678962, 679032, 704178, 705829, 717944, 720207, 720707, 721426, 721884, 727927, 728259, 728446, 732774, 732852, 735462, 744006, 753668, 756506, 758576, 759543, 759796, 761047, 764208, 765451, 766992, 770141, 775784, 777250, 780243, 780637, 780986, 781107, 782564, 786993, 789824, 791202, 791844, 793948, 795543, 795750, 798671, 802036, 810297, 813932, 814768, 815058);

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
  366053
  418058
  464696
  491061
  517571
  518918
  524097
  538520
  552267
  579483
  581937
  591995
  605576
  608828
  619531
  621683
  628116
  635974
  639809
  642063
  643100
  654355
  662000
  663715
  666886
  677015
  678943
  678962
  679032
  704178
  705829
  717944
  720207
  720707
  721426
  721884
  727927
  728259
  728446
  732774
  732852
  735462
  744006
  753668
  756506
  758576
  759543
  759796
  761047
  764208
  765451
  766992
  770141
  775784
  777250
  780243
  780637
  780986
  781107
  782564
  786993
  789824
  791202
  791844
  793948
  795543
  795750
  798671
  802036
  810297
  813932
  814768
  815058
]

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 (366053, 418058, 464696, 491061, 517571, 518918, 524097, 538520, 552267, 579483, 581937, 591995, 605576, 608828, 619531, 621683, 628116, 635974, 639809, 642063, 643100, 654355, 662000, 663715, 666886, 677015, 678943, 678962, 679032, 704178, 705829, 717944, 720207, 720707, 721426, 721884, 727927, 728259, 728446, 732774, 732852, 735462, 744006, 753668, 756506, 758576, 759543, 759796, 761047, 764208, 765451, 766992, 770141, 775784, 777250, 780243, 780637, 780986, 781107, 782564, 786993, 789824, 791202, 791844, 793948, 795543, 795750, 798671, 802036, 810297, 813932, 814768, 815058);

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
        ;