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 drink piss"
]

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

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

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'teen drink писсинг';

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

[
  "teen drink писсинг"
]

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

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