Query Metrics
7
Database Queries
7
Different statements
180.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
156.04 ms (86.57%) |
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 407150 412333 413869 433445 434735 434817 437790 438109 440685 446840 450135 451018 463807 485672 486755 487364 491334 504634 524039 526595 529237 537488 538147 545029 554267 580133 583423 585737 586175 588177 595751 599639 604729 605437 605714 606431 609564 614682 614683 616740 625729 628482 631316 637209 643582 660002 666971 672704 675829 678018 686586 687056 692653 703589 706405 707871 709313 710277 711655 716664 724794 729267 730003 736850 744884 746137 746354 750830 756343 762448 762540 762746 763068 763218 764638 764956 767403 768380 768909 769088 771547 772927 772965 774245 774715 776377 777878 778592 778748 779459 779481 779732 783003 786627 787308 787442 787819 789483 790681 790701 793571 798629 803518 809310 810919 811159 811160 811442 813301 813595 813957 814284 814993 816113 817891 818247 818694 818866 824082 826238 ] |
||||||||||||||||||||||||||||||
|
13.51 ms (7.50%) |
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 486755 537488 545029 716664 628482 778592 786627 774715 789483 790681 730003 762746 769088 810919 729267 744884 772965 746137 746354 764956 768909 777878 778748 787442 407150 487364 434817 437790 605437 763218 585737 817891 818694 526595 583423 485672 711655 776377 779459 779732 772927 764638 771547 438109 446840 675829 450135 660002 609564 413869 491334 762540 451018 686586 803518 707871 710277 631316 809310 814993 818247 767403 434735 599639 588177 783003 595751 463807 504634 554267 779481 724794 736850 762448 826238 692653 774245 625729 813957 813595 816113 824082 818866 538147 529237 790701 798629 787308 813301 811159 811160 811442 756343 763068 768380 440685 412333 793571 678018 666971 433445 524039 580133 709313 687056 706405 672704 703589 604729 606431 614682 616740 643582 586175 605714 637209 750830 614683 814284 787819 ] |
||||||||||||||||||||||||||||||
|
3.09 ms (1.72%) |
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 407150 412333 413869 433445 434735 434817 437790 438109 440685 446840 450135 451018 463807 485672 486755 487364 491334 504634 524039 526595 529237 537488 538147 545029 554267 580133 583423 585737 586175 588177 595751 599639 604729 605437 605714 606431 609564 614682 614683 616740 625729 628482 631316 637209 643582 660002 666971 672704 675829 678018 686586 687056 692653 703589 706405 707871 709313 710277 711655 716664 724794 729267 730003 736850 744884 746137 746354 750830 756343 762448 762540 762746 763068 763218 764638 764956 767403 768380 768909 769088 771547 772927 772965 774245 774715 776377 777878 778592 778748 779459 779481 779732 783003 786627 787308 787442 787819 789483 790681 790701 793571 798629 803518 809310 810919 811159 811160 811442 813301 813595 813957 814284 814993 816113 817891 818247 818694 818866 824082 826238 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur deepthroat cum"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.91 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск глубокийминет минет оральн секс cum"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.79%) |
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.