Query Metrics
7
Database Queries
7
Different statements
144.66 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
118.95 ms (82.23%) |
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 401427 412620 418132 422140 426298 433981 436116 446954 448774 449236 449310 449572 449668 451334 452997 457056 473747 493908 505601 515673 526616 530416 533397 542181 548840 559347 561920 564889 574998 585831 589927 591535 594396 600795 609673 612905 613899 615695 617789 620547 624688 624752 625793 628602 634905 635067 636161 636610 638198 639363 640827 641250 650649 651770 663193 664094 664181 678895 680346 682642 684516 687620 693779 706000 706422 709364 710360 716350 734184 735756 739718 739908 740527 744460 745470 748378 750626 753655 757012 757518 758276 759115 760609 766349 768494 768575 768952 769514 770049 773187 773747 774880 776796 784122 784853 784962 785526 787221 790403 790685 791386 794968 796284 796375 796899 801841 801990 802003 802578 803819 803822 804249 804793 808713 808880 810806 811885 812054 813752 819157 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (10.50%) |
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 684516 710360 561920 634905 636610 585831 612905 624752 600795 776796 784122 785526 794968 784962 790685 796375 745470 770049 773187 734184 739718 739908 758276 760609 768494 757012 766349 769514 636161 638198 709364 774880 784853 802578 493908 635067 533397 693779 808713 436116 819157 446954 448774 449236 457056 530416 505601 526616 559347 574998 542181 564889 650649 664094 706422 651770 678895 687620 706000 663193 664181 680346 682642 548840 591535 613899 615695 624688 625793 628602 639363 640827 589927 594396 609673 617789 641250 790403 791386 801841 796284 803819 810806 735756 750626 768952 787221 803822 804793 812054 744460 740527 759115 753655 773747 748378 757518 796899 801990 804249 811885 401427 433981 412620 451334 473747 449668 515673 620547 808880 802003 716350 768575 426298 422140 418132 813752 452997 449310 449572 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (1.94%) |
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 401427 412620 418132 422140 426298 433981 436116 446954 448774 449236 449310 449572 449668 451334 452997 457056 473747 493908 505601 515673 526616 530416 533397 542181 548840 559347 561920 564889 574998 585831 589927 591535 594396 600795 609673 612905 613899 615695 617789 620547 624688 624752 625793 628602 634905 635067 636161 636610 638198 639363 640827 641250 650649 651770 663193 664094 664181 678895 680346 682642 684516 687620 693779 706000 706422 709364 710360 716350 734184 735756 739718 739908 740527 744460 745470 748378 750626 753655 757012 757518 758276 759115 760609 766349 768494 768575 768952 769514 770049 773187 773747 774880 776796 784122 784853 784962 785526 787221 790403 790685 791386 794968 796284 796375 796899 801841 801990 802003 802578 803819 803822 804249 804793 808713 808880 810806 811885 812054 813752 819157 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (1.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"fingering жен"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (1.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"fingering wife"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.24%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"fingering жен"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.