Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.97 ms
(85.77%)
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
  182110
  387510
  390954
  391493
  397917
  410563
  413335
  419170
  420370
  423299
  432704
  435114
  440897
  441518
  456587
  458966
  465164
  478611
  497509
  509575
  510879
  533363
  547434
  555592
  564559
  566858
  593985
  604306
  604320
  629744
  636308
  651685
  655132
  656483
  656521
  656567
  661987
  670915
  678868
  680434
  680440
  693425
  697203
  707307
  707308
  707310
  707416
  709594
  710018
  715888
  717072
  720705
  725416
  726936
  727736
  727859
  728779
  730407
  734332
  734960
  736780
  740871
  740879
  742728
  746052
  747250
  748362
  749009
  750294
  753552
  755147
  756681
  756986
  758766
  759950
  759960
  760249
  760877
  760973
  761104
  761510
  761597
  763510
  764161
  767086
  767116
  767159
  767269
  768388
  769906
  775228
  776973
  783376
  786174
  787512
  791815
  791846
  793232
  795900
  795916
  796031
  796147
  797012
  797444
  798799
  800638
  802053
  802138
  804335
  804524
  805241
  812014
  816607
  817283
  819334
  820177
  823720
  824049
  826048
  828452
]
14.44 ms
(8.21%)
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
  749009
  755147
  707307
  707310
  715888
  720705
  798799
  423299
  759950
  826048
  419170
  420370
  497509
  656521
  680434
  775228
  740871
  727736
  760973
  767116
  742728
  804524
  456587
  747250
  776973
  680440
  441518
  824049
  760877
  769906
  728779
  432704
  748362
  783376
  820177
  693425
  787512
  736780
  761104
  795916
  391493
  440897
  678868
  182110
  823720
  707416
  795900
  797012
  797444
  726936
  564559
  812014
  756986
  760249
  761597
  413335
  566858
  651685
  709594
  697203
  655132
  670915
  717072
  547434
  604320
  805241
  796031
  804335
  793232
  800638
  727859
  763510
  768388
  730407
  734960
  767086
  767159
  767269
  707308
  710018
  390954
  478611
  465164
  593985
  656567
  636308
  758766
  555592
  410563
  533363
  656483
  796147
  761510
  756681
  759960
  791846
  387510
  510879
  661987
  828452
  816607
  819334
  750294
  791815
  458966
  817283
  746052
  753552
  397917
  509575
  629744
  604306
  802138
  734332
  740879
  786174
  802053
  725416
  764161
  435114
]
3.22 ms
(1.83%)
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
  182110
  387510
  390954
  391493
  397917
  410563
  413335
  419170
  420370
  423299
  432704
  435114
  440897
  441518
  456587
  458966
  465164
  478611
  497509
  509575
  510879
  533363
  547434
  555592
  564559
  566858
  593985
  604306
  604320
  629744
  636308
  651685
  655132
  656483
  656521
  656567
  661987
  670915
  678868
  680434
  680440
  693425
  697203
  707307
  707308
  707310
  707416
  709594
  710018
  715888
  717072
  720705
  725416
  726936
  727736
  727859
  728779
  730407
  734332
  734960
  736780
  740871
  740879
  742728
  746052
  747250
  748362
  749009
  750294
  753552
  755147
  756681
  756986
  758766
  759950
  759960
  760249
  760877
  760973
  761104
  761510
  761597
  763510
  764161
  767086
  767116
  767159
  767269
  768388
  769906
  775228
  776973
  783376
  786174
  787512
  791815
  791846
  793232
  795900
  795916
  796031
  796147
  797012
  797444
  798799
  800638
  802053
  802138
  804335
  804524
  805241
  812014
  816607
  817283
  819334
  820177
  823720
  824049
  826048
  828452
]
2.21 ms
(1.25%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf anal creampie"
]
1.90 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf анал creampie"
]
1.54 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf анал creampie"
]

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.