Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.43 ms
(81.58%)
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
  7213
  123541
  185109
  194687
  271638
  278236
  311734
  327786
  384551
  385955
  387175
  388350
  388551
  392672
  397209
  397763
  397766
  400938
  407250
  409931
  410836
  413062
  413240
  416335
  416346
  417005
  420869
  421037
  421189
  421492
  421792
  424207
  426920
  426990
  429065
  429185
  431167
  434914
  437019
  438712
  439146
  439264
  439345
  441166
  442444
  444515
  445078
  446509
  447405
  450585
  450647
  450765
  450854
  451541
  451691
  452372
  452596
  453033
  453831
  454028
  454643
  455588
  456209
  456234
  457694
  458055
  458098
  458362
  460251
  460318
  462231
  463174
  464284
  464443
  465411
  466105
  467223
  467992
  469036
  469197
  471346
  471526
  472587
  472873
  475606
  476149
  477848
  478519
  480242
  483329
  488528
  488679
  489210
  490168
  491602
  501730
  503082
  503155
  504564
  506072
  509847
  509916
  510495
  512293
  512586
  512647
  513675
  521869
  523505
  538224
  539155
  539463
  558045
  558618
  571736
  587054
  587587
  622297
  696126
  809217
]
18.59 ms
(11.20%)
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
  444515
  439146
  458362
  488679
  510495
  506072
  467223
  558618
  809217
  327786
  458098
  426920
  441166
  469197
  480242
  392672
  421189
  387175
  467992
  472587
  421037
  512293
  512647
  503082
  513675
  509916
  538224
  384551
  397209
  413062
  409931
  451691
  452596
  456209
  465411
  475606
  503155
  469036
  571736
  587054
  453831
  458055
  463174
  439264
  457694
  478519
  434914
  426990
  450854
  456234
  454028
  450765
  454643
  539155
  460251
  464284
  587587
  194687
  407250
  466105
  388350
  450647
  385955
  421792
  442444
  445078
  437019
  450585
  464443
  504564
  512586
  696126
  622297
  185109
  439345
  446509
  462231
  471346
  388551
  429185
  452372
  483329
  491602
  523505
  438712
  460318
  477848
  539463
  490168
  455588
  476149
  278236
  424207
  397763
  417005
  453033
  400938
  397766
  416335
  489210
  123541
  416346
  413240
  509847
  311734
  429065
  410836
  471526
  558045
  451541
  420869
  472873
  431167
  447405
  501730
  488528
  521869
  271638
  7213
  421492
]
4.58 ms
(2.76%)
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
  7213
  123541
  185109
  194687
  271638
  278236
  311734
  327786
  384551
  385955
  387175
  388350
  388551
  392672
  397209
  397763
  397766
  400938
  407250
  409931
  410836
  413062
  413240
  416335
  416346
  417005
  420869
  421037
  421189
  421492
  421792
  424207
  426920
  426990
  429065
  429185
  431167
  434914
  437019
  438712
  439146
  439264
  439345
  441166
  442444
  444515
  445078
  446509
  447405
  450585
  450647
  450765
  450854
  451541
  451691
  452372
  452596
  453033
  453831
  454028
  454643
  455588
  456209
  456234
  457694
  458055
  458098
  458362
  460251
  460318
  462231
  463174
  464284
  464443
  465411
  466105
  467223
  467992
  469036
  469197
  471346
  471526
  472587
  472873
  475606
  476149
  477848
  478519
  480242
  483329
  488528
  488679
  489210
  490168
  491602
  501730
  503082
  503155
  504564
  506072
  509847
  509916
  510495
  512293
  512586
  512647
  513675
  521869
  523505
  538224
  539155
  539463
  558045
  558618
  571736
  587054
  587587
  622297
  696126
  809217
]
2.05 ms
(1.23%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.93 ms
(1.16%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "секс ласки"
]
1.75 ms
(1.06%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "секс ласк"
]
1.67 ms
(1.01%)
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.