Query Metrics
7
Database Queries
7
Different statements
184.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.97 ms (85.79%) |
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 32874 34123 88274 134404 143195 145053 191246 195676 382110 382307 382447 383149 389352 393687 395518 395520 395668 406067 408433 409349 415535 424778 510040 535985 547054 558612 559100 565981 567727 585896 594218 598628 604825 604895 608729 628344 640321 644187 664277 665884 666728 667655 672554 678761 691561 692503 710837 712518 714208 717069 719073 728650 735404 735854 736412 737375 737449 743788 745483 748254 748608 748714 751451 753745 754214 755580 759709 771314 771620 773200 776729 779589 780037 780679 781844 782410 789523 790195 790335 792656 794513 794957 798017 799369 801490 802250 802448 804503 805264 805269 805717 806011 806244 807192 807697 807906 808045 808215 809143 811968 812944 813713 814555 814565 815509 816938 817065 817661 817825 818402 818678 819086 819186 819196 820003 823156 823231 827887 828460 ] |
||||||||||||||||||||||||||||||
|
14.68 ms (7.97%) |
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 759709 792656 143195 565981 664277 780037 807192 145053 823231 712518 666728 692503 737375 748254 191246 598628 817661 134404 818402 608729 799369 801490 789523 745483 808045 383149 691561 382307 395518 814565 819196 510040 559100 547054 672554 714208 719073 585896 736412 798017 743788 735854 779589 665884 807906 755580 395668 382110 815509 818678 817825 819086 819186 820003 827887 535985 567727 558612 667655 678761 644187 628344 781844 804503 805269 809143 790195 790335 812944 728650 754214 802250 805717 807697 773200 748608 771314 751451 753745 737449 717069 88274 382447 408433 828460 823156 811968 594218 735404 415535 195676 393687 395520 32874 816938 710837 640321 604825 794957 782410 34123 406067 409349 814555 813713 817065 694097 604895 776729 802448 794513 805264 748714 771620 780679 806011 806244 808215 424778 389352 ] |
||||||||||||||||||||||||||||||
|
3.23 ms (1.75%) |
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 32874 34123 88274 134404 143195 145053 191246 195676 382110 382307 382447 383149 389352 393687 395518 395520 395668 406067 408433 409349 415535 424778 510040 535985 547054 558612 559100 565981 567727 585896 594218 598628 604825 604895 608729 628344 640321 644187 664277 665884 666728 667655 672554 678761 691561 692503 710837 712518 714208 717069 719073 728650 735404 735854 736412 737375 737449 743788 745483 748254 748608 748714 751451 753745 754214 755580 759709 771314 771620 773200 776729 779589 780037 780679 781844 782410 789523 790195 790335 792656 794513 794957 798017 799369 801490 802250 802448 804503 805264 805269 805717 806011 806244 807192 807697 807906 808045 808215 809143 811968 812944 813713 814555 814565 815509 816938 817065 817661 817825 818402 818678 819086 819186 819196 820003 823156 823231 827887 828460 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.24%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие busty секс"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.98 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big busty fuck"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие busty секс"
]
|
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.