Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
165.31 ms
(87.24%)
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
  56349
  91146
  145424
  145988
  233187
  335919
  383153
  383784
  385321
  387263
  389142
  389527
  389943
  394433
  395880
  397258
  398514
  401915
  403229
  404503
  404841
  410029
  410076
  410709
  411742
  412518
  413117
  418334
  421198
  422716
  439217
  441955
  442280
  447745
  448987
  463295
  468616
  470384
  475919
  479690
  480826
  511903
  519142
  519152
  526083
  535059
  546038
  553107
  555335
  555391
  556848
  556858
  559874
  561725
  561736
  567005
  581345
  581680
  584066
  606515
  615475
  617568
  650146
  652827
  660389
  660692
  666031
  681621
  683202
  698916
  712298
  712703
  714587
  718498
  719117
  720004
  720344
  720455
  722138
  722470
  723961
  724260
  725580
  725616
  727535
  730849
  732204
  733217
  734049
  734407
  734664
  744989
  745755
  763966
  770091
  770290
  772398
  773621
  775628
  780631
  782022
  785287
  790388
  793775
  794676
  802572
  803173
  806239
  806827
  809907
  809926
  810051
  810057
  817064
  817800
  818148
  824077
  826620
  826785
  827938
]
14.80 ms
(7.81%)
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
  383784
  395880
  519152
  698916
  650146
  681621
  718498
  790388
  794676
  725616
  744989
  734049
  773621
  606515
  617568
  809907
  810057
  56349
  827938
  394433
  480826
  561736
  581345
  91146
  335919
  410076
  660389
  727535
  806239
  389527
  441955
  824077
  826620
  817064
  817800
  584066
  722138
  666031
  780631
  793775
  810051
  724260
  734664
  770091
  745755
  772398
  763966
  714587
  418334
  145424
  468616
  145988
  401915
  567005
  712298
  722470
  720004
  720455
  723961
  725580
  806827
  809926
  730849
  233187
  397258
  410709
  421198
  413117
  439217
  442280
  546038
  555335
  447745
  404503
  412518
  422716
  475919
  448987
  555391
  389943
  511903
  526083
  556848
  732204
  733217
  403229
  383153
  398514
  404841
  556858
  818148
  826785
  581680
  712703
  385321
  470384
  535059
  559874
  652827
  660692
  719117
  615475
  775628
  782022
  785287
  803173
  734407
  802572
  770290
  389142
  387263
  410029
  411742
  479690
  463295
  519142
  561725
  553107
  683202
  720344
]
2.54 ms
(1.34%)
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
  56349
  91146
  145424
  145988
  233187
  335919
  383153
  383784
  385321
  387263
  389142
  389527
  389943
  394433
  395880
  397258
  398514
  401915
  403229
  404503
  404841
  410029
  410076
  410709
  411742
  412518
  413117
  418334
  421198
  422716
  439217
  441955
  442280
  447745
  448987
  463295
  468616
  470384
  475919
  479690
  480826
  511903
  519142
  519152
  526083
  535059
  546038
  553107
  555335
  555391
  556848
  556858
  559874
  561725
  561736
  567005
  581345
  581680
  584066
  606515
  615475
  617568
  650146
  652827
  660389
  660692
  666031
  681621
  683202
  698916
  712298
  712703
  714587
  718498
  719117
  720004
  720344
  720455
  722138
  722470
  723961
  724260
  725580
  725616
  727535
  730849
  732204
  733217
  734049
  734407
  734664
  744989
  745755
  763966
  770091
  770290
  772398
  773621
  775628
  780631
  782022
  785287
  790388
  793775
  794676
  802572
  803173
  806239
  806827
  809907
  809926
  810051
  810057
  817064
  817800
  818148
  824077
  826620
  826785
  827938
]
1.96 ms
(1.03%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "licking hairy"
]
1.74 ms
(0.92%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "лиза волосатая"
]
1.64 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "лиза волосатая"
]
1.49 ms
(0.79%)
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.