Query Metrics
7
Database Queries
7
Different statements
183.42 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.52 ms (87.51%) |
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 415742 442452 460555 463701 475727 516985 526767 531974 532416 535258 536299 543647 544462 544602 565626 566094 585434 586150 586985 588781 589646 600853 604840 606628 612574 612700 615352 615395 615453 618837 621674 623399 626128 627181 627880 633836 639624 639801 639912 644016 644781 649785 650630 655211 659960 661991 670181 676389 680284 687940 695390 695707 708960 710389 710881 714340 714523 718359 731652 732804 733357 734602 736977 737315 737614 740983 742902 745749 750883 753642 756718 757288 758287 758504 761607 763983 764309 764361 771737 775640 775771 778218 778847 779369 780795 784108 785104 786418 787609 788374 790340 790830 791120 793997 794423 796492 797073 797237 797350 803764 803774 806088 808033 808379 810793 810801 814414 816515 817174 817899 818890 820117 821775 823274 824767 825954 826160 826303 826555 827805 ] |
||||||||||||||||||||||||||||||
|
12.40 ms (6.76%) |
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 536299 787609 757288 764309 737315 763983 531974 535258 544462 650630 659960 670181 695390 708960 714340 649785 680284 621674 606628 615395 639912 600853 604840 627880 639624 644016 731652 761607 615352 627181 644781 415742 825954 820117 817174 824767 814414 821775 817899 818890 826303 460555 475727 585434 790830 797073 806088 786418 796492 808033 734602 740983 790340 791120 753642 733357 750883 714523 778218 797350 803764 565626 793997 826160 655211 775640 737614 742902 827805 526767 710881 633836 589646 618837 797237 745749 615453 586985 586150 732804 808379 764361 756718 778847 784108 810793 785104 463701 676389 544602 532416 695707 661991 639801 623399 626128 794423 710389 588781 780795 736977 687940 612574 442452 823274 826555 816515 516985 566094 543647 718359 612700 775771 779369 810801 758287 758504 771737 788374 803774 ] |
||||||||||||||||||||||||||||||
|
3.21 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 415742 442452 460555 463701 475727 516985 526767 531974 532416 535258 536299 543647 544462 544602 565626 566094 585434 586150 586985 588781 589646 600853 604840 606628 612574 612700 615352 615395 615453 618837 621674 623399 626128 627181 627880 633836 639624 639801 639912 644016 644781 649785 650630 655211 659960 661991 670181 676389 680284 687940 695390 695707 708960 710389 710881 714340 714523 718359 731652 732804 733357 734602 736977 737315 737614 740983 742902 745749 750883 753642 756718 757288 758287 758504 761607 763983 764309 764361 771737 775640 775771 778218 778847 779369 780795 784108 785104 786418 787609 788374 790340 790830 791120 793997 794423 796492 797073 797237 797350 803764 803774 806088 808033 808379 810793 810801 814414 816515 817174 817899 818890 820117 821775 823274 824767 825954 826160 826303 826555 827805 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom ass homemade"
]
|
||||||||||||||||||||||||||||||
|
2.01 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.64 ms (0.89%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom жоп домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom жоп домашн любительск"
]
|
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.