Query Metrics
7
Database Queries
7
Different statements
139.70 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
119.26 ms (85.37%) |
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 223663 382861 388185 409050 413254 471066 490437 500689 500692 539892 541034 545155 545735 545740 545742 546146 550530 557607 569661 576237 576766 576791 587805 594426 606097 609073 612622 619620 621051 626169 627232 628568 629695 640448 641300 643943 644199 648017 648273 652163 666062 666094 666670 667113 668007 668023 668027 676677 684752 684792 697177 697303 701059 703709 703748 703772 703783 706391 708035 713063 714366 714407 714569 715703 716293 718806 719781 722167 724503 724505 724667 727985 728148 728952 728955 728984 729045 729050 729051 729932 730318 730323 733307 733342 734205 734207 735391 735435 735976 736036 736671 739895 739969 740541 740666 742863 744140 744805 747251 748478 748517 748526 749487 758913 759701 767560 773866 778481 794570 794632 795812 800737 802272 803927 807827 815222 819307 827272 827577 827585 ] |
||||||||||||||||||||||||||||||
|
11.26 ms (8.06%) |
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 569661 794632 748478 545740 545155 541034 545742 703748 714366 667113 684792 697177 706391 668027 684752 626169 629695 628568 606097 641300 643943 729932 734207 749487 728952 728955 739969 744805 748517 728984 729045 748526 697303 714569 715703 594426 758913 724667 724505 730318 819307 730323 500689 666062 719781 733342 733307 795812 223663 546146 773866 716293 500692 550530 827272 827577 767560 409050 666670 803927 727985 736671 794570 802272 382861 735435 471066 736036 815222 718806 413254 388185 744140 576791 652163 666094 708035 644199 587805 778481 742863 724503 735391 807827 490437 539892 545735 576237 557607 576766 701059 713063 648273 668023 676677 648017 668007 703772 722167 609073 612622 627232 640448 729051 734205 740541 728148 729050 739895 747251 740666 703709 703783 714407 735976 619620 759701 800737 621051 827585 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (1.69%) |
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 223663 382861 388185 409050 413254 471066 490437 500689 500692 539892 541034 545155 545735 545740 545742 546146 550530 557607 569661 576237 576766 576791 587805 594426 606097 609073 612622 619620 621051 626169 627232 628568 629695 640448 641300 643943 644199 648017 648273 652163 666062 666094 666670 667113 668007 668023 668027 676677 684752 684792 697177 697303 701059 703709 703748 703772 703783 706391 708035 713063 714366 714407 714569 715703 716293 718806 719781 722167 724503 724505 724667 727985 728148 728952 728955 728984 729045 729050 729051 729932 730318 730323 733307 733342 734205 734207 735391 735435 735976 736036 736671 739895 739969 740541 740666 742863 744140 744805 747251 748478 748517 748526 749487 758913 759701 767560 773866 778481 794570 794632 795812 800737 802272 803927 807827 815222 819307 827272 827577 827585 ] |
||||||||||||||||||||||||||||||
|
1.95 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big hairy pussy"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.22%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие волосатая pussy"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие волосатая pussy"
]
|
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.