Query Metrics
7
Database Queries
7
Different statements
171.91 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.16 ms (87.35%) |
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 145635 398124 418773 436055 451517 473962 487254 494588 509298 512087 513632 513670 531736 533655 536295 539317 543546 544967 547782 548644 548957 555547 557529 559420 566397 570868 579218 583232 587491 595455 600731 617552 618475 625921 627414 628559 628566 642963 645745 650305 661619 662150 664181 664573 665081 666981 667363 669899 670963 672836 675344 684500 685742 688173 689877 689885 696758 701344 702318 703218 709676 710777 718825 727048 730508 734251 738491 743920 746098 746592 750204 756496 758953 759072 759823 764071 764237 768725 768757 772166 773747 774661 777753 779641 782108 783954 785362 788662 788874 790139 791723 792368 792706 794212 799150 801430 802932 803385 804232 804679 804702 806596 806801 810092 812040 812292 812296 812538 813196 816644 817650 819822 819836 824611 824710 824857 825183 825579 ] |
||||||||||||||||||||||||||||||
|
11.42 ms (6.64%) |
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 650305 669899 685742 689885 703218 664181 664573 666981 684500 710777 547782 548957 617552 627414 587491 595455 600731 625921 777753 779641 790139 792368 806596 801430 803361 806801 812296 734251 758953 759072 772166 782108 783954 785362 788662 791723 812292 812538 813196 768725 727048 768757 730508 738491 746592 759823 764071 773747 756496 764237 642963 774661 788874 792706 794212 799150 804232 812040 436055 513670 487254 513632 548644 696758 579218 743746 743920 398124 628566 802932 803385 804679 819822 824611 533655 544967 557529 566397 618475 750204 718825 451517 583232 628559 804702 746098 810092 418773 512087 145635 816644 824710 824857 817650 819836 825183 825579 473962 539317 509298 531736 494588 536295 570868 543546 555547 559420 645745 661619 662150 702318 665081 670963 675344 689877 701344 709676 667363 672836 688173 ] |
||||||||||||||||||||||||||||||
|
2.91 ms (1.69%) |
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 145635 398124 418773 436055 451517 473962 487254 494588 509298 512087 513632 513670 531736 533655 536295 539317 543546 544967 547782 548644 548957 555547 557529 559420 566397 570868 579218 583232 587491 595455 600731 617552 618475 625921 627414 628559 628566 642963 645745 650305 661619 662150 664181 664573 665081 666981 667363 669899 670963 672836 675344 684500 685742 688173 689877 689885 696758 701344 702318 703218 709676 710777 718825 727048 730508 734251 738491 743920 746098 746592 750204 756496 758953 759072 759823 764071 764237 768725 768757 772166 773747 774661 777753 779641 782108 783954 785362 788662 788874 790139 791723 792368 792706 794212 799150 801430 802932 803385 804232 804679 804702 806596 806801 810092 812040 812292 812296 812538 813196 816644 817650 819822 819836 824611 824710 824857 825183 825579 ] |
||||||||||||||||||||||||||||||
|
2.32 ms (1.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð╝ð░ÐüÐéÐâÐÇð▒ð░ÐåÐÅ ð┐ðÁÐÇðÁð┤ ð╝ÐâðÂð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.71 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац жен"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.85%) |
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.