Query Metrics
7
Database Queries
7
Different statements
174.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.61 ms (89.83%) |
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 181441 325228 364775 382390 383111 393089 395216 396471 398702 497381 516061 529620 533501 533778 537616 537621 537628 538167 547085 550546 564007 590654 591939 594359 624935 638524 641200 652119 667820 668033 681795 690494 690925 693437 693700 694164 694175 696281 697675 699162 701038 701050 701400 704432 704434 705008 705365 706439 712520 718356 719283 725766 730290 730826 730974 731142 732336 732827 738052 740211 742207 744223 744376 745857 745867 745882 745888 745899 745904 748449 748832 748844 749743 749779 749997 755066 757937 759051 760219 762019 766303 767678 768029 768841 772868 773834 775407 776679 777258 786158 787177 788725 789097 790163 790395 790718 790979 791310 791795 791800 793557 794145 794157 794177 794523 795186 795347 801980 804917 810318 810393 810545 810586 812264 813456 813872 813876 813881 813885 ] |
||||||||||||||||||||||||||||||
|
8.88 ms (5.09%) |
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 591939 790395 777258 787177 794177 810393 810545 745882 748832 768841 745888 749997 641200 705365 719283 383111 396471 398702 813872 813881 813885 533778 516061 533501 547085 550546 690925 693437 697675 699162 701038 712520 681795 690494 694164 694175 696281 704434 705008 706439 718356 652119 667820 693700 704432 590654 594359 638524 790718 790979 791800 801980 810318 775407 786158 788725 791310 794157 795347 804917 812264 730826 755066 760219 767678 768748 789097 790163 794145 794523 810586 730974 732827 740211 745867 749779 762019 773834 730290 742207 745857 748449 748844 759051 768029 725766 731142 732336 744223 757937 738052 744376 745899 745904 749743 766303 772868 701050 701400 776679 791795 793557 795186 813456 564007 668033 624935 181441 393089 395216 325228 364775 382390 813876 538167 537616 537621 497381 529620 537628 ] |
||||||||||||||||||||||||||||||
|
2.60 ms (1.49%) |
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 181441 325228 364775 382390 383111 393089 395216 396471 398702 497381 516061 529620 533501 533778 537616 537621 537628 538167 547085 550546 564007 590654 591939 594359 624935 638524 641200 652119 667820 668033 681795 690494 690925 693437 693700 694164 694175 696281 697675 699162 701038 701050 701400 704432 704434 705008 705365 706439 712520 718356 719283 725766 730290 730826 730974 731142 732336 732827 738052 740211 742207 744223 744376 745857 745867 745882 745888 745899 745904 748449 748832 748844 749743 749779 749997 755066 757937 759051 760219 762019 766303 767678 768029 768841 772868 773834 775407 776679 777258 786158 787177 788725 789097 790163 790395 790718 790979 791310 791795 791800 793557 794145 794157 794177 794523 795186 795347 801980 804917 810318 810393 810545 810586 812264 813456 813872 813876 813881 813885 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пара пара"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пар пар"
]
|
||||||||||||||||||||||||||||||
|
1.37 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пар пар"
]
|
||||||||||||||||||||||||||||||
|
1.25 ms (0.72%) |
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.