{
"query_block": {
"select_id": 1,
"table": {
"table_name": "cscart_products",
"access_type": "range",
"possible_keys": ["PRIMARY"],
"key": "PRIMARY",
"key_length": "3",
"used_key_parts": ["product_id"],
"rows": 10,
"filtered": 100,
"attached_condition": "cscart_products.product_id in (551390,552905,552783,552926,551876,552881,552606,552882,551536,551904)"
}
}
}
product_id | product_code | product_type | status | old_status | company_id | list_price | amount | weight | length | width | height | shipping_freight | low_avail_limit | timestamp | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
551390 | 01-13558 | P | A | 3364 | 125.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669195409 | 1669273073 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | PERF-47922 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
551536 | 01-15233 | P | A | 3364 | 94.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669195616 | 1669273154 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | SHER-10028751 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
551876 | 01-18148 | P | A | 3364 | 70.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669196132 | 1669273353 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | SHER-20081015 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
551904 | 01-18227 | P | A | 3364 | 96.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669196177 | 1669273369 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | BEAUTY-DGK100M | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552606 | 01-19834 | P | A | 3364 | 94.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197276 | 1669273768 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | BEAUTY-DGTO100M | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552783 | 01-20063 | P | A | 3364 | 86.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197546 | 1669273870 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | SHER-10111897 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552881 | 01-2358 | P | A | 3364 | 85.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197703 | 1669273923 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | BEAUTY-LBDG50W | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552882 | 01-2359 | P | A | 3364 | 72.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197704 | 1669273924 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | BEAUTY-LBDG75M | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552905 | 01-3676 | P | A | 3364 | 96.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197738 | 1669273937 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | BEAUTY-DGTO50W | N | Y | 0 | |||||||||||||||||||||||||||||||||||
552926 | 01-3856 | P | A | 3364 | 70.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669197767 | 1669273949 | 0 | N | N | N | Y | N | N | N | Y | 30 | 0 | N | 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 | SHER-20201543 | N | Y | 0 |