SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    14641, 14640, 14637, 14635, 14634, 14633, 
    14632, 14631, 14630, 14629, 14628, 
    14627, 14626, 14481, 14480, 14482, 
    24684, 24683, 14436, 14434, 14438, 
    14437, 14411, 16539, 14409, 14410, 
    14101, 14138, 14137, 31447, 31446, 
    31445, 31444, 31443, 31442, 31441, 
    31440, 31439, 31438, 31437
  )

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
14101 ATMOSUKDIG027 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361923208 0 Y N N B N R Y N N Y 10 1361923200 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 5052653524001 GBKQU1343489 N Copyright Control Toby Veale 0 Y 2021-12-17 17:37:27 0
14137 HARD063 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361923201 0 Y N N B N R Y N N Y 10 1361923200 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 5052653512237 GBKQU1340968 N SDK Rekords Sadowick 0 Y 2021-12-17 17:37:27 0
14138 HARD063 P A 1 1.69 1 0.000 0 0 0 0.00 0 1361923202 0 Y N N B N R Y N N Y 10 1361923200 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 5052653512237 GBKQU1340969 N SDK Rekords Sadowick 0 Y 2021-12-17 17:37:27 0
14409 AD007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362009616 0 Y N N B N R Y N N Y 10 1362009600 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 5052653519748 GBKQU1342481 N Absolution Digital Danny Williamson 0 Y 2021-12-17 17:37:27 0
14410 AD007 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362009615 0 Y N N B N R Y N N Y 10 1362009600 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 5052653519748 GBKQU1342482 N Absolution Digital Danny Williamson 0 Y 2021-12-17 17:37:27 0
14411 DNZ053 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362182400 0 Y N N B N R Y N N Y 10 1362182400 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 5052653536196 GBKQU1345756 N Salva Mercader Salva Mercader 0 Y 2021-12-17 17:37:27 0
14434 FLMBD030 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362355221 0 Y N N B N R Y N N Y 10 1362355200 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 5052653523905 GBKQU1343454 N Flammable Records Junky Twins 0 Y 2021-12-17 17:37:27 0
14436 RIOT113 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362355221 0 Y N N B N R Y N N Y 10 1362355200 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 5052653507363 GBKQU1339999 N Copyright Control Scott Attrill 0 Y 2021-12-17 17:37:27 0
14437 DNZ061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362355217 0 Y N N B N R Y N N Y 10 1362355200 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 5052653540216 GBKQU1346598 N Ginxi Dj Ginxi Dj 0 Y 2021-12-17 17:37:27 0
14438 DNZ061 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362355218 0 Y N N B N R Y N N Y 10 1362355200 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 5052653540216 GBKQU1346599 N Ginxi Dj Ginxi Dj 0 Y 2021-12-17 17:37:27 0
14480 HARD064 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362528004 0 Y N N B N R Y N N Y 10 1362528000 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 5052653529693 GBKQU1344517 N SDK Rekords Sadowick 0 Y 2021-12-17 17:37:27 0
14481 UV013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362528004 0 Y N N B N R Y N N Y 10 1362528000 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 5052653536950 AU5U41200028 N Copyright Control N. Zupan 0 Y 2021-12-17 17:37:27 0
14482 UV013 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362528002 0 Y N N B N R Y N N Y 10 1362528000 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 5052653536950 AU5U41200029 N Copyright Control N. Zupan 0 Y 2021-12-17 17:37:27 0
14626 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960002 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBKQU1140145 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14627 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960003 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBKQU1271208 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14628 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960004 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBKQU1278501 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14629 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960005 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 NLEY10800066 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14630 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960006 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100015 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14631 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960007 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100070 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14632 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960008 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100007 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14633 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960009 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100009 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14634 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960010 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100030 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14635 IHDSB008 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960011 0 Y N N B N R Y N N Y 10 1362960000 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 5052653536844 GBX7Q1100013 N 14636 Various Various 0 Y 2021-12-17 17:37:27 0
14637 TR105 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960013 0 Y N N B N R Y N N Y 10 1362960000 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 5052653570015 GBKQU1353187 N Copyright Control Cut Up 0 Y 2021-12-17 17:37:27 0
14640 RIOTCDD018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960016 0 Y N N B N R Y N N Y 10 1362960000 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 5052653525695 GBKQU1135488 N Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
14641 RIOTCDD018 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362960017 0 Y N N B N R Y N N Y 10 1362960000 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 5052653525695 GBKQU1288279 N Copyright Control Various Artists 0 Y 2021-12-17 17:37:27 0
16539 MCV03 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362009618 0 Y N N B N R Y N N Y 10 1362009600 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;} 5052653499668 GBKQU1238256 N Defensive Music Ltd. Clayton Yellowwings 0 N 2021-12-17 17:37:27 0
24683 COMPLEX015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362528000 0 Y N N B N R Y N N Y 10 1362528000 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 5052653521291 GBKQU1342833 N SDK Rekords Sadowick 1392806584 Y 2021-12-17 17:37:27 0
24684 COMPLEX015 P A 1 1.69 1 0.000 0 0 0 0.00 0 1362528000 0 Y N N B N R Y N N Y 10 1362528000 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 5052653521291 GBKQU1342834 N SDK Rekords Sadowick 1392806586 Y 2021-12-17 17:37:27 0
31437 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 GBKQU1212967 N 31448 Copyright Control Various Artists 1397626105 Y 2021-12-17 17:37:27 0
31438 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 AU5U41200022 N 31448 Copyright Control Various Artists 1397626107 Y 2021-12-17 17:37:27 0
31439 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 GBKQU1202747 N 31448 Copyright Control Various Artists 1397626109 Y 2021-12-17 17:37:27 0
31440 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 GBACM1200231 N 31448 Copyright Control Various Artists 1397626110 Y 2021-12-17 17:37:27 0
31441 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 GBKQU1213325 N 31448 Copyright Control Various Artists 1397626112 Y 2021-12-17 17:37:27 0
31442 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 GBKQU1295286 N 31448 Copyright Control Various Artists 1397626114 Y 2021-12-17 17:37:27 0
31443 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 GBKQU1211114 N 31448 Copyright Control Various Artists 1397626116 Y 2021-12-17 17:37:27 0
31444 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 GBKQU1208316 N 31448 Copyright Control Various Artists 1397626118 Y 2021-12-17 17:37:27 0
31445 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 GBKQU1210140 N 31448 Copyright Control Various Artists 1397626120 Y 2021-12-17 17:37:27 0
31446 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 GBKQU1207007 N 31448 Copyright Control Various Artists 1397626122 Y 2021-12-17 17:37:27 0
31447 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 GBKQU1214986 N 31448 Copyright Control Various Artists 1397626124 Y 2021-12-17 17:37:27 0