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

[
  "rocco siffredi 2024"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'rocco siffredi 2024' 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
  533536
  142823
  522879
  789841
  526782
  789844
  486179
  648232
  716323
  576712
  401261
  576715
  41433
  699540
  541378
  523549
  576690
  576711
  699594
  504481
  421363
  397303
  699567
  385457
  506801
  595511
  715676
  465980
  282218
  472317
  522917
  533802
  516744
  10665
  530469
  47854
  397308
  488721
  401677
  396732
  513267
  104130
  445269
  475824
  391523
  464187
  447454
  447466
  448830
  457291
  533798
  474766
  548694
  448831
  451552
  453918
  448820
  446337
  486182
  600330
  467597
  452058
  511816
  475830
  542519
  605306
  418416
  421562
  511812
  524992
  514820
  429572
  592346
]

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 (533536, 142823, 522879, 789841, 526782, 789844, 486179, 648232, 716323, 576712, 401261, 576715, 41433, 699540, 541378, 523549, 576690, 576711, 699594, 504481, 421363, 397303, 699567, 385457, 506801, 595511, 715676, 465980, 282218, 472317, 522917, 533802, 516744, 10665, 530469, 47854, 397308, 488721, 401677, 396732, 513267, 104130, 445269, 475824, 391523, 464187, 447454, 447466, 448830, 457291, 533798, 474766, 548694, 448831, 451552, 453918, 448820, 446337, 486182, 600330, 467597, 452058, 511816, 475830, 542519, 605306, 418416, 421562, 511812, 524992, 514820, 429572, 592346);

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
  10665
  41433
  47854
  104130
  142823
  282218
  385457
  391523
  396732
  397303
  397308
  401261
  401677
  418416
  421363
  421562
  429572
  445269
  446337
  447454
  447466
  448820
  448830
  448831
  451552
  452058
  453918
  457291
  464187
  465980
  467597
  472317
  474766
  475824
  475830
  486179
  486182
  488721
  504481
  506801
  511812
  511816
  513267
  514820
  516744
  522879
  522917
  523549
  524992
  526782
  530469
  533536
  533798
  533802
  541378
  542519
  548694
  576690
  576711
  576712
  576715
  592346
  595511
  600330
  605306
  648232
  699540
  699567
  699594
  715676
  716323
  789841
  789844
]

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 (10665, 41433, 47854, 104130, 142823, 282218, 385457, 391523, 396732, 397303, 397308, 401261, 401677, 418416, 421363, 421562, 429572, 445269, 446337, 447454, 447466, 448820, 448830, 448831, 451552, 452058, 453918, 457291, 464187, 465980, 467597, 472317, 474766, 475824, 475830, 486179, 486182, 488721, 504481, 506801, 511812, 511816, 513267, 514820, 516744, 522879, 522917, 523549, 524992, 526782, 530469, 533536, 533798, 533802, 541378, 542519, 548694, 576690, 576711, 576712, 576715, 592346, 595511, 600330, 605306, 648232, 699540, 699567, 699594, 715676, 716323, 789841, 789844);

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
  10665
  41433
  47854
  104130
  142823
  282218
  385457
  391523
  396732
  397303
  397308
  401261
  401677
  418416
  421363
  421562
  429572
  445269
  446337
  447454
  447466
  448820
  448830
  448831
  451552
  452058
  453918
  457291
  464187
  465980
  467597
  472317
  474766
  475824
  475830
  486179
  486182
  488721
  504481
  506801
  511812
  511816
  513267
  514820
  516744
  522879
  522917
  523549
  524992
  526782
  530469
  533536
  533798
  533802
  541378
  542519
  548694
  576690
  576711
  576712
  576715
  592346
  595511
  600330
  605306
  648232
  699540
  699567
  699594
  715676
  716323
  789841
  789844
]

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 (10665, 41433, 47854, 104130, 142823, 282218, 385457, 391523, 396732, 397303, 397308, 401261, 401677, 418416, 421363, 421562, 429572, 445269, 446337, 447454, 447466, 448820, 448830, 448831, 451552, 452058, 453918, 457291, 464187, 465980, 467597, 472317, 474766, 475824, 475830, 486179, 486182, 488721, 504481, 506801, 511812, 511816, 513267, 514820, 516744, 522879, 522917, 523549, 524992, 526782, 530469, 533536, 533798, 533802, 541378, 542519, 548694, 576690, 576711, 576712, 576715, 592346, 595511, 600330, 605306, 648232, 699540, 699567, 699594, 715676, 716323, 789841, 789844);

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

[
  "roccosiffredi"
]

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

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

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

[
  "roccosiffredi"
]

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

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

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST (?) AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST (?)
              AND `query` <> ?
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT ?

[
  "rocco siffredi 2024"
  "rocco siffredi 2024"
  "rocco siffredi 2024"
  20
]

SELECT
  `query_id`,
  `cover`,
  `query`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  `search_log`
WHERE
  MATCH (`query`) AGAINST (?)
  AND `query` <> ?
  AND `blocked` = 0
ORDER BY
  `relevance` DESC
LIMIT
  ?

SELECT `query_id`, `cover`, `query`, MATCH (`query`) AGAINST ('rocco siffredi 2024') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('rocco siffredi 2024')
              AND `query` <> 'rocco siffredi 2024'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;