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

[
  "drink cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'drink cum' 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
  743001
  498289
  709244
  542583
  542595
  601579
  637043
  599961
  541197
  642066
  599914
  537204
  545373
  647859
  648854
  666892
  569922
  641700
  633491
  633451
  631194
  641975
  634218
  639760
  634801
  545409
  676428
  545372
  545469
  628332
  628383
  639719
  628371
  630552
  815738
  785570
  529792
  559178
  545355
  438031
  564122
  634787
  599875
  627807
  635258
  553970
  639767
  786832
  792323
  636210
  428517
  607610
  632562
  417318
  450643
  420588
  597587
  550124
  543627
  582323
  651599
  666901
  650127
  601584
  634790
  666902
  601583
  639292
  537864
  646427
  639818
  707391
  634140
  666850
]

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 (743001, 498289, 709244, 542583, 542595, 601579, 637043, 599961, 541197, 642066, 599914, 537204, 545373, 647859, 648854, 666892, 569922, 641700, 633491, 633451, 631194, 641975, 634218, 639760, 634801, 545409, 676428, 545372, 545469, 628332, 628383, 639719, 628371, 630552, 815738, 785570, 529792, 559178, 545355, 438031, 564122, 634787, 599875, 627807, 635258, 553970, 639767, 786832, 792323, 636210, 428517, 607610, 632562, 417318, 450643, 420588, 597587, 550124, 543627, 582323, 651599, 666901, 650127, 601584, 634790, 666902, 601583, 639292, 537864, 646427, 639818, 707391, 634140, 666850);

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
  417318
  420588
  428517
  438031
  450643
  498289
  529792
  537204
  537864
  541197
  542583
  542595
  543627
  545355
  545372
  545373
  545409
  545469
  550124
  553970
  559178
  564122
  569922
  582323
  597587
  599875
  599914
  599961
  601579
  601583
  601584
  607610
  627807
  628332
  628371
  628383
  630552
  631194
  632562
  633451
  633491
  634140
  634218
  634787
  634790
  634801
  635258
  636210
  637043
  639292
  639719
  639760
  639767
  639818
  641700
  641975
  642066
  646427
  647859
  648854
  650127
  651599
  666850
  666892
  666901
  666902
  676428
  707391
  709244
  743001
  785570
  792323
  815738
]

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 (417318, 420588, 428517, 438031, 450643, 498289, 529792, 537204, 537864, 541197, 542583, 542595, 543627, 545355, 545372, 545373, 545409, 545469, 550124, 553970, 559178, 564122, 569922, 582323, 597587, 599875, 599914, 599961, 601579, 601583, 601584, 607610, 627807, 628332, 628371, 628383, 630552, 631194, 632562, 633451, 633491, 634140, 634218, 634787, 634790, 634801, 635258, 636210, 637043, 639292, 639719, 639760, 639767, 639818, 641700, 641975, 642066, 646427, 647859, 648854, 650127, 651599, 666850, 666892, 666901, 666902, 676428, 707391, 709244, 743001, 785570, 792323, 815738);

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
  417318
  420588
  428517
  438031
  450643
  498289
  529792
  537204
  537864
  541197
  542583
  542595
  543627
  545355
  545372
  545373
  545409
  545469
  550124
  553970
  559178
  564122
  569922
  582323
  597587
  599875
  599914
  599961
  601579
  601583
  601584
  607610
  627807
  628332
  628371
  628383
  630552
  631194
  632562
  633451
  633491
  634140
  634218
  634787
  634790
  634801
  635258
  636210
  637043
  639292
  639719
  639760
  639767
  639818
  641700
  641975
  642066
  646427
  647859
  648854
  650127
  651599
  666850
  666892
  666901
  666902
  676428
  707391
  709244
  743001
  785570
  792323
  815738
]

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 (417318, 420588, 428517, 438031, 450643, 498289, 529792, 537204, 537864, 541197, 542583, 542595, 543627, 545355, 545372, 545373, 545409, 545469, 550124, 553970, 559178, 564122, 569922, 582323, 597587, 599875, 599914, 599961, 601579, 601583, 601584, 607610, 627807, 628332, 628371, 628383, 630552, 631194, 632562, 633451, 633491, 634140, 634218, 634787, 634790, 634801, 635258, 636210, 637043, 639292, 639719, 639760, 639767, 639818, 641700, 641975, 642066, 646427, 647859, 648854, 650127, 651599, 666850, 666892, 666901, 666902, 676428, 707391, 709244, 743001, 785570, 792323, 815738);

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

[
  "drink cum"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'drink cum';

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

[
  "drink cum"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'drink cum';

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 ?

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