{
"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": 2,
"filtered": 100,
"attached_condition": "cscart_products.product_id in (64774,65674)"
}
}
}| product_id | product_code | product_type | trustmark_origin | trustmark_certified | trustmark_leadtime | trustmark_location | trustmark_return | owner_id | status | company_id | list_price | amount | weight | length | width | height | shipping_freight | low_avail_limit | 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 | updated_timestamp | pricing_note | use_new_layout | category_image | tax_code | upc_code | product_detail_ids | nav_sku | sku_columns | nav_review_user_id | hide_price | vendor_fulfilled | hide_commercial_price | non_returnable | ble_basics | commercial_hidden | allow_configurator | enable_customize | enable_buy_american | base_cost | redline_p |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 64774 | BLE-G-ASL | E | C | M | W | A | 0 | A | 1 | 385.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1565292223 | 0 | N | N | N | D | N | R | N | N | N | Y | 30 | 0 | N | 0 | 0 | 0 | 0 | 13 | N | 0 | P | F | default | 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;} | 1732203933 | Price increased of $89 - DC 4/28/21 35% commercial discount to base price manually added - DC 4/28/21 Price increased 10% from $230 to $253 - DC 5/24/22 Price increased from $253 to $260 - DC 11/1/22 Price increased from $260 to $385 - DM 10/18/23 | Y | none | none | 355,356,357 | BLE-G | {"22342":1,"22343":3,"22035":4,"22345":6,"21941":7,"23537":6} | 1051256 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | |||
| 65674 | BLE-S-ASL | P | E | C | M | W | A | 0 | A | 1 | 355.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1665493361 | 0 | N | N | N | D | N | R | N | N | N | Y | 10 | 0 | N | 0 | 0 | 0 | 0 | 13 | N | 0 | P | F | default | 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;} | 1769541461 | Price increased from $250 to $355 - DM 10/18/23 | Y | none | none | 3607,3608 | BLE-S | {"21936":9,"21937":9,"21938":8,"21939":8,"21935":8,"21934":8,"21933":8,"22254":7,"21976":9,"21977":9,"21950":9,"22016":9,"22017":9,"21941":8,"21970":3,"22224":7} | 1008383 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 |