Query Metrics
7
Database Queries
7
Different statements
357.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
334.12 ms (93.40%) |
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 402754 526175 540020 554991 557877 562539 581585 582315 583630 597769 609989 612923 616550 617285 617303 618700 621823 623712 623893 627038 627123 630651 634941 635365 640315 662920 677289 685757 694962 697219 700590 700639 703395 706415 706704 708728 709405 710583 711625 713116 716218 716956 720750 721884 723742 723788 724322 726173 726305 726709 727548 727889 730229 730666 732995 733982 734183 737209 738020 738110 738443 738712 738780 738985 739724 740794 742949 743003 744385 749330 749863 750781 751669 752208 752235 752372 752377 752388 752439 756373 758581 758681 766808 770354 772314 775061 775348 775714 776930 778334 779800 779853 781619 784939 786872 787050 787549 787918 788976 795748 795896 797364 799114 799448 801037 806357 812644 812845 814582 814955 817938 818952 819655 823150 823412 824227 824838 825160 827168 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (3.63%) |
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 700590 703395 711625 710583 713116 677289 685757 700639 706704 708728 582315 609989 630651 623712 623893 617285 617303 618700 784939 752377 812845 752208 738020 627038 635365 697219 540020 562539 662920 706415 716218 721884 583630 621823 640315 634941 597769 612923 732995 726173 627123 823412 402754 824838 825160 819655 823150 824227 827168 814582 817938 814955 818952 526175 581585 554991 557877 709405 716956 720750 694962 616550 775061 775348 775714 776930 781619 787050 787549 788976 799114 801037 812644 778334 779800 779853 795748 799448 723788 726305 726709 730229 730666 733982 734183 737209 740794 743003 749330 749863 752235 752388 756373 758681 771975 772314 786872 787918 795896 797364 806357 738110 738712 738780 739724 742949 750781 751669 770354 723742 724322 727548 727889 738443 738985 744385 752372 752439 758581 766808 ] |
||||||||||||||||||||||||||||||
|
3.06 ms (0.86%) |
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 402754 526175 540020 554991 557877 562539 581585 582315 583630 597769 609989 612923 616550 617285 617303 618700 621823 623712 623893 627038 627123 630651 634941 635365 640315 662920 677289 685757 694962 697219 700590 700639 703395 706415 706704 708728 709405 710583 711625 713116 716218 716956 720750 721884 723742 723788 724322 726173 726305 726709 727548 727889 730229 730666 732995 733982 734183 737209 738020 738110 738443 738712 738780 738985 739724 740794 742949 743003 744385 749330 749863 750781 751669 752208 752235 752372 752377 752388 752439 756373 758581 758681 766808 770354 772314 775061 775348 775714 776930 778334 779800 779853 781619 784939 786872 787050 787549 787918 788976 795748 795896 797364 799114 799448 801037 806357 812644 812845 814582 814955 817938 818952 819655 823150 823412 824227 824838 825160 827168 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur latina"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск латинская"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск латинская"
]
|
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.