Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
166.04 ms
(86.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
  4274
  198616
  385389
  390163
  391043
  397510
  398871
  401973
  411219
  413342
  413623
  415423
  415858
  416514
  418799
  423927
  429837
  432939
  435593
  436982
  437740
  438694
  439376
  442503
  442971
  444042
  444914
  446765
  448573
  449238
  449545
  454305
  454689
  455568
  455573
  456125
  456792
  459354
  459793
  460890
  461282
  461986
  463397
  463709
  465447
  466871
  466970
  468308
  470790
  471656
  472629
  475643
  477132
  479607
  480564
  483775
  486487
  488281
  494630
  495000
  496444
  496958
  497893
  498104
  498123
  499710
  500287
  500323
  501980
  503551
  504357
  504869
  505269
  506092
  506324
  506691
  511509
  512775
  513668
  517158
  517537
  518630
  521401
  522213
  522339
  523485
  523531
  528280
  528970
  534353
  537570
  539609
  544204
  545677
  549938
  550031
  571772
  585306
  585825
  586236
  595574
  604422
  607200
  629117
  631395
  644222
  645300
  666682
  678787
  701001
  718041
  738226
  749974
  763740
  769860
  778434
  795567
  804254
  811987
  813940
]
15.78 ms
(8.20%)
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
  586236
  763740
  749974
  438694
  461282
  435593
  455568
  456125
  442503
  454305
  397510
  418799
  429837
  439376
  444914
  463397
  442971
  460890
  488281
  494630
  498104
  498123
  503551
  500287
  505269
  423927
  415423
  472629
  446765
  455573
  459793
  499710
  517537
  504357
  528970
  461986
  545677
  571772
  678787
  413623
  444042
  477132
  437740
  411219
  511509
  506092
  496958
  512775
  517158
  518630
  528280
  497893
  501980
  416514
  495000
  496444
  595574
  479607
  415858
  513668
  385389
  390163
  401973
  436982
  413342
  813940
  468308
  466871
  506324
  539609
  523485
  534353
  537570
  465447
  544204
  645300
  701001
  666682
  549938
  585306
  585825
  631395
  604422
  607200
  644222
  795567
  769860
  738226
  629117
  718041
  778434
  804254
  811987
  198616
  391043
  448573
  456792
  466970
  398871
  4274
  454689
  459354
  463709
  470790
  475643
  523531
  486487
  522213
  483775
  500323
  506691
  521401
  550031
  432939
  449238
  471656
  480564
  449545
  504869
  522339
]
3.74 ms
(1.94%)
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
  4274
  198616
  385389
  390163
  391043
  397510
  398871
  401973
  411219
  413342
  413623
  415423
  415858
  416514
  418799
  423927
  429837
  432939
  435593
  436982
  437740
  438694
  439376
  442503
  442971
  444042
  444914
  446765
  448573
  449238
  449545
  454305
  454689
  455568
  455573
  456125
  456792
  459354
  459793
  460890
  461282
  461986
  463397
  463709
  465447
  466871
  466970
  468308
  470790
  471656
  472629
  475643
  477132
  479607
  480564
  483775
  486487
  488281
  494630
  495000
  496444
  496958
  497893
  498104
  498123
  499710
  500287
  500323
  501980
  503551
  504357
  504869
  505269
  506092
  506324
  506691
  511509
  512775
  513668
  517158
  517537
  518630
  521401
  522213
  522339
  523485
  523531
  528280
  528970
  534353
  537570
  539609
  544204
  545677
  549938
  550031
  571772
  585306
  585825
  586236
  595574
  604422
  607200
  629117
  631395
  644222
  645300
  666682
  678787
  701001
  718041
  738226
  749974
  763740
  769860
  778434
  795567
  804254
  811987
  813940
]
1.90 ms
(0.99%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "голая вагин"
]
1.88 ms
(0.98%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "голая писька"
]
1.76 ms
(0.92%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.39 ms
(0.72%)
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.