Query Metrics
7
Database Queries
7
Different statements
153.34 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.40 ms (87.00%) |
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 108029 461127 498642 502365 509542 522055 530172 540169 541704 544593 544877 546321 546871 550783 553806 558154 563751 566902 571110 572270 576237 584060 592096 593611 595183 610128 610513 610772 612621 616506 619017 621799 622904 626637 627546 628192 628510 628723 629547 630145 632092 633268 633640 634922 636911 640254 641219 643786 650723 653031 656167 656538 670550 670914 686341 687847 691784 692919 693716 696708 702005 703709 703772 704346 708755 710218 710309 710880 720337 724012 725662 727486 728952 729050 729063 730175 732193 734876 734954 735187 742277 742785 748565 748570 749144 750743 759050 762063 765383 767535 767570 768300 768527 769914 770086 770571 771900 773385 778153 779070 780112 780405 780585 784413 786208 787218 790138 790637 790904 792429 793049 793055 797581 798812 799377 803903 808645 ] |
||||||||||||||||||||||||||||||
|
9.76 ms (6.37%) |
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 593611 633640 787218 734954 767535 771900 558154 584060 768527 793049 592096 498642 610772 546321 550783 641219 797581 766664 750743 732193 734876 742785 803903 502365 540169 546871 610128 627546 799377 727486 749144 696708 704346 710309 622904 628192 792429 735187 748565 769914 786208 728952 762063 634922 790138 108029 509542 530172 576237 650723 653031 693716 670550 670914 686341 703772 595183 610513 616506 628723 636911 628510 633268 780405 790904 729063 793055 729050 763487 770571 730175 765383 767570 703709 798812 656538 708755 621799 790637 773385 770086 773406 612621 780112 544593 626637 759050 808645 643786 572270 742277 725662 768300 710880 778153 566902 656167 691784 522055 553806 544877 748570 461127 541704 724012 619017 630145 779070 784413 563751 702005 720337 692919 710218 687847 571110 640254 632092 629547 780585 ] |
||||||||||||||||||||||||||||||
|
2.76 ms (1.80%) |
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 108029 461127 498642 502365 509542 522055 530172 540169 541704 544593 544877 546321 546871 550783 553806 558154 563751 566902 571110 572270 576237 584060 592096 593611 595183 610128 610513 610772 612621 616506 619017 621799 622904 626637 627546 628192 628510 628723 629547 630145 632092 633268 633640 634922 636911 640254 641219 643786 650723 653031 656167 656538 670550 670914 686341 687847 691784 692919 693716 696708 702005 703709 703772 704346 708755 710218 710309 710880 720337 724012 725662 727486 728952 729050 729063 730175 732193 734876 734954 735187 742277 742785 748565 748570 749144 750743 759050 762063 765383 767535 767570 768300 768527 769914 770086 770571 771900 773385 778153 779070 780112 780405 780585 784413 786208 787218 790138 790637 790904 792429 793049 793055 797581 798812 799377 803903 808645 ] |
||||||||||||||||||||||||||||||
|
2.12 ms (1.38%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
b"ð┤ðÁð▓ÐâÐêð║ð© ð▒ÐïÐüÐéÐÇð¥ ð║ð¥ð¢Ðçð░Ð%ÔǪ"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.24%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.78 ms (1.16%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"девушк быстр сперм"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (1.05%) |
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.