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

[
  "sister cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sister cum' 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
  476013
  508140
  516427
  526092
  527965
  495088
  507685
  511496
  524789
  498238
  503216
  519510
  525145
  505794
  433792
  445883
  459656
  451380
  453732
  529217
  522642
  528838
  524099
  560868
  545633
  552367
  584382
  588200
  603660
  590076
  587397
  619849
  457319
  442967
  462844
  426148
  433140
  434670
  449208
  455153
  455875
  518231
  528914
  504906
  521241
  526813
  529171
  483039
  504772
  514357
  518820
  446054
  494815
  502453
  567716
  584752
  586734
  632055
  520201
  526805
  608245
  433888
  492455
  526814
  519528
  461375
  520310
  497935
  608737
  628277
  601886
  618743
  621735
  457676
]

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 (476013, 508140, 516427, 526092, 527965, 495088, 507685, 511496, 524789, 498238, 503216, 519510, 525145, 505794, 433792, 445883, 459656, 451380, 453732, 529217, 522642, 528838, 524099, 560868, 545633, 552367, 584382, 588200, 603660, 590076, 587397, 619849, 457319, 442967, 462844, 426148, 433140, 434670, 449208, 455153, 455875, 518231, 528914, 504906, 521241, 526813, 529171, 483039, 504772, 514357, 518820, 446054, 494815, 502453, 567716, 584752, 586734, 632055, 520201, 526805, 608245, 433888, 492455, 526814, 519528, 461375, 520310, 497935, 608737, 628277, 601886, 618743, 621735, 457676);

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
  426148
  433140
  433792
  433888
  434670
  442967
  445883
  446054
  449208
  451380
  453732
  455153
  455875
  457319
  457676
  459656
  461375
  462844
  476013
  483039
  492455
  494815
  495088
  497935
  498238
  502453
  503216
  504772
  504906
  507685
  508140
  511496
  514357
  516427
  518231
  518820
  519510
  519528
  520201
  520310
  521241
  522642
  524099
  524789
  525145
  526092
  526805
  526813
  526814
  527965
  528838
  528914
  529171
  529217
  545633
  552367
  560868
  567716
  584382
  584752
  586734
  587397
  588200
  590076
  601886
  603660
  608245
  608737
  618743
  619849
  621735
  628277
  632055
]

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 (426148, 433140, 433792, 433888, 434670, 442967, 445883, 446054, 449208, 451380, 453732, 455153, 455875, 457319, 457676, 459656, 461375, 462844, 476013, 483039, 492455, 494815, 495088, 497935, 498238, 502453, 503216, 504772, 504906, 507685, 508140, 511496, 514357, 516427, 518231, 518820, 519510, 519528, 520201, 520310, 521241, 522642, 524099, 524789, 525145, 526092, 526805, 526813, 526814, 527965, 528838, 528914, 529171, 529217, 545633, 552367, 560868, 567716, 584382, 584752, 586734, 587397, 588200, 590076, 601886, 603660, 608245, 608737, 618743, 619849, 621735, 628277, 632055);

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
  426148
  433140
  433792
  433888
  434670
  442967
  445883
  446054
  449208
  451380
  453732
  455153
  455875
  457319
  457676
  459656
  461375
  462844
  476013
  483039
  492455
  494815
  495088
  497935
  498238
  502453
  503216
  504772
  504906
  507685
  508140
  511496
  514357
  516427
  518231
  518820
  519510
  519528
  520201
  520310
  521241
  522642
  524099
  524789
  525145
  526092
  526805
  526813
  526814
  527965
  528838
  528914
  529171
  529217
  545633
  552367
  560868
  567716
  584382
  584752
  586734
  587397
  588200
  590076
  601886
  603660
  608245
  608737
  618743
  619849
  621735
  628277
  632055
]

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 (426148, 433140, 433792, 433888, 434670, 442967, 445883, 446054, 449208, 451380, 453732, 455153, 455875, 457319, 457676, 459656, 461375, 462844, 476013, 483039, 492455, 494815, 495088, 497935, 498238, 502453, 503216, 504772, 504906, 507685, 508140, 511496, 514357, 516427, 518231, 518820, 519510, 519528, 520201, 520310, 521241, 522642, 524099, 524789, 525145, 526092, 526805, 526813, 526814, 527965, 528838, 528914, 529171, 529217, 545633, 552367, 560868, 567716, 584382, 584752, 586734, 587397, 588200, 590076, 601886, 603660, 608245, 608737, 618743, 619849, 621735, 628277, 632055);

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

[
  "sister cum"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'sister cum';

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

[
  "sister cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sister cum';