Query Metrics
7
Database Queries
7
Different statements
218.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.57 ms (86.31%) |
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 410905 416022 418215 422380 430374 433981 434321 434355 434374 435005 437496 437929 440876 444168 444189 444527 448369 448898 450697 456385 456593 456857 463384 467877 467882 476670 478010 478023 480647 484206 495381 502861 504725 505589 506239 509019 510898 513741 513938 515452 520651 524237 526604 528122 541575 547794 555984 562384 571316 571697 590102 590410 591197 592862 593974 595660 599001 608174 609926 614910 620689 623832 653187 653452 653560 659690 659793 661268 663293 666530 669893 669905 675179 678611 685807 688922 690666 690952 695708 699928 709914 718678 718746 725524 731813 735194 736959 741851 744786 744896 746087 750699 751312 751316 753902 756480 758163 766150 767419 771452 777830 779780 779870 781429 782547 782731 784792 787043 789188 790038 791365 791489 791623 798059 802282 803880 805995 809484 810896 825864 ] |
||||||||||||||||||||||||||||||
|
17.58 ms (8.05%) |
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 590410 750699 478010 653452 592862 440876 456385 476670 562384 571697 659793 669893 480647 416022 513938 509019 528122 504725 718746 653187 663293 669905 685807 608174 593974 599001 779780 782731 789188 791365 798059 771452 735194 758163 744896 746087 753902 736959 751312 751316 614910 777830 791623 803880 433981 437496 825864 555984 541575 718678 666530 623832 590102 609926 791489 434374 467877 467882 444527 430374 510898 653560 484206 495381 513741 505589 571316 688922 690666 690952 695708 659690 675179 678611 699928 709914 595660 620689 782547 784792 787043 802282 725524 781429 810896 744786 756480 741851 766150 767419 779870 790038 805995 809484 410905 448898 463384 478023 731813 435005 524237 591197 422380 456857 547794 434321 434355 448369 444168 444189 456593 418215 437929 450697 515452 526604 506239 502861 520651 661268 ] |
||||||||||||||||||||||||||||||
|
4.05 ms (1.86%) |
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 410905 416022 418215 422380 430374 433981 434321 434355 434374 435005 437496 437929 440876 444168 444189 444527 448369 448898 450697 456385 456593 456857 463384 467877 467882 476670 478010 478023 480647 484206 495381 502861 504725 505589 506239 509019 510898 513741 513938 515452 520651 524237 526604 528122 541575 547794 555984 562384 571316 571697 590102 590410 591197 592862 593974 595660 599001 608174 609926 614910 620689 623832 653187 653452 653560 659690 659793 661268 663293 666530 669893 669905 675179 678611 685807 688922 690666 690952 695708 699928 709914 718678 718746 725524 731813 735194 736959 741851 744786 744896 746087 750699 751312 751316 753902 756480 758163 766150 767419 771452 777830 779780 779870 781429 782547 782731 784792 787043 789188 790038 791365 791489 791623 798059 802282 803880 805995 809484 810896 825864 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.25%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"русская дрожит"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск оргазм"
]
|
||||||||||||||||||||||||||||||
|
1.85 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.