Query Metrics
7
Database Queries
7
Different statements
402.18 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
210.65 ms (52.38%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск teens couple"
]
|
||||||||||||||||||||||||||||||
|
171.40 ms (42.62%) |
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 73774 391492 398239 455746 481088 496385 516061 516738 530615 538167 550546 567471 567933 590654 591939 592542 594359 607055 615175 621633 626187 628027 629441 635647 638524 641200 652119 663314 667820 670079 681795 683359 685259 690925 692154 693435 693437 694164 694175 696281 697675 699162 700707 700816 701030 701400 702350 704432 704434 705008 706439 707298 707774 710027 714219 714693 718356 720987 722440 725659 725766 730589 730792 730829 730840 730974 735185 737213 737240 738052 745876 745899 748841 748844 749779 749997 755066 759051 760219 760510 762019 766253 766303 767635 767678 768544 768565 772868 773473 775407 776679 777258 777949 778175 786158 789097 789499 790718 791795 792028 793557 793860 794145 794523 795186 795223 796533 796761 804917 811209 812086 812264 813456 813881 813885 818844 820028 825529 825867 ] |
||||||||||||||||||||||||||||||
|
11.39 ms (2.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 621633 391492 737240 707774 700707 789499 737213 700816 812086 455746 592542 481088 693435 714219 730829 811209 607055 722440 766253 792028 820028 777949 735185 701030 626187 635647 730840 773473 778175 760510 73774 818844 516738 530615 692154 496385 768565 796533 795223 730792 793860 748841 567933 628027 641200 796761 707298 714693 629441 591939 615175 777258 690925 697675 694175 704434 704432 590654 594359 825867 567471 702350 720987 749997 516061 550546 681795 696281 705008 706439 718356 652119 667820 775407 755066 730974 748844 738052 745899 772868 701400 813881 694164 786158 804917 768748 794145 794523 749779 762019 759051 725766 791795 670079 398239 813885 693437 699162 638524 760219 776679 793557 685259 790718 812264 767678 789097 766303 795186 813456 768544 825529 538167 710027 683359 767635 730589 745876 725659 663314 ] |
||||||||||||||||||||||||||||||
|
2.72 ms (0.68%) |
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 73774 391492 398239 455746 481088 496385 516061 516738 530615 538167 550546 567471 567933 590654 591939 592542 594359 607055 615175 621633 626187 628027 629441 635647 638524 641200 652119 663314 667820 670079 681795 683359 685259 690925 692154 693435 693437 694164 694175 696281 697675 699162 700707 700816 701030 701400 702350 704432 704434 705008 706439 707298 707774 710027 714219 714693 718356 720987 722440 725659 725766 730589 730792 730829 730840 730974 735185 737213 737240 738052 745876 745899 748841 748844 749779 749997 755066 759051 760219 760510 762019 766253 766303 767635 767678 768544 768565 772868 773473 775407 776679 777258 777949 778175 786158 789097 789499 790718 791795 792028 793557 793860 794145 794523 795186 795223 796533 796761 804917 811209 812086 812264 813456 813881 813885 818844 820028 825529 825867 ] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur teens couple"
]
|
||||||||||||||||||||||||||||||
|
2.05 ms (0.51%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.75 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"любительск teens couple"
]
|
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.