Query Metrics
7
Database Queries
7
Different statements
144.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.14 ms (84.61%) |
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 393980 397211 420556 428577 491011 497410 520196 522503 533692 533693 534104 534661 543359 545915 547984 566463 568172 585231 587759 590182 595306 602835 603458 606853 607035 613484 614866 618214 619311 621786 625484 627065 636400 639632 639923 645142 647213 650967 653156 653368 654006 656813 656852 689889 689930 695392 701214 703282 704583 704622 705784 707938 708742 714829 714951 717214 720027 723805 724210 726172 727543 728129 729000 731235 732531 733491 741303 743013 743714 745553 747549 751774 758565 765041 766395 768568 773402 774917 777576 782310 784628 786595 788977 792673 793157 793532 794452 794516 795436 795805 800182 801183 802376 802934 803705 807721 811812 812101 816155 816685 816696 817569 818397 818750 818881 819712 824361 825085 825270 825698 826773 827063 827263 827479 828179 828379 828607 ] |
||||||||||||||||||||||||||||||
|
13.00 ms (9.01%) |
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 777576 828379 520196 645142 695392 717214 614866 786595 793532 743013 747549 784628 726172 741303 729000 618214 428577 816155 817569 823717 823734 825698 816685 816696 818397 825085 826773 827063 827479 824361 818750 818881 825270 828179 828607 701214 590182 627065 812101 751774 724210 728129 543359 650967 689930 607035 802376 743714 727543 703282 801183 393980 420556 827263 819712 824282 491011 533693 533692 522503 534661 545915 547984 647213 714829 653156 602835 619311 587759 613484 636400 585231 639632 639923 794516 811812 774917 793157 794452 795805 800182 788977 792673 802934 803705 732531 765041 766395 723805 733491 745553 768568 773402 731235 758565 625484 704583 720027 782310 795436 807721 397211 497410 534104 653368 656813 705784 708742 714951 654006 656852 689889 704622 707938 566463 568172 595306 603458 606853 621786 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (2.01%) |
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 393980 397211 420556 428577 491011 497410 520196 522503 533692 533693 534104 534661 543359 545915 547984 566463 568172 585231 587759 590182 595306 602835 603458 606853 607035 613484 614866 618214 619311 621786 625484 627065 636400 639632 639923 645142 647213 650967 653156 653368 654006 656813 656852 689889 689930 695392 701214 703282 704583 704622 705784 707938 708742 714829 714951 717214 720027 723805 724210 726172 727543 728129 729000 731235 732531 733491 741303 743013 743714 745553 747549 751774 758565 765041 766395 768568 773402 774917 777576 782310 784628 786595 788977 792673 793157 793532 794452 794516 795436 795805 800182 801183 802376 802934 803705 807721 811812 812101 816155 816685 816696 817569 818397 818750 818881 819712 824361 825085 825270 825698 826773 827063 827263 827479 828179 828379 828607 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"husband wife"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"husband жен"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.99%) |
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.