Query Metrics
7
Database Queries
7
Different statements
138.07 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
116.00 ms (84.02%) |
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 13265 43029 281942 388795 399598 403252 407389 411599 417657 444117 445141 447818 448598 454728 454902 458902 459466 459833 460199 465583 468812 472378 476052 477227 477411 477500 477525 478007 479931 483335 490211 499369 500861 505331 513814 524548 525373 526079 528183 529620 530044 531009 531299 532654 532872 537026 537280 543427 557292 559965 560255 560898 563361 563912 569614 572268 575935 583350 585633 586988 589947 596074 599347 602136 610251 611183 611260 618071 622663 624265 624298 636413 639481 641842 646863 689885 692697 702060 712930 717717 737524 742240 743172 743244 744060 744189 751637 765808 777150 777314 779373 783335 783375 788499 788522 789990 791033 798311 798439 798479 801826 803025 805142 805560 808330 814166 814208 816834 816874 817185 818743 819089 819123 819229 819257 820170 821524 822313 825100 825132 ] |
||||||||||||||||||||||||||||||
|
13.34 ms (9.66%) |
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 447818 528183 560255 611260 788499 744060 543427 646863 563912 641842 798439 798479 281942 743172 743244 798311 43029 388795 417657 411599 454728 454902 532872 460199 478007 624298 611183 777314 407389 465583 816874 825100 814166 819229 526079 531009 531299 692697 702060 610251 801826 777150 779373 803025 742240 808330 737524 744189 624265 717717 788522 789990 13265 599347 783335 751637 765808 805142 476052 445141 479931 477525 472378 560898 563361 569614 572268 583350 589947 602136 468812 525373 483335 500861 444117 448598 458902 712930 791033 399598 459466 477411 477227 537026 490211 499369 505331 477500 524548 557292 559965 586988 618071 636413 585633 596074 805560 783375 639481 689885 622663 403252 814208 825132 816834 821524 819123 822313 817185 818743 819089 819257 820170 459833 513814 530044 529620 532654 537280 575935 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.65%) |
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 13265 43029 281942 388795 399598 403252 407389 411599 417657 444117 445141 447818 448598 454728 454902 458902 459466 459833 460199 465583 468812 472378 476052 477227 477411 477500 477525 478007 479931 483335 490211 499369 500861 505331 513814 524548 525373 526079 528183 529620 530044 531009 531299 532654 532872 537026 537280 543427 557292 559965 560255 560898 563361 563912 569614 572268 575935 583350 585633 586988 589947 596074 599347 602136 610251 611183 611260 618071 622663 624265 624298 636413 639481 641842 646863 689885 692697 702060 712930 717717 737524 742240 743172 743244 744060 744189 751637 765808 777150 777314 779373 783335 783375 788499 788522 789990 791033 798311 798439 798479 801826 803025 805142 805560 808330 814166 814208 816834 816874 817185 818743 819089 819123 819229 819257 820170 821524 822313 825100 825132 ] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sport masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"спортивная мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.46 ms (1.06%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.46 ms (1.06%) |
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.