Query Metrics
7
Database Queries
7
Different statements
168.30 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
141.35 ms (83.99%) |
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 491829 522377 522601 522885 529899 530364 532067 537574 537705 538850 538873 538950 538951 538953 540460 541339 541586 542469 542477 544116 544260 544275 544279 544280 544286 544291 544292 544306 544323 544329 546390 547303 547317 547325 547860 549268 549285 549298 549322 549326 549334 549356 549357 549360 549377 549382 549387 549394 549400 549409 549410 549413 549434 549898 549916 549955 549988 549996 550010 550333 550334 551020 551066 551078 551927 552032 556794 556860 557322 559122 559128 560999 561033 562844 566687 566689 566805 566891 570797 570806 570825 572587 572599 572601 572603 572605 572638 572650 572748 573214 574222 574292 574451 576644 576655 581312 581334 583872 586816 586866 592435 606757 621322 628137 628322 641658 642793 648259 668937 681040 681052 685447 687096 687116 687132 699677 700742 707273 756313 790088 ] |
||||||||||||||||||||||||||||||
|
15.26 ms (9.07%) |
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 606757 592435 586866 621322 641658 537705 530364 537574 538950 538953 540460 546390 547325 549360 549409 549955 566891 570806 572638 549394 547317 549916 549988 566805 573214 681040 687096 687132 700742 549434 549898 628322 628137 586816 642793 790088 756313 699677 707273 491829 529899 538873 522377 532067 538951 522601 522885 538850 544275 544291 547860 549268 549377 549382 549387 550334 557322 559128 572599 572601 572603 572605 576644 581312 541339 541586 542469 544279 544280 544292 544323 547303 549285 549298 549326 549400 550333 551066 556860 559122 566687 572587 574222 574292 581334 542477 544116 544260 544286 544306 544329 549322 549334 549356 549357 549410 549996 550010 552032 556794 566689 572650 576655 648259 668937 681052 685447 687116 549413 551020 551078 551927 560999 561033 562844 570797 570825 572748 574451 583872 ] |
||||||||||||||||||||||||||||||
|
3.28 ms (1.95%) |
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 491829 522377 522601 522885 529899 530364 532067 537574 537705 538850 538873 538950 538951 538953 540460 541339 541586 542469 542477 544116 544260 544275 544279 544280 544286 544291 544292 544306 544323 544329 546390 547303 547317 547325 547860 549268 549285 549298 549322 549326 549334 549356 549357 549360 549377 549382 549387 549394 549400 549409 549410 549413 549434 549898 549916 549955 549988 549996 550010 550333 550334 551020 551066 551078 551927 552032 556794 556860 557322 559122 559128 560999 561033 562844 566687 566689 566805 566891 570797 570806 570825 572587 572599 572601 572603 572605 572638 572650 572748 573214 574222 574292 574451 576644 576655 581312 581334 583872 586816 586866 592435 606757 621322 628137 628322 641658 642793 648259 668937 681040 681052 685447 687096 687116 687132 699677 700742 707273 756313 790088 ] |
||||||||||||||||||||||||||||||
|
2.46 ms (1.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"фильм"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"film 2022"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (0.99%) |
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.