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

[
  "кончил внутрь неожиданно"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'кончил внутрь неожиданно' 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
  805736
  803255
  604314
  725172
  796909
  791650
  736292
  564679
  813758
  656580
  789400
  787040
  715669
  758812
  781522
  780770
  687463
  730039
  546193
  762879
  677877
  701890
  775640
  729650
  779264
  811919
  738009
  810587
  593745
  796031
  785910
  656874
  625247
  746207
  627528
  723233
  708582
  622286
  779768
  761320
  785945
  761118
  480737
  779904
  760955
  514094
  576840
  713896
  627307
  744184
  710890
  625379
  503529
  726882
  592301
  776773
  722934
  535416
  579811
  549534
  579812
  596497
  572697
  577641
  773565
  613815
  603001
]

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 (805736, 803255, 604314, 725172, 796909, 791650, 736292, 564679, 813758, 656580, 789400, 787040, 715669, 758812, 781522, 780770, 687463, 730039, 546193, 762879, 677877, 701890, 775640, 729650, 779264, 811919, 738009, 810587, 593745, 796031, 785910, 656874, 625247, 746207, 627528, 723233, 708582, 622286, 779768, 761320, 785945, 761118, 480737, 779904, 760955, 514094, 576840, 713896, 627307, 744184, 710890, 625379, 503529, 726882, 592301, 776773, 722934, 535416, 579811, 549534, 579812, 596497, 572697, 577641, 773565, 613815, 603001);

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
  480737
  503529
  514094
  535416
  546193
  549534
  564679
  572697
  576840
  577641
  579811
  579812
  592301
  593745
  596497
  603001
  604314
  613815
  622286
  625247
  625379
  627307
  627528
  656580
  656874
  677877
  687463
  701890
  708582
  710890
  713896
  715669
  722934
  723233
  725172
  726882
  729650
  730039
  736292
  738009
  744184
  746207
  758812
  760955
  761118
  761320
  762879
  773565
  775640
  776773
  779264
  779768
  779904
  780770
  781522
  785910
  785945
  787040
  789400
  791650
  796031
  796909
  803255
  805736
  810587
  811919
  813758
]

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 (480737, 503529, 514094, 535416, 546193, 549534, 564679, 572697, 576840, 577641, 579811, 579812, 592301, 593745, 596497, 603001, 604314, 613815, 622286, 625247, 625379, 627307, 627528, 656580, 656874, 677877, 687463, 701890, 708582, 710890, 713896, 715669, 722934, 723233, 725172, 726882, 729650, 730039, 736292, 738009, 744184, 746207, 758812, 760955, 761118, 761320, 762879, 773565, 775640, 776773, 779264, 779768, 779904, 780770, 781522, 785910, 785945, 787040, 789400, 791650, 796031, 796909, 803255, 805736, 810587, 811919, 813758);

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
  480737
  503529
  514094
  535416
  546193
  549534
  564679
  572697
  576840
  577641
  579811
  579812
  592301
  593745
  596497
  603001
  604314
  613815
  622286
  625247
  625379
  627307
  627528
  656580
  656874
  677877
  687463
  701890
  708582
  710890
  713896
  715669
  722934
  723233
  725172
  726882
  729650
  730039
  736292
  738009
  744184
  746207
  758812
  760955
  761118
  761320
  762879
  773565
  775640
  776773
  779264
  779768
  779904
  780770
  781522
  785910
  785945
  787040
  789400
  791650
  796031
  796909
  803255
  805736
  810587
  811919
  813758
]

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 (480737, 503529, 514094, 535416, 546193, 549534, 564679, 572697, 576840, 577641, 579811, 579812, 592301, 593745, 596497, 603001, 604314, 613815, 622286, 625247, 625379, 627307, 627528, 656580, 656874, 677877, 687463, 701890, 708582, 710890, 713896, 715669, 722934, 723233, 725172, 726882, 729650, 730039, 736292, 738009, 744184, 746207, 758812, 760955, 761118, 761320, 762879, 773565, 775640, 776773, 779264, 779768, 779904, 780770, 781522, 785910, 785945, 787040, 789400, 791650, 796031, 796909, 803255, 805736, 810587, 811919, 813758);

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 ?

[
  "кончил внутрь неожиданно"
  "кончил внутрь неожиданно"
  "кончил внутрь неожиданно"
  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 ('кончил внутрь неожиданно') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('кончил внутрь неожиданно')
              AND `query` <> 'кончил внутрь неожиданно'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;