Query Metrics
7
Database Queries
7
Different statements
139.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.35 ms (84.23%) |
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 381995 389793 505795 521712 529083 529689 536192 542158 544004 584964 644819 653042 664446 674258 682820 693003 697994 701773 709284 719152 719309 723701 724567 724903 725201 726444 727914 728148 728951 728953 729050 731186 732692 733158 734491 736739 738543 739585 740541 743070 743708 744724 747251 749615 752846 755056 755107 758412 758759 758844 758996 761394 762654 762655 763603 764695 765420 766329 766934 766964 767487 767716 768081 768328 769913 771778 772371 772872 779442 780084 780281 781516 781528 782308 786528 789547 790092 790127 790131 790662 790904 791595 792274 792327 792435 792941 793155 794577 794586 795344 795805 796425 796660 797258 797714 797723 800039 800173 800945 801207 802268 802309 803439 803922 804857 805561 808201 810304 812213 813634 813903 813937 817032 823862 825862 825892 827709 ] |
||||||||||||||||||||||||||||||
|
11.84 ms (8.50%) |
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 723701 725201 740541 758996 761394 766964 767890 769913 772371 800039 804857 808201 724903 726444 727914 728148 728951 729050 732692 734491 736739 758412 758844 768328 731186 733158 743070 744724 747251 758759 765166 728953 738543 743708 752846 762654 771778 772872 779442 794586 389793 381995 505795 521712 536192 813937 813634 813903 817032 827709 825892 823862 542158 719152 719309 785843 786528 790904 794577 795344 802268 802309 780084 780281 781516 781528 790127 791595 792435 792941 795805 796660 797258 797723 800945 803439 749615 755107 768081 790131 790662 792274 792327 800173 801207 755056 763603 764695 724567 766329 739585 762655 765420 766934 767487 767716 697994 789547 790092 793155 796425 797714 803922 805561 810304 812213 782308 709284 825862 644819 529083 529689 544004 584964 653042 664446 674258 682820 693003 701773 ] |
||||||||||||||||||||||||||||||
|
2.68 ms (1.93%) |
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 381995 389793 505795 521712 529083 529689 536192 542158 544004 584964 644819 653042 664446 674258 682820 693003 697994 701773 709284 719152 719309 723701 724567 724903 725201 726444 727914 728148 728951 728953 729050 731186 732692 733158 734491 736739 738543 739585 740541 743070 743708 744724 747251 749615 752846 755056 755107 758412 758759 758844 758996 761394 762654 762655 763603 764695 765420 766329 766934 766964 767487 767716 768081 768328 769913 771778 772371 772872 779442 780084 780281 781516 781528 782308 786528 789547 790092 790127 790131 790662 790904 791595 792274 792327 792435 792941 793155 794577 794586 795344 795805 796425 796660 797258 797714 797723 800039 800173 800945 801207 802268 802309 803439 803922 804857 805561 808201 810304 812213 813634 813903 813937 817032 823862 825862 825892 827709 ] |
||||||||||||||||||||||||||||||
|
2.23 ms (1.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot homemade"
]
|
||||||||||||||||||||||||||||||
|
1.88 ms (1.35%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cumshot домашн любительск"
]
|
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.