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

[
  "skinny gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny gangbang' LIMIT 1;

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

[
  b"\x01”!º?Épj­mMøFô\x15)"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019421BA3FC9706AAD6D4DF846F41529 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
  444654
  531247
  534984
  534387
  550207
  543858
  557985
  565277
  542864
  677783
  655705
  545773
  557676
  565245
  623196
  634115
  614747
  617411
  633445
  634774
  615717
  632595
  597272
  634769
  628082
  632269
  632616
  632978
  490201
  507880
  536584
  540437
  530382
  545363
  545389
  577331
  579113
  545488
  553272
  707391
  650316
  666880
  659323
  666868
  680176
  680197
  695127
  583982
  591882
  634187
  587864
  613174
  634198
  597963
  599361
  601933
  617132
  628383
  630869
  620636
  628371
  634218
  638967
  608756
  633449
  540330
  541643
  565541
  568450
  545418
  628333
  598806
  603906
  521453
  530369
  562814
  562825
  585716
  617420
  642662
  609196
  615696
  618326
  642700
]

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 (444654, 531247, 534984, 534387, 550207, 543858, 557985, 565277, 542864, 677783, 655705, 545773, 557676, 565245, 623196, 634115, 614747, 617411, 633445, 634774, 615717, 632595, 597272, 634769, 628082, 632269, 632616, 632978, 490201, 507880, 536584, 540437, 530382, 545363, 545389, 577331, 579113, 545488, 553272, 707391, 650316, 666880, 659323, 666868, 680176, 680197, 695127, 583982, 591882, 634187, 587864, 613174, 634198, 597963, 599361, 601933, 617132, 628383, 630869, 620636, 628371, 634218, 638967, 608756, 633449, 540330, 541643, 565541, 568450, 545418, 628333, 598806, 603906, 521453, 530369, 562814, 562825, 585716, 617420, 642662, 609196, 615696, 618326, 642700);

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
  444654
  490201
  507880
  521453
  530369
  530382
  531247
  534387
  534984
  536584
  540330
  540437
  541643
  542864
  543858
  545363
  545389
  545418
  545488
  545773
  550207
  553272
  557676
  557985
  562814
  562825
  565245
  565277
  565541
  568450
  577331
  579113
  583982
  585716
  587864
  591882
  597272
  597963
  598806
  599361
  601933
  603906
  608756
  609196
  613174
  614747
  615696
  615717
  617132
  617411
  617420
  618326
  620636
  623196
  628082
  628333
  628371
  628383
  630869
  632269
  632595
  632616
  632978
  633445
  633449
  634115
  634187
  634198
  634218
  634769
  634774
  638967
  642662
  642700
  650316
  655705
  659323
  666868
  666880
  677783
  680176
  680197
  695127
  707391
]

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 (444654, 490201, 507880, 521453, 530369, 530382, 531247, 534387, 534984, 536584, 540330, 540437, 541643, 542864, 543858, 545363, 545389, 545418, 545488, 545773, 550207, 553272, 557676, 557985, 562814, 562825, 565245, 565277, 565541, 568450, 577331, 579113, 583982, 585716, 587864, 591882, 597272, 597963, 598806, 599361, 601933, 603906, 608756, 609196, 613174, 614747, 615696, 615717, 617132, 617411, 617420, 618326, 620636, 623196, 628082, 628333, 628371, 628383, 630869, 632269, 632595, 632616, 632978, 633445, 633449, 634115, 634187, 634198, 634218, 634769, 634774, 638967, 642662, 642700, 650316, 655705, 659323, 666868, 666880, 677783, 680176, 680197, 695127, 707391);

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
  444654
  490201
  507880
  521453
  530369
  530382
  531247
  534387
  534984
  536584
  540330
  540437
  541643
  542864
  543858
  545363
  545389
  545418
  545488
  545773
  550207
  553272
  557676
  557985
  562814
  562825
  565245
  565277
  565541
  568450
  577331
  579113
  583982
  585716
  587864
  591882
  597272
  597963
  598806
  599361
  601933
  603906
  608756
  609196
  613174
  614747
  615696
  615717
  617132
  617411
  617420
  618326
  620636
  623196
  628082
  628333
  628371
  628383
  630869
  632269
  632595
  632616
  632978
  633445
  633449
  634115
  634187
  634198
  634218
  634769
  634774
  638967
  642662
  642700
  650316
  655705
  659323
  666868
  666880
  677783
  680176
  680197
  695127
  707391
]

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 (444654, 490201, 507880, 521453, 530369, 530382, 531247, 534387, 534984, 536584, 540330, 540437, 541643, 542864, 543858, 545363, 545389, 545418, 545488, 545773, 550207, 553272, 557676, 557985, 562814, 562825, 565245, 565277, 565541, 568450, 577331, 579113, 583982, 585716, 587864, 591882, 597272, 597963, 598806, 599361, 601933, 603906, 608756, 609196, 613174, 614747, 615696, 615717, 617132, 617411, 617420, 618326, 620636, 623196, 628082, 628333, 628371, 628383, 630869, 632269, 632595, 632616, 632978, 633445, 633449, 634115, 634187, 634198, 634218, 634769, 634774, 638967, 642662, 642700, 650316, 655705, 659323, 666868, 666880, 677783, 680176, 680197, 695127, 707391);

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

[
  "худые gangbang"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые gangbang';

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

[
  "худые gangbang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые gangbang';