SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    102182, 102181, 101847, 101846, 101845, 
    101844, 101843, 101826, 101825, 101812, 
    101811, 101810, 101707, 101706, 101472, 
    101961, 101699, 101403, 101402, 101401
  )

Query time 0.00066

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
101401 JTM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643587200 0 Y N N B N R Y N N Y 10 1643587200 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 5054286369028 GBLV62136654 N Copyright Control Janne Tamminen 1641013508 Y 2022-01-01 06:05:08 0
101402 JTM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643587200 0 Y N N B N R Y N N Y 10 1643587200 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 5054286369028 GBLV62136655 N Copyright Control Janne Tamminen 1641013509 Y 2022-01-01 06:05:09 0
101403 JTM005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643587200 0 Y N N B N R Y N N Y 10 1643587200 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 5054286369028 GBLV62136656 N Copyright Control Janne Tamminen 1641013509 Y 2022-01-01 06:05:09 0
101472 FINRGL001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286377030 GBLV62138769 N Copyright Control Jon Grindley 1641360604 Y 2022-01-05 06:30:04 0
101699 OD043 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643587200 0 Y N N B N R Y N N Y 10 1643587200 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;} UKGEQ2200154 N Copyright Control Hagane Shizuka/Emil Abergh 1709279606 Y 0 0 2022-01-16 18:45:20 0
101706 PANDA018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286415305 UKT6B2100272 N Copyright control J.Hartshorn, S.Nurse 1643976278 Y 2022-01-17 18:05:02 0
101707 PANDA018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286415305 UKT6B2100273 N Copyright control J.Hartshorn, S.Nurse 1642439102 Y 2022-01-17 18:05:02 0
101810 KARNAGEDIGITA24 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286419396 GBKQU2206239 N Copyright Control Sebastien Janssens, Mikis Parassiadis 1642525803 Y 2022-01-18 18:10:03 0
101811 KARNAGEDIGITA24 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286419396 GBKQU2206240 N Copyright Control Sebastien Janssens, Mikis Parassiadis 1642525803 Y 2022-01-18 18:10:03 0
101812 KARNAGEDIGITA24 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286419396 GBKQU2206241 N Copyright Control Sebastien Janssens, Mikis Parassiadis 1642525803 Y 2022-01-18 18:10:03 0
101825 247HC250 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286414858 UKT6B2200059 N All-Media Music / Copyright Control D.Heavey 1643976295 Y 2022-01-18 18:15:02 0
101826 247HC250 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286414858 UKT6B2200058 N All-Media Music / Copyright Control D.Heavey 1642526102 Y 2022-01-18 18:15:02 0
101843 247HCLP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286412618 UKT6B2200003 N All-Media Music / Copyright Control D.Edge, D.Heavey 1642527011 Y 2022-01-18 18:30:11 0
101844 247HCLP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286412618 UKT6B2200004 N All-Media Music / Copyright Control D.Edge, D.Heavey 1642527011 Y 2022-01-18 18:30:11 0
101845 247HCLP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286412618 UKT6B2200005 N All-Media Music / Copyright Control D.Edge, D.Heavey 1642527011 Y 2022-01-18 18:30:11 0
101846 247HCLP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286412618 UKT6B2200006 N All-Media Music / Copyright Control D.Edge, D.Heavey 1642527012 Y 2022-01-18 18:30:12 0
101847 247HCLP010 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286412618 UKT6B2200008 N All-Media Music / Copyright Control D.Edge, D.Heavey 1642527012 Y 2022-01-18 18:30:12 0
101961 DARKULLP004t01 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643846400 0 Y N N B N R Y N N Y 10 1643846400 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 5054286430599 GBKQU2208233 N Copyright Control Paula Vigara Vives 1642784709 Y 2022-01-21 18:05:09 0
102181 XTR037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286457008 GBKQU2212171 N Luca Bragaglia, Stefano Zucchelli, Andriy Ursaki, Emanuele Agostinetto Luca Bragaglia, Stefano Zucchelli 1643865002 Y 2022-02-03 06:10:02 0
102182 XTR037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1643932800 0 Y N N B N R Y N N Y 10 1643932800 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 5054286457008 GBKQU2212172 N Luca Bragaglia, Stefano Zucchelli, Andriy Ursaki, Emanuele Agostinetto Luca Bragaglia, Stefano Zucchelli 1643865002 Y 2022-02-03 06:10:02 0