Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
143.83 ms
(83.88%)
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
  78412
  150405
  184359
  381811
  387885
  391893
  392967
  394543
  397700
  397891
  398210
  398700
  403245
  405820
  411574
  420782
  421131
  443838
  454456
  457786
  469764
  470242
  470917
  474012
  474016
  477046
  484721
  495043
  504201
  506820
  517620
  519240
  526597
  530286
  532681
  533050
  533523
  533929
  534004
  534640
  535585
  535602
  535612
  536063
  536544
  536958
  540443
  542770
  542821
  543658
  544252
  544661
  544751
  545096
  545210
  545420
  545584
  547966
  553241
  554811
  555152
  557371
  557977
  557981
  558626
  561046
  563644
  568180
  568188
  575667
  578413
  580413
  582864
  583955
  630578
  645493
  648984
  649276
  650978
  651287
  651317
  651420
  653175
  653712
  653889
  654217
  660084
  667075
  671243
  676788
  677584
  679415
  680587
  682291
  682351
  692457
  693789
  694027
  694265
  694346
  697153
  705398
  707239
  712501
  712892
  714126
  715158
  716564
  719726
  719963
  720208
  721972
  722104
  722967
  723433
  741152
  745311
  755134
  785118
  802483
]
16.60 ms
(9.68%)
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
  755134
  741152
  745311
  630578
  707239
  719963
  723433
  785118
  802483
  405820
  78412
  411574
  397700
  397891
  398210
  519240
  533929
  534004
  474012
  557977
  558626
  578413
  542770
  557981
  470242
  474016
  421131
  454456
  477046
  469764
  470917
  457786
  526597
  484721
  495043
  506820
  504201
  150405
  184359
  394543
  391893
  392967
  381811
  387885
  398700
  403245
  420782
  443838
  517620
  533523
  534640
  535585
  535602
  536063
  540443
  536544
  536958
  530286
  532681
  533050
  535612
  543658
  544661
  544751
  545096
  547966
  557371
  568180
  575667
  580413
  542821
  545420
  545584
  554811
  555152
  563644
  544252
  545210
  553241
  561046
  568188
  582864
  583955
  651287
  651420
  653712
  653889
  660084
  671243
  676788
  680587
  692457
  693789
  694027
  694346
  712501
  715158
  719726
  722104
  722967
  645493
  648984
  649276
  650978
  651317
  653175
  654217
  667075
  677584
  679415
  682291
  682351
  694265
  697153
  705398
  712892
  714126
  716564
  720208
  721972
]
2.78 ms
(1.62%)
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
  78412
  150405
  184359
  381811
  387885
  391893
  392967
  394543
  397700
  397891
  398210
  398700
  403245
  405820
  411574
  420782
  421131
  443838
  454456
  457786
  469764
  470242
  470917
  474012
  474016
  477046
  484721
  495043
  504201
  506820
  517620
  519240
  526597
  530286
  532681
  533050
  533523
  533929
  534004
  534640
  535585
  535602
  535612
  536063
  536544
  536958
  540443
  542770
  542821
  543658
  544252
  544661
  544751
  545096
  545210
  545420
  545584
  547966
  553241
  554811
  555152
  557371
  557977
  557981
  558626
  561046
  563644
  568180
  568188
  575667
  578413
  580413
  582864
  583955
  630578
  645493
  648984
  649276
  650978
  651287
  651317
  651420
  653175
  653712
  653889
  654217
  660084
  667075
  671243
  676788
  677584
  679415
  680587
  682291
  682351
  692457
  693789
  694027
  694265
  694346
  697153
  705398
  707239
  712501
  712892
  714126
  715158
  716564
  719726
  719963
  720208
  721972
  722104
  722967
  723433
  741152
  745311
  755134
  785118
  802483
]
2.39 ms
(1.40%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "свингерское"
]
2.21 ms
(1.29%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.95 ms
(1.13%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "свингер"
]
1.71 ms
(1.00%)
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.