Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
172.81 ms
(87.80%)
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
  256487
  387180
  387925
  420072
  434075
  445273
  457743
  469228
  469251
  480495
  511696
  515810
  528034
  529785
  529885
  534036
  534857
  535064
  535318
  537384
  538318
  538753
  539609
  539611
  540774
  541563
  546036
  548093
  548919
  554788
  556600
  558453
  559342
  562054
  563942
  566008
  572959
  573134
  575299
  583606
  585832
  589757
  592523
  602218
  602245
  603567
  606023
  608000
  614485
  614582
  625178
  630120
  633477
  634263
  636444
  644539
  646042
  649480
  651066
  651947
  652286
  661701
  663540
  663796
  664235
  666046
  666182
  666183
  669261
  678254
  678895
  683270
  690726
  692971
  694172
  695551
  696108
  698342
  702557
  706555
  707509
  708301
  709504
  710720
  710777
  713768
  720529
  722317
  730697
  730920
  738263
  739787
  742325
  742332
  751313
  752458
  757521
  765627
  771909
  772855
  773110
  776796
  778887
  781950
  784125
  786090
  787523
  789625
  791169
  792104
  792438
  797369
  804489
  812198
  812479
  813629
  819349
  825449
  826354
  827624
]
13.92 ms
(7.07%)
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
  387180
  583606
  566008
  663540
  387925
  445273
  813629
  826354
  819349
  827624
  529785
  538753
  469228
  541563
  554788
  558453
  575299
  646042
  649480
  661701
  664235
  695551
  652286
  666182
  690726
  694172
  696108
  709504
  666183
  669261
  698342
  563942
  585832
  589757
  614485
  633477
  602218
  614582
  630120
  592523
  603567
  606023
  608000
  634263
  636444
  644539
  776796
  786090
  791169
  792104
  804489
  789625
  792438
  812479
  773110
  797369
  738263
  742332
  772855
  730920
  742325
  752458
  739787
  751313
  757521
  730697
  765627
  771909
  602245
  713768
  720529
  778887
  781950
  784125
  787523
  812198
  420072
  256487
  535318
  528034
  515810
  562054
  625178
  511696
  434075
  825449
  469251
  480495
  457743
  529885
  537384
  538318
  539609
  540774
  534036
  534857
  535064
  539611
  559342
  573134
  546036
  548093
  548919
  556600
  572959
  651947
  683270
  707509
  708301
  678254
  678895
  692971
  702557
  706555
  722317
  651066
  663796
  666046
  710720
  710777
]
3.35 ms
(1.70%)
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
  256487
  387180
  387925
  420072
  434075
  445273
  457743
  469228
  469251
  480495
  511696
  515810
  528034
  529785
  529885
  534036
  534857
  535064
  535318
  537384
  538318
  538753
  539609
  539611
  540774
  541563
  546036
  548093
  548919
  554788
  556600
  558453
  559342
  562054
  563942
  566008
  572959
  573134
  575299
  583606
  585832
  589757
  592523
  602218
  602245
  603567
  606023
  608000
  614485
  614582
  625178
  630120
  633477
  634263
  636444
  644539
  646042
  649480
  651066
  651947
  652286
  661701
  663540
  663796
  664235
  666046
  666182
  666183
  669261
  678254
  678895
  683270
  690726
  692971
  694172
  695551
  696108
  698342
  702557
  706555
  707509
  708301
  709504
  710720
  710777
  713768
  720529
  722317
  730697
  730920
  738263
  739787
  742325
  742332
  751313
  752458
  757521
  765627
  771909
  772855
  773110
  776796
  778887
  781950
  784125
  786090
  787523
  789625
  791169
  792104
  792438
  797369
  804489
  812198
  812479
  813629
  819349
  825449
  826354
  827624
]
1.94 ms
(0.98%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.89 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "erotic video"
]
1.53 ms
(0.78%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "эротик video"
]
1.39 ms
(0.71%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "эротик video"
]

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.