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
  606774
  558581
  569131
  652915
  610607
  528447
  513656
  486688
  478367
  689379
  519765
  606286
  525662
  526030
  531566
  552089
  501177
  687484
  551916
  609813
  387905
  437592
  462930
  469145
  543599
  572273
  622373
  569132
  591289
  519590
  543597
  526545
  488132
  666784
  523423
  520746
  414729
  458925
  467195
  619082
  597227
  584713
  569098
  604890
  564864
  602801
  510858
  680216
  500299
  341596
  533978
  516763
  495647
  519591
  482727
  529392
  512939
  589524
  589290
  603539
  522794
  567522
  478596
  569030
  486446
  432929
  582179
  675471
  516711
  506612
  488751
  588244
  608431
  571244
  516727
  583989
  591065
  541770
  512941
  609953
  541647
  562825
  576726
  531155
  508150
  665328
]

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 (606774, 558581, 569131, 652915, 610607, 528447, 513656, 486688, 478367, 689379, 519765, 606286, 525662, 526030, 531566, 552089, 501177, 687484, 551916, 609813, 387905, 437592, 462930, 469145, 543599, 572273, 622373, 569132, 591289, 519590, 543597, 526545, 488132, 666784, 523423, 520746, 414729, 458925, 467195, 619082, 597227, 584713, 569098, 604890, 564864, 602801, 510858, 680216, 500299, 341596, 533978, 516763, 495647, 519591, 482727, 529392, 512939, 589524, 589290, 603539, 522794, 567522, 478596, 569030, 486446, 432929, 582179, 675471, 516711, 506612, 488751, 588244, 608431, 571244, 516727, 583989, 591065, 541770, 512941, 609953, 541647, 562825, 576726, 531155, 508150, 665328);

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
  341596
  387905
  414729
  432929
  437592
  458925
  462930
  467195
  469145
  478367
  478596
  482727
  486446
  486688
  488132
  488751
  495647
  500299
  501177
  506612
  508150
  510858
  512939
  512941
  513656
  516711
  516727
  516763
  519590
  519591
  519765
  520746
  522794
  523423
  525662
  526030
  526545
  528447
  529392
  531155
  531566
  533978
  541647
  541770
  543597
  543599
  551916
  552089
  558581
  562825
  564864
  567522
  569030
  569098
  569131
  569132
  571244
  572273
  576726
  582179
  583989
  584713
  588244
  589290
  589524
  591065
  591289
  597227
  602801
  603539
  604890
  606286
  606774
  608431
  609813
  609953
  610607
  619082
  622373
  652915
  665328
  666784
  675471
  680216
  687484
  689379
]

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 (341596, 387905, 414729, 432929, 437592, 458925, 462930, 467195, 469145, 478367, 478596, 482727, 486446, 486688, 488132, 488751, 495647, 500299, 501177, 506612, 508150, 510858, 512939, 512941, 513656, 516711, 516727, 516763, 519590, 519591, 519765, 520746, 522794, 523423, 525662, 526030, 526545, 528447, 529392, 531155, 531566, 533978, 541647, 541770, 543597, 543599, 551916, 552089, 558581, 562825, 564864, 567522, 569030, 569098, 569131, 569132, 571244, 572273, 576726, 582179, 583989, 584713, 588244, 589290, 589524, 591065, 591289, 597227, 602801, 603539, 604890, 606286, 606774, 608431, 609813, 609953, 610607, 619082, 622373, 652915, 665328, 666784, 675471, 680216, 687484, 689379);

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
  341596
  387905
  414729
  432929
  437592
  458925
  462930
  467195
  469145
  478367
  478596
  482727
  486446
  486688
  488132
  488751
  495647
  500299
  501177
  506612
  508150
  510858
  512939
  512941
  513656
  516711
  516727
  516763
  519590
  519591
  519765
  520746
  522794
  523423
  525662
  526030
  526545
  528447
  529392
  531155
  531566
  533978
  541647
  541770
  543597
  543599
  551916
  552089
  558581
  562825
  564864
  567522
  569030
  569098
  569131
  569132
  571244
  572273
  576726
  582179
  583989
  584713
  588244
  589290
  589524
  591065
  591289
  597227
  602801
  603539
  604890
  606286
  606774
  608431
  609813
  609953
  610607
  619082
  622373
  652915
  665328
  666784
  675471
  680216
  687484
  689379
]

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 (341596, 387905, 414729, 432929, 437592, 458925, 462930, 467195, 469145, 478367, 478596, 482727, 486446, 486688, 488132, 488751, 495647, 500299, 501177, 506612, 508150, 510858, 512939, 512941, 513656, 516711, 516727, 516763, 519590, 519591, 519765, 520746, 522794, 523423, 525662, 526030, 526545, 528447, 529392, 531155, 531566, 533978, 541647, 541770, 543597, 543599, 551916, 552089, 558581, 562825, 564864, 567522, 569030, 569098, 569131, 569132, 571244, 572273, 576726, 582179, 583989, 584713, 588244, 589290, 589524, 591065, 591289, 597227, 602801, 603539, 604890, 606286, 606774, 608431, 609813, 609953, 610607, 619082, 622373, 652915, 665328, 666784, 675471, 680216, 687484, 689379);

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` = 'секс в сапог';