Query Metrics
7
Database Queries
7
Different statements
254.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
228.56 ms (89.67%) |
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 540139 540150 542285 542445 545418 551037 556040 556337 559020 559924 562053 569379 571248 574000 580129 580382 581033 584267 585812 589337 593734 596244 597763 598048 604715 605512 606322 612430 614382 615053 615634 623339 626332 626841 629680 630254 630536 636463 637511 639741 639751 640156 640859 642774 644655 645700 647860 649306 650075 650608 650634 650919 651922 662480 671070 672760 678492 690524 701194 710265 712712 714577 721737 724039 726330 728605 732589 732805 733887 734342 734364 736534 736944 737605 741692 743684 744418 745264 745981 747384 748138 748154 757246 758292 761479 762210 768157 784127 784501 786458 788127 793671 794240 795416 795812 795979 796577 796919 797240 797250 799636 799934 800506 800698 801326 802315 803960 804199 805836 808659 810390 811010 811270 811862 811882 811889 814333 817709 817879 819488 ] |
||||||||||||||||||||||||||||||
|
15.27 ms (5.99%) |
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 795416 800506 626332 797250 757246 799636 726330 545418 647860 642774 630536 819488 581033 671070 612430 597763 630254 788127 797240 799934 732589 745981 589337 640859 817709 817879 569379 650634 605512 606322 604715 629680 736534 724039 758292 637511 559924 796577 710265 672760 803960 761479 732805 784501 801326 542445 556337 662480 574000 640156 598048 644655 795979 786458 810390 802315 733887 747384 542285 645700 650075 714577 593734 615053 794240 728605 736944 748138 734364 741692 614382 800698 811010 814333 559020 571248 712712 649306 596244 626841 796919 811270 793671 734342 808659 748154 768157 795812 540150 580382 556040 562053 584267 650608 678492 651922 690524 721737 615634 585812 804199 811882 805836 737605 744418 745264 762210 743684 701194 811862 811889 639741 639751 540139 551037 650919 580129 636463 623339 784127 ] |
||||||||||||||||||||||||||||||
|
3.36 ms (1.32%) |
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 540139 540150 542285 542445 545418 551037 556040 556337 559020 559924 562053 569379 571248 574000 580129 580382 581033 584267 585812 589337 593734 596244 597763 598048 604715 605512 606322 612430 614382 615053 615634 623339 626332 626841 629680 630254 630536 636463 637511 639741 639751 640156 640859 642774 644655 645700 647860 649306 650075 650608 650634 650919 651922 662480 671070 672760 678492 690524 701194 710265 712712 714577 721737 724039 726330 728605 732589 732805 733887 734342 734364 736534 736944 737605 741692 743684 744418 745264 745981 747384 748138 748154 757246 758292 761479 762210 768157 784127 784501 786458 788127 793671 794240 795416 795812 795979 796577 796919 797240 797250 799636 799934 800506 800698 801326 802315 803960 804199 805836 808659 810390 811010 811270 811862 811882 811889 814333 817709 817879 819488 ] |
||||||||||||||||||||||||||||||
|
2.19 ms (0.86%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг сиськ"
]
|
||||||||||||||||||||||||||||||
|
2.09 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss on tits"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"писсинг сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.67 ms (0.66%) |
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.