Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
207.34 ms
(89.56%)
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
  30967
  322090
  395332
  397089
  397417
  406724
  409613
  415451
  416863
  417733
  421068
  421412
  422280
  424541
  434992
  440947
  450160
  484304
  504748
  520163
  528848
  551221
  552928
  558048
  562688
  565291
  566051
  566287
  581418
  593790
  596944
  599318
  606253
  620707
  621715
  621979
  625492
  630769
  638147
  639882
  647607
  668034
  671220
  673860
  673908
  675536
  684533
  685432
  687140
  690052
  692378
  694661
  697203
  698352
  705726
  711358
  713208
  715435
  718864
  719457
  722253
  722434
  722709
  723819
  729789
  731580
  733671
  737587
  739459
  743892
  747429
  747982
  752580
  755352
  758420
  759608
  763529
  763589
  764518
  767983
  769585
  771442
  774698
  775826
  779289
  779427
  779806
  782307
  785029
  785229
  789922
  792570
  793680
  793755
  793787
  795089
  799446
  799864
  801737
  803714
  804864
  807417
  809592
  810924
  816001
  818404
  818826
  818835
  819720
  819872
  819938
  820196
  820709
  820757
  821122
  821586
  822201
  823720
  824546
  825581
]
15.36 ms
(6.63%)
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
  764518
  755352
  687140
  819720
  820757
  820196
  818826
  562688
  722434
  621715
  752580
  747982
  792570
  675536
  690052
  638147
  639882
  789922
  685432
  566287
  668034
  810924
  30967
  799864
  818404
  620707
  731580
  733671
  520163
  821122
  719457
  722253
  715435
  774698
  807417
  739459
  767983
  397417
  434992
  409613
  421412
  818835
  566051
  558048
  785229
  723819
  722709
  775826
  819872
  825581
  630769
  785029
  698352
  417733
  801737
  606253
  793680
  803714
  484304
  819938
  684533
  694661
  397089
  593790
  422280
  711358
  596944
  771442
  415451
  737587
  816001
  647607
  824546
  820709
  565291
  625492
  793755
  793787
  759608
  747429
  758420
  450160
  718864
  713208
  322090
  763529
  769585
  729789
  804864
  528848
  671220
  763589
  779427
  697203
  823720
  743892
  416863
  421068
  799446
  581418
  705726
  621979
  552928
  692378
  779806
  395332
  673860
  504748
  440947
  821586
  822201
  809592
  424541
  551221
  673908
  599318
  779289
  782307
  795089
  406724
]
2.13 ms
(0.92%)
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
  30967
  322090
  395332
  397089
  397417
  406724
  409613
  415451
  416863
  417733
  421068
  421412
  422280
  424541
  434992
  440947
  450160
  484304
  504748
  520163
  528848
  551221
  552928
  558048
  562688
  565291
  566051
  566287
  581418
  593790
  596944
  599318
  606253
  620707
  621715
  621979
  625492
  630769
  638147
  639882
  647607
  668034
  671220
  673860
  673908
  675536
  684533
  685432
  687140
  690052
  692378
  694661
  697203
  698352
  705726
  711358
  713208
  715435
  718864
  719457
  722253
  722434
  722709
  723819
  729789
  731580
  733671
  737587
  739459
  743892
  747429
  747982
  752580
  755352
  758420
  759608
  763529
  763589
  764518
  767983
  769585
  771442
  774698
  775826
  779289
  779427
  779806
  782307
  785029
  785229
  789922
  792570
  793680
  793755
  793787
  795089
  799446
  799864
  801737
  803714
  804864
  807417
  809592
  810924
  816001
  818404
  818826
  818835
  819720
  819872
  819938
  820196
  820709
  820757
  821122
  821586
  822201
  823720
  824546
  825581
]
1.72 ms
(0.74%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.74%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "real минет оральн секс сперм"
]
1.68 ms
(0.72%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "real минет оральн секс сперм"
]
1.57 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "real blowjob sperm"
]

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.