Query Metrics

8 Database Queries
8 Different statements
552.52 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
222.09 ms
(40.20%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  532780
  478036
  597853
  807383
  442679
  480385
  397982
  480397
  442290
  454676
  530473
  454710
  419136
  480377
  468527
  472152
  532776
  388856
  477025
  480399
  480379
  480394
  471352
  450833
  478044
  582409
  565150
  712694
  480393
  480373
  480396
  530833
  480387
  464084
  446030
  480370
  528038
  480392
  480380
  617137
  577931
  466561
  468630
  485454
  464139
  494985
]
208.58 ms
(37.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "butts ass"
]
101.19 ms
(18.31%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  388856
  397982
  419136
  442290
  442679
  446030
  450833
  454676
  454710
  464084
  464139
  466561
  468527
  468630
  471352
  472152
  477025
  478036
  478044
  480370
  480373
  480377
  480379
  480380
  480385
  480387
  480392
  480393
  480394
  480396
  480397
  480399
  485454
  494985
  528038
  530473
  530833
  532776
  532780
  565150
  577931
  582409
  597853
  617137
  712694
  807383
]
13.00 ms
(2.35%)
1
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 ?
Parameters:
[
  "butts ass"
  "butts ass"
  "butts ass"
  20
]
2.22 ms
(0.40%)
1
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1
  2
  388856
  397982
  419136
  442290
  442679
  446030
  450833
  454676
  454710
  464084
  464139
  466561
  468527
  468630
  471352
  472152
  477025
  478036
  478044
  480370
  480373
  480377
  480379
  480380
  480385
  480387
  480392
  480393
  480394
  480396
  480397
  480399
  485454
  494985
  528038
  530473
  530833
  532776
  532780
  565150
  577931
  582409
  597853
  617137
  712694
  807383
]
1.96 ms
(0.35%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.33%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "butts жоп"
]
1.63 ms
(0.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "butts жоп"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.