{
"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 (61430,65146)"
}
}
}
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 61430 | BLE-PMDB | E | N | M | W | D | 0 | A | 1 | 413.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1224561600 | 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;} | 1716904898 | Price increased 5% from $357 to $375 - DC 5/24/21 Price increased 10% from $375 to $413 - DC 6/1/22 | Y | none | none | 803 | BLE | {"16490":1,"16491":2,"16803":3} | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 | |||
| 65146 | BLE-PMD-WHA-LED | E | C | M | W | A | 0 | A | 1 | 1462.00 | 1000 | 0.000 | 0 | 0 | 0 | 0.00 | 0 | 1588347171 | 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;} | 1769107706 | Increased by $60 per DS - DC 6/19/19 Price increased 5% from $1266 to $1329 - DC 5/28/21 Price increased 10% from $1329 to $1462 - DC 6/1/22 | Y | none | none | 2542,2544,2546 | BLE | {"22397":10,"22643":10,"22644":11,"22645":12} | 1056013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0 |