SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    92533, 92532, 93007, 98607, 92736, 92513, 
    92806, 92805, 92473, 92830, 92829, 
    92276, 92612, 92663, 92118, 98608, 
    92778, 92777, 92776, 92775
  )

Query time 0.00044

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
92118 FE328 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612224000 0 Y N N B N R Y N N Y 10 1612224000 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 5054285582039 GBLV62040637 N Fatal Energy Records Michael Hepburn 1609780503 Y 2021-12-17 17:37:27 0
92276 IT065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285542941 GBLV62033253 N Copyright Control David Rosenberg / DJ Darroo 1609909801 Y 2021-12-17 17:37:27 0
92473 WAOD065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612742400 0 Y N N B N R Y N N Y 10 1612742400 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 5054285614235 GBKQU2104259 N Copyright Control R.Scott 1610558103 Y 2021-12-17 17:37:27 0
92513 RIOT191 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613347200 0 Y N N B N R Y N N Y 10 1613347200 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 5054285584774 GBLV62041207 N mcps copyright control Scott Attrill 1646418488 Y 2021-12-17 17:37:27 0
92532 HDP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285607114 GBKQU1140109 N 92553 mcps copyright control various artists 1610991011 Y 2021-12-17 17:37:27 0
92533 HDP001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613520000 0 Y N N B N R Y N N Y 10 1613520000 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 5054285607114 GBKQU1150482 N 92553 mcps copyright control various artists 1610991011 Y 2021-12-17 17:37:27 0
92612 DNZF941 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612310400 0 Y N N B N R Y N N Y 10 1612310400 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 5054285630709 GBKQU2107376 N DNZ Records Zero Range 1611077101 Y 2021-12-17 17:37:27 0
92663 DNZF940 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612224000 0 Y N N B N R Y N N Y 10 1612224000 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 5054285631485 GBKQU2107489 N DNZ Records Silent Skies 1611162302 Y 2021-12-17 17:37:27 0
92736 RTR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613347200 0 Y N N B N R Y N N Y 10 1613347200 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 5054285639009 GBKQU2108659 N Copyright Control R.Scott 1611378618 Y 2021-12-17 17:37:27 0
92775 HS04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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 5054285637036 GBKQU2108303 N Hardest Soft Freeboy, LOUISE 1611594303 Y 2021-12-17 17:37:27 0
92776 HS04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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 5054285637036 GBKQU2108304 N Hardest Soft Freeboy, LOUISE 1611594303 Y 2021-12-17 17:37:27 0
92777 HS04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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 5054285637036 GBKQU2108305 N Hardest Soft Freeboy, LOUISE 1611594304 Y 2021-12-17 17:37:27 0
92778 HS04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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 5054285637036 GBKQU2108306 N Hardest Soft Freeboy, LOUISE 1611594305 Y 2021-12-17 17:37:27 0
92805 ARX003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 5054285643051 ITU9F2100010 N IHU Music, The Saifam Group Srl, Arkham Digital Paul Bartolome, Xavier Miranda 1611637803 Y 2021-12-17 17:37:27 0
92806 ARX003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613088000 0 Y N N B N R Y N N Y 10 1613088000 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 5054285643051 ITU9F2100011 N IHU Music, The Saifam Group Srl, Arkham Digital Paul Bartolome, Xavier Miranda 1611637803 Y 2021-12-17 17:37:27 0
92829 DNZ435 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285650585 GBKQU2110711 N DNZ Records Adelle 1611767403 Y 2021-12-17 17:37:27 0
92830 DNZ435 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612483200 0 Y N N B N R Y N N Y 10 1612483200 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 5054285650585 GBKQU2110712 N DNZ Records Adelle 1611767404 Y 2021-12-17 17:37:27 0
93007 DNZF949 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613433600 0 Y N N B N R Y N N Y 10 1613433600 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 5054285661031 GBKQU2112471 N DNZ Records Barry P 1612200603 Y 2021-12-17 17:37:27 0
98607 RR051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1613347200 0 Y N N B N R Y N N Y 10 1613347200 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;} CA5KR2124747 N n/a Martin Zajic 1629945018 Y 2021-12-17 17:37:27 0
98608 RR050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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;} CA5KR2124745 N n/a Michael Crilly 1629945036 Y 2021-12-17 17:37:27 0