Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
152.84 ms
(85.87%)
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
  385282
  389697
  426218
  429827
  448592
  499971
  520470
  535391
  539733
  539983
  541035
  548270
  550645
  550674
  550911
  563644
  564669
  568567
  576162
  595800
  597164
  605547
  606978
  606991
  607025
  609108
  616604
  618549
  618553
  632394
  632428
  632886
  633554
  636379
  638058
  638721
  642982
  654239
  677920
  680941
  682728
  697604
  698088
  705398
  707980
  708137
  709576
  710188
  710213
  710348
  710410
  711585
  712056
  713288
  713782
  713800
  714048
  714071
  714845
  717029
  718530
  721972
  721985
  722043
  725508
  726917
  727721
  728247
  728564
  732884
  732984
  734105
  736535
  739871
  739922
  744920
  746468
  748768
  753247
  756914
  757044
  758406
  761830
  765886
  765893
  767391
  769506
  773296
  778456
  780883
  783018
  784078
  784104
  785505
  785526
  789265
  791643
  794489
  795611
  796506
  796515
  796524
  796683
  797752
  798847
  799039
  801503
  802942
  805979
  807844
  810627
  813026
  818085
  818094
  819469
  821794
  825556
  826774
]
13.97 ms
(7.85%)
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
  744920
  757044
  757577
  761830
  718530
  721985
  784078
  785505
  795611
  801503
  807844
  429827
  539733
  550645
  541035
  563644
  654239
  707980
  710188
  713782
  705398
  711585
  713288
  697604
  708137
  710348
  710410
  564669
  609108
  616604
  636379
  597164
  606991
  618549
  748768
  606978
  698088
  548270
  595800
  638721
  799039
  385282
  818094
  821794
  539983
  499971
  568567
  550911
  714071
  722043
  709576
  717029
  677920
  682728
  712056
  633554
  605547
  632428
  632886
  607025
  638058
  783018
  796506
  727721
  728564
  758406
  761730
  732884
  773296
  725508
  739871
  769506
  618553
  632394
  642982
  714048
  780883
  797752
  818085
  819469
  826774
  794489
  791643
  796515
  796524
  810627
  798847
  802942
  389697
  805979
  726917
  753247
  426218
  825556
  448592
  520470
  535391
  576162
  550674
  680941
  713800
  721972
  710213
  714845
  778456
  785526
  789265
  796683
  813026
  784104
  734105
  739922
  765886
  765893
  767391
  732984
  736535
  756914
  728247
  746468
]
3.86 ms
(2.17%)
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
  385282
  389697
  426218
  429827
  448592
  499971
  520470
  535391
  539733
  539983
  541035
  548270
  550645
  550674
  550911
  563644
  564669
  568567
  576162
  595800
  597164
  605547
  606978
  606991
  607025
  609108
  616604
  618549
  618553
  632394
  632428
  632886
  633554
  636379
  638058
  638721
  642982
  654239
  677920
  680941
  682728
  697604
  698088
  705398
  707980
  708137
  709576
  710188
  710213
  710348
  710410
  711585
  712056
  713288
  713782
  713800
  714048
  714071
  714845
  717029
  718530
  721972
  721985
  722043
  725508
  726917
  727721
  728247
  728564
  732884
  732984
  734105
  736535
  739871
  739922
  744920
  746468
  748768
  753247
  756914
  757044
  758406
  761830
  765886
  765893
  767391
  769506
  773296
  778456
  780883
  783018
  784078
  784104
  785505
  785526
  789265
  791643
  794489
  795611
  796506
  796515
  796524
  796683
  797752
  798847
  799039
  801503
  802942
  805979
  807844
  810627
  813026
  818085
  818094
  819469
  821794
  825556
  826774
]
2.05 ms
(1.15%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "любительск stranger"
]
1.94 ms
(1.09%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "amateur stranger"
]
1.82 ms
(1.02%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.53 ms
(0.86%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "любительск stranger"
]

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.