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
  463721
  427447
  494432
  448769
  619475
  564598
  597244
  469576
  529855
  529849
  630280
  815275
  523222
  472488
  647980
  603199
  761585
  465208
  528307
  534077
  590859
  471667
  530017
  422633
  624510
  520540
  601125
  392423
  401924
  491248
  468705
  554434
  571812
  422996
  683237
  422933
  544753
  559158
  680130
  528356
  430828
  473372
  541084
  558201
  567354
  630533
  639783
  595121
  713551
  597246
  469200
  422694
  454812
  546786
  628170
  604492
  541879
  614401
  394103
  614993
  636247
  606493
  475443
  427174
  544366
  651209
  472567
  520424
  448821
  530661
  530670
  537199
  544281
  582540
  538223
  721557
  522977
  600132
  532812
  650380
  637049
  542189
  540330
  548012
]

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 (463721, 427447, 494432, 448769, 619475, 564598, 597244, 469576, 529855, 529849, 630280, 815275, 523222, 472488, 647980, 603199, 761585, 465208, 528307, 534077, 590859, 471667, 530017, 422633, 624510, 520540, 601125, 392423, 401924, 491248, 468705, 554434, 571812, 422996, 683237, 422933, 544753, 559158, 680130, 528356, 430828, 473372, 541084, 558201, 567354, 630533, 639783, 595121, 713551, 597246, 469200, 422694, 454812, 546786, 628170, 604492, 541879, 614401, 394103, 614993, 636247, 606493, 475443, 427174, 544366, 651209, 472567, 520424, 448821, 530661, 530670, 537199, 544281, 582540, 538223, 721557, 522977, 600132, 532812, 650380, 637049, 542189, 540330, 548012);

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
  392423
  394103
  401924
  422633
  422694
  422933
  422996
  427174
  427447
  430828
  448769
  448821
  454812
  463721
  465208
  468705
  469200
  469576
  471667
  472488
  472567
  473372
  475443
  491248
  494432
  520424
  520540
  522977
  523222
  528307
  528356
  529849
  529855
  530017
  530661
  530670
  532812
  534077
  537199
  538223
  540330
  541084
  541879
  542189
  544281
  544366
  544753
  546786
  548012
  554434
  558201
  559158
  564598
  567354
  571812
  582540
  590859
  595121
  597244
  597246
  600132
  601125
  603199
  604492
  606493
  614401
  614993
  619475
  624510
  628170
  630280
  630533
  636247
  637049
  639783
  647980
  650380
  651209
  680130
  683237
  713551
  721557
  761585
  815275
]

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 (392423, 394103, 401924, 422633, 422694, 422933, 422996, 427174, 427447, 430828, 448769, 448821, 454812, 463721, 465208, 468705, 469200, 469576, 471667, 472488, 472567, 473372, 475443, 491248, 494432, 520424, 520540, 522977, 523222, 528307, 528356, 529849, 529855, 530017, 530661, 530670, 532812, 534077, 537199, 538223, 540330, 541084, 541879, 542189, 544281, 544366, 544753, 546786, 548012, 554434, 558201, 559158, 564598, 567354, 571812, 582540, 590859, 595121, 597244, 597246, 600132, 601125, 603199, 604492, 606493, 614401, 614993, 619475, 624510, 628170, 630280, 630533, 636247, 637049, 639783, 647980, 650380, 651209, 680130, 683237, 713551, 721557, 761585, 815275);

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
  392423
  394103
  401924
  422633
  422694
  422933
  422996
  427174
  427447
  430828
  448769
  448821
  454812
  463721
  465208
  468705
  469200
  469576
  471667
  472488
  472567
  473372
  475443
  491248
  494432
  520424
  520540
  522977
  523222
  528307
  528356
  529849
  529855
  530017
  530661
  530670
  532812
  534077
  537199
  538223
  540330
  541084
  541879
  542189
  544281
  544366
  544753
  546786
  548012
  554434
  558201
  559158
  564598
  567354
  571812
  582540
  590859
  595121
  597244
  597246
  600132
  601125
  603199
  604492
  606493
  614401
  614993
  619475
  624510
  628170
  630280
  630533
  636247
  637049
  639783
  647980
  650380
  651209
  680130
  683237
  713551
  721557
  761585
  815275
]

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 (392423, 394103, 401924, 422633, 422694, 422933, 422996, 427174, 427447, 430828, 448769, 448821, 454812, 463721, 465208, 468705, 469200, 469576, 471667, 472488, 472567, 473372, 475443, 491248, 494432, 520424, 520540, 522977, 523222, 528307, 528356, 529849, 529855, 530017, 530661, 530670, 532812, 534077, 537199, 538223, 540330, 541084, 541879, 542189, 544281, 544366, 544753, 546786, 548012, 554434, 558201, 559158, 564598, 567354, 571812, 582540, 590859, 595121, 597244, 597246, 600132, 601125, 603199, 604492, 606493, 614401, 614993, 619475, 624510, 628170, 630280, 630533, 636247, 637049, 639783, 647980, 650380, 651209, 680130, 683237, 713551, 721557, 761585, 815275);

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` = 'красивая азиатк чулк нижн бел';