Query Metrics
7
Database Queries
7
Different statements
145.17 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.34 ms |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.35 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"while"
]
|
||||||||||||||||||||||||||||||
| 3 | 13.38 ms |
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 783536 783843 785389 785984 787711 788009 788730 790050 790942 791116 791985 795368 795478 795821 795897 796580 807368 808298 812181 812529 813295 813299 775646 776109 777589 778008 779841 780368 782455 782549 782613 782693 782732 783993 784106 784995 786047 786688 787054 787696 790720 791481 793197 796404 796688 796800 796894 798749 801448 801533 802223 803804 804403 807409 810566 724107 724892 725273 729112 729586 733225 734124 736287 736338 737277 739607 744771 754608 755135 755581 757205 757869 764279 766494 767333 768832 769137 771447 782122 784218 784295 784309 785082 785495 785708 785753 785801 786772 786869 786996 787133 787149 789075 789110 789485 789488 789649 789757 791353 793133 793365 793467 794136 796316 797173 797359 797882 798876 799863 800174 801136 805603 807285 809599 810150 813183 813211 724131 724812 732616 ] |
||||||||||||||||||||||||||||||
| 4 | 2.42 ms |
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 724107 724131 724812 724892 725273 729112 729586 732616 733225 734124 736287 736338 737277 739607 744771 754608 755135 755581 757205 757869 764279 766494 767333 768832 769137 771447 775646 776109 777589 778008 779841 780368 782122 782455 782549 782613 782693 782732 783536 783843 783993 784106 784218 784295 784309 784995 785082 785389 785495 785708 785753 785801 785984 786047 786688 786772 786869 786996 787054 787133 787149 787696 787711 788009 788730 789075 789110 789485 789488 789649 789757 790050 790720 790942 791116 791353 791481 791985 793133 793197 793365 793467 794136 795368 795478 795821 795897 796316 796404 796580 796688 796800 796894 797173 797359 797882 798749 798876 799863 800174 801136 801448 801533 802223 803804 804403 805603 807285 807368 807409 808298 809599 810150 810566 812181 812529 813183 813211 813295 813299 ] |
||||||||||||||||||||||||||||||
| 5 | 122.83 ms |
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 724107 724131 724812 724892 725273 729112 729586 732616 733225 734124 736287 736338 737277 739607 744771 754608 755135 755581 757205 757869 764279 766494 767333 768832 769137 771447 775646 776109 777589 778008 779841 780368 782122 782455 782549 782613 782693 782732 783536 783843 783993 784106 784218 784295 784309 784995 785082 785389 785495 785708 785753 785801 785984 786047 786688 786772 786869 786996 787054 787133 787149 787696 787711 788009 788730 789075 789110 789485 789488 789649 789757 790050 790720 790942 791116 791353 791481 791985 793133 793197 793365 793467 794136 795368 795478 795821 795897 796316 796404 796580 796688 796800 796894 797173 797359 797882 798749 798876 799863 800174 801136 801448 801533 802223 803804 804403 805603 807285 807368 807409 808298 809599 810150 810566 812181 812529 813183 813211 813295 813299 ] |
||||||||||||||||||||||||||||||
| 6 | 1.63 ms |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"while"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.22 ms |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"while"
]
|
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.