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 pussy vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hairy pussy 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
  573764
  580863
  583885
  592478
  606778
  622976
  624793
  592437
  592440
  620130
  622953
  592403
  592456
  593441
  615735
  592530
  541606
  592521
  524986
  562836
  573765
  576691
  541408
  550033
  566503
  577366
  541366
  541828
  546993
  573909
  576630
  578257
  566693
  628327
  620157
  619483
  541623
  556987
  554784
  577177
  541698
  563093
  541738
  566252
  689702
  583533
  727812
  541699
  541651
  541886
  541661
  541665
  541874
  541594
  513025
  571428
  541614
  541640
  541683
  541888
  542196
  543579
  541633
  541667
  574258
  576710
  617641
  562825
  541643
  541671
  541588
  525745
  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 (573764, 580863, 583885, 592478, 606778, 622976, 624793, 592437, 592440, 620130, 622953, 592403, 592456, 593441, 615735, 592530, 541606, 592521, 524986, 562836, 573765, 576691, 541408, 550033, 566503, 577366, 541366, 541828, 546993, 573909, 576630, 578257, 566693, 628327, 620157, 619483, 541623, 556987, 554784, 577177, 541698, 563093, 541738, 566252, 689702, 583533, 727812, 541699, 541651, 541886, 541661, 541665, 541874, 541594, 513025, 571428, 541614, 541640, 541683, 541888, 542196, 543579, 541633, 541667, 574258, 576710, 617641, 562825, 541643, 541671, 541588, 525745, 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
  524986
  525745
  541366
  541408
  541588
  541594
  541606
  541611
  541614
  541623
  541633
  541640
  541643
  541651
  541661
  541665
  541667
  541671
  541683
  541688
  541698
  541699
  541738
  541804
  541828
  541871
  541874
  541886
  541888
  542196
  543579
  546993
  550033
  554784
  554787
  556987
  559127
  562825
  562836
  563093
  566252
  566503
  566693
  571428
  573764
  573765
  573909
  574258
  576630
  576691
  576710
  577177
  577366
  578257
  580863
  583533
  583885
  592403
  592437
  592440
  592456
  592478
  592521
  592530
  593441
  606778
  609196
  615735
  617641
  619483
  620130
  620157
  622953
  622976
  624793
  628327
  689702
  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, 524986, 525745, 541366, 541408, 541588, 541594, 541606, 541611, 541614, 541623, 541633, 541640, 541643, 541651, 541661, 541665, 541667, 541671, 541683, 541688, 541698, 541699, 541738, 541804, 541828, 541871, 541874, 541886, 541888, 542196, 543579, 546993, 550033, 554784, 554787, 556987, 559127, 562825, 562836, 563093, 566252, 566503, 566693, 571428, 573764, 573765, 573909, 574258, 576630, 576691, 576710, 577177, 577366, 578257, 580863, 583533, 583885, 592403, 592437, 592440, 592456, 592478, 592521, 592530, 593441, 606778, 609196, 615735, 617641, 619483, 620130, 620157, 622953, 622976, 624793, 628327, 689702, 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
  524986
  525745
  541366
  541408
  541588
  541594
  541606
  541611
  541614
  541623
  541633
  541640
  541643
  541651
  541661
  541665
  541667
  541671
  541683
  541688
  541698
  541699
  541738
  541804
  541828
  541871
  541874
  541886
  541888
  542196
  543579
  546993
  550033
  554784
  554787
  556987
  559127
  562825
  562836
  563093
  566252
  566503
  566693
  571428
  573764
  573765
  573909
  574258
  576630
  576691
  576710
  577177
  577366
  578257
  580863
  583533
  583885
  592403
  592437
  592440
  592456
  592478
  592521
  592530
  593441
  606778
  609196
  615735
  617641
  619483
  620130
  620157
  622953
  622976
  624793
  628327
  689702
  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, 524986, 525745, 541366, 541408, 541588, 541594, 541606, 541611, 541614, 541623, 541633, 541640, 541643, 541651, 541661, 541665, 541667, 541671, 541683, 541688, 541698, 541699, 541738, 541804, 541828, 541871, 541874, 541886, 541888, 542196, 543579, 546993, 550033, 554784, 554787, 556987, 559127, 562825, 562836, 563093, 566252, 566503, 566693, 571428, 573764, 573765, 573909, 574258, 576630, 576691, 576710, 577177, 577366, 578257, 580863, 583533, 583885, 592403, 592437, 592440, 592456, 592478, 592521, 592530, 593441, 606778, 609196, 615735, 617641, 619483, 620130, 620157, 622953, 622976, 624793, 628327, 689702, 727812);

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

[
  "волосатая pussy vintage"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'волосатая pussy vintage';

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

[
  "волосатая pussy vintage"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'волосатая pussy vintage';