Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.35 ms
(82.91%)
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
  187759
  187938
  188390
  188456
  382277
  382947
  387125
  397884
  399075
  409938
  411766
  411897
  411907
  413283
  451464
  451488
  454184
  460759
  465949
  466147
  466986
  471053
  474123
  474485
  476343
  479081
  484397
  485763
  516461
  547018
  558013
  571144
  591046
  591877
  593542
  609268
  609274
  624470
  664861
  665095
  665219
  665264
  665395
  667281
  667291
  667661
  668888
  697180
  710510
  710579
  711661
  712215
  712332
  712987
  713635
  714152
  714171
  716557
  718549
  718553
  721467
  722127
  723984
  724232
  724476
  725135
  726572
  726859
  726955
  727050
  727499
  727740
  727924
  728442
  728446
  732356
  736402
  737164
  737897
  740792
  741080
  741653
  741896
  744229
  746890
  748163
  748213
  748226
  748245
  758118
  758431
  758436
  758437
  765632
  770139
  772100
  772113
  774176
  776320
  779197
  781652
  781686
  781688
  781702
  781731
  781745
  781746
  781761
  781930
  782183
  794830
  803522
  808558
  817555
  819032
  820384
  824244
  824320
  824584
  826784
]
14.76 ms
(10.00%)
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
  411897
  484397
  387125
  397884
  399075
  516461
  722127
  714152
  593542
  741080
  382277
  187759
  187938
  479081
  667291
  665095
  668888
  712332
  713635
  718549
  723984
  770139
  808558
  732356
  727050
  781930
  476343
  665264
  451464
  817555
  382947
  188456
  409938
  740792
  741896
  466986
  591046
  728446
  451488
  465949
  571144
  591877
  725135
  758118
  727499
  712215
  460759
  471053
  474485
  466147
  547018
  188390
  820384
  826784
  665219
  710579
  781746
  781702
  727740
  765632
  781652
  781686
  781745
  819032
  411907
  824320
  712987
  779197
  781731
  782183
  746890
  781688
  726572
  726955
  741653
  413283
  411766
  824244
  824584
  454184
  485763
  474123
  665395
  710510
  667281
  697180
  714171
  716557
  718553
  664861
  667661
  711661
  721467
  558013
  609274
  624470
  609268
  776320
  794830
  781761
  803522
  726859
  727924
  748226
  758431
  758436
  758437
  724476
  736402
  748213
  748245
  772100
  737164
  772113
  774176
  728442
  744229
  748163
  724232
  737897
]
3.03 ms
(2.05%)
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
  187759
  187938
  188390
  188456
  382277
  382947
  387125
  397884
  399075
  409938
  411766
  411897
  411907
  413283
  451464
  451488
  454184
  460759
  465949
  466147
  466986
  471053
  474123
  474485
  476343
  479081
  484397
  485763
  516461
  547018
  558013
  571144
  591046
  591877
  593542
  609268
  609274
  624470
  664861
  665095
  665219
  665264
  665395
  667281
  667291
  667661
  668888
  697180
  710510
  710579
  711661
  712215
  712332
  712987
  713635
  714152
  714171
  716557
  718549
  718553
  721467
  722127
  723984
  724232
  724476
  725135
  726572
  726859
  726955
  727050
  727499
  727740
  727924
  728442
  728446
  732356
  736402
  737164
  737897
  740792
  741080
  741653
  741896
  744229
  746890
  748163
  748213
  748226
  748245
  758118
  758431
  758436
  758437
  765632
  770139
  772100
  772113
  774176
  776320
  779197
  781652
  781686
  781688
  781702
  781731
  781745
  781746
  781761
  781930
  782183
  794830
  803522
  808558
  817555
  819032
  820384
  824244
  824320
  824584
  826784
]
1.92 ms
(1.30%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature сиськ"
]
1.92 ms
(1.30%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.91 ms
(1.29%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature tits"
]
1.69 ms
(1.15%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature сиськ"
]

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.