Query Metrics
7
Database Queries
7
Different statements
377.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
212.82 ms (56.31%) |
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 391597 400512 401004 411897 412157 417071 426407 437949 439437 443682 443690 443713 444142 444216 448662 448714 448915 448918 452905 453214 454073 454136 454205 461950 462156 462658 463247 464539 464547 465822 466079 466478 467814 469450 469896 470271 470916 470934 473932 474181 474323 476636 476675 476837 483844 483852 484781 485425 485986 486375 488273 490499 491967 494796 496019 499307 504325 509966 513691 542259 545662 546893 550234 560341 563125 563454 566672 569993 571352 571419 573912 580684 593384 619899 631393 667971 683256 714609 728900 740442 741480 742387 742402 755900 761254 764101 769188 774146 777897 778575 779386 781489 783609 788004 794704 799673 799918 803729 805666 808313 814973 814990 816120 817989 818075 819273 819277 819358 819777 819933 824213 824260 824312 825907 826196 826584 826643 826687 827031 827582 ] |
||||||||||||||||||||||||||||||
|
143.57 ms (37.99%) |
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 391597 400512 401004 411897 412157 417071 426407 437949 439437 443682 443690 443713 444142 444216 448662 448714 448915 448918 452905 453214 454073 454136 454205 461950 462156 462658 463247 464539 464547 465822 466079 466478 467814 469450 469896 470271 470916 470934 473932 474181 474323 476636 476675 476837 483844 483852 484781 485425 485986 486375 488273 490499 491967 494796 496019 499307 504325 509966 513691 542259 545662 546893 550234 560341 563125 563454 566672 569993 571352 571419 573912 580684 593384 619899 631393 667971 683256 714609 728900 740442 741480 742387 742402 755900 761254 764101 769188 774146 777897 778575 779386 781489 783609 788004 794704 799673 799918 803729 805666 808313 814973 814990 816120 817989 818075 819273 819277 819358 819777 819933 824213 824260 824312 825907 826196 826584 826643 826687 827031 827582 ] |
||||||||||||||||||||||||||||||
|
14.90 ms (3.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 781489 805666 443713 563125 401004 499307 391597 825907 814973 819777 814990 462156 488273 714609 580684 631393 778575 788004 764101 742402 742387 448662 444216 469896 417071 563454 779386 783609 504325 816120 824213 817989 824312 571352 573912 803729 777897 794704 799918 755900 799673 728900 741480 412157 819277 826643 818075 819273 542259 545662 566672 619899 808313 769188 774146 740442 761254 473932 467814 560341 569993 683256 550234 411897 439437 464539 465822 469450 470271 470934 437949 448714 448915 454073 464547 444142 448918 474181 476675 454205 470916 453214 466079 483844 483852 486375 484781 490499 494796 667971 476837 496019 426407 452905 466478 474323 462658 509966 485425 571419 454136 476636 546893 463247 400512 443682 491967 443690 461950 485986 513691 593384 826196 826584 826687 819933 824260 827031 827582 819358 ] |
||||||||||||||||||||||||||||||
|
2.17 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"russian saggy tits"
]
|
||||||||||||||||||||||||||||||
|
1.59 ms (0.42%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"русск saggy сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.39%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.40 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"русск saggy сиськ"
]
|
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.