Query Metrics
7
Database Queries
7
Different statements
176.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.21 ms (84.39%) |
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 471049 510724 510917 515284 530419 530717 530961 531009 536081 536093 537453 537486 538015 539315 539388 541414 545155 546167 548343 552915 553226 554869 557872 558734 559422 559425 559438 561781 565688 572682 576424 576485 576528 576784 579496 585654 594375 596542 607953 609727 610127 610198 610237 612979 614460 614936 622300 629809 641652 643326 648960 651737 652986 659465 660808 666142 670399 670437 670802 672743 676696 678677 692728 699544 706073 710875 713046 715285 722406 723030 726814 740809 742240 743179 743239 744000 744027 744211 744805 751743 752990 754338 756817 773055 773638 774035 774884 776780 777150 777791 777831 781268 781305 782051 783171 783568 784174 786803 787067 790735 791520 791837 792369 792414 796508 797184 797196 801662 801815 804077 804663 806806 810471 816705 818301 819424 820058 824256 825371 ] |
||||||||||||||||||||||||||||||
|
19.24 ms (10.88%) |
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 824256 816705 818301 819424 820058 825371 510917 515284 530717 536081 539315 510724 530419 530961 531009 537453 537486 539388 536093 538015 471049 548343 541414 545155 579496 557872 565688 572682 576784 648960 652986 660808 672743 676696 699544 651737 670399 670437 670802 692728 706073 710875 713046 723030 659465 666142 678677 715285 722406 546167 552915 553226 554869 558734 559422 559425 559438 561781 576424 576485 576528 585654 610198 610237 594375 610127 614936 622300 607953 609727 612979 643326 588152 596542 614460 629809 641652 774884 782051 791837 792414 797196 801815 806806 776780 777150 777791 777831 781305 783568 790735 797184 801662 804663 810471 740809 742240 743179 744027 744211 752990 756817 773055 773638 774035 781268 783171 784174 786803 787067 791520 792369 796508 804077 726814 743239 744000 744805 751743 754338 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.24%) |
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 471049 510724 510917 515284 530419 530717 530961 531009 536081 536093 537453 537486 538015 539315 539388 541414 545155 546167 548343 552915 553226 554869 557872 558734 559422 559425 559438 561781 565688 572682 576424 576485 576528 576784 579496 585654 594375 596542 607953 609727 610127 610198 610237 612979 614460 614936 622300 629809 641652 643326 648960 651737 652986 659465 660808 666142 670399 670437 670802 672743 676696 678677 692728 699544 706073 710875 713046 715285 722406 723030 726814 740809 742240 743179 743239 744000 744027 744211 744805 751743 752990 754338 756817 773055 773638 774035 774884 776780 777150 777791 777831 781268 781305 782051 783171 783568 784174 786803 787067 790735 791520 791837 792369 792414 796508 797184 797196 801662 801815 804077 804663 806806 810471 816705 818301 819424 820058 824256 825371 ] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац pussy"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"solo masturbation pussy"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.88%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"соло мастурбац pussy"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.69%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.