Query Metrics
7
Database Queries
7
Different statements
436.89 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
411.28 ms (94.14%) |
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 210281 384015 391792 410292 457744 474507 485929 487896 489728 503954 529057 530257 533771 550914 551993 552928 564660 577602 581739 585157 585595 587268 588483 590029 590328 592149 596944 597903 608545 609107 610422 616604 617074 620938 621548 627690 634697 652278 653006 653009 662076 668085 668099 673187 680597 685432 686321 694565 696198 702639 704478 711358 714799 716570 718868 720235 720612 722058 724027 731197 731361 733041 734185 734277 737126 740173 744210 744834 748263 750314 755780 760551 761484 761634 761883 764060 765063 765327 765518 767193 768472 768660 769683 770982 771442 773621 775416 776042 780883 783887 784267 784357 784735 787252 789273 791235 791246 791538 792258 793202 794168 794909 796244 798834 799659 802166 803026 803651 804872 804902 805533 806849 806965 808048 809745 813667 815952 819870 820159 ] |
||||||||||||||||||||||||||||||
|
13.96 ms (3.20%) |
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 731361 761883 773621 627690 722058 776042 780883 789273 791235 802166 806849 410292 820159 533771 680597 702639 714799 662076 581739 590328 587268 787252 791538 798834 792258 734185 761484 784357 794909 796244 744834 765327 734277 744210 775416 474507 391792 457744 384015 210281 552928 551993 815952 813667 819870 485929 489728 487896 503954 529057 530257 550914 577602 652278 668085 673187 696198 704478 711358 716570 718868 720235 694565 653006 653009 668099 685432 686321 720612 564660 592149 597903 608545 634697 588483 609107 610422 621548 585157 585595 590029 616604 596944 620938 783887 784267 804872 784735 791246 805533 806965 809745 724027 750314 761634 765518 768660 794168 799659 803026 804902 740173 748263 765063 771442 731197 733041 755780 768472 737126 762399 764060 767193 760551 769683 770982 617074 793202 803651 808048 ] |
||||||||||||||||||||||||||||||
|
3.02 ms (0.69%) |
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 210281 384015 391792 410292 457744 474507 485929 487896 489728 503954 529057 530257 533771 550914 551993 552928 564660 577602 581739 585157 585595 587268 588483 590029 590328 592149 596944 597903 608545 609107 610422 616604 617074 620938 621548 627690 634697 652278 653006 653009 662076 668085 668099 673187 680597 685432 686321 694565 696198 702639 704478 711358 714799 716570 718868 720235 720612 722058 724027 731197 731361 733041 734185 734277 737126 740173 744210 744834 748263 750314 755780 760551 761484 761634 761883 764060 765063 765327 765518 767193 768472 768660 769683 770982 771442 773621 775416 776042 780883 783887 784267 784357 784735 787252 789273 791235 791246 791538 792258 793202 794168 794909 796244 798834 799659 802166 803026 803651 804872 804902 805533 806849 806965 808048 809745 813667 815952 819870 820159 ] |
||||||||||||||||||||||||||||||
|
2.69 ms (0.61%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
2.39 ms (0.55%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"sex real"
]
|
||||||||||||||||||||||||||||||
|
1.93 ms (0.44%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"секс real"
]
|
||||||||||||||||||||||||||||||
|
1.61 ms (0.37%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"секс real"
]
|
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.