Skip to content

Strategy P. 15

Page 36 of 46

  • The Myth of Unbounded Growth

    Popular wisdom holds that blue-chip companies can somehow grow continuously. According to the authors, however, the struggle of corporate icons like Kodak, Digital and Xerox demonstrate that natural limitations, managerial complexity, a lack of stakeholder harmony and antitrust concerns make continuous growth increasingly difficult. Rather than seeking growth at any cost, they suggest that companies seek alternative ways of moving beyond natural growth limits. The authors draw on a host of examples -- from Microsoft, J.P. Morgan, IBM and others -- suggesting that companies finding themselves confronting this scenario can either break up their company, create new corporate forms or make a graceful growth-to-value transition. In evaluating their options, say the authors, the corporate executives must consider their company's position in its life cycle -- growth, stall or post-stall. Stalls can be anticipated by assessing the natural limits of the company's dominant growth strategy and its pattern of financial performance. Executives must also realistically assess their company's capacity for both innovation and new-business creation in order to decide whether their capital and talent would be better spent on core business development than on the reckless pursuit of high growth. Choosing alternate options is not easy, suggest the authors, given the pervasive culture of continuous growth. The first step toward making constructive decisions for a company's future, however, is to acknowledge that unbounded growth may indeed be a myth.

    More

  • Cross-Cultural Lessons in Leadership

    Data from a decade-long research project puts advice to managers in context, country by country.

    More

  • Stock Market Valuation and Mergers

    Much of the recent research on mergers and acquisitions (M&;A) seeks to link the market valuations of individual companies, as well as overall stock market levels, with merger activity and performance. In their review of work conducted in this field, the authors present a primer on ways to measure whether M&;A actually creates value and then offer an overview of the "winners" and "losers." But the long-held observation that stock prices affect merger activity was confirmed in 2001, they say, by work that revealed a correlation between high merger activity and high market valuations. Several other studies have shown that acquirers who pay with stock underperform their peers in the long run, whereas acquirers who pay cash outperform their peers. Another line of inquiry, according to the authors, finds that the level of the stock market when an acquisition is announced affects short-term and long-term merger performance. The short-term effects are positive for acquisitions announced in high-valuation markets and negative for those undertaken in low-valuation markets. Supporting evidence is provided in other recent work too: Acquisitions that take place during periods of below-average economic growth create more shareholder value than strong-economy acquisitions. The strong performance of low-valuation acquirers and weak-economy acquirers suggests that they are not distracted by short-run market reactions, but instead focus on business fundamentals and true potential synergies. Two articles published in 2002, suggesting that the root cause of such links between valuation and performance may be incorrect valuation by the market, are empirically supported by current work that Bouwman et al. also describe. The conclusion of these various research streams is that stock prices matter, say the authors. The key implication for managers: Be wary of acquisitions made when market or firm valuations are high, and be optimistic about acquisitions when valuations are low. This review includes a comprehensive sidebar of all referenced and relevant research.

    More

  • The Dangers of Too Much Governance

    Overreacting to corporate scandal will hobble risk taking, innovation and growth

    More

  • The Future of Corporate Venturing

    During the late 1990s stock market boom, many large companies established corporate-venturing units, seeking to develop innovative new businesses and spur growth. However, with the downturn of the economy, many of these units ceased operations -- while others managed to survive and a few even thrived. What went wrong with failing companies, and how do those that still have corporate-venturing units manage to succeed? The authors studied nearly 100 venturing units, proposing that failures often occurred because such groups lacked clarity -- both in their objectives and in their business models. Using the example of successful venturing units, such as Intel Capital, Mustang Ventures at Siemens, Lucent New Venture Group and GE Equity, the authors outline four common types of venturing scenarios that, by using a careful, steady approach, companies can execute well: ecosystem venturing, innovation venturing, harvest venturing and private-equity venturing. They discuss the characteristics and benefits of each and how successful companies avoid the pitfalls that snare others. In the end, the authors conclude, there are many ways to do corporate venturing. But to succeed, companies must define their goals clearly and narrowly, understand the differences among the various types, and use the appropriate type for the appropriate activity. The ultimate key to accomplishing that, say the authors, lies in effectively employing the differences to their advantage.

    More

  • Leveraging the Incumbent's Advantage

    People often talk about business competition as if it’s a short race: Get to market first and you are bound to win. Indeed, the importance of first-mover advantage has been drummed into the heads of many business executives, and some have almost been brainwashed to think that speed is everything. But when a new technology like the Internet threatens to transform an industry, the companies that are quickest to respond aren’t necessarily the ones that reap the greatest benefits. In fact, choosing a fast strategy can lock them into a set of decisions that actually hurt them in the long run. Instead, organizations that choose the right strategy for the entire race & #8212; both for the early and late stages & #8212; will come out ahead. Specifically, we have found that companies that respond quickly by launching a spinoff usually have difficulty achieving true staying power in the market. For enduring success, incumbent companies are better off creating a group that is & #8212; or will eventually be & #8212; integrated within their organizations. Only then will they be able to tap fully into their numerous strengths and assets, leveraging their incumbent’s advantage.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0006
