Query Metrics
7
Database Queries
7
Different statements
137.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.82 ms (82.94%) |
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 532050 538913 539649 541642 541647 541661 541664 541683 541740 541780 541808 541873 541875 542196 543497 544254 544272 544277 544295 544300 544313 544317 544337 544347 544349 544350 544352 547308 548289 549273 549300 549327 549957 549965 549968 550017 550328 556786 560080 560087 561026 562830 562846 563099 563534 563540 565571 565993 566246 566686 566692 566697 566699 572594 572645 573905 573911 573914 576632 576687 577353 577375 579950 581260 592391 592446 592539 593635 596576 597215 600557 601055 601068 606680 606781 608040 615749 620120 621316 626549 626556 628131 628329 630769 631818 642791 644287 646337 648912 650833 671761 681152 697705 699689 701345 702461 702893 704722 708785 709207 713138 716323 717074 719052 722685 723517 725176 727490 730225 730524 739478 742246 744262 744527 744591 755474 761321 790407 801192 801362 ] |
||||||||||||||||||||||||||||||
|
13.98 ms (10.19%) |
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 592539 600557 592391 596576 626556 593635 628131 644287 801362 739478 744527 801192 742246 701345 702461 702893 709207 538913 543497 544277 544313 544317 548289 562830 565571 576687 577353 581260 541873 544254 544300 544347 544352 560080 562846 563540 566686 566692 573905 573911 577375 541875 544295 549300 549327 549968 563099 563534 566246 566699 576632 681152 671761 716323 650833 556786 561026 601055 601068 620120 606680 615749 621316 597215 626549 592446 628329 541661 566697 573914 723517 539649 532050 544272 549965 560087 579950 544337 549273 565993 572645 544349 544350 550017 646337 699689 648912 717074 722685 697705 704722 708785 713138 719052 547308 549957 550328 572594 630769 631818 606781 642791 790407 727490 730225 725176 744591 730524 744262 761321 755474 608040 541647 541780 541808 541683 542196 541642 541664 541740 ] |
||||||||||||||||||||||||||||||
|
2.44 ms (1.78%) |
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 532050 538913 539649 541642 541647 541661 541664 541683 541740 541780 541808 541873 541875 542196 543497 544254 544272 544277 544295 544300 544313 544317 544337 544347 544349 544350 544352 547308 548289 549273 549300 549327 549957 549965 549968 550017 550328 556786 560080 560087 561026 562830 562846 563099 563534 563540 565571 565993 566246 566686 566692 566697 566699 572594 572645 573905 573911 573914 576632 576687 577353 577375 579950 581260 592391 592446 592539 593635 596576 597215 600557 601055 601068 606680 606781 608040 615749 620120 621316 626549 626556 628131 628329 630769 631818 642791 644287 646337 648912 650833 671761 681152 697705 699689 701345 702461 702893 704722 708785 709207 713138 716323 717074 719052 722685 723517 725176 727490 730225 730524 739478 742246 744262 744527 744591 755474 761321 790407 801192 801362 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"film long"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.22%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм длинные"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (1.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.61 ms (1.17%) |
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.