Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
56.84 ms
(57.83%)
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
  242127
  383225
  386735
  389976
  391317
  392582
  393148
  407027
  421294
  426782
  427035
  442709
  445768
  459383
  461090
  461858
  464285
  467650
  470016
  472287
  477169
  477425
  490030
  498243
  499350
  500698
  508502
  510048
  511356
  511904
  518287
  528182
  528559
  533494
  534561
  555963
  568425
  569558
  579707
  585784
  602015
  628923
  634268
  678702
  678983
  698344
  704606
  710328
  731438
  738445
  750189
  758114
]
22.01 ms
(22.40%)
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:
[
  "побрила киску"
  "побрила киску"
  "побрила киску"
  20
]
9.36 ms
(9.52%)
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
  242127
  407027
  628923
  634268
  731438
  710328
  383225
  427035
  477425
  461858
  389976
  445768
  498243
  569558
  442709
  758114
  500698
  386735
  421294
  510048
  518287
  508502
  472287
  470016
  533494
  461090
  698344
  585784
  392582
  704606
  391317
  678983
  426782
  738445
  393148
  528559
  511904
  678702
  490030
  750189
  467650
  477169
  511356
  602015
  499350
  528182
  555963
  464285
  459383
  534561
  579707
  568425
]
2.33 ms
(2.37%)
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
  242127
  383225
  386735
  389976
  391317
  392582
  393148
  407027
  421294
  426782
  427035
  442709
  445768
  459383
  461090
  461858
  464285
  467650
  470016
  472287
  477169
  477425
  490030
  498243
  499350
  500698
  508502
  510048
  511356
  511904
  518287
  528182
  528559
  533494
  534561
  555963
  568425
  569558
  579707
  585784
  602015
  628923
  634268
  678702
  678983
  698344
  704606
  710328
  731438
  738445
  750189
  758114
]
2.26 ms
(2.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "побр вагин"
]
2.01 ms
(2.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "побрила киску"
]
1.74 ms
(1.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "побр вагин"
]
1.73 ms
(1.76%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.