Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.48 ms
(86.40%)
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
  154694
  155198
  382014
  410980
  411260
  411469
  418078
  421257
  425984
  426722
  445064
  450793
  455034
  459883
  469833
  479738
  486643
  493838
  495905
  499921
  508250
  510222
  513794
  514047
  518941
  519374
  522600
  526206
  526261
  526549
  532837
  534665
  535707
  536491
  536527
  548547
  554325
  555007
  560180
  563728
  573197
  573462
  575899
  575924
  578654
  579670
  580532
  582330
  582545
  582833
  586289
  587178
  589710
  592756
  597031
  597857
  597875
  599064
  601772
  602811
  603358
  609959
  610716
  617118
  618565
  625467
  631203
  635219
  637463
  643263
  660147
  662876
  665971
  672740
  681539
  688003
  693185
  694894
  695869
  700990
  709729
  724289
  729538
  735906
  740997
  741878
  744774
  745422
  749543
  752644
  752676
  758248
  759132
  761393
  762671
  769337
  771004
  774333
  775529
  775944
  776273
  776400
  778254
  782059
  785437
  787966
  790696
  790853
  792265
  800422
  801147
  801341
  804192
  807387
  808650
  809600
  810839
  811125
  811477
  814401
]
14.72 ms
(7.64%)
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
  579670
  587178
  814401
  418078
  694894
  575899
  801147
  744774
  774333
  804192
  513794
  519374
  548547
  695869
  601772
  752676
  811125
  735906
  752644
  426722
  411469
  421257
  535707
  560180
  660147
  662876
  672740
  709729
  597875
  610716
  631203
  741878
  609959
  785437
  514047
  700990
  410980
  469833
  637463
  801341
  486643
  589710
  810839
  455034
  499921
  582545
  790696
  411260
  582330
  563728
  582833
  592756
  778254
  761393
  775944
  809600
  643263
  762671
  580532
  155198
  599064
  775529
  792265
  758248
  534665
  518941
  688003
  603358
  536527
  573462
  776273
  759132
  782059
  749543
  740997
  425984
  508250
  555007
  665971
  769337
  771004
  800422
  526206
  522600
  575924
  586289
  635219
  382014
  554325
  625467
  807387
  808650
  745422
  811477
  154694
  493838
  573197
  510222
  479738
  445064
  526261
  526549
  495905
  617118
  532837
  681539
  602811
  450793
  459883
  578654
  693185
  618565
  597031
  776400
  787966
  724289
  790853
  536491
  597857
  729538
]
3.61 ms
(1.88%)
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
  154694
  155198
  382014
  410980
  411260
  411469
  418078
  421257
  425984
  426722
  445064
  450793
  455034
  459883
  469833
  479738
  486643
  493838
  495905
  499921
  508250
  510222
  513794
  514047
  518941
  519374
  522600
  526206
  526261
  526549
  532837
  534665
  535707
  536491
  536527
  548547
  554325
  555007
  560180
  563728
  573197
  573462
  575899
  575924
  578654
  579670
  580532
  582330
  582545
  582833
  586289
  587178
  589710
  592756
  597031
  597857
  597875
  599064
  601772
  602811
  603358
  609959
  610716
  617118
  618565
  625467
  631203
  635219
  637463
  643263
  660147
  662876
  665971
  672740
  681539
  688003
  693185
  694894
  695869
  700990
  709729
  724289
  729538
  735906
  740997
  741878
  744774
  745422
  749543
  752644
  752676
  758248
  759132
  761393
  762671
  769337
  771004
  774333
  775529
  775944
  776273
  776400
  778254
  782059
  785437
  787966
  790696
  790853
  792265
  800422
  801147
  801341
  804192
  807387
  808650
  809600
  810839
  811125
  811477
  814401
]
2.26 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "big huge tits"
]
2.22 ms
(1.15%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большие огромные сиськ"
]
1.51 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.