Query Metrics
7
Database Queries
7
Different statements
185.23 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.73 ms (85.70%) |
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 418405 429169 447919 451685 481191 481482 510653 540914 543836 546682 546843 548632 548668 548735 548743 548778 550238 550405 551219 551392 552376 552533 552677 552683 557261 558026 558498 558825 558826 559033 559099 559503 559820 560008 560488 560558 560610 560611 560613 561841 564091 564632 566222 566224 566345 567082 568404 570324 570505 570673 571474 571857 572128 572806 573026 573077 573098 573294 573417 573550 573663 573772 573788 573834 573959 574497 574595 574601 574812 574849 574877 574904 574920 575059 575078 575080 575089 575100 575137 575154 575468 575498 575503 575510 575524 575749 575755 575770 576045 576060 576077 576279 576293 576366 576387 576410 577130 578129 578384 578393 580648 580675 581668 583671 588878 590787 595477 595512 596350 597593 601313 603674 607101 626063 630736 664433 683955 685889 736101 737728 ] |
||||||||||||||||||||||||||||||
|
15.39 ms (8.31%) |
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 550238 551392 596350 630736 595512 601313 626063 603674 607101 590787 597593 737728 736101 481191 451685 418405 429169 447919 481482 510653 551219 568404 575749 546682 560610 548735 567082 540914 548668 552533 557261 558825 558826 559033 559503 560488 560558 564091 572806 573417 574595 575468 575503 575755 576387 578393 548743 552376 552677 561841 566224 570324 570673 571474 573077 573550 573772 573959 574497 574877 575059 575078 575100 575154 575498 575510 576077 576293 576366 576410 578384 543836 548632 552683 558498 559099 559820 560008 564632 566222 566345 573026 573788 574601 574812 575080 575137 575770 576060 577130 581668 664433 685889 683955 546843 548778 550405 558026 560611 560613 570505 571857 572128 573098 573294 573663 573834 574849 574904 574920 575089 575524 576045 576279 578129 580648 580675 583671 588878 595477 ] |
||||||||||||||||||||||||||||||
|
4.11 ms (2.22%) |
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 418405 429169 447919 451685 481191 481482 510653 540914 543836 546682 546843 548632 548668 548735 548743 548778 550238 550405 551219 551392 552376 552533 552677 552683 557261 558026 558498 558825 558826 559033 559099 559503 559820 560008 560488 560558 560610 560611 560613 561841 564091 564632 566222 566224 566345 567082 568404 570324 570505 570673 571474 571857 572128 572806 573026 573077 573098 573294 573417 573550 573663 573772 573788 573834 573959 574497 574595 574601 574812 574849 574877 574904 574920 575059 575078 575080 575089 575100 575137 575154 575468 575498 575503 575510 575524 575749 575755 575770 576045 576060 576077 576279 576293 576366 576387 576410 577130 578129 578384 578393 580648 580675 581668 583671 588878 590787 595477 595512 596350 597593 601313 603674 607101 626063 630736 664433 683955 685889 736101 737728 ] |
||||||||||||||||||||||||||||||
|
2.02 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"small and big"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"маленькая большие"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.48 ms (0.80%) |
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.