Query Metrics
7
Database Queries
7
Different statements
141.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.83 ms (82.76%) |
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 3335 14389 44120 53553 86796 96479 97288 118258 210661 221091 233686 236472 239112 269876 311853 341782 350861 382654 382756 385304 387186 396903 397893 403243 403268 448036 470600 488576 490068 502021 510427 517301 524621 537542 538112 538858 543685 545067 549757 550561 552928 557145 560783 562754 566442 575233 587860 604593 612245 622822 623912 635853 635855 645894 648236 648943 648952 651912 653174 654491 654680 656642 657293 661289 665450 666826 669441 670496 671000 672015 674722 675752 680587 690012 701638 703229 706602 709684 716314 718489 721847 722871 727850 728742 732721 735492 736049 742604 742906 742911 744867 755121 760834 770819 774334 775026 775054 775896 776206 776876 783790 786039 787912 788105 790955 790996 798695 799674 799929 804110 804943 805781 805819 807602 824804 825501 827416 828175 828756 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (9.30%) |
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 221091 799929 799674 350861 53553 575233 587860 560783 562754 742604 387186 651912 86796 728742 118258 396903 566442 543685 790996 732721 233686 397893 382756 96479 403268 524621 385304 680587 783790 786039 787912 742906 760834 210661 648236 623912 804943 97288 403243 770819 709684 776206 805819 490068 502021 722871 448036 14389 827416 671000 661289 311853 239112 269876 382654 825501 822402 828175 828756 538112 488576 545067 645894 648943 654491 657293 665450 666826 721847 648952 653174 669441 706602 654680 670496 675752 701638 622822 612245 635855 635853 805781 775026 742911 744867 788105 798695 807602 735492 755121 703229 804110 44120 824804 552928 690012 672015 775054 790955 736049 727850 775896 236472 341782 470600 510427 517301 3335 538858 537542 550561 549757 656642 674722 716314 557145 604593 776876 774334 718489 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (2.28%) |
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 3335 14389 44120 53553 86796 96479 97288 118258 210661 221091 233686 236472 239112 269876 311853 341782 350861 382654 382756 385304 387186 396903 397893 403243 403268 448036 470600 488576 490068 502021 510427 517301 524621 537542 538112 538858 543685 545067 549757 550561 552928 557145 560783 562754 566442 575233 587860 604593 612245 622822 623912 635853 635855 645894 648236 648943 648952 651912 653174 654491 654680 656642 657293 661289 665450 666826 669441 670496 671000 672015 674722 675752 680587 690012 701638 703229 706602 709684 716314 718489 721847 722871 727850 728742 732721 735492 736049 742604 742906 742911 744867 755121 760834 770819 774334 775026 775054 775896 776206 776876 783790 786039 787912 788105 790955 790996 798695 799674 799929 804110 804943 805781 805819 807602 824804 825501 827416 828175 828756 ] |
||||||||||||||||||||||||||||||
|
2.22 ms (1.57%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"мжм секс втро жмж секс втро чернокожая"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мжм жмж негритянки"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.