Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
155.02 ms
(88.06%)
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
  14369
  186988
  191117
  195676
  250422
  271496
  383088
  386336
  389289
  397184
  397605
  398555
  398927
  401814
  403087
  408743
  409350
  411054
  411731
  416855
  421257
  422278
  437352
  439456
  443191
  449894
  453122
  454429
  455325
  459566
  460129
  462968
  464423
  467823
  485610
  487953
  488532
  489169
  493679
  503978
  520106
  527417
  530098
  533716
  537760
  543545
  544184
  546558
  554460
  567113
  588635
  589578
  591741
  604673
  606252
  617390
  629810
  629826
  644102
  652749
  664813
  666197
  667574
  669771
  670501
  699765
  701257
  711660
  714173
  714204
  719907
  724491
  726492
  728380
  729100
  729292
  731040
  731046
  731317
  734108
  739561
  740138
  740954
  742721
  744053
  745264
  746095
  746658
  748483
  751472
  751522
  756256
  756811
  769393
  772120
  775158
  775589
  781846
  781885
  781892
  781900
  790305
  792593
  794175
  800176
  801494
  804030
  808231
  808631
  810350
  810356
  823746
  823881
  823956
  824331
  825385
  826703
  827097
  827183
  827977
]
11.29 ms
(6.41%)
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
  527417
  543545
  664813
  667574
  827183
  827977
  533716
  711660
  589578
  629810
  794175
  810356
  724491
  728380
  731046
  726492
  756811
  719907
  775589
  781900
  810350
  397184
  408743
  422278
  487953
  455325
  554460
  617390
  409350
  439456
  383088
  389289
  398927
  398555
  411731
  823746
  827097
  485610
  503978
  546558
  670501
  567113
  606252
  644102
  792593
  800176
  804030
  801494
  748483
  744053
  746095
  756256
  714173
  775158
  250422
  191117
  271496
  397605
  401814
  403087
  449894
  453122
  454429
  493679
  462968
  530098
  669771
  604673
  781885
  772120
  740138
  488532
  14369
  386336
  186988
  195676
  411054
  823881
  825385
  826703
  823956
  824331
  537760
  652749
  701257
  714204
  666197
  588635
  790305
  808631
  781846
  808231
  729100
  734108
  731040
  731317
  745264
  729292
  746658
  751472
  739561
  740954
  742721
  751522
  769393
  629826
  699765
  460129
  544184
  467823
  416855
  437352
  459566
  464423
  591741
  781892
  443191
  520106
  489169
  421257
]
2.46 ms
(1.40%)
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
  14369
  186988
  191117
  195676
  250422
  271496
  383088
  386336
  389289
  397184
  397605
  398555
  398927
  401814
  403087
  408743
  409350
  411054
  411731
  416855
  421257
  422278
  437352
  439456
  443191
  449894
  453122
  454429
  455325
  459566
  460129
  462968
  464423
  467823
  485610
  487953
  488532
  489169
  493679
  503978
  520106
  527417
  530098
  533716
  537760
  543545
  544184
  546558
  554460
  567113
  588635
  589578
  591741
  604673
  606252
  617390
  629810
  629826
  644102
  652749
  664813
  666197
  667574
  669771
  670501
  699765
  701257
  711660
  714173
  714204
  719907
  724491
  726492
  728380
  729100
  729292
  731040
  731046
  731317
  734108
  739561
  740138
  740954
  742721
  744053
  745264
  746095
  746658
  748483
  751472
  751522
  756256
  756811
  769393
  772120
  775158
  775589
  781846
  781885
  781892
  781900
  790305
  792593
  794175
  800176
  801494
  804030
  808231
  808631
  810350
  810356
  823746
  823881
  823956
  824331
  825385
  826703
  827097
  827183
  827977
]
2.24 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "ебут пышку"
]
1.78 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс полная"
]
1.66 ms
(0.94%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.