Query Metrics
7
Database Queries
7
Different statements
360.05 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
209.56 ms (58.20%) |
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 391966 442795 466408 486118 489222 523611 533752 544161 549503 563762 564549 575621 579719 583323 586146 586253 588433 589644 590465 600279 604837 610830 611284 687942 718053 719284 722083 724535 725301 728393 730361 734301 734574 741866 743793 763972 764026 764505 766451 767688 768200 769135 769207 769616 773339 778291 778592 781153 782493 783802 784237 787459 787822 788644 788733 788761 789152 789365 789643 790946 791449 791606 791817 792298 793955 794262 794580 794595 794721 794957 795338 795353 796257 797037 802292 803213 803738 803871 803943 805455 807857 808279 810318 811086 811546 813638 813936 814106 817201 817555 817588 818766 819040 819172 819728 819733 819916 819944 820215 821757 821758 821776 823571 823600 823763 824003 824086 824777 824792 824852 825035 825090 825350 825425 826155 827010 827220 827492 827562 ] |
||||||||||||||||||||||||||||||
|
132.99 ms (36.94%) |
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 391966 442795 466408 486118 489222 523611 533752 544161 549503 563762 564549 575621 579719 583323 586146 586253 588433 589644 590465 600279 604837 610830 611284 687942 718053 719284 722083 724535 725301 728393 730361 734301 734574 741866 743793 763972 764026 764505 766451 767688 768200 769135 769207 769616 773339 778291 778592 781153 782493 783802 784237 787459 787822 788644 788733 788761 789152 789365 789643 790946 791449 791606 791817 792298 793955 794262 794580 794595 794721 794957 795338 795353 796257 797037 802292 803213 803738 803871 803943 805455 807857 808279 810318 811086 811546 813638 813936 814106 817201 817555 817588 818766 819040 819172 819728 819733 819916 819944 820215 821757 821758 821776 823571 823600 823763 824003 824086 824777 824792 824852 825035 825090 825350 825425 826155 827010 827220 827492 827562 ] |
||||||||||||||||||||||||||||||
|
9.66 ms (2.68%) |
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 778592 794957 725301 768200 730361 763806 769616 813936 533752 564549 579719 549503 590465 810318 807857 600279 391966 819728 814106 824086 803213 767688 781153 784237 793955 687942 563762 604837 586253 588433 611284 589644 486118 734301 803943 769135 791449 811546 575621 583323 442795 610830 489222 466408 586146 818766 819040 824003 824792 813638 826155 823763 817555 819916 823571 824852 825090 825350 827010 827220 827492 821757 821758 819733 825035 523611 544161 719284 782493 783802 788733 788761 789152 789365 791606 811086 763972 766451 769207 787459 788644 794580 802292 724535 741866 728393 764505 773339 764026 734574 743793 718053 722083 778291 787822 794721 795353 796257 797037 803738 803871 817588 825425 821776 823600 827562 819172 817201 819944 820215 824777 789643 792298 808279 791817 794262 794595 790946 795338 805455 ] |
||||||||||||||||||||||||||||||
|
2.37 ms (0.66%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.20 ms (0.61%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade milf pov"
]
|
||||||||||||||||||||||||||||||
|
1.68 ms (0.47%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск milf пов"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск milf пов"
]
|
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.