Query Metrics
7
Database Queries
7
Different statements
407.11 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
267.75 ms (65.77%) |
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 396218 409590 413809 507165 485281 560804 392918 382488 467997 822653 819122 821693 821720 822062 827837 460487 687908 774698 752460 796995 724433 373905 415392 514381 396041 405129 817549 822665 524713 452318 453565 480610 815003 532487 550068 568139 577514 549326 710690 671396 679297 645393 650586 665928 589077 640917 610701 592902 593116 593389 636816 592275 592997 597700 600373 788248 758540 758554 807923 750168 756689 756800 724555 731944 726196 615177 797375 385034 398230 444477 814849 454091 453438 466524 445553 468956 550065 596816 596740 623879 809368 760739 810926 730299 402793 447352 496820 527480 91570 821405 822553 823231 821986 822637 452356 766886 383139 399869 422708 461048 523092 579310 630900 412287 458578 405123 404275 515567 824718 822646 720942 416137 817246 822668 822670 822769 818871 819463 822079 822085 ] |
||||||||||||||||||||||||||||||
|
128.35 ms (31.53%) |
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 91570 373905 382488 383139 385034 392918 396041 396218 398230 399869 402793 404275 405123 405129 409590 412287 413809 415392 416137 422708 444477 445553 447352 452318 452356 453438 453565 454091 458578 460487 461048 466524 467997 468956 480610 485281 496820 507165 514381 515567 523092 524713 527480 532487 549326 550065 550068 560804 568139 577514 579310 589077 592275 592902 592997 593116 593389 596740 596816 597700 600373 610701 615177 623879 630900 636816 640917 645393 650586 665928 671396 679297 687908 710690 720942 724433 724555 726196 730299 731944 750168 752460 756689 756800 758540 758554 760739 766886 774698 788248 796995 797375 807923 809368 810926 814849 815003 817246 817549 818871 819122 819463 821405 821693 821720 821986 822062 822079 822085 822553 822637 822646 822653 822665 822668 822670 822769 823231 824718 827837 ] |
||||||||||||||||||||||||||||||
|
2.93 ms (0.72%) |
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 91570 373905 382488 383139 385034 392918 396041 396218 398230 399869 402793 404275 405123 405129 409590 412287 413809 415392 416137 422708 444477 445553 447352 452318 452356 453438 453565 454091 458578 460487 461048 466524 467997 468956 480610 485281 496820 507165 514381 515567 523092 524713 527480 532487 549326 550065 550068 560804 568139 577514 579310 589077 592275 592902 592997 593116 593389 596740 596816 597700 600373 610701 615177 623879 630900 636816 640917 645393 650586 665928 671396 679297 687908 710690 720942 724433 724555 726196 730299 731944 750168 752460 756689 756800 758540 758554 760739 766886 774698 788248 796995 797375 807923 809368 810926 814849 815003 817246 817549 818871 819122 819463 821405 821693 821720 821986 822062 822079 822085 822553 822637 822646 822653 822665 822668 822670 822769 823231 824718 827837 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"latina big"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.99 ms (0.49%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская большие"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
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.