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

[
  "curly hair girl"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curly hair girl' 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
  21210
  584995
  537925
  544803
  804574
  755045
  828587
  743276
  821215
  753691
  702762
  771982
  686255
  719397
  742137
  692100
  799756
  736943
  600903
  696929
  569578
  721941
  527795
  757337
  496763
  625597
  731159
  617730
  471536
  734022
  810191
  54301
  557931
  553475
  684829
  670513
  757151
  514085
  505353
  566083
  466934
  567402
  733538
  625578
  482411
  542359
  449911
  552308
  563294
  716409
  700179
  639897
  454938
  483610
  484920
  480975
  461579
  567745
  501830
  524004
  418704
  523958
  679721
  560387
  513730
  510887
  423027
  582790
  556728
  456024
  496762
  557118
  424746
]

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 (21210, 584995, 537925, 544803, 804574, 755045, 828587, 743276, 821215, 753691, 702762, 771982, 686255, 719397, 742137, 692100, 799756, 736943, 600903, 696929, 569578, 721941, 527795, 757337, 496763, 625597, 731159, 617730, 471536, 734022, 810191, 54301, 557931, 553475, 684829, 670513, 757151, 514085, 505353, 566083, 466934, 567402, 733538, 625578, 482411, 542359, 449911, 552308, 563294, 716409, 700179, 639897, 454938, 483610, 484920, 480975, 461579, 567745, 501830, 524004, 418704, 523958, 679721, 560387, 513730, 510887, 423027, 582790, 556728, 456024, 496762, 557118, 424746);

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
  21210
  54301
  418704
  423027
  424746
  449911
  454938
  456024
  461579
  466934
  471536
  480975
  482411
  483610
  484920
  496762
  496763
  501830
  505353
  510887
  513730
  514085
  523958
  524004
  527795
  537925
  542359
  544803
  552308
  553475
  556728
  557118
  557931
  560387
  563294
  566083
  567402
  567745
  569578
  582790
  584995
  600903
  617730
  625578
  625597
  639897
  670513
  679721
  684829
  686255
  692100
  696929
  700179
  702762
  716409
  719397
  721941
  731159
  733538
  734022
  736943
  742137
  743276
  753691
  755045
  757151
  757337
  771982
  799756
  804574
  810191
  821215
  828587
]

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 (21210, 54301, 418704, 423027, 424746, 449911, 454938, 456024, 461579, 466934, 471536, 480975, 482411, 483610, 484920, 496762, 496763, 501830, 505353, 510887, 513730, 514085, 523958, 524004, 527795, 537925, 542359, 544803, 552308, 553475, 556728, 557118, 557931, 560387, 563294, 566083, 567402, 567745, 569578, 582790, 584995, 600903, 617730, 625578, 625597, 639897, 670513, 679721, 684829, 686255, 692100, 696929, 700179, 702762, 716409, 719397, 721941, 731159, 733538, 734022, 736943, 742137, 743276, 753691, 755045, 757151, 757337, 771982, 799756, 804574, 810191, 821215, 828587);

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
  21210
  54301
  418704
  423027
  424746
  449911
  454938
  456024
  461579
  466934
  471536
  480975
  482411
  483610
  484920
  496762
  496763
  501830
  505353
  510887
  513730
  514085
  523958
  524004
  527795
  537925
  542359
  544803
  552308
  553475
  556728
  557118
  557931
  560387
  563294
  566083
  567402
  567745
  569578
  582790
  584995
  600903
  617730
  625578
  625597
  639897
  670513
  679721
  684829
  686255
  692100
  696929
  700179
  702762
  716409
  719397
  721941
  731159
  733538
  734022
  736943
  742137
  743276
  753691
  755045
  757151
  757337
  771982
  799756
  804574
  810191
  821215
  828587
]

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 (21210, 54301, 418704, 423027, 424746, 449911, 454938, 456024, 461579, 466934, 471536, 480975, 482411, 483610, 484920, 496762, 496763, 501830, 505353, 510887, 513730, 514085, 523958, 524004, 527795, 537925, 542359, 544803, 552308, 553475, 556728, 557118, 557931, 560387, 563294, 566083, 567402, 567745, 569578, 582790, 584995, 600903, 617730, 625578, 625597, 639897, 670513, 679721, 684829, 686255, 692100, 696929, 700179, 702762, 716409, 719397, 721941, 731159, 733538, 734022, 736943, 742137, 743276, 753691, 755045, 757151, 757337, 771982, 799756, 804574, 810191, 821215, 828587);

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

[
  "curly hair девушк"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'curly hair девушк';

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

[
  "curly hair девушк"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'curly hair девушк';

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 ?

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