Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.76 ms
(87.43%)
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
  37730
  193890
  386324
  393972
  395542
  411817
  441241
  457155
  494892
  514470
  528875
  530930
  534123
  534795
  539500
  541306
  543242
  543922
  545254
  558996
  564391
  566883
  567570
  579872
  583529
  591895
  603288
  609452
  623452
  625245
  629072
  630637
  654353
  665505
  666861
  667682
  669435
  678192
  678651
  683932
  685680
  688016
  689945
  692100
  694324
  701000
  709834
  710949
  716482
  718119
  718143
  718518
  718867
  719854
  721276
  721388
  722712
  724935
  730736
  734698
  751106
  753203
  757324
  758050
  758066
  758951
  759399
  763558
  763959
  766483
  767333
  771400
  771437
  777889
  778482
  778800
  779105
  779542
  780252
  780849
  782284
  783065
  783084
  784024
  785815
  785931
  787658
  789478
  790861
  791168
  791965
  792994
  793732
  795475
  796044
  796172
  797074
  801327
  801337
  801614
  804037
  804307
  804463
  808433
  808761
  809877
  810148
  810671
  810989
  811028
  812171
  812639
  812840
  813337
  813795
  813888
  816134
  821923
  823422
  824451
]
13.02 ms
(7.40%)
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
  757324
  758050
  763959
  771437
  603288
  701000
  710949
  718119
  721276
  721388
  777889
  790861
  792994
  795475
  801337
  801614
  804037
  809877
  812171
  813337
  411817
  393972
  530930
  804307
  724935
  629072
  719854
  810148
  386324
  514470
  543242
  583529
  692100
  558996
  810989
  778482
  783065
  789478
  766483
  793732
  395542
  816134
  813888
  823422
  824451
  528875
  566883
  545254
  564391
  716482
  665505
  678192
  678651
  683932
  722712
  623452
  609452
  779542
  780252
  780849
  784024
  796044
  808761
  811028
  779105
  791965
  797074
  804463
  810671
  730736
  753203
  767333
  791168
  796172
  801327
  808433
  751106
  763558
  758066
  759399
  718518
  718867
  778800
  785815
  37730
  193890
  441241
  813795
  821923
  457155
  494892
  534795
  534123
  539500
  567570
  543922
  541306
  654353
  669435
  685680
  694324
  709834
  718143
  666861
  667682
  688016
  689945
  579872
  591895
  630637
  625245
  785931
  812639
  782284
  812840
  734698
  758951
  771400
  783084
  787658
]
2.54 ms
(1.45%)
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
  37730
  193890
  386324
  393972
  395542
  411817
  441241
  457155
  494892
  514470
  528875
  530930
  534123
  534795
  539500
  541306
  543242
  543922
  545254
  558996
  564391
  566883
  567570
  579872
  583529
  591895
  603288
  609452
  623452
  625245
  629072
  630637
  654353
  665505
  666861
  667682
  669435
  678192
  678651
  683932
  685680
  688016
  689945
  692100
  694324
  701000
  709834
  710949
  716482
  718119
  718143
  718518
  718867
  719854
  721276
  721388
  722712
  724935
  730736
  734698
  751106
  753203
  757324
  758050
  758066
  758951
  759399
  763558
  763959
  766483
  767333
  771400
  771437
  777889
  778482
  778800
  779105
  779542
  780252
  780849
  782284
  783065
  783084
  784024
  785815
  785931
  787658
  789478
  790861
  791168
  791965
  792994
  793732
  795475
  796044
  796172
  797074
  801327
  801337
  801614
  804037
  804307
  804463
  808433
  808761
  809877
  810148
  810671
  810989
  811028
  812171
  812639
  812840
  813337
  813795
  813888
  816134
  821923
  823422
  824451
]
1.76 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "horny fuck"
]
1.71 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "horny секс"
]
1.69 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.79%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "horny секс"
]

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.