SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    59836, 59835, 59834, 59833, 59832, 59831, 
    59830, 59829, 59828, 59827, 59826, 
    59825, 59824, 59823, 59822, 59821, 
    59820, 59819, 59818, 59817, 59816, 
    59815, 59814, 59813, 59812, 59811, 
    59810, 59809
  )

Query time 0.00070

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_products range PRIMARY PRIMARY 3 28 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
59809 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253319 Y 2021-12-17 17:37:27 0
59810 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253377 Y 2021-12-17 17:37:27 0
59811 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253436 Y 2021-12-17 17:37:27 0
59812 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253472 Y 2021-12-17 17:37:27 0
59813 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253506 Y 2021-12-17 17:37:27 0
59814 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253547 Y 2021-12-17 17:37:27 0
59815 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253579 Y 2021-12-17 17:37:27 0
59816 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253619 Y 2021-12-17 17:37:27 0
59817 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253698 Y 2021-12-17 17:37:27 0
59818 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253731 Y 2021-12-17 17:37:27 0
59819 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253760 Y 2021-12-17 17:37:27 0
59820 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253804 Y 2021-12-17 17:37:27 0
59821 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253839 Y 2021-12-17 17:37:27 0
59822 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498253879 Y 2021-12-17 17:37:27 0
59823 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254011 Y 2021-12-17 17:37:27 0
59824 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254051 Y 2021-12-17 17:37:27 0
59825 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254087 Y 2021-12-17 17:37:27 0
59826 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254124 Y 2021-12-17 17:37:27 0
59827 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella / Dave Owens 1498254162 Y 2021-12-17 17:37:27 0
59828 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254202 Y 2021-12-17 17:37:27 0
59829 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254239 Y 2021-12-17 17:37:27 0
59830 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254284 Y 2021-12-17 17:37:27 0
59831 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498254995 Y 2021-12-17 17:37:27 0
59832 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498255036 Y 2021-12-17 17:37:27 0
59833 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498255063 Y 2021-12-17 17:37:27 0
59834 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498255103 Y 2021-12-17 17:37:27 0
59835 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498255187 Y 2021-12-17 17:37:27 0
59836 WPA001 P A 1 1.69 1 0.000 0 0 0 0.00 0 1498172400 0 Y N N B N R Y N N Y 10 1498172400 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 Gavin Kinsella 1498255243 Y 2021-12-17 17:37:27 0