Query Metrics
7
Database Queries
7
Different statements
185.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.61 ms (86.58%) |
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 65700 362958 391096 392401 396040 399364 406067 438690 461858 461942 462270 468936 471590 484522 502036 503764 510860 515723 517290 528675 528740 532292 533896 534635 537619 539930 542297 544936 551481 552988 557794 557908 558865 570746 571156 574631 579066 584615 584840 586075 592114 594772 595326 597903 600638 602432 603255 606389 607153 616745 620938 621161 624143 624329 625425 625503 628671 633405 634452 634697 638756 641351 646999 652298 653006 656544 664976 666677 668133 668765 668944 669606 670388 671906 671925 671927 673523 674111 675494 675618 676992 677265 677289 682908 685372 689943 692172 692475 693789 694914 697465 699828 703687 705139 706620 707604 708457 712653 712831 715981 716984 717420 719768 720304 720612 722867 779289 781279 787549 796936 796983 799968 802131 804043 804807 809976 810384 810720 811965 813870 ] |
||||||||||||||||||||||||||||||
|
14.75 ms (7.95%) |
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 796936 796983 799968 802131 804043 804807 811965 399364 462270 362958 471590 603255 515723 392401 65700 391096 396040 406067 438690 813870 484522 461858 468936 510860 534635 503764 517290 528675 528740 532292 533896 537619 539930 502036 461942 542297 551481 552988 557908 574631 584615 544936 557794 558865 571156 584840 646999 656544 671906 671925 676992 689943 693789 694914 699828 703687 706620 708457 716984 717420 664976 666677 668765 668944 669606 671927 673523 674111 677265 682908 685372 692172 692475 697465 705139 712653 712831 715981 722867 652298 653006 668133 670388 675494 675618 677289 707604 719768 720304 720612 570746 579066 592114 597903 600638 606389 616745 624329 625503 628671 633405 634697 602432 607153 624143 625425 594772 595326 634452 638756 641351 586075 620938 621161 779289 781279 787549 809976 810384 810720 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (1.64%) |
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 65700 362958 391096 392401 396040 399364 406067 438690 461858 461942 462270 468936 471590 484522 502036 503764 510860 515723 517290 528675 528740 532292 533896 534635 537619 539930 542297 544936 551481 552988 557794 557908 558865 570746 571156 574631 579066 584615 584840 586075 592114 594772 595326 597903 600638 602432 603255 606389 607153 616745 620938 621161 624143 624329 625425 625503 628671 633405 634452 634697 638756 641351 646999 652298 653006 656544 664976 666677 668133 668765 668944 669606 670388 671906 671925 671927 673523 674111 675494 675618 676992 677265 677289 682908 685372 689943 692172 692475 693789 694914 697465 699828 703687 705139 706620 707604 708457 712653 712831 715981 716984 717420 719768 720304 720612 722867 779289 781279 787549 796936 796983 799968 802131 804043 804807 809976 810384 810720 811965 813870 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.00%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"пара пара"
]
|
||||||||||||||||||||||||||||||
|
1.84 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пар пар"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"пар пар"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.89%) |
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.