Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
164.99 ms
(86.28%)
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
  210661
  382089
  384859
  389888
  391772
  393129
  393284
  397079
  401560
  401945
  417749
  423352
  423845
  424535
  424757
  435045
  436445
  436956
  448749
  452344
  455221
  459554
  460030
  460405
  461123
  461301
  461314
  461360
  466430
  475587
  475973
  478008
  478241
  480922
  494235
  506878
  512757
  514193
  514198
  521684
  525925
  527334
  537021
  546400
  549578
  550055
  553632
  567567
  569017
  573512
  574000
  588862
  591138
  592657
  599746
  599995
  601130
  602792
  606022
  609835
  609918
  612482
  617330
  625333
  636127
  636263
  638790
  650306
  661344
  664514
  678232
  680688
  681936
  691618
  692910
  696381
  698001
  705087
  705715
  707497
  713924
  715675
  716547
  720986
  721355
  721953
  722991
  725265
  725491
  732909
  736531
  740539
  740966
  745685
  756343
  757725
  760897
  761142
  762674
  765934
  767380
  768380
  768451
  769094
  769469
  770567
  777536
  778406
  783981
  785912
  786228
  786238
  786360
  786596
  795065
  809155
  809340
  825611
  827194
  827785
]
15.90 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
  391772
  827194
  825611
  809155
  809340
  210661
  527334
  716547
  480922
  423845
  460030
  461314
  461301
  397079
  459554
  417749
  573512
  549578
  617330
  713924
  546400
  691618
  692910
  698001
  650306
  601130
  606022
  636127
  592657
  599995
  636263
  740966
  786596
  769469
  722991
  512757
  382089
  466430
  567567
  569017
  680688
  720986
  721953
  609835
  599746
  625333
  778406
  725265
  769094
  770567
  786228
  725491
  732909
  736531
  756343
  740539
  760897
  762674
  768380
  707497
  715675
  436445
  393129
  525925
  514198
  786360
  448749
  553632
  514193
  609918
  785912
  478008
  475587
  423352
  478241
  460405
  455221
  389888
  664514
  696381
  588862
  521684
  506878
  550055
  705715
  661344
  678232
  681936
  721355
  574000
  638790
  591138
  602792
  612482
  705087
  537021
  494235
  393284
  424535
  424757
  435045
  827785
  452344
  461360
  786238
  777536
  783981
  765934
  768451
  745685
  767380
  757725
  761142
  795065
  384859
  475973
  401560
  401945
  436956
  461123
]
3.08 ms
(1.61%)
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
  210661
  382089
  384859
  389888
  391772
  393129
  393284
  397079
  401560
  401945
  417749
  423352
  423845
  424535
  424757
  435045
  436445
  436956
  448749
  452344
  455221
  459554
  460030
  460405
  461123
  461301
  461314
  461360
  466430
  475587
  475973
  478008
  478241
  480922
  494235
  506878
  512757
  514193
  514198
  521684
  525925
  527334
  537021
  546400
  549578
  550055
  553632
  567567
  569017
  573512
  574000
  588862
  591138
  592657
  599746
  599995
  601130
  602792
  606022
  609835
  609918
  612482
  617330
  625333
  636127
  636263
  638790
  650306
  661344
  664514
  678232
  680688
  681936
  691618
  692910
  696381
  698001
  705087
  705715
  707497
  713924
  715675
  716547
  720986
  721355
  721953
  722991
  725265
  725491
  732909
  736531
  740539
  740966
  745685
  756343
  757725
  760897
  761142
  762674
  765934
  767380
  768380
  768451
  769094
  769469
  770567
  777536
  778406
  783981
  785912
  786228
  786238
  786360
  786596
  795065
  809155
  809340
  825611
  827194
  827785
]
2.11 ms
(1.10%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur pickup"
]
1.83 ms
(0.96%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.72 ms
(0.90%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск пикап"
]
1.61 ms
(0.84%)
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.