Query Metrics
7
Database Queries
7
Different statements
156.94 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
128.62 ms (81.95%) |
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 394351 418513 418665 422421 429259 438486 458628 474057 489155 492016 500444 514976 515227 527165 533763 534111 536217 536825 537822 539707 540181 540412 543657 552159 554121 554180 556060 563598 575681 582214 582656 585499 585525 589579 594632 597735 603082 603489 605022 605900 606965 608088 612269 613293 613350 618782 621536 622334 622562 624180 626819 628801 628846 628957 630823 636522 642679 649862 651832 659459 660794 661709 664409 669961 674600 676522 677047 678195 692994 695706 696194 702375 704343 704638 708680 710458 711699 712293 712931 713652 713838 714080 715235 716403 716515 717235 719642 719817 721122 721771 724891 725348 743355 780485 781760 782387 784083 784759 785227 785441 787328 787914 787936 788655 789754 790602 795697 796904 800702 804729 805650 805653 807268 810548 811537 812908 812958 814419 818186 824568 ] |
||||||||||||||||||||||||||||||
|
18.60 ms (11.85%) |
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 702375 712293 713652 721771 780485 781760 782387 784083 787328 787936 805650 807268 812908 812958 429259 418665 418513 438486 394351 422421 814419 824568 818186 458628 489155 492016 536217 534111 536825 514976 515227 527165 533763 537822 539707 540181 500444 540412 474057 543657 552159 554180 554121 582214 582656 649862 661709 669961 674600 678195 695706 714080 719642 651832 660794 664409 676522 704343 708680 712931 713838 716403 719817 721122 659459 677047 692994 696194 704638 710458 711699 715235 716515 717235 556060 563598 575681 585499 605900 613293 613350 622562 628801 628957 636522 597735 603082 603489 621536 622334 624180 630823 642679 594632 612269 626819 628846 585525 589579 605022 606965 608088 618782 784759 785441 787914 788655 796904 810548 811537 785227 789754 790602 795697 800702 804729 805653 724891 725348 743355 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (1.76%) |
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 394351 418513 418665 422421 429259 438486 458628 474057 489155 492016 500444 514976 515227 527165 533763 534111 536217 536825 537822 539707 540181 540412 543657 552159 554121 554180 556060 563598 575681 582214 582656 585499 585525 589579 594632 597735 603082 603489 605022 605900 606965 608088 612269 613293 613350 618782 621536 622334 622562 624180 626819 628801 628846 628957 630823 636522 642679 649862 651832 659459 660794 661709 664409 669961 674600 676522 677047 678195 692994 695706 696194 702375 704343 704638 708680 710458 711699 712293 712931 713652 713838 714080 715235 716403 716515 717235 719642 719817 721122 721771 724891 725348 743355 780485 781760 782387 784083 784759 785227 785441 787328 787914 787936 788655 789754 790602 795697 796904 800702 804729 805650 805653 807268 810548 811537 812908 812958 814419 818186 824568 ] |
||||||||||||||||||||||||||||||
|
2.04 ms (1.30%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"year"
]
|
||||||||||||||||||||||||||||||
|
1.74 ms (1.11%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"year"
]
|
||||||||||||||||||||||||||||||
|
1.70 ms (1.08%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.49 ms (0.95%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"year"
]
|
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.