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

[
  "making sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'making sex' 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
  522468
  488749
  450762
  514575
  473167
  513404
  451875
  509328
  517182
  467854
  580880
  578599
  603842
  467544
  447023
  534172
  500749
  482551
  454950
  449173
  476330
  580222
  603395
  810962
  625471
  493902
  510428
  570737
  546682
  576056
  481501
  504658
  514105
  582833
  512698
  405528
  446085
  556643
  597843
  609083
  417941
  507876
  496872
  567165
  473207
  423330
  505673
  513790
  603937
  524397
  524226
  558586
  507767
  562269
  536471
  580286
  477586
  559095
  509622
  440620
  598622
  514263
  479527
  557725
  443246
  650992
  482080
  540071
  605503
  420406
  517596
  555798
  504759
  553269
  581897
  730798
  599498
  478981
  520145
  595862
  623026
  597571
  510668
]

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 (522468, 488749, 450762, 514575, 473167, 513404, 451875, 509328, 517182, 467854, 580880, 578599, 603842, 467544, 447023, 534172, 500749, 482551, 454950, 449173, 476330, 580222, 603395, 810962, 625471, 493902, 510428, 570737, 546682, 576056, 481501, 504658, 514105, 582833, 512698, 405528, 446085, 556643, 597843, 609083, 417941, 507876, 496872, 567165, 473207, 423330, 505673, 513790, 603937, 524397, 524226, 558586, 507767, 562269, 536471, 580286, 477586, 559095, 509622, 440620, 598622, 514263, 479527, 557725, 443246, 650992, 482080, 540071, 605503, 420406, 517596, 555798, 504759, 553269, 581897, 730798, 599498, 478981, 520145, 595862, 623026, 597571, 510668);

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
  405528
  417941
  420406
  423330
  440620
  443246
  446085
  447023
  449173
  450762
  451875
  454950
  467544
  467854
  473167
  473207
  476330
  477586
  478981
  479527
  481501
  482080
  482551
  488749
  493902
  496872
  500749
  504658
  504759
  505673
  507767
  507876
  509328
  509622
  510428
  510668
  512698
  513404
  513790
  514105
  514263
  514575
  517182
  517596
  520145
  522468
  524226
  524397
  534172
  536471
  540071
  546682
  553269
  555798
  556643
  557725
  558586
  559095
  562269
  567165
  570737
  576056
  578599
  580222
  580286
  580880
  581897
  582833
  595862
  597571
  597843
  598622
  599498
  603395
  603842
  603937
  605503
  609083
  623026
  625471
  650992
  730798
  810962
]

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 (405528, 417941, 420406, 423330, 440620, 443246, 446085, 447023, 449173, 450762, 451875, 454950, 467544, 467854, 473167, 473207, 476330, 477586, 478981, 479527, 481501, 482080, 482551, 488749, 493902, 496872, 500749, 504658, 504759, 505673, 507767, 507876, 509328, 509622, 510428, 510668, 512698, 513404, 513790, 514105, 514263, 514575, 517182, 517596, 520145, 522468, 524226, 524397, 534172, 536471, 540071, 546682, 553269, 555798, 556643, 557725, 558586, 559095, 562269, 567165, 570737, 576056, 578599, 580222, 580286, 580880, 581897, 582833, 595862, 597571, 597843, 598622, 599498, 603395, 603842, 603937, 605503, 609083, 623026, 625471, 650992, 730798, 810962);

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
  405528
  417941
  420406
  423330
  440620
  443246
  446085
  447023
  449173
  450762
  451875
  454950
  467544
  467854
  473167
  473207
  476330
  477586
  478981
  479527
  481501
  482080
  482551
  488749
  493902
  496872
  500749
  504658
  504759
  505673
  507767
  507876
  509328
  509622
  510428
  510668
  512698
  513404
  513790
  514105
  514263
  514575
  517182
  517596
  520145
  522468
  524226
  524397
  534172
  536471
  540071
  546682
  553269
  555798
  556643
  557725
  558586
  559095
  562269
  567165
  570737
  576056
  578599
  580222
  580286
  580880
  581897
  582833
  595862
  597571
  597843
  598622
  599498
  603395
  603842
  603937
  605503
  609083
  623026
  625471
  650992
  730798
  810962
]

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 (405528, 417941, 420406, 423330, 440620, 443246, 446085, 447023, 449173, 450762, 451875, 454950, 467544, 467854, 473167, 473207, 476330, 477586, 478981, 479527, 481501, 482080, 482551, 488749, 493902, 496872, 500749, 504658, 504759, 505673, 507767, 507876, 509328, 509622, 510428, 510668, 512698, 513404, 513790, 514105, 514263, 514575, 517182, 517596, 520145, 522468, 524226, 524397, 534172, 536471, 540071, 546682, 553269, 555798, 556643, 557725, 558586, 559095, 562269, 567165, 570737, 576056, 578599, 580222, 580286, 580880, 581897, 582833, 595862, 597571, 597843, 598622, 599498, 603395, 603842, 603937, 605503, 609083, 623026, 625471, 650992, 730798, 810962);

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

[
  "making секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'making секс';

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

[
  "making секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'making секс';