Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
219.98 ms
(89.99%)
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
  130016
  320879
  338022
  386172
  391659
  394251
  403769
  412984
  417134
  428218
  431504
  432618
  441395
  448464
  452976
  456451
  460330
  462259
  462957
  474277
  475466
  476142
  482633
  484701
  486784
  488238
  489313
  491056
  492966
  496579
  501357
  505085
  509747
  516490
  516945
  518220
  518606
  522219
  526304
  533384
  533867
  541474
  545821
  554093
  556128
  556422
  556616
  559300
  560909
  564242
  564393
  564558
  576180
  586178
  586456
  589487
  590473
  591860
  591992
  592089
  592696
  593599
  603417
  604270
  604658
  606725
  607002
  607465
  616849
  621171
  621750
  659974
  660452
  666062
  675188
  681237
  690050
  702619
  720207
  724304
  726942
  730507
  730813
  732718
  732990
  735936
  736656
  742640
  742735
  756660
  758141
  758355
  759885
  760980
  761169
  761469
  761600
  761781
  761848
  763547
  764200
  765322
  765400
  766628
  766647
  766707
  766777
  767252
  768590
  769044
  778379
  791330
  791455
  796150
  802053
  804552
  809747
  810907
  813055
  828380
]
13.99 ms
(5.72%)
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
  791330
  802053
  810907
  730507
  730813
  758141
  765400
  769044
  732990
  736656
  742640
  766777
  758355
  761469
  813055
  441395
  320879
  505085
  556422
  456451
  518220
  448464
  486784
  559300
  590473
  621171
  509747
  516490
  386172
  130016
  394251
  412984
  428218
  417134
  828380
  460330
  474277
  475466
  476142
  492966
  484701
  482633
  488238
  491056
  533384
  533867
  496579
  516945
  526304
  541474
  576180
  545821
  560909
  564558
  556616
  564393
  659974
  666062
  702619
  681237
  690050
  720207
  660452
  675188
  554093
  556128
  564242
  589487
  592089
  593599
  604270
  591992
  592696
  604658
  606725
  607002
  607465
  621750
  586178
  603417
  586456
  591860
  616849
  796150
  804552
  724304
  761600
  761781
  763547
  791455
  809747
  756660
  766707
  726942
  761169
  764200
  765322
  732718
  735936
  742735
  759885
  760980
  761848
  768590
  766628
  766647
  767252
  778379
  432618
  452976
  462259
  338022
  391659
  403769
  462957
  501357
  489313
  522219
  518606
  431504
]
2.55 ms
(1.04%)
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
  130016
  320879
  338022
  386172
  391659
  394251
  403769
  412984
  417134
  428218
  431504
  432618
  441395
  448464
  452976
  456451
  460330
  462259
  462957
  474277
  475466
  476142
  482633
  484701
  486784
  488238
  489313
  491056
  492966
  496579
  501357
  505085
  509747
  516490
  516945
  518220
  518606
  522219
  526304
  533384
  533867
  541474
  545821
  554093
  556128
  556422
  556616
  559300
  560909
  564242
  564393
  564558
  576180
  586178
  586456
  589487
  590473
  591860
  591992
  592089
  592696
  593599
  603417
  604270
  604658
  606725
  607002
  607465
  616849
  621171
  621750
  659974
  660452
  666062
  675188
  681237
  690050
  702619
  720207
  724304
  726942
  730507
  730813
  732718
  732990
  735936
  736656
  742640
  742735
  756660
  758141
  758355
  759885
  760980
  761169
  761469
  761600
  761781
  761848
  763547
  764200
  765322
  765400
  766628
  766647
  766707
  766777
  767252
  768590
  769044
  778379
  791330
  791455
  796150
  802053
  804552
  809747
  810907
  813055
  828380
]
2.15 ms
(0.88%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "milf рак creampie"
]
2.14 ms
(0.87%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "milf doggy creampie"
]
1.98 ms
(0.81%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "milf рак creampie"
]
1.67 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.