Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
147.26 ms
(87.25%)
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
  80230
  188462
  357753
  382744
  383341
  385682
  386050
  390329
  392439
  393077
  393571
  395932
  396337
  401041
  401441
  401459
  406616
  407801
  411904
  425422
  425759
  435613
  443893
  452532
  456030
  460956
  461151
  465157
  476157
  477254
  479771
  481390
  483472
  489403
  490665
  491344
  494895
  496148
  499844
  502033
  504021
  505369
  505641
  510779
  512892
  515203
  516468
  525742
  526733
  535345
  536107
  544540
  544550
  548421
  551662
  551666
  560954
  563293
  563776
  567005
  567612
  577576
  578156
  578199
  581972
  584378
  586459
  588242
  588900
  590724
  590958
  593431
  595922
  599737
  614834
  617575
  619573
  639181
  647534
  647839
  652161
  664799
  666130
  666697
  677371
  690410
  697175
  707472
  709898
  712298
  713160
  714357
  714418
  719781
  720455
  720797
  723961
  725580
  725613
  726348
  726859
  728629
  733307
  733565
  737844
  739940
  745257
  746013
  746107
  753182
  753244
  753729
  758919
  794390
  795909
  797053
  814272
  819307
  819396
  827138
]
12.08 ms
(7.16%)
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
  593431
  794390
  726348
  758919
  725613
  188462
  479771
  477254
  819307
  814272
  452532
  476157
  563293
  548421
  563776
  577576
  647839
  677371
  714357
  719781
  664799
  595922
  588900
  599737
  619573
  614834
  617575
  726859
  795909
  745257
  733307
  491344
  525742
  80230
  720797
  505369
  510779
  499844
  496148
  535345
  505641
  490665
  690410
  590724
  590958
  456030
  395932
  406616
  435613
  401441
  425422
  512892
  551662
  544540
  551666
  567005
  578156
  584378
  544550
  666697
  707472
  712298
  647534
  666130
  697175
  713160
  714418
  720455
  567612
  578199
  586459
  588242
  639181
  723961
  725580
  728629
  733565
  739940
  746107
  753729
  746013
  753244
  709898
  797053
  386050
  460956
  390329
  401041
  401459
  393571
  383341
  407801
  504021
  494895
  465157
  489403
  515203
  385682
  425759
  652161
  753182
  737844
  392439
  481390
  502033
  526733
  581972
  393077
  483472
  819396
  827138
  357753
  382744
  396337
  411904
  443893
  536107
  516468
  461151
  560954
]
2.49 ms
(1.48%)
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
  80230
  188462
  357753
  382744
  383341
  385682
  386050
  390329
  392439
  393077
  393571
  395932
  396337
  401041
  401441
  401459
  406616
  407801
  411904
  425422
  425759
  435613
  443893
  452532
  456030
  460956
  461151
  465157
  476157
  477254
  479771
  481390
  483472
  489403
  490665
  491344
  494895
  496148
  499844
  502033
  504021
  505369
  505641
  510779
  512892
  515203
  516468
  525742
  526733
  535345
  536107
  544540
  544550
  548421
  551662
  551666
  560954
  563293
  563776
  567005
  567612
  577576
  578156
  578199
  581972
  584378
  586459
  588242
  588900
  590724
  590958
  593431
  595922
  599737
  614834
  617575
  619573
  639181
  647534
  647839
  652161
  664799
  666130
  666697
  677371
  690410
  697175
  707472
  709898
  712298
  713160
  714357
  714418
  719781
  720455
  720797
  723961
  725580
  725613
  726348
  726859
  728629
  733307
  733565
  737844
  739940
  745257
  746013
  746107
  753182
  753244
  753729
  758919
  794390
  795909
  797053
  814272
  819307
  819396
  827138
]
1.98 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "член волосатая"
]
1.78 ms
(1.05%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "член волосатая"
]
1.69 ms
(1.00%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dick hairy"
]
1.50 ms
(0.89%)
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.