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

[
  "wife panties orgasm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'wife panties orgasm' 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
  449234
  469666
  496518
  449313
  452688
  451113
  488260
  481121
  436828
  438984
  451358
  552042
  445108
  426897
  435625
  436649
  449582
  445717
  535332
  436827
  438648
  462069
  452326
  483314
  601801
  399152
  449102
  437970
  439257
  483667
  494665
  516353
  428761
  450077
  429020
  434527
  417400
  429406
  449332
  567526
  575988
  606197
  787510
  432318
  423342
  428685
  434885
  418259
  449114
  451386
  542535
  542146
  587143
  598213
  620174
  599155
  495501
  528144
  427971
  492181
  518007
  575708
  677898
  615182
  444913
  522771
  567220
  509714
  624064
]

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 (449234, 469666, 496518, 449313, 452688, 451113, 488260, 481121, 436828, 438984, 451358, 552042, 445108, 426897, 435625, 436649, 449582, 445717, 535332, 436827, 438648, 462069, 452326, 483314, 601801, 399152, 449102, 437970, 439257, 483667, 494665, 516353, 428761, 450077, 429020, 434527, 417400, 429406, 449332, 567526, 575988, 606197, 787510, 432318, 423342, 428685, 434885, 418259, 449114, 451386, 542535, 542146, 587143, 598213, 620174, 599155, 495501, 528144, 427971, 492181, 518007, 575708, 677898, 615182, 444913, 522771, 567220, 509714, 624064);

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
  399152
  417400
  418259
  423342
  426897
  427971
  428685
  428761
  429020
  429406
  432318
  434527
  434885
  435625
  436649
  436827
  436828
  437970
  438648
  438984
  439257
  444913
  445108
  445717
  449102
  449114
  449234
  449313
  449332
  449582
  450077
  451113
  451358
  451386
  452326
  452688
  462069
  469666
  481121
  483314
  483667
  488260
  492181
  494665
  495501
  496518
  509714
  516353
  518007
  522771
  528144
  535332
  542146
  542535
  552042
  567220
  567526
  575708
  575988
  587143
  598213
  599155
  601801
  606197
  615182
  620174
  624064
  677898
  787510
]

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 (399152, 417400, 418259, 423342, 426897, 427971, 428685, 428761, 429020, 429406, 432318, 434527, 434885, 435625, 436649, 436827, 436828, 437970, 438648, 438984, 439257, 444913, 445108, 445717, 449102, 449114, 449234, 449313, 449332, 449582, 450077, 451113, 451358, 451386, 452326, 452688, 462069, 469666, 481121, 483314, 483667, 488260, 492181, 494665, 495501, 496518, 509714, 516353, 518007, 522771, 528144, 535332, 542146, 542535, 552042, 567220, 567526, 575708, 575988, 587143, 598213, 599155, 601801, 606197, 615182, 620174, 624064, 677898, 787510);

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
  399152
  417400
  418259
  423342
  426897
  427971
  428685
  428761
  429020
  429406
  432318
  434527
  434885
  435625
  436649
  436827
  436828
  437970
  438648
  438984
  439257
  444913
  445108
  445717
  449102
  449114
  449234
  449313
  449332
  449582
  450077
  451113
  451358
  451386
  452326
  452688
  462069
  469666
  481121
  483314
  483667
  488260
  492181
  494665
  495501
  496518
  509714
  516353
  518007
  522771
  528144
  535332
  542146
  542535
  552042
  567220
  567526
  575708
  575988
  587143
  598213
  599155
  601801
  606197
  615182
  620174
  624064
  677898
  787510
]

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 (399152, 417400, 418259, 423342, 426897, 427971, 428685, 428761, 429020, 429406, 432318, 434527, 434885, 435625, 436649, 436827, 436828, 437970, 438648, 438984, 439257, 444913, 445108, 445717, 449102, 449114, 449234, 449313, 449332, 449582, 450077, 451113, 451358, 451386, 452326, 452688, 462069, 469666, 481121, 483314, 483667, 488260, 492181, 494665, 495501, 496518, 509714, 516353, 518007, 522771, 528144, 535332, 542146, 542535, 552042, 567220, 567526, 575708, 575988, 587143, 598213, 599155, 601801, 606197, 615182, 620174, 624064, 677898, 787510);

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

[
  "жен трусик нижн бел orgasm"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'жен трусик нижн бел orgasm';

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

[
  "жен трусик нижн бел orgasm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'жен трусик нижн бел orgasm';

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 ?

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