SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    74405, 74404, 74403, 74402, 74401, 74400, 
    74399, 74398, 74397, 74396, 74395, 
    74394, 73974, 74268, 74180, 74091, 
    73995, 73744, 74267, 73822, 73690, 
    73601, 74090, 74089, 74088, 74087, 
    74086, 74085, 74084, 74083, 74082, 
    74081, 74080, 74079, 74078, 74077, 
    74076, 74075, 74074, 74073
  )

Query time 0.00051

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
73601 TBR191 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549324800 0 Y N N B N R Y N N Y 10 1549238400 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 Copyright Control Dawn Lee 1549272506 Y 2021-12-17 17:37:27 0
73690 AAN78 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549497600 0 Y N N B N R Y N N Y 10 1549497600 1550707200 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;} 3 labelworx 5054284149615 GBLV61821038 N Ahura Mazda Recordings NITRO Burak Harsitlioglu 1547010006 Y 2021-12-17 17:37:27 0
73744 PMD004 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 1550793600 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 5054284159539 GBKQU1900658 N Joe Longbottom Joe Longbottom Leigh D 1547355601 Y 2021-12-17 17:37:27 0
73822 IOD070 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549497600 0 Y N N B N R Y N N Y 10 1549497600 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 Elliot Fletcher 1547849720 Y 2021-12-17 17:37:27 0
73974 HOT024 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 1551052800 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 5054284199184 GBKQU1908609 N Hot Box Digital Dan Dyson 1548738008 Y 2021-12-17 17:37:27 0
73995 TMP120 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 Tempo Trax Dawn Lee 1548868935 Y 2021-12-17 17:37:27 0
74073 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Tim Wellings 1549018756 Y 2021-12-17 17:37:27 0
74074 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Steve Maynard 1549018785 Y 2021-12-17 17:37:27 0
74075 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Mark Ioannides / Toryn Davies 1549018828 Y 2021-12-17 17:37:27 0
74076 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Devlin 1549018858 Y 2021-12-17 17:37:27 0
74077 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi 1549018887 Y 2021-12-17 17:37:27 0
74078 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi 1549018922 Y 2021-12-17 17:37:27 0
74079 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi 1549018969 Y 2021-12-17 17:37:27 0
74080 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi 1549019001 Y 2021-12-17 17:37:27 0
74081 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Dave Owens / James Jackson 1549019031 Y 2021-12-17 17:37:27 0
74082 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Gary O'Connor 1549019060 Y 2021-12-17 17:37:27 0
74083 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Tim Wellings 1549019087 Y 2021-12-17 17:37:27 0
74084 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Capitani 1549019116 Y 2021-12-17 17:37:27 0
74085 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 1549019146 Y 2021-12-17 17:37:27 0
74086 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Paul Batten 1549019191 Y 2021-12-17 17:37:27 0
74087 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi / SJ 1549019222 Y 2021-12-17 17:37:27 0
74088 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi / SJ 1549019257 Y 2021-12-17 17:37:27 0
74089 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 James Nardi / SJ 1549019297 Y 2021-12-17 17:37:27 0
74090 TTBO1 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549238400 0 Y N N B N R Y N N Y 10 1549238400 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 Jason Pepper / Ian Fitzpatrick 1549019362 Y 2021-12-17 17:37:27 0
74091 DER017 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 Reactor 4, Kelly Ward 1549029120 Y 2021-12-17 17:37:27 0
74180 BZK073 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 0 N 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 James Jackson 1593722286 Y 2021-12-17 17:37:27 0
74267 UBT019 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549576125 0 Y N N B N R Y N N Y 10 1549497600 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 Unbounded Traxx Damien Blanes /Chucky 1549616111 Y 2021-12-17 17:37:27 0
74268 FR070 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549584000 0 Y N N B N R Y N N Y 10 1549584000 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 Toolbox Publishing Rob Yellowley 1641475484 Y 08/02/2019 10/03/2019 2021-12-17 17:37:27 0
74394 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Walter / Ian Fitzpatrick 1549830126 Y 2021-12-17 17:37:27 0
74395 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Capitani 1549830130 Y 2021-12-17 17:37:27 0
74396 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Lee Brough 1549830134 Y 2021-12-17 17:37:27 0
74397 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Jason Pepper / Ian Fitzpatrick 1549830140 Y 2021-12-17 17:37:27 0
74398 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Ian Mulford 1549830144 Y 2021-12-17 17:37:27 0
74399 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Justin Bourne 1549830148 Y 2021-12-17 17:37:27 0
74400 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Lee Brough / Dave Owens 1549830152 Y 2021-12-17 17:37:27 0
74401 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Ian Fitzpatrick 1549830156 Y 2021-12-17 17:37:27 0
74402 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Tom Basquil 1549829746 Y 2021-12-17 17:37:27 0
74403 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Frank Farrell 1549829771 Y 2021-12-17 17:37:27 0
74404 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Jesse Jackson / Ian Fitzpatrick 1549829813 Y 2021-12-17 17:37:27 0
74405 TTB02 P A 1 1.69 1 0.000 0 0 0 0.00 0 1549843200 0 Y N N B N R Y N N Y 10 1549843200 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 Ian Fitzpatrick 1549829841 Y 2021-12-17 17:37:27 0