Query Metrics
7
Database Queries
7
Different statements
440.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.10 ms (48.56%) |
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 7373 7449 109218 191698 233166 274758 323581 383111 384895 386414 389067 394004 398229 408214 411829 411842 429409 439470 440841 442830 451626 483440 484730 500597 502277 502279 515931 521515 524850 524853 524858 524860 524878 530002 532019 536447 544181 546671 547030 549716 553146 553455 567415 578473 581267 584050 584996 592117 593072 603678 609161 629416 633166 634569 634922 638829 641372 649956 652253 660701 668680 669195 669216 673053 675203 676783 676804 693931 700908 707069 707507 712646 716052 719872 721167 724041 729816 735548 738247 741093 741515 742237 743426 749646 752291 756544 758504 761538 765967 766601 768862 770021 775605 776820 776829 779315 780536 783994 787171 787495 788262 790961 793237 794691 794875 796597 797208 802702 803126 805135 805666 807614 808268 811549 818847 820131 823808 824156 828257 828383 ] |
||||||||||||||||||||||||||||||
|
206.65 ms (46.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf fuck"
]
|
||||||||||||||||||||||||||||||
|
11.66 ms (2.64%) |
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 191698 411829 483440 451626 500597 532019 788262 603678 584050 524858 609161 515931 787171 761538 780536 578473 384895 633166 803126 775605 389067 776820 766601 770021 743426 581267 749646 442830 820131 553146 408214 676804 484730 693931 765967 828383 823808 383111 828257 741093 797208 707507 805135 807614 707069 7373 641372 502279 719872 634922 567415 502277 787495 796597 783994 768862 790961 521515 386414 675203 676783 593072 794875 758504 735548 700908 7449 544181 429409 547030 752291 756544 524853 669216 805666 649956 794691 411842 668680 629416 638829 811549 274758 524850 634569 323581 439470 584996 660701 109218 652253 818847 824156 729816 742237 233166 776829 398229 530002 808268 738247 716052 779315 549716 721167 793237 802702 524878 524860 394004 440841 592117 741515 673053 536447 712646 669195 553455 546671 724041 ] |
||||||||||||||||||||||||||||||
|
3.75 ms (0.85%) |
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 7373 7449 109218 191698 233166 274758 323581 383111 384895 386414 389067 394004 398229 408214 411829 411842 429409 439470 440841 442830 451626 483440 484730 500597 502277 502279 515931 521515 524850 524853 524858 524860 524878 530002 532019 536447 544181 546671 547030 549716 553146 553455 567415 578473 581267 584050 584996 592117 593072 603678 609161 629416 633166 634569 634922 638829 641372 649956 652253 660701 668680 669195 669216 673053 675203 676783 676804 693931 700908 707069 707507 712646 716052 719872 721167 724041 729816 735548 738247 741093 741515 742237 743426 749646 752291 756544 758504 761538 765967 766601 768862 770021 775605 776820 776829 779315 780536 783994 787171 787495 788262 790961 793237 794691 794875 796597 797208 802702 803126 805135 805666 807614 808268 811549 818847 820131 823808 824156 828257 828383 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf секс"
]
|
||||||||||||||||||||||||||||||
|
1.44 ms (0.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf секс"
]
|
||||||||||||||||||||||||||||||
|
1.41 ms (0.32%) |
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.