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

[
  "hidden mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'hidden mom' LIMIT 1;

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

[
  b"\x01“´l\x19ˆr\x08¶_%\x14Ë=Áƒ"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193B46C19887208B65F2514CB3DC183 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
  698933
  698312
  617153
  585744
  702850
  498030
  547993
  575289
  594108
  640677
  782993
  397068
  455222
  526979
  590282
  768586
  424240
  526718
  447677
  467293
  494778
  498039
  438009
  486820
  553277
  555432
  669200
  684308
  650422
  793543
  797646
  520311
  578326
  481507
  492472
  484519
  491955
  504610
  428073
  432650
  474783
  490744
  472656
  488514
  459398
  531493
  474782
  638578
  807529
  806435
  409083
  563513
  516445
  426616
  458438
  511030
  531473
  531424
  572767
  643072
  496119
  493391
  483401
  545779
  559223
  572712
  576192
  750611
  474777
  449246
  483502
  606837
  464395
  587257
  402985
  586484
  809930
  568610
  515579
  542187
]

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 (698933, 698312, 617153, 585744, 702850, 498030, 547993, 575289, 594108, 640677, 782993, 397068, 455222, 526979, 590282, 768586, 424240, 526718, 447677, 467293, 494778, 498039, 438009, 486820, 553277, 555432, 669200, 684308, 650422, 793543, 797646, 520311, 578326, 481507, 492472, 484519, 491955, 504610, 428073, 432650, 474783, 490744, 472656, 488514, 459398, 531493, 474782, 638578, 807529, 806435, 409083, 563513, 516445, 426616, 458438, 511030, 531473, 531424, 572767, 643072, 496119, 493391, 483401, 545779, 559223, 572712, 576192, 750611, 474777, 449246, 483502, 606837, 464395, 587257, 402985, 586484, 809930, 568610, 515579, 542187);

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
  397068
  402985
  409083
  424240
  426616
  428073
  432650
  438009
  447677
  449246
  455222
  458438
  459398
  464395
  467293
  472656
  474777
  474782
  474783
  481507
  483401
  483502
  484519
  486820
  488514
  490744
  491955
  492472
  493391
  494778
  496119
  498030
  498039
  504610
  511030
  515579
  516445
  520311
  526718
  526979
  531424
  531473
  531493
  542187
  545779
  547993
  553277
  555432
  559223
  563513
  568610
  572712
  572767
  575289
  576192
  578326
  585744
  586484
  587257
  590282
  594108
  606837
  617153
  638578
  640677
  643072
  650422
  669200
  684308
  698312
  698933
  702850
  750611
  768586
  782993
  793543
  797646
  806435
  807529
  809930
]

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 (397068, 402985, 409083, 424240, 426616, 428073, 432650, 438009, 447677, 449246, 455222, 458438, 459398, 464395, 467293, 472656, 474777, 474782, 474783, 481507, 483401, 483502, 484519, 486820, 488514, 490744, 491955, 492472, 493391, 494778, 496119, 498030, 498039, 504610, 511030, 515579, 516445, 520311, 526718, 526979, 531424, 531473, 531493, 542187, 545779, 547993, 553277, 555432, 559223, 563513, 568610, 572712, 572767, 575289, 576192, 578326, 585744, 586484, 587257, 590282, 594108, 606837, 617153, 638578, 640677, 643072, 650422, 669200, 684308, 698312, 698933, 702850, 750611, 768586, 782993, 793543, 797646, 806435, 807529, 809930);

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
  397068
  402985
  409083
  424240
  426616
  428073
  432650
  438009
  447677
  449246
  455222
  458438
  459398
  464395
  467293
  472656
  474777
  474782
  474783
  481507
  483401
  483502
  484519
  486820
  488514
  490744
  491955
  492472
  493391
  494778
  496119
  498030
  498039
  504610
  511030
  515579
  516445
  520311
  526718
  526979
  531424
  531473
  531493
  542187
  545779
  547993
  553277
  555432
  559223
  563513
  568610
  572712
  572767
  575289
  576192
  578326
  585744
  586484
  587257
  590282
  594108
  606837
  617153
  638578
  640677
  643072
  650422
  669200
  684308
  698312
  698933
  702850
  750611
  768586
  782993
  793543
  797646
  806435
  807529
  809930
]

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 (397068, 402985, 409083, 424240, 426616, 428073, 432650, 438009, 447677, 449246, 455222, 458438, 459398, 464395, 467293, 472656, 474777, 474782, 474783, 481507, 483401, 483502, 484519, 486820, 488514, 490744, 491955, 492472, 493391, 494778, 496119, 498030, 498039, 504610, 511030, 515579, 516445, 520311, 526718, 526979, 531424, 531473, 531493, 542187, 545779, 547993, 553277, 555432, 559223, 563513, 568610, 572712, 572767, 575289, 576192, 578326, 585744, 586484, 587257, 590282, 594108, 606837, 617153, 638578, 640677, 643072, 650422, 669200, 684308, 698312, 698933, 702850, 750611, 768586, 782993, 793543, 797646, 806435, 807529, 809930);

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

[
  "скрыт mom"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'скрыт mom';

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

[
  "скрыт mom"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'скрыт mom';