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

[
  "cum on lips"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cum on lips' 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
  398588
  771753
  555052
  579145
  494816
  481753
  484228
  536819
  552795
  782918
  521666
  451879
  715235
  801943
  790777
  700718
  419235
  574018
  772357
  705536
  720137
  819281
  772273
  700230
  790732
  730175
  743940
  392325
  825305
  796765
  814641
  653099
  637286
  742066
  747002
  760273
  702280
  666468
  606034
  799889
  741266
  762024
  768555
  763087
  773806
  719861
  780802
  795599
  704079
  708135
  790706
  734465
  540588
  517532
  682328
  802335
  781403
  792428
  443848
  512763
  521700
  465735
  709786
  607907
  734687
  498723
  508868
  483246
  497934
  452326
  622777
  628515
  520411
  529276
  516363
  529565
  511919
  586358
  498459
  588022
  477772
  486864
]

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 (398588, 771753, 555052, 579145, 494816, 481753, 484228, 536819, 552795, 782918, 521666, 451879, 715235, 801943, 790777, 700718, 419235, 574018, 772357, 705536, 720137, 819281, 772273, 700230, 790732, 730175, 743940, 392325, 825305, 796765, 814641, 653099, 637286, 742066, 747002, 760273, 702280, 666468, 606034, 799889, 741266, 762024, 768555, 763087, 773806, 719861, 780802, 795599, 704079, 708135, 790706, 734465, 540588, 517532, 682328, 802335, 781403, 792428, 443848, 512763, 521700, 465735, 709786, 607907, 734687, 498723, 508868, 483246, 497934, 452326, 622777, 628515, 520411, 529276, 516363, 529565, 511919, 586358, 498459, 588022, 477772, 486864);

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
  392325
  398588
  419235
  443848
  451879
  452326
  465735
  477772
  481753
  483246
  484228
  486864
  494816
  497934
  498459
  498723
  508868
  511919
  512763
  516363
  517532
  520411
  521666
  521700
  529276
  529565
  536819
  540588
  552795
  555052
  574018
  579145
  586358
  588022
  606034
  607907
  622777
  628515
  637286
  653099
  666468
  682328
  700230
  700718
  702280
  704079
  705536
  708135
  709786
  715235
  719861
  720137
  730175
  734465
  734687
  741266
  742066
  743940
  747002
  760273
  762024
  763087
  768555
  771753
  772273
  772357
  773806
  780802
  781403
  782918
  790706
  790732
  790777
  792428
  795599
  796765
  799889
  801943
  802335
  814641
  819281
  825305
]

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 (392325, 398588, 419235, 443848, 451879, 452326, 465735, 477772, 481753, 483246, 484228, 486864, 494816, 497934, 498459, 498723, 508868, 511919, 512763, 516363, 517532, 520411, 521666, 521700, 529276, 529565, 536819, 540588, 552795, 555052, 574018, 579145, 586358, 588022, 606034, 607907, 622777, 628515, 637286, 653099, 666468, 682328, 700230, 700718, 702280, 704079, 705536, 708135, 709786, 715235, 719861, 720137, 730175, 734465, 734687, 741266, 742066, 743940, 747002, 760273, 762024, 763087, 768555, 771753, 772273, 772357, 773806, 780802, 781403, 782918, 790706, 790732, 790777, 792428, 795599, 796765, 799889, 801943, 802335, 814641, 819281, 825305);

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
  392325
  398588
  419235
  443848
  451879
  452326
  465735
  477772
  481753
  483246
  484228
  486864
  494816
  497934
  498459
  498723
  508868
  511919
  512763
  516363
  517532
  520411
  521666
  521700
  529276
  529565
  536819
  540588
  552795
  555052
  574018
  579145
  586358
  588022
  606034
  607907
  622777
  628515
  637286
  653099
  666468
  682328
  700230
  700718
  702280
  704079
  705536
  708135
  709786
  715235
  719861
  720137
  730175
  734465
  734687
  741266
  742066
  743940
  747002
  760273
  762024
  763087
  768555
  771753
  772273
  772357
  773806
  780802
  781403
  782918
  790706
  790732
  790777
  792428
  795599
  796765
  799889
  801943
  802335
  814641
  819281
  825305
]

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 (392325, 398588, 419235, 443848, 451879, 452326, 465735, 477772, 481753, 483246, 484228, 486864, 494816, 497934, 498459, 498723, 508868, 511919, 512763, 516363, 517532, 520411, 521666, 521700, 529276, 529565, 536819, 540588, 552795, 555052, 574018, 579145, 586358, 588022, 606034, 607907, 622777, 628515, 637286, 653099, 666468, 682328, 700230, 700718, 702280, 704079, 705536, 708135, 709786, 715235, 719861, 720137, 730175, 734465, 734687, 741266, 742066, 743940, 747002, 760273, 762024, 763087, 768555, 771753, 772273, 772357, 773806, 780802, 781403, 782918, 790706, 790732, 790777, 792428, 795599, 796765, 799889, 801943, 802335, 814641, 819281, 825305);

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

[
  "cum lips"
]

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

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

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

[
  "cum lips"
]

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

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