Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
190.46 ms
(89.26%)
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
  511162
  512318
  513536
  522210
  526780
  528283
  543708
  549787
  551856
  554998
  558990
  561253
  561929
  562122
  562223
  562905
  562941
  563191
  565658
  566360
  568608
  568973
  569299
  572358
  575131
  576096
  576301
  579613
  580134
  584832
  587072
  587890
  589619
  590500
  591088
  593485
  595764
  595791
  597158
  598186
  598198
  598214
  598228
  598749
  599367
  600049
  601437
  601868
  601940
  602001
  602793
  603970
  603986
  604120
  606019
  608464
  609130
  609133
  609181
  609271
  609602
  609723
  609837
  610390
  611469
  611484
  613356
  613415
  614495
  614701
  614987
  615658
  615680
  616909
  617026
  618825
  619098
  619180
  619364
  619515
  619522
  620040
  620054
  620072
  620083
  620264
  621181
  621224
  621672
  621973
  624821
  624936
  624949
  625382
  626127
  626405
  627095
  636257
  636264
  650028
  651214
  652213
  654468
  655541
  659225
  659295
  659300
  659427
  661237
  661281
  662380
  662594
  663789
  670617
  676209
  677387
  678935
  682719
  685929
  742279
]
12.55 ms
(5.88%)
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
  543708
  742279
  601868
  561929
  598749
  636257
  512318
  528283
  562223
  565658
  569299
  562905
  568608
  659295
  659300
  670617
  676209
  652213
  659225
  685929
  655541
  661237
  677387
  682719
  551856
  554998
  562122
  563191
  579613
  584832
  599367
  603970
  608464
  609130
  609837
  616909
  618825
  619098
  621973
  626127
  587890
  598198
  598228
  603986
  609723
  614987
  620072
  621181
  621672
  624936
  624949
  590500
  614701
  615658
  619515
  620054
  620083
  589619
  591088
  604120
  611484
  614495
  621224
  624821
  601940
  602793
  609271
  609602
  613415
  619364
  627095
  636264
  549787
  600049
  597158
  526780
  561253
  566360
  576096
  651214
  678935
  511162
  513536
  522210
  562941
  576301
  580134
  558990
  575131
  659427
  662380
  662594
  663789
  650028
  654468
  661281
  568973
  572358
  593485
  595791
  598214
  602001
  606019
  620040
  625382
  595764
  598186
  609133
  611469
  613356
  617026
  620264
  587072
  601437
  609181
  615680
  619180
  619522
  626405
  610390
]
3.48 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
  511162
  512318
  513536
  522210
  526780
  528283
  543708
  549787
  551856
  554998
  558990
  561253
  561929
  562122
  562223
  562905
  562941
  563191
  565658
  566360
  568608
  568973
  569299
  572358
  575131
  576096
  576301
  579613
  580134
  584832
  587072
  587890
  589619
  590500
  591088
  593485
  595764
  595791
  597158
  598186
  598198
  598214
  598228
  598749
  599367
  600049
  601437
  601868
  601940
  602001
  602793
  603970
  603986
  604120
  606019
  608464
  609130
  609133
  609181
  609271
  609602
  609723
  609837
  610390
  611469
  611484
  613356
  613415
  614495
  614701
  614987
  615658
  615680
  616909
  617026
  618825
  619098
  619180
  619364
  619515
  619522
  620040
  620054
  620072
  620083
  620264
  621181
  621224
  621672
  621973
  624821
  624936
  624949
  625382
  626127
  626405
  627095
  636257
  636264
  650028
  651214
  652213
  654468
  655541
  659225
  659295
  659300
  659427
  661237
  661281
  662380
  662594
  663789
  670617
  676209
  677387
  678935
  682719
  685929
  742279
]
1.97 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "русски порно"
]
1.76 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "русск порн"
]
1.59 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.74%)
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.