Query Metrics
7
Database Queries
7
Different statements
164.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.66 ms (86.24%) |
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 74135 154257 154491 154826 182232 384397 389794 393313 393314 397437 398073 401769 401810 402628 402632 413418 416695 416704 429601 466427 467715 473446 477090 511866 513830 521139 524675 529793 531822 531839 531850 531856 531866 534532 534537 539185 541377 543127 543897 545438 547458 547854 548834 550916 550925 553130 559360 564222 564291 564295 567122 568501 573183 574375 574656 579673 583712 601208 605208 608076 609887 618231 628097 629281 630793 632254 655242 658784 658802 662049 662856 664189 665958 666898 669073 670366 671002 671020 672938 680252 695875 697473 713501 713507 720186 722428 723461 728269 738476 738822 740932 742363 744266 745083 745128 749067 749084 749221 749271 752603 752652 752664 752675 752681 752712 752755 755821 759179 766943 770254 770262 782836 784775 788192 799695 799696 803134 808331 814487 819218 ] |
||||||||||||||||||||||||||||||
|
12.66 ms (7.71%) |
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 154491 154826 393314 402628 413418 429601 467715 574375 583712 720186 655242 608076 628097 629281 154257 389794 416704 477090 513830 534532 534537 529793 547458 541377 548834 564222 564295 658784 664189 669073 697473 722428 553130 567122 632254 601208 799695 799696 755821 752652 752675 744266 770254 749271 630793 416695 402632 74135 401810 511866 524675 531839 531850 662049 695875 579673 605208 609887 782836 752603 752712 738476 749084 384397 752664 808331 393313 401769 819218 521139 531822 531856 466427 573183 550916 574656 658802 662856 665958 666898 672938 680252 713501 713507 784775 788192 740932 752681 728269 749067 749221 766943 770262 738822 742363 752755 745083 745128 618231 803134 398073 182232 759179 671020 670366 397437 814487 473446 539185 531866 559360 543897 564291 543127 545438 547854 550925 568501 671002 723461 ] |
||||||||||||||||||||||||||||||
|
2.98 ms (1.81%) |
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 74135 154257 154491 154826 182232 384397 389794 393313 393314 397437 398073 401769 401810 402628 402632 413418 416695 416704 429601 466427 467715 473446 477090 511866 513830 521139 524675 529793 531822 531839 531850 531856 531866 534532 534537 539185 541377 543127 543897 545438 547458 547854 548834 550916 550925 553130 559360 564222 564291 564295 567122 568501 573183 574375 574656 579673 583712 601208 605208 608076 609887 618231 628097 629281 630793 632254 655242 658784 658802 662049 662856 664189 665958 666898 669073 670366 671002 671020 672938 680252 695875 697473 713501 713507 720186 722428 723461 728269 738476 738822 740932 742363 744266 745083 745128 749067 749084 749221 749271 752603 752652 752664 752675 752681 752712 752755 755821 759179 766943 770254 770262 782836 784775 788192 799695 799696 803134 808331 814487 819218 ] |
||||||||||||||||||||||||||||||
|
1.88 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"огромные анал"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"huge anal"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.90%) |
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.