Query Metrics
7
Database Queries
7
Different statements
152.12 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.08 ms (84.20%) |
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 475327 479982 484153 491178 533175 533190 533230 533288 541063 544072 545254 545858 553106 553429 553806 559305 559316 562554 564043 577676 578427 592851 594286 596381 601328 611463 614281 615156 637798 642226 646066 648422 649072 655538 666683 672725 672732 686741 687140 688268 691611 697733 697937 700717 715457 727985 743069 746262 754939 759249 760397 763413 763433 763550 764246 764856 764858 765369 765995 767339 767449 768533 768542 772551 773193 773407 773413 774327 774420 777565 777591 781553 781636 783354 784063 785985 787071 787583 791788 792462 792500 793348 794065 795112 795474 796004 797208 798582 799218 799515 799608 800782 801547 802514 802588 803181 804779 805209 805523 806116 808478 809231 809672 809739 809861 809908 810424 813861 813977 815059 815085 815103 815115 815134 816627 825049 827757 ] |
||||||||||||||||||||||||||||||
|
12.70 ms (8.35%) |
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 793348 799218 799515 801547 805209 809739 809861 727985 743069 763433 765995 767449 781553 783354 784063 787583 791788 792462 792500 794065 795474 797208 799608 802588 803181 804779 805523 808478 809672 809908 760397 764858 773193 754939 759249 764246 773407 774327 746262 763413 763550 765369 767339 768533 768542 772551 773413 764856 614281 637798 697733 700717 777565 777591 781636 785985 787071 796004 798582 800782 802514 806116 809231 810424 816627 686741 764517 815115 825049 826432 827757 828697 795112 815085 774420 815059 815103 813861 813977 815134 479982 475327 484153 533288 533190 533230 533175 491178 545858 553429 553806 562554 577676 559305 559316 578427 541063 544072 545254 553106 649072 687140 688268 691611 655538 672725 672732 715457 646066 648422 666683 697937 564043 592851 596381 601328 611463 615156 642226 594286 ] |
||||||||||||||||||||||||||||||
|
3.07 ms (2.02%) |
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 475327 479982 484153 491178 533175 533190 533230 533288 541063 544072 545254 545858 553106 553429 553806 559305 559316 562554 564043 577676 578427 592851 594286 596381 601328 611463 614281 615156 637798 642226 646066 648422 649072 655538 666683 672725 672732 686741 687140 688268 691611 697733 697937 700717 715457 727985 743069 746262 754939 759249 760397 763413 763433 763550 764246 764856 764858 765369 765995 767339 767449 768533 768542 772551 773193 773407 773413 774327 774420 777565 777591 781553 781636 783354 784063 785985 787071 787583 791788 792462 792500 793348 794065 795112 795474 796004 797208 798582 799218 799515 799608 800782 801547 802514 802588 803181 804779 805209 805523 806116 808478 809231 809672 809739 809861 809908 810424 813861 813977 815059 815085 815103 815115 815134 816627 825049 827757 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"от первой лица"
]
|
||||||||||||||||||||||||||||||
|
2.14 ms (1.41%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"пов"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (1.19%) |
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.