Query Metrics
7
Database Queries
7
Different statements
365.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
208.86 ms (57.19%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf big boobs"
]
|
||||||||||||||||||||||||||||||
|
133.79 ms (36.63%) |
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 183956 188613 191474 386740 390278 391074 401388 410993 420208 470433 487587 512444 531314 531924 537135 541905 548327 555021 555573 558073 558724 563731 569182 569725 573179 579998 587990 588942 589646 590261 591111 591112 591121 604872 605362 605640 608432 618010 624403 628594 629256 629852 634633 642379 644217 644793 649634 651520 652148 658919 660069 669220 677557 684106 688016 693683 695415 708125 709303 710192 710339 712197 712333 713612 714165 715267 717355 718329 718950 719896 721141 723400 723981 725464 732725 735391 735532 736015 738276 739200 740458 745200 745976 759682 759709 760898 769985 770570 771224 771358 772678 776655 780559 781842 781909 785118 789517 794188 794758 794875 796965 797016 798638 798859 803804 807850 813770 814538 815497 816066 816302 816394 817851 818161 819583 823849 823957 824632 825924 826860 ] |
||||||||||||||||||||||||||||||
|
14.20 ms (3.89%) |
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 531924 548327 558724 714165 652148 712197 723400 555573 558073 644217 644793 604872 789517 769985 745976 781909 794188 386740 183956 188613 191474 390278 391074 401388 420208 410993 813770 817851 824632 825924 814538 818161 819583 815497 816066 816394 823849 816302 823957 826860 487587 470433 512444 537135 531314 563731 541905 573179 669220 677557 709303 713612 717355 684106 695415 710192 718329 718950 649634 651520 658919 660069 688016 693683 708125 712333 715267 555021 569182 569725 579998 590261 629256 588942 591111 634633 589646 591121 608432 624403 629852 642379 587990 591112 605362 605640 780559 794875 798859 776655 796965 798638 803804 723981 736015 739200 781842 794758 797016 807850 735391 740458 759709 771224 735532 745200 759682 760898 771358 732725 738276 725464 770570 772678 618010 628594 710339 719896 721141 785118 ] |
||||||||||||||||||||||||||||||
|
3.26 ms (0.89%) |
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 183956 188613 191474 386740 390278 391074 401388 410993 420208 470433 487587 512444 531314 531924 537135 541905 548327 555021 555573 558073 558724 563731 569182 569725 573179 579998 587990 588942 589646 590261 591111 591112 591121 604872 605362 605640 608432 618010 624403 628594 629256 629852 634633 642379 644217 644793 649634 651520 652148 658919 660069 669220 677557 684106 688016 693683 695415 708125 709303 710192 710339 712197 712333 713612 714165 715267 717355 718329 718950 719896 721141 723400 723981 725464 732725 735391 735532 736015 738276 739200 740458 745200 745976 759682 759709 760898 769985 770570 771224 771358 772678 776655 780559 781842 781909 785118 789517 794188 794758 794875 796965 797016 798638 798859 803804 807850 813770 814538 815497 816066 816302 816394 817851 818161 819583 823849 823957 824632 825924 826860 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.49%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf большие boobs"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.48%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.52 ms (0.42%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"milf большие boobs"
]
|
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.