Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
158.03 ms
(85.45%)
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
  197345
  375092
  383281
  384298
  389014
  393442
  393524
  394768
  394931
  398354
  399223
  399332
  403555
  409317
  410402
  412539
  414601
  415093
  418869
  420382
  421513
  424534
  425430
  427179
  429319
  429609
  431566
  432524
  433441
  439431
  440087
  440646
  441601
  441864
  442372
  442802
  443038
  444386
  444848
  444974
  446138
  446210
  447641
  448274
  451671
  452425
  453991
  453993
  454121
  454569
  456060
  456085
  456209
  457296
  457600
  457808
  457962
  457967
  458057
  458082
  458609
  458927
  459379
  460070
  460598
  461667
  463536
  464502
  464710
  466892
  469093
  469703
  469862
  470995
  472566
  472577
  473649
  474567
  474711
  474763
  474836
  474871
  475797
  478261
  482001
  482594
  483010
  483994
  484231
  485646
  486137
  486310
  486949
  488561
  489327
  490692
  491597
  496750
  497044
  497466
  498051
  499476
  499497
  499932
  502010
  503758
  505353
  506460
  510045
  513658
  517468
  520060
  521402
  521413
  522502
  526972
  528683
  534493
  538034
  814841
]
16.50 ms
(8.92%)
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
  414601
  415093
  452425
  460598
  482001
  499932
  526972
  488561
  499497
  513658
  521402
  486310
  489327
  497044
  497466
  522502
  383281
  384298
  197345
  393442
  393524
  394768
  394931
  375092
  389014
  398354
  399332
  399223
  403555
  410402
  425430
  427179
  440646
  442802
  421513
  431566
  432524
  433441
  439431
  440087
  442372
  444974
  441864
  443038
  409317
  444848
  412539
  418869
  420382
  424534
  429319
  429609
  441601
  444386
  814841
  482594
  446138
  451671
  453991
  456060
  456085
  457296
  457600
  464502
  470995
  472566
  472577
  474836
  474871
  475797
  483010
  483994
  484231
  486949
  491597
  446210
  447641
  453993
  454121
  454569
  457808
  457967
  458057
  458609
  458927
  460070
  464710
  469862
  473649
  474567
  474763
  478261
  485646
  448274
  456209
  457962
  458082
  459379
  466892
  469093
  490692
  510045
  521413
  498051
  506460
  528683
  534493
  538034
  503758
  505353
  517468
  520060
  496750
  499476
  502010
  461667
  463536
  469703
  474711
  486137
]
2.43 ms
(1.31%)
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
  197345
  375092
  383281
  384298
  389014
  393442
  393524
  394768
  394931
  398354
  399223
  399332
  403555
  409317
  410402
  412539
  414601
  415093
  418869
  420382
  421513
  424534
  425430
  427179
  429319
  429609
  431566
  432524
  433441
  439431
  440087
  440646
  441601
  441864
  442372
  442802
  443038
  444386
  444848
  444974
  446138
  446210
  447641
  448274
  451671
  452425
  453991
  453993
  454121
  454569
  456060
  456085
  456209
  457296
  457600
  457808
  457962
  457967
  458057
  458082
  458609
  458927
  459379
  460070
  460598
  461667
  463536
  464502
  464710
  466892
  469093
  469703
  469862
  470995
  472566
  472577
  473649
  474567
  474711
  474763
  474836
  474871
  475797
  478261
  482001
  482594
  483010
  483994
  484231
  485646
  486137
  486310
  486949
  488561
  489327
  490692
  491597
  496750
  497044
  497466
  498051
  499476
  499497
  499932
  502010
  503758
  505353
  506460
  510045
  513658
  517468
  520060
  521402
  521413
  522502
  526972
  528683
  534493
  538034
  814841
]
2.28 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "прос"
]
2.04 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "она просит ещё"
]
1.91 ms
(1.03%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.76 ms
(0.95%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.