Query Metrics
7
Database Queries
7
Different statements
159.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.53 ms (85.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 27635 81571 142253 382677 382798 383237 383639 383667 387919 396348 398325 398917 521780 532344 542489 544757 566583 576512 587819 591591 593893 600058 601831 603572 606696 619585 623335 633049 633148 635780 644656 648852 649542 649627 650662 654094 659339 663869 667510 676146 678576 679061 679078 684052 684369 685220 685618 688277 689310 693188 694128 694557 695236 697761 697789 705893 706612 711258 714115 714542 718919 718964 720215 721792 722876 729659 731774 733830 736263 742876 745740 752183 752537 753255 754198 756433 764338 767327 767330 770202 772245 778156 781902 784072 787914 788669 788921 789108 789999 790012 792487 793342 794799 795853 797578 798930 801069 801474 802655 803793 804188 807650 808359 810836 811181 811513 811947 815639 815952 817458 817922 818163 819176 820549 820989 821484 822027 822052 823419 826480 ] |
||||||||||||||||||||||||||||||
|
12.28 ms (7.70%) |
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 576512 649542 718964 676146 684052 659339 688277 587819 591591 784072 789999 793342 807650 810836 808359 767327 795853 804188 811947 745740 752183 756433 742876 753255 733830 767330 633148 720215 721792 788669 792487 382677 398325 142253 382798 383237 383639 387919 396348 815639 817922 822027 815952 818163 532344 650662 678576 679061 679078 695236 714542 648852 667510 685220 711258 722876 685618 689310 694557 706612 593893 606696 635780 778156 788921 801069 811513 736263 772245 797578 731774 770202 764338 697761 697789 790012 802655 383667 81571 27635 398917 817458 820989 821484 822052 823419 820549 819176 826480 521780 542489 566583 654094 694128 705893 718919 649627 663869 684369 693188 714115 544757 600058 619585 623335 633049 644656 601831 603572 781902 787914 798930 801474 811181 789108 794799 803793 729659 752537 754198 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (2.54%) |
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 27635 81571 142253 382677 382798 383237 383639 383667 387919 396348 398325 398917 521780 532344 542489 544757 566583 576512 587819 591591 593893 600058 601831 603572 606696 619585 623335 633049 633148 635780 644656 648852 649542 649627 650662 654094 659339 663869 667510 676146 678576 679061 679078 684052 684369 685220 685618 688277 689310 693188 694128 694557 695236 697761 697789 705893 706612 711258 714115 714542 718919 718964 720215 721792 722876 729659 731774 733830 736263 742876 745740 752183 752537 753255 754198 756433 764338 767327 767330 770202 772245 778156 781902 784072 787914 788669 788921 789108 789999 790012 792487 793342 794799 795853 797578 798930 801069 801474 802655 803793 804188 807650 808359 810836 811181 811513 811947 815639 815952 817458 817922 818163 819176 820549 820989 821484 822027 822052 823419 826480 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жмж жмж"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жмж секс втро жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.33 ms (0.83%) |
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.