Unique  (cost=58.36..58.41 rows=2 width=884)
  ->  Sort  (cost=58.36..58.37 rows=2 width=884)
        Sort Key: "?column?", name, name, methodid, description, name, name, methodid, description
        ->  Append  (cost=0.00..58.35 rows=2 width=884)
              ->  Subquery Scan "*SELECT* 1"  (cost=0.00..29.18 rows=1 width=884)
                    ->  Nested Loop  (cost=0.00..29.17 rows=1 width=884)
                          ->  Nested Loop  (cost=0.00..23.33 rows=1 width=806)
                                ->  Nested Loop  (cost=0.00..17.49 rows=1 width=446)
                                      ->  Nested Loop  (cost=0.00..11.66 rows=1 width=368)
                                            ->  Index Scan using shop_commerce_baskets_pkey on shop_commerce_baskets b  (cost=0.00..5.82 rows=1 width=8)
                                                  Index Cond: (basketid = 3)
                                            ->  Index Scan using shop_commerce_paymethods_pkey on shop_commerce_paymethods pm  (cost=0.00..5.82 rows=1 width=364)
                                                  Index Cond: (pm.methodid = "outer".paymethodonstockid)
                                      ->  Index Scan using shop_commerce_paytypes_pkey on shop_commerce_paytypes pt  (cost=0.00..5.82 rows=1 width=86)
                                            Index Cond: ("outer".typeid = pt.typeid)
                                ->  Index Scan using shop_commerce_shipmethods_pkey on shop_commerce_shipmethods sm  (cost=0.00..5.82 rows=1 width=364)
                                      Index Cond: (sm.methodid = "outer".shipmethodonstockid)
                          ->  Index Scan using shop_commerce_shiptypes_pkey on shop_commerce_shiptypes st  (cost=0.00..5.82 rows=1 width=86)
                                Index Cond: ("outer".typeid = st.typeid)
              ->  Subquery Scan "*SELECT* 2"  (cost=0.00..29.18 rows=1 width=884)
                    ->  Nested Loop  (cost=0.00..29.17 rows=1 width=884)
                          ->  Nested Loop  (cost=0.00..23.33 rows=1 width=806)
                                ->  Nested Loop  (cost=0.00..17.49 rows=1 width=446)
                                      ->  Nested Loop  (cost=0.00..11.66 rows=1 width=368)
                                            ->  Index Scan using shop_commerce_baskets_pkey on shop_commerce_baskets b  (cost=0.00..5.82 rows=1 width=8)
                                                  Index Cond: (basketid = 3)
                                            ->  Index Scan using shop_commerce_paymethods_pkey on shop_commerce_paymethods pm  (cost=0.00..5.82 rows=1 width=364)
                                                  Index Cond: (pm.methodid = "outer".paymethodbackorderid)
                                      ->  Index Scan using shop_commerce_paytypes_pkey on shop_commerce_paytypes pt  (cost=0.00..5.82 rows=1 width=86)
                                            Index Cond: ("outer".typeid = pt.typeid)
                                ->  Index Scan using shop_commerce_shipmethods_pkey on shop_commerce_shipmethods sm  (cost=0.00..5.82 rows=1 width=364)
                                      Index Cond: (sm.methodid = "outer".shipmethodbackorderid)
                          ->  Index Scan using shop_commerce_shiptypes_pkey on shop_commerce_shiptypes st  (cost=0.00..5.82 rows=1 width=86)
                                Index Cond: ("outer".typeid = st.typeid)