Query Metrics
7
Database Queries
7
Different statements
193.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
172.17 ms (88.82%) |
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 453340 543425 558206 565658 568078 571149 572709 575830 579827 603640 604453 610777 612809 613598 616908 620904 621174 626004 626401 628500 630977 635572 639959 646049 650727 655238 655458 660713 661894 662042 667328 679651 689456 694917 695724 695737 695790 704377 710455 715041 718327 718983 722273 724074 728724 734487 735004 739281 740787 743456 749237 750242 751405 756554 759321 760534 761221 761491 761625 761858 763136 765266 765768 766637 766648 766748 767039 767098 767588 767967 768385 770383 770499 770517 771613 773618 774696 776997 777134 777887 778307 779689 779961 780243 780745 781458 784206 786850 787492 787508 787516 787891 788572 789075 790437 790869 791339 791356 792050 794892 795731 796661 796682 800854 802443 805578 806614 806838 806887 807352 811540 811679 812068 812405 812973 812982 813277 818037 818168 818349 ] |
||||||||||||||||||||||||||||||
|
12.72 ms (6.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 777134 689456 613598 795731 812405 743456 759321 728724 818349 802443 790437 740787 739281 761858 765768 790869 756554 604453 694917 695724 621174 806614 767588 812982 734487 704377 796682 565658 818168 722273 770517 558206 766637 789075 750242 579827 650727 718327 620904 568078 655238 661894 626004 786850 812068 813277 779689 779961 781458 788572 812973 787891 791339 811679 724074 766748 767039 760534 780243 796661 811540 572709 660713 695790 695737 710455 639959 794892 770499 787516 749237 735004 776997 806887 774696 662042 761491 771613 612809 715041 791356 628500 655458 780745 784206 667328 610777 773618 792050 767967 767098 768385 751405 635572 763136 818037 616908 777887 761221 646049 807352 800854 806838 543425 603640 778307 679651 761625 766648 770383 718983 787492 571149 626401 453340 805578 575830 630977 765266 787508 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.07%) |
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 453340 543425 558206 565658 568078 571149 572709 575830 579827 603640 604453 610777 612809 613598 616908 620904 621174 626004 626401 628500 630977 635572 639959 646049 650727 655238 655458 660713 661894 662042 667328 679651 689456 694917 695724 695737 695790 704377 710455 715041 718327 718983 722273 724074 728724 734487 735004 739281 740787 743456 749237 750242 751405 756554 759321 760534 761221 761491 761625 761858 763136 765266 765768 766637 766648 766748 767039 767098 767588 767967 768385 770383 770499 770517 771613 773618 774696 776997 777134 777887 778307 779689 779961 780243 780745 781458 784206 786850 787492 787508 787516 787891 788572 789075 790437 790869 791339 791356 792050 794892 795731 796661 796682 800854 802443 805578 806614 806838 806887 807352 811540 811679 812068 812405 812973 812982 813277 818037 818168 818349 ] |
||||||||||||||||||||||||||||||
|
2.06 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal ffm onlyfans"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.87%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал жмж секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал жмж секс втро онлифанс социальн сет"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.78%) |
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.