SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    91827, 91796, 91825, 91824, 91823, 91808, 
    91807, 91806, 91805, 91804, 91803, 
    91639, 91600, 91537, 91535, 91425, 
    91025, 90894, 90888, 90881
  )

Query time 0.00036

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
90881 ED006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 1609459200 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;} 4 labelworx 5054285412275 GBLV62009805 N Copyright Control Matt Wade, Matty Tweed 1605676807 Y 2021-12-17 17:37:27 0
90888 PMD035 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 1609459200 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;} 4 labelworx 5054285490136 GBLV62023261 N Pumped David Holt 1605677104 Y 2021-12-17 17:37:27 0
90894 HOT078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 1609459200 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;} 4 labelworx 5054285467411 GBLV62019311 N Hot Box Digital Paul Reeves 1605677108 Y 2021-12-17 17:37:27 0
91025 UTHHD043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 1609459200 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;} 4 labelworx 5054285500224 GBLV62025432 N Ultratech Dance Music UK David Grabowski 1605720007 Y 2021-12-17 17:37:27 0
91425 DBD52 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 1609459200 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;} 4 labelworx 5054285534120 GBLV62031736 N Drop Bear Digital Michael Costigan, Kahul Harris 1607101501 Y 2021-12-17 17:37:27 0
91535 HWR016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 0 N 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;} 4 N Hooverweight Records Leigh Day / Paul Hunter 1711483264 Y 2021-12-17 17:37:27 0
91537 KT008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 N Kaki Trax Paul Norris 1607668390 Y 2021-12-17 17:37:27 0
91600 RPR192 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 0 N 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;} 4 AUTOGENERATE N none Grady G 1607722733 Y 2021-12-17 17:37:27 0
91639 VCR302 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608249600 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 N Copyright Control Will Shepherd / Lee Mills 1607890361 Y 2021-12-17 17:37:27 0
91796 TGR072 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608422400 0 Y N N B N R Y N N Y 10 1608422400 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;} 4 N Copyright control Paul Batten/Jonny Googoo 1608147377 Y 2021-12-17 17:37:27 0
91803 HFAS002B P A 1 1.69 1 0.000 0 0 0 0.00 0 1608275973 0 Y N N B N R Y N N Y 10 1608249600 0 N 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;} 4 N Toolbox Digital Dean Richardson 1608280878 Y 2021-12-17 17:37:27 0
91804 HFAS002A P A 1 1.69 1 0.000 0 0 0 0.00 0 1608276126 0 Y N N B N R Y N N Y 10 1608249600 0 N 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;} 4 N Toolbox Digital Jake Surgey/Micheal Galvin 1608280855 Y 2021-12-17 17:37:27 0
91805 DIP 3033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608289745 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 UKWDN2000012 N Dip Music Mik Cree 1608290122 Y 2021-12-17 17:37:27 0
91806 BB010A P A 1 1.69 1 0.000 0 0 0 0.00 0 1608299310 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 N Copyright Control Tara Nicholson 1608300023 Y 2021-12-17 17:37:27 0
91807 BB010B P A 1 1.69 1 0.000 0 0 0 0.00 0 1608299380 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 N Copyright Control Tara Nicholson 1608300045 Y 2021-12-17 17:37:27 0
91808 BB010C P A 1 1.69 1 0.000 0 0 0 0.00 0 1608299477 0 Y N N B N R Y N N Y 10 1608249600 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;} 4 N Copyright Control Tara Nicholson / Ben Miles 1608300066 Y 2021-12-17 17:37:27 0
91823 TERBRR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608405830 0 Y N N B N R Y N N Y 10 1608336000 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;} 4 N Toolbox Ross Homson 1623998177 Y 2021-12-17 17:37:27 0
91824 TERBRR058 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608405908 0 Y N N B N R Y N N Y 10 1608336000 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;} 4 N Toolbox Ross Homson 1623998177 Y 2021-12-17 17:37:27 0
91825 TERBRR059 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608405989 0 Y N N B N R Y N N Y 10 1608336000 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;} 4 N Toolbox Ross Homson 1623998177 Y 2021-12-17 17:37:27 0
91827 DD151 P A 1 1.69 1 0.000 0 0 0 0.00 0 1608482824 0 Y N N B N R Y N N Y 10 1608422400 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;} 4 GBLV62038089 N Copyright Control Nikkdbubble & Random But Raw 1608483621 Y 2021-12-17 17:37:27 0