Query Metrics
7
Database Queries
7
Different statements
157.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.49 ms (85.28%) |
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 263039 346141 400735 401799 405528 409334 411896 413687 415873 443168 455598 460622 476088 476666 499089 510595 515874 527085 530479 530700 531223 532816 536538 541669 543652 550379 557873 559368 561107 569922 575705 587536 593316 599833 599961 600004 600417 605909 624810 629965 632650 634472 636315 638298 638742 639274 639818 639823 640400 648235 652766 666736 669893 669912 678836 681081 681131 688546 707389 713329 718678 718768 718784 720950 721168 721750 736905 736944 737473 739820 744598 751587 751600 751611 752759 756614 757883 758952 761570 765683 765836 772884 774575 776548 784750 787408 787479 787488 788818 789954 791489 792652 797771 800706 801416 801949 802832 804451 805490 805564 806973 808450 810132 810896 812626 813002 813003 814491 814852 815031 815396 815801 816057 816292 818442 819594 820070 825864 826715 827080 ] |
||||||||||||||||||||||||||||||
|
12.91 ms (8.18%) |
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 669912 605909 812626 805564 787479 801416 810896 756614 739820 765683 632650 721750 813003 814491 559368 515874 652766 455598 263039 678836 813002 530479 648235 569922 634472 599961 405528 825864 530700 575705 718678 784750 801949 791489 346141 826715 819594 827080 816057 557873 681131 707389 587536 789954 800706 806973 787408 808450 761570 765836 629965 718768 774575 805490 411896 409334 600004 792652 443168 460622 476088 541669 758952 636315 413687 532816 536538 543652 638298 639818 599833 400735 816292 814852 815031 815801 820070 815396 818442 550379 666736 681081 718784 688546 669893 721168 593316 624810 640400 639274 600417 638742 776548 787488 804451 802832 737473 751611 797771 810132 736944 751600 757883 736905 751587 752759 772884 744598 713329 720950 788818 415873 476666 510595 531223 561107 639823 401799 499089 527085 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.93%) |
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 263039 346141 400735 401799 405528 409334 411896 413687 415873 443168 455598 460622 476088 476666 499089 510595 515874 527085 530479 530700 531223 532816 536538 541669 543652 550379 557873 559368 561107 569922 575705 587536 593316 599833 599961 600004 600417 605909 624810 629965 632650 634472 636315 638298 638742 639274 639818 639823 640400 648235 652766 666736 669893 669912 678836 681081 681131 688546 707389 713329 718678 718768 718784 720950 721168 721750 736905 736944 737473 739820 744598 751587 751600 751611 752759 756614 757883 758952 761570 765683 765836 772884 774575 776548 784750 787408 787479 787488 788818 789954 791489 792652 797771 800706 801416 801949 802832 804451 805490 805564 806973 808450 810132 810896 812626 813002 813003 814491 814852 815031 815396 815801 816057 816292 818442 819594 820070 825864 826715 827080 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф оргазм"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфы оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.03%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.60 ms (1.02%) |
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.