Query Metrics
8
Database Queries
8
Different statements
380.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
214.36 ms (56.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"mom дрочк член"
]
|
||||||||||||||||||||||||||||||
|
140.87 ms (37.04%) |
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 386816 421105 450830 456787 482618 485328 495082 512794 514757 527154 539614 551908 553968 556664 561124 562743 563124 569192 570861 577918 579437 580345 581981 582461 585663 586323 587819 588336 588691 588978 589739 590318 606253 606743 606823 607139 609422 610275 612062 614529 624869 627846 630492 643321 645349 648963 649289 659984 661882 663562 667774 669171 669219 671725 672015 673329 681022 681117 681159 687386 690868 691533 694105 694141 701661 704878 705549 710078 714049 716590 724990 728115 730688 732156 733195 734294 736379 737752 740069 744681 748254 751564 754965 756766 757018 761411 762543 763077 765197 769626 772091 774281 774370 775593 775786 775950 778741 779338 779824 783683 783754 783866 784576 786147 786577 788979 789981 790759 795503 799028 800129 810836 811241 815141 816052 817266 817341 818106 822637 ] |
||||||||||||||||||||||||||||||
|
14.55 ms (3.83%) |
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 774281 728115 765197 768922 769626 774370 701661 775786 778741 783683 783754 786147 786577 788979 795503 799028 421105 386816 450830 485328 539614 669171 590318 763077 512794 514757 556664 456787 482618 580345 690868 705549 553968 585663 588691 624869 730688 607139 627846 775950 495082 815141 816052 817341 818106 817266 822637 527154 563124 581981 579437 551908 570861 577918 659984 661882 663562 669219 681117 710078 714049 645349 649289 671725 672015 681022 687386 691533 694105 694141 704878 716590 648963 667774 673329 681159 561124 562743 569192 582461 587819 588978 606253 630492 612062 614529 643321 586323 588336 589739 606823 609422 610275 789981 810836 811241 775593 779338 779824 783866 790759 732156 733195 740069 762543 784576 800129 724990 748254 761411 734294 754965 736379 737752 744681 756766 772091 751564 757018 606743 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.62%) |
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 386816 421105 450830 456787 482618 485328 495082 512794 514757 527154 539614 551908 553968 556664 561124 562743 563124 569192 570861 577918 579437 580345 581981 582461 585663 586323 587819 588336 588691 588978 589739 590318 606253 606743 606823 607139 609422 610275 612062 614529 624869 627846 630492 643321 645349 648963 649289 659984 661882 663562 667774 669171 669219 671725 672015 673329 681022 681117 681159 687386 690868 691533 694105 694141 701661 704878 705549 710078 714049 716590 724990 728115 730688 732156 733195 734294 736379 737752 740069 744681 748254 751564 754965 756766 757018 761411 762543 763077 765197 769626 772091 774281 774370 775593 775786 775950 778741 779338 779824 783683 783754 783866 784576 786147 786577 788979 789981 790759 795503 799028 800129 810836 811241 815141 816052 817266 817341 818106 822637 ] |
||||||||||||||||||||||||||||||
|
2.36 ms (0.62%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"mom handjob"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.52%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.93 ms (0.51%) |
1 |
SELECT 1 FROM `trend_has_post` WHERE `trend_id` = ? LIMIT 1
Parameters:
[
b"\x01“V\x16\x01]rÚ©Ñ^—ß©\x1E"
]
|
||||||||||||||||||||||||||||||
|
1.91 ms (0.50%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"mom дрочк член"
]
|
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.