Query Metrics
7
Database Queries
7
Different statements
212.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
188.97 ms (88.76%) |
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 6714 381887 391108 391837 397141 417308 432728 448282 448663 454243 455596 460544 467283 469303 483531 484230 485069 488295 488937 504303 506424 512530 515846 521172 524025 526877 534947 537542 543575 547877 547998 549586 552280 557358 562168 563497 563504 565671 566465 578063 578075 580271 589486 589786 598431 612040 617179 627167 647770 647805 648201 651030 654128 667804 671913 681780 686044 689360 692113 695410 699046 701179 701230 702372 704731 704894 704897 706348 706989 707865 712794 713951 715576 719746 724025 728502 731709 732940 734421 735333 738229 739538 740049 742765 743404 744164 744364 744762 746660 754022 760413 761322 761812 764616 765972 768422 771778 773454 773465 775147 776887 778299 780686 787751 789340 790831 805123 806259 810341 810342 814578 817465 817478 818314 818838 818842 819529 826882 827408 828278 ] |
||||||||||||||||||||||||||||||
|
13.75 ms (6.46%) |
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 771778 552280 454243 483531 484230 818314 485069 506424 537542 549586 563497 578063 563504 704894 704897 706989 706348 557358 565671 775147 776887 787751 790831 805123 743404 761812 806259 810342 734421 735333 744364 744762 760413 724025 739538 754022 738229 768422 731709 742765 764616 765972 701179 707865 780686 789340 810341 6714 391837 524025 543575 547877 589786 598431 589486 467283 417308 469303 526877 512530 391108 818838 818842 828278 534947 566465 648201 695410 702372 715576 647770 651030 667804 689360 701230 713951 671913 686044 547998 578075 627167 612040 617179 778299 732940 761322 773454 773465 744164 746660 728502 740049 719746 397141 432728 580271 562168 455596 448282 448663 460544 521172 515846 488295 504303 488937 381887 817478 827408 819529 814578 817465 826882 647805 692113 699046 704731 654128 681780 712794 ] |
||||||||||||||||||||||||||||||
|
2.81 ms (1.32%) |
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 6714 381887 391108 391837 397141 417308 432728 448282 448663 454243 455596 460544 467283 469303 483531 484230 485069 488295 488937 504303 506424 512530 515846 521172 524025 526877 534947 537542 543575 547877 547998 549586 552280 557358 562168 563497 563504 565671 566465 578063 578075 580271 589486 589786 598431 612040 617179 627167 647770 647805 648201 651030 654128 667804 671913 681780 686044 689360 692113 695410 699046 701179 701230 702372 704731 704894 704897 706348 706989 707865 712794 713951 715576 719746 724025 728502 731709 732940 734421 735333 738229 739538 740049 742765 743404 744164 744364 744762 746660 754022 760413 761322 761812 764616 765972 768422 771778 773454 773465 775147 776887 778299 780686 787751 789340 790831 805123 806259 810341 810342 814578 817465 817478 818314 818838 818842 819529 826882 827408 828278 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.94 ms (0.91%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"hidden fuck"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"скрыт секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.79%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.