Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
101.95 ms
(82.01%)
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
  381982
  406391
  407687
  411638
  411767
  413806
  416277
  419856
  422610
  445515
  461645
  462242
  467967
  468718
  472831
  477183
  494099
  500601
  510286
  510299
  510438
  512125
  525257
  529864
  532903
  532977
  532994
  535540
  553083
  560627
  567777
  575755
  576044
  579957
  580286
  586595
  601094
  604030
  607466
  625222
  629866
  644268
  646300
  717189
  732059
  794214
  796079
  797721
]
9.57 ms
(7.70%)
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
  500601
  532977
  532994
  560627
  575755
  579957
  646300
  607466
  797721
  381982
  462242
  419856
  510438
  406391
  416277
  445515
  461645
  529864
  532903
  553083
  717189
  644268
  604030
  732059
  629866
  407687
  422610
  535540
  494099
  411638
  472831
  512125
  567777
  586595
  794214
  796079
  580286
  477183
  411767
  625222
  525257
  467967
  468718
  413806
  510286
  576044
  510299
  601094
]
3.39 ms
(2.73%)
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:
[
  "titties"
  "titties"
  "titties"
  20
]
2.28 ms
(1.84%)
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
  381982
  406391
  407687
  411638
  411767
  413806
  416277
  419856
  422610
  445515
  461645
  462242
  467967
  468718
  472831
  477183
  494099
  500601
  510286
  510299
  510438
  512125
  525257
  529864
  532903
  532977
  532994
  535540
  553083
  560627
  567777
  575755
  576044
  579957
  580286
  586595
  601094
  604030
  607466
  625222
  629866
  644268
  646300
  717189
  732059
  794214
  796079
  797721
]
1.88 ms
(1.52%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "titties"
]
1.85 ms
(1.48%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "titties"
]
1.61 ms
(1.30%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "titties"
]

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.