Query Metrics
7
Database Queries
7
Different statements
377.78 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.12 ms (56.41%) |
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 317866 325706 383274 386264 388805 390827 392817 394152 397997 410331 448678 451687 451694 453312 463896 476297 491788 492840 494758 505722 505899 506924 507138 507532 509310 509596 511061 511309 519754 522448 526535 529422 530130 535898 539800 544503 547035 548590 555502 565126 565627 567116 567628 568202 575997 578704 580033 580886 582153 582792 584430 584434 586552 590734 595434 595590 596251 596778 599472 600614 602328 602343 602704 603396 604634 604808 604854 604863 606082 620401 620403 628589 638181 638742 661031 661410 666808 667199 667649 667672 671328 676208 680538 680570 687144 695867 699267 700855 703949 705677 707483 707529 709790 709960 710001 710228 712081 712177 712283 714203 715732 743858 749578 750395 756914 772547 776421 790323 793917 796272 798829 804649 810384 810996 814498 814988 815941 822646 824735 825190 ] |
||||||||||||||||||||||||||||||
|
137.56 ms (36.41%) |
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 317866 325706 383274 386264 388805 390827 392817 394152 397997 410331 448678 451687 451694 453312 463896 476297 491788 492840 494758 505722 505899 506924 507138 507532 509310 509596 511061 511309 519754 522448 526535 529422 530130 535898 539800 544503 547035 548590 555502 565126 565627 567116 567628 568202 575997 578704 580033 580886 582153 582792 584430 584434 586552 590734 595434 595590 596251 596778 599472 600614 602328 602343 602704 603396 604634 604808 604854 604863 606082 620401 620403 628589 638181 638742 661031 661410 666808 667199 667649 667672 671328 676208 680538 680570 687144 695867 699267 700855 703949 705677 707483 707529 709790 709960 710001 710228 712081 712177 712283 714203 715732 743858 749578 750395 756914 772547 776421 790323 793917 796272 798829 804649 810384 810996 814498 814988 815941 822646 824735 825190 ] |
||||||||||||||||||||||||||||||
|
20.31 ms (5.38%) |
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 386264 383274 317866 390827 815941 680538 699267 709960 712283 600614 590734 604808 595590 606082 790323 793917 810384 756914 749578 712081 715732 392817 388805 397997 822646 824735 453312 582153 667672 603396 804649 772547 750395 743858 798829 810996 325706 529422 825190 491788 505899 509310 511309 526535 539800 519754 511061 530130 565126 555502 582792 584434 712177 580033 602328 604634 602343 602704 796272 394152 522448 410331 814498 814988 451694 448678 451687 476297 492840 507138 507532 509596 535898 505722 494758 506924 463896 548590 565627 578704 544503 547035 575997 580886 584430 567628 661410 666808 671328 703949 705677 707483 707529 709790 661031 667199 676208 695867 710001 667649 680570 687144 700855 710228 714203 567116 568202 596251 604863 628589 638181 586552 595434 596778 620401 620403 599472 604854 638742 776421 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"boobs tits"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.43%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (0.43%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"boobs сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"boobs сиськ"
]
|
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.