Query Metrics
7
Database Queries
7
Different statements
451.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
221.74 ms (49.13%) |
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 69969 382347 382661 386103 393424 393738 394186 394227 396451 396473 397298 400482 411175 413195 413295 418421 443372 444834 446254 463265 465128 470738 472439 472912 506445 525671 526038 547656 550435 550449 557964 567984 569671 569676 569687 569688 570073 609144 610232 617759 618913 621686 622111 623723 626844 653523 663883 669606 671316 671340 676525 680156 681213 681809 684052 684208 684267 684980 684998 687920 688078 688578 694600 694635 696995 700547 700663 701299 701498 701501 707011 717834 717887 720435 721685 722665 722912 726329 730492 732078 741999 743126 743144 743415 744279 744324 747573 747624 751753 756090 757996 758032 759574 761005 771254 774158 779798 792822 797662 799315 807638 808280 810623 812361 813318 813599 814084 816214 816998 817623 818370 819617 819698 820513 821178 822725 824146 827941 ] |
||||||||||||||||||||||||||||||
|
208.78 ms (46.25%) |
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 69969 382347 382661 386103 393424 393738 394186 394227 396451 396473 397298 400482 411175 413195 413295 418421 443372 444834 446254 463265 465128 470738 472439 472912 506445 525671 526038 547656 550435 550449 557964 567984 569671 569676 569687 569688 570073 609144 610232 617759 618913 621686 622111 623723 626844 653523 663883 669606 671316 671340 676525 680156 681213 681809 684052 684208 684267 684980 684998 687920 688078 688578 694600 694635 696995 700547 700663 701299 701498 701501 707011 717834 717887 720435 721685 722665 722912 726329 730492 732078 741999 743126 743144 743415 744279 744324 747573 747624 751753 756090 757996 758032 759574 761005 771254 774158 779798 792822 797662 799315 807638 808280 810623 812361 813318 813599 814084 816214 816998 817623 818370 819617 819698 820513 821178 822725 824146 827941 ] |
||||||||||||||||||||||||||||||
|
13.83 ms (3.06%) |
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 618913 569676 812361 526038 720435 700663 696995 761005 663883 676525 653523 394227 743415 817623 671340 669606 569671 722912 413295 722665 827961 827941 567984 684208 684267 771254 807638 393738 732078 610232 743144 623723 779798 747624 443372 700547 792822 396473 413195 814084 816214 813599 819698 820513 821178 816998 819617 547656 688078 694635 671316 681809 797662 799315 808280 757996 726329 813318 525671 69969 818370 701299 707011 743126 386103 822725 824146 684998 688578 626844 622111 744324 444834 418421 472912 569687 570073 684980 701501 744279 759574 550435 569688 756090 382661 684052 617759 800948 741999 747573 774158 394186 393424 446254 470738 701498 609144 465128 472439 506445 758032 694600 400482 681213 717834 721685 810623 680156 717887 382347 463265 397298 621686 730492 751753 550449 557964 687920 411175 396451 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young blowjob"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.37 ms (0.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young минет оральн секс"
]
|
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.