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

[
  b"в колготках под штанаÐ…"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD0B220D0BAD0BED0BBD0B3D0BED182D0BAD0B0D18520D0BFD0BED0B420D188D182D0B0D0BDD0B0D0E280A6 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
  396438
  584483
  433954
  406347
  559365
  812726
  432453
  432534
  433707
  432413
  422920
  546977
  433696
  503429
  787567
  584611
  20180
  433552
  490879
  510312
  513816
  422469
  432440
  397407
  483260
  432471
  432394
  563444
  520488
  486256
  718468
  786098
  490874
  522066
  412101
  470724
  812573
  696984
  527823
  428821
  455625
  467750
  523634
  555533
  470199
  623026
  620250
  522478
  568344
  470209
  487321
  535016
  470213
  511907
  609210
  494066
]

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 (396438, 584483, 433954, 406347, 559365, 812726, 432453, 432534, 433707, 432413, 422920, 546977, 433696, 503429, 787567, 584611, 20180, 433552, 490879, 510312, 513816, 422469, 432440, 397407, 483260, 432471, 432394, 563444, 520488, 486256, 718468, 786098, 490874, 522066, 412101, 470724, 812573, 696984, 527823, 428821, 455625, 467750, 523634, 555533, 470199, 623026, 620250, 522478, 568344, 470209, 487321, 535016, 470213, 511907, 609210, 494066);

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
  20180
  396438
  397407
  406347
  412101
  422469
  422920
  428821
  432394
  432413
  432440
  432453
  432471
  432534
  433552
  433696
  433707
  433954
  455625
  467750
  470199
  470209
  470213
  470724
  483260
  486256
  487321
  490874
  490879
  494066
  503429
  510312
  511907
  513816
  520488
  522066
  522478
  523634
  527823
  535016
  546977
  555533
  559365
  563444
  568344
  584483
  584611
  609210
  620250
  623026
  696984
  718468
  786098
  787567
  812573
  812726
]

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 (20180, 396438, 397407, 406347, 412101, 422469, 422920, 428821, 432394, 432413, 432440, 432453, 432471, 432534, 433552, 433696, 433707, 433954, 455625, 467750, 470199, 470209, 470213, 470724, 483260, 486256, 487321, 490874, 490879, 494066, 503429, 510312, 511907, 513816, 520488, 522066, 522478, 523634, 527823, 535016, 546977, 555533, 559365, 563444, 568344, 584483, 584611, 609210, 620250, 623026, 696984, 718468, 786098, 787567, 812573, 812726);

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
  20180
  396438
  397407
  406347
  412101
  422469
  422920
  428821
  432394
  432413
  432440
  432453
  432471
  432534
  433552
  433696
  433707
  433954
  455625
  467750
  470199
  470209
  470213
  470724
  483260
  486256
  487321
  490874
  490879
  494066
  503429
  510312
  511907
  513816
  520488
  522066
  522478
  523634
  527823
  535016
  546977
  555533
  559365
  563444
  568344
  584483
  584611
  609210
  620250
  623026
  696984
  718468
  786098
  787567
  812573
  812726
]

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 (20180, 396438, 397407, 406347, 412101, 422469, 422920, 428821, 432394, 432413, 432440, 432453, 432471, 432534, 433552, 433696, 433707, 433954, 455625, 467750, 470199, 470209, 470213, 470724, 483260, 486256, 487321, 490874, 490879, 494066, 503429, 510312, 511907, 513816, 520488, 522066, 522478, 523634, 527823, 535016, 546977, 555533, 559365, 563444, 568344, 584483, 584611, 609210, 620250, 623026, 696984, 718468, 786098, 787567, 812573, 812726);

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 ?

[
  b"в колготках под штанаÐ…"
  b"в колготках под штанаÐ…"
  b"в колготках под штанаÐ…"
  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 (0xD0B220D0BAD0BED0BBD0B3D0BED182D0BAD0B0D18520D0BFD0BED0B420D188D182D0B0D0BDD0B0D0E280A6) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (0xD0B220D0BAD0BED0BBD0B3D0BED182D0BAD0B0D18520D0BFD0BED0B420D188D182D0B0D0BDD0B0D0E280A6)
              AND `query` <> 0xD0B220D0BAD0BED0BBD0B3D0BED182D0BAD0B0D18520D0BFD0BED0B420D188D182D0B0D0BDD0B0D0E280A6
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;