Query Metrics
7
Database Queries
7
Different statements
212.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
189.68 ms (89.39%) |
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 4387 393848 394167 422107 426718 428188 505725 508962 533695 543532 543717 545990 549102 552645 552689 553757 554113 560122 564391 564579 568002 571415 576977 579023 580343 580606 587908 588606 590826 604228 605816 608225 611040 616387 618451 619934 630697 633323 634562 638097 643516 643647 645761 647108 648674 650094 650315 651040 651974 655289 656286 656634 656654 657458 661607 662889 669279 670720 675571 675856 681208 696128 696923 698259 701526 701535 707045 716992 717718 718144 720952 726243 728762 739164 742631 759299 760962 761701 763430 764240 764843 765061 765819 765926 767120 767138 767762 768758 770227 773097 773409 774652 776937 777737 779893 779961 786958 790637 790941 791422 791502 791769 791936 793228 794541 794863 798801 800407 800785 804228 804325 804927 810332 813042 816597 817275 818330 819425 819719 825670 ] |
||||||||||||||||||||||||||||||
|
13.14 ms (6.19%) |
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 554113 720952 560122 571415 587908 777737 798801 790637 800407 764843 764240 765819 759299 716992 793228 800785 422107 816597 804927 819425 580606 4387 533695 543532 645761 651040 656634 675856 651974 656654 661607 701526 701535 707045 647108 650094 650315 655289 656286 657458 662889 669279 675571 549102 576977 580343 590826 619934 638097 643516 616387 643647 605816 608225 611040 618451 634562 768758 633323 696923 426718 553757 564391 717718 648674 545990 774652 776937 810332 791502 791936 804228 813042 761701 767138 794541 726243 742631 763430 767120 773409 765926 790941 791422 794863 543717 630697 765061 825670 817275 819719 728762 739164 804325 670720 564579 773097 779961 779893 767762 760962 786958 698259 394167 393848 428188 505725 508962 696128 552645 552689 579023 681208 588606 770227 604228 818330 568002 791769 718144 ] |
||||||||||||||||||||||||||||||
|
2.67 ms (1.26%) |
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 4387 393848 394167 422107 426718 428188 505725 508962 533695 543532 543717 545990 549102 552645 552689 553757 554113 560122 564391 564579 568002 571415 576977 579023 580343 580606 587908 588606 590826 604228 605816 608225 611040 616387 618451 619934 630697 633323 634562 638097 643516 643647 645761 647108 648674 650094 650315 651040 651974 655289 656286 656634 656654 657458 661607 662889 669279 670720 675571 675856 681208 696128 696923 698259 701526 701535 707045 716992 717718 718144 720952 726243 728762 739164 742631 759299 760962 761701 763430 764240 764843 765061 765819 765926 767120 767138 767762 768758 770227 773097 773409 774652 776937 777737 779893 779961 786958 790637 790941 791422 791502 791769 791936 793228 794541 794863 798801 800407 800785 804228 804325 804927 810332 813042 816597 817275 818330 819425 819719 825670 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur pov anal"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск пов анал"
]
|
||||||||||||||||||||||||||||||
|
1.52 ms (0.72%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.47 ms (0.69%) |
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.