Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
135.92 ms
(85.47%)
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
  154187
  295616
  305892
  368536
  383076
  397772
  400620
  402588
  403870
  412858
  414005
  423459
  423471
  459291
  463953
  504028
  517479
  523234
  530821
  531658
  537504
  549012
  549119
  558612
  573356
  582469
  612257
  616680
  630294
  630743
  636458
  651729
  655900
  660418
  667279
  668674
  671454
  671686
  676442
  677026
  680825
  692115
  698343
  698454
  699246
  702005
  705200
  708061
  714953
  715806
  716779
  717664
  718461
  719916
  720730
  721033
  721876
  722022
  722089
  726928
  729295
  729789
  730333
  731187
  733051
  733571
  736233
  737309
  740420
  741953
  742791
  746089
  746807
  747982
  748054
  755938
  756253
  757535
  759008
  759943
  760418
  764960
  765028
  765334
  766317
  766493
  768363
  775382
  775693
  777118
  778222
  782042
  783810
  787235
  787888
  789445
  791874
  793043
  793363
  793498
  793907
  796040
  796095
  796235
  796591
  797969
  798285
  800800
  802417
  805196
  808053
  811769
  812644
  812980
  813182
  815472
  818036
  821797
  825539
]
13.19 ms
(8.29%)
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
  530821
  721033
  716779
  805196
  791874
  729295
  747982
  719916
  789445
  796591
  812980
  403870
  668674
  383076
  397772
  702005
  715806
  775382
  800800
  793907
  808053
  731187
  722089
  793043
  825539
  815472
  680825
  671454
  677026
  793363
  796040
  762511
  741953
  414005
  818036
  720730
  802417
  787235
  796095
  400620
  821797
  660418
  717664
  798285
  766493
  759008
  733051
  740420
  742791
  748054
  766317
  630294
  154187
  459291
  523234
  783810
  755938
  671686
  651729
  729789
  295616
  368536
  517479
  676442
  718461
  616680
  764960
  793498
  402588
  573356
  692115
  708061
  722022
  655900
  699246
  721876
  636458
  782042
  775693
  797969
  737309
  756253
  730333
  733571
  765334
  612257
  549012
  630743
  777118
  812644
  778222
  736233
  760418
  757535
  412858
  423459
  423471
  463953
  531658
  537504
  582469
  558612
  705200
  667279
  698343
  698454
  714953
  549119
  726928
  811769
  765028
  768363
  746089
  746807
  787888
  796235
  813182
  504028
  305892
  759943
]
2.67 ms
(1.68%)
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
  154187
  295616
  305892
  368536
  383076
  397772
  400620
  402588
  403870
  412858
  414005
  423459
  423471
  459291
  463953
  504028
  517479
  523234
  530821
  531658
  537504
  549012
  549119
  558612
  573356
  582469
  612257
  616680
  630294
  630743
  636458
  651729
  655900
  660418
  667279
  668674
  671454
  671686
  676442
  677026
  680825
  692115
  698343
  698454
  699246
  702005
  705200
  708061
  714953
  715806
  716779
  717664
  718461
  719916
  720730
  721033
  721876
  722022
  722089
  726928
  729295
  729789
  730333
  731187
  733051
  733571
  736233
  737309
  740420
  741953
  742791
  746089
  746807
  747982
  748054
  755938
  756253
  757535
  759008
  759943
  760418
  764960
  765028
  765334
  766317
  766493
  768363
  775382
  775693
  777118
  778222
  782042
  783810
  787235
  787888
  789445
  791874
  793043
  793363
  793498
  793907
  796040
  796095
  796235
  796591
  797969
  798285
  800800
  802417
  805196
  808053
  811769
  812644
  812980
  813182
  815472
  818036
  821797
  825539
]
2.04 ms
(1.28%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "please sex"
]
1.95 ms
(1.22%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.74 ms
(1.10%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "please секс"
]
1.52 ms
(0.95%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "please секс"
]

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.