Query Metrics
7
Database Queries
7
Different statements
368.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
213.32 ms (57.86%) |
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 425415 441409 441472 441829 443541 452553 468676 473825 485234 494316 506283 507789 528346 533672 537283 542340 549126 567946 576865 579494 580606 582096 583086 584074 584191 590839 593779 604178 615058 615829 618055 634735 639377 642563 644149 652276 655239 656489 661678 664712 665631 667167 668387 675638 681709 685074 685097 693857 693918 710033 710393 711278 713159 714427 715028 717070 719370 719916 720052 722148 722268 722372 722445 724519 726135 726888 730392 732710 732988 734966 734970 735591 736348 743654 743732 744365 745227 745878 748481 750156 750854 756354 757795 758593 758824 759603 762809 764911 765060 766863 771912 773419 773424 775043 775119 775382 778198 779730 781327 785296 789774 790039 793872 794936 796921 797093 798033 802207 813748 817246 817470 818097 823645 823839 823947 825028 825227 825534 825732 ] |
||||||||||||||||||||||||||||||
|
134.23 ms (36.41%) |
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 425415 441409 441472 441829 443541 452553 468676 473825 485234 494316 506283 507789 528346 533672 537283 542340 549126 567946 576865 579494 580606 582096 583086 584074 584191 590839 593779 604178 615058 615829 618055 634735 639377 642563 644149 652276 655239 656489 661678 664712 665631 667167 668387 675638 681709 685074 685097 693857 693918 710033 710393 711278 713159 714427 715028 717070 719370 719916 720052 722148 722268 722372 722445 724519 726135 726888 730392 732710 732988 734966 734970 735591 736348 743654 743732 744365 745227 745878 748481 750156 750854 756354 757795 758593 758824 759603 762809 764911 765060 766863 771912 773419 773424 775043 775119 775382 778198 779730 781327 785296 789774 790039 793872 794936 796921 797093 798033 802207 813748 817246 817470 818097 823645 823839 823947 825028 825227 825534 825732 ] |
||||||||||||||||||||||||||||||
|
13.84 ms (3.75%) |
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 507789 665631 732710 615829 452553 825732 722372 773419 818097 825709 722445 506283 710033 817470 825227 726135 825534 473825 576865 590839 567946 656489 655239 693918 714427 715028 744365 745878 710393 441829 823947 825028 722268 735591 764911 775119 528346 593779 759603 720052 675638 441409 468676 549126 425415 661678 685074 693857 584191 604178 642563 797093 732988 771912 618055 681709 823839 719370 793872 790039 773424 743732 748481 765060 441472 823645 778198 796921 785296 798033 789774 794936 766863 734970 537283 494316 533672 542340 584074 583086 685097 652276 664712 668387 667167 582096 634735 639377 644149 615058 711278 443541 580606 579494 713159 775043 775382 779730 726888 750854 734966 745227 758824 730392 736348 762809 724519 743654 719916 485234 817246 813748 717070 722148 781327 750156 802207 758593 757795 756354 ] |
||||||||||||||||||||||||||||||
|
2.25 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"amateur screaming"
]
|
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.45%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"любительск крича вперв"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.43%) |
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.