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

[
  "anal atm"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal atm' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01–\x1A"rÃqñ¾Þ\x08–þ…ð+"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01961A2272C371F1BEDE0896FE85F02B 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
  541197
  696579
  501641
  585984
  530489
  666899
  633806
  672712
  457884
  447959
  537654
  599914
  647993
  647830
  628402
  599965
  600019
  633775
  530378
  647936
  672710
  647952
  633770
  634543
  628382
  433139
  594074
  610555
  634115
  537203
  666901
  600206
  599899
  633796
  534027
  536648
  543652
  666819
  634774
  632978
  473418
  433211
  545373
  696582
  634153
  633123
  545410
  428761
  695122
  600297
  634801
  417349
  647979
  647859
  650180
  600363
  632258
  633792
  406121
  545409
  634198
  634218
  632261
  486871
  545611
  628332
  628383
  647972
  634780
  545418
  545605
  588265
  628333
  533915
  648257
  635275
  598105
]

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 (541197, 696579, 501641, 585984, 530489, 666899, 633806, 672712, 457884, 447959, 537654, 599914, 647993, 647830, 628402, 599965, 600019, 633775, 530378, 647936, 672710, 647952, 633770, 634543, 628382, 433139, 594074, 610555, 634115, 537203, 666901, 600206, 599899, 633796, 534027, 536648, 543652, 666819, 634774, 632978, 473418, 433211, 545373, 696582, 634153, 633123, 545410, 428761, 695122, 600297, 634801, 417349, 647979, 647859, 650180, 600363, 632258, 633792, 406121, 545409, 634198, 634218, 632261, 486871, 545611, 628332, 628383, 647972, 634780, 545418, 545605, 588265, 628333, 533915, 648257, 635275, 598105);

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
  406121
  417349
  428761
  433139
  433211
  447959
  457884
  473418
  486871
  501641
  530378
  530489
  533915
  534027
  536648
  537203
  537654
  541197
  543652
  545373
  545409
  545410
  545418
  545605
  545611
  585984
  588265
  594074
  598105
  599899
  599914
  599965
  600019
  600206
  600297
  600363
  610555
  628332
  628333
  628382
  628383
  628402
  632258
  632261
  632978
  633123
  633770
  633775
  633792
  633796
  633806
  634115
  634153
  634198
  634218
  634543
  634774
  634780
  634801
  635275
  647830
  647859
  647936
  647952
  647972
  647979
  647993
  648257
  650180
  666819
  666899
  666901
  672710
  672712
  695122
  696579
  696582
]

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 (406121, 417349, 428761, 433139, 433211, 447959, 457884, 473418, 486871, 501641, 530378, 530489, 533915, 534027, 536648, 537203, 537654, 541197, 543652, 545373, 545409, 545410, 545418, 545605, 545611, 585984, 588265, 594074, 598105, 599899, 599914, 599965, 600019, 600206, 600297, 600363, 610555, 628332, 628333, 628382, 628383, 628402, 632258, 632261, 632978, 633123, 633770, 633775, 633792, 633796, 633806, 634115, 634153, 634198, 634218, 634543, 634774, 634780, 634801, 635275, 647830, 647859, 647936, 647952, 647972, 647979, 647993, 648257, 650180, 666819, 666899, 666901, 672710, 672712, 695122, 696579, 696582);

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
  406121
  417349
  428761
  433139
  433211
  447959
  457884
  473418
  486871
  501641
  530378
  530489
  533915
  534027
  536648
  537203
  537654
  541197
  543652
  545373
  545409
  545410
  545418
  545605
  545611
  585984
  588265
  594074
  598105
  599899
  599914
  599965
  600019
  600206
  600297
  600363
  610555
  628332
  628333
  628382
  628383
  628402
  632258
  632261
  632978
  633123
  633770
  633775
  633792
  633796
  633806
  634115
  634153
  634198
  634218
  634543
  634774
  634780
  634801
  635275
  647830
  647859
  647936
  647952
  647972
  647979
  647993
  648257
  650180
  666819
  666899
  666901
  672710
  672712
  695122
  696579
  696582
]

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 (406121, 417349, 428761, 433139, 433211, 447959, 457884, 473418, 486871, 501641, 530378, 530489, 533915, 534027, 536648, 537203, 537654, 541197, 543652, 545373, 545409, 545410, 545418, 545605, 545611, 585984, 588265, 594074, 598105, 599899, 599914, 599965, 600019, 600206, 600297, 600363, 610555, 628332, 628333, 628382, 628383, 628402, 632258, 632261, 632978, 633123, 633770, 633775, 633792, 633796, 633806, 634115, 634153, 634198, 634218, 634543, 634774, 634780, 634801, 635275, 647830, 647859, 647936, 647952, 647972, 647979, 647993, 648257, 650180, 666819, 666899, 666901, 672710, 672712, 695122, 696579, 696582);

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

[
  "анал atm"
]

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

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

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

[
  "анал atm"
]

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

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