Query Metrics
7
Database Queries
7
Different statements
142.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
122.51 ms (85.79%) |
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 80035 102250 303426 338338 398428 422123 472646 504683 521731 529851 532334 540949 543619 548910 576194 617377 626943 629776 629979 630111 635334 642094 645773 648872 651901 661909 668742 670065 683281 692682 716602 718141 718397 722123 724793 728144 728918 730985 732670 733468 733519 735501 735841 736259 742944 743794 743874 746216 747220 748696 755238 759033 760497 761259 761444 766875 769473 773781 777461 779442 782484 784426 786921 787269 789622 790329 790364 791841 793198 793731 793747 794586 794725 795787 796346 799378 799787 803209 803682 810330 817204 817517 818050 818614 818679 819413 819728 819987 820202 821787 821804 823258 823554 823751 823763 823897 824003 824098 824117 824220 824721 824796 824944 824970 824973 825118 825180 825245 825306 825352 825380 825391 825711 825850 825881 826929 826932 826933 827647 ] |
||||||||||||||||||||||||||||||
|
10.54 ms (7.38%) |
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 825306 521731 543619 576194 668742 645773 626943 777461 790329 794725 732670 819987 735501 784426 786921 779442 794586 823897 824721 825245 825118 825352 827647 722123 803682 728144 767970 760497 789622 548910 651901 736259 338338 824973 819413 825180 795787 422123 824944 824796 810330 824003 824970 825850 825881 823763 820202 826932 769473 730985 773781 718397 398428 793198 747220 748696 799378 670065 818050 818679 818614 826933 823554 824098 825711 790364 799787 803209 793731 759033 761444 724793 796346 823258 617377 791841 819728 742944 661909 642094 743874 824220 733468 532334 80035 303426 821787 824117 825391 823751 826929 821804 825380 746216 755238 766875 102250 540949 782484 761259 817204 504683 529851 648872 683281 692682 718141 629776 630111 635334 728918 733519 735841 743794 629979 787269 817517 793747 716602 472646 ] |
||||||||||||||||||||||||||||||
|
2.74 ms (1.92%) |
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 80035 102250 303426 338338 398428 422123 472646 504683 521731 529851 532334 540949 543619 548910 576194 617377 626943 629776 629979 630111 635334 642094 645773 648872 651901 661909 668742 670065 683281 692682 716602 718141 718397 722123 724793 728144 728918 730985 732670 733468 733519 735501 735841 736259 742944 743794 743874 746216 747220 748696 755238 759033 760497 761259 761444 766875 769473 773781 777461 779442 782484 784426 786921 787269 789622 790329 790364 791841 793198 793731 793747 794586 794725 795787 796346 799378 799787 803209 803682 810330 817204 817517 818050 818614 818679 819413 819728 819987 820202 821787 821804 823258 823554 823751 823763 823897 824003 824098 824117 824220 824721 824796 824944 824970 824973 825118 825180 825245 825306 825352 825380 825391 825711 825850 825881 826929 826932 826933 827647 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.31%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"любительский минет до…"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (1.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск минет оральн секс"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.