SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    33254, 33242, 33256, 33188, 33166, 33156, 
    30927, 30717, 30722, 32940, 30583, 
    30529, 30453, 30452, 30403, 30402, 
    30300, 30294, 30291, 30255
  )

Query time 0.00063

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
30255 ACTD040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1395878400 0 Y N N B N R Y N N Y 10 1395878400 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 5054281053045 GBKQU1421563 N Active Sound Records Ginex Asiss 1395378023 Y 2021-12-17 17:37:27 0
30291 OMP007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1395964800 0 Y N N B N R Y N N Y 10 1395964800 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 5054281024694 GBKQU1415066 N OMPTraxx Audio Hedz, Dean E & Allan E 1395997808 Y 2021-12-17 17:37:27 0
30294 EDD057 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396051200 0 Y N N B N R Y N N Y 10 1396051200 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 5054281047471 GBKQU1420263 N Emotive Dance Digital Peters TDJ. 1396252192 Y 2021-12-17 17:37:27 0
30300 YEAH069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396220400 0 Y N N B N R Y N N Y 10 1396220400 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 5054281011724 GB2P41400012 N Yeah Boi Recordings Bowie666 1395723619 Y 2021-12-17 17:37:27 0
30402 AA049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396306800 0 Y N N B N R Y N N Y 10 1396306800 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 5054281033573 GBKQU1416946 N Audio Abuse Recordings Kye Shand 1397037969 Y 2021-12-17 17:37:27 0
30403 AA049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396306800 0 Y N N B N R Y N N Y 10 1396306800 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 5054281033573 GBKQU1416947 N Audio Abuse Recordings Kye Shand 1397037986 Y 2021-12-17 17:37:27 0
30452 BS002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396566000 0 Y N N B N R Y N N Y 10 1396566000 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 5054281058965 GBKQU1422833 N Basics Hard Music Company Alvaro Vargas, Miguel Aimeur & Neira 1397045296 Y 2021-12-17 17:37:27 0
30453 BS002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396566000 0 Y N N B N R Y N N Y 10 1396566000 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 5054281058965 GBKQU1422834 N Basics Hard Music Company Alvaro Vargas, Miguel Aimeur & Neira 1397045309 Y 2021-12-17 17:37:27 0
30529 ACTD039 P A 1 1.69 1 0.000 0 0 0 0.00 0 1396911600 0 Y N N B N R Y N N Y 10 1396911600 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 5054281079755 GBKQU1427110 N Active Sound Records Jonathan Leyton 1396414802 Y 2021-12-17 17:37:27 0
30583 BS003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1397170800 0 Y N N B N R Y N N Y 10 1397170800 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 5054281058972 GBKQU1422835 N Basic Hard Music Company Miguel Aimeur 1397210113 Y 2021-12-17 17:37:27 0
30717 HNRS033 P A 1 1.69 1 0.000 0 0 0 0.00 0 1397775600 0 Y N N B N R Y N N Y 10 1397775600 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 5054281068506 GBKQU1424735 N Hardnoise Records Vengeance 1397278852 Y 2021-12-17 17:37:27 0
30722 BR029 P A 1 1.69 1 0.000 0 0 0 0.00 0 1397430000 0 Y N N B N R Y N N Y 10 1397430000 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;} GBKQU1409806 N Blessed Recordings Aaron Curtis/Martin Dean/Adam Davies 1507056906 Y 2021-12-17 17:37:27 0
30927 dan020mx P A 1 1.69 1 0.000 0 0 0 0.00 0 1398121200 0 Y N N B N R Y N N Y 10 1398121200 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 5054281041684 ES60B1400137 N Squad Music SL Bounce Warriors 1398158079 Y 2021-12-17 17:37:27 0
32940 DNZ107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1397343600 0 Y N N B N R Y N N Y 10 1397343600 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 5054281109148 GBKQU1433803 N DNZ Records Miky One Dj 1397711178 Y 2021-12-17 17:37:27 0
33156 LWFHDC14 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398294000 0 Y N N B N R Y N N Y 10 1398294000 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 5054281053496 GBKQU1338413 N 33162 Copyright Control Various Artists 1398326665 Y 2021-12-17 17:37:27 0
33166 HNRS034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398380400 0 Y N N B N R Y N N Y 10 1398380400 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 5054281077737 GBKQU1426719 N Hardnoise Records Dejotalberto 1398413262 Y 2021-12-17 17:37:27 0
33188 OMP009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398380400 0 Y N N B N R Y N N Y 10 1398380400 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 5054281106741 GBKQU1433319 N OMPTraxx Audio Hedz 1397883666 Y 2021-12-17 17:37:27 0
33242 ACTD042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398639600 0 Y N N B N R Y N N Y 10 1398639600 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 5054281096042 GBKQU1430828 N Active Sound Records Kernnel 1398142893 Y 2021-12-17 17:37:27 0
33254 DNZ106 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398812400 0 Y N N B N R Y N N Y 10 1398812400 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 5054281096066 GBKQU1430834 N DNZ Records Dj Suko 1398315607 Y 2021-12-17 17:37:27 0
33256 OMP008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1398380400 0 Y N N B N R Y N N Y 10 1398380400 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 5054281106628 GBKQU1433283 N OMPTraxx Mark Hybridz & Audio Hedz 1398413414 Y 2021-12-17 17:37:27 0