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

[
  "dildo porn solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dildo porn solo' 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
  652786
  807654
  812195
  500778
  670737
  794636
  812497
  435529
  435548
  553221
  675409
  384836
  788118
  461873
  743455
  401184
  584821
  689886
  588833
  641386
  758082
  779277
  529034
  451317
  460237
  678185
  787519
  785986
  573267
  783237
  537472
  598923
  598956
  438615
  425529
  452846
  527494
  535807
  783671
  722404
  595161
  751327
  631301
  438052
  579449
  418138
  417396
  700682
  784596
  713361
  781873
  783486
  789028
  724948
  802908
  528663
  512939
  435547
  536388
  613356
  627007
  429555
  463966
  529076
  516510
  742279
  525092
  541132
  602614
  605746
  441907
  621259
  500292
]

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 (652786, 807654, 812195, 500778, 670737, 794636, 812497, 435529, 435548, 553221, 675409, 384836, 788118, 461873, 743455, 401184, 584821, 689886, 588833, 641386, 758082, 779277, 529034, 451317, 460237, 678185, 787519, 785986, 573267, 783237, 537472, 598923, 598956, 438615, 425529, 452846, 527494, 535807, 783671, 722404, 595161, 751327, 631301, 438052, 579449, 418138, 417396, 700682, 784596, 713361, 781873, 783486, 789028, 724948, 802908, 528663, 512939, 435547, 536388, 613356, 627007, 429555, 463966, 529076, 516510, 742279, 525092, 541132, 602614, 605746, 441907, 621259, 500292);

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
  384836
  401184
  417396
  418138
  425529
  429555
  435529
  435547
  435548
  438052
  438615
  441907
  451317
  452846
  460237
  461873
  463966
  500292
  500778
  512939
  516510
  525092
  527494
  528663
  529034
  529076
  535807
  536388
  537472
  541132
  553221
  573267
  579449
  584821
  588833
  595161
  598923
  598956
  602614
  605746
  613356
  621259
  627007
  631301
  641386
  652786
  670737
  675409
  678185
  689886
  700682
  713361
  722404
  724948
  742279
  743455
  751327
  758082
  779277
  781873
  783237
  783486
  783671
  784596
  785986
  787519
  788118
  789028
  794636
  802908
  807654
  812195
  812497
]

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 (384836, 401184, 417396, 418138, 425529, 429555, 435529, 435547, 435548, 438052, 438615, 441907, 451317, 452846, 460237, 461873, 463966, 500292, 500778, 512939, 516510, 525092, 527494, 528663, 529034, 529076, 535807, 536388, 537472, 541132, 553221, 573267, 579449, 584821, 588833, 595161, 598923, 598956, 602614, 605746, 613356, 621259, 627007, 631301, 641386, 652786, 670737, 675409, 678185, 689886, 700682, 713361, 722404, 724948, 742279, 743455, 751327, 758082, 779277, 781873, 783237, 783486, 783671, 784596, 785986, 787519, 788118, 789028, 794636, 802908, 807654, 812195, 812497);

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
  384836
  401184
  417396
  418138
  425529
  429555
  435529
  435547
  435548
  438052
  438615
  441907
  451317
  452846
  460237
  461873
  463966
  500292
  500778
  512939
  516510
  525092
  527494
  528663
  529034
  529076
  535807
  536388
  537472
  541132
  553221
  573267
  579449
  584821
  588833
  595161
  598923
  598956
  602614
  605746
  613356
  621259
  627007
  631301
  641386
  652786
  670737
  675409
  678185
  689886
  700682
  713361
  722404
  724948
  742279
  743455
  751327
  758082
  779277
  781873
  783237
  783486
  783671
  784596
  785986
  787519
  788118
  789028
  794636
  802908
  807654
  812195
  812497
]

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 (384836, 401184, 417396, 418138, 425529, 429555, 435529, 435547, 435548, 438052, 438615, 441907, 451317, 452846, 460237, 461873, 463966, 500292, 500778, 512939, 516510, 525092, 527494, 528663, 529034, 529076, 535807, 536388, 537472, 541132, 553221, 573267, 579449, 584821, 588833, 595161, 598923, 598956, 602614, 605746, 613356, 621259, 627007, 631301, 641386, 652786, 670737, 675409, 678185, 689886, 700682, 713361, 722404, 724948, 742279, 743455, 751327, 758082, 779277, 781873, 783237, 783486, 783671, 784596, 785986, 787519, 788118, 789028, 794636, 802908, 807654, 812195, 812497);

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

[
  "дилд porn соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'дилд porn соло';

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

[
  "дилд porn соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'дилд porn соло';

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 ?

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