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

[
  "first teen creampie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'first teen creampie' 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
  781052
  594289
  819397
  743083
  757038
  793663
  705225
  715907
  777143
  639959
  637690
  552689
  682918
  669279
  785553
  796196
  796916
  756849
  740089
  397295
  816607
  564184
  761764
  767269
  764274
  490536
  712366
  722583
  608818
  575157
  586664
  592544
  444912
  399062
  421637
  480037
  633286
  806614
  770303
  522451
  584222
  791844
  733246
  743068
  619375
  447543
  616025
  426346
  571126
  579210
  806325
  479756
  412442
  456263
  505881
  814460
  465790
  499902
  579670
  576114
  648924
  771918
  423620
  443555
  452768
  435022
  511400
  597282
  545649
  666877
  642060
  473529
  666539
  402232
  478184
  525043
  531163
  666546
  634118
  463815
  633792
  537648
  520632
  539203
]

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 (781052, 594289, 819397, 743083, 757038, 793663, 705225, 715907, 777143, 639959, 637690, 552689, 682918, 669279, 785553, 796196, 796916, 756849, 740089, 397295, 816607, 564184, 761764, 767269, 764274, 490536, 712366, 722583, 608818, 575157, 586664, 592544, 444912, 399062, 421637, 480037, 633286, 806614, 770303, 522451, 584222, 791844, 733246, 743068, 619375, 447543, 616025, 426346, 571126, 579210, 806325, 479756, 412442, 456263, 505881, 814460, 465790, 499902, 579670, 576114, 648924, 771918, 423620, 443555, 452768, 435022, 511400, 597282, 545649, 666877, 642060, 473529, 666539, 402232, 478184, 525043, 531163, 666546, 634118, 463815, 633792, 537648, 520632, 539203);

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
  397295
  399062
  402232
  412442
  421637
  423620
  426346
  435022
  443555
  444912
  447543
  452768
  456263
  463815
  465790
  473529
  478184
  479756
  480037
  490536
  499902
  505881
  511400
  520632
  522451
  525043
  531163
  537648
  539203
  545649
  552689
  564184
  571126
  575157
  576114
  579210
  579670
  584222
  586664
  592544
  594289
  597282
  608818
  616025
  619375
  633286
  633792
  634118
  637690
  639959
  642060
  648924
  666539
  666546
  666877
  669279
  682918
  705225
  712366
  715907
  722583
  733246
  740089
  743068
  743083
  756849
  757038
  761764
  764274
  767269
  770303
  771918
  777143
  781052
  785553
  791844
  793663
  796196
  796916
  806325
  806614
  814460
  816607
  819397
]

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 (397295, 399062, 402232, 412442, 421637, 423620, 426346, 435022, 443555, 444912, 447543, 452768, 456263, 463815, 465790, 473529, 478184, 479756, 480037, 490536, 499902, 505881, 511400, 520632, 522451, 525043, 531163, 537648, 539203, 545649, 552689, 564184, 571126, 575157, 576114, 579210, 579670, 584222, 586664, 592544, 594289, 597282, 608818, 616025, 619375, 633286, 633792, 634118, 637690, 639959, 642060, 648924, 666539, 666546, 666877, 669279, 682918, 705225, 712366, 715907, 722583, 733246, 740089, 743068, 743083, 756849, 757038, 761764, 764274, 767269, 770303, 771918, 777143, 781052, 785553, 791844, 793663, 796196, 796916, 806325, 806614, 814460, 816607, 819397);

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
  397295
  399062
  402232
  412442
  421637
  423620
  426346
  435022
  443555
  444912
  447543
  452768
  456263
  463815
  465790
  473529
  478184
  479756
  480037
  490536
  499902
  505881
  511400
  520632
  522451
  525043
  531163
  537648
  539203
  545649
  552689
  564184
  571126
  575157
  576114
  579210
  579670
  584222
  586664
  592544
  594289
  597282
  608818
  616025
  619375
  633286
  633792
  634118
  637690
  639959
  642060
  648924
  666539
  666546
  666877
  669279
  682918
  705225
  712366
  715907
  722583
  733246
  740089
  743068
  743083
  756849
  757038
  761764
  764274
  767269
  770303
  771918
  777143
  781052
  785553
  791844
  793663
  796196
  796916
  806325
  806614
  814460
  816607
  819397
]

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 (397295, 399062, 402232, 412442, 421637, 423620, 426346, 435022, 443555, 444912, 447543, 452768, 456263, 463815, 465790, 473529, 478184, 479756, 480037, 490536, 499902, 505881, 511400, 520632, 522451, 525043, 531163, 537648, 539203, 545649, 552689, 564184, 571126, 575157, 576114, 579210, 579670, 584222, 586664, 592544, 594289, 597282, 608818, 616025, 619375, 633286, 633792, 634118, 637690, 639959, 642060, 648924, 666539, 666546, 666877, 669279, 682918, 705225, 712366, 715907, 722583, 733246, 740089, 743068, 743083, 756849, 757038, 761764, 764274, 767269, 770303, 771918, 777143, 781052, 785553, 791844, 793663, 796196, 796916, 806325, 806614, 814460, 816607, 819397);

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

[
  "first teen creampie"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'first teen creampie';

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

[
  "first teen creampie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'first teen creampie';