My Controller Construct  0.0003
Build Nav  0.0006
Controller Execution Time ( Products / Route )  0.0603
Total Execution Time  0.0610
  GET DATA  
$_GET['cat_id']   249
$_GET['offset']   350
  MEMORY USAGE  
1.9163 MB
  POST DATA  
No POST data exists
  URI STRING  
store/strategy
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 150  (Hide)
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8c220124e726479b438a7ccfda2ecb1f'
ORDER BY `created_atDESC 
0.0004  

SELECT `parent_id`
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
skuIN ('strateg''strategP''strategC''strategX') 
AND `
type_id` =  'V'
LIMIT 1 
0.0002  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM 
(`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'strategy'
AND `parent_id` =  
0.0059  

SELECT c.parent_idc.format_id
                    FROM products 
AS pproducts AS cproduct_categories__products
                    WHERE p
.prod_id c.parent_id AND
                        
p.prod_id product_categories__products.prod_id AND
                        
c.avail_id IN ('A','B','D') AND
                        
c.type_id 'V' AND
                        
product_categories__products.cat_id 249 AND
                        (
                            
c.sku 'strategy' OR
                            if(
c.format_id 'Certificate'''p.url_friendly) = 'strategy'
                        
)
                    
LIMIT 1 
0.0005  

SELECT `cat_idAS id, `parent_idAS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY 
`parent_id`, IF(position 010) AS, `position`, `name
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'product_categories'
AND `foreign_key_column` =  'cat_id'
AND `foreign_key_value` =  '249'
AND `kind` =  'hero_image'
ORDER BY IF(position 010) AS, `position
0.0112  

SELECT SQL_CALC_FOUND_ROWS p.prod_id AS parent_idp.pool_id AS parent_pool_idp.type_id AS parent_type_idp.title AS parent_titlep.description AS parent_descriptionp.url_friendly AS parent_url_friendlyp.product_typep.publication_datec.prod_idc.avail_idc.type_idc.skuc.titlec.pricec.sale_pricec.toggle_inventory_apic.qty_availablec.expected_dateproduct_categories__products.cat_idCOALESCE(product_categories.name'') as category_name
FROM 
(`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
LEFT JOIN (product_categories__products) ON `p`.`prod_id` = `product_categories__products`.`prod_id`
LEFT JOIN (product_categories) ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `c`.`type_id` =  'V'
AND `c`.`format_id` != "Certificate"
AND c.avail_id IN ('A','B','D')
AND 
product_categories__products.cat_id IN ('249','284','270','279','254','260')
GROUP BY `c`.`parent_id`
ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_dateDESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 350 
0.0001  

SELECT FOUND_ROWS() AS total 

0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1644' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1643' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1643'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0005  

SELECT `cat_idAS id, `parent_idAS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY 
`parent_id`, IF(position 010) AS, `position`, `name
0.0003  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1643'
ORDER BY `sortAS
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1643' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1643'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1643' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1643'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1643'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '799' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '799' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1664' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1663' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1663'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1663'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1663' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1663'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1663' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1663'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1663'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1704' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1703' 
0.0003  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1703'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1703'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1703' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1703'
ORDER BY IF(position 010) AS, `position
0.0004  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1703' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1703'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1703'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '825' 
0.0002  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '825' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1706' 
0.0001  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1705' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1705'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1705'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1705' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1705'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1705' 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1705'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1705'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '826' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '826' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1674' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1673' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1673'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1673'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1673' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1673'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1673' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1673'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1673'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '810' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '810' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1702' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1701' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1701'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1701'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1701' 
0.0002  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1701'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1701' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1701'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1701'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '824' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '824' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1680' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1679' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1679'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1679'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1679' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1679'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1679' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1679'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1679'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '813' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '813' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1710' 
0.0003  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1709' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1709'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1709'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1709' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1709'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1709' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1709'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1709'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '828' 
0.0001  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0001  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '828' 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1742' 
0.0001  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1741' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1741'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1741'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1741' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1741'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1741' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1741'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1741'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1744' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1743' 
0.0002  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categoriesON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1743'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authorsON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1743'
ORDER BY `sortAS
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1743' 
0.0001  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1743'
ORDER BY IF(position 010) AS, `position
0.0002  

SELECT `c`.`prod_id`, `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`productsAS p)
JOIN (products AS c) ON `p`.`prod_id` = `c`.`parent_id`
WHERE `c`.`avail_idIN ('A''B''D') 
AND `
c`.`type_id` =  'V'
AND `c`.`parent_id` =  '1743' 
0.0002  

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1743'
AND `type_id` =  'V'
ORDER BY IF(position 010) AS, `position`, `title
0.0002  

SELECT SQL_CALC_FOUND_ROWS media_idposition
FROM 
(`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1743'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0003  

SELECT *
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `parent_id` =  1
AND `cat_idNOT IN (1261) 
ORDER BY `name
0.0002  

SELECT *
FROM (`site_settings`)
WHERE `option_key` =  'announcement' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)