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

[
  "kissing erotic"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kissing erotic' 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
  549964
  602917
  630192
  600491
  586750
  589014
  602727
  605358
  631778
  801475
  739687
  753084
  795276
  438082
  461810
  471174
  462903
  526507
  580850
  547873
  551969
  567712
  581575
  545926
  552216
  581001
  702352
  594088
  604701
  605464
  608229
  610623
  609412
  521342
  7871
  565984
  56632
  105477
  473911
  557510
  565982
  544347
  544352
  574417
  562398
  565650
  604083
  105845
  446906
  500614
  511031
  512198
  549362
  542737
  603671
  570813
  390129
  430920
  739475
  428823
  721699
  389864
  583819
  455909
  448262
  466312
  448930
  621091
  500691
  566709
  451458
  550647
  561850
  517587
  426116
  527295
  382190
  602761
  614729
]

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 (549964, 602917, 630192, 600491, 586750, 589014, 602727, 605358, 631778, 801475, 739687, 753084, 795276, 438082, 461810, 471174, 462903, 526507, 580850, 547873, 551969, 567712, 581575, 545926, 552216, 581001, 702352, 594088, 604701, 605464, 608229, 610623, 609412, 521342, 7871, 565984, 56632, 105477, 473911, 557510, 565982, 544347, 544352, 574417, 562398, 565650, 604083, 105845, 446906, 500614, 511031, 512198, 549362, 542737, 603671, 570813, 390129, 430920, 739475, 428823, 721699, 389864, 583819, 455909, 448262, 466312, 448930, 621091, 500691, 566709, 451458, 550647, 561850, 517587, 426116, 527295, 382190, 602761, 614729);

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
  7871
  56632
  105477
  105845
  382190
  389864
  390129
  426116
  428823
  430920
  438082
  446906
  448262
  448930
  451458
  455909
  461810
  462903
  466312
  471174
  473911
  500614
  500691
  511031
  512198
  517587
  521342
  526507
  527295
  542737
  544347
  544352
  545926
  547873
  549362
  549964
  550647
  551969
  552216
  557510
  561850
  562398
  565650
  565982
  565984
  566709
  567712
  570813
  574417
  580850
  581001
  581575
  583819
  586750
  589014
  594088
  600491
  602727
  602761
  602917
  603671
  604083
  604701
  605358
  605464
  608229
  609412
  610623
  614729
  621091
  630192
  631778
  702352
  721699
  739475
  739687
  753084
  795276
  801475
]

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 (7871, 56632, 105477, 105845, 382190, 389864, 390129, 426116, 428823, 430920, 438082, 446906, 448262, 448930, 451458, 455909, 461810, 462903, 466312, 471174, 473911, 500614, 500691, 511031, 512198, 517587, 521342, 526507, 527295, 542737, 544347, 544352, 545926, 547873, 549362, 549964, 550647, 551969, 552216, 557510, 561850, 562398, 565650, 565982, 565984, 566709, 567712, 570813, 574417, 580850, 581001, 581575, 583819, 586750, 589014, 594088, 600491, 602727, 602761, 602917, 603671, 604083, 604701, 605358, 605464, 608229, 609412, 610623, 614729, 621091, 630192, 631778, 702352, 721699, 739475, 739687, 753084, 795276, 801475);

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
  7871
  56632
  105477
  105845
  382190
  389864
  390129
  426116
  428823
  430920
  438082
  446906
  448262
  448930
  451458
  455909
  461810
  462903
  466312
  471174
  473911
  500614
  500691
  511031
  512198
  517587
  521342
  526507
  527295
  542737
  544347
  544352
  545926
  547873
  549362
  549964
  550647
  551969
  552216
  557510
  561850
  562398
  565650
  565982
  565984
  566709
  567712
  570813
  574417
  580850
  581001
  581575
  583819
  586750
  589014
  594088
  600491
  602727
  602761
  602917
  603671
  604083
  604701
  605358
  605464
  608229
  609412
  610623
  614729
  621091
  630192
  631778
  702352
  721699
  739475
  739687
  753084
  795276
  801475
]

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 (7871, 56632, 105477, 105845, 382190, 389864, 390129, 426116, 428823, 430920, 438082, 446906, 448262, 448930, 451458, 455909, 461810, 462903, 466312, 471174, 473911, 500614, 500691, 511031, 512198, 517587, 521342, 526507, 527295, 542737, 544347, 544352, 545926, 547873, 549362, 549964, 550647, 551969, 552216, 557510, 561850, 562398, 565650, 565982, 565984, 566709, 567712, 570813, 574417, 580850, 581001, 581575, 583819, 586750, 589014, 594088, 600491, 602727, 602761, 602917, 603671, 604083, 604701, 605358, 605464, 608229, 609412, 610623, 614729, 621091, 630192, 631778, 702352, 721699, 739475, 739687, 753084, 795276, 801475);

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

[
  "kissing эротик"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'kissing эротик';

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

[
  "kissing эротик"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'kissing эротик';