Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.52 ms
(87.81%)
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
  466873
  539461
  542298
  543128
  545980
  546264
  548024
  553426
  554153
  555162
  557070
  564279
  572177
  584040
  584050
  585317
  588727
  604612
  604892
  606853
  606981
  610118
  622677
  622684
  628627
  628683
  631123
  635133
  639300
  641346
  647032
  647306
  648872
  651130
  653339
  671892
  671901
  677069
  691182
  692022
  693683
  693748
  694568
  697716
  701581
  704352
  707473
  707511
  710416
  712189
  712347
  723774
  724250
  724459
  724494
  725163
  728354
  729989
  730148
  733057
  733116
  736285
  738301
  739595
  740872
  740880
  741064
  742352
  743789
  745978
  749020
  749658
  758046
  759723
  759763
  762381
  762887
  762898
  764877
  764988
  768730
  768930
  768937
  774032
  787011
  788467
  789488
  789498
  791266
  793482
  795680
  795861
  795908
  800160
  803532
  803682
  807850
  808243
  810148
  811801
  813832
  817553
  817559
  818547
  819384
  823748
  824226
  824522
  824589
  824613
  825172
  825264
  825381
  826164
  826693
  827528
  827561
]
9.77 ms
(6.33%)
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
  691182
  745978
  764877
  800160
  724494
  819384
  768937
  671892
  818547
  788467
  712189
  824522
  604612
  827528
  543128
  692022
  738301
  749658
  585317
  606981
  694568
  823874
  764988
  635133
  647306
  729989
  762887
  628683
  724459
  610118
  710416
  768930
  795861
  825264
  824589
  553426
  789488
  725163
  693748
  631123
  712347
  733116
  542298
  827561
  761367
  733057
  762381
  803682
  758046
  795908
  639300
  622677
  545980
  564279
  825381
  826164
  557070
  677069
  707511
  572177
  791266
  628627
  749020
  653339
  606853
  789498
  803532
  740872
  795680
  546264
  742352
  759763
  724250
  728354
  826693
  824226
  808243
  584040
  584050
  651130
  588727
  774032
  762898
  622684
  730148
  739595
  736285
  759723
  466873
  807850
  701581
  604892
  810148
  824613
  793482
  743789
  539461
  647032
  554153
  723774
  693683
  813832
  768730
  741064
  823748
  825172
  548024
  697716
  704352
  648872
  671901
  740880
  811801
  817559
  817553
  767592
  641346
  555162
  707473
  787011
]
2.15 ms
(1.39%)
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
  466873
  539461
  542298
  543128
  545980
  546264
  548024
  553426
  554153
  555162
  557070
  564279
  572177
  584040
  584050
  585317
  588727
  604612
  604892
  606853
  606981
  610118
  622677
  622684
  628627
  628683
  631123
  635133
  639300
  641346
  647032
  647306
  648872
  651130
  653339
  671892
  671901
  677069
  691182
  692022
  693683
  693748
  694568
  697716
  701581
  704352
  707473
  707511
  710416
  712189
  712347
  723774
  724250
  724459
  724494
  725163
  728354
  729989
  730148
  733057
  733116
  736285
  738301
  739595
  740872
  740880
  741064
  742352
  743789
  745978
  749020
  749658
  758046
  759723
  759763
  762381
  762887
  762898
  764877
  764988
  768730
  768930
  768937
  774032
  787011
  788467
  789488
  789498
  791266
  793482
  795680
  795861
  795908
  800160
  803532
  803682
  807850
  808243
  810148
  811801
  813832
  817553
  817559
  818547
  819384
  823748
  824226
  824522
  824589
  824613
  825172
  825264
  825381
  826164
  826693
  827528
  827561
]
1.94 ms
(1.26%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск milf жен"
]
1.77 ms
(1.14%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.61 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск milf жен"
]
1.57 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade milf wife"
]

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.