Query Metrics
7
Database Queries
7
Different statements
140.88 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
120.78 ms (85.73%) |
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 148101 390931 393435 395534 395731 401968 409340 430227 430833 430979 433249 438488 453540 466710 539654 546425 555669 569555 573756 588144 596789 605362 612845 643384 644187 661657 673660 675405 680778 682165 682176 684916 685900 686637 687552 687584 687605 688254 698224 702455 714283 714320 714908 714916 715039 715058 718779 719276 720109 720514 725375 726627 726843 731444 734461 740573 742248 742445 742665 744165 753123 753656 753673 754312 757249 757288 760158 765919 775569 776473 776933 777371 779248 781029 786283 788583 788603 788947 789706 790017 791673 795337 800085 801465 802095 802201 802228 802500 802506 803080 804517 805689 805690 805706 806290 807403 807446 807824 808041 813264 813393 816655 816732 817737 818053 818242 818402 818423 818473 819233 819919 819935 824535 824994 825296 825825 825870 826543 826907 828533 ] |
||||||||||||||||||||||||||||||
|
11.10 ms (7.88%) |
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 438488 675405 588144 740573 680778 401968 430979 430833 714320 828533 818242 596789 826543 686637 754312 818423 682176 777371 819233 555669 802095 775569 789706 742665 409340 726843 573756 826907 818053 819935 687584 714908 795337 802201 802500 807446 805706 742445 718779 698224 816655 817737 825296 825825 720514 714283 714916 788603 802228 791673 808041 395731 393435 818473 825870 816732 819919 688254 687552 687605 673660 720109 605362 643384 786283 800085 804517 803080 805689 725375 760158 788583 806290 731444 753656 757249 753673 765919 753123 715039 719276 776473 781029 148101 430227 546425 569555 390931 453540 433249 824535 824994 818402 466710 539654 661657 684916 715058 682165 685900 702455 644187 612845 776933 779248 802506 805690 813393 788947 734461 744165 757288 813264 742248 726627 790017 801465 807403 807824 395534 ] |
||||||||||||||||||||||||||||||
|
2.61 ms (1.85%) |
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 148101 390931 393435 395534 395731 401968 409340 430227 430833 430979 433249 438488 453540 466710 539654 546425 555669 569555 573756 588144 596789 605362 612845 643384 644187 661657 673660 675405 680778 682165 682176 684916 685900 686637 687552 687584 687605 688254 698224 702455 714283 714320 714908 714916 715039 715058 718779 719276 720109 720514 725375 726627 726843 731444 734461 740573 742248 742445 742665 744165 753123 753656 753673 754312 757249 757288 760158 765919 775569 776473 776933 777371 779248 781029 786283 788583 788603 788947 789706 790017 791673 795337 800085 801465 802095 802201 802228 802500 802506 803080 804517 805689 805690 805706 806290 807403 807446 807824 808041 813264 813393 816655 816732 817737 818053 818242 818402 818423 818473 819233 819919 819935 824535 824994 825296 825825 825870 826543 826907 828533 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.45%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.58 ms (1.12%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom stepmom"
]
|
||||||||||||||||||||||||||||||
|
1.48 ms (1.05%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.30 ms (0.92%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom stepmom"
]
|
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.