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“’{øFsjƒÃçT\n
    œeo
    """
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193927BF846736A83C3E7540A9C656F 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
  523013
  517716
  579714
  606387
  662000
  660060
  590280
  593863
  515971
  515523
  606801
  494784
  568580
  606798
  419860
  561073
  530371
  501286
  477114
  445026
  523577
  517369
  523673
  468128
  588801
  454107
  501641
  484970
  508686
  516771
  548258
  506787
  525450
  631195
  609604
  541201
  624346
  553070
  533760
  474744
  522594
  513534
  513303
  429797
  491804
  524281
  541197
  633796
  553129
  627807
  536789
  632261
  638298
  578411
  568555
  618378
  584059
  553992
  634153
  634885
  628397
  631194
  675017
  606929
  579367
  628332
  621612
  541632
  500562
  582631
  696213
  503658
  530690
  537210
  524276
  635275
]

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 (523013, 517716, 579714, 606387, 662000, 660060, 590280, 593863, 515971, 515523, 606801, 494784, 568580, 606798, 419860, 561073, 530371, 501286, 477114, 445026, 523577, 517369, 523673, 468128, 588801, 454107, 501641, 484970, 508686, 516771, 548258, 506787, 525450, 631195, 609604, 541201, 624346, 553070, 533760, 474744, 522594, 513534, 513303, 429797, 491804, 524281, 541197, 633796, 553129, 627807, 536789, 632261, 638298, 578411, 568555, 618378, 584059, 553992, 634153, 634885, 628397, 631194, 675017, 606929, 579367, 628332, 621612, 541632, 500562, 582631, 696213, 503658, 530690, 537210, 524276, 635275);

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
  419860
  429797
  445026
  454107
  468128
  474744
  477114
  484970
  491804
  494784
  500562
  501286
  501641
  503658
  506787
  508686
  513303
  513534
  515523
  515971
  516771
  517369
  517716
  522594
  523013
  523577
  523673
  524276
  524281
  525450
  530371
  530690
  533760
  536789
  537210
  541197
  541201
  541632
  548258
  553070
  553129
  553992
  561073
  568555
  568580
  578411
  579367
  579714
  582631
  584059
  588801
  590280
  593863
  606387
  606798
  606801
  606929
  609604
  618378
  621612
  624346
  627807
  628332
  628397
  631194
  631195
  632261
  633796
  634153
  634885
  635275
  638298
  660060
  662000
  675017
  696213
]

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 (419860, 429797, 445026, 454107, 468128, 474744, 477114, 484970, 491804, 494784, 500562, 501286, 501641, 503658, 506787, 508686, 513303, 513534, 515523, 515971, 516771, 517369, 517716, 522594, 523013, 523577, 523673, 524276, 524281, 525450, 530371, 530690, 533760, 536789, 537210, 541197, 541201, 541632, 548258, 553070, 553129, 553992, 561073, 568555, 568580, 578411, 579367, 579714, 582631, 584059, 588801, 590280, 593863, 606387, 606798, 606801, 606929, 609604, 618378, 621612, 624346, 627807, 628332, 628397, 631194, 631195, 632261, 633796, 634153, 634885, 635275, 638298, 660060, 662000, 675017, 696213);

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
  419860
  429797
  445026
  454107
  468128
  474744
  477114
  484970
  491804
  494784
  500562
  501286
  501641
  503658
  506787
  508686
  513303
  513534
  515523
  515971
  516771
  517369
  517716
  522594
  523013
  523577
  523673
  524276
  524281
  525450
  530371
  530690
  533760
  536789
  537210
  541197
  541201
  541632
  548258
  553070
  553129
  553992
  561073
  568555
  568580
  578411
  579367
  579714
  582631
  584059
  588801
  590280
  593863
  606387
  606798
  606801
  606929
  609604
  618378
  621612
  624346
  627807
  628332
  628397
  631194
  631195
  632261
  633796
  634153
  634885
  635275
  638298
  660060
  662000
  675017
  696213
]

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 (419860, 429797, 445026, 454107, 468128, 474744, 477114, 484970, 491804, 494784, 500562, 501286, 501641, 503658, 506787, 508686, 513303, 513534, 515523, 515971, 516771, 517369, 517716, 522594, 523013, 523577, 523673, 524276, 524281, 525450, 530371, 530690, 533760, 536789, 537210, 541197, 541201, 541632, 548258, 553070, 553129, 553992, 561073, 568555, 568580, 578411, 579367, 579714, 582631, 584059, 588801, 590280, 593863, 606387, 606798, 606801, 606929, 609604, 618378, 621612, 624346, 627807, 628332, 628397, 631194, 631195, 632261, 633796, 634153, 634885, 635275, 638298, 660060, 662000, 675017, 696213);

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` = 'хардкор секс в рот';