Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
128.84 ms
(85.33%)
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
  531689
  533220
  533424
  536297
  538740
  539674
  540831
  542638
  543257
  544679
  545136
  546417
  550358
  555172
  566837
  566879
  567967
  568959
  569377
  571339
  571861
  581927
  582902
  585315
  597762
  619134
  621366
  626507
  627482
  630314
  641427
  641648
  644524
  645301
  648059
  649119
  649646
  649789
  651925
  653320
  655585
  661429
  661494
  664981
  665258
  666375
  667113
  668027
  669609
  671462
  673893
  677129
  678984
  681234
  681756
  684783
  685265
  686129
  687771
  690494
  690588
  691535
  693618
  693699
  696314
  700674
  702240
  703999
  705241
  713951
  716461
  716488
  716491
  716955
  716995
  718366
  718617
  718646
  720566
  722158
  723558
  728761
  730114
  732193
  736752
  744496
  745313
  745889
  747570
  749928
  749997
  755116
  755404
  760508
  774284
  774323
  791163
  809750
  817110
  818500
  818676
  819108
  819716
  819998
  823444
  824274
  825050
  825207
  825236
  825873
  826549
  826627
  827471
  828335
  828480
]
11.72 ms
(7.76%)
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
  824274
  826427
  825050
  531689
  543257
  555172
  581927
  648059
  653320
  716491
  661429
  661494
  684783
  687771
  690588
  713951
  649646
  665258
  666375
  696314
  716461
  716488
  718617
  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
  568959
  693618
  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
]
3.00 ms
(1.99%)
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
  531689
  533220
  533424
  536297
  538740
  539674
  540831
  542638
  543257
  544679
  545136
  546417
  550358
  555172
  566837
  566879
  567967
  568959
  569377
  571339
  571861
  581927
  582902
  585315
  597762
  619134
  621366
  626507
  627482
  630314
  641427
  641648
  644524
  645301
  648059
  649119
  649646
  649789
  651925
  653320
  655585
  661429
  661494
  664981
  665258
  666375
  667113
  668027
  669609
  671462
  673893
  677129
  678984
  681234
  681756
  684783
  685265
  686129
  687771
  690494
  690588
  691535
  693618
  693699
  696314
  700674
  702240
  703999
  705241
  713951
  716461
  716488
  716491
  716955
  716995
  718366
  718617
  718646
  720566
  722158
  723558
  728761
  730114
  732193
  736752
  744496
  745313
  745889
  747570
  749928
  749997
  755116
  755404
  760508
  774284
  774323
  791163
  809750
  817110
  818500
  818676
  819108
  819716
  819998
  823444
  824274
  825050
  825207
  825236
  825873
  826549
  826627
  827471
  828335
  828480
]
2.10 ms
(1.39%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "fucking cock"
]
1.92 ms
(1.27%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.88 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "fucking cock"
]
1.53 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "fucking 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.