Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
222.14 ms
(57.94%)
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
  588833
  623056
  642924
  794079
  784995
  791138
  810924
  733678
  739329
  740401
  741414
  750620
  760168
  793035
  804142
  733715
  739292
  741327
  741392
  747701
  750654
  752068
  758536
  735346
  745562
  747918
  741413
  749568
  751849
  735231
  749897
  750655
  767518
  787529
  792228
  792665
  401684
  457383
  579611
  420803
  510051
  427006
  445364
  469810
  513167
  531315
  530286
  543661
  579240
  660035
  673488
  678185
  690946
  698491
  700647
  711358
  715378
  659028
  666371
  689514
  690934
  691155
  691998
  712111
  714006
  720304
  564660
  578487
  584583
  595463
  605743
  614222
  628843
  620938
  790093
  809846
  774663
  782307
  787519
  790630
  736428
  739446
  761634
  784889
  741356
  747921
  734079
  761892
  736112
  741378
  743722
  630920
  789597
  800298
  807203
  457353
  506235
  457245
  444643
  383462
  442027
  813747
  813833
  452846
  511479
  533770
  523926
  538659
  514405
  525033
  549781
  547232
  564185
  556151
  558605
  697666
  701009
  651217
  663838
  695775
]
150.51 ms
(39.26%)
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
  383462
  401684
  420803
  427006
  442027
  444643
  445364
  452846
  457245
  457353
  457383
  469810
  506235
  510051
  511479
  513167
  514405
  523926
  525033
  530286
  531315
  533770
  538659
  543661
  547232
  549781
  556151
  558605
  564185
  564660
  578487
  579240
  579611
  584583
  588833
  595463
  605743
  614222
  620938
  623056
  628843
  630920
  642924
  651217
  659028
  660035
  663838
  666371
  673488
  678185
  689514
  690934
  690946
  691155
  691998
  695775
  697666
  698491
  700647
  701009
  711358
  712111
  714006
  715378
  720304
  733678
  733715
  734079
  735231
  735346
  736112
  736428
  739292
  739329
  739446
  740401
  741327
  741356
  741378
  741392
  741413
  741414
  743722
  745562
  747701
  747918
  747921
  749568
  749897
  750620
  750654
  750655
  751849
  752068
  758536
  760168
  761634
  761892
  767518
  774663
  782307
  784889
  784995
  787519
  787529
  789597
  790093
  790630
  791138
  792228
  792665
  793035
  794079
  800298
  804142
  807203
  809846
  810924
  813747
  813833
]
3.54 ms
(0.92%)
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
  383462
  401684
  420803
  427006
  442027
  444643
  445364
  452846
  457245
  457353
  457383
  469810
  506235
  510051
  511479
  513167
  514405
  523926
  525033
  530286
  531315
  533770
  538659
  543661
  547232
  549781
  556151
  558605
  564185
  564660
  578487
  579240
  579611
  584583
  588833
  595463
  605743
  614222
  620938
  623056
  628843
  630920
  642924
  651217
  659028
  660035
  663838
  666371
  673488
  678185
  689514
  690934
  690946
  691155
  691998
  695775
  697666
  698491
  700647
  701009
  711358
  712111
  714006
  715378
  720304
  733678
  733715
  734079
  735231
  735346
  736112
  736428
  739292
  739329
  739446
  740401
  741327
  741356
  741378
  741392
  741413
  741414
  743722
  745562
  747701
  747918
  747921
  749568
  749897
  750620
  750654
  750655
  751849
  752068
  758536
  760168
  761634
  761892
  767518
  774663
  782307
  784889
  784995
  787519
  787529
  789597
  790093
  790630
  791138
  792228
  792665
  793035
  794079
  800298
  804142
  807203
  809846
  810924
  813747
  813833
]
1.98 ms
(0.52%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(0.50%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "porn webcam"
]
1.81 ms
(0.47%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "porn вебкамер"
]
1.48 ms
(0.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "porn вебкамер"
]

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.