Query Metrics
7
Database Queries
7
Different statements
246.21 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
216.84 ms (88.07%) |
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 131522 132148 235834 313463 391296 392902 392909 395266 396403 397918 401216 410781 411183 417721 417724 417727 417731 423427 424606 438898 443167 443396 453539 453620 454550 455865 456418 457984 457985 458830 459457 460512 460770 461129 461144 461893 466424 466842 466861 466886 469457 471012 471074 471077 471395 471411 471413 472858 473886 474098 474146 474149 477296 480758 484869 495878 498731 504116 509797 520057 523330 526751 526754 526755 541255 542161 547579 557415 562410 568460 569050 569498 574457 577086 579555 581025 583513 583681 583829 585569 590165 591253 592036 592778 592890 593856 594463 597878 599713 602024 602632 602633 604082 606058 606101 606162 606357 606367 606424 606438 606590 606608 606626 606644 609735 618139 619612 620491 640394 652358 719887 726744 761592 766687 774061 796450 799417 800030 801542 804168 ] |
||||||||||||||||||||||||||||||
|
18.94 ms (7.69%) |
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 640394 411183 590165 796450 761592 801542 395266 542161 132148 456418 466842 466886 579555 606058 606644 604082 799417 466424 235834 509797 417724 609735 726744 455865 417731 594463 766687 652358 585569 606367 606626 618139 606438 606101 461893 484869 577086 583513 583829 547579 568460 562410 569498 592778 592890 593856 602633 620491 804168 131522 397918 443396 424606 471074 454550 460770 466861 471077 498731 460512 469457 472858 557415 574457 619612 602632 800030 774061 391296 474149 392909 523330 599713 313463 401216 438898 459457 480758 471411 477296 526751 541255 606424 606608 520057 410781 443167 457984 471012 526755 461129 569050 719887 592036 602024 606162 606357 597878 471413 471395 473886 495878 474098 392902 396403 417727 417721 453620 458830 474146 606590 453539 461144 581025 591253 423427 457985 504116 526754 583681 ] |
||||||||||||||||||||||||||||||
|
3.37 ms (1.37%) |
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 131522 132148 235834 313463 391296 392902 392909 395266 396403 397918 401216 410781 411183 417721 417724 417727 417731 423427 424606 438898 443167 443396 453539 453620 454550 455865 456418 457984 457985 458830 459457 460512 460770 461129 461144 461893 466424 466842 466861 466886 469457 471012 471074 471077 471395 471411 471413 472858 473886 474098 474146 474149 477296 480758 484869 495878 498731 504116 509797 520057 523330 526751 526754 526755 541255 542161 547579 557415 562410 568460 569050 569498 574457 577086 579555 581025 583513 583681 583829 585569 590165 591253 592036 592778 592890 593856 594463 597878 599713 602024 602632 602633 604082 606058 606101 606162 606357 606367 606424 606438 606590 606608 606626 606644 609735 618139 619612 620491 640394 652358 719887 726744 761592 766687 774061 796450 799417 800030 801542 804168 ] |
||||||||||||||||||||||||||||||
|
2.05 ms (0.83%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german homemade"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.75%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.68%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.49 ms (0.60%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"german домашн любительск"
]
|
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.