Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.30 ms
(87.58%)
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
  490781
  496061
  506303
  511904
  526186
  527761
  535651
  538268
  546510
  547707
  547846
  548957
  552358
  558655
  572538
  575026
  581109
  584145
  584261
  584287
  584517
  590795
  590799
  590804
  593594
  597507
  597965
  598784
  604349
  607828
  616099
  625065
  629166
  630222
  633746
  635872
  640133
  647743
  652613
  655003
  663231
  665588
  665678
  669337
  678012
  680774
  682406
  691991
  700047
  700052
  710479
  713137
  713502
  713855
  714622
  717235
  719454
  719917
  720061
  720232
  721556
  723820
  726171
  726287
  730327
  730346
  734978
  735338
  736040
  736603
  736735
  737321
  739894
  741577
  743436
  743905
  744790
  744907
  747474
  747558
  749555
  750244
  750349
  751422
  751441
  753638
  754200
  757298
  757740
  758239
  766040
  767399
  768392
  769631
  769910
  771526
  775383
  778427
  779666
  781002
  781599
  784083
  786790
  791283
  791399
  791997
  792268
  794075
  794442
  795836
  796384
  796880
  799289
  800471
  804381
  806376
  806649
  810098
  813312
  813850
]
12.55 ms
(6.53%)
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
  723820
  750244
  751441
  640133
  779666
  813850
  496061
  511904
  506303
  572538
  584261
  584145
  584517
  678012
  719454
  713855
  720232
  717235
  548957
  598784
  597507
  635872
  590795
  604349
  629166
  786790
  791997
  800471
  791283
  726171
  739894
  796384
  744907
  730346
  734978
  750349
  758239
  749555
  767399
  769910
  781002
  527761
  538268
  558655
  581109
  552358
  575026
  647743
  652613
  713137
  721556
  663231
  691991
  546510
  616099
  593594
  590804
  795836
  806649
  743905
  766040
  730327
  736735
  736603
  743436
  754200
  747558
  753638
  751422
  771526
  633746
  775383
  547707
  682406
  700052
  719917
  720061
  655003
  680774
  713502
  781599
  813312
  792268
  806376
  741577
  794075
  794442
  804381
  737321
  769631
  726287
  757298
  768392
  735338
  747474
  757740
  625065
  630222
  700047
  710479
  714622
  784083
  791399
  796880
  810098
  526186
  744790
  607828
  584287
  665588
  778427
  669337
  490781
  535651
  547846
  665678
  590799
  597965
  799289
  736040
]
4.10 ms
(2.13%)
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
  490781
  496061
  506303
  511904
  526186
  527761
  535651
  538268
  546510
  547707
  547846
  548957
  552358
  558655
  572538
  575026
  581109
  584145
  584261
  584287
  584517
  590795
  590799
  590804
  593594
  597507
  597965
  598784
  604349
  607828
  616099
  625065
  629166
  630222
  633746
  635872
  640133
  647743
  652613
  655003
  663231
  665588
  665678
  669337
  678012
  680774
  682406
  691991
  700047
  700052
  710479
  713137
  713502
  713855
  714622
  717235
  719454
  719917
  720061
  720232
  721556
  723820
  726171
  726287
  730327
  730346
  734978
  735338
  736040
  736603
  736735
  737321
  739894
  741577
  743436
  743905
  744790
  744907
  747474
  747558
  749555
  750244
  750349
  751422
  751441
  753638
  754200
  757298
  757740
  758239
  766040
  767399
  768392
  769631
  769910
  771526
  775383
  778427
  779666
  781002
  781599
  784083
  786790
  791283
  791399
  791997
  792268
  794075
  794442
  795836
  796384
  796880
  799289
  800471
  804381
  806376
  806649
  810098
  813312
  813850
]
2.02 ms
(1.05%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "first time girl"
]
1.79 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "вперв девушк"
]
1.66 ms
(0.87%)
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.