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

[
  "full anal film"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'full anal film' 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
  542190
  541693
  541752
  542191
  541683
  716177
  750064
  541637
  541725
  541764
  542198
  541636
  541667
  541828
  716323
  541712
  541885
  541698
  541781
  541748
  541661
  541889
  541806
  541647
  542196
  541664
  541740
  541634
  541690
  699707
  541738
  583533
  541780
  541808
  541642
  541644
  541643
  541830
  541886
  541821
  542194
  541651
  541665
  541751
  541671
  541638
  541614
  541640
  541673
  541774
  541822
  541630
  542193
  541864
  542189
  794807
  541721
  541656
  542195
  542192
  801907
  541635
  541831
  541833
  522342
  715670
  541632
  712775
  521367
  452283
  574982
  541646
  591094
  446976
  542199
]

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 (542190, 541693, 541752, 542191, 541683, 716177, 750064, 541637, 541725, 541764, 542198, 541636, 541667, 541828, 716323, 541712, 541885, 541698, 541781, 541748, 541661, 541889, 541806, 541647, 542196, 541664, 541740, 541634, 541690, 699707, 541738, 583533, 541780, 541808, 541642, 541644, 541643, 541830, 541886, 541821, 542194, 541651, 541665, 541751, 541671, 541638, 541614, 541640, 541673, 541774, 541822, 541630, 542193, 541864, 542189, 794807, 541721, 541656, 542195, 542192, 801907, 541635, 541831, 541833, 522342, 715670, 541632, 712775, 521367, 452283, 574982, 541646, 591094, 446976, 542199);

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
  446976
  452283
  521367
  522342
  541614
  541630
  541632
  541634
  541635
  541636
  541637
  541638
  541640
  541642
  541643
  541644
  541646
  541647
  541651
  541656
  541661
  541664
  541665
  541667
  541671
  541673
  541683
  541690
  541693
  541698
  541712
  541721
  541725
  541738
  541740
  541748
  541751
  541752
  541764
  541774
  541780
  541781
  541806
  541808
  541821
  541822
  541828
  541830
  541831
  541833
  541864
  541885
  541886
  541889
  542189
  542190
  542191
  542192
  542193
  542194
  542195
  542196
  542198
  542199
  574982
  583533
  591094
  699707
  712775
  715670
  716177
  716323
  750064
  794807
  801907
]

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 (446976, 452283, 521367, 522342, 541614, 541630, 541632, 541634, 541635, 541636, 541637, 541638, 541640, 541642, 541643, 541644, 541646, 541647, 541651, 541656, 541661, 541664, 541665, 541667, 541671, 541673, 541683, 541690, 541693, 541698, 541712, 541721, 541725, 541738, 541740, 541748, 541751, 541752, 541764, 541774, 541780, 541781, 541806, 541808, 541821, 541822, 541828, 541830, 541831, 541833, 541864, 541885, 541886, 541889, 542189, 542190, 542191, 542192, 542193, 542194, 542195, 542196, 542198, 542199, 574982, 583533, 591094, 699707, 712775, 715670, 716177, 716323, 750064, 794807, 801907);

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
  446976
  452283
  521367
  522342
  541614
  541630
  541632
  541634
  541635
  541636
  541637
  541638
  541640
  541642
  541643
  541644
  541646
  541647
  541651
  541656
  541661
  541664
  541665
  541667
  541671
  541673
  541683
  541690
  541693
  541698
  541712
  541721
  541725
  541738
  541740
  541748
  541751
  541752
  541764
  541774
  541780
  541781
  541806
  541808
  541821
  541822
  541828
  541830
  541831
  541833
  541864
  541885
  541886
  541889
  542189
  542190
  542191
  542192
  542193
  542194
  542195
  542196
  542198
  542199
  574982
  583533
  591094
  699707
  712775
  715670
  716177
  716323
  750064
  794807
  801907
]

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 (446976, 452283, 521367, 522342, 541614, 541630, 541632, 541634, 541635, 541636, 541637, 541638, 541640, 541642, 541643, 541644, 541646, 541647, 541651, 541656, 541661, 541664, 541665, 541667, 541671, 541673, 541683, 541690, 541693, 541698, 541712, 541721, 541725, 541738, 541740, 541748, 541751, 541752, 541764, 541774, 541780, 541781, 541806, 541808, 541821, 541822, 541828, 541830, 541831, 541833, 541864, 541885, 541886, 541889, 542189, 542190, 542191, 542192, 542193, 542194, 542195, 542196, 542198, 542199, 574982, 583533, 591094, 699707, 712775, 715670, 716177, 716323, 750064, 794807, 801907);

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

[
  "full анал фильм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'full анал фильм';

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

[
  "full анал фильм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'full анал фильм';