SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    6243, 6290, 4074, 6274, 6222, 6219, 3254, 
    4100, 4097, 6209, 6245, 6285, 6258, 
    6329, 6270, 6269, 6268, 6267, 6266, 
    6265
  )

Query time 0.00028

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
3254 KTI009A P A 1 1.69 1 0.000 0 0 0 0.00 0 1337727600 0 Y N N B Y R Y N N Y 10 1337727600 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;} N Truelove Music Dom Sweeten / Owen Swinerd 1642492582 Y 2021-12-17 17:37:27 0
4074 ac001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1339282800 0 Y N N B N R Y N N Y 10 1339282800 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 230862 5052653288927 ES60B1200802 N Squad Music SL Alex Cervera 1393942855 Y 2021-12-17 17:37:27 0
4097 AWSMB013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1337554800 0 Y N N B N R Y N N Y 10 1337554800 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 195654 5052653227988 GBKQU1158555 N 4102 Various Various 1393503027 Y 2021-12-17 17:37:27 0
4100 AWSMB013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1337554800 0 Y N N B N R Y N N Y 10 1337554800 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 195657 5052653227988 GBKQU1136001 N 4102 Various Various 1393944157 Y 2021-12-17 17:37:27 0
6209 UDT53 P A 1 1.69 1 0.000 0 0 0 0.00 0 1337382000 0 Y N N B N R Y N N Y 10 1337382000 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 197258 5052653233729 GBKQU1276503 N Underdog Trax Periferal & Pez 1393944330 Y 2021-12-17 17:37:27 0
6219 UDT57 P A 1 1.69 1 0.000 0 0 0 0.00 0 1337986800 0 Y N N B N R Y N N Y 10 1337986800 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 209276 5052653260534 GBKQU1282825 N Underdog Trax Okami & Hybridz 1393943919 Y 2021-12-17 17:37:27 0
6222 RC020 P A 1 1.69 1 0.000 0 0 0 0.00 0 1338850800 0 Y N N B N R Y N N Y 10 1338850800 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 224931 5052653277525 GBKQU1286672 N Copyright Control Ian, Diego, Endika, Javier 1393943237 Y 2021-12-17 17:37:27 0
6243 UDT60 P A 1 1.69 1 0.000 0 0 0 0.00 0 1340578800 0 Y N N B N R Y N N Y 10 1340578800 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 244928 5052653299442 GBKQU1291535 N Underdogtrax Mr Mister & Foid 1393942213 Y 2021-12-17 17:37:27 0
6245 TR065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1336950000 0 Y N N B N R Y N N Y 10 1336950000 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 204393 5052653243926 GBZ7C1100073 N Bucks Music Group (Masif Publishing) / Copyright Control A.Bamford, M.Tracey & D.Palmer 1393944576 Y 2021-12-17 17:37:27 0
6258 BAD008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335999600 0 Y N N B N R Y N N Y 10 1335999600 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 184265 5052653218979 GBKQU1273064 N Copyright Control KS2, Ozy & Ash P 1393945775 Y 2021-12-17 17:37:27 0
6265 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195624 5052653227940 GBKQU1022693 N 6271 Various Various 1393946664 Y 2021-12-17 17:37:27 0
6266 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195625 5052653227940 GBKQU1017377 N 6271 Various Various 1393504116 Y 2021-12-17 17:37:27 0
6267 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195626 5052653227940 GBKQU1024223 N 6271 Various Various 1393946082 Y 2021-12-17 17:37:27 0
6268 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195627 5052653227940 GBKQU1024224 N 6271 Various Various 1393946562 Y 2021-12-17 17:37:27 0
6269 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195628 5052653227940 GBKQU1024225 N 6271 Various Various 1393946543 Y 2021-12-17 17:37:27 0
6270 AWSMB011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335135600 0 Y N N B N R Y N N Y 10 1335135600 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 195629 5052653227940 GBKQU1028859 N 6271 Various Various 1393946167 Y 2021-12-17 17:37:27 0
6274 BAD009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1338850800 0 Y N N B N R Y N N Y 10 1338850800 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 184280 5052653218986 GBKQU1273065 N Copyright Control Kye Shand ( KS2 ) Bench & Ash P 1393943220 Y 2021-12-17 17:37:27 0
6285 BAD007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335999600 0 Y N N B N R Y N N Y 10 1335999600 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 184258 5052653218962 GBKQU1273063 N Copyright Control KS2 - Cliffy 1393945758 Y 2021-12-17 17:37:27 0
6290 BAD011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1340319600 0 Y N N B N R Y N N Y 10 1340319600 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 233818 5052653296977 GBKQU1291073 N Copyright Control Lusty & Hyperstate 1393942613 Y 2021-12-17 17:37:27 0
6329 B2T037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1335913200 0 Y N N B N R Y N N Y 10 1335913200 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 173327 5052653256490 GBKQU1281983 N Copyright Control Charlie Bosh 1393945846 Y 2021-12-17 17:37:27 0