Query Metrics
7
Database Queries
7
Different statements
139.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.91 ms (86.21%) |
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 85949 219052 397777 399013 401834 418572 438365 455996 456663 466418 530102 531353 531355 531363 534504 540887 548831 558957 562451 563457 567861 579029 584211 585290 591175 597000 603828 614939 615893 617852 623372 626797 629650 632071 632409 635726 648165 648315 648323 648326 649866 650095 652434 652529 652532 653307 653915 654984 657759 657830 659190 661924 670069 671166 674257 678643 689160 693503 693572 699108 700869 701283 701530 701772 710208 716729 718427 720217 725782 726344 726356 731669 733316 733938 742012 743711 745933 748458 755166 761955 763232 763771 764313 764558 764582 764826 764991 769977 771512 773413 776364 777503 777990 778046 779843 780037 780081 780840 782500 783510 783706 783788 784698 786667 787327 789147 789508 790263 790540 791982 793349 793752 793756 793764 802840 817971 822989 824093 825047 825646 ] |
||||||||||||||||||||||||||||||
|
9.36 ms (6.73%) |
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 700869 540887 531353 579029 562451 652532 689160 693572 648326 652434 701772 648323 671166 584211 626797 597000 778046 764826 769977 773413 614939 789508 793764 771512 743711 466418 720217 824093 455996 764558 764582 649866 793756 399013 726356 530102 817971 825047 567861 699108 653307 701530 629650 776364 731669 763232 764991 790540 793349 761955 764313 763771 615893 718427 780840 783788 787327 632071 531355 650095 657759 648315 678643 710208 648165 657830 591175 745933 635726 742012 674257 548831 791982 438365 563457 652529 558957 585290 779843 783706 725782 782500 780081 733938 85949 701283 780037 786667 777503 783510 784698 790263 733316 748458 777990 693503 534504 716729 661924 603828 632409 789147 617852 802840 531363 659190 726344 219052 456663 418572 755166 401834 397777 623372 670069 793752 653915 822989 825646 654984 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.76%) |
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 85949 219052 397777 399013 401834 418572 438365 455996 456663 466418 530102 531353 531355 531363 534504 540887 548831 558957 562451 563457 567861 579029 584211 585290 591175 597000 603828 614939 615893 617852 623372 626797 629650 632071 632409 635726 648165 648315 648323 648326 649866 650095 652434 652529 652532 653307 653915 654984 657759 657830 659190 661924 670069 671166 674257 678643 689160 693503 693572 699108 700869 701283 701530 701772 710208 716729 718427 720217 725782 726344 726356 731669 733316 733938 742012 743711 745933 748458 755166 761955 763232 763771 764313 764558 764582 764826 764991 769977 771512 773413 776364 777503 777990 778046 779843 780037 780081 780840 782500 783510 783706 783788 784698 786667 787327 789147 789508 790263 790540 791982 793349 793752 793756 793764 802840 817971 822989 824093 825047 825646 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"минет оральн секс любительск"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"минет оральн секс любительск"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"минет любительское же…"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.26%) |
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.