{
"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": 6,
"filtered": 100,
"attached_condition": "cscart_products.product_id in (558893,558889,559332,563215,558919,558821)"
}
}
}
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
558821 | 13-1114 | P | A | 3364 | 32.99 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669206514 | 1669277596 | 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 | MELI-9160 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
558889 | 13-1634 | P | A | 3364 | 16.50 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669206609 | 1669277634 | 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 | FABERKIDS-14558 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
558893 | 13-1641 | P | A | 3364 | 17.00 | 1000 | 0.000 | 0 | 0 | 0 | 16.00 | 0 | 1669206615 | 1669277636 | 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 | FABERKIDS-FC14592 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
558919 | 13-1776 | P | A | 3364 | 69.97 | 1000 | 0.000 | 0 | 0 | 0 | 23.00 | 0 | 1669206651 | 1669277651 | 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 | KIT-MELISSA70 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
559332 | 13-652 | P | A | 3364 | 32.99 | 1000 | 0.000 | 0 | 0 | 0 | 19.00 | 0 | 1669207263 | 1669277883 | 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 | MELI-488 | N | Y | 0 | |||||||||||||||||||||||||||||||||||
563215 | 18-3073 | P | A | 3364 | 375.00 | 1000 | 0.000 | 0 | 0 | 0 | 33.00 | 0 | 1669210864 | 1669281129 | 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 | LENOX-890951 | N | Y | 0 |