Query Metrics
7
Database Queries
7
Different statements
152.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.01 ms (83.53%) |
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 97156 391893 402982 403834 410857 413730 444240 469494 488571 500551 507809 509228 524121 528571 530287 533680 535693 540967 545080 545979 548752 557949 560368 562765 565224 566187 566391 566423 566431 566434 566451 566463 566464 568192 577209 581427 583688 585750 591165 591170 593884 604679 605029 606521 621371 622131 630578 635791 635871 635877 636510 640697 644538 645050 645749 649086 649250 649626 651301 653328 653347 653366 653600 653914 653915 653917 654282 654291 654652 657254 662019 663546 665732 673533 675233 675934 675986 676836 677460 680588 681785 682914 693596 693772 694310 710320 714279 720916 732257 732850 733347 739858 748741 755121 759766 762269 764955 773961 775893 775896 776276 784323 784452 786065 793175 793555 796964 797402 797936 799553 799929 809533 809534 809636 812429 813044 818465 826217 827068 827898 ] |
||||||||||||||||||||||||||||||
|
13.01 ms (8.56%) |
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 681785 653328 583688 581427 560368 413730 748741 680588 528571 693596 622131 533680 649626 654282 653366 665732 566423 605029 759766 585750 733347 635871 732850 530287 566187 566451 507809 663546 509228 548752 809636 784323 540967 799929 797402 675986 776276 793555 653915 654291 402982 566431 566464 621371 562765 809534 565224 566391 714279 606521 568192 813044 732257 812429 793175 566463 673533 577209 764955 720916 651301 545080 797936 775896 827068 755121 640697 488571 677460 654652 604679 645749 653914 773961 786065 410857 693772 653917 500551 827898 535693 566434 545979 645050 649086 649250 653347 653600 657254 662019 694310 635791 593884 635877 630578 826217 469494 675934 591170 391893 762269 636510 739858 97156 676836 809533 557949 591165 524121 644538 403834 444240 682914 675233 799553 775893 818465 784452 796964 710320 ] |
||||||||||||||||||||||||||||||
|
4.43 ms (2.91%) |
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 97156 391893 402982 403834 410857 413730 444240 469494 488571 500551 507809 509228 524121 528571 530287 533680 535693 540967 545080 545979 548752 557949 560368 562765 565224 566187 566391 566423 566431 566434 566451 566463 566464 568192 577209 581427 583688 585750 591165 591170 593884 604679 605029 606521 621371 622131 630578 635791 635871 635877 636510 640697 644538 645050 645749 649086 649250 649626 651301 653328 653347 653366 653600 653914 653915 653917 654282 654291 654652 657254 662019 663546 665732 673533 675233 675934 675986 676836 677460 680588 681785 682914 693596 693772 694310 710320 714279 720916 732257 732850 733347 739858 748741 755121 759766 762269 764955 773961 775893 775896 776276 784323 784452 786065 793175 793555 796964 797402 797936 799553 799929 809533 809534 809636 812429 813044 818465 826217 827068 827898 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"домашнее видео втроёÐâ…"
]
|
||||||||||||||||||||||||||||||
|
2.04 ms (1.34%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск виде секс втро"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (1.08%) |
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.