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
  513521
  523023
  439726
  536618
  549643
  573746
  662653
  554358
  573733
  596323
  439615
  472148
  439575
  450544
  450964
  480095
  439460
  440581
  445706
  458199
  465353
  439581
  439612
  449178
  455913
  465346
  477454
  528081
  496874
  502750
  513518
  540802
  486576
  493164
  500375
  486590
  513474
  522363
  542218
  562003
  676989
  557592
  619526
  439649
  439653
  439718
  465354
  439664
  454584
  470100
  523032
  495325
  496870
  502745
  527295
  566908
  513338
  503272
  435728
  524513
  568305
  440993
  439518
  439558
  509995
  522690
  523033
  619519
  486569
  542903
  591065
  621340
  619527
  626944
]

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 (513521, 523023, 439726, 536618, 549643, 573746, 662653, 554358, 573733, 596323, 439615, 472148, 439575, 450544, 450964, 480095, 439460, 440581, 445706, 458199, 465353, 439581, 439612, 449178, 455913, 465346, 477454, 528081, 496874, 502750, 513518, 540802, 486576, 493164, 500375, 486590, 513474, 522363, 542218, 562003, 676989, 557592, 619526, 439649, 439653, 439718, 465354, 439664, 454584, 470100, 523032, 495325, 496870, 502745, 527295, 566908, 513338, 503272, 435728, 524513, 568305, 440993, 439518, 439558, 509995, 522690, 523033, 619519, 486569, 542903, 591065, 621340, 619527, 626944);

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
  435728
  439460
  439518
  439558
  439575
  439581
  439612
  439615
  439649
  439653
  439664
  439718
  439726
  440581
  440993
  445706
  449178
  450544
  450964
  454584
  455913
  458199
  465346
  465353
  465354
  470100
  472148
  477454
  480095
  486569
  486576
  486590
  493164
  495325
  496870
  496874
  500375
  502745
  502750
  503272
  509995
  513338
  513474
  513518
  513521
  522363
  522690
  523023
  523032
  523033
  524513
  527295
  528081
  536618
  540802
  542218
  542903
  549643
  554358
  557592
  562003
  566908
  568305
  573733
  573746
  591065
  596323
  619519
  619526
  619527
  621340
  626944
  662653
  676989
]

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 (435728, 439460, 439518, 439558, 439575, 439581, 439612, 439615, 439649, 439653, 439664, 439718, 439726, 440581, 440993, 445706, 449178, 450544, 450964, 454584, 455913, 458199, 465346, 465353, 465354, 470100, 472148, 477454, 480095, 486569, 486576, 486590, 493164, 495325, 496870, 496874, 500375, 502745, 502750, 503272, 509995, 513338, 513474, 513518, 513521, 522363, 522690, 523023, 523032, 523033, 524513, 527295, 528081, 536618, 540802, 542218, 542903, 549643, 554358, 557592, 562003, 566908, 568305, 573733, 573746, 591065, 596323, 619519, 619526, 619527, 621340, 626944, 662653, 676989);

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
  435728
  439460
  439518
  439558
  439575
  439581
  439612
  439615
  439649
  439653
  439664
  439718
  439726
  440581
  440993
  445706
  449178
  450544
  450964
  454584
  455913
  458199
  465346
  465353
  465354
  470100
  472148
  477454
  480095
  486569
  486576
  486590
  493164
  495325
  496870
  496874
  500375
  502745
  502750
  503272
  509995
  513338
  513474
  513518
  513521
  522363
  522690
  523023
  523032
  523033
  524513
  527295
  528081
  536618
  540802
  542218
  542903
  549643
  554358
  557592
  562003
  566908
  568305
  573733
  573746
  591065
  596323
  619519
  619526
  619527
  621340
  626944
  662653
  676989
]

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 (435728, 439460, 439518, 439558, 439575, 439581, 439612, 439615, 439649, 439653, 439664, 439718, 439726, 440581, 440993, 445706, 449178, 450544, 450964, 454584, 455913, 458199, 465346, 465353, 465354, 470100, 472148, 477454, 480095, 486569, 486576, 486590, 493164, 495325, 496870, 496874, 500375, 502745, 502750, 503272, 509995, 513338, 513474, 513518, 513521, 522363, 522690, 523023, 523032, 523033, 524513, 527295, 528081, 536618, 540802, 542218, 542903, 549643, 554358, 557592, 562003, 566908, 568305, 573733, 573746, 591065, 596323, 619519, 619526, 619527, 621340, 626944, 662653, 676989);

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
        ;