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

[
  "bare"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'bare' 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
  725334
  824055
  654812
  666045
  707401
  656969
  818312
  657412
  705736
  717717
  823870
  659122
  655549
  811132
  791249
  796748
  490809
  657403
  654159
  799708
  746050
  787893
  408835
  661330
  660249
  740261
  814296
  546177
  573858
  654239
  661328
  710213
  749829
  728702
  793069
  813940
  493581
  560826
  588765
  783054
  804254
  490807
  197300
  576176
  606989
  435567
  480555
  558444
  557376
  622163
  495860
  515550
  560864
  661359
  596520
  777006
  789830
  608705
  101986
  534164
  510310
  490813
  550716
  584188
  623504
  407557
  550001
  590990
  513780
  655736
  572592
  483629
  442612
  608681
]

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 (725334, 824055, 654812, 666045, 707401, 656969, 818312, 657412, 705736, 717717, 823870, 659122, 655549, 811132, 791249, 796748, 490809, 657403, 654159, 799708, 746050, 787893, 408835, 661330, 660249, 740261, 814296, 546177, 573858, 654239, 661328, 710213, 749829, 728702, 793069, 813940, 493581, 560826, 588765, 783054, 804254, 490807, 197300, 576176, 606989, 435567, 480555, 558444, 557376, 622163, 495860, 515550, 560864, 661359, 596520, 777006, 789830, 608705, 101986, 534164, 510310, 490813, 550716, 584188, 623504, 407557, 550001, 590990, 513780, 655736, 572592, 483629, 442612, 608681);

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
  101986
  197300
  407557
  408835
  435567
  442612
  480555
  483629
  490807
  490809
  490813
  493581
  495860
  510310
  513780
  515550
  534164
  546177
  550001
  550716
  557376
  558444
  560826
  560864
  572592
  573858
  576176
  584188
  588765
  590990
  596520
  606989
  608681
  608705
  622163
  623504
  654159
  654239
  654812
  655549
  655736
  656969
  657403
  657412
  659122
  660249
  661328
  661330
  661359
  666045
  705736
  707401
  710213
  717717
  725334
  728702
  740261
  746050
  749829
  777006
  783054
  787893
  789830
  791249
  793069
  796748
  799708
  804254
  811132
  813940
  814296
  818312
  823870
]

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 (101986, 197300, 407557, 408835, 435567, 442612, 480555, 483629, 490807, 490809, 490813, 493581, 495860, 510310, 513780, 515550, 534164, 546177, 550001, 550716, 557376, 558444, 560826, 560864, 572592, 573858, 576176, 584188, 588765, 590990, 596520, 606989, 608681, 608705, 622163, 623504, 654159, 654239, 654812, 655549, 655736, 656969, 657403, 657412, 659122, 660249, 661328, 661330, 661359, 666045, 705736, 707401, 710213, 717717, 725334, 728702, 740261, 746050, 749829, 777006, 783054, 787893, 789830, 791249, 793069, 796748, 799708, 804254, 811132, 813940, 814296, 818312, 823870);

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
  101986
  197300
  407557
  408835
  435567
  442612
  480555
  483629
  490807
  490809
  490813
  493581
  495860
  510310
  513780
  515550
  534164
  546177
  550001
  550716
  557376
  558444
  560826
  560864
  572592
  573858
  576176
  584188
  588765
  590990
  596520
  606989
  608681
  608705
  622163
  623504
  654159
  654239
  654812
  655549
  655736
  656969
  657403
  657412
  659122
  660249
  661328
  661330
  661359
  666045
  705736
  707401
  710213
  717717
  725334
  728702
  740261
  746050
  749829
  777006
  783054
  787893
  789830
  791249
  793069
  796748
  799708
  804254
  811132
  813940
  814296
  818312
  823870
]

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 (101986, 197300, 407557, 408835, 435567, 442612, 480555, 483629, 490807, 490809, 490813, 493581, 495860, 510310, 513780, 515550, 534164, 546177, 550001, 550716, 557376, 558444, 560826, 560864, 572592, 573858, 576176, 584188, 588765, 590990, 596520, 606989, 608681, 608705, 622163, 623504, 654159, 654239, 654812, 655549, 655736, 656969, 657403, 657412, 659122, 660249, 661328, 661330, 661359, 666045, 705736, 707401, 710213, 717717, 725334, 728702, 740261, 746050, 749829, 777006, 783054, 787893, 789830, 791249, 793069, 796748, 799708, 804254, 811132, 813940, 814296, 818312, 823870);

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

[
  "bare"
]

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

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

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

[
  "bare"
]

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

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

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 ?

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