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

[
  "squirt and cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'squirt and cum' 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
  633451
  540915
  795398
  794442
  744405
  729072
  777815
  811365
  676638
  600297
  88505
  716418
  589187
  807057
  725224
  735974
  675000
  539265
  573983
  718089
  812373
  730149
  621737
  666734
  793400
  787511
  777533
  434544
  455694
  524352
  522278
  499829
  581092
  580282
  584226
  640368
  779986
  741060
  742100
  759014
  698860
  434771
  502772
  529504
  545355
  415753
  510229
  575827
  555485
  557706
  580672
  541582
  584362
  724410
  509051
  639810
  486873
  555988
  560969
  726864
  527641
  432637
  506082
  536865
  534386
  605794
  619849
  435922
  484478
  585751
  564327
  679004
  591680
  584461
]

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 (633451, 540915, 795398, 794442, 744405, 729072, 777815, 811365, 676638, 600297, 88505, 716418, 589187, 807057, 725224, 735974, 675000, 539265, 573983, 718089, 812373, 730149, 621737, 666734, 793400, 787511, 777533, 434544, 455694, 524352, 522278, 499829, 581092, 580282, 584226, 640368, 779986, 741060, 742100, 759014, 698860, 434771, 502772, 529504, 545355, 415753, 510229, 575827, 555485, 557706, 580672, 541582, 584362, 724410, 509051, 639810, 486873, 555988, 560969, 726864, 527641, 432637, 506082, 536865, 534386, 605794, 619849, 435922, 484478, 585751, 564327, 679004, 591680, 584461);

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
  88505
  415753
  432637
  434544
  434771
  435922
  455694
  484478
  486873
  499829
  502772
  506082
  509051
  510229
  522278
  524352
  527641
  529504
  534386
  536865
  539265
  540915
  541582
  545355
  555485
  555988
  557706
  560969
  564327
  573983
  575827
  580282
  580672
  581092
  584226
  584362
  584461
  585751
  589187
  591680
  600297
  605794
  619849
  621737
  633451
  639810
  640368
  666734
  675000
  676638
  679004
  698860
  716418
  718089
  724410
  725224
  726864
  729072
  730149
  735974
  741060
  742100
  744405
  759014
  777533
  777815
  779986
  787511
  793400
  794442
  795398
  807057
  811365
  812373
]

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 (88505, 415753, 432637, 434544, 434771, 435922, 455694, 484478, 486873, 499829, 502772, 506082, 509051, 510229, 522278, 524352, 527641, 529504, 534386, 536865, 539265, 540915, 541582, 545355, 555485, 555988, 557706, 560969, 564327, 573983, 575827, 580282, 580672, 581092, 584226, 584362, 584461, 585751, 589187, 591680, 600297, 605794, 619849, 621737, 633451, 639810, 640368, 666734, 675000, 676638, 679004, 698860, 716418, 718089, 724410, 725224, 726864, 729072, 730149, 735974, 741060, 742100, 744405, 759014, 777533, 777815, 779986, 787511, 793400, 794442, 795398, 807057, 811365, 812373);

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
  88505
  415753
  432637
  434544
  434771
  435922
  455694
  484478
  486873
  499829
  502772
  506082
  509051
  510229
  522278
  524352
  527641
  529504
  534386
  536865
  539265
  540915
  541582
  545355
  555485
  555988
  557706
  560969
  564327
  573983
  575827
  580282
  580672
  581092
  584226
  584362
  584461
  585751
  589187
  591680
  600297
  605794
  619849
  621737
  633451
  639810
  640368
  666734
  675000
  676638
  679004
  698860
  716418
  718089
  724410
  725224
  726864
  729072
  730149
  735974
  741060
  742100
  744405
  759014
  777533
  777815
  779986
  787511
  793400
  794442
  795398
  807057
  811365
  812373
]

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 (88505, 415753, 432637, 434544, 434771, 435922, 455694, 484478, 486873, 499829, 502772, 506082, 509051, 510229, 522278, 524352, 527641, 529504, 534386, 536865, 539265, 540915, 541582, 545355, 555485, 555988, 557706, 560969, 564327, 573983, 575827, 580282, 580672, 581092, 584226, 584362, 584461, 585751, 589187, 591680, 600297, 605794, 619849, 621737, 633451, 639810, 640368, 666734, 675000, 676638, 679004, 698860, 716418, 718089, 724410, 725224, 726864, 729072, 730149, 735974, 741060, 742100, 744405, 759014, 777533, 777815, 779986, 787511, 793400, 794442, 795398, 807057, 811365, 812373);

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

[
  "сквирт оргазм cum"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'сквирт оргазм cum';

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

[
  "сквирт оргазм cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'сквирт оргазм cum';