Query Metrics
7
Database Queries
7
Different statements
151.92 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.04 ms (83.63%) |
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 385239 400348 415345 420303 440892 443188 474507 487804 498331 515658 529993 530431 531394 534628 539133 539350 539637 579599 599032 613440 615137 615184 617388 619241 622849 625776 625935 625958 625978 627094 638439 648693 651768 652747 652750 656576 664473 664622 668086 668111 670068 672836 674494 678711 684888 689040 695467 697496 699101 699304 701897 702315 706244 707069 707148 707194 707488 710884 712347 712397 713181 716994 718614 720026 725240 728354 728551 729038 734124 734185 734672 743630 744218 744224 746491 747429 749598 750978 758420 765091 768472 768758 771424 771430 772559 780213 783033 783250 783692 784292 784886 787732 788938 789797 790110 791028 791312 791716 791729 793008 794706 794765 795895 795950 797194 798816 801343 801932 802334 802483 809672 812262 817969 819720 820156 820196 824913 825055 825767 828285 ] |
||||||||||||||||||||||||||||||
|
13.86 ms (9.12%) |
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 615137 734124 734185 613440 768472 443188 487804 534628 648693 689040 617388 801932 728551 771424 797194 747429 758420 707488 801343 802483 474507 784292 795895 768758 385239 400348 420303 415345 440892 817969 819720 820196 824913 825767 820156 825055 828285 498331 515658 531394 529993 539133 539350 539637 530431 579599 664473 664622 668086 670068 674494 684888 697496 699101 699304 702315 707069 707148 707194 712347 712397 720026 656576 701897 706244 710884 716994 718614 651768 652747 652750 668111 672836 678711 695467 713181 615184 625776 599032 622849 625958 627094 619241 625935 625978 638439 783692 784886 787732 788938 790110 791028 798816 812262 780213 789797 791729 794706 734672 743630 744224 746491 749598 750978 765091 771430 772559 783033 783250 791312 791716 793008 794765 795950 802334 809672 725240 728354 729038 744218 ] |
||||||||||||||||||||||||||||||
|
3.06 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 385239 400348 415345 420303 440892 443188 474507 487804 498331 515658 529993 530431 531394 534628 539133 539350 539637 579599 599032 613440 615137 615184 617388 619241 622849 625776 625935 625958 625978 627094 638439 648693 651768 652747 652750 656576 664473 664622 668086 668111 670068 672836 674494 678711 684888 689040 695467 697496 699101 699304 701897 702315 706244 707069 707148 707194 707488 710884 712347 712397 713181 716994 718614 720026 725240 728354 728551 729038 734124 734185 734672 743630 744218 744224 746491 747429 749598 750978 758420 765091 768472 768758 771424 771430 772559 780213 783033 783250 783692 784292 784886 787732 788938 789797 790110 791028 791312 791716 791729 793008 794706 794765 795895 795950 797194 798816 801343 801932 802334 802483 809672 812262 817969 819720 820156 820196 824913 825055 825767 828285 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.51%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife real"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (1.31%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен real"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.18%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен real"
]
|
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.