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

[
  "love boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'love boobs' LIMIT 1;

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

[
  b"\x01–râ}yrس\f¬\x10·Ôs°"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019672E27D7972D8B30CAC10B7D473B0 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
  678021
  546623
  573519
  616382
  634812
  615913
  597843
  797464
  726526
  748909
  766616
  423973
  400636
  428119
  465954
  478043
  401482
  411320
  512410
  528187
  488898
  508121
  527421
  558899
  418838
  815275
  447916
  482644
  516324
  519257
  513750
  528386
  487348
  542678
  545616
  681563
  596900
  726714
  726553
  440568
  475245
  440974
  452950
  500798
  489310
  490428
  509622
  511308
  515347
  458764
  480512
  517454
  517395
  529777
  543193
  556728
  681660
  591022
  602946
  606624
  615826
  639718
  639790
  470302
  440876
  440426
  442841
  490453
  524934
  480340
  557118
  554389
  474000
  514375
  597689
  639818
  506803
  572003
  560176
  625861
  556524
  570765
  647656
  588039
  489112
  565186
]

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 (678021, 546623, 573519, 616382, 634812, 615913, 597843, 797464, 726526, 748909, 766616, 423973, 400636, 428119, 465954, 478043, 401482, 411320, 512410, 528187, 488898, 508121, 527421, 558899, 418838, 815275, 447916, 482644, 516324, 519257, 513750, 528386, 487348, 542678, 545616, 681563, 596900, 726714, 726553, 440568, 475245, 440974, 452950, 500798, 489310, 490428, 509622, 511308, 515347, 458764, 480512, 517454, 517395, 529777, 543193, 556728, 681660, 591022, 602946, 606624, 615826, 639718, 639790, 470302, 440876, 440426, 442841, 490453, 524934, 480340, 557118, 554389, 474000, 514375, 597689, 639818, 506803, 572003, 560176, 625861, 556524, 570765, 647656, 588039, 489112, 565186);

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
  400636
  401482
  411320
  418838
  423973
  428119
  440426
  440568
  440876
  440974
  442841
  447916
  452950
  458764
  465954
  470302
  474000
  475245
  478043
  480340
  480512
  482644
  487348
  488898
  489112
  489310
  490428
  490453
  500798
  506803
  508121
  509622
  511308
  512410
  513750
  514375
  515347
  516324
  517395
  517454
  519257
  524934
  527421
  528187
  528386
  529777
  542678
  543193
  545616
  546623
  554389
  556524
  556728
  557118
  558899
  560176
  565186
  570765
  572003
  573519
  588039
  591022
  596900
  597689
  597843
  602946
  606624
  615826
  615913
  616382
  625861
  634812
  639718
  639790
  639818
  647656
  681563
  681660
  726526
  726553
  726714
  748909
  766616
  797464
  815275
]

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 (400636, 401482, 411320, 418838, 423973, 428119, 440426, 440568, 440876, 440974, 442841, 447916, 452950, 458764, 465954, 470302, 474000, 475245, 478043, 480340, 480512, 482644, 487348, 488898, 489112, 489310, 490428, 490453, 500798, 506803, 508121, 509622, 511308, 512410, 513750, 514375, 515347, 516324, 517395, 517454, 519257, 524934, 527421, 528187, 528386, 529777, 542678, 543193, 545616, 546623, 554389, 556524, 556728, 557118, 558899, 560176, 565186, 570765, 572003, 573519, 588039, 591022, 596900, 597689, 597843, 602946, 606624, 615826, 615913, 616382, 625861, 634812, 639718, 639790, 639818, 647656, 681563, 681660, 726526, 726553, 726714, 748909, 766616, 797464, 815275);

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
  400636
  401482
  411320
  418838
  423973
  428119
  440426
  440568
  440876
  440974
  442841
  447916
  452950
  458764
  465954
  470302
  474000
  475245
  478043
  480340
  480512
  482644
  487348
  488898
  489112
  489310
  490428
  490453
  500798
  506803
  508121
  509622
  511308
  512410
  513750
  514375
  515347
  516324
  517395
  517454
  519257
  524934
  527421
  528187
  528386
  529777
  542678
  543193
  545616
  546623
  554389
  556524
  556728
  557118
  558899
  560176
  565186
  570765
  572003
  573519
  588039
  591022
  596900
  597689
  597843
  602946
  606624
  615826
  615913
  616382
  625861
  634812
  639718
  639790
  639818
  647656
  681563
  681660
  726526
  726553
  726714
  748909
  766616
  797464
  815275
]

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 (400636, 401482, 411320, 418838, 423973, 428119, 440426, 440568, 440876, 440974, 442841, 447916, 452950, 458764, 465954, 470302, 474000, 475245, 478043, 480340, 480512, 482644, 487348, 488898, 489112, 489310, 490428, 490453, 500798, 506803, 508121, 509622, 511308, 512410, 513750, 514375, 515347, 516324, 517395, 517454, 519257, 524934, 527421, 528187, 528386, 529777, 542678, 543193, 545616, 546623, 554389, 556524, 556728, 557118, 558899, 560176, 565186, 570765, 572003, 573519, 588039, 591022, 596900, 597689, 597843, 602946, 606624, 615826, 615913, 616382, 625861, 634812, 639718, 639790, 639818, 647656, 681563, 681660, 726526, 726553, 726714, 748909, 766616, 797464, 815275);

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

[
  "love boobs"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'love boobs';

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

[
  "love boobs"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'love boobs';