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
  717965
  526407
  603674
  541840
  553118
  612182
  730422
  779957
  535785
  584743
  607813
  528667
  560701
  593249
  637474
  450044
  525578
  536944
  560522
  682374
  475834
  538951
  563110
  578246
  554093
  602927
  425026
  508225
  621367
  512506
  595451
  561404
  582003
  560170
  562818
  680035
  596084
  616944
  559451
  508072
  542706
  563651
  554985
  812992
  471903
  565773
  582687
  600787
  560138
  612259
  451737
  466281
  571332
  547815
  444041
  561510
  550827
  603382
  534194
  557628
  524976
  499205
  499412
  585320
  682252
  521502
  551110
  481569
  532331
  591646
  507710
  624550
  492279
  621347
  518406
  588057
  666405
  508725
  486302
  520145
  637460
  609649
  608560
  611900
  523822
]

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 (717965, 526407, 603674, 541840, 553118, 612182, 730422, 779957, 535785, 584743, 607813, 528667, 560701, 593249, 637474, 450044, 525578, 536944, 560522, 682374, 475834, 538951, 563110, 578246, 554093, 602927, 425026, 508225, 621367, 512506, 595451, 561404, 582003, 560170, 562818, 680035, 596084, 616944, 559451, 508072, 542706, 563651, 554985, 812992, 471903, 565773, 582687, 600787, 560138, 612259, 451737, 466281, 571332, 547815, 444041, 561510, 550827, 603382, 534194, 557628, 524976, 499205, 499412, 585320, 682252, 521502, 551110, 481569, 532331, 591646, 507710, 624550, 492279, 621347, 518406, 588057, 666405, 508725, 486302, 520145, 637460, 609649, 608560, 611900, 523822);

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
  425026
  444041
  450044
  451737
  466281
  471903
  475834
  481569
  486302
  492279
  499205
  499412
  507710
  508072
  508225
  508725
  512506
  518406
  520145
  521502
  523822
  524976
  525578
  526407
  528667
  532331
  534194
  535785
  536944
  538951
  541840
  542706
  547815
  550827
  551110
  553118
  554093
  554985
  557628
  559451
  560138
  560170
  560522
  560701
  561404
  561510
  562818
  563110
  563651
  565773
  571332
  578246
  582003
  582687
  584743
  585320
  588057
  591646
  593249
  595451
  596084
  600787
  602927
  603382
  603674
  607813
  608560
  609649
  611900
  612182
  612259
  616944
  621347
  621367
  624550
  637460
  637474
  666405
  680035
  682252
  682374
  717965
  730422
  779957
  812992
]

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 (425026, 444041, 450044, 451737, 466281, 471903, 475834, 481569, 486302, 492279, 499205, 499412, 507710, 508072, 508225, 508725, 512506, 518406, 520145, 521502, 523822, 524976, 525578, 526407, 528667, 532331, 534194, 535785, 536944, 538951, 541840, 542706, 547815, 550827, 551110, 553118, 554093, 554985, 557628, 559451, 560138, 560170, 560522, 560701, 561404, 561510, 562818, 563110, 563651, 565773, 571332, 578246, 582003, 582687, 584743, 585320, 588057, 591646, 593249, 595451, 596084, 600787, 602927, 603382, 603674, 607813, 608560, 609649, 611900, 612182, 612259, 616944, 621347, 621367, 624550, 637460, 637474, 666405, 680035, 682252, 682374, 717965, 730422, 779957, 812992);

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
  425026
  444041
  450044
  451737
  466281
  471903
  475834
  481569
  486302
  492279
  499205
  499412
  507710
  508072
  508225
  508725
  512506
  518406
  520145
  521502
  523822
  524976
  525578
  526407
  528667
  532331
  534194
  535785
  536944
  538951
  541840
  542706
  547815
  550827
  551110
  553118
  554093
  554985
  557628
  559451
  560138
  560170
  560522
  560701
  561404
  561510
  562818
  563110
  563651
  565773
  571332
  578246
  582003
  582687
  584743
  585320
  588057
  591646
  593249
  595451
  596084
  600787
  602927
  603382
  603674
  607813
  608560
  609649
  611900
  612182
  612259
  616944
  621347
  621367
  624550
  637460
  637474
  666405
  680035
  682252
  682374
  717965
  730422
  779957
  812992
]

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 (425026, 444041, 450044, 451737, 466281, 471903, 475834, 481569, 486302, 492279, 499205, 499412, 507710, 508072, 508225, 508725, 512506, 518406, 520145, 521502, 523822, 524976, 525578, 526407, 528667, 532331, 534194, 535785, 536944, 538951, 541840, 542706, 547815, 550827, 551110, 553118, 554093, 554985, 557628, 559451, 560138, 560170, 560522, 560701, 561404, 561510, 562818, 563110, 563651, 565773, 571332, 578246, 582003, 582687, 584743, 585320, 588057, 591646, 593249, 595451, 596084, 600787, 602927, 603382, 603674, 607813, 608560, 609649, 611900, 612182, 612259, 616944, 621347, 621367, 624550, 637460, 637474, 666405, 680035, 682252, 682374, 717965, 730422, 779957, 812992);

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` = 'классн секс';