Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.27 ms
(83.85%)
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
  24724
  156525
  198253
  383388
  387027
  387409
  391535
  396378
  398376
  401450
  419013
  423703
  446251
  450216
  451661
  452205
  456654
  461571
  463637
  464268
  464270
  465489
  470155
  490238
  493114
  495787
  495885
  499013
  504348
  506732
  508048
  513252
  513430
  514034
  515992
  521294
  526234
  530296
  543569
  544589
  551973
  552190
  553155
  553166
  553697
  554707
  555808
  570870
  578851
  579502
  586218
  588125
  602807
  604815
  609726
  614483
  627012
  629596
  633406
  633477
  637318
  640488
  650221
  652573
  652884
  654125
  656660
  661265
  663285
  663971
  664717
  667246
  669708
  670238
  670937
  673049
  677148
  680382
  680778
  689566
  699196
  703650
  707388
  715047
  719817
  722368
  730672
  731119
  732685
  736184
  741863
  751412
  753619
  753733
  754638
  754918
  755284
  759160
  762854
  763496
  767267
  769122
  778381
  778948
  779274
  779483
  779930
  782067
  782918
  783780
  787935
  790399
  793989
  800134
  803886
  807070
  807825
  811512
  813723
  827227
]
13.63 ms
(9.50%)
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
  544589
  553155
  627012
  730672
  732685
  753619
  722368
  604815
  463637
  508048
  513430
  387027
  493114
  514034
  677148
  664717
  490238
  513252
  778381
  446251
  24724
  530296
  552190
  543569
  656660
  654125
  652573
  669708
  680382
  689566
  633477
  629596
  751412
  753733
  387409
  456654
  391535
  470155
  156525
  396378
  452205
  495787
  551973
  570870
  419013
  464268
  515992
  554707
  670937
  661265
  663285
  715047
  602807
  609726
  614483
  637318
  787935
  803886
  769122
  741863
  754638
  731119
  633406
  807825
  198253
  401450
  495885
  652884
  719817
  670238
  707388
  790399
  800134
  807070
  763496
  759160
  767267
  450216
  754918
  504348
  578851
  586218
  461571
  451661
  506732
  526234
  827227
  811512
  755284
  553697
  663971
  673049
  699196
  650221
  667246
  782918
  783780
  793989
  778948
  779274
  736184
  762854
  779483
  779930
  782067
  521294
  383388
  553166
  555808
  703650
  588125
  640488
  423703
  464270
  398376
  465489
  579502
  680778
  813723
  499013
]
2.93 ms
(2.05%)
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
  24724
  156525
  198253
  383388
  387027
  387409
  391535
  396378
  398376
  401450
  419013
  423703
  446251
  450216
  451661
  452205
  456654
  461571
  463637
  464268
  464270
  465489
  470155
  490238
  493114
  495787
  495885
  499013
  504348
  506732
  508048
  513252
  513430
  514034
  515992
  521294
  526234
  530296
  543569
  544589
  551973
  552190
  553155
  553166
  553697
  554707
  555808
  570870
  578851
  579502
  586218
  588125
  602807
  604815
  609726
  614483
  627012
  629596
  633406
  633477
  637318
  640488
  650221
  652573
  652884
  654125
  656660
  661265
  663285
  663971
  664717
  667246
  669708
  670238
  670937
  673049
  677148
  680382
  680778
  689566
  699196
  703650
  707388
  715047
  719817
  722368
  730672
  731119
  732685
  736184
  741863
  751412
  753619
  753733
  754638
  754918
  755284
  759160
  762854
  763496
  767267
  769122
  778381
  778948
  779274
  779483
  779930
  782067
  782918
  783780
  787935
  790399
  793989
  800134
  803886
  807070
  807825
  811512
  813723
  827227
]
1.98 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "girl bathroom"
]
1.61 ms
(1.12%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "девушк ван"
]
1.51 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.05%)
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.