JPA-tuning.md

JPA 조회 최적화

---+++++ find world by creatorId


----- no tuning -----

select world0_.oid as oid1_3_, world0_.created_at as created_2_3_, world0_.last_modified_at as last_mod3_3_, world0_.approved_version_id as approved9_3_, world0_.creator_id as creator_4_3_, world0_.dev_policy_agreed as dev_poli5_3_, world0_.not_reviewed_version_id as not_rev10_3_, world0_.published_count as publishe6_3_, world0_.published_version_id as publish11_3_, world0_.rejected_version_id as rejecte12_3_, world0_.status as status7_3_, world0_.world_id as world_id8_3_ from world world0_ where world0_.creator_id='omwomw' limit 20;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=1;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=3;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=4;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=5;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=6;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=7;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid=8;


----- default-batch-fetch-size 100 적용 -----

select world0_.oid as oid1_3_, world0_.created_at as created_2_3_, world0_.last_modified_at as last_mod3_3_, world0_.approved_version_id as approved9_3_, world0_.creator_id as creator_4_3_, world0_.dev_policy_agreed as dev_poli5_3_, world0_.not_reviewed_version_id as not_rev10_3_, world0_.published_count as publishe6_3_, world0_.published_version_id as publish11_3_, world0_.rejected_version_id as rejecte12_3_, world0_.status as status7_3_, world0_.world_id as world_id8_3_ from world world0_ where world0_.creator_id='omwomw' limit 20;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_, worldversi5_.oid as oid1_6_5_, worldversi5_.created_at as created_2_6_5_, worldversi5_.last_modified_at as last_mod3_6_5_, worldversi5_.category1id as category4_6_5_, worldversi5_.category2id as category5_6_5_, worldversi5_.cover_image_id as cover_i18_6_5_, worldversi5_.creator_id as creator_6_6_5_, worldversi5_.description as descript7_6_5_, worldversi5_.forbidden_reason as forbidde8_6_5_, worldversi5_.guideline_agreed as guidelin9_6_5_, worldversi5_.name as name10_6_5_, worldversi5_.package_file_id as package19_6_5_, worldversi5_.published_time as publish11_6_5_, worldversi5_.review_id as review_12_6_5_, worldversi5_.status as status13_6_5_, worldversi5_.status_changed_time as status_14_6_5_, worldversi5_.submitted_time as submitt15_6_5_, worldversi5_.tags as tags16_6_5_, worldversi5_.test_link as test_li17_6_5_, worldversi5_.world_oid as world_o20_6_5_, worldversi6_.oid as oid1_6_6_, worldversi6_.created_at as created_2_6_6_, worldversi6_.last_modified_at as last_mod3_6_6_, worldversi6_.category1id as category4_6_6_, worldversi6_.category2id as category5_6_6_, worldversi6_.cover_image_id as cover_i18_6_6_, worldversi6_.creator_id as creator_6_6_6_, worldversi6_.description as descript7_6_6_, worldversi6_.forbidden_reason as forbidde8_6_6_, worldversi6_.guideline_agreed as guidelin9_6_6_, worldversi6_.name as name10_6_6_, worldversi6_.package_file_id as package19_6_6_, worldversi6_.published_time as publish11_6_6_, worldversi6_.review_id as review_12_6_6_, worldversi6_.status as status13_6_6_, worldversi6_.status_changed_time as status_14_6_6_, worldversi6_.submitted_time as submitt15_6_6_, worldversi6_.tags as tags16_6_6_, worldversi6_.test_link as test_li17_6_6_, worldversi6_.world_oid as world_o20_6_6_, worldversi7_.oid as oid1_6_7_, worldversi7_.created_at as created_2_6_7_, worldversi7_.last_modified_at as last_mod3_6_7_, worldversi7_.category1id as category4_6_7_, worldversi7_.category2id as category5_6_7_, worldversi7_.cover_image_id as cover_i18_6_7_, worldversi7_.creator_id as creator_6_6_7_, worldversi7_.description as descript7_6_7_, worldversi7_.forbidden_reason as forbidde8_6_7_, worldversi7_.guideline_agreed as guidelin9_6_7_, worldversi7_.name as name10_6_7_, worldversi7_.package_file_id as package19_6_7_, worldversi7_.published_time as publish11_6_7_, worldversi7_.review_id as review_12_6_7_, worldversi7_.status as status13_6_7_, worldversi7_.status_changed_time as status_14_6_7_, worldversi7_.submitted_time as submitt15_6_7_, worldversi7_.tags as tags16_6_7_, worldversi7_.test_link as test_li17_6_7_, worldversi7_.world_oid as world_o20_6_7_, worldversi8_.oid as oid1_6_8_, worldversi8_.created_at as created_2_6_8_, worldversi8_.last_modified_at as last_mod3_6_8_, worldversi8_.category1id as category4_6_8_, worldversi8_.category2id as category5_6_8_, worldversi8_.cover_image_id as cover_i18_6_8_, worldversi8_.creator_id as creator_6_6_8_, worldversi8_.description as descript7_6_8_, worldversi8_.forbidden_reason as forbidde8_6_8_, worldversi8_.guideline_agreed as guidelin9_6_8_, worldversi8_.name as name10_6_8_, worldversi8_.package_file_id as package19_6_8_, worldversi8_.published_time as publish11_6_8_, worldversi8_.review_id as review_12_6_8_, worldversi8_.status as status13_6_8_, worldversi8_.status_changed_time as status_14_6_8_, worldversi8_.submitted_time as submitt15_6_8_, worldversi8_.tags as tags16_6_8_, worldversi8_.test_link as test_li17_6_8_, worldversi8_.world_oid as world_o20_6_8_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid 
left outer join world_version worldversi5_ on world4_.approved_version_id=worldversi5_.oid 
left outer join world_version worldversi6_ on world4_.not_reviewed_version_id=worldversi6_.oid 
left outer join world_version worldversi7_ on world4_.published_version_id=worldversi7_.oid 
left outer join world_version worldversi8_ on world4_.rejected_version_id=worldversi8_.oid where worldversi0_.oid in (1, 3, 4, 5, 6, 7, 8);




