Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
217.75 ms
(89.53%)
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
  397741
  398355
  398435
  401522
  422316
  431483
  432804
  450597
  463398
  480282
  497903
  509719
  512354
  514910
  517273
  522693
  548116
  555064
  563015
  575308
  577919
  582428
  583560
  588161
  588531
  590812
  591766
  591818
  592379
  594980
  605410
  606529
  612281
  617011
  624652
  626325
  634905
  640304
  645575
  647080
  650094
  650315
  656518
  656582
  656634
  661967
  662889
  669279
  670915
  682989
  690618
  693281
  696104
  699166
  712484
  715888
  719799
  719961
  723566
  726240
  727969
  729657
  730222
  734326
  734347
  740952
  744493
  745069
  746090
  748083
  749009
  750100
  757210
  757535
  761082
  761484
  763762
  767692
  768758
  768983
  771732
  773365
  776785
  778503
  778954
  779264
  779551
  781136
  782130
  782446
  782637
  783144
  783368
  783378
  785325
  785724
  787982
  790298
  791698
  791770
  791782
  793680
  793837
  794511
  794957
  796131
  797163
  797228
  798707
  801553
  804376
  811800
  814454
  820041
  820177
  823447
  824263
  824874
  825557
]
15.24 ms
(6.27%)
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
  746090
  748083
  763762
  779264
  785325
  797228
  804376
  761082
  398435
  778503
  798707
  787982
  670915
  592379
  823447
  814454
  824263
  577919
  781136
  783144
  793837
  779551
  730222
  797163
  811800
  745069
  726240
  757535
  749009
  750100
  757210
  773365
  715888
  791698
  791782
  682989
  514910
  719799
  555064
  605410
  776785
  794957
  768983
  729657
  771732
  727969
  563015
  744493
  723566
  463398
  450597
  512354
  582428
  575308
  656582
  656634
  690618
  699166
  647080
  656518
  661967
  696104
  645575
  650094
  650315
  662889
  669279
  712484
  583560
  634905
  640304
  590812
  594980
  588531
  591766
  606529
  617011
  591818
  612281
  626325
  734988
  734326
  768758
  624652
  431483
  509719
  522693
  401522
  693281
  517273
  480282
  793680
  397741
  398355
  432804
  422316
  820041
  824874
  820177
  825557
  497903
  548116
  719961
  588161
  782637
  790298
  794511
  796131
  801553
  778954
  782446
  785724
  740952
  761484
  767692
  782130
  783368
  783378
  791770
  734347
]
2.62 ms
(1.08%)
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
  397741
  398355
  398435
  401522
  422316
  431483
  432804
  450597
  463398
  480282
  497903
  509719
  512354
  514910
  517273
  522693
  548116
  555064
  563015
  575308
  577919
  582428
  583560
  588161
  588531
  590812
  591766
  591818
  592379
  594980
  605410
  606529
  612281
  617011
  624652
  626325
  634905
  640304
  645575
  647080
  650094
  650315
  656518
  656582
  656634
  661967
  662889
  669279
  670915
  682989
  690618
  693281
  696104
  699166
  712484
  715888
  719799
  719961
  723566
  726240
  727969
  729657
  730222
  734326
  734347
  740952
  744493
  745069
  746090
  748083
  749009
  750100
  757210
  757535
  761082
  761484
  763762
  767692
  768758
  768983
  771732
  773365
  776785
  778503
  778954
  779264
  779551
  781136
  782130
  782446
  782637
  783144
  783368
  783378
  785325
  785724
  787982
  790298
  791698
  791770
  791782
  793680
  793837
  794511
  794957
  796131
  797163
  797228
  798707
  801553
  804376
  811800
  814454
  820041
  820177
  823447
  824263
  824874
  825557
]
2.00 ms
(0.82%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "домашн любительск секс creampie"
]
1.98 ms
(0.81%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.82 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "homemade sex creampie"
]
1.81 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск секс creampie"
]

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.