Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
146.47 ms
(88.33%)
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
  398617
  403242
  432962
  489255
  526141
  529600
  529805
  530815
  531572
  532706
  533976
  535692
  540472
  542695
  543380
  543987
  547044
  553089
  553470
  561370
  574004
  578635
  581977
  582534
  583545
  587129
  593756
  593818
  604636
  610837
  611312
  617854
  619790
  621981
  623126
  625690
  627582
  627644
  628229
  629661
  629768
  630687
  632367
  638131
  638908
  639182
  639193
  640965
  643172
  646640
  648311
  650062
  651746
  652423
  652443
  652674
  652721
  658538
  660112
  660131
  661435
  667101
  669970
  670668
  671223
  671228
  671494
  673159
  674601
  678422
  687855
  695697
  696503
  697244
  697613
  699145
  704966
  707221
  707376
  709284
  711850
  712596
  713168
  714132
  716599
  716606
  716637
  723852
  726987
  728850
  729860
  730999
  733540
  743954
  746312
  762181
  762431
  763609
  763623
  766051
  766800
  767207
  769205
  779094
  779884
  780158
  780353
  780465
  783201
  783294
  791702
  799813
  808695
  810499
  816159
  817209
  817661
  818021
  819942
]
9.72 ms
(5.86%)
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
  660112
  716599
  780353
  791702
  646640
  671494
  723852
  716606
  532706
  581977
  730999
  746312
  762181
  629768
  632367
  593818
  611312
  743954
  697613
  709284
  652423
  630687
  707376
  817209
  489255
  529805
  531572
  526141
  535692
  540472
  542695
  553470
  574004
  578635
  543380
  582534
  648311
  652443
  658538
  669970
  674601
  699145
  652674
  667101
  671223
  687855
  707221
  670668
  673159
  711850
  553089
  628229
  643172
  627582
  638908
  639193
  726987
  617854
  623126
  638131
  779884
  733540
  762431
  398617
  432962
  678422
  403242
  533976
  547044
  543987
  587129
  763623
  766051
  651746
  799813
  766800
  767207
  817661
  696503
  716637
  660131
  697244
  621981
  629661
  640965
  779094
  783201
  729860
  810499
  769205
  704966
  783294
  808695
  530815
  650062
  713168
  661435
  695697
  593756
  604636
  610837
  619790
  625690
  728850
  763609
  714132
  818021
  819942
  816159
  529600
  583545
  561370
  652721
  671228
  712596
  627644
  639182
  780158
  780457
  780465
]
2.94 ms
(1.77%)
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
  398617
  403242
  432962
  489255
  526141
  529600
  529805
  530815
  531572
  532706
  533976
  535692
  540472
  542695
  543380
  543987
  547044
  553089
  553470
  561370
  574004
  578635
  581977
  582534
  583545
  587129
  593756
  593818
  604636
  610837
  611312
  617854
  619790
  621981
  623126
  625690
  627582
  627644
  628229
  629661
  629768
  630687
  632367
  638131
  638908
  639182
  639193
  640965
  643172
  646640
  648311
  650062
  651746
  652423
  652443
  652674
  652721
  658538
  660112
  660131
  661435
  667101
  669970
  670668
  671223
  671228
  671494
  673159
  674601
  678422
  687855
  695697
  696503
  697244
  697613
  699145
  704966
  707221
  707376
  709284
  711850
  712596
  713168
  714132
  716599
  716606
  716637
  723852
  726987
  728850
  729860
  730999
  733540
  743954
  746312
  762181
  762431
  763609
  763623
  766051
  766800
  767207
  769205
  779094
  779884
  780158
  780353
  780465
  783201
  783294
  791702
  799813
  808695
  810499
  816159
  817209
  817661
  818021
  819942
]
1.93 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob amateurs"
]
1.76 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс любительск"
]
1.60 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.41 ms
(0.85%)
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.