Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
157.90 ms
(84.71%)
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
  8713
  38933
  39142
  75811
  147148
  163762
  312919
  350700
  355294
  382034
  382728
  383294
  386686
  386859
  389122
  390974
  392765
  393430
  395142
  396322
  396441
  397036
  414736
  415554
  417043
  418426
  418438
  419272
  422106
  423945
  426389
  427181
  429504
  430486
  432412
  432414
  432426
  432485
  432493
  432527
  433234
  433716
  433904
  433983
  434220
  434848
  437161
  438017
  438020
  441310
  443522
  443985
  444607
  446199
  446812
  447164
  447252
  450181
  450363
  453259
  453269
  455799
  457027
  457167
  458999
  461709
  461842
  465387
  469402
  471449
  471748
  479450
  480522
  481567
  482896
  483283
  483724
  485043
  486361
  486480
  488541
  489047
  494241
  494319
  495881
  497857
  498735
  501896
  506891
  506942
  507018
  511752
  514757
  517245
  518817
  524904
  526234
  527400
  543284
  543290
  569935
  578847
  583406
  592843
  653790
  698224
  698235
  726108
  730687
  739555
  768418
  783113
  787195
  788001
  791016
  792278
  801860
  808866
  813045
  820261
]
19.04 ms
(10.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
  443522
  583406
  393430
  788001
  791016
  423945
  438017
  395142
  698224
  514757
  483724
  350700
  396441
  433904
  392765
  453269
  527400
  414736
  506942
  8713
  417043
  455799
  432527
  147148
  430486
  426389
  469402
  446199
  479450
  480522
  461842
  432493
  461709
  501896
  498735
  453259
  432412
  163762
  517245
  447164
  592843
  38933
  389122
  482896
  518817
  465387
  486361
  507018
  698235
  578847
  382034
  730687
  75811
  443985
  415554
  438020
  312919
  457167
  386686
  429504
  432414
  481567
  355294
  427181
  450181
  437161
  506891
  483283
  39142
  418438
  543290
  422106
  433234
  383294
  458999
  419272
  433716
  526234
  524904
  488541
  494319
  446812
  808866
  801860
  787195
  396322
  447252
  485043
  444607
  494241
  390974
  653790
  768418
  432485
  433983
  489047
  457027
  434220
  432426
  397036
  386859
  569935
  441310
  471748
  497857
  418426
  495881
  382728
  486480
  471449
  450363
  511752
  739555
  726108
  783113
  813045
  434848
  820261
  543284
  792278
]
2.60 ms
(1.39%)
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
  8713
  38933
  39142
  75811
  147148
  163762
  312919
  350700
  355294
  382034
  382728
  383294
  386686
  386859
  389122
  390974
  392765
  393430
  395142
  396322
  396441
  397036
  414736
  415554
  417043
  418426
  418438
  419272
  422106
  423945
  426389
  427181
  429504
  430486
  432412
  432414
  432426
  432485
  432493
  432527
  433234
  433716
  433904
  433983
  434220
  434848
  437161
  438017
  438020
  441310
  443522
  443985
  444607
  446199
  446812
  447164
  447252
  450181
  450363
  453259
  453269
  455799
  457027
  457167
  458999
  461709
  461842
  465387
  469402
  471449
  471748
  479450
  480522
  481567
  482896
  483283
  483724
  485043
  486361
  486480
  488541
  489047
  494241
  494319
  495881
  497857
  498735
  501896
  506891
  506942
  507018
  511752
  514757
  517245
  518817
  524904
  526234
  527400
  543284
  543290
  569935
  578847
  583406
  592843
  653790
  698224
  698235
  726108
  730687
  739555
  768418
  783113
  787195
  788001
  791016
  792278
  801860
  808866
  813045
  820261
]
1.97 ms
(1.06%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "handjob boy"
]
1.82 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.75 ms
(0.94%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "дрочк член парен"
]
1.32 ms
(0.71%)
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.