Query Metrics
7
Database Queries
7
Different statements
216.84 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
191.02 ms (88.09%) |
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 462406 478642 501073 506257 510736 525299 543744 548994 549129 550276 555021 556171 567840 575269 577599 587689 603589 604186 610516 618751 620975 625504 635549 636130 636605 636628 640478 646111 648393 648524 650688 652803 654187 654356 658919 659387 661652 668098 677136 686065 686996 689529 691614 697458 701213 702288 705178 705752 708365 709343 713398 720102 723158 726578 728735 734703 735885 736117 736231 736835 738236 738391 742491 743910 749710 752956 759907 765598 765713 766800 767054 768394 769076 771790 775161 779296 781368 781606 784106 784434 788565 788661 789110 791506 791773 791878 792708 793113 793580 793865 794859 795623 796039 796157 796749 796773 798887 799590 801111 801693 803242 804599 806118 809353 809412 810847 811691 813097 813861 816610 818911 824468 824706 825294 825623 827431 827944 827947 827964 ] |
||||||||||||||||||||||||||||||
|
15.72 ms (7.25%) |
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 816610 818911 825294 827431 824706 825623 813861 824468 827947 827964 827944 478642 501073 506257 525299 510736 462406 577599 543744 548994 556171 567840 549129 550276 648393 652803 654187 661652 668098 677136 691614 701213 702288 648524 654356 659387 686065 686996 689529 705178 705752 720102 646111 650688 658919 697458 708365 709343 713398 723158 555021 575269 587689 625504 635549 636628 604186 620975 636130 610516 640478 603589 618751 636605 779296 781606 794859 798887 799590 806118 809412 811691 775161 781368 784106 788661 791773 792708 793113 793865 796039 796749 801693 803242 804599 809353 813097 736117 736231 752956 769076 784434 788565 789110 791506 791878 793580 795623 796157 796773 801111 810847 736835 738236 738391 749710 765598 766800 726578 742491 743910 767054 759907 762206 765713 768394 771790 728735 734703 735885 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.49%) |
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 462406 478642 501073 506257 510736 525299 543744 548994 549129 550276 555021 556171 567840 575269 577599 587689 603589 604186 610516 618751 620975 625504 635549 636130 636605 636628 640478 646111 648393 648524 650688 652803 654187 654356 658919 659387 661652 668098 677136 686065 686996 689529 691614 697458 701213 702288 705178 705752 708365 709343 713398 720102 723158 726578 728735 734703 735885 736117 736231 736835 738236 738391 742491 743910 749710 752956 759907 765598 765713 766800 767054 768394 769076 771790 775161 779296 781368 781606 784106 784434 788565 788661 789110 791506 791773 791878 792708 793113 793580 793865 794859 795623 796039 796157 796749 796773 798887 799590 801111 801693 803242 804599 806118 809353 809412 810847 811691 813097 813861 816610 818911 824468 824706 825294 825623 827431 827944 827947 827964 ] |
||||||||||||||||||||||||||||||
|
1.91 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"doggy hard"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"рак hard"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"рак hard"
]
|
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.