Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
394.37 ms
(93.65%)
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
  396540
  401927
  404035
  410128
  412332
  415833
  417564
  420527
  420594
  422398
  425331
  427092
  430949
  433930
  443118
  445747
  448307
  450646
  450851
  451583
  453666
  455804
  456688
  457321
  457540
  457674
  458436
  459265
  461005
  461886
  470347
  471759
  475010
  475071
  475550
  479286
  482191
  486086
  487313
  490720
  494686
  495303
  496693
  498151
  499155
  502884
  504695
  505189
  505858
  509005
  509666
  518380
  523995
  524513
  525542
  525951
  527931
  529277
  540229
  541041
  542026
  542854
  543593
  546833
  548510
  557382
  558210
  559051
  562118
  564566
  565001
  567698
  568743
  578109
  578961
  582568
  590188
  593122
  598420
  601705
  610629
  610773
  614213
  614258
  625294
  626824
  631185
  646202
  650218
  661547
  662861
  667002
  680375
  682625
  689136
  689736
  691219
  691578
  693572
  705516
  705742
  719644
  719837
  720421
  729629
  745557
  758404
  758691
  765055
  774214
  778089
  780786
  782978
  783161
  791778
  793050
  798698
  800325
  808011
  819454
]
16.28 ms
(3.87%)
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
  443118
  420594
  646202
  498151
  396540
  631185
  662861
  471759
  496693
  691219
  562118
  691578
  800325
  504695
  499155
  705742
  546833
  568743
  567698
  791778
  470347
  610629
  541041
  451583
  525542
  448307
  457321
  682625
  614213
  445747
  798698
  412332
  518380
  745557
  729629
  540229
  529277
  778089
  680375
  479286
  719644
  610773
  461005
  505189
  578109
  425331
  494686
  509666
  650218
  450646
  582568
  614258
  417564
  487313
  422398
  502884
  459265
  774214
  455804
  819454
  693572
  542026
  410128
  705516
  598420
  401927
  720421
  548510
  524513
  490720
  404035
  475550
  525951
  593122
  689736
  689136
  782978
  758691
  765055
  430949
  453666
  509005
  808011
  457540
  486086
  625294
  475071
  450851
  667002
  495303
  758404
  793050
  475010
  458436
  564566
  415833
  557382
  559051
  565001
  601705
  780786
  523995
  433930
  626824
  427092
  527931
  461886
  457674
  661547
  456688
  783161
  505858
  558210
  578961
  482191
  543593
  590188
  420527
  719837
  542854
]
2.69 ms
(0.64%)
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
  396540
  401927
  404035
  410128
  412332
  415833
  417564
  420527
  420594
  422398
  425331
  427092
  430949
  433930
  443118
  445747
  448307
  450646
  450851
  451583
  453666
  455804
  456688
  457321
  457540
  457674
  458436
  459265
  461005
  461886
  470347
  471759
  475010
  475071
  475550
  479286
  482191
  486086
  487313
  490720
  494686
  495303
  496693
  498151
  499155
  502884
  504695
  505189
  505858
  509005
  509666
  518380
  523995
  524513
  525542
  525951
  527931
  529277
  540229
  541041
  542026
  542854
  543593
  546833
  548510
  557382
  558210
  559051
  562118
  564566
  565001
  567698
  568743
  578109
  578961
  582568
  590188
  593122
  598420
  601705
  610629
  610773
  614213
  614258
  625294
  626824
  631185
  646202
  650218
  661547
  662861
  667002
  680375
  682625
  689136
  689736
  691219
  691578
  693572
  705516
  705742
  719644
  719837
  720421
  729629
  745557
  758404
  758691
  765055
  774214
  778089
  780786
  782978
  783161
  791778
  793050
  798698
  800325
  808011
  819454
]
2.18 ms
(0.52%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "глубокийминет минет оральн секс в гор природ"
]
2.17 ms
(0.51%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "глубокая глотка в гор%…"
]
1.84 ms
(0.44%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.57 ms
(0.37%)
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.