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
  516408
  518336
  491110
  525325
  502538
  547717
  542082
  567605
  601853
  424060
  484585
  675798
  564160
  567829
  595704
  593180
  616800
  587926
  466869
  421566
  516091
  503321
  522221
  428353
  621757
  597503
  603011
  462497
  515128
  520145
  486229
  561998
  580646
  543616
  566082
  570998
  651929
  652572
  567667
  626892
  595155
  613055
  636283
  601851
  607087
  597208
  469424
  515252
  510767
  533348
  543881
  556524
  574430
  577378
  557249
  680824
  555868
  580667
  598142
  621228
  623727
  609279
  617674
  469355
  518511
  524528
  541770
  526218
  619407
  590723
  528011
  558432
  590878
  560511
]

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 (516408, 518336, 491110, 525325, 502538, 547717, 542082, 567605, 601853, 424060, 484585, 675798, 564160, 567829, 595704, 593180, 616800, 587926, 466869, 421566, 516091, 503321, 522221, 428353, 621757, 597503, 603011, 462497, 515128, 520145, 486229, 561998, 580646, 543616, 566082, 570998, 651929, 652572, 567667, 626892, 595155, 613055, 636283, 601851, 607087, 597208, 469424, 515252, 510767, 533348, 543881, 556524, 574430, 577378, 557249, 680824, 555868, 580667, 598142, 621228, 623727, 609279, 617674, 469355, 518511, 524528, 541770, 526218, 619407, 590723, 528011, 558432, 590878, 560511);

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
  421566
  424060
  428353
  462497
  466869
  469355
  469424
  484585
  486229
  491110
  502538
  503321
  510767
  515128
  515252
  516091
  516408
  518336
  518511
  520145
  522221
  524528
  525325
  526218
  528011
  533348
  541770
  542082
  543616
  543881
  547717
  555868
  556524
  557249
  558432
  560511
  561998
  564160
  566082
  567605
  567667
  567829
  570998
  574430
  577378
  580646
  580667
  587926
  590723
  590878
  593180
  595155
  595704
  597208
  597503
  598142
  601851
  601853
  603011
  607087
  609279
  613055
  616800
  617674
  619407
  621228
  621757
  623727
  626892
  636283
  651929
  652572
  675798
  680824
]

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 (421566, 424060, 428353, 462497, 466869, 469355, 469424, 484585, 486229, 491110, 502538, 503321, 510767, 515128, 515252, 516091, 516408, 518336, 518511, 520145, 522221, 524528, 525325, 526218, 528011, 533348, 541770, 542082, 543616, 543881, 547717, 555868, 556524, 557249, 558432, 560511, 561998, 564160, 566082, 567605, 567667, 567829, 570998, 574430, 577378, 580646, 580667, 587926, 590723, 590878, 593180, 595155, 595704, 597208, 597503, 598142, 601851, 601853, 603011, 607087, 609279, 613055, 616800, 617674, 619407, 621228, 621757, 623727, 626892, 636283, 651929, 652572, 675798, 680824);

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
  421566
  424060
  428353
  462497
  466869
  469355
  469424
  484585
  486229
  491110
  502538
  503321
  510767
  515128
  515252
  516091
  516408
  518336
  518511
  520145
  522221
  524528
  525325
  526218
  528011
  533348
  541770
  542082
  543616
  543881
  547717
  555868
  556524
  557249
  558432
  560511
  561998
  564160
  566082
  567605
  567667
  567829
  570998
  574430
  577378
  580646
  580667
  587926
  590723
  590878
  593180
  595155
  595704
  597208
  597503
  598142
  601851
  601853
  603011
  607087
  609279
  613055
  616800
  617674
  619407
  621228
  621757
  623727
  626892
  636283
  651929
  652572
  675798
  680824
]

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 (421566, 424060, 428353, 462497, 466869, 469355, 469424, 484585, 486229, 491110, 502538, 503321, 510767, 515128, 515252, 516091, 516408, 518336, 518511, 520145, 522221, 524528, 525325, 526218, 528011, 533348, 541770, 542082, 543616, 543881, 547717, 555868, 556524, 557249, 558432, 560511, 561998, 564160, 566082, 567605, 567667, 567829, 570998, 574430, 577378, 580646, 580667, 587926, 590723, 590878, 593180, 595155, 595704, 597208, 597503, 598142, 601851, 601853, 603011, 607087, 609279, 613055, 616800, 617674, 619407, 621228, 621757, 623727, 626892, 636283, 651929, 652572, 675798, 680824);

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
        ;