SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    93059, 93057, 92492, 92956, 92883, 92900, 
    92899, 92898, 92897, 92895, 92834, 
    92808, 92789, 92788, 92765, 92758, 
    92675, 92673, 92291, 92238
  )

Query time 0.00050

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
92238 HOT080 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 1613088000 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;} 4 labelworx 5054285594148 GBKQU2101116 N Copyright Control Dean Richardson 1609869606 Y 2021-12-17 17:37:27 0
92291 ED007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 1613088000 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;} 4 labelworx 5054285599242 GBKQU2102083 N Epidemic Digital FilterFreakz 1610039402 Y 2021-12-17 17:37:27 0
92492 BMR211 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612224000 0 Y N N B N R Y N N Y 10 1612224000 1614643200 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;} 4 labelworx 5054285617205 GBKQU2104686 N Beast Mode Recordings Dylan Stewart, Alexei Reynolds 1610643908 Y 2021-12-17 17:37:27 0
92673 twistedtraxx 75 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 0 N 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;} 4 N sentinelz/twistedtraxx space sentinelz 1611777399 Y 2021-12-17 17:37:27 0
92675 VRC002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Kelly Ward/Scott Chaney 1611187268 Y 2021-12-17 17:37:27 0
92758 RF014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Casey Fournere/Emma Fournere 1611398237 Y 2021-12-17 17:37:27 0
92765 RPR193 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 0 N 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;} 4 AUTOGENERATE N Toolbox Publishing/none Michael Costigan/Richard Jermyn 1611529858 Y 2021-12-17 17:37:27 0
92788 HELL017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Toolbox Publishing Paul Norris / James Jackson 1642352491 Y 2021-12-17 17:37:27 0
92789 FLY008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 0 N 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;} 4 N Copyright Control Bizarre Q 1624430040 Y 2021-12-17 17:37:27 0
92808 GAR001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Jimmy Draycott 1642247625 Y 29/01/2021 28/02/2021 2021-12-17 17:37:27 0
92834 TMP168 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Tempo Trax Paul Hunter, Peter Davidson & Matt Clarkson 1611774275 Y 2021-12-17 17:37:27 0
92883 HHF009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612137600 0 Y N N B N R Y N N Y 10 1612137600 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;} 4 N Copyright Control Artem Svirchevskiy 1611853407 Y 2021-12-17 17:37:27 0
92895 TWDIG001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611878400 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Artem Svirchevskiy 1611854113 Y 2021-12-17 17:37:27 0
92897 BB014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611899511 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Ben Miles, Dave Grabowski 1637683176 Y 2021-12-17 17:37:27 0
92898 TGR073 P A 1 1.69 1 0.000 0 0 0 0.00 0 1611918076 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright control Paul Batten/Richard Whybrow/Matthew Cox 1611919368 Y 2021-12-17 17:37:27 0
92899 IA009A P A 1 1.69 1 0.000 0 0 0 0.00 0 1611923790 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Ben Miles 1611924322 Y 2021-12-17 17:37:27 0
92900 IA009B P A 1 1.69 1 0.000 0 0 0 0.00 0 1611924263 0 Y N N B N R Y N N Y 10 1611878400 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;} 4 N Copyright Control Tara Nicholson 1611924341 Y 2021-12-17 17:37:27 0
92956 HF026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612164499 0 Y N N B N R Y N N Y 10 1612137600 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;} 4 N Toolbox Digital Matt Clarkson/Gary Orton 1612164622 Y 2021-12-17 17:37:27 0
93057 ESP065 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612292961 0 Y N N B N R Y N N Y 10 1612224000 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;} 4 N Energy Source Productions DJ Serenity 1612293326 Y 2021-12-17 17:37:27 0
93059 DD155 P A 1 1.69 1 0.000 0 0 0 0.00 0 1612293854 0 Y N N B N R Y N N Y 10 1612224000 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;} 4 GBKQU2113464 N Copyright Control Nikkdbubble 1612294241 Y 2021-12-17 17:37:27 0