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