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ô,ÁLÚp§£\x1A¢\x02WÅ)\f"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01932CB54CE970F59C1ABD02578F290C 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
  576089
  584631
  551190
  558847
  564407
  660520
  586180
  591784
  607372
  616971
  620320
  596677
  623206
  628389
  507973
  484498
  523335
  569686
  576095
  554425
  653537
  657402
  680197
  569357
  570866
  579273
  605416
  606687
  619318
  621449
  598838
  620290
  636283
  642686
  605586
  610869
  597045
  599483
  608416
  618943
  480800
  396168
  464385
  520008
  525525
  527414
  489893
  536397
  542550
  574527
  555868
  576310
  603493
  615444
  603816
  609839
  615801
  621265
  624217
  446376
  479629
  415419
  492736
  523336
  515184
  506338
  524542
  523822
  559127
  562825
  557235
  569682
  418686
  472486
  503840
  528075
]

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 (576089, 584631, 551190, 558847, 564407, 660520, 586180, 591784, 607372, 616971, 620320, 596677, 623206, 628389, 507973, 484498, 523335, 569686, 576095, 554425, 653537, 657402, 680197, 569357, 570866, 579273, 605416, 606687, 619318, 621449, 598838, 620290, 636283, 642686, 605586, 610869, 597045, 599483, 608416, 618943, 480800, 396168, 464385, 520008, 525525, 527414, 489893, 536397, 542550, 574527, 555868, 576310, 603493, 615444, 603816, 609839, 615801, 621265, 624217, 446376, 479629, 415419, 492736, 523336, 515184, 506338, 524542, 523822, 559127, 562825, 557235, 569682, 418686, 472486, 503840, 528075);

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
  396168
  415419
  418686
  446376
  464385
  472486
  479629
  480800
  484498
  489893
  492736
  503840
  506338
  507973
  515184
  520008
  523335
  523336
  523822
  524542
  525525
  527414
  528075
  536397
  542550
  551190
  554425
  555868
  557235
  558847
  559127
  562825
  564407
  569357
  569682
  569686
  570866
  574527
  576089
  576095
  576310
  579273
  584631
  586180
  591784
  596677
  597045
  598838
  599483
  603493
  603816
  605416
  605586
  606687
  607372
  608416
  609839
  610869
  615444
  615801
  616971
  618943
  619318
  620290
  620320
  621265
  621449
  623206
  624217
  628389
  636283
  642686
  653537
  657402
  660520
  680197
]

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 (396168, 415419, 418686, 446376, 464385, 472486, 479629, 480800, 484498, 489893, 492736, 503840, 506338, 507973, 515184, 520008, 523335, 523336, 523822, 524542, 525525, 527414, 528075, 536397, 542550, 551190, 554425, 555868, 557235, 558847, 559127, 562825, 564407, 569357, 569682, 569686, 570866, 574527, 576089, 576095, 576310, 579273, 584631, 586180, 591784, 596677, 597045, 598838, 599483, 603493, 603816, 605416, 605586, 606687, 607372, 608416, 609839, 610869, 615444, 615801, 616971, 618943, 619318, 620290, 620320, 621265, 621449, 623206, 624217, 628389, 636283, 642686, 653537, 657402, 660520, 680197);

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
  396168
  415419
  418686
  446376
  464385
  472486
  479629
  480800
  484498
  489893
  492736
  503840
  506338
  507973
  515184
  520008
  523335
  523336
  523822
  524542
  525525
  527414
  528075
  536397
  542550
  551190
  554425
  555868
  557235
  558847
  559127
  562825
  564407
  569357
  569682
  569686
  570866
  574527
  576089
  576095
  576310
  579273
  584631
  586180
  591784
  596677
  597045
  598838
  599483
  603493
  603816
  605416
  605586
  606687
  607372
  608416
  609839
  610869
  615444
  615801
  616971
  618943
  619318
  620290
  620320
  621265
  621449
  623206
  624217
  628389
  636283
  642686
  653537
  657402
  660520
  680197
]

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 (396168, 415419, 418686, 446376, 464385, 472486, 479629, 480800, 484498, 489893, 492736, 503840, 506338, 507973, 515184, 520008, 523335, 523336, 523822, 524542, 525525, 527414, 528075, 536397, 542550, 551190, 554425, 555868, 557235, 558847, 559127, 562825, 564407, 569357, 569682, 569686, 570866, 574527, 576089, 576095, 576310, 579273, 584631, 586180, 591784, 596677, 597045, 598838, 599483, 603493, 603816, 605416, 605586, 606687, 607372, 608416, 609839, 610869, 615444, 615801, 616971, 618943, 619318, 620290, 620320, 621265, 621449, 623206, 624217, 628389, 636283, 642686, 653537, 657402, 660520, 680197);

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` = 'короткие';