Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
63.46 ms
(60.48%)
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
  466384
  471006
  541741
  545940
  547414
  549031
  549040
  554717
  554843
  555055
  555438
  562111
  571708
  574398
  576484
  578148
  583523
  583536
  583913
  590350
  591487
  596244
  600778
  616409
  618531
  630254
  633182
  634381
  636707
  650711
  666057
  680937
  690173
  692683
  692721
  703733
  710221
  710471
  714737
  720446
  729246
  743996
  746021
  752950
  801054
  808277
]
22.19 ms
(21.15%)
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:
[
  "hairy wife pee"
  "hairy wife pee"
  "hairy wife pee"
  20
]
8.17 ms
(7.79%)
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
  752950
  801054
  808277
  600778
  650711
  555438
  549031
  666057
  590350
  634381
  743996
  703733
  576484
  549040
  690173
  729246
  583523
  692683
  692721
  583536
  562111
  554843
  618531
  630254
  636707
  633182
  720446
  466384
  547414
  746021
  710471
  714737
  471006
  571708
  680937
  554717
  578148
  596244
  574398
  541741
  545940
  710221
  616409
  591487
  555055
  583913
]
2.74 ms
(2.61%)
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
  466384
  471006
  541741
  545940
  547414
  549031
  549040
  554717
  554843
  555055
  555438
  562111
  571708
  574398
  576484
  578148
  583523
  583536
  583913
  590350
  591487
  596244
  600778
  616409
  618531
  630254
  633182
  634381
  636707
  650711
  666057
  680937
  690173
  692683
  692721
  703733
  710221
  710471
  714737
  720446
  729246
  743996
  746021
  752950
  801054
  808277
]
2.33 ms
(2.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy wife pee"
]
2.16 ms
(2.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая жен pee"
]
2.16 ms
(2.06%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(1.64%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая жен pee"
]

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.