Query Metrics
7
Database Queries
7
Different statements
1248.04 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
638.32 ms (51.15%) |
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 402649 448414 445323 511895 525546 544150 484129 545444 595845 819758 823751 783089 793511 706847 780932 733681 750816 826100 820170 555753 767694 722121 799378 533980 535576 649071 797419 723754 728841 775509 437509 398355 677377 677127 788470 799899 772792 783463 787419 811426 767061 768611 762493 792463 388176 818091 650683 595020 793786 787918 797926 747972 762525 726246 748026 746488 723556 533338 648378 676430 781060 726221 764912 765078 728775 755485 434587 652273 669693 692993 719727 628638 637605 606933 621433 790072 774819 765083 726369 765118 638048 710679 794361 446999 723485 591957 733534 772350 719131 785109 511490 498500 551005 557567 579213 562541 567359 656264 695828 558081 642211 636503 776548 796435 725425 765112 760895 767769 608037 811635 444262 469304 416019 448092 511698 403357 425497 442663 451614 456476 ] |
||||||||||||||||||||||||||||||
|
216.38 ms (17.34%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"best ever"
]
|
||||||||||||||||||||||||||||||
|
212.25 ms (17.01%) |
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 388176 398355 402649 403357 416019 425497 434587 437509 442663 444262 445323 446999 448092 448414 451614 456476 469304 484129 498500 511490 511698 511895 525546 533338 533980 535576 544150 545444 551005 555753 557567 562541 567359 579213 591957 595020 595845 606933 608037 621433 628638 636503 637605 638048 642211 648378 649071 650683 652273 656264 669693 676430 677127 677377 692993 695828 706847 710679 719131 719727 722121 723485 723556 723754 725425 726221 726246 726369 728775 728841 733534 733681 746488 747972 748026 750816 755485 760895 762493 762525 764912 765078 765083 765112 765118 767061 767694 767769 768611 772350 772792 774819 775509 776548 780932 781060 783089 783463 785109 787419 787918 788470 790072 792463 793511 793786 794361 796435 797419 797926 799378 799899 811426 811635 818091 819758 820170 823751 826100 ] |
||||||||||||||||||||||||||||||
|
175.14 ms (14.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 388176 398355 402649 403357 416019 425497 434587 437509 442663 444262 445323 446999 448092 448414 451614 456476 469304 484129 498500 511490 511698 511895 525546 533338 533980 535576 544150 545444 551005 555753 557567 562541 567359 579213 591957 595020 595845 606933 608037 621433 628638 636503 637605 638048 642211 648378 649071 650683 652273 656264 669693 676430 677127 677377 692993 695828 706847 710679 719131 719727 722121 723485 723556 723754 725425 726221 726246 726369 728775 728841 733534 733681 746488 747972 748026 750816 755485 760895 762493 762525 764912 765078 765083 765112 765118 767061 767694 767769 768611 772350 772792 774819 775509 776548 780932 781060 783089 783463 785109 787419 787918 788470 790072 792463 793511 793786 794361 796435 797419 797926 799378 799899 811426 811635 818091 819758 820170 823751 826100 ] |
||||||||||||||||||||||||||||||
|
2.13 ms (0.17%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"best of ever"
]
|
||||||||||||||||||||||||||||||
|
1.92 ms (0.15%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.90 ms (0.15%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"best ever"
]
|
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.