Query Metrics
7
Database Queries
7
Different statements
194.39 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
164.82 ms (84.79%) |
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 346141 383599 400735 401799 409334 411896 434314 437484 454531 466564 467908 471088 473410 479816 492716 499089 502776 510592 511372 524792 527085 528641 531181 531223 534734 539416 539607 547802 557873 560021 573760 577058 584267 599865 600021 600252 600268 600360 604891 604909 605909 610039 629965 632650 639751 639767 639823 641978 644986 647344 647948 648241 666894 669860 681131 685701 699538 704557 705253 705262 707389 708465 711771 718746 718768 718793 720717 721750 735404 736294 739820 756614 759847 761570 765683 765836 766335 774575 787408 789710 789954 794934 795820 796957 800293 800656 800672 800706 801206 801369 801416 804098 805490 805564 805935 806653 806973 807589 808450 808625 808665 810896 812626 813003 813706 814114 814852 815031 815038 815317 815448 815585 816057 816292 818371 819594 820151 826715 826971 827080 ] |
||||||||||||||||||||||||||||||
|
18.42 ms (9.47%) |
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 815317 813706 815448 818371 534734 584267 718746 789710 800672 800656 801206 805935 806653 735404 705253 705262 718793 804098 814114 699538 795820 466564 511372 604891 796957 473410 708465 644986 647948 685701 648241 666894 600252 600021 600360 599865 639767 820151 826971 815585 720717 605909 812626 805564 801416 810896 756614 739820 765683 632650 721750 813003 531181 547802 807589 531223 639823 401799 499089 527085 434314 711771 604909 437484 502776 801369 808665 759847 346141 826715 819594 827080 816057 557873 681131 707389 789954 800706 806973 787408 808450 761570 765836 629965 718768 774575 805490 411896 409334 815038 539416 704557 560021 577058 800293 528641 600268 471088 479816 524792 669860 794934 736294 573760 610039 766335 647344 639751 641978 383599 467908 454531 492716 539607 808625 510592 400735 816292 814852 815031 ] |
||||||||||||||||||||||||||||||
|
3.98 ms (2.05%) |
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 346141 383599 400735 401799 409334 411896 434314 437484 454531 466564 467908 471088 473410 479816 492716 499089 502776 510592 511372 524792 527085 528641 531181 531223 534734 539416 539607 547802 557873 560021 573760 577058 584267 599865 600021 600252 600268 600360 604891 604909 605909 610039 629965 632650 639751 639767 639823 641978 644986 647344 647948 648241 666894 669860 681131 685701 699538 704557 705253 705262 707389 708465 711771 718746 718768 718793 720717 721750 735404 736294 739820 756614 759847 761570 765683 765836 766335 774575 787408 789710 789954 794934 795820 796957 800293 800656 800672 800706 801206 801369 801416 804098 805490 805564 805935 806653 806973 807589 808450 808625 808665 810896 812626 813003 813706 814114 814852 815031 815038 815317 815448 815585 816057 816292 818371 819594 820151 826715 826971 827080 ] |
||||||||||||||||||||||||||||||
|
2.07 ms (1.06%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сквирт милф"
]
|
||||||||||||||||||||||||||||||
|
1.86 ms (0.96%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм милф"
]
|
||||||||||||||||||||||||||||||
|
1.82 ms (0.94%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм милф"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.74%) |
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.