Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.36 ms
(84.67%)
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
  73571
  98749
  142809
  184359
  209373
  396800
  397891
  398995
  417888
  421617
  430312
  431805
  441550
  443772
  454251
  466094
  471723
  474013
  474024
  474827
  476409
  479866
  483049
  484656
  491301
  497547
  497579
  497581
  500363
  501254
  510742
  511764
  514733
  515179
  517620
  530828
  533054
  535585
  535602
  543997
  545417
  545420
  545718
  546671
  546682
  548888
  548893
  553206
  554121
  556453
  556600
  562539
  562826
  575800
  576116
  595754
  597870
  603620
  603658
  603803
  606521
  606527
  606535
  610814
  622191
  630712
  635789
  637050
  638369
  640233
  643927
  644398
  651287
  652272
  653154
  653620
  653907
  664481
  671243
  671863
  674131
  676344
  676788
  689404
  696289
  696870
  701964
  703209
  707970
  711258
  712646
  712649
  712653
  712892
  713444
  714855
  716564
  717062
  724041
  732268
  741152
  749989
  776572
  781302
  787676
  788169
  796637
  800832
  801149
  806379
  806381
  807144
  807180
  817464
  819996
  824156
  827480
  827827
  827851
  827854
]
17.30 ms
(9.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
  474827
  510742
  827851
  701964
  712646
  610814
  635789
  606521
  603620
  781302
  824156
  806379
  575800
  576116
  431805
  209373
  471723
  417888
  443772
  497579
  497581
  515179
  497547
  511764
  535602
  142809
  603803
  466094
  484656
  827480
  543997
  545417
  664481
  553206
  776572
  724041
  741152
  651287
  653620
  644398
  674131
  827827
  535585
  671243
  689404
  712653
  712892
  606527
  441550
  817464
  548888
  546671
  800832
  801149
  796637
  397891
  595754
  562826
  501254
  562539
  676788
  398995
  622191
  732268
  476409
  545718
  546682
  474013
  454251
  479866
  514733
  184359
  421617
  517620
  545420
  716564
  807144
  749989
  713444
  714855
  788169
  807180
  500363
  474024
  712649
  98749
  652272
  396800
  827854
  707970
  653154
  696289
  696870
  711258
  653907
  556453
  638369
  597870
  637050
  640233
  603658
  630712
  643927
  819996
  483049
  787676
  717062
  530828
  533054
  548893
  676344
  606535
  703209
  671863
  491301
  73571
  806381
  430312
  554121
  556600
]
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
  73571
  98749
  142809
  184359
  209373
  396800
  397891
  398995
  417888
  421617
  430312
  431805
  441550
  443772
  454251
  466094
  471723
  474013
  474024
  474827
  476409
  479866
  483049
  484656
  491301
  497547
  497579
  497581
  500363
  501254
  510742
  511764
  514733
  515179
  517620
  530828
  533054
  535585
  535602
  543997
  545417
  545420
  545718
  546671
  546682
  548888
  548893
  553206
  554121
  556453
  556600
  562539
  562826
  575800
  576116
  595754
  597870
  603620
  603658
  603803
  606521
  606527
  606535
  610814
  622191
  630712
  635789
  637050
  638369
  640233
  643927
  644398
  651287
  652272
  653154
  653620
  653907
  664481
  671243
  671863
  674131
  676344
  676788
  689404
  696289
  696870
  701964
  703209
  707970
  711258
  712646
  712649
  712653
  712892
  713444
  714855
  716564
  717062
  724041
  732268
  741152
  749989
  776572
  781302
  787676
  788169
  796637
  800832
  801149
  806379
  806381
  807144
  807180
  817464
  819996
  824156
  827480
  827827
  827851
  827854
]
2.25 ms
(1.23%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "домашняя групповую"
]
2.09 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск группов"
]
1.86 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск группов"
]
1.83 ms
(1.00%)
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.