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

[
  "sex gang gang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sex gang gang' 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
  423940
  431105
  520725
  565096
  501474
  790884
  575810
  666901
  680203
  778307
  474680
  421352
  529849
  545441
  670758
  550265
  627809
  588301
  597232
  633749
  515152
  644964
  680185
  695126
  632979
  624175
  637080
  627807
  473780
  612422
  575661
  597876
  443823
  538815
  545341
  548552
  637030
  648543
  545393
  627808
  530017
  627814
  629967
  641856
  545427
  680190
  490201
  545444
  608431
  597272
  472125
  628389
  635215
  651647
  518592
  545409
  680207
  545363
  545389
  545410
  639334
  627812
  630552
  553272
  680197
  621988
  520731
  650788
  545418
  540330
  617423
  559127
  642662
]

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 (423940, 431105, 520725, 565096, 501474, 790884, 575810, 666901, 680203, 778307, 474680, 421352, 529849, 545441, 670758, 550265, 627809, 588301, 597232, 633749, 515152, 644964, 680185, 695126, 632979, 624175, 637080, 627807, 473780, 612422, 575661, 597876, 443823, 538815, 545341, 548552, 637030, 648543, 545393, 627808, 530017, 627814, 629967, 641856, 545427, 680190, 490201, 545444, 608431, 597272, 472125, 628389, 635215, 651647, 518592, 545409, 680207, 545363, 545389, 545410, 639334, 627812, 630552, 553272, 680197, 621988, 520731, 650788, 545418, 540330, 617423, 559127, 642662);

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
  421352
  423940
  431105
  443823
  472125
  473780
  474680
  490201
  501474
  515152
  518592
  520725
  520731
  529849
  530017
  538815
  540330
  545341
  545363
  545389
  545393
  545409
  545410
  545418
  545427
  545441
  545444
  548552
  550265
  553272
  559127
  565096
  575661
  575810
  588301
  597232
  597272
  597876
  608431
  612422
  617423
  621988
  624175
  627807
  627808
  627809
  627812
  627814
  628389
  629967
  630552
  632979
  633749
  635215
  637030
  637080
  639334
  641856
  642662
  644964
  648543
  650788
  651647
  666901
  670758
  680185
  680190
  680197
  680203
  680207
  695126
  778307
  790884
]

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 (421352, 423940, 431105, 443823, 472125, 473780, 474680, 490201, 501474, 515152, 518592, 520725, 520731, 529849, 530017, 538815, 540330, 545341, 545363, 545389, 545393, 545409, 545410, 545418, 545427, 545441, 545444, 548552, 550265, 553272, 559127, 565096, 575661, 575810, 588301, 597232, 597272, 597876, 608431, 612422, 617423, 621988, 624175, 627807, 627808, 627809, 627812, 627814, 628389, 629967, 630552, 632979, 633749, 635215, 637030, 637080, 639334, 641856, 642662, 644964, 648543, 650788, 651647, 666901, 670758, 680185, 680190, 680197, 680203, 680207, 695126, 778307, 790884);

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
  421352
  423940
  431105
  443823
  472125
  473780
  474680
  490201
  501474
  515152
  518592
  520725
  520731
  529849
  530017
  538815
  540330
  545341
  545363
  545389
  545393
  545409
  545410
  545418
  545427
  545441
  545444
  548552
  550265
  553272
  559127
  565096
  575661
  575810
  588301
  597232
  597272
  597876
  608431
  612422
  617423
  621988
  624175
  627807
  627808
  627809
  627812
  627814
  628389
  629967
  630552
  632979
  633749
  635215
  637030
  637080
  639334
  641856
  642662
  644964
  648543
  650788
  651647
  666901
  670758
  680185
  680190
  680197
  680203
  680207
  695126
  778307
  790884
]

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 (421352, 423940, 431105, 443823, 472125, 473780, 474680, 490201, 501474, 515152, 518592, 520725, 520731, 529849, 530017, 538815, 540330, 545341, 545363, 545389, 545393, 545409, 545410, 545418, 545427, 545441, 545444, 548552, 550265, 553272, 559127, 565096, 575661, 575810, 588301, 597232, 597272, 597876, 608431, 612422, 617423, 621988, 624175, 627807, 627808, 627809, 627812, 627814, 628389, 629967, 630552, 632979, 633749, 635215, 637030, 637080, 639334, 641856, 642662, 644964, 648543, 650788, 651647, 666901, 670758, 680185, 680190, 680197, 680203, 680207, 695126, 778307, 790884);

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

[
  "секс gang gang"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'секс gang gang';

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

[
  "секс gang gang"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'секс gang gang';