Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
153.57 ms
(86.47%)
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
  89421
  386990
  397761
  401589
  401798
  401838
  533187
  540342
  552601
  552756
  554127
  555464
  560890
  562610
  565616
  569069
  569127
  569182
  569210
  570683
  574019
  574020
  586628
  593083
  601328
  602200
  602771
  609157
  611493
  626274
  628507
  632026
  639065
  639638
  644699
  665065
  665835
  668848
  690830
  691454
  701079
  703106
  703265
  709686
  710210
  711924
  716315
  717063
  719638
  719649
  719829
  721831
  722053
  722681
  723583
  725378
  727863
  731580
  736284
  737132
  737529
  745375
  746709
  747256
  748659
  748862
  750127
  750787
  750864
  751590
  753525
  757284
  758036
  761052
  761824
  764173
  765632
  766701
  768862
  769544
  771312
  772661
  776117
  776572
  778637
  779348
  781481
  781757
  783652
  785855
  787990
  788072
  789214
  789313
  791353
  791722
  795475
  795881
  796531
  798876
  798910
  801797
  804536
  805334
  806540
  809942
  811204
  815372
  815428
  816023
  817661
  817679
  820019
  820103
  821468
  821743
  821917
  824167
  826043
  827498
]
14.47 ms
(8.15%)
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
  701079
  401589
  817679
  827498
  821743
  816023
  821917
  533187
  555464
  565616
  554127
  552601
  560890
  703106
  570683
  628507
  602200
  639638
  639065
  801797
  747256
  757284
  737529
  771312
  761052
  703265
  795475
  811204
  401838
  821468
  817661
  569069
  719649
  719829
  690830
  798910
  731580
  401798
  569127
  711924
  721831
  609157
  611493
  776572
  781757
  787990
  788072
  804536
  765632
  709686
  722053
  783652
  796531
  397761
  820019
  562610
  574019
  665065
  632026
  644699
  781481
  806540
  750127
  766701
  750864
  772661
  586628
  820103
  723583
  826043
  815372
  824167
  710210
  716315
  569182
  785855
  776117
  779348
  789214
  795881
  798876
  725378
  727863
  750787
  758036
  764173
  768862
  789313
  809942
  89421
  386990
  815428
  552756
  569210
  574020
  668848
  691454
  722681
  665835
  601328
  626274
  593083
  602771
  791722
  805334
  791353
  748862
  769544
  745375
  746709
  748659
  751590
  736284
  753525
  761824
  717063
  778637
  719638
  737132
  540342
]
2.93 ms
(1.65%)
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
  89421
  386990
  397761
  401589
  401798
  401838
  533187
  540342
  552601
  552756
  554127
  555464
  560890
  562610
  565616
  569069
  569127
  569182
  569210
  570683
  574019
  574020
  586628
  593083
  601328
  602200
  602771
  609157
  611493
  626274
  628507
  632026
  639065
  639638
  644699
  665065
  665835
  668848
  690830
  691454
  701079
  703106
  703265
  709686
  710210
  711924
  716315
  717063
  719638
  719649
  719829
  721831
  722053
  722681
  723583
  725378
  727863
  731580
  736284
  737132
  737529
  745375
  746709
  747256
  748659
  748862
  750127
  750787
  750864
  751590
  753525
  757284
  758036
  761052
  761824
  764173
  765632
  766701
  768862
  769544
  771312
  772661
  776117
  776572
  778637
  779348
  781481
  781757
  783652
  785855
  787990
  788072
  789214
  789313
  791353
  791722
  795475
  795881
  796531
  798876
  798910
  801797
  804536
  805334
  806540
  809942
  811204
  815372
  815428
  816023
  817661
  817679
  820019
  820103
  821468
  821743
  821917
  824167
  826043
  827498
]
2.06 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "dirty sex"
]
1.62 ms
(0.91%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "dirty секс"
]
1.52 ms
(0.86%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.43 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "dirty секс"
]

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.