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

[
  "banana tits"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'banana tits' 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
  644540
  488907
  448614
  528652
  562420
  643517
  615692
  678823
  524758
  534448
  537456
  574769
  614542
  528935
  492619
  700462
  466439
  552834
  797224
  552824
  588175
  780327
  438967
  507505
  681798
  408845
  489523
  568603
  793992
  494017
  588828
  810118
  586721
  549800
  630083
  805990
  464023
  649974
  813250
  549639
  517204
  439565
  172224
  812036
  619395
  524321
  473251
  473965
  497888
  237161
  670402
  567387
  496315
  287315
  597977
  489537
  415346
  594401
  403695
  665975
  549794
  509317
  562287
  186948
  452711
  478303
  598529
  452379
  451664
  420593
  509995
  611535
]

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 (644540, 488907, 448614, 528652, 562420, 643517, 615692, 678823, 524758, 534448, 537456, 574769, 614542, 528935, 492619, 700462, 466439, 552834, 797224, 552824, 588175, 780327, 438967, 507505, 681798, 408845, 489523, 568603, 793992, 494017, 588828, 810118, 586721, 549800, 630083, 805990, 464023, 649974, 813250, 549639, 517204, 439565, 172224, 812036, 619395, 524321, 473251, 473965, 497888, 237161, 670402, 567387, 496315, 287315, 597977, 489537, 415346, 594401, 403695, 665975, 549794, 509317, 562287, 186948, 452711, 478303, 598529, 452379, 451664, 420593, 509995, 611535);

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
  172224
  186948
  237161
  287315
  403695
  408845
  415346
  420593
  438967
  439565
  448614
  451664
  452379
  452711
  464023
  466439
  473251
  473965
  478303
  488907
  489523
  489537
  492619
  494017
  496315
  497888
  507505
  509317
  509995
  517204
  524321
  524758
  528652
  528935
  534448
  537456
  549639
  549794
  549800
  552824
  552834
  562287
  562420
  567387
  568603
  574769
  586721
  588175
  588828
  594401
  597977
  598529
  611535
  614542
  615692
  619395
  630083
  643517
  644540
  649974
  665975
  670402
  678823
  681798
  700462
  780327
  793992
  797224
  805990
  810118
  812036
  813250
]

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 (172224, 186948, 237161, 287315, 403695, 408845, 415346, 420593, 438967, 439565, 448614, 451664, 452379, 452711, 464023, 466439, 473251, 473965, 478303, 488907, 489523, 489537, 492619, 494017, 496315, 497888, 507505, 509317, 509995, 517204, 524321, 524758, 528652, 528935, 534448, 537456, 549639, 549794, 549800, 552824, 552834, 562287, 562420, 567387, 568603, 574769, 586721, 588175, 588828, 594401, 597977, 598529, 611535, 614542, 615692, 619395, 630083, 643517, 644540, 649974, 665975, 670402, 678823, 681798, 700462, 780327, 793992, 797224, 805990, 810118, 812036, 813250);

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
  172224
  186948
  237161
  287315
  403695
  408845
  415346
  420593
  438967
  439565
  448614
  451664
  452379
  452711
  464023
  466439
  473251
  473965
  478303
  488907
  489523
  489537
  492619
  494017
  496315
  497888
  507505
  509317
  509995
  517204
  524321
  524758
  528652
  528935
  534448
  537456
  549639
  549794
  549800
  552824
  552834
  562287
  562420
  567387
  568603
  574769
  586721
  588175
  588828
  594401
  597977
  598529
  611535
  614542
  615692
  619395
  630083
  643517
  644540
  649974
  665975
  670402
  678823
  681798
  700462
  780327
  793992
  797224
  805990
  810118
  812036
  813250
]

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 (172224, 186948, 237161, 287315, 403695, 408845, 415346, 420593, 438967, 439565, 448614, 451664, 452379, 452711, 464023, 466439, 473251, 473965, 478303, 488907, 489523, 489537, 492619, 494017, 496315, 497888, 507505, 509317, 509995, 517204, 524321, 524758, 528652, 528935, 534448, 537456, 549639, 549794, 549800, 552824, 552834, 562287, 562420, 567387, 568603, 574769, 586721, 588175, 588828, 594401, 597977, 598529, 611535, 614542, 615692, 619395, 630083, 643517, 644540, 649974, 665975, 670402, 678823, 681798, 700462, 780327, 793992, 797224, 805990, 810118, 812036, 813250);

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 ?

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