Query Metrics
7
Database Queries
7
Different statements
169.83 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.82 ms (85.86%) |
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 326289 401830 401960 432573 434771 435572 438012 440947 447815 452308 453508 455949 456950 460325 461026 462649 493402 499286 507915 512528 518186 519251 524805 525376 539632 540388 546976 556648 598088 605560 614847 615274 616687 617639 631207 634849 651768 662889 672824 680619 680654 682612 683978 686119 689161 694559 696104 696745 700217 705200 709346 712574 712665 714037 714587 714620 715879 715908 720706 722125 726928 726966 728255 729039 731350 731552 735847 735984 736378 736519 744486 747406 752741 756354 757290 761138 763870 764963 766888 768348 770494 779283 783145 784206 787147 791607 791803 794306 794325 794435 794710 795988 796001 796117 796147 800394 800598 801264 801327 801368 801460 802769 811923 813627 813946 816596 817249 819405 819431 820345 823836 824974 825167 826739 827037 827069 828491 828565 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (8.39%) |
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 794325 800394 800598 801327 802769 761138 764963 735847 752741 766888 768348 731350 731552 714037 714587 720706 779283 791607 796117 456950 811923 631207 828491 617639 512528 460325 519251 540388 499286 680654 705200 700217 689161 616687 801460 726928 744486 757290 794435 614847 615274 747406 447815 401830 401960 801264 784206 728255 794306 462649 714620 598088 634849 795988 770494 434771 326289 525376 819405 824974 827069 825167 828018 828565 546976 791803 524805 823816 539632 556648 672824 712665 680619 682612 696745 651768 794710 796001 729039 756354 763870 605560 709346 722125 787147 518186 432573 736378 435572 493402 735984 820345 455949 694559 736519 801368 726966 783145 507915 453508 452308 796147 440947 438012 813946 813627 826739 823836 827037 817249 816596 819431 461026 683978 712574 686119 696104 715879 715908 662889 ] |
||||||||||||||||||||||||||||||
|
2.87 ms (1.69%) |
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 326289 401830 401960 432573 434771 435572 438012 440947 447815 452308 453508 455949 456950 460325 461026 462649 493402 499286 507915 512528 518186 519251 524805 525376 539632 540388 546976 556648 598088 605560 614847 615274 616687 617639 631207 634849 651768 662889 672824 680619 680654 682612 683978 686119 689161 694559 696104 696745 700217 705200 709346 712574 712665 714037 714587 714620 715879 715908 720706 722125 726928 726966 728255 729039 731350 731552 735847 735984 736378 736519 744486 747406 752741 756354 757290 761138 763870 764963 766888 768348 770494 779283 783145 784206 787147 791607 791803 794306 794325 794435 794710 795988 796001 796117 796147 800394 800598 801264 801327 801368 801460 802769 811923 813627 813946 816596 817249 819405 819431 820345 823836 824974 825167 826739 827037 827069 828491 828565 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (1.29%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"cum мам женщин"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (1.13%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"cum in mother"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (0.82%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.39 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"cum мам женщин"
]
|
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.