Query Metrics
7
Database Queries
7
Different statements
158.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.64 ms (80.54%) |
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 305824 444893 452702 456484 458148 470915 476377 536950 543381 545069 547951 554576 560130 565607 568171 568788 578933 584054 585091 602818 610999 613288 613338 616688 621780 622179 624012 624818 625298 626894 632568 640587 641490 642130 642517 648658 653347 654212 658457 661425 662585 668135 668136 673924 674257 674549 675503 683649 690002 691807 692464 693010 693420 695373 695777 695856 703935 707865 713454 713766 713989 716311 719491 720564 721677 722352 723087 728502 731504 732733 732867 736499 736612 742097 742685 742808 742986 746930 749632 749900 753505 753581 754173 757835 760188 761812 762132 762689 762803 764845 765296 766059 767819 767973 768705 771919 772010 772336 775429 776528 777618 778231 778245 778292 780376 782035 782036 783612 783815 787587 789622 790131 790290 790294 791720 793198 793654 794308 805339 810034 ] |
||||||||||||||||||||||||||||||
|
18.22 ms (11.50%) |
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 695373 721677 658457 695856 692464 760188 668135 621780 731504 762803 584054 690002 764845 728502 746930 668136 568171 736612 736499 778292 673924 810034 742986 772010 790131 754173 762689 654212 693010 778231 790290 642517 794308 762132 703935 545069 753581 693420 653347 536950 624012 641490 732867 749632 640587 780376 767819 610999 616688 622179 720564 765296 776528 783612 772336 793654 632568 543381 805339 444893 695777 742685 713454 560130 624818 753505 458148 547951 456484 732733 719491 585091 749900 791720 642130 648658 613288 707865 767973 768705 782035 661425 691807 625298 775429 789622 761812 722352 766059 783815 568788 602818 742097 742808 777618 683649 554576 793198 771919 723087 787587 662585 674257 675503 613338 626894 716311 757835 674549 578933 565607 713766 476377 790294 305824 713989 452702 782036 470915 778245 ] |
||||||||||||||||||||||||||||||
|
4.56 ms (2.88%) |
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 305824 444893 452702 456484 458148 470915 476377 536950 543381 545069 547951 554576 560130 565607 568171 568788 578933 584054 585091 602818 610999 613288 613338 616688 621780 622179 624012 624818 625298 626894 632568 640587 641490 642130 642517 648658 653347 654212 658457 661425 662585 668135 668136 673924 674257 674549 675503 683649 690002 691807 692464 693010 693420 695373 695777 695856 703935 707865 713454 713766 713989 716311 719491 720564 721677 722352 723087 728502 731504 732733 732867 736499 736612 742097 742685 742808 742986 746930 749632 749900 753505 753581 754173 757835 760188 761812 762132 762689 762803 764845 765296 766059 767819 767973 768705 771919 772010 772336 775429 776528 777618 778231 778245 778292 780376 782035 782036 783612 783815 787587 789622 790131 790290 790294 791720 793198 793654 794308 805339 810034 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (1.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жену с другом частное…"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.10%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен друг любительск"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.99%) |
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.