Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.77 ms
(86.43%)
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
  398744
  411805
  414173
  416881
  417278
  418739
  418795
  425641
  429242
  429265
  442090
  443415
  443950
  456444
  457411
  460276
  462228
  462347
  464872
  466786
  468516
  474982
  477876
  483769
  491696
  493676
  497843
  502010
  504282
  506166
  508256
  512311
  513921
  518510
  519828
  523059
  528188
  532284
  535622
  538103
  539398
  541692
  548017
  552813
  553433
  557600
  558343
  558379
  562025
  562618
  564442
  574185
  575274
  579686
  590401
  596484
  598020
  601210
  604993
  606352
  606926
  607885
  614444
  615640
  622488
  626256
  642275
  690455
  693174
  702224
  718639
  729198
  730052
  734789
  740627
  743350
  755589
  756256
  763950
  763964
  765927
  767643
  771291
  771660
  771824
  773681
  774234
  777866
  778646
  779002
  779338
  781272
  781584
  782382
  782497
  785468
  786080
  786244
  789496
  790849
  791196
  796086
  796897
  797018
  798127
  800777
  802480
  802801
  804323
  807365
  809996
  810417
  812703
  813116
  813298
  813617
  818823
  819440
  820190
]
13.72 ms
(7.71%)
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
  590401
  596484
  604993
  614444
  615640
  606352
  606926
  607885
  622488
  778646
  782382
  782497
  791196
  796897
  802801
  813116
  779338
  786080
  789496
  796086
  797018
  802480
  740627
  743350
  755589
  763950
  772131
  781272
  781584
  785468
  786244
  790849
  798127
  800777
  807365
  810417
  729198
  734789
  773681
  774234
  756256
  771291
  771660
  771824
  763964
  765927
  767643
  642275
  702224
  779002
  804323
  812703
  813298
  443950
  462347
  468516
  464872
  457411
  462228
  491696
  693174
  690455
  777866
  809996
  730052
  718639
  398744
  819440
  502010
  552813
  564442
  474982
  477876
  418795
  411805
  506166
  512311
  562618
  579686
  548017
  601210
  626256
  598020
  425641
  443415
  442090
  416881
  418739
  414173
  417278
  429242
  429265
  813617
  818823
  820190
  466786
  493676
  456444
  460276
  483769
  497843
  518510
  528188
  532284
  508256
  519828
  523059
  538103
  504282
  513921
  535622
  539398
  562025
  574185
  575274
  541692
  553433
  557600
  558343
  558379
]
2.90 ms
(1.63%)
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
  398744
  411805
  414173
  416881
  417278
  418739
  418795
  425641
  429242
  429265
  442090
  443415
  443950
  456444
  457411
  460276
  462228
  462347
  464872
  466786
  468516
  474982
  477876
  483769
  491696
  493676
  497843
  502010
  504282
  506166
  508256
  512311
  513921
  518510
  519828
  523059
  528188
  532284
  535622
  538103
  539398
  541692
  548017
  552813
  553433
  557600
  558343
  558379
  562025
  562618
  564442
  574185
  575274
  579686
  590401
  596484
  598020
  601210
  604993
  606352
  606926
  607885
  614444
  615640
  622488
  626256
  642275
  690455
  693174
  702224
  718639
  729198
  730052
  734789
  740627
  743350
  755589
  756256
  763950
  763964
  765927
  767643
  771291
  771660
  771824
  773681
  774234
  777866
  778646
  779002
  779338
  781272
  781584
  782382
  782497
  785468
  786080
  786244
  789496
  790849
  791196
  796086
  796897
  797018
  798127
  800777
  802480
  802801
  804323
  807365
  809996
  810417
  812703
  813116
  813298
  813617
  818823
  819440
  820190
]
2.15 ms
(1.21%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pov fucking"
]
1.84 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(1.02%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "пов fucking"
]
1.70 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "пов fucking"
]

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.