Query Metrics
7
Database Queries
7
Different statements
164.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
143.26 ms (87.22%) |
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 188600 362726 387104 390580 391735 397080 397870 398385 398960 409946 411344 419862 425540 439601 448656 468363 486344 531571 533655 533775 533793 544161 545175 545669 547609 559401 563730 564296 564301 564549 567994 604260 609238 647689 672190 673960 680312 707102 711744 716780 717193 719308 720810 727757 727927 728266 728393 729277 729291 729907 731349 731357 736237 736242 742637 748068 749891 755076 755089 756677 758192 761069 761538 762301 765723 765792 766673 766985 767203 767212 773312 777233 777575 782294 783042 784162 791482 791624 792647 792654 793867 794070 796884 797159 798688 798804 799910 800326 800392 800469 800511 801214 801781 802025 804810 807926 808049 810318 813828 816985 817210 817336 818469 818609 819403 821005 821166 824615 826155 826265 827220 827492 827514 827609 827686 827721 828553 828595 828636 828773 ] |
||||||||||||||||||||||||||||||
|
10.03 ms (6.11%) |
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 765792 792647 736237 729291 742637 765723 766985 756677 797159 387104 398385 828595 545175 564301 777233 398960 397080 818469 818609 807926 390580 728266 801781 729277 486344 827514 824615 828636 533655 533793 748068 731349 731357 767212 188600 813828 821005 828773 468363 531571 545669 547609 567994 544161 559401 647689 672190 680312 707102 716780 717193 604260 793867 810318 777575 783042 784162 796884 798688 799910 800469 804810 729907 767203 791482 802025 736242 755076 728393 749891 761069 761538 762301 766673 720810 782294 792654 794070 798804 800326 448656 808049 609238 362726 425540 409946 819403 826155 817336 826265 827220 827492 817210 821166 827721 827609 827686 828553 533775 564549 719308 711744 564296 800392 800511 727757 755089 758192 773312 791624 801214 391735 816985 563730 411344 673960 397870 727927 419862 439601 ] |
||||||||||||||||||||||||||||||
|
2.90 ms (1.76%) |
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 188600 362726 387104 390580 391735 397080 397870 398385 398960 409946 411344 419862 425540 439601 448656 468363 486344 531571 533655 533775 533793 544161 545175 545669 547609 559401 563730 564296 564301 564549 567994 604260 609238 647689 672190 673960 680312 707102 711744 716780 717193 719308 720810 727757 727927 728266 728393 729277 729291 729907 731349 731357 736237 736242 742637 748068 749891 755076 755089 756677 758192 761069 761538 762301 765723 765792 766673 766985 767203 767212 773312 777233 777575 782294 783042 784162 791482 791624 792647 792654 793867 794070 796884 797159 798688 798804 799910 800326 800392 800469 800511 801214 801781 802025 804810 807926 808049 810318 813828 816985 817210 817336 818469 818609 819403 821005 821166 824615 826155 826265 827220 827492 827514 827609 827686 827721 828553 828595 828636 828773 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"мам анал"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"мам женщин анал"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.19%) |
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.