Query Metrics
7
Database Queries
7
Different statements
212.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.92 ms (88.82%) |
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 385701 417609 417983 449894 460375 463969 471062 472718 485723 489826 498095 498218 500159 506954 510574 513129 522657 522754 523807 524876 530279 534194 534241 537671 545494 545811 549749 551927 552889 556204 567322 568147 569334 571666 572024 572900 575185 578126 578132 583549 586569 589595 590246 601663 601923 603691 604245 605727 606238 610044 613810 614144 614450 618735 618815 624266 624646 625259 627660 629965 636578 641445 648567 648740 652282 653333 654421 678334 679050 685856 693074 695488 695691 697155 706411 708964 717897 720535 720698 725036 725933 726520 726544 727055 732964 737082 740084 741104 742869 744319 744444 744850 745955 746134 750785 753486 757365 766693 769752 772064 772788 781173 781912 782253 788086 788469 790148 797126 797551 798579 798889 800791 802631 803187 804230 804518 806886 808374 808636 811546 ] |
||||||||||||||||||||||||||||||
|
13.54 ms (6.36%) |
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 769752 697155 641445 530279 652282 678334 772788 808636 726520 510574 601663 788469 679050 797551 648567 571666 636578 800791 725933 811546 685856 717897 781173 753486 601923 472718 802631 808374 417609 720535 798579 498095 567322 613810 551927 781912 744319 417983 625259 614450 788086 750785 629965 744850 804518 589595 498218 583549 624646 737082 804230 489826 653333 695691 706411 605727 618815 806886 732964 624266 449894 485723 695488 552889 569334 790148 740084 741104 727055 610044 798889 385701 522657 500159 545494 590246 744444 742869 746134 708964 572024 725036 522754 627660 545811 606238 534241 720698 782253 534194 556204 603691 797126 460375 523807 693074 513129 654421 578132 506954 614144 586569 604245 772064 757365 745955 618735 803187 471062 537671 648740 463969 549749 572900 568147 575185 578126 726544 766693 524876 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"хорош минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
2.34 ms (1.10%) |
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 385701 417609 417983 449894 460375 463969 471062 472718 485723 489826 498095 498218 500159 506954 510574 513129 522657 522754 523807 524876 530279 534194 534241 537671 545494 545811 549749 551927 552889 556204 567322 568147 569334 571666 572024 572900 575185 578126 578132 583549 586569 589595 590246 601663 601923 603691 604245 605727 606238 610044 613810 614144 614450 618735 618815 624266 624646 625259 627660 629965 636578 641445 648567 648740 652282 653333 654421 678334 679050 685856 693074 695488 695691 697155 706411 708964 717897 720535 720698 725036 725933 726520 726544 727055 732964 737082 740084 741104 742869 744319 744444 744850 745955 746134 750785 753486 757365 766693 769752 772064 772788 781173 781912 782253 788086 788469 790148 797126 797551 798579 798889 800791 802631 803187 804230 804518 806886 808374 808636 811546 ] |
||||||||||||||||||||||||||||||
|
2.03 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"хороший отсос"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"хорош минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (0.80%) |
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.