Query Metrics
7
Database Queries
7
Different statements
183.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
161.70 ms (88.03%) |
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 365954 388760 390233 395908 453682 470777 477976 479086 485921 543640 563454 566672 603679 610473 613989 621446 623385 628672 630395 650162 656084 656453 657352 658431 658481 659938 661270 666807 670987 671000 673256 678972 686481 695417 698158 714647 719063 721502 721570 722195 722886 725327 725498 728974 729255 731122 731218 733553 736010 736816 736999 738300 738338 738346 738355 738356 739592 739913 740530 741027 741211 741257 741710 741736 741755 741765 741768 741905 742070 742386 743181 743496 744396 744400 744435 744885 745321 746132 746639 746655 751480 751497 751501 753602 754236 754255 754481 754658 755830 757382 758291 762672 768049 774121 774642 777755 780796 781706 781747 782146 782762 783357 786746 787021 788419 788823 788836 791204 799713 800741 800757 801110 801113 801678 803440 803447 805315 805623 807017 807018 ] |
||||||||||||||||||||||||||||||
|
12.03 ms (6.55%) |
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 721570 657352 658431 658481 670987 678972 686481 719063 721502 650162 656084 656453 659938 661270 666807 673256 695417 698158 714647 722195 566672 610473 603679 613989 628672 621446 630395 782762 788836 791204 800741 801113 803447 805315 781747 782146 786746 801678 807017 741211 741736 744885 751480 754236 755830 783357 788823 799713 803440 725327 733553 736816 741755 744396 744435 745321 751501 753602 754658 758291 728974 736010 738300 738346 738355 739913 741765 743496 744400 746132 754255 725498 729255 739592 741027 741257 741768 741905 742070 743181 746639 746655 754481 757382 768049 731122 731218 736999 738338 738356 740530 751497 774121 722886 777755 787021 788419 800757 801110 805623 807018 390233 395908 671000 477976 485921 543640 563454 780796 781706 741710 742386 762672 623385 774642 388760 470777 479086 365954 453682 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.71%) |
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 365954 388760 390233 395908 453682 470777 477976 479086 485921 543640 563454 566672 603679 610473 613989 621446 623385 628672 630395 650162 656084 656453 657352 658431 658481 659938 661270 666807 670987 671000 673256 678972 686481 695417 698158 714647 719063 721502 721570 722195 722886 725327 725498 728974 729255 731122 731218 733553 736010 736816 736999 738300 738338 738346 738355 738356 739592 739913 740530 741027 741211 741257 741710 741736 741755 741765 741768 741905 742070 742386 743181 743496 744396 744400 744435 744885 745321 746132 746639 746655 751480 751497 751501 753602 754236 754255 754481 754658 755830 757382 758291 762672 768049 774121 774642 777755 780796 781706 781747 782146 782762 783357 786746 787021 788419 788823 788836 791204 799713 800741 800757 801110 801113 801678 803440 803447 805315 805623 807017 807018 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"short hair russian"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"short hair русск"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.89%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.31 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"short hair русск"
]
|
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.