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 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01”\x07¡äÙsZ¨@P\x16V+|\x7F"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019407A1E4D9735AA8405016562B7C7F 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
  573365
  603551
  483412
  471664
  463216
  453183
  518587
  480293
  508736
  574416
  466813
  561615
  660029
  778949
  555007
  633312
  543612
  534674
  525652
  543603
  543615
  804765
  463984
  565353
  592738
  512880
  555434
  669233
  610582
  588033
  459176
  525662
  485463
  526885
  520983
  439488
  518771
  543255
  525626
  543599
  486901
  631937
  619802
  551111
  524510
  487470
  662801
  534676
  548231
  592457
  508375
  606202
  474561
  522910
  654671
  423094
  453070
  585958
  484628
  401203
  471442
  442869
  453095
  496615
  444111
  650813
  484161
  453076
  546125
  615800
  464326
  606533
  614743
  504120
  525492
  584125
  614273
  585725
]

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 (573365, 603551, 483412, 471664, 463216, 453183, 518587, 480293, 508736, 574416, 466813, 561615, 660029, 778949, 555007, 633312, 543612, 534674, 525652, 543603, 543615, 804765, 463984, 565353, 592738, 512880, 555434, 669233, 610582, 588033, 459176, 525662, 485463, 526885, 520983, 439488, 518771, 543255, 525626, 543599, 486901, 631937, 619802, 551111, 524510, 487470, 662801, 534676, 548231, 592457, 508375, 606202, 474561, 522910, 654671, 423094, 453070, 585958, 484628, 401203, 471442, 442869, 453095, 496615, 444111, 650813, 484161, 453076, 546125, 615800, 464326, 606533, 614743, 504120, 525492, 584125, 614273, 585725);

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
  401203
  423094
  439488
  442869
  444111
  453070
  453076
  453095
  453183
  459176
  463216
  463984
  464326
  466813
  471442
  471664
  474561
  480293
  483412
  484161
  484628
  485463
  486901
  487470
  496615
  504120
  508375
  508736
  512880
  518587
  518771
  520983
  522910
  524510
  525492
  525626
  525652
  525662
  526885
  534674
  534676
  543255
  543599
  543603
  543612
  543615
  546125
  548231
  551111
  555007
  555434
  561615
  565353
  573365
  574416
  584125
  585725
  585958
  588033
  592457
  592738
  603551
  606202
  606533
  610582
  614273
  614743
  615800
  619802
  631937
  633312
  650813
  654671
  660029
  662801
  669233
  778949
  804765
]

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 (401203, 423094, 439488, 442869, 444111, 453070, 453076, 453095, 453183, 459176, 463216, 463984, 464326, 466813, 471442, 471664, 474561, 480293, 483412, 484161, 484628, 485463, 486901, 487470, 496615, 504120, 508375, 508736, 512880, 518587, 518771, 520983, 522910, 524510, 525492, 525626, 525652, 525662, 526885, 534674, 534676, 543255, 543599, 543603, 543612, 543615, 546125, 548231, 551111, 555007, 555434, 561615, 565353, 573365, 574416, 584125, 585725, 585958, 588033, 592457, 592738, 603551, 606202, 606533, 610582, 614273, 614743, 615800, 619802, 631937, 633312, 650813, 654671, 660029, 662801, 669233, 778949, 804765);

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
  401203
  423094
  439488
  442869
  444111
  453070
  453076
  453095
  453183
  459176
  463216
  463984
  464326
  466813
  471442
  471664
  474561
  480293
  483412
  484161
  484628
  485463
  486901
  487470
  496615
  504120
  508375
  508736
  512880
  518587
  518771
  520983
  522910
  524510
  525492
  525626
  525652
  525662
  526885
  534674
  534676
  543255
  543599
  543603
  543612
  543615
  546125
  548231
  551111
  555007
  555434
  561615
  565353
  573365
  574416
  584125
  585725
  585958
  588033
  592457
  592738
  603551
  606202
  606533
  610582
  614273
  614743
  615800
  619802
  631937
  633312
  650813
  654671
  660029
  662801
  669233
  778949
  804765
]

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 (401203, 423094, 439488, 442869, 444111, 453070, 453076, 453095, 453183, 459176, 463216, 463984, 464326, 466813, 471442, 471664, 474561, 480293, 483412, 484161, 484628, 485463, 486901, 487470, 496615, 504120, 508375, 508736, 512880, 518587, 518771, 520983, 522910, 524510, 525492, 525626, 525652, 525662, 526885, 534674, 534676, 543255, 543599, 543603, 543612, 543615, 546125, 548231, 551111, 555007, 555434, 561615, 565353, 573365, 574416, 584125, 585725, 585958, 588033, 592457, 592738, 603551, 606202, 606533, 610582, 614273, 614743, 615800, 619802, 631937, 633312, 650813, 654671, 660029, 662801, 669233, 778949, 804765);

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` = 'зрелая женщин в лес природ';