Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.64 ms
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
2 2.10 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "face to face"
]
3 14.31 ms
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
  791995
  792398
  793753
  794481
  795104
  798117
  801578
  807008
  808853
  810593
  811033
  729863
  734229
  734343
  739915
  742306
  744486
  750432
  752176
  752197
  754122
  757280
  760696
  761397
  762246
  767482
  783381
  783450
  783929
  785944
  786032
  787576
  788840
  789154
  789165
  790838
  791785
  794193
  799739
  800118
  803256
  803443
  733789
  734238
  738299
  748335
  771953
  724501
  724697
  727884
  734856
  746042
  747169
  759812
  765029
  768126
  768363
  771849
  726373
  728814
  734350
  734354
  741045
  744158
  744439
  746616
  749138
  749153
  762970
  763064
  763122
  763334
  769340
  772251
  729269
  731753
  740018
  748767
  758292
  765197
  765770
  768023
  769350
  772922
  773498
  773829
  612578
  624691
  697558
  701200
  701939
  709323
  719755
  774880
  776464
  777199
  777479
  777612
  778797
  778939
  779036
  779949
  782774
  782939
  783752
  788979
  790159
  790824
  790952
  791049
  791491
  792197
  793878
  795766
  800273
  800994
  802976
  808529
  332765
  444639
]
4 4.33 ms
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
  332765
  444639
  612578
  624691
  697558
  701200
  701939
  709323
  719755
  724501
  724697
  726373
  727884
  728814
  729269
  729863
  731753
  733789
  734229
  734238
  734343
  734350
  734354
  734856
  738299
  739915
  740018
  741045
  742306
  744158
  744439
  744486
  746042
  746616
  747169
  748335
  748767
  749138
  749153
  750432
  752176
  752197
  754122
  757280
  758292
  759812
  760696
  761397
  762246
  762970
  763064
  763122
  763334
  765029
  765197
  765770
  767482
  768023
  768126
  768363
  769340
  769350
  771849
  771953
  772251
  772922
  773498
  773829
  774880
  776464
  777199
  777479
  777612
  778797
  778939
  779036
  779949
  782774
  782939
  783381
  783450
  783752
  783929
  785944
  786032
  787576
  788840
  788979
  789154
  789165
  790159
  790824
  790838
  790952
  791049
  791491
  791785
  791995
  792197
  792398
  793753
  793878
  794193
  794481
  795104
  795766
  798117
  799739
  800118
  800273
  800994
  801578
  802976
  803256
  803443
  807008
  808529
  808853
  810593
  811033
]
5 186.63 ms
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
  332765
  444639
  612578
  624691
  697558
  701200
  701939
  709323
  719755
  724501
  724697
  726373
  727884
  728814
  729269
  729863
  731753
  733789
  734229
  734238
  734343
  734350
  734354
  734856
  738299
  739915
  740018
  741045
  742306
  744158
  744439
  744486
  746042
  746616
  747169
  748335
  748767
  749138
  749153
  750432
  752176
  752197
  754122
  757280
  758292
  759812
  760696
  761397
  762246
  762970
  763064
  763122
  763334
  765029
  765197
  765770
  767482
  768023
  768126
  768363
  769340
  769350
  771849
  771953
  772251
  772922
  773498
  773829
  774880
  776464
  777199
  777479
  777612
  778797
  778939
  779036
  779949
  782774
  782939
  783381
  783450
  783752
  783929
  785944
  786032
  787576
  788840
  788979
  789154
  789165
  790159
  790824
  790838
  790952
  791049
  791491
  791785
  791995
  792197
  792398
  793753
  793878
  794193
  794481
  795104
  795766
  798117
  799739
  800118
  800273
  800994
  801578
  802976
  803256
  803443
  807008
  808529
  808853
  810593
  811033
]
6 1.89 ms
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "face face"
]
7 1.52 ms
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "face face"
]

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.