Query Metrics
7
Database Queries
7
Different statements
139.58 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.92 ms (85.91%) |
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 39478 163116 256898 365314 382158 396762 412237 423019 426104 427749 429298 436632 441802 470014 501118 513935 521952 529415 532536 552092 552838 567295 570852 577226 577293 583656 584849 587663 589991 596969 599075 610342 616615 618192 619600 620029 621092 622986 636261 641171 642115 644010 645400 652274 662437 670187 693250 695029 697853 702134 708495 708747 709074 709090 709155 711606 713667 714578 719535 720791 721909 725353 726788 733041 734472 735964 736535 739222 744170 747840 749595 751289 756187 756994 758494 759460 761586 763518 765890 768200 771166 771847 772063 773576 773621 775617 778255 778350 780249 781055 782430 784340 791122 791337 791598 797661 798121 799075 799892 802455 802760 805160 805654 807364 807536 808740 811338 811537 813116 813616 814278 815781 816804 818866 819144 819197 821231 821760 824468 825572 ] |
||||||||||||||||||||||||||||||
|
10.02 ms (7.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 736535 382158 814278 815781 501118 567295 583656 739222 756187 773576 765890 642115 163116 365314 412237 824468 708747 670187 695029 702134 709074 709155 778255 791122 798121 751289 771166 761586 708495 713667 711606 725353 773621 470014 441802 427749 825572 813616 819197 821231 821760 552092 577293 570852 693250 720791 662437 719535 587663 589991 636261 622986 619600 620029 781055 791598 799892 778350 744170 784340 802760 808740 811338 733041 747840 763518 797661 759460 735964 756994 818866 552838 577226 584849 618192 616615 811537 758494 771847 39478 819144 529415 521952 714578 644010 610342 599075 621092 813116 805654 768200 791337 807536 726788 641171 802455 807364 396762 426104 256898 423019 429298 816804 513935 532536 645400 697853 652274 709090 596969 780249 799075 734472 782430 805160 749595 772063 721909 775617 436632 ] |
||||||||||||||||||||||||||||||
|
2.44 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 39478 163116 256898 365314 382158 396762 412237 423019 426104 427749 429298 436632 441802 470014 501118 513935 521952 529415 532536 552092 552838 567295 570852 577226 577293 583656 584849 587663 589991 596969 599075 610342 616615 618192 619600 620029 621092 622986 636261 641171 642115 644010 645400 652274 662437 670187 693250 695029 697853 702134 708495 708747 709074 709090 709155 711606 713667 714578 719535 720791 721909 725353 726788 733041 734472 735964 736535 739222 744170 747840 749595 751289 756187 756994 758494 759460 761586 763518 765890 768200 771166 771847 772063 773576 773621 775617 778255 778350 780249 781055 782430 784340 791122 791337 791598 797661 798121 799075 799892 802455 802760 805160 805654 807364 807536 808740 811338 811537 813116 813616 814278 815781 816804 818866 819144 819197 821231 821760 824468 825572 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"body sex"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (1.40%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.26%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"body секс"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (1.07%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"body секс"
]
|
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.