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

[
  "mature squirt solo"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature squirt solo' 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
  506904
  508778
  511273
  446386
  511272
  476191
  583387
  770155
  803880
  467878
  813819
  464971
  468142
  564387
  811296
  460338
  434364
  497667
  452953
  660397
  413373
  569309
  660410
  791738
  452977
  409035
  643380
  629828
  541832
  455217
  512975
  555991
  603286
  748504
  650305
  752647
  513670
  800599
  741750
  523881
  741699
  496842
  581050
  555001
  660014
  664166
  582751
  604265
  793187
  555020
  517810
  560409
  556004
  415753
  578146
  583355
  707556
  626872
  643126
  728469
  802914
  513615
  568532
  592756
  545982
  555967
  626588
  601806
  805139
  604419
  572259
  568379
]

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 (506904, 508778, 511273, 446386, 511272, 476191, 583387, 770155, 803880, 467878, 813819, 464971, 468142, 564387, 811296, 460338, 434364, 497667, 452953, 660397, 413373, 569309, 660410, 791738, 452977, 409035, 643380, 629828, 541832, 455217, 512975, 555991, 603286, 748504, 650305, 752647, 513670, 800599, 741750, 523881, 741699, 496842, 581050, 555001, 660014, 664166, 582751, 604265, 793187, 555020, 517810, 560409, 556004, 415753, 578146, 583355, 707556, 626872, 643126, 728469, 802914, 513615, 568532, 592756, 545982, 555967, 626588, 601806, 805139, 604419, 572259, 568379);

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
  409035
  413373
  415753
  434364
  446386
  452953
  452977
  455217
  460338
  464971
  467878
  468142
  476191
  496842
  497667
  506904
  508778
  511272
  511273
  512975
  513615
  513670
  517810
  523881
  541832
  545982
  555001
  555020
  555967
  555991
  556004
  560409
  564387
  568379
  568532
  569309
  572259
  578146
  581050
  582751
  583355
  583387
  592756
  601806
  603286
  604265
  604419
  626588
  626872
  629828
  643126
  643380
  650305
  660014
  660397
  660410
  664166
  707556
  728469
  741699
  741750
  748504
  752647
  770155
  791738
  793187
  800599
  802914
  803880
  805139
  811296
  813819
]

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 (409035, 413373, 415753, 434364, 446386, 452953, 452977, 455217, 460338, 464971, 467878, 468142, 476191, 496842, 497667, 506904, 508778, 511272, 511273, 512975, 513615, 513670, 517810, 523881, 541832, 545982, 555001, 555020, 555967, 555991, 556004, 560409, 564387, 568379, 568532, 569309, 572259, 578146, 581050, 582751, 583355, 583387, 592756, 601806, 603286, 604265, 604419, 626588, 626872, 629828, 643126, 643380, 650305, 660014, 660397, 660410, 664166, 707556, 728469, 741699, 741750, 748504, 752647, 770155, 791738, 793187, 800599, 802914, 803880, 805139, 811296, 813819);

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
  409035
  413373
  415753
  434364
  446386
  452953
  452977
  455217
  460338
  464971
  467878
  468142
  476191
  496842
  497667
  506904
  508778
  511272
  511273
  512975
  513615
  513670
  517810
  523881
  541832
  545982
  555001
  555020
  555967
  555991
  556004
  560409
  564387
  568379
  568532
  569309
  572259
  578146
  581050
  582751
  583355
  583387
  592756
  601806
  603286
  604265
  604419
  626588
  626872
  629828
  643126
  643380
  650305
  660014
  660397
  660410
  664166
  707556
  728469
  741699
  741750
  748504
  752647
  770155
  791738
  793187
  800599
  802914
  803880
  805139
  811296
  813819
]

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 (409035, 413373, 415753, 434364, 446386, 452953, 452977, 455217, 460338, 464971, 467878, 468142, 476191, 496842, 497667, 506904, 508778, 511272, 511273, 512975, 513615, 513670, 517810, 523881, 541832, 545982, 555001, 555020, 555967, 555991, 556004, 560409, 564387, 568379, 568532, 569309, 572259, 578146, 581050, 582751, 583355, 583387, 592756, 601806, 603286, 604265, 604419, 626588, 626872, 629828, 643126, 643380, 650305, 660014, 660397, 660410, 664166, 707556, 728469, 741699, 741750, 748504, 752647, 770155, 791738, 793187, 800599, 802914, 803880, 805139, 811296, 813819);

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

[
  "mature сквирт оргазм соло"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'mature сквирт оргазм соло';

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

[
  "mature сквирт оргазм соло"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'mature сквирт оргазм соло';

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 ?

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