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

[
  "fell"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'fell' 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
  537118
  532018
  531998
  532017
  532030
  828030
  818580
  808289
  795747
  395192
  700922
  815795
  670829
  623184
  441965
  614755
  712785
  519782
  761491
  788784
  761625
  716844
  509484
  455326
  537132
  528851
  554403
  559699
  678992
  629947
  787950
  484115
  506480
  495437
  521203
  532010
  532016
  507695
  511190
  559441
  585723
  739251
  458061
  446608
  457675
  468963
  513552
  518388
  453731
  457686
  532020
  519438
  528832
  532011
  552812
  581746
  566843
  432899
  532015
  532024
  542745
  544858
  391262
  532019
  532029
  518965
  532037
  439591
  513565
  518959
  499718
  532009
  512502
  661528
]

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 (537118, 532018, 531998, 532017, 532030, 828030, 818580, 808289, 795747, 395192, 700922, 815795, 670829, 623184, 441965, 614755, 712785, 519782, 761491, 788784, 761625, 716844, 509484, 455326, 537132, 528851, 554403, 559699, 678992, 629947, 787950, 484115, 506480, 495437, 521203, 532010, 532016, 507695, 511190, 559441, 585723, 739251, 458061, 446608, 457675, 468963, 513552, 518388, 453731, 457686, 532020, 519438, 528832, 532011, 552812, 581746, 566843, 432899, 532015, 532024, 542745, 544858, 391262, 532019, 532029, 518965, 532037, 439591, 513565, 518959, 499718, 532009, 512502, 661528);

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
  391262
  395192
  432899
  439591
  441965
  446608
  453731
  455326
  457675
  457686
  458061
  468963
  484115
  495437
  499718
  506480
  507695
  509484
  511190
  512502
  513552
  513565
  518388
  518959
  518965
  519438
  519782
  521203
  528832
  528851
  531998
  532009
  532010
  532011
  532015
  532016
  532017
  532018
  532019
  532020
  532024
  532029
  532030
  532037
  537118
  537132
  542745
  544858
  552812
  554403
  559441
  559699
  566843
  581746
  585723
  614755
  623184
  629947
  661528
  670829
  678992
  700922
  712785
  716844
  739251
  761491
  761625
  787950
  788784
  795747
  808289
  815795
  818580
  828030
]

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 (391262, 395192, 432899, 439591, 441965, 446608, 453731, 455326, 457675, 457686, 458061, 468963, 484115, 495437, 499718, 506480, 507695, 509484, 511190, 512502, 513552, 513565, 518388, 518959, 518965, 519438, 519782, 521203, 528832, 528851, 531998, 532009, 532010, 532011, 532015, 532016, 532017, 532018, 532019, 532020, 532024, 532029, 532030, 532037, 537118, 537132, 542745, 544858, 552812, 554403, 559441, 559699, 566843, 581746, 585723, 614755, 623184, 629947, 661528, 670829, 678992, 700922, 712785, 716844, 739251, 761491, 761625, 787950, 788784, 795747, 808289, 815795, 818580, 828030);

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
  391262
  395192
  432899
  439591
  441965
  446608
  453731
  455326
  457675
  457686
  458061
  468963
  484115
  495437
  499718
  506480
  507695
  509484
  511190
  512502
  513552
  513565
  518388
  518959
  518965
  519438
  519782
  521203
  528832
  528851
  531998
  532009
  532010
  532011
  532015
  532016
  532017
  532018
  532019
  532020
  532024
  532029
  532030
  532037
  537118
  537132
  542745
  544858
  552812
  554403
  559441
  559699
  566843
  581746
  585723
  614755
  623184
  629947
  661528
  670829
  678992
  700922
  712785
  716844
  739251
  761491
  761625
  787950
  788784
  795747
  808289
  815795
  818580
  828030
]

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 (391262, 395192, 432899, 439591, 441965, 446608, 453731, 455326, 457675, 457686, 458061, 468963, 484115, 495437, 499718, 506480, 507695, 509484, 511190, 512502, 513552, 513565, 518388, 518959, 518965, 519438, 519782, 521203, 528832, 528851, 531998, 532009, 532010, 532011, 532015, 532016, 532017, 532018, 532019, 532020, 532024, 532029, 532030, 532037, 537118, 537132, 542745, 544858, 552812, 554403, 559441, 559699, 566843, 581746, 585723, 614755, 623184, 629947, 661528, 670829, 678992, 700922, 712785, 716844, 739251, 761491, 761625, 787950, 788784, 795747, 808289, 815795, 818580, 828030);

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

[
  "fell"
]

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

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

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

[
  "fell"
]

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

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

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 ?

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