Query Metrics
7
Database Queries
7
Different statements
143.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.18 ms (85.38%) |
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 386179 402134 403765 414720 521659 533766 545900 554310 561516 570821 578357 592979 616827 623348 625577 627276 628040 633704 634036 637938 641331 642086 643801 668371 672802 673247 673746 674795 677972 685768 687949 688377 688849 693719 694551 695001 696293 698132 704998 705024 705112 705241 705853 706687 707515 709777 711050 712825 714179 716452 716711 717193 717387 718123 719401 720149 722930 722957 727956 738659 740064 740829 740880 741202 750458 753574 753658 753661 753682 754370 754602 754984 758571 758683 763573 763803 767321 767632 769483 775109 775121 777486 778354 778357 781542 781581 782664 783131 783263 783853 784025 784162 784380 785512 785734 786751 787786 787958 789243 791193 791642 794948 796419 797159 797313 798672 799779 800547 801307 801676 801945 804032 805559 807540 807643 813736 813872 ] |
||||||||||||||||||||||||||||||
|
9.69 ms (6.77%) |
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 767632 403765 688377 694551 704998 628040 807643 775121 777486 750458 763803 753574 753658 754984 727956 738659 627276 714179 789243 799779 801307 402134 592979 554310 677972 705853 718123 709777 712825 716452 693719 705112 637938 625577 791193 787786 797313 798672 740829 758571 783131 791642 801945 805559 754602 769483 742877 753661 753682 740880 741202 633704 706687 707515 786751 797159 804032 386179 414720 813872 813736 533766 521659 570821 578357 717387 719401 720149 672802 673247 674795 687949 688849 695001 698132 705024 705241 711050 716711 722930 668371 673746 685768 696293 717193 722957 545900 561516 616827 634036 642086 623348 641331 643801 775109 778354 784380 787958 794948 801676 807540 776744 778357 782664 783263 784162 785512 785734 796419 800547 740064 754370 758683 763573 767321 772628 781542 781581 783853 784025 ] |
||||||||||||||||||||||||||||||
|
3.90 ms (2.72%) |
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 386179 402134 403765 414720 521659 533766 545900 554310 561516 570821 578357 592979 616827 623348 625577 627276 628040 633704 634036 637938 641331 642086 643801 668371 672802 673247 673746 674795 677972 685768 687949 688377 688849 693719 694551 695001 696293 698132 704998 705024 705112 705241 705853 706687 707515 709777 711050 712825 714179 716452 716711 717193 717387 718123 719401 720149 722930 722957 727956 738659 740064 740829 740880 741202 750458 753574 753658 753661 753682 754370 754602 754984 758571 758683 763573 763803 767321 767632 769483 775109 775121 777486 778354 778357 781542 781581 782664 783131 783263 783853 784025 784162 784380 785512 785734 786751 787786 787958 789243 791193 791642 794948 796419 797159 797313 798672 799779 800547 801307 801676 801945 804032 805559 807540 807643 813736 813872 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"люба"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"люб"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.16%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (1.04%) |
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.