Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
162.87 ms
(86.02%)
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
  95943
  96056
  154157
  156014
  187542
  213573
  326289
  359084
  378046
  382637
  385851
  388436
  392971
  404076
  407827
  412273
  417050
  419523
  419636
  421885
  422211
  424841
  425540
  426155
  429440
  433110
  439705
  439707
  441774
  442088
  445056
  459513
  462396
  464521
  464826
  466752
  467146
  470234
  472305
  472601
  474582
  478993
  479071
  488743
  492372
  493600
  497516
  512964
  513487
  518763
  524781
  555130
  562967
  564111
  572669
  581126
  592955
  601930
  634559
  670354
  672041
  672184
  683284
  699743
  709528
  711744
  719245
  719308
  720067
  720788
  722160
  726776
  727741
  731327
  733454
  734436
  749891
  757052
  758504
  759796
  759806
  760932
  761069
  761119
  761461
  762301
  766673
  767061
  773912
  777734
  781590
  782294
  786550
  789619
  791202
  792654
  794070
  794859
  794877
  795309
  795540
  795706
  796156
  796252
  797163
  798804
  798999
  800326
  800349
  800511
  800612
  801214
  801301
  810301
  812926
  820946
  827220
  827383
  827492
  828553
]
16.02 ms
(8.46%)
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
  749891
  761069
  762301
  766673
  782294
  792654
  794070
  798804
  800326
  812926
  581126
  672184
  359084
  472305
  512964
  564111
  467146
  426155
  419523
  699743
  213573
  388436
  412273
  479071
  562967
  777734
  326289
  425540
  827220
  827492
  828553
  719308
  711744
  800511
  801214
  786550
  796156
  798999
  439705
  385851
  154157
  761119
  761461
  555130
  518763
  441774
  683284
  709528
  634559
  796252
  758504
  572669
  382637
  720067
  791202
  794859
  795309
  767061
  760932
  96056
  789619
  462396
  493600
  592955
  466752
  464826
  513487
  801301
  478993
  497516
  421885
  439707
  524781
  459513
  470234
  378046
  417050
  472601
  419636
  187542
  392971
  827383
  719245
  407827
  95943
  433110
  601930
  733454
  488743
  795540
  424841
  442088
  474582
  727741
  422211
  445056
  404076
  820946
  492372
  722160
  672041
  720788
  670354
  781590
  795706
  800612
  726776
  734436
  759796
  773912
  731327
  759806
  800349
  810301
  156014
  794877
  797163
  464521
  757052
  429440
]
2.73 ms
(1.44%)
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
  95943
  96056
  154157
  156014
  187542
  213573
  326289
  359084
  378046
  382637
  385851
  388436
  392971
  404076
  407827
  412273
  417050
  419523
  419636
  421885
  422211
  424841
  425540
  426155
  429440
  433110
  439705
  439707
  441774
  442088
  445056
  459513
  462396
  464521
  464826
  466752
  467146
  470234
  472305
  472601
  474582
  478993
  479071
  488743
  492372
  493600
  497516
  512964
  513487
  518763
  524781
  555130
  562967
  564111
  572669
  581126
  592955
  601930
  634559
  670354
  672041
  672184
  683284
  699743
  709528
  711744
  719245
  719308
  720067
  720788
  722160
  726776
  727741
  731327
  733454
  734436
  749891
  757052
  758504
  759796
  759806
  760932
  761069
  761119
  761461
  762301
  766673
  767061
  773912
  777734
  781590
  782294
  786550
  789619
  791202
  792654
  794070
  794859
  794877
  795309
  795540
  795706
  796156
  796252
  797163
  798804
  798999
  800326
  800349
  800511
  800612
  801214
  801301
  810301
  812926
  820946
  827220
  827383
  827492
  828553
]
2.04 ms
(1.08%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "мамочку ебут в жопу"
]
1.94 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.92 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мам женщин секс анал"
]
1.81 ms
(0.95%)
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.