SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    111575, 112163, 111572, 111571, 111570, 
    111569, 111568, 111567, 111566, 111565, 
    111564, 111563, 111562, 111561, 111560, 
    125112, 112045, 112044, 112043, 110706
  )

Query time 0.00038

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
110706 BRR205 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670198400 0 Y N N B N R Y N N Y 10 1670198400 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 5054287008346 GBKQU2241578 N 110707 Electronic Muzik Organization Various Artists 1667625313 Y 2022-11-05 06:15:13 0
111560 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202338 N 111573 Copyright Control P. de Rooij 1668058272 Y 2022-11-10 06:15:05 0
111561 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202339 N 111573 Copyright Control P. de Rooij 1668058287 Y 2022-11-10 06:15:06 0
111562 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202340 N 111573 Copyright Control P. de Rooij 1668058302 Y 2022-11-10 06:15:07 0
111563 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202341 N 111573 Copyright Control P. de Rooij 1668058318 Y 2022-11-10 06:15:07 0
111564 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202342 N 111573 Copyright Control P. de Rooij 1668058333 Y 2022-11-10 06:15:07 0
111565 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202343 N 111573 Copyright Control P. de Rooij 1668058350 Y 2022-11-10 06:15:07 0
111566 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202344 N 111573 Copyright Control P. de Rooij 1668058364 Y 2022-11-10 06:15:08 0
111567 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202345 N 111573 Copyright Control P. de Rooij 1668058381 Y 2022-11-10 06:15:08 0
111568 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202346 N 111573 Copyright Control P. de Rooij 1668058394 Y 2022-11-10 06:15:08 0
111569 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202347 N 111573 Copyright Control P. de Rooij 1668058409 Y 2022-11-10 06:15:08 0
111570 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202348 N 111573 Copyright Control P. de Rooij 1668058423 Y 2022-11-10 06:15:08 0
111571 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202349 N 111573 Copyright Control P. de Rooij 1668058438 Y 2022-11-10 06:15:09 0
111572 Hells069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287024063 GBLV62202350 N 111573 Copyright Control P. de Rooij 1668058453 Y 2022-11-10 06:15:09 0
111575 MOK270 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670457600 0 Y N N B N R Y N N Y 10 1670457600 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 5054287022618 NLLB82200114 N Copyright Control Milo Brunicardi / Nikita Zazemov 1668057310 Y 2022-11-10 06:15:10 0
112043 UIR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670284800 0 Y N N B N R Y N N Y 10 1670284800 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 5054287067046 GBLV62208903 N Underground Industry Records Kin Wing Lam, Leonard Wieder, Mathias Chavillon 1669657502 Y 2022-11-28 18:45:02 0
112044 UIR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670284800 0 Y N N B N R Y N N Y 10 1670284800 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 5054287067046 GBLV62208904 N Underground Industry Records Kin Wing Lam, Leonard Wieder, Mathias Chavillon 1669657503 Y 2022-11-28 18:45:03 0
112045 UIR021 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670284800 0 Y N N B N R Y N N Y 10 1670284800 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 5054287067046 GBLV62208905 N Underground Industry Records Kin Wing Lam, Leonard Wieder, Mathias Chavillon 1669657503 Y 2022-11-28 18:45:03 0
112163 PCR090 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670371200 0 Y N N B N R Y N N Y 10 1670371200 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 5054287077786 NLS202200169 N 2 Dex Publishing Angelo Zevenhek 1670001325 Y 2022-12-02 18:15:25 0
125112 MGN003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1670284800 0 Y N N B N R Y N N Y 10 1670284800 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 5054288293918 GBKQU2457327 N MEGANESIA Lyndon Parry, Peter Dimou, Dexter Van der Schyff, Greyson Bullen, Bill Evans, Grayson Aitken, Bridget Chappel 1718065828 Y 2024-06-11 01:20:02 0