Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
133.25 ms
(83.55%)
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
  459276
  459631
  462192
  483990
  489881
  508171
  526870
  530987
  534094
  535311
  536750
  539173
  539229
  541003
  543664
  543704
  545734
  546310
  547672
  548100
  549616
  552651
  552657
  558254
  559406
  564521
  566267
  569633
  570143
  575341
  576201
  576983
  583528
  587479
  588167
  589621
  590847
  598360
  599314
  600165
  605713
  613435
  620637
  624161
  624617
  626685
  629174
  630039
  630395
  631220
  636893
  636943
  636960
  640098
  641250
  643462
  646129
  649244
  649361
  649688
  653322
  655288
  655304
  657193
  657217
  657561
  658840
  660048
  660341
  660461
  660738
  666857
  667087
  667913
  668086
  668343
  668585
  669282
  670014
  670727
  670737
  671255
  671898
  679248
  679262
  680816
  685434
  686414
  690218
  690285
  690933
  692032
  696142
  696404
  697187
  698091
  700546
  701018
  702656
  702667
  706520
  707164
  707311
  708867
  711147
  711802
  728675
  738256
  739098
  740206
  750947
  763020
  778966
  788491
  789576
  791521
  794889
  795119
  804496
]
15.92 ms
(9.98%)
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
  626685
  738256
  788491
  508171
  541003
  543704
  545734
  666857
  750947
  795119
  667913
  489881
  536750
  660048
  671898
  570143
  660738
  670727
  711802
  685434
  483990
  660341
  649244
  646129
  636943
  462192
  576201
  680816
  543664
  549616
  679248
  690933
  653322
  668585
  670737
  692032
  696142
  789576
  768728
  548100
  539229
  539173
  552651
  547672
  576983
  668343
  690285
  700546
  670014
  671255
  657217
  667087
  696404
  569633
  600165
  624161
  624617
  599314
  605713
  643462
  631220
  740206
  702667
  707311
  708867
  686414
  640098
  641250
  526870
  566267
  558254
  655288
  657561
  658840
  668086
  679262
  711147
  698091
  702656
  649361
  655304
  669282
  707164
  546310
  552657
  583528
  587479
  589621
  613435
  629174
  588167
  598360
  630395
  636893
  739098
  620637
  630039
  706520
  559406
  804496
  794889
  778966
  459276
  459631
  791521
  728675
  763020
  530987
  534094
  535311
  564521
  575341
  649688
  657193
  660461
  690218
  701018
  697187
  636960
  590847
]
2.51 ms
(1.57%)
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
  459276
  459631
  462192
  483990
  489881
  508171
  526870
  530987
  534094
  535311
  536750
  539173
  539229
  541003
  543664
  543704
  545734
  546310
  547672
  548100
  549616
  552651
  552657
  558254
  559406
  564521
  566267
  569633
  570143
  575341
  576201
  576983
  583528
  587479
  588167
  589621
  590847
  598360
  599314
  600165
  605713
  613435
  620637
  624161
  624617
  626685
  629174
  630039
  630395
  631220
  636893
  636943
  636960
  640098
  641250
  643462
  646129
  649244
  649361
  649688
  653322
  655288
  655304
  657193
  657217
  657561
  658840
  660048
  660341
  660461
  660738
  666857
  667087
  667913
  668086
  668343
  668585
  669282
  670014
  670727
  670737
  671255
  671898
  679248
  679262
  680816
  685434
  686414
  690218
  690285
  690933
  692032
  696142
  696404
  697187
  698091
  700546
  701018
  702656
  702667
  706520
  707164
  707311
  708867
  711147
  711802
  728675
  738256
  739098
  740206
  750947
  763020
  778966
  788491
  789576
  791521
  794889
  795119
  804496
]
2.14 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молоденькая домашнее …"
]
1.97 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(1.19%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк домашн любительск"
]
1.80 ms
(1.13%)
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.