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

[
  "atm teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'atm teen' 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
  426214
  435108
  433480
  459362
  531115
  542583
  542590
  541201
  542595
  646896
  666899
  720836
  650174
  692887
  599990
  633743
  633806
  595471
  535505
  540338
  536687
  540518
  584713
  541197
  696579
  666901
  634116
  633796
  531119
  647936
  696582
  647979
  647993
  672710
  672712
  647830
  647952
  650180
  628402
  633770
  634153
  628396
  600363
  628382
  633775
  633792
  433139
  406121
  534027
  536676
  536648
  647972
  594074
  610555
  634115
  632978
  634801
  417349
  473418
  644916
  486871
  540559
  545409
  545410
  545611
  634198
  628383
  588265
  634780
  545418
  648257
  628333
  533915
  598105
]

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 (426214, 435108, 433480, 459362, 531115, 542583, 542590, 541201, 542595, 646896, 666899, 720836, 650174, 692887, 599990, 633743, 633806, 595471, 535505, 540338, 536687, 540518, 584713, 541197, 696579, 666901, 634116, 633796, 531119, 647936, 696582, 647979, 647993, 672710, 672712, 647830, 647952, 650180, 628402, 633770, 634153, 628396, 600363, 628382, 633775, 633792, 433139, 406121, 534027, 536676, 536648, 647972, 594074, 610555, 634115, 632978, 634801, 417349, 473418, 644916, 486871, 540559, 545409, 545410, 545611, 634198, 628383, 588265, 634780, 545418, 648257, 628333, 533915, 598105);

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
  406121
  417349
  426214
  433139
  433480
  435108
  459362
  473418
  486871
  531115
  531119
  533915
  534027
  535505
  536648
  536676
  536687
  540338
  540518
  540559
  541197
  541201
  542583
  542590
  542595
  545409
  545410
  545418
  545611
  584713
  588265
  594074
  595471
  598105
  599990
  600363
  610555
  628333
  628382
  628383
  628396
  628402
  632978
  633743
  633770
  633775
  633792
  633796
  633806
  634115
  634116
  634153
  634198
  634780
  634801
  644916
  646896
  647830
  647936
  647952
  647972
  647979
  647993
  648257
  650174
  650180
  666899
  666901
  672710
  672712
  692887
  696579
  696582
  720836
]

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 (406121, 417349, 426214, 433139, 433480, 435108, 459362, 473418, 486871, 531115, 531119, 533915, 534027, 535505, 536648, 536676, 536687, 540338, 540518, 540559, 541197, 541201, 542583, 542590, 542595, 545409, 545410, 545418, 545611, 584713, 588265, 594074, 595471, 598105, 599990, 600363, 610555, 628333, 628382, 628383, 628396, 628402, 632978, 633743, 633770, 633775, 633792, 633796, 633806, 634115, 634116, 634153, 634198, 634780, 634801, 644916, 646896, 647830, 647936, 647952, 647972, 647979, 647993, 648257, 650174, 650180, 666899, 666901, 672710, 672712, 692887, 696579, 696582, 720836);

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
  406121
  417349
  426214
  433139
  433480
  435108
  459362
  473418
  486871
  531115
  531119
  533915
  534027
  535505
  536648
  536676
  536687
  540338
  540518
  540559
  541197
  541201
  542583
  542590
  542595
  545409
  545410
  545418
  545611
  584713
  588265
  594074
  595471
  598105
  599990
  600363
  610555
  628333
  628382
  628383
  628396
  628402
  632978
  633743
  633770
  633775
  633792
  633796
  633806
  634115
  634116
  634153
  634198
  634780
  634801
  644916
  646896
  647830
  647936
  647952
  647972
  647979
  647993
  648257
  650174
  650180
  666899
  666901
  672710
  672712
  692887
  696579
  696582
  720836
]

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 (406121, 417349, 426214, 433139, 433480, 435108, 459362, 473418, 486871, 531115, 531119, 533915, 534027, 535505, 536648, 536676, 536687, 540338, 540518, 540559, 541197, 541201, 542583, 542590, 542595, 545409, 545410, 545418, 545611, 584713, 588265, 594074, 595471, 598105, 599990, 600363, 610555, 628333, 628382, 628383, 628396, 628402, 632978, 633743, 633770, 633775, 633792, 633796, 633806, 634115, 634116, 634153, 634198, 634780, 634801, 644916, 646896, 647830, 647936, 647952, 647972, 647979, 647993, 648257, 650174, 650180, 666899, 666901, 672710, 672712, 692887, 696579, 696582, 720836);

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

[
  "atm teen"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'atm teen';

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

[
  "atm teen"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'atm teen';

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 ?

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