SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    109465, 109886, 109742, 109741, 109740, 
    109739, 109448, 109447, 109446, 109445, 
    109444, 109376, 122293, 122292, 122291, 
    122290, 122289, 122288, 122287, 122286
  )

Query time 0.00049

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
109376 STDIGI066 P A 1 1.69 1 0.000 0 0 0 0.00 0 1664924400 0 Y N N B N R Y N N Y 10 1664924400 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 5054286891734 GBKQU2282057 N Smiley Tunes Digital Michael Zhuchkov 1665125774 Y 2022-09-05 18:15:03 0
109444 ATECH12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286892861 GBKQU2282257 N Copyright Control R. Besgrove 1662441302 Y 2022-09-06 06:15:02 0
109445 ATECH12 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286892861 GBKQU2282258 N Copyright Control R. Besgrove 1662441305 Y 2022-09-06 06:15:05 0
109446 MOK266 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286889809 NLLB82200099 N Copyright Control Sergey Rubtsov 1662441306 Y 2022-09-06 06:15:06 0
109447 MOK266 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286889809 NLLB82200100 N Copyright Control Sergey Rubtsov 1662441307 Y 2022-09-06 06:15:07 0
109448 MOK266 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286889809 NLLB82200101 N Copyright Control Sergey Rubtsov 1662441307 Y 2022-09-06 06:15:07 0
109465 Cheek599 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665097200 0 Y N N B N R Y N N Y 10 1665097200 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 5054286819998 GBKQU2270788 N Copyright Control Lee Dagger, Stephen Timothy 1662529502 Y 2022-09-07 06:45:02 0
109739 CATID107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286922582 NLN6L2200033 N The Funky Cat Publishing C.S. Jensen 1663696810 Y 2022-09-20 19:00:10 0
109740 CATID107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286922582 NLN6L2200034 N The Funky Cat Publishing C.S. Jensen 1663696810 Y 2022-09-20 19:00:10 0
109741 CATID107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286922582 NLN6L2200035 N The Funky Cat Publishing C.S. Jensen 1663696810 Y 2022-09-20 19:00:10 0
109742 CATID107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286922582 NLN6L2200036 N The Funky Cat Publishing C.S. Jensen 1663696810 Y 2022-09-20 19:00:10 0
109886 XLUSIVE004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1665010800 0 Y N N B N R Y N N Y 10 1665010800 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 5054286942443 GBKQU2289996 N Abel Valcarcel Millan, Andriy Ursaki Abel Valcarcel Millan 1664298903 Y 2022-09-27 18:15:03 0
122286 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62124267 N 122294 Copyright Control Various Artists 1708046869 Y 2024-02-16 02:09:27 0
122287 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBKQU2194553 N 122294 Copyright Control Various Artists 1708046897 Y 2024-02-16 02:09:48 0
122288 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62121251 N 122294 Copyright Control Various Artists 1708046943 Y 2024-02-16 02:10:09 0
122289 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62128321 N 122294 Copyright Control Various Artists 1708046969 Y 2024-02-16 02:10:14 0
122290 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62115653 N 122294 Copyright Control Various Artists 1708046996 Y 2024-02-16 02:10:20 0
122291 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62111117 N 122294 Copyright Control Various Artists 1708047025 Y 2024-02-16 02:10:27 0
122292 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBKQU2139842 N 122294 Copyright Control Various Artists 1708047052 Y 2024-02-16 02:10:33 0
122293 LWHTS05b P A 1 1.69 1 0.000 0 0 0 0.00 0 1664751600 0 Y N N B N R Y N N Y 10 1664751600 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 5054288017941 GBLV62102581 N 122294 Copyright Control Various Artists 1708047077 Y 2024-02-16 02:10:39 0