Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
231.78 ms
(89.61%)
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
  31134
  73289
  152056
  168687
  247954
  383480
  383784
  383923
  385934
  387815
  390445
  391405
  391915
  391950
  394704
  395930
  398112
  401790
  401894
  406334
  407382
  411009
  414782
  420866
  422415
  427285
  429884
  430227
  433673
  434105
  456709
  461044
  465393
  468290
  468508
  469464
  471014
  471015
  471027
  471028
  471058
  474475
  479843
  490600
  496004
  496261
  503372
  504028
  507272
  517789
  525742
  537162
  544915
  545887
  547573
  548394
  549040
  550425
  555486
  561759
  570127
  576618
  578202
  587126
  597663
  602466
  605243
  605270
  605628
  607213
  628563
  631457
  631459
  652757
  681621
  696108
  697219
  700804
  710439
  714707
  718498
  719100
  724768
  725395
  730267
  730297
  733326
  734271
  735947
  738292
  745320
  747964
  753729
  768153
  776434
  776464
  776469
  776842
  789265
  789704
  790388
  794408
  794423
  794585
  804028
  808464
  809907
  810057
  810100
  818396
  823552
  824533
  824589
  824633
  824732
  825264
  825341
  826594
  826739
  828689
]
16.64 ms
(6.43%)
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
  474475
  152056
  430227
  433673
  434105
  507272
  747964
  828689
  548394
  602466
  383480
  73289
  824533
  383784
  390445
  387815
  407382
  414782
  826739
  825341
  503372
  471027
  471028
  545887
  547573
  549040
  550425
  681621
  696108
  718498
  719100
  544915
  555486
  570127
  576618
  597663
  605628
  631457
  605270
  607213
  628563
  587126
  631459
  776469
  789704
  790388
  794408
  794585
  776842
  789265
  808464
  724768
  733326
  738292
  810100
  730267
  734271
  745320
  725395
  730297
  768153
  697219
  700804
  710439
  776464
  804028
  809907
  810057
  168687
  471014
  422415
  468508
  490600
  504028
  578202
  714707
  605243
  753729
  537162
  429884
  385934
  383923
  391915
  401894
  401790
  406334
  420866
  411009
  427285
  823552
  824732
  826594
  818396
  824633
  469464
  461044
  471058
  479843
  456709
  471015
  517789
  496261
  468290
  735947
  776434
  247954
  465393
  391950
  398112
  394704
  395930
  496004
  794423
  652757
  825264
  824589
  525742
  561759
  31134
  391405
]
3.49 ms
(1.35%)
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
  31134
  73289
  152056
  168687
  247954
  383480
  383784
  383923
  385934
  387815
  390445
  391405
  391915
  391950
  394704
  395930
  398112
  401790
  401894
  406334
  407382
  411009
  414782
  420866
  422415
  427285
  429884
  430227
  433673
  434105
  456709
  461044
  465393
  468290
  468508
  469464
  471014
  471015
  471027
  471028
  471058
  474475
  479843
  490600
  496004
  496261
  503372
  504028
  507272
  517789
  525742
  537162
  544915
  545887
  547573
  548394
  549040
  550425
  555486
  561759
  570127
  576618
  578202
  587126
  597663
  602466
  605243
  605270
  605628
  607213
  628563
  631457
  631459
  652757
  681621
  696108
  697219
  700804
  710439
  714707
  718498
  719100
  724768
  725395
  730267
  730297
  733326
  734271
  735947
  738292
  745320
  747964
  753729
  768153
  776434
  776464
  776469
  776842
  789265
  789704
  790388
  794408
  794423
  794585
  804028
  808464
  809907
  810057
  810100
  818396
  823552
  824533
  824589
  824633
  824732
  825264
  825341
  826594
  826739
  828689
]
1.84 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf hairy"
]
1.72 ms
(0.66%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf волосатая"
]
1.67 ms
(0.64%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.59%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf волосатая"
]

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.