Query Metrics
7
Database Queries
7
Different statements
205.02 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
181.75 ms (88.65%) |
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 382947 384455 391959 398522 411737 413472 416871 433684 443187 451474 453091 454205 454565 457603 462567 464556 465375 465597 466012 466384 466726 473227 474847 474876 475685 477707 477960 484447 488989 490825 499568 508602 510948 518860 518863 518868 520745 521210 523371 528560 537855 544971 549389 549758 552569 557706 557817 558174 558315 561459 563139 568054 569985 582581 585434 586950 592438 592690 592945 593510 597094 608354 615705 621196 623831 624472 624790 659383 660807 663404 663916 665101 665214 665218 665229 665357 665871 666093 666796 667514 667833 675479 676160 692460 706889 710127 714487 714698 715472 722116 725428 725447 726876 727742 728345 730352 733962 735799 742283 746122 748551 752703 766613 774196 777203 780653 789616 790991 800976 802150 804224 804452 804456 806311 808466 817349 824365 824868 825396 827100 ] |
||||||||||||||||||||||||||||||
|
13.44 ms (6.56%) |
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 582581 544971 549758 563139 706889 665101 665214 667833 714698 663916 676160 710127 569985 777203 800976 802150 746122 766613 774196 615705 624790 411737 451474 477707 824365 827100 521210 518860 508602 549389 692460 715472 722116 585434 789616 725447 733962 804456 735799 725428 742283 790991 804224 398522 443187 824868 825396 457603 433684 382947 416871 384455 413472 817349 464556 466726 475685 518868 523371 537855 520745 568054 552569 557817 561459 665229 665871 666796 675479 665357 666093 659383 663404 665218 667514 608354 597094 624472 621196 623831 780653 727742 748551 808466 752703 726876 728345 804452 806311 391959 453091 454565 466012 473227 474876 454205 465375 477960 518863 484447 730352 462567 474847 490825 510948 528560 499568 465597 466384 488989 558174 557706 558315 660807 714487 586950 592690 592438 592945 593510 ] |
||||||||||||||||||||||||||||||
|
2.85 ms (1.39%) |
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 382947 384455 391959 398522 411737 413472 416871 433684 443187 451474 453091 454205 454565 457603 462567 464556 465375 465597 466012 466384 466726 473227 474847 474876 475685 477707 477960 484447 488989 490825 499568 508602 510948 518860 518863 518868 520745 521210 523371 528560 537855 544971 549389 549758 552569 557706 557817 558174 558315 561459 563139 568054 569985 582581 585434 586950 592438 592690 592945 593510 597094 608354 615705 621196 623831 624472 624790 659383 660807 663404 663916 665101 665214 665218 665229 665357 665871 666093 666796 667514 667833 675479 676160 692460 706889 710127 714487 714698 715472 722116 725428 725447 726876 727742 728345 730352 733962 735799 742283 746122 748551 752703 766613 774196 777203 780653 789616 790991 800976 802150 804224 804452 804456 806311 808466 817349 824365 824868 825396 827100 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy hairy mature"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy волосатая mature"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (0.80%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy волосатая mature"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.72%) |
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.