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

[
  "score"
]

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

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

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

[
  b"\x01”+ÆÁ…r °\x1D½n.\x0E"$"
]

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

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x01942BC6C1857220B01DBD6E2E0E2224 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
  608226
  625906
  628273
  598838
  601982
  607256
  598770
  599177
  620559
  623876
  632304
  600035
  621559
  436074
  407597
  518270
  484924
  511469
  516999
  522077
  529216
  521307
  525154
  525965
  530064
  528807
  529485
  561478
  564901
  652947
  654740
  653238
  684305
  605840
  589068
  596500
  610575
  613014
  621259
  624109
  625983
  590448
  591314
  617205
  599191
  609280
  621340
  608771
  617219
  625239
  404584
  446376
  475294
  512050
  516308
  522035
  523336
  529162
  515184
  519249
  520737
  482944
  526546
  585007
  542187
  584720
  548870
  618889
  615449
  620205
  624428
  418686
  472597
  528398
  507421
  526220
  541804
  594121
  616994
  541866
  532482
]

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 (608226, 625906, 628273, 598838, 601982, 607256, 598770, 599177, 620559, 623876, 632304, 600035, 621559, 436074, 407597, 518270, 484924, 511469, 516999, 522077, 529216, 521307, 525154, 525965, 530064, 528807, 529485, 561478, 564901, 652947, 654740, 653238, 684305, 605840, 589068, 596500, 610575, 613014, 621259, 624109, 625983, 590448, 591314, 617205, 599191, 609280, 621340, 608771, 617219, 625239, 404584, 446376, 475294, 512050, 516308, 522035, 523336, 529162, 515184, 519249, 520737, 482944, 526546, 585007, 542187, 584720, 548870, 618889, 615449, 620205, 624428, 418686, 472597, 528398, 507421, 526220, 541804, 594121, 616994, 541866, 532482);

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
  404584
  407597
  418686
  436074
  446376
  472597
  475294
  482944
  484924
  507421
  511469
  512050
  515184
  516308
  516999
  518270
  519249
  520737
  521307
  522035
  522077
  523336
  525154
  525965
  526220
  526546
  528398
  528807
  529162
  529216
  529485
  530064
  532482
  541804
  541866
  542187
  548870
  561478
  564901
  584720
  585007
  589068
  590448
  591314
  594121
  596500
  598770
  598838
  599177
  599191
  600035
  601982
  605840
  607256
  608226
  608771
  609280
  610575
  613014
  615449
  616994
  617205
  617219
  618889
  620205
  620559
  621259
  621340
  621559
  623876
  624109
  624428
  625239
  625906
  625983
  628273
  632304
  652947
  653238
  654740
  684305
]

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 (404584, 407597, 418686, 436074, 446376, 472597, 475294, 482944, 484924, 507421, 511469, 512050, 515184, 516308, 516999, 518270, 519249, 520737, 521307, 522035, 522077, 523336, 525154, 525965, 526220, 526546, 528398, 528807, 529162, 529216, 529485, 530064, 532482, 541804, 541866, 542187, 548870, 561478, 564901, 584720, 585007, 589068, 590448, 591314, 594121, 596500, 598770, 598838, 599177, 599191, 600035, 601982, 605840, 607256, 608226, 608771, 609280, 610575, 613014, 615449, 616994, 617205, 617219, 618889, 620205, 620559, 621259, 621340, 621559, 623876, 624109, 624428, 625239, 625906, 625983, 628273, 632304, 652947, 653238, 654740, 684305);

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
  404584
  407597
  418686
  436074
  446376
  472597
  475294
  482944
  484924
  507421
  511469
  512050
  515184
  516308
  516999
  518270
  519249
  520737
  521307
  522035
  522077
  523336
  525154
  525965
  526220
  526546
  528398
  528807
  529162
  529216
  529485
  530064
  532482
  541804
  541866
  542187
  548870
  561478
  564901
  584720
  585007
  589068
  590448
  591314
  594121
  596500
  598770
  598838
  599177
  599191
  600035
  601982
  605840
  607256
  608226
  608771
  609280
  610575
  613014
  615449
  616994
  617205
  617219
  618889
  620205
  620559
  621259
  621340
  621559
  623876
  624109
  624428
  625239
  625906
  625983
  628273
  632304
  652947
  653238
  654740
  684305
]

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 (404584, 407597, 418686, 436074, 446376, 472597, 475294, 482944, 484924, 507421, 511469, 512050, 515184, 516308, 516999, 518270, 519249, 520737, 521307, 522035, 522077, 523336, 525154, 525965, 526220, 526546, 528398, 528807, 529162, 529216, 529485, 530064, 532482, 541804, 541866, 542187, 548870, 561478, 564901, 584720, 585007, 589068, 590448, 591314, 594121, 596500, 598770, 598838, 599177, 599191, 600035, 601982, 605840, 607256, 608226, 608771, 609280, 610575, 613014, 615449, 616994, 617205, 617219, 618889, 620205, 620559, 621259, 621340, 621559, 623876, 624109, 624428, 625239, 625906, 625983, 628273, 632304, 652947, 653238, 654740, 684305);

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

[
  "score"
]

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

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

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

[
  "score"
]

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

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