Query Metrics
7
Database Queries
7
Different statements
177.74 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
145.11 ms (81.64%) |
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 418958 421821 421822 421824 421825 421845 421847 421858 421875 421913 421918 421931 422141 422146 422165 422183 422187 422196 422207 426701 427113 427536 428853 428869 428890 428892 430433 430486 433977 435676 438219 439635 439648 439652 439660 439698 439704 439707 439763 439774 439802 440979 442237 443832 443946 444044 448955 452772 455282 456057 460601 460659 460728 463624 466762 468091 475174 480982 489384 490929 493166 493189 495007 505956 506131 506134 506824 512895 513495 514441 516886 519426 519480 519735 520204 522168 523323 523827 523837 523848 524486 524781 525469 525878 525964 529157 529170 529376 537020 538002 538970 541535 543773 549823 549842 549849 550220 557551 557554 563432 575704 588755 591155 591258 609203 619717 622667 623499 659986 716927 720258 729635 731063 748210 756209 756714 769547 806084 808675 809271 ] |
||||||||||||||||||||||||||||||
|
21.87 ms (12.30%) |
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 541535 543773 549823 549849 557551 575704 659986 720258 716927 549842 550220 557554 563432 588755 591258 609203 623499 591155 622667 806084 808675 731063 748210 729635 769547 756209 756714 619717 809271 422165 422183 422207 426701 428853 428869 428890 438219 439652 439774 443832 456057 460728 463624 475174 480982 421821 421822 421824 421875 421931 433977 439635 439648 439698 439707 439802 440979 442237 443946 448955 460659 468091 421847 421858 421913 421918 422141 422146 422196 427536 428892 444044 452772 466762 439660 439704 439763 460601 418958 421825 421845 422187 427113 430433 430486 435676 455282 519480 529157 538970 506131 514441 519426 519735 520204 524781 525878 529170 538002 489384 493166 493189 495007 505956 506134 512895 513495 516886 523323 523848 525964 529376 537020 490929 506824 522168 523827 523837 524486 525469 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.33%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"son long"
]
|
||||||||||||||||||||||||||||||
|
2.36 ms (1.33%) |
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 418958 421821 421822 421824 421825 421845 421847 421858 421875 421913 421918 421931 422141 422146 422165 422183 422187 422196 422207 426701 427113 427536 428853 428869 428890 428892 430433 430486 433977 435676 438219 439635 439648 439652 439660 439698 439704 439707 439763 439774 439802 440979 442237 443832 443946 444044 448955 452772 455282 456057 460601 460659 460728 463624 466762 468091 475174 480982 489384 490929 493166 493189 495007 505956 506131 506134 506824 512895 513495 514441 516886 519426 519480 519735 520204 522168 523323 523827 523837 523848 524486 524781 525469 525878 525964 529157 529170 529376 537020 538002 538970 541535 543773 549823 549842 549849 550220 557551 557554 563432 575704 588755 591155 591258 609203 619717 622667 623499 659986 716927 720258 729635 731063 748210 756209 756714 769547 806084 808675 809271 ] |
||||||||||||||||||||||||||||||
|
2.08 ms (1.17%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.05 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"son длинные"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"son длинные"
]
|
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.