Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
167.79 ms
(87.85%)
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
  147073
  450682
  454981
  490952
  491424
  496793
  500815
  510102
  516226
  516496
  531006
  538066
  539454
  541064
  541301
  542474
  544417
  546420
  547402
  548909
  550965
  553417
  554846
  555411
  555457
  555992
  556876
  574118
  578773
  584577
  588550
  599464
  600358
  600942
  604760
  630143
  631538
  633857
  634902
  640366
  645006
  647111
  662914
  668105
  678997
  681344
  681609
  684486
  686107
  689040
  696291
  697188
  699323
  699519
  705478
  707238
  708532
  708561
  709850
  710244
  710503
  714402
  714587
  719074
  721037
  723642
  725081
  725154
  728373
  730103
  730154
  736981
  738534
  739645
  742066
  745684
  747981
  748028
  748034
  752532
  756827
  757290
  767474
  768348
  773639
  773691
  775294
  776216
  777422
  777992
  784631
  784974
  786101
  786858
  790415
  792681
  793905
  794418
  797969
  801788
  801986
  802319
  802597
  803311
  803477
  803486
  804695
  806681
  807887
  809625
  810114
  811875
  813122
  814421
  816596
  823272
  824075
  824644
  825086
  827539
]
12.89 ms
(6.75%)
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
  454981
  510102
  450682
  633857
  631538
  490952
  516496
  645006
  516226
  555992
  496793
  757290
  147073
  824075
  723642
  814421
  827539
  823272
  825086
  555457
  574118
  541301
  547402
  541064
  548909
  555411
  684486
  686107
  696291
  647111
  689040
  707238
  662914
  668105
  681344
  708561
  710244
  721037
  553417
  578773
  588550
  634902
  640366
  599464
  600942
  776216
  777422
  777992
  784631
  790415
  794418
  801788
  803311
  804695
  775294
  797969
  725081
  725154
  730103
  742066
  748028
  748034
  767474
  773639
  786101
  786858
  802319
  802597
  806681
  807887
  810114
  739645
  728373
  745684
  756827
  773691
  730154
  747981
  752532
  768348
  736981
  738534
  630143
  697188
  699323
  710503
  714402
  714587
  784974
  792681
  793905
  801986
  803477
  803486
  809625
  811875
  500815
  709850
  604760
  600358
  813122
  491424
  556876
  719074
  824644
  816596
  539454
  538066
  531006
  542474
  544417
  584577
  546420
  550965
  554846
  678997
  681609
  699519
  705478
  708532
]
3.41 ms
(1.78%)
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
  147073
  450682
  454981
  490952
  491424
  496793
  500815
  510102
  516226
  516496
  531006
  538066
  539454
  541064
  541301
  542474
  544417
  546420
  547402
  548909
  550965
  553417
  554846
  555411
  555457
  555992
  556876
  574118
  578773
  584577
  588550
  599464
  600358
  600942
  604760
  630143
  631538
  633857
  634902
  640366
  645006
  647111
  662914
  668105
  678997
  681344
  681609
  684486
  686107
  689040
  696291
  697188
  699323
  699519
  705478
  707238
  708532
  708561
  709850
  710244
  710503
  714402
  714587
  719074
  721037
  723642
  725081
  725154
  728373
  730103
  730154
  736981
  738534
  739645
  742066
  745684
  747981
  748028
  748034
  752532
  756827
  757290
  767474
  768348
  773639
  773691
  775294
  776216
  777422
  777992
  784631
  784974
  786101
  786858
  790415
  792681
  793905
  794418
  797969
  801788
  801986
  802319
  802597
  803311
  803477
  803486
  804695
  806681
  807887
  809625
  810114
  811875
  813122
  814421
  816596
  823272
  824075
  824644
  825086
  827539
]
1.98 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hole cum"
]
1.95 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.71 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дырк cum"
]
1.27 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "дырк cum"
]

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.