Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
119.50 ms
(81.19%)
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
  186592
  390264
  396016
  411373
  428821
  429863
  432530
  432556
  442545
  447600
  451443
  460440
  466047
  466066
  466130
  472948
  475568
  480385
  481256
  485355
  490904
  515597
  515629
  530403
  532780
  534013
  535318
  536305
  536391
  544834
  545497
  545498
  546307
  548213
  553687
  555991
  557027
  561566
  564299
  564797
  569271
  571128
  571494
  574422
  579998
  589129
  597610
  598347
  600855
  601118
  602803
  603644
  604257
  604920
  605255
  623403
  623906
  626576
  629334
  629595
  648987
  658483
  665052
  695334
  695403
  695407
  695424
  699938
  709615
  715444
  716143
  716273
  717033
  718227
  718717
  725469
  725533
  726929
  727898
  730759
  732825
  733208
  734359
  742097
  748323
  759623
  760969
  761517
  765459
  767704
  778215
  784162
  788121
  789492
  789985
  794098
  795166
  795296
  795952
  796061
  796489
  796555
  800653
  801253
  804339
  806095
  806166
  807383
  810597
  811454
  811708
  811747
  812506
  813557
  815966
  816755
  816985
  828052
  828551
]
16.21 ms
(11.01%)
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
  545497
  553687
  569271
  545498
  604257
  765459
  761517
  603644
  811454
  432530
  451443
  466066
  428821
  475568
  536391
  485355
  759623
  695403
  796489
  748323
  447600
  532780
  571128
  605255
  589129
  727898
  807383
  429863
  515629
  515597
  816755
  597610
  796555
  732825
  466047
  623906
  481256
  716273
  794098
  574422
  186592
  815966
  460440
  561566
  623403
  795296
  795166
  760969
  733208
  778215
  789985
  626576
  390264
  828551
  810597
  801253
  480385
  472948
  548213
  557027
  571494
  601118
  602803
  432556
  466130
  534013
  796061
  725533
  742097
  826362
  828052
  734359
  411373
  709615
  665052
  715444
  800653
  811708
  806095
  806166
  535318
  544834
  490904
  813557
  536305
  717033
  579998
  604920
  629334
  725469
  812506
  767704
  788121
  442545
  555991
  804339
  726929
  730759
  396016
  816985
  530403
  564797
  546307
  564299
  716143
  718227
  718717
  695407
  695424
  648987
  658483
  695334
  699938
  598347
  629595
  600855
  795952
  811747
  784162
  789492
]
3.54 ms
(2.40%)
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
  186592
  390264
  396016
  411373
  428821
  429863
  432530
  432556
  442545
  447600
  451443
  460440
  466047
  466066
  466130
  472948
  475568
  480385
  481256
  485355
  490904
  515597
  515629
  530403
  532780
  534013
  535318
  536305
  536391
  544834
  545497
  545498
  546307
  548213
  553687
  555991
  557027
  561566
  564299
  564797
  569271
  571128
  571494
  574422
  579998
  589129
  597610
  598347
  600855
  601118
  602803
  603644
  604257
  604920
  605255
  623403
  623906
  626576
  629334
  629595
  648987
  658483
  665052
  695334
  695403
  695407
  695424
  699938
  709615
  715444
  716143
  716273
  717033
  718227
  718717
  725469
  725533
  726929
  727898
  730759
  732825
  733208
  734359
  742097
  748323
  759623
  760969
  761517
  765459
  767704
  778215
  784162
  788121
  789492
  789985
  794098
  795166
  795296
  795952
  796061
  796489
  796555
  800653
  801253
  804339
  806095
  806166
  807383
  810597
  811454
  811708
  811747
  812506
  813557
  815966
  816755
  816985
  828052
  828551
]
2.12 ms
(1.44%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "pantyhose ass milf"
]
2.00 ms
(1.36%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "pantyhose жоп milf"
]
1.97 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "pantyhose жоп milf"
]
1.86 ms
(1.26%)
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.