Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.58 ms
(87.41%)
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
  34170
  261891
  390278
  391906
  393688
  394521
  397760
  416299
  419609
  420130
  436047
  442064
  448499
  448894
  453383
  454434
  454945
  455940
  457605
  457639
  458318
  458766
  458990
  462840
  462845
  466567
  468157
  471148
  471455
  484754
  486816
  486877
  509248
  512514
  525666
  526140
  527919
  535363
  538776
  539679
  541573
  542186
  546438
  583167
  588481
  588495
  590255
  594409
  595434
  606919
  609161
  609976
  616625
  624921
  629828
  647941
  648696
  652983
  661410
  664575
  675965
  677743
  697876
  699145
  715358
  724439
  726102
  732572
  734268
  735391
  738212
  749883
  753964
  755256
  766105
  768613
  769359
  769610
  772379
  774264
  774299
  775530
  775610
  781298
  783116
  791932
  792310
  792781
  793017
  793844
  794268
  794584
  797055
  797120
  797642
  798961
  801008
  801065
  801495
  801984
  802179
  802265
  802272
  802307
  803325
  805319
  807015
  808673
  819683
  820006
  821775
  823758
  824116
  824887
  825319
  826226
  826304
  826643
  827179
  827395
]
14.41 ms
(6.90%)
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
  652983
  397760
  823758
  826643
  821775
  486816
  805319
  808673
  801008
  792781
  794584
  797120
  798961
  802272
  664575
  699145
  583167
  606919
  588495
  661410
  793844
  453383
  471148
  509248
  462845
  436047
  462840
  471455
  442064
  512514
  648696
  261891
  420130
  525666
  647941
  675965
  616625
  797642
  801065
  458990
  448894
  594409
  595434
  486877
  819683
  827179
  827395
  820006
  454945
  448499
  466567
  535363
  538776
  542186
  677743
  609976
  775610
  802179
  802265
  802307
  749883
  769359
  783116
  726102
  734268
  735391
  774264
  766105
  732572
  768613
  772379
  755256
  715358
  391906
  458318
  468157
  457605
  738212
  792310
  753964
  455940
  458766
  527919
  484754
  824887
  457639
  624921
  609161
  590255
  419609
  394521
  393688
  390278
  416299
  824116
  825319
  826304
  826226
  539679
  541573
  546438
  697876
  588481
  629828
  791932
  801984
  807015
  781298
  801495
  793017
  797055
  803325
  769610
  724439
  774299
  775530
  794268
  34170
  454434
  526140
]
4.54 ms
(2.17%)
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
  34170
  261891
  390278
  391906
  393688
  394521
  397760
  416299
  419609
  420130
  436047
  442064
  448499
  448894
  453383
  454434
  454945
  455940
  457605
  457639
  458318
  458766
  458990
  462840
  462845
  466567
  468157
  471148
  471455
  484754
  486816
  486877
  509248
  512514
  525666
  526140
  527919
  535363
  538776
  539679
  541573
  542186
  546438
  583167
  588481
  588495
  590255
  594409
  595434
  606919
  609161
  609976
  616625
  624921
  629828
  647941
  648696
  652983
  661410
  664575
  675965
  677743
  697876
  699145
  715358
  724439
  726102
  732572
  734268
  735391
  738212
  749883
  753964
  755256
  766105
  768613
  769359
  769610
  772379
  774264
  774299
  775530
  775610
  781298
  783116
  791932
  792310
  792781
  793017
  793844
  794268
  794584
  797055
  797120
  797642
  798961
  801008
  801065
  801495
  801984
  802179
  802265
  802272
  802307
  803325
  805319
  807015
  808673
  819683
  820006
  821775
  823758
  824116
  824887
  825319
  826226
  826304
  826643
  827179
  827395
]
2.22 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "huge boobs amateur"
]
1.97 ms
(0.95%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "огромные boobs любительск"
]
1.45 ms
(0.69%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "огромные boobs любительск"
]

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.