Query Metrics
7
Database Queries
7
Different statements
147.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.83 ms (85.87%) |
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 384883 398019 416407 418195 429504 433234 443969 450847 460974 469997 477067 477493 512895 525168 529305 529663 531072 535653 535790 535806 539715 543773 561559 570854 578657 586038 588341 591258 592843 596234 604493 604593 606109 607650 616049 630494 638569 641381 648901 674670 680049 687584 695759 702050 703977 704872 705553 709396 717943 718592 718779 724282 727520 728089 730504 730700 730977 733973 737089 737582 739762 744693 747078 755145 755359 758110 759074 760648 767556 767694 768396 769257 770007 771394 774384 775569 775583 776775 780008 784850 784861 784894 784946 786226 786562 787571 789505 791637 792287 792918 795559 797469 797876 800107 802075 802095 802981 804302 806207 807019 807037 807612 809208 809791 810506 811314 812975 815420 816677 817018 818113 819472 819589 822308 823017 823763 825274 826860 826907 ] |
||||||||||||||||||||||||||||||
|
10.28 ms (6.96%) |
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 525168 535806 535653 604593 469997 570854 592843 826860 769257 398019 604493 596234 429504 784946 792287 787571 811314 758110 774384 709396 809791 460974 450847 531072 416407 512895 529305 786226 784894 797469 767694 730700 792918 477493 823763 818113 817018 816677 819589 535790 561559 776775 784850 802095 775569 789505 795559 804302 802981 810506 728089 733973 737089 771394 702050 705553 384883 586038 591258 759074 433234 812975 767556 797876 807037 730504 807612 823017 826907 822308 819472 825274 529663 680049 704872 674670 687584 588341 638569 641381 775583 784861 780008 806207 727520 747078 755145 724282 755359 760648 768396 771220 730977 718779 418195 703977 539715 717943 543773 616049 695759 802075 739762 815420 718592 807019 809208 737582 744693 648901 630494 791637 800107 770007 607650 786562 477067 578657 443969 606109 ] |
||||||||||||||||||||||||||||||
|
3.24 ms (2.19%) |
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 384883 398019 416407 418195 429504 433234 443969 450847 460974 469997 477067 477493 512895 525168 529305 529663 531072 535653 535790 535806 539715 543773 561559 570854 578657 586038 588341 591258 592843 596234 604493 604593 606109 607650 616049 630494 638569 641381 648901 674670 680049 687584 695759 702050 703977 704872 705553 709396 717943 718592 718779 724282 727520 728089 730504 730700 730977 733973 737089 737582 739762 744693 747078 755145 755359 758110 759074 760648 767556 767694 768396 769257 770007 771394 774384 775569 775583 776775 780008 784850 784861 784894 784946 786226 786562 787571 789505 791637 792287 792918 795559 797469 797876 800107 802075 802095 802981 804302 806207 807019 807037 807612 809208 809791 810506 811314 812975 815420 816677 817018 818113 819472 819589 822308 823017 823763 825274 826860 826907 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom hand job"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.