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

[
  "thai pov blowjob"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'thai pov blowjob' 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
  762110
  815131
  758875
  799426
  673144
  554340
  469207
  429949
  559164
  419917
  600460
  604319
  559159
  600526
  419914
  825468
  461638
  417161
  472949
  605380
  416155
  765703
  784590
  445766
  521122
  606214
  641492
  596514
  429276
  416367
  416128
  775300
  459262
  419906
  583595
  459264
  452444
  600624
  562808
  459237
  444938
  596911
  419912
  467760
  665906
  754865
  810549
  600805
  810176
  668459
  602575
  603929
  631214
  756279
  600535
  619125
  568629
  708263
  626432
  477399
  600610
  455981
  455967
  455978
  538223
  455975
  473300
  571812
  420680
  432990
]

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 (762110, 815131, 758875, 799426, 673144, 554340, 469207, 429949, 559164, 419917, 600460, 604319, 559159, 600526, 419914, 825468, 461638, 417161, 472949, 605380, 416155, 765703, 784590, 445766, 521122, 606214, 641492, 596514, 429276, 416367, 416128, 775300, 459262, 419906, 583595, 459264, 452444, 600624, 562808, 459237, 444938, 596911, 419912, 467760, 665906, 754865, 810549, 600805, 810176, 668459, 602575, 603929, 631214, 756279, 600535, 619125, 568629, 708263, 626432, 477399, 600610, 455981, 455967, 455978, 538223, 455975, 473300, 571812, 420680, 432990);

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
  416128
  416155
  416367
  417161
  419906
  419912
  419914
  419917
  420680
  429276
  429949
  432990
  444938
  445766
  452444
  455967
  455975
  455978
  455981
  459237
  459262
  459264
  461638
  467760
  469207
  472949
  473300
  477399
  521122
  538223
  554340
  559159
  559164
  562808
  568629
  571812
  583595
  596514
  596911
  600460
  600526
  600535
  600610
  600624
  600805
  602575
  603929
  604319
  605380
  606214
  619125
  626432
  631214
  641492
  665906
  668459
  673144
  708263
  754865
  756279
  758875
  762110
  765703
  775300
  784590
  799426
  810176
  810549
  815131
  825468
]

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 (416128, 416155, 416367, 417161, 419906, 419912, 419914, 419917, 420680, 429276, 429949, 432990, 444938, 445766, 452444, 455967, 455975, 455978, 455981, 459237, 459262, 459264, 461638, 467760, 469207, 472949, 473300, 477399, 521122, 538223, 554340, 559159, 559164, 562808, 568629, 571812, 583595, 596514, 596911, 600460, 600526, 600535, 600610, 600624, 600805, 602575, 603929, 604319, 605380, 606214, 619125, 626432, 631214, 641492, 665906, 668459, 673144, 708263, 754865, 756279, 758875, 762110, 765703, 775300, 784590, 799426, 810176, 810549, 815131, 825468);

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
  416128
  416155
  416367
  417161
  419906
  419912
  419914
  419917
  420680
  429276
  429949
  432990
  444938
  445766
  452444
  455967
  455975
  455978
  455981
  459237
  459262
  459264
  461638
  467760
  469207
  472949
  473300
  477399
  521122
  538223
  554340
  559159
  559164
  562808
  568629
  571812
  583595
  596514
  596911
  600460
  600526
  600535
  600610
  600624
  600805
  602575
  603929
  604319
  605380
  606214
  619125
  626432
  631214
  641492
  665906
  668459
  673144
  708263
  754865
  756279
  758875
  762110
  765703
  775300
  784590
  799426
  810176
  810549
  815131
  825468
]

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 (416128, 416155, 416367, 417161, 419906, 419912, 419914, 419917, 420680, 429276, 429949, 432990, 444938, 445766, 452444, 455967, 455975, 455978, 455981, 459237, 459262, 459264, 461638, 467760, 469207, 472949, 473300, 477399, 521122, 538223, 554340, 559159, 559164, 562808, 568629, 571812, 583595, 596514, 596911, 600460, 600526, 600535, 600610, 600624, 600805, 602575, 603929, 604319, 605380, 606214, 619125, 626432, 631214, 641492, 665906, 668459, 673144, 708263, 754865, 756279, 758875, 762110, 765703, 775300, 784590, 799426, 810176, 810549, 815131, 825468);

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

[
  "тайк азиатк пов минет оральн секс"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'тайк азиатк пов минет оральн секс';

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

[
  "тайк азиатк пов минет оральн секс"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'тайк азиатк пов минет оральн секс';

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 ?

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