Query Metrics
7
Database Queries
7
Different statements
271.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
247.59 ms (91.31%) |
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 7178 157194 233135 304572 398800 398811 401014 401114 401666 402375 405188 407970 413183 414643 426378 435700 445740 457943 461402 468581 468884 473921 482519 504211 510132 511869 513114 513817 516012 517074 522614 524755 526828 530788 531137 534641 535611 536230 536335 536554 544747 554752 563864 564731 568560 573320 586456 590302 591353 593605 601553 604313 608569 612816 613122 619652 621315 625523 637755 640771 656206 664087 670753 671758 681686 683003 683826 687211 694479 698554 699590 704928 715807 718701 718746 718784 723643 725581 725974 735774 740617 741291 741607 744654 747310 750545 751510 751611 756426 756499 759982 767175 770402 775848 777544 778774 784569 785847 786195 793951 795538 798929 800288 801261 801267 805222 805431 805706 805735 806686 808401 809131 812715 814178 815053 815480 815508 816545 823593 824500 ] |
||||||||||||||||||||||||||||||
|
13.09 ms (4.83%) |
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 715807 401114 656206 784569 770402 815053 699590 808401 785847 805735 759982 814178 457943 524755 535611 536554 511869 516012 531137 513817 461402 563864 564731 573320 544747 568560 683003 718784 683826 704928 718701 554752 608569 612816 613122 604313 586456 601553 795538 805222 805431 800288 806686 751611 741607 767175 747310 725581 741291 744654 751510 777544 468581 7178 398800 401666 413183 402375 473921 233135 401014 414643 522614 510132 513114 698554 687211 805706 398811 815480 816545 823593 824500 671758 718746 670753 694479 786195 801261 756426 750545 725974 637755 778774 812715 304572 591353 798929 482519 536335 530788 681686 640771 435700 405188 445740 526828 504211 534641 809131 775848 157194 407970 426378 468884 517074 815508 723643 536230 664087 619652 621315 801267 756499 793951 590302 593605 740617 735774 625523 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.02%) |
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 7178 157194 233135 304572 398800 398811 401014 401114 401666 402375 405188 407970 413183 414643 426378 435700 445740 457943 461402 468581 468884 473921 482519 504211 510132 511869 513114 513817 516012 517074 522614 524755 526828 530788 531137 534641 535611 536230 536335 536554 544747 554752 563864 564731 568560 573320 586456 590302 591353 593605 601553 604313 608569 612816 613122 619652 621315 625523 637755 640771 656206 664087 670753 671758 681686 683003 683826 687211 694479 698554 699590 704928 715807 718701 718746 718784 723643 725581 725974 735774 740617 741291 741607 744654 747310 750545 751510 751611 756426 756499 759982 767175 770402 775848 777544 778774 784569 785847 786195 793951 795538 798929 800288 801261 801267 805222 805431 805706 805735 806686 808401 809131 812715 814178 815053 815480 815508 816545 823593 824500 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.76%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"beauty milf анал"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.72%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"beauty milf anal"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.70%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.67%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"beauty milf анал"
]
|
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.