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

[
  "skinny retro"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'skinny retro' 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
  622331
  603247
  541623
  559127
  542194
  551225
  571028
  577368
  541889
  544627
  549371
  559120
  563093
  566252
  580256
  607707
  541699
  659262
  726457
  541830
  541831
  577356
  583856
  541661
  541874
  541877
  542956
  544529
  571213
  582179
  592521
  600837
  600069
  622831
  570859
  741434
  541587
  541647
  544296
  566248
  541640
  541673
  541683
  541833
  542196
  542961
  558003
  541642
  541664
  541667
  541774
  542188
  544478
  554205
  622839
  636268
  659270
  541643
  542191
  576717
  541639
  541721
  542189
  542195
  566702
  577378
  580969
  541924
  542192
  571198
  541650
  541770
  630982
  542199
  562825
  567416
  609196
  541804
  587791
  541611
  541646
]

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 (622331, 603247, 541623, 559127, 542194, 551225, 571028, 577368, 541889, 544627, 549371, 559120, 563093, 566252, 580256, 607707, 541699, 659262, 726457, 541830, 541831, 577356, 583856, 541661, 541874, 541877, 542956, 544529, 571213, 582179, 592521, 600837, 600069, 622831, 570859, 741434, 541587, 541647, 544296, 566248, 541640, 541673, 541683, 541833, 542196, 542961, 558003, 541642, 541664, 541667, 541774, 542188, 544478, 554205, 622839, 636268, 659270, 541643, 542191, 576717, 541639, 541721, 542189, 542195, 566702, 577378, 580969, 541924, 542192, 571198, 541650, 541770, 630982, 542199, 562825, 567416, 609196, 541804, 587791, 541611, 541646);

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
  541587
  541611
  541623
  541639
  541640
  541642
  541643
  541646
  541647
  541650
  541661
  541664
  541667
  541673
  541683
  541699
  541721
  541770
  541774
  541804
  541830
  541831
  541833
  541874
  541877
  541889
  541924
  542188
  542189
  542191
  542192
  542194
  542195
  542196
  542199
  542956
  542961
  544296
  544478
  544529
  544627
  549371
  551225
  554205
  558003
  559120
  559127
  562825
  563093
  566248
  566252
  566702
  567416
  570859
  571028
  571198
  571213
  576717
  577356
  577368
  577378
  580256
  580969
  582179
  583856
  587791
  592521
  600069
  600837
  603247
  607707
  609196
  622331
  622831
  622839
  630982
  636268
  659262
  659270
  726457
  741434
]

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 (541587, 541611, 541623, 541639, 541640, 541642, 541643, 541646, 541647, 541650, 541661, 541664, 541667, 541673, 541683, 541699, 541721, 541770, 541774, 541804, 541830, 541831, 541833, 541874, 541877, 541889, 541924, 542188, 542189, 542191, 542192, 542194, 542195, 542196, 542199, 542956, 542961, 544296, 544478, 544529, 544627, 549371, 551225, 554205, 558003, 559120, 559127, 562825, 563093, 566248, 566252, 566702, 567416, 570859, 571028, 571198, 571213, 576717, 577356, 577368, 577378, 580256, 580969, 582179, 583856, 587791, 592521, 600069, 600837, 603247, 607707, 609196, 622331, 622831, 622839, 630982, 636268, 659262, 659270, 726457, 741434);

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
  541587
  541611
  541623
  541639
  541640
  541642
  541643
  541646
  541647
  541650
  541661
  541664
  541667
  541673
  541683
  541699
  541721
  541770
  541774
  541804
  541830
  541831
  541833
  541874
  541877
  541889
  541924
  542188
  542189
  542191
  542192
  542194
  542195
  542196
  542199
  542956
  542961
  544296
  544478
  544529
  544627
  549371
  551225
  554205
  558003
  559120
  559127
  562825
  563093
  566248
  566252
  566702
  567416
  570859
  571028
  571198
  571213
  576717
  577356
  577368
  577378
  580256
  580969
  582179
  583856
  587791
  592521
  600069
  600837
  603247
  607707
  609196
  622331
  622831
  622839
  630982
  636268
  659262
  659270
  726457
  741434
]

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 (541587, 541611, 541623, 541639, 541640, 541642, 541643, 541646, 541647, 541650, 541661, 541664, 541667, 541673, 541683, 541699, 541721, 541770, 541774, 541804, 541830, 541831, 541833, 541874, 541877, 541889, 541924, 542188, 542189, 542191, 542192, 542194, 542195, 542196, 542199, 542956, 542961, 544296, 544478, 544529, 544627, 549371, 551225, 554205, 558003, 559120, 559127, 562825, 563093, 566248, 566252, 566702, 567416, 570859, 571028, 571198, 571213, 576717, 577356, 577368, 577378, 580256, 580969, 582179, 583856, 587791, 592521, 600069, 600837, 603247, 607707, 609196, 622331, 622831, 622839, 630982, 636268, 659262, 659270, 726457, 741434);

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

[
  "худые ретр"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'худые ретр';

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

[
  "худые ретр"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'худые ретр';