Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.40 ms
(87.41%)
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
  382661
  382931
  392069
  396816
  397063
  398724
  441541
  496245
  521742
  530175
  530261
  530595
  540983
  553470
  578353
  580109
  580606
  588110
  592177
  592867
  616395
  617854
  630578
  632938
  638131
  646076
  655170
  668034
  674850
  676156
  680879
  681456
  696067
  710432
  711000
  716637
  720152
  727442
  727683
  728761
  728938
  730479
  730857
  734327
  734432
  739016
  739087
  740974
  741138
  744613
  745289
  745923
  747425
  748108
  748661
  753034
  756290
  756403
  757571
  757804
  761224
  763357
  764105
  764515
  764530
  766140
  766887
  767291
  768187
  768803
  770204
  770375
  772799
  773402
  778096
  778122
  778776
  778930
  779405
  781186
  782525
  782962
  783950
  784171
  784195
  786702
  788062
  789899
  790216
  790865
  791630
  792015
  792264
  792702
  793953
  795002
  796406
  796765
  798027
  800800
  801310
  801677
  802788
  802856
  806229
  807932
  810876
  817988
  818704
  819644
  819936
  820536
  821731
  822571
  822726
  825055
  825246
]
13.56 ms
(7.21%)
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
  768803
  768187
  825246
  739087
  773537
  818704
  821731
  822571
  817988
  530261
  676156
  681456
  696067
  680879
  778930
  789899
  781186
  792264
  784171
  784195
  767291
  770204
  757571
  744613
  740974
  772799
  793953
  382931
  810876
  727683
  728761
  764515
  802788
  496245
  530595
  578353
  655170
  588110
  778776
  728938
  761224
  773402
  741138
  756403
  782525
  397063
  441541
  720152
  779405
  807932
  734432
  764105
  730479
  711000
  392069
  382661
  819644
  820536
  822726
  819936
  530175
  580109
  646076
  674850
  592177
  616395
  778122
  786702
  791630
  795002
  801677
  796765
  727442
  788062
  798027
  801310
  730857
  734327
  745289
  747425
  756290
  770375
  764530
  745923
  753034
  766140
  632938
  782962
  792702
  398724
  396816
  668034
  630578
  716637
  790216
  790865
  521742
  553470
  780457
  778096
  796406
  802856
  757804
  766887
  748661
  762511
  763357
  617854
  638131
  783950
  792015
  806229
  825055
  540983
  580606
  710432
  592867
  800800
  739016
  748108
]
3.64 ms
(1.94%)
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
  382661
  382931
  392069
  396816
  397063
  398724
  441541
  496245
  521742
  530175
  530261
  530595
  540983
  553470
  578353
  580109
  580606
  588110
  592177
  592867
  616395
  617854
  630578
  632938
  638131
  646076
  655170
  668034
  674850
  676156
  680879
  681456
  696067
  710432
  711000
  716637
  720152
  727442
  727683
  728761
  728938
  730479
  730857
  734327
  734432
  739016
  739087
  740974
  741138
  744613
  745289
  745923
  747425
  748108
  748661
  753034
  756290
  756403
  757571
  757804
  761224
  763357
  764105
  764515
  764530
  766140
  766887
  767291
  768187
  768803
  770204
  770375
  772799
  773402
  778096
  778122
  778776
  778930
  779405
  781186
  782525
  782962
  783950
  784171
  784195
  786702
  788062
  789899
  790216
  790865
  791630
  792015
  792264
  792702
  793953
  795002
  796406
  796765
  798027
  800800
  801310
  801677
  802788
  802856
  806229
  807932
  810876
  817988
  818704
  819644
  819936
  820536
  821731
  822571
  822726
  825055
  825246
]
1.83 ms
(0.97%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "little секс"
]
1.74 ms
(0.93%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "little sex"
]
1.45 ms
(0.77%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.45 ms
(0.77%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "little секс"
]

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.