Query Metrics
7
Database Queries
7
Different statements
173.17 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
150.19 ms (86.73%) |
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 94897 384241 385129 391572 400157 402134 408624 453746 471904 472944 533729 535938 538238 540148 540477 542346 547332 548362 549328 549330 549333 549363 549408 549928 549975 556328 557172 559388 560092 560145 566801 570216 571174 571181 571264 574202 577229 577235 577254 586826 586831 589928 593199 593232 596164 597223 603071 606846 606856 627155 627656 630479 643118 644339 648595 655309 655422 655633 655727 656032 656384 656392 656426 656749 656948 656951 657305 657351 657437 657651 657693 657701 657896 657927 657967 658009 658026 658426 658588 659581 659612 659709 660492 660538 660543 660930 661866 663050 669111 670176 671088 691499 693885 702636 708653 721200 722405 723364 725310 738889 740215 744104 747393 753469 753470 770885 785216 789352 794831 808409 814147 818254 818350 818912 820491 820781 820938 826186 828733 828872 ] |
||||||||||||||||||||||||||||||
|
13.56 ms (7.83%) |
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 655633 657305 657967 663050 655727 656426 657351 657651 659709 669111 693885 656951 658588 661866 547332 549408 549928 577254 740215 606846 384241 400157 818912 542346 549328 571264 556328 560145 708653 722405 691499 559388 560092 593232 586826 630479 606856 589928 627155 627656 808409 725310 753469 738889 753470 770885 744104 747393 702636 472944 385129 391572 535938 597223 453746 820781 826186 818350 820491 818254 828872 828733 538238 540477 540148 471904 570216 574202 577229 549333 549363 566801 571181 548362 549330 648595 655422 656032 657927 658426 660930 670176 656392 657701 657896 658026 659581 660492 671088 655309 656384 656749 656948 657437 657693 658009 659612 660538 660543 721200 549975 557172 571174 577235 596164 603071 586831 593199 643118 785216 794831 644339 723364 789352 94897 408624 402134 814147 820938 533729 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.45%) |
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 94897 384241 385129 391572 400157 402134 408624 453746 471904 472944 533729 535938 538238 540148 540477 542346 547332 548362 549328 549330 549333 549363 549408 549928 549975 556328 557172 559388 560092 560145 566801 570216 571174 571181 571264 574202 577229 577235 577254 586826 586831 589928 593199 593232 596164 597223 603071 606846 606856 627155 627656 630479 643118 644339 648595 655309 655422 655633 655727 656032 656384 656392 656426 656749 656948 656951 657305 657351 657437 657651 657693 657701 657896 657927 657967 658009 658026 658426 658588 659581 659612 659709 660492 660538 660543 660930 661866 663050 669111 670176 671088 691499 693885 702636 708653 721200 722405 723364 725310 738889 740215 744104 747393 753469 753470 770885 785216 789352 794831 808409 814147 818254 818350 818912 820491 820781 820938 826186 828733 828872 ] |
||||||||||||||||||||||||||||||
|
1.99 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"skinny beauty"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"худые beauty"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"худые beauty"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (0.90%) |
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.