SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    10566, 10499, 10474, 10473, 10472, 10471, 
    31948, 10339, 10226, 10064, 10049, 
    8088, 6289, 4064, 3580, 3578, 3577, 
    6278, 6202, 3978
  )

Query time 0.00039

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
3577 RORILB005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1342047600 0 Y N N B Y R Y N N Y 10 1342047600 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;} GBKQU1017649 N Copyright Control Tom Ingamels 1393941352 Y 2021-12-17 17:37:27 0
3578 RORILB007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1342047600 0 Y N N B Y R Y N N Y 10 1342047600 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;} GBKQU1017657 N Westbury Music Mik Cree 1393941369 Y 2021-12-17 17:37:27 0
3580 RORILB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1342047600 0 Y N N B Y R Y N N Y 10 1342047600 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;} GBKQU1017652 N Copyright Control Tom Ingamells 1393941382 Y 2021-12-17 17:37:27 0
3978 ac002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1341010800 0 Y N N B N R Y N N Y 10 1341010800 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 230877 5052653288934 ES60B1200803 N Squad Music SL Alex Cervera 1393942074 Y 2021-12-17 17:37:27 0
4064 BAD013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1342047600 0 Y N N B N R Y N N Y 10 1342047600 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 233824 5052653296991 GBKQU1291075 N Copyright Control The Don 1393941408 Y 2021-12-17 17:37:27 0
6202 B2T013B P A 1 1.69 1 0.000 0 0 0 0.00 0 1341442800 0 Y N N B N R Y N N Y 10 1341442800 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 234857 5052653297547 GBKQU1291172 N Copyright Control KS2, SPROUT DJ 1393941979 Y 2021-12-17 17:37:27 0
6278 UDT61 P A 1 1.69 1 0.000 0 0 0 0.00 0 1341615600 0 Y N N B N R Y N N Y 10 1341615600 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 260934 5052653312202 GBKQU1294530 N Underdog Trax Matt Alliss & K-Finn 1393941826 Y 2021-12-17 17:37:27 0
6289 UDT62 P A 1 1.69 1 0.000 0 0 0 0.00 0 1342825200 0 Y N N B N R Y N N Y 10 1342825200 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 260941 5052653308779 GBKQU1293669 N Underdog Trax Dan Diamond 1393941221 Y 2021-12-17 17:37:27 0
8088 UDT66 P A 1 1.69 1 0.000 0 0 0 0.00 0 1344639600 0 Y N N B N R Y N N Y 10 1344639600 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 260949 5052653338066 GBKQU1200629 N Underdog Trax K-Finn & MooneY 1393940463 Y 2021-12-17 17:37:27 0
10049 DNZ041 P A 1 1.69 1 0.000 0 0 0 0.00 0 1345158000 0 Y N N B N R Y N N Y 10 1345158000 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 284187 5052653354240 GBKQU1204499 N DNZ Records Dj Oskar 1393931862 Y 2021-12-17 17:37:27 0
10064 UDT65 P A 1 1.69 1 0.000 0 0 0 0.00 0 1345244400 0 Y N N B N R Y N N Y 10 1345244400 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 260947 5052653338073 GBKQU1200630 N Underdog Trax Okami & Hybridz 1393940234 Y 2021-12-17 17:37:27 0
10226 AA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1347318000 0 Y N N B N R Y N N Y 10 1347318000 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 287234 5052653364355 GBKQU1206767 N Audio Abuse Recordings Tom Berry, Justin Daniels, Jamie Russell 1393939203 Y 2021-12-17 17:37:27 0
10339 FRWL002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1348441200 0 Y N N B N R Y N N Y 10 1348441200 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 296467 5052653382212 GBKQU1210900 N 10362 Flammable Records Rock Shocker & Steve Axid 1393495354 Y 2021-12-17 17:37:27 0
10471 YEAH048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1349046000 0 Y N N B N R Y N N Y 10 1349046000 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 293745 5052653388481 GB2P41200046 N Yeah Boi Recordings Heath Aspinall 1393938190 Y 2021-12-17 17:37:27 0
10472 YEAH048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1349046000 0 Y N N B N R Y N N Y 10 1349046000 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 293746 5052653388481 GB2P41200047 N Yeah Boi Recordings Heath Aspinall 1393938161 Y 2021-12-17 17:37:27 0
10473 YEAH048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1349046000 0 Y N N B N R Y N N Y 10 1349046000 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 294074 5052653388481 GB2P41200048 N Yeah Boi Recordings Heath Aspinall 1393938146 Y 2021-12-17 17:37:27 0
10474 YEAH048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1349046000 0 Y N N B N R Y N N Y 10 1349046000 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 294086 5052653388481 GB2P41200049 N Yeah Boi Recordings Heath Aspinall 1393938131 Y 2021-12-17 17:37:27 0
10499 RC021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1349391600 0 Y N N B N R Y N N Y 10 1349391600 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 5052653380539 GBKQU1210457 N Copyright Control Ramiro P Sanz 1393938001 Y 2021-12-17 17:37:27 0
10566 YEAH049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1350255600 0 Y N N B N R Y N N Y 10 1350255600 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 5052653391740 GB2P41200051 N Yeah Boi Recordings Lee4Real, Fl4sh, Trix, Bowie666 1393934340 Y 2021-12-17 17:37:27 0
31948 LWFHDC01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1348441200 0 Y N N B N R Y N N Y 10 1348441200 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 5052653391955 GB2P41200023 N 31958 Copyright Control Various Artists 1397627437 Y 2021-12-17 17:37:27 0