Query Metrics
7
Database Queries
7
Different statements
159.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
137.95 ms (86.37%) |
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 69956 382955 384415 388423 388883 389122 401641 402034 407282 410073 420782 429512 433033 458766 460104 467796 467798 478295 478406 480829 489894 506883 508166 517491 519160 538930 539243 539483 551645 552255 558998 563706 568728 579375 583176 583471 585047 593776 595117 595314 602675 606143 608357 609676 615386 617592 619521 621109 626327 629653 636501 636508 639116 648599 648630 660692 661637 662089 662921 666080 674263 678992 687717 688190 688969 693789 697327 697462 700305 707175 707629 709452 715563 718875 721749 722687 723965 724437 727087 731111 731825 736151 737121 739699 740508 740577 742414 747249 747571 755165 756251 757455 758154 759666 759747 761167 761705 768078 768722 769346 771332 773620 778288 784261 785625 788854 793836 794530 794539 794585 799164 800186 801322 802815 803417 810572 813718 816708 824067 825487 ] |
||||||||||||||||||||||||||||||
|
12.25 ms (7.67%) |
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 568728 579375 648599 697327 707629 648630 707175 615386 595314 617592 595117 778288 731825 759666 724437 759747 768722 773620 740508 747571 740577 768078 769346 788854 799164 388883 467796 69956 407282 402034 384415 410073 813718 824067 478295 480829 489894 460104 517491 539483 539243 506883 519160 558998 583176 583471 552255 709452 715563 666080 721749 674263 678992 722687 551645 593776 608357 626327 619521 606143 609676 800186 802815 784261 794530 810572 727087 742414 757455 761167 761705 731111 756251 771332 747249 736151 739699 755165 758154 700305 801322 382955 389122 388423 478406 467798 433033 458766 508166 401641 429512 420782 585047 816708 825487 538930 563706 662089 687717 693789 718875 660692 661637 688969 697462 662921 688190 621109 629653 636501 639116 602675 636508 794585 803417 785625 737121 793836 794539 723965 ] |
||||||||||||||||||||||||||||||
|
3.04 ms (1.90%) |
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 69956 382955 384415 388423 388883 389122 401641 402034 407282 410073 420782 429512 433033 458766 460104 467796 467798 478295 478406 480829 489894 506883 508166 517491 519160 538930 539243 539483 551645 552255 558998 563706 568728 579375 583176 583471 585047 593776 595117 595314 602675 606143 608357 609676 615386 617592 619521 621109 626327 629653 636501 636508 639116 648599 648630 660692 661637 662089 662921 666080 674263 678992 687717 688190 688969 693789 697327 697462 700305 707175 707629 709452 715563 718875 721749 722687 723965 724437 727087 731111 731825 736151 737121 739699 740508 740577 742414 747249 747571 755165 756251 757455 758154 759666 759747 761167 761705 768078 768722 769346 771332 773620 778288 784261 785625 788854 793836 794530 794539 794585 799164 800186 801322 802815 803417 810572 813718 816708 824067 825487 ] |
||||||||||||||||||||||||||||||
|
1.96 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"tits cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.00%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сиськ cumshot"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (1.00%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сиськ cumshot"
]
|
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.