Query Metrics
7
Database Queries
7
Different statements
136.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.32 ms (84.32%) |
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 403163 411373 529844 531013 532220 532870 533532 535554 535649 536112 540204 544428 574969 580240 580487 581245 584839 584915 586209 586696 591901 594585 595030 600664 615377 620979 622952 623191 623281 623397 626186 627471 629686 641172 642814 647005 655030 655170 661678 666951 668791 672883 681349 683287 689762 690721 695495 701610 702068 710289 711578 715042 716316 716360 717196 721707 723268 724144 726175 726258 730974 735161 735187 736029 738913 739369 740243 741261 744536 746823 749362 750162 751177 752494 754115 754490 755076 757774 760962 762360 763472 765073 765505 766785 767876 771889 771897 772448 772953 777000 778232 779670 781392 782074 783809 785613 789627 789904 790292 792449 794535 795885 797567 798998 799686 799806 799909 801080 801084 804496 804857 807032 811925 813936 818840 825418 826263 827317 ] |
||||||||||||||||||||||||||||||
|
11.92 ms (8.72%) |
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 672883 683287 695495 620979 623191 629686 591901 641172 642814 783809 730974 744536 763472 647005 804496 533532 600664 813936 586696 757774 827317 754490 701610 580240 778232 794535 779670 797567 799686 754115 755076 741261 751177 760962 771889 771897 781392 792449 529844 531013 532220 535649 574969 584839 544428 661678 668791 681349 710289 711578 580487 615377 627471 626186 594585 623397 764302 762360 826263 825418 581245 622952 721707 715042 782074 789627 807032 724144 735187 789904 799909 801084 765073 752494 772448 795885 798998 584915 818840 540204 595030 411373 535554 723268 689762 716316 702068 623281 586209 785613 790292 777000 799806 811925 746823 804857 740243 749362 768810 726258 735161 739369 765505 767876 726175 736029 738913 750162 716360 717196 801080 772953 766785 403163 532870 536112 655030 690721 655170 666951 ] |
||||||||||||||||||||||||||||||
|
2.80 ms (2.05%) |
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 403163 411373 529844 531013 532220 532870 533532 535554 535649 536112 540204 544428 574969 580240 580487 581245 584839 584915 586209 586696 591901 594585 595030 600664 615377 620979 622952 623191 623281 623397 626186 627471 629686 641172 642814 647005 655030 655170 661678 666951 668791 672883 681349 683287 689762 690721 695495 701610 702068 710289 711578 715042 716316 716360 717196 721707 723268 724144 726175 726258 730974 735161 735187 736029 738913 739369 740243 741261 744536 746823 749362 750162 751177 752494 754115 754490 755076 757774 760962 762360 763472 765073 765505 766785 767876 771889 771897 772448 772953 777000 778232 779670 781392 782074 783809 785613 789627 789904 790292 792449 794535 795885 797567 798998 799686 799806 799909 801080 801084 804496 804857 807032 811925 813936 818840 825418 826263 827317 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.59%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жопы домашнее"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.26 ms (0.92%) |
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.