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
  666886
  672408
  594100
  626216
  606793
  614781
  784729
  792531
  758428
  761047
  619531
  717944
  464696
  524097
  526222
  536385
  531063
  566075
  558008
  563034
  573873
  662390
  706909
  678943
  716307
  713065
  565778
  580663
  591995
  629421
  603977
  612478
  600686
  635974
  601237
  775784
  732905
  728446
  756506
  736605
  740226
  627095
  810297
  463319
  491061
  534769
  578323
  565149
  567696
  564776
  579483
  673655
  598877
  621683
  643100
  628116
  777443
  524999
  460588
  467459
  517571
  518918
  552267
  681833
  714475
  650830
  605576
  635222
  639809
  699536
  714457
  506142
  534274
  580326
  662000
  673659
  648132
  678962
  625950
  789769
  609803
  679032
  642063
  562007
  617198
]

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 (666886, 672408, 594100, 626216, 606793, 614781, 784729, 792531, 758428, 761047, 619531, 717944, 464696, 524097, 526222, 536385, 531063, 566075, 558008, 563034, 573873, 662390, 706909, 678943, 716307, 713065, 565778, 580663, 591995, 629421, 603977, 612478, 600686, 635974, 601237, 775784, 732905, 728446, 756506, 736605, 740226, 627095, 810297, 463319, 491061, 534769, 578323, 565149, 567696, 564776, 579483, 673655, 598877, 621683, 643100, 628116, 777443, 524999, 460588, 467459, 517571, 518918, 552267, 681833, 714475, 650830, 605576, 635222, 639809, 699536, 714457, 506142, 534274, 580326, 662000, 673659, 648132, 678962, 625950, 789769, 609803, 679032, 642063, 562007, 617198);

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
  460588
  463319
  464696
  467459
  491061
  506142
  517571
  518918
  524097
  524999
  526222
  531063
  534274
  534769
  536385
  552267
  558008
  562007
  563034
  564776
  565149
  565778
  566075
  567696
  573873
  578323
  579483
  580326
  580663
  591995
  594100
  598877
  600686
  601237
  603977
  605576
  606793
  609803
  612478
  614781
  617198
  619531
  621683
  625950
  626216
  627095
  628116
  629421
  635222
  635974
  639809
  642063
  643100
  648132
  650830
  662000
  662390
  666886
  672408
  673655
  673659
  678943
  678962
  679032
  681833
  699536
  706909
  713065
  714457
  714475
  716307
  717944
  728446
  732905
  736605
  740226
  756506
  758428
  761047
  775784
  777443
  784729
  789769
  792531
  810297
]

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 (460588, 463319, 464696, 467459, 491061, 506142, 517571, 518918, 524097, 524999, 526222, 531063, 534274, 534769, 536385, 552267, 558008, 562007, 563034, 564776, 565149, 565778, 566075, 567696, 573873, 578323, 579483, 580326, 580663, 591995, 594100, 598877, 600686, 601237, 603977, 605576, 606793, 609803, 612478, 614781, 617198, 619531, 621683, 625950, 626216, 627095, 628116, 629421, 635222, 635974, 639809, 642063, 643100, 648132, 650830, 662000, 662390, 666886, 672408, 673655, 673659, 678943, 678962, 679032, 681833, 699536, 706909, 713065, 714457, 714475, 716307, 717944, 728446, 732905, 736605, 740226, 756506, 758428, 761047, 775784, 777443, 784729, 789769, 792531, 810297);

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
  460588
  463319
  464696
  467459
  491061
  506142
  517571
  518918
  524097
  524999
  526222
  531063
  534274
  534769
  536385
  552267
  558008
  562007
  563034
  564776
  565149
  565778
  566075
  567696
  573873
  578323
  579483
  580326
  580663
  591995
  594100
  598877
  600686
  601237
  603977
  605576
  606793
  609803
  612478
  614781
  617198
  619531
  621683
  625950
  626216
  627095
  628116
  629421
  635222
  635974
  639809
  642063
  643100
  648132
  650830
  662000
  662390
  666886
  672408
  673655
  673659
  678943
  678962
  679032
  681833
  699536
  706909
  713065
  714457
  714475
  716307
  717944
  728446
  732905
  736605
  740226
  756506
  758428
  761047
  775784
  777443
  784729
  789769
  792531
  810297
]

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 (460588, 463319, 464696, 467459, 491061, 506142, 517571, 518918, 524097, 524999, 526222, 531063, 534274, 534769, 536385, 552267, 558008, 562007, 563034, 564776, 565149, 565778, 566075, 567696, 573873, 578323, 579483, 580326, 580663, 591995, 594100, 598877, 600686, 601237, 603977, 605576, 606793, 609803, 612478, 614781, 617198, 619531, 621683, 625950, 626216, 627095, 628116, 629421, 635222, 635974, 639809, 642063, 643100, 648132, 650830, 662000, 662390, 666886, 672408, 673655, 673659, 678943, 678962, 679032, 681833, 699536, 706909, 713065, 714457, 714475, 716307, 717944, 728446, 732905, 736605, 740226, 756506, 758428, 761047, 775784, 777443, 784729, 789769, 792531, 810297);

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` = 'виде урок';