Query Metrics
7
Database Queries
7
Different statements
159.75 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.78 ms (84.37%) |
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 25461 387046 398519 403377 405623 422641 423845 424720 424739 424742 427081 432256 445206 448643 452208 458738 459820 464979 467133 467134 467172 470609 471580 474564 475188 478693 479561 479996 488221 492355 492668 501835 506483 509834 512337 513891 515790 522273 524011 524277 526015 527535 541967 549163 551142 552135 552138 552144 552358 558410 563516 564735 566746 568847 569954 572858 575054 575084 575129 575743 575758 578065 584633 584661 589141 589737 589785 591236 594760 594853 594950 599475 601265 603027 606179 611588 611716 611890 611894 611933 611941 612029 612038 617675 618774 619120 620653 622587 630607 632279 643247 643652 645316 664514 667799 667846 671306 682763 687420 691674 698450 712558 714127 715148 716547 721438 724863 729588 731092 735846 758201 765529 776776 777678 780752 796507 797905 799453 810682 ] |
||||||||||||||||||||||||||||||
|
15.19 ms (9.51%) |
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 575129 664514 687420 721438 667846 599475 612029 731092 617675 714127 479996 424720 603027 467133 572858 552138 552358 563516 566746 589141 632279 729588 715148 475188 478693 448643 552135 645316 682763 643652 591236 735846 765529 459820 522273 492668 620653 691674 611890 716547 810682 622587 589737 619120 643247 780752 536850 568847 575054 667799 594950 797905 724863 423845 398519 467172 424739 445206 526015 611894 776776 474564 387046 471580 569954 549163 564735 589785 594853 606179 630607 799453 422641 470609 515790 513891 552144 601265 611588 611933 405623 458738 509834 492355 541967 758201 612038 698450 611716 575084 594760 777678 611941 25461 712558 618774 796507 479561 452208 506483 524277 488221 578065 584661 575758 671306 403377 427081 501835 512337 524011 432256 424742 464979 467134 527535 584633 551142 558410 575743 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.69%) |
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 25461 387046 398519 403377 405623 422641 423845 424720 424739 424742 427081 432256 445206 448643 452208 458738 459820 464979 467133 467134 467172 470609 471580 474564 475188 478693 479561 479996 488221 492355 492668 501835 506483 509834 512337 513891 515790 522273 524011 524277 526015 527535 541967 549163 551142 552135 552138 552144 552358 558410 563516 564735 566746 568847 569954 572858 575054 575084 575129 575743 575758 578065 584633 584661 589141 589737 589785 591236 594760 594853 594950 599475 601265 603027 606179 611588 611716 611890 611894 611933 611941 612029 612038 617675 618774 619120 620653 622587 630607 632279 643247 643652 645316 664514 667799 667846 671306 682763 687420 691674 698450 712558 714127 715148 716547 721438 724863 729588 731092 735846 758201 765529 776776 777678 780752 796507 797905 799453 810682 ] |
||||||||||||||||||||||||||||||
|
1.94 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"money секс"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.14%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"money fuck"
]
|
||||||||||||||||||||||||||||||
|
1.42 ms (0.89%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"money секс"
]
|
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.