Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
209.51 ms
(88.66%)
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
  3793
  149573
  391530
  391983
  392021
  424012
  435567
  435576
  435593
  437369
  437950
  438321
  452946
  454077
  454547
  455118
  456804
  456938
  459600
  460551
  460593
  462522
  466699
  466899
  468314
  469346
  469427
  469896
  470008
  470024
  470610
  470922
  475555
  476637
  476790
  476986
  477641
  477933
  479378
  479410
  482045
  485392
  485425
  485497
  485595
  488273
  488686
  495516
  496019
  498158
  500639
  504175
  504241
  505768
  506466
  509176
  510693
  511405
  513623
  513628
  513632
  513670
  513681
  514064
  520622
  529472
  532503
  539371
  543754
  547774
  551576
  557995
  559034
  560413
  564104
  565303
  565880
  565898
  569564
  597090
  603784
  605485
  612602
  619924
  658464
  672807
  703948
  714324
  714496
  715935
  725243
  729339
  742314
  747128
  752732
  758301
  778492
  778781
  782503
  782652
  784407
  784674
  789748
  790403
  791923
  792276
  794717
  794980
  796002
  800736
  800742
  800755
  801430
  803880
  809885
  811785
  819346
  825560
  825771
]
16.78 ms
(7.10%)
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
  547774
  424012
  482045
  460551
  477641
  504175
  778492
  437950
  485392
  454547
  496019
  500639
  551576
  569564
  459600
  462522
  466699
  477933
  438321
  470024
  470610
  513681
  485595
  819346
  825560
  825771
  509176
  495516
  532503
  539371
  469346
  564104
  714496
  715935
  782503
  784407
  790403
  778781
  791923
  792276
  796002
  800755
  801430
  725243
  742314
  752732
  758301
  782652
  794717
  811785
  747128
  784674
  789748
  794980
  800736
  800742
  803880
  452946
  466899
  391983
  392021
  475555
  455118
  456938
  476790
  513623
  513670
  506466
  513632
  504241
  505768
  470008
  3793
  514064
  605485
  437369
  479378
  469427
  468314
  435593
  435567
  476637
  479410
  511405
  513628
  520622
  485425
  498158
  529472
  560413
  149573
  391530
  729339
  476986
  488686
  510693
  454077
  460593
  543754
  559034
  469896
  809885
  456804
  565898
  565303
  485497
  488273
  470922
  435576
  703948
  779905
  565880
  557995
  672807
  658464
  714324
  597090
  612602
  603784
  619924
]
3.09 ms
(1.31%)
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
  3793
  149573
  391530
  391983
  392021
  424012
  435567
  435576
  435593
  437369
  437950
  438321
  452946
  454077
  454547
  455118
  456804
  456938
  459600
  460551
  460593
  462522
  466699
  466899
  468314
  469346
  469427
  469896
  470008
  470024
  470610
  470922
  475555
  476637
  476790
  476986
  477641
  477933
  479378
  479410
  482045
  485392
  485425
  485497
  485595
  488273
  488686
  495516
  496019
  498158
  500639
  504175
  504241
  505768
  506466
  509176
  510693
  511405
  513623
  513628
  513632
  513670
  513681
  514064
  520622
  529472
  532503
  539371
  543754
  547774
  551576
  557995
  559034
  560413
  564104
  565303
  565880
  565898
  569564
  597090
  603784
  605485
  612602
  619924
  658464
  672807
  703948
  714324
  714496
  715935
  725243
  729339
  742314
  747128
  752732
  758301
  778492
  778781
  782503
  782652
  784407
  784674
  789748
  790403
  791923
  792276
  794717
  794980
  796002
  800736
  800742
  800755
  801430
  803880
  809885
  811785
  819346
  825560
  825771
]
2.26 ms
(0.96%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
  "home made rus"
]
1.61 ms
(0.68%)
1
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[]
1.59 ms
(0.67%)
1
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
  "домашн любительск русск"
]
1.47 ms
(0.62%)
1
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.