Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
136.48 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
  197982
  387925
  414061
  435589
  458524
  462713
  466970
  476891
  486772
  505768
  514785
  530929
  532038
  532237
  534183
  535064
  537384
  537619
  542723
  547339
  548093
  557723
  563942
  566005
  582448
  585475
  585832
  596732
  598028
  609219
  610123
  617143
  617509
  621183
  621882
  625985
  626688
  628184
  628569
  629179
  629313
  630120
  635212
  636444
  649034
  651066
  651128
  651947
  654092
  656608
  661435
  666183
  668133
  676775
  678254
  678895
  682851
  683484
  685832
  687021
  687340
  690946
  692319
  694073
  694492
  696354
  698342
  698405
  698483
  699743
  699779
  706555
  706734
  707509
  707604
  710720
  710777
  714596
  715872
  716101
  722991
  733713
  738242
  739471
  740603
  740679
  740839
  745259
  748668
  749645
  757201
  758715
  760461
  762059
  765143
  766062
  769963
  771732
  775668
  776253
  777254
  778075
  780764
  781599
  787117
  788916
  790617
  800498
  804932
  808153
  810262
  810573
  811468
  812328
  823475
  823892
  823895
  824190
  827998
  828845
]
12.69 ms
(7.97%)
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
  414061
  823892
  486772
  530929
  537384
  532237
  534183
  535064
  547339
  542723
  548093
  582448
  651947
  676775
  692319
  707509
  656608
  678254
  678895
  687021
  694492
  699779
  706555
  651066
  654092
  685832
  698405
  710720
  710777
  716101
  585475
  617143
  629313
  621882
  609219
  621183
  625985
  596732
  617509
  626688
  629179
  775668
  804932
  812328
  788916
  800498
  739471
  740839
  757201
  758715
  810573
  769963
  762059
  733713
  745259
  748668
  771732
  738242
  740603
  740679
  749645
  698483
  722991
  777254
  808153
  462713
  466970
  197982
  435589
  505768
  514785
  387925
  823895
  823475
  824190
  827998
  828845
  458524
  476891
  532038
  537619
  557723
  566005
  651128
  682851
  683484
  690946
  706734
  699743
  714596
  715872
  649034
  661435
  666183
  668133
  687340
  694073
  696354
  698342
  707604
  563942
  585832
  598028
  635212
  610123
  628184
  628569
  630120
  636444
  778075
  781599
  790617
  776253
  780764
  787117
  810262
  811468
  760461
  765143
  766062
]
2.78 ms
(1.75%)
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
  197982
  387925
  414061
  435589
  458524
  462713
  466970
  476891
  486772
  505768
  514785
  530929
  532038
  532237
  534183
  535064
  537384
  537619
  542723
  547339
  548093
  557723
  563942
  566005
  582448
  585475
  585832
  596732
  598028
  609219
  610123
  617143
  617509
  621183
  621882
  625985
  626688
  628184
  628569
  629179
  629313
  630120
  635212
  636444
  649034
  651066
  651128
  651947
  654092
  656608
  661435
  666183
  668133
  676775
  678254
  678895
  682851
  683484
  685832
  687021
  687340
  690946
  692319
  694073
  694492
  696354
  698342
  698405
  698483
  699743
  699779
  706555
  706734
  707509
  707604
  710720
  710777
  714596
  715872
  716101
  722991
  733713
  738242
  739471
  740603
  740679
  740839
  745259
  748668
  749645
  757201
  758715
  760461
  762059
  765143
  766062
  769963
  771732
  775668
  776253
  777254
  778075
  780764
  781599
  787117
  788916
  790617
  800498
  804932
  808153
  810262
  810573
  811468
  812328
  823475
  823892
  823895
  824190
  827998
  828845
]
2.18 ms
(1.37%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "video girl"
]
1.87 ms
(1.17%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "video девушк"
]
1.58 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "video девушк"
]

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.