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

[
  "sleeping fucking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sleeping fucking' 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
  454053
  456578
  489278
  454051
  477324
  509391
  497462
  510217
  517824
  518233
  525386
  558022
  567311
  615645
  603482
  623367
  479473
  417839
  391027
  422078
  416039
  473258
  417835
  518174
  519183
  502809
  662382
  527669
  583457
  469507
  565788
  563915
  576649
  459389
  473506
  491683
  517874
  497026
  492913
  500513
  494920
  525142
  536655
  519982
  567003
  559009
  483044
  795415
  504162
  514653
  521027
  521807
  532022
  552319
  558338
  606782
  625556
  789665
  621352
  477442
  407562
  480087
  703268
  490944
  515122
  491208
  521461
  459342
  413934
  515840
  501259
  682252
  464442
]

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 (454053, 456578, 489278, 454051, 477324, 509391, 497462, 510217, 517824, 518233, 525386, 558022, 567311, 615645, 603482, 623367, 479473, 417839, 391027, 422078, 416039, 473258, 417835, 518174, 519183, 502809, 662382, 527669, 583457, 469507, 565788, 563915, 576649, 459389, 473506, 491683, 517874, 497026, 492913, 500513, 494920, 525142, 536655, 519982, 567003, 559009, 483044, 795415, 504162, 514653, 521027, 521807, 532022, 552319, 558338, 606782, 625556, 789665, 621352, 477442, 407562, 480087, 703268, 490944, 515122, 491208, 521461, 459342, 413934, 515840, 501259, 682252, 464442);

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
  391027
  407562
  413934
  416039
  417835
  417839
  422078
  454051
  454053
  456578
  459342
  459389
  464442
  469507
  473258
  473506
  477324
  477442
  479473
  480087
  483044
  489278
  490944
  491208
  491683
  492913
  494920
  497026
  497462
  500513
  501259
  502809
  504162
  509391
  510217
  514653
  515122
  515840
  517824
  517874
  518174
  518233
  519183
  519982
  521027
  521461
  521807
  525142
  525386
  527669
  532022
  536655
  552319
  558022
  558338
  559009
  563915
  565788
  567003
  567311
  576649
  583457
  603482
  606782
  615645
  621352
  623367
  625556
  662382
  682252
  703268
  789665
  795415
]

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 (391027, 407562, 413934, 416039, 417835, 417839, 422078, 454051, 454053, 456578, 459342, 459389, 464442, 469507, 473258, 473506, 477324, 477442, 479473, 480087, 483044, 489278, 490944, 491208, 491683, 492913, 494920, 497026, 497462, 500513, 501259, 502809, 504162, 509391, 510217, 514653, 515122, 515840, 517824, 517874, 518174, 518233, 519183, 519982, 521027, 521461, 521807, 525142, 525386, 527669, 532022, 536655, 552319, 558022, 558338, 559009, 563915, 565788, 567003, 567311, 576649, 583457, 603482, 606782, 615645, 621352, 623367, 625556, 662382, 682252, 703268, 789665, 795415);

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
  391027
  407562
  413934
  416039
  417835
  417839
  422078
  454051
  454053
  456578
  459342
  459389
  464442
  469507
  473258
  473506
  477324
  477442
  479473
  480087
  483044
  489278
  490944
  491208
  491683
  492913
  494920
  497026
  497462
  500513
  501259
  502809
  504162
  509391
  510217
  514653
  515122
  515840
  517824
  517874
  518174
  518233
  519183
  519982
  521027
  521461
  521807
  525142
  525386
  527669
  532022
  536655
  552319
  558022
  558338
  559009
  563915
  565788
  567003
  567311
  576649
  583457
  603482
  606782
  615645
  621352
  623367
  625556
  662382
  682252
  703268
  789665
  795415
]

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 (391027, 407562, 413934, 416039, 417835, 417839, 422078, 454051, 454053, 456578, 459342, 459389, 464442, 469507, 473258, 473506, 477324, 477442, 479473, 480087, 483044, 489278, 490944, 491208, 491683, 492913, 494920, 497026, 497462, 500513, 501259, 502809, 504162, 509391, 510217, 514653, 515122, 515840, 517824, 517874, 518174, 518233, 519183, 519982, 521027, 521461, 521807, 525142, 525386, 527669, 532022, 536655, 552319, 558022, 558338, 559009, 563915, 565788, 567003, 567311, 576649, 583457, 603482, 606782, 615645, 621352, 623367, 625556, 662382, 682252, 703268, 789665, 795415);

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

[
  "спящ fucking"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'спящ fucking';

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

[
  "спящ fucking"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'спящ fucking';