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
  396730
  456696
  398453
  396091
  385647
  502499
  654380
  421486
  428034
  498520
  462026
  555797
  424929
  683028
  426359
  499765
  609639
  605831
  591938
  432288
  426362
  439062
  514995
  662083
  454679
  497689
  554288
  447914
  680206
  537962
  607021
  463945
  553556
  420517
  483739
  523357
  596578
  464791
  469225
  515339
  622371
  722825
  472737
  426361
  519558
  387544
  436139
  559295
  452268
  519563
  566993
  609890
  598858
  462377
  447532
  561270
  597750
  591867
  602829
  526564
  431514
  454501
  518366
  650851
  458810
  583670
  598193
  521576
  477125
  540330
]

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 (396730, 456696, 398453, 396091, 385647, 502499, 654380, 421486, 428034, 498520, 462026, 555797, 424929, 683028, 426359, 499765, 609639, 605831, 591938, 432288, 426362, 439062, 514995, 662083, 454679, 497689, 554288, 447914, 680206, 537962, 607021, 463945, 553556, 420517, 483739, 523357, 596578, 464791, 469225, 515339, 622371, 722825, 472737, 426361, 519558, 387544, 436139, 559295, 452268, 519563, 566993, 609890, 598858, 462377, 447532, 561270, 597750, 591867, 602829, 526564, 431514, 454501, 518366, 650851, 458810, 583670, 598193, 521576, 477125, 540330);

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
  385647
  387544
  396091
  396730
  398453
  420517
  421486
  424929
  426359
  426361
  426362
  428034
  431514
  432288
  436139
  439062
  447532
  447914
  452268
  454501
  454679
  456696
  458810
  462026
  462377
  463945
  464791
  469225
  472737
  477125
  483739
  498520
  499765
  502499
  514995
  515339
  518366
  519558
  519563
  521576
  523357
  526564
  537962
  540330
  553556
  554288
  555797
  559295
  561270
  566993
  583670
  591867
  591938
  596578
  597750
  598193
  598858
  602829
  605831
  607021
  609639
  609890
  622371
  650851
  654380
  662083
  680206
  683028
  722825
]

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 (385647, 387544, 396091, 396730, 398453, 420517, 421486, 424929, 426359, 426361, 426362, 428034, 431514, 432288, 436139, 439062, 447532, 447914, 452268, 454501, 454679, 456696, 458810, 462026, 462377, 463945, 464791, 469225, 472737, 477125, 483739, 498520, 499765, 502499, 514995, 515339, 518366, 519558, 519563, 521576, 523357, 526564, 537962, 540330, 553556, 554288, 555797, 559295, 561270, 566993, 583670, 591867, 591938, 596578, 597750, 598193, 598858, 602829, 605831, 607021, 609639, 609890, 622371, 650851, 654380, 662083, 680206, 683028, 722825);

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
  385647
  387544
  396091
  396730
  398453
  420517
  421486
  424929
  426359
  426361
  426362
  428034
  431514
  432288
  436139
  439062
  447532
  447914
  452268
  454501
  454679
  456696
  458810
  462026
  462377
  463945
  464791
  469225
  472737
  477125
  483739
  498520
  499765
  502499
  514995
  515339
  518366
  519558
  519563
  521576
  523357
  526564
  537962
  540330
  553556
  554288
  555797
  559295
  561270
  566993
  583670
  591867
  591938
  596578
  597750
  598193
  598858
  602829
  605831
  607021
  609639
  609890
  622371
  650851
  654380
  662083
  680206
  683028
  722825
]

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 (385647, 387544, 396091, 396730, 398453, 420517, 421486, 424929, 426359, 426361, 426362, 428034, 431514, 432288, 436139, 439062, 447532, 447914, 452268, 454501, 454679, 456696, 458810, 462026, 462377, 463945, 464791, 469225, 472737, 477125, 483739, 498520, 499765, 502499, 514995, 515339, 518366, 519558, 519563, 521576, 523357, 526564, 537962, 540330, 553556, 554288, 555797, 559295, 561270, 566993, 583670, 591867, 591938, 596578, 597750, 598193, 598858, 602829, 605831, 607021, 609639, 609890, 622371, 650851, 654380, 662083, 680206, 683028, 722825);

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
        ;