Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.59 ms
(82.21%)
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
  393323
  396177
  401654
  531324
  533220
  533424
  536297
  538740
  539674
  540831
  542638
  544679
  545136
  546417
  550358
  555935
  566837
  566879
  567967
  569377
  570375
  571339
  571861
  572112
  582902
  585315
  588686
  597762
  599774
  602431
  607110
  615401
  616665
  619134
  621366
  622019
  626169
  626507
  627482
  628620
  630314
  633656
  635559
  636117
  641427
  641648
  644524
  645301
  649119
  649789
  651925
  655585
  664981
  667113
  668027
  669609
  671462
  672693
  673893
  675230
  677129
  678984
  681234
  681756
  684752
  685265
  686129
  690494
  691535
  693618
  693699
  700674
  702240
  703999
  705241
  712182
  714327
  715022
  716955
  716995
  718366
  718646
  720566
  721974
  722031
  722158
  723558
  728761
  730114
  732193
  736752
  744496
  745313
  745889
  747570
  749928
  749997
  755116
  755404
  760508
  774284
  774323
  791163
  793410
  809750
  817110
  818500
  818676
  819108
  819716
  819998
  823444
  825207
  825236
  825873
  826549
  826627
  827471
  828335
  828480
]
18.22 ms
(11.13%)
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
  567967
  585315
  619134
  626507
  641648
  621366
  641427
  597762
  630314
  791163
  755116
  736752
  744496
  749928
  755404
  774284
  774323
  730114
  745313
  745889
  732193
  749997
  760508
  627482
  644524
  716955
  809750
  401654
  825207
  538740
  675230
  693618
  793410
  728761
  747570
  393323
  396177
  823444
  540831
  723558
  826627
  819716
  819998
  825873
  827471
  817110
  818676
  819108
  818500
  825236
  826549
  828335
  828480
  533220
  536297
  539674
  531324
  533424
  546417
  569377
  571861
  544679
  582902
  542638
  545136
  550358
  566837
  566879
  571339
  649789
  677129
  681234
  700674
  702240
  703999
  718646
  722158
  645301
  649119
  655585
  667113
  673893
  678984
  681756
  685265
  686129
  690494
  691535
  693699
  705241
  716995
  718366
  720566
  651925
  664981
  668027
  669609
  671462
  672693
  684752
  712182
  714327
  715022
  721974
  722031
  555935
  570375
  572112
  599774
  607110
  628620
  635559
  636117
  588686
  602431
  615401
  616665
  622019
  626169
  633656
]
3.48 ms
(2.13%)
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
  393323
  396177
  401654
  531324
  533220
  533424
  536297
  538740
  539674
  540831
  542638
  544679
  545136
  546417
  550358
  555935
  566837
  566879
  567967
  569377
  570375
  571339
  571861
  572112
  582902
  585315
  588686
  597762
  599774
  602431
  607110
  615401
  616665
  619134
  621366
  622019
  626169
  626507
  627482
  628620
  630314
  633656
  635559
  636117
  641427
  641648
  644524
  645301
  649119
  649789
  651925
  655585
  664981
  667113
  668027
  669609
  671462
  672693
  673893
  675230
  677129
  678984
  681234
  681756
  684752
  685265
  686129
  690494
  691535
  693618
  693699
  700674
  702240
  703999
  705241
  712182
  714327
  715022
  716955
  716995
  718366
  718646
  720566
  721974
  722031
  722158
  723558
  728761
  730114
  732193
  736752
  744496
  745313
  745889
  747570
  749928
  749997
  755116
  755404
  760508
  774284
  774323
  791163
  793410
  809750
  817110
  818500
  818676
  819108
  819716
  819998
  823444
  825207
  825236
  825873
  826549
  826627
  827471
  828335
  828480
]
2.06 ms
(1.26%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "cock fucking"
]
1.90 ms
(1.16%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "cock fucking"
]
1.84 ms
(1.12%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.62 ms
(0.99%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "cock fucking"
]

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.