Query Metrics
7
Database Queries
7
Different statements
129.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
110.99 ms (85.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 13450 30310 76981 170225 235677 266369 298529 310725 384065 385674 386622 398924 477355 478570 478902 490198 515006 529346 533549 533986 539455 540106 543939 569727 578337 583033 595217 605605 606606 606663 619073 625739 641856 646191 659602 660250 667681 671078 671892 678779 678818 684989 687755 687802 692462 693540 695054 695353 695359 702896 705887 707379 721670 738349 747072 747770 751713 753615 754756 756135 756311 760761 764648 774119 774567 776535 777710 782366 782368 791779 792026 794854 796657 799009 803008 803254 811467 813950 815401 817315 817572 817588 817856 818990 819241 820040 820078 820180 820694 821711 821766 822572 823057 823450 823862 823954 824008 824234 824288 824903 824932 825142 825226 825737 825985 826113 826613 826680 826987 827585 828202 828445 828499 828548 828654 828755 828785 ] |
||||||||||||||||||||||||||||||
|
10.40 ms (8.01%) |
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 754756 398924 490198 687755 777710 796657 824234 820040 825737 828445 828654 774119 310725 625739 747770 477355 583033 678779 641856 13450 235677 386622 298529 815401 817856 821711 824903 826613 819241 821766 822572 823954 813950 823057 823450 824288 825928 826522 817315 823797 823862 825226 826113 828755 828785 828499 478570 533986 515006 543939 578337 646191 695359 721670 605605 619073 606606 606663 791779 803008 803254 774567 794854 799009 756135 792026 811467 764648 738349 751713 753615 760761 747072 756311 702896 776535 782366 782368 384065 170225 828548 595217 385674 266369 76981 30310 817572 817588 818990 820180 824008 824932 826680 820078 820694 825142 825985 826987 827585 828202 539455 529346 533549 540106 478902 569727 660250 687802 707379 667681 671892 692462 659602 671078 678818 684989 693540 695054 695353 705887 ] |
||||||||||||||||||||||||||||||
|
2.11 ms (1.62%) |
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 13450 30310 76981 170225 235677 266369 298529 310725 384065 385674 386622 398924 477355 478570 478902 490198 515006 529346 533549 533986 539455 540106 543939 569727 578337 583033 595217 605605 606606 606663 619073 625739 641856 646191 659602 660250 667681 671078 671892 678779 678818 684989 687755 687802 692462 693540 695054 695353 695359 702896 705887 707379 721670 738349 747072 747770 751713 753615 754756 756135 756311 760761 764648 774119 774567 776535 777710 782366 782368 791779 792026 794854 796657 799009 803008 803254 811467 813950 815401 817315 817572 817588 817856 818990 819241 820040 820078 820180 820694 821711 821766 822572 823057 823450 823862 823954 824008 824234 824288 824903 824932 825142 825226 825737 825985 826113 826613 826680 826987 827585 828202 828445 828499 828548 828654 828755 828785 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"чулки и белье"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"чулк нижн бел бел"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (1.10%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (1.07%) |
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.