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

[
  "bbc petite"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc petite' 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
  536242
  543866
  722529
  722527
  789013
  758876
  459371
  472470
  425320
  406172
  445726
  446873
  468797
  532926
  536911
  531166
  534804
  543260
  573081
  592067
  812876
  489607
  519105
  414666
  505103
  534787
  572021
  575905
  575852
  580706
  628910
  596160
  612844
  399414
  429305
  446108
  601834
  632563
  414098
  458125
  457751
  530385
  530623
  531198
  543865
  566324
  650333
  632699
  390413
  525348
  408460
  413944
  532984
  604460
  518470
  530493
  494622
  554770
  568554
  642385
  586596
  599912
  434001
  475704
  556030
  674962
  589484
  623203
  520775
  602939
  674943
  542548
  551137
]

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 (536242, 543866, 722529, 722527, 789013, 758876, 459371, 472470, 425320, 406172, 445726, 446873, 468797, 532926, 536911, 531166, 534804, 543260, 573081, 592067, 812876, 489607, 519105, 414666, 505103, 534787, 572021, 575905, 575852, 580706, 628910, 596160, 612844, 399414, 429305, 446108, 601834, 632563, 414098, 458125, 457751, 530385, 530623, 531198, 543865, 566324, 650333, 632699, 390413, 525348, 408460, 413944, 532984, 604460, 518470, 530493, 494622, 554770, 568554, 642385, 586596, 599912, 434001, 475704, 556030, 674962, 589484, 623203, 520775, 602939, 674943, 542548, 551137);

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
  390413
  399414
  406172
  408460
  413944
  414098
  414666
  425320
  429305
  434001
  445726
  446108
  446873
  457751
  458125
  459371
  468797
  472470
  475704
  489607
  494622
  505103
  518470
  519105
  520775
  525348
  530385
  530493
  530623
  531166
  531198
  532926
  532984
  534787
  534804
  536242
  536911
  542548
  543260
  543865
  543866
  551137
  554770
  556030
  566324
  568554
  572021
  573081
  575852
  575905
  580706
  586596
  589484
  592067
  596160
  599912
  601834
  602939
  604460
  612844
  623203
  628910
  632563
  632699
  642385
  650333
  674943
  674962
  722527
  722529
  758876
  789013
  812876
]

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 (390413, 399414, 406172, 408460, 413944, 414098, 414666, 425320, 429305, 434001, 445726, 446108, 446873, 457751, 458125, 459371, 468797, 472470, 475704, 489607, 494622, 505103, 518470, 519105, 520775, 525348, 530385, 530493, 530623, 531166, 531198, 532926, 532984, 534787, 534804, 536242, 536911, 542548, 543260, 543865, 543866, 551137, 554770, 556030, 566324, 568554, 572021, 573081, 575852, 575905, 580706, 586596, 589484, 592067, 596160, 599912, 601834, 602939, 604460, 612844, 623203, 628910, 632563, 632699, 642385, 650333, 674943, 674962, 722527, 722529, 758876, 789013, 812876);

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
  390413
  399414
  406172
  408460
  413944
  414098
  414666
  425320
  429305
  434001
  445726
  446108
  446873
  457751
  458125
  459371
  468797
  472470
  475704
  489607
  494622
  505103
  518470
  519105
  520775
  525348
  530385
  530493
  530623
  531166
  531198
  532926
  532984
  534787
  534804
  536242
  536911
  542548
  543260
  543865
  543866
  551137
  554770
  556030
  566324
  568554
  572021
  573081
  575852
  575905
  580706
  586596
  589484
  592067
  596160
  599912
  601834
  602939
  604460
  612844
  623203
  628910
  632563
  632699
  642385
  650333
  674943
  674962
  722527
  722529
  758876
  789013
  812876
]

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 (390413, 399414, 406172, 408460, 413944, 414098, 414666, 425320, 429305, 434001, 445726, 446108, 446873, 457751, 458125, 459371, 468797, 472470, 475704, 489607, 494622, 505103, 518470, 519105, 520775, 525348, 530385, 530493, 530623, 531166, 531198, 532926, 532984, 534787, 534804, 536242, 536911, 542548, 543260, 543865, 543866, 551137, 554770, 556030, 566324, 568554, 572021, 573081, 575852, 575905, 580706, 586596, 589484, 592067, 596160, 599912, 601834, 602939, 604460, 612844, 623203, 628910, 632563, 632699, 642385, 650333, 674943, 674962, 722527, 722529, 758876, 789013, 812876);

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

[
  "bbc petite"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'bbc petite';

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

[
  "bbc petite"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bbc petite';

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 ?

[
  "bbc petite"
  "bbc petite"
  "bbc petite"
  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 ('bbc petite') AS `relevance`
            FROM `search_log`
            WHERE MATCH (`query`) AGAINST ('bbc petite')
              AND `query` <> 'bbc petite'
              AND `blocked` = 0
            ORDER BY `relevance` DESC
            LIMIT 20
        ;