Query Metrics
7
Database Queries
7
Different statements
352.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
332.64 ms (94.29%) |
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 193462 398683 403027 407165 420829 427053 438682 441118 448497 449181 458277 460245 472571 481119 488900 488908 496004 497013 497629 529691 537166 537171 540590 574020 609081 636477 692733 697217 701235 704943 710189 712146 713153 714563 714794 718017 722125 728464 728556 730526 730835 732984 733425 734439 736326 740573 741319 741683 741853 742133 742657 743860 744154 751004 751345 754978 756975 757237 761728 767519 767547 768049 768719 768876 769495 771903 772606 773054 773291 773351 775590 775624 775647 780028 780323 783707 790447 792940 794756 794908 795070 795370 795825 795889 796589 798769 801018 801614 801842 804405 804411 804699 809715 810174 810311 810324 810372 810381 812140 812147 813359 813991 816152 818722 819891 820011 820020 823580 823719 824554 824642 826832 827011 827048 827394 827439 827494 827578 827627 827711 ] |
||||||||||||||||||||||||||||||
|
10.37 ms (2.94%) |
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 773351 728464 730526 730835 734439 736326 740573 741853 744154 751345 754978 761728 767519 768049 768719 728556 733425 741319 741683 742133 743860 756975 767547 769495 771903 773054 773291 701235 712146 713153 714794 718017 722125 775590 775624 775647 780028 780323 783707 790447 792940 794756 794908 795070 795370 796589 798769 801614 801842 804699 809715 810174 810311 810372 810381 812140 813359 403027 398683 697217 801018 193462 827578 827711 537166 574020 714563 609081 772606 810324 751004 420829 449181 804411 757237 812147 732984 742657 768876 704943 710189 804405 427053 496004 692733 795825 636477 795889 407165 438682 441118 818722 813991 820011 824554 826832 827011 827439 827627 827394 827494 816152 819891 820020 823719 823580 824642 827048 472571 458277 460245 481119 488900 448497 488908 497013 497629 529691 537171 540590 ] |
||||||||||||||||||||||||||||||
|
2.88 ms (0.82%) |
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 193462 398683 403027 407165 420829 427053 438682 441118 448497 449181 458277 460245 472571 481119 488900 488908 496004 497013 497629 529691 537166 537171 540590 574020 609081 636477 692733 697217 701235 704943 710189 712146 713153 714563 714794 718017 722125 728464 728556 730526 730835 732984 733425 734439 736326 740573 741319 741683 741853 742133 742657 743860 744154 751004 751345 754978 756975 757237 761728 767519 767547 768049 768719 768876 769495 771903 772606 773054 773291 773351 775590 775624 775647 780028 780323 783707 790447 792940 794756 794908 795070 795370 795825 795889 796589 798769 801018 801614 801842 804405 804411 804699 809715 810174 810311 810324 810372 810381 812140 812147 813359 813991 816152 818722 819891 820011 820020 823580 823719 824554 824642 826832 827011 827048 827394 827439 827494 827578 827627 827711 ] |
||||||||||||||||||||||||||||||
|
2.01 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"orgasm wife"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"orgasm жен"
]
|
||||||||||||||||||||||||||||||
|
1.56 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"orgasm жен"
]
|
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.