Query Metrics
7
Database Queries
7
Different statements
632.47 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
396.63 ms (62.71%) |
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 32485 413700 434370 447847 486270 497924 530202 530475 531449 532348 533202 533841 534633 534748 534756 534762 534785 534812 534819 534827 535272 535275 535827 535829 537832 538069 538158 541868 541898 542330 544708 548834 550926 553004 553007 554215 556402 556590 561121 563650 575303 583927 587157 587489 593590 593606 595323 595921 595929 596105 599695 601172 604536 604799 606554 607018 616699 622155 629378 634215 634422 636432 636923 637188 637251 638147 639261 640377 641156 644493 648793 649115 650098 651641 653139 656597 664462 664476 676546 677710 686357 697718 700303 704231 706665 709179 709807 712568 712935 719838 721870 732450 735308 735538 746087 760087 767375 773961 775993 778038 783840 785676 786450 788993 789017 789954 789957 789980 789987 789988 789997 790004 790008 790011 790029 790113 790162 790752 807773 ] |
||||||||||||||||||||||||||||||
|
213.23 ms (33.71%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ?
Parameters:
[
"trailer"
]
|
||||||||||||||||||||||||||||||
|
14.68 ms (2.32%) |
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 767375 783840 786450 789988 732450 746087 735308 604536 638147 700303 788993 790029 413700 534756 530475 535827 538069 533202 533841 531449 532348 535272 535275 554215 556590 548834 553004 664462 648793 649115 677710 697718 709179 712935 653139 656597 664476 676546 561121 575303 593590 606554 622155 634215 634422 639261 587157 595929 637251 775993 778038 789997 790004 790011 785676 735538 773961 629378 721870 789980 807773 32485 434370 447847 486270 534748 538158 534380 534633 534785 497924 530202 535829 537832 534762 534812 534819 534827 542330 541898 550926 553007 556402 541868 544708 650098 704231 651641 686357 706665 709807 712568 719838 563650 583927 593606 595921 601172 604799 607018 637188 640377 641156 596105 599695 636432 644493 616699 636923 587489 595323 789987 789954 789957 790162 760087 789017 790008 790113 790752 ] |
||||||||||||||||||||||||||||||
|
2.77 ms (0.44%) |
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 32485 413700 434370 447847 486270 497924 530202 530475 531449 532348 533202 533841 534633 534748 534756 534762 534785 534812 534819 534827 535272 535275 535827 535829 537832 538069 538158 541868 541898 542330 544708 548834 550926 553004 553007 554215 556402 556590 561121 563650 575303 583927 587157 587489 593590 593606 595323 595921 595929 596105 599695 601172 604536 604799 606554 607018 616699 622155 629378 634215 634422 636432 636923 637188 637251 638147 639261 640377 641156 644493 648793 649115 650098 651641 653139 656597 664462 664476 676546 677710 686357 697718 700303 704231 706665 709179 709807 712568 712935 719838 721870 732450 735308 735538 746087 760087 767375 773961 775993 778038 783840 785676 786450 788993 789017 789954 789957 789980 789987 789988 789997 790004 790008 790011 790029 790113 790162 790752 807773 ] |
||||||||||||||||||||||||||||||
|
1.82 ms (0.29%) |
1 |
SELECT `trend_id` FROM `trend` WHERE `subject` = ? LIMIT 1
Parameters:
[
"trailer"
]
|
||||||||||||||||||||||||||||||
|
1.75 ms (0.28%) |
1 |
SELECT `query_id` FROM `search_log` WHERE `query` = ?
Parameters:
[
"trailer"
]
|
||||||||||||||||||||||||||||||
|
1.60 ms (0.25%) |
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.