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

[
  "retro threesome"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'retro threesome' 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
  544627
  541738
  689702
  563093
  583533
  727812
  559120
  699397
  576623
  611616
  541721
  542195
  541643
  541635
  541874
  571213
  577350
  577356
  600837
  546774
  716879
  670765
  717947
  511392
  542954
  541673
  541888
  541633
  541769
  541614
  541640
  542196
  541664
  541774
  541780
  541683
  541644
  542188
  576710
  775811
  571428
  541808
  544296
  574244
  566688
  562831
  554205
  566702
  622832
  703098
  576684
  599577
  541588
  541924
  542192
  542189
  541671
  541639
  563441
  541650
  541871
  542191
  571198
  485589
  541623
  610108
  677712
  587791
  541646
  567416
  542956
  559378
  509910
  470944
  577371
  556778
]

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 (544627, 541738, 689702, 563093, 583533, 727812, 559120, 699397, 576623, 611616, 541721, 542195, 541643, 541635, 541874, 571213, 577350, 577356, 600837, 546774, 716879, 670765, 717947, 511392, 542954, 541673, 541888, 541633, 541769, 541614, 541640, 542196, 541664, 541774, 541780, 541683, 541644, 542188, 576710, 775811, 571428, 541808, 544296, 574244, 566688, 562831, 554205, 566702, 622832, 703098, 576684, 599577, 541588, 541924, 542192, 542189, 541671, 541639, 563441, 541650, 541871, 542191, 571198, 485589, 541623, 610108, 677712, 587791, 541646, 567416, 542956, 559378, 509910, 470944, 577371, 556778);

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
  470944
  485589
  509910
  511392
  541588
  541614
  541623
  541633
  541635
  541639
  541640
  541643
  541644
  541646
  541650
  541664
  541671
  541673
  541683
  541721
  541738
  541769
  541774
  541780
  541808
  541871
  541874
  541888
  541924
  542188
  542189
  542191
  542192
  542195
  542196
  542954
  542956
  544296
  544627
  546774
  554205
  556778
  559120
  559378
  562831
  563093
  563441
  566688
  566702
  567416
  571198
  571213
  571428
  574244
  576623
  576684
  576710
  577350
  577356
  577371
  583533
  587791
  599577
  600837
  610108
  611616
  622832
  670765
  677712
  689702
  699397
  703098
  716879
  717947
  727812
  775811
]

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 (470944, 485589, 509910, 511392, 541588, 541614, 541623, 541633, 541635, 541639, 541640, 541643, 541644, 541646, 541650, 541664, 541671, 541673, 541683, 541721, 541738, 541769, 541774, 541780, 541808, 541871, 541874, 541888, 541924, 542188, 542189, 542191, 542192, 542195, 542196, 542954, 542956, 544296, 544627, 546774, 554205, 556778, 559120, 559378, 562831, 563093, 563441, 566688, 566702, 567416, 571198, 571213, 571428, 574244, 576623, 576684, 576710, 577350, 577356, 577371, 583533, 587791, 599577, 600837, 610108, 611616, 622832, 670765, 677712, 689702, 699397, 703098, 716879, 717947, 727812, 775811);

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
  470944
  485589
  509910
  511392
  541588
  541614
  541623
  541633
  541635
  541639
  541640
  541643
  541644
  541646
  541650
  541664
  541671
  541673
  541683
  541721
  541738
  541769
  541774
  541780
  541808
  541871
  541874
  541888
  541924
  542188
  542189
  542191
  542192
  542195
  542196
  542954
  542956
  544296
  544627
  546774
  554205
  556778
  559120
  559378
  562831
  563093
  563441
  566688
  566702
  567416
  571198
  571213
  571428
  574244
  576623
  576684
  576710
  577350
  577356
  577371
  583533
  587791
  599577
  600837
  610108
  611616
  622832
  670765
  677712
  689702
  699397
  703098
  716879
  717947
  727812
  775811
]

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 (470944, 485589, 509910, 511392, 541588, 541614, 541623, 541633, 541635, 541639, 541640, 541643, 541644, 541646, 541650, 541664, 541671, 541673, 541683, 541721, 541738, 541769, 541774, 541780, 541808, 541871, 541874, 541888, 541924, 542188, 542189, 542191, 542192, 542195, 542196, 542954, 542956, 544296, 544627, 546774, 554205, 556778, 559120, 559378, 562831, 563093, 563441, 566688, 566702, 567416, 571198, 571213, 571428, 574244, 576623, 576684, 576710, 577350, 577356, 577371, 583533, 587791, 599577, 600837, 610108, 611616, 622832, 670765, 677712, 689702, 699397, 703098, 716879, 717947, 727812, 775811);

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` = 'ретр секс втро';