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

[
  "guys ass"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'guys ass' 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
  458905
  456393
  500467
  514576
  521586
  532343
  649970
  651599
  668534
  633819
  603635
  634778
  460734
  465378
  466107
  447803
  485712
  506211
  511595
  484722
  490762
  484653
  517654
  583981
  634193
  632693
  604569
  460738
  556046
  341675
  494620
  550130
  560665
  541942
  681310
  554743
  565096
  590579
  641667
  809520
  498497
  508445
  675001
  477707
  521239
  480749
  559577
  676088
  632283
  633126
  466321
  500857
  484750
  562068
  646176
  607150
  532756
  570074
  598486
  606494
  460706
  437811
  518206
  487713
  523212
  499104
  505132
  464326
  492111
  516938
  555805
  590893
  531105
  514717
  524696
  634140
  637148
  554518
  620098
  508518
  518586
  613169
  569682
]

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 (458905, 456393, 500467, 514576, 521586, 532343, 649970, 651599, 668534, 633819, 603635, 634778, 460734, 465378, 466107, 447803, 485712, 506211, 511595, 484722, 490762, 484653, 517654, 583981, 634193, 632693, 604569, 460738, 556046, 341675, 494620, 550130, 560665, 541942, 681310, 554743, 565096, 590579, 641667, 809520, 498497, 508445, 675001, 477707, 521239, 480749, 559577, 676088, 632283, 633126, 466321, 500857, 484750, 562068, 646176, 607150, 532756, 570074, 598486, 606494, 460706, 437811, 518206, 487713, 523212, 499104, 505132, 464326, 492111, 516938, 555805, 590893, 531105, 514717, 524696, 634140, 637148, 554518, 620098, 508518, 518586, 613169, 569682);

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
  341675
  437811
  447803
  456393
  458905
  460706
  460734
  460738
  464326
  465378
  466107
  466321
  477707
  480749
  484653
  484722
  484750
  485712
  487713
  490762
  492111
  494620
  498497
  499104
  500467
  500857
  505132
  506211
  508445
  508518
  511595
  514576
  514717
  516938
  517654
  518206
  518586
  521239
  521586
  523212
  524696
  531105
  532343
  532756
  541942
  550130
  554518
  554743
  555805
  556046
  559577
  560665
  562068
  565096
  569682
  570074
  583981
  590579
  590893
  598486
  603635
  604569
  606494
  607150
  613169
  620098
  632283
  632693
  633126
  633819
  634140
  634193
  634778
  637148
  641667
  646176
  649970
  651599
  668534
  675001
  676088
  681310
  809520
]

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 (341675, 437811, 447803, 456393, 458905, 460706, 460734, 460738, 464326, 465378, 466107, 466321, 477707, 480749, 484653, 484722, 484750, 485712, 487713, 490762, 492111, 494620, 498497, 499104, 500467, 500857, 505132, 506211, 508445, 508518, 511595, 514576, 514717, 516938, 517654, 518206, 518586, 521239, 521586, 523212, 524696, 531105, 532343, 532756, 541942, 550130, 554518, 554743, 555805, 556046, 559577, 560665, 562068, 565096, 569682, 570074, 583981, 590579, 590893, 598486, 603635, 604569, 606494, 607150, 613169, 620098, 632283, 632693, 633126, 633819, 634140, 634193, 634778, 637148, 641667, 646176, 649970, 651599, 668534, 675001, 676088, 681310, 809520);

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
  341675
  437811
  447803
  456393
  458905
  460706
  460734
  460738
  464326
  465378
  466107
  466321
  477707
  480749
  484653
  484722
  484750
  485712
  487713
  490762
  492111
  494620
  498497
  499104
  500467
  500857
  505132
  506211
  508445
  508518
  511595
  514576
  514717
  516938
  517654
  518206
  518586
  521239
  521586
  523212
  524696
  531105
  532343
  532756
  541942
  550130
  554518
  554743
  555805
  556046
  559577
  560665
  562068
  565096
  569682
  570074
  583981
  590579
  590893
  598486
  603635
  604569
  606494
  607150
  613169
  620098
  632283
  632693
  633126
  633819
  634140
  634193
  634778
  637148
  641667
  646176
  649970
  651599
  668534
  675001
  676088
  681310
  809520
]

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 (341675, 437811, 447803, 456393, 458905, 460706, 460734, 460738, 464326, 465378, 466107, 466321, 477707, 480749, 484653, 484722, 484750, 485712, 487713, 490762, 492111, 494620, 498497, 499104, 500467, 500857, 505132, 506211, 508445, 508518, 511595, 514576, 514717, 516938, 517654, 518206, 518586, 521239, 521586, 523212, 524696, 531105, 532343, 532756, 541942, 550130, 554518, 554743, 555805, 556046, 559577, 560665, 562068, 565096, 569682, 570074, 583981, 590579, 590893, 598486, 603635, 604569, 606494, 607150, 613169, 620098, 632283, 632693, 633126, 633819, 634140, 634193, 634778, 637148, 641667, 646176, 649970, 651599, 668534, 675001, 676088, 681310, 809520);

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

[
  "guys жоп"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'guys жоп';

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

[
  "guys жоп"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'guys жоп';