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

[
  "friends hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'friends hot' 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
  819817
  776686
  779086
  408622
  803318
  819692
  803464
  397912
  613813
  783964
  191420
  612926
  421491
  803595
  773105
  721822
  804525
  763613
  711671
  187990
  359062
  807404
  523133
  620055
  585694
  397907
  194286
  193452
  740690
  421015
  501875
  466555
  511291
  694166
  548757
  557949
  565224
  412208
  654599
  773194
  524472
  533401
  618061
  749658
  588433
  428033
  450213
  557440
  650880
  627815
  399631
  402015
  817446
  474819
  524485
  474053
  793827
  745906
  398712
  482186
  568370
  557473
  511597
  450533
  557937
  572315
  400137
  484119
  488439
  498357
  561351
  427530
  481688
  607372
]

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 (819817, 776686, 779086, 408622, 803318, 819692, 803464, 397912, 613813, 783964, 191420, 612926, 421491, 803595, 773105, 721822, 804525, 763613, 711671, 187990, 359062, 807404, 523133, 620055, 585694, 397907, 194286, 193452, 740690, 421015, 501875, 466555, 511291, 694166, 548757, 557949, 565224, 412208, 654599, 773194, 524472, 533401, 618061, 749658, 588433, 428033, 450213, 557440, 650880, 627815, 399631, 402015, 817446, 474819, 524485, 474053, 793827, 745906, 398712, 482186, 568370, 557473, 511597, 450533, 557937, 572315, 400137, 484119, 488439, 498357, 561351, 427530, 481688, 607372);

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
  187990
  191420
  193452
  194286
  359062
  397907
  397912
  398712
  399631
  400137
  402015
  408622
  412208
  421015
  421491
  427530
  428033
  450213
  450533
  466555
  474053
  474819
  481688
  482186
  484119
  488439
  498357
  501875
  511291
  511597
  523133
  524472
  524485
  533401
  548757
  557440
  557473
  557937
  557949
  561351
  565224
  568370
  572315
  585694
  588433
  607372
  612926
  613813
  618061
  620055
  627815
  650880
  654599
  694166
  711671
  721822
  740690
  745906
  749658
  763613
  773105
  773194
  776686
  779086
  783964
  793827
  803318
  803464
  803595
  804525
  807404
  817446
  819692
  819817
]

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 (187990, 191420, 193452, 194286, 359062, 397907, 397912, 398712, 399631, 400137, 402015, 408622, 412208, 421015, 421491, 427530, 428033, 450213, 450533, 466555, 474053, 474819, 481688, 482186, 484119, 488439, 498357, 501875, 511291, 511597, 523133, 524472, 524485, 533401, 548757, 557440, 557473, 557937, 557949, 561351, 565224, 568370, 572315, 585694, 588433, 607372, 612926, 613813, 618061, 620055, 627815, 650880, 654599, 694166, 711671, 721822, 740690, 745906, 749658, 763613, 773105, 773194, 776686, 779086, 783964, 793827, 803318, 803464, 803595, 804525, 807404, 817446, 819692, 819817);

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
  187990
  191420
  193452
  194286
  359062
  397907
  397912
  398712
  399631
  400137
  402015
  408622
  412208
  421015
  421491
  427530
  428033
  450213
  450533
  466555
  474053
  474819
  481688
  482186
  484119
  488439
  498357
  501875
  511291
  511597
  523133
  524472
  524485
  533401
  548757
  557440
  557473
  557937
  557949
  561351
  565224
  568370
  572315
  585694
  588433
  607372
  612926
  613813
  618061
  620055
  627815
  650880
  654599
  694166
  711671
  721822
  740690
  745906
  749658
  763613
  773105
  773194
  776686
  779086
  783964
  793827
  803318
  803464
  803595
  804525
  807404
  817446
  819692
  819817
]

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 (187990, 191420, 193452, 194286, 359062, 397907, 397912, 398712, 399631, 400137, 402015, 408622, 412208, 421015, 421491, 427530, 428033, 450213, 450533, 466555, 474053, 474819, 481688, 482186, 484119, 488439, 498357, 501875, 511291, 511597, 523133, 524472, 524485, 533401, 548757, 557440, 557473, 557937, 557949, 561351, 565224, 568370, 572315, 585694, 588433, 607372, 612926, 613813, 618061, 620055, 627815, 650880, 654599, 694166, 711671, 721822, 740690, 745906, 749658, 763613, 773105, 773194, 776686, 779086, 783964, 793827, 803318, 803464, 803595, 804525, 807404, 817446, 819692, 819817);

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

[
  "friends hot"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'friends hot';

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

[
  "friends hot"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'friends hot';

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 ?

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