Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
120.39 ms
(83.37%)
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
  386166
  393326
  402950
  412779
  417389
  419062
  419826
  421423
  424331
  427539
  432299
  436230
  440094
  441021
  441027
  441073
  441495
  443496
  445413
  446274
  447600
  449173
  450679
  451121
  451316
  453137
  453583
  453678
  468434
  477118
  480450
  487429
  489953
  493749
  493757
  497509
  497906
  499211
  499617
  504482
  507542
  508666
  510102
  511866
  512543
  520400
  528474
  530394
  531821
  541277
  541322
  542268
  542881
  544108
  544988
  545808
  547386
  547496
  547848
  548460
  556876
  559202
  561042
  565142
  597457
  600358
  603057
  616296
  646290
  655919
  657505
  663337
  666898
  670357
  681643
  696236
  704232
  708923
  711699
  713500
  716118
  717516
  720737
  724127
  725115
  729243
  730355
  738826
  740849
  745121
  749245
  752592
  752595
  758027
  758778
  758799
  762975
  769917
  775572
  776956
  777847
  782040
  782090
  782351
  782789
  783382
  785582
  791930
  792654
  795523
  801543
  803124
  803255
  810290
  813021
  813093
  814232
  817210
  827632
  827686
]
14.67 ms
(10.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
  480450
  510102
  497906
  720737
  792654
  597457
  782040
  600358
  740849
  511866
  762975
  729243
  393326
  402950
  477118
  424331
  531821
  724127
  441495
  814232
  541322
  716118
  657505
  708923
  717516
  749245
  758799
  725115
  508666
  547496
  803255
  795523
  730355
  817210
  827686
  776956
  417389
  489953
  440094
  419826
  758027
  547386
  775572
  782090
  783382
  810290
  769917
  801543
  813093
  493749
  603057
  803124
  453583
  745121
  547848
  827632
  545808
  453137
  512543
  559202
  445413
  704232
  785582
  752595
  542268
  681643
  738826
  791930
  449173
  451121
  451316
  447600
  556876
  441021
  528474
  548460
  670357
  696236
  565142
  782351
  419062
  436230
  752592
  386166
  421423
  542881
  487429
  758778
  711699
  561042
  432299
  441027
  504482
  666898
  813021
  441073
  427539
  443496
  446274
  468434
  493757
  450679
  497509
  544108
  616296
  777847
  782789
  453678
  499617
  499211
  507542
  520400
  541277
  412779
  530394
  544988
  663337
  646290
  655919
  713500
]
2.47 ms
(1.71%)
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
  386166
  393326
  402950
  412779
  417389
  419062
  419826
  421423
  424331
  427539
  432299
  436230
  440094
  441021
  441027
  441073
  441495
  443496
  445413
  446274
  447600
  449173
  450679
  451121
  451316
  453137
  453583
  453678
  468434
  477118
  480450
  487429
  489953
  493749
  493757
  497509
  497906
  499211
  499617
  504482
  507542
  508666
  510102
  511866
  512543
  520400
  528474
  530394
  531821
  541277
  541322
  542268
  542881
  544108
  544988
  545808
  547386
  547496
  547848
  548460
  556876
  559202
  561042
  565142
  597457
  600358
  603057
  616296
  646290
  655919
  657505
  663337
  666898
  670357
  681643
  696236
  704232
  708923
  711699
  713500
  716118
  717516
  720737
  724127
  725115
  729243
  730355
  738826
  740849
  745121
  749245
  752592
  752595
  758027
  758778
  758799
  762975
  769917
  775572
  776956
  777847
  782040
  782090
  782351
  782789
  783382
  785582
  791930
  792654
  795523
  801543
  803124
  803255
  810290
  813021
  813093
  814232
  817210
  827632
  827686
]
2.05 ms
(1.42%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "огромная дырка в жопе…"
]
1.91 ms
(1.32%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.50 ms
(1.04%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "большая большие дырк анал"
]
1.42 ms
(0.98%)
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.