Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
192.34 ms
(89.34%)
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
  12680
  78479
  218742
  233333
  330715
  383780
  385172
  390150
  392439
  404490
  405812
  407492
  408783
  415354
  425592
  426486
  429488
  434012
  443710
  449662
  453462
  461464
  481750
  481963
  492274
  509412
  509837
  515907
  565157
  570813
  590260
  594215
  604104
  614030
  621385
  622028
  624264
  637705
  638574
  638980
  644315
  663497
  664514
  664857
  666830
  669171
  673122
  681187
  684018
  690516
  691578
  693457
  696769
  702793
  707886
  715589
  716140
  716571
  717058
  717921
  718961
  719802
  721173
  726757
  728254
  731898
  738436
  740258
  745325
  748757
  749522
  750903
  754487
  756452
  756454
  756697
  758293
  760042
  763314
  763749
  764271
  764638
  765552
  768001
  768887
  769904
  770155
  771596
  772104
  774243
  775355
  775860
  776304
  778931
  779595
  781578
  781814
  782505
  786216
  786468
  789540
  789685
  790553
  794954
  795529
  796243
  798373
  804620
  805038
  808015
  809798
  810818
  813807
  814851
  818117
  818251
  818545
  820727
  821079
  822286
]
14.09 ms
(6.54%)
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
  749522
  756452
  763749
  740258
  756454
  750903
  754487
  768001
  770155
  758293
  763314
  768887
  624264
  716571
  798373
  434012
  78479
  233333
  415354
  425592
  461464
  390150
  449662
  383780
  12680
  407492
  814851
  822286
  515907
  673122
  691578
  666830
  717921
  565157
  638574
  590260
  622028
  638980
  775355
  795529
  775860
  748757
  804620
  728254
  764638
  765552
  760042
  771596
  717058
  719802
  778931
  405812
  443710
  429488
  481750
  385172
  218742
  392439
  330715
  404490
  408783
  426486
  813807
  818251
  818117
  818545
  820727
  821079
  492274
  453462
  509837
  509412
  481963
  570813
  664514
  669171
  690516
  696769
  707886
  715589
  721173
  681187
  684018
  702793
  718961
  663497
  664857
  693457
  716140
  594215
  644315
  614030
  621385
  782505
  786216
  786468
  789685
  790553
  810818
  776304
  781814
  805038
  808015
  809798
  781578
  789540
  794954
  796243
  726757
  738436
  756697
  769904
  772104
  774243
  731898
  745325
  764271
  604104
  637705
  779595
]
2.65 ms
(1.23%)
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
  12680
  78479
  218742
  233333
  330715
  383780
  385172
  390150
  392439
  404490
  405812
  407492
  408783
  415354
  425592
  426486
  429488
  434012
  443710
  449662
  453462
  461464
  481750
  481963
  492274
  509412
  509837
  515907
  565157
  570813
  590260
  594215
  604104
  614030
  621385
  622028
  624264
  637705
  638574
  638980
  644315
  663497
  664514
  664857
  666830
  669171
  673122
  681187
  684018
  690516
  691578
  693457
  696769
  702793
  707886
  715589
  716140
  716571
  717058
  717921
  718961
  719802
  721173
  726757
  728254
  731898
  738436
  740258
  745325
  748757
  749522
  750903
  754487
  756452
  756454
  756697
  758293
  760042
  763314
  763749
  764271
  764638
  765552
  768001
  768887
  769904
  770155
  771596
  772104
  774243
  775355
  775860
  776304
  778931
  779595
  781578
  781814
  782505
  786216
  786468
  789540
  789685
  790553
  794954
  795529
  796243
  798373
  804620
  805038
  808015
  809798
  810818
  813807
  814851
  818117
  818251
  818545
  820727
  821079
  822286
]
1.78 ms
(0.83%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.63 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "busty секс"
]
1.62 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "busty fuck"
]
1.17 ms
(0.55%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "busty секс"
]

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.