Query Metrics
7
Database Queries
7
Different statements
182.08 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
157.55 ms (86.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 386858 418692 424429 425215 432350 443408 452925 454055 465579 471107 472864 476163 476325 479106 479148 480466 487930 513794 514578 515878 515916 516491 518615 520813 522448 523881 537848 550367 554407 558173 558247 558302 560828 565110 583232 584621 585306 588202 590498 591013 591162 591759 593486 604806 605147 607064 607507 607599 609071 612056 613676 615022 615693 628704 629851 649437 663441 665288 721992 724264 726565 726808 726829 726849 728229 733446 738433 740986 741699 741726 741733 741752 741756 741758 741773 742383 742703 744220 744359 744425 747151 748463 751012 756043 758210 758234 758281 758792 758793 760167 763121 777792 780704 781924 790193 790403 794197 794841 796328 796452 799027 799693 800707 800736 800754 800755 802005 804427 804444 810086 810092 810461 811736 812409 812756 820313 824247 825329 826387 827185 ] |
||||||||||||||||||||||||||||||
|
15.69 ms (8.62%) |
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 649437 584621 585306 605147 607507 591759 607064 790403 804444 794197 796328 800755 744220 744425 726808 742703 777792 800736 812409 465579 480466 487930 554407 518615 522448 418692 425215 454055 472864 537848 523881 513794 515878 476163 476325 558302 565110 558173 665288 721992 663441 550367 560828 591013 609071 615022 590498 593486 613676 629851 588202 781924 790193 804427 780704 811736 724264 741752 741756 748463 799693 741726 744359 758234 758792 726565 728229 733446 741733 741758 741773 747151 758793 741699 742383 758281 763121 726849 758210 607599 612056 615693 799027 424429 386858 443408 479148 432350 471107 479106 516491 520813 515916 514578 558247 591162 800754 802005 756043 726829 583232 604806 628704 810461 794841 740986 810086 812756 751012 760167 738433 796452 800707 810092 452925 820313 824247 825329 826387 827185 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (1.48%) |
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 386858 418692 424429 425215 432350 443408 452925 454055 465579 471107 472864 476163 476325 479106 479148 480466 487930 513794 514578 515878 515916 516491 518615 520813 522448 523881 537848 550367 554407 558173 558247 558302 560828 565110 583232 584621 585306 588202 590498 591013 591162 591759 593486 604806 605147 607064 607507 607599 609071 612056 613676 615022 615693 628704 629851 649437 663441 665288 721992 724264 726565 726808 726829 726849 728229 733446 738433 740986 741699 741726 741733 741752 741756 741758 741773 742383 742703 744220 744359 744425 747151 748463 751012 756043 758210 758234 758281 758792 758793 760167 763121 777792 780704 781924 790193 790403 794197 794841 796328 796452 799027 799693 800707 800736 800754 800755 802005 804427 804444 810086 810092 810461 811736 812409 812756 820313 824247 825329 826387 827185 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.11%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"saggy mature masturbation"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"saggy mature мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.77%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.24 ms (0.68%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"saggy mature мастурбац"
]
|
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.