Query Metrics
7
Database Queries
7
Different statements
144.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.98 ms (83.79%) |
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 7741 188293 382158 386996 392388 397145 427749 429298 441802 501118 513935 527838 529765 532536 538771 539983 542905 545349 547715 548026 550682 552092 553884 555503 556261 558403 565970 566596 567295 570852 577293 579234 583656 587663 589428 589857 589922 589991 590048 596969 599407 606000 615277 617775 619600 620029 622986 629001 629099 632075 634249 636261 636747 637470 643777 644623 645400 650113 652274 652926 662437 662512 676408 681388 683766 693250 697853 709036 709061 709090 711606 713667 719535 720791 723807 725353 734472 739222 744170 776467 778350 780249 781055 782430 783952 784340 788124 790314 791010 791598 796607 796927 799075 799821 799892 801245 802760 802935 803118 804039 804737 804954 805160 808070 808740 811126 811147 811338 813616 814278 815781 816143 816804 816815 818910 819197 821231 821760 825572 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (10.05%) |
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 791010 796607 796927 802935 803118 804039 804954 808070 188293 386996 392388 382158 7741 397145 441802 427749 429298 825572 813616 816143 816804 819197 814278 815781 816815 818910 821231 821760 539983 527838 513935 532536 538771 501118 529765 547715 552092 553884 558403 565970 577293 542905 545349 550682 555503 570852 548026 556261 567295 645400 652926 693250 697853 709036 720791 650113 652274 662437 676408 713667 662512 681388 683766 709061 709090 711606 719535 566596 579234 583656 587663 589428 589991 590048 599407 606000 615277 629001 636261 644623 589857 589922 622986 629099 637470 643777 607641 619600 620029 632075 636747 596969 617775 634249 776467 780249 781055 790314 791598 799075 799821 799892 811126 811147 778350 788124 801245 723807 725353 734472 739222 744170 782430 783952 784340 802760 804737 805160 808740 811338 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.68%) |
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 7741 188293 382158 386996 392388 397145 427749 429298 441802 501118 513935 527838 529765 532536 538771 539983 542905 545349 547715 548026 550682 552092 553884 555503 556261 558403 565970 566596 567295 570852 577293 579234 583656 587663 589428 589857 589922 589991 590048 596969 599407 606000 615277 617775 619600 620029 622986 629001 629099 632075 634249 636261 636747 637470 643777 644623 645400 650113 652274 652926 662437 662512 676408 681388 683766 693250 697853 709036 709061 709090 711606 713667 719535 720791 723807 725353 734472 739222 744170 776467 778350 780249 781055 782430 783952 784340 788124 790314 791010 791598 796607 796927 799075 799821 799892 801245 802760 802935 803118 804039 804737 804954 805160 808070 808740 811126 811147 811338 813616 814278 815781 816143 816804 816815 818910 819197 821231 821760 825572 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body to body"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body body"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body body"
]
|
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.