SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    97918, 97916, 97215, 97911, 97900, 97899, 
    97896, 97757, 97670, 97165, 97164, 
    97106, 92927, 96739, 97748, 97747, 
    97746, 92926, 97705, 97704
  )

Query time 0.00050

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
92926 VCR325 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626476400 0 Y N N B N R Y N N Y 10 1626390000 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;} 4 N Truelove Music Dom Sweeten 1626416492 Y 2021-12-17 17:37:27 0
92927 VCR326 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 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 Craig Dunbar 1612123902 Y 2021-12-17 17:37:27 0
96739 ST19 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626908400 0 Y N N B N R Y N N Y 10 1626908400 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 Hatfish Music James Nardi & Matt Smith 1622908552 Y 2021-12-17 17:37:27 0
97106 FD053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 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;} 3 N Copyright Control Przemysław Gołacki 1624353582 Y 2021-12-17 17:37:27 0
97164 Cheek535 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 1628204400 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 5054285839799 GBKQU2143024 N Copyright Control Matt Bailey, David Jackson 1624425302 Y 2021-12-17 17:37:27 0
97165 Cheek535 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 1628204400 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 5054285839799 GBKQU2143025 N Copyright Control Matt Bailey, David Jackson 1624425308 Y 2021-12-17 17:37:27 0
97215 BTN015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627254000 0 Y N N B N R Y N N Y 10 1627254000 1628463600 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;} 3 labelworx 5054285992357 GBKQU2171289 N Bring the noise recordings Liam Mcnamara 1624684804 Y 2021-12-17 17:37:27 0
97670 TMP181 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 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 Tempo Trax Paul Norris/Matt Clarkson/Ian Jay 1626177565 Y 2021-12-17 17:37:27 0
97704 IA016C P A 1 1.69 1 0.000 0 0 0 0.00 0 1626428334 0 Y N N B N R Y N N Y 10 1626390000 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 Copyright Control Ben Miles 1627208641 Y 2021-12-17 17:37:27 0
97705 ST1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626434052 0 Y N N B N R Y N N Y 10 1626390000 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 Hatfish Music James Nardi 1626434124 Y 2021-12-17 17:37:27 0
97746 HFEP006A P A 1 1.69 1 0.000 0 0 0 0.00 0 1626675499 0 Y N N B N R Y N N Y 10 1626649200 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 Digital Danny Gibson 1626676223 Y 2021-12-17 17:37:27 0
97747 HFEP006B P A 1 1.69 1 0.000 0 0 0 0.00 0 1626675692 0 Y N N B N R Y N N Y 10 1626649200 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 Danny Gibson 1626676239 Y 2021-12-17 17:37:27 0
97748 BDR011 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626680483 0 Y N N B N R Y N N Y 10 1626649200 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 Adrian Buss 1643556951 Y 19/07/2021 18/08/2021 2021-12-17 17:37:27 0
97757 GARHT001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1626994800 0 Y N N B N R Y N N Y 10 1626994800 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 Adam Bellew / Alexie Reynolds 1642255668 Y 23/07/2021 22/08/2021 2021-12-17 17:37:27 0
97896 BB027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627024404 0 Y N N B N R Y N N Y 10 1626994800 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 Robert Healy 1627024525 Y 2021-12-17 17:37:27 0
97899 IA016D P A 1 1.69 1 0.000 0 0 0 0.00 0 1627033221 0 Y N N B N R Y N N Y 10 1626994800 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 Jared Blyth 1627033527 Y 2021-12-17 17:37:27 0
97900 PDR047 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627057308 0 Y N N B N R Y N N Y 10 1626994800 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 Publishing , Copyright Control pat glenny/jake surgey 1642265629 Y 23/07/2021 22/08/2021 2021-12-17 17:37:27 0
97911 BDR012 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627129371 0 Y N N B N R Y N N Y 10 1627081200 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 Hunter 1643556993 Y 24/07/2021 23/08/2021 2021-12-17 17:37:27 0
97916 HF048 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627281350 0 Y N N B N R Y N N Y 10 1627254000 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 Digital Nuro GL/Dylan Stuart 1627281988 Y 2021-12-17 17:37:27 0
97918 ESP076 P A 1 1.69 1 0.000 0 0 0 0.00 0 1627317820 0 Y N N B N R Y N N Y 10 1627254000 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 Energy Source Productions DJ Serenity 1627317925 Y 2021-12-17 17:37:27 0