SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    6978, 7272, 7266, 7265, 7096, 7279, 7498, 
    7492, 7491, 7807, 14126, 14115, 7802, 
    7987, 32993, 7997, 7993, 8290, 14266, 
    14265
  )

Query time 0.00042

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 20 Using where

Result

product_id product_code product_type 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 exclusive_end_date 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 final_category aggregator aggregator_id ean isrc tbid is_album from_album publisher writers updated_timestamp available_worldwide stream_release_date download_release_date added_timestamp parent_product_id
6978 B2T024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1309993200 0 Y N N B N R Y N N Y 10 1309993200 0 B 0 0 0 0 6 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;} labelworx 109279 5052653076098 GBKQU1141345 N Copyright Control Kye Shand, Justin Daniels & Jamie Russel 1393514869 Y 2021-12-17 17:37:27 0
7096 AWSM034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1306710000 0 Y N N B N R Y N N Y 10 1306710000 0 B 0 0 0 0 6 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;} labelworx 101205 5052653055550 GBW7F1100164 N 23rd Precinct / Copyright Control Andy Whitby, MDA & Spherical 1393504159 Y 2021-12-17 17:37:27 0
7265 AWSMSHOW01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1306710000 0 Y N N B N R Y N N Y 10 1306710000 0 B 0 0 0 0 6 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;} labelworx 103780 5052653068451 GBKQU1139530 N 7267 Various Various 1393504205 Y 2021-12-17 17:37:27 0
7266 AWSMSHOW01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1306710000 0 Y N N B N R Y N N Y 10 1306710000 0 B 0 0 0 0 6 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;} labelworx 103781 5052653068451 GBKQU1139531 N 7267 Various Various 1393504258 Y 2021-12-17 17:37:27 0
7272 DEF51 P A 1 1.69 1 0.000 0 0 0 0.00 0 1309042800 0 Y N N B N R Y N N Y 10 1309042800 0 B 0 0 0 0 6 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;} labelworx 152100 5052653070690 GBKQU1140088 N 23rd Presinct S.Brett 1393510546 Y 2021-12-17 17:37:27 0
7279 cheek011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1305241200 0 Y N N B N R Y N N Y 10 1305241200 0 B 0 0 0 0 6 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;} labelworx 99423 5052653061162 GBKQU1138025 N Copyright Control Andy Shimeld, Ian Dewhurst, Josh Butler 1393931292 Y 2021-12-17 17:37:27 0
7491 AWSMB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1303081200 0 Y N N B N R Y N N Y 10 1303081200 0 B 0 0 0 0 6 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;} labelworx 101306 5052653046190 GBKQU1134814 N 7501 Various Various 1393504267 Y 2021-12-17 17:37:27 0
7492 AWSMB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1303081200 0 Y N N B N R Y N N Y 10 1303081200 0 B 0 0 0 0 6 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;} labelworx 101307 5052653046190 GBKQU1134815 N 7501 Various Various 1393504215 Y 2021-12-17 17:37:27 0
7498 AWSMB001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1303081200 0 Y N N B N R Y N N Y 10 1303081200 0 B 0 0 0 0 6 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;} labelworx 101313 5052653046190 GBYNV1000008 N 7501 Various Various 1393946116 Y 2021-12-17 17:37:27 0
7802 cheek004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1293580800 0 Y N N B N R Y N N Y 10 1293580800 0 B 0 0 0 0 6 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;} labelworx 70821 5052653011341 GBKQU1027153 N Copyright Control Josh Butler & Emma Worral 1393931328 Y 2021-12-17 17:37:27 0
7807 ILI07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1297555200 0 Y N N B N R Y N N Y 10 1297555200 0 B 0 0 0 0 6 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;} labelworx 152053 5052653023498 GBKQU1029463 N Copyright Control T.Berry 1393510383 Y 2021-12-17 17:37:27 0
7987 AWSMBC009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1292198400 0 Y N N B N R Y N N Y 10 1292198400 0 B 0 0 0 0 6 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;} labelworx 101172 5052653010580 GBKQU1026955 N Copyright Control Paul Fearon 1393946204 Y 2021-12-17 17:37:27 0
7993 AWSMPACK003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1289779200 0 Y N N B N R Y N N Y 10 1289779200 0 B 0 0 0 0 6 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;} labelworx 101300 5055274106601 GBKQU1023080 N 7998 23rd Precinct. Various 1393504224 Y 2021-12-17 17:37:27 0
7997 AWSMPACK003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1289779200 0 Y N N B N R Y N N Y 10 1289779200 0 B 0 0 0 0 6 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;} labelworx 101305 5055274106601 GBKQU1023084 N 7998 23rd Precinct. Various 1393259436 Y 2021-12-17 17:37:27 0
8290 DEF36 P A 1 1.69 1 0.000 0 0 0 0.00 0 1285542000 0 Y N N B N R Y N N Y 10 1285542000 0 B 0 0 0 0 6 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;} labelworx 151972 5055274099255 GBKQU1021725 N 23rd Presinct / Copyright Control S.Brett & R.Cain 1393510493 Y 2021-12-17 17:37:27 0
14115 1360WNUK P A 1 1.69 1 0.000 0 0 0 0.00 0 1295827200 0 Y N N B N R Y N N Y 10 1295827200 0 B 0 0 0 0 6 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;} labelworx 5025375513608 GBBRQ0800229 N 14130 Various Artists Various Artists 1393518610 Y 2021-12-17 17:37:27 0
14126 1360WNUK P A 1 1.69 1 0.000 0 0 0 0.00 0 1295827200 0 Y N N B N R Y N N Y 10 1295827200 0 B 0 0 0 0 6 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;} labelworx 5025375513608 GBBRQ0000072 N 14130 Various Artists Various Artists 1392916270 Y 2021-12-17 17:37:27 0
14265 1327WNUK P A 1 1.69 1 0.000 0 0 0 0.00 0 1283122800 0 Y N N B N R Y N N Y 10 1283122800 0 B 0 0 0 0 6 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;} labelworx 5025375513271 GBBRQ1000218 N Various Various 1393253219 Y 2021-12-17 17:37:27 0
14266 1327WNUK P A 1 1.69 1 0.000 0 0 0 0.00 0 1283122800 0 Y N N B N R Y N N Y 10 1283122800 0 B 0 0 0 0 6 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;} labelworx 5025375513271 GBBRQ1000228 N Various Various 1393253240 Y 2021-12-17 17:37:27 0
32993 LWHSE003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1291593600 0 Y N N B N R Y N N Y 10 1291593600 0 B 0 0 0 0 6 N 0 P F 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;} labelworx 5052653010801 GBKQU1020873 N 32995 Copyright Control Various Artists 1397711368 Y 2021-12-17 17:37:27 0