Query Metrics
7
Database Queries
7
Different statements
366.19 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
211.50 ms (57.76%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"not at home"
]
|
||||||||||||||||||||||||||||||
|
134.65 ms (36.77%) |
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 545002 559510 562428 572662 585514 588695 590005 590674 591546 592965 599091 599304 606641 606859 606999 609625 611343 617245 617388 622460 624478 626622 627624 628020 630230 630696 635649 636605 639895 640166 704722 707971 708131 709284 712688 712704 714673 721887 724692 725273 726456 727450 727695 732616 733422 733742 734536 735499 736338 736889 740225 742680 745593 747005 747891 748855 750548 752020 752490 752752 753166 753349 759612 761944 762278 768635 775066 775453 775646 775652 776109 778180 778450 778839 778905 779111 779841 780726 781158 781513 782122 782732 784218 784309 785082 785506 786402 787132 787249 787696 787711 787990 788620 789485 789649 790050 790251 790942 791083 793084 793365 793775 793966 794079 794160 796847 797194 797370 799863 801136 801933 803590 803711 805116 805788 809095 809551 809599 810515 810904 ] |
||||||||||||||||||||||||||||||
|
12.01 ms (3.28%) |
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 704722 707971 708131 709284 712688 712704 714673 721887 545002 559510 562428 572662 588695 590005 592965 599304 606999 617245 630696 635649 585514 591546 606859 611343 617388 622460 624478 640166 599091 606641 609625 627624 628020 630230 639895 590674 626622 636605 775066 775652 778450 779111 780726 781158 785506 787711 790050 790942 793775 794079 801933 803590 809095 809551 810515 775453 775646 776109 778180 778839 778905 779841 782732 786402 787132 787696 787990 790251 793084 794160 796847 797370 805116 810904 725273 727450 733422 733742 734536 736338 745593 750548 752752 753166 768635 781513 782122 784218 784309 785082 787249 788620 789485 789649 791083 793365 793966 797194 799863 801136 803711 805788 809599 726456 732616 736889 740225 753349 724692 742680 747005 747891 752020 752490 759612 761944 762278 727695 735499 748855 ] |
||||||||||||||||||||||||||||||
|
3.01 ms (0.82%) |
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 545002 559510 562428 572662 585514 588695 590005 590674 591546 592965 599091 599304 606641 606859 606999 609625 611343 617245 617388 622460 624478 626622 627624 628020 630230 630696 635649 636605 639895 640166 704722 707971 708131 709284 712688 712704 714673 721887 724692 725273 726456 727450 727695 732616 733422 733742 734536 735499 736338 736889 740225 742680 745593 747005 747891 748855 750548 752020 752490 752752 753166 753349 759612 761944 762278 768635 775066 775453 775646 775652 776109 778180 778450 778839 778905 779111 779841 780726 781158 781513 782122 782732 784218 784309 785082 785506 786402 787132 787249 787696 787711 787990 788620 789485 789649 790050 790251 790942 791083 793084 793365 793775 793966 794079 794160 796847 797194 797370 799863 801136 801933 803590 803711 805116 805788 809095 809551 809599 810515 810904 ] |
||||||||||||||||||||||||||||||
|
1.79 ms (0.49%) |
1 |
SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`
Parameters:
[] |
||||||||||||||||||||||||||||||
|
1.67 ms (0.46%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"home"
]
|
||||||||||||||||||||||||||||||
|
1.57 ms (0.43%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"home"
]
|
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.