Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.71 ms
(83.75%)
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
  389208
  401919
  404925
  409774
  417521
  421323
  432751
  436032
  445681
  448307
  452199
  453875
  457793
  462535
  465024
  467009
  468433
  469030
  472750
  476108
  476797
  482527
  485541
  486199
  486569
  488734
  493477
  494978
  495835
  496080
  497885
  500384
  500493
  500904
  504700
  508523
  512490
  513338
  514689
  515538
  516350
  520448
  520954
  520966
  521985
  523290
  523317
  524879
  526104
  526224
  526948
  531201
  532676
  532847
  533350
  535016
  539008
  540346
  543419
  543832
  544800
  546669
  549343
  571018
  574527
  575459
  575810
  579371
  582540
  586524
  587896
  588265
  590651
  591169
  591312
  591314
  598105
  599888
  601583
  602968
  602971
  605151
  605374
  608261
  611558
  614752
  615881
  618596
  619468
  623380
  632614
  634472
  634482
  634484
  634487
  634495
  637049
  639796
  640022
  643523
  647932
  648853
  662137
  674994
  676089
  698133
  701010
  701348
  813759
  814784
]
20.02 ms
(10.98%)
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
  448307
  504700
  515538
  465024
  445681
  512490
  539008
  486199
  605374
  469030
  813759
  814784
  540346
  500493
  526224
  579371
  602971
  619468
  608261
  453875
  417521
  500384
  520966
  462535
  436032
  457793
  485541
  494978
  532847
  634484
  513338
  523317
  421323
  476108
  532676
  495835
  496080
  575810
  591312
  632614
  701010
  468433
  516350
  521985
  520448
  575459
  648853
  701348
  549343
  582540
  493477
  526948
  409774
  533350
  571018
  602968
  640022
  643523
  634487
  618596
  404925
  497885
  467009
  514689
  452199
  546669
  634482
  599888
  623380
  605151
  486569
  520954
  543832
  647932
  591169
  476797
  586524
  389208
  524879
  500904
  544800
  401919
  523290
  432751
  482527
  591314
  676089
  662137
  634472
  601583
  488734
  587896
  611558
  637049
  588265
  614752
  674994
  590651
  639796
  634495
  698133
  508523
  598105
  531201
  615881
  526104
  535016
  574527
  543419
  472750
]
2.78 ms
(1.52%)
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
  389208
  401919
  404925
  409774
  417521
  421323
  432751
  436032
  445681
  448307
  452199
  453875
  457793
  462535
  465024
  467009
  468433
  469030
  472750
  476108
  476797
  482527
  485541
  486199
  486569
  488734
  493477
  494978
  495835
  496080
  497885
  500384
  500493
  500904
  504700
  508523
  512490
  513338
  514689
  515538
  516350
  520448
  520954
  520966
  521985
  523290
  523317
  524879
  526104
  526224
  526948
  531201
  532676
  532847
  533350
  535016
  539008
  540346
  543419
  543832
  544800
  546669
  549343
  571018
  574527
  575459
  575810
  579371
  582540
  586524
  587896
  588265
  590651
  591169
  591312
  591314
  598105
  599888
  601583
  602968
  602971
  605151
  605374
  608261
  611558
  614752
  615881
  618596
  619468
  623380
  632614
  634472
  634482
  634484
  634487
  634495
  637049
  639796
  640022
  643523
  647932
  648853
  662137
  674994
  676089
  698133
  701010
  701348
  813759
  814784
]
1.94 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "party tits"
]
1.74 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "party сиськ"
]
1.63 ms
(0.89%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "party сиськ"
]
1.52 ms
(0.83%)
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.