Query Metrics
7
Database Queries
7
Different statements
168.82 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
144.52 ms (85.61%) |
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 392721 422106 441892 479377 502788 505480 521952 534133 536392 537215 546089 549472 556685 557030 560305 563721 577084 589636 592708 592987 600518 602036 603621 604452 604993 605684 606352 606965 611491 617000 618821 619371 621718 622116 622179 625608 625896 626528 631417 631851 632251 632540 638430 640177 641405 642562 644102 648672 651333 651370 653863 653880 657825 663777 664616 665969 665978 667057 675193 677511 678607 679549 692735 692845 693273 695700 695773 695805 696577 697633 697685 700831 701188 702302 704685 709468 711938 713641 714254 717062 727541 728365 728642 730153 731661 732717 735488 739717 753501 755151 756724 759374 760986 764125 764510 765715 766762 774311 780743 782673 783677 786952 787052 787937 789141 790768 792277 794005 794433 797090 799834 801074 802487 802882 807858 809344 810017 811453 811728 827854 ] |
||||||||||||||||||||||||||||||
|
13.13 ms (7.78%) |
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 780743 782673 790768 792277 799834 789141 797090 809344 811728 739717 753501 755151 760986 783677 786952 787052 787937 794005 794433 802487 802882 811453 728642 774311 730153 732717 735488 756724 759374 764125 764510 765715 766762 717062 801074 807858 810017 479377 392721 422106 441892 827854 505480 502788 534133 537215 521952 536392 563721 546089 549472 560305 577084 648672 651333 653863 665969 675193 677511 679549 692735 693273 695700 695773 701188 702302 704685 657825 665978 692845 697633 697685 709468 651370 653880 663777 664616 667057 678607 695805 696577 700831 711938 713641 714254 556685 557030 603621 605684 618821 626528 638430 592708 592987 600518 621718 622179 631851 632251 642562 589636 602036 604452 604993 611491 617000 622116 625896 632540 606352 606965 625608 631417 640177 644102 728365 731661 727541 619371 641405 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (1.79%) |
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 392721 422106 441892 479377 502788 505480 521952 534133 536392 537215 546089 549472 556685 557030 560305 563721 577084 589636 592708 592987 600518 602036 603621 604452 604993 605684 606352 606965 611491 617000 618821 619371 621718 622116 622179 625608 625896 626528 631417 631851 632251 632540 638430 640177 641405 642562 644102 648672 651333 651370 653863 653880 657825 663777 664616 665969 665978 667057 675193 677511 678607 679549 692735 692845 693273 695700 695773 695805 696577 697633 697685 700831 701188 702302 704685 709468 711938 713641 714254 717062 727541 728365 728642 730153 731661 732717 735488 739717 753501 755151 756724 759374 760986 764125 764510 765715 766762 774311 780743 782673 783677 786952 787052 787937 789141 790768 792277 794005 794433 797090 799834 801074 802487 802882 807858 809344 810017 811453 811728 827854 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade friend"
]
|
||||||||||||||||||||||||||||||
|
2.19 ms (1.30%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск friend"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.12%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.99%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск friend"
]
|
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.