{
"query_block": {
"select_id": 1,
"table": {
"table_name": "prod",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
},
"table": {
"table_name": "com",
"access_type": "const",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "4",
"used_key_parts": ["company_id"],
"ref": ["const"],
"rows": 1,
"filtered": 100
}
}
}
company_id | status | company | lang_code | 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 | product_id | product_code | product_type | old_status | list_price | amount | weight | length | width | height | shipping_freight | low_avail_limit | updated_timestamp | usergroup_ids | is_edp | edp_shipping | unlimited_download | tracking | free_shipping | zero_price_action | is_pbp | is_op | is_oper | is_returnable | return_period | avail_since | out_of_stock_actions | localization | min_qty | max_qty | qty_step | list_qty_count | tax_ids | age_verification | age_limit | options_type | exceptions_type | details_layout | shipping_params | facebook_obj_type | parent_product_id | buy_now_url | master_product_id | master_product_status | master_product_offers_count | ab__stickers_manual_ids | ab__stickers_generated_ids | enable_store_pickup | store_pickup_only | ebay_template_id | product_hash | ebay_price | package_type | ebay_status | ebay_override_price | vendor_product | override_commission | product_commission | product_commission_fee | affiliate_products | amz_asin | amz_sku | amz_ean | amz_upc | amz_isbn | amz_item_type | amz_condition | amz_condition_note | amz_browse_node | amz_price | amz_item_is_marketplace | amz_override_price | amz_synchronization | has_video | avatax_code | GPItemNumber | is_stock_split_by_warehouses | spo_vendor | is_equity | alt_video_id | alt_video_filename | alt_video_preload_filename | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
19 | A | Source 4 Shopping | en | Santa Clarita | CA | US | 91350 | Source_Shop@outlook.com | (661) 286-4334 | https://www.wesave.com/source-4-shopping/ | none | Y | 1616088147 | 43,54,85,82,87,48 | 0 | N | N | N | 6 | 0 | 0 | 0 | 0 | not_checked | 1 | N | wesave-sourceinc-33258800-3173582-1647883808 | 0 | 0 | 1 | Y | 223960 | D5329989-A32F-4D48-9CB4-E8A2352ECDF6 | P | 0.00 | 50 | 453.592 | 0 | 0 | 0 | 5.18 | 0 | 1616088147 | 0 | N | N | N | O | N | N | N | N | Y | 10 | 0 | N | 2 | N | 0 | a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} | 0 | 0 | A | 0 | N | N | 0 | Letter | N | N | no | 0 | N | N | Y | N | N | Y | 0 |