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

[
  "cumshot compilation anal"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cumshot compilation anal' 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
  624194
  626403
  497269
  791364
  772863
  798602
  395275
  432641
  711672
  77381
  580624
  400713
  446999
  817283
  432694
  454541
  461402
  683143
  813189
  741156
  724130
  777026
  418125
  437925
  524139
  738441
  778931
  442524
  791589
  627635
  801886
  477118
  691166
  519872
  813987
  520711
  600010
  478993
  824456
  454275
  674117
  419979
  454540
  528123
  615014
  492338
  588276
  601659
  534801
  606633
  749909
  487410
  419383
  452456
  584779
  413791
  761167
  558574
  453342
  569071
  486589
  464372
  418068
  519209
  608414
  464366
  792558
  593596
  456705
  601101
]

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 (624194, 626403, 497269, 791364, 772863, 798602, 395275, 432641, 711672, 77381, 580624, 400713, 446999, 817283, 432694, 454541, 461402, 683143, 813189, 741156, 724130, 777026, 418125, 437925, 524139, 738441, 778931, 442524, 791589, 627635, 801886, 477118, 691166, 519872, 813987, 520711, 600010, 478993, 824456, 454275, 674117, 419979, 454540, 528123, 615014, 492338, 588276, 601659, 534801, 606633, 749909, 487410, 419383, 452456, 584779, 413791, 761167, 558574, 453342, 569071, 486589, 464372, 418068, 519209, 608414, 464366, 792558, 593596, 456705, 601101);

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
  77381
  395275
  400713
  413791
  418068
  418125
  419383
  419979
  432641
  432694
  437925
  442524
  446999
  452456
  453342
  454275
  454540
  454541
  456705
  461402
  464366
  464372
  477118
  478993
  486589
  487410
  492338
  497269
  519209
  519872
  520711
  524139
  528123
  534801
  558574
  569071
  580624
  584779
  588276
  593596
  600010
  601101
  601659
  606633
  608414
  615014
  624194
  626403
  627635
  674117
  683143
  691166
  711672
  724130
  738441
  741156
  749909
  761167
  772863
  777026
  778931
  791364
  791589
  792558
  798602
  801886
  813189
  813987
  817283
  824456
]

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 (77381, 395275, 400713, 413791, 418068, 418125, 419383, 419979, 432641, 432694, 437925, 442524, 446999, 452456, 453342, 454275, 454540, 454541, 456705, 461402, 464366, 464372, 477118, 478993, 486589, 487410, 492338, 497269, 519209, 519872, 520711, 524139, 528123, 534801, 558574, 569071, 580624, 584779, 588276, 593596, 600010, 601101, 601659, 606633, 608414, 615014, 624194, 626403, 627635, 674117, 683143, 691166, 711672, 724130, 738441, 741156, 749909, 761167, 772863, 777026, 778931, 791364, 791589, 792558, 798602, 801886, 813189, 813987, 817283, 824456);

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
  77381
  395275
  400713
  413791
  418068
  418125
  419383
  419979
  432641
  432694
  437925
  442524
  446999
  452456
  453342
  454275
  454540
  454541
  456705
  461402
  464366
  464372
  477118
  478993
  486589
  487410
  492338
  497269
  519209
  519872
  520711
  524139
  528123
  534801
  558574
  569071
  580624
  584779
  588276
  593596
  600010
  601101
  601659
  606633
  608414
  615014
  624194
  626403
  627635
  674117
  683143
  691166
  711672
  724130
  738441
  741156
  749909
  761167
  772863
  777026
  778931
  791364
  791589
  792558
  798602
  801886
  813189
  813987
  817283
  824456
]

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 (77381, 395275, 400713, 413791, 418068, 418125, 419383, 419979, 432641, 432694, 437925, 442524, 446999, 452456, 453342, 454275, 454540, 454541, 456705, 461402, 464366, 464372, 477118, 478993, 486589, 487410, 492338, 497269, 519209, 519872, 520711, 524139, 528123, 534801, 558574, 569071, 580624, 584779, 588276, 593596, 600010, 601101, 601659, 606633, 608414, 615014, 624194, 626403, 627635, 674117, 683143, 691166, 711672, 724130, 738441, 741156, 749909, 761167, 772863, 777026, 778931, 791364, 791589, 792558, 798602, 801886, 813189, 813987, 817283, 824456);

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

[
  "cumshot подборк анал"
]

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

SELECT `query_id` FROM `search_log` WHERE `query` = 'cumshot подборк анал';

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

[
  "cumshot подборк анал"
]

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

SELECT `trend_id` FROM `trend` WHERE `subject` = 'cumshot подборк анал';

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 ?

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