Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.66 ms
(81.27%)
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
  397961
  400156
  400195
  403003
  409144
  409585
  414177
  417258
  425079
  426105
  433808
  434182
  437366
  438429
  439200
  443859
  445502
  445551
  446268
  446587
  447574
  447979
  448578
  450399
  456061
  458723
  459225
  463563
  464200
  465167
  466865
  472295
  479330
  481599
  482249
  484300
  485187
  486348
  489250
  492614
  498238
  507889
  512886
  515384
  516427
  516444
  519831
  523475
  523476
  523494
  524109
  524144
  524397
  526591
  526611
  527687
  528817
  528833
  534722
  536901
  544103
  546425
  548489
  556398
  561281
  561948
  567185
  572220
  574990
  578569
  581137
  584765
  586178
  587915
  588378
  590735
  591940
  601175
  601325
  601940
  605809
  606621
  606827
  607698
  608415
  610235
  615712
  619955
  620300
  623754
  625649
  697909
  700540
  701527
  714626
  717948
  717966
  719912
  723945
  724045
  726410
  727891
  753205
  753764
  761986
  769536
  772446
  775270
  793042
  799063
  805069
  806058
  810760
  818080
  820337
  825114
]
17.56 ms
(11.93%)
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
  717966
  810760
  459225
  434182
  400156
  512886
  524144
  425079
  443859
  417258
  437366
  439200
  818080
  445502
  482249
  528833
  534722
  523475
  464200
  544103
  578569
  561281
  717948
  701527
  548489
  574990
  601325
  586178
  608415
  623754
  588378
  607698
  619955
  775270
  724045
  727891
  772446
  761986
  769536
  723945
  753764
  615712
  714626
  719912
  793042
  492614
  606621
  620300
  516427
  438429
  447574
  448578
  456061
  519831
  463563
  466865
  481599
  556398
  590735
  799063
  805069
  806058
  753205
  726410
  700540
  426105
  450399
  527687
  485187
  489250
  523476
  528817
  446587
  516444
  561948
  414177
  397961
  458723
  479330
  507889
  526591
  824020
  445551
  523494
  581137
  567185
  601940
  446268
  400195
  409144
  526611
  484300
  498238
  524109
  823834
  409585
  465167
  524397
  486348
  403003
  433808
  825114
  820337
  536901
  447979
  472295
  515384
  527201
  572220
  584765
  676582
  697909
  546425
  587915
  591940
  606827
  605809
  610235
  601175
  625649
]
2.84 ms
(1.93%)
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
  397961
  400156
  400195
  403003
  409144
  409585
  414177
  417258
  425079
  426105
  433808
  434182
  437366
  438429
  439200
  443859
  445502
  445551
  446268
  446587
  447574
  447979
  448578
  450399
  456061
  458723
  459225
  463563
  464200
  465167
  466865
  472295
  479330
  481599
  482249
  484300
  485187
  486348
  489250
  492614
  498238
  507889
  512886
  515384
  516427
  516444
  519831
  523475
  523476
  523494
  524109
  524144
  524397
  526591
  526611
  527687
  528817
  528833
  534722
  536901
  544103
  546425
  548489
  556398
  561281
  561948
  567185
  572220
  574990
  578569
  581137
  584765
  586178
  587915
  588378
  590735
  591940
  601175
  601325
  601940
  605809
  606621
  606827
  607698
  608415
  610235
  615712
  619955
  620300
  623754
  625649
  697909
  700540
  701527
  714626
  717948
  717966
  719912
  723945
  724045
  726410
  727891
  753205
  753764
  761986
  769536
  772446
  775270
  793042
  799063
  805069
  806058
  810760
  818080
  820337
  825114
]
2.07 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "step girls"
]
1.86 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.73 ms
(1.18%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "step девушк"
]
1.51 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "step девушк"
]

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.