Query Metrics
7
Database Queries
7
Different statements
224.69 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
200.84 ms (89.38%) |
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 204545 213932 381885 389657 391526 403086 413196 430543 440440 440962 451171 461974 469539 485078 486778 491436 516320 518438 529882 531679 531729 541304 542328 543483 549909 549943 550375 551891 557599 565148 574470 582216 590240 595050 596247 607000 616204 620646 631520 633473 634194 641053 645825 651786 660837 667447 670711 678228 683772 684314 686786 687199 687435 693350 700892 702178 703999 705115 711509 721488 722517 723392 723852 725290 725922 730242 730611 732667 734081 737547 738148 738178 739583 739737 742245 743292 743837 743934 744678 745646 745910 747124 749825 758136 758655 758830 761657 765972 766514 767366 771762 773193 773520 773815 774225 774547 776630 778369 779861 780750 785296 785716 786141 787766 789996 793077 794723 795405 796854 797559 799253 799377 799512 801191 803023 803100 803647 809253 810637 814127 ] |
||||||||||||||||||||||||||||||
|
13.94 ms (6.20%) |
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 557599 451171 440962 469539 430543 705115 491436 742245 738178 440440 590240 684314 702178 549909 574470 732667 730242 789996 722517 634194 595050 803647 773815 531679 549943 743934 703999 633473 801191 810637 743292 620646 529882 686786 693350 803100 774547 779861 739583 747124 758655 766514 803023 809253 745646 745910 738148 739737 786141 516320 778369 631520 543483 645825 771762 814127 796854 799512 765972 776630 787766 542328 582216 389657 403086 761657 767366 780750 381885 531729 541304 651786 687199 687435 721488 723392 551891 797559 785296 795405 723852 785716 737547 734081 743837 744678 711509 518438 725922 213932 485078 550375 678228 730611 749825 413196 700892 660837 670711 683772 641053 799377 793077 725290 607000 461974 204545 391526 486778 565148 667447 596247 794723 799253 773520 758830 773193 774225 758136 616204 ] |
||||||||||||||||||||||||||||||
|
3.13 ms (1.39%) |
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 204545 213932 381885 389657 391526 403086 413196 430543 440440 440962 451171 461974 469539 485078 486778 491436 516320 518438 529882 531679 531729 541304 542328 543483 549909 549943 550375 551891 557599 565148 574470 582216 590240 595050 596247 607000 616204 620646 631520 633473 634194 641053 645825 651786 660837 667447 670711 678228 683772 684314 686786 687199 687435 693350 700892 702178 703999 705115 711509 721488 722517 723392 723852 725290 725922 730242 730611 732667 734081 737547 738148 738178 739583 739737 742245 743292 743837 743934 744678 745646 745910 747124 749825 758136 758655 758830 761657 765972 766514 767366 771762 773193 773520 773815 774225 774547 776630 778369 779861 780750 785296 785716 786141 787766 789996 793077 794723 795405 796854 797559 799253 799377 799512 801191 803023 803100 803647 809253 810637 814127 ] |
||||||||||||||||||||||||||||||
|
2.09 ms (0.93%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"нов секс"
]
|
||||||||||||||||||||||||||||||
|
1.77 ms (0.79%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.69 ms (0.75%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"нови секс 2023"
]
|
||||||||||||||||||||||||||||||
|
1.24 ms (0.55%) |
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.