Query Metrics
7
Database Queries
7
Different statements
243.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
217.75 ms (89.53%) |
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 397741 398355 398435 401522 422316 431483 432804 450597 463398 480282 497903 509719 512354 514910 517273 522693 548116 555064 563015 575308 577919 582428 583560 588161 588531 590812 591766 591818 592379 594980 605410 606529 612281 617011 624652 626325 634905 640304 645575 647080 650094 650315 656518 656582 656634 661967 662889 669279 670915 682989 690618 693281 696104 699166 712484 715888 719799 719961 723566 726240 727969 729657 730222 734326 734347 740952 744493 745069 746090 748083 749009 750100 757210 757535 761082 761484 763762 767692 768758 768983 771732 773365 776785 778503 778954 779264 779551 781136 782130 782446 782637 783144 783368 783378 785325 785724 787982 790298 791698 791770 791782 793680 793837 794511 794957 796131 797163 797228 798707 801553 804376 811800 814454 820041 820177 823447 824263 824874 825557 ] |
||||||||||||||||||||||||||||||
|
15.24 ms (6.27%) |
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 746090 748083 763762 779264 785325 797228 804376 761082 398435 778503 798707 787982 670915 592379 823447 814454 824263 577919 781136 783144 793837 779551 730222 797163 811800 745069 726240 757535 749009 750100 757210 773365 715888 791698 791782 682989 514910 719799 555064 605410 776785 794957 768983 729657 771732 727969 563015 744493 723566 463398 450597 512354 582428 575308 656582 656634 690618 699166 647080 656518 661967 696104 645575 650094 650315 662889 669279 712484 583560 634905 640304 590812 594980 588531 591766 606529 617011 591818 612281 626325 734988 734326 768758 624652 431483 509719 522693 401522 693281 517273 480282 793680 397741 398355 432804 422316 820041 824874 820177 825557 497903 548116 719961 588161 782637 790298 794511 796131 801553 778954 782446 785724 740952 761484 767692 782130 783368 783378 791770 734347 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.08%) |
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 397741 398355 398435 401522 422316 431483 432804 450597 463398 480282 497903 509719 512354 514910 517273 522693 548116 555064 563015 575308 577919 582428 583560 588161 588531 590812 591766 591818 592379 594980 605410 606529 612281 617011 624652 626325 634905 640304 645575 647080 650094 650315 656518 656582 656634 661967 662889 669279 670915 682989 690618 693281 696104 699166 712484 715888 719799 719961 723566 726240 727969 729657 730222 734326 734347 740952 744493 745069 746090 748083 749009 750100 757210 757535 761082 761484 763762 767692 768758 768983 771732 773365 776785 778503 778954 779264 779551 781136 782130 782446 782637 783144 783368 783378 785325 785724 787982 790298 791698 791770 791782 793680 793837 794511 794957 796131 797163 797228 798707 801553 804376 811800 814454 820041 820177 823447 824263 824874 825557 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск секс creampie"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.81%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade sex creampie"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск секс creampie"
]
|
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.