explain
select 
tabdt0_.name as col_0_0_, tabdt0_.rid as col_1_0_, tabdt0_.id as col_2_0_, 
vwsf2_.sval as col_3_0_, 
vwsf3_.sval as col_4_0_, 
vwsf4_.sval as col_5_0_, 
vwsf5_.sval as col_6_0_, 
vwsf6_.sval as col_7_0_, 
vwsf7_.sval as col_8_0_, 
vwsf8_.sval as col_9_0_, 
vwsf9_.sval as col_10_0_, 
vwsf10_.sval as col_11_0_, 
vwsf11_.sval as col_12_0_, 
vwsf12_.sval as col_13_0_, 
vwsf13_.sval as col_14_0_, 
vwsf14_.sval as col_15_0_, 
vwsf15_.sval as col_16_0_, 
vwsf16_.sval as col_17_0_, 
vwsf17_.sval as col_18_0_, 
vwsf18_.sval as col_19_0_, 
vwsf19_.sval as col_20_0_, 
vwsf20_.sval as col_21_0_, 
vwsf21_.sval as col_22_0_, 
vwsf22_.sval as col_23_0_, 
vwsf23_.sval as col_24_0_, 
vwsf24_.sval as col_25_0_, 
vwsf25_.sval as col_26_0_, 
vwsf26_.sval as col_27_0_, 
vwsf27_.sval as col_28_0_, 
vwsf28_.sval as col_29_0_, 
vwsf29_.sval as col_30_0_, 
vwsf30_.sval as col_31_0_
-- ,vwsf31_.sval as col_32_0_
from 
tab_dt tabdt0_ inner join tab_inf tabinf1_ on tabdt0_.bid=tabinf1_.id 
left join vw_sf vwsf2_ on tabinf1_.id=vwsf2_.bid and (vwsf2_.name='field1') 
left join vw_sf vwsf3_ on tabinf1_.id=vwsf3_.bid and (vwsf3_.name='field2') 
left join vw_sf vwsf4_ on tabinf1_.id=vwsf4_.bid and (vwsf4_.name='field3') 
left join vw_sf vwsf5_ on tabinf1_.id=vwsf5_.bid and (vwsf5_.name='field4') 
left join vw_sf vwsf6_ on tabinf1_.id=vwsf6_.bid and (vwsf6_.name='field5') 
left join vw_sf vwsf7_ on tabinf1_.id=vwsf7_.bid and (vwsf7_.name='field6') 
left join vw_sf vwsf8_ on tabinf1_.id=vwsf8_.bid and (vwsf8_.name='field7') 
left join vw_sf vwsf9_ on tabinf1_.id=vwsf9_.bid and (vwsf9_.name='field8') 
left join vw_sf vwsf10_ on tabinf1_.id=vwsf10_.bid and (vwsf10_.name='field9') 
left join vw_sf vwsf11_ on tabinf1_.id=vwsf11_.bid and (vwsf11_.name='field10') 
left join vw_sf vwsf12_ on tabinf1_.id=vwsf12_.bid and (vwsf12_.name='field11') 
left join vw_sf vwsf13_ on tabinf1_.id=vwsf13_.bid and (vwsf13_.name='field12') 
left join vw_sf vwsf14_ on tabinf1_.id=vwsf14_.bid and (vwsf14_.name='field13') 
left join vw_sf vwsf15_ on tabinf1_.id=vwsf15_.bid and (vwsf15_.name='field14') 
left join vw_sf vwsf16_ on tabinf1_.id=vwsf16_.bid and (vwsf16_.name='field15') 
left join vw_sf vwsf17_ on tabinf1_.id=vwsf17_.bid and (vwsf17_.name='field16') 
left join vw_sf vwsf18_ on tabinf1_.id=vwsf18_.bid and (vwsf18_.name='field17') 
left join vw_sf vwsf19_ on tabinf1_.id=vwsf19_.bid and (vwsf19_.name='field18') 
left join vw_sf vwsf20_ on tabinf1_.id=vwsf20_.bid and (vwsf20_.name='field19') 
left join vw_sf vwsf21_ on tabinf1_.id=vwsf21_.bid and (vwsf21_.name='field20') 
left join vw_sf vwsf22_ on tabinf1_.id=vwsf22_.bid and (vwsf22_.name='field21') 
left join vw_sf vwsf23_ on tabinf1_.id=vwsf23_.bid and (vwsf23_.name='field22') 
left join vw_sf vwsf24_ on tabinf1_.id=vwsf24_.bid and (vwsf24_.name='field23') 
left join vw_sf vwsf25_ on tabinf1_.id=vwsf25_.bid and (vwsf25_.name='field24') 
left join vw_sf vwsf26_ on tabinf1_.id=vwsf26_.bid and (vwsf26_.name='field25') 
left join vw_sf vwsf27_ on tabinf1_.id=vwsf27_.bid and (vwsf27_.name='field26') 
left join vw_sf vwsf28_ on tabinf1_.id=vwsf28_.bid and (vwsf28_.name='field27') 
left join vw_sf vwsf29_ on tabinf1_.id=vwsf29_.bid and (vwsf29_.name='field28') 
left join vw_sf vwsf30_ on tabinf1_.id=vwsf30_.bid and (vwsf30_.name='field29') 
-- left join vw_sf vwsf31_ on tabinf1_.id=vwsf31_.bid and (vwsf31_.name='field30') 
where 
tabdt0_.bid in (1,2,3,4,5)