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

[
  "hairy vintage"
]

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

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

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

[
  b"\x01“\x039\x14©pC¨\x05€]b‰Xø"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193033914A97043A805805D628958F8 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
  560372
  716078
  556987
  554784
  554205
  541884
  562836
  573765
  576691
  576704
  541408
  550033
  566503
  577366
  577371
  541366
  541592
  541604
  541828
  546993
  566243
  573909
  576630
  578257
  566693
  622979
  628327
  620157
  603247
  619483
  541623
  541698
  577368
  563093
  541738
  566252
  689702
  662137
  576623
  576720
  583533
  727812
  541699
  541651
  577177
  541886
  541661
  541665
  541874
  541594
  513025
  559119
  571428
  541614
  541640
  541683
  541888
  542196
  543579
  541633
  541667
  543496
  574244
  576723
  574258
  576710
  617641
  562825
  541643
  541671
  541588
  525745
  538848
  541688
  554787
  559127
  541871
  609196
  541804
  541611
]

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 (560372, 716078, 556987, 554784, 554205, 541884, 562836, 573765, 576691, 576704, 541408, 550033, 566503, 577366, 577371, 541366, 541592, 541604, 541828, 546993, 566243, 573909, 576630, 578257, 566693, 622979, 628327, 620157, 603247, 619483, 541623, 541698, 577368, 563093, 541738, 566252, 689702, 662137, 576623, 576720, 583533, 727812, 541699, 541651, 577177, 541886, 541661, 541665, 541874, 541594, 513025, 559119, 571428, 541614, 541640, 541683, 541888, 542196, 543579, 541633, 541667, 543496, 574244, 576723, 574258, 576710, 617641, 562825, 541643, 541671, 541588, 525745, 538848, 541688, 554787, 559127, 541871, 609196, 541804, 541611);

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
  513025
  525745
  538848
  541366
  541408
  541588
  541592
  541594
  541604
  541611
  541614
  541623
  541633
  541640
  541643
  541651
  541661
  541665
  541667
  541671
  541683
  541688
  541698
  541699
  541738
  541804
  541828
  541871
  541874
  541884
  541886
  541888
  542196
  543496
  543579
  546993
  550033
  554205
  554784
  554787
  556987
  559119
  559127
  560372
  562825
  562836
  563093
  566243
  566252
  566503
  566693
  571428
  573765
  573909
  574244
  574258
  576623
  576630
  576691
  576704
  576710
  576720
  576723
  577177
  577366
  577368
  577371
  578257
  583533
  603247
  609196
  617641
  619483
  620157
  622979
  628327
  662137
  689702
  716078
  727812
]

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 (513025, 525745, 538848, 541366, 541408, 541588, 541592, 541594, 541604, 541611, 541614, 541623, 541633, 541640, 541643, 541651, 541661, 541665, 541667, 541671, 541683, 541688, 541698, 541699, 541738, 541804, 541828, 541871, 541874, 541884, 541886, 541888, 542196, 543496, 543579, 546993, 550033, 554205, 554784, 554787, 556987, 559119, 559127, 560372, 562825, 562836, 563093, 566243, 566252, 566503, 566693, 571428, 573765, 573909, 574244, 574258, 576623, 576630, 576691, 576704, 576710, 576720, 576723, 577177, 577366, 577368, 577371, 578257, 583533, 603247, 609196, 617641, 619483, 620157, 622979, 628327, 662137, 689702, 716078, 727812);

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
  513025
  525745
  538848
  541366
  541408
  541588
  541592
  541594
  541604
  541611
  541614
  541623
  541633
  541640
  541643
  541651
  541661
  541665
  541667
  541671
  541683
  541688
  541698
  541699
  541738
  541804
  541828
  541871
  541874
  541884
  541886
  541888
  542196
  543496
  543579
  546993
  550033
  554205
  554784
  554787
  556987
  559119
  559127
  560372
  562825
  562836
  563093
  566243
  566252
  566503
  566693
  571428
  573765
  573909
  574244
  574258
  576623
  576630
  576691
  576704
  576710
  576720
  576723
  577177
  577366
  577368
  577371
  578257
  583533
  603247
  609196
  617641
  619483
  620157
  622979
  628327
  662137
  689702
  716078
  727812
]

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 (513025, 525745, 538848, 541366, 541408, 541588, 541592, 541594, 541604, 541611, 541614, 541623, 541633, 541640, 541643, 541651, 541661, 541665, 541667, 541671, 541683, 541688, 541698, 541699, 541738, 541804, 541828, 541871, 541874, 541884, 541886, 541888, 542196, 543496, 543579, 546993, 550033, 554205, 554784, 554787, 556987, 559119, 559127, 560372, 562825, 562836, 563093, 566243, 566252, 566503, 566693, 571428, 573765, 573909, 574244, 574258, 576623, 576630, 576691, 576704, 576710, 576720, 576723, 577177, 577366, 577368, 577371, 578257, 583533, 603247, 609196, 617641, 619483, 620157, 622979, 628327, 662137, 689702, 716078, 727812);

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';