Query Metrics
7
Database Queries
7
Different statements
183.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
160.13 ms (87.29%) |
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 228398 383530 397494 397767 399971 422316 482871 483847 487634 511950 515996 529115 530522 532306 533175 533679 540872 544942 546578 552692 557766 558404 559895 561163 564287 566764 577935 578572 583323 584570 585521 587924 588460 590002 590031 591991 601494 605215 605440 606968 607468 615335 629993 630238 632216 633883 638138 639222 640617 640667 640672 641228 642426 646066 648182 668735 685926 690461 691182 692174 696984 710679 710687 716713 724048 725029 726988 727985 731032 731539 733995 739389 742507 750265 758679 759899 763844 764651 765313 766572 767705 770295 771021 771205 775187 777497 777804 778017 778981 779132 779235 781458 781907 783719 783846 785538 785754 791624 794072 795694 796061 796131 799898 800147 803065 804935 808495 810435 811161 811592 812080 812090 819824 819931 820207 828584 828690 828786 ] |
||||||||||||||||||||||||||||||
|
13.97 ms (7.62%) |
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 587924 795694 759899 750265 726988 632216 716713 777804 727985 710687 583323 785538 710679 828584 557766 668735 796061 515996 692174 640672 590031 633883 642426 778017 731032 766572 794072 799898 588460 533175 646066 778981 796131 731539 811592 228398 397767 820207 828786 585521 724048 483847 690461 607468 811161 812080 783846 767705 629993 783719 791624 812090 383530 819824 824746 529115 532306 533679 558404 561163 552692 691182 605440 781458 764651 733995 739389 771021 640667 638138 640617 808495 777497 785754 765313 584570 546578 696984 577935 540872 482871 487634 544942 648182 615335 601494 630238 641228 779132 775187 779235 800147 803065 810435 758679 763844 826500 828690 566764 591991 590002 564287 578572 639222 606968 605215 804935 742507 530522 511950 559895 685926 725029 771205 770295 781907 397494 399971 422316 819931 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (1.64%) |
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 228398 383530 397494 397767 399971 422316 482871 483847 487634 511950 515996 529115 530522 532306 533175 533679 540872 544942 546578 552692 557766 558404 559895 561163 564287 566764 577935 578572 583323 584570 585521 587924 588460 590002 590031 591991 601494 605215 605440 606968 607468 615335 629993 630238 632216 633883 638138 639222 640617 640667 640672 641228 642426 646066 648182 668735 685926 690461 691182 692174 696984 710679 710687 716713 724048 725029 726988 727985 731032 731539 733995 739389 742507 750265 758679 759899 763844 764651 765313 766572 767705 770295 771021 771205 775187 777497 777804 778017 778981 779132 779235 781458 781907 783719 783846 785538 785754 791624 794072 795694 796061 796131 799898 800147 803065 804935 808495 810435 811161 811592 812080 812090 819824 819931 820207 828584 828690 828786 ] |
||||||||||||||||||||||||||||||
|
1.76 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп пов"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass pov"
]
|
||||||||||||||||||||||||||||||
|
1.50 ms (0.82%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"жоп пов"
]
|
||||||||||||||||||||||||||||||
|
1.38 ms (0.75%) |
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.