Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
129.91 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
  150798
  187857
  188266
  381757
  385603
  391571
  397883
  407809
  439752
  440851
  454544
  465949
  466907
  468357
  469372
  477135
  478387
  483351
  490846
  493172
  493177
  495813
  510879
  513194
  513499
  514445
  526089
  531533
  531887
  532872
  534534
  536457
  538006
  538011
  539372
  544190
  549033
  549851
  553130
  555086
  557244
  559071
  559401
  563025
  563173
  566774
  591977
  604673
  614881
  619531
  620228
  620258
  620480
  627361
  627362
  629823
  660061
  660120
  669706
  670254
  672794
  680442
  693317
  700997
  705640
  710250
  715373
  720008
  720780
  724052
  726143
  726957
  727800
  729923
  730347
  730361
  731025
  734373
  735032
  740731
  740844
  741177
  744386
  750303
  756551
  759926
  759939
  761025
  761469
  761596
  765547
  767127
  769491
  772740
  792678
  794759
  794897
  795867
  796119
  796158
  796566
  799910
  800508
  801254
  802053
  802136
  802138
  802142
  802151
  803526
  803730
  807586
  810298
  817536
  820371
  824454
  824584
  826655
  826660
]
12.58 ms
(8.31%)
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
  614881
  792678
  803730
  729923
  744386
  763214
  726957
  730361
  726143
  672794
  629823
  761596
  802136
  150798
  794759
  187857
  824584
  727800
  478387
  440851
  454544
  826655
  693317
  555086
  705640
  407809
  539372
  557244
  563025
  563173
  559071
  591977
  439752
  538011
  493177
  514445
  660061
  772740
  510879
  490846
  381757
  720008
  759939
  796119
  731025
  767127
  627361
  735032
  769491
  715373
  483351
  700997
  385603
  465949
  559401
  619531
  397883
  513194
  493172
  660120
  620480
  710250
  549851
  826660
  817536
  807586
  802151
  188266
  495813
  544190
  810298
  466907
  477135
  566774
  669706
  796158
  802142
  801254
  795867
  802138
  802053
  759926
  803526
  796566
  549033
  756551
  761469
  730347
  526089
  604673
  627362
  799910
  469372
  536457
  538006
  513499
  824454
  820371
  720780
  741177
  750303
  740844
  761025
  794897
  680442
  531887
  532872
  534534
  531533
  468357
  670254
  553130
  620258
  620228
  800508
  734373
  740731
  724052
  765547
  391571
]
2.18 ms
(1.44%)
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
  150798
  187857
  188266
  381757
  385603
  391571
  397883
  407809
  439752
  440851
  454544
  465949
  466907
  468357
  469372
  477135
  478387
  483351
  490846
  493172
  493177
  495813
  510879
  513194
  513499
  514445
  526089
  531533
  531887
  532872
  534534
  536457
  538006
  538011
  539372
  544190
  549033
  549851
  553130
  555086
  557244
  559071
  559401
  563025
  563173
  566774
  591977
  604673
  614881
  619531
  620228
  620258
  620480
  627361
  627362
  629823
  660061
  660120
  669706
  670254
  672794
  680442
  693317
  700997
  705640
  710250
  715373
  720008
  720780
  724052
  726143
  726957
  727800
  729923
  730347
  730361
  731025
  734373
  735032
  740731
  740844
  741177
  744386
  750303
  756551
  759926
  759939
  761025
  761469
  761596
  765547
  767127
  769491
  772740
  792678
  794759
  794897
  795867
  796119
  796158
  796566
  799910
  800508
  801254
  802053
  802136
  802138
  802142
  802151
  803526
  803730
  807586
  810298
  817536
  820371
  824454
  824584
  826655
  826660
]
2.09 ms
(1.38%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "mature anal homemade"
]
1.67 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "mature анал домашн любительск"
]
1.64 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.37 ms
(0.90%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "mature анал домашн любительск"
]

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.