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

[
  "gym"
]

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

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

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

[
  b"\x01ô┤:ÇöpÑ▒<.RÉÔ╣["
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x0193B43A809470A5B13C2E5290E2B95B 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
  446453
  518026
  515813
  523653
  426258
  415843
  435488
  464075
  521525
  521326
  531227
  523855
  535422
  498285
  522648
  524157
  553478
  577316
  546311
  558418
  584592
  613853
  586043
  410615
  443010
  395602
  445646
  390634
  463544
  514969
  518252
  523861
  415005
  416200
  445687
  486290
  523860
  519876
  546987
  681647
  562475
  572259
  584945
  587066
  454890
  521059
  529710
  523863
  438934
  523868
  608716
  610096
  601650
  480945
  418361
  496269
  515605
  510169
  535417
  580135
  639783
  523857
  496270
  520306
  523588
  507651
  568088
  624272
  523720
  528923
  620015
  591272
  522562
  550599
]

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 (446453, 518026, 515813, 523653, 426258, 415843, 435488, 464075, 521525, 521326, 531227, 523855, 535422, 498285, 522648, 524157, 553478, 577316, 546311, 558418, 584592, 613853, 586043, 410615, 443010, 395602, 445646, 390634, 463544, 514969, 518252, 523861, 415005, 416200, 445687, 486290, 523860, 519876, 546987, 681647, 562475, 572259, 584945, 587066, 454890, 521059, 529710, 523863, 438934, 523868, 608716, 610096, 601650, 480945, 418361, 496269, 515605, 510169, 535417, 580135, 639783, 523857, 496270, 520306, 523588, 507651, 568088, 624272, 523720, 528923, 620015, 591272, 522562, 550599);

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
  390634
  395602
  410615
  415005
  415843
  416200
  418361
  426258
  435488
  438934
  443010
  445646
  445687
  446453
  454890
  463544
  464075
  480945
  486290
  496269
  496270
  498285
  507651
  510169
  514969
  515605
  515813
  518026
  518252
  519876
  520306
  521059
  521326
  521525
  522562
  522648
  523588
  523653
  523720
  523855
  523857
  523860
  523861
  523863
  523868
  524157
  528923
  529710
  531227
  535417
  535422
  546311
  546987
  550599
  553478
  558418
  562475
  568088
  572259
  577316
  580135
  584592
  584945
  586043
  587066
  591272
  601650
  608716
  610096
  613853
  620015
  624272
  639783
  681647
]

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 (390634, 395602, 410615, 415005, 415843, 416200, 418361, 426258, 435488, 438934, 443010, 445646, 445687, 446453, 454890, 463544, 464075, 480945, 486290, 496269, 496270, 498285, 507651, 510169, 514969, 515605, 515813, 518026, 518252, 519876, 520306, 521059, 521326, 521525, 522562, 522648, 523588, 523653, 523720, 523855, 523857, 523860, 523861, 523863, 523868, 524157, 528923, 529710, 531227, 535417, 535422, 546311, 546987, 550599, 553478, 558418, 562475, 568088, 572259, 577316, 580135, 584592, 584945, 586043, 587066, 591272, 601650, 608716, 610096, 613853, 620015, 624272, 639783, 681647);

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
  390634
  395602
  410615
  415005
  415843
  416200
  418361
  426258
  435488
  438934
  443010
  445646
  445687
  446453
  454890
  463544
  464075
  480945
  486290
  496269
  496270
  498285
  507651
  510169
  514969
  515605
  515813
  518026
  518252
  519876
  520306
  521059
  521326
  521525
  522562
  522648
  523588
  523653
  523720
  523855
  523857
  523860
  523861
  523863
  523868
  524157
  528923
  529710
  531227
  535417
  535422
  546311
  546987
  550599
  553478
  558418
  562475
  568088
  572259
  577316
  580135
  584592
  584945
  586043
  587066
  591272
  601650
  608716
  610096
  613853
  620015
  624272
  639783
  681647
]

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 (390634, 395602, 410615, 415005, 415843, 416200, 418361, 426258, 435488, 438934, 443010, 445646, 445687, 446453, 454890, 463544, 464075, 480945, 486290, 496269, 496270, 498285, 507651, 510169, 514969, 515605, 515813, 518026, 518252, 519876, 520306, 521059, 521326, 521525, 522562, 522648, 523588, 523653, 523720, 523855, 523857, 523860, 523861, 523863, 523868, 524157, 528923, 529710, 531227, 535417, 535422, 546311, 546987, 550599, 553478, 558418, 562475, 568088, 572259, 577316, 580135, 584592, 584945, 586043, 587066, 591272, 601650, 608716, 610096, 613853, 620015, 624272, 639783, 681647);

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

[
  "gym"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'gym';

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

[
  "gym"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'gym';