Query Metrics
7
Database Queries
7
Different statements
173.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.39 ms (86.88%) |
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 3638 403136 416434 427911 450133 455165 455274 459431 461474 472881 477479 481718 497174 514755 519182 529699 542348 545303 551485 553115 553684 558662 558893 574469 578535 579977 583795 584583 588618 592123 605180 617509 620940 621183 628903 635576 636057 643071 645593 646052 646719 662925 675581 676215 676430 676657 680781 680900 688386 699518 700379 700928 705705 707457 708052 708254 710466 710541 711327 714931 716669 717202 718367 724396 726920 728060 728702 737557 737644 738836 739906 740037 740175 744340 750342 752509 754073 760241 760874 761314 761795 763518 765715 765717 765805 767377 769287 771986 773187 778410 780873 784197 784299 785962 787927 789927 791531 792685 794877 795303 795942 796294 799508 799549 800586 800994 801440 801702 802806 803532 804028 806819 808855 809874 810195 811704 812359 819948 823468 824031 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (7.83%) |
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 558662 542348 676215 688386 714931 716669 636057 809874 787927 760241 784197 808855 737644 728060 739906 752509 760874 771986 740175 744340 767377 738836 740037 761314 763518 778410 791531 792685 804028 806819 455165 3638 481718 784299 646052 592123 553115 635576 796294 416434 810195 461474 427911 819948 823468 455274 472881 514755 700379 558893 584583 780873 789927 795942 800586 794877 795303 801440 811704 750342 761795 773187 801702 726920 754073 724396 728702 765717 769287 765715 717202 785962 799508 799549 800994 802806 812359 529699 551485 583795 578535 574469 579977 646719 699518 708254 711327 675581 676657 645593 662925 676430 680781 680900 710466 620940 643071 621183 628903 588618 605180 617509 803532 765805 737557 700928 705705 710541 459431 497174 718367 707457 708052 545303 403136 824031 477479 450133 519182 553684 ] |
||||||||||||||||||||||||||||||
|
2.35 ms (1.36%) |
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 3638 403136 416434 427911 450133 455165 455274 459431 461474 472881 477479 481718 497174 514755 519182 529699 542348 545303 551485 553115 553684 558662 558893 574469 578535 579977 583795 584583 588618 592123 605180 617509 620940 621183 628903 635576 636057 643071 645593 646052 646719 662925 675581 676215 676430 676657 680781 680900 688386 699518 700379 700928 705705 707457 708052 708254 710466 710541 711327 714931 716669 717202 718367 724396 726920 728060 728702 737557 737644 738836 739906 740037 740175 744340 750342 752509 754073 760241 760874 761314 761795 763518 765715 765717 765805 767377 769287 771986 773187 778410 780873 784197 784299 785962 787927 789927 791531 792685 794877 795303 795942 796294 799508 799549 800586 800994 801440 801702 802806 803532 804028 806819 808855 809874 810195 811704 812359 819948 823468 824031 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск doggystyle"
]
|
||||||||||||||||||||||||||||||
|
1.32 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск doggystyle"
]
|
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.