SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    77318, 77094, 76484, 77518, 77246, 77080, 
    77507, 76443, 77045, 76891, 76890, 
    76264, 76889, 76152, 76151, 76150, 
    76149, 76148, 76147, 76146
  )

Query time 0.00044

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
76146 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886639 N 76153 Peer Music Al Storm 1556946024 Y 2021-12-17 17:37:27 0
76147 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886640 N 76153 Peer Music Al Storm 1556946024 Y 2021-12-17 17:37:27 0
76148 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886641 N 76153 Peer Music Al Storm 1556946025 Y 2021-12-17 17:37:27 0
76149 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886642 N 76153 Peer Music Al Storm 1556946025 Y 2021-12-17 17:37:27 0
76150 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886643 N 76153 Peer Music Al Storm 1556946025 Y 2021-12-17 17:37:27 0
76151 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886644 N 76153 Peer Music Al Storm 1556946025 Y 2021-12-17 17:37:27 0
76152 247HCLP006DL P A 1 1.69 1 0.000 0 0 0 0.00 0 1559257200 0 Y N N B N R Y N N Y 10 1559257200 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 5054284152479 GBKQU1886645 N 76153 Peer Music Al Storm 1556946025 Y 2021-12-17 17:37:27 0
76264 FE213 P A 1 1.69 1 0.000 0 0 0 0.00 0 1559862000 0 Y N N B N R Y N N Y 10 1559862000 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 5054284371221 GBKQU1942819 N Fatal Energy Records Dave Parker 1557378016 Y 2021-12-17 17:37:27 0
76443 WAOD037 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560121200 0 Y N N B N R Y N N Y 10 1560121200 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 5054284323442 GBKQU1932262 N Copyright Control R.Scott 1616760101 Y 2021-12-17 17:37:27 0
76484 HGX005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560380400 0 Y N N B N R Y N N Y 10 1560380400 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 5054284385075 GBKQU1945611 N HOURGLAXX Records Kim Tae Joon 1557896447 N 2021-12-17 17:37:27 0
76889 DNZF531 P A 1 1.69 1 0.000 0 0 0 0.00 0 1559602800 0 Y N N B N R Y N N Y 10 1559602800 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 5054284415000 GBKQU1951297 N DNZ Records Garbie Project 1558501201 Y 2021-12-17 17:37:27 0
76890 DNZF533 P A 1 1.69 1 0.000 0 0 0 0.00 0 1559862000 0 Y N N B N R Y N N Y 10 1559862000 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 5054284416762 GBKQU1951749 N DNZ Records Call Of Duty 1558501202 Y 2021-12-17 17:37:27 0
76891 DNZF533 P A 1 1.69 1 0.000 0 0 0 0.00 0 1559862000 0 Y N N B N R Y N N Y 10 1559862000 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 5054284416762 GBKQU1951750 N DNZ Records Call Of Duty 1558501202 Y 2021-12-17 17:37:27 0
77045 DNZF534 P A 1 1.69 1 0.000 0 0 0 0.00 0 1559948400 0 Y N N B N R Y N N Y 10 1559948400 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 5054284423555 GBKQU1953460 N DNZ Records Garbie Project 1558846814 Y 2021-12-17 17:37:27 0
77080 DNZF537 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560207600 0 Y N N B N R Y N N Y 10 1560207600 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 5054284428055 GBKQU1954271 N DNZ Records Paul Garbie 1559192407 Y 2021-12-17 17:37:27 0
77094 PTR098 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560380400 0 Y N N B N R Y N N Y 10 1560380400 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 5054284427010 GBKQU1954116 N Power Tracks Records Power Tracks Records 1559278802 Y 2021-12-17 17:37:27 0
77246 DNZF536 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560207600 0 Y N N B N R Y N N Y 10 1560207600 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 5054284440811 GBKQU1956985 N DNZ Records Que & Rkay 1559710850 Y 2021-12-17 17:37:27 0
77318 DNZF539 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560380400 0 Y N N B N R Y N N Y 10 1560380400 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 5054284442266 GBKQU1957256 N DNZ Records Jamie B 1559797384 Y 2021-12-17 17:37:27 0
77507 UND0001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560195948 0 Y N N B N R Y N N Y 10 1560121200 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;} QZS1Z1632594 N Undiscovered Digital D03 1560196819 Y 2021-12-17 17:37:27 0
77518 UND0018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1560277921 0 Y N N B N R Y N N Y 10 1560207600 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;} QZ5FN1853469 N Undiscovered Digital Tamerax 1560278722 Y 2021-12-17 17:37:27 0