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

[
  b"ÐüÐéð░ÐÇÐïðÁ Ðü ð╝ð¥ð╗ð¥ð┤Ðïð╝ð© ÐìÐÇð¥ÐÔǪ"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 0xD181D182D0B0D180D18BD0B520D18120D0BCD0BED0BBD0BED0B4D18BD0BCD0B820D18DD180D0BED1E280A6 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
  693059
  749160
  388261
  455909
  721699
  790200
  535346
  401479
  575728
  411591
  574200
  515931
  482315
  401223
  590966
  597045
  443512
  568601
  570177
  599497
  731939
  389458
  394199
  448930
  479098
  405534
  423396
  470792
  490184
  513523
  383538
  422997
  566709
  575715
  622188
  731921
  439595
  451458
  484607
  491899
  499423
  550641
  471631
  550647
  562626
  569930
  604100
  440964
  466273
  422863
  466250
  569967
  659025
  527295
  535025
  624122
  502738
  486110
  440971
  439558
  581797
  489958
  528788
  575197
  598654
  593125
  621340
  631957
  480298
  513207
]

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 (693059, 749160, 388261, 455909, 721699, 790200, 535346, 401479, 575728, 411591, 574200, 515931, 482315, 401223, 590966, 597045, 443512, 568601, 570177, 599497, 731939, 389458, 394199, 448930, 479098, 405534, 423396, 470792, 490184, 513523, 383538, 422997, 566709, 575715, 622188, 731921, 439595, 451458, 484607, 491899, 499423, 550641, 471631, 550647, 562626, 569930, 604100, 440964, 466273, 422863, 466250, 569967, 659025, 527295, 535025, 624122, 502738, 486110, 440971, 439558, 581797, 489958, 528788, 575197, 598654, 593125, 621340, 631957, 480298, 513207);

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
  383538
  388261
  389458
  394199
  401223
  401479
  405534
  411591
  422863
  422997
  423396
  439558
  439595
  440964
  440971
  443512
  448930
  451458
  455909
  466250
  466273
  470792
  471631
  479098
  480298
  482315
  484607
  486110
  489958
  490184
  491899
  499423
  502738
  513207
  513523
  515931
  527295
  528788
  535025
  535346
  550641
  550647
  562626
  566709
  568601
  569930
  569967
  570177
  574200
  575197
  575715
  575728
  581797
  590966
  593125
  597045
  598654
  599497
  604100
  621340
  622188
  624122
  631957
  659025
  693059
  721699
  731921
  731939
  749160
  790200
]

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 (383538, 388261, 389458, 394199, 401223, 401479, 405534, 411591, 422863, 422997, 423396, 439558, 439595, 440964, 440971, 443512, 448930, 451458, 455909, 466250, 466273, 470792, 471631, 479098, 480298, 482315, 484607, 486110, 489958, 490184, 491899, 499423, 502738, 513207, 513523, 515931, 527295, 528788, 535025, 535346, 550641, 550647, 562626, 566709, 568601, 569930, 569967, 570177, 574200, 575197, 575715, 575728, 581797, 590966, 593125, 597045, 598654, 599497, 604100, 621340, 622188, 624122, 631957, 659025, 693059, 721699, 731921, 731939, 749160, 790200);

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
  383538
  388261
  389458
  394199
  401223
  401479
  405534
  411591
  422863
  422997
  423396
  439558
  439595
  440964
  440971
  443512
  448930
  451458
  455909
  466250
  466273
  470792
  471631
  479098
  480298
  482315
  484607
  486110
  489958
  490184
  491899
  499423
  502738
  513207
  513523
  515931
  527295
  528788
  535025
  535346
  550641
  550647
  562626
  566709
  568601
  569930
  569967
  570177
  574200
  575197
  575715
  575728
  581797
  590966
  593125
  597045
  598654
  599497
  604100
  621340
  622188
  624122
  631957
  659025
  693059
  721699
  731921
  731939
  749160
  790200
]

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 (383538, 388261, 389458, 394199, 401223, 401479, 405534, 411591, 422863, 422997, 423396, 439558, 439595, 440964, 440971, 443512, 448930, 451458, 455909, 466250, 466273, 470792, 471631, 479098, 480298, 482315, 484607, 486110, 489958, 490184, 491899, 499423, 502738, 513207, 513523, 515931, 527295, 528788, 535025, 535346, 550641, 550647, 562626, 566709, 568601, 569930, 569967, 570177, 574200, 575197, 575715, 575728, 581797, 590966, 593125, 597045, 598654, 599497, 604100, 621340, 622188, 624122, 631957, 659025, 693059, 721699, 731921, 731939, 749160, 790200);

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` = 'старые молодые эротик';