Query Metrics
7
Database Queries
7
Different statements
152.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.13 ms (87.31%) |
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 401537 459735 514851 523227 529389 533167 533389 535545 536988 537484 539384 547099 550421 550921 552636 565071 579464 579835 584027 585937 591718 591842 593611 593615 600718 608625 633265 633690 636346 636930 645107 648273 653752 655467 656134 656137 656487 656532 656644 663315 666996 670550 674882 676437 680825 680909 689123 689779 689841 692962 695693 696560 698765 700719 703264 703335 706199 707567 709134 710083 713933 715407 716375 716940 718107 718654 718818 719392 720566 723152 725034 737844 746303 753219 759954 760588 761871 761874 766221 767298 767564 775474 776046 777033 781149 784095 786629 786680 787318 789568 791112 791207 791239 791275 791617 791717 792433 792674 792704 792806 795463 796356 797575 797605 797894 797923 800820 801150 802566 802584 803914 810362 810580 810583 810597 813006 813433 824798 825265 825675 ] |
||||||||||||||||||||||||||||||
|
10.04 ms (6.59%) |
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 825265 824798 825675 459735 514851 716940 718654 720566 723152 781149 791275 795463 796356 797605 810583 776046 791207 791239 791617 792806 797894 797923 801150 746303 767564 784095 786629 791112 791717 792433 792674 797575 800820 802566 803914 810362 813433 725034 737844 761874 759954 761871 767298 753219 760588 766221 775474 786680 787318 789568 792704 802584 810580 810597 813006 715407 680825 777033 401537 523227 533389 529389 535545 533167 536988 537484 539384 550421 584027 550921 565071 579464 579835 645107 653752 656487 666996 689123 689841 706199 713933 716375 718818 719392 648273 655467 656134 656644 674882 680909 689779 692962 695693 703264 703335 707567 710083 656137 656532 663315 670550 676437 696560 698765 700719 709134 718107 547099 552636 585937 591718 591842 633265 633690 636930 593611 593615 600718 608625 636346 ] |
||||||||||||||||||||||||||||||
|
3.08 ms (2.02%) |
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 401537 459735 514851 523227 529389 533167 533389 535545 536988 537484 539384 547099 550421 550921 552636 565071 579464 579835 584027 585937 591718 591842 593611 593615 600718 608625 633265 633690 636346 636930 645107 648273 653752 655467 656134 656137 656487 656532 656644 663315 666996 670550 674882 676437 680825 680909 689123 689779 689841 692962 695693 696560 698765 700719 703264 703335 706199 707567 709134 710083 713933 715407 716375 716940 718107 718654 718818 719392 720566 723152 725034 737844 746303 753219 759954 760588 761871 761874 766221 767298 767564 775474 776046 777033 781149 784095 786629 786680 787318 789568 791112 791207 791239 791275 791617 791717 792433 792674 792704 792806 795463 796356 797575 797605 797894 797923 800820 801150 802566 802584 803914 810362 810580 810583 810597 813006 813433 824798 825265 825675 ] |
||||||||||||||||||||||||||||||
|
1.68 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"creampie homemade"
]
|
||||||||||||||||||||||||||||||
|
1.66 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (1.08%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"creampie домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"creampie домашн любительск"
]
|
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.