Query Metrics
7
Database Queries
7
Different statements
162.93 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
136.12 ms (83.54%) |
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 145956 197516 350574 382326 382643 383681 394059 401463 406616 412537 422360 443105 445765 452287 453157 454028 456030 457119 457313 465076 468927 471026 474822 479110 479674 490646 504005 510520 517485 523627 525468 530973 533128 533424 534209 536496 537583 543542 544487 556692 557844 562553 563290 586271 587979 598274 601449 605695 607572 612304 616556 617392 619622 624106 625803 630254 633482 634758 637882 643490 647065 650431 664969 670220 674374 674741 677529 686088 688339 693987 694195 697272 698580 702609 706439 710268 712234 714927 718356 718806 721956 724514 725433 726814 729074 729192 729935 730559 733018 735991 737131 737687 739788 743254 746624 756494 760175 770038 773754 773840 780588 789410 791837 795159 795348 801243 803738 804268 810014 810063 810503 819773 820533 823989 824520 824833 824892 825063 828179 828666 ] |
||||||||||||||||||||||||||||||
|
17.06 ms (10.47%) |
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 625803 714927 453157 456030 422360 406616 443105 525468 490646 517485 533128 702609 710268 637882 468927 510520 819773 804268 563290 729935 401463 412537 823989 820533 824520 825063 828179 828666 523627 536496 537583 530973 534209 533424 543542 557844 562553 650431 664969 670220 677529 686088 693987 698580 647065 674374 694195 697272 706439 712234 718356 721956 674741 688339 605695 607572 619622 634758 586271 616556 624106 598274 633482 643490 587979 617392 791837 801243 810503 780588 729192 735991 737687 789410 795159 810014 725433 726814 733018 729074 739788 770038 724514 730559 743254 746624 760175 737131 756494 773754 773840 612304 795348 803738 810063 145956 383681 197516 394059 382326 350574 382643 824892 824833 471026 479674 445765 452287 454028 457313 457119 465076 504005 474822 479110 544487 556692 718806 601449 630254 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.61%) |
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 145956 197516 350574 382326 382643 383681 394059 401463 406616 412537 422360 443105 445765 452287 453157 454028 456030 457119 457313 465076 468927 471026 474822 479110 479674 490646 504005 510520 517485 523627 525468 530973 533128 533424 534209 536496 537583 543542 544487 556692 557844 562553 563290 586271 587979 598274 601449 605695 607572 612304 616556 617392 619622 624106 625803 630254 633482 634758 637882 643490 647065 650431 664969 670220 674374 674741 677529 686088 688339 693987 694195 697272 698580 702609 706439 710268 712234 714927 718356 718806 721956 724514 725433 726814 729074 729192 729935 730559 733018 735991 737131 737687 739788 743254 746624 756494 760175 770038 773754 773840 780588 789410 791837 795159 795348 801243 803738 804268 810014 810063 810503 819773 820533 823989 824520 824833 824892 825063 828179 828666 ] |
||||||||||||||||||||||||||||||
|
2.00 ms (1.23%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"natural and hairy"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"натуральная натуральные волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.06%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"натуральная натуральные волосатая"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.01%) |
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.