Query Metrics

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

Queries

Group similar statements

# Time Info
1 9.73 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 11.87 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock into cock"
]
3 40.72 ms
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
  725333
  729169
  729971
  732563
  733986
  741042
  741131
  742973
  746311
  746581
  749550
  750339
  753121
  753428
  754195
  754539
  755102
  760529
  761394
  767694
  783803
  794842
  801347
  805303
  808689
  810211
  811886
  725260
  730625
  735311
  736161
  736297
  737859
  739616
  743967
  744451
  748633
  748912
  750002
  753382
  756229
  756761
  762010
  764695
  768550
  769226
  724459
  724603
  724829
  726308
  727495
  728160
  728505
  729992
  733361
  735795
  735798
  738875
  740518
  743837
  747075
  748350
  754229
  756328
  757610
  761954
  726015
  726350
  732048
  732247
  733648
  734457
  734495
  734497
  738221
  738283
  739326
  739585
  739707
  741802
  741812
  742953
  747196
  748743
  762348
  764676
  771622
  772289
  727009
  729122
  738085
  738976
  744680
  748586
  749654
  749749
  753238
  758057
  764386
  770161
  772889
  773751
  606513
  607005
  629850
  632514
  696703
  698811
  700329
  703342
  710552
  716991
  717721
  717801
  720259
  720283
  721277
  721759
  721808
  722184
]
4 10.35 ms
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
  606513
  607005
  629850
  632514
  696703
  698811
  700329
  703342
  710552
  716991
  717721
  717801
  720259
  720283
  721277
  721759
  721808
  722184
  724459
  724603
  724829
  725260
  725333
  726015
  726308
  726350
  727009
  727495
  728160
  728505
  729122
  729169
  729971
  729992
  730625
  732048
  732247
  732563
  733361
  733648
  733986
  734457
  734495
  734497
  735311
  735795
  735798
  736161
  736297
  737859
  738085
  738221
  738283
  738875
  738976
  739326
  739585
  739616
  739707
  740518
  741042
  741131
  741802
  741812
  742953
  742973
  743837
  743967
  744451
  744680
  746311
  746581
  747075
  747196
  748350
  748586
  748633
  748743
  748912
  749550
  749654
  749749
  750002
  750339
  753121
  753238
  753382
  753428
  754195
  754229
  754539
  755102
  756229
  756328
  756761
  757610
  758057
  760529
  761394
  761954
  762010
  762348
  764386
  764676
  764695
  767694
  768550
  769226
  770161
  771622
  772289
  772889
  773751
  783803
  794842
  801347
  805303
  808689
  810211
  811886
]
5 155.32 ms
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
  606513
  607005
  629850
  632514
  696703
  698811
  700329
  703342
  710552
  716991
  717721
  717801
  720259
  720283
  721277
  721759
  721808
  722184
  724459
  724603
  724829
  725260
  725333
  726015
  726308
  726350
  727009
  727495
  728160
  728505
  729122
  729169
  729971
  729992
  730625
  732048
  732247
  732563
  733361
  733648
  733986
  734457
  734495
  734497
  735311
  735795
  735798
  736161
  736297
  737859
  738085
  738221
  738283
  738875
  738976
  739326
  739585
  739616
  739707
  740518
  741042
  741131
  741802
  741812
  742953
  742973
  743837
  743967
  744451
  744680
  746311
  746581
  747075
  747196
  748350
  748586
  748633
  748743
  748912
  749550
  749654
  749749
  750002
  750339
  753121
  753238
  753382
  753428
  754195
  754229
  754539
  755102
  756229
  756328
  756761
  757610
  758057
  760529
  761394
  761954
  762010
  762348
  764386
  764676
  764695
  767694
  768550
  769226
  770161
  771622
  772289
  772889
  773751
  783803
  794842
  801347
  805303
  808689
  810211
  811886
]
6 7.69 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock cock"
]
7 8.96 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock cock"
]

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.