{
"query_block": {
"select_id": 1,
"const_condition": "1",
"table": {
"table_name": "cscart_companies",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "cscart_company_descriptions",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "10",
"used_key_parts": ["company_id", "lang_code"],
"ref": ["const", "const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "p",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["plan_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
}
}
company_id | lang_code | company_description | terms | i18n_company | i18n_address | i18n_city | status | company | address | city | state | country | zipcode | phone | url | storefront | secure_storefront | entry_page | redirect_customer | countries_list | timestamp | shippings | logos | request_user_id | request_account_name | request_account_data | pre_moderation | pre_moderation_edit | pre_moderation_edit_vendors | plan_id | suspend_date | grace_period_start | last_time_suspended | last_debt_notification_time | tax_number | saved_shippings_state | registered_from_storefront_id | kiosk_vendor | price | periodicity | commission | products_limit | revenue_limit | vendor_store | categories | storefronts | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | en | Your Mix Distributors | Plot 17396 Bosiga Industrial | Maun | A | Your Mix Distributors | Plot 17396 Bosiga Industrial | Maun | NWD | BW | thero@ymonline.co.bw | +267-71-111-111 | none | Y | 1598878073 | 10, 9, 16, 17,10,13,16,17,18,9 | 0 | a:4:{s:14:"company_fields";a:2:{i:37;s:3:"Kat";i:38;s:12:"Benningfield";}s:15:"admin_firstname";s:3:"Kat";s:14:"admin_lastname";s:12:"Benningfield";s:6:"fields";a:0:{}} | N | N | N | 22 | 1693121213 | 0 | 1700807808 | 0 | BW000000000 | 10, 9 | Y | 0.00 | month | 0.00 | 0 | 0.00 | 1 |