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

[
  "piercing anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'piercing anal' 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
  521292
  566908
  558439
  559142
  564563
  583994
  607630
  614056
  481904
  500799
  602519
  605372
  596642
  527106
  680190
  577435
  403256
  508518
  653459
  653189
  547490
  532943
  647898
  609906
  559120
  556045
  555789
  576692
  565180
  640684
  427967
  503834
  524506
  531511
  531065
  541638
  541888
  662020
  620641
  590444
  556037
  536695
  541639
  457886
  469597
  565321
  583080
  601253
  604640
  623199
  520710
  556741
  624247
  625675
  607374
  637413
  617420
  533707
  538281
  552619
  475329
  530273
  542456
  567673
  523568
  590763
  469110
  528358
  547245
  525082
  583039
  606577
  650313
  610613
]

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 (521292, 566908, 558439, 559142, 564563, 583994, 607630, 614056, 481904, 500799, 602519, 605372, 596642, 527106, 680190, 577435, 403256, 508518, 653459, 653189, 547490, 532943, 647898, 609906, 559120, 556045, 555789, 576692, 565180, 640684, 427967, 503834, 524506, 531511, 531065, 541638, 541888, 662020, 620641, 590444, 556037, 536695, 541639, 457886, 469597, 565321, 583080, 601253, 604640, 623199, 520710, 556741, 624247, 625675, 607374, 637413, 617420, 533707, 538281, 552619, 475329, 530273, 542456, 567673, 523568, 590763, 469110, 528358, 547245, 525082, 583039, 606577, 650313, 610613);

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
  403256
  427967
  457886
  469110
  469597
  475329
  481904
  500799
  503834
  508518
  520710
  521292
  523568
  524506
  525082
  527106
  528358
  530273
  531065
  531511
  532943
  533707
  536695
  538281
  541638
  541639
  541888
  542456
  547245
  547490
  552619
  555789
  556037
  556045
  556741
  558439
  559120
  559142
  564563
  565180
  565321
  566908
  567673
  576692
  577435
  583039
  583080
  583994
  590444
  590763
  596642
  601253
  602519
  604640
  605372
  606577
  607374
  607630
  609906
  610613
  614056
  617420
  620641
  623199
  624247
  625675
  637413
  640684
  647898
  650313
  653189
  653459
  662020
  680190
]

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 (403256, 427967, 457886, 469110, 469597, 475329, 481904, 500799, 503834, 508518, 520710, 521292, 523568, 524506, 525082, 527106, 528358, 530273, 531065, 531511, 532943, 533707, 536695, 538281, 541638, 541639, 541888, 542456, 547245, 547490, 552619, 555789, 556037, 556045, 556741, 558439, 559120, 559142, 564563, 565180, 565321, 566908, 567673, 576692, 577435, 583039, 583080, 583994, 590444, 590763, 596642, 601253, 602519, 604640, 605372, 606577, 607374, 607630, 609906, 610613, 614056, 617420, 620641, 623199, 624247, 625675, 637413, 640684, 647898, 650313, 653189, 653459, 662020, 680190);

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
  403256
  427967
  457886
  469110
  469597
  475329
  481904
  500799
  503834
  508518
  520710
  521292
  523568
  524506
  525082
  527106
  528358
  530273
  531065
  531511
  532943
  533707
  536695
  538281
  541638
  541639
  541888
  542456
  547245
  547490
  552619
  555789
  556037
  556045
  556741
  558439
  559120
  559142
  564563
  565180
  565321
  566908
  567673
  576692
  577435
  583039
  583080
  583994
  590444
  590763
  596642
  601253
  602519
  604640
  605372
  606577
  607374
  607630
  609906
  610613
  614056
  617420
  620641
  623199
  624247
  625675
  637413
  640684
  647898
  650313
  653189
  653459
  662020
  680190
]

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 (403256, 427967, 457886, 469110, 469597, 475329, 481904, 500799, 503834, 508518, 520710, 521292, 523568, 524506, 525082, 527106, 528358, 530273, 531065, 531511, 532943, 533707, 536695, 538281, 541638, 541639, 541888, 542456, 547245, 547490, 552619, 555789, 556037, 556045, 556741, 558439, 559120, 559142, 564563, 565180, 565321, 566908, 567673, 576692, 577435, 583039, 583080, 583994, 590444, 590763, 596642, 601253, 602519, 604640, 605372, 606577, 607374, 607630, 609906, 610613, 614056, 617420, 620641, 623199, 624247, 625675, 637413, 640684, 647898, 650313, 653189, 653459, 662020, 680190);

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` = 'пирсинг анал';

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "piercing anal"
  "piercing anal"
  "piercing anal"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('piercing anal') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('piercing anal')
              AND `query` <> 'piercing anal'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;