SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    31436, 31435, 31434, 31433, 31432, 31431, 
    31430, 31429, 31428, 31427, 31426, 
    31425, 31424, 31423, 14017, 13990, 
    13989, 13968, 13987, 13986, 13985, 
    13983, 13982, 13981, 13980, 13979, 
    13978, 13977, 13976, 13975, 13974, 
    13973, 13972, 13971, 13970, 13969, 
    16527, 13892, 13891, 13882
  )

Query time 0.00058

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
13882 DNZ050 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361318402 0 Y N N B N R Y N N Y 10 1361318400 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 5052653531580 GBKQU1344856 N DNZ Records Dj Oskar 0 Y 2021-12-17 17:37:27 0
13891 DDY027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361404808 0 Y N N B N R Y N N Y 10 1361404800 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 5052653517751 GBKQU1342108 N Copyright Chris Meikle, Dean Mcmillan, James Kitcher 0 Y 2021-12-17 17:37:27 0
13892 DDY027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361404808 0 Y N N B N R Y N N Y 10 1361404800 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 5052653517751 GBKQU1342109 N Copyright Chris Meikle, Dean Mcmillan, James Kitcher 0 Y 2021-12-17 17:37:27 0
13968 NGAGED031 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750482 0 Y N N B N R Y N N Y 10 1361750400 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 5052653480024 GBKQU1233364 N 23rd Precinct Cally Gage, Lox & Leigh Green 0 Y 2021-12-17 17:37:27 0
13969 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750422 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339416 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13970 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750423 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339405 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13971 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750424 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339959 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13972 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750425 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339995 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13973 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750426 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339419 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13974 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750427 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1340002 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13975 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750428 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339975 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13976 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750429 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339433 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13977 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750430 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339987 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13978 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750431 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339414 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13979 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750432 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339982 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13980 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750433 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1222645 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13981 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750434 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBU6Z1100025 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13982 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750435 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1237587 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13983 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750436 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1338846 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13985 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750438 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1340008 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13986 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750439 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1273734 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13987 T100P4 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750440 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507509 GBKQU1339425 N 13988 Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
13989 RIOT112 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750482 0 Y N N B N R Y N N Y 10 1361750400 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 5052653507356 GBKQU1339998 N Copyright Control Scott Attrill 0 Y 2021-12-17 17:37:27 0
13990 TR085 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750482 0 Y N N B N R Y N N Y 10 1361750400 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 5052653419611 GBKQU1219430 N Bucks Music Group (Masif Publishing) / Hms Music Publishing A.Bamford, S.Cranny 0 Y 2021-12-17 17:37:27 0
14017 TR086 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361750482 0 Y N N B N R Y N N Y 10 1361750400 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 5052653508773 GBKQU1340280 N Bucks Music Group (Masif) / Copyright Control A.Bamford, M.Tracey. 0 Y 2021-12-17 17:37:27 0
16527 MCV02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361404811 0 Y N N B N R Y N N Y 10 1361404800 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;} 5052653499651 GBKQU1238255 N Defensive Music Ltd. Sharad Shekar, Gabriel Lavesque 0 N 2021-12-17 17:37:27 0
31423 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1211508 N 31448 Copyright Control Various Artists 1397626075 Y 2021-12-17 17:37:27 0
31424 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBMC81200013 N 31448 Copyright Control Various Artists 1397626077 Y 2021-12-17 17:37:27 0
31425 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1218603 N 31448 Copyright Control Various Artists 1397626079 Y 2021-12-17 17:37:27 0
31426 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1211841 N 31448 Copyright Control Various Artists 1397626081 Y 2021-12-17 17:37:27 0
31427 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1217911 N 31448 Copyright Control Various Artists 1397626083 Y 2021-12-17 17:37:27 0
31428 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1215016 N 31448 Copyright Control Various Artists 1397626087 Y 2021-12-17 17:37:27 0
31429 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1210075 N 31448 Copyright Control Various Artists 1397626089 Y 2021-12-17 17:37:27 0
31430 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1214987 N 31448 Copyright Control Various Artists 1397626091 Y 2021-12-17 17:37:27 0
31431 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1214153 N 31448 Copyright Control Various Artists 1397626093 Y 2021-12-17 17:37:27 0
31432 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1214204 N 31448 Copyright Control Various Artists 1397626095 Y 2021-12-17 17:37:27 0
31433 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1213037 N 31448 Copyright Control Various Artists 1397626096 Y 2021-12-17 17:37:27 0
31434 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1215439 N 31448 Copyright Control Various Artists 1397626098 Y 2021-12-17 17:37:27 0
31435 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 GBKQU1213106 N 31448 Copyright Control Various Artists 1397626100 Y 2021-12-17 17:37:27 0
31436 LWFHDC05 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361836800 0 Y N N B N R Y N N Y 10 1361836800 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 5052653545181 ES60B1202366 N 31448 Copyright Control Various Artists 1397626103 Y 2021-12-17 17:37:27 0