Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
121.11 ms
(84.49%)
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
  4377
  12307
  14578
  39301
  52231
  66866
  72666
  91560
  156055
  187856
  188244
  305976
  358259
  383482
  384039
  385826
  389887
  390139
  391875
  396041
  396889
  396967
  397221
  398753
  399514
  406073
  439691
  439728
  439730
  441003
  442118
  453291
  455337
  456194
  462346
  464372
  465222
  466023
  468835
  469359
  472649
  472670
  472860
  474710
  476276
  476354
  485960
  485985
  495514
  495814
  497391
  504464
  505261
  506318
  506404
  511412
  516040
  518735
  524992
  526455
  531529
  537257
  539357
  539516
  539641
  542569
  544794
  550216
  554452
  557137
  565026
  567113
  567683
  601589
  618651
  632367
  660251
  664610
  676252
  677511
  697249
  710769
  714936
  719864
  720510
  724447
  726392
  726493
  728208
  728366
  734077
  734090
  734204
  735929
  738324
  740121
  741774
  741778
  742773
  742889
  747087
  749907
  754138
  755991
  758444
  761436
  774384
  776865
  781752
  784185
  784241
  788345
  788432
  789192
  791003
  796513
  801705
  803498
  825361
]
13.61 ms
(9.49%)
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
  526455
  485985
  539516
  476354
  464372
  720510
  784185
  776865
  462346
  465222
  397221
  187856
  456194
  676252
  728208
  439691
  825361
  539357
  664610
  719864
  724447
  740121
  439728
  455337
  789192
  788432
  524992
  384039
  396041
  52231
  4377
  39301
  791003
  601589
  758444
  618651
  801705
  726392
  72666
  796513
  557137
  441003
  742889
  542569
  531529
  660251
  632367
  495814
  472860
  439730
  398753
  774384
  66866
  741774
  742773
  734077
  746729
  91560
  156055
  472649
  728366
  389887
  504464
  697249
  741778
  735929
  677511
  505261
  14578
  442118
  537257
  305976
  747087
  550216
  506404
  749907
  188244
  390139
  396967
  495514
  734090
  734204
  738324
  474710
  755991
  511412
  761436
  714936
  453291
  358259
  516040
  468835
  385826
  565026
  399514
  396889
  554452
  788345
  754138
  784241
  406073
  472670
  391875
  803498
  12307
  544794
  710769
  539641
  781752
  476276
  383482
  469359
  567113
  726493
  485960
  497391
  567683
  506318
  518735
  466023
]
2.31 ms
(1.61%)
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
  4377
  12307
  14578
  39301
  52231
  66866
  72666
  91560
  156055
  187856
  188244
  305976
  358259
  383482
  384039
  385826
  389887
  390139
  391875
  396041
  396889
  396967
  397221
  398753
  399514
  406073
  439691
  439728
  439730
  441003
  442118
  453291
  455337
  456194
  462346
  464372
  465222
  466023
  468835
  469359
  472649
  472670
  472860
  474710
  476276
  476354
  485960
  485985
  495514
  495814
  497391
  504464
  505261
  506318
  506404
  511412
  516040
  518735
  524992
  526455
  531529
  537257
  539357
  539516
  539641
  542569
  544794
  550216
  554452
  557137
  565026
  567113
  567683
  601589
  618651
  632367
  660251
  664610
  676252
  677511
  697249
  710769
  714936
  719864
  720510
  724447
  726392
  726493
  728208
  728366
  734077
  734090
  734204
  735929
  738324
  740121
  741774
  741778
  742773
  742889
  747087
  749907
  754138
  755991
  758444
  761436
  774384
  776865
  781752
  784185
  784241
  788345
  788432
  789192
  791003
  796513
  801705
  803498
  825361
]
1.69 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "минет зрелка"
]
1.64 ms
(1.14%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "минет оральн секс зрелая женщин"
]
1.54 ms
(1.07%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "минет оральн секс зрелая женщин"
]
1.45 ms
(1.01%)
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.