Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.51 ms
(85.79%)
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
  80035
  102250
  303426
  338338
  398428
  422123
  472646
  504683
  521731
  529851
  532334
  540949
  543619
  548910
  576194
  617377
  626943
  629776
  629979
  630111
  635334
  642094
  645773
  648872
  651901
  661909
  668742
  670065
  683281
  692682
  716602
  718141
  718397
  722123
  724793
  728144
  728918
  730985
  732670
  733468
  733519
  735501
  735841
  736259
  742944
  743794
  743874
  746216
  747220
  748696
  755238
  759033
  760497
  761259
  761444
  766875
  769473
  773781
  777461
  779442
  782484
  784426
  786921
  787269
  789622
  790329
  790364
  791841
  793198
  793731
  793747
  794586
  794725
  795787
  796346
  799378
  799787
  803209
  803682
  810330
  817204
  817517
  818050
  818614
  818679
  819413
  819728
  819987
  820202
  821787
  821804
  823258
  823554
  823751
  823763
  823897
  824003
  824098
  824117
  824220
  824721
  824796
  824944
  824970
  824973
  825118
  825180
  825245
  825306
  825352
  825380
  825391
  825711
  825850
  825881
  826929
  826932
  826933
  827647
]
10.54 ms
(7.38%)
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
  825306
  521731
  543619
  576194
  668742
  645773
  626943
  777461
  790329
  794725
  732670
  819987
  735501
  784426
  786921
  779442
  794586
  823897
  824721
  825245
  825118
  825352
  827647
  722123
  803682
  728144
  767970
  760497
  789622
  548910
  651901
  736259
  338338
  824973
  819413
  825180
  795787
  422123
  824944
  824796
  810330
  824003
  824970
  825850
  825881
  823763
  820202
  826932
  769473
  730985
  773781
  718397
  398428
  793198
  747220
  748696
  799378
  670065
  818050
  818679
  818614
  826933
  823554
  824098
  825711
  790364
  799787
  803209
  793731
  759033
  761444
  724793
  796346
  823258
  617377
  791841
  819728
  742944
  661909
  642094
  743874
  824220
  733468
  532334
  80035
  303426
  821787
  824117
  825391
  823751
  826929
  821804
  825380
  746216
  755238
  766875
  102250
  540949
  782484
  761259
  817204
  504683
  529851
  648872
  683281
  692682
  718141
  629776
  630111
  635334
  728918
  733519
  735841
  743794
  629979
  787269
  817517
  793747
  716602
  472646
]
2.74 ms
(1.92%)
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
  80035
  102250
  303426
  338338
  398428
  422123
  472646
  504683
  521731
  529851
  532334
  540949
  543619
  548910
  576194
  617377
  626943
  629776
  629979
  630111
  635334
  642094
  645773
  648872
  651901
  661909
  668742
  670065
  683281
  692682
  716602
  718141
  718397
  722123
  724793
  728144
  728918
  730985
  732670
  733468
  733519
  735501
  735841
  736259
  742944
  743794
  743874
  746216
  747220
  748696
  755238
  759033
  760497
  761259
  761444
  766875
  769473
  773781
  777461
  779442
  782484
  784426
  786921
  787269
  789622
  790329
  790364
  791841
  793198
  793731
  793747
  794586
  794725
  795787
  796346
  799378
  799787
  803209
  803682
  810330
  817204
  817517
  818050
  818614
  818679
  819413
  819728
  819987
  820202
  821787
  821804
  823258
  823554
  823751
  823763
  823897
  824003
  824098
  824117
  824220
  824721
  824796
  824944
  824970
  824973
  825118
  825180
  825245
  825306
  825352
  825380
  825391
  825711
  825850
  825881
  826929
  826932
  826933
  827647
]
1.87 ms
(1.31%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "любительский минет до…"
]
1.76 ms
(1.23%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск минет оральн секс"
]
1.71 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск минет оральн секс"
]
1.67 ms
(1.17%)
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.