SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    62636, 62635, 62634, 62633, 62632, 62631, 
    62630, 62629, 62628, 62627, 62626, 
    62625, 62611, 62609, 62607, 62569, 
    62456, 61887, 60269, 62370, 62342, 
    62098, 62097, 61770, 61769, 61704, 
    60784, 60268, 62217, 61403, 61442, 
    62055, 61886, 61768, 60787, 60267, 
    62105, 61512, 62019, 61960
  )

Query time 0.00066

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 40 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
60267 HIOKT097 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505430000 0 Y N N B N R Y N N Y 10 1505430000 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 Adam Martin / Mark Tench 1499290462 Y 2021-12-17 17:37:27 0
60268 HIOKT098 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 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 Adam Martin / Mark Tench 1499290597 Y 2021-12-17 17:37:27 0
60269 HIOKT099 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506639600 0 Y N N B N R Y N N Y 10 1506639600 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 Adam Martin / Mark Tench 1499290680 Y 2021-12-17 17:37:27 0
60784 FBR276 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 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 Aaron Price 1501099049 Y 2021-12-17 17:37:27 0
60787 FBR279 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505430000 0 Y N N B N R Y N N Y 10 1505430000 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 Craig Jones 1501099283 Y 2021-12-17 17:37:27 0
61403 FE095 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505689200 0 Y N N B N R Y N N Y 10 1505689200 1506898800 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;} 1 labelworx 5054283182620 GBKQU1779950 N Fatal Energy Records Ilya Popov, Hagane Shizuka 1505981841 Y 2021-12-17 17:37:27 0
61442 DT081 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505516400 0 Y N N B N R Y N N Y 10 1505516400 1506726000 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 5054283193343 GBKQU1781976 N Devious Trax Dale West 1503550877 Y 2021-12-17 17:37:27 0
61512 AAA146 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505343600 0 Y N N B N R Y N N Y 10 1505343600 1506553200 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;} 3 labelworx 5054283199710 GBKQU1783218 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1503637209 Y 2021-12-17 17:37:27 0
61704 DB015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 1507244400 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 5054283215571 GBKQU1786231 N Drop Bear Digital Dan Hall, Mark Hard 1504328514 Y 2021-12-17 17:37:27 0
61768 VCR248 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505430000 0 Y N N B N R Y N N Y 10 1505430000 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 Defensive Music Ben Stevens / Anthony Ratcliffe 1504605066 Y 2021-12-17 17:37:27 0
61769 VCR249 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 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 Andy Farley / Paul Glazby 1504605592 Y 2021-12-17 17:37:27 0
61770 VCR249 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 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 Andy Farley / Paul Glazby 1504605659 Y 2021-12-17 17:37:27 0
61886 PDHH078 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505430000 0 Y N N B N R Y N N Y 10 1505430000 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 Premonition/Taylor/Clack Taylor/Clack 1504812777 Y 2021-12-17 17:37:27 0
61887 PDHH079 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506639600 0 Y N N B N R Y N N Y 10 1506639600 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 Premonition/Pearson Taylor/Pearson 1504813074 Y 2021-12-17 17:37:27 0
61960 TERB015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1504911600 0 Y N N B N R Y N N Y 10 1504911600 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 Ross Homson 1504944965 Y 2021-12-17 17:37:27 0
62019 TBF003 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505170800 0 Y N N B N R Y N N Y 10 1505170800 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 The Bounce Factory Ben Keen / Jamie Russell / Ed Myers 1507050093 Y 2021-12-17 17:37:27 0
62055 FR045 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505430000 0 Y N N B N R Y N N Y 10 1505430000 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 Leigh Jones / Mish Cheeky B 1505295879 Y 2021-12-17 17:37:27 0
62097 Cheek341 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 1507244400 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 5054283236132 GBKQU1707770 N Copyright Control Michael Hagan 1505365330 Y 2021-12-17 17:37:27 0
62098 Cheek341 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 1507244400 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 5054283236132 GBKQU1789865 N Copyright Control Michael Hagan 1505365332 Y 2021-12-17 17:37:27 0
62105 IOD049 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505343600 0 Y N N B N R Y N N Y 10 1505343600 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 Inside Out Digital Danny Gilligan 1505381352 Y 2021-12-17 17:37:27 0
62217 SC060 P A 1 1.69 1 0.000 0 0 0 0.00 0 1505689200 0 Y N N B N R Y N N Y 10 1505689200 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 Hatfish James Hill 1505763606 Y 2021-12-17 17:37:27 0
62342 JAM016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506034800 0 Y N N B N R Y N N Y 10 1506034800 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 UKG3L1700008 N Copyright Control Danny Harris 1506023442 Y 2021-12-17 17:37:27 0
62370 HWR005 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506096831 0 Y N N B N R Y N N Y 10 1506034800 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 UK/LD7/17/00 N Hard West Records Ross Baldwin 1506096923 Y 2021-12-17 17:37:27 0
62456 TND001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506639600 0 Y N N B N R Y N N Y 10 1506639600 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 Matt Wade/Kenny Seear 1506441471 Y 2021-12-17 17:37:27 0
62569 SSD025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506639600 0 Y N N B N R Y N N Y 10 1506639600 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 Sean Inside Out/D-Fi 1506628191 Y 2021-12-17 17:37:27 0
62607 NEVER023 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506666697 0 Y N N B N R Y N N Y 10 1506639600 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 UKCCW1700008 N Copyright Control Matt Wade/Steve Taylor 1506667525 Y 2021-12-17 17:37:27 0
62609 TMP092 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506694119 0 Y N N B N R Y N N Y 10 1506639600 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 Marc Lewis 1506694522 Y 2021-12-17 17:37:27 0
62611 IOD040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1506704010 0 Y N N B N R Y N N Y 10 1506639600 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 Inside Out Digital Adrian Buss 1506704422 Y 2021-12-17 17:37:27 0
62625 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Adam Jukes / Jon Paul Montgomery / Daley Robinson 1506880667 Y 2021-12-17 17:37:27 0
62626 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Ian Jay / Kris O'Rourke 1506880691 Y 2021-12-17 17:37:27 0
62627 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Eogham Pocock 1506880695 Y 2021-12-17 17:37:27 0
62628 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Truelove Music Paul King 1506880706 Y 2021-12-17 17:37:27 0
62629 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton 1506880719 Y 2021-12-17 17:37:27 0
62630 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton 1506880728 Y 2021-12-17 17:37:27 0
62631 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Robbie Muir 1506880737 Y 2021-12-17 17:37:27 0
62632 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton / Paul King 1506880749 Y 2021-12-17 17:37:27 0
62633 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Benjamin Leung 1506880755 Y 2021-12-17 17:37:27 0
62634 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton 1506880764 Y 2021-12-17 17:37:27 0
62635 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton / Pulse Fiction 1506880769 Y 2021-12-17 17:37:27 0
62636 TBRD20A P A 1 1.69 1 0.000 0 0 0 0.00 0 1506898800 0 Y N N B N R Y N N Y 10 1506898800 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 Copyright Control Nik Denton 1506880783 Y 2021-12-17 17:37:27 0