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

[
  "секс перед телевизоро…"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс перед телевизоро…' 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
  461371
  555742
  635723
  478304
  523849
  498326
  493615
  519738
  432864
  480792
  537810
  543562
  567170
  509267
  509060
  524399
  687929
  506027
  421815
  439648
  456551
  505394
  526050
  667825
  421824
  421818
  515235
  519372
  712684
  521641
  565748
  444270
  480058
  520899
  520012
  549842
  486746
  451452
  489436
  607014
  526450
  506093
  549726
  490935
  483629
  497793
  456240
  523204
  462319
  455228
  465333
  482399
  548013
  466243
  549829
  477705
  504776
  659386
  439749
  459710
  554880
  653507
  526022
  618826
  603035
  625906
  652907
  465248
  583099
  605586
  607045
  610575
  615482
  625983
  619003
  523336
  623405
]

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 (461371, 555742, 635723, 478304, 523849, 498326, 493615, 519738, 432864, 480792, 537810, 543562, 567170, 509267, 509060, 524399, 687929, 506027, 421815, 439648, 456551, 505394, 526050, 667825, 421824, 421818, 515235, 519372, 712684, 521641, 565748, 444270, 480058, 520899, 520012, 549842, 486746, 451452, 489436, 607014, 526450, 506093, 549726, 490935, 483629, 497793, 456240, 523204, 462319, 455228, 465333, 482399, 548013, 466243, 549829, 477705, 504776, 659386, 439749, 459710, 554880, 653507, 526022, 618826, 603035, 625906, 652907, 465248, 583099, 605586, 607045, 610575, 615482, 625983, 619003, 523336, 623405);

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
  421815
  421818
  421824
  432864
  439648
  439749
  444270
  451452
  455228
  456240
  456551
  459710
  461371
  462319
  465248
  465333
  466243
  477705
  478304
  480058
  480792
  482399
  483629
  486746
  489436
  490935
  493615
  497793
  498326
  504776
  505394
  506027
  506093
  509060
  509267
  515235
  519372
  519738
  520012
  520899
  521641
  523204
  523336
  523849
  524399
  526022
  526050
  526450
  537810
  543562
  548013
  549726
  549829
  549842
  554880
  555742
  565748
  567170
  583099
  603035
  605586
  607014
  607045
  610575
  615482
  618826
  619003
  623405
  625906
  625983
  635723
  652907
  653507
  659386
  667825
  687929
  712684
]

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 (421815, 421818, 421824, 432864, 439648, 439749, 444270, 451452, 455228, 456240, 456551, 459710, 461371, 462319, 465248, 465333, 466243, 477705, 478304, 480058, 480792, 482399, 483629, 486746, 489436, 490935, 493615, 497793, 498326, 504776, 505394, 506027, 506093, 509060, 509267, 515235, 519372, 519738, 520012, 520899, 521641, 523204, 523336, 523849, 524399, 526022, 526050, 526450, 537810, 543562, 548013, 549726, 549829, 549842, 554880, 555742, 565748, 567170, 583099, 603035, 605586, 607014, 607045, 610575, 615482, 618826, 619003, 623405, 625906, 625983, 635723, 652907, 653507, 659386, 667825, 687929, 712684);

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
  421815
  421818
  421824
  432864
  439648
  439749
  444270
  451452
  455228
  456240
  456551
  459710
  461371
  462319
  465248
  465333
  466243
  477705
  478304
  480058
  480792
  482399
  483629
  486746
  489436
  490935
  493615
  497793
  498326
  504776
  505394
  506027
  506093
  509060
  509267
  515235
  519372
  519738
  520012
  520899
  521641
  523204
  523336
  523849
  524399
  526022
  526050
  526450
  537810
  543562
  548013
  549726
  549829
  549842
  554880
  555742
  565748
  567170
  583099
  603035
  605586
  607014
  607045
  610575
  615482
  618826
  619003
  623405
  625906
  625983
  635723
  652907
  653507
  659386
  667825
  687929
  712684
]

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 (421815, 421818, 421824, 432864, 439648, 439749, 444270, 451452, 455228, 456240, 456551, 459710, 461371, 462319, 465248, 465333, 466243, 477705, 478304, 480058, 480792, 482399, 483629, 486746, 489436, 490935, 493615, 497793, 498326, 504776, 505394, 506027, 506093, 509060, 509267, 515235, 519372, 519738, 520012, 520899, 521641, 523204, 523336, 523849, 524399, 526022, 526050, 526450, 537810, 543562, 548013, 549726, 549829, 549842, 554880, 555742, 565748, 567170, 583099, 603035, 605586, 607014, 607045, 610575, 615482, 618826, 619003, 623405, 625906, 625983, 635723, 652907, 653507, 659386, 667825, 687929, 712684);

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