Query Metrics
7
Database Queries
7
Different statements
159.48 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
133.25 ms (83.55%) |
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 459276 459631 462192 483990 489881 508171 526870 530987 534094 535311 536750 539173 539229 541003 543664 543704 545734 546310 547672 548100 549616 552651 552657 558254 559406 564521 566267 569633 570143 575341 576201 576983 583528 587479 588167 589621 590847 598360 599314 600165 605713 613435 620637 624161 624617 626685 629174 630039 630395 631220 636893 636943 636960 640098 641250 643462 646129 649244 649361 649688 653322 655288 655304 657193 657217 657561 658840 660048 660341 660461 660738 666857 667087 667913 668086 668343 668585 669282 670014 670727 670737 671255 671898 679248 679262 680816 685434 686414 690218 690285 690933 692032 696142 696404 697187 698091 700546 701018 702656 702667 706520 707164 707311 708867 711147 711802 728675 738256 739098 740206 750947 763020 778966 788491 789576 791521 794889 795119 804496 ] |
||||||||||||||||||||||||||||||
|
15.92 ms (9.98%) |
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 626685 738256 788491 508171 541003 543704 545734 666857 750947 795119 667913 489881 536750 660048 671898 570143 660738 670727 711802 685434 483990 660341 649244 646129 636943 462192 576201 680816 543664 549616 679248 690933 653322 668585 670737 692032 696142 789576 768728 548100 539229 539173 552651 547672 576983 668343 690285 700546 670014 671255 657217 667087 696404 569633 600165 624161 624617 599314 605713 643462 631220 740206 702667 707311 708867 686414 640098 641250 526870 566267 558254 655288 657561 658840 668086 679262 711147 698091 702656 649361 655304 669282 707164 546310 552657 583528 587479 589621 613435 629174 588167 598360 630395 636893 739098 620637 630039 706520 559406 804496 794889 778966 459276 459631 791521 728675 763020 530987 534094 535311 564521 575341 649688 657193 660461 690218 701018 697187 636960 590847 ] |
||||||||||||||||||||||||||||||
|
2.51 ms (1.57%) |
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 459276 459631 462192 483990 489881 508171 526870 530987 534094 535311 536750 539173 539229 541003 543664 543704 545734 546310 547672 548100 549616 552651 552657 558254 559406 564521 566267 569633 570143 575341 576201 576983 583528 587479 588167 589621 590847 598360 599314 600165 605713 613435 620637 624161 624617 626685 629174 630039 630395 631220 636893 636943 636960 640098 641250 643462 646129 649244 649361 649688 653322 655288 655304 657193 657217 657561 658840 660048 660341 660461 660738 666857 667087 667913 668086 668343 668585 669282 670014 670727 670737 671255 671898 679248 679262 680816 685434 686414 690218 690285 690933 692032 696142 696404 697187 698091 700546 701018 702656 702667 706520 707164 707311 708867 711147 711802 728675 738256 739098 740206 750947 763020 778966 788491 789576 791521 794889 795119 804496 ] |
||||||||||||||||||||||||||||||
|
2.14 ms (1.34%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"молоденькая домашнее …"
]
|
||||||||||||||||||||||||||||||
|
1.97 ms (1.23%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.19%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"молодая девушк домашн любительск"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.13%) |
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.