Query Metrics
7
Database Queries
7
Different statements
217.45 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
187.44 ms (86.20%) |
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 409035 415539 419061 424780 425050 439543 440625 443389 446386 452823 455217 460618 468019 468754 469738 472124 476778 482507 494081 495376 502043 505763 507123 509821 510396 511272 521738 523027 526887 527641 530011 531155 531524 532812 533426 534994 535019 535358 536288 537863 546804 547751 547756 547774 547779 555991 557295 560203 560227 565153 566761 567022 569379 583913 583982 584738 586411 597216 597908 599988 603258 609085 612061 623262 633502 634784 639745 643380 644436 646034 650155 653720 653730 666650 666850 666906 667974 675008 675010 676638 678153 708226 710868 716160 730073 734484 734807 739556 742457 748504 749577 750739 758330 768258 778781 779986 779996 784106 786598 789469 791516 791738 792713 793056 794375 794442 795720 797009 797443 801883 803455 807591 808226 811365 815471 817008 817047 818327 822707 826720 ] |
||||||||||||||||||||||||||||||
|
18.13 ms (8.34%) |
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 482507 510396 537863 560203 560227 666906 676638 678153 603258 609085 803455 634784 826720 817008 817047 797009 749577 811365 557295 443389 446386 460618 468019 511272 531524 535358 536288 791738 468754 472124 409035 742457 507123 716160 786598 452823 646034 584738 778781 734807 801883 533426 531155 532812 675010 650155 583982 639745 623262 502043 523027 419061 469738 455217 521738 530011 555991 566761 612061 439543 643380 822707 818327 547774 644436 586411 597908 789469 807591 795720 710868 793056 730073 567022 653720 653730 808226 750739 758330 739556 535019 583913 667974 784106 505763 734484 534994 546804 666850 675008 597216 633502 494081 666650 779986 797443 791516 748504 779996 794375 509821 495376 569379 792713 794442 415539 565153 425050 547756 527641 526887 708226 768258 440625 424780 599988 815471 476778 547751 547779 ] |
||||||||||||||||||||||||||||||
|
3.35 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 409035 415539 419061 424780 425050 439543 440625 443389 446386 452823 455217 460618 468019 468754 469738 472124 476778 482507 494081 495376 502043 505763 507123 509821 510396 511272 521738 523027 526887 527641 530011 531155 531524 532812 533426 534994 535019 535358 536288 537863 546804 547751 547756 547774 547779 555991 557295 560203 560227 565153 566761 567022 569379 583913 583982 584738 586411 597216 597908 599988 603258 609085 612061 623262 633502 634784 639745 643380 644436 646034 650155 653720 653730 666650 666850 666906 667974 675008 675010 676638 678153 708226 710868 716160 730073 734484 734807 739556 742457 748504 749577 750739 758330 768258 778781 779986 779996 784106 786598 789469 791516 791738 792713 793056 794375 794442 795720 797009 797443 801883 803455 807591 808226 811365 815471 817008 817047 818327 822707 826720 ] |
||||||||||||||||||||||||||||||
|
2.29 ms (1.05%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"сквирт милф"
]
|
||||||||||||||||||||||||||||||
|
2.15 ms (0.99%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"сквирт оргазм милф"
]
|
||||||||||||||||||||||||||||||
|
2.12 ms (0.97%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"сквирт оргазм милф"
]
|
||||||||||||||||||||||||||||||
|
1.98 ms (0.91%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
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.