Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
197.18 ms
(89.74%)
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
  21210
  186592
  281431
  345780
  382665
  382993
  383923
  385494
  385812
  388401
  391944
  395252
  411096
  416240
  420333
  424566
  434306
  443843
  445972
  446788
  453154
  457567
  462232
  466389
  468196
  471017
  471019
  471029
  471069
  473096
  477374
  486141
  492664
  496471
  496842
  496846
  499927
  510923
  514031
  515024
  526460
  529372
  529919
  531593
  531760
  532476
  534732
  537162
  537480
  539770
  541136
  541144
  550367
  557827
  557921
  558162
  559415
  559420
  562542
  563687
  563688
  565290
  569564
  571050
  571094
  575391
  576490
  577008
  578177
  578196
  581130
  584304
  584985
  588811
  592948
  592966
  605387
  609551
  614844
  620880
  627060
  630129
  633190
  634877
  635775
  642273
  645813
  650618
  650685
  659475
  660028
  661535
  666024
  666155
  667987
  693254
  694619
  694638
  706041
  714332
  715420
  733549
  736047
  736094
  748431
  750514
  752848
  776414
  789444
  794718
  796494
  796860
  799636
  801804
  804432
  804713
  811125
  813202
  814297
  824731
]
13.32 ms
(6.06%)
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
  577008
  592966
  21210
  537162
  383923
  388401
  391944
  571050
  666024
  550367
  466389
  477374
  811125
  434306
  424566
  385494
  411096
  420333
  416240
  814297
  445972
  462232
  473096
  471017
  471019
  537480
  529372
  532476
  529919
  531760
  496846
  534732
  558162
  562542
  571094
  578177
  541144
  563687
  693254
  650685
  661535
  694619
  694638
  706041
  715420
  650618
  660028
  666155
  667987
  569564
  592948
  620880
  633190
  642273
  588811
  635775
  605387
  609551
  789444
  799636
  801804
  804432
  804713
  750514
  736094
  733549
  752848
  736047
  748431
  614844
  627060
  630129
  776414
  796494
  796860
  813202
  443843
  395252
  471029
  514031
  492664
  486141
  471069
  557921
  186592
  281431
  345780
  824731
  457567
  515024
  496471
  559420
  557827
  559415
  634877
  794718
  382665
  385812
  382993
  584985
  446788
  453154
  496842
  499927
  526460
  531593
  539770
  510923
  468196
  576490
  541136
  563688
  578196
  581130
  584304
  565290
  575391
  659475
  714332
  645813
]
2.82 ms
(1.28%)
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
  21210
  186592
  281431
  345780
  382665
  382993
  383923
  385494
  385812
  388401
  391944
  395252
  411096
  416240
  420333
  424566
  434306
  443843
  445972
  446788
  453154
  457567
  462232
  466389
  468196
  471017
  471019
  471029
  471069
  473096
  477374
  486141
  492664
  496471
  496842
  496846
  499927
  510923
  514031
  515024
  526460
  529372
  529919
  531593
  531760
  532476
  534732
  537162
  537480
  539770
  541136
  541144
  550367
  557827
  557921
  558162
  559415
  559420
  562542
  563687
  563688
  565290
  569564
  571050
  571094
  575391
  576490
  577008
  578177
  578196
  581130
  584304
  584985
  588811
  592948
  592966
  605387
  609551
  614844
  620880
  627060
  630129
  633190
  634877
  635775
  642273
  645813
  650618
  650685
  659475
  660028
  661535
  666024
  666155
  667987
  693254
  694619
  694638
  706041
  714332
  715420
  733549
  736047
  736094
  748431
  750514
  752848
  776414
  789444
  794718
  796494
  796860
  799636
  801804
  804432
  804713
  811125
  813202
  814297
  824731
]
1.67 ms
(0.76%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая соло волосатая"
]
1.65 ms
(0.75%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy solo hairy"
]
1.61 ms
(0.73%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.48 ms
(0.67%)
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.