Query Metrics
7
Database Queries
7
Different statements
191.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
168.06 ms (87.72%) |
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 387489 395367 453210 475615 486869 496865 502816 506277 527140 529764 531984 532048 535003 540075 540127 540174 540707 542211 542427 546617 547406 548895 550511 553155 553545 553753 554698 554708 554735 555301 557766 558894 559970 560414 560912 561044 563971 563977 574077 575868 583755 584864 586615 592118 595306 600668 601648 602964 605632 606992 632471 634363 636726 641298 653691 654006 660442 661028 668733 673935 687778 694420 695495 696287 697878 700818 703689 708320 711695 713423 714594 715133 715621 716148 718908 724754 735183 737998 738891 745335 746057 748627 764104 766929 767718 769197 786136 786320 787392 790712 792425 793563 793602 795108 796971 798745 800436 811541 816666 817214 817277 818109 818128 818750 819112 819527 819811 819940 820026 823725 823888 824274 825035 825191 825824 825904 825925 826321 826544 827547 ] |
||||||||||||||||||||||||||||||
|
11.83 ms (6.17%) |
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 703689 560912 636726 786320 738891 767718 746057 715133 793563 823888 823725 820026 825191 819112 824274 529764 540174 506277 532048 546617 557766 584864 560414 668733 711695 563971 634363 601648 793602 737998 748627 766929 745335 769197 724754 735183 764104 632471 387489 475615 502816 527140 558894 550511 553545 586615 602964 496865 486869 660442 700818 654006 694420 605632 595306 395367 825925 826544 825904 816666 817214 817277 818109 818128 819940 827547 819811 825824 818750 819527 825035 826321 453210 540707 540127 531984 540075 535003 542211 554698 554735 575868 542427 553753 561044 574077 583755 548895 553155 554708 563977 653691 697878 718908 661028 687778 714594 716148 673935 695495 696287 708320 713423 715621 547406 555301 559970 600668 641298 592118 606992 787392 792425 798745 800436 811541 786136 790712 795108 796971 ] |
||||||||||||||||||||||||||||||
|
3.79 ms (1.98%) |
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 387489 395367 453210 475615 486869 496865 502816 506277 527140 529764 531984 532048 535003 540075 540127 540174 540707 542211 542427 546617 547406 548895 550511 553155 553545 553753 554698 554708 554735 555301 557766 558894 559970 560414 560912 561044 563971 563977 574077 575868 583755 584864 586615 592118 595306 600668 601648 602964 605632 606992 632471 634363 636726 641298 653691 654006 660442 661028 668733 673935 687778 694420 695495 696287 697878 700818 703689 708320 711695 713423 714594 715133 715621 716148 718908 724754 735183 737998 738891 745335 746057 748627 764104 766929 767718 769197 786136 786320 787392 790712 792425 793563 793602 795108 796971 798745 800436 811541 816666 817214 817277 818109 818128 818750 819112 819527 819811 819940 820026 823725 823888 824274 825035 825191 825824 825904 825925 826321 826544 827547 ] |
||||||||||||||||||||||||||||||
|
2.18 ms (1.14%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"жен туалет"
]
|
||||||||||||||||||||||||||||||
|
2.00 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"жену в туалет"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (1.01%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.81 ms (0.94%) |
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.