Query Metrics
7
Database Queries
7
Different statements
152.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
127.69 ms (83.95%) |
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 37183 107874 332365 385609 386954 387000 400431 403603 418070 422032 423332 438353 445560 445723 448547 454300 466394 470364 473884 480620 491901 499688 518245 518801 522244 522642 523897 527072 535548 551602 552582 570909 574387 578538 588939 589558 595419 604207 606604 623808 625477 646212 646270 648370 648471 661590 662050 666719 668757 675483 676660 679713 680611 698818 699166 707455 716972 719144 719781 723965 725616 726716 727987 728285 730078 741496 746807 748716 749614 750063 750627 753080 753728 755404 756640 757290 759648 762024 769600 770054 771002 772118 773336 776503 777118 778377 786883 788132 790796 792608 792794 793524 794178 797764 800015 800899 800956 801580 803472 804121 805160 805259 806111 810052 810062 811021 814378 814421 814671 815299 823634 824700 825143 825955 826172 826454 828430 828791 ] |
||||||||||||||||||||||||||||||
|
14.25 ms (9.37%) |
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 551602 570909 680611 699166 716972 648471 676660 698818 777118 793524 794178 801580 790796 792794 725616 730078 771002 792608 797764 800015 804121 805160 750627 759648 762024 723965 748716 753728 757290 772118 726716 746807 753080 769600 773336 800956 826454 828791 778377 814671 588939 604207 727987 518801 438353 466394 826172 552582 661590 662050 668757 518245 646270 719781 589558 595419 625477 776503 756640 623808 803472 810052 480620 470364 535548 606604 805259 825955 522642 527072 788132 418070 423332 828430 755404 385609 814421 707455 332365 499688 675483 646212 800899 811021 738923 770054 724582 741496 749614 728285 37183 386954 400431 422032 815299 445723 445560 448547 491901 574387 578538 648370 719144 666719 679713 750063 522244 107874 786883 806111 810062 387000 824700 403603 814378 823634 825143 454300 473884 523897 ] |
||||||||||||||||||||||||||||||
|
2.89 ms (1.90%) |
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 37183 107874 332365 385609 386954 387000 400431 403603 418070 422032 423332 438353 445560 445723 448547 454300 466394 470364 473884 480620 491901 499688 518245 518801 522244 522642 523897 527072 535548 551602 552582 570909 574387 578538 588939 589558 595419 604207 606604 623808 625477 646212 646270 648370 648471 661590 662050 666719 668757 675483 676660 679713 680611 698818 699166 707455 716972 719144 719781 723965 725616 726716 727987 728285 730078 741496 746807 748716 749614 750063 750627 753080 753728 755404 756640 757290 759648 762024 769600 770054 771002 772118 773336 776503 777118 778377 786883 788132 790796 792608 792794 793524 794178 797764 800015 800899 800956 801580 803472 804121 805160 805259 806111 810052 810062 811021 814378 814421 814671 815299 823634 824700 825143 825955 826172 826454 828430 828791 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big ass pussy"
]
|
||||||||||||||||||||||||||||||
|
1.81 ms (1.19%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (1.15%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большая большие жоп pussy"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большая большие жоп pussy"
]
|
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.