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 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01ö┘╗²tr\x06æ7\eªð\x1EUØ"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0194D9BBFD74720691371BA6D01E559D 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
  619870
  797760
  431496
  400496
  392602
  426180
  385248
  445138
  538224
  585048
  466174
  518484
  536887
  498143
  571565
  553410
  578333
  564472
  676418
  716660
  645319
  681782
  552476
  556310
  613791
  596954
  617636
  606042
  633607
  634589
  812585
  726446
  433596
  425333
  492721
  512296
  460600
  522782
  580982
  560758
  559238
  569134
  620117
  621336
  603783
  800556
  772399
  401185
  416314
  430297
  499969
  482870
  505775
  499657
  460590
  687551
  561929
  603478
  589795
  621270
  810902
  515858
  503863
  574322
  564122
  679350
  606036
  603696
  611556
  521033
  563362
  652981
  608787
  530999
  683083
  647307
  626942
  587921
  570866
  608560
  621520
]

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 (619870, 797760, 431496, 400496, 392602, 426180, 385248, 445138, 538224, 585048, 466174, 518484, 536887, 498143, 571565, 553410, 578333, 564472, 676418, 716660, 645319, 681782, 552476, 556310, 613791, 596954, 617636, 606042, 633607, 634589, 812585, 726446, 433596, 425333, 492721, 512296, 460600, 522782, 580982, 560758, 559238, 569134, 620117, 621336, 603783, 800556, 772399, 401185, 416314, 430297, 499969, 482870, 505775, 499657, 460590, 687551, 561929, 603478, 589795, 621270, 810902, 515858, 503863, 574322, 564122, 679350, 606036, 603696, 611556, 521033, 563362, 652981, 608787, 530999, 683083, 647307, 626942, 587921, 570866, 608560, 621520);

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
  385248
  392602
  400496
  401185
  416314
  425333
  426180
  430297
  431496
  433596
  445138
  460590
  460600
  466174
  482870
  492721
  498143
  499657
  499969
  503863
  505775
  512296
  515858
  518484
  521033
  522782
  530999
  536887
  538224
  552476
  553410
  556310
  559238
  560758
  561929
  563362
  564122
  564472
  569134
  570866
  571565
  574322
  578333
  580982
  585048
  587921
  589795
  596954
  603478
  603696
  603783
  606036
  606042
  608560
  608787
  611556
  613791
  617636
  619870
  620117
  621270
  621336
  621520
  626942
  633607
  634589
  645319
  647307
  652981
  676418
  679350
  681782
  683083
  687551
  716660
  726446
  772399
  797760
  800556
  810902
  812585
]

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 (385248, 392602, 400496, 401185, 416314, 425333, 426180, 430297, 431496, 433596, 445138, 460590, 460600, 466174, 482870, 492721, 498143, 499657, 499969, 503863, 505775, 512296, 515858, 518484, 521033, 522782, 530999, 536887, 538224, 552476, 553410, 556310, 559238, 560758, 561929, 563362, 564122, 564472, 569134, 570866, 571565, 574322, 578333, 580982, 585048, 587921, 589795, 596954, 603478, 603696, 603783, 606036, 606042, 608560, 608787, 611556, 613791, 617636, 619870, 620117, 621270, 621336, 621520, 626942, 633607, 634589, 645319, 647307, 652981, 676418, 679350, 681782, 683083, 687551, 716660, 726446, 772399, 797760, 800556, 810902, 812585);

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
  385248
  392602
  400496
  401185
  416314
  425333
  426180
  430297
  431496
  433596
  445138
  460590
  460600
  466174
  482870
  492721
  498143
  499657
  499969
  503863
  505775
  512296
  515858
  518484
  521033
  522782
  530999
  536887
  538224
  552476
  553410
  556310
  559238
  560758
  561929
  563362
  564122
  564472
  569134
  570866
  571565
  574322
  578333
  580982
  585048
  587921
  589795
  596954
  603478
  603696
  603783
  606036
  606042
  608560
  608787
  611556
  613791
  617636
  619870
  620117
  621270
  621336
  621520
  626942
  633607
  634589
  645319
  647307
  652981
  676418
  679350
  681782
  683083
  687551
  716660
  726446
  772399
  797760
  800556
  810902
  812585
]

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 (385248, 392602, 400496, 401185, 416314, 425333, 426180, 430297, 431496, 433596, 445138, 460590, 460600, 466174, 482870, 492721, 498143, 499657, 499969, 503863, 505775, 512296, 515858, 518484, 521033, 522782, 530999, 536887, 538224, 552476, 553410, 556310, 559238, 560758, 561929, 563362, 564122, 564472, 569134, 570866, 571565, 574322, 578333, 580982, 585048, 587921, 589795, 596954, 603478, 603696, 603783, 606036, 606042, 608560, 608787, 611556, 613791, 617636, 619870, 620117, 621270, 621336, 621520, 626942, 633607, 634589, 645319, 647307, 652981, 676418, 679350, 681782, 683083, 687551, 716660, 726446, 772399, 797760, 800556, 810902, 812585);

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` = 'красивый';