Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
191.95 ms
(88.88%)
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
  385282
  398002
  456166
  466349
  488631
  498947
  546610
  557311
  571085
  571966
  575288
  583334
  603828
  606911
  611342
  615001
  616585
  621548
  628172
  635788
  646338
  647806
  647915
  650037
  654251
  656875
  663280
  671654
  673934
  678643
  683042
  684965
  685390
  685417
  685422
  686429
  688279
  693022
  696990
  705538
  705724
  706816
  710316
  718527
  719776
  720304
  726173
  726726
  726943
  727352
  730049
  732270
  735089
  735532
  735570
  737449
  737822
  738455
  741074
  744893
  745742
  746230
  746468
  746610
  749204
  749448
  752956
  753445
  754868
  756172
  760934
  762748
  764325
  765913
  766049
  766487
  771418
  772034
  772778
  779228
  781693
  783699
  786535
  787458
  787800
  789137
  789421
  789604
  789829
  789948
  789949
  790012
  794143
  795743
  796212
  796264
  800090
  800171
  800493
  801549
  802822
  806805
  808860
  811462
  812028
  812944
  814034
  814534
  815671
  816639
  817099
  817968
  818902
  819919
  820205
  821772
  823536
  823539
  824305
  825708
]
13.97 ms
(6.47%)
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
  816639
  823539
  814534
  684965
  789604
  787458
  726943
  746610
  764325
  746230
  765913
  817099
  817968
  488631
  557311
  685417
  654251
  673934
  628172
  786535
  727352
  783699
  756172
  678643
  818902
  603828
  802822
  686429
  705538
  706816
  646338
  693022
  606911
  749448
  771418
  800090
  800493
  766049
  735570
  762748
  819919
  820205
  821772
  825708
  685390
  685422
  571085
  789421
  796264
  800171
  801549
  752956
  732270
  754868
  766487
  735532
  745742
  760934
  696990
  796212
  466349
  735089
  688279
  823536
  575288
  806805
  705724
  787800
  385282
  815671
  456166
  647806
  650037
  789137
  808860
  730049
  753445
  772778
  811462
  789829
  647915
  671654
  683042
  656875
  738455
  749204
  583334
  546610
  663280
  718527
  720304
  571966
  611342
  795743
  772034
  814034
  824305
  498947
  710316
  616585
  615001
  621548
  794143
  812028
  781693
  812944
  726726
  737822
  741074
  744893
  746468
  726173
  737449
  789948
  789949
  635788
  790012
  398002
  719776
  779228
]
2.67 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
  385282
  398002
  456166
  466349
  488631
  498947
  546610
  557311
  571085
  571966
  575288
  583334
  603828
  606911
  611342
  615001
  616585
  621548
  628172
  635788
  646338
  647806
  647915
  650037
  654251
  656875
  663280
  671654
  673934
  678643
  683042
  684965
  685390
  685417
  685422
  686429
  688279
  693022
  696990
  705538
  705724
  706816
  710316
  718527
  719776
  720304
  726173
  726726
  726943
  727352
  730049
  732270
  735089
  735532
  735570
  737449
  737822
  738455
  741074
  744893
  745742
  746230
  746468
  746610
  749204
  749448
  752956
  753445
  754868
  756172
  760934
  762748
  764325
  765913
  766049
  766487
  771418
  772034
  772778
  779228
  781693
  783699
  786535
  787458
  787800
  789137
  789421
  789604
  789829
  789948
  789949
  790012
  794143
  795743
  796212
  796264
  800090
  800171
  800493
  801549
  802822
  806805
  808860
  811462
  812028
  812944
  814034
  814534
  815671
  816639
  817099
  817968
  818902
  819919
  820205
  821772
  823536
  823539
  824305
  825708
]
2.02 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "night fuck"
]
1.85 ms
(0.86%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "night секс"
]
1.82 ms
(0.84%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.70 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "night секс"
]

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.