Query Metrics
7
Database Queries
7
Different statements
354.49 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.44 ms (59.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"step девушк"
]
|
||||||||||||||||||||||||||||||
|
121.61 ms (34.30%) |
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 365903 396302 403099 429409 483847 504927 530027 532132 538279 538562 544589 549112 554608 559044 559533 567319 574172 576609 608737 610826 615769 616530 616677 618184 620637 621454 622558 626169 627243 632316 636117 643792 650573 651167 660618 667244 668584 672676 678224 680853 688862 694138 695741 697441 698936 701388 709574 709587 714327 716517 716726 716916 716995 717227 717790 719120 719168 719352 721679 730602 731499 737051 738791 738856 738879 739664 741938 744536 746317 747263 749529 750208 752009 757503 760359 761114 762653 769053 769101 771253 771718 775778 775782 776241 782704 787285 787375 791333 791593 792285 795433 796410 797677 798682 801435 802824 804934 807372 808307 808427 811985 816193 817565 818241 819875 820087 821758 823667 824044 824534 825484 825989 826942 827838 827844 827885 827991 ] |
||||||||||||||||||||||||||||||
|
13.18 ms (3.72%) |
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 620637 816193 817565 819875 824044 823667 824534 825484 825989 821758 827838 827991 483847 530027 532132 538562 538279 544589 567319 694138 701388 716517 719168 651167 697441 709574 709587 716726 716995 721679 650573 668584 680853 695741 698936 714327 717227 554608 559533 576609 616530 616677 636117 618184 626169 643792 632316 615769 622558 776241 791333 792285 795433 775778 775782 798682 801435 804934 730602 746317 747263 760359 769053 787285 787375 807372 808307 739664 744536 750208 771718 738791 752009 762823 771253 749529 757503 762653 768738 731499 738856 738879 627243 716916 717790 719120 719352 775768 782704 797677 808427 811985 365903 429409 559044 608737 621454 504927 396302 403099 818241 826942 820087 827885 827844 574172 672676 678224 660618 667244 688862 549112 610826 791593 802824 796410 761114 741938 769101 737051 ] |
||||||||||||||||||||||||||||||
|
3.21 ms (0.91%) |
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 365903 396302 403099 429409 483847 504927 530027 532132 538279 538562 544589 549112 554608 559044 559533 567319 574172 576609 608737 610826 615769 616530 616677 618184 620637 621454 622558 626169 627243 632316 636117 643792 650573 651167 660618 667244 668584 672676 678224 680853 688862 694138 695741 697441 698936 701388 709574 709587 714327 716517 716726 716916 716995 717227 717790 719120 719168 719352 721679 730602 731499 737051 738791 738856 738879 739664 741938 744536 746317 747263 749529 750208 752009 757503 760359 761114 762653 769053 769101 771253 771718 775778 775782 776241 782704 787285 787375 791333 791593 792285 795433 796410 797677 798682 801435 802824 804934 807372 808307 808427 811985 816193 817565 818241 819875 820087 821758 823667 824044 824534 825484 825989 826942 827838 827844 827885 827991 ] |
||||||||||||||||||||||||||||||
|
2.43 ms (0.69%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"step girl"
]
|
||||||||||||||||||||||||||||||
|
1.83 ms (0.52%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"step девушк"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (0.51%) |
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.