Query Metrics
7
Database Queries
7
Different statements
406.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
381.26 ms (93.85%) |
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 84837 387937 408624 466078 520708 533495 540934 546587 554120 554176 557347 566253 570349 577296 593193 596164 599599 601648 603001 603441 611905 615537 625841 627655 633748 638858 641842 644273 646886 651639 653540 659520 660534 665626 667223 671107 675746 680583 682825 691946 696525 698213 699409 699672 702131 708107 716769 717279 717833 717904 719786 721200 729940 730689 730836 732630 735465 737949 738100 740937 741224 742240 743101 743260 750974 752017 752289 752418 752455 752583 753630 753682 753717 757894 773159 773596 779335 780117 780120 782127 782647 782741 783646 786795 787882 791434 799278 802591 802725 810686 810742 811917 813642 813724 813857 816852 817873 819148 819210 820044 821707 824327 824351 824653 824655 825750 826258 826464 826976 827105 828147 828195 828199 828203 828362 828467 828500 828692 828727 ] |
||||||||||||||||||||||||||||||
|
14.43 ms (3.55%) |
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 651639 603441 644273 786795 699672 675746 737949 773159 593193 828203 828362 828467 717833 824327 653540 596164 779335 741224 738100 408624 743260 821707 828195 828199 566253 799278 742240 717279 816852 824655 828692 533495 546587 680583 696525 719786 599599 752017 810686 603001 813642 813857 826258 820044 828147 554176 671107 717904 627655 791434 811917 708107 698213 641842 743101 752418 753717 813724 387937 520708 699409 824653 826976 828500 702131 682825 716769 638858 729940 730836 761934 732630 611905 802591 782741 783646 633748 824351 540934 570349 659520 660534 667223 615537 601648 780117 782647 730689 752289 752455 753682 752583 782127 84837 828727 466078 557347 691946 780120 810742 757894 773596 753630 740937 750974 817873 819210 827105 819148 826464 825750 554120 577296 646886 665626 721200 802725 735465 625841 787882 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (0.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 84837 387937 408624 466078 520708 533495 540934 546587 554120 554176 557347 566253 570349 577296 593193 596164 599599 601648 603001 603441 611905 615537 625841 627655 633748 638858 641842 644273 646886 651639 653540 659520 660534 665626 667223 671107 675746 680583 682825 691946 696525 698213 699409 699672 702131 708107 716769 717279 717833 717904 719786 721200 729940 730689 730836 732630 735465 737949 738100 740937 741224 742240 743101 743260 750974 752017 752289 752418 752455 752583 753630 753682 753717 757894 773159 773596 779335 780117 780120 782127 782647 782741 783646 786795 787882 791434 799278 802591 802725 810686 810742 811917 813642 813724 813857 816852 817873 819148 819210 820044 821707 824327 824351 824653 824655 825750 826258 826464 826976 827105 828147 828195 828199 828203 828362 828467 828500 828692 828727 ] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girls hot"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк hot"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк hot"
]
|
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.