SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    95318, 95317, 95316, 95315, 95314, 95313, 
    95312, 95311, 95310, 95309, 95308, 
    95307, 98602, 94670, 94299, 94252, 
    94163, 94162, 94161, 94160
  )

Query time 0.00040

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
94160 HDP003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618354800 0 Y N N B N R Y N N Y 10 1618354800 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 5054285607169 GBKQU1496650 N 94164 mcps copyright control various artists 1615784709 Y 2021-12-17 17:37:27 0
94161 HDP003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618354800 0 Y N N B N R Y N N Y 10 1618354800 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 5054285607169 GBKQU1222647 N 94164 mcps copyright control various artists 1615784709 Y 2021-12-17 17:37:27 0
94162 HDP003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618354800 0 Y N N B N R Y N N Y 10 1618354800 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 5054285607169 GBKQU1270089 N 94164 mcps copyright control various artists 1615784709 Y 2021-12-17 17:37:27 0
94163 HDP003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618354800 0 Y N N B N R Y N N Y 10 1618354800 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 5054285607169 GBKQU1136156 N 94164 mcps copyright control various artists 1615784709 Y 2021-12-17 17:37:27 0
94252 FE348 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618527600 0 Y N N B N R Y N N Y 10 1618527600 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 5054285734544 GBKQU2125175 N Fatal Energy Records Paul Jenkins 1615958411 Y 2021-12-17 17:37:27 0
94299 FE349 P A 1 1.69 1 0.000 0 0 0 0.00 0 1618786800 0 Y N N B N R Y N N Y 10 1618786800 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 5054285734551 GBKQU2125180 N Fatal Energy Records Adian Jones 1616217605 Y 2021-12-17 17:37:27 0
94670 PTR160 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619132400 0 Y N N B N R Y N N Y 10 1619132400 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 5054285801000 GBKQU2137172 N Power Tracks Records Brivi 1617210605 Y 2021-12-17 17:37:27 0
95307 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147872 N 95336 Copyright Control Various Artists 1619457607 Y 2021-12-17 17:37:27 0
95308 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147873 N 95336 Copyright Control Various Artists 1619457607 Y 2021-12-17 17:37:27 0
95309 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147874 N 95336 Copyright Control Various Artists 1619457607 Y 2021-12-17 17:37:27 0
95310 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147875 N 95336 Copyright Control Various Artists 1619457608 Y 2021-12-17 17:37:27 0
95311 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147876 N 95336 Copyright Control Various Artists 1646418498 Y 2021-12-17 17:37:27 0
95312 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147877 N 95336 Copyright Control Various Artists 1646418501 Y 2021-12-17 17:37:27 0
95313 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147878 N 95336 Copyright Control Various Artists 1619457608 Y 2021-12-17 17:37:27 0
95314 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147879 N 95336 Copyright Control Various Artists 1619457608 Y 2021-12-17 17:37:27 0
95315 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147880 N 95336 Copyright Control Various Artists 1619457609 Y 2021-12-17 17:37:27 0
95316 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147881 N 95336 Copyright Control Various Artists 1619457609 Y 2021-12-17 17:37:27 0
95317 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147882 N 95336 Copyright Control Various Artists 1619457609 Y 2021-12-17 17:37:27 0
95318 HDCHDM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619564400 0 Y N N B N R Y N N Y 10 1619564400 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 5054285866955 GBKQU2147883 N 95336 Copyright Control Various Artists 1619457610 Y 2021-12-17 17:37:27 0
98602 RR056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1619391600 0 Y N N B N R Y N N Y 10 1619391600 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;} CA5KR2160123 N n/a Laura Maygrove 1629943226 Y 2021-12-17 17:37:27 0