Query Metrics
7
Database Queries
7
Different statements
389.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.68 ms (54.64%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife husband sex"
]
|
||||||||||||||||||||||||||||||
|
157.01 ms (40.34%) |
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 156877 385467 420326 420556 479224 501616 510934 516090 519601 522976 534345 534661 541071 543359 544131 544593 547105 571110 574399 580396 595306 603458 613484 613678 619472 621786 632500 636400 640231 641339 647097 653347 653359 653368 654006 656852 668887 671454 682413 689889 693852 698106 702995 704169 705784 718025 718142 724078 725237 725614 725643 726124 726973 730154 730188 730924 732816 734124 734703 740789 745373 745553 746226 748855 749394 756249 757486 765921 766395 768096 768755 773402 775026 776504 779048 780058 780096 781444 782310 783055 783536 790325 791668 792444 792673 792780 794357 794584 795066 795150 795901 796335 796610 798781 798909 799829 800182 800618 800892 801170 802027 803637 803696 805603 807844 811533 812101 814060 816095 819422 819747 820114 821635 823353 824593 824849 825418 825799 827263 827479 ] |
||||||||||||||||||||||||||||||
|
11.38 ms (2.92%) |
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 827479 812101 653347 807844 668887 816095 820114 823353 574399 781444 730924 647097 791668 725643 790325 510934 613678 792780 749394 543359 156877 671454 420556 827263 534661 613484 636400 800892 800182 792673 766395 745553 773402 782310 798781 726973 745373 725237 632500 796610 819747 825799 824849 819422 824593 825418 544593 693852 780058 795150 534345 519601 580396 783536 801170 732816 805603 726124 765921 776504 516090 653368 705784 704169 654006 656852 689889 595306 603458 621786 730188 740789 768096 718142 385467 641339 798909 780096 779048 802027 501616 746226 522976 702995 420326 619472 479224 544131 682413 698106 718025 571110 640231 792444 795901 799829 811533 796335 795066 800618 803696 724078 768755 757486 725614 783055 794584 775026 821635 814060 541071 653359 547105 794357 734124 756249 803637 730154 748855 734703 ] |
||||||||||||||||||||||||||||||
|
2.95 ms (0.76%) |
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 156877 385467 420326 420556 479224 501616 510934 516090 519601 522976 534345 534661 541071 543359 544131 544593 547105 571110 574399 580396 595306 603458 613484 613678 619472 621786 632500 636400 640231 641339 647097 653347 653359 653368 654006 656852 668887 671454 682413 689889 693852 698106 702995 704169 705784 718025 718142 724078 725237 725614 725643 726124 726973 730154 730188 730924 732816 734124 734703 740789 745373 745553 746226 748855 749394 756249 757486 765921 766395 768096 768755 773402 775026 776504 779048 780058 780096 781444 782310 783055 783536 790325 791668 792444 792673 792780 794357 794584 795066 795150 795901 796335 796610 798781 798909 799829 800182 800618 800892 801170 802027 803637 803696 805603 807844 811533 812101 814060 816095 819422 819747 820114 821635 823353 824593 824849 825418 825799 827263 827479 ] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.47%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.83 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен husband секс"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен husband секс"
]
|
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.