----- World ToOne+JoinColumn 에 Lazy 적용 -----

select world0_.oid as oid1_3_, world0_.created_at as created_2_3_, world0_.last_modified_at as last_mod3_3_, world0_.approved_version_id as approved9_3_, world0_.creator_id as creator_4_3_, world0_.dev_policy_agreed as dev_poli5_3_, world0_.not_reviewed_version_id as not_rev10_3_, world0_.published_count as publishe6_3_, world0_.published_version_id as publish11_3_, world0_.rejected_version_id as rejecte12_3_, world0_.status as status7_3_, world0_.world_id as world_id8_3_ from world world0_ where world0_.creator_id='omwomw' limit 20;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_, resourcefi1_.oid as oid1_1_1_, resourcefi1_.created_at as created_2_1_1_, resourcefi1_.last_modified_at as last_mod3_1_1_, resourcefi1_.file_path as file_pat4_1_1_, resourcefi1_.original_file_name as original5_1_1_, resourcefi1_.size as size6_1_1_, resourcefi1_.type as type7_1_1_, resourcefi1_.uploaded_time as uploaded8_1_1_, resourcefi1_.world_version_id as world_ve9_1_1_, worldversi2_.oid as oid1_6_2_, worldversi2_.created_at as created_2_6_2_, worldversi2_.last_modified_at as last_mod3_6_2_, worldversi2_.category1id as category4_6_2_, worldversi2_.category2id as category5_6_2_, worldversi2_.cover_image_id as cover_i18_6_2_, worldversi2_.creator_id as creator_6_6_2_, worldversi2_.description as descript7_6_2_, worldversi2_.forbidden_reason as forbidde8_6_2_, worldversi2_.guideline_agreed as guidelin9_6_2_, worldversi2_.name as name10_6_2_, worldversi2_.package_file_id as package19_6_2_, worldversi2_.published_time as publish11_6_2_, worldversi2_.review_id as review_12_6_2_, worldversi2_.status as status13_6_2_, worldversi2_.status_changed_time as status_14_6_2_, worldversi2_.submitted_time as submitt15_6_2_, worldversi2_.tags as tags16_6_2_, worldversi2_.test_link as test_li17_6_2_, worldversi2_.world_oid as world_o20_6_2_, packagefil3_.oid as oid1_0_3_, packagefil3_.created_at as created_2_0_3_, packagefil3_.last_modified_at as last_mod3_0_3_, packagefil3_.file_path as file_pat4_0_3_, packagefil3_.original_file_name as original5_0_3_, packagefil3_.size as size6_0_3_, packagefil3_.uploaded_time as uploaded7_0_3_, packagefil3_.version as version8_0_3_, world4_.oid as oid1_3_4_, world4_.created_at as created_2_3_4_, world4_.last_modified_at as last_mod3_3_4_, world4_.approved_version_id as approved9_3_4_, world4_.creator_id as creator_4_3_4_, world4_.dev_policy_agreed as dev_poli5_3_4_, world4_.not_reviewed_version_id as not_rev10_3_4_, world4_.published_count as publishe6_3_4_, world4_.published_version_id as publish11_3_4_, world4_.rejected_version_id as rejecte12_3_4_, world4_.status as status7_3_4_, world4_.world_id as world_id8_3_4_ 
from world_version worldversi0_ 
left outer join resource_file resourcefi1_ on worldversi0_.cover_image_id=resourcefi1_.oid 
left outer join world_version worldversi2_ on resourcefi1_.world_version_id=worldversi2_.oid 
left outer join package_file packagefil3_ on worldversi0_.package_file_id=packagefil3_.oid 
left outer join world world4_ on worldversi0_.world_oid=world4_.oid where worldversi0_.oid in (1, 3, 4, 5, 6, 7, 8);



