{
"query_block": {
"select_id": 1,
"filesort": {
"sort_key": "storefronts.is_default desc",
"temporary_table": {
"table": {
"table_name": "languages",
"access_type": "index",
"possible_keys": ["PRIMARY", "idx_storefront_id"],
"key": "PRIMARY",
"key_length": "8",
"used_key_parts": ["storefront_id", "language_id"],
"rows": 3,
"filtered": 100,
"attached_condition": "languages.language_id = '1'",
"using_index": true
},
"block-nl-join": {
"table": {
"table_name": "storefronts",
"access_type": "ALL",
"possible_keys": ["PRIMARY"],
"rows": 3,
"filtered": 100
},
"buffer_type": "flat",
"buffer_size": "108",
"join_type": "BNL",
"attached_condition": "storefronts.storefront_id = languages.storefront_id"
}
}
}
}
}
storefront_id | url | redirect_customer | is_default | status | access_key | name | theme_name | is_accessible_for_authorized_customers_only |
---|---|---|---|---|---|---|---|---|
1 | staging2.wesave.com | N | Y | N | 6f890bf9d9ca795c99ceb9a42b8021c9 | DEV Wesave | wesave_theme | N |
25 | wesavedesignerdeals.staging2.wesave.com | N | N | Y | 5a2ca31d2d6292fa78f762a0757c7bda | WeSave Main | wesave_theme | N |
26 | staging2.wesave.com/wesaveshopdirect | N | N | N | 0f96b14874881df670e26bf1ce30de8d | WeSave-Shop Direct | wesave_theme | N |