Query Metrics
7
Database Queries
7
Different statements
175.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
154.90 ms (88.38%) |
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 3607 391718 398554 456679 457011 504044 515203 525890 530594 536186 536313 536530 536670 537826 538068 538798 554452 557005 561864 567988 570688 571730 574198 574207 574233 577561 577813 583330 588471 589655 592292 593983 596660 596662 598894 603136 603519 603617 608091 614802 615612 615937 616491 618187 618603 622427 622579 623943 624078 625065 627265 628569 628795 628811 630155 630389 636349 639236 639942 641006 642951 648722 651588 654881 655184 655214 657536 657860 661665 667242 669606 672800 673868 673877 676196 678185 679296 679304 679305 682647 684812 687093 687374 690530 692641 693301 693881 694585 700052 700737 701526 702137 702382 702672 704942 705040 705054 705102 708350 709535 710439 711273 712625 713684 727915 738314 740166 742549 746710 748639 749878 761384 764692 767381 787948 794990 795387 810587 814490 ] |
||||||||||||||||||||||||||||||
|
11.09 ms (6.33%) |
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 787948 795387 810587 628811 504044 608091 639236 536670 530594 536313 537826 538068 538798 536186 536530 554452 574233 574207 583330 557005 571730 651588 655184 678185 679304 679305 684812 687093 690530 693301 700052 702382 702672 705102 709535 712625 655214 657860 667242 669606 672800 679296 682647 687374 693881 701526 704942 705040 705054 711273 654881 657536 661665 676196 692641 702137 713684 596662 614802 615937 628795 630155 592292 603519 618603 639942 589655 593983 596660 598894 603617 628569 630389 636349 588471 603136 615612 616491 622579 627265 642951 727915 761384 738314 618187 622427 625065 641006 700737 710439 561864 574198 694585 742549 515203 525890 748639 749878 764692 624078 3607 457011 531288 577561 648722 577813 623943 794990 746710 767381 740166 456679 708350 673868 673877 567988 570688 391718 398554 814490 ] |
||||||||||||||||||||||||||||||
|
2.70 ms (1.54%) |
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 3607 391718 398554 456679 457011 504044 515203 525890 530594 536186 536313 536530 536670 537826 538068 538798 554452 557005 561864 567988 570688 571730 574198 574207 574233 577561 577813 583330 588471 589655 592292 593983 596660 596662 598894 603136 603519 603617 608091 614802 615612 615937 616491 618187 618603 622427 622579 623943 624078 625065 627265 628569 628795 628811 630155 630389 636349 639236 639942 641006 642951 648722 651588 654881 655184 655214 657536 657860 661665 667242 669606 672800 673868 673877 676196 678185 679296 679304 679305 682647 684812 687093 687374 690530 692641 693301 693881 694585 700052 700737 701526 702137 702382 702672 704942 705040 705054 705102 708350 709535 710439 711273 712625 713684 727915 738314 740166 742549 746710 748639 749878 761384 764692 767381 787948 794990 795387 810587 814490 ] |
||||||||||||||||||||||||||||||
|
1.80 ms (1.03%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"homemade old"
]
|
||||||||||||||||||||||||||||||
|
1.69 ms (0.96%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.66 ms (0.95%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"домашн любительск old"
]
|
||||||||||||||||||||||||||||||
|
1.43 ms (0.81%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"домашн любительск old"
]
|
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.