Query Metrics
7
Database Queries
7
Different statements
210.96 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
192.22 ms (91.12%) |
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 31218 58408 59007 233330 272566 305824 358410 382182 383541 385712 388850 390580 391485 392082 392391 393886 397155 397866 398239 410079 413356 418621 424284 428033 439455 442429 443938 447200 451225 480083 482853 488684 494893 500877 501541 502934 502999 505569 507112 507439 509264 510197 516374 519473 526683 536944 538099 539652 542117 542298 553620 558226 559015 562544 563588 577512 594552 602979 605632 609512 615377 650649 651392 660770 667150 680295 681780 687310 702310 704418 707161 707419 709340 711139 711749 717274 724908 725022 731173 732211 734637 737318 739230 740763 742220 742561 742742 747507 752487 753762 756370 756424 756685 757878 762049 762830 764387 766114 766265 766272 768300 769496 770977 772474 777939 778410 783136 787425 792022 795195 795966 796097 797712 801800 804988 809914 814993 817578 825171 828804 ] |
||||||||||||||||||||||||||||||
|
9.67 ms (4.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 795966 740763 757878 762049 762830 766265 742561 764387 769496 772474 732211 737318 739230 742220 742742 756685 734637 747507 756370 756424 770977 709340 711749 777939 778410 796097 801800 809914 58408 385712 447200 31218 505569 482853 562544 717274 391485 388850 825171 563588 804988 752487 766272 795195 358410 428033 536944 731173 509264 519473 681780 615377 725022 783136 753762 605632 609512 594552 59007 392391 488684 451225 494893 390580 397866 398239 651392 766114 707161 233330 305824 272566 817578 828804 539652 542298 707419 704418 602979 797712 724908 792022 768300 711139 787425 383541 393886 392082 382182 397155 410079 413356 442429 418621 439455 424284 443938 814993 500877 516374 526683 538099 510197 507112 507439 501541 502934 502999 480083 559015 542117 577512 553620 558226 650649 660770 667150 680295 687310 702310 ] |
||||||||||||||||||||||||||||||
|
2.45 ms (1.16%) |
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 31218 58408 59007 233330 272566 305824 358410 382182 383541 385712 388850 390580 391485 392082 392391 393886 397155 397866 398239 410079 413356 418621 424284 428033 439455 442429 443938 447200 451225 480083 482853 488684 494893 500877 501541 502934 502999 505569 507112 507439 509264 510197 516374 519473 526683 536944 538099 539652 542117 542298 553620 558226 559015 562544 563588 577512 594552 602979 605632 609512 615377 650649 651392 660770 667150 680295 681780 687310 702310 704418 707161 707419 709340 711139 711749 717274 724908 725022 731173 732211 734637 737318 739230 740763 742220 742561 742742 747507 752487 753762 756370 756424 756685 757878 762049 762830 764387 766114 766265 766272 768300 769496 770977 772474 777939 778410 783136 787425 792022 795195 795966 796097 797712 801800 804988 809914 814993 817578 825171 828804 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (0.85%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жену рако"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.85%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.65 ms (0.78%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен рак"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.65%) |
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.