Query Metrics
7
Database Queries
7
Different statements
369.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.98 ms (56.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие saggy"
]
|
||||||||||||||||||||||||||||||
|
138.28 ms (37.37%) |
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 150897 385437 453258 518860 524476 531667 532395 532623 533843 533898 537351 540264 542259 547004 547037 549483 555528 559920 562704 565076 565116 565232 566012 566672 568112 568243 573209 575980 601590 604926 607444 613040 613527 623951 631668 631708 634691 634825 636416 639300 639578 643031 643645 650446 653087 663415 664528 667295 667762 671694 671696 679701 680640 705454 708829 710573 711342 711636 714148 714690 716349 717430 717437 719530 725150 728634 734097 734660 738828 740442 745057 746260 748550 754394 757315 762305 769383 774440 774730 776635 780998 781790 781931 781989 791054 797153 797784 802706 803218 804659 805328 805731 808494 810121 811187 814458 817540 818454 818508 818673 818692 819327 820373 820611 823781 823978 824088 824793 824903 825062 825398 825974 826019 826062 826388 826481 826497 826550 826595 826603 ] |
||||||||||||||||||||||||||||||
|
14.33 ms (3.87%) |
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 518860 524476 533843 533898 540264 531667 532395 532623 537351 547004 565116 566012 568112 573209 542259 555528 568243 575980 549483 559920 650446 653087 664528 671694 671696 717437 663415 667295 679701 708829 711342 717430 667762 680640 714690 719530 547037 562704 565076 565232 566672 601590 623951 631668 634691 613040 636416 643645 613527 604926 631708 639300 639578 643031 774730 776635 780998 781931 797153 797784 802706 811187 804659 805328 805731 728634 746260 762305 803218 734097 745057 748550 754394 757315 769383 725150 738828 734660 740442 607444 634825 705454 710573 711636 714148 716349 781790 781989 791054 808494 810121 453258 385437 150897 814458 817540 818454 818508 819327 823781 823978 824088 824793 824903 825062 826019 826062 774440 826481 826497 825974 826550 826388 826603 825398 826595 818673 818692 820373 820611 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (0.75%) |
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 150897 385437 453258 518860 524476 531667 532395 532623 533843 533898 537351 540264 542259 547004 547037 549483 555528 559920 562704 565076 565116 565232 566012 566672 568112 568243 573209 575980 601590 604926 607444 613040 613527 623951 631668 631708 634691 634825 636416 639300 639578 643031 643645 650446 653087 663415 664528 667295 667762 671694 671696 679701 680640 705454 708829 710573 711342 711636 714148 714690 716349 717430 717437 719530 725150 728634 734097 734660 738828 740442 745057 746260 748550 754394 757315 762305 769383 774440 774730 776635 780998 781790 781931 781989 791054 797153 797784 802706 803218 804659 805328 805731 808494 810121 811187 814458 817540 818454 818508 818673 818692 819327 820373 820611 823781 823978 824088 824793 824903 825062 825398 825974 826019 826062 826388 826481 826497 826550 826595 826603 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (0.56%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big saggy"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие saggy"
]
|
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.