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

[
  "spread"
]

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

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

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

[
  b"\x01’ÏÃc×sùŽå0/\x18\x11U\x05"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0192CFC363D773F98EE5302F18115505 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
  527176
  826267
  446761
  469238
  475684
  475662
  498726
  526077
  543400
  584379
  580242
  684845
  695199
  684830
  550367
  597160
  615910
  586527
  603058
  620701
  800718
  805243
  725135
  751428
  761692
  801087
  758164
  725527
  433921
  390286
  444839
  428855
  501509
  486610
  526516
  516893
  585142
  449107
  510938
  504593
  519747
  475752
  557244
  543774
  549864
  556341
  545645
  562905
  664556
  692743
  552757
  572006
  603482
  613800
  812043
  760610
  538022
  519746
  487427
  542724
  547827
  572712
  584366
  669269
  680706
  611032
  523824
  518623
  538009
  567685
  573746
  561526
  563544
  588022
  457465
  455479
  421915
  439725
  516809
  509440
  528345
  565691
  602092
  439657
  439676
  558056
]

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 (527176, 826267, 446761, 469238, 475684, 475662, 498726, 526077, 543400, 584379, 580242, 684845, 695199, 684830, 550367, 597160, 615910, 586527, 603058, 620701, 800718, 805243, 725135, 751428, 761692, 801087, 758164, 725527, 433921, 390286, 444839, 428855, 501509, 486610, 526516, 516893, 585142, 449107, 510938, 504593, 519747, 475752, 557244, 543774, 549864, 556341, 545645, 562905, 664556, 692743, 552757, 572006, 603482, 613800, 812043, 760610, 538022, 519746, 487427, 542724, 547827, 572712, 584366, 669269, 680706, 611032, 523824, 518623, 538009, 567685, 573746, 561526, 563544, 588022, 457465, 455479, 421915, 439725, 516809, 509440, 528345, 565691, 602092, 439657, 439676, 558056);

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
  390286
  421915
  428855
  433921
  439657
  439676
  439725
  444839
  446761
  449107
  455479
  457465
  469238
  475662
  475684
  475752
  486610
  487427
  498726
  501509
  504593
  509440
  510938
  516809
  516893
  518623
  519746
  519747
  523824
  526077
  526516
  527176
  528345
  538009
  538022
  542724
  543400
  543774
  545645
  547827
  549864
  550367
  552757
  556341
  557244
  558056
  561526
  562905
  563544
  565691
  567685
  572006
  572712
  573746
  580242
  584366
  584379
  585142
  586527
  588022
  597160
  602092
  603058
  603482
  611032
  613800
  615910
  620701
  664556
  669269
  680706
  684830
  684845
  692743
  695199
  725135
  725527
  751428
  758164
  760610
  761692
  800718
  801087
  805243
  812043
  826267
]

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 (390286, 421915, 428855, 433921, 439657, 439676, 439725, 444839, 446761, 449107, 455479, 457465, 469238, 475662, 475684, 475752, 486610, 487427, 498726, 501509, 504593, 509440, 510938, 516809, 516893, 518623, 519746, 519747, 523824, 526077, 526516, 527176, 528345, 538009, 538022, 542724, 543400, 543774, 545645, 547827, 549864, 550367, 552757, 556341, 557244, 558056, 561526, 562905, 563544, 565691, 567685, 572006, 572712, 573746, 580242, 584366, 584379, 585142, 586527, 588022, 597160, 602092, 603058, 603482, 611032, 613800, 615910, 620701, 664556, 669269, 680706, 684830, 684845, 692743, 695199, 725135, 725527, 751428, 758164, 760610, 761692, 800718, 801087, 805243, 812043, 826267);

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
  390286
  421915
  428855
  433921
  439657
  439676
  439725
  444839
  446761
  449107
  455479
  457465
  469238
  475662
  475684
  475752
  486610
  487427
  498726
  501509
  504593
  509440
  510938
  516809
  516893
  518623
  519746
  519747
  523824
  526077
  526516
  527176
  528345
  538009
  538022
  542724
  543400
  543774
  545645
  547827
  549864
  550367
  552757
  556341
  557244
  558056
  561526
  562905
  563544
  565691
  567685
  572006
  572712
  573746
  580242
  584366
  584379
  585142
  586527
  588022
  597160
  602092
  603058
  603482
  611032
  613800
  615910
  620701
  664556
  669269
  680706
  684830
  684845
  692743
  695199
  725135
  725527
  751428
  758164
  760610
  761692
  800718
  801087
  805243
  812043
  826267
]

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 (390286, 421915, 428855, 433921, 439657, 439676, 439725, 444839, 446761, 449107, 455479, 457465, 469238, 475662, 475684, 475752, 486610, 487427, 498726, 501509, 504593, 509440, 510938, 516809, 516893, 518623, 519746, 519747, 523824, 526077, 526516, 527176, 528345, 538009, 538022, 542724, 543400, 543774, 545645, 547827, 549864, 550367, 552757, 556341, 557244, 558056, 561526, 562905, 563544, 565691, 567685, 572006, 572712, 573746, 580242, 584366, 584379, 585142, 586527, 588022, 597160, 602092, 603058, 603482, 611032, 613800, 615910, 620701, 664556, 669269, 680706, 684830, 684845, 692743, 695199, 725135, 725527, 751428, 758164, 760610, 761692, 800718, 801087, 805243, 812043, 826267);

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

[
  "spread"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'spread';

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

[
  "spread"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'spread';