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

[
  "masturbate pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'masturbate pussy' LIMIT 1;

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

[
  b"\x01ö\x07í`¶r¸▓Ú\x1F│k╔Éú"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019407A160F472F7B2E91FB36BC990A3 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
  425611
  824870
  494865
  527271
  526457
  567186
  562464
  621496
  586689
  606912
  618799
  614600
  790459
  777006
  796577
  734253
  741217
  803606
  767827
  770662
  739779
  605706
  707545
  790485
  790710
  435560
  484277
  567883
  590345
  437259
  471041
  478987
  526563
  499568
  460459
  583200
  564988
  674474
  614612
  600436
  589832
  604980
  617045
  601185
  612675
  801560
  753751
  726549
  739759
  412688
  457577
  520789
  554756
  564598
  567272
  602578
  596864
  632083
  438333
  509430
  529176
  597873
  593994
  435398
  560385
  680819
  644150
  697000
  453394
  455719
  536903
  584120
  623108
  516078
  516741
  572029
]

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 (425611, 824870, 494865, 527271, 526457, 567186, 562464, 621496, 586689, 606912, 618799, 614600, 790459, 777006, 796577, 734253, 741217, 803606, 767827, 770662, 739779, 605706, 707545, 790485, 790710, 435560, 484277, 567883, 590345, 437259, 471041, 478987, 526563, 499568, 460459, 583200, 564988, 674474, 614612, 600436, 589832, 604980, 617045, 601185, 612675, 801560, 753751, 726549, 739759, 412688, 457577, 520789, 554756, 564598, 567272, 602578, 596864, 632083, 438333, 509430, 529176, 597873, 593994, 435398, 560385, 680819, 644150, 697000, 453394, 455719, 536903, 584120, 623108, 516078, 516741, 572029);

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
  412688
  425611
  435398
  435560
  437259
  438333
  453394
  455719
  457577
  460459
  471041
  478987
  484277
  494865
  499568
  509430
  516078
  516741
  520789
  526457
  526563
  527271
  529176
  536903
  554756
  560385
  562464
  564598
  564988
  567186
  567272
  567883
  572029
  583200
  584120
  586689
  589832
  590345
  593994
  596864
  597873
  600436
  601185
  602578
  604980
  605706
  606912
  612675
  614600
  614612
  617045
  618799
  621496
  623108
  632083
  644150
  674474
  680819
  697000
  707545
  726549
  734253
  739759
  739779
  741217
  753751
  767827
  770662
  777006
  790459
  790485
  790710
  796577
  801560
  803606
  824870
]

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 (412688, 425611, 435398, 435560, 437259, 438333, 453394, 455719, 457577, 460459, 471041, 478987, 484277, 494865, 499568, 509430, 516078, 516741, 520789, 526457, 526563, 527271, 529176, 536903, 554756, 560385, 562464, 564598, 564988, 567186, 567272, 567883, 572029, 583200, 584120, 586689, 589832, 590345, 593994, 596864, 597873, 600436, 601185, 602578, 604980, 605706, 606912, 612675, 614600, 614612, 617045, 618799, 621496, 623108, 632083, 644150, 674474, 680819, 697000, 707545, 726549, 734253, 739759, 739779, 741217, 753751, 767827, 770662, 777006, 790459, 790485, 790710, 796577, 801560, 803606, 824870);

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
  412688
  425611
  435398
  435560
  437259
  438333
  453394
  455719
  457577
  460459
  471041
  478987
  484277
  494865
  499568
  509430
  516078
  516741
  520789
  526457
  526563
  527271
  529176
  536903
  554756
  560385
  562464
  564598
  564988
  567186
  567272
  567883
  572029
  583200
  584120
  586689
  589832
  590345
  593994
  596864
  597873
  600436
  601185
  602578
  604980
  605706
  606912
  612675
  614600
  614612
  617045
  618799
  621496
  623108
  632083
  644150
  674474
  680819
  697000
  707545
  726549
  734253
  739759
  739779
  741217
  753751
  767827
  770662
  777006
  790459
  790485
  790710
  796577
  801560
  803606
  824870
]

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 (412688, 425611, 435398, 435560, 437259, 438333, 453394, 455719, 457577, 460459, 471041, 478987, 484277, 494865, 499568, 509430, 516078, 516741, 520789, 526457, 526563, 527271, 529176, 536903, 554756, 560385, 562464, 564598, 564988, 567186, 567272, 567883, 572029, 583200, 584120, 586689, 589832, 590345, 593994, 596864, 597873, 600436, 601185, 602578, 604980, 605706, 606912, 612675, 614600, 614612, 617045, 618799, 621496, 623108, 632083, 644150, 674474, 680819, 697000, 707545, 726549, 734253, 739759, 739779, 741217, 753751, 767827, 770662, 777006, 790459, 790485, 790710, 796577, 801560, 803606, 824870);

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

[
  "masturbate pussy"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'masturbate pussy';

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

[
  "masturbate pussy"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'masturbate pussy';