Query Metrics
7
Database Queries
7
Different statements
316.81 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
292.29 ms (92.26%) |
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 542285 542423 542549 545389 545418 554843 559924 569379 575358 576453 581033 589337 593734 597763 599833 600297 601578 604715 605512 606322 607217 608679 610199 612430 614382 615053 618870 626332 629680 630254 630552 632579 632706 632750 637511 639060 639719 639796 640156 641953 642006 642226 642774 645700 646176 647860 650075 650634 666894 671070 671773 672401 672764 678095 680176 685511 690942 704896 710026 714577 715888 719649 719829 721949 724039 726330 727969 728605 729187 732589 732869 734350 734364 736396 736534 736944 737883 738326 738694 741692 744765 745981 747069 747384 748138 751453 752840 753656 753707 757237 757246 758145 758292 768059 775815 788127 789111 793438 793723 794240 796577 797240 799934 800698 800763 800920 807881 809358 809925 811010 814302 817709 817864 817879 818291 819488 820347 824196 827279 827591 ] |
||||||||||||||||||||||||||||||
|
13.99 ms (4.42%) |
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 542549 646176 639796 600297 610199 738326 814302 672764 710026 757237 768059 775815 576453 632750 793438 807881 736396 800763 809925 737883 789111 732869 599833 820347 817864 729187 753707 678095 666894 827279 575358 607217 744765 647860 680176 601578 632706 752840 747069 819488 612430 732589 745981 824196 827591 719649 719829 685511 690942 554843 753656 751453 738694 758145 608679 545389 641953 639719 630552 639060 642006 589337 818291 704896 618870 734350 715888 559924 642774 581033 671070 597763 630254 788127 797240 799934 736534 793723 727969 800920 721949 626332 757246 726330 640156 605512 604715 637511 632579 796577 714577 593734 736944 748138 614382 671773 672401 642226 809358 817709 817879 569379 650634 606322 629680 724039 758292 542285 645700 650075 615053 794240 728605 734364 741692 800698 811010 545418 542423 747384 ] |
||||||||||||||||||||||||||||||
|
2.55 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"piss big tits"
]
|
||||||||||||||||||||||||||||||
|
2.44 ms (0.77%) |
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 542285 542423 542549 545389 545418 554843 559924 569379 575358 576453 581033 589337 593734 597763 599833 600297 601578 604715 605512 606322 607217 608679 610199 612430 614382 615053 618870 626332 629680 630254 630552 632579 632706 632750 637511 639060 639719 639796 640156 641953 642006 642226 642774 645700 646176 647860 650075 650634 666894 671070 671773 672401 672764 678095 680176 685511 690942 704896 710026 714577 715888 719649 719829 721949 724039 726330 727969 728605 729187 732589 732869 734350 734364 736396 736534 736944 737883 738326 738694 741692 744765 745981 747069 747384 748138 751453 752840 753656 753707 757237 757246 758145 758292 768059 775815 788127 789111 793438 793723 794240 796577 797240 799934 800698 800763 800920 807881 809358 809925 811010 814302 817709 817864 817879 818291 819488 820347 824196 827279 827591 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.62%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.85 ms (0.58%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"писсинг большие сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.54%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.