Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
168.75 ms
(90.45%)
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
  79520
  149538
  207540
  392987
  494539
  500311
  502540
  517440
  532137
  532195
  536951
  543284
  545890
  546143
  546264
  547115
  562453
  565517
  566804
  567621
  588002
  620485
  629579
  632820
  697683
  701238
  702381
  704345
  704401
  706154
  715440
  716268
  716452
  716975
  720666
  722106
  725344
  725421
  725449
  726126
  726281
  726764
  730060
  730413
  730837
  730951
  731271
  735478
  736681
  739684
  740274
  741094
  742352
  742505
  743773
  743789
  744169
  744342
  744811
  746854
  749648
  750700
  751954
  752110
  753781
  754850
  755043
  760173
  761526
  762887
  763449
  767513
  767536
  768508
  768676
  768894
  771347
  780912
  782595
  783133
  788673
  794645
  794731
  795013
  795197
  797290
  801703
  803301
  808246
  818257
  818265
  818978
  818983
  819116
  819347
  819745
  820129
  820161
  820749
  823744
  823867
  824143
  824717
  824801
  824879
  825089
  825837
  826091
  826229
  826276
  826491
  826507
  826770
  827055
  827087
  827418
  827525
  827580
  828572
]
8.78 ms
(4.70%)
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
  801703
  726126
  746854
  725449
  741094
  742505
  629579
  632820
  700231
  702381
  704401
  706154
  715440
  794731
  797290
  744169
  783133
  725421
  744811
  731271
  744342
  392987
  826770
  818983
  726281
  500311
  543284
  826276
  824717
  532137
  567621
  716975
  762887
  149538
  546143
  546264
  742352
  755043
  749648
  826491
  819347
  827087
  827418
  827525
  826507
  819745
  826091
  828572
  532195
  565517
  716268
  720666
  788673
  782595
  726764
  730060
  730413
  760173
  767513
  767536
  794645
  803301
  730951
  736681
  754850
  768508
  740274
  763449
  735478
  739684
  743789
  752110
  771347
  761526
  768894
  780912
  795013
  207540
  795197
  750700
  751954
  725344
  536951
  566804
  547115
  704345
  562453
  620485
  743773
  701238
  79520
  722106
  808246
  753781
  818978
  824879
  827580
  820161
  517440
  697683
  502540
  545890
  588002
  730837
  716452
  768676
  818265
  826229
  825837
  825089
  819116
  820129
  823744
  823867
  827055
  824143
  824801
  818257
  820749
  494539
]
2.17 ms
(1.16%)
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
  79520
  149538
  207540
  392987
  494539
  500311
  502540
  517440
  532137
  532195
  536951
  543284
  545890
  546143
  546264
  547115
  562453
  565517
  566804
  567621
  588002
  620485
  629579
  632820
  697683
  701238
  702381
  704345
  704401
  706154
  715440
  716268
  716452
  716975
  720666
  722106
  725344
  725421
  725449
  726126
  726281
  726764
  730060
  730413
  730837
  730951
  731271
  735478
  736681
  739684
  740274
  741094
  742352
  742505
  743773
  743789
  744169
  744342
  744811
  746854
  749648
  750700
  751954
  752110
  753781
  754850
  755043
  760173
  761526
  762887
  763449
  767513
  767536
  768508
  768676
  768894
  771347
  780912
  782595
  783133
  788673
  794645
  794731
  795013
  795197
  797290
  801703
  803301
  808246
  818257
  818265
  818978
  818983
  819116
  819347
  819745
  820129
  820161
  820749
  823744
  823867
  824143
  824717
  824801
  824879
  825089
  825837
  826091
  826229
  826276
  826491
  826507
  826770
  827055
  827087
  827418
  827525
  827580
  828572
]
1.98 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateurs wife"
]
1.75 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск жен"
]
1.74 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.76%)
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.