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
  549159
  551995
  565174
  569778
  601160
  609874
  476934
  508678
  526230
  493047
  542754
  560396
  579876
  585335
  614441
  428521
  663527
  567892
  797519
  500912
  559140
  424498
  450339
  509672
  508567
  525011
  455943
  578411
  427284
  517233
  489536
  510116
  579647
  618987
  397400
  466151
  571102
  588078
  631504
  613985
  540217
  521372
  524198
  543844
  660103
  615382
  486102
  653189
  570866
  591202
  585668
  608336
  625212
  451832
  507872
  518270
  508437
  523013
  544296
  546913
  568720
  541644
  652263
  707391
  608560
  550436
  553190
  468065
  521453
  520763
  559062
  533707
  626014
  527608
  541866
]

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 (549159, 551995, 565174, 569778, 601160, 609874, 476934, 508678, 526230, 493047, 542754, 560396, 579876, 585335, 614441, 428521, 663527, 567892, 797519, 500912, 559140, 424498, 450339, 509672, 508567, 525011, 455943, 578411, 427284, 517233, 489536, 510116, 579647, 618987, 397400, 466151, 571102, 588078, 631504, 613985, 540217, 521372, 524198, 543844, 660103, 615382, 486102, 653189, 570866, 591202, 585668, 608336, 625212, 451832, 507872, 518270, 508437, 523013, 544296, 546913, 568720, 541644, 652263, 707391, 608560, 550436, 553190, 468065, 521453, 520763, 559062, 533707, 626014, 527608, 541866);

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
  397400
  424498
  427284
  428521
  450339
  451832
  455943
  466151
  468065
  476934
  486102
  489536
  493047
  500912
  507872
  508437
  508567
  508678
  509672
  510116
  517233
  518270
  520763
  521372
  521453
  523013
  524198
  525011
  526230
  527608
  533707
  540217
  541644
  541866
  542754
  543844
  544296
  546913
  549159
  550436
  551995
  553190
  559062
  559140
  560396
  565174
  567892
  568720
  569778
  570866
  571102
  578411
  579647
  579876
  585335
  585668
  588078
  591202
  601160
  608336
  608560
  609874
  613985
  614441
  615382
  618987
  625212
  626014
  631504
  652263
  653189
  660103
  663527
  707391
  797519
]

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 (397400, 424498, 427284, 428521, 450339, 451832, 455943, 466151, 468065, 476934, 486102, 489536, 493047, 500912, 507872, 508437, 508567, 508678, 509672, 510116, 517233, 518270, 520763, 521372, 521453, 523013, 524198, 525011, 526230, 527608, 533707, 540217, 541644, 541866, 542754, 543844, 544296, 546913, 549159, 550436, 551995, 553190, 559062, 559140, 560396, 565174, 567892, 568720, 569778, 570866, 571102, 578411, 579647, 579876, 585335, 585668, 588078, 591202, 601160, 608336, 608560, 609874, 613985, 614441, 615382, 618987, 625212, 626014, 631504, 652263, 653189, 660103, 663527, 707391, 797519);

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
  397400
  424498
  427284
  428521
  450339
  451832
  455943
  466151
  468065
  476934
  486102
  489536
  493047
  500912
  507872
  508437
  508567
  508678
  509672
  510116
  517233
  518270
  520763
  521372
  521453
  523013
  524198
  525011
  526230
  527608
  533707
  540217
  541644
  541866
  542754
  543844
  544296
  546913
  549159
  550436
  551995
  553190
  559062
  559140
  560396
  565174
  567892
  568720
  569778
  570866
  571102
  578411
  579647
  579876
  585335
  585668
  588078
  591202
  601160
  608336
  608560
  609874
  613985
  614441
  615382
  618987
  625212
  626014
  631504
  652263
  653189
  660103
  663527
  707391
  797519
]

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 (397400, 424498, 427284, 428521, 450339, 451832, 455943, 466151, 468065, 476934, 486102, 489536, 493047, 500912, 507872, 508437, 508567, 508678, 509672, 510116, 517233, 518270, 520763, 521372, 521453, 523013, 524198, 525011, 526230, 527608, 533707, 540217, 541644, 541866, 542754, 543844, 544296, 546913, 549159, 550436, 551995, 553190, 559062, 559140, 560396, 565174, 567892, 568720, 569778, 570866, 571102, 578411, 579647, 579876, 585335, 585668, 588078, 591202, 601160, 608336, 608560, 609874, 613985, 614441, 615382, 618987, 625212, 626014, 631504, 652263, 653189, 660103, 663527, 707391, 797519);

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` = 'сперм рту';