SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    58722, 59121, 58587, 58854, 58778, 58646, 
    58357, 57734, 58959, 58958, 58961, 
    58952, 58951, 58950, 58949, 58948, 
    58947, 58946, 58945, 58944, 58943, 
    58942, 58941, 58940, 58939, 58938, 
    58937, 58936, 58935, 58934, 58933, 
    58932, 58931, 58930, 58929, 58928, 
    58927, 58926, 58925, 58924
  )

Query time 0.00059

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
57734 FD024D P A 1 1.69 1 0.000 0 0 0 0.00 0 1494543600 0 Y N N B N R Y N N Y 10 1494543600 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 Frantic Digital Wayne German 1514891056 Y 2021-12-17 17:37:27 0
58357 INDNEW001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494543600 0 Y N N B N R Y N N Y 10 1494543600 1496962800 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;} 1 labelworx 5054282969697 GBKQU1740898 N Industry Music Benjamin Collie 1492146011 Y 2021-12-17 17:37:27 0
58587 XTRA107 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494889200 0 Y N N B N R Y N N Y 10 1494889200 1496098800 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 5054282988674 GBKQU1744505 N Xtrahard Records Baz Coleman 1493269207 Y 2021-12-17 17:37:27 0
58646 PDHH069 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494543600 0 Y N N B N R Y N N Y 10 1494543600 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 Phillips/Banks Dion Phillips/Tara Banks 1493680165 Y 2021-12-17 17:37:27 0
58722 DB009 P A 1 1.69 1 0.000 0 0 0 0.00 0 1495148400 0 Y N N B N R Y N N Y 10 1495148400 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 5054282949293 GBKQU1735405 N Drop Bear Digital Alexei Reynolds 1495120004 Y 2021-12-17 17:37:27 0
58778 FBR266 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494543600 0 Y N N B N R Y N N Y 10 1494543600 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 / Simon Mowling 1495034570 Y 2021-12-17 17:37:27 0
58854 VCRPKR7 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494543600 0 Y N N B N R Y N N Y 10 1494543600 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 Truelove Music Paul King 1494266326 Y 2021-12-17 17:37:27 0
58924 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497038654 Y 2021-12-17 17:37:27 0
58925 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425647 Y 2021-12-17 17:37:27 0
58926 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425654 Y 2021-12-17 17:37:27 0
58927 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425659 Y 2021-12-17 17:37:27 0
58928 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425664 Y 2021-12-17 17:37:27 0
58929 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425669 Y 2021-12-17 17:37:27 0
58930 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425676 Y 2021-12-17 17:37:27 0
58931 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425681 Y 2021-12-17 17:37:27 0
58932 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497192001 Y 2021-12-17 17:37:27 0
58933 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425690 Y 2021-12-17 17:37:27 0
58934 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497038663 Y 2021-12-17 17:37:27 0
58935 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497038670 Y 2021-12-17 17:37:27 0
58936 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425702 Y 2021-12-17 17:37:27 0
58937 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425706 Y 2021-12-17 17:37:27 0
58938 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425710 Y 2021-12-17 17:37:27 0
58939 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425713 Y 2021-12-17 17:37:27 0
58940 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425717 Y 2021-12-17 17:37:27 0
58941 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425721 Y 2021-12-17 17:37:27 0
58942 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425724 Y 2021-12-17 17:37:27 0
58943 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425730 Y 2021-12-17 17:37:27 0
58944 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425526 Y 2021-12-17 17:37:27 0
58945 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425566 Y 2021-12-17 17:37:27 0
58946 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425573 Y 2021-12-17 17:37:27 0
58947 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425581 Y 2021-12-17 17:37:27 0
58948 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425590 Y 2021-12-17 17:37:27 0
58949 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497038676 Y 2021-12-17 17:37:27 0
58950 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1497038685 Y 2021-12-17 17:37:27 0
58951 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425607 Y 2021-12-17 17:37:27 0
58952 VCRPK006 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494284400 0 Y N N B N R Y N N Y 10 1494284400 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 58953 1494425613 Y 2021-12-17 17:37:27 0
58958 BB19A P A 1 1.69 1 0.000 0 0 0 0.00 0 1494457200 0 Y N N B N R Y N N Y 10 1494457200 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 John Evans 1636451770 Y 2021-12-17 17:37:27 0
58959 BB19B P A 1 1.69 1 0.000 0 0 0 0.00 0 1494457200 0 Y N N B N R Y N N Y 10 1494457200 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 Hatfish John Evans 1636451769 Y 2021-12-17 17:37:27 0
58961 IOD034 P A 1 1.69 1 0.000 0 0 0 0.00 0 1494370800 0 Y N N B N R Y N N Y 10 1494370800 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 Barry Harding 1494429529 Y 2021-12-17 17:37:27 0
59121 DD111 P A 1 1.69 1 0.000 0 0 0 0.00 0 1495062000 0 Y N N B N R Y N N Y 10 1495062000 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 GBKQU1752876 N Copyright Control Jondog 1495141461 Y 2021-12-17 17:37:27 0