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 creampie piss"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'anal creampie piss' 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
  811844
  647844
  614428
  595699
  632635
  541856
  646930
  599955
  634139
  639716
  641681
  647893
  599865
  728276
  715888
  668555
  632703
  632654
  634780
  599875
  649215
  599945
  647948
  647885
  639802
  540577
  632691
  632645
  630531
  633502
  637413
  647838
  702677
  631209
  632663
  666883
  635275
  639796
  641955
  600363
  545389
  641953
  639060
  698133
  600268
  647860
  666850
  676428
  601578
  656507
  695123
  642774
  639751
  666534
  666877
  651168
  600340
  651627
  599990
  600332
  640762
  599864
  566729
  627807
  666539
  666540
  600171
  647994
  600206
  633792
  639767
  600021
  600252
  641978
]

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 (811844, 647844, 614428, 595699, 632635, 541856, 646930, 599955, 634139, 639716, 641681, 647893, 599865, 728276, 715888, 668555, 632703, 632654, 634780, 599875, 649215, 599945, 647948, 647885, 639802, 540577, 632691, 632645, 630531, 633502, 637413, 647838, 702677, 631209, 632663, 666883, 635275, 639796, 641955, 600363, 545389, 641953, 639060, 698133, 600268, 647860, 666850, 676428, 601578, 656507, 695123, 642774, 639751, 666534, 666877, 651168, 600340, 651627, 599990, 600332, 640762, 599864, 566729, 627807, 666539, 666540, 600171, 647994, 600206, 633792, 639767, 600021, 600252, 641978);

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
  540577
  541856
  545389
  566729
  595699
  599864
  599865
  599875
  599945
  599955
  599990
  600021
  600171
  600206
  600252
  600268
  600332
  600340
  600363
  601578
  614428
  627807
  630531
  631209
  632635
  632645
  632654
  632663
  632691
  632703
  633502
  633792
  634139
  634780
  635275
  637413
  639060
  639716
  639751
  639767
  639796
  639802
  640762
  641681
  641953
  641955
  641978
  642774
  646930
  647838
  647844
  647860
  647885
  647893
  647948
  647994
  649215
  651168
  651627
  656507
  666534
  666539
  666540
  666850
  666877
  666883
  668555
  676428
  695123
  698133
  702677
  715888
  728276
  811844
]

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 (540577, 541856, 545389, 566729, 595699, 599864, 599865, 599875, 599945, 599955, 599990, 600021, 600171, 600206, 600252, 600268, 600332, 600340, 600363, 601578, 614428, 627807, 630531, 631209, 632635, 632645, 632654, 632663, 632691, 632703, 633502, 633792, 634139, 634780, 635275, 637413, 639060, 639716, 639751, 639767, 639796, 639802, 640762, 641681, 641953, 641955, 641978, 642774, 646930, 647838, 647844, 647860, 647885, 647893, 647948, 647994, 649215, 651168, 651627, 656507, 666534, 666539, 666540, 666850, 666877, 666883, 668555, 676428, 695123, 698133, 702677, 715888, 728276, 811844);

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
  540577
  541856
  545389
  566729
  595699
  599864
  599865
  599875
  599945
  599955
  599990
  600021
  600171
  600206
  600252
  600268
  600332
  600340
  600363
  601578
  614428
  627807
  630531
  631209
  632635
  632645
  632654
  632663
  632691
  632703
  633502
  633792
  634139
  634780
  635275
  637413
  639060
  639716
  639751
  639767
  639796
  639802
  640762
  641681
  641953
  641955
  641978
  642774
  646930
  647838
  647844
  647860
  647885
  647893
  647948
  647994
  649215
  651168
  651627
  656507
  666534
  666539
  666540
  666850
  666877
  666883
  668555
  676428
  695123
  698133
  702677
  715888
  728276
  811844
]

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 (540577, 541856, 545389, 566729, 595699, 599864, 599865, 599875, 599945, 599955, 599990, 600021, 600171, 600206, 600252, 600268, 600332, 600340, 600363, 601578, 614428, 627807, 630531, 631209, 632635, 632645, 632654, 632663, 632691, 632703, 633502, 633792, 634139, 634780, 635275, 637413, 639060, 639716, 639751, 639767, 639796, 639802, 640762, 641681, 641953, 641955, 641978, 642774, 646930, 647838, 647844, 647860, 647885, 647893, 647948, 647994, 649215, 651168, 651627, 656507, 666534, 666539, 666540, 666850, 666877, 666883, 668555, 676428, 695123, 698133, 702677, 715888, 728276, 811844);

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

[
  "анал creampie писсинг"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'анал creampie писсинг';

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

[
  "анал creampie писсинг"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'анал creampie писсинг';