Query Metrics
7
Database Queries
7
Different statements
187.28 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.36 ms (86.70%) |
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 467333 483049 522425 530666 531487 533539 534199 534677 539297 540342 548889 551710 551812 552429 554541 554828 558613 560049 565913 569029 569036 570641 575450 584996 585845 588121 588843 616817 618367 618494 626993 628344 629416 630134 644167 649700 650094 650595 650779 657757 666661 668160 671305 675810 677347 691241 695401 702960 703994 709686 709823 712817 713690 714955 716069 717063 719633 719787 721675 724323 724540 725378 727863 731128 731975 732626 732982 733062 733269 734239 735435 736284 740905 742474 744010 745375 746163 746709 747651 748262 748433 749041 750303 750787 751411 751419 751590 753183 753525 756084 757073 758036 759079 759643 759674 763432 764173 765632 767257 767517 767766 768795 770231 770470 770537 771944 772071 783652 784263 786701 787777 789313 790128 796531 801696 806470 807850 809942 811180 813571 ] |
||||||||||||||||||||||||||||||
|
14.66 ms (7.83%) |
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 744010 746163 757073 767257 767517 770231 770537 771944 787777 790128 801696 807850 811180 724323 724540 725378 727863 731975 748262 759643 763432 767766 768795 732982 742474 745375 746709 770470 732626 734239 735435 747651 750303 750787 751411 751590 765632 772071 731128 733062 733269 736284 740905 748433 749041 751419 753183 753525 756084 758036 759079 759674 764173 626993 709686 714955 717063 783652 784263 786701 789313 796531 806470 809942 584996 813571 483049 531487 533539 534199 530666 539297 540342 534677 522425 467333 551710 575450 565913 548889 551812 554541 554828 569029 649700 650779 666661 668160 671305 677347 691241 702960 713690 650595 675810 703994 709823 716069 719633 719787 650094 657757 695401 712817 721675 552429 558613 560049 569036 570641 588121 629416 630134 585845 618367 644167 616817 588843 618494 628344 ] |
||||||||||||||||||||||||||||||
|
3.72 ms (1.99%) |
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 467333 483049 522425 530666 531487 533539 534199 534677 539297 540342 548889 551710 551812 552429 554541 554828 558613 560049 565913 569029 569036 570641 575450 584996 585845 588121 588843 616817 618367 618494 626993 628344 629416 630134 644167 649700 650094 650595 650779 657757 666661 668160 671305 675810 677347 691241 695401 702960 703994 709686 709823 712817 713690 714955 716069 717063 719633 719787 721675 724323 724540 725378 727863 731128 731975 732626 732982 733062 733269 734239 735435 736284 740905 742474 744010 745375 746163 746709 747651 748262 748433 749041 750303 750787 751411 751419 751590 753183 753525 756084 757073 758036 759079 759643 759674 763432 764173 765632 767257 767517 767766 768795 770231 770470 770537 771944 772071 783652 784263 786701 787777 789313 790128 796531 801696 806470 807850 809942 811180 813571 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"грязную"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"грязн"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.86%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.69%) |
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.