Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
182.03 ms
(87.71%)
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
  545507
  546843
  546857
  546887
  549253
  549358
  549787
  550357
  551949
  552495
  554124
  554245
  554466
  555356
  555942
  558508
  559586
  559855
  560149
  560174
  561913
  562049
  562955
  562975
  563170
  564309
  565769
  567130
  567216
  568096
  571741
  572226
  572542
  572543
  572583
  572647
  573248
  574630
  577074
  577697
  578295
  579166
  579776
  580449
  584200
  584507
  584853
  585163
  585240
  585307
  585936
  587274
  587278
  587801
  588097
  588629
  588760
  589664
  589680
  589694
  590604
  590705
  590919
  591052
  591278
  591288
  591313
  591514
  591823
  591859
  592453
  592499
  592588
  593046
  593421
  593506
  596557
  599010
  599734
  600609
  600624
  600645
  602997
  603302
  603781
  604619
  604844
  605904
  606092
  607303
  610025
  610049
  613941
  616461
  616474
  618333
  618469
  619470
  620345
  622170
  622360
  622462
  624845
  625221
  626866
  626891
  630566
  631264
  631604
  632072
  636409
  641308
  643851
  651192
  660943
  676508
  680838
  683787
  684029
  687468
]
15.58 ms
(7.51%)
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
  676508
  680838
  683787
  684029
  651192
  660943
  687468
  545507
  546843
  546857
  546887
  549253
  549358
  549787
  550357
  551949
  552495
  554124
  554245
  554466
  555356
  555942
  558508
  559586
  559855
  560149
  560174
  561913
  562049
  562955
  562975
  563170
  564309
  565769
  567130
  567216
  568096
  571741
  572226
  572542
  572543
  572583
  572647
  573248
  574630
  577074
  577697
  578295
  579166
  579776
  580449
  584200
  584507
  584853
  587274
  588097
  588629
  590705
  592453
  593046
  593506
  599734
  600609
  600645
  602997
  604619
  610025
  610049
  613941
  618469
  622170
  625221
  626866
  626891
  630566
  631264
  632072
  636409
  585936
  587801
  588760
  589680
  590604
  590919
  591052
  591278
  591288
  591514
  591859
  592588
  593421
  596557
  599010
  600624
  603302
  603781
  604844
  605904
  606092
  607303
  616461
  616474
  618333
  619470
  620345
  622360
  622462
  624845
  631604
  641308
  643851
  585163
  585240
  585307
  587278
  589664
  589694
  591313
  591823
  592499
]
3.27 ms
(1.57%)
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
  545507
  546843
  546857
  546887
  549253
  549358
  549787
  550357
  551949
  552495
  554124
  554245
  554466
  555356
  555942
  558508
  559586
  559855
  560149
  560174
  561913
  562049
  562955
  562975
  563170
  564309
  565769
  567130
  567216
  568096
  571741
  572226
  572542
  572543
  572583
  572647
  573248
  574630
  577074
  577697
  578295
  579166
  579776
  580449
  584200
  584507
  584853
  585163
  585240
  585307
  585936
  587274
  587278
  587801
  588097
  588629
  588760
  589664
  589680
  589694
  590604
  590705
  590919
  591052
  591278
  591288
  591313
  591514
  591823
  591859
  592453
  592499
  592588
  593046
  593421
  593506
  596557
  599010
  599734
  600609
  600624
  600645
  602997
  603302
  603781
  604619
  604844
  605904
  606092
  607303
  610025
  610049
  613941
  616461
  616474
  618333
  618469
  619470
  620345
  622170
  622360
  622462
  624845
  625221
  626866
  626891
  630566
  631264
  631604
  632072
  636409
  641308
  643851
  651192
  660943
  676508
  680838
  683787
  684029
  687468
]
1.92 ms
(0.92%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "классическая"
]
1.78 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.56 ms
(0.75%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "классическ"
]
1.39 ms
(0.67%)
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.