Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
140.59 ms
(80.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
  4282
  197300
  382851
  389618
  392772
  396303
  397075
  397401
  417284
  421618
  426374
  426877
  427250
  427373
  450684
  452731
  454470
  456505
  458313
  458527
  460410
  460417
  461676
  463397
  463501
  465415
  467082
  469693
  476446
  477122
  478362
  483025
  489924
  496123
  499964
  499995
  500553
  506246
  508243
  509864
  516793
  518004
  519595
  522749
  539913
  551576
  554129
  556779
  572720
  574967
  575539
  578207
  578809
  584170
  585375
  586057
  587274
  590604
  591401
  594608
  605675
  626839
  653117
  688902
  691982
  700219
  711554
  711565
  717274
  722149
  724698
  729111
  735581
  745962
  748687
  750458
  758023
  765536
  768615
  768624
  770958
  771931
  772461
  773601
  776678
  778786
  779147
  781128
  782318
  787847
  789461
  789472
  791769
  792399
  795998
  796744
  797313
  798791
  804032
  811528
  818097
  819527
  819804
  823013
  825068
  825191
  825350
  825400
  825633
  825764
  825930
  825985
  825986
  827142
  827280
  827632
  828438
  828442
  828555
  828781
]
23.18 ms
(13.26%)
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
  392772
  818097
  828781
  827632
  828442
  522749
  578809
  653117
  691982
  750458
  773601
  758023
  771931
  778786
  458313
  452731
  539913
  463501
  575539
  578207
  605675
  626839
  590604
  724698
  460410
  499964
  499995
  506246
  518004
  396303
  454470
  519595
  556779
  554129
  717274
  711554
  711565
  586057
  587274
  591401
  776678
  745962
  467082
  478362
  427250
  426877
  516793
  508243
  483025
  496123
  825633
  825191
  825985
  827142
  827280
  825068
  828555
  828438
  688902
  700219
  585375
  781128
  779147
  797313
  772461
  782318
  789461
  789472
  791769
  768624
  729111
  765536
  787847
  798791
  804032
  197300
  397401
  397075
  421618
  426374
  460417
  461676
  489924
  456505
  477122
  500553
  509864
  584170
  551576
  572720
  574967
  722149
  594608
  796744
  748687
  792399
  795998
  735581
  768615
  770958
  811528
  382851
  427373
  465415
  417284
  463397
  469693
  450684
  458527
  476446
  4282
  389618
  825930
  819804
  823013
  825350
  825400
  819527
  825764
  825986
]
3.47 ms
(1.99%)
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
  4282
  197300
  382851
  389618
  392772
  396303
  397075
  397401
  417284
  421618
  426374
  426877
  427250
  427373
  450684
  452731
  454470
  456505
  458313
  458527
  460410
  460417
  461676
  463397
  463501
  465415
  467082
  469693
  476446
  477122
  478362
  483025
  489924
  496123
  499964
  499995
  500553
  506246
  508243
  509864
  516793
  518004
  519595
  522749
  539913
  551576
  554129
  556779
  572720
  574967
  575539
  578207
  578809
  584170
  585375
  586057
  587274
  590604
  591401
  594608
  605675
  626839
  653117
  688902
  691982
  700219
  711554
  711565
  717274
  722149
  724698
  729111
  735581
  745962
  748687
  750458
  758023
  765536
  768615
  768624
  770958
  771931
  772461
  773601
  776678
  778786
  779147
  781128
  782318
  787847
  789461
  789472
  791769
  792399
  795998
  796744
  797313
  798791
  804032
  811528
  818097
  819527
  819804
  823013
  825068
  825191
  825350
  825400
  825633
  825764
  825930
  825985
  825986
  827142
  827280
  827632
  828438
  828442
  828555
  828781
]
2.40 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy cum"
]
1.83 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак cum"
]
1.82 ms
(1.04%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.49 ms
(0.85%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак cum"
]

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.