Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
134.88 ms
(83.54%)
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
  21981
  395583
  396672
  401799
  403108
  405990
  407871
  411344
  413488
  413963
  416044
  416153
  424795
  429547
  437494
  448863
  454009
  460011
  476713
  495866
  497878
  515200
  525350
  526372
  534625
  535279
  543874
  554423
  558200
  564120
  565470
  569595
  586899
  598720
  604726
  604891
  605909
  606831
  626547
  628398
  639274
  641978
  642308
  642323
  645012
  652612
  653187
  655153
  661568
  666538
  672355
  674430
  681081
  686224
  692599
  697220
  702048
  703843
  703963
  705239
  709259
  714892
  715798
  720239
  720308
  720339
  720946
  720950
  725743
  732791
  733841
  741499
  742927
  744878
  744896
  751316
  753902
  754186
  756614
  760612
  765156
  765211
  766770
  768790
  771452
  771510
  772842
  775632
  780041
  782978
  789710
  789892
  789945
  789958
  791205
  791623
  793723
  796734
  797071
  797771
  798918
  801938
  804498
  805201
  805935
  807923
  810132
  813706
  815031
  815317
  815396
  815801
  817460
  818475
  819036
  819594
  820151
  823833
  824434
  826972
]
14.80 ms
(9.16%)
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
  709259
  652612
  766770
  645012
  655153
  598720
  754186
  405990
  666538
  543874
  416153
  819594
  817460
  476713
  780041
  741499
  768790
  395583
  753902
  403108
  564120
  565470
  534625
  535279
  495866
  411344
  454009
  819036
  437494
  554423
  715798
  805935
  744878
  772842
  558200
  807923
  586899
  628398
  686224
  604726
  401799
  702048
  820151
  413963
  813706
  569595
  703843
  705239
  793723
  771452
  791623
  526372
  416044
  497878
  661568
  760612
  771510
  804498
  672355
  720946
  732791
  413488
  460011
  681081
  642308
  765156
  641978
  789892
  720950
  674430
  639274
  424795
  818475
  823833
  604891
  720308
  642323
  775632
  429547
  396672
  815396
  692599
  720239
  797771
  733841
  798918
  815317
  824434
  714892
  653187
  720339
  789710
  796734
  801938
  725743
  789945
  744896
  765211
  751316
  703963
  797071
  21981
  606831
  626547
  782978
  810132
  407871
  448863
  826972
  697220
  605909
  805201
  742927
  756614
  789958
  791205
  515200
  525350
  815031
  815801
]
4.18 ms
(2.59%)
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
  21981
  395583
  396672
  401799
  403108
  405990
  407871
  411344
  413488
  413963
  416044
  416153
  424795
  429547
  437494
  448863
  454009
  460011
  476713
  495866
  497878
  515200
  525350
  526372
  534625
  535279
  543874
  554423
  558200
  564120
  565470
  569595
  586899
  598720
  604726
  604891
  605909
  606831
  626547
  628398
  639274
  641978
  642308
  642323
  645012
  652612
  653187
  655153
  661568
  666538
  672355
  674430
  681081
  686224
  692599
  697220
  702048
  703843
  703963
  705239
  709259
  714892
  715798
  720239
  720308
  720339
  720946
  720950
  725743
  732791
  733841
  741499
  742927
  744878
  744896
  751316
  753902
  754186
  756614
  760612
  765156
  765211
  766770
  768790
  771452
  771510
  772842
  775632
  780041
  782978
  789710
  789892
  789945
  789958
  791205
  791623
  793723
  796734
  797071
  797771
  798918
  801938
  804498
  805201
  805935
  807923
  810132
  813706
  815031
  815317
  815396
  815801
  817460
  818475
  819036
  819594
  820151
  823833
  824434
  826972
]
2.20 ms
(1.36%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2.14 ms
(1.32%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "squirt blowjob"
]
1.64 ms
(1.02%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "сквирт оргазм минет оральн секс"
]
1.63 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.