Query Metrics
7
Database Queries
7
Different statements
582.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
418.02 ms (71.78%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"onlyfans masturbation"
]
|
||||||||||||||||||||||||||||||
|
136.90 ms (23.51%) |
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 500803 540917 541570 548860 553708 554620 555551 556353 557621 557650 558496 560841 562542 564480 579677 584593 588879 589824 594349 602022 608380 617606 632905 633695 641176 649339 650290 650685 650727 652779 668309 669331 673230 674220 674241 679499 679500 680768 683724 684492 686972 691963 693636 697540 700016 703277 703650 706759 707061 707496 707867 708198 709105 709182 710142 712627 714672 718068 722169 738928 751050 757910 758248 769158 769447 772951 773317 773697 774706 774850 776088 776994 777851 779615 780025 780039 780848 782584 782682 783380 783966 784044 784654 784674 784885 785309 785453 785540 785795 785974 787808 788498 791382 793492 794840 798261 799085 799347 799541 799552 803757 804672 804790 806651 806827 807142 808542 808670 811570 811706 811885 812732 813298 813811 813815 814397 814403 818938 819421 827484 ] |
||||||||||||||||||||||||||||||
|
19.34 ms (3.32%) |
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 769447 772951 773317 602022 608380 632905 633695 641176 700016 703277 714672 718068 722169 774850 776088 776994 777851 779615 780025 780848 782584 783380 783966 784044 784674 785453 785540 785795 785974 787808 788498 791382 794840 798261 799085 799347 803757 804790 806651 806827 808670 811570 811706 811885 812732 813298 541570 579677 556353 560841 500803 558496 707867 686972 774706 780039 751050 757910 808542 738928 652779 799541 799552 814397 555551 679500 673230 710142 588879 617606 589824 594349 784885 804672 785309 807142 769158 782682 758248 773697 784654 793492 814403 819421 827484 813811 813815 818938 540917 553708 584593 562542 548860 554620 557621 557650 564480 650290 650727 674220 674241 679499 683724 684492 697540 703650 706759 707061 707496 708198 709105 709182 712627 649339 650685 668309 669331 680768 691963 693636 ] |
||||||||||||||||||||||||||||||
|
2.86 ms (0.49%) |
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 500803 540917 541570 548860 553708 554620 555551 556353 557621 557650 558496 560841 562542 564480 579677 584593 588879 589824 594349 602022 608380 617606 632905 633695 641176 649339 650290 650685 650727 652779 668309 669331 673230 674220 674241 679499 679500 680768 683724 684492 686972 691963 693636 697540 700016 703277 703650 706759 707061 707496 707867 708198 709105 709182 710142 712627 714672 718068 722169 738928 751050 757910 758248 769158 769447 772951 773317 773697 774706 774850 776088 776994 777851 779615 780025 780039 780848 782584 782682 783380 783966 784044 784654 784674 784885 785309 785453 785540 785795 785974 787808 788498 791382 793492 794840 798261 799085 799347 799541 799552 803757 804672 804790 806651 806827 807142 808542 808670 811570 811706 811885 812732 813298 813811 813815 814397 814403 818938 819421 827484 ] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"онлифанс социальн сет мастурбац"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (0.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.27%) |
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.