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“yÔ„Np ƒÁ+ÿ\x0E\x19S2"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019379D4844E702083C12BFF0E195332 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
  517212
  519735
  525317
  493174
  493189
  499212
  524736
  527168
  500365
  502809
  432674
  453866
  515663
  498431
  518369
  562869
  541757
  558216
  612904
  809153
  743065
  749981
  793608
  466367
  470019
  477236
  459705
  472439
  506051
  522294
  497240
  501426
  510612
  525241
  530478
  493194
  506196
  509174
  442501
  453161
  492531
  448175
  533623
  524235
  558515
  437632
  470762
  528592
  494181
  526118
  484705
  488030
  497286
  533610
  484485
  460734
  466103
  441645
  518858
  525277
  654312
  586616
  523260
  617117
  526211
  553031
  601903
  612099
  619107
  521135
  620098
  598080
  446376
  614745
  594121
]

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 (517212, 519735, 525317, 493174, 493189, 499212, 524736, 527168, 500365, 502809, 432674, 453866, 515663, 498431, 518369, 562869, 541757, 558216, 612904, 809153, 743065, 749981, 793608, 466367, 470019, 477236, 459705, 472439, 506051, 522294, 497240, 501426, 510612, 525241, 530478, 493194, 506196, 509174, 442501, 453161, 492531, 448175, 533623, 524235, 558515, 437632, 470762, 528592, 494181, 526118, 484705, 488030, 497286, 533610, 484485, 460734, 466103, 441645, 518858, 525277, 654312, 586616, 523260, 617117, 526211, 553031, 601903, 612099, 619107, 521135, 620098, 598080, 446376, 614745, 594121);

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
  432674
  437632
  441645
  442501
  446376
  448175
  453161
  453866
  459705
  460734
  466103
  466367
  470019
  470762
  472439
  477236
  484485
  484705
  488030
  492531
  493174
  493189
  493194
  494181
  497240
  497286
  498431
  499212
  500365
  501426
  502809
  506051
  506196
  509174
  510612
  515663
  517212
  518369
  518858
  519735
  521135
  522294
  523260
  524235
  524736
  525241
  525277
  525317
  526118
  526211
  527168
  528592
  530478
  533610
  533623
  541757
  553031
  558216
  558515
  562869
  586616
  594121
  598080
  601903
  612099
  612904
  614745
  617117
  619107
  620098
  654312
  743065
  749981
  793608
  809153
]

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 (432674, 437632, 441645, 442501, 446376, 448175, 453161, 453866, 459705, 460734, 466103, 466367, 470019, 470762, 472439, 477236, 484485, 484705, 488030, 492531, 493174, 493189, 493194, 494181, 497240, 497286, 498431, 499212, 500365, 501426, 502809, 506051, 506196, 509174, 510612, 515663, 517212, 518369, 518858, 519735, 521135, 522294, 523260, 524235, 524736, 525241, 525277, 525317, 526118, 526211, 527168, 528592, 530478, 533610, 533623, 541757, 553031, 558216, 558515, 562869, 586616, 594121, 598080, 601903, 612099, 612904, 614745, 617117, 619107, 620098, 654312, 743065, 749981, 793608, 809153);

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
  432674
  437632
  441645
  442501
  446376
  448175
  453161
  453866
  459705
  460734
  466103
  466367
  470019
  470762
  472439
  477236
  484485
  484705
  488030
  492531
  493174
  493189
  493194
  494181
  497240
  497286
  498431
  499212
  500365
  501426
  502809
  506051
  506196
  509174
  510612
  515663
  517212
  518369
  518858
  519735
  521135
  522294
  523260
  524235
  524736
  525241
  525277
  525317
  526118
  526211
  527168
  528592
  530478
  533610
  533623
  541757
  553031
  558216
  558515
  562869
  586616
  594121
  598080
  601903
  612099
  612904
  614745
  617117
  619107
  620098
  654312
  743065
  749981
  793608
  809153
]

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 (432674, 437632, 441645, 442501, 446376, 448175, 453161, 453866, 459705, 460734, 466103, 466367, 470019, 470762, 472439, 477236, 484485, 484705, 488030, 492531, 493174, 493189, 493194, 494181, 497240, 497286, 498431, 499212, 500365, 501426, 502809, 506051, 506196, 509174, 510612, 515663, 517212, 518369, 518858, 519735, 521135, 522294, 523260, 524235, 524736, 525241, 525277, 525317, 526118, 526211, 527168, 528592, 530478, 533610, 533623, 541757, 553031, 558216, 558515, 562869, 586616, 594121, 598080, 601903, 612099, 612904, 614745, 617117, 619107, 620098, 654312, 743065, 749981, 793608, 809153);

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` = 'буд';