Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
150.68 ms
(86.97%)
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
  334847
  390892
  391579
  392602
  394258
  395891
  395933
  396966
  398955
  414788
  415594
  424422
  443677
  443701
  443705
  443709
  443719
  443728
  443818
  443997
  456731
  462110
  462117
  486896
  496346
  515073
  519997
  530537
  534260
  534851
  539497
  541374
  546937
  546938
  550377
  550379
  560395
  563195
  563213
  563421
  563426
  564818
  580297
  586256
  590417
  603242
  610315
  619650
  621067
  621403
  632060
  647984
  650494
  663929
  663936
  684304
  685686
  688083
  688351
  688546
  688572
  689328
  694387
  712338
  714171
  717631
  720607
  721812
  724476
  725558
  725570
  726640
  728018
  728234
  740792
  742656
  743811
  745015
  745422
  745728
  746615
  746685
  747258
  748243
  752876
  758436
  761590
  772109
  774172
  775014
  775545
  779175
  779346
  782194
  782220
  785426
  788288
  788452
  788507
  788601
  788875
  788879
  788959
  789658
  790983
  793703
  801210
  802832
  804219
  807392
  807401
  807517
  807539
  807546
  807553
  808447
  808496
  808537
  808647
  813351
]
13.00 ms
(7.50%)
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
  486896
  515073
  534851
  539497
  530537
  534260
  462110
  541374
  546937
  563195
  580297
  550377
  550379
  563421
  560395
  564818
  650494
  663929
  684304
  688572
  689328
  663936
  685686
  688546
  694387
  712338
  714171
  717631
  647984
  688083
  688351
  546938
  563213
  563426
  603242
  619650
  621403
  590417
  586256
  610315
  632060
  779175
  782220
  788507
  788875
  788879
  790983
  807392
  807401
  779346
  782194
  788959
  789658
  801210
  802832
  807539
  740792
  745422
  746615
  758436
  761590
  772109
  774172
  788601
  807546
  807553
  808447
  808496
  808537
  813351
  724476
  725558
  728234
  745728
  746685
  748243
  742656
  747258
  743811
  752876
  725570
  726640
  728018
  745015
  621067
  720607
  721812
  775014
  775545
  785426
  788288
  788452
  793703
  804219
  807517
  808647
  390892
  395933
  443701
  443719
  443728
  462117
  394258
  398955
  424422
  334847
  391579
  392602
  414788
  443818
  456731
  395891
  396966
  415594
  443677
  443705
  443709
  443997
  519997
  496346
]
2.48 ms
(1.43%)
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
  334847
  390892
  391579
  392602
  394258
  395891
  395933
  396966
  398955
  414788
  415594
  424422
  443677
  443701
  443705
  443709
  443719
  443728
  443818
  443997
  456731
  462110
  462117
  486896
  496346
  515073
  519997
  530537
  534260
  534851
  539497
  541374
  546937
  546938
  550377
  550379
  560395
  563195
  563213
  563421
  563426
  564818
  580297
  586256
  590417
  603242
  610315
  619650
  621067
  621403
  632060
  647984
  650494
  663929
  663936
  684304
  685686
  688083
  688351
  688546
  688572
  689328
  694387
  712338
  714171
  717631
  720607
  721812
  724476
  725558
  725570
  726640
  728018
  728234
  740792
  742656
  743811
  745015
  745422
  745728
  746615
  746685
  747258
  748243
  752876
  758436
  761590
  772109
  774172
  775014
  775545
  779175
  779346
  782194
  782220
  785426
  788288
  788452
  788507
  788601
  788875
  788879
  788959
  789658
  790983
  793703
  801210
  802832
  804219
  807392
  807401
  807517
  807539
  807546
  807553
  808447
  808496
  808537
  808647
  813351
]
2.14 ms
(1.24%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mom old pussy"
]
1.85 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mom old pussy"
]
1.61 ms
(0.93%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mom old pussy"
]

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.