Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
271.41 ms
(92.25%)
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
  397008
  397447
  397811
  401953
  406969
  407595
  409866
  411592
  414953
  418961
  433685
  434066
  439694
  439743
  449352
  458682
  462595
  466723
  476346
  484603
  489943
  504897
  514004
  519847
  522483
  523018
  525497
  528349
  534767
  534798
  560346
  565757
  573404
  574030
  576197
  577578
  578158
  590537
  593067
  604643
  618468
  618960
  619536
  620041
  625233
  647984
  660006
  666396
  668509
  682358
  684198
  685864
  688069
  689970
  693238
  701476
  701573
  704579
  715417
  718040
  718048
  718553
  719015
  727050
  727857
  728489
  732821
  734506
  734734
  736783
  738281
  745382
  746696
  749951
  756289
  756683
  758230
  759127
  761125
  763174
  765299
  766413
  767752
  768469
  770478
  773271
  784210
  785426
  786179
  788275
  788507
  788601
  788603
  788792
  788942
  789491
  790813
  794306
  794766
  797340
  799352
  800529
  800859
  801527
  802208
  803073
  803569
  804006
  807295
  807321
  807352
  807546
  808484
  808685
  809522
  809613
  810389
  815940
  816058
  818403
]
10.93 ms
(3.71%)
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
  439694
  504897
  816058
  684198
  489943
  528349
  759127
  788601
  734734
  785426
  409866
  484603
  414953
  514004
  788603
  732821
  668509
  682358
  620041
  593067
  618468
  618960
  784210
  807295
  802208
  766413
  794766
  728489
  763174
  761125
  458682
  734506
  397008
  397447
  818403
  519847
  578158
  718048
  718553
  619536
  788275
  788507
  807352
  770478
  804006
  807546
  745382
  765299
  797340
  815940
  685864
  719015
  466723
  525497
  576197
  565757
  666396
  689970
  693238
  701476
  660006
  799352
  808685
  790813
  807321
  738281
  727050
  736783
  746696
  758230
  704579
  462595
  522483
  439743
  476346
  407595
  688069
  411592
  523018
  401953
  397811
  534798
  534767
  701573
  647984
  590537
  767752
  788792
  433685
  434066
  449352
  560346
  574030
  718040
  573404
  577578
  625233
  788942
  801527
  803073
  803569
  809522
  727857
  786179
  800529
  749951
  756683
  768469
  773271
  756289
  604643
  715417
  789491
  794306
  800859
  808484
  809613
  810389
  418961
  406969
]
4.69 ms
(1.60%)
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
  397008
  397447
  397811
  401953
  406969
  407595
  409866
  411592
  414953
  418961
  433685
  434066
  439694
  439743
  449352
  458682
  462595
  466723
  476346
  484603
  489943
  504897
  514004
  519847
  522483
  523018
  525497
  528349
  534767
  534798
  560346
  565757
  573404
  574030
  576197
  577578
  578158
  590537
  593067
  604643
  618468
  618960
  619536
  620041
  625233
  647984
  660006
  666396
  668509
  682358
  684198
  685864
  688069
  689970
  693238
  701476
  701573
  704579
  715417
  718040
  718048
  718553
  719015
  727050
  727857
  728489
  732821
  734506
  734734
  736783
  738281
  745382
  746696
  749951
  756289
  756683
  758230
  759127
  761125
  763174
  765299
  766413
  767752
  768469
  770478
  773271
  784210
  785426
  786179
  788275
  788507
  788601
  788603
  788792
  788942
  789491
  790813
  794306
  794766
  797340
  799352
  800529
  800859
  801527
  802208
  803073
  803569
  804006
  807295
  807321
  807352
  807546
  808484
  808685
  809522
  809613
  810389
  815940
  816058
  818403
]
2.26 ms
(0.77%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс stepmom"
]
1.69 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "blowjob stepmom"
]
1.67 ms
(0.57%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс stepmom"
]
1.57 ms
(0.53%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.