SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    87149, 87148, 87147, 87146, 87478, 87461, 
    87267, 87013, 87012, 86982, 87168, 
    87437, 87163, 87162, 87438, 87288, 
    87287, 87025, 87022, 86884, 88075, 
    88074, 88073, 88072, 87072, 87071, 
    87070, 86983, 86835, 86603, 86602, 
    86601, 87357, 86850, 86849, 86848, 
    86847, 86846, 86845, 86693
  )

Query time 0.00099

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
86601 VDH042 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285104057 GBKQU2052350 N Various Digital Hardcore Overdrive & Monster 1591812440 Y 2021-12-17 17:37:27 0
86602 CR0177 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285143131 GBKQU2059689 N Label Worx Jon Garritty & Joey Riot 1591812442 Y 2021-12-17 17:37:27 0
86603 CR0177 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285143131 GBKQU2059690 N Label Worx Jon Garritty & Joey Riot 1591812442 Y 2021-12-17 17:37:27 0
86693 ONESEVENTY69 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285091142 GBKQU2049925 N Copyright Control Jamie Jackson 1591817724 Y 2021-12-17 17:37:27 0
86835 KTRAR016 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285143193 GBKQU2059702 N Copyright Control Kutski 1591824572 Y 2021-12-17 17:37:27 0
86845 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000055 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86846 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000056 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86847 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000057 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86848 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000058 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86849 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000059 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86850 MOK214 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285155578 NLLB82000060 N Copyright Control Berry Verschuren 1591824582 Y 2021-12-17 17:37:27 0
86884 CRR025 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594422000 0 Y N N B N R Y N N Y 10 1594422000 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 5054285048078 GBKQU2042255 N Copyright Control Fucking Paranoid 1591987204 Y 2021-12-17 17:37:27 0
86982 CF056 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285161685 GBKQU2063187 N Peers Music Chris Fear 1594052822 Y 2021-12-17 17:37:27 0
86983 HTTC006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285172513 GBKQU2065041 N Hard To The Core Digital Audio Nitrate & Jay G 1594052824 Y 2021-12-17 17:37:27 0
87012 CR0179 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285143261 GBKQU2059710 N Label Worx Rik Norton-Wilkes & John Langton 1594052851 Y 2021-12-17 17:37:27 0
87013 CR0179 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285143261 GBKQU2059711 N Label Worx Rik Norton-Wilkes & John Langton 1594052851 Y 2021-12-17 17:37:27 0
87022 CRR026 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285048092 GBKQU2042257 N Copyright Control Syndrome 1594052862 Y 2021-12-17 17:37:27 0
87025 STI0142 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285108932 GBKQU2053277 N copyright control Solo 1594052866 Y 2021-12-17 17:37:27 0
87070 Hells040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285177624 GBKQU2065935 N Hell's recordings D. vd Berkmortel 1594052908 Y 2021-12-17 17:37:27 0
87071 Hells040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285177624 GBKQU2065936 N Hell's recordings D. vd Berkmortel 1594052908 Y 2021-12-17 17:37:27 0
87072 Hells040 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285177624 GBKQU2065937 N Hell's recordings D. vd Berkmortel 1594052909 Y 2021-12-17 17:37:27 0
87146 DARKUL014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285138762 GBKQU2058845 N Copyright Control M.Furlin, Hannes Fuehrer 1594052988 Y 2021-12-17 17:37:27 0
87147 DARKUL014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285138762 GBKQU2058846 N Copyright Control M.Furlin, Hannes Fuehrer 1594052989 Y 2021-12-17 17:37:27 0
87148 DARKUL014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285138762 GBKQU2058847 N Copyright Control M.Furlin, Hannes Fuehrer 1594052989 Y 2021-12-17 17:37:27 0
87149 DARKUL014 P A 1 1.69 1 0.000 0 0 0 0.00 0 1595199600 0 Y N N B N R Y N N Y 10 1595199600 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 5054285138762 GBKQU2058848 N Copyright Control M.Furlin, Hannes Fuehrer 1594052989 Y 2021-12-17 17:37:27 0
87162 CR0178 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594681200 0 Y N N B N R Y N N Y 10 1594681200 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 5054285143216 GBKQU2059705 N Label Worx Neil Lowndes 1594053005 Y 2021-12-17 17:37:27 0
87163 CR0178 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594681200 0 Y N N B N R Y N N Y 10 1594681200 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 5054285143216 GBKQU2059706 N Label Worx Neil Lowndes 1594053005 Y 2021-12-17 17:37:27 0
87168 STI0143 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594767600 0 Y N N B N R Y N N Y 10 1594767600 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 5054285108956 GBKQU2053281 N copyright control Pez 1594053010 Y 2021-12-17 17:37:27 0
87267 STI0144 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285108987 GBKQU2053284 N Copyright Control Delgado 1594054331 Y 2021-12-17 17:37:27 0
87287 ARCD002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285182246 GBKQU2066805 N 87289 Copyright Control Various Artists 1594054345 Y 2021-12-17 17:37:27 0
87288 ARCD002 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285182246 GBKQU2066806 N 87289 Copyright Control Various Artists 1594054345 Y 2021-12-17 17:37:27 0
87357 TOKDD15 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594249200 0 Y N N B N R Y N N Y 10 1594249200 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 5054285172957 GBKQU2065098 N Tears of Kunlun Olly Clapp 1594054447 Y 2021-12-17 17:37:27 0
87437 DNZF812 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594681200 0 Y N N B N R Y N N Y 10 1594681200 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 5054285215685 GBKQU2073192 N DNZ Records Zero Range 1594055010 Y 2021-12-17 17:37:27 0
87438 JH281 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594594800 0 Y N N B N R Y N N Y 10 1594594800 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 5054285215500 GBKQU2073164 N Copyright Control EzKiLL & A.N.T 1594055028 Y 2021-12-17 17:37:27 0
87461 HTTC007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285172711 GBKQU2065077 N Hard To The Core Digital Jay G 1594055321 Y 2021-12-17 17:37:27 0
87478 CRR027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594940400 0 Y N N B N R Y N N Y 10 1594940400 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 5054285054369 GBKQU2043500 N Copyright Control Fatal Footwork Freaks 1594055403 Y 2021-12-17 17:37:27 0
88072 247HC202 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285197769 UKT6B2000083 N copyright control K.Fitzharris 1596652592 Y 2021-12-17 17:37:27 0
88073 247HC202 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285197769 UKT6B2000082 N copyright control K.Fitzharris 1596652601 Y 2021-12-17 17:37:27 0
88074 247HC202 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285197769 UKT6B2000084 N copyright control K.Fitzharris 1596652616 Y 2021-12-17 17:37:27 0
88075 247HC202 P A 1 1.69 1 0.000 0 0 0 0.00 0 1594335600 0 Y N N B N R Y N N Y 10 1594335600 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 5054285197769 UKT6B2000085 N copyright control K.Fitzharris 1596652629 Y 2021-12-17 17:37:27 0