Query Metrics
7
Database Queries
7
Different statements
169.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
148.28 ms (87.54%) |
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 294 3561 382113 395246 397173 414430 416240 422064 434135 442704 459515 468722 472498 473764 478520 497813 509516 512392 517536 520148 524046 528295 529661 530398 530409 534975 535780 536756 537785 538731 540129 540158 547412 548515 548902 550992 553144 553600 554143 554199 554685 555597 560678 561213 562150 562542 563374 564486 564643 565137 567222 570892 571698 576482 583796 585645 586411 596144 601163 628747 628756 628854 650258 650928 660743 661023 664227 674231 690666 694751 715426 727163 743996 749025 750387 752944 753630 754504 758561 759114 759129 759222 761116 764731 765863 769148 772483 777292 778448 784052 784337 789561 795389 805154 808540 810390 812497 813139 813704 813819 814441 816854 821367 821547 821785 822313 823009 823437 823771 823774 823991 823994 824112 825335 825367 825800 826856 827440 827630 ] |
||||||||||||||||||||||||||||||
|
12.34 ms (7.28%) |
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 743996 753630 754504 759222 727163 749025 764731 715426 777292 395246 752944 382113 3561 414430 434135 416240 459515 512392 517536 530409 553600 583796 562542 570892 563374 565137 660743 664227 674231 690666 694751 650258 650928 661023 554143 554199 555597 561213 562150 567222 571698 628747 585645 586411 596144 601163 628756 628854 778448 784052 789561 795389 808540 813139 810390 812497 750387 759129 772483 784337 758561 765863 769148 759114 761116 805154 422064 468722 473764 478520 442704 524046 509516 564643 564486 294 397173 823774 825335 814441 821547 826856 827440 827630 821367 822313 823437 823492 823771 823991 824112 813704 813819 816854 821785 823009 823994 825367 825800 520148 529661 530398 537785 538731 540158 497813 534975 536756 540129 528295 535780 472498 547412 550992 548902 553144 554685 560678 576482 548515 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.19%) |
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 294 3561 382113 395246 397173 414430 416240 422064 434135 442704 459515 468722 472498 473764 478520 497813 509516 512392 517536 520148 524046 528295 529661 530398 530409 534975 535780 536756 537785 538731 540129 540158 547412 548515 548902 550992 553144 553600 554143 554199 554685 555597 560678 561213 562150 562542 563374 564486 564643 565137 567222 570892 571698 576482 583796 585645 586411 596144 601163 628747 628756 628854 650258 650928 660743 661023 664227 674231 690666 694751 715426 727163 743996 749025 750387 752944 753630 754504 758561 759114 759129 759222 761116 764731 765863 769148 772483 777292 778448 784052 784337 789561 795389 805154 808540 810390 812497 813139 813704 813819 814441 816854 821367 821547 821785 822313 823009 823437 823771 823774 823991 823994 824112 825335 825367 825800 826856 827440 827630 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"bathroom solo"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"ван соло"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"ван соло"
]
|
||||||||||||||||||||||||||||||
|
1.30 ms (0.77%) |
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.