Query Metrics
7
Database Queries
7
Different statements
185.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
158.30 ms (85.20%) |
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 70636 400884 413123 453152 471025 475682 483995 485016 485673 486475 489119 490437 490592 490594 496845 502544 504028 531595 532414 541017 541116 543317 544877 545743 546146 547573 549031 554170 555486 558674 559313 559334 563685 567629 574143 576597 576791 577270 578171 578510 583403 597663 599238 612169 614222 614802 616381 616569 617568 619620 621382 623071 625209 626176 631457 631459 634934 640361 641571 644218 650531 652163 660383 661534 662424 666067 666078 666094 666122 666680 666713 666722 670263 684183 687103 697219 698916 700804 705349 706895 708578 708706 708743 709611 710229 710439 710856 712140 713973 714418 721938 722167 722681 734661 739895 742280 745294 762186 771424 778481 781771 790201 793565 794577 795344 796490 796704 802219 802303 802307 803136 804257 804738 807193 808125 809555 811443 812032 825250 ] |
||||||||||||||||||||||||||||||
|
15.45 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 807193 485673 490437 496845 577270 713973 722167 794577 795344 802303 796704 808125 809555 762186 739895 745294 721938 790201 812032 413123 453152 475682 490592 70636 825250 471025 559334 541116 708578 652163 661534 666067 666094 709611 708706 641571 700804 543317 490594 400884 502544 531595 541017 574143 583403 545743 547573 567629 666122 666680 687103 698916 666722 705349 710229 650531 666078 670263 706895 710856 712140 555486 597663 614222 614802 625209 626176 631457 640361 616381 619620 621382 616512 616569 631459 617568 634934 697219 710439 504028 489119 684183 714418 486475 742280 483995 532414 485016 546146 558674 576791 578171 549031 578510 544877 559313 563685 662424 708743 660383 666713 722681 554170 576597 623071 644218 599238 612169 778481 793565 811443 802307 803136 804257 804738 734661 771424 781771 796490 802219 ] |
||||||||||||||||||||||||||||||
|
3.96 ms (2.13%) |
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 70636 400884 413123 453152 471025 475682 483995 485016 485673 486475 489119 490437 490592 490594 496845 502544 504028 531595 532414 541017 541116 543317 544877 545743 546146 547573 549031 554170 555486 558674 559313 559334 563685 567629 574143 576597 576791 577270 578171 578510 583403 597663 599238 612169 614222 614802 616381 616569 617568 619620 621382 623071 625209 626176 631457 631459 634934 640361 641571 644218 650531 652163 660383 661534 662424 666067 666078 666094 666122 666680 666713 666722 670263 684183 687103 697219 698916 700804 705349 706895 708578 708706 708743 709611 710229 710439 710856 712140 713973 714418 721938 722167 722681 734661 739895 742280 745294 762186 771424 778481 781771 790201 793565 794577 795344 796490 796704 802219 802303 802307 803136 804257 804738 807193 808125 809555 811443 812032 825250 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur hairy"
]
|
||||||||||||||||||||||||||||||
|
2.20 ms (1.18%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.76 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.73 ms (0.93%) |
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.