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"18-ð╗ðÁÐéð¢ÐÅÐÅ ÐÇÐâÐüÐüð║ð░ÐÅ ð▓ ð┐ð©ÐüÐ%ÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0x31382DD0BBD0B5D182D0BDD18FD18F20D180D183D181D181D0BAD0B0D18F20D0B220D0BFD0B8D181D125E280A6 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
  393298
  400161
  463095
  454856
  580296
  602655
  448667
  505836
  510769
  528353
  609196
  620620
  515184
  599044
  480326
  595507
  553992
  564009
  600535
  620493
  522049
  621612
  600069
  551487
  480117
  529078
  452477
  515459
  560006
  602991
  612455
  528252
  486300
  483788
  404292
  587421
  624734
  596423
  574527
  625701
  510757
  654740
  478025
  461137
  484498
  459486
  605996
  410657
  567829
  514997
  565322
  577909
  521989
  419627
  522077
  603954
  576113
  510266
  589148
  620205
  529450
  603813
  521815
]

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 (393298, 400161, 463095, 454856, 580296, 602655, 448667, 505836, 510769, 528353, 609196, 620620, 515184, 599044, 480326, 595507, 553992, 564009, 600535, 620493, 522049, 621612, 600069, 551487, 480117, 529078, 452477, 515459, 560006, 602991, 612455, 528252, 486300, 483788, 404292, 587421, 624734, 596423, 574527, 625701, 510757, 654740, 478025, 461137, 484498, 459486, 605996, 410657, 567829, 514997, 565322, 577909, 521989, 419627, 522077, 603954, 576113, 510266, 589148, 620205, 529450, 603813, 521815);

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
  393298
  400161
  404292
  410657
  419627
  448667
  452477
  454856
  459486
  461137
  463095
  478025
  480117
  480326
  483788
  484498
  486300
  505836
  510266
  510757
  510769
  514997
  515184
  515459
  521815
  521989
  522049
  522077
  528252
  528353
  529078
  529450
  551487
  553992
  560006
  564009
  565322
  567829
  574527
  576113
  577909
  580296
  587421
  589148
  595507
  596423
  599044
  600069
  600535
  602655
  602991
  603813
  603954
  605996
  609196
  612455
  620205
  620493
  620620
  621612
  624734
  625701
  654740
]

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 (393298, 400161, 404292, 410657, 419627, 448667, 452477, 454856, 459486, 461137, 463095, 478025, 480117, 480326, 483788, 484498, 486300, 505836, 510266, 510757, 510769, 514997, 515184, 515459, 521815, 521989, 522049, 522077, 528252, 528353, 529078, 529450, 551487, 553992, 560006, 564009, 565322, 567829, 574527, 576113, 577909, 580296, 587421, 589148, 595507, 596423, 599044, 600069, 600535, 602655, 602991, 603813, 603954, 605996, 609196, 612455, 620205, 620493, 620620, 621612, 624734, 625701, 654740);

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
  393298
  400161
  404292
  410657
  419627
  448667
  452477
  454856
  459486
  461137
  463095
  478025
  480117
  480326
  483788
  484498
  486300
  505836
  510266
  510757
  510769
  514997
  515184
  515459
  521815
  521989
  522049
  522077
  528252
  528353
  529078
  529450
  551487
  553992
  560006
  564009
  565322
  567829
  574527
  576113
  577909
  580296
  587421
  589148
  595507
  596423
  599044
  600069
  600535
  602655
  602991
  603813
  603954
  605996
  609196
  612455
  620205
  620493
  620620
  621612
  624734
  625701
  654740
]

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 (393298, 400161, 404292, 410657, 419627, 448667, 452477, 454856, 459486, 461137, 463095, 478025, 480117, 480326, 483788, 484498, 486300, 505836, 510266, 510757, 510769, 514997, 515184, 515459, 521815, 521989, 522049, 522077, 528252, 528353, 529078, 529450, 551487, 553992, 560006, 564009, 565322, 567829, 574527, 576113, 577909, 580296, 587421, 589148, 595507, 596423, 599044, 600069, 600535, 602655, 602991, 603813, 603954, 605996, 609196, 612455, 620205, 620493, 620620, 621612, 624734, 625701, 654740);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "18 19 русск лет в пис"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = '18 19 русск лет в пис';

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

[
  "18 19 русск лет в пис"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = '18 19 русск лет в пис';

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"18-ð╗ðÁÐéð¢ÐÅÐÅ ÐÇÐâÐüÐüð║ð░ÐÅ ð▓ ð┐ð©ÐüÐ%ÔǪ"
  b"18-ð╗ðÁÐéð¢ÐÅÐÅ ÐÇÐâÐüÐüð║ð░ÐÅ ð▓ ð┐ð©ÐüÐ%ÔǪ"
  b"18-ð╗ðÁÐéð¢ÐÅÐÅ ÐÇÐâÐüÐüð║ð░ÐÅ ð▓ ð┐ð©ÐüÐ%ÔǪ"
  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 (0x31382DD0BBD0B5D182D0BDD18FD18F20D180D183D181D181D0BAD0B0D18F20D0B220D0BFD0B8D181D125E280A6) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (0x31382DD0BBD0B5D182D0BDD18FD18F20D180D183D181D181D0BAD0B0D18F20D0B220D0BFD0B8D181D125E280A6)
              AND `query` <> 0x31382DD0BBD0B5D182D0BDD18FD18F20D180D183D181D181D0BAD0B0D18F20D0B220D0BFD0B8D181D125E280A6
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;