Query Metrics
7
Database Queries
7
Different statements
158.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
134.01 ms (84.39%) |
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 31941 265967 382115 387408 395550 395922 400487 400489 400493 400513 400808 402045 404644 420163 428148 442523 442545 442612 442912 442933 443278 443786 444703 446059 446294 454439 454508 454560 457417 457468 458615 462695 463157 465331 465342 466277 466312 467413 467426 467494 467626 470203 472691 474627 474685 476454 477989 478377 478680 480526 480929 482342 483628 484739 488378 489212 489457 490262 507281 509267 511160 511517 516485 521129 521220 525557 534932 535485 544493 561526 577116 587272 599716 609825 613683 624792 631974 639755 644499 650779 668641 668732 669744 670493 698458 712140 726555 727751 733254 733587 735029 739900 747188 749015 751610 758434 761061 765939 770896 772118 784189 793664 799208 799465 801175 803541 803897 804215 805266 805969 807976 808054 810061 813946 813947 815941 816558 817311 824572 824883 ] |
||||||||||||||||||||||||||||||
|
15.77 ms (9.93%) |
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 733587 727751 747188 770896 726555 739900 758434 609825 799208 804215 807976 810061 404644 457468 467494 472691 395550 395922 400487 443786 446294 454560 463157 465342 467413 477989 482342 400493 454508 467426 476454 400489 400513 420163 478377 428148 465331 466312 507281 509267 516485 521129 521220 458615 613683 265967 382115 813946 813947 817311 816558 824883 815941 824572 478680 534932 525557 535485 577116 650779 668732 698458 669744 670493 712140 631974 639755 644499 599716 801175 799465 803541 805266 749015 784189 793664 765939 735029 751610 772118 733254 761061 624792 803897 805969 808054 402045 31941 387408 489212 484739 488378 489457 544493 561526 668641 587272 442545 462695 480526 444703 457417 466277 467626 470203 400808 442933 442912 454439 474627 480929 442523 442612 443278 446059 474685 511160 511517 483628 490262 ] |
||||||||||||||||||||||||||||||
|
2.40 ms (1.51%) |
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 31941 265967 382115 387408 395550 395922 400487 400489 400493 400513 400808 402045 404644 420163 428148 442523 442545 442612 442912 442933 443278 443786 444703 446059 446294 454439 454508 454560 457417 457468 458615 462695 463157 465331 465342 466277 466312 467413 467426 467494 467626 470203 472691 474627 474685 476454 477989 478377 478680 480526 480929 482342 483628 484739 488378 489212 489457 490262 507281 509267 511160 511517 516485 521129 521220 525557 534932 535485 544493 561526 577116 587272 599716 609825 613683 624792 631974 639755 644499 650779 668641 668732 669744 670493 698458 712140 726555 727751 733254 733587 735029 739900 747188 749015 751610 758434 761061 765939 770896 772118 784189 793664 799208 799465 801175 803541 803897 804215 805266 805969 807976 808054 810061 813946 813947 815941 816558 817311 824572 824883 ] |
||||||||||||||||||||||||||||||
|
1.90 ms (1.20%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mature red"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.11%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.56 ms (0.98%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mature red"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mature red"
]
|
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.