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
  420171
  434645
  411454
  488887
  500905
  580285
  432334
  249926
  446289
  445875
  462670
  495897
  549731
  603327
  119869
  447910
  459025
  410781
  483803
  497627
  505523
  558179
  598180
  488559
  426553
  586868
  491585
  548721
  657882
  463008
  471969
  495984
  515624
  429901
  449173
  453035
  547807
  586917
  401465
  434286
  578323
  545751
  567420
  590418
  491738
  435722
  429867
  569603
  426259
  433316
  513825
  526467
  523111
  400960
  455054
  492926
  534617
  567502
  555023
  456684
  527033
  579583
  597116
  412979
  606600
  418605
  607879
  462497
  575556
  519497
  591428
  657670
  594802
  562740
  568062
  553942
  620546
  566272
  632059
  507177
]

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 (420171, 434645, 411454, 488887, 500905, 580285, 432334, 249926, 446289, 445875, 462670, 495897, 549731, 603327, 119869, 447910, 459025, 410781, 483803, 497627, 505523, 558179, 598180, 488559, 426553, 586868, 491585, 548721, 657882, 463008, 471969, 495984, 515624, 429901, 449173, 453035, 547807, 586917, 401465, 434286, 578323, 545751, 567420, 590418, 491738, 435722, 429867, 569603, 426259, 433316, 513825, 526467, 523111, 400960, 455054, 492926, 534617, 567502, 555023, 456684, 527033, 579583, 597116, 412979, 606600, 418605, 607879, 462497, 575556, 519497, 591428, 657670, 594802, 562740, 568062, 553942, 620546, 566272, 632059, 507177);

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
  119869
  249926
  400960
  401465
  410781
  411454
  412979
  418605
  420171
  426259
  426553
  429867
  429901
  432334
  433316
  434286
  434645
  435722
  445875
  446289
  447910
  449173
  453035
  455054
  456684
  459025
  462497
  462670
  463008
  471969
  483803
  488559
  488887
  491585
  491738
  492926
  495897
  495984
  497627
  500905
  505523
  507177
  513825
  515624
  519497
  523111
  526467
  527033
  534617
  545751
  547807
  548721
  549731
  553942
  555023
  558179
  562740
  566272
  567420
  567502
  568062
  569603
  575556
  578323
  579583
  580285
  586868
  586917
  590418
  591428
  594802
  597116
  598180
  603327
  606600
  607879
  620546
  632059
  657670
  657882
]

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 (119869, 249926, 400960, 401465, 410781, 411454, 412979, 418605, 420171, 426259, 426553, 429867, 429901, 432334, 433316, 434286, 434645, 435722, 445875, 446289, 447910, 449173, 453035, 455054, 456684, 459025, 462497, 462670, 463008, 471969, 483803, 488559, 488887, 491585, 491738, 492926, 495897, 495984, 497627, 500905, 505523, 507177, 513825, 515624, 519497, 523111, 526467, 527033, 534617, 545751, 547807, 548721, 549731, 553942, 555023, 558179, 562740, 566272, 567420, 567502, 568062, 569603, 575556, 578323, 579583, 580285, 586868, 586917, 590418, 591428, 594802, 597116, 598180, 603327, 606600, 607879, 620546, 632059, 657670, 657882);

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
  119869
  249926
  400960
  401465
  410781
  411454
  412979
  418605
  420171
  426259
  426553
  429867
  429901
  432334
  433316
  434286
  434645
  435722
  445875
  446289
  447910
  449173
  453035
  455054
  456684
  459025
  462497
  462670
  463008
  471969
  483803
  488559
  488887
  491585
  491738
  492926
  495897
  495984
  497627
  500905
  505523
  507177
  513825
  515624
  519497
  523111
  526467
  527033
  534617
  545751
  547807
  548721
  549731
  553942
  555023
  558179
  562740
  566272
  567420
  567502
  568062
  569603
  575556
  578323
  579583
  580285
  586868
  586917
  590418
  591428
  594802
  597116
  598180
  603327
  606600
  607879
  620546
  632059
  657670
  657882
]

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 (119869, 249926, 400960, 401465, 410781, 411454, 412979, 418605, 420171, 426259, 426553, 429867, 429901, 432334, 433316, 434286, 434645, 435722, 445875, 446289, 447910, 449173, 453035, 455054, 456684, 459025, 462497, 462670, 463008, 471969, 483803, 488559, 488887, 491585, 491738, 492926, 495897, 495984, 497627, 500905, 505523, 507177, 513825, 515624, 519497, 523111, 526467, 527033, 534617, 545751, 547807, 548721, 549731, 553942, 555023, 558179, 562740, 566272, 567420, 567502, 568062, 569603, 575556, 578323, 579583, 580285, 586868, 586917, 590418, 591428, 594802, 597116, 598180, 603327, 606600, 607879, 620546, 632059, 657670, 657882);

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` = 'широк раздвига вагин';