Query Metrics
7
Database Queries
7
Different statements
174.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.08 ms (84.96%) |
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 182110 398099 398300 414082 416656 422101 441093 448012 448082 452846 452914 466639 493838 500320 512079 513460 515950 516597 518905 519350 523273 531892 536236 536388 542705 542711 546057 548969 548973 554827 562183 566739 568530 575935 576534 577344 582020 589621 590038 595438 600423 600450 616013 623275 628602 634027 650305 656812 656826 656938 657561 658845 661676 667324 668305 671094 671529 680801 681787 686139 687810 696143 697833 706422 707819 707895 712881 713240 722378 725739 733798 736809 736971 738451 740820 745114 745119 745121 749118 749204 749256 749685 750344 751294 751308 752619 752657 752752 756832 760436 760649 765617 765677 767745 768244 770379 770860 781326 782436 785552 785606 785855 788529 792089 793266 799683 799699 800528 803092 803101 804766 805813 810076 813635 813819 824766 826804 ] |
||||||||||||||||||||||||||||||
|
17.51 ms (10.04%) |
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 448082 523273 542711 696143 697833 616013 824766 546057 182110 414082 803092 707895 668305 600450 712881 566739 657561 589621 590038 767745 804766 667324 512079 785552 785606 706422 628602 736971 448012 536388 813635 826804 500320 548973 568530 656812 658845 661676 671094 686139 687810 722378 656826 656938 680801 707819 548969 554827 576534 600423 634027 623275 785855 793266 800528 782436 803101 736809 752752 760436 788529 799699 738451 745114 749204 752657 770379 749256 770860 745121 765677 749685 751294 756832 765617 768244 792089 582020 595438 750344 725739 542705 823492 813819 536236 531892 516597 575935 681787 805813 733798 757736 749118 745119 740820 441093 422101 493838 513460 515950 466639 519350 671529 650305 781326 595376 760649 518905 713240 810076 751308 752619 799683 398300 452846 398099 416656 452914 562183 577344 ] |
||||||||||||||||||||||||||||||
|
2.28 ms (1.31%) |
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 182110 398099 398300 414082 416656 422101 441093 448012 448082 452846 452914 466639 493838 500320 512079 513460 515950 516597 518905 519350 523273 531892 536236 536388 542705 542711 546057 548969 548973 554827 562183 566739 568530 575935 576534 577344 582020 589621 590038 595438 600423 600450 616013 623275 628602 634027 650305 656812 656826 656938 657561 658845 661676 667324 668305 671094 671529 680801 681787 686139 687810 696143 697833 706422 707819 707895 712881 713240 722378 725739 733798 736809 736971 738451 740820 745114 745119 745121 749118 749204 749256 749685 750344 751294 751308 752619 752657 752752 756832 760436 760649 765617 765677 767745 768244 770379 770860 781326 782436 785552 785606 785855 788529 792089 793266 799683 799699 800528 803092 803101 804766 805813 810076 813635 813819 824766 826804 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"masturbation anal solo"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мастурбац анал соло"
]
|
||||||||||||||||||||||||||||||
|
1.34 ms (0.77%) |
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.