Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
130.16 ms
(84.34%)
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
  385288
  388316
  392213
  400867
  436071
  438312
  439683
  443795
  451515
  454260
  454345
  454351
  455331
  459445
  460715
  460757
  460890
  461400
  461936
  462193
  466037
  466127
  466252
  469113
  470147
  470826
  471076
  472810
  472814
  473645
  477975
  478394
  478727
  479073
  479391
  480638
  480851
  483451
  483692
  483978
  485625
  488703
  490899
  494933
  495484
  497042
  497480
  499291
  499956
  500432
  501992
  502562
  503016
  511524
  512823
  514015
  515651
  520919
  521415
  523165
  525452
  525741
  538213
  545673
  546001
  546377
  547619
  547738
  547791
  547794
  547796
  551560
  551619
  551876
  552346
  554222
  554238
  556490
  556881
  558158
  559047
  559066
  560038
  560422
  560645
  561357
  561462
  563038
  564955
  567409
  572194
  572203
  575180
  575460
  575555
  578538
  582583
  587894
  595870
  598032
  598201
  598554
  600318
  605011
  619034
  619059
  619091
  620058
  626872
  643986
  659204
  662376
  668139
  690745
  751262
  761141
  765810
  771392
  778828
  791858
]
14.50 ms
(9.40%)
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
  771392
  751262
  761141
  765810
  605011
  778828
  791858
  392213
  436071
  438312
  439683
  480851
  385288
  451515
  455331
  459445
  462193
  466252
  469113
  478727
  400867
  478394
  479391
  454345
  454351
  461400
  460715
  460890
  472814
  514015
  483451
  488703
  499291
  483692
  483978
  500432
  501992
  520919
  525741
  538213
  564955
  546377
  668139
  546001
  598032
  598201
  643986
  595870
  461936
  466037
  477975
  480638
  443795
  454260
  388316
  460757
  471076
  473645
  470826
  479073
  466127
  515651
  485625
  503016
  511524
  523165
  525452
  502562
  512823
  490899
  497480
  499956
  521415
  472810
  470147
  494933
  495484
  497042
  545673
  547791
  551619
  560422
  561462
  572194
  572203
  575555
  582583
  547738
  547796
  556490
  556881
  558158
  560645
  563038
  547794
  551560
  552346
  554222
  559066
  560038
  567409
  575180
  578538
  662376
  659204
  690745
  547619
  551876
  554238
  559047
  561357
  575460
  619091
  619059
  626872
  587894
  598554
  600318
  619034
  620058
]
2.83 ms
(1.83%)
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
  385288
  388316
  392213
  400867
  436071
  438312
  439683
  443795
  451515
  454260
  454345
  454351
  455331
  459445
  460715
  460757
  460890
  461400
  461936
  462193
  466037
  466127
  466252
  469113
  470147
  470826
  471076
  472810
  472814
  473645
  477975
  478394
  478727
  479073
  479391
  480638
  480851
  483451
  483692
  483978
  485625
  488703
  490899
  494933
  495484
  497042
  497480
  499291
  499956
  500432
  501992
  502562
  503016
  511524
  512823
  514015
  515651
  520919
  521415
  523165
  525452
  525741
  538213
  545673
  546001
  546377
  547619
  547738
  547791
  547794
  547796
  551560
  551619
  551876
  552346
  554222
  554238
  556490
  556881
  558158
  559047
  559066
  560038
  560422
  560645
  561357
  561462
  563038
  564955
  567409
  572194
  572203
  575180
  575460
  575555
  578538
  582583
  587894
  595870
  598032
  598201
  598554
  600318
  605011
  619034
  619059
  619091
  620058
  626872
  643986
  659204
  662376
  668139
  690745
  751262
  761141
  765810
  771392
  778828
  791858
]
1.97 ms
(1.27%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "платье русские"
]
1.84 ms
(1.19%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.67 ms
(1.08%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "плат русск"
]
1.36 ms
(0.88%)
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.