Query Metrics
7
Database Queries
7
Different statements
400.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
205.70 ms (51.30%) |
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 113794 182110 391473 452995 483743 499924 535322 535775 539557 539701 540808 545042 550965 553749 554991 575336 576772 578786 584355 584961 588320 589333 591669 591924 595166 601872 603343 604261 605710 619684 624751 636651 638829 641386 647111 659002 660384 669319 669851 669890 669897 669923 672734 680754 699313 702864 708226 713323 716101 723294 726634 734826 735197 738484 738499 738514 739937 739967 742293 742297 742327 742329 749129 749577 752658 752920 753612 753666 759474 761164 762171 765612 765617 765672 766381 769122 774880 776741 777775 777843 783044 783248 784205 785549 787519 788128 790689 791955 794403 795655 795721 796672 796712 797040 799197 799201 800551 800656 800676 800682 800807 800825 801791 802225 802555 802571 802999 804767 804932 805290 805584 807567 809640 810149 810762 810797 811069 818944 819231 827505 ] |
||||||||||||||||||||||||||||||
|
173.75 ms (43.33%) |
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 113794 182110 391473 452995 483743 499924 535322 535775 539557 539701 540808 545042 550965 553749 554991 575336 576772 578786 584355 584961 588320 589333 591669 591924 595166 601872 603343 604261 605710 619684 624751 636651 638829 641386 647111 659002 660384 669319 669851 669890 669897 669923 672734 680754 699313 702864 708226 713323 716101 723294 726634 734826 735197 738484 738499 738514 739937 739967 742293 742297 742327 742329 749129 749577 752658 752920 753612 753666 759474 761164 762171 765612 765617 765672 766381 769122 774880 776741 777775 777843 783044 783248 784205 785549 787519 788128 790689 791955 794403 795655 795721 796672 796712 797040 799197 799201 800551 800656 800676 800682 800807 800825 801791 802225 802555 802571 802999 804767 804932 805290 805584 807567 809640 810149 810762 810797 811069 818944 819231 827505 ] |
||||||||||||||||||||||||||||||
|
14.35 ms (3.58%) |
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 647111 669890 672734 702864 669897 619684 595166 591924 603343 641386 589333 601872 776741 795655 797040 800676 802999 802571 804767 742293 769122 805290 805584 809640 810149 810797 811069 734826 765672 753612 753666 739967 752658 765617 795721 800682 800825 802555 783248 680754 545042 638829 796672 499924 182110 827505 819231 452995 539701 535322 483743 575336 550965 554991 660384 713323 659002 669319 669851 584961 605710 636651 604261 791955 807567 810762 777843 787519 799197 801791 788128 738514 749577 735197 738499 739937 742329 759474 726634 761164 762171 699313 774880 777775 785549 794403 796712 113794 624751 539557 669923 708226 391473 790689 540808 818944 535775 553749 584355 576772 723294 716101 578786 588320 591669 783044 799201 802225 804932 784205 800551 800807 742327 749129 752920 800656 765612 766381 738484 742297 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.48%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"milf dildo solo"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.48%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"milf дилд соло"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"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.