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
  681209
  562829
  585447
  806228
  731442
  491378
  499025
  491372
  528701
  669643
  566304
  461049
  513204
  525138
  557595
  573914
  425118
  570304
  565405
  596880
  506562
  404471
  484161
  555967
  541109
  750445
  749981
  441017
  443607
  496854
  566611
  513548
  407168
  540709
  512451
  527268
  529312
  503662
  558210
  576007
  617021
  604163
  523600
  650311
  571653
  590966
  521126
  622386
  580334
  599483
  595885
  599534
  550097
  562282
  541773
  557042
  603900
  546757
  599803
  402722
  606822
  598545
  497661
  484870
  504610
  431262
  614273
  523995
  611392
  542954
  553942
  564136
  484924
  464594
]

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 (681209, 562829, 585447, 806228, 731442, 491378, 499025, 491372, 528701, 669643, 566304, 461049, 513204, 525138, 557595, 573914, 425118, 570304, 565405, 596880, 506562, 404471, 484161, 555967, 541109, 750445, 749981, 441017, 443607, 496854, 566611, 513548, 407168, 540709, 512451, 527268, 529312, 503662, 558210, 576007, 617021, 604163, 523600, 650311, 571653, 590966, 521126, 622386, 580334, 599483, 595885, 599534, 550097, 562282, 541773, 557042, 603900, 546757, 599803, 402722, 606822, 598545, 497661, 484870, 504610, 431262, 614273, 523995, 611392, 542954, 553942, 564136, 484924, 464594);

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
  402722
  404471
  407168
  425118
  431262
  441017
  443607
  461049
  464594
  484161
  484870
  484924
  491372
  491378
  496854
  497661
  499025
  503662
  504610
  506562
  512451
  513204
  513548
  521126
  523600
  523995
  525138
  527268
  528701
  529312
  540709
  541109
  541773
  542954
  546757
  550097
  553942
  555967
  557042
  557595
  558210
  562282
  562829
  564136
  565405
  566304
  566611
  570304
  571653
  573914
  576007
  580334
  585447
  590966
  595885
  596880
  598545
  599483
  599534
  599803
  603900
  604163
  606822
  611392
  614273
  617021
  622386
  650311
  669643
  681209
  731442
  749981
  750445
  806228
]

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 (402722, 404471, 407168, 425118, 431262, 441017, 443607, 461049, 464594, 484161, 484870, 484924, 491372, 491378, 496854, 497661, 499025, 503662, 504610, 506562, 512451, 513204, 513548, 521126, 523600, 523995, 525138, 527268, 528701, 529312, 540709, 541109, 541773, 542954, 546757, 550097, 553942, 555967, 557042, 557595, 558210, 562282, 562829, 564136, 565405, 566304, 566611, 570304, 571653, 573914, 576007, 580334, 585447, 590966, 595885, 596880, 598545, 599483, 599534, 599803, 603900, 604163, 606822, 611392, 614273, 617021, 622386, 650311, 669643, 681209, 731442, 749981, 750445, 806228);

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
  402722
  404471
  407168
  425118
  431262
  441017
  443607
  461049
  464594
  484161
  484870
  484924
  491372
  491378
  496854
  497661
  499025
  503662
  504610
  506562
  512451
  513204
  513548
  521126
  523600
  523995
  525138
  527268
  528701
  529312
  540709
  541109
  541773
  542954
  546757
  550097
  553942
  555967
  557042
  557595
  558210
  562282
  562829
  564136
  565405
  566304
  566611
  570304
  571653
  573914
  576007
  580334
  585447
  590966
  595885
  596880
  598545
  599483
  599534
  599803
  603900
  604163
  606822
  611392
  614273
  617021
  622386
  650311
  669643
  681209
  731442
  749981
  750445
  806228
]

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 (402722, 404471, 407168, 425118, 431262, 441017, 443607, 461049, 464594, 484161, 484870, 484924, 491372, 491378, 496854, 497661, 499025, 503662, 504610, 506562, 512451, 513204, 513548, 521126, 523600, 523995, 525138, 527268, 528701, 529312, 540709, 541109, 541773, 542954, 546757, 550097, 553942, 555967, 557042, 557595, 558210, 562282, 562829, 564136, 565405, 566304, 566611, 570304, 571653, 573914, 576007, 580334, 585447, 590966, 595885, 596880, 598545, 599483, 599534, 599803, 603900, 604163, 606822, 611392, 614273, 617021, 622386, 650311, 669643, 681209, 731442, 749981, 750445, 806228);

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` = 'в дорог';