{
"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 | 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 | paypal_commerce_platform_account_id | stripe_connect_account_id | paypal_email | paypal_base_for_commission | paypal_verification | ppa_first_name | ppa_last_name | verify | allow_create_payment | digitzs_connect_account_id | plan_status | payment_token | downgrade_plan_id | password | affiliate_merchant | affiliate_product_count | search_terms | shopify_api_key | shopify_api_token | shopify_store_url | vendor_type | tax_number | stripe_connect_account_type | allow_vendor_shopping_option | allow_anonymous_shopping_vendor | show_products | passport_external_id | passport_customer_id | passport_account_id | passport_merchant_id | is_lpo | price | periodicity | commission | products_limit | revenue_limit | vendor_store | categories | storefronts | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3389 | en | <p>Shopping with thousands of brands through one online shopping bag is now possible. Gain exclusive access to special offers and curated assortments from your favorite brands—always on sale, all in one convenient place.</p> | A | Coach | 401 RYLAND ST, STE 200-A | Reno | NV | US | 89502 | staging2merchanttwo@yopmail.com | (956) 756-7565 | https://test.com | none | Y | 2024 | 87,85,82,47,54,48 | 0 | N | N | N | 2 | 0 | 0 | 0 | 0 | not_checked | 1 | N | wesave-dinhhuyen-718569020-3049797-1675171786 | 0 | TX000076 | 0 | 1 | Y | 4704986 | 4008708 | 4001327 | 19.99 | month | 10.00 | 10 | 500.00 | 1 |