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
  646233
  581404
  585398
  589425
  603066
  601621
  394532
  422567
  468587
  448587
  487582
  523529
  448640
  594262
  434293
  608347
  412460
  536092
  684802
  568602
  588240
  425752
  419152
  449666
  500802
  508145
  581509
  679709
  616713
  419417
  455011
  434364
  446600
  451951
  599938
  422712
  468661
  552616
  565914
  579312
  419912
  571228
  429943
  422626
  500913
  489077
  544937
  622223
  591640
  467888
  596354
  443437
  414125
  486199
  434001
  399263
  493992
  564867
  584328
  680181
  414548
  529252
  516214
  536590
  492215
  580298
  680375
  416415
  575841
  542961
  674995
  569357
  606011
  536695
  553280
]

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 (646233, 581404, 585398, 589425, 603066, 601621, 394532, 422567, 468587, 448587, 487582, 523529, 448640, 594262, 434293, 608347, 412460, 536092, 684802, 568602, 588240, 425752, 419152, 449666, 500802, 508145, 581509, 679709, 616713, 419417, 455011, 434364, 446600, 451951, 599938, 422712, 468661, 552616, 565914, 579312, 419912, 571228, 429943, 422626, 500913, 489077, 544937, 622223, 591640, 467888, 596354, 443437, 414125, 486199, 434001, 399263, 493992, 564867, 584328, 680181, 414548, 529252, 516214, 536590, 492215, 580298, 680375, 416415, 575841, 542961, 674995, 569357, 606011, 536695, 553280);

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
  394532
  399263
  412460
  414125
  414548
  416415
  419152
  419417
  419912
  422567
  422626
  422712
  425752
  429943
  434001
  434293
  434364
  443437
  446600
  448587
  448640
  449666
  451951
  455011
  467888
  468587
  468661
  486199
  487582
  489077
  492215
  493992
  500802
  500913
  508145
  516214
  523529
  529252
  536092
  536590
  536695
  542961
  544937
  552616
  553280
  564867
  565914
  568602
  569357
  571228
  575841
  579312
  580298
  581404
  581509
  584328
  585398
  588240
  589425
  591640
  594262
  596354
  599938
  601621
  603066
  606011
  608347
  616713
  622223
  646233
  674995
  679709
  680181
  680375
  684802
]

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 (394532, 399263, 412460, 414125, 414548, 416415, 419152, 419417, 419912, 422567, 422626, 422712, 425752, 429943, 434001, 434293, 434364, 443437, 446600, 448587, 448640, 449666, 451951, 455011, 467888, 468587, 468661, 486199, 487582, 489077, 492215, 493992, 500802, 500913, 508145, 516214, 523529, 529252, 536092, 536590, 536695, 542961, 544937, 552616, 553280, 564867, 565914, 568602, 569357, 571228, 575841, 579312, 580298, 581404, 581509, 584328, 585398, 588240, 589425, 591640, 594262, 596354, 599938, 601621, 603066, 606011, 608347, 616713, 622223, 646233, 674995, 679709, 680181, 680375, 684802);

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
  394532
  399263
  412460
  414125
  414548
  416415
  419152
  419417
  419912
  422567
  422626
  422712
  425752
  429943
  434001
  434293
  434364
  443437
  446600
  448587
  448640
  449666
  451951
  455011
  467888
  468587
  468661
  486199
  487582
  489077
  492215
  493992
  500802
  500913
  508145
  516214
  523529
  529252
  536092
  536590
  536695
  542961
  544937
  552616
  553280
  564867
  565914
  568602
  569357
  571228
  575841
  579312
  580298
  581404
  581509
  584328
  585398
  588240
  589425
  591640
  594262
  596354
  599938
  601621
  603066
  606011
  608347
  616713
  622223
  646233
  674995
  679709
  680181
  680375
  684802
]

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 (394532, 399263, 412460, 414125, 414548, 416415, 419152, 419417, 419912, 422567, 422626, 422712, 425752, 429943, 434001, 434293, 434364, 443437, 446600, 448587, 448640, 449666, 451951, 455011, 467888, 468587, 468661, 486199, 487582, 489077, 492215, 493992, 500802, 500913, 508145, 516214, 523529, 529252, 536092, 536590, 536695, 542961, 544937, 552616, 553280, 564867, 565914, 568602, 569357, 571228, 575841, 579312, 580298, 581404, 581509, 584328, 585398, 588240, 589425, 591640, 594262, 596354, 599938, 601621, 603066, 606011, 608347, 616713, 622223, 646233, 674995, 679709, 680181, 680375, 684802);

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` = 'худая упругая сиськ';