gistfile1.txt

------------------------ LOAD PLAN BRANCH

  select
        file0_.filename as filename1_16_0_,
        file0_.parent_filename as parent2_16_0_,
        file0_2_.xsize as xsize1_9_0_,
        file0_3_.target_filename as target2_15_0_,
        case 
            when file0_1_.filename is not null then 1 
            when file0_2_.filename is not null then 2 
            when file0_3_.filename is not null then 3 
            when file0_.filename is not null then 0 
        end as clazz_0_,
        folder1_.filename as filename1_16_1_,
        folder1_1_.parent_filename as parent2_16_1_,
        folder2_.filename as filename1_16_2_,
        folder2_1_.parent_filename as parent2_16_2_,
        folder3_.filename as filename1_16_3_,
        folder3_1_.parent_filename as parent2_16_3_,
        folder4_.filename as filename1_16_4_,
        folder4_1_.parent_filename as parent2_16_4_,
        file5_.filename as filename1_16_5_,
        file5_.parent_filename as parent2_16_5_,
        file5_2_.xsize as xsize1_9_5_,
        file5_3_.target_filename as target2_15_5_,
        case 
            when file5_1_.filename is not null then 1 
            when file5_2_.filename is not null then 2 
            when file5_3_.filename is not null then 3 
            when file5_.filename is not null then 0 
        end as clazz_5_,
        folder6_.filename as filename1_16_6_,
        folder6_1_.parent_filename as parent2_16_6_,
        folder7_.filename as filename1_16_7_,
        folder7_1_.parent_filename as parent2_16_7_,
        folder8_.filename as filename1_16_8_,
        folder8_1_.parent_filename as parent2_16_8_,
        folder9_.filename as filename1_16_9_,
        folder9_1_.parent_filename as parent2_16_9_,
        file10_.filename as filename1_16_10_,
        file10_.parent_filename as parent2_16_10_,
        file10_2_.xsize as xsize1_9_10_,
        file10_3_.target_filename as target2_15_10_,
        case 
            when file10_1_.filename is not null then 1 
            when file10_2_.filename is not null then 2 
            when file10_3_.filename is not null then 3 
            when file10_.filename is not null then 0 
        end as clazz_10_ 
    from
        joined_file file0_ 
    left outer join
        Folder file0_1_ 
            on file0_.filename=file0_1_.filename 
    left outer join
        Document file0_2_ 
            on file0_.filename=file0_2_.filename 
    left outer join
        SymbolicLink file0_3_ 
            on file0_.filename=file0_3_.filename 
    left outer join
        Folder folder1_ 
            on file0_.parent_filename=folder1_.filename 
    left outer join
        joined_file folder1_1_ 
            on folder1_.filename=folder1_1_.filename 
    left outer join
        Folder folder2_ 
            on file0_.parent_filename=folder2_.filename 
    left outer join
        joined_file folder2_1_ 
            on folder2_.filename=folder2_1_.filename 
    left outer join
        Folder folder3_ 
            on file0_.parent_filename=folder3_.filename 
    left outer join
        joined_file folder3_1_ 
            on folder3_.filename=folder3_1_.filename 
    left outer join
        Folder folder4_ 
            on file0_.parent_filename=folder4_.filename 
    left outer join
        joined_file folder4_1_ 
            on folder4_.filename=folder4_1_.filename 
    inner join
        joined_file file5_ 
            on file0_3_.target_filename=file5_.filename 
    left outer join
        Folder file5_1_ 
            on file5_.filename=file5_1_.filename 
    left outer join
        Document file5_2_ 
            on file5_.filename=file5_2_.filename 
    left outer join
        SymbolicLink file5_3_ 
            on file5_.filename=file5_3_.filename 
    left outer join
        Folder folder6_ 
            on file5_.parent_filename=folder6_.filename 
    left outer join
        joined_file folder6_1_ 
            on folder6_.filename=folder6_1_.filename 
    left outer join
        Folder folder7_ 
            on file5_.parent_filename=folder7_.filename 
    left outer join
        joined_file folder7_1_ 
            on folder7_.filename=folder7_1_.filename 
    left outer join
        Folder folder8_ 
            on file5_.parent_filename=folder8_.filename 
    left outer join
        joined_file folder8_1_ 
            on folder8_.filename=folder8_1_.filename 
    left outer join
        Folder folder9_ 
            on file5_.parent_filename=folder9_.filename 
    left outer join
        joined_file folder9_1_ 
            on folder9_.filename=folder9_1_.filename 
    inner join
        joined_file file10_ 
            on file5_3_.target_filename=file10_.filename 
    left outer join
        Folder file10_1_ 
            on file10_.filename=file10_1_.filename 
    left outer join
        Document file10_2_ 
            on file10_.filename=file10_2_.filename 
    left outer join
        SymbolicLink file10_3_ 
            on file10_.filename=file10_3_.filename 
    where
        file0_.filename=?

----------------------------------  MASTER

    select
        file0_.filename as filename1_16_2_,
        file0_.parent_filename as parent_f2_16_2_,
        file0_2_.xsize as xsize1_9_2_,
        file0_3_.target_filename as target_f2_15_2_,
        case 
            when file0_1_.filename is not null then 1 
            when file0_2_.filename is not null then 2 
            when file0_3_.filename is not null then 3 
            when file0_.filename is not null then 0 
        end as clazz_2_,
        folder1_.filename as filename1_16_0_,
        folder1_1_.parent_filename as parent_f2_16_0_,
        file2_.filename as filename1_16_1_,
        file2_.parent_filename as parent_f2_16_1_,
        file2_2_.xsize as xsize1_9_1_,
        file2_3_.target_filename as target_f2_15_1_,
        case 
            when file2_1_.filename is not null then 1 
            when file2_2_.filename is not null then 2 
            when file2_3_.filename is not null then 3 
            when file2_.filename is not null then 0 
        end as clazz_1_ 
    from
        joined_file file0_ 
    left outer join
        Folder file0_1_ 
            on file0_.filename=file0_1_.filename 
    left outer join
        Document file0_2_ 
            on file0_.filename=file0_2_.filename 
    left outer join
        SymbolicLink file0_3_ 
            on file0_.filename=file0_3_.filename 
    left outer join
        Folder folder1_ 
            on file0_.parent_filename=folder1_.filename 
    left outer join
        joined_file folder1_1_ 
            on folder1_.filename=folder1_1_.filename 
    left outer join
        joined_file file2_ 
            on file0_3_.target_filename=file2_.filename 
    left outer join
        Folder file2_1_ 
            on file2_.filename=file2_1_.filename 
    left outer join
        Document file2_2_ 
            on file2_.filename=file2_2_.filename 
    left outer join
        SymbolicLink file2_3_ 
            on file2_.filename=file2_3_.filename 
    where
        file0_.filename=?