Query Metrics
7
Database Queries
7
Different statements
134.80 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
113.85 ms (84.46%) |
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 60096 392508 404440 479446 525444 535972 541350 548913 550539 554114 554236 556285 569365 574289 575636 577836 577905 577989 583531 590328 592326 593919 594051 594067 594604 603374 614665 622303 622477 622512 628219 628851 629727 630473 630478 631828 637898 643879 644600 645728 652424 655841 657158 660789 660799 675715 677074 691676 707741 709459 720104 720328 721125 721223 721756 725336 728759 729705 730432 730676 730780 730944 731123 734813 735379 735743 737971 741553 742075 742193 744882 746650 746753 748369 748649 755130 755553 760288 761861 762015 764193 764808 766517 769128 778510 778518 778722 779926 780808 782499 785171 786204 786491 787941 791325 791748 795577 795611 796857 797573 798527 800283 800317 801624 802522 802632 804197 804853 805649 807924 813279 814490 818937 819102 819442 821800 825537 827041 827569 ] |
||||||||||||||||||||||||||||||
|
11.53 ms (8.56%) |
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 819102 525444 550539 721223 725336 577836 655841 707741 721125 592326 630473 631828 637898 644600 594051 622512 778722 782499 786204 786491 800317 731123 734813 798527 730944 741553 769128 735379 764808 748369 764193 746753 627511 800283 805649 813279 660799 603374 594067 795577 796857 801624 730780 746650 554114 802632 60096 535972 554236 575636 577905 556285 541350 569365 645728 657158 709459 720104 652424 574289 577989 590328 593919 630478 622303 629727 614665 778510 778518 779926 785171 791325 797573 787941 802522 807924 729705 730676 742075 744882 766517 791748 735743 761861 762015 748649 755553 760288 742193 728759 730432 755130 643879 721756 780808 795611 804197 804853 392508 814490 821800 825537 818937 827041 827569 819442 720328 737971 404440 479446 548913 583531 660789 691676 675715 677074 594604 622477 628219 628851 ] |
||||||||||||||||||||||||||||||
|
2.63 ms (1.95%) |
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 60096 392508 404440 479446 525444 535972 541350 548913 550539 554114 554236 556285 569365 574289 575636 577836 577905 577989 583531 590328 592326 593919 594051 594067 594604 603374 614665 622303 622477 622512 628219 628851 629727 630473 630478 631828 637898 643879 644600 645728 652424 655841 657158 660789 660799 675715 677074 691676 707741 709459 720104 720328 721125 721223 721756 725336 728759 729705 730432 730676 730780 730944 731123 734813 735379 735743 737971 741553 742075 742193 744882 746650 746753 748369 748649 755130 755553 760288 761861 762015 764193 764808 766517 769128 778510 778518 778722 779926 780808 782499 785171 786204 786491 787941 791325 791748 795577 795611 796857 797573 798527 800283 800317 801624 802522 802632 804197 804853 805649 807924 813279 814490 818937 819102 819442 821800 825537 827041 827569 ] |
||||||||||||||||||||||||||||||
|
1.89 ms (1.40%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.78 ms (1.32%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.72 ms (1.27%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"18 year"
]
|
||||||||||||||||||||||||||||||
|
1.40 ms (1.04%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"18 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.