Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
138.19 ms
(83.03%)
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
  397284
  490812
  541592
  541618
  541634
  541671
  541690
  541738
  541806
  541821
  541830
  541872
  541886
  543471
  544281
  548278
  561007
  561030
  562823
  564545
  567396
  573914
  576623
  576626
  576629
  576641
  576645
  576706
  576711
  576713
  577358
  577368
  581372
  583533
  592514
  595731
  619405
  620172
  621319
  621698
  622979
  628148
  641120
  641879
  643007
  643114
  644309
  644922
  651630
  662137
  670103
  670108
  670110
  670761
  670772
  670773
  671714
  671751
  672151
  672181
  681040
  681085
  687119
  687249
  689699
  689702
  690810
  699546
  699594
  699667
  703037
  703046
  703051
  703062
  703091
  703097
  703432
  703509
  703512
  703521
  703554
  705278
  705514
  705520
  705521
  705537
  705546
  705878
  705913
  706611
  706899
  707318
  708099
  708421
  708422
  708424
  708468
  708476
  708525
  711997
  712001
  713695
  719097
  719137
  720726
  724173
  725568
  726205
  744276
  744287
  755460
  755474
  784308
  789659
  797771
  800625
  805433
  810689
  813115
  818278
]
17.58 ms
(10.56%)
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
  541872
  573914
  541806
  548278
  562823
  576713
  543471
  576645
  576706
  576711
  592514
  622979
  619405
  576641
  699594
  703097
  703512
  713695
  681085
  705521
  620172
  641879
  800625
  813115
  744276
  744287
  703037
  703046
  703521
  490812
  681040
  818278
  687249
  670103
  561007
  541618
  561030
  705278
  705514
  707318
  711997
  703432
  705520
  719137
  671714
  689699
  699667
  703554
  708525
  576626
  644309
  643114
  628148
  789659
  703062
  712001
  577368
  541738
  544281
  689702
  662137
  576623
  583533
  621698
  670772
  755474
  541634
  541690
  541592
  576629
  541830
  541886
  541821
  541671
  397284
  644922
  564545
  703051
  705878
  703509
  720726
  708468
  595731
  810689
  567396
  577358
  581372
  670110
  670773
  708421
  708424
  719097
  651630
  670108
  670761
  672151
  672181
  690810
  706611
  671751
  687119
  699546
  705537
  705546
  705913
  708422
  708476
  621319
  643007
  641120
  805433
  755460
  784308
  797771
  724173
  726205
  725568
  703091
  706899
  708099
]
3.43 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
  397284
  490812
  541592
  541618
  541634
  541671
  541690
  541738
  541806
  541821
  541830
  541872
  541886
  543471
  544281
  548278
  561007
  561030
  562823
  564545
  567396
  573914
  576623
  576626
  576629
  576641
  576645
  576706
  576711
  576713
  577358
  577368
  581372
  583533
  592514
  595731
  619405
  620172
  621319
  621698
  622979
  628148
  641120
  641879
  643007
  643114
  644309
  644922
  651630
  662137
  670103
  670108
  670110
  670761
  670772
  670773
  671714
  671751
  672151
  672181
  681040
  681085
  687119
  687249
  689699
  689702
  690810
  699546
  699594
  699667
  703037
  703046
  703051
  703062
  703091
  703097
  703432
  703509
  703512
  703521
  703554
  705278
  705514
  705520
  705521
  705537
  705546
  705878
  705913
  706611
  706899
  707318
  708099
  708421
  708422
  708424
  708468
  708476
  708525
  711997
  712001
  713695
  719097
  719137
  720726
  724173
  725568
  726205
  744276
  744287
  755460
  755474
  784308
  789659
  797771
  800625
  805433
  810689
  813115
  818278
]
1.96 ms
(1.18%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "films anal"
]
1.79 ms
(1.08%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.78 ms
(1.07%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "фильм анал"
]
1.70 ms
(1.02%)
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.