Query Metrics
7
Database Queries
7
Different statements
388.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
349.24 ms (90.00%) |
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 191420 285885 390192 396430 414788 422286 424916 427433 428033 443870 446086 449352 459015 459965 460387 463704 466555 468217 470529 470533 474819 475945 483437 498287 500084 502136 505636 508423 509210 509223 510759 510762 512227 516662 516664 519767 520754 522640 523788 524888 530540 533690 539375 543923 545139 546667 546802 547741 550280 557440 557473 558790 559674 564390 565749 566360 575298 577690 579635 585694 591907 593166 593823 593853 594952 595797 595833 600725 603913 605525 606908 608301 612089 614829 620055 625089 625131 625682 627706 627815 632780 635794 635854 637559 642521 644229 644421 649056 650875 651155 653437 660075 660142 668467 669700 678374 682057 683696 698086 707588 712631 715116 715518 718040 718828 730797 731687 745257 749063 763613 766306 773965 784186 787628 790679 793827 797871 798099 804525 810512 ] |
||||||||||||||||||||||||||||||
|
29.06 ms (7.49%) |
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 428033 443870 718828 644421 533690 660142 427433 516664 483437 558790 566360 650875 653437 637559 593823 635854 798099 793827 745257 632780 459015 449352 498287 530540 557440 547741 649056 718040 668467 608301 627815 594952 804525 730797 766306 731687 763613 612089 625131 509210 509223 463704 539375 470533 546667 698086 715518 790679 396430 635794 787628 505636 468217 474819 508423 500084 519767 575298 559674 678374 651155 707588 683696 593853 595833 595797 593166 600725 605525 784186 749063 773965 614829 466555 424916 390192 550280 591907 625682 285885 516662 502136 543923 545139 797871 522640 191420 810512 603913 475945 579635 669700 715116 606908 627706 470529 510759 682057 414788 644229 422286 459965 446086 460387 520754 512227 524888 510762 523788 564390 565749 660075 712631 546802 557473 577690 620055 642521 585694 625089 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (0.62%) |
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 191420 285885 390192 396430 414788 422286 424916 427433 428033 443870 446086 449352 459015 459965 460387 463704 466555 468217 470529 470533 474819 475945 483437 498287 500084 502136 505636 508423 509210 509223 510759 510762 512227 516662 516664 519767 520754 522640 523788 524888 530540 533690 539375 543923 545139 546667 546802 547741 550280 557440 557473 558790 559674 564390 565749 566360 575298 577690 579635 585694 591907 593166 593823 593853 594952 595797 595833 600725 603913 605525 606908 608301 612089 614829 620055 625089 625131 625682 627706 627815 632780 635794 635854 637559 642521 644229 644421 649056 650875 651155 653437 660075 660142 668467 669700 678374 682057 683696 698086 707588 712631 715116 715518 718040 718828 730797 731687 745257 749063 763613 766306 773965 784186 787628 790679 793827 797871 798099 804525 810512 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.53%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен friends"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (0.53%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife for friends"
]
|
||||||||||||||||||||||||||||||
|
2.02 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.20 ms (0.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен friends"
]
|
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.