Query Metrics
7
Database Queries
7
Different statements
161.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.06 ms (88.06%) |
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 118885 382665 472498 493363 495733 496713 500825 530980 531655 532696 533572 533785 534975 535003 540174 541533 543704 545242 550992 553753 554698 559965 559970 563971 566589 570868 574077 578642 580129 590332 599211 601343 609844 612961 621255 626751 635823 645388 651008 652984 656318 658901 661619 679281 687280 688173 689252 692691 694608 697552 697878 699963 702377 707373 708521 708543 712234 712615 744231 748495 748519 749025 751331 751380 754360 754614 754715 754938 759123 764717 764741 764782 765808 767242 771133 774730 776844 778183 780412 780543 780545 782874 784509 790109 790683 790808 792401 798409 800096 800139 800143 801049 803529 803883 804153 804236 805142 805699 811828 812365 812663 813704 813729 813769 814185 817871 819811 820169 820847 821367 821547 821752 822313 823437 823989 823991 827440 828472 828587 ] |
||||||||||||||||||||||||||||||
|
10.25 ms (6.35%) |
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 563971 804153 776844 645388 780545 800143 817871 823989 533572 495733 535003 697878 590332 780543 744231 751380 754360 754614 754938 749025 679281 626751 580129 782874 652984 702377 599211 774730 805699 697552 566589 687280 828472 764741 820847 813769 819811 821752 496713 532696 554698 553753 574077 651008 712234 559970 609844 801049 759123 790808 748519 798409 578642 658901 543704 708543 792401 814185 500825 493363 533785 531655 559965 708521 621255 800096 764782 821547 822313 823492 823991 828587 472498 550992 541533 545242 601343 780412 790109 754715 771133 751331 764717 570868 661619 688173 811828 382665 812663 765808 805142 692691 812365 118885 540174 820169 827440 813729 821367 823437 813704 530980 534975 699963 707373 712615 694608 656318 689252 635823 612961 784509 778183 800139 803529 804236 767242 790683 803883 748495 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.49%) |
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 118885 382665 472498 493363 495733 496713 500825 530980 531655 532696 533572 533785 534975 535003 540174 541533 543704 545242 550992 553753 554698 559965 559970 563971 566589 570868 574077 578642 580129 590332 599211 601343 609844 612961 621255 626751 635823 645388 651008 652984 656318 658901 661619 679281 687280 688173 689252 692691 694608 697552 697878 699963 702377 707373 708521 708543 712234 712615 744231 748495 748519 749025 751331 751380 754360 754614 754715 754938 759123 764717 764741 764782 765808 767242 771133 774730 776844 778183 780412 780543 780545 782874 784509 790109 790683 790808 792401 798409 800096 800139 800143 801049 803529 803883 804153 804236 805142 805699 811828 812365 812663 813704 813729 813769 814185 817871 819811 820169 820847 821367 821547 821752 822313 823437 823989 823991 827440 828472 828587 ] |
||||||||||||||||||||||||||||||
|
1.87 ms (1.16%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"девушк мастурбац туалет"
]
|
||||||||||||||||||||||||||||||
|
1.71 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"girl masturbation toilet"
]
|
||||||||||||||||||||||||||||||
|
1.53 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк мастурбац туалет"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.93%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
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.