Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
117.62 ms
(81.62%)
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
  541624
  545121
  545476
  546392
  546849
  549191
  549352
  549948
  551114
  551723
  552037
  552038
  552040
  552245
  552844
  553610
  554123
  554850
  556983
  556993
  557344
  557539
  559685
  559744
  560748
  560772
  560859
  561471
  561631
  561950
  563047
  563153
  564088
  565736
  565760
  566223
  567019
  567589
  569438
  569529
  569639
  569973
  570315
  570367
  571725
  572228
  575125
  575183
  575439
  577646
  577949
  578048
  579576
  580269
  580491
  581038
  582040
  583877
  584214
  587446
  587613
  587835
  588467
  588916
  589766
  591544
  591555
  591568
  592315
  593077
  593690
  593816
  595298
  596315
  596416
  596681
  598905
  600027
  600828
  602892
  605471
  605825
  611918
  616493
  618685
  619797
  622876
  624292
  625134
  625176
  625326
  625489
  625759
  626356
  628497
  635655
  637802
  642191
  648488
  651876
  652004
  652752
  653248
  654126
  658519
  659408
  660845
  662865
  663432
  669717
  673574
  677363
  678857
  678878
  682216
  682417
  684977
  685533
  686133
  687466
]
17.03 ms
(11.82%)
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
  549352
  554123
  559685
  559744
  560859
  561950
  563047
  564088
  569639
  569973
  570315
  572228
  575125
  575183
  575439
  577949
  579576
  581038
  584214
  541624
  552040
  552844
  557539
  560748
  560772
  563153
  565760
  580269
  582040
  652752
  662865
  663432
  673574
  677363
  678878
  651876
  658519
  659408
  660845
  669717
  678857
  682216
  686133
  687466
  648488
  652004
  653248
  654126
  682417
  684977
  685533
  545121
  545476
  546392
  546849
  549191
  549948
  551114
  551723
  552037
  552038
  552245
  553610
  554850
  556983
  556993
  557344
  561471
  561631
  565736
  566223
  567019
  567589
  569438
  569529
  570367
  571725
  577646
  578048
  580491
  583877
  587835
  600828
  605825
  624292
  625176
  625326
  625759
  642191
  587446
  591544
  591555
  592315
  596681
  600027
  602892
  616493
  618685
  619797
  622876
  625489
  626356
  635655
  588916
  589766
  591568
  593077
  593816
  595298
  596315
  605471
  611918
  625134
  628497
  637802
  587613
  588467
  593690
  596416
  598905
]
3.04 ms
(2.11%)
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
  541624
  545121
  545476
  546392
  546849
  549191
  549352
  549948
  551114
  551723
  552037
  552038
  552040
  552245
  552844
  553610
  554123
  554850
  556983
  556993
  557344
  557539
  559685
  559744
  560748
  560772
  560859
  561471
  561631
  561950
  563047
  563153
  564088
  565736
  565760
  566223
  567019
  567589
  569438
  569529
  569639
  569973
  570315
  570367
  571725
  572228
  575125
  575183
  575439
  577646
  577949
  578048
  579576
  580269
  580491
  581038
  582040
  583877
  584214
  587446
  587613
  587835
  588467
  588916
  589766
  591544
  591555
  591568
  592315
  593077
  593690
  593816
  595298
  596315
  596416
  596681
  598905
  600027
  600828
  602892
  605471
  605825
  611918
  616493
  618685
  619797
  622876
  624292
  625134
  625176
  625326
  625489
  625759
  626356
  628497
  635655
  637802
  642191
  648488
  651876
  652004
  652752
  653248
  654126
  658519
  659408
  660845
  662865
  663432
  669717
  673574
  677363
  678857
  678878
  682216
  682417
  684977
  685533
  686133
  687466
]
2.07 ms
(1.43%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "стоя перед"
]
1.52 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "сто"
]
1.51 ms
(1.05%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.31 ms
(0.91%)
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.