SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    5362, 5352, 5694, 5693, 5692, 5691, 5686, 
    5676, 5634, 5940, 26680, 6076, 6072, 
    6067, 6413, 6421, 6517, 6474, 6380, 
    6790
  )

Query time 0.00053

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
5352 DEFCA05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323043200 0 Y N N B N R Y N N Y 10 1323043200 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 152391 5052653150385 GBKQU1029463 N 5380 23rd Precinct & Copyright Control Various 1393510373 Y 2021-12-17 17:37:27 0
5362 DEFCA05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1323043200 0 Y N N B N R Y N N Y 10 1323043200 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 152401 5052653150385 GBKQU1140088 N 5380 23rd Precinct & Copyright Control Various 1393510515 Y 2021-12-17 17:37:27 0
5634 AWSUMCD01IT P A 1 1.69 1 0.000 0 0 0 0.00 0 1320624000 0 Y N N B N R Y N N Y 10 1320624000 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 151715 5052653150941 GBKQU1158521 N Various Various 1393503037 Y 2021-12-17 17:37:27 0
5676 AWSUMCD001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1320624000 0 Y N N B N R Y N N Y 10 1320624000 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 149793 5052653150972 GBKQU1158555 N 5683 Various Various 1393503046 Y 2021-12-17 17:37:27 0
5686 DEFCA02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1321228800 0 Y N N B N R Y N N Y 10 1321228800 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 152354 5052653134569 GBKQU1140088 N 5695 23rd Precinct & Copyright Control Various 1393510523 Y 2021-12-17 17:37:27 0
5691 DEFCA02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1321228800 0 Y N N B N R Y N N Y 10 1321228800 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 152359 5052653134569 GBKQU1021725 N 5695 23rd Precinct & Copyright Control Various 1393510485 Y 2021-12-17 17:37:27 0
5692 DEFCA02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1321228800 0 Y N N B N R Y N N Y 10 1321228800 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 152360 5052653134569 GBKQU1142371 N 5695 23rd Precinct & Copyright Control Various 1393510441 Y 2021-12-17 17:37:27 0
5693 DEFCA02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1321228800 0 Y N N B N R Y N N Y 10 1321228800 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 152361 5052653134569 GBKQU1029463 N 5695 23rd Precinct & Copyright Control Various 1393510363 Y 2021-12-17 17:37:27 0
5694 DEFCA02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1321228800 0 Y N N B N R Y N N Y 10 1321228800 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 152362 5052653134569 GBKQU1149039 N 5695 23rd Precinct & Copyright Control Various 1393510325 Y 2021-12-17 17:37:27 0
5940 NUSM007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1319410800 0 Y N N B N R Y N N Y 10 1319410800 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 132403 5052653116480 GBKQU1150992 N Copyright Control DJ Ransome 1393511293 Y 2021-12-17 17:37:27 0
6067 DEFC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1316991600 0 Y N N B N R Y N N Y 10 1316991600 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 152313 5052653128216 GBKQU1140088 N 6078 23rd Precinct & Copyright Control Various 1393510532 Y 2021-12-17 17:37:27 0
6072 DEFC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1316991600 0 Y N N B N R Y N N Y 10 1316991600 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 152318 5052653128216 GBKQU1149039 N 6078 23rd Precinct & Copyright Control Various 1393510335 Y 2021-12-17 17:37:27 0
6076 DEFC02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1316991600 0 Y N N B N R Y N N Y 10 1316991600 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 152322 5052653128216 GBKQU1142371 N 6078 23rd Precinct & Copyright Control Various 1393510451 Y 2021-12-17 17:37:27 0
6380 UDT02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1312585200 0 Y N N B N R Y N N Y 10 1312585200 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 138222 5052653129718 GBKQU1154013 N Underdog Trax Perifal 1393514580 Y 2021-12-17 17:37:27 0
6413 UDT04 P A 1 1.69 1 0.000 0 0 0 0.00 0 1314313200 0 Y N N B N R Y N N Y 10 1314313200 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 138244 5052653129756 GBKQU1154017 N Underdog Trax Mooney 1393514214 Y 2021-12-17 17:37:27 0
6421 AWSMB004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1313967600 0 Y N N B N R Y N N Y 10 1313967600 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 126998 5052653108102 GBKQU1149043 N 6426 Various Various 1393259449 Y 2021-12-17 17:37:27 0
6474 DEF55 P A 1 1.69 1 0.000 0 0 0 0.00 0 1313362800 0 Y N N B N R Y N N Y 10 1313362800 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 152163 5052653108096 GBKQU1149039 N Copyright Control Copyright Control 1393510347 Y 2021-12-17 17:37:27 0
6517 UDT03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1313794800 0 Y N N B N R Y N N Y 10 1313794800 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 138231 5052653129732 GBKQU1154015 N Underdog Trax Streamline 1393514310 Y 2021-12-17 17:37:27 0
6790 DEF52 P A 1 1.69 1 0.000 0 0 0 0.00 0 1310252400 0 Y N N B N R Y N N Y 10 1310252400 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 152108 5052653079990 GBKQU1142371 N Copyright Control R.Cain & M.Di Scala 1393510462 Y 2021-12-17 17:37:27 0
26680 247HC051 P A 1 1.69 1 0.000 0 0 0 0.00 0 1318546800 0 Y N N B N R Y N N Y 10 1318546800 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 5052653128131 GBKQU1153641 N All-Media Music Taylor, Littlewood, Hazell 1392874059 Y 2021-12-17 17:37:27 0