Query Metrics
7
Database Queries
7
Different statements
141.87 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.99 ms (84.58%) |
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 3371 12775 21478 46186 70646 270104 320786 383898 384811 385925 386430 392266 394768 395310 395325 396037 400668 403458 403476 403555 406080 407322 408743 415619 416092 416470 420143 428246 428804 429278 438959 441864 442928 445582 445826 446219 449911 453987 454681 454948 460011 463726 464920 468857 469105 469437 473459 479784 481695 487972 490168 491842 493278 505061 506352 509729 525896 529230 530051 530059 532487 533475 536828 540637 542289 550068 585341 625765 720874 724379 731694 748751 752407 756220 758123 758567 760122 760965 764337 766613 767189 771243 771255 774601 780553 784550 786725 798361 799052 800208 800666 801527 803327 807385 809287 810048 810214 810227 811540 813074 813215 814137 815003 818687 819081 819134 820342 821142 821153 821296 821611 821681 822267 822608 823200 823301 826213 826215 828411 ] |
||||||||||||||||||||||||||||||
|
12.32 ms (8.69%) |
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 799052 801527 809287 810048 810214 810227 774601 775033 780553 800666 803327 807385 813074 752407 758567 767189 771243 784550 786725 798361 813215 731694 760122 766613 771255 724379 748751 758123 760965 764337 625765 720874 800208 811540 46186 400668 445582 395325 428804 481695 386430 3371 396037 818687 821142 821153 822267 822608 823301 820342 826213 826215 819081 819134 821296 821611 821681 828411 585341 756220 70646 270104 385925 383898 384811 394768 395310 392266 320786 21478 12775 403476 403458 406080 403555 408743 416092 420143 407322 415619 416470 441864 442928 428246 429278 438959 823200 814137 815003 445826 468857 473459 487972 491842 446219 453987 454681 454948 460011 479784 493278 449911 464920 469437 530051 505061 509729 530059 533475 540637 506352 525896 529230 532487 536828 463726 469105 490168 542289 550068 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (2.13%) |
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 3371 12775 21478 46186 70646 270104 320786 383898 384811 385925 386430 392266 394768 395310 395325 396037 400668 403458 403476 403555 406080 407322 408743 415619 416092 416470 420143 428246 428804 429278 438959 441864 442928 445582 445826 446219 449911 453987 454681 454948 460011 463726 464920 468857 469105 469437 473459 479784 481695 487972 490168 491842 493278 505061 506352 509729 525896 529230 530051 530059 532487 533475 536828 540637 542289 550068 585341 625765 720874 724379 731694 748751 752407 756220 758123 758567 760122 760965 764337 766613 767189 771243 771255 774601 780553 784550 786725 798361 799052 800208 800666 801527 803327 807385 809287 810048 810214 810227 811540 813074 813215 814137 815003 818687 819081 819134 820342 821142 821153 821296 821611 821681 822267 822608 823200 823301 826213 826215 828411 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (1.28%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"латин а"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"латинская"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"латинская"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.04%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.