Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
70.85 ms
(46.77%)
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
  439649
  443634
  443659
  453841
  460486
  464834
  467571
  471596
  493260
  496603
  496794
  508180
  508208
  516590
  520127
  524613
  528081
  531807
  545216
  549239
  550667
  559486
  578411
  579797
  581433
  583723
  586564
  587864
  588746
  590620
  592314
  595731
  597452
  610695
  623149
  628654
  639277
  644059
  654352
  657504
  699398
  720163
  726248
  733239
  756845
  760859
  761203
  766623
  773963
  774692
  791351
  809147
]
62.23 ms
(41.08%)
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:
[
  "anal cuckold homemade"
  "anal cuckold homemade"
  "anal cuckold homemade"
  20
]
8.94 ms
(5.90%)
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
  592314
  496794
  578411
  508180
  726248
  508208
  559486
  733239
  581433
  579797
  761203
  791351
  720163
  443634
  460486
  756845
  774692
  595731
  628654
  773963
  531807
  588746
  639277
  760859
  699398
  644059
  766623
  586564
  516590
  467571
  587864
  464834
  471596
  443659
  590620
  493260
  520127
  496603
  545216
  809147
  610695
  623149
  657504
  439649
  453841
  550667
  549239
  597452
  654352
  583723
  528081
  524613
]
2.46 ms
(1.62%)
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
  439649
  443634
  443659
  453841
  460486
  464834
  467571
  471596
  493260
  496603
  496794
  508180
  508208
  516590
  520127
  524613
  528081
  531807
  545216
  549239
  550667
  559486
  578411
  579797
  581433
  583723
  586564
  587864
  588746
  590620
  592314
  595731
  597452
  610695
  623149
  628654
  639277
  644059
  654352
  657504
  699398
  720163
  726248
  733239
  756845
  760859
  761203
  766623
  773963
  774692
  791351
  809147
]
1.94 ms
(1.28%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "анал куколд домашн любительск"
]
1.76 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "anal cuckold homemade"
]
1.72 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.60 ms
(1.06%)
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.