Query Metrics
7
Database Queries
7
Different statements
879.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
416.75 ms (47.37%) |
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 386662 387515 389788 392525 398388 402439 415875 467910 480038 488298 493493 499083 509976 537662 541073 549069 555086 590297 591995 592161 595447 602400 608545 612905 619476 620258 625937 625980 629172 633813 641792 647119 650167 654918 659055 660403 661606 668091 669403 673670 681523 684669 692723 705291 707928 708867 710909 712574 712582 712591 715453 715800 717921 719942 719960 722329 722474 722597 725113 726179 728372 728675 730383 730744 731198 734964 736321 736921 738718 742742 743961 744645 747500 748748 748795 749336 749794 750100 750273 750280 752184 753472 755030 756095 757043 757052 757180 757403 757535 758087 758216 760894 761605 761718 761767 761784 762104 762411 763418 764867 767808 768867 769754 769767 769774 769804 769811 769841 769917 770866 778115 786199 787063 796081 801543 806332 811074 813005 825378 825961 ] |
||||||||||||||||||||||||||||||
|
232.86 ms (26.47%) |
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 386662 387515 389788 392525 398388 402439 415875 467910 480038 488298 493493 499083 509976 537662 541073 549069 555086 590297 591995 592161 595447 602400 608545 612905 619476 620258 625937 625980 629172 633813 641792 647119 650167 654918 659055 660403 661606 668091 669403 673670 681523 684669 692723 705291 707928 708867 710909 712574 712582 712591 715453 715800 717921 719942 719960 722329 722474 722597 725113 726179 728372 728675 730383 730744 731198 734964 736321 736921 738718 742742 743961 744645 747500 748748 748795 749336 749794 750100 750273 750280 752184 753472 755030 756095 757043 757052 757180 757403 757535 758087 758216 760894 761605 761718 761767 761784 762104 762411 763418 764867 767808 768867 769754 769767 769774 769804 769811 769841 769917 770866 778115 786199 787063 796081 801543 806332 811074 813005 825378 825961 ] |
||||||||||||||||||||||||||||||
|
211.40 ms (24.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"anal cock anal"
]
|
||||||||||||||||||||||||||||||
|
13.54 ms (1.54%) |
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 753472 757043 760894 762104 762411 764867 728675 744645 748795 752184 757403 758087 761767 763418 767808 731198 736921 738718 747500 749336 749794 750273 761718 768867 769767 769917 602400 629172 705291 708867 710909 719942 722329 796081 801543 806332 386662 387515 537662 467910 493493 541073 591995 633813 758216 755030 719960 659055 661606 625980 770866 787063 480038 650167 654918 712574 712582 722597 692723 647119 668091 684669 707928 715800 722474 608545 641792 590297 592161 612905 778115 813005 786199 736321 743961 757052 761784 769841 728372 734964 757180 769811 730383 730744 769754 769804 742742 757535 761605 750100 750280 769774 625937 402439 392525 825961 825378 509976 389788 398388 415875 499083 488298 549069 669403 712591 660403 673670 681523 715453 717921 555086 595447 620258 619476 811074 725113 756095 726179 748748 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (0.23%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"анал cock анал"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.43 ms (0.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"анал cock анал"
]
|
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.