{
"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 (633735,633732,633753,635144,633738,633734)"
}
}
}
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
633732 | GIFT40030 | P | A | 9567 | 25.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718120366 | 1718120867 | 0 | N | N | N | N | N | N | N | Y | 10 | 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 | N | Y | 0 | ||||||||||||||||||||||||||||||||||||
633734 | GIFT60641 | P | A | 9567 | 25.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718120367 | 1718121148 | 0 | N | N | N | N | N | N | N | Y | 10 | 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 | N | Y | 0 | ||||||||||||||||||||||||||||||||||||
633735 | GIFT40260 | P | A | 9567 | 5.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718120367 | 1718120871 | 0 | N | N | N | N | N | N | N | Y | 10 | 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 | N | Y | 0 | ||||||||||||||||||||||||||||||||||||
633738 | GIFT20621 | P | A | 9567 | 25.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718120367 | 1718120568 | 0 | N | N | N | N | N | N | N | Y | 10 | 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 | N | Y | 0 | ||||||||||||||||||||||||||||||||||||
633753 | GIFT24139 | P | A | 9567 | 10.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718120367 | 1718120626 | 0 | N | N | N | N | N | N | N | Y | 10 | 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 | N | Y | 0 | ||||||||||||||||||||||||||||||||||||
635144 | GIFTCARD348 | P | A | 9564 | 25.00 | 5 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1718962016 | 1718962462 | 0 | N | N | N | N | N | N | N | N | 10 | 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 | N | Y | 0 |