Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
205.13 ms
(54.68%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hot ass solo"
]
144.29 ms
(38.46%)
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
  390839
  394309
  395983
  398124
  410796
  413006
  419895
  423773
  449572
  450583
  457056
  457074
  458508
  466031
  472548
  480494
  492808
  506302
  511006
  515531
  517441
  520524
  521014
  522102
  528296
  528926
  529595
  529810
  531856
  535807
  537155
  539557
  540691
  541805
  545504
  551883
  556040
  568652
  576176
  577054
  579236
  579523
  584140
  584363
  585453
  587241
  591993
  592656
  593183
  594934
  597725
  599601
  600362
  602320
  603717
  607573
  618072
  620813
  630233
  634836
  639652
  640375
  641064
  642076
  649738
  650447
  650649
  654196
  655297
  656228
  660597
  663751
  666733
  668026
  668303
  675837
  678661
  682611
  692165
  699232
  700985
  710523
  710800
  711597
  711637
  712884
  713117
  714253
  734416
  736814
  739133
  749611
  750981
  752251
  752496
  760609
  770544
  776007
  776524
  777756
  779718
  783297
  784199
  784337
  785366
  787526
  790214
  792547
  796807
  804440
  804453
  810754
  812198
  812557
  814285
  816836
  818960
  819950
  824104
  827553
]
15.79 ms
(4.21%)
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
  827553
  649738
  597725
  395983
  390839
  410796
  515531
  528926
  545504
  660597
  398124
  819950
  816836
  818960
  458508
  529810
  528296
  537155
  522102
  584363
  551883
  656228
  663751
  668026
  678661
  682611
  714253
  654196
  675837
  713117
  607573
  620813
  600362
  603717
  639652
  641064
  618072
  777756
  790214
  752496
  792547
  804453
  810754
  812557
  739133
  750981
  752251
  734416
  760609
  699232
  783297
  784199
  796807
  804440
  812198
  506302
  531856
  517441
  655297
  592656
  779718
  749611
  776007
  394309
  423773
  511006
  457074
  770544
  492808
  591993
  480494
  449572
  450583
  576176
  579523
  579236
  710523
  776524
  787526
  784337
  419895
  472548
  521014
  466031
  584140
  577054
  587241
  602320
  599601
  593183
  785366
  736814
  413006
  814285
  824104
  457056
  520524
  529595
  539557
  540691
  535807
  541805
  556040
  650447
  650649
  668303
  700985
  711637
  666733
  710800
  712884
  692165
  711597
  568652
  594934
  634836
  640375
  642076
  585453
  630233
]
4.15 ms
(1.11%)
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
  390839
  394309
  395983
  398124
  410796
  413006
  419895
  423773
  449572
  450583
  457056
  457074
  458508
  466031
  472548
  480494
  492808
  506302
  511006
  515531
  517441
  520524
  521014
  522102
  528296
  528926
  529595
  529810
  531856
  535807
  537155
  539557
  540691
  541805
  545504
  551883
  556040
  568652
  576176
  577054
  579236
  579523
  584140
  584363
  585453
  587241
  591993
  592656
  593183
  594934
  597725
  599601
  600362
  602320
  603717
  607573
  618072
  620813
  630233
  634836
  639652
  640375
  641064
  642076
  649738
  650447
  650649
  654196
  655297
  656228
  660597
  663751
  666733
  668026
  668303
  675837
  678661
  682611
  692165
  699232
  700985
  710523
  710800
  711597
  711637
  712884
  713117
  714253
  734416
  736814
  739133
  749611
  750981
  752251
  752496
  760609
  770544
  776007
  776524
  777756
  779718
  783297
  784199
  784337
  785366
  787526
  790214
  792547
  796807
  804440
  804453
  810754
  812198
  812557
  814285
  816836
  818960
  819950
  824104
  827553
]
2.18 ms
(0.58%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.83 ms
(0.49%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "hot жоп соло"
]
1.79 ms
(0.48%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "hot жоп соло"
]

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.