----- WorldVersion ToOne+JoinColumn 에 Lazy 적용 -----

select world0_.oid as oid1_3_, world0_.created_at as created_2_3_, world0_.last_modified_at as last_mod3_3_, world0_.approved_version_id as approved9_3_, world0_.creator_id as creator_4_3_, world0_.dev_policy_agreed as dev_poli5_3_, world0_.not_reviewed_version_id as not_rev10_3_, world0_.published_count as publishe6_3_, world0_.published_version_id as publish11_3_, world0_.rejected_version_id as rejecte12_3_, world0_.status as status7_3_, world0_.world_id as world_id8_3_ from world world0_ where world0_.creator_id='omwomw' limit 20;

select worldversi0_.oid as oid1_6_0_, worldversi0_.created_at as created_2_6_0_, worldversi0_.last_modified_at as last_mod3_6_0_, worldversi0_.category1id as category4_6_0_, worldversi0_.category2id as category5_6_0_, worldversi0_.cover_image_id as cover_i18_6_0_, worldversi0_.creator_id as creator_6_6_0_, worldversi0_.description as descript7_6_0_, worldversi0_.forbidden_reason as forbidde8_6_0_, worldversi0_.guideline_agreed as guidelin9_6_0_, worldversi0_.name as name10_6_0_, worldversi0_.package_file_id as package19_6_0_, worldversi0_.published_time as publish11_6_0_, worldversi0_.review_id as review_12_6_0_, worldversi0_.status as status13_6_0_, worldversi0_.status_changed_time as status_14_6_0_, worldversi0_.submitted_time as submitt15_6_0_, worldversi0_.tags as tags16_6_0_, worldversi0_.test_link as test_li17_6_0_, worldversi0_.world_oid as world_o20_6_0_ 
from world_version worldversi0_ where worldversi0_.oid in (1, 3, 4, 5, 6, 7, 8);