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

[
  "sperm for lube"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sperm for lube' 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
  793479
  447619
  812904
  325804
  718610
  732007
  821411
  825363
  767323
  772627
  563949
  760574
  824982
  795897
  810129
  749727
  730158
  656590
  604287
  711268
  646902
  712241
  729216
  711862
  778336
  778361
  791601
  616798
  791359
  630725
  503542
  625558
  785982
  787952
  790069
  729740
  753672
  761776
  398200
  535389
  493256
  658217
  583502
  733246
  805309
  823634
  790087
  791189
  583287
  593844
  626651
  441213
  821829
  461845
  658208
  675188
  719076
  805242
  810132
  782317
  451312
  544977
  707408
  552356
  447218
  654234
  780650
  564526
  553399
  463909
  515985
  563634
  425356
  581968
]

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 (793479, 447619, 812904, 325804, 718610, 732007, 821411, 825363, 767323, 772627, 563949, 760574, 824982, 795897, 810129, 749727, 730158, 656590, 604287, 711268, 646902, 712241, 729216, 711862, 778336, 778361, 791601, 616798, 791359, 630725, 503542, 625558, 785982, 787952, 790069, 729740, 753672, 761776, 398200, 535389, 493256, 658217, 583502, 733246, 805309, 823634, 790087, 791189, 583287, 593844, 626651, 441213, 821829, 461845, 658208, 675188, 719076, 805242, 810132, 782317, 451312, 544977, 707408, 552356, 447218, 654234, 780650, 564526, 553399, 463909, 515985, 563634, 425356, 581968);

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
  325804
  398200
  425356
  441213
  447218
  447619
  451312
  461845
  463909
  493256
  503542
  515985
  535389
  544977
  552356
  553399
  563634
  563949
  564526
  581968
  583287
  583502
  593844
  604287
  616798
  625558
  626651
  630725
  646902
  654234
  656590
  658208
  658217
  675188
  707408
  711268
  711862
  712241
  718610
  719076
  729216
  729740
  730158
  732007
  733246
  749727
  753672
  760574
  761776
  767323
  772627
  778336
  778361
  780650
  782317
  785982
  787952
  790069
  790087
  791189
  791359
  791601
  793479
  795897
  805242
  805309
  810129
  810132
  812904
  821411
  821829
  823634
  824982
  825363
]

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 (325804, 398200, 425356, 441213, 447218, 447619, 451312, 461845, 463909, 493256, 503542, 515985, 535389, 544977, 552356, 553399, 563634, 563949, 564526, 581968, 583287, 583502, 593844, 604287, 616798, 625558, 626651, 630725, 646902, 654234, 656590, 658208, 658217, 675188, 707408, 711268, 711862, 712241, 718610, 719076, 729216, 729740, 730158, 732007, 733246, 749727, 753672, 760574, 761776, 767323, 772627, 778336, 778361, 780650, 782317, 785982, 787952, 790069, 790087, 791189, 791359, 791601, 793479, 795897, 805242, 805309, 810129, 810132, 812904, 821411, 821829, 823634, 824982, 825363);

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
  325804
  398200
  425356
  441213
  447218
  447619
  451312
  461845
  463909
  493256
  503542
  515985
  535389
  544977
  552356
  553399
  563634
  563949
  564526
  581968
  583287
  583502
  593844
  604287
  616798
  625558
  626651
  630725
  646902
  654234
  656590
  658208
  658217
  675188
  707408
  711268
  711862
  712241
  718610
  719076
  729216
  729740
  730158
  732007
  733246
  749727
  753672
  760574
  761776
  767323
  772627
  778336
  778361
  780650
  782317
  785982
  787952
  790069
  790087
  791189
  791359
  791601
  793479
  795897
  805242
  805309
  810129
  810132
  812904
  821411
  821829
  823634
  824982
  825363
]

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 (325804, 398200, 425356, 441213, 447218, 447619, 451312, 461845, 463909, 493256, 503542, 515985, 535389, 544977, 552356, 553399, 563634, 563949, 564526, 581968, 583287, 583502, 593844, 604287, 616798, 625558, 626651, 630725, 646902, 654234, 656590, 658208, 658217, 675188, 707408, 711268, 711862, 712241, 718610, 719076, 729216, 729740, 730158, 732007, 733246, 749727, 753672, 760574, 761776, 767323, 772627, 778336, 778361, 780650, 782317, 785982, 787952, 790069, 790087, 791189, 791359, 791601, 793479, 795897, 805242, 805309, 810129, 810132, 812904, 821411, 821829, 823634, 824982, 825363);

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

[
  "сперм lube"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'сперм lube';

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

[
  "сперм lube"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'сперм lube';

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 ?

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