Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
123.28 ms
(83.47%)
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
  193666
  271496
  387121
  390954
  400850
  411401
  421147
  421819
  425131
  427335
  428059
  428089
  429049
  429542
  430219
  433609
  434608
  438031
  441910
  442426
  443227
  443328
  443415
  444773
  445324
  450213
  454040
  454498
  454518
  455677
  457253
  457868
  458841
  462291
  465793
  466129
  466258
  470427
  470931
  471437
  472020
  477224
  477357
  480381
  482450
  487020
  487260
  489062
  490899
  493145
  495442
  496279
  496504
  500844
  501459
  504682
  505258
  506209
  507499
  508586
  508784
  511023
  512913
  516241
  518978
  519491
  521008
  529504
  541688
  543988
  552338
  556634
  568171
  569278
  573755
  588942
  593037
  604644
  607275
  611307
  617423
  629849
  637543
  670005
  670935
  682107
  695373
  702306
  705549
  719746
  720003
  723021
  724289
  728502
  731670
  732670
  732708
  737037
  742254
  742685
  744172
  758319
  773454
  778127
  778143
  778292
  778369
  788469
  788674
  791112
  791710
  796110
  796549
  801463
  801868
  802313
  803595
  805714
  807404
  808447
]
13.74 ms
(9.30%)
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
  487020
  487260
  443415
  429542
  472020
  670005
  801463
  758319
  805714
  737037
  731670
  702306
  723021
  778143
  791710
  637543
  791112
  742254
  732670
  796549
  569278
  604644
  433609
  511023
  455677
  496279
  796110
  428089
  500844
  493145
  400850
  518978
  271496
  482450
  470427
  521008
  552338
  808447
  430219
  427335
  504682
  508586
  529504
  506209
  507499
  519491
  705549
  720003
  573755
  411401
  470931
  607275
  454518
  477224
  489062
  387121
  434608
  543988
  556634
  695373
  568171
  788674
  778292
  744172
  732708
  778127
  450213
  801868
  778369
  773454
  728502
  719746
  442426
  443227
  444773
  454040
  803595
  466258
  495442
  490899
  193666
  465793
  445324
  477357
  516241
  390954
  541688
  458841
  588942
  802313
  724289
  421819
  443328
  505258
  425131
  682107
  629849
  421147
  617423
  441910
  611307
  466129
  457868
  457253
  788469
  428059
  454498
  480381
  670935
  593037
  807404
  742685
  438031
  501459
  508784
  496504
  512913
  462291
  429049
  471437
]
2.44 ms
(1.65%)
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
  193666
  271496
  387121
  390954
  400850
  411401
  421147
  421819
  425131
  427335
  428059
  428089
  429049
  429542
  430219
  433609
  434608
  438031
  441910
  442426
  443227
  443328
  443415
  444773
  445324
  450213
  454040
  454498
  454518
  455677
  457253
  457868
  458841
  462291
  465793
  466129
  466258
  470427
  470931
  471437
  472020
  477224
  477357
  480381
  482450
  487020
  487260
  489062
  490899
  493145
  495442
  496279
  496504
  500844
  501459
  504682
  505258
  506209
  507499
  508586
  508784
  511023
  512913
  516241
  518978
  519491
  521008
  529504
  541688
  543988
  552338
  556634
  568171
  569278
  573755
  588942
  593037
  604644
  607275
  611307
  617423
  629849
  637543
  670005
  670935
  682107
  695373
  702306
  705549
  719746
  720003
  723021
  724289
  728502
  731670
  732670
  732708
  737037
  742254
  742685
  744172
  758319
  773454
  778127
  778143
  778292
  778369
  788469
  788674
  791112
  791710
  796110
  796549
  801463
  801868
  802313
  803595
  805714
  807404
  808447
]
2.31 ms
(1.57%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс мам женщин друг"
]
2.08 ms
(1.41%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "секс мам женщин друг"
]
2.05 ms
(1.39%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.80 ms
(1.22%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
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.