Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
334.12 ms
(93.40%)
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
  402754
  526175
  540020
  554991
  557877
  562539
  581585
  582315
  583630
  597769
  609989
  612923
  616550
  617285
  617303
  618700
  621823
  623712
  623893
  627038
  627123
  630651
  634941
  635365
  640315
  662920
  677289
  685757
  694962
  697219
  700590
  700639
  703395
  706415
  706704
  708728
  709405
  710583
  711625
  713116
  716218
  716956
  720750
  721884
  723742
  723788
  724322
  726173
  726305
  726709
  727548
  727889
  730229
  730666
  732995
  733982
  734183
  737209
  738020
  738110
  738443
  738712
  738780
  738985
  739724
  740794
  742949
  743003
  744385
  749330
  749863
  750781
  751669
  752208
  752235
  752372
  752377
  752388
  752439
  756373
  758581
  758681
  766808
  770354
  772314
  775061
  775348
  775714
  776930
  778334
  779800
  779853
  781619
  784939
  786872
  787050
  787549
  787918
  788976
  795748
  795896
  797364
  799114
  799448
  801037
  806357
  812644
  812845
  814582
  814955
  817938
  818952
  819655
  823150
  823412
  824227
  824838
  825160
  827168
]
13.00 ms
(3.63%)
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
  700590
  703395
  711625
  710583
  713116
  677289
  685757
  700639
  706704
  708728
  582315
  609989
  630651
  623712
  623893
  617285
  617303
  618700
  784939
  752377
  812845
  752208
  738020
  627038
  635365
  697219
  540020
  562539
  662920
  706415
  716218
  721884
  583630
  621823
  640315
  634941
  597769
  612923
  732995
  726173
  627123
  823412
  402754
  824838
  825160
  819655
  823150
  824227
  827168
  814582
  817938
  814955
  818952
  526175
  581585
  554991
  557877
  709405
  716956
  720750
  694962
  616550
  775061
  775348
  775714
  776930
  781619
  787050
  787549
  788976
  799114
  801037
  812644
  778334
  779800
  779853
  795748
  799448
  723788
  726305
  726709
  730229
  730666
  733982
  734183
  737209
  740794
  743003
  749330
  749863
  752235
  752388
  756373
  758681
  771975
  772314
  786872
  787918
  795896
  797364
  806357
  738110
  738712
  738780
  739724
  742949
  750781
  751669
  770354
  723742
  724322
  727548
  727889
  738443
  738985
  744385
  752372
  752439
  758581
  766808
]
3.06 ms
(0.86%)
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
  402754
  526175
  540020
  554991
  557877
  562539
  581585
  582315
  583630
  597769
  609989
  612923
  616550
  617285
  617303
  618700
  621823
  623712
  623893
  627038
  627123
  630651
  634941
  635365
  640315
  662920
  677289
  685757
  694962
  697219
  700590
  700639
  703395
  706415
  706704
  708728
  709405
  710583
  711625
  713116
  716218
  716956
  720750
  721884
  723742
  723788
  724322
  726173
  726305
  726709
  727548
  727889
  730229
  730666
  732995
  733982
  734183
  737209
  738020
  738110
  738443
  738712
  738780
  738985
  739724
  740794
  742949
  743003
  744385
  749330
  749863
  750781
  751669
  752208
  752235
  752372
  752377
  752388
  752439
  756373
  758581
  758681
  766808
  770354
  772314
  775061
  775348
  775714
  776930
  778334
  779800
  779853
  781619
  784939
  786872
  787050
  787549
  787918
  788976
  795748
  795896
  797364
  799114
  799448
  801037
  806357
  812644
  812845
  814582
  814955
  817938
  818952
  819655
  823150
  823412
  824227
  824838
  825160
  827168
]
2.01 ms
(0.56%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur latina"
]
1.87 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.85 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск латинская"
]
1.81 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.