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

[
  "surprise creampie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'surprise creampie' 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
  474507
  787280
  627528
  456444
  708582
  524816
  595967
  397456
  576840
  542972
  474505
  579812
  596730
  381784
  448177
  577641
  579811
  586691
  596497
  796909
  736292
  818135
  746207
  709372
  796031
  761592
  761320
  514710
  733146
  810583
  761874
  826634
  759088
  635389
  802581
  711936
  761484
  810587
  453958
  687463
  605625
  810842
  775640
  750100
  723233
  593594
  612977
  425401
  421376
  535461
  472446
  806614
  450192
  480737
  459768
  601401
  590461
  760955
  785945
  407157
  511421
  579821
  726882
  420853
  505846
  579858
  549534
  585942
  773565
  416255
  572697
  586009
  583371
]

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 (474507, 787280, 627528, 456444, 708582, 524816, 595967, 397456, 576840, 542972, 474505, 579812, 596730, 381784, 448177, 577641, 579811, 586691, 596497, 796909, 736292, 818135, 746207, 709372, 796031, 761592, 761320, 514710, 733146, 810583, 761874, 826634, 759088, 635389, 802581, 711936, 761484, 810587, 453958, 687463, 605625, 810842, 775640, 750100, 723233, 593594, 612977, 425401, 421376, 535461, 472446, 806614, 450192, 480737, 459768, 601401, 590461, 760955, 785945, 407157, 511421, 579821, 726882, 420853, 505846, 579858, 549534, 585942, 773565, 416255, 572697, 586009, 583371);

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
  381784
  397456
  407157
  416255
  420853
  421376
  425401
  448177
  450192
  453958
  456444
  459768
  472446
  474505
  474507
  480737
  505846
  511421
  514710
  524816
  535461
  542972
  549534
  572697
  576840
  577641
  579811
  579812
  579821
  579858
  583371
  585942
  586009
  586691
  590461
  593594
  595967
  596497
  596730
  601401
  605625
  612977
  627528
  635389
  687463
  708582
  709372
  711936
  723233
  726882
  733146
  736292
  746207
  750100
  759088
  760955
  761320
  761484
  761592
  761874
  773565
  775640
  785945
  787280
  796031
  796909
  802581
  806614
  810583
  810587
  810842
  818135
  826634
]

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 (381784, 397456, 407157, 416255, 420853, 421376, 425401, 448177, 450192, 453958, 456444, 459768, 472446, 474505, 474507, 480737, 505846, 511421, 514710, 524816, 535461, 542972, 549534, 572697, 576840, 577641, 579811, 579812, 579821, 579858, 583371, 585942, 586009, 586691, 590461, 593594, 595967, 596497, 596730, 601401, 605625, 612977, 627528, 635389, 687463, 708582, 709372, 711936, 723233, 726882, 733146, 736292, 746207, 750100, 759088, 760955, 761320, 761484, 761592, 761874, 773565, 775640, 785945, 787280, 796031, 796909, 802581, 806614, 810583, 810587, 810842, 818135, 826634);

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
  381784
  397456
  407157
  416255
  420853
  421376
  425401
  448177
  450192
  453958
  456444
  459768
  472446
  474505
  474507
  480737
  505846
  511421
  514710
  524816
  535461
  542972
  549534
  572697
  576840
  577641
  579811
  579812
  579821
  579858
  583371
  585942
  586009
  586691
  590461
  593594
  595967
  596497
  596730
  601401
  605625
  612977
  627528
  635389
  687463
  708582
  709372
  711936
  723233
  726882
  733146
  736292
  746207
  750100
  759088
  760955
  761320
  761484
  761592
  761874
  773565
  775640
  785945
  787280
  796031
  796909
  802581
  806614
  810583
  810587
  810842
  818135
  826634
]

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 (381784, 397456, 407157, 416255, 420853, 421376, 425401, 448177, 450192, 453958, 456444, 459768, 472446, 474505, 474507, 480737, 505846, 511421, 514710, 524816, 535461, 542972, 549534, 572697, 576840, 577641, 579811, 579812, 579821, 579858, 583371, 585942, 586009, 586691, 590461, 593594, 595967, 596497, 596730, 601401, 605625, 612977, 627528, 635389, 687463, 708582, 709372, 711936, 723233, 726882, 733146, 736292, 746207, 750100, 759088, 760955, 761320, 761484, 761592, 761874, 773565, 775640, 785945, 787280, 796031, 796909, 802581, 806614, 810583, 810587, 810842, 818135, 826634);

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

[
  "surprise creampie"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'surprise creampie';

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

[
  "surprise creampie"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'surprise creampie';

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 ?

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