Query Metrics
7
Database Queries
7
Different statements
162.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
132.03 ms (81.30%) |
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 387149 388175 418762 424063 436046 436075 437991 440994 441800 441962 445721 445752 446215 446241 446561 449310 449572 451157 452682 452925 452997 456856 459258 459996 460638 461360 461658 480498 485294 492140 503889 504079 504851 514879 522052 536080 545222 554823 555610 564954 575560 583347 585554 586757 590804 596402 598525 599528 603245 605046 609146 609930 610138 614338 615710 617793 620518 620880 628522 629733 630270 637156 646081 663528 666120 669331 669652 705466 707463 708692 709651 712939 714479 714921 725462 736692 738433 740848 749430 750296 751528 753193 757057 757234 758248 758992 760602 765490 765863 766441 768655 776524 782553 783211 784113 784126 784127 784643 785087 785348 787771 791507 794637 795008 795352 796629 800727 801181 802282 803767 804614 804622 804668 804696 807611 808037 811705 817173 819759 826715 ] |
||||||||||||||||||||||||||||||
|
21.28 ms (13.10%) |
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 452997 449310 449572 461360 452682 456856 504079 522052 536080 503889 461658 554823 555610 564954 545222 575560 669652 712939 663528 669331 708692 666120 620880 585554 590804 603245 609930 610138 629733 776524 787771 811705 791507 795008 802282 804614 804668 740848 760602 766441 785348 803767 804696 725462 765863 738433 749430 751528 753193 758992 617793 707463 782553 808037 436075 436046 446215 441962 441800 452925 459996 714479 615710 424063 418762 826715 819759 445721 451157 459258 514879 492140 583347 714921 646081 705466 598525 609146 628522 596402 599528 630270 586757 605046 614338 800727 801181 794637 796629 804622 757057 757234 765490 783211 784113 784126 784127 785087 795352 807611 750296 758248 768655 637156 709651 784643 480498 460638 445752 446241 504851 485294 736692 620518 387149 388175 437991 440994 817173 446561 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.78%) |
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 387149 388175 418762 424063 436046 436075 437991 440994 441800 441962 445721 445752 446215 446241 446561 449310 449572 451157 452682 452925 452997 456856 459258 459996 460638 461360 461658 480498 485294 492140 503889 504079 504851 514879 522052 536080 545222 554823 555610 564954 575560 583347 585554 586757 590804 596402 598525 599528 603245 605046 609146 609930 610138 614338 615710 617793 620518 620880 628522 629733 630270 637156 646081 663528 666120 669331 669652 705466 707463 708692 709651 712939 714479 714921 725462 736692 738433 740848 749430 750296 751528 753193 757057 757234 758248 758992 760602 765490 765863 766441 768655 776524 782553 783211 784113 784126 784127 784643 785087 785348 787771 791507 794637 795008 795352 796629 800727 801181 802282 803767 804614 804622 804668 804696 807611 808037 811705 817173 819759 826715 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife fingering"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.07%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.34 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен fingering"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен fingering"
]
|
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.