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
  567158
  585321
  805739
  458106
  484302
  428603
  399089
  432736
  479698
  413786
  455611
  360065
  597117
  427217
  460689
  510257
  467642
  410366
  466493
  578898
  426290
  452475
  455156
  489361
  478568
  477084
  513005
  436118
  620499
  527447
  460501
  400684
  411477
  465224
  465169
  496314
  520405
  458971
  421289
  490132
  465698
  466858
  516655
  460327
  422732
  435515
  452283
  487747
  486214
  456981
  449933
  433047
  499336
  14534
  524859
  464194
  458625
  468035
  450224
  529360
  452282
  499332
  419862
  588285
  584720
  420695
  450204
  456109
  567141
  467583
  568059
  582376
  567139
  584754
  471723
  536910
  507944
  535013
  545828
  612792
  543881
  605545
  621612
  451983
  603875
]

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 (567158, 585321, 805739, 458106, 484302, 428603, 399089, 432736, 479698, 413786, 455611, 360065, 597117, 427217, 460689, 510257, 467642, 410366, 466493, 578898, 426290, 452475, 455156, 489361, 478568, 477084, 513005, 436118, 620499, 527447, 460501, 400684, 411477, 465224, 465169, 496314, 520405, 458971, 421289, 490132, 465698, 466858, 516655, 460327, 422732, 435515, 452283, 487747, 486214, 456981, 449933, 433047, 499336, 14534, 524859, 464194, 458625, 468035, 450224, 529360, 452282, 499332, 419862, 588285, 584720, 420695, 450204, 456109, 567141, 467583, 568059, 582376, 567139, 584754, 471723, 536910, 507944, 535013, 545828, 612792, 543881, 605545, 621612, 451983, 603875);

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
  14534
  360065
  399089
  400684
  410366
  411477
  413786
  419862
  420695
  421289
  422732
  426290
  427217
  428603
  432736
  433047
  435515
  436118
  449933
  450204
  450224
  451983
  452282
  452283
  452475
  455156
  455611
  456109
  456981
  458106
  458625
  458971
  460327
  460501
  460689
  464194
  465169
  465224
  465698
  466493
  466858
  467583
  467642
  468035
  471723
  477084
  478568
  479698
  484302
  486214
  487747
  489361
  490132
  496314
  499332
  499336
  507944
  510257
  513005
  516655
  520405
  524859
  527447
  529360
  535013
  536910
  543881
  545828
  567139
  567141
  567158
  568059
  578898
  582376
  584720
  584754
  585321
  588285
  597117
  603875
  605545
  612792
  620499
  621612
  805739
]

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 (14534, 360065, 399089, 400684, 410366, 411477, 413786, 419862, 420695, 421289, 422732, 426290, 427217, 428603, 432736, 433047, 435515, 436118, 449933, 450204, 450224, 451983, 452282, 452283, 452475, 455156, 455611, 456109, 456981, 458106, 458625, 458971, 460327, 460501, 460689, 464194, 465169, 465224, 465698, 466493, 466858, 467583, 467642, 468035, 471723, 477084, 478568, 479698, 484302, 486214, 487747, 489361, 490132, 496314, 499332, 499336, 507944, 510257, 513005, 516655, 520405, 524859, 527447, 529360, 535013, 536910, 543881, 545828, 567139, 567141, 567158, 568059, 578898, 582376, 584720, 584754, 585321, 588285, 597117, 603875, 605545, 612792, 620499, 621612, 805739);

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
  14534
  360065
  399089
  400684
  410366
  411477
  413786
  419862
  420695
  421289
  422732
  426290
  427217
  428603
  432736
  433047
  435515
  436118
  449933
  450204
  450224
  451983
  452282
  452283
  452475
  455156
  455611
  456109
  456981
  458106
  458625
  458971
  460327
  460501
  460689
  464194
  465169
  465224
  465698
  466493
  466858
  467583
  467642
  468035
  471723
  477084
  478568
  479698
  484302
  486214
  487747
  489361
  490132
  496314
  499332
  499336
  507944
  510257
  513005
  516655
  520405
  524859
  527447
  529360
  535013
  536910
  543881
  545828
  567139
  567141
  567158
  568059
  578898
  582376
  584720
  584754
  585321
  588285
  597117
  603875
  605545
  612792
  620499
  621612
  805739
]

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 (14534, 360065, 399089, 400684, 410366, 411477, 413786, 419862, 420695, 421289, 422732, 426290, 427217, 428603, 432736, 433047, 435515, 436118, 449933, 450204, 450224, 451983, 452282, 452283, 452475, 455156, 455611, 456109, 456981, 458106, 458625, 458971, 460327, 460501, 460689, 464194, 465169, 465224, 465698, 466493, 466858, 467583, 467642, 468035, 471723, 477084, 478568, 479698, 484302, 486214, 487747, 489361, 490132, 496314, 499332, 499336, 507944, 510257, 513005, 516655, 520405, 524859, 527447, 529360, 535013, 536910, 543881, 545828, 567139, 567141, 567158, 568059, 578898, 582376, 584720, 584754, 585321, 588285, 597117, 603875, 605545, 612792, 620499, 621612, 805739);

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` = 'жен чернокожий любительск';