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

[
  "creampie surprise"
]

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

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

[
  "creampie surprise"
]

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

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

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

[
  "creampie surprise"
]

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

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

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 ?

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