Query Metrics
7
Database Queries
7
Different statements
157.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
131.38 ms (83.53%) |
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 81656 107651 132148 235834 274678 313463 377241 383801 385947 389255 391539 392902 395266 396333 396403 397089 398773 401144 401224 406881 417223 417721 417726 417727 417742 417748 418010 420348 420400 428517 445920 448648 453620 455325 457994 458830 465389 465543 466990 469596 474146 477863 485484 487116 489678 497963 500704 504790 509834 513332 520218 525494 528025 538957 559122 562676 566644 568429 568516 568984 569053 569122 569219 569476 569547 569550 577407 579555 581041 583591 583871 584104 588272 588507 598104 599688 601109 603650 606059 606400 606405 606595 606598 613726 619807 620145 621360 630246 673081 708203 709756 714188 715497 717948 720924 723982 726744 727858 734734 735893 736489 741998 750867 753257 774050 775751 775810 775988 788178 794557 796227 798703 799417 802128 808946 810744 812929 813128 818455 ] |
||||||||||||||||||||||||||||||
|
15.79 ms (10.04%) |
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 520218 583591 588272 406881 469596 581041 715497 714188 599688 794557 798703 736489 727858 802128 808946 274678 383801 313463 420348 428517 489678 709756 562676 598104 606400 613726 810744 741998 107651 395266 509834 528025 398773 818455 448648 606598 630246 812929 726744 417742 389255 81656 397089 420400 485484 465543 579555 568984 569122 569219 673081 568516 569476 603650 620145 588507 601109 621360 775751 775810 813128 723982 750867 799417 457994 391539 392902 377241 417726 417721 417748 453620 487116 465389 525494 504790 538957 477863 569053 569550 566644 720924 717948 708203 606059 619807 606405 606595 775988 788178 753257 796227 734734 774050 735893 401144 2939 235834 417223 445920 500704 385947 132148 396333 396403 401224 417727 418010 458830 455325 474146 497963 513332 466990 577407 583871 559122 584104 568429 569547 ] |
||||||||||||||||||||||||||||||
|
2.78 ms (1.77%) |
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 81656 107651 132148 235834 274678 313463 377241 383801 385947 389255 391539 392902 395266 396333 396403 397089 398773 401144 401224 406881 417223 417721 417726 417727 417742 417748 418010 420348 420400 428517 445920 448648 453620 455325 457994 458830 465389 465543 466990 469596 474146 477863 485484 487116 489678 497963 500704 504790 509834 513332 520218 525494 528025 538957 559122 562676 566644 568429 568516 568984 569053 569122 569219 569476 569547 569550 577407 579555 581041 583591 583871 584104 588272 588507 598104 599688 601109 603650 606059 606400 606405 606595 606598 613726 619807 620145 621360 630246 673081 708203 709756 714188 715497 717948 720924 723982 726744 727858 734734 735893 736489 741998 750867 753257 774050 775751 775810 775988 788178 794557 796227 798703 799417 802128 808946 810744 812929 813128 818455 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"german секс"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (1.20%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (1.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"german sex"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.10%) |
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.