Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.43 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 1.70 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  b"ð╝ðÂð╝ ð¢ð░ÐéÐâÐÇð░ð╗Ðîð¢ð░ÐÅ ð│ÐÇÐâð┤Ð%ÔǪ"
]
3 16.42 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
  665448
  667196
  707546
  717603
  665875
  667532
  607376
  586684
  795807
  780655
  773963
  743803
  766607
  703472
  476426
  650425
  542770
  607023
  520135
  590978
  741538
  644259
  574269
  511291
  649614
  720293
  665849
  681288
  620164
  794832
  545708
  815051
  731356
  758180
  698102
  632383
  432337
  470512
  395639
  525657
  453622
  484660
  661567
  794265
  742683
  812992
  470926
  585995
  603041
  457789
  525511
  815214
  736226
  732323
  43271
  418567
  618513
  495738
  722796
  650836
  383744
  412183
  484944
  677958
  699583
  663466
  692455
  720112
  632157
  621972
  790962
  720121
  788527
  443130
  453080
  520758
  592884
  408970
  517042
  196316
  814353
  453073
  666828
  692293
  699718
  546802
  566690
  592453
  734514
  743782
  768879
  463176
  426367
  167756
  817463
  453842
  683963
  645964
  684053
  606489
  795584
  404409
  338075
  817440
  651290
  653618
  661279
  681020
  692806
  620103
  643007
  739518
  705808
  714826
  789274
  411940
  504206
  527231
  665317
  667878
]
4 1.95 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
  43271
  167756
  196316
  338075
  383744
  395639
  404409
  408970
  411940
  412183
  418567
  426367
  432337
  443130
  453073
  453080
  453622
  453842
  457789
  463176
  470512
  470926
  476426
  484660
  484944
  495738
  504206
  511291
  517042
  520135
  520758
  525511
  525657
  527231
  542770
  545708
  546802
  566690
  574269
  585995
  586684
  590978
  592453
  592884
  603041
  606489
  607023
  607376
  618513
  620103
  620164
  621972
  632157
  632383
  643007
  644259
  645964
  649614
  650425
  650836
  651290
  653618
  661279
  661567
  663466
  665317
  665448
  665849
  665875
  666828
  667196
  667532
  667878
  677958
  681020
  681288
  683963
  684053
  692293
  692455
  692806
  698102
  699583
  699718
  703472
  705808
  707546
  714826
  717603
  720112
  720121
  720293
  722796
  731356
  732323
  734514
  736226
  739518
  741538
  742683
  743782
  743803
  758180
  766607
  768879
  773963
  780655
  788527
  789274
  790962
  794265
  794832
  795584
  795807
  812992
  814353
  815051
  815214
  817440
  817463
]
5 144.63 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
  43271
  167756
  196316
  338075
  383744
  395639
  404409
  408970
  411940
  412183
  418567
  426367
  432337
  443130
  453073
  453080
  453622
  453842
  457789
  463176
  470512
  470926
  476426
  484660
  484944
  495738
  504206
  511291
  517042
  520135
  520758
  525511
  525657
  527231
  542770
  545708
  546802
  566690
  574269
  585995
  586684
  590978
  592453
  592884
  603041
  606489
  607023
  607376
  618513
  620103
  620164
  621972
  632157
  632383
  643007
  644259
  645964
  649614
  650425
  650836
  651290
  653618
  661279
  661567
  663466
  665317
  665448
  665849
  665875
  666828
  667196
  667532
  667878
  677958
  681020
  681288
  683963
  684053
  692293
  692455
  692806
  698102
  699583
  699718
  703472
  705808
  707546
  714826
  717603
  720112
  720121
  720293
  722796
  731356
  732323
  734514
  736226
  739518
  741538
  742683
  743782
  743803
  758180
  766607
  768879
  773963
  780655
  788527
  789274
  790962
  794265
  794832
  795584
  795807
  812992
  814353
  815051
  815214
  817440
  817463
]
6 1.42 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "мжм секс втро натуральные сиськ без силикон"
]
7 1.26 ms
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.