SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    61081, 62246, 60906, 62040, 61425, 62167, 
    62023, 64273, 30013, 61697, 60484, 
    30012
  )

Query time 0.00081

JSON explain

{
  "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": 12,
      "filtered": 100,
      "attached_condition": "cscart_products.product_id in (61081,62246,60906,62040,61425,62167,62023,64273,30013,61697,60484,30012)"
    }
  }
}

Result

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
30012 BLE-W-BULKOS N U M W D 0 A 1 180.00 1000 0.000 0 0 0 0.00 0 1224734400 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;} 1749147900 Price increased 5% from $174 to $183 - DC 5/25/21 Price increased by 10% from $183 to $202 - DC 5/24/22 Price decreased from $202 to $180 - DC 10/28/2022 Commercial price increased to $130 - DM 9/12/23 Y none none 188 BLE-W {"1719":1} 1051256 0 0 0 0 0 0 0 0 0 0.00 0
30013 BLE-W-BULKRS N U M W D 0 A 1 190.00 1000 0.000 0 0 0 0.00 0 1224734400 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;} 1749147894 Price increased 5% from $174 to $183 - DC 5/25/21 Price temporarily increased $21 to account for no small option - DC 6/30/21 Price decreased $21 to account for small option back in stock - DC 1/24/21 Price increased by 10% from $183 to $202 - DC 5/24/22 Price decreased from $202 to $180 - DC 10/28/2022 Price increased from $180 to $190 - DC 7/10/23 Commercial price increased to $138 - DM 9/12/23 Y none none 3475 BLE-W {"1721":1,"23627":1} 1051256 0 0 0 0 0 0 0 0 0 0.00 0
60484 BLE-W-CGGT P E U M W A 0 A 1 285.00 1000 0.000 0 0 0 0.00 0 1403496000 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;} 1776874547 Price increased by $39 - DC 5/27/20 Price increased 5% from $230 to $242 - DC 5/25/21 Price decreased by $3 - DC 6/16/21 Price increased 10% from $239 to $263 - DC 5/256/22 Price increased from $263 to $285 - DC 12/28/22 Y images/category_images/static-navy-more-styles-available .jpg none none 1029,1030 BLE-W-CGGT {"23083":2,"21941":6,"24039":4,"24041":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
60906 BLE-W-WHA10 E C M W A 0 A 1 265.00 1000 0.000 0 0 0 0.00 0 1223438400 0 N N N D N P 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;} 1755706156 Price increased 5% from $134 to $141 - DC 5/25/21 Price increased by $55 - DC 4/21/22 Price increased 10% from $196 to $216 - DC 5/31/22 Commercial price increased to $190 - DM 9/12/23 Price increased from $216 to $265 - DM 9/28/23 Y none none 985,986 BLE-W {"22996":1,"21941":8,"22024":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61081 BLE-W-SOH-CAN P E C M W A 0 A 1 375.00 1000 0.000 0 0 0 0.00 0 1352178000 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;} 1732203933 Price decreased by $60 - DC 4/1/20 Price decreased by $38 - DC 5/19/21 38% commercial discount to base price manually added - DC 5/19/21 Price increased 5% from $302 to $317 - DC 5/25/21 Price increased 10% from $317 to $349 - DC 5/24/22 Price increased from $349 to $375 - DC 11/8/22 Y none none 191 BLE-W-SOH-CAN {"21970":1,"22952":1,"22037":2,"21973":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
61425 BLE-G-CGG P E C M W A 0 A 1 310.00 1000 0.000 0 0 0 0.00 0 1359954000 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;} 1776879561 Price increased 5% from $172 to $181 - DC 6/3/21 Price increased by $110 - DC 6/16/21 Price increased 10% from $282 to $311 - DC 5/24/22 Price decreased from $311 to $310 - DC 11/4/22 Y images/category_images/more-styles-available-311-jadite.jpg none none 1035,1036 BLE-G-CGG {"21941":10,"22345":8,"23018":7,"23019":7,"23020":7,"23016":6,"23015":5,"22971":4,"23133":2,"23050":1,"23537":8,"23538":8,"21970":1,"24042":6} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
61697 BLE-G-HIB P E C M W A 0 A 1 285.00 1000 0.000 0 0 0 0.00 0 1366603200 0 N N N D N P 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;} 1732205373 Price increased by $60 - DC 5/19/21 38% commercial discount to base price manually added - DC 5/19/21 Price increased 10% from $242 to $267 - DC 5/24/22 Price increased from $267 to $285 - DC 11/1/22 Y none none 564,3250 BLE-G-HIB {"22617":3,"22035":4,"22345":5,"21941":6,"23537":5} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62023 BLE-W-CLAR8 P E C M W A 0 A 1 330.00 1000 0.000 0 0 0 0.00 0 1382932800 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;} 1753278821 Price increased by $69 - DC 4/19/21 36% commercial discount to base price manually added - DC 4/19/21 Price increased 5% from $245 to $257 - DC 5/25/21 Price increased 10% from $257 to $283 - DC 5/26/22 Price increased from $283 to $330 - DC 10/31/22 Y none none 577,578,579 BLE-W-CLAR8 {"22711":1,"21984":5,"21967":6,"21985":7,"21941":8,"22911":3,"22040":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
62040 BLE-G-2WHS-G55 E C M W A 0 A 1 458.00 1000 0.000 0 0 0 0.00 0 1354856400 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;} 1767729163 Price decreased by $254 - DC 4/14/20 Price increased 10% from $416 to $458 - DC 5/24/22 Y none none 640,641,642 BLE-G {"22771":1,"22772":2,"22773":3,"22786":4,"22774":4,"22778":5,"22779":6,"22784":8,"22782":8,"22783":8,"22397":9,"23607":6,"22040":7,"23587":7} 1056013 0 0 0 0 0 0 0 0 1 0.00 0
62167 BLE-G-ULA P E C M W A 0 A 1 375.00 1000 0.000 0 0 0 0.00 0 1391144400 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;} 1753983533 Price increased by $55 - DC 5/10/21 37% commercial discount to base price manually added - DC 5/10/21 Price increased 10% from $275 to $303 - DC 5/24/22 Price increased from $303 to $375 - DC 10/26/22 Y none none 767,768,769 BLE-G {"22861":6,"22862":6,"22863":8,"22864":8,"22865":8,"22872":9,"22852":10,"21941":12,"22873":11,"22874":11,"22875":11} 1008383 0 0 0 0 0 0 0 0 1 0.00 0
62246 BLE-L-WL002 P E C M A A 0 A 1 335.00 1000 0.000 0 0 0 0.00 0 1398830400 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;} 1761853974 Price increased 5% from $208 to $218 - DC 5/25/21 Price increased 10% from $218 to $240 - DC 5/31/22 Price increased from $240 to $260 - DC 8/10/22 Price increased from $260 to $310 - DC 10/28/2022 Commercial price increased to $200 - DM 9/12/23 Price decreased from $310 to $279 - DM 9/28/23 Price increased from $279 to $335 - DM 11/28/23 Y none none 619 BLE-L-WL002 {"22685":1,"22682":2,"21954":2} 1051256 0 0 0 0 0 0 0 0 1 0.00 0
64273 BLE-L-WL008 P E C M D A 0 A 1 370.00 1000 0.000 0 0 0 0.00 0 1492488000 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;} 1747932479 Price increased 5% from $281 to $295 - DC 5/25/21 Price increased by $21 - DC 7/7/21 38% commercial discount to base price manually added - DC 7/7/21 Price decreased by $2 - DC 4/12/22 Price increased 10% from $314 to $346 - DC 5/24/22 Price increased from $346 to $370 - DC 11/18/22 Y none none 857 BLE-L-WL008 {"22952":1,"22951":2,"22950":4} 1051256 0 0 0 0 0 0 0 0 1 0.00 0