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

[
  "swallow hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'swallow hot' 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
  483578
  577815
  586658
  486870
  665622
  704218
  760789
  779848
  748152
  550824
  650808
  631908
  590935
  743967
  576579
  652536
  740045
  807018
  542441
  677916
  710208
  787419
  751205
  776290
  746342
  785322
  721207
  774583
  450155
  536143
  699581
  438062
  741935
  726933
  762665
  392066
  469710
  494096
  555088
  636574
  613848
  624600
  800470
  784280
  724555
  767769
  418043
  421144
  402434
  456350
  528756
  593193
  673862
  712540
  569923
  573473
  608645
  802691
  402887
  466587
  395166
  555930
  755030
  722918
  510881
  464661
  461221
  584752
  704222
  461635
  429369
  622773
  620236
  591176
]

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 (483578, 577815, 586658, 486870, 665622, 704218, 760789, 779848, 748152, 550824, 650808, 631908, 590935, 743967, 576579, 652536, 740045, 807018, 542441, 677916, 710208, 787419, 751205, 776290, 746342, 785322, 721207, 774583, 450155, 536143, 699581, 438062, 741935, 726933, 762665, 392066, 469710, 494096, 555088, 636574, 613848, 624600, 800470, 784280, 724555, 767769, 418043, 421144, 402434, 456350, 528756, 593193, 673862, 712540, 569923, 573473, 608645, 802691, 402887, 466587, 395166, 555930, 755030, 722918, 510881, 464661, 461221, 584752, 704222, 461635, 429369, 622773, 620236, 591176);

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
  392066
  395166
  402434
  402887
  418043
  421144
  429369
  438062
  450155
  456350
  461221
  461635
  464661
  466587
  469710
  483578
  486870
  494096
  510881
  528756
  536143
  542441
  550824
  555088
  555930
  569923
  573473
  576579
  577815
  584752
  586658
  590935
  591176
  593193
  608645
  613848
  620236
  622773
  624600
  631908
  636574
  650808
  652536
  665622
  673862
  677916
  699581
  704218
  704222
  710208
  712540
  721207
  722918
  724555
  726933
  740045
  741935
  743967
  746342
  748152
  751205
  755030
  760789
  762665
  767769
  774583
  776290
  779848
  784280
  785322
  787419
  800470
  802691
  807018
]

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 (392066, 395166, 402434, 402887, 418043, 421144, 429369, 438062, 450155, 456350, 461221, 461635, 464661, 466587, 469710, 483578, 486870, 494096, 510881, 528756, 536143, 542441, 550824, 555088, 555930, 569923, 573473, 576579, 577815, 584752, 586658, 590935, 591176, 593193, 608645, 613848, 620236, 622773, 624600, 631908, 636574, 650808, 652536, 665622, 673862, 677916, 699581, 704218, 704222, 710208, 712540, 721207, 722918, 724555, 726933, 740045, 741935, 743967, 746342, 748152, 751205, 755030, 760789, 762665, 767769, 774583, 776290, 779848, 784280, 785322, 787419, 800470, 802691, 807018);

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
  392066
  395166
  402434
  402887
  418043
  421144
  429369
  438062
  450155
  456350
  461221
  461635
  464661
  466587
  469710
  483578
  486870
  494096
  510881
  528756
  536143
  542441
  550824
  555088
  555930
  569923
  573473
  576579
  577815
  584752
  586658
  590935
  591176
  593193
  608645
  613848
  620236
  622773
  624600
  631908
  636574
  650808
  652536
  665622
  673862
  677916
  699581
  704218
  704222
  710208
  712540
  721207
  722918
  724555
  726933
  740045
  741935
  743967
  746342
  748152
  751205
  755030
  760789
  762665
  767769
  774583
  776290
  779848
  784280
  785322
  787419
  800470
  802691
  807018
]

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 (392066, 395166, 402434, 402887, 418043, 421144, 429369, 438062, 450155, 456350, 461221, 461635, 464661, 466587, 469710, 483578, 486870, 494096, 510881, 528756, 536143, 542441, 550824, 555088, 555930, 569923, 573473, 576579, 577815, 584752, 586658, 590935, 591176, 593193, 608645, 613848, 620236, 622773, 624600, 631908, 636574, 650808, 652536, 665622, 673862, 677916, 699581, 704218, 704222, 710208, 712540, 721207, 722918, 724555, 726933, 740045, 741935, 743967, 746342, 748152, 751205, 755030, 760789, 762665, 767769, 774583, 776290, 779848, 784280, 785322, 787419, 800470, 802691, 807018);

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

[
  "глота hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'глота hot';

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

[
  "глота hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'глота hot';

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 ?

[
  "swallow hot"
  "swallow hot"
  "swallow hot"
  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 ('swallow hot') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('swallow hot')
              AND `query` <> 'swallow hot'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;