Query Metrics
7
Database Queries
7
Different statements
166.61 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
135.00 ms (81.03%) |
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 190958 233340 381835 389729 390794 401005 410908 414953 418065 424646 428265 428840 430215 430287 430570 431481 434182 437555 443092 443428 443594 443760 443814 443981 444087 447749 447751 453039 454284 457654 457682 458005 461388 467149 470477 473133 476345 484591 485693 490167 490394 491160 491993 502702 509032 510503 510759 512050 515891 526477 526478 527669 529249 533998 534273 534336 536625 546113 546119 546687 548642 549977 550221 552650 552757 552758 554004 555176 558001 558844 560441 561692 563070 563141 563865 563930 565625 565632 566993 569970 570177 574417 576036 580665 582801 585158 586671 612490 614339 624122 626353 637400 650843 665386 668676 668949 675637 697892 699707 714748 720693 721795 726706 726718 726777 726846 731464 742871 772126 780724 788300 795041 796078 796135 798680 800936 803461 804215 807944 808603 ] |
||||||||||||||||||||||||||||||
|
21.07 ms (12.65%) |
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 668676 697892 665386 668949 546687 552650 552758 563141 565625 569970 586671 780724 788300 807944 742871 795041 800936 726706 726846 772126 726777 721795 796135 804215 424646 443594 447749 410908 434182 443428 458005 467149 428840 444087 453039 457654 457682 233340 390794 461388 470477 443760 443814 484591 490167 491993 510759 526477 491160 510503 526478 529249 430287 515891 554004 548642 560441 580665 563865 566993 624122 430570 527669 512050 190958 381835 401005 418065 430215 431481 443981 428265 437555 414953 485693 454284 473133 476345 490394 534336 534273 536625 502702 509032 533998 546113 565632 570177 546119 574417 550221 558001 558844 561692 563070 576036 675637 720693 650843 714748 549977 552757 555176 563930 582801 585158 612490 626353 637400 614339 798680 808603 726718 796078 803461 731464 699707 389729 443092 447751 ] |
||||||||||||||||||||||||||||||
|
3.00 ms (1.80%) |
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 190958 233340 381835 389729 390794 401005 410908 414953 418065 424646 428265 428840 430215 430287 430570 431481 434182 437555 443092 443428 443594 443760 443814 443981 444087 447749 447751 453039 454284 457654 457682 458005 461388 467149 470477 473133 476345 484591 485693 490167 490394 491160 491993 502702 509032 510503 510759 512050 515891 526477 526478 527669 529249 533998 534273 534336 536625 546113 546119 546687 548642 549977 550221 552650 552757 552758 554004 555176 558001 558844 560441 561692 563070 563141 563865 563930 565625 565632 566993 569970 570177 574417 576036 580665 582801 585158 586671 612490 614339 624122 626353 637400 650843 665386 668676 668949 675637 697892 699707 714748 720693 721795 726706 726718 726777 726846 731464 742871 772126 780724 788300 795041 796078 796135 798680 800936 803461 804215 807944 808603 ] |
||||||||||||||||||||||||||||||
|
2.41 ms (1.44%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"young sleep"
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.79 ms (1.07%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"young спящ"
]
|
||||||||||||||||||||||||||||||
|
1.54 ms (0.93%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"young спящ"
]
|
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.