Query Metrics
7
Database Queries
7
Different statements
157.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.94 ms (86.47%) |
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 393248 396021 424072 437767 453747 489916 506963 508394 513323 531396 533829 539226 560259 564533 584961 600328 610052 614035 617213 617807 620255 620662 621086 625026 632128 633577 639571 641569 645761 646077 646244 648612 650100 650344 652979 655214 655241 657228 666398 668662 669967 672968 675193 683052 685433 692517 695690 699602 701282 710837 712213 715774 716719 717432 719731 719797 719799 722701 723566 726082 726143 727785 727792 727969 729657 734708 740603 740791 740893 740997 741035 742239 744656 747674 751728 753966 756661 758237 758528 762041 762436 763460 763537 768727 769423 772404 773084 773463 777851 777861 778757 779507 781624 783744 788334 789436 791233 792335 793765 793774 794957 795074 798629 799324 799898 800199 801524 801921 802852 802880 803277 804526 805527 809329 810624 811653 811735 812053 813953 814521 ] |
||||||||||||||||||||||||||||||
|
10.87 ms (6.92%) |
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 424072 396021 506963 533829 675193 685433 648612 672968 683052 701282 710837 719799 560259 639571 779507 801921 783744 794957 740893 753966 795074 802880 803277 809329 811735 747674 762041 729657 727969 740603 758237 621086 712213 715774 793774 437767 393248 813953 489916 531396 692517 695690 717432 650100 650344 666398 722701 668662 719797 610052 793765 798629 804526 778757 802852 768727 772404 788334 799324 811653 762436 751728 763460 741035 763537 726082 734708 740791 769423 773084 617807 632128 719731 777851 777861 792335 799898 800199 810624 814521 508394 513323 564533 646244 669967 614035 620255 600328 617213 791233 801524 758528 805527 742239 773463 727792 726143 727785 740997 744656 756661 625026 699602 716719 781624 789436 812053 723566 453747 539226 645761 657228 655214 646077 652979 655241 584961 641569 620662 633577 ] |
||||||||||||||||||||||||||||||
|
3.12 ms (1.98%) |
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 393248 396021 424072 437767 453747 489916 506963 508394 513323 531396 533829 539226 560259 564533 584961 600328 610052 614035 617213 617807 620255 620662 621086 625026 632128 633577 639571 641569 645761 646077 646244 648612 650100 650344 652979 655214 655241 657228 666398 668662 669967 672968 675193 683052 685433 692517 695690 699602 701282 710837 712213 715774 716719 717432 719731 719797 719799 722701 723566 726082 726143 727785 727792 727969 729657 734708 740603 740791 740893 740997 741035 742239 744656 747674 751728 753966 756661 758237 758528 762041 762436 763460 763537 768727 769423 772404 773084 773463 777851 777861 778757 779507 781624 783744 788334 789436 791233 792335 793765 793774 794957 795074 798629 799324 799898 800199 801524 801921 802852 802880 803277 804526 805527 809329 810624 811653 811735 812053 813953 814521 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (1.36%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"глубокий секс"
]
|
||||||||||||||||||||||||||||||
|
1.90 ms (1.21%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"глубок секс"
]
|
||||||||||||||||||||||||||||||
|
1.72 ms (1.09%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.53 ms (0.97%) |
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.