Query Metrics
7
Database Queries
7
Different statements
233.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.45 ms (91.39%) |
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 9797 13803 38343 384095 387324 408084 425405 425636 430227 450797 489244 523762 535359 550645 553292 561575 563620 564286 570799 572351 590211 596913 604927 606127 606639 612144 615759 624201 630619 642354 643919 645912 649956 680772 681153 686177 688668 699061 702144 708626 710249 711606 715226 717741 719022 719350 719473 719790 719994 721141 722321 723981 724261 726845 727282 727339 729649 731916 732408 734501 738276 740458 741608 741624 745200 748604 750021 751590 755420 755495 756057 757216 757340 758504 765308 770058 771358 772513 774114 779793 780262 782636 785762 786168 787101 788121 788374 789214 789216 789474 789478 789498 789504 790699 791654 797016 797638 797780 800025 800416 802451 803377 805355 805577 805588 805603 805952 806470 807417 807431 809412 811308 812506 812639 812731 813068 813774 814555 814581 814589 ] |
||||||||||||||||||||||||||||||
|
10.06 ms (4.31%) |
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 779793 800416 802451 803377 805577 805588 805952 807431 809412 811308 812639 780262 785762 789216 789474 789504 791654 797638 800025 805355 807417 723981 734501 748604 758504 772513 786168 787101 788374 789214 789478 789498 797016 805603 812506 729649 732408 740458 727339 741608 741624 745200 755495 757216 765308 771358 724261 726845 731916 738276 751590 756057 757340 770058 727282 750021 755420 774114 721141 722321 782636 788121 790699 797780 806470 812731 813068 387324 425405 9797 13803 38343 384095 430227 489244 570799 624201 553292 719350 450797 408084 425636 523762 814589 814555 813774 814581 535359 550645 563620 564286 561575 649956 719473 688668 702144 708626 710249 719022 719994 645912 680772 681153 686177 699061 711606 715226 717741 719790 572351 590211 604927 643919 606639 612144 630619 642354 596913 606127 615759 ] |
||||||||||||||||||||||||||||||
|
2.92 ms (1.25%) |
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 9797 13803 38343 384095 387324 408084 425405 425636 430227 450797 489244 523762 535359 550645 553292 561575 563620 564286 570799 572351 590211 596913 604927 606127 606639 612144 615759 624201 630619 642354 643919 645912 649956 680772 681153 686177 688668 699061 702144 708626 710249 711606 715226 717741 719022 719350 719473 719790 719994 721141 722321 723981 724261 726845 727282 727339 729649 731916 732408 734501 738276 740458 741608 741624 745200 748604 750021 751590 755420 755495 756057 757216 757340 758504 765308 770058 771358 772513 774114 779793 780262 782636 785762 786168 787101 788121 788374 789214 789216 789474 789478 789498 789504 790699 791654 797016 797638 797780 800025 800416 802451 803377 805355 805577 805588 805603 805952 806470 807417 807431 809412 811308 812506 812639 812731 813068 813774 814555 814581 814589 ] |
||||||||||||||||||||||||||||||
|
1.97 ms (0.84%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"милф"
]
|
||||||||||||||||||||||||||||||
|
1.89 ms (0.81%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"милф"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"милфой"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.69%) |
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.