Query Metrics
7
Database Queries
7
Different statements
185.16 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
162.36 ms (87.68%) |
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 386263 388772 393693 395667 395920 399062 404122 408532 421544 421637 426266 441559 458138 460449 461711 468711 480037 484424 490536 495364 499457 511357 528421 529025 536271 540685 541755 547702 552682 553722 556013 565159 565344 570135 581061 588898 597229 597241 598874 605677 608818 609875 613765 618362 619476 623165 623651 627759 631709 633241 633286 634541 637018 640739 649511 656644 664760 668646 671077 671810 672052 674220 678799 678802 685068 687844 687896 697491 698248 699961 702162 703586 704025 712366 715773 719235 720880 722583 722594 723159 728362 728369 731874 735772 740088 742216 750334 750550 752722 756849 760968 761790 765235 766969 770303 770582 772449 772729 777888 782959 785553 790632 792183 793075 793663 794917 796699 797863 798996 805660 811943 812993 813906 814019 818044 821189 822216 822934 823721 ] |
||||||||||||||||||||||||||||||
|
12.39 ms (6.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 623165 640739 408532 528421 722583 792183 404122 458138 823721 540685 671810 680196 605677 597229 785553 756849 818044 822934 678802 765235 386263 395667 634541 805660 770303 395920 813906 814019 490536 499457 547702 553722 565159 565344 674220 678799 687896 664760 671077 672052 697491 698248 712366 723159 633241 627759 637018 619476 790632 793075 797863 777888 782959 796699 770582 793663 794917 752722 766969 728369 728362 731874 735772 750334 760968 608818 609875 699961 715773 426266 529025 656644 618362 750550 742216 421544 581061 552682 633286 588898 597241 812993 388772 468711 511357 772449 703586 704025 772729 822216 623651 631709 811943 740088 798996 461711 484424 570135 702162 556013 598874 613765 761790 460449 495364 393693 399062 441559 421637 821189 480037 536271 541755 649511 685068 720880 722594 668646 687844 719235 ] |
||||||||||||||||||||||||||||||
|
3.57 ms (1.93%) |
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 386263 388772 393693 395667 395920 399062 404122 408532 421544 421637 426266 441559 458138 460449 461711 468711 480037 484424 490536 495364 499457 511357 528421 529025 536271 540685 541755 547702 552682 553722 556013 565159 565344 570135 581061 588898 597229 597241 598874 605677 608818 609875 613765 618362 619476 623165 623651 627759 631709 633241 633286 634541 637018 640739 649511 656644 664760 668646 671077 671810 672052 674220 678799 678802 685068 687844 687896 697491 698248 699961 702162 703586 704025 712366 715773 719235 720880 722583 722594 723159 728362 728369 731874 735772 740088 742216 750334 750550 752722 756849 760968 761790 765235 766969 770303 770582 772449 772729 777888 782959 785553 790632 792183 793075 793663 794917 796699 797863 798996 805660 811943 812993 813906 814019 818044 821189 822216 822934 823721 ] |
||||||||||||||||||||||||||||||
|
2.16 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"teens first anal"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.51 ms (0.82%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"teens first анал"
]
|
||||||||||||||||||||||||||||||
|
1.39 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"teens first анал"
]
|
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.