Query Metrics
7
Database Queries
7
Different statements
175.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.33 ms (87.05%) |
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 509103 519241 538664 538835 538847 538858 538865 538948 538955 539175 541361 541378 541396 541607 541624 541626 542464 542470 542488 542938 543010 543806 544276 544293 544294 544314 544316 544325 544326 544331 544343 544591 545765 546719 548271 548288 548290 548299 548300 548504 549282 549938 550033 554900 556789 556985 556988 559118 560078 560084 560920 561032 561585 561594 563099 563538 564543 566569 566682 566860 572558 572583 572625 573912 574201 574203 574249 574286 576633 576640 576709 576718 577118 577241 581285 583861 586826 586850 590932 592424 592461 592472 592474 592481 592493 592501 593270 593402 621703 623939 624153 624157 626558 626563 628170 628171 628298 628319 629286 629902 630309 647334 648485 649573 649989 651210 651617 668441 668465 668941 670764 672190 673567 687098 687114 696268 696270 706907 742152 750065 ] |
||||||||||||||||||||||||||||||
|
12.86 ms (7.35%) |
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 546719 548299 548290 544314 573912 577241 673567 696268 566569 623939 628171 519241 541396 583861 556789 576633 561594 548300 572583 592461 592481 544326 628319 572625 593270 539175 544293 549282 566682 548288 544331 581285 672190 696270 648485 649573 651617 706907 574249 576640 628298 592424 624153 626563 509103 541378 541607 538948 538847 560078 542464 542938 545765 548271 560084 687098 549938 592472 586826 593402 624157 592474 750065 576709 576718 563099 628170 538858 538835 544343 543806 561032 561585 574203 574286 687114 647334 670764 548504 564543 572558 574201 592493 621703 626558 586850 742152 629286 629902 543010 559118 563538 542488 544276 544591 556985 649989 668441 577118 592501 590932 538664 541361 556988 541626 630309 550033 538865 538955 542470 544316 566860 541624 544294 544325 651210 668941 668465 554900 560920 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.46%) |
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 509103 519241 538664 538835 538847 538858 538865 538948 538955 539175 541361 541378 541396 541607 541624 541626 542464 542470 542488 542938 543010 543806 544276 544293 544294 544314 544316 544325 544326 544331 544343 544591 545765 546719 548271 548288 548290 548299 548300 548504 549282 549938 550033 554900 556789 556985 556988 559118 560078 560084 560920 561032 561585 561594 563099 563538 564543 566569 566682 566860 572558 572583 572625 573912 574201 574203 574249 574286 576633 576640 576709 576718 577118 577241 581285 583861 586826 586850 590932 592424 592461 592472 592474 592481 592493 592501 593270 593402 621703 623939 624153 624157 626558 626563 628170 628171 628298 628319 629286 629902 630309 647334 648485 649573 649989 651210 651617 668441 668465 668941 670764 672190 673567 687098 687114 696268 696270 706907 742152 750065 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.14%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"films retro"
]
|
||||||||||||||||||||||||||||||
|
1.87 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"фильм ретр"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.85%) |
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.