Query Metrics
7
Database Queries
7
Different statements
566.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
227.08 ms (40.07%) |
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 739437 740298 749107 758066 707684 716561 778452 785815 809969 817020 557911 682179 719452 690728 720269 660798 718916 557224 614001 590840 777294 781588 787904 790942 802515 811479 776117 789140 789149 796894 811117 734536 739607 746304 760197 784166 799863 800128 804547 813495 748328 757744 731245 741200 761765 707882 709365 775550 795387 800943 809942 812881 644855 827589 813703 560863 541494 700086 706174 713830 716240 650070 678249 696904 707596 714914 685411 687850 689962 701963 707076 710123 712640 608806 609065 599032 639915 778417 786205 794448 797064 800642 806240 744073 745241 754268 770714 781412 789411 793396 798869 724837 757666 773661 736502 758506 764240 764383 767680 771079 736642 746882 764193 750519 756316 764180 765686 768203 700382 713670 778029 645913 825519 814170 817819 825005 813977 819664 819873 825196 ] |
||||||||||||||||||||||||||||||
|
210.86 ms (37.21%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
119.59 ms (21.10%) |
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 541494 557224 560863 590840 599032 608806 609065 614001 639915 644855 645913 650070 660798 678249 682179 685411 687850 689962 690728 696904 700086 700382 701963 706174 707076 707596 707684 707882 709365 710123 712640 713670 713830 714914 716240 716561 718916 719452 720269 724837 731245 734536 736502 736642 739437 739607 740298 741200 744073 745241 746304 746882 748328 749107 750519 754268 756316 757666 757744 758066 758506 760197 761765 764180 764193 764240 764383 765686 767680 768203 770714 771079 773661 775550 776117 777294 778029 778417 778452 781412 781588 784166 785815 786205 787904 789140 789149 789411 790942 793396 794448 795387 796894 797064 798869 799863 800128 800642 800943 802515 804547 806240 809942 809969 811117 811479 812881 813495 813703 813977 814170 817020 817819 819664 819873 825005 825196 825519 827589 ] |
||||||||||||||||||||||||||||||
|
3.22 ms (0.57%) |
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 541494 557224 560863 590840 599032 608806 609065 614001 639915 644855 645913 650070 660798 678249 682179 685411 687850 689962 690728 696904 700086 700382 701963 706174 707076 707596 707684 707882 709365 710123 712640 713670 713830 714914 716240 716561 718916 719452 720269 724837 731245 734536 736502 736642 739437 739607 740298 741200 744073 745241 746304 746882 748328 749107 750519 754268 756316 757666 757744 758066 758506 760197 761765 764180 764193 764240 764383 765686 767680 768203 770714 771079 773661 775550 776117 777294 778029 778417 778452 781412 781588 784166 785815 786205 787904 789140 789149 789411 790942 793396 794448 795387 796894 797064 798869 799863 800128 800642 800943 802515 804547 806240 809942 809969 811117 811479 812881 813495 813703 813977 814170 817020 817819 819664 819873 825005 825196 825519 827589 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex stepsister"
]
|
||||||||||||||||||||||||||||||
|
1.94 ms (0.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс stepsister"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс stepsister"
]
|
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.