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ôÉÉ\x0F(q\x13Àd}Ѓԣx"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019390900F287113B7647DD19FE29C78 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
  484386
  545708
  479425
  420769
  523035
  603295
  643517
  423740
  422145
  487726
  577290
  546370
  564643
  419758
  437811
  466268
  486875
  500581
  624150
  644954
  587833
  603523
  507973
  461038
  526894
  549643
  570743
  512659
  601856
  549248
  565366
  598702
  598954
  629021
  576317
  565740
  600070
  432246
  442697
  653544
  527468
  568676
  652594
  623026
  596627
  529216
  491208
  501655
  534729
  541961
  566312
  585951
  611525
  598870
  634501
  578500
  540141
  541770
  541738
  623933
  620499
  480808
  595875
  620236
  602991
  629445
  485204
  647898
  603011
  557537
  605122
  578399
  547525
  597134
  626215
  613487
  602972
  429084
]

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 (484386, 545708, 479425, 420769, 523035, 603295, 643517, 423740, 422145, 487726, 577290, 546370, 564643, 419758, 437811, 466268, 486875, 500581, 624150, 644954, 587833, 603523, 507973, 461038, 526894, 549643, 570743, 512659, 601856, 549248, 565366, 598702, 598954, 629021, 576317, 565740, 600070, 432246, 442697, 653544, 527468, 568676, 652594, 623026, 596627, 529216, 491208, 501655, 534729, 541961, 566312, 585951, 611525, 598870, 634501, 578500, 540141, 541770, 541738, 623933, 620499, 480808, 595875, 620236, 602991, 629445, 485204, 647898, 603011, 557537, 605122, 578399, 547525, 597134, 626215, 613487, 602972, 429084);

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
  419758
  420769
  422145
  423740
  429084
  432246
  437811
  442697
  461038
  466268
  479425
  480808
  484386
  485204
  486875
  487726
  491208
  500581
  501655
  507973
  512659
  523035
  526894
  527468
  529216
  534729
  540141
  541738
  541770
  541961
  545708
  546370
  547525
  549248
  549643
  557537
  564643
  565366
  565740
  566312
  568676
  570743
  576317
  577290
  578399
  578500
  585951
  587833
  595875
  596627
  597134
  598702
  598870
  598954
  600070
  601856
  602972
  602991
  603011
  603295
  603523
  605122
  611525
  613487
  620236
  620499
  623026
  623933
  624150
  626215
  629021
  629445
  634501
  643517
  644954
  647898
  652594
  653544
]

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 (419758, 420769, 422145, 423740, 429084, 432246, 437811, 442697, 461038, 466268, 479425, 480808, 484386, 485204, 486875, 487726, 491208, 500581, 501655, 507973, 512659, 523035, 526894, 527468, 529216, 534729, 540141, 541738, 541770, 541961, 545708, 546370, 547525, 549248, 549643, 557537, 564643, 565366, 565740, 566312, 568676, 570743, 576317, 577290, 578399, 578500, 585951, 587833, 595875, 596627, 597134, 598702, 598870, 598954, 600070, 601856, 602972, 602991, 603011, 603295, 603523, 605122, 611525, 613487, 620236, 620499, 623026, 623933, 624150, 626215, 629021, 629445, 634501, 643517, 644954, 647898, 652594, 653544);

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
  419758
  420769
  422145
  423740
  429084
  432246
  437811
  442697
  461038
  466268
  479425
  480808
  484386
  485204
  486875
  487726
  491208
  500581
  501655
  507973
  512659
  523035
  526894
  527468
  529216
  534729
  540141
  541738
  541770
  541961
  545708
  546370
  547525
  549248
  549643
  557537
  564643
  565366
  565740
  566312
  568676
  570743
  576317
  577290
  578399
  578500
  585951
  587833
  595875
  596627
  597134
  598702
  598870
  598954
  600070
  601856
  602972
  602991
  603011
  603295
  603523
  605122
  611525
  613487
  620236
  620499
  623026
  623933
  624150
  626215
  629021
  629445
  634501
  643517
  644954
  647898
  652594
  653544
]

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 (419758, 420769, 422145, 423740, 429084, 432246, 437811, 442697, 461038, 466268, 479425, 480808, 484386, 485204, 486875, 487726, 491208, 500581, 501655, 507973, 512659, 523035, 526894, 527468, 529216, 534729, 540141, 541738, 541770, 541961, 545708, 546370, 547525, 549248, 549643, 557537, 564643, 565366, 565740, 566312, 568676, 570743, 576317, 577290, 578399, 578500, 585951, 587833, 595875, 596627, 597134, 598702, 598870, 598954, 600070, 601856, 602972, 602991, 603011, 603295, 603523, 605122, 611525, 613487, 620236, 620499, 623026, 623933, 624150, 626215, 629021, 629445, 634501, 643517, 644954, 647898, 652594, 653544);

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` = 'в желт';