Query Metrics
7
Database Queries
7
Different statements
134.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
115.30 ms (85.50%) |
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 459194 478979 504117 505933 506652 520222 547402 556200 556207 567655 569517 575627 586295 588441 588492 588550 592896 599304 603113 605891 628695 629642 636119 639238 668711 674502 687935 692367 702855 703704 703814 704840 705058 709886 710663 718282 721037 725635 727029 727229 730191 731049 733430 733742 734201 738315 739573 742075 742609 747991 751241 751742 752741 753172 753210 755119 755186 756972 758345 758547 760148 761138 764115 765924 767402 767480 767759 768836 769137 770069 772218 773639 773691 774267 775294 776359 777992 778281 779111 781289 781348 783125 784631 785020 786568 787086 787205 787975 788091 791629 791672 791732 791988 792245 793355 794109 794272 794596 794758 794942 797481 797484 799065 800394 801605 802141 802187 805237 806561 807315 810081 810493 810723 813472 824157 826741 827947 828570 ] |
||||||||||||||||||||||||||||||
|
11.56 ms (8.57%) |
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 827947 824157 826741 828570 459194 478979 504117 506652 520222 505933 567655 575627 547402 556200 556207 569517 703704 705058 709886 668711 702855 703814 710663 674502 687935 692367 704840 718282 721037 588550 599304 605891 588441 592896 586295 588492 628695 629642 636119 603113 639238 777992 779111 781289 784631 791672 791988 794596 797484 805237 810493 775294 776359 778281 781348 785020 787086 787205 787975 791629 793355 794109 794272 797481 801605 802141 802187 806561 810081 813472 733430 733742 738315 742075 742609 753172 755119 758345 758547 767402 767480 769137 773517 773639 783125 786568 788091 791732 792245 794758 794942 799065 800394 807315 810723 731049 734201 755186 756972 760148 761138 765924 767759 773295 727229 739573 747991 751742 752741 753210 768836 770069 773691 774267 725635 751241 764115 772218 727029 730191 ] |
||||||||||||||||||||||||||||||
|
2.31 ms (1.71%) |
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 459194 478979 504117 505933 506652 520222 547402 556200 556207 567655 569517 575627 586295 588441 588492 588550 592896 599304 603113 605891 628695 629642 636119 639238 668711 674502 687935 692367 702855 703704 703814 704840 705058 709886 710663 718282 721037 725635 727029 727229 730191 731049 733430 733742 734201 738315 739573 742075 742609 747991 751241 751742 752741 753172 753210 755119 755186 756972 758345 758547 760148 761138 764115 765924 767402 767480 767759 768836 769137 770069 772218 773639 773691 774267 775294 776359 777992 778281 779111 781289 781348 783125 784631 785020 786568 787086 787205 787975 788091 791629 791672 791732 791988 792245 793355 794109 794272 794596 794758 794942 797481 797484 799065 800394 801605 802141 802187 805237 806561 807315 810081 810493 810723 813472 824157 826741 827947 828570 ] |
||||||||||||||||||||||||||||||
|
1.52 ms (1.13%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"трусик нижн бел cum"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"panties cum on"
]
|
||||||||||||||||||||||||||||||
|
1.36 ms (1.01%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"трусик нижн бел cum"
]
|
||||||||||||||||||||||||||||||
|
1.31 ms (0.97%) |
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.