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ö╗!\rñs ¢)t\tØj┌³"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0194BB210DA473FFBD2974099D6ADAFC 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
  617814
  632593
  792583
  803187
  467357
  517870
  522962
  493448
  463416
  501477
  535181
  566592
  544753
  545659
  549274
  582944
  674473
  714494
  549314
  578121
  604197
  782450
  775962
  496496
  409222
  531214
  536636
  583191
  543088
  562806
  566047
  629398
  626206
  642399
  587519
  595209
  623724
  473969
  496976
  531257
  537885
  532960
  536586
  516013
  531173
  536293
  537913
  528447
  485055
  557195
  709748
  583885
  585969
  588722
  530269
  525727
  540689
  676087
  666853
  600312
  536459
  532360
  536387
  526351
  541076
  544680
  545393
  628402
  647932
  647986
  578179
  631179
  455195
  467973
  522976
  483802
  543579
  632642
  617417
  518597
  513965
]

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 (617814, 632593, 792583, 803187, 467357, 517870, 522962, 493448, 463416, 501477, 535181, 566592, 544753, 545659, 549274, 582944, 674473, 714494, 549314, 578121, 604197, 782450, 775962, 496496, 409222, 531214, 536636, 583191, 543088, 562806, 566047, 629398, 626206, 642399, 587519, 595209, 623724, 473969, 496976, 531257, 537885, 532960, 536586, 516013, 531173, 536293, 537913, 528447, 485055, 557195, 709748, 583885, 585969, 588722, 530269, 525727, 540689, 676087, 666853, 600312, 536459, 532360, 536387, 526351, 541076, 544680, 545393, 628402, 647932, 647986, 578179, 631179, 455195, 467973, 522976, 483802, 543579, 632642, 617417, 518597, 513965);

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
  409222
  455195
  463416
  467357
  467973
  473969
  483802
  485055
  493448
  496496
  496976
  501477
  513965
  516013
  517870
  518597
  522962
  522976
  525727
  526351
  528447
  530269
  531173
  531214
  531257
  532360
  532960
  535181
  536293
  536387
  536459
  536586
  536636
  537885
  537913
  540689
  541076
  543088
  543579
  544680
  544753
  545393
  545659
  549274
  549314
  557195
  562806
  566047
  566592
  578121
  578179
  582944
  583191
  583885
  585969
  587519
  588722
  595209
  600312
  604197
  617417
  617814
  623724
  626206
  628402
  629398
  631179
  632593
  632642
  642399
  647932
  647986
  666853
  674473
  676087
  709748
  714494
  775962
  782450
  792583
  803187
]

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 (409222, 455195, 463416, 467357, 467973, 473969, 483802, 485055, 493448, 496496, 496976, 501477, 513965, 516013, 517870, 518597, 522962, 522976, 525727, 526351, 528447, 530269, 531173, 531214, 531257, 532360, 532960, 535181, 536293, 536387, 536459, 536586, 536636, 537885, 537913, 540689, 541076, 543088, 543579, 544680, 544753, 545393, 545659, 549274, 549314, 557195, 562806, 566047, 566592, 578121, 578179, 582944, 583191, 583885, 585969, 587519, 588722, 595209, 600312, 604197, 617417, 617814, 623724, 626206, 628402, 629398, 631179, 632593, 632642, 642399, 647932, 647986, 666853, 674473, 676087, 709748, 714494, 775962, 782450, 792583, 803187);

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
  409222
  455195
  463416
  467357
  467973
  473969
  483802
  485055
  493448
  496496
  496976
  501477
  513965
  516013
  517870
  518597
  522962
  522976
  525727
  526351
  528447
  530269
  531173
  531214
  531257
  532360
  532960
  535181
  536293
  536387
  536459
  536586
  536636
  537885
  537913
  540689
  541076
  543088
  543579
  544680
  544753
  545393
  545659
  549274
  549314
  557195
  562806
  566047
  566592
  578121
  578179
  582944
  583191
  583885
  585969
  587519
  588722
  595209
  600312
  604197
  617417
  617814
  623724
  626206
  628402
  629398
  631179
  632593
  632642
  642399
  647932
  647986
  666853
  674473
  676087
  709748
  714494
  775962
  782450
  792583
  803187
]

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 (409222, 455195, 463416, 467357, 467973, 473969, 483802, 485055, 493448, 496496, 496976, 501477, 513965, 516013, 517870, 518597, 522962, 522976, 525727, 526351, 528447, 530269, 531173, 531214, 531257, 532360, 532960, 535181, 536293, 536387, 536459, 536586, 536636, 537885, 537913, 540689, 541076, 543088, 543579, 544680, 544753, 545393, 545659, 549274, 549314, 557195, 562806, 566047, 566592, 578121, 578179, 582944, 583191, 583885, 585969, 587519, 588722, 595209, 600312, 604197, 617417, 617814, 623724, 626206, 628402, 629398, 631179, 632593, 632642, 642399, 647932, 647986, 666853, 674473, 676087, 709748, 714494, 775962, 782450, 792583, 803187);

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` = 'нимфоманк';