Query Metrics
7
Database Queries
7
Different statements
170.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
149.55 ms (87.47%) |
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 75969 99145 184062 384460 387143 389697 403605 411817 430288 477479 492457 506771 506819 512444 535090 535095 537521 539583 540119 548327 559959 561678 564749 589852 591489 603707 606421 609977 611342 630637 644200 660976 663390 663499 664295 665200 665429 665505 665675 667682 669749 698472 702620 704065 713481 715981 716104 718518 719538 720610 723185 726661 730068 731767 732730 735783 738944 742207 742486 743841 745196 748557 749583 749606 749612 754064 760180 763586 766771 770040 771695 773472 774204 779498 780409 789952 790718 793493 794583 795439 797898 798839 799996 801098 801337 801372 801564 801614 802727 803223 804165 805719 805912 806279 808529 809189 811109 811693 813954 814557 817791 817930 818722 819388 820101 821177 822217 822389 823525 824275 824983 826440 827179 827295 827533 828420 828636 828835 ] |
||||||||||||||||||||||||||||||
|
12.61 ms (7.38%) |
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 559959 591489 713481 826440 723185 644200 384460 669749 742486 822389 820101 663499 665505 698472 664295 667682 630637 748557 738944 718518 803223 75969 828420 771695 539583 548327 797898 804165 811693 702620 99145 732730 790718 779498 806279 742207 754064 817791 818722 827179 827295 813954 512444 660976 704065 801564 805719 795439 799996 802727 766771 749606 716104 184062 387143 819388 789952 828615 828835 776051 814557 665200 506771 808529 798839 735783 749583 811109 780409 824983 828636 805912 794583 770040 665675 817930 822217 823525 809189 745196 760180 492457 506819 540119 537521 720610 535090 389697 430288 609977 730068 774204 793493 801337 801614 403605 411817 719538 561678 564749 589852 801372 821177 827533 665429 715981 663390 606421 603707 611342 726661 749612 773472 731767 743841 763586 824275 535095 477479 801098 ] |
||||||||||||||||||||||||||||||
|
2.42 ms (1.41%) |
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 75969 99145 184062 384460 387143 389697 403605 411817 430288 477479 492457 506771 506819 512444 535090 535095 537521 539583 540119 548327 559959 561678 564749 589852 591489 603707 606421 609977 611342 630637 644200 660976 663390 663499 664295 665200 665429 665505 665675 667682 669749 698472 702620 704065 713481 715981 716104 718518 719538 720610 723185 726661 730068 731767 732730 735783 738944 742207 742486 743841 745196 748557 749583 749606 749612 754064 760180 763586 766771 770040 771695 773472 774204 779498 780409 789952 790718 793493 794583 795439 797898 798839 799996 801098 801337 801372 801564 801614 802727 803223 804165 805719 805912 806279 808529 809189 811109 811693 813954 814557 817791 817930 818722 819388 820101 821177 822217 822389 823525 824275 824983 826440 827179 827295 827533 828420 828636 828835 ] |
||||||||||||||||||||||||||||||
|
1.86 ms (1.09%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"big tits horny"
]
|
||||||||||||||||||||||||||||||
|
1.63 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"большие сиськ horny"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (0.87%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"большие сиськ horny"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.84%) |
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.