Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
122.30 ms
(83.39%)
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
  232975
  233674
  358365
  379578
  381959
  388310
  391967
  398760
  398965
  408585
  414594
  415475
  418714
  419535
  435874
  443708
  443793
  443821
  444911
  451502
  454222
  454231
  454298
  455149
  455877
  456030
  456045
  458163
  460554
  460752
  462181
  462705
  463172
  463394
  466192
  466350
  466466
  466898
  467841
  468897
  470280
  470960
  471009
  473245
  474194
  474315
  474791
  475102
  479080
  479106
  479422
  480050
  481383
  484405
  490193
  490339
  490641
  490648
  493961
  494963
  497828
  502718
  504005
  506092
  509430
  513528
  516539
  519753
  521147
  522946
  523627
  524444
  525468
  525884
  543542
  544527
  544556
  544898
  551515
  556692
  557999
  558314
  562109
  562418
  573973
  573996
  574578
  579510
  587986
  592985
  598768
  599354
  602215
  602392
  621087
  658797
  664737
  665956
  673841
  674277
  676781
  678716
  703789
  714476
  714789
  718644
  719100
  719514
  728381
  735954
  754536
  758746
  764212
  783177
  819883
  824735
  825396
  825400
  828666
]
14.43 ms
(9.84%)
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
  466350
  474194
  480050
  454222
  473245
  479106
  443821
  497828
  522946
  490339
  502718
  444911
  824735
  825396
  573973
  462181
  463394
  398965
  415475
  470960
  602215
  519753
  544898
  558314
  678716
  714476
  658797
  592985
  599354
  587986
  796642
  456030
  509430
  525468
  819883
  825400
  828666
  523627
  543542
  551515
  544556
  573996
  664737
  719514
  665956
  674277
  703789
  673841
  676781
  714789
  718644
  602392
  758746
  735954
  754536
  764212
  783177
  233674
  379578
  414594
  481383
  598768
  391967
  358365
  474315
  479422
  462705
  232975
  398760
  467841
  516539
  521147
  484405
  460752
  475102
  460554
  479080
  454298
  493961
  525884
  388310
  471009
  719100
  728381
  494963
  621087
  504005
  466466
  544527
  556692
  579510
  466898
  458163
  435874
  451502
  506092
  513528
  490648
  524444
  490193
  490641
  381959
  562109
  557999
  562418
  574578
  443708
  443793
  463172
  456045
  474791
  455149
  466192
  470280
  418714
  419535
  454231
  468897
  408585
  455877
]
2.64 ms
(1.80%)
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
  232975
  233674
  358365
  379578
  381959
  388310
  391967
  398760
  398965
  408585
  414594
  415475
  418714
  419535
  435874
  443708
  443793
  443821
  444911
  451502
  454222
  454231
  454298
  455149
  455877
  456030
  456045
  458163
  460554
  460752
  462181
  462705
  463172
  463394
  466192
  466350
  466466
  466898
  467841
  468897
  470280
  470960
  471009
  473245
  474194
  474315
  474791
  475102
  479080
  479106
  479422
  480050
  481383
  484405
  490193
  490339
  490641
  490648
  493961
  494963
  497828
  502718
  504005
  506092
  509430
  513528
  516539
  519753
  521147
  522946
  523627
  524444
  525468
  525884
  543542
  544527
  544556
  544898
  551515
  556692
  557999
  558314
  562109
  562418
  573973
  573996
  574578
  579510
  587986
  592985
  598768
  599354
  602215
  602392
  621087
  658797
  664737
  665956
  673841
  674277
  676781
  678716
  703789
  714476
  714789
  718644
  719100
  719514
  728381
  735954
  754536
  758746
  764212
  783177
  819883
  824735
  825396
  825400
  828666
]
2.10 ms
(1.43%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
  "волосатая русск"
]
1.96 ms
(1.34%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "hairy russian"
]
1.77 ms
(1.20%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "волосатая русск"
]
1.47 ms
(1.00%)
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.