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

[
  "rus first anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rus first anal' 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
  517204
  496818
  785727
  504450
  490261
  532799
  637445
  586423
  751589
  503153
  513718
  487206
  528262
  400728
  633804
  476937
  785628
  501406
  597233
  630511
  435391
  458912
  491924
  575756
  428993
  463815
  427087
  534028
  536337
  576395
  678973
  600354
  456452
  447615
  522283
  447465
  696997
  648575
  659419
  633732
  653455
  452425
  574184
  597227
  590560
  505614
  811724
  568315
  646838
  710524
  497368
  499125
  572339
  552471
  483252
  619965
  516615
  586770
  534027
  702166
  603536
  597902
  621339
  506397
  458810
  448148
  623678
  521428
  528282
  437789
  631193
  723074
  625660
  537236
  625437
  422449
  580596
]

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 (517204, 496818, 785727, 504450, 490261, 532799, 637445, 586423, 751589, 503153, 513718, 487206, 528262, 400728, 633804, 476937, 785628, 501406, 597233, 630511, 435391, 458912, 491924, 575756, 428993, 463815, 427087, 534028, 536337, 576395, 678973, 600354, 456452, 447615, 522283, 447465, 696997, 648575, 659419, 633732, 653455, 452425, 574184, 597227, 590560, 505614, 811724, 568315, 646838, 710524, 497368, 499125, 572339, 552471, 483252, 619965, 516615, 586770, 534027, 702166, 603536, 597902, 621339, 506397, 458810, 448148, 623678, 521428, 528282, 437789, 631193, 723074, 625660, 537236, 625437, 422449, 580596);

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
  400728
  422449
  427087
  428993
  435391
  437789
  447465
  447615
  448148
  452425
  456452
  458810
  458912
  463815
  476937
  483252
  487206
  490261
  491924
  496818
  497368
  499125
  501406
  503153
  504450
  505614
  506397
  513718
  516615
  517204
  521428
  522283
  528262
  528282
  532799
  534027
  534028
  536337
  537236
  552471
  568315
  572339
  574184
  575756
  576395
  580596
  586423
  586770
  590560
  597227
  597233
  597902
  600354
  603536
  619965
  621339
  623678
  625437
  625660
  630511
  631193
  633732
  633804
  637445
  646838
  648575
  653455
  659419
  678973
  696997
  702166
  710524
  723074
  751589
  785628
  785727
  811724
]

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 (400728, 422449, 427087, 428993, 435391, 437789, 447465, 447615, 448148, 452425, 456452, 458810, 458912, 463815, 476937, 483252, 487206, 490261, 491924, 496818, 497368, 499125, 501406, 503153, 504450, 505614, 506397, 513718, 516615, 517204, 521428, 522283, 528262, 528282, 532799, 534027, 534028, 536337, 537236, 552471, 568315, 572339, 574184, 575756, 576395, 580596, 586423, 586770, 590560, 597227, 597233, 597902, 600354, 603536, 619965, 621339, 623678, 625437, 625660, 630511, 631193, 633732, 633804, 637445, 646838, 648575, 653455, 659419, 678973, 696997, 702166, 710524, 723074, 751589, 785628, 785727, 811724);

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
  400728
  422449
  427087
  428993
  435391
  437789
  447465
  447615
  448148
  452425
  456452
  458810
  458912
  463815
  476937
  483252
  487206
  490261
  491924
  496818
  497368
  499125
  501406
  503153
  504450
  505614
  506397
  513718
  516615
  517204
  521428
  522283
  528262
  528282
  532799
  534027
  534028
  536337
  537236
  552471
  568315
  572339
  574184
  575756
  576395
  580596
  586423
  586770
  590560
  597227
  597233
  597902
  600354
  603536
  619965
  621339
  623678
  625437
  625660
  630511
  631193
  633732
  633804
  637445
  646838
  648575
  653455
  659419
  678973
  696997
  702166
  710524
  723074
  751589
  785628
  785727
  811724
]

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 (400728, 422449, 427087, 428993, 435391, 437789, 447465, 447615, 448148, 452425, 456452, 458810, 458912, 463815, 476937, 483252, 487206, 490261, 491924, 496818, 497368, 499125, 501406, 503153, 504450, 505614, 506397, 513718, 516615, 517204, 521428, 522283, 528262, 528282, 532799, 534027, 534028, 536337, 537236, 552471, 568315, 572339, 574184, 575756, 576395, 580596, 586423, 586770, 590560, 597227, 597233, 597902, 600354, 603536, 619965, 621339, 623678, 625437, 625660, 630511, 631193, 633732, 633804, 637445, 646838, 648575, 653455, 659419, 678973, 696997, 702166, 710524, 723074, 751589, 785628, 785727, 811724);

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

[
  "русск first анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'русск first анал';

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

[
  "русск first анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'русск first анал';