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

[
  "mature homemade squirt"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature homemade squirt' 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
  736674
  728486
  768258
  537760
  735974
  803200
  513670
  818327
  560949
  666426
  752597
  494594
  423329
  578823
  564049
  800599
  741750
  555291
  523881
  741699
  533920
  564551
  777533
  476033
  660014
  582751
  553487
  664566
  604265
  741060
  745900
  555020
  555001
  664166
  742100
  759014
  794375
  517810
  424780
  603415
  826278
  626872
  643126
  773457
  728469
  513615
  493587
  478517
  415753
  557706
  578146
  583355
  707556
  802914
  458820
  546804
  545982
  477588
  514828
  494457
  555988
  560409
  556004
  791209
  527641
  489207
  428223
  579512
  568532
  432637
  626588
  601806
  751589
  515053
  770205
  805139
  604419
  526228
  439606
  439510
  440891
  450550
  513182
  567291
  424385
  511345
]

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 (736674, 728486, 768258, 537760, 735974, 803200, 513670, 818327, 560949, 666426, 752597, 494594, 423329, 578823, 564049, 800599, 741750, 555291, 523881, 741699, 533920, 564551, 777533, 476033, 660014, 582751, 553487, 664566, 604265, 741060, 745900, 555020, 555001, 664166, 742100, 759014, 794375, 517810, 424780, 603415, 826278, 626872, 643126, 773457, 728469, 513615, 493587, 478517, 415753, 557706, 578146, 583355, 707556, 802914, 458820, 546804, 545982, 477588, 514828, 494457, 555988, 560409, 556004, 791209, 527641, 489207, 428223, 579512, 568532, 432637, 626588, 601806, 751589, 515053, 770205, 805139, 604419, 526228, 439606, 439510, 440891, 450550, 513182, 567291, 424385, 511345);

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
  415753
  423329
  424385
  424780
  428223
  432637
  439510
  439606
  440891
  450550
  458820
  476033
  477588
  478517
  489207
  493587
  494457
  494594
  511345
  513182
  513615
  513670
  514828
  515053
  517810
  523881
  526228
  527641
  533920
  537760
  545982
  546804
  553487
  555001
  555020
  555291
  555988
  556004
  557706
  560409
  560949
  564049
  564551
  567291
  568532
  578146
  578823
  579512
  582751
  583355
  601806
  603415
  604265
  604419
  626588
  626872
  643126
  660014
  664166
  664566
  666426
  707556
  728469
  728486
  735974
  736674
  741060
  741699
  741750
  742100
  745900
  751589
  752597
  759014
  768258
  770205
  773457
  777533
  791209
  794375
  800599
  802914
  803200
  805139
  818327
  826278
]

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 (415753, 423329, 424385, 424780, 428223, 432637, 439510, 439606, 440891, 450550, 458820, 476033, 477588, 478517, 489207, 493587, 494457, 494594, 511345, 513182, 513615, 513670, 514828, 515053, 517810, 523881, 526228, 527641, 533920, 537760, 545982, 546804, 553487, 555001, 555020, 555291, 555988, 556004, 557706, 560409, 560949, 564049, 564551, 567291, 568532, 578146, 578823, 579512, 582751, 583355, 601806, 603415, 604265, 604419, 626588, 626872, 643126, 660014, 664166, 664566, 666426, 707556, 728469, 728486, 735974, 736674, 741060, 741699, 741750, 742100, 745900, 751589, 752597, 759014, 768258, 770205, 773457, 777533, 791209, 794375, 800599, 802914, 803200, 805139, 818327, 826278);

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
  415753
  423329
  424385
  424780
  428223
  432637
  439510
  439606
  440891
  450550
  458820
  476033
  477588
  478517
  489207
  493587
  494457
  494594
  511345
  513182
  513615
  513670
  514828
  515053
  517810
  523881
  526228
  527641
  533920
  537760
  545982
  546804
  553487
  555001
  555020
  555291
  555988
  556004
  557706
  560409
  560949
  564049
  564551
  567291
  568532
  578146
  578823
  579512
  582751
  583355
  601806
  603415
  604265
  604419
  626588
  626872
  643126
  660014
  664166
  664566
  666426
  707556
  728469
  728486
  735974
  736674
  741060
  741699
  741750
  742100
  745900
  751589
  752597
  759014
  768258
  770205
  773457
  777533
  791209
  794375
  800599
  802914
  803200
  805139
  818327
  826278
]

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 (415753, 423329, 424385, 424780, 428223, 432637, 439510, 439606, 440891, 450550, 458820, 476033, 477588, 478517, 489207, 493587, 494457, 494594, 511345, 513182, 513615, 513670, 514828, 515053, 517810, 523881, 526228, 527641, 533920, 537760, 545982, 546804, 553487, 555001, 555020, 555291, 555988, 556004, 557706, 560409, 560949, 564049, 564551, 567291, 568532, 578146, 578823, 579512, 582751, 583355, 601806, 603415, 604265, 604419, 626588, 626872, 643126, 660014, 664166, 664566, 666426, 707556, 728469, 728486, 735974, 736674, 741060, 741699, 741750, 742100, 745900, 751589, 752597, 759014, 768258, 770205, 773457, 777533, 791209, 794375, 800599, 802914, 803200, 805139, 818327, 826278);

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

[
  "mature домашн любительск сквирт оргазм"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature домашн любительск сквирт оргазм';

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

[
  "mature домашн любительск сквирт оргазм"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature домашн любительск сквирт оргазм';