Query Metrics
7
Database Queries
7
Different statements
164.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
142.65 ms (86.79%) |
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 170 83163 191048 197451 300296 330564 393016 395563 395986 398012 413075 418935 427770 431348 443932 454072 477045 492112 492767 496537 504161 519717 525182 533190 533820 536490 536753 551118 573172 583641 589399 591496 593300 609261 611282 613271 613294 616075 624368 627577 627738 629334 637481 641745 644014 645538 650067 651806 653680 659210 660976 663358 663468 664314 664492 665515 665878 667832 671497 672354 672734 672741 673209 675203 675253 681389 693299 695456 698120 701479 704218 707519 714111 715445 716588 721416 724503 726756 731785 733117 734015 734459 734726 735979 736011 738960 740159 742836 750005 753929 754620 754760 757240 757241 759306 760011 763878 766483 767026 771738 774085 776745 778572 780723 781973 784523 786198 786427 786603 788518 788520 789495 790855 797252 797278 797798 798607 800214 804536 811968 ] |
||||||||||||||||||||||||||||||
|
12.17 ms (7.40%) |
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 427770 431348 492767 492112 496537 519717 704218 413075 418935 197451 393016 300296 330564 170 443932 525182 533820 536753 533190 536490 583641 573172 659210 664314 664492 665878 672741 675203 721416 651806 653680 660976 663358 663468 665515 672354 672734 673209 681389 695456 701479 645538 650067 667832 671497 675253 698120 707519 714111 716588 551118 593300 616075 624368 627577 637481 641745 644014 589399 591496 613271 629334 609261 611282 627738 613294 776745 778572 786198 786603 789495 797278 800214 786427 788520 798607 811968 734726 736011 740159 742836 753929 754760 757241 763878 804536 724503 726756 734015 750005 754620 757240 759306 766483 733117 738960 731785 734459 760011 767026 774085 735979 771738 780723 781973 788518 790855 797252 398012 477045 395986 454072 693299 784523 715445 797798 504161 83163 191048 395563 ] |
||||||||||||||||||||||||||||||
|
2.53 ms (1.54%) |
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 170 83163 191048 197451 300296 330564 393016 395563 395986 398012 413075 418935 427770 431348 443932 454072 477045 492112 492767 496537 504161 519717 525182 533190 533820 536490 536753 551118 573172 583641 589399 591496 593300 609261 611282 613271 613294 616075 624368 627577 627738 629334 637481 641745 644014 645538 650067 651806 653680 659210 660976 663358 663468 664314 664492 665515 665878 667832 671497 672354 672734 672741 673209 675203 675253 681389 693299 695456 698120 701479 704218 707519 714111 715445 716588 721416 724503 726756 731785 733117 734015 734459 734726 735979 736011 738960 740159 742836 750005 753929 754620 754760 757240 757241 759306 760011 763878 766483 767026 771738 774085 776745 778572 780723 781973 784523 786198 786427 786603 788518 788520 789495 790855 797252 797278 797798 798607 800214 804536 811968 ] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"blonde natural"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"беловолосая натуральная натуральные"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.99%) |
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.