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

[
  "oral webcams homemade"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'oral webcams homemade' 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
  421652
  462589
  426779
  426815
  417945
  442844
  449344
  456797
  460119
  485984
  504171
  502508
  518126
  581136
  602475
  446237
  448095
  475972
  434655
  467667
  461678
  479967
  422170
  442542
  537956
  670750
  493431
  553359
  579230
  586026
  437783
  434530
  446678
  437459
  437789
  444080
  449222
  509045
  546626
  624876
  592373
  594151
  414960
  426663
  452399
  452645
  415811
  504174
  488282
  488567
  557983
  546226
  432707
  444015
  437772
  477358
  501603
  492670
  519859
  602572
  434789
  455610
  455974
  500503
  450440
  525450
  624962
  448693
  476423
  436047
  477772
  459661
  521204
  456451
  462863
  616800
  505795
  528931
  505794
  597208
  586386
  586118
]

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 (421652, 462589, 426779, 426815, 417945, 442844, 449344, 456797, 460119, 485984, 504171, 502508, 518126, 581136, 602475, 446237, 448095, 475972, 434655, 467667, 461678, 479967, 422170, 442542, 537956, 670750, 493431, 553359, 579230, 586026, 437783, 434530, 446678, 437459, 437789, 444080, 449222, 509045, 546626, 624876, 592373, 594151, 414960, 426663, 452399, 452645, 415811, 504174, 488282, 488567, 557983, 546226, 432707, 444015, 437772, 477358, 501603, 492670, 519859, 602572, 434789, 455610, 455974, 500503, 450440, 525450, 624962, 448693, 476423, 436047, 477772, 459661, 521204, 456451, 462863, 616800, 505795, 528931, 505794, 597208, 586386, 586118);

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
  414960
  415811
  417945
  421652
  422170
  426663
  426779
  426815
  432707
  434530
  434655
  434789
  436047
  437459
  437772
  437783
  437789
  442542
  442844
  444015
  444080
  446237
  446678
  448095
  448693
  449222
  449344
  450440
  452399
  452645
  455610
  455974
  456451
  456797
  459661
  460119
  461678
  462589
  462863
  467667
  475972
  476423
  477358
  477772
  479967
  485984
  488282
  488567
  492670
  493431
  500503
  501603
  502508
  504171
  504174
  505795
  509045
  518126
  519859
  521204
  525450
  528931
  537956
  546226
  546626
  553359
  557983
  579230
  581136
  586026
  586118
  586386
  592373
  594151
  597208
  602475
  602572
  616800
  624876
  624962
  670750
]

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 (414960, 415811, 417945, 421652, 422170, 426663, 426779, 426815, 432707, 434530, 434655, 434789, 436047, 437459, 437772, 437783, 437789, 442542, 442844, 444015, 444080, 446237, 446678, 448095, 448693, 449222, 449344, 450440, 452399, 452645, 455610, 455974, 456451, 456797, 459661, 460119, 461678, 462589, 462863, 467667, 475972, 476423, 477358, 477772, 479967, 485984, 488282, 488567, 492670, 493431, 500503, 501603, 502508, 504171, 504174, 505795, 509045, 518126, 519859, 521204, 525450, 528931, 537956, 546226, 546626, 553359, 557983, 579230, 581136, 586026, 586118, 586386, 592373, 594151, 597208, 602475, 602572, 616800, 624876, 624962, 670750);

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
  414960
  415811
  417945
  421652
  422170
  426663
  426779
  426815
  432707
  434530
  434655
  434789
  436047
  437459
  437772
  437783
  437789
  442542
  442844
  444015
  444080
  446237
  446678
  448095
  448693
  449222
  449344
  450440
  452399
  452645
  455610
  455974
  456451
  456797
  459661
  460119
  461678
  462589
  462863
  467667
  475972
  476423
  477358
  477772
  479967
  485984
  488282
  488567
  492670
  493431
  500503
  501603
  502508
  504171
  504174
  505795
  509045
  518126
  519859
  521204
  525450
  528931
  537956
  546226
  546626
  553359
  557983
  579230
  581136
  586026
  586118
  586386
  592373
  594151
  597208
  602475
  602572
  616800
  624876
  624962
  670750
]

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 (414960, 415811, 417945, 421652, 422170, 426663, 426779, 426815, 432707, 434530, 434655, 434789, 436047, 437459, 437772, 437783, 437789, 442542, 442844, 444015, 444080, 446237, 446678, 448095, 448693, 449222, 449344, 450440, 452399, 452645, 455610, 455974, 456451, 456797, 459661, 460119, 461678, 462589, 462863, 467667, 475972, 476423, 477358, 477772, 479967, 485984, 488282, 488567, 492670, 493431, 500503, 501603, 502508, 504171, 504174, 505795, 509045, 518126, 519859, 521204, 525450, 528931, 537956, 546226, 546626, 553359, 557983, 579230, 581136, 586026, 586118, 586386, 592373, 594151, 597208, 602475, 602572, 616800, 624876, 624962, 670750);

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

[
  "oral webcams домашн любительск"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'oral webcams домашн любительск';

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

[
  "oral webcams домашн любительск"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'oral webcams домашн любительск';