Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
137.28 ms
(84.32%)
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
  425207
  441820
  445954
  446606
  447273
  448398
  449511
  449863
  450129
  453937
  454785
  455824
  456153
  456349
  456834
  457073
  457805
  458473
  459590
  460055
  461615
  462422
  463404
  464599
  466545
  467667
  471460
  471721
  473225
  475499
  476086
  478113
  478220
  479600
  480327
  480331
  482876
  482919
  484837
  484844
  488725
  488893
  489313
  489756
  489841
  490019
  491331
  493453
  497077
  499514
  500104
  502368
  504065
  505061
  505643
  506245
  507249
  507860
  508072
  508644
  508711
  508827
  509080
  509558
  509941
  510015
  515777
  518152
  522084
  523132
  524568
  529359
  533241
  538773
  539940
  540904
  544048
  546308
  548610
  551731
  555672
  555954
  559465
  574469
  578535
  581264
  586459
  605176
  605180
  605924
  617509
  620940
  621183
  628596
  629337
  643071
  646052
  660569
  662925
  675581
  676430
  676576
  684208
  699518
  707457
  708194
  708254
  709181
  711327
  717187
  728225
  740959
  750691
  759921
  784153
  790615
  796294
  805254
  807392
  820841
]
15.26 ms
(9.37%)
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
  425207
  820841
  450129
  457073
  461615
  471460
  489841
  491331
  449511
  462422
  499514
  508711
  505061
  500104
  507249
  518152
  522084
  539940
  463404
  482876
  551731
  807392
  750691
  784153
  446606
  455824
  456349
  441820
  480327
  445954
  473225
  453937
  454785
  456153
  460055
  464599
  478113
  448398
  457805
  458473
  459590
  466545
  509080
  508644
  509941
  484837
  489313
  489756
  497077
  502368
  504065
  510015
  529359
  484844
  488725
  488893
  506245
  507860
  508827
  509558
  447273
  471721
  480331
  456834
  508072
  467667
  479600
  478220
  524568
  544048
  555954
  717187
  660569
  790615
  728225
  476086
  482919
  493453
  533241
  559465
  581264
  546308
  605176
  805254
  629337
  709181
  490019
  515777
  538773
  475499
  449863
  505643
  523132
  548610
  540904
  555672
  578535
  574469
  646052
  676576
  699518
  708194
  708254
  711327
  675581
  684208
  707457
  662925
  676430
  586459
  620940
  628596
  605924
  643071
  621183
  605180
  617509
  796294
  740959
  759921
]
3.54 ms
(2.17%)
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
  425207
  441820
  445954
  446606
  447273
  448398
  449511
  449863
  450129
  453937
  454785
  455824
  456153
  456349
  456834
  457073
  457805
  458473
  459590
  460055
  461615
  462422
  463404
  464599
  466545
  467667
  471460
  471721
  473225
  475499
  476086
  478113
  478220
  479600
  480327
  480331
  482876
  482919
  484837
  484844
  488725
  488893
  489313
  489756
  489841
  490019
  491331
  493453
  497077
  499514
  500104
  502368
  504065
  505061
  505643
  506245
  507249
  507860
  508072
  508644
  508711
  508827
  509080
  509558
  509941
  510015
  515777
  518152
  522084
  523132
  524568
  529359
  533241
  538773
  539940
  540904
  544048
  546308
  548610
  551731
  555672
  555954
  559465
  574469
  578535
  581264
  586459
  605176
  605180
  605924
  617509
  620940
  621183
  628596
  629337
  643071
  646052
  660569
  662925
  675581
  676430
  676576
  684208
  699518
  707457
  708194
  708254
  709181
  711327
  717187
  728225
  740959
  750691
  759921
  784153
  790615
  796294
  805254
  807392
  820841
]
1.75 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "doggystyle большой большие член"
]
1.69 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "doggystyle большой большие член"
]
1.69 ms
(1.04%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggystyle big dick"
]
1.60 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.