Query Metrics
7
Database Queries
7
Different statements
421.03 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
394.74 ms (93.76%) |
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 81869 188079 201531 233473 343078 366283 382699 382943 383227 383521 384142 388755 390293 390593 391075 395862 398104 398919 407191 410873 419126 422227 484131 521780 530828 532367 533338 534907 542346 542489 544757 544879 548900 552005 556432 566583 567462 585340 590871 597507 600058 601831 603572 606823 609284 615016 617692 619585 622005 623335 630668 633049 633884 636267 644656 649627 651888 651889 651912 654094 663869 667337 672492 675906 684369 693188 693765 694128 697770 703211 705893 714115 715192 718919 721417 729659 731431 731784 731794 732060 732751 736768 737752 742185 744588 746082 748664 749557 750080 752537 754198 755449 766944 772072 781902 785289 787914 789108 792510 792511 794799 798930 799015 799246 801474 803793 807498 807612 807624 807693 810309 811181 817039 819176 820549 822052 823419 825899 826480 827830 ] |
||||||||||||||||||||||||||||||
|
16.67 ms (3.96%) |
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 822052 823419 820549 819176 826480 521780 542489 566583 654094 694128 705893 718919 649627 663869 684369 693188 714115 544757 600058 619585 623335 633049 644656 601831 603572 781902 787914 798930 801474 811181 789108 794799 803793 729659 752537 754198 792510 799246 749557 731794 732751 744588 750080 755449 617692 799015 810309 201531 366283 343078 81869 233473 382943 384142 398104 407191 410873 827830 533338 534907 532367 633884 585340 590871 807693 785289 766944 772072 382699 383521 742185 383227 398919 419126 825899 530828 542346 544879 567462 556432 548900 697770 703211 630668 636267 615016 597507 606823 807624 736768 737752 807498 807612 390293 552005 792511 395862 672492 731431 391075 721417 732060 731784 748664 651888 651889 622005 746082 693765 675906 651912 188079 667337 422227 388755 390593 817039 484131 715192 609284 ] |
||||||||||||||||||||||||||||||
|
3.16 ms (0.75%) |
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 81869 188079 201531 233473 343078 366283 382699 382943 383227 383521 384142 388755 390293 390593 391075 395862 398104 398919 407191 410873 419126 422227 484131 521780 530828 532367 533338 534907 542346 542489 544757 544879 548900 552005 556432 566583 567462 585340 590871 597507 600058 601831 603572 606823 609284 615016 617692 619585 622005 623335 630668 633049 633884 636267 644656 649627 651888 651889 651912 654094 663869 667337 672492 675906 684369 693188 693765 694128 697770 703211 705893 714115 715192 718919 721417 729659 731431 731784 731794 732060 732751 736768 737752 742185 744588 746082 748664 749557 750080 752537 754198 755449 766944 772072 781902 785289 787914 789108 792510 792511 794799 798930 799015 799246 801474 803793 807498 807612 807624 807693 810309 811181 817039 819176 820549 822052 823419 825899 826480 827830 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс втро жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.37%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.54 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс втро жмж секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"trio ffm"
]
|
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.