Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.03 ms
(85.72%)
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
  389995
  390459
  421404
  441997
  466418
  519444
  529766
  534639
  543600
  548247
  548355
  554108
  557805
  567978
  576579
  581192
  610140
  626636
  629659
  631024
  631816
  656147
  685233
  688245
  691706
  692164
  693425
  710352
  710936
  715183
  715692
  717119
  718113
  718325
  718346
  718847
  719083
  721714
  723476
  725240
  725489
  726888
  728568
  728634
  729018
  730309
  730780
  730972
  733944
  734295
  734300
  734540
  739887
  748063
  750703
  751269
  753216
  753704
  756295
  758296
  760787
  761378
  761418
  763370
  763644
  764850
  765476
  766221
  766260
  766278
  768641
  768686
  768814
  770153
  771430
  771894
  772863
  775168
  775474
  776028
  777041
  777276
  777484
  778065
  778719
  779079
  779405
  779586
  779730
  781543
  783572
  787647
  788053
  788358
  788560
  788869
  790181
  791151
  791869
  792704
  793396
  793519
  793595
  794922
  795236
  795905
  797120
  797472
  799511
  800798
  802228
  802619
  803699
  808316
  811381
  811589
  813313
  813428
  814032
]
10.15 ms
(7.31%)
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
  725489
  763644
  766221
  766278
  775474
  792704
  793595
  813313
  389995
  441997
  421404
  814032
  715692
  802228
  787647
  813428
  771430
  784610
  790181
  791151
  795236
  811381
  734295
  771894
  733944
  739887
  758296
  779079
  791869
  793519
  797120
  811589
  692164
  529766
  581192
  691706
  631816
  629659
  730780
  763370
  610140
  710936
  777484
  693425
  656147
  688245
  685233
  772863
  756295
  390459
  466418
  534639
  519444
  543600
  567978
  554108
  557805
  576579
  717119
  718847
  721714
  723476
  718325
  718346
  719083
  710352
  715183
  718113
  548247
  548355
  626636
  631024
  775168
  777276
  778719
  779405
  779730
  788053
  788869
  795905
  800798
  803699
  776028
  777041
  778065
  779586
  783572
  788358
  788560
  802619
  726888
  728568
  728634
  729018
  734300
  751269
  753216
  753704
  760787
  761378
  761418
  764850
  765476
  766260
  768641
  768686
  768814
  770153
  781543
  793396
  794922
  797472
  799511
  808316
  725240
  730309
  730972
  734540
  748063
  750703
]
3.29 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
  389995
  390459
  421404
  441997
  466418
  519444
  529766
  534639
  543600
  548247
  548355
  554108
  557805
  567978
  576579
  581192
  610140
  626636
  629659
  631024
  631816
  656147
  685233
  688245
  691706
  692164
  693425
  710352
  710936
  715183
  715692
  717119
  718113
  718325
  718346
  718847
  719083
  721714
  723476
  725240
  725489
  726888
  728568
  728634
  729018
  730309
  730780
  730972
  733944
  734295
  734300
  734540
  739887
  748063
  750703
  751269
  753216
  753704
  756295
  758296
  760787
  761378
  761418
  763370
  763644
  764850
  765476
  766221
  766260
  766278
  768641
  768686
  768814
  770153
  771430
  771894
  772863
  775168
  775474
  776028
  777041
  777276
  777484
  778065
  778719
  779079
  779405
  779586
  779730
  781543
  783572
  787647
  788053
  788358
  788560
  788869
  790181
  791151
  791869
  792704
  793396
  793519
  793595
  794922
  795236
  795905
  797120
  797472
  799511
  800798
  802228
  802619
  803699
  808316
  811381
  811589
  813313
  813428
  814032
]
1.85 ms
(1.33%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "sperm homemade"
]
1.62 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сперм домашн любительск"
]
1.34 ms
(0.96%)
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.