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

[
  "зрелый муж трахает"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'зрелый муж трахает' 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
  523815
  538290
  569679
  510258
  590966
  495665
  573477
  518597
  571198
  615444
  495403
  520681
  515206
  606948
  620620
  571428
  588244
  627812
  515184
  404778
  423235
  548549
  562885
  534167
  584539
  562858
  585671
  550609
  688664
  550233
  478527
  563884
  426025
  688007
  586564
  476856
  544686
  466994
  649525
  688586
  613177
  471494
  462698
  631957
  491023
  507681
  578396
  489112
  591368
  623622
  612125
  541877
  569421
  624504
  523809
  580289
  512050
  525118
  517048
  515252
  571754
  623616
  624392
  559233
  624846
  515223
  464328
  618326
  618889
  561307
  580215
]

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 (523815, 538290, 569679, 510258, 590966, 495665, 573477, 518597, 571198, 615444, 495403, 520681, 515206, 606948, 620620, 571428, 588244, 627812, 515184, 404778, 423235, 548549, 562885, 534167, 584539, 562858, 585671, 550609, 688664, 550233, 478527, 563884, 426025, 688007, 586564, 476856, 544686, 466994, 649525, 688586, 613177, 471494, 462698, 631957, 491023, 507681, 578396, 489112, 591368, 623622, 612125, 541877, 569421, 624504, 523809, 580289, 512050, 525118, 517048, 515252, 571754, 623616, 624392, 559233, 624846, 515223, 464328, 618326, 618889, 561307, 580215);

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
  404778
  423235
  426025
  462698
  464328
  466994
  471494
  476856
  478527
  489112
  491023
  495403
  495665
  507681
  510258
  512050
  515184
  515206
  515223
  515252
  517048
  518597
  520681
  523809
  523815
  525118
  534167
  538290
  541877
  544686
  548549
  550233
  550609
  559233
  561307
  562858
  562885
  563884
  569421
  569679
  571198
  571428
  571754
  573477
  578396
  580215
  580289
  584539
  585671
  586564
  588244
  590966
  591368
  606948
  612125
  613177
  615444
  618326
  618889
  620620
  623616
  623622
  624392
  624504
  624846
  627812
  631957
  649525
  688007
  688586
  688664
]

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 (404778, 423235, 426025, 462698, 464328, 466994, 471494, 476856, 478527, 489112, 491023, 495403, 495665, 507681, 510258, 512050, 515184, 515206, 515223, 515252, 517048, 518597, 520681, 523809, 523815, 525118, 534167, 538290, 541877, 544686, 548549, 550233, 550609, 559233, 561307, 562858, 562885, 563884, 569421, 569679, 571198, 571428, 571754, 573477, 578396, 580215, 580289, 584539, 585671, 586564, 588244, 590966, 591368, 606948, 612125, 613177, 615444, 618326, 618889, 620620, 623616, 623622, 624392, 624504, 624846, 627812, 631957, 649525, 688007, 688586, 688664);

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
  404778
  423235
  426025
  462698
  464328
  466994
  471494
  476856
  478527
  489112
  491023
  495403
  495665
  507681
  510258
  512050
  515184
  515206
  515223
  515252
  517048
  518597
  520681
  523809
  523815
  525118
  534167
  538290
  541877
  544686
  548549
  550233
  550609
  559233
  561307
  562858
  562885
  563884
  569421
  569679
  571198
  571428
  571754
  573477
  578396
  580215
  580289
  584539
  585671
  586564
  588244
  590966
  591368
  606948
  612125
  613177
  615444
  618326
  618889
  620620
  623616
  623622
  624392
  624504
  624846
  627812
  631957
  649525
  688007
  688586
  688664
]

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 (404778, 423235, 426025, 462698, 464328, 466994, 471494, 476856, 478527, 489112, 491023, 495403, 495665, 507681, 510258, 512050, 515184, 515206, 515223, 515252, 517048, 518597, 520681, 523809, 523815, 525118, 534167, 538290, 541877, 544686, 548549, 550233, 550609, 559233, 561307, 562858, 562885, 563884, 569421, 569679, 571198, 571428, 571754, 573477, 578396, 580215, 580289, 584539, 585671, 586564, 588244, 590966, 591368, 606948, 612125, 613177, 615444, 618326, 618889, 620620, 623616, 623622, 624392, 624504, 624846, 627812, 631957, 649525, 688007, 688586, 688664);

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 ?

[
  "зрелый муж трахает"
  "зрелый муж трахает"
  "зрелый муж трахает"
  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 ('зрелый муж трахает') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('зрелый муж трахает')
              AND `query` <> 'зрелый муж трахает'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;