Query Metrics
7
Database Queries
7
Different statements
162.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
139.14 ms (85.42%) |
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 14320 341782 384977 386725 391906 499042 508238 522041 532090 541756 552525 567370 569736 580025 600374 608177 609361 615355 618515 619997 625360 627196 628912 642430 652671 655005 655193 660999 667805 667979 679062 680611 681646 683216 690842 694684 699828 711245 713126 715409 716288 717062 718461 720323 727689 727866 729666 730419 732849 732982 740173 740794 741877 745114 745249 745584 750229 750797 752452 752470 755111 757813 757816 760120 760230 760295 762123 763373 764667 766239 767401 770379 771442 775700 775926 778281 781055 781181 781188 781325 781963 782307 784357 784388 786199 786225 786339 786353 786587 788029 792512 793910 793977 794299 794408 794567 797891 800015 801502 801935 803179 803989 804036 805001 808836 809350 811137 811728 812860 813647 813817 815795 817257 825156 825604 825710 826545 826707 827601 827737 ] |
||||||||||||||||||||||||||||||
|
14.48 ms (8.89%) |
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 690842 717062 792512 815795 699828 679062 681646 805001 386725 827737 567370 660999 667979 718461 781181 811137 781188 782307 786199 793910 797891 804036 786353 741877 760295 763373 730419 745249 766239 826545 522041 508238 532090 569736 713126 715409 720323 667805 694684 625360 600374 781963 786225 800015 812860 727689 764667 803179 384977 14320 825156 817257 825604 827601 499042 541756 655005 615355 619997 642430 628912 775700 778281 801502 801935 755111 784357 732849 745114 770379 727866 732982 745584 729666 793977 809350 391906 775926 750229 341782 826707 813647 813817 825710 552525 580025 652671 680611 711245 716288 655193 683216 608177 609361 618515 627196 781055 788029 794299 794408 808836 781325 786339 794567 811728 740794 760120 784388 786587 803989 740173 752470 757816 760230 762123 771442 752452 757813 750797 767401 ] |
||||||||||||||||||||||||||||||
|
2.62 ms (1.61%) |
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 14320 341782 384977 386725 391906 499042 508238 522041 532090 541756 552525 567370 569736 580025 600374 608177 609361 615355 618515 619997 625360 627196 628912 642430 652671 655005 655193 660999 667805 667979 679062 680611 681646 683216 690842 694684 699828 711245 713126 715409 716288 717062 718461 720323 727689 727866 729666 730419 732849 732982 740173 740794 741877 745114 745249 745584 750229 750797 752452 752470 755111 757813 757816 760120 760230 760295 762123 763373 764667 766239 767401 770379 771442 775700 775926 778281 781055 781181 781188 781325 781963 782307 784357 784388 786199 786225 786339 786353 786587 788029 792512 793910 793977 794299 794408 794567 797891 800015 801502 801935 803179 803989 804036 805001 808836 809350 811137 811728 812860 813647 813817 815795 817257 825156 825604 825710 826545 826707 827601 827737 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.26%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"love fuck"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"love секс"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"love секс"
]
|
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.