Query Metrics
7
Database Queries
7
Different statements
157.31 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.98 ms (86.44%) |
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 4463 12573 187717 249773 358264 358596 382383 388700 391247 391267 393659 395574 395667 395669 396654 397910 400666 407809 417476 422504 441550 443154 445795 466238 468399 487338 505758 513499 514802 560637 560952 574935 586010 591899 598474 605966 612861 619375 619786 626686 628391 628403 628441 640772 643612 648512 655131 656569 663976 668100 688025 689146 691584 692047 697456 697806 707214 707819 708475 711112 713671 719524 719638 720680 721390 723147 725115 727753 731347 733796 737164 737444 742312 742799 744601 745678 747368 748415 750041 752694 753441 753479 753503 754222 756160 757442 758193 766718 766810 766887 769040 769895 770280 770590 771607 774698 775883 777637 778951 781587 783197 790141 790446 791047 791200 792989 794924 796289 800377 800903 803101 806617 809652 810671 814390 820565 821319 821559 826264 827381 ] |
||||||||||||||||||||||||||||||
|
12.59 ms (8.01%) |
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 800377 725115 757442 737164 758193 727753 744601 754222 770280 619375 697806 4463 358264 397910 395669 443154 692047 688025 708475 775883 747368 719638 417476 663976 628403 720680 711112 656569 689146 790446 791200 778951 792989 806617 756160 769040 771607 777637 391267 445795 697456 707214 713671 668100 643612 781587 800903 742312 794924 748415 783197 628441 809652 12573 395667 827381 826264 733796 790141 731347 388700 358596 391247 628391 640772 422504 187717 396654 407809 612861 393659 466238 487338 513499 560952 574935 605966 586010 468399 505758 249773 395574 382383 400666 441550 821319 820565 814390 821559 514802 648512 655131 719524 721390 723147 691584 707819 560637 591899 598474 619786 626686 774698 791047 803101 810671 737444 769895 770590 796289 742799 752694 753479 753503 766810 766887 745678 750041 753441 766718 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.37%) |
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 4463 12573 187717 249773 358264 358596 382383 388700 391247 391267 393659 395574 395667 395669 396654 397910 400666 407809 417476 422504 441550 443154 445795 466238 468399 487338 505758 513499 514802 560637 560952 574935 586010 591899 598474 605966 612861 619375 619786 626686 628391 628403 628441 640772 643612 648512 655131 656569 663976 668100 688025 689146 691584 692047 697456 697806 707214 707819 708475 711112 713671 719524 719638 720680 721390 723147 725115 727753 731347 733796 737164 737444 742312 742799 744601 745678 747368 748415 750041 752694 753441 753479 753503 754222 756160 757442 758193 766718 766810 766887 769040 769895 770280 770590 771607 774698 775883 777637 778951 781587 783197 790141 790446 791047 791200 792989 794924 796289 800377 800903 803101 806617 809652 810671 814390 820565 821319 821559 826264 827381 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс молодые анал"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.13%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ебут молодых в жопу"
]
|
||||||||||||||||||||||||||||||
|
1.22 ms (0.78%) |
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.