Query Metrics
7
Database Queries
7
Different statements
203.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
182.15 ms (89.60%) |
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 256162 417077 458948 478348 490591 529785 532235 533796 537078 537095 537283 541563 542479 543702 551481 551713 551837 563572 564698 565129 567458 568312 575299 577308 583405 585303 589857 594547 596284 603567 608000 610421 612228 615256 616535 619393 622275 627595 630345 633477 634263 636556 637170 637785 639715 641501 644456 646639 650048 650269 650881 652286 660622 661701 665827 665954 668331 681710 681719 685432 688252 692214 692437 693040 695551 699431 708908 709504 710015 712144 712582 713285 713768 716502 716994 730920 739263 740565 742325 742332 744030 745314 745639 745792 748853 749394 749754 751313 752458 764826 765404 765627 770381 771909 773110 778132 778610 780274 783880 784125 784130 787737 788464 788637 788938 791169 792104 792438 801713 802043 803683 803857 804297 804489 811324 820206 821789 823409 823996 826354 ] |
||||||||||||||||||||||||||||||
|
12.28 ms (6.04%) |
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 417077 821789 823409 820206 490591 533796 537078 537095 532235 537283 478348 565129 577308 542479 551837 564698 543702 551713 665954 681719 692437 699431 713285 646639 650269 650881 708908 716994 650048 660622 665827 692214 693040 710015 585303 596284 616535 641501 619393 636556 644456 594547 637170 639715 788464 788938 787737 739263 764826 803683 803857 749754 745314 745639 745792 765404 748853 749394 615256 778132 788637 801713 804297 458948 826354 529785 563572 695551 652286 622275 630345 783880 791169 802043 740565 770381 778610 256162 823996 541563 551481 568312 575299 583405 661701 712582 668331 681710 709504 685432 688252 712144 716502 567458 589857 610421 627595 633477 603567 608000 612228 634263 780274 792104 804489 811324 792438 744030 773110 784130 742332 730920 742325 752458 751313 765627 771909 637785 713768 784125 ] |
||||||||||||||||||||||||||||||
|
2.26 ms (1.11%) |
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 256162 417077 458948 478348 490591 529785 532235 533796 537078 537095 537283 541563 542479 543702 551481 551713 551837 563572 564698 565129 567458 568312 575299 577308 583405 585303 589857 594547 596284 603567 608000 610421 612228 615256 616535 619393 622275 627595 630345 633477 634263 636556 637170 637785 639715 641501 644456 646639 650048 650269 650881 652286 660622 661701 665827 665954 668331 681710 681719 685432 688252 692214 692437 693040 695551 699431 708908 709504 710015 712144 712582 713285 713768 716502 716994 730920 739263 740565 742325 742332 744030 745314 745639 745792 748853 749394 749754 751313 752458 764826 765404 765627 770381 771909 773110 778132 778610 780274 783880 784125 784130 787737 788464 788637 788938 791169 792104 792438 801713 802043 803683 803857 804297 804489 811324 820206 821789 823409 823996 826354 ] |
||||||||||||||||||||||||||||||
|
1.78 ms (0.88%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"video девушк"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.79%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"video девушк"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"video girl"
]
|
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.