Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
115.98 ms
(83.74%)
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
  415534
  458277
  459920
  466238
  471847
  480998
  483879
  491867
  507805
  509381
  510288
  530036
  531645
  536177
  536634
  537454
  545513
  545561
  545786
  554846
  566555
  566894
  569069
  588715
  598143
  600515
  601955
  604098
  604590
  606167
  610260
  617382
  621674
  624409
  625464
  625473
  628685
  630767
  633338
  633381
  635099
  639229
  647797
  653754
  654137
  656868
  659075
  661099
  661789
  663690
  665578
  665900
  666347
  668939
  669500
  671446
  682872
  684880
  689894
  691584
  692904
  693395
  698603
  699122
  699564
  701207
  704804
  705806
  707044
  707143
  710945
  715379
  715692
  718654
  720149
  722031
  723090
  726999
  728551
  728945
  732041
  733461
  734264
  738276
  739200
  743990
  745923
  747372
  748055
  750467
  751244
  751899
  752292
  755688
  757239
  757465
  764083
  771206
  777855
  783338
  800775
  803640
  806489
  817573
  818304
  821005
  821556
  822704
  823163
  823397
  823723
  823999
  824863
  825301
  826110
  827257
  827930
]
12.90 ms
(9.31%)
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
  823163
  458277
  530036
  531645
  471847
  569069
  659075
  701207
  691584
  566894
  621674
  604098
  624409
  606167
  728551
  739200
  750467
  751244
  755688
  783338
  803640
  734264
  738276
  752292
  757465
  728945
  604590
  633338
  459920
  536634
  827257
  821556
  554846
  669500
  707044
  689894
  723090
  682872
  707143
  625464
  598143
  732041
  751899
  601955
  466238
  415534
  509381
  823397
  825301
  480998
  483879
  491867
  536177
  507805
  510288
  537454
  566555
  665900
  688681
  715379
  668939
  671446
  715692
  628685
  633381
  617382
  630767
  733461
  748055
  757239
  771206
  764083
  743990
  726999
  745923
  747372
  639229
  698603
  699564
  806489
  823723
  824863
  826110
  822704
  825178
  817573
  818304
  821005
  823999
  827930
  545513
  545786
  647797
  656868
  666347
  699122
  704804
  720149
  653754
  663690
  705806
  710945
  718654
  654137
  661099
  661789
  665578
  684880
  692904
  693395
  722031
  545561
  610260
  625473
  635099
  588715
  639401
  600515
  777855
  800775
]
2.50 ms
(1.81%)
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
  415534
  458277
  459920
  466238
  471847
  480998
  483879
  491867
  507805
  509381
  510288
  530036
  531645
  536177
  536634
  537454
  545513
  545561
  545786
  554846
  566555
  566894
  569069
  588715
  598143
  600515
  601955
  604098
  604590
  606167
  610260
  617382
  621674
  624409
  625464
  625473
  628685
  630767
  633338
  633381
  635099
  639229
  647797
  653754
  654137
  656868
  659075
  661099
  661789
  663690
  665578
  665900
  666347
  668939
  669500
  671446
  682872
  684880
  689894
  691584
  692904
  693395
  698603
  699122
  699564
  701207
  704804
  705806
  707044
  707143
  710945
  715379
  715692
  718654
  720149
  722031
  723090
  726999
  728551
  728945
  732041
  733461
  734264
  738276
  739200
  743990
  745923
  747372
  748055
  750467
  751244
  751899
  752292
  755688
  757239
  757465
  764083
  771206
  777855
  783338
  800775
  803640
  806489
  817573
  818304
  821005
  821556
  822704
  823163
  823397
  823723
  823999
  824863
  825301
  826110
  827257
  827930
]
2.17 ms
(1.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "masturbation big cock"
]
1.79 ms
(1.29%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мастурбац большие cock"
]
1.67 ms
(1.21%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "мастурбац большие cock"
]

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.