Query Metrics
7
Database Queries
7
Different statements
196.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
170.04 ms (86.63%) |
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 403858 413115 422722 426897 434903 438957 449573 449582 472535 472606 474925 477429 479604 480984 483658 495251 496377 497716 513450 516458 527834 528541 529774 534443 534734 538024 540196 544791 559314 560071 564749 577309 577698 579622 581745 585645 586752 593082 599795 603747 605795 606594 613899 617682 620817 634895 651690 655926 662151 664094 672901 678697 681491 687620 693313 695321 697654 702308 702317 702338 704079 706727 706826 707851 708505 708692 708989 711637 713314 713343 736074 736349 738514 740848 741186 742702 743268 743610 744002 744206 748263 748283 751791 752295 752452 753193 758316 760573 765256 777838 777840 780151 782135 782654 784047 784116 784459 785986 787976 788128 789234 791542 792712 796992 798481 799058 800692 802251 803104 804622 804696 806642 806803 806967 808158 809924 812681 813327 ] |
||||||||||||||||||||||||||||||
|
15.76 ms (8.03%) |
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 777838 777840 780151 782135 782654 784459 787976 796992 800692 812681 741186 744002 758316 784116 788128 789234 806967 808158 813327 736349 738514 748263 748283 765256 752452 751791 752295 760573 736074 742702 743268 744206 702308 702317 784047 785986 799058 803104 806642 806803 743610 792712 802251 438957 579622 804622 474925 426897 413115 434903 477429 449573 449582 538024 581745 708692 707851 585645 620817 791542 809924 740848 798481 804696 806505 753193 702338 479604 403858 480984 495251 483658 422722 472606 472535 516458 496377 497716 527834 528541 540196 534734 513450 529774 534443 544791 560071 559314 577698 564749 577309 664094 681491 697654 704079 706727 706826 711637 713291 713314 651690 662151 672901 678697 687620 693313 695321 708505 708989 655926 713343 603747 605795 613899 617682 634895 599795 606594 586752 593082 ] |
||||||||||||||||||||||||||||||
|
2.56 ms (1.31%) |
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 403858 413115 422722 426897 434903 438957 449573 449582 472535 472606 474925 477429 479604 480984 483658 495251 496377 497716 513450 516458 527834 528541 529774 534443 534734 538024 540196 544791 559314 560071 564749 577309 577698 579622 581745 585645 586752 593082 599795 603747 605795 606594 613899 617682 620817 634895 651690 655926 662151 664094 672901 678697 681491 687620 693313 695321 697654 702308 702317 702338 704079 706727 706826 707851 708505 708692 708989 711637 713314 713343 736074 736349 738514 740848 741186 742702 743268 743610 744002 744206 748263 748283 751791 752295 752452 753193 758316 760573 765256 777838 777840 780151 782135 782654 784047 784116 784459 785986 787976 788128 789234 791542 792712 796992 798481 799058 800692 802251 803104 804622 804696 806642 806803 806967 808158 809924 812681 813327 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"соло мастурбация мокрая"
]
|
||||||||||||||||||||||||||||||
|
2.06 ms (1.05%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"соло мастурбац мокрая"
]
|
||||||||||||||||||||||||||||||
|
1.95 ms (0.99%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 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.