Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
131.62 ms
(81.48%)
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
  36844
  65533
  249773
  395574
  395985
  396645
  396844
  403397
  404968
  409995
  415230
  417491
  418369
  418494
  422010
  422409
  424387
  426323
  428029
  428587
  429945
  433164
  437635
  439769
  439800
  439886
  443481
  443590
  443987
  445795
  446358
  447146
  447425
  447434
  447435
  447438
  447444
  447480
  447486
  447499
  447514
  447519
  447532
  447549
  447750
  448519
  448876
  452593
  454726
  454836
  454842
  458172
  460217
  461462
  462009
  463965
  464185
  465879
  468345
  469189
  473208
  478485
  482335
  484525
  484893
  485138
  485228
  485389
  486275
  487189
  487206
  489522
  490786
  490982
  491326
  491667
  491683
  491689
  491718
  492553
  492822
  493480
  493677
  494892
  496040
  497426
  497580
  502634
  502763
  505130
  510392
  510393
  510612
  512257
  512333
  513313
  513346
  513655
  514796
  515096
  519841
  521082
  521588
  524793
  526136
  526776
  527378
  527610
  527629
  529557
  530478
  816623
  818209
  821035
  821666
  822180
  823759
  825566
  826069
  826221
]
19.33 ms
(11.97%)
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
  424387
  428587
  433164
  437635
  447438
  447514
  447519
  447549
  448519
  454836
  458172
  461462
  404968
  409995
  415230
  418369
  418494
  422409
  426323
  439769
  439800
  439886
  443481
  443590
  443987
  447146
  447425
  447434
  447435
  447444
  447480
  447532
  447750
  448876
  454726
  454842
  463965
  465879
  473208
  417491
  428029
  429945
  447486
  447499
  452593
  464185
  512257
  524793
  526776
  527629
  486275
  491667
  491683
  492822
  493480
  497426
  497580
  502763
  505130
  512333
  513346
  527378
  484893
  485138
  487189
  490786
  490982
  491326
  491718
  492553
  510392
  510393
  510612
  513313
  513655
  519841
  521588
  529557
  530478
  487206
  489522
  491689
  496040
  502634
  514796
  249773
  395574
  395985
  65533
  396645
  396844
  403397
  422010
  821666
  823759
  826069
  816623
  826221
  825566
  818209
  821035
  822180
  36844
  462009
  469189
  478485
  482335
  493677
  445795
  460217
  485389
  446358
  468345
  484525
  485228
  494892
  515096
  521082
  526136
  527610
]
2.78 ms
(1.72%)
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
  36844
  65533
  249773
  395574
  395985
  396645
  396844
  403397
  404968
  409995
  415230
  417491
  418369
  418494
  422010
  422409
  424387
  426323
  428029
  428587
  429945
  433164
  437635
  439769
  439800
  439886
  443481
  443590
  443987
  445795
  446358
  447146
  447425
  447434
  447435
  447438
  447444
  447480
  447486
  447499
  447514
  447519
  447532
  447549
  447750
  448519
  448876
  452593
  454726
  454836
  454842
  458172
  460217
  461462
  462009
  463965
  464185
  465879
  468345
  469189
  473208
  478485
  482335
  484525
  484893
  485138
  485228
  485389
  486275
  487189
  487206
  489522
  490786
  490982
  491326
  491667
  491683
  491689
  491718
  492553
  492822
  493480
  493677
  494892
  496040
  497426
  497580
  502634
  502763
  505130
  510392
  510393
  510612
  512257
  512333
  513313
  513346
  513655
  514796
  515096
  519841
  521082
  521588
  524793
  526136
  526776
  527378
  527610
  527629
  529557
  530478
  816623
  818209
  821035
  821666
  822180
  823759
  825566
  826069
  826221
]
2.21 ms
(1.37%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.06 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "white teen"
]
1.78 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "white teen"
]
1.76 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "white teen"
]

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.