Query Metrics
7
Database Queries
7
Different statements
139.65 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.78 ms (83.62%) |
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 429911 465104 483848 488633 492905 529914 530081 535404 535410 536895 543105 545224 545862 545967 547782 555967 555991 559049 560255 567498 570933 573134 574342 575299 576468 577398 585050 587144 588414 590835 592228 592685 593196 595077 597730 598009 598640 601175 604846 604999 605257 612904 613722 614797 614830 614865 615371 615697 617445 617706 617729 617789 617793 639904 641319 657768 657775 660620 664604 672836 679296 684677 689877 689879 689885 692831 693378 697879 705106 708597 709379 709761 711347 716201 717300 721204 721587 723171 730230 730612 731543 740775 742312 742454 749207 749579 751004 751326 751335 751345 751784 751843 753021 757222 757225 758068 758541 765808 767709 773747 774117 774646 777346 780788 783248 783250 783375 785579 785655 788874 789797 790264 791344 807564 807648 812365 813710 813741 813943 824831 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (9.31%) |
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 617445 597730 592228 614865 601175 614797 483848 492905 529914 535404 559049 716201 592685 604999 567498 605257 780788 535410 570933 614830 585050 577398 657768 615371 612904 588414 555967 555991 657775 639904 465104 664604 545862 697879 742454 730612 791344 689879 693378 672836 721587 615697 731543 777346 684677 751004 705106 749579 767709 617729 604846 590835 593196 530081 711347 774646 598640 783375 545967 536895 679296 692831 613722 598009 790264 573134 689885 587144 560255 785655 740775 774117 807564 812365 751784 751843 709761 689877 807648 789797 783250 751345 488633 730230 824831 574342 543105 575299 641319 783248 749207 753021 757222 751335 765808 721204 708597 709379 595077 617793 813943 742312 751326 758068 717300 429911 813741 813710 545224 660620 547782 617789 785579 773747 757225 723171 788874 576468 617706 758541 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (2.06%) |
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 429911 465104 483848 488633 492905 529914 530081 535404 535410 536895 543105 545224 545862 545967 547782 555967 555991 559049 560255 567498 570933 573134 574342 575299 576468 577398 585050 587144 588414 590835 592228 592685 593196 595077 597730 598009 598640 601175 604846 604999 605257 612904 613722 614797 614830 614865 615371 615697 617445 617706 617729 617789 617793 639904 641319 657768 657775 660620 664604 672836 679296 684677 689877 689879 689885 692831 693378 697879 705106 708597 709379 709761 711347 716201 717300 721204 721587 723171 730230 730612 731543 740775 742312 742454 749207 749579 751004 751326 751335 751345 751784 751843 753021 757222 757225 758068 758541 765808 767709 773747 774117 774646 777346 780788 783248 783250 783375 785579 785655 788874 789797 790264 791344 807564 807648 812365 813710 813741 813943 824831 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo amateur"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло любительск"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.