Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
145.22 ms
(86.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
  396471
  461997
  466940
  476923
  516061
  516738
  537628
  548994
  550546
  552103
  564007
  565202
  567933
  590654
  591939
  594359
  617642
  624935
  628027
  629441
  632483
  638524
  641200
  647192
  652551
  652554
  653564
  660455
  667820
  670079
  685259
  685429
  685612
  688394
  690494
  690925
  691351
  691405
  693433
  693437
  694164
  694175
  695467
  697675
  699162
  701038
  701400
  702350
  702623
  704432
  704434
  705008
  706439
  707298
  708457
  710027
  712812
  714105
  714572
  714693
  718356
  719283
  720987
  722438
  725766
  730792
  730974
  732336
  737250
  738052
  739913
  740211
  740738
  742207
  745888
  745899
  748832
  748844
  749474
  749779
  749997
  755066
  759051
  762019
  763413
  766303
  767678
  772865
  772868
  773834
  775407
  776679
  777633
  781339
  781568
  782084
  786158
  786804
  788649
  789097
  790395
  790718
  791481
  791795
  793557
  794145
  794523
  795186
  795223
  796533
  796761
  804708
  804912
  810545
  813456
  813872
  813876
  813881
  813885
]
11.70 ms
(6.99%)
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
  516738
  714572
  670079
  795223
  730792
  796533
  796761
  693437
  694164
  694175
  768748
  794523
  742207
  725766
  766303
  772868
  793557
  564007
  788649
  739913
  740738
  624935
  567933
  702350
  707298
  714105
  712812
  720987
  714693
  628027
  629441
  591939
  790395
  810545
  748832
  745888
  749997
  641200
  719283
  660455
  685429
  691405
  647192
  695467
  804708
  763413
  772865
  781339
  781568
  461997
  466940
  476923
  804912
  552103
  632483
  786804
  749474
  737250
  548994
  685612
  691351
  693433
  396471
  813872
  813881
  813885
  516061
  550546
  690925
  697675
  699162
  701038
  690494
  704434
  705008
  706439
  718356
  667820
  704432
  590654
  594359
  638524
  790718
  775407
  786158
  755066
  767678
  789097
  794145
  730974
  740211
  749779
  762019
  773834
  748844
  759051
  732336
  738052
  745899
  701400
  776679
  791795
  795186
  813456
  708457
  702623
  777633
  791481
  813876
  537628
  652551
  685259
  710027
  653564
  652554
  688394
  722438
  565202
  617642
  782084
]
3.44 ms
(2.06%)
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
  396471
  461997
  466940
  476923
  516061
  516738
  537628
  548994
  550546
  552103
  564007
  565202
  567933
  590654
  591939
  594359
  617642
  624935
  628027
  629441
  632483
  638524
  641200
  647192
  652551
  652554
  653564
  660455
  667820
  670079
  685259
  685429
  685612
  688394
  690494
  690925
  691351
  691405
  693433
  693437
  694164
  694175
  695467
  697675
  699162
  701038
  701400
  702350
  702623
  704432
  704434
  705008
  706439
  707298
  708457
  710027
  712812
  714105
  714572
  714693
  718356
  719283
  720987
  722438
  725766
  730792
  730974
  732336
  737250
  738052
  739913
  740211
  740738
  742207
  745888
  745899
  748832
  748844
  749474
  749779
  749997
  755066
  759051
  762019
  763413
  766303
  767678
  772865
  772868
  773834
  775407
  776679
  777633
  781339
  781568
  782084
  786158
  786804
  788649
  789097
  790395
  790718
  791481
  791795
  793557
  794145
  794523
  795186
  795223
  796533
  796761
  804708
  804912
  810545
  813456
  813872
  813876
  813881
  813885
]
2.01 ms
(1.20%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.96 ms
(1.17%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "молодые девушки с пар%…"
]
1.69 ms
(1.01%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "молодая девушк пар"
]
1.30 ms
(0.77%)
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.