Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
81.61 ms
(71.93%)
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
  418453
  430404
  430709
  445327
  452058
  457795
  466481
  474550
  497899
  513215
  532172
  533802
  537206
  537241
  540570
  541634
  541656
  545305
  578395
  581711
  586652
  588283
  600061
  601114
  602968
  603724
  612831
  619475
  632579
  635243
  636033
  636304
  638967
  639744
  639748
  639824
  642700
  642706
  643020
  643067
  647635
  647885
  649514
  666525
  666866
  674983
  674988
  675012
  676636
  701348
  746994
  807023
]
15.57 ms
(13.73%)
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
  466481
  603724
  474550
  452058
  537241
  497899
  647885
  612831
  445327
  537206
  602968
  588283
  581711
  532172
  666866
  601114
  600061
  541656
  541634
  430709
  533802
  639748
  418453
  647635
  807023
  701348
  643067
  513215
  545305
  674988
  639824
  619475
  578395
  540570
  674983
  676636
  666525
  649514
  636033
  642706
  643020
  632579
  430404
  638967
  639744
  635243
  746994
  457795
  675012
  586652
  642700
  636304
]
6.69 ms
(5.90%)
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
]
2.15 ms
(1.89%)
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
  418453
  430404
  430709
  445327
  452058
  457795
  466481
  474550
  497899
  513215
  532172
  533802
  537206
  537241
  540570
  541634
  541656
  545305
  578395
  581711
  586652
  588283
  600061
  601114
  602968
  603724
  612831
  619475
  632579
  635243
  636033
  636304
  638967
  639744
  639748
  639824
  642700
  642706
  643020
  643067
  647635
  647885
  649514
  666525
  666866
  674983
  674988
  675012
  676636
  701348
  746994
  807023
]
2.13 ms
(1.88%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "групповуха с негритянками"
]
1.87 ms
(1.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.86 ms
(1.64%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "группов секс чернокожая"
]
1.57 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.