Query Metrics
7
Database Queries
7
Different statements
180.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
155.16 ms (86.10%) |
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 428239 443668 448011 461090 484464 488231 493079 504187 516844 518291 529152 529467 536043 536146 541013 542082 542179 548912 551608 551622 553673 554741 554795 563982 570262 573115 582934 583314 584722 584932 586665 591753 600583 601219 605186 606389 608488 621725 622780 624762 626133 626579 627455 627617 628261 631056 634958 635590 650126 674119 677581 682865 690179 694595 694930 697934 702908 703279 707155 707766 708505 709396 709738 716418 719208 720484 720595 722688 723073 728171 728814 729842 730102 730341 731762 735307 741425 742139 742604 747961 749101 749176 752111 753339 757200 758012 764811 768555 768745 771805 773187 774711 777625 778953 779716 780052 782047 784060 788840 788918 789288 789938 791371 792964 793005 793123 795472 795673 799892 802073 802976 803367 806833 807670 810565 810814 813595 818912 819841 ] |
||||||||||||||||||||||||||||||
|
14.50 ms (8.04%) |
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 583314 584932 606389 626133 628261 600583 621725 622780 626579 627455 591753 608488 601219 627617 774711 784060 795673 799892 803367 777625 779716 780052 788918 789938 793005 795472 810565 810814 749176 752111 757200 758820 773187 782047 788840 793123 806833 807670 728171 731762 742139 749101 768555 730102 728814 729842 730341 741425 747961 753339 758012 768745 735307 742604 764811 771805 605186 631056 634958 635590 702908 703279 707155 707766 709396 778953 789288 791371 792964 802073 802976 542082 584722 624762 461090 553673 586665 518291 443668 428239 818912 819841 813595 448011 484464 488231 504187 529152 529467 536043 536146 516844 493079 548912 551608 541013 542179 551622 554741 554795 563982 570262 573115 582934 650126 677581 682865 694595 716418 719208 690179 694930 708505 720484 720595 722688 723073 674119 697934 709738 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.82%) |
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 428239 443668 448011 461090 484464 488231 493079 504187 516844 518291 529152 529467 536043 536146 541013 542082 542179 548912 551608 551622 553673 554741 554795 563982 570262 573115 582934 583314 584722 584932 586665 591753 600583 601219 605186 606389 608488 621725 622780 624762 626133 626579 627455 627617 628261 631056 634958 635590 650126 674119 677581 682865 690179 694595 694930 697934 702908 703279 707155 707766 708505 709396 709738 716418 719208 720484 720595 722688 723073 728171 728814 729842 730102 730341 731762 735307 741425 742139 742604 747961 749101 749176 752111 753339 757200 758012 764811 768555 768745 771805 773187 774711 777625 778953 779716 780052 782047 784060 788840 788918 789288 789938 791371 792964 793005 793123 795472 795673 799892 802073 802976 803367 806833 807670 810565 810814 813595 818912 819841 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny cum"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.97%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые cum"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые cum"
]
|
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.