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
  557022
  602463
  523021
  565788
  486765
  579876
  544640
  620726
  609297
  546960
  589232
  625487
  551268
  593577
  598271
  624953
  539292
  660060
  626887
  527091
  496872
  500726
  545384
  571455
  618861
  620230
  604352
  493193
  471316
  485057
  496397
  497907
  519698
  544128
  562855
  595699
  522238
  522768
  540988
  616152
  571618
  482768
  518747
  542862
  596551
  587939
  476520
  569204
  597866
  584907
  461303
  598915
  509678
  548254
  613401
  584870
  529567
  614975
  514800
  565653
  586386
  444660
  440632
  485155
  554440
  622255
  578411
  527431
  561304
  584887
  604364
  678800
  643377
  567837
  602991
  486871
  615382
]

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 (557022, 602463, 523021, 565788, 486765, 579876, 544640, 620726, 609297, 546960, 589232, 625487, 551268, 593577, 598271, 624953, 539292, 660060, 626887, 527091, 496872, 500726, 545384, 571455, 618861, 620230, 604352, 493193, 471316, 485057, 496397, 497907, 519698, 544128, 562855, 595699, 522238, 522768, 540988, 616152, 571618, 482768, 518747, 542862, 596551, 587939, 476520, 569204, 597866, 584907, 461303, 598915, 509678, 548254, 613401, 584870, 529567, 614975, 514800, 565653, 586386, 444660, 440632, 485155, 554440, 622255, 578411, 527431, 561304, 584887, 604364, 678800, 643377, 567837, 602991, 486871, 615382);

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
  440632
  444660
  461303
  471316
  476520
  482768
  485057
  485155
  486765
  486871
  493193
  496397
  496872
  497907
  500726
  509678
  514800
  518747
  519698
  522238
  522768
  523021
  527091
  527431
  529567
  539292
  540988
  542862
  544128
  544640
  545384
  546960
  548254
  551268
  554440
  557022
  561304
  562855
  565653
  565788
  567837
  569204
  571455
  571618
  578411
  579876
  584870
  584887
  584907
  586386
  587939
  589232
  593577
  595699
  596551
  597866
  598271
  598915
  602463
  602991
  604352
  604364
  609297
  613401
  614975
  615382
  616152
  618861
  620230
  620726
  622255
  624953
  625487
  626887
  643377
  660060
  678800
]

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 (440632, 444660, 461303, 471316, 476520, 482768, 485057, 485155, 486765, 486871, 493193, 496397, 496872, 497907, 500726, 509678, 514800, 518747, 519698, 522238, 522768, 523021, 527091, 527431, 529567, 539292, 540988, 542862, 544128, 544640, 545384, 546960, 548254, 551268, 554440, 557022, 561304, 562855, 565653, 565788, 567837, 569204, 571455, 571618, 578411, 579876, 584870, 584887, 584907, 586386, 587939, 589232, 593577, 595699, 596551, 597866, 598271, 598915, 602463, 602991, 604352, 604364, 609297, 613401, 614975, 615382, 616152, 618861, 620230, 620726, 622255, 624953, 625487, 626887, 643377, 660060, 678800);

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
  440632
  444660
  461303
  471316
  476520
  482768
  485057
  485155
  486765
  486871
  493193
  496397
  496872
  497907
  500726
  509678
  514800
  518747
  519698
  522238
  522768
  523021
  527091
  527431
  529567
  539292
  540988
  542862
  544128
  544640
  545384
  546960
  548254
  551268
  554440
  557022
  561304
  562855
  565653
  565788
  567837
  569204
  571455
  571618
  578411
  579876
  584870
  584887
  584907
  586386
  587939
  589232
  593577
  595699
  596551
  597866
  598271
  598915
  602463
  602991
  604352
  604364
  609297
  613401
  614975
  615382
  616152
  618861
  620230
  620726
  622255
  624953
  625487
  626887
  643377
  660060
  678800
]

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 (440632, 444660, 461303, 471316, 476520, 482768, 485057, 485155, 486765, 486871, 493193, 496397, 496872, 497907, 500726, 509678, 514800, 518747, 519698, 522238, 522768, 523021, 527091, 527431, 529567, 539292, 540988, 542862, 544128, 544640, 545384, 546960, 548254, 551268, 554440, 557022, 561304, 562855, 565653, 565788, 567837, 569204, 571455, 571618, 578411, 579876, 584870, 584887, 584907, 586386, 587939, 589232, 593577, 595699, 596551, 597866, 598271, 598915, 602463, 602991, 604352, 604364, 609297, 613401, 614975, 615382, 616152, 618861, 620230, 620726, 622255, 624953, 625487, 626887, 643377, 660060, 678800);

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` = 'вход в домашн любительск';