Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
169.05 ms
(88.06%)
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
  386493
  396925
  396988
  399691
  403476
  409252
  411693
  413516
  421543
  425646
  435535
  436942
  446756
  451514
  453804
  458988
  460145
  460503
  461213
  461240
  462224
  474860
  475556
  476073
  492137
  492276
  492714
  504666
  505538
  509114
  509408
  513188
  515377
  517299
  517332
  517805
  519175
  521722
  531325
  532817
  534276
  534837
  537464
  543428
  553062
  554544
  555448
  559601
  562974
  564558
  568381
  568452
  568474
  568985
  569035
  569116
  569126
  569149
  569530
  569539
  569545
  570146
  578456
  578858
  583515
  585370
  585959
  591087
  603417
  604213
  604908
  607481
  607691
  610066
  613825
  616448
  616700
  625220
  629619
  638688
  652760
  663566
  667942
  672842
  673121
  675654
  686185
  697766
  701566
  704153
  709450
  712682
  714925
  716201
  717645
  725624
  732990
  733645
  739089
  760755
  760980
  761066
  778986
  795137
  795983
  796150
  796793
  796805
  796919
  800042
  803035
  803148
  810465
  812768
  814092
  816211
  819268
  819777
  820956
  823456
]
13.85 ms
(7.21%)
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
  652760
  796150
  760980
  532817
  513188
  559601
  460503
  760755
  800042
  819777
  819268
  476073
  509114
  531325
  492276
  569035
  570146
  701566
  709450
  717645
  712682
  585370
  591087
  796793
  803035
  725624
  732990
  778986
  396988
  820956
  446756
  462224
  534276
  537464
  583515
  562974
  564558
  569530
  578858
  604213
  733645
  409252
  413516
  451514
  436942
  517299
  517805
  505538
  519175
  814092
  795137
  399691
  403476
  816211
  474860
  453804
  460145
  521722
  509408
  553062
  569116
  543428
  663566
  672842
  704153
  555448
  568474
  569539
  604908
  616700
  607481
  625220
  603417
  607691
  616448
  629619
  638688
  795983
  796805
  796919
  803148
  810465
  812768
  739089
  610066
  613825
  697766
  396925
  411693
  515377
  568381
  569149
  716201
  673121
  667942
  761066
  461240
  568985
  475556
  492714
  421543
  425646
  435535
  823456
  458988
  492137
  534837
  504666
  461213
  554544
  569545
  675654
  714925
  568452
  517332
  578456
  686185
  569126
  585959
  386493
]
2.71 ms
(1.41%)
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
  386493
  396925
  396988
  399691
  403476
  409252
  411693
  413516
  421543
  425646
  435535
  436942
  446756
  451514
  453804
  458988
  460145
  460503
  461213
  461240
  462224
  474860
  475556
  476073
  492137
  492276
  492714
  504666
  505538
  509114
  509408
  513188
  515377
  517299
  517332
  517805
  519175
  521722
  531325
  532817
  534276
  534837
  537464
  543428
  553062
  554544
  555448
  559601
  562974
  564558
  568381
  568452
  568474
  568985
  569035
  569116
  569126
  569149
  569530
  569539
  569545
  570146
  578456
  578858
  583515
  585370
  585959
  591087
  603417
  604213
  604908
  607481
  607691
  610066
  613825
  616448
  616700
  625220
  629619
  638688
  652760
  663566
  667942
  672842
  673121
  675654
  686185
  697766
  701566
  704153
  709450
  712682
  714925
  716201
  717645
  725624
  732990
  733645
  739089
  760755
  760980
  761066
  778986
  795137
  795983
  796150
  796793
  796805
  796919
  800042
  803035
  803148
  810465
  812768
  814092
  816211
  819268
  819777
  820956
  823456
]
1.99 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty ass milf"
]
1.64 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty жоп milf"
]
1.38 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty жоп milf"
]
1.34 ms
(0.70%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.