SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    101756, 101755, 101754, 101753, 101752, 
    101751, 101750, 101749, 101748, 101747, 
    101716, 101715, 101469, 101468, 101373, 
    101372, 101954, 101943, 101360, 101359
  )

Query time 0.00053

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
101359 RAVEMUZIK050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643241600 0 Y N N B N R Y N N Y 10 1643241600 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 5054286305439 GBLV62124385 N Copyright Control P. Nitschke 1640667902 Y 2021-12-28 06:05:02 0
101360 RAVEMUZIK050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643241600 0 Y N N B N R Y N N Y 10 1643241600 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 5054286305439 GBLV62124386 N Copyright Control P. Nitschke 1640667903 Y 2021-12-28 06:05:03 0
101372 ONESEVENTY122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286350521 GBLV62132950 N Copyright Control Tatsunoshin Fujiyoshi 1643362502 Y 2021-12-29 06:10:05 0
101373 ONESEVENTY122 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286350521 GBLV62132951 N Copyright Control Tatsunoshin Fujiyoshi 1640754605 Y 2021-12-29 06:10:05 0
101468 Hells056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286380696 GBKQU2200532 N Copyright Control A. Monastra 1641360001 Y 2022-01-05 06:20:01 0
101469 Hells056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286380696 GBKQU2200533 N Copyright Control A. Monastra 1641360001 Y 2022-01-05 06:20:01 0
101715 247HC262 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286415336 UKT6B2200097 N Peer Music R.Cox, A.Taylor 1643362518 Y 2022-01-17 18:05:06 0
101716 247HC262 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286415336 UKT6B2200096 N Peer Music R.Cox, A.Taylor 1642439106 Y 2022-01-17 18:05:06 0
101747 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200044 N 101762 Paul Rodriguez Music M.Greig 1642525512 Y 2022-01-18 18:05:12 0
101748 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200031 N 101762 Paul Rodriguez Music M.Greig 1642525512 Y 2022-01-18 18:05:12 0
101749 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200032 N 101762 Paul Rodriguez Music M.Greig 1642525512 Y 2022-01-18 18:05:12 0
101750 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200033 N 101762 Paul Rodriguez Music M.Greig 1642525512 Y 2022-01-18 18:05:12 0
101751 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200045 N 101762 Paul Rodriguez Music M.Greig 1642525513 Y 2022-01-18 18:05:13 0
101752 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200034 N 101762 Paul Rodriguez Music M.Greig 1642525513 Y 2022-01-18 18:05:13 0
101753 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200035 N 101762 Paul Rodriguez Music M.Greig 1642525513 Y 2022-01-18 18:05:13 0
101754 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200036 N 101762 Paul Rodriguez Music M.Greig 1642525513 Y 2022-01-18 18:05:13 0
101755 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200037 N 101762 Paul Rodriguez Music M.Greig 1642525513 Y 2022-01-18 18:05:13 0
101756 247HCLP013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643328000 0 Y N N B N R Y N N Y 10 1643328000 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 5054286414636 UKT6B2200038 N 101762 Paul Rodriguez Music M.Greig 1642525514 Y 2022-01-18 18:05:14 0
101943 JH329 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643241600 0 Y N N B N R Y N N Y 10 1643241600 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 5054286426554 GBKQU2207521 N Copyright Control Kengo 1642698602 Y 2022-01-20 18:10:02 0
101954 DARKULLP004t07 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643241600 0 Y N N B N R Y N N Y 10 1643241600 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 5054286429630 GBKQU2208055 N Copyright Control Paula Vigara Vives, Kenzo Borri 1642784702 Y 2022-01-21 18:05:02 0