Query Metrics
7
Database Queries
7
Different statements
172.09 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
151.12 ms (87.81%) |
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 73724 402936 486146 526351 563291 571947 575591 602495 603601 604037 605730 615184 622850 622891 626050 632545 652552 652905 662443 668127 668585 674131 674233 679533 680370 681745 685406 687447 703571 706643 710893 712397 714213 717806 719321 719373 721762 725333 726939 727486 728199 729416 729871 730815 731075 731076 734732 735118 736608 737284 737969 744146 744814 748966 751963 752875 753037 755246 756709 757887 759813 760515 761277 761686 763831 763993 764623 765061 765071 765072 765101 765109 766370 766885 769046 771957 772597 775407 775659 775996 776679 777227 777854 779981 781579 782721 782957 783975 785794 786227 786320 786380 786877 788649 789897 792205 792295 792519 793453 793607 794145 795381 798809 799879 800960 805686 810270 814558 817969 819379 819941 821414 821490 821600 822651 822838 823036 825188 825794 828280 ] |
||||||||||||||||||||||||||||||
|
11.36 ms (6.60%) |
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 526351 821414 668127 602495 761686 781579 805686 765101 765109 726939 735118 814558 819379 828280 674233 775407 792295 744814 765072 794145 728199 766885 729871 748966 763831 776679 825188 679533 779981 793607 782721 786320 769046 772597 759813 761277 821600 823036 821490 563291 703571 719321 721762 685406 714213 719373 603601 622850 604037 622891 626050 632545 792205 783975 786380 725333 737284 757887 786877 792519 730815 731076 736608 766370 734732 753037 771957 755246 775996 777227 777854 782957 798809 799879 810270 402936 680370 710893 793453 731075 825794 819941 652905 712397 789897 729416 751963 817969 822838 822651 652552 662443 674131 571947 615184 786227 788649 756709 764623 763993 785794 765071 73724 486146 575591 681745 668585 687447 605730 775659 800960 795381 744146 752875 765061 727486 737969 760515 706643 717806 ] |
||||||||||||||||||||||||||||||
|
2.79 ms (1.62%) |
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 73724 402936 486146 526351 563291 571947 575591 602495 603601 604037 605730 615184 622850 622891 626050 632545 652552 652905 662443 668127 668585 674131 674233 679533 680370 681745 685406 687447 703571 706643 710893 712397 714213 717806 719321 719373 721762 725333 726939 727486 728199 729416 729871 730815 731075 731076 734732 735118 736608 737284 737969 744146 744814 748966 751963 752875 753037 755246 756709 757887 759813 760515 761277 761686 763831 763993 764623 765061 765071 765072 765101 765109 766370 766885 769046 771957 772597 775407 775659 775996 776679 777227 777854 779981 781579 782721 782957 783975 785794 786227 786320 786380 786877 788649 789897 792205 792295 792519 793453 793607 794145 795381 798809 799879 800960 805686 810270 814558 817969 819379 819941 821414 821490 821600 822651 822838 823036 825188 825794 828280 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"real sex teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"real секс teens"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.38 ms (0.80%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"real секс teens"
]
|
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.