Query Metrics
7
Database Queries
7
Different statements
148.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
129.08 ms (86.68%) |
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 56632 392401 419938 437560 441808 441892 458541 475560 485929 487896 490158 493994 507816 531937 535865 550914 551534 553443 557728 558570 559657 561431 561571 564533 566817 585334 588483 603761 610517 613981 614880 620716 620938 622855 622870 628828 630098 642996 643334 648033 654256 654261 657735 658555 671193 673880 675491 680584 681371 681490 681797 685263 686753 687466 703235 704673 705111 707569 707915 709937 712582 712952 714855 716270 718868 719325 726818 730641 731361 732984 733330 737126 741796 744493 748263 748304 751507 764518 765063 767193 773621 775606 776042 777862 780883 782387 782654 783963 786756 789437 789597 791235 791895 792479 794877 795089 795895 796399 796916 801094 801145 801182 801572 801580 802166 803026 803651 804902 805239 805533 806849 808048 808585 810856 813016 814283 817688 818753 818833 ] |
||||||||||||||||||||||||||||||
|
11.01 ms (7.39%) |
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 730641 748263 765063 726818 737126 762399 767193 731361 773621 703235 714855 776042 780883 802166 806849 810856 441808 475560 675491 559657 557728 535865 620716 707569 553443 564533 566817 681490 709937 704673 705111 654256 654261 657735 673880 558570 685263 716270 603761 628828 681797 719325 707915 561431 671193 680584 681371 687466 686753 622855 622870 610517 613981 643334 614880 801182 733330 789437 751507 630098 531937 648033 658555 712952 585334 744493 801094 801145 808585 813016 764518 392401 419938 818833 814283 818753 817688 485929 458541 487896 561571 550914 712582 718868 588483 620938 642996 777862 783963 792479 796916 801572 801580 782654 786756 794877 795089 805239 805533 791895 795895 796399 803026 804902 732984 741796 748304 775606 782387 789597 791235 803651 808048 56632 437560 441892 507816 490158 493994 551534 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.45%) |
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 56632 392401 419938 437560 441808 441892 458541 475560 485929 487896 490158 493994 507816 531937 535865 550914 551534 553443 557728 558570 559657 561431 561571 564533 566817 585334 588483 603761 610517 613981 614880 620716 620938 622855 622870 628828 630098 642996 643334 648033 654256 654261 657735 658555 671193 673880 675491 680584 681371 681490 681797 685263 686753 687466 703235 704673 705111 707569 707915 709937 712582 712952 714855 716270 718868 719325 726818 730641 731361 732984 733330 737126 741796 744493 748263 748304 751507 764518 765063 767193 773621 775606 776042 777862 780883 782387 782654 783963 786756 789437 789597 791235 791895 792479 794877 795089 795895 796399 796916 801094 801145 801182 801572 801580 802166 803026 803651 804902 805239 805533 806849 808048 808585 810856 813016 814283 817688 818753 818833 ] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск real"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade real"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск real"
]
|
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.