query_definition

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)