Query Metrics
7
Database Queries
7
Different statements
144.72 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.27 ms (83.11%) |
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 6765 66348 86315 188282 311746 386583 393582 394138 420044 421553 423770 429859 442573 443433 445374 447966 462406 463398 463409 471038 498542 498786 514620 516149 518810 523813 524733 529015 530641 533756 534474 536005 541815 544922 549482 553571 554126 555032 555657 557186 559068 559223 560305 560456 560826 574646 577698 580025 584485 591838 600876 606263 606628 607836 607845 617242 618985 620129 621663 623071 627790 636959 639282 640507 641378 641509 644840 668734 669880 671572 682728 683036 683665 685204 689161 697614 702258 702380 703016 704442 708282 713343 716823 720356 725508 725529 728090 730517 733982 734995 735659 735870 737637 738000 741857 746188 746575 746873 747999 749207 751372 753176 753946 757111 758318 759164 760883 766487 771491 774020 783091 783345 789335 791314 793141 795984 796752 799870 813404 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (9.81%) |
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 728090 734995 746188 708282 423770 559223 555657 557186 443433 463409 311746 421553 529015 533756 534474 498542 524733 530641 462406 541815 549482 671572 668734 704442 720356 683036 702380 553571 606628 618985 620129 623071 606263 607845 641509 640507 793141 796752 783091 799870 746873 766487 735659 737637 725529 730517 735870 746575 747999 751372 641378 702258 386583 442573 559068 621663 429859 498786 393582 66348 445374 463398 514620 518810 516149 584485 544922 560456 574646 580025 716823 703016 682728 689161 555032 591838 636959 607836 627790 639282 791314 813404 725213 733982 749207 753946 771491 774020 783345 789335 795984 741857 738000 760883 725508 753176 757111 758318 759164 617242 394138 523813 188282 86315 6765 420044 644840 447966 536005 471038 560826 577698 554126 560305 669880 685204 697614 683665 713343 600876 ] |
||||||||||||||||||||||||||||||
|
2.49 ms (1.72%) |
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 6765 66348 86315 188282 311746 386583 393582 394138 420044 421553 423770 429859 442573 443433 445374 447966 462406 463398 463409 471038 498542 498786 514620 516149 518810 523813 524733 529015 530641 533756 534474 536005 541815 544922 549482 553571 554126 555032 555657 557186 559068 559223 560305 560456 560826 574646 577698 580025 584485 591838 600876 606263 606628 607836 607845 617242 618985 620129 621663 623071 627790 636959 639282 640507 641378 641509 644840 668734 669880 671572 682728 683036 683665 685204 689161 697614 702258 702380 703016 704442 708282 713343 716823 720356 725508 725529 728090 730517 733982 734995 735659 735870 737637 738000 741857 746188 746575 746873 747999 749207 751372 753176 753946 757111 758318 759164 760883 766487 771491 774020 783091 783345 789335 791314 793141 795984 796752 799870 813404 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"юбку"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.38%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"юбк"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.18%) |
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.