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

[
  "dap anal bbc"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?
LIMIT
  1

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dap anal bbc' 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
  533837
  537584
  471691
  649525
  677303
  650198
  545461
  569922
  591695
  599913
  637729
  600271
  565277
  675001
  649546
  634774
  534149
  531182
  536582
  542549
  674967
  666880
  676089
  678126
  650157
  676026
  676641
  677676
  634472
  633742
  632258
  531247
  499104
  677307
  678153
  634769
  628082
  531420
  545409
  676020
  545372
  599865
  545389
  677296
  678522
  666527
  676016
  674943
  545437
  555789
  599927
  600257
  617417
  529794
  677783
  676638
  531123
  666850
  647948
  675010
  676428
  675000
  695127
  545469
  588265
  545418
  679019
  675008
  628333
  545355
  530369
  635275
  598105
  599940
]

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 (533837, 537584, 471691, 649525, 677303, 650198, 545461, 569922, 591695, 599913, 637729, 600271, 565277, 675001, 649546, 634774, 534149, 531182, 536582, 542549, 674967, 666880, 676089, 678126, 650157, 676026, 676641, 677676, 634472, 633742, 632258, 531247, 499104, 677307, 678153, 634769, 628082, 531420, 545409, 676020, 545372, 599865, 545389, 677296, 678522, 666527, 676016, 674943, 545437, 555789, 599927, 600257, 617417, 529794, 677783, 676638, 531123, 666850, 647948, 675010, 676428, 675000, 695127, 545469, 588265, 545418, 679019, 675008, 628333, 545355, 530369, 635275, 598105, 599940);

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
  471691
  499104
  529794
  530369
  531123
  531182
  531247
  531420
  533837
  534149
  536582
  537584
  542549
  545355
  545372
  545389
  545409
  545418
  545437
  545461
  545469
  555789
  565277
  569922
  588265
  591695
  598105
  599865
  599913
  599927
  599940
  600257
  600271
  617417
  628082
  628333
  632258
  633742
  634472
  634769
  634774
  635275
  637729
  647948
  649525
  649546
  650157
  650198
  666527
  666850
  666880
  674943
  674967
  675000
  675001
  675008
  675010
  676016
  676020
  676026
  676089
  676428
  676638
  676641
  677296
  677303
  677307
  677676
  677783
  678126
  678153
  678522
  679019
  695127
]

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 (471691, 499104, 529794, 530369, 531123, 531182, 531247, 531420, 533837, 534149, 536582, 537584, 542549, 545355, 545372, 545389, 545409, 545418, 545437, 545461, 545469, 555789, 565277, 569922, 588265, 591695, 598105, 599865, 599913, 599927, 599940, 600257, 600271, 617417, 628082, 628333, 632258, 633742, 634472, 634769, 634774, 635275, 637729, 647948, 649525, 649546, 650157, 650198, 666527, 666850, 666880, 674943, 674967, 675000, 675001, 675008, 675010, 676016, 676020, 676026, 676089, 676428, 676638, 676641, 677296, 677303, 677307, 677676, 677783, 678126, 678153, 678522, 679019, 695127);

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
  471691
  499104
  529794
  530369
  531123
  531182
  531247
  531420
  533837
  534149
  536582
  537584
  542549
  545355
  545372
  545389
  545409
  545418
  545437
  545461
  545469
  555789
  565277
  569922
  588265
  591695
  598105
  599865
  599913
  599927
  599940
  600257
  600271
  617417
  628082
  628333
  632258
  633742
  634472
  634769
  634774
  635275
  637729
  647948
  649525
  649546
  650157
  650198
  666527
  666850
  666880
  674943
  674967
  675000
  675001
  675008
  675010
  676016
  676020
  676026
  676089
  676428
  676638
  676641
  677296
  677303
  677307
  677676
  677783
  678126
  678153
  678522
  679019
  695127
]

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 (471691, 499104, 529794, 530369, 531123, 531182, 531247, 531420, 533837, 534149, 536582, 537584, 542549, 545355, 545372, 545389, 545409, 545418, 545437, 545461, 545469, 555789, 565277, 569922, 588265, 591695, 598105, 599865, 599913, 599927, 599940, 600257, 600271, 617417, 628082, 628333, 632258, 633742, 634472, 634769, 634774, 635275, 637729, 647948, 649525, 649546, 650157, 650198, 666527, 666850, 666880, 674943, 674967, 675000, 675001, 675008, 675010, 676016, 676020, 676026, 676089, 676428, 676638, 676641, 677296, 677303, 677307, 677676, 677783, 678126, 678153, 678522, 679019, 695127);

SELECT `query_id` FROM `search_log` WHERE `query` = ?

[
  "dap анал bbc"
]

SELECT
  `query_id`
FROM
  `search_log`
WHERE
  `query` = ?

SELECT `query_id` FROM `search_log` WHERE `query` = 'dap анал bbc';

SELECT `trend_id` FROM `trend` WHERE `subject` = ?

[
  "dap анал bbc"
]

SELECT
  `trend_id`
FROM
  `trend`
WHERE
  `subject` = ?

SELECT `trend_id` FROM `trend` WHERE `subject` = 'dap анал bbc';