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

[
  "girls squirt compilation"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'girls squirt compilation' 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
  423196
  443242
  797291
  750900
  466294
  527409
  456857
  804487
  512975
  511275
  483486
  584351
  415818
  632059
  590788
  629828
  429848
  417889
  448863
  765222
  536647
  649991
  498576
  418009
  519316
  617395
  730091
  776940
  770155
  443112
  821851
  508903
  469434
  424682
  460322
  702622
  449061
  430675
  515187
  448821
  816007
  470458
  425910
  493180
  473500
  494231
  631981
  423615
  450343
  640368
  559453
  427174
  827335
  768157
  555991
  711283
  428103
  788366
  699397
  557833
  583913
  546048
  428223
  803200
  597908
  452953
  518915
  440625
  509051
  793400
  433968
  559924
  573212
  666850
  728469
  478517
  785226
  437960
  787506
  540139
  805139
  784948
]

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 (423196, 443242, 797291, 750900, 466294, 527409, 456857, 804487, 512975, 511275, 483486, 584351, 415818, 632059, 590788, 629828, 429848, 417889, 448863, 765222, 536647, 649991, 498576, 418009, 519316, 617395, 730091, 776940, 770155, 443112, 821851, 508903, 469434, 424682, 460322, 702622, 449061, 430675, 515187, 448821, 816007, 470458, 425910, 493180, 473500, 494231, 631981, 423615, 450343, 640368, 559453, 427174, 827335, 768157, 555991, 711283, 428103, 788366, 699397, 557833, 583913, 546048, 428223, 803200, 597908, 452953, 518915, 440625, 509051, 793400, 433968, 559924, 573212, 666850, 728469, 478517, 785226, 437960, 787506, 540139, 805139, 784948);

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
  415818
  417889
  418009
  423196
  423615
  424682
  425910
  427174
  428103
  428223
  429848
  430675
  433968
  437960
  440625
  443112
  443242
  448821
  448863
  449061
  450343
  452953
  456857
  460322
  466294
  469434
  470458
  473500
  478517
  483486
  493180
  494231
  498576
  508903
  509051
  511275
  512975
  515187
  518915
  519316
  527409
  536647
  540139
  546048
  555991
  557833
  559453
  559924
  573212
  583913
  584351
  590788
  597908
  617395
  629828
  631981
  632059
  640368
  649991
  666850
  699397
  702622
  711283
  728469
  730091
  750900
  765222
  768157
  770155
  776940
  784948
  785226
  787506
  788366
  793400
  797291
  803200
  804487
  805139
  816007
  821851
  827335
]

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 (415818, 417889, 418009, 423196, 423615, 424682, 425910, 427174, 428103, 428223, 429848, 430675, 433968, 437960, 440625, 443112, 443242, 448821, 448863, 449061, 450343, 452953, 456857, 460322, 466294, 469434, 470458, 473500, 478517, 483486, 493180, 494231, 498576, 508903, 509051, 511275, 512975, 515187, 518915, 519316, 527409, 536647, 540139, 546048, 555991, 557833, 559453, 559924, 573212, 583913, 584351, 590788, 597908, 617395, 629828, 631981, 632059, 640368, 649991, 666850, 699397, 702622, 711283, 728469, 730091, 750900, 765222, 768157, 770155, 776940, 784948, 785226, 787506, 788366, 793400, 797291, 803200, 804487, 805139, 816007, 821851, 827335);

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
  415818
  417889
  418009
  423196
  423615
  424682
  425910
  427174
  428103
  428223
  429848
  430675
  433968
  437960
  440625
  443112
  443242
  448821
  448863
  449061
  450343
  452953
  456857
  460322
  466294
  469434
  470458
  473500
  478517
  483486
  493180
  494231
  498576
  508903
  509051
  511275
  512975
  515187
  518915
  519316
  527409
  536647
  540139
  546048
  555991
  557833
  559453
  559924
  573212
  583913
  584351
  590788
  597908
  617395
  629828
  631981
  632059
  640368
  649991
  666850
  699397
  702622
  711283
  728469
  730091
  750900
  765222
  768157
  770155
  776940
  784948
  785226
  787506
  788366
  793400
  797291
  803200
  804487
  805139
  816007
  821851
  827335
]

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 (415818, 417889, 418009, 423196, 423615, 424682, 425910, 427174, 428103, 428223, 429848, 430675, 433968, 437960, 440625, 443112, 443242, 448821, 448863, 449061, 450343, 452953, 456857, 460322, 466294, 469434, 470458, 473500, 478517, 483486, 493180, 494231, 498576, 508903, 509051, 511275, 512975, 515187, 518915, 519316, 527409, 536647, 540139, 546048, 555991, 557833, 559453, 559924, 573212, 583913, 584351, 590788, 597908, 617395, 629828, 631981, 632059, 640368, 649991, 666850, 699397, 702622, 711283, 728469, 730091, 750900, 765222, 768157, 770155, 776940, 784948, 785226, 787506, 788366, 793400, 797291, 803200, 804487, 805139, 816007, 821851, 827335);

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` = 'девушк сквирт оргазм подборк';