Query Metrics
7
Database Queries
7
Different statements
147.26 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
123.32 ms (83.74%) |
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 6602 21220 98871 143572 386202 386508 403467 407796 408249 411897 411944 411953 413472 427315 445667 446298 452296 454205 460141 467054 474876 476337 484397 525528 530326 532062 537157 543694 543738 550223 554759 567412 569957 574403 577388 581628 582333 627171 645925 651165 651887 663929 663989 664321 664322 664953 665100 665224 665229 665233 665273 665300 665384 665455 665465 665871 666115 666123 666124 666849 667009 667209 667281 667284 667659 668192 669768 669771 673608 673990 675537 685614 685687 694048 696320 697180 699338 709536 709578 709902 710588 711679 712905 714053 714167 714870 716164 716181 718048 718522 718553 721459 726556 728799 732425 734489 737439 760034 776488 788293 789016 798640 803271 807454 807991 813388 815437 816543 817432 817687 818488 818504 820732 821337 822788 824244 824935 825139 826592 827861 ] |
||||||||||||||||||||||||||||||
|
14.21 ms (9.65%) |
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 675537 98871 818488 718522 760034 732425 427315 408249 413472 446298 476337 550223 714870 567412 788293 798640 813388 627171 776488 807991 411897 460141 474876 452296 454205 484397 716181 525528 537157 816543 664953 685614 728799 716164 807454 143572 21220 386508 817432 817687 820732 827861 530326 543694 581628 543738 789016 734489 803271 737439 726556 6602 386202 403467 407796 411944 411953 815437 818504 825139 826592 821337 822788 824935 824244 445667 467054 532062 582333 554759 569957 574403 577388 645925 663929 664321 665229 665233 665273 665300 665455 665871 666115 666123 667209 667284 669768 669771 673608 673990 696320 699338 709578 709902 711679 714167 718048 651165 651887 663989 664322 665100 665224 665384 665465 666124 666849 667009 667281 667659 668192 685687 694048 697180 709536 710588 712905 714053 718553 721459 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.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 6602 21220 98871 143572 386202 386508 403467 407796 408249 411897 411944 411953 413472 427315 445667 446298 452296 454205 460141 467054 474876 476337 484397 525528 530326 532062 537157 543694 543738 550223 554759 567412 569957 574403 577388 581628 582333 627171 645925 651165 651887 663929 663989 664321 664322 664953 665100 665224 665229 665233 665273 665300 665384 665455 665465 665871 666115 666123 666124 666849 667009 667209 667281 667284 667659 668192 669768 669771 673608 673990 675537 685614 685687 694048 696320 697180 699338 709536 709578 709902 710588 711679 712905 714053 714167 714870 716164 716181 718048 718522 718553 721459 726556 728799 732425 734489 737439 760034 776488 788293 789016 798640 803271 807454 807991 813388 815437 816543 817432 817687 818488 818504 820732 821337 822788 824244 824935 825139 826592 827861 ] |
||||||||||||||||||||||||||||||
|
1.92 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð▒ð¥ð╗ÐîÐêð©ðÁ ÐüÐéð░ÐÇÐïðÁ Ðüð©ÐüÐîð║ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.77 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие старые сиськ"
]
|
||||||||||||||||||||||||||||||
|
1.64 ms (1.11%) |
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.