Query Metrics
7
Database Queries
7
Different statements
175.90 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
147.48 ms (83.85%) |
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 383388 396447 398551 415750 439797 439960 450357 452363 464071 469439 470024 473515 513161 525435 528452 533805 539647 541519 547960 552779 553167 554037 562542 563312 575287 577107 584837 588387 597633 603747 603817 605109 606146 607826 610374 614480 614577 615691 615700 616984 616991 618808 626411 628682 642271 643755 650986 652992 657527 703944 703945 704072 704074 709171 712153 717541 722370 722404 729366 730781 739809 740434 740836 743610 744967 746799 753554 753588 755489 756967 757829 757863 758088 760485 760697 761974 769153 770041 771939 772061 772523 772650 772654 773283 774793 777663 777932 779351 779870 780303 780547 780887 781262 781645 782305 782584 783291 784029 786600 787373 787534 789436 790137 791179 793110 797053 799164 800672 803489 803745 806647 810483 810788 811165 811890 812378 813200 814211 818062 824735 ] |
||||||||||||||||||||||||||||||
|
17.93 ms (10.20%) |
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 652992 722370 603747 626411 628682 607826 643755 777663 787534 791179 760485 772523 773283 740434 769153 771939 772654 730781 746799 740836 758088 704074 779351 780303 782584 813200 464071 398551 415750 396447 818062 469439 539647 541519 577107 657527 606146 616991 780887 790137 800672 774793 806647 753554 781645 782305 784029 787373 793110 812378 761974 753588 756967 757829 615691 780547 789436 797053 811165 513161 650986 616984 605109 597633 439960 450357 439797 452363 473515 552779 743610 528452 383388 712153 709171 783291 575287 814211 824735 533805 547960 553167 563312 584837 562542 554037 703944 704072 722404 717541 588387 603817 615700 618808 610374 614577 642271 614480 786600 803745 810483 810788 777932 803489 811890 772061 772650 781262 729366 739809 755489 757863 760697 770041 744967 703945 779870 799164 470024 525435 ] |
||||||||||||||||||||||||||||||
|
2.84 ms (1.62%) |
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 383388 396447 398551 415750 439797 439960 450357 452363 464071 469439 470024 473515 513161 525435 528452 533805 539647 541519 547960 552779 553167 554037 562542 563312 575287 577107 584837 588387 597633 603747 603817 605109 606146 607826 610374 614480 614577 615691 615700 616984 616991 618808 626411 628682 642271 643755 650986 652992 657527 703944 703945 704072 704074 709171 712153 717541 722370 722404 729366 730781 739809 740434 740836 743610 744967 746799 753554 753588 755489 756967 757829 757863 758088 760485 760697 761974 769153 770041 771939 772061 772523 772650 772654 773283 774793 777663 777932 779351 779870 780303 780547 780887 781262 781645 782305 782584 783291 784029 786600 787373 787534 789436 790137 791179 793110 797053 799164 800672 803489 803745 806647 810483 810788 811165 811890 812378 813200 814211 818062 824735 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
1.96 ms (1.12%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск рыжая соло"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.10%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur redhead solo"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.