SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    97123, 97122, 109027, 109026, 108917, 
    108999, 108998, 108975, 109046, 108960, 
    108877, 108920, 110746, 110725, 97093, 
    97092, 113549, 122783, 125264, 97127
  )

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
97092 AREC022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054285056455 GBKQU2043833 N Akkros Records Chistopher Meijvogel, Roy Meijvogel 1624297121 Y 2021-12-17 17:37:27 0
97093 AREC022 P A 1 1.69 1 0.000 0 0 0 0.00 0 1591311600 0 Y N N B N R Y N N Y 10 1591311600 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 5054285056455 GBKQU2043834 N Akkros Records Chistopher Meijvogel, Roy Meijvogel 1624297135 Y 2021-12-17 17:37:27 0
97122 A367201 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 3701478115599 FRDKW2102919 N MackiTek Records Keja & Kan10 1624382330 Y 2021-12-17 17:37:27 0
97123 A367201 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 3701478115599 FRDKW2102918 N MackiTek Records Keja & Kan10 1624382346 Y 2021-12-17 17:37:27 0
97127 MTR367202 P A 1 1.69 1 0.000 0 0 0 0.00 0 1486512000 0 Y N N B N R Y N N Y 10 1486512000 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 3701478115438 FRDKW2102880 N MackiTek Records Keja & Kan10 1624382408 Y 2021-12-17 17:37:27 0
108877 KKR003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610064000 0 Y N N B N R Y N N Y 10 1610064000 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 9008798359653 ATR981220141 N Copyright Control Matthias Wegner 1661190694 Y 2022-08-22 18:30:18 0
108917 KKR008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611532800 0 Y N N B N R Y N N Y 10 1611532800 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 9008798362509 ATR981221707 N Copyright Control Matthias Wegner 1661191498 Y 2022-08-22 18:45:09 0
108920 KKR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1609718400 0 Y N N B N R Y N N Y 10 1609718400 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 9008798359554 ATR981220088 N Copyright Control Matthias Wegner 1661191529 Y 2022-08-22 18:45:10 0
108960 KKR002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610064000 0 Y N N B N R Y N N Y 10 1610064000 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 9008798359561 ATR981220089 N Copyright Control Michael Suckfuell 1661192103 Y 2022-08-22 18:45:47 0
108975 KKR006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610928000 0 Y N N B N R Y N N Y 10 1610928000 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 9008798361816 ATR981221278 N Copyright Control Owen Stammers 1661192295 Y 2022-08-22 18:45:53 0
108998 KKR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 9008798361823 ATR981221279 N Copyright Control Haye Haverbus 1661192570 Y 2022-08-22 18:46:01 0
108999 KKR007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611273600 0 Y N N B N R Y N N Y 10 1611273600 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 9008798361823 ATR981221280 N Copyright Control Haye Haverbus 1661192583 Y 2022-08-22 18:46:01 0
109026 KKR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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 9008798364114 ATR981222151 N Copyright Control Matthias Wegner 1661192901 Y 2022-08-22 18:46:11 0
109027 KKR009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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 9008798364114 ATR981222152 N Copyright Control Matthias Wegner 1661192914 Y 2022-08-22 18:46:11 0
109046 KKR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1610668800 0 Y N N B N R Y N N Y 10 1610668800 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 9008798360819 ATR981220858 N Copyright Control Michael Suckfuell 1661193139 Y 2022-08-22 18:46:19 0
110725 CNMTK107DJ P A 1 1.69 1 0.000 0 0 0 0.00 0 1605830400 0 Y N N B N R Y N N Y 10 1605830400 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;} xelon 9355974319155 AUXN22095261 N Copyright Control Stephen George Game 1667835918 Y 2022-11-07 16:30:03 0
110746 CNMTK108DJ 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;} xelon 9355974345048 AUXN22102030 N Copyright Control Jamie Mike Morhain 1667844916 Y 2022-11-07 19:00:03 0
113549 SPECIAL01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1580515200 0 Y N N B N R Y N N Y 10 1580515200 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 5054287173396 SGB221500024 N Copyright Control Eino Kettunen 1674715512 Y 2023-01-26 07:15:01 0
122783 FCT002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1573603200 0 Y N N B N R Y N N Y 10 1573603200 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 5054288053956 GBKQU2421052 N Copyright Control Vincent Biquerave 1709702772 Y 2024-03-06 06:11:04 0
125264 K405R079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1540508400 0 Y N N B N R Y N N Y 10 1540508400 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 5054283900095 GBYKK1800009 N K405 Kidd Kaos & MKN 1718670609 Y 2024-06-18 01:15:02 0