Query Metrics
7
Database Queries
7
Different statements
144.40 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
121.46 ms (84.11%) |
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 87066 387319 398974 400554 406949 411446 488456 522554 531264 535602 551134 564046 575288 577704 583400 592575 596358 622304 634460 644138 644398 650096 651729 653968 660074 668064 687124 689023 689245 697996 701285 713158 715153 716631 716640 716652 717062 719075 719130 720084 722189 724736 724789 725349 726373 728022 728662 729906 736468 740037 740840 741879 748767 748798 749138 750781 752502 753683 754343 758020 760461 761998 763342 763571 763575 763592 763629 764243 765410 765762 768807 769624 769631 771710 771714 771752 772251 774711 774729 776457 777612 778751 778939 779448 779548 779932 780149 781619 782914 782939 783547 784265 785311 789045 793411 793442 793474 793724 793751 794977 794992 797433 798339 798623 799488 799508 803445 805627 805632 806260 806317 810593 817126 817383 817754 817755 819265 824506 824916 826126 ] |
||||||||||||||||||||||||||||||
|
12.46 ms (8.63%) |
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 741879 748798 726373 729906 736468 754343 763629 768807 771710 772251 740840 748767 763571 763575 763592 764243 765410 769624 771714 717062 720084 722189 774729 778939 782914 783547 789045 398974 406949 387319 411446 817383 817755 826126 817126 824506 824916 817754 819265 522554 531264 535602 488456 564046 577704 551134 575288 583400 687124 716640 716652 719075 701285 713158 715153 716631 650096 651729 653968 660074 668064 689023 689245 697996 622304 644138 596358 634460 592575 774711 779448 781619 793411 793724 794992 798339 798623 803445 805632 793442 797433 805627 806317 810593 724789 760461 784265 785311 794977 799488 725349 728662 750781 753683 728022 761998 769631 749138 752502 765762 724736 740037 758020 763342 771752 644398 719130 776457 777612 778751 779548 779932 780149 782939 793474 793751 799508 806260 87066 400554 ] |
||||||||||||||||||||||||||||||
|
2.75 ms (1.91%) |
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 87066 387319 398974 400554 406949 411446 488456 522554 531264 535602 551134 564046 575288 577704 583400 592575 596358 622304 634460 644138 644398 650096 651729 653968 660074 668064 687124 689023 689245 697996 701285 713158 715153 716631 716640 716652 717062 719075 719130 720084 722189 724736 724789 725349 726373 728022 728662 729906 736468 740037 740840 741879 748767 748798 749138 750781 752502 753683 754343 758020 760461 761998 763342 763571 763575 763592 763629 764243 765410 765762 768807 769624 769631 771710 771714 771752 772251 774711 774729 776457 777612 778751 778939 779448 779548 779932 780149 781619 782914 782939 783547 784265 785311 789045 793411 793442 793474 793724 793751 794977 794992 797433 798339 798623 799488 799508 803445 805627 805632 806260 806317 810593 817126 817383 817754 817755 819265 824506 824916 826126 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.52%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex webcam"
]
|
||||||||||||||||||||||||||||||
|
1.99 ms (1.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс вебкамер"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.31%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (1.15%) |
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.