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

[
  "jules jordan"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'jules jordan' LIMIT 1;

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1

[
  b"\x01–Uu\x1E\x07s’¤ŽýäÄ<eV"
]

SELECT
  1
FROM
  `trend_has_post`
WHERE
  `trend_id` = ?
LIMIT
  1

SELECT 1 FROM `trend_has_post` WHERE `trend_id` = 0x019655751E077392A48EFDE4C43C6556 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
  809128
  418371
  805110
  553064
  624653
  433968
  475485
  494347
  625448
  625446
  401924
  426378
  828526
  473451
  625450
  487361
  398864
  817090
  817063
  506884
  826972
  408738
  414222
  404409
  419600
  398217
  422328
  410439
  469102
  482981
  508191
  598120
  620316
  418270
  448869
  479846
  492717
  401989
  415591
  409641
  451265
  452068
  478052
  462798
  451989
  443213
  452109
  451946
  480420
  461624
  499481
  482800
  451991
  448072
  452139
  451970
  452519
  538023
  575193
  565154
  580646
]

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 (809128, 418371, 805110, 553064, 624653, 433968, 475485, 494347, 625448, 625446, 401924, 426378, 828526, 473451, 625450, 487361, 398864, 817090, 817063, 506884, 826972, 408738, 414222, 404409, 419600, 398217, 422328, 410439, 469102, 482981, 508191, 598120, 620316, 418270, 448869, 479846, 492717, 401989, 415591, 409641, 451265, 452068, 478052, 462798, 451989, 443213, 452109, 451946, 480420, 461624, 499481, 482800, 451991, 448072, 452139, 451970, 452519, 538023, 575193, 565154, 580646);

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
  398217
  398864
  401924
  401989
  404409
  408738
  409641
  410439
  414222
  415591
  418270
  418371
  419600
  422328
  426378
  433968
  443213
  448072
  448869
  451265
  451946
  451970
  451989
  451991
  452068
  452109
  452139
  452519
  461624
  462798
  469102
  473451
  475485
  478052
  479846
  480420
  482800
  482981
  487361
  492717
  494347
  499481
  506884
  508191
  538023
  553064
  565154
  575193
  580646
  598120
  620316
  624653
  625446
  625448
  625450
  805110
  809128
  817063
  817090
  826972
  828526
]

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 (398217, 398864, 401924, 401989, 404409, 408738, 409641, 410439, 414222, 415591, 418270, 418371, 419600, 422328, 426378, 433968, 443213, 448072, 448869, 451265, 451946, 451970, 451989, 451991, 452068, 452109, 452139, 452519, 461624, 462798, 469102, 473451, 475485, 478052, 479846, 480420, 482800, 482981, 487361, 492717, 494347, 499481, 506884, 508191, 538023, 553064, 565154, 575193, 580646, 598120, 620316, 624653, 625446, 625448, 625450, 805110, 809128, 817063, 817090, 826972, 828526);

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
  398217
  398864
  401924
  401989
  404409
  408738
  409641
  410439
  414222
  415591
  418270
  418371
  419600
  422328
  426378
  433968
  443213
  448072
  448869
  451265
  451946
  451970
  451989
  451991
  452068
  452109
  452139
  452519
  461624
  462798
  469102
  473451
  475485
  478052
  479846
  480420
  482800
  482981
  487361
  492717
  494347
  499481
  506884
  508191
  538023
  553064
  565154
  575193
  580646
  598120
  620316
  624653
  625446
  625448
  625450
  805110
  809128
  817063
  817090
  826972
  828526
]

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 (398217, 398864, 401924, 401989, 404409, 408738, 409641, 410439, 414222, 415591, 418270, 418371, 419600, 422328, 426378, 433968, 443213, 448072, 448869, 451265, 451946, 451970, 451989, 451991, 452068, 452109, 452139, 452519, 461624, 462798, 469102, 473451, 475485, 478052, 479846, 480420, 482800, 482981, 487361, 492717, 494347, 499481, 506884, 508191, 538023, 553064, 565154, 575193, 580646, 598120, 620316, 624653, 625446, 625448, 625450, 805110, 809128, 817063, 817090, 826972, 828526);

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

[
  "julesjordanvideo"
]

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

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

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

[
  "julesjordanvideo"
]

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

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

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 ?

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