Query Metrics
7
Database Queries
7
Different statements
157.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.69 ms (86.89%) |
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 330409 381995 395990 521712 529083 529689 542158 544004 629549 644819 665077 682992 697994 706597 717117 719152 719309 722167 724567 724903 726444 727914 728148 728871 728893 728951 728953 729050 731186 732692 733158 734491 736158 736739 738543 739585 743070 743708 744724 747251 749615 752846 755056 755107 758412 758759 758844 762654 762655 763603 764695 765420 765802 766329 766934 767487 767716 767884 768081 768328 771778 772872 779442 779692 780084 780281 781516 781528 786528 789547 790092 790127 790131 790662 790904 791595 792274 792327 792435 792941 793155 794577 794586 795344 795805 796425 796660 797258 797714 797723 800173 800945 801207 802268 802309 803156 803439 803922 805561 808201 810304 812213 813634 813903 813937 816680 817032 818855 819133 819790 823862 825892 826006 826110 826236 827709 828342 828540 ] |
||||||||||||||||||||||||||||||
|
11.15 ms (7.09%) |
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 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 381995 395990 818855 826110 816680 819790 803156 706597 521712 682992 767884 736158 629549 330409 813937 813634 813903 817032 826006 827709 825892 826236 819133 823862 828342 828540 542158 717117 719152 719309 665077 722167 785843 786528 790904 794577 795344 802268 802309 779692 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 728893 765802 766329 739585 762655 765420 766934 767487 767716 728871 697994 789547 790092 793155 796425 797714 803922 805561 810304 812213 644819 529083 529689 544004 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.57%) |
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 330409 381995 395990 521712 529083 529689 542158 544004 629549 644819 665077 682992 697994 706597 717117 719152 719309 722167 724567 724903 726444 727914 728148 728871 728893 728951 728953 729050 731186 732692 733158 734491 736158 736739 738543 739585 743070 743708 744724 747251 749615 752846 755056 755107 758412 758759 758844 762654 762655 763603 764695 765420 765802 766329 766934 767487 767716 767884 768081 768328 771778 772872 779442 779692 780084 780281 781516 781528 786528 789547 790092 790127 790131 790662 790904 791595 792274 792327 792435 792941 793155 794577 794586 795344 795805 796425 796660 797258 797714 797723 800173 800945 801207 802268 802309 803156 803439 803922 805561 808201 810304 812213 813634 813903 813937 816680 817032 818855 819133 819790 823862 825892 826006 826110 826236 827709 828342 828540 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.32%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cumshot любительск"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cumshot amateur"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.02%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.59 ms (1.01%) |
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.