Query Metrics
7
Database Queries
7
Different statements
141.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.66 ms (85.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 386749 424102 432410 432493 433059 433061 433599 433622 433749 434810 434836 440900 446816 448218 450127 451761 458806 461709 468962 487555 489768 494798 502971 505430 516599 518433 519919 526325 529094 538182 541420 544771 546134 556350 577693 615932 632092 678250 690198 700121 703012 707378 715071 719031 727422 731122 731153 732821 734540 734590 736010 739233 740112 741683 741768 744780 746147 746691 749377 749604 750925 754038 758157 761378 761379 761387 761837 766966 766981 767538 767545 767570 767614 767615 767716 767792 768002 773120 774909 774919 774996 778497 779742 779799 780172 780210 787482 787689 790709 791254 791779 792269 792439 792442 792476 794267 794579 795361 795852 795904 796693 798142 800173 800741 801139 801500 801505 802077 802247 803165 809708 810293 811330 811831 812370 820081 ] |
||||||||||||||||||||||||||||||
|
11.29 ms (7.98%) |
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 791779 792439 794267 774919 778497 779742 779799 780210 791254 794579 795361 795904 796693 809708 810293 740112 766981 767890 787482 787689 792442 792476 795852 798142 800173 802077 761837 766966 727422 746147 773120 746691 761387 767570 767716 767792 731153 739233 749604 758157 768002 774996 780172 801500 801505 811831 812370 424102 440900 451761 526325 516599 801139 386749 556350 700121 719031 544771 458806 461709 450127 505430 518433 538182 432410 434810 468962 529094 502971 519919 494798 434836 448218 446816 577693 761379 432493 433749 541420 487555 433059 433061 433599 489768 433622 820081 828652 546134 678250 690198 703012 707378 715071 615932 632092 787763 790709 800741 802247 774909 792269 803165 744780 761378 767538 767545 767615 811330 732821 734540 734590 750925 736010 754038 741768 749377 766975 767614 731122 741683 ] |
||||||||||||||||||||||||||||||
|
2.65 ms (1.87%) |
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 386749 424102 432410 432493 433059 433061 433599 433622 433749 434810 434836 440900 446816 448218 450127 451761 458806 461709 468962 487555 489768 494798 502971 505430 516599 518433 519919 526325 529094 538182 541420 544771 546134 556350 577693 615932 632092 678250 690198 700121 703012 707378 715071 719031 727422 731122 731153 732821 734540 734590 736010 739233 740112 741683 741768 744780 746147 746691 749377 749604 750925 754038 758157 761378 761379 761387 761837 766966 766981 767538 767545 767570 767614 767615 767716 767792 768002 773120 774909 774919 774996 778497 779742 779799 780172 780210 787482 787689 790709 791254 791779 792269 792439 792442 792476 794267 794579 795361 795852 795904 796693 798142 800173 800741 801139 801500 801505 802077 802247 803165 809708 810293 811330 811831 812370 820081 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.27%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"wife handjob"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.74 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жен дрочк член"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.