Query Metrics
7
Database Queries
7
Different statements
190.43 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
166.50 ms (87.43%) |
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 143235 254390 382073 391482 395516 396768 399020 401968 402999 426183 433721 435579 444739 455569 460207 469706 476534 485184 488356 490826 504938 510774 512483 534785 542493 555915 559312 563383 569035 582828 583201 587558 595981 596153 597670 598862 599122 601199 607199 612089 615359 660762 670715 670891 682735 688632 698531 699292 702309 703439 705442 708905 709385 713574 714752 717645 720410 728521 732600 733204 735998 736021 736368 736908 742331 743822 745002 748812 751821 753204 755492 756798 756877 757421 758284 758355 758649 765803 769522 773247 778752 782680 783953 784633 785184 785188 785482 786781 787295 787630 787829 789480 789740 790023 790813 791284 792507 795449 799473 801361 802872 806403 806742 806836 807321 808444 810680 810798 811110 811313 811840 813416 813431 813471 813494 813728 815508 818451 827080 827903 ] |
||||||||||||||||||||||||||||||
|
13.52 ms (7.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 391482 402999 254390 401968 435579 396768 476534 455569 469706 485184 488356 582828 555915 733204 395516 382073 399020 444739 433721 426183 815508 827080 813728 818451 827903 460207 490826 504938 510774 512483 534785 559312 569035 583201 563383 542493 660762 670891 702309 682735 688632 698531 703439 713574 717645 670715 714752 720410 596153 599122 607199 597670 587558 601199 595981 598862 785188 790023 791284 801361 802872 806403 806836 810798 778752 782680 784633 786781 789480 790813 792507 810680 813431 736021 736368 756877 758284 785184 787295 787630 789740 799473 807321 808444 811313 813416 813471 813494 732600 735998 742331 751821 753204 755492 728521 748812 756798 758649 769522 743822 758355 736908 745002 757421 765803 773247 612089 615359 699292 705442 708905 709385 783953 785482 787829 795449 806742 811110 811840 143235 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.40%) |
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 143235 254390 382073 391482 395516 396768 399020 401968 402999 426183 433721 435579 444739 455569 460207 469706 476534 485184 488356 490826 504938 510774 512483 534785 542493 555915 559312 563383 569035 582828 583201 587558 595981 596153 597670 598862 599122 601199 607199 612089 615359 660762 670715 670891 682735 688632 698531 699292 702309 703439 705442 708905 709385 713574 714752 717645 720410 728521 732600 733204 735998 736021 736368 736908 742331 743822 745002 748812 751821 753204 755492 756798 756877 757421 758284 758355 758649 765803 769522 773247 778752 782680 783953 784633 785184 785188 785482 786781 787295 787630 787829 789480 789740 790023 790813 791284 792507 795449 799473 801361 802872 806403 806742 806836 807321 808444 810680 810798 811110 811313 811840 813416 813431 813471 813494 813728 815508 818451 827080 827903 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"not my mom"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (0.90%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"my mom"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.88%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"my mom"
]
|
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.