SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    108922, 97567, 98182, 108918, 97536, 
    97674, 97673, 97551, 97508, 109006, 
    97467, 97466, 97711, 97710, 97700, 
    97699, 97289, 97287, 97279, 97531
  )

Query time 0.00060

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
97279 UPR093 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054285917718 NL3TA2105501 N Copyright Control R. de Jong, S. Bosma 1625029801 Y 2021-12-17 17:37:27 0
97287 KTRAR042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286000655 GBKQU2172831 N Copyright Control Josh Rogers 1625030404 Y 2021-12-17 17:37:27 0
97289 THR12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286005308 GBKQU2173671 N Twisted Hardcore Records Mario , Mary 1625030405 Y 2021-12-17 17:37:27 0
97466 NUTTY089 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627858800 0 Y N N B N R Y N N Y 10 1627858800 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 5054285979679 UK9E92100290 N Nutty Traxx Bart Sloot 1625289601 Y 2021-12-17 17:37:27 0
97467 NUTTY089 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627858800 0 Y N N B N R Y N N Y 10 1627858800 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 5054285979679 UK9E92100291 N Nutty Traxx Bart Sloot 1625289602 Y 2021-12-17 17:37:27 0
97508 AREC062E P A 1 1.69 1 0.000 0 0 0 0.00 0 1627945200 0 Y N N B N R Y N N Y 10 1627945200 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 5054286008088 GBKQU2174058 N Akkros Records Time Art 1625375102 Y 2021-12-17 17:37:27 0
97531 INFEXORI004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627513200 0 Y N N B N R Y N N Y 10 1627513200 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 5054286024132 GBKQU2176590 N Copyright Control Francesco Del Frate, Marco Comis, Hans Ninchritz 1625591401 Y 2021-12-17 17:37:27 0
97536 UPR094 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 5054285925850 NL3TA2105601 N Copyright Control M. Vargiu, V. Asya Hijazi 1625634303 Y 2021-12-17 17:37:27 0
97551 INFEXRAW004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628118000 0 Y N N B N R Y N N Y 10 1628118000 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 5054286028444 GBKQU2177256 N Copyright Control Michael Simoens, Morad Merzoug 1625677801 Y 2021-12-17 17:37:27 0
97567 twist002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628463600 0 Y N N B N R Y N N Y 10 1628463600 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 5054285939871 GBKQU2162608 N twisted tunes bart sloot 1625894701 Y 2021-12-17 17:37:27 0
97673 HBR120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628118000 0 Y N N B N R Y N N Y 10 1628118000 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 5054286039747 GBKQU2179133 N Copyright Control Song Luo 1626196201 Y 2021-12-17 17:37:27 0
97674 HBR120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628118000 0 Y N N B N R Y N N Y 10 1628118000 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 5054286039747 GBKQU2179134 N Copyright Control Song Luo 1626196202 Y 2021-12-17 17:37:27 0
97699 BKW032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286029342 IT0282100013 N Theracords Music Publishing M.Capri - H.Zimmer 1626411901 Y 2021-12-17 17:37:27 0
97700 BKW032 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286029342 GBKQU2179973 N Theracords Music Publishing M.Capri - H.Zimmer 1626411902 Y 2021-12-17 17:37:27 0
97710 ELL038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286046561 GBKQU2180316 N Ellivium Music Andrey Gribanov & Dmitry Duplyakin 1626455103 Y 2021-12-17 17:37:27 0
97711 ELL038 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627599600 0 Y N N B N R Y N N Y 10 1627599600 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 5054286046561 GBKQU2180317 N Ellivium Music Andrey Gribanov & Dmitry Duplyakin 1626455103 Y 2021-12-17 17:37:27 0
98182 DECI012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628377200 0 Y N N B N R Y N N Y 10 1628377200 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 5054286085690 GBKQU2186615 N Decimate Records Lucas Burgos 1628226302 Y 2021-12-17 17:37:27 0
108918 KKR056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628204400 0 Y N N B N R Y N N Y 10 1628204400 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 9145563331329 ATR981236377 N Copyright Control Andy Thoncianus 1661191509 Y 2022-08-22 18:45:09 0
108922 KKR057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1628463600 0 Y N N B N R Y N N Y 10 1628463600 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 9505791744436 ATR981236647 N Copyright Control Jordan Faidherbe 1661191556 Y 2022-08-22 18:45:10 0
109006 KKR055 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627858800 0 Y N N B N R Y N N Y 10 1627858800 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 9503918151730 ATR981235969 N Copyright Control Ruben Pettersen & Hans Christian Jacobsen 1661192666 Y 2022-08-22 18:46:03 0