Query Metrics
7
Database Queries
7
Different statements
186.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
163.39 ms (87.62%) |
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 2939 69932 131522 132148 235834 313463 377241 382731 385947 386024 391539 395266 396333 398773 411183 417219 417223 417724 417740 420348 421524 456418 461893 465444 466424 466842 466886 469451 474149 484869 504010 509797 512350 523390 526210 528025 528390 528493 542161 547579 557406 562410 563065 568451 568460 569095 569122 569498 569547 575392 577086 577122 579555 581041 583513 583829 583967 584045 585569 590165 592778 592890 593856 594453 594463 598104 599791 599802 602580 602620 602633 604082 606058 606101 606156 606298 606367 606401 606405 606438 606616 606626 606644 609735 615535 615997 616448 618139 621999 630246 640394 652358 714188 717948 721749 723681 724038 726744 736146 741998 750872 755353 755375 761592 769567 774050 775915 785370 795581 796450 798748 798918 799417 801542 802113 802585 803210 809937 817716 818283 ] |
||||||||||||||||||||||||||||||
|
14.12 ms (7.57%) |
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 569547 606298 606401 621999 630246 755353 398773 417740 417219 817716 469451 504010 523390 528390 528493 557406 568451 577122 717948 721749 714188 584045 616448 606156 606405 723681 769567 640394 411183 598104 590165 606616 796450 798918 736146 741998 761592 755375 801542 803210 395266 385947 132148 391539 396333 456418 466842 466886 465444 579555 569122 575392 606058 606644 604082 774050 799417 466424 2939 235834 382731 417223 509797 421524 583967 602580 785370 798748 795581 750872 131522 594453 609735 602620 594463 377241 474149 526210 581041 563065 615535 775915 726744 542161 652358 585569 606367 606626 618139 606438 606101 417724 386024 69932 313463 420348 818283 802585 802113 724038 809937 512350 528025 461893 484869 569095 577086 583513 583829 547579 568460 562410 569498 592778 592890 615997 593856 599791 599802 602633 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.40%) |
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 2939 69932 131522 132148 235834 313463 377241 382731 385947 386024 391539 395266 396333 398773 411183 417219 417223 417724 417740 420348 421524 456418 461893 465444 466424 466842 466886 469451 474149 484869 504010 509797 512350 523390 526210 528025 528390 528493 542161 547579 557406 562410 563065 568451 568460 569095 569122 569498 569547 575392 577086 577122 579555 581041 583513 583829 583967 584045 585569 590165 592778 592890 593856 594453 594463 598104 599791 599802 602580 602620 602633 604082 606058 606101 606156 606298 606367 606401 606405 606438 606616 606626 606644 609735 615535 615997 616448 618139 621999 630246 640394 652358 714188 717948 721749 723681 724038 726744 736146 741998 750872 755353 755375 761592 769567 774050 775915 785370 795581 796450 798748 798918 799417 801542 802113 802585 803210 809937 817716 818283 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.02%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск german xxx"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.84%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.50 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur german xxx"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.74%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск german xxx"
]
|
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.