Query Metrics
7
Database Queries
7
Different statements
153.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
126.36 ms (82.37%) |
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 423552 433352 443129 452840 459028 481655 482891 487976 490300 492410 510586 516990 517186 521387 523060 527437 527474 528730 534488 540004 544471 545677 546099 546546 547721 548055 559148 560316 560745 560897 562437 563736 568799 568826 568932 571096 573861 574151 577614 578331 579684 584718 587332 592052 592186 592218 593105 594635 595573 596919 598525 600682 609072 617961 619512 627349 627789 628748 628901 639222 651758 652380 658224 665588 672588 673448 678615 678732 687368 688997 694929 695169 695473 696333 696345 696576 699910 700006 712073 712276 715012 716374 721124 722262 733869 735144 736693 740092 740093 747969 751337 757196 758732 760558 767056 768675 770386 770514 771870 777924 784796 788879 794702 795363 795431 797668 797817 799095 799289 801003 801619 806693 807332 807419 809712 809779 811668 812038 813260 813482 ] |
||||||||||||||||||||||||||||||
|
15.68 ms (10.22%) |
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 812038 443129 459028 423552 433352 510586 544471 658224 672588 788879 807332 794702 492410 452840 481655 482891 487976 490300 540004 521387 534488 517186 528730 516990 523060 527437 527474 545677 560316 574151 577614 578331 563736 568799 568932 560745 560897 562437 571096 573861 665588 678615 688997 695169 699910 721124 678732 687368 694929 695473 696345 696576 712073 651758 652380 673448 696333 700006 712276 715012 716374 546099 546546 547721 548055 559148 568826 579684 584718 592218 594635 598525 639222 592052 593105 609072 617961 592186 595573 596919 600682 628748 628901 587332 777924 795431 797668 799095 799289 801003 809779 784796 795363 807419 809712 740092 740093 757196 797817 801619 806693 811668 813260 813482 736693 758732 767056 768675 751337 771870 733869 735144 747969 760558 770386 770514 619512 627349 627789 722262 ] |
||||||||||||||||||||||||||||||
|
3.27 ms (2.13%) |
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 423552 433352 443129 452840 459028 481655 482891 487976 490300 492410 510586 516990 517186 521387 523060 527437 527474 528730 534488 540004 544471 545677 546099 546546 547721 548055 559148 560316 560745 560897 562437 563736 568799 568826 568932 571096 573861 574151 577614 578331 579684 584718 587332 592052 592186 592218 593105 594635 595573 596919 598525 600682 609072 617961 619512 627349 627789 628748 628901 639222 651758 652380 658224 665588 672588 673448 678615 678732 687368 688997 694929 695169 695473 696333 696345 696576 699910 700006 712073 712276 715012 716374 721124 722262 733869 735144 736693 740092 740093 747969 751337 757196 758732 760558 767056 768675 770386 770514 771870 777924 784796 788879 794702 795363 795431 797668 797817 799095 799289 801003 801619 806693 807332 807419 809712 809779 811668 812038 813260 813482 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.50%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"узкая молодые"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"узкая молодые"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.28%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
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.