Query Metrics
7
Database Queries
7
Different statements
392.38 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.71 ms (53.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жоп лиза сперм"
]
|
||||||||||||||||||||||||||||||
|
160.31 ms (40.86%) |
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 70476 146721 358438 385321 394610 394652 402700 406070 420109 425887 447807 458955 520469 535816 543246 557815 579308 579629 588275 597841 599039 604715 614321 614441 615475 623352 624157 643972 652910 670998 703935 710364 712957 714128 717701 717998 718624 720269 720766 721680 723549 725347 730616 732739 733608 736634 737733 738026 738813 740024 740890 747499 750200 753262 756107 757308 758033 759525 759593 760305 761584 761851 765428 765888 766131 767983 769033 769804 773522 774427 774597 775626 777409 780663 781978 786211 789019 791312 793738 794631 795187 796307 796800 800053 801646 801763 802757 803334 805428 805619 805691 805902 806046 812049 812259 812380 812446 813295 813396 816030 816302 816620 816904 817632 817793 818468 818776 819999 823583 823643 824150 824395 824598 824618 824760 825879 826241 826683 826684 826938 ] |
||||||||||||||||||||||||||||||
|
12.17 ms (3.10%) |
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 599039 614321 643972 775626 806046 812380 733608 791312 793738 732739 725347 730616 759525 773522 703935 812049 402700 394652 817793 720766 757308 70476 394610 760305 777409 520469 824760 816030 826938 824150 816302 816904 824618 670998 588275 780663 800053 801763 805428 794631 796800 805619 761584 813396 736634 737733 767983 761851 766131 146721 796307 623352 624157 738026 614441 406070 823583 818468 750200 826684 826683 818776 824395 652910 710364 720269 813295 769033 765428 385321 816620 825879 823643 458955 579308 712957 718624 717701 615475 604715 801646 803334 812259 740890 747499 756107 759593 738813 758033 765888 769804 753262 789019 805691 420109 425887 358438 597841 812446 579629 447807 817632 819999 723549 774427 824598 826241 535816 543246 714128 721680 717998 557815 774597 781978 795187 802757 805902 740024 786211 ] |
||||||||||||||||||||||||||||||
|
3.05 ms (0.78%) |
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 70476 146721 358438 385321 394610 394652 402700 406070 420109 425887 447807 458955 520469 535816 543246 557815 579308 579629 588275 597841 599039 604715 614321 614441 615475 623352 624157 643972 652910 670998 703935 710364 712957 714128 717701 717998 718624 720269 720766 721680 723549 725347 730616 732739 733608 736634 737733 738026 738813 740024 740890 747499 750200 753262 756107 757308 758033 759525 759593 760305 761584 761851 765428 765888 766131 767983 769033 769804 773522 774427 774597 775626 777409 780663 781978 786211 789019 791312 793738 794631 795187 796307 796800 800053 801646 801763 802757 803334 805428 805619 805691 805902 806046 812049 812259 812380 812446 813295 813396 816030 816302 816620 816904 817632 817793 818468 818776 819999 823583 823643 824150 824395 824598 824618 824760 825879 826241 826683 826684 826938 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.46%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"ass lick sperm"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (0.44%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.63 ms (0.41%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
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.