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

[
  "sneak"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'sneak' 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
  802300
  666007
  535281
  791347
  709382
  709433
  790007
  725592
  800083
  757861
  710589
  775761
  394400
  817611
  815398
  702188
  716401
  706369
  730627
  759103
  696578
  708044
  714339
  629667
  808818
  767436
  820761
  696603
  789301
  756868
  755613
  708702
  546274
  758386
  616080
  632137
  542812
  758430
  736450
  816242
  516014
  583269
  581183
  680618
  615558
  806983
  738936
  764029
  435165
  443073
  522379
  592152
  597918
  636658
  729239
  401031
  684298
  710852
  609815
  626876
  626207
  753517
  424502
  515100
  560489
  585966
  499581
  560111
  439226
  545622
  580125
  507202
  581616
]

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 (802300, 666007, 535281, 791347, 709382, 709433, 790007, 725592, 800083, 757861, 710589, 775761, 394400, 817611, 815398, 702188, 716401, 706369, 730627, 759103, 696578, 708044, 714339, 629667, 808818, 767436, 820761, 696603, 789301, 756868, 755613, 708702, 546274, 758386, 616080, 632137, 542812, 758430, 736450, 816242, 516014, 583269, 581183, 680618, 615558, 806983, 738936, 764029, 435165, 443073, 522379, 592152, 597918, 636658, 729239, 401031, 684298, 710852, 609815, 626876, 626207, 753517, 424502, 515100, 560489, 585966, 499581, 560111, 439226, 545622, 580125, 507202, 581616);

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
  394400
  401031
  424502
  435165
  439226
  443073
  499581
  507202
  515100
  516014
  522379
  535281
  542812
  545622
  546274
  560111
  560489
  580125
  581183
  581616
  583269
  585966
  592152
  597918
  609815
  615558
  616080
  626207
  626876
  629667
  632137
  636658
  666007
  680618
  684298
  696578
  696603
  702188
  706369
  708044
  708702
  709382
  709433
  710589
  710852
  714339
  716401
  725592
  729239
  730627
  736450
  738936
  753517
  755613
  756868
  757861
  758386
  758430
  759103
  764029
  767436
  775761
  789301
  790007
  791347
  800083
  802300
  806983
  808818
  815398
  816242
  817611
  820761
]

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 (394400, 401031, 424502, 435165, 439226, 443073, 499581, 507202, 515100, 516014, 522379, 535281, 542812, 545622, 546274, 560111, 560489, 580125, 581183, 581616, 583269, 585966, 592152, 597918, 609815, 615558, 616080, 626207, 626876, 629667, 632137, 636658, 666007, 680618, 684298, 696578, 696603, 702188, 706369, 708044, 708702, 709382, 709433, 710589, 710852, 714339, 716401, 725592, 729239, 730627, 736450, 738936, 753517, 755613, 756868, 757861, 758386, 758430, 759103, 764029, 767436, 775761, 789301, 790007, 791347, 800083, 802300, 806983, 808818, 815398, 816242, 817611, 820761);

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
  394400
  401031
  424502
  435165
  439226
  443073
  499581
  507202
  515100
  516014
  522379
  535281
  542812
  545622
  546274
  560111
  560489
  580125
  581183
  581616
  583269
  585966
  592152
  597918
  609815
  615558
  616080
  626207
  626876
  629667
  632137
  636658
  666007
  680618
  684298
  696578
  696603
  702188
  706369
  708044
  708702
  709382
  709433
  710589
  710852
  714339
  716401
  725592
  729239
  730627
  736450
  738936
  753517
  755613
  756868
  757861
  758386
  758430
  759103
  764029
  767436
  775761
  789301
  790007
  791347
  800083
  802300
  806983
  808818
  815398
  816242
  817611
  820761
]

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 (394400, 401031, 424502, 435165, 439226, 443073, 499581, 507202, 515100, 516014, 522379, 535281, 542812, 545622, 546274, 560111, 560489, 580125, 581183, 581616, 583269, 585966, 592152, 597918, 609815, 615558, 616080, 626207, 626876, 629667, 632137, 636658, 666007, 680618, 684298, 696578, 696603, 702188, 706369, 708044, 708702, 709382, 709433, 710589, 710852, 714339, 716401, 725592, 729239, 730627, 736450, 738936, 753517, 755613, 756868, 757861, 758386, 758430, 759103, 764029, 767436, 775761, 789301, 790007, 791347, 800083, 802300, 806983, 808818, 815398, 816242, 817611, 820761);

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

[
  "sneak"
]

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

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

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

[
  "sneak"
]

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

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

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 ?

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