Query Metrics

7 Database Queries
7 Different statements
156.74 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
132.13 ms
(84.30%)
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
  152508
  382793
  383482
  386864
  394536
  395398
  398281
  407987
  417097
  417316
  419028
  419987
  420657
  427634
  435657
  458009
  458050
  458716
  459438
  460477
  472172
  475201
  477467
  478260
  480550
  482007
  485095
  491472
  491643
  495311
  496192
  497214
  500044
  503449
  511140
  512144
  516392
  526697
  528414
  528496
  533657
  536352
  538365
  539700
  541029
  543384
  544959
  552101
  553171
  554360
  559072
  559466
  561726
  561989
  564093
  567018
  567646
  569394
  577640
  590214
  593598
  593985
  599490
  608428
  608828
  614587
  614631
  615853
  627896
  629831
  636471
  636599
  639247
  639330
  650603
  650648
  655554
  660571
  692750
  701847
  708433
  712639
  715137
  718790
  719716
  721640
  724102
  724604
  726687
  726694
  739675
  747682
  757622
  762487
  765168
  768186
  769327
  770313
  774050
  775379
  778471
  782301
  785184
  788799
  792581
  793368
  796953
  797874
  798207
  801552
  801786
  802814
  805798
  810521
  810533
  812286
  814769
  821838
  827648
]
14.79 ms
(9.43%)
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
  427634
  827648
  458009
  512144
  544959
  712639
  593598
  798207
  726694
  801552
  812286
  724102
  739675
  788799
  792581
  801786
  496192
  768186
  770313
  543384
  782301
  762487
  718790
  472172
  553171
  554360
  708433
  639330
  724604
  478260
  419987
  814769
  460477
  511140
  536352
  539700
  561989
  559072
  564093
  699417
  719716
  650648
  608828
  614587
  614631
  636471
  636599
  810521
  796953
  785184
  747682
  765168
  726687
  629831
  797874
  152508
  459438
  382793
  383482
  398281
  407987
  417097
  533657
  552101
  561726
  715137
  655554
  660571
  701847
  627896
  775379
  778471
  769327
  757622
  608428
  802814
  475201
  419028
  395398
  420657
  417316
  477467
  538365
  528414
  480550
  541029
  650603
  721640
  599490
  593985
  590214
  615853
  793368
  810533
  805798
  774050
  639247
  386864
  458050
  435657
  394536
  491472
  491643
  497214
  821838
  458716
  482007
  495311
  500044
  526697
  528496
  503449
  516392
  485095
  567018
  567646
  569394
  559466
  577640
  692750
]
2.53 ms
(1.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
  152508
  382793
  383482
  386864
  394536
  395398
  398281
  407987
  417097
  417316
  419028
  419987
  420657
  427634
  435657
  458009
  458050
  458716
  459438
  460477
  472172
  475201
  477467
  478260
  480550
  482007
  485095
  491472
  491643
  495311
  496192
  497214
  500044
  503449
  511140
  512144
  516392
  526697
  528414
  528496
  533657
  536352
  538365
  539700
  541029
  543384
  544959
  552101
  553171
  554360
  559072
  559466
  561726
  561989
  564093
  567018
  567646
  569394
  577640
  590214
  593598
  593985
  599490
  608428
  608828
  614587
  614631
  615853
  627896
  629831
  636471
  636599
  639247
  639330
  650603
  650648
  655554
  660571
  692750
  701847
  708433
  712639
  715137
  718790
  719716
  721640
  724102
  724604
  726687
  726694
  739675
  747682
  757622
  762487
  765168
  768186
  769327
  770313
  774050
  775379
  778471
  782301
  785184
  788799
  792581
  793368
  796953
  797874
  798207
  801552
  801786
  802814
  805798
  810521
  810533
  812286
  814769
  821838
  827648
]
1.99 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sex room"
]
1.84 ms
(1.17%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс room"
]
1.82 ms
(1.16%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.65 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс room"
]

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.