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

[
  "solo vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'solo vintage' 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
  654092
  672755
  673560
  710847
  592516
  587451
  603489
  611030
  607149
  630293
  475661
  539503
  566622
  566907
  566668
  544322
  661899
  651686
  679445
  551836
  568259
  568261
  628115
  600325
  590914
  593310
  631255
  634692
  389739
  538952
  580852
  568262
  651684
  672754
  653192
  714609
  566649
  568266
  598373
  589700
  602180
  538905
  538843
  568298
  564756
  545345
  566624
  568258
  568590
  583914
  682822
  666856
  681232
  681908
  577373
  602461
  772574
  751017
  772554
  566675
  567726
  557511
  574257
  584315
  661903
  672742
  646336
  683297
  546153
  634071
  589817
  601695
  630288
  511388
  566625
  568519
  581306
  580921
  697459
  603310
  558172
  648466
  583387
]

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 (654092, 672755, 673560, 710847, 592516, 587451, 603489, 611030, 607149, 630293, 475661, 539503, 566622, 566907, 566668, 544322, 661899, 651686, 679445, 551836, 568259, 568261, 628115, 600325, 590914, 593310, 631255, 634692, 389739, 538952, 580852, 568262, 651684, 672754, 653192, 714609, 566649, 568266, 598373, 589700, 602180, 538905, 538843, 568298, 564756, 545345, 566624, 568258, 568590, 583914, 682822, 666856, 681232, 681908, 577373, 602461, 772574, 751017, 772554, 566675, 567726, 557511, 574257, 584315, 661903, 672742, 646336, 683297, 546153, 634071, 589817, 601695, 630288, 511388, 566625, 568519, 581306, 580921, 697459, 603310, 558172, 648466, 583387);

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
  389739
  475661
  511388
  538843
  538905
  538952
  539503
  544322
  545345
  546153
  551836
  557511
  558172
  564756
  566622
  566624
  566625
  566649
  566668
  566675
  566907
  567726
  568258
  568259
  568261
  568262
  568266
  568298
  568519
  568590
  574257
  577373
  580852
  580921
  581306
  583387
  583914
  584315
  587451
  589700
  589817
  590914
  592516
  593310
  598373
  600325
  601695
  602180
  602461
  603310
  603489
  607149
  611030
  628115
  630288
  630293
  631255
  634071
  634692
  646336
  648466
  651684
  651686
  653192
  654092
  661899
  661903
  666856
  672742
  672754
  672755
  673560
  679445
  681232
  681908
  682822
  683297
  697459
  710847
  714609
  751017
  772554
  772574
]

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 (389739, 475661, 511388, 538843, 538905, 538952, 539503, 544322, 545345, 546153, 551836, 557511, 558172, 564756, 566622, 566624, 566625, 566649, 566668, 566675, 566907, 567726, 568258, 568259, 568261, 568262, 568266, 568298, 568519, 568590, 574257, 577373, 580852, 580921, 581306, 583387, 583914, 584315, 587451, 589700, 589817, 590914, 592516, 593310, 598373, 600325, 601695, 602180, 602461, 603310, 603489, 607149, 611030, 628115, 630288, 630293, 631255, 634071, 634692, 646336, 648466, 651684, 651686, 653192, 654092, 661899, 661903, 666856, 672742, 672754, 672755, 673560, 679445, 681232, 681908, 682822, 683297, 697459, 710847, 714609, 751017, 772554, 772574);

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
  389739
  475661
  511388
  538843
  538905
  538952
  539503
  544322
  545345
  546153
  551836
  557511
  558172
  564756
  566622
  566624
  566625
  566649
  566668
  566675
  566907
  567726
  568258
  568259
  568261
  568262
  568266
  568298
  568519
  568590
  574257
  577373
  580852
  580921
  581306
  583387
  583914
  584315
  587451
  589700
  589817
  590914
  592516
  593310
  598373
  600325
  601695
  602180
  602461
  603310
  603489
  607149
  611030
  628115
  630288
  630293
  631255
  634071
  634692
  646336
  648466
  651684
  651686
  653192
  654092
  661899
  661903
  666856
  672742
  672754
  672755
  673560
  679445
  681232
  681908
  682822
  683297
  697459
  710847
  714609
  751017
  772554
  772574
]

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 (389739, 475661, 511388, 538843, 538905, 538952, 539503, 544322, 545345, 546153, 551836, 557511, 558172, 564756, 566622, 566624, 566625, 566649, 566668, 566675, 566907, 567726, 568258, 568259, 568261, 568262, 568266, 568298, 568519, 568590, 574257, 577373, 580852, 580921, 581306, 583387, 583914, 584315, 587451, 589700, 589817, 590914, 592516, 593310, 598373, 600325, 601695, 602180, 602461, 603310, 603489, 607149, 611030, 628115, 630288, 630293, 631255, 634071, 634692, 646336, 648466, 651684, 651686, 653192, 654092, 661899, 661903, 666856, 672742, 672754, 672755, 673560, 679445, 681232, 681908, 682822, 683297, 697459, 710847, 714609, 751017, 772554, 772574);

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

[
  "соло vintage"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'соло vintage';

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

[
  "соло vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'соло vintage';