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

[
  "teen pissing drink"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen pissing drink' 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
  671678
  733881
  542580
  672685
  733842
  733897
  428517
  628387
  733840
  680121
  627810
  632562
  672682
  672684
  651620
  704226
  632684
  627803
  651051
  683262
  628361
  644962
  542583
  542588
  542595
  543627
  680112
  680126
  599945
  601579
  628365
  634787
  637043
  628368
  733855
  541197
  666901
  680189
  695126
  640805
  634790
  637080
  627807
  651148
  666902
  641955
  597235
  633451
  600363
  628382
  641956
  632635
  639292
  646427
  634115
  639716
  634801
  545409
  707391
  666880
  666894
  545469
  628383
  628371
  634780
  647860
  666850
  545355
  639741
  642774
  633435
]

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 (671678, 733881, 542580, 672685, 733842, 733897, 428517, 628387, 733840, 680121, 627810, 632562, 672682, 672684, 651620, 704226, 632684, 627803, 651051, 683262, 628361, 644962, 542583, 542588, 542595, 543627, 680112, 680126, 599945, 601579, 628365, 634787, 637043, 628368, 733855, 541197, 666901, 680189, 695126, 640805, 634790, 637080, 627807, 651148, 666902, 641955, 597235, 633451, 600363, 628382, 641956, 632635, 639292, 646427, 634115, 639716, 634801, 545409, 707391, 666880, 666894, 545469, 628383, 628371, 634780, 647860, 666850, 545355, 639741, 642774, 633435);

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
  428517
  541197
  542580
  542583
  542588
  542595
  543627
  545355
  545409
  545469
  597235
  599945
  600363
  601579
  627803
  627807
  627810
  628361
  628365
  628368
  628371
  628382
  628383
  628387
  632562
  632635
  632684
  633435
  633451
  634115
  634780
  634787
  634790
  634801
  637043
  637080
  639292
  639716
  639741
  640805
  641955
  641956
  642774
  644962
  646427
  647860
  651051
  651148
  651620
  666850
  666880
  666894
  666901
  666902
  671678
  672682
  672684
  672685
  680112
  680121
  680126
  680189
  683262
  695126
  704226
  707391
  733840
  733842
  733855
  733881
  733897
]

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 (428517, 541197, 542580, 542583, 542588, 542595, 543627, 545355, 545409, 545469, 597235, 599945, 600363, 601579, 627803, 627807, 627810, 628361, 628365, 628368, 628371, 628382, 628383, 628387, 632562, 632635, 632684, 633435, 633451, 634115, 634780, 634787, 634790, 634801, 637043, 637080, 639292, 639716, 639741, 640805, 641955, 641956, 642774, 644962, 646427, 647860, 651051, 651148, 651620, 666850, 666880, 666894, 666901, 666902, 671678, 672682, 672684, 672685, 680112, 680121, 680126, 680189, 683262, 695126, 704226, 707391, 733840, 733842, 733855, 733881, 733897);

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
  428517
  541197
  542580
  542583
  542588
  542595
  543627
  545355
  545409
  545469
  597235
  599945
  600363
  601579
  627803
  627807
  627810
  628361
  628365
  628368
  628371
  628382
  628383
  628387
  632562
  632635
  632684
  633435
  633451
  634115
  634780
  634787
  634790
  634801
  637043
  637080
  639292
  639716
  639741
  640805
  641955
  641956
  642774
  644962
  646427
  647860
  651051
  651148
  651620
  666850
  666880
  666894
  666901
  666902
  671678
  672682
  672684
  672685
  680112
  680121
  680126
  680189
  683262
  695126
  704226
  707391
  733840
  733842
  733855
  733881
  733897
]

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 (428517, 541197, 542580, 542583, 542588, 542595, 543627, 545355, 545409, 545469, 597235, 599945, 600363, 601579, 627803, 627807, 627810, 628361, 628365, 628368, 628371, 628382, 628383, 628387, 632562, 632635, 632684, 633435, 633451, 634115, 634780, 634787, 634790, 634801, 637043, 637080, 639292, 639716, 639741, 640805, 641955, 641956, 642774, 644962, 646427, 647860, 651051, 651148, 651620, 666850, 666880, 666894, 666901, 666902, 671678, 672682, 672684, 672685, 680112, 680121, 680126, 680189, 683262, 695126, 704226, 707391, 733840, 733842, 733855, 733881, 733897);

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

[
  "teen pissing drink"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen pissing drink';

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

[
  "teen pissing drink"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'teen pissing drink';

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 ?

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