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
  383031
  358879
  398157
  517146
  414987
  574529
  527451
  482695
  274678
  318795
  654785
  393782
  513891
  384138
  388715
  408734
  397891
  433995
  471448
  152479
  394780
  667312
  295700
  395667
  515607
  402160
  498856
  563846
  567393
  441395
  567406
  188737
  473978
  504557
  515838
  576112
  449243
  458137
  490752
  549619
  568719
  568819
  563611
  508159
  520661
  523820
  484425
  510616
  500991
  475927
  484721
  518493
  614621
  404318
  479258
  519819
  542084
  527968
  497952
  457332
  514750
  578898
  523992
  458197
  501611
  574460
  418453
  555868
  655431
  593185
  517567
  601890
  603224
  578396
  580334
  554392
  625359
  513949
  588286
  612792
  558432
]

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 (383031, 358879, 398157, 517146, 414987, 574529, 527451, 482695, 274678, 318795, 654785, 393782, 513891, 384138, 388715, 408734, 397891, 433995, 471448, 152479, 394780, 667312, 295700, 395667, 515607, 402160, 498856, 563846, 567393, 441395, 567406, 188737, 473978, 504557, 515838, 576112, 449243, 458137, 490752, 549619, 568719, 568819, 563611, 508159, 520661, 523820, 484425, 510616, 500991, 475927, 484721, 518493, 614621, 404318, 479258, 519819, 542084, 527968, 497952, 457332, 514750, 578898, 523992, 458197, 501611, 574460, 418453, 555868, 655431, 593185, 517567, 601890, 603224, 578396, 580334, 554392, 625359, 513949, 588286, 612792, 558432);

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
  152479
  188737
  274678
  295700
  318795
  358879
  383031
  384138
  388715
  393782
  394780
  395667
  397891
  398157
  402160
  404318
  408734
  414987
  418453
  433995
  441395
  449243
  457332
  458137
  458197
  471448
  473978
  475927
  479258
  482695
  484425
  484721
  490752
  497952
  498856
  500991
  501611
  504557
  508159
  510616
  513891
  513949
  514750
  515607
  515838
  517146
  517567
  518493
  519819
  520661
  523820
  523992
  527451
  527968
  542084
  549619
  554392
  555868
  558432
  563611
  563846
  567393
  567406
  568719
  568819
  574460
  574529
  576112
  578396
  578898
  580334
  588286
  593185
  601890
  603224
  612792
  614621
  625359
  654785
  655431
  667312
]

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 (152479, 188737, 274678, 295700, 318795, 358879, 383031, 384138, 388715, 393782, 394780, 395667, 397891, 398157, 402160, 404318, 408734, 414987, 418453, 433995, 441395, 449243, 457332, 458137, 458197, 471448, 473978, 475927, 479258, 482695, 484425, 484721, 490752, 497952, 498856, 500991, 501611, 504557, 508159, 510616, 513891, 513949, 514750, 515607, 515838, 517146, 517567, 518493, 519819, 520661, 523820, 523992, 527451, 527968, 542084, 549619, 554392, 555868, 558432, 563611, 563846, 567393, 567406, 568719, 568819, 574460, 574529, 576112, 578396, 578898, 580334, 588286, 593185, 601890, 603224, 612792, 614621, 625359, 654785, 655431, 667312);

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
  152479
  188737
  274678
  295700
  318795
  358879
  383031
  384138
  388715
  393782
  394780
  395667
  397891
  398157
  402160
  404318
  408734
  414987
  418453
  433995
  441395
  449243
  457332
  458137
  458197
  471448
  473978
  475927
  479258
  482695
  484425
  484721
  490752
  497952
  498856
  500991
  501611
  504557
  508159
  510616
  513891
  513949
  514750
  515607
  515838
  517146
  517567
  518493
  519819
  520661
  523820
  523992
  527451
  527968
  542084
  549619
  554392
  555868
  558432
  563611
  563846
  567393
  567406
  568719
  568819
  574460
  574529
  576112
  578396
  578898
  580334
  588286
  593185
  601890
  603224
  612792
  614621
  625359
  654785
  655431
  667312
]

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 (152479, 188737, 274678, 295700, 318795, 358879, 383031, 384138, 388715, 393782, 394780, 395667, 397891, 398157, 402160, 404318, 408734, 414987, 418453, 433995, 441395, 449243, 457332, 458137, 458197, 471448, 473978, 475927, 479258, 482695, 484425, 484721, 490752, 497952, 498856, 500991, 501611, 504557, 508159, 510616, 513891, 513949, 514750, 515607, 515838, 517146, 517567, 518493, 519819, 520661, 523820, 523992, 527451, 527968, 542084, 549619, 554392, 555868, 558432, 563611, 563846, 567393, 567406, 568719, 568819, 574460, 574529, 576112, 578396, 578898, 580334, 588286, 593185, 601890, 603224, 612792, 614621, 625359, 654785, 655431, 667312);

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` = 'чуж мужчин';