Query Metrics
7
Database Queries
7
Different statements
149.14 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.14 ms (82.56%) |
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 439322 440644 442234 442307 442783 443171 451316 463976 464550 464859 483732 507935 510783 511640 517892 521244 523762 528771 530437 531631 541513 546577 550146 553583 555883 559775 559983 564502 581174 582569 587434 597505 597828 623104 626174 637472 638099 640489 641032 641804 667024 673513 678602 686464 697647 698459 706143 718066 729436 738437 740366 740478 740549 740895 741609 744192 744767 744805 749019 751797 751970 753142 755124 761248 763392 768911 768942 769031 769968 770031 770238 771942 773129 774185 776827 778535 780384 780884 780886 780889 782076 782566 782632 783289 785234 785817 786019 788417 788434 789473 791929 794031 796952 797374 798225 800653 800664 800669 800690 800693 802545 802700 802920 803503 803749 803766 804190 804770 806753 807861 810686 812223 813741 816869 819085 819130 822817 824311 826610 827665 ] |
||||||||||||||||||||||||||||||
|
15.12 ms (10.14%) |
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 796952 804770 810686 740895 753142 755124 797374 740478 744805 729436 751797 780884 782566 803749 813741 740366 564502 773129 819130 822817 464859 559983 541513 550146 555883 697647 686464 718066 553583 559775 626174 638099 597505 782632 800653 800664 780889 788417 788434 791929 800669 800690 794031 802920 741609 763392 740549 751970 768911 768942 774185 771942 761248 769031 769968 770031 698459 780886 782076 783289 803503 803766 804190 440644 442307 443171 439322 451316 507935 517892 530437 546577 581174 587434 442234 442783 463976 464550 521244 511640 523762 483732 510783 807861 819085 826610 824311 816869 827665 528771 531631 582569 678602 706143 667024 673513 623104 637472 597828 640489 641032 641804 776827 778535 780384 785817 786019 802545 785234 798225 800693 802700 806753 812223 744767 770238 789473 749019 738437 744192 ] |
||||||||||||||||||||||||||||||
|
2.94 ms (1.97%) |
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 439322 440644 442234 442307 442783 443171 451316 463976 464550 464859 483732 507935 510783 511640 517892 521244 523762 528771 530437 531631 541513 546577 550146 553583 555883 559775 559983 564502 581174 582569 587434 597505 597828 623104 626174 637472 638099 640489 641032 641804 667024 673513 678602 686464 697647 698459 706143 718066 729436 738437 740366 740478 740549 740895 741609 744192 744767 744805 749019 751797 751970 753142 755124 761248 763392 768911 768942 769031 769968 770031 770238 771942 773129 774185 776827 778535 780384 780884 780886 780889 782076 782566 782632 783289 785234 785817 786019 788417 788434 789473 791929 794031 796952 797374 798225 800653 800664 800669 800690 800693 802545 802700 802920 803503 803749 803766 804190 804770 806753 807861 810686 812223 813741 816869 819085 819130 822817 824311 826610 827665 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.63%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hair redhead solo"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"hair рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"hair рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (1.13%) |
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.