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
  562964
  593029
  464699
  489980
  454245
  472693
  778515
  562886
  798684
  606567
  517369
  600672
  383045
  478978
  563312
  484559
  814818
  576112
  788878
  780783
  594580
  407562
  494036
  491584
  553650
  468834
  532022
  581098
  415207
  698609
  565788
  775256
  546058
  591119
  717167
  788866
  415710
  534837
  435634
  624846
  586591
  526894
  556002
  609252
  479486
  619107
  561298
  663259
  391910
  420635
  414135
  468897
  521832
  555181
  611416
  508236
  544495
  453438
  587878
  456109
  550882
  726526
  421030
  566587
  524276
  501259
  512050
  617004
  585101
  518768
  512952
]

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 (562964, 593029, 464699, 489980, 454245, 472693, 778515, 562886, 798684, 606567, 517369, 600672, 383045, 478978, 563312, 484559, 814818, 576112, 788878, 780783, 594580, 407562, 494036, 491584, 553650, 468834, 532022, 581098, 415207, 698609, 565788, 775256, 546058, 591119, 717167, 788866, 415710, 534837, 435634, 624846, 586591, 526894, 556002, 609252, 479486, 619107, 561298, 663259, 391910, 420635, 414135, 468897, 521832, 555181, 611416, 508236, 544495, 453438, 587878, 456109, 550882, 726526, 421030, 566587, 524276, 501259, 512050, 617004, 585101, 518768, 512952);

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
  383045
  391910
  407562
  414135
  415207
  415710
  420635
  421030
  435634
  453438
  454245
  456109
  464699
  468834
  468897
  472693
  478978
  479486
  484559
  489980
  491584
  494036
  501259
  508236
  512050
  512952
  517369
  518768
  521832
  524276
  526894
  532022
  534837
  544495
  546058
  550882
  553650
  555181
  556002
  561298
  562886
  562964
  563312
  565788
  566587
  576112
  581098
  585101
  586591
  587878
  591119
  593029
  594580
  600672
  606567
  609252
  611416
  617004
  619107
  624846
  663259
  698609
  717167
  726526
  775256
  778515
  780783
  788866
  788878
  798684
  814818
]

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 (383045, 391910, 407562, 414135, 415207, 415710, 420635, 421030, 435634, 453438, 454245, 456109, 464699, 468834, 468897, 472693, 478978, 479486, 484559, 489980, 491584, 494036, 501259, 508236, 512050, 512952, 517369, 518768, 521832, 524276, 526894, 532022, 534837, 544495, 546058, 550882, 553650, 555181, 556002, 561298, 562886, 562964, 563312, 565788, 566587, 576112, 581098, 585101, 586591, 587878, 591119, 593029, 594580, 600672, 606567, 609252, 611416, 617004, 619107, 624846, 663259, 698609, 717167, 726526, 775256, 778515, 780783, 788866, 788878, 798684, 814818);

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
  383045
  391910
  407562
  414135
  415207
  415710
  420635
  421030
  435634
  453438
  454245
  456109
  464699
  468834
  468897
  472693
  478978
  479486
  484559
  489980
  491584
  494036
  501259
  508236
  512050
  512952
  517369
  518768
  521832
  524276
  526894
  532022
  534837
  544495
  546058
  550882
  553650
  555181
  556002
  561298
  562886
  562964
  563312
  565788
  566587
  576112
  581098
  585101
  586591
  587878
  591119
  593029
  594580
  600672
  606567
  609252
  611416
  617004
  619107
  624846
  663259
  698609
  717167
  726526
  775256
  778515
  780783
  788866
  788878
  798684
  814818
]

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 (383045, 391910, 407562, 414135, 415207, 415710, 420635, 421030, 435634, 453438, 454245, 456109, 464699, 468834, 468897, 472693, 478978, 479486, 484559, 489980, 491584, 494036, 501259, 508236, 512050, 512952, 517369, 518768, 521832, 524276, 526894, 532022, 534837, 544495, 546058, 550882, 553650, 555181, 556002, 561298, 562886, 562964, 563312, 565788, 566587, 576112, 581098, 585101, 586591, 587878, 591119, 593029, 594580, 600672, 606567, 609252, 611416, 617004, 619107, 624846, 663259, 698609, 717167, 726526, 775256, 778515, 780783, 788866, 788878, 798684, 814818);

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` = 'жен спящ пок';