Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
203.41 ms
(89.81%)
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
  7065
  69950
  91853
  152440
  197690
  365295
  381844
  382050
  387744
  389829
  393863
  398077
  398639
  421865
  421894
  426865
  433388
  445864
  459651
  472679
  483654
  486816
  492972
  494316
  494572
  497524
  502602
  506866
  509749
  511468
  511485
  520376
  520667
  522514
  524985
  527424
  529694
  532722
  532845
  533843
  534621
  536447
  536476
  543297
  545067
  545071
  545535
  547004
  547981
  549726
  554794
  557822
  561520
  564224
  564398
  574996
  577510
  579809
  582494
  582927
  590525
  592242
  593118
  597754
  600813
  600949
  602119
  604396
  608151
  617627
  621376
  626116
  629739
  631490
  640898
  644622
  650641
  650916
  653904
  659425
  663960
  665237
  669755
  670512
  680297
  684704
  695358
  695417
  696745
  712624
  713433
  714189
  716493
  739557
  794099
  794816
  794873
  795051
  796075
  797108
  798801
  800715
  800729
  800749
  801515
  802145
  806310
  813547
  819411
  820372
  824643
  824744
  824963
  825261
  826204
  826209
  826811
  827517
  828110
  828810
]
13.46 ms
(5.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
  511485
  483654
  494572
  497524
  511468
  520376
  522514
  524985
  564224
  382050
  520667
  564398
  604396
  389829
  502602
  492972
  527424
  445864
  549726
  684704
  739557
  421894
  459651
  421865
  426865
  472679
  433388
  506866
  197690
  152440
  393863
  365295
  381844
  69950
  7065
  91853
  387744
  398077
  398639
  813547
  826209
  824643
  826811
  827517
  824963
  826204
  819411
  820372
  824744
  825261
  828810
  828110
  486816
  494316
  536476
  532845
  533843
  509749
  532722
  534621
  536447
  529694
  543297
  547004
  577510
  582494
  547981
  557822
  561520
  574996
  579809
  545067
  545535
  554794
  582927
  650641
  650916
  653904
  659425
  695358
  714189
  696745
  712624
  713433
  663960
  665237
  669755
  670512
  680297
  695417
  716493
  545071
  592242
  608151
  626116
  640898
  644622
  590525
  602119
  617627
  621376
  593118
  597754
  600813
  600949
  629739
  631490
  794099
  795051
  798801
  800729
  800749
  802145
  806310
  794816
  794873
  796075
  797108
  800715
  801515
]
2.59 ms
(1.15%)
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
  7065
  69950
  91853
  152440
  197690
  365295
  381844
  382050
  387744
  389829
  393863
  398077
  398639
  421865
  421894
  426865
  433388
  445864
  459651
  472679
  483654
  486816
  492972
  494316
  494572
  497524
  502602
  506866
  509749
  511468
  511485
  520376
  520667
  522514
  524985
  527424
  529694
  532722
  532845
  533843
  534621
  536447
  536476
  543297
  545067
  545071
  545535
  547004
  547981
  549726
  554794
  557822
  561520
  564224
  564398
  574996
  577510
  579809
  582494
  582927
  590525
  592242
  593118
  597754
  600813
  600949
  602119
  604396
  608151
  617627
  621376
  626116
  629739
  631490
  640898
  644622
  650641
  650916
  653904
  659425
  663960
  665237
  669755
  670512
  680297
  684704
  695358
  695417
  696745
  712624
  713433
  714189
  716493
  739557
  794099
  794816
  794873
  795051
  796075
  797108
  798801
  800715
  800729
  800749
  801515
  802145
  806310
  813547
  819411
  820372
  824643
  824744
  824963
  825261
  826204
  826209
  826811
  827517
  828110
  828810
]
2.24 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "рак chubby"
]
1.78 ms
(0.78%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "doggy chubby"
]
1.54 ms
(0.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "рак chubby"
]
1.47 ms
(0.65%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]

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.