Query Metrics
7
Database Queries
7
Different statements
170.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
146.72 ms (85.96%) |
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 185606 386344 387422 388155 389983 395839 396777 406047 420327 422300 422335 434379 439184 443866 446378 456113 458339 470812 487225 508268 511199 526658 528633 547417 552998 560680 565985 567560 592522 603941 612089 616585 618208 651928 661637 663851 665989 677053 678554 680846 682851 692587 693341 695828 698147 698885 699520 702088 708237 710798 711057 712226 715404 715787 716669 718875 722232 725004 728151 728642 729354 732592 737537 744842 750867 751817 755763 757552 764923 765112 766762 767318 769308 770368 770587 772157 773628 773786 775614 778671 778718 778876 779852 780749 781874 782115 782307 783612 783953 787052 787549 787918 789039 789141 792571 794005 795669 797090 797414 797794 798095 798361 800012 801037 801074 801993 802882 804854 807436 811926 812004 813984 814008 817970 817990 819870 822825 827836 827857 827887 ] |
||||||||||||||||||||||||||||||
|
14.27 ms (8.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 798361 751817 764923 612089 699520 708237 783953 434379 528633 814008 792571 508268 592522 567560 677053 651928 787549 811926 782307 797090 767318 797794 802882 728642 729354 757552 770587 732592 766762 770368 715404 422300 778671 526658 773786 446378 389983 511199 702088 678554 775614 822825 395839 406047 813984 547417 698885 722232 715787 663851 618208 797414 779852 782115 728151 755763 801074 807436 387422 420327 560680 711057 692587 789039 470812 765112 185606 565985 603941 783612 800012 737537 396777 552998 769308 744842 798095 422335 443866 693341 695828 773628 750867 487225 458339 388155 386344 439184 817970 817990 819870 827836 827857 827887 456113 682851 710798 718875 661637 665989 698147 712226 680846 716669 616585 778718 778876 801037 780749 781874 789141 804854 812004 772157 787052 787918 794005 795669 801993 725004 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.67%) |
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 185606 386344 387422 388155 389983 395839 396777 406047 420327 422300 422335 434379 439184 443866 446378 456113 458339 470812 487225 508268 511199 526658 528633 547417 552998 560680 565985 567560 592522 603941 612089 616585 618208 651928 661637 663851 665989 677053 678554 680846 682851 692587 693341 695828 698147 698885 699520 702088 708237 710798 711057 712226 715404 715787 716669 718875 722232 725004 728151 728642 729354 732592 737537 744842 750867 751817 755763 757552 764923 765112 766762 767318 769308 770368 770587 772157 773628 773786 775614 778671 778718 778876 779852 780749 781874 782115 782307 783612 783953 787052 787549 787918 789039 789141 792571 794005 795669 797090 797414 797794 798095 798361 800012 801037 801074 801993 802882 804854 807436 811926 812004 813984 814008 817970 817990 819870 822825 827836 827857 827887 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best blow job"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.29 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best минет оральн секс"
]
|
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.