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

[
  "teens share cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teens share cock' 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
  458789
  512203
  565195
  576109
  576350
  582841
  574884
  575162
  578812
  587253
  590891
  627727
  431765
  433998
  445249
  424695
  427327
  450988
  480991
  471722
  411320
  435642
  441013
  521375
  512322
  515135
  593849
  393481
  567166
  676112
  629357
  430836
  487424
  820871
  567153
  575233
  648526
  596351
  419113
  404773
  424505
  461906
  815268
  522605
  560219
  556045
  410051
  432077
  442829
  506908
  395576
  417631
  513189
  617437
  434723
  406954
  431022
  431376
  524635
  443299
  575193
  643411
  421254
  430697
  597186
  587901
  620636
  590910
  579732
  610686
  486594
  494983
  504922
  561137
  653568
  525849
  596466
  596423
]

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 (458789, 512203, 565195, 576109, 576350, 582841, 574884, 575162, 578812, 587253, 590891, 627727, 431765, 433998, 445249, 424695, 427327, 450988, 480991, 471722, 411320, 435642, 441013, 521375, 512322, 515135, 593849, 393481, 567166, 676112, 629357, 430836, 487424, 820871, 567153, 575233, 648526, 596351, 419113, 404773, 424505, 461906, 815268, 522605, 560219, 556045, 410051, 432077, 442829, 506908, 395576, 417631, 513189, 617437, 434723, 406954, 431022, 431376, 524635, 443299, 575193, 643411, 421254, 430697, 597186, 587901, 620636, 590910, 579732, 610686, 486594, 494983, 504922, 561137, 653568, 525849, 596466, 596423);

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
  393481
  395576
  404773
  406954
  410051
  411320
  417631
  419113
  421254
  424505
  424695
  427327
  430697
  430836
  431022
  431376
  431765
  432077
  433998
  434723
  435642
  441013
  442829
  443299
  445249
  450988
  458789
  461906
  471722
  480991
  486594
  487424
  494983
  504922
  506908
  512203
  512322
  513189
  515135
  521375
  522605
  524635
  525849
  556045
  560219
  561137
  565195
  567153
  567166
  574884
  575162
  575193
  575233
  576109
  576350
  578812
  579732
  582841
  587253
  587901
  590891
  590910
  593849
  596351
  596423
  596466
  597186
  610686
  617437
  620636
  627727
  629357
  643411
  648526
  653568
  676112
  815268
  820871
]

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 (393481, 395576, 404773, 406954, 410051, 411320, 417631, 419113, 421254, 424505, 424695, 427327, 430697, 430836, 431022, 431376, 431765, 432077, 433998, 434723, 435642, 441013, 442829, 443299, 445249, 450988, 458789, 461906, 471722, 480991, 486594, 487424, 494983, 504922, 506908, 512203, 512322, 513189, 515135, 521375, 522605, 524635, 525849, 556045, 560219, 561137, 565195, 567153, 567166, 574884, 575162, 575193, 575233, 576109, 576350, 578812, 579732, 582841, 587253, 587901, 590891, 590910, 593849, 596351, 596423, 596466, 597186, 610686, 617437, 620636, 627727, 629357, 643411, 648526, 653568, 676112, 815268, 820871);

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
  393481
  395576
  404773
  406954
  410051
  411320
  417631
  419113
  421254
  424505
  424695
  427327
  430697
  430836
  431022
  431376
  431765
  432077
  433998
  434723
  435642
  441013
  442829
  443299
  445249
  450988
  458789
  461906
  471722
  480991
  486594
  487424
  494983
  504922
  506908
  512203
  512322
  513189
  515135
  521375
  522605
  524635
  525849
  556045
  560219
  561137
  565195
  567153
  567166
  574884
  575162
  575193
  575233
  576109
  576350
  578812
  579732
  582841
  587253
  587901
  590891
  590910
  593849
  596351
  596423
  596466
  597186
  610686
  617437
  620636
  627727
  629357
  643411
  648526
  653568
  676112
  815268
  820871
]

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 (393481, 395576, 404773, 406954, 410051, 411320, 417631, 419113, 421254, 424505, 424695, 427327, 430697, 430836, 431022, 431376, 431765, 432077, 433998, 434723, 435642, 441013, 442829, 443299, 445249, 450988, 458789, 461906, 471722, 480991, 486594, 487424, 494983, 504922, 506908, 512203, 512322, 513189, 515135, 521375, 522605, 524635, 525849, 556045, 560219, 561137, 565195, 567153, 567166, 574884, 575162, 575193, 575233, 576109, 576350, 578812, 579732, 582841, 587253, 587901, 590891, 590910, 593849, 596351, 596423, 596466, 597186, 610686, 617437, 620636, 627727, 629357, 643411, 648526, 653568, 676112, 815268, 820871);

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

[
  "teens share cock"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teens share cock';

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

[
  "teens share cock"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teens share cock';