Query Metrics
7
Database Queries
7
Different statements
150.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
125.26 ms (83.03%) |
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 389307 390131 398325 398567 418547 421732 423793 427448 431702 442615 442619 442620 442648 446551 446661 448300 451771 457787 461775 464364 466466 466492 466884 466888 470007 471650 472102 472657 472678 472687 475656 475681 475682 475685 475686 475689 477069 479926 484981 487057 490595 490603 491631 495286 495730 496841 499568 499842 505970 506156 508773 509113 509664 522702 537175 539349 546059 555479 555594 555607 564751 570941 572172 573196 574049 579376 579377 581992 583083 585050 588017 590730 592948 596961 597730 599577 602218 603554 604059 610154 614834 616359 629554 629602 629647 630414 648710 649429 652890 654935 673528 694366 696108 708583 710866 712053 722168 735132 735622 735798 742067 752603 757176 764420 765668 768157 782481 789616 793671 800611 801351 803819 803960 807855 812745 819309 823968 824555 825711 826455 ] |
||||||||||||||||||||||||||||||
|
15.65 ms (10.37%) |
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 696108 446551 505970 629602 807855 457787 819309 602218 812745 466466 710866 629647 475656 461775 496841 803960 555479 506156 472687 592948 499842 803819 490595 825711 472678 581992 648710 712053 610154 793671 768157 442648 537175 782481 599577 649429 475681 824555 475685 390131 446661 448300 431702 442615 475682 427448 442620 471650 801351 490603 596961 451771 826455 673528 466492 694366 800611 590730 477069 495730 764420 765668 742067 579376 752603 470007 475686 570941 735622 472102 539349 614834 421732 442619 579377 574049 555607 583083 479926 484981 472657 508773 652890 735798 757176 522702 495286 708583 616359 466888 823968 722168 418547 466884 509113 398567 597730 585050 564751 573196 555594 630414 735132 398325 389307 572172 603554 789616 475689 491631 654935 629554 423793 487057 604059 499568 588017 509664 464364 546059 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.78%) |
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 389307 390131 398325 398567 418547 421732 423793 427448 431702 442615 442619 442620 442648 446551 446661 448300 451771 457787 461775 464364 466466 466492 466884 466888 470007 471650 472102 472657 472678 472687 475656 475681 475682 475685 475686 475689 477069 479926 484981 487057 490595 490603 491631 495286 495730 496841 499568 499842 505970 506156 508773 509113 509664 522702 537175 539349 546059 555479 555594 555607 564751 570941 572172 573196 574049 579376 579377 581992 583083 585050 588017 590730 592948 596961 597730 599577 602218 603554 604059 610154 614834 616359 629554 629602 629647 630414 648710 649429 652890 654935 673528 694366 696108 708583 710866 712053 722168 735132 735622 735798 742067 752603 757176 764420 765668 768157 782481 789616 793671 800611 801351 803819 803960 807855 812745 819309 823968 824555 825711 826455 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"волосатая любительск подборк"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"волосатая любительск подборк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hairy amateur compilation"
]
|
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.