Query Metrics
7
Database Queries
7
Different statements
160.56 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.88 ms (83.38%) |
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 389288 400428 403653 417283 418868 436680 438552 440250 440747 440877 440939 442988 447908 448218 455647 456126 459390 460895 461414 462638 463136 475516 476849 478253 485517 486990 487842 496135 501475 504682 506520 506559 516866 516929 520298 527897 540816 541500 552368 554723 556090 559615 559619 562047 566920 569632 576462 576739 577679 579775 580348 587444 588293 589837 597810 599592 601830 614118 617089 623037 623465 626143 628772 641366 645446 650919 662429 664630 678704 680622 682763 687620 689871 702613 711320 720446 721948 722201 730331 730482 734008 735243 736153 738951 742101 748707 749038 753743 756735 762174 764944 768008 771571 772296 774241 777995 779344 779551 779871 782066 788502 791101 796187 798720 798757 799297 799424 803384 805640 806929 806955 809345 809945 810171 811876 813336 813585 813593 826514 828426 ] |
||||||||||||||||||||||||||||||
|
15.55 ms (9.69%) |
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 736153 455647 738951 742101 828426 748707 559619 580348 779871 442988 730482 782066 791101 682763 711320 826514 463136 541500 720446 478253 628772 806955 599592 813585 809945 461414 768008 799297 813336 813593 589837 805640 810171 771571 730331 552368 809345 617089 554723 440939 735243 576462 623465 623037 777995 460895 520298 475516 448218 556090 588293 734008 462638 527897 689871 762174 803384 772296 400428 749038 516929 664630 559615 566920 811876 501475 601830 436680 504682 687620 516866 764944 662429 487842 796187 678704 779344 438552 798720 403653 389288 459390 597810 798757 440250 447908 506520 722201 562047 753743 680622 476849 496135 614118 641366 540816 650919 721948 779551 440747 579775 417283 587444 788502 485517 506559 486990 702613 799424 756735 626143 576739 774241 569632 645446 418868 456126 806929 440877 577679 ] |
||||||||||||||||||||||||||||||
|
3.11 ms (1.94%) |
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 389288 400428 403653 417283 418868 436680 438552 440250 440747 440877 440939 442988 447908 448218 455647 456126 459390 460895 461414 462638 463136 475516 476849 478253 485517 486990 487842 496135 501475 504682 506520 506559 516866 516929 520298 527897 540816 541500 552368 554723 556090 559615 559619 562047 566920 569632 576462 576739 577679 579775 580348 587444 588293 589837 597810 599592 601830 614118 617089 623037 623465 626143 628772 641366 645446 650919 662429 664630 678704 680622 682763 687620 689871 702613 711320 720446 721948 722201 730331 730482 734008 735243 736153 738951 742101 748707 749038 753743 756735 762174 764944 768008 771571 772296 774241 777995 779344 779551 779871 782066 788502 791101 796187 798720 798757 799297 799424 803384 805640 806929 806955 809345 809945 810171 811876 813336 813585 813593 826514 828426 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"risky public fuck"
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (1.29%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (1.20%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"risky на улиц секс"
]
|
||||||||||||||||||||||||||||||
|
1.73 ms (1.08%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"risky на улиц секс"
]
|
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.