Query Metrics
7
Database Queries
7
Different statements
175.64 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
152.48 ms (86.81%) |
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 97689 97769 172322 183506 358849 383829 384282 384977 385341 385709 386658 390643 393355 398982 399456 400521 403404 403416 403467 403476 420143 421053 435549 436479 446756 447556 456636 461697 472830 472879 472897 472924 472935 472959 473499 476578 478621 481157 481662 496162 503322 509911 513446 514252 517607 519534 524469 526046 527484 528027 535700 536726 540207 540550 545718 550712 552030 556843 561134 563069 564583 564719 564736 564740 564741 567354 568133 578131 583144 584128 591063 591383 591492 591522 596793 596796 596901 597777 597786 600406 615513 619469 630941 636658 641156 643007 663875 664504 677048 677963 680898 691989 699646 700966 713820 715891 729764 736596 741046 748437 751664 766861 775396 775598 779686 780254 781481 788025 789260 789477 791003 803135 810056 810766 814743 818173 818278 818302 824214 ] |
||||||||||||||||||||||||||||||
|
14.13 ms (8.05%) |
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 810056 814743 476578 536726 514252 472935 545718 552030 564719 564741 561134 596793 172322 591063 781481 810766 97769 818302 824187 540550 456636 472924 583144 600406 641156 591383 751664 615513 461697 447556 556843 550712 729764 524469 596901 481157 472879 527484 824214 478621 383829 97689 400521 421053 818173 481662 568133 775396 775598 779686 780254 791003 788025 766861 748437 630941 358849 513446 503322 677963 564740 386658 384282 399456 403416 403476 403467 420143 818278 472830 446756 472897 509911 535700 564583 563069 584128 680898 700966 564736 597777 619469 643007 596796 597786 636658 741046 390643 393355 403404 183506 436479 472959 526046 519534 528027 473499 496162 677048 715891 789477 540207 789260 567354 398982 713820 578131 591492 591522 803135 736596 699646 384977 385709 435549 385341 517607 691989 663875 664504 ] |
||||||||||||||||||||||||||||||
|
2.50 ms (1.42%) |
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 97689 97769 172322 183506 358849 383829 384282 384977 385341 385709 386658 390643 393355 398982 399456 400521 403404 403416 403467 403476 420143 421053 435549 436479 446756 447556 456636 461697 472830 472879 472897 472924 472935 472959 473499 476578 478621 481157 481662 496162 503322 509911 513446 514252 517607 519534 524469 526046 527484 528027 535700 536726 540207 540550 545718 550712 552030 556843 561134 563069 564583 564719 564736 564740 564741 567354 568133 578131 583144 584128 591063 591383 591492 591522 596793 596796 596901 597777 597786 600406 615513 619469 630941 636658 641156 643007 663875 664504 677048 677963 680898 691989 699646 700966 713820 715891 729764 736596 741046 748437 751664 766861 775396 775598 779686 780254 781481 788025 789260 789477 791003 803135 810056 810766 814743 818173 818278 818302 824214 ] |
||||||||||||||||||||||||||||||
|
1.84 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"brunette maid"
]
|
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.62 ms (0.92%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"черноволосая горничн"
]
|
||||||||||||||||||||||||||||||
|
1.45 ms (0.83%) |
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.