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

[
  "18 лед"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = '18 лед' 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
  615883
  737124
  404913
  385302
  144343
  213604
  585111
  540396
  541333
  672618
  769103
  789932
  432497
  88788
  385563
  448885
  666886
  667636
  667498
  684567
  614628
  782790
  781653
  788852
  745125
  791012
  390144
  575905
  628653
  512180
  539252
  575276
  693967
  480190
  385680
  413126
  534216
  531127
  669410
  668508
  696945
  626032
  632586
  797799
  187903
  414138
  720938
  531489
  519886
  579669
  390634
  382825
  586520
  534650
  497873
  510402
  511240
  536292
  676080
  634189
  642060
  531512
  630766
  506599
  558990
  550748
  596417
  606349
  606578
  651089
  472721
  531431
  678089
  635487
  631163
  513882
  505655
  530513
  531413
  609105
  556830
  598031
  629882
  620674
  520803
]

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 (615883, 737124, 404913, 385302, 144343, 213604, 585111, 540396, 541333, 672618, 769103, 789932, 432497, 88788, 385563, 448885, 666886, 667636, 667498, 684567, 614628, 782790, 781653, 788852, 745125, 791012, 390144, 575905, 628653, 512180, 539252, 575276, 693967, 480190, 385680, 413126, 534216, 531127, 669410, 668508, 696945, 626032, 632586, 797799, 187903, 414138, 720938, 531489, 519886, 579669, 390634, 382825, 586520, 534650, 497873, 510402, 511240, 536292, 676080, 634189, 642060, 531512, 630766, 506599, 558990, 550748, 596417, 606349, 606578, 651089, 472721, 531431, 678089, 635487, 631163, 513882, 505655, 530513, 531413, 609105, 556830, 598031, 629882, 620674, 520803);

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
  88788
  144343
  187903
  213604
  382825
  385302
  385563
  385680
  390144
  390634
  404913
  413126
  414138
  432497
  448885
  472721
  480190
  497873
  505655
  506599
  510402
  511240
  512180
  513882
  519886
  520803
  530513
  531127
  531413
  531431
  531489
  531512
  534216
  534650
  536292
  539252
  540396
  541333
  550748
  556830
  558990
  575276
  575905
  579669
  585111
  586520
  596417
  598031
  606349
  606578
  609105
  614628
  615883
  620674
  626032
  628653
  629882
  630766
  631163
  632586
  634189
  635487
  642060
  651089
  666886
  667498
  667636
  668508
  669410
  672618
  676080
  678089
  684567
  693967
  696945
  720938
  737124
  745125
  781653
  782790
  788852
  789932
  791012
  797799
]

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 (88788, 144343, 187903, 213604, 382825, 385302, 385563, 385680, 390144, 390634, 404913, 413126, 414138, 432497, 448885, 472721, 480190, 497873, 505655, 506599, 510402, 511240, 512180, 513882, 519886, 520803, 530513, 531127, 531413, 531431, 531489, 531512, 534216, 534650, 536292, 539252, 540396, 541333, 550748, 556830, 558990, 575276, 575905, 579669, 585111, 586520, 596417, 598031, 606349, 606578, 609105, 614628, 615883, 620674, 626032, 628653, 629882, 630766, 631163, 632586, 634189, 635487, 642060, 651089, 666886, 667498, 667636, 668508, 669410, 672618, 676080, 678089, 684567, 693967, 696945, 720938, 737124, 745125, 781653, 782790, 788852, 789932, 791012, 797799);

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
  88788
  144343
  187903
  213604
  382825
  385302
  385563
  385680
  390144
  390634
  404913
  413126
  414138
  432497
  448885
  472721
  480190
  497873
  505655
  506599
  510402
  511240
  512180
  513882
  519886
  520803
  530513
  531127
  531413
  531431
  531489
  531512
  534216
  534650
  536292
  539252
  540396
  541333
  550748
  556830
  558990
  575276
  575905
  579669
  585111
  586520
  596417
  598031
  606349
  606578
  609105
  614628
  615883
  620674
  626032
  628653
  629882
  630766
  631163
  632586
  634189
  635487
  642060
  651089
  666886
  667498
  667636
  668508
  669410
  672618
  676080
  678089
  684567
  693967
  696945
  720938
  737124
  745125
  781653
  782790
  788852
  789932
  791012
  797799
]

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 (88788, 144343, 187903, 213604, 382825, 385302, 385563, 385680, 390144, 390634, 404913, 413126, 414138, 432497, 448885, 472721, 480190, 497873, 505655, 506599, 510402, 511240, 512180, 513882, 519886, 520803, 530513, 531127, 531413, 531431, 531489, 531512, 534216, 534650, 536292, 539252, 540396, 541333, 550748, 556830, 558990, 575276, 575905, 579669, 585111, 586520, 596417, 598031, 606349, 606578, 609105, 614628, 615883, 620674, 626032, 628653, 629882, 630766, 631163, 632586, 634189, 635487, 642060, 651089, 666886, 667498, 667636, 668508, 669410, 672618, 676080, 678089, 684567, 693967, 696945, 720938, 737124, 745125, 781653, 782790, 788852, 789932, 791012, 797799);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "18 лед"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = '18 лед';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "18 лед"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = '18 лед';