Query Metrics
7
Database Queries
7
Different statements
366.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
344.07 ms (93.98%) |
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 546281 547220 572277 585348 587295 588117 588119 588124 588134 588162 588191 588906 589631 589771 594985 596372 599651 606379 614665 614706 616887 618074 620043 628524 631870 631901 632295 637232 638585 640166 640366 642794 642805 644169 648165 648655 659059 665970 665986 677127 694720 702380 716296 718499 720310 723282 724122 727963 729112 729662 731131 732016 732849 733348 742007 742032 743492 743912 744500 744851 746373 747240 753991 760562 768706 772368 772792 773484 775484 776983 777807 778159 781218 781769 782374 782379 783463 784232 784798 785061 785157 785313 787054 787102 787419 787781 788072 788470 789599 789809 790623 790806 791052 791305 791468 792139 792166 792457 793412 793688 793706 794347 795418 796688 797329 797429 797565 798109 799899 801089 801312 803563 803590 804693 805010 807161 808651 809904 811426 811806 ] |
||||||||||||||||||||||||||||||
|
11.28 ms (3.08%) |
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 720310 723282 648165 648655 659059 665970 665986 677127 694720 702380 716296 718499 546281 547220 572277 585348 588134 588191 631901 637232 638585 644169 588906 589631 589771 594985 599651 620043 631870 640166 640366 587295 588117 588162 596372 614665 616887 618074 628524 642794 588119 588124 606379 614706 632295 642805 775484 776983 777807 781769 782374 785157 788470 789599 790806 791052 791305 792139 792166 795418 797429 797565 799899 801312 803590 804693 811806 778159 781218 782379 784232 787054 793412 793688 793706 796688 801089 803563 805010 807161 809904 729112 729662 731131 733348 742007 742032 743912 746373 753991 760562 768706 772368 772792 773484 783463 784798 785061 785313 787102 787419 787781 788072 789809 790623 791468 792457 794347 797329 798109 808651 811426 724122 727963 732016 732849 743492 744500 744851 747240 ] |
||||||||||||||||||||||||||||||
|
3.65 ms (1.00%) |
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 546281 547220 572277 585348 587295 588117 588119 588124 588134 588162 588191 588906 589631 589771 594985 596372 599651 606379 614665 614706 616887 618074 620043 628524 631870 631901 632295 637232 638585 640166 640366 642794 642805 644169 648165 648655 659059 665970 665986 677127 694720 702380 716296 718499 720310 723282 724122 727963 729112 729662 731131 732016 732849 733348 742007 742032 743492 743912 744500 744851 746373 747240 753991 760562 768706 772368 772792 773484 775484 776983 777807 778159 781218 781769 782374 782379 783463 784232 784798 785061 785157 785313 787054 787102 787419 787781 788072 788470 789599 789809 790623 790806 791052 791305 791468 792139 792166 792457 793412 793688 793706 794347 795418 796688 797329 797429 797565 798109 799899 801089 801312 803563 803590 804693 805010 807161 808651 809904 811426 811806 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"2022 best"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.50%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best"
]
|
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.