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

[
  "super hairy sex"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'super hairy sex' 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
  684752
  804630
  719146
  824589
  825253
  696131
  820591
  824587
  559313
  576475
  725616
  810655
  710856
  784262
  746185
  411096
  577987
  502061
  714400
  632101
  543922
  392439
  462229
  666706
  660014
  789559
  471048
  539342
  554791
  488982
  810281
  737144
  803821
  725613
  403988
  490638
  469036
  560409
  741213
  647605
  614852
  511356
  428616
  488388
  575645
  770836
  418840
  425294
  518556
  425773
  389442
  500458
  478480
  521794
  410429
  526165
  616409
  454531
  580199
  572737
  579290
  588411
  492994
  536546
  445022
  422584
  596330
  422834
  472147
  510622
  409506
  522870
  469017
]

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 (684752, 804630, 719146, 824589, 825253, 696131, 820591, 824587, 559313, 576475, 725616, 810655, 710856, 784262, 746185, 411096, 577987, 502061, 714400, 632101, 543922, 392439, 462229, 666706, 660014, 789559, 471048, 539342, 554791, 488982, 810281, 737144, 803821, 725613, 403988, 490638, 469036, 560409, 741213, 647605, 614852, 511356, 428616, 488388, 575645, 770836, 418840, 425294, 518556, 425773, 389442, 500458, 478480, 521794, 410429, 526165, 616409, 454531, 580199, 572737, 579290, 588411, 492994, 536546, 445022, 422584, 596330, 422834, 472147, 510622, 409506, 522870, 469017);

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
  389442
  392439
  403988
  409506
  410429
  411096
  418840
  422584
  422834
  425294
  425773
  428616
  445022
  454531
  462229
  469017
  469036
  471048
  472147
  478480
  488388
  488982
  490638
  492994
  500458
  502061
  510622
  511356
  518556
  521794
  522870
  526165
  536546
  539342
  543922
  554791
  559313
  560409
  572737
  575645
  576475
  577987
  579290
  580199
  588411
  596330
  614852
  616409
  632101
  647605
  660014
  666706
  684752
  696131
  710856
  714400
  719146
  725613
  725616
  737144
  741213
  746185
  770836
  784262
  789559
  803821
  804630
  810281
  810655
  820591
  824587
  824589
  825253
]

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 (389442, 392439, 403988, 409506, 410429, 411096, 418840, 422584, 422834, 425294, 425773, 428616, 445022, 454531, 462229, 469017, 469036, 471048, 472147, 478480, 488388, 488982, 490638, 492994, 500458, 502061, 510622, 511356, 518556, 521794, 522870, 526165, 536546, 539342, 543922, 554791, 559313, 560409, 572737, 575645, 576475, 577987, 579290, 580199, 588411, 596330, 614852, 616409, 632101, 647605, 660014, 666706, 684752, 696131, 710856, 714400, 719146, 725613, 725616, 737144, 741213, 746185, 770836, 784262, 789559, 803821, 804630, 810281, 810655, 820591, 824587, 824589, 825253);

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
  389442
  392439
  403988
  409506
  410429
  411096
  418840
  422584
  422834
  425294
  425773
  428616
  445022
  454531
  462229
  469017
  469036
  471048
  472147
  478480
  488388
  488982
  490638
  492994
  500458
  502061
  510622
  511356
  518556
  521794
  522870
  526165
  536546
  539342
  543922
  554791
  559313
  560409
  572737
  575645
  576475
  577987
  579290
  580199
  588411
  596330
  614852
  616409
  632101
  647605
  660014
  666706
  684752
  696131
  710856
  714400
  719146
  725613
  725616
  737144
  741213
  746185
  770836
  784262
  789559
  803821
  804630
  810281
  810655
  820591
  824587
  824589
  825253
]

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 (389442, 392439, 403988, 409506, 410429, 411096, 418840, 422584, 422834, 425294, 425773, 428616, 445022, 454531, 462229, 469017, 469036, 471048, 472147, 478480, 488388, 488982, 490638, 492994, 500458, 502061, 510622, 511356, 518556, 521794, 522870, 526165, 536546, 539342, 543922, 554791, 559313, 560409, 572737, 575645, 576475, 577987, 579290, 580199, 588411, 596330, 614852, 616409, 632101, 647605, 660014, 666706, 684752, 696131, 710856, 714400, 719146, 725613, 725616, 737144, 741213, 746185, 770836, 784262, 789559, 803821, 804630, 810281, 810655, 820591, 824587, 824589, 825253);

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

[
  "super волосатая секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'super волосатая секс';

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

[
  "super волосатая секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'super волосатая секс';

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 ?

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