Query Metrics
7
Database Queries
7
Different statements
199.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
173.01 ms (86.80%) |
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 317866 388825 391115 391812 396863 434688 445211 449361 450289 452845 454390 468379 473757 476168 477221 480004 482437 484233 486808 488550 496621 498247 500040 507422 509202 511004 521831 525042 528094 532126 532599 542139 542700 545810 547042 553619 559495 560537 562536 575334 582656 585318 588118 590887 591777 595314 595943 601166 605505 617329 622878 625465 636574 637161 640411 643683 645207 651548 655529 659435 659931 663818 663834 675930 677245 678696 679653 682364 693680 697608 711580 721129 721479 725709 726841 728203 742074 742560 743559 750448 750833 751438 753550 756840 758731 758754 761754 764234 766737 767280 769291 769494 769533 774883 778124 778298 778434 780938 783194 784072 784477 784753 785422 790045 795843 797796 799567 801115 801481 803904 805310 806892 807631 809397 812857 813219 813749 814483 816617 825457 ] |
||||||||||||||||||||||||||||||
|
14.81 ms (7.43%) |
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 663818 655529 764234 521831 590887 396863 434688 825457 452845 511004 532126 528094 532599 542139 559495 575334 582656 560537 677245 645207 675930 721479 553619 588118 803904 778124 778298 784477 742074 750448 751438 761754 767280 784753 797796 753550 766737 728203 758731 769494 769533 750833 726841 743559 778434 812857 813219 496621 488550 721129 756840 477221 480004 445211 450289 484233 636574 317866 678696 388825 622878 643683 769291 500040 637161 813749 814483 816617 482437 454390 473757 486808 507422 547042 711580 562536 640411 774883 784072 799567 805310 807631 785422 806892 809397 725709 783194 795843 801115 742560 758754 780938 790045 801481 391812 509202 391115 542700 545810 651548 659931 682364 697608 663834 659435 693680 591777 595314 617329 585318 601166 605505 595943 625465 498247 476168 449361 525042 468379 679653 ] |
||||||||||||||||||||||||||||||
|
4.19 ms (2.10%) |
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 317866 388825 391115 391812 396863 434688 445211 449361 450289 452845 454390 468379 473757 476168 477221 480004 482437 484233 486808 488550 496621 498247 500040 507422 509202 511004 521831 525042 528094 532126 532599 542139 542700 545810 547042 553619 559495 560537 562536 575334 582656 585318 588118 590887 591777 595314 595943 601166 605505 617329 622878 625465 636574 637161 640411 643683 645207 651548 655529 659435 659931 663818 663834 675930 677245 678696 679653 682364 693680 697608 711580 721129 721479 725709 726841 728203 742074 742560 743559 750448 750833 751438 753550 756840 758731 758754 761754 764234 766737 767280 769291 769494 769533 774883 778124 778298 778434 780938 783194 784072 784477 784753 785422 790045 795843 797796 799567 801115 801481 803904 805310 806892 807631 809397 812857 813219 813749 814483 816617 825457 ] |
||||||||||||||||||||||||||||||
|
2.10 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette riding homemade"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.95%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.91%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая riding домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.51 ms (0.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"черноволосая riding домашн любительск"
]
|
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.