Query Metrics
7
Database Queries
7
Different statements
139.57 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
117.55 ms (84.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 74830 237362 337190 385265 386573 387325 398759 398932 403649 411729 418548 430936 447297 448547 454462 455675 456789 459309 462832 472375 479147 483093 492072 495095 495885 513924 518638 519092 519984 541096 546415 551211 551810 551828 558486 571455 571636 572306 576692 579614 583546 584866 584884 588438 598703 609545 612282 615297 622508 626026 641195 669641 676660 677181 685165 685230 694987 696874 698486 698768 698879 700682 704218 718606 719150 720557 723690 730183 734593 742284 743716 744496 744807 746433 747242 748520 749885 753219 754072 756414 757489 760442 760448 762061 763449 764286 765396 765811 767295 767298 767304 767328 767331 769122 774207 777552 778546 783857 786629 787661 787665 787671 787681 790100 790123 791269 791299 791795 792928 793054 793859 794049 796863 797564 804692 808279 809697 810371 817831 820619 ] |
||||||||||||||||||||||||||||||
|
12.89 ms (9.23%) |
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 622508 696874 794049 762061 734593 641195 769122 677181 743716 398759 783857 337190 700682 609545 746433 513924 386573 447297 387325 398932 760448 456789 448547 430936 455675 704218 462832 495885 676660 572306 571636 385265 479147 418548 719150 583546 483093 541096 584884 411729 492072 237362 579614 571455 787671 804692 791299 748520 495095 576692 551211 403649 754072 787665 742284 763449 756414 584866 718606 793054 744807 808279 472375 669641 558486 685165 767331 786629 790123 694987 777552 764286 787681 698486 615297 698768 790100 551828 74830 817831 454462 519984 598703 720557 791269 551810 747242 793859 698879 809697 767304 767328 723690 765396 767298 753219 791795 518638 778546 797564 774207 787661 744496 757489 765811 792928 810371 820619 685230 626026 767295 519092 459309 546415 588438 612282 730183 760442 796863 749885 ] |
||||||||||||||||||||||||||||||
|
2.30 ms (1.65%) |
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 74830 237362 337190 385265 386573 387325 398759 398932 403649 411729 418548 430936 447297 448547 454462 455675 456789 459309 462832 472375 479147 483093 492072 495095 495885 513924 518638 519092 519984 541096 546415 551211 551810 551828 558486 571455 571636 572306 576692 579614 583546 584866 584884 588438 598703 609545 612282 615297 622508 626026 641195 669641 676660 677181 685165 685230 694987 696874 698486 698768 698879 700682 704218 718606 719150 720557 723690 730183 734593 742284 743716 744496 744807 746433 747242 748520 749885 753219 754072 756414 757489 760442 760448 762061 763449 764286 765396 765811 767295 767298 767304 767328 767331 769122 774207 777552 778546 783857 786629 787661 787665 787671 787681 790100 790123 791269 791299 791795 792928 793054 793859 794049 796863 797564 804692 808279 809697 810371 817831 820619 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex vagina"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс вагин"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (1.02%) |
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.