Query Metrics
7
Database Queries
7
Different statements
349.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
328.23 ms (93.99%) |
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 188613 361679 384480 385434 396807 493578 525182 533188 536978 538538 540753 541107 548197 554153 558887 588790 595166 595186 597277 600660 601506 601521 602595 618080 629256 635303 635536 637798 640085 641263 641473 645529 645606 648931 660383 665986 667174 670902 692703 697484 697585 700177 715276 715627 716155 720356 721712 723724 723749 723750 724014 729086 730128 732999 733505 733530 734660 735275 735297 738317 739533 739636 739878 744379 745244 748958 749641 751504 755644 757278 757287 757315 762660 764279 766283 768706 768866 771052 772261 775678 778281 778601 778673 779263 779294 780705 781245 782044 785738 786015 787264 789515 791770 793017 794715 795777 795917 796689 799809 800481 800493 800818 801166 804693 804975 806129 807161 808991 809343 809660 811603 813211 813946 816183 819960 826165 827296 827395 827494 ] |
||||||||||||||||||||||||||||||
|
11.55 ms (3.31%) |
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 723749 739533 789515 795917 800493 809660 732999 757278 757315 771052 730128 735275 738317 744379 733505 748958 734660 745244 765782 768866 635536 637798 697585 700177 779263 782044 787264 800818 809343 811603 384480 618080 641473 361679 813946 396807 721712 385434 188613 819960 827296 827395 827494 816183 826165 493578 525182 538538 536978 540753 533188 541107 645606 667174 715627 645529 660383 670902 692703 720356 648931 665986 548197 554153 558887 601521 629256 595166 597277 600660 588790 601506 602595 641263 595186 775678 779294 780705 786015 794715 804693 804975 778281 778601 781245 807161 808991 723724 729086 749641 755644 757287 764279 768706 772261 785738 791770 793017 800481 801166 806129 813211 739636 762660 723750 724014 739878 733530 735297 751504 766283 635303 640085 697484 715276 716155 778673 795777 796689 799809 ] |
||||||||||||||||||||||||||||||
|
3.14 ms (0.90%) |
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 188613 361679 384480 385434 396807 493578 525182 533188 536978 538538 540753 541107 548197 554153 558887 588790 595166 595186 597277 600660 601506 601521 602595 618080 629256 635303 635536 637798 640085 641263 641473 645529 645606 648931 660383 665986 667174 670902 692703 697484 697585 700177 715276 715627 716155 720356 721712 723724 723749 723750 724014 729086 730128 732999 733505 733530 734660 735275 735297 738317 739533 739636 739878 744379 745244 748958 749641 751504 755644 757278 757287 757315 762660 764279 766283 768706 768866 771052 772261 775678 778281 778601 778673 779263 779294 780705 781245 782044 785738 786015 787264 789515 791770 793017 794715 795777 795917 796689 799809 800481 800493 800818 801166 804693 804975 806129 807161 808991 809343 809660 811603 813211 813946 816183 819960 826165 827296 827395 827494 ] |
||||||||||||||||||||||||||||||
|
1.98 ms (0.57%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"riding wife"
]
|
||||||||||||||||||||||||||||||
|
1.65 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"riding жен"
]
|
||||||||||||||||||||||||||||||
|
1.47 ms (0.42%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.22 ms (0.35%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"riding жен"
]
|
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.