Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.08 ms
(89.60%)
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
  415816
  479929
  482183
  492178
  494280
  494931
  497853
  498880
  499088
  507108
  507208
  507447
  512905
  517185
  517597
  518762
  519892
  522119
  522265
  523137
  523637
  526977
  528598
  529442
  530152
  533684
  534488
  535865
  541624
  541898
  542948
  543278
  546335
  546392
  548326
  549948
  550491
  551114
  551723
  552037
  552038
  552040
  553610
  554850
  556983
  556993
  557016
  557254
  557539
  558342
  559685
  560748
  560772
  560859
  561471
  561631
  563047
  563153
  564088
  565736
  566129
  566223
  566613
  567589
  569089
  569529
  569639
  569973
  570315
  571864
  572228
  572274
  575439
  577646
  579576
  580269
  580491
  581038
  581317
  587613
  587835
  591544
  591555
  591568
  592315
  593077
  595298
  600828
  604000
  604336
  604356
  605471
  616493
  618685
  619312
  619797
  622876
  623304
  625134
  625176
  625326
  625463
  625489
  635655
  637802
  648488
  652752
  653248
  658519
  659408
  660845
  663432
  673574
  678857
  678878
  682216
  682417
  684977
  686133
  763182
]
9.29 ms
(5.30%)
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
  522119
  499088
  507108
  522265
  523137
  479929
  569089
  572274
  541898
  570315
  581038
  557539
  682216
  653248
  684977
  551114
  552038
  553610
  566223
  567589
  587835
  625176
  591555
  622876
  625489
  591568
  593077
  625463
  415816
  482183
  498880
  529442
  530152
  512905
  517185
  518762
  523637
  535865
  497853
  507208
  517597
  543278
  548326
  557016
  557254
  566129
  566613
  571864
  581317
  560859
  563047
  569973
  575439
  552040
  560748
  560772
  580269
  652752
  673574
  658519
  659408
  660845
  686133
  648488
  682417
  551723
  552037
  556983
  556993
  561471
  561631
  577646
  580491
  591544
  616493
  635655
  595298
  625134
  604000
  604336
  604356
  619312
  494280
  507447
  526977
  534488
  494931
  492178
  542948
  550491
  558342
  546335
  559685
  564088
  569639
  572228
  579576
  541624
  563153
  663432
  678878
  678857
  546392
  549948
  554850
  565736
  569529
  600828
  625326
  592315
  618685
  619797
  605471
  637802
  587613
  623304
  763182
  528598
  519892
  533684
]
2.59 ms
(1.48%)
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
  415816
  479929
  482183
  492178
  494280
  494931
  497853
  498880
  499088
  507108
  507208
  507447
  512905
  517185
  517597
  518762
  519892
  522119
  522265
  523137
  523637
  526977
  528598
  529442
  530152
  533684
  534488
  535865
  541624
  541898
  542948
  543278
  546335
  546392
  548326
  549948
  550491
  551114
  551723
  552037
  552038
  552040
  553610
  554850
  556983
  556993
  557016
  557254
  557539
  558342
  559685
  560748
  560772
  560859
  561471
  561631
  563047
  563153
  564088
  565736
  566129
  566223
  566613
  567589
  569089
  569529
  569639
  569973
  570315
  571864
  572228
  572274
  575439
  577646
  579576
  580269
  580491
  581038
  581317
  587613
  587835
  591544
  591555
  591568
  592315
  593077
  595298
  600828
  604000
  604336
  604356
  605471
  616493
  618685
  619312
  619797
  622876
  623304
  625134
  625176
  625326
  625463
  625489
  635655
  637802
  648488
  652752
  653248
  658519
  659408
  660845
  663432
  673574
  678857
  678878
  682216
  682417
  684977
  686133
  763182
]
1.80 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс стоят"
]
1.64 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс сто"
]
1.54 ms
(0.88%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.78%)
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.