Skip to content

Strategy P. 16

Page 38 of 46

  • Product cover

    The Need for a Corporate Global Mind-Set

    Thomas M. Begley , David P. Boyd
    January 15, 2003 | STRATEGY

    Many international business leaders consider a global mind-set desirable, but few know how to embed it companywide. A corporate global mind-set differs from having a few managers think globally. That comes first. But global thinking must be incorporated into an organization’s processes so that everyone knows how to handle the tug-of-war between local responsiveness and corporate efficiency. Two Northeastern University professors studied global companies and found that inculcating a corporate global mind-set lagged behind the will to do so. IBM made the most progress. Having originally overemphasized global consistency, it learned to embrace a more flexible approach, adopting global-policy-development teams, worldwide knowledge networks and appropriate performance measures. Unfortunately, many American executives regard globalization as pursuing standardized products through centralized decision making. In favoring global consistency, they often fail to secure local cooperation. Through a global mind-set, corporate-decision-making processes become more permeable to influences from beyond the home country. The authors show how managers can determine when an issue calls for a locally adaptive response, when it calls for a globally consistent response and when both elements are needed. The corporate global mind-set is a requirement for motivating a diverse and sprawling work force and giving it a common purpose.

    More

  • Product cover

    The Real Value of Strategic Planning

    Sarah Kaplan, Eric D. Beinhocker
    January 15, 2003 | STRATEGY

    Most companies invest a significant amount of time and effort in a formal, annual strategic-planning process & #8212; but many executives see little benefit from the investment. In the course of the authors’ research, one manager compared his company’s process with a “primitive tribal ritual,” and another likened it to the Soviet system: “We pretend to make strategy and they pretend to follow it.” The authors found that, although few truly strategic decisions are made in the context of a formal process, formal planning can be a real source of competitive advantage when it is approached with the right goal in mind: as a learning tool to help companies create within their management teams “prepared minds” (to borrow from Louis Pasteur). The key is getting right a host of seemingly mundane but actually critical details concerning the annual meetings that are at the heart of all formal processes & #8212; including who should attend the meetings, where they should be held and what kind of preparation is necessary to make them effective. Following an analysis of those details, the authors offer several examples showing prepared minds in action, in which formal planning helped managers make solidly grounded, real-time strategic decisions in a world of turbulence and uncertainty.

    More

  • Product cover

    Blending Cultural Business Styles

    October 15, 2002 | STRATEGY

    More

  • Product cover

    Competitive Pressure Systems: Mapping and Managing Multimarket Contact

    Richard D'Aveni
    October 15, 2002 | STRATEGY

    All organizations sense competitive pressure intuitively, but most, says the author, do not do a good job of managing it. That is, in part, because it is often difficult to see the overall pressure system & #8212; a complex, shifting pattern of overlapping contacts among rivals that continually alters the climate of an industry by changing the incentives for players to compete, mutually forbear or even formally cooperate. This article illustrates how pressure systems can be mapped and controlled to a significant extent. A map based on measured pressures has important implications for an organization’s market’ and competitor selection, growth plans, product-portfolio and diversification strategy, resource-allocation priorities, competitive-intelligence system, merger-and-acquisition strategy, and scenario-planning process. In any industry, companies can develop competitive strategy by using a pressure map to answer two critical questions: If the current pressure pattern continues, what position will my company ultimately hold? How can my company stabilize or shift the direction of pressure to reduce (or enhance) the predicted impact of the current pressure system? Through detailed discussion of the airline, automobile and European wireless-telecom industries, among others, the author demonstrates how pressure maps can reveal the underlying competitive dynamics of an industry. He then offers a variety of mechanisms by which organizations can and do affect their competitive landscapes & #8212; stabilizing or destabilizing them to greatest advantage.

    More

  • Product cover

    Risk Management in Practice

    October 15, 2002 | STRATEGY

    The use of risk-assessment tools is far from pervasive.

    More

  • Product cover

    Sharpening the IPO Double-Edged Sword

    October 15, 2002 | STRATEGY

    More

  • Product cover

    The Great Leap: Driving Innovation From the Base of the Pyramid

    Stuart L. Hart, Clayton M. Christensen
    October 15, 2002 | STRATEGY

    As multinationals unrelentingly seek new growth to satisfy shareholders, they increasingly hear concerns from many quarters about environmental degradation, labor exploitation, cultural hegemony and local autonomy. What is to be done? Must corporations’ thirst for growth and profits serve only to exacerbate the antiglobalization movement? On the contrary, the authors say, a solution to this dilemma does exist. Companies can generate growth and satisfy social and environmental stakeholders through a “great leap” to the base of the economic pyramid, where 4 billion people aspire to join the market economy for the first time. This is not a question simply of doing the right thing in order to lift people out of poverty & #8212; although that will surely be a result of the leap the authors have in mind. From a senior executive’s point of view, it’s a matter of finding the most exciting growth markets of the future. It is also where the technologies that are needed to address the social and environmental challenges associated with economic growth can best be developed. The authors illustrate their point with examples of companies that are already profitably disrupting such industries as telecommunications, consumer electronics and energy production.

    More

  • Product cover

    Calculated Risk: A Framework for Evaluating Product Development

    Craig R. Davis
    July 15, 2002 | STRATEGY

    The product-development process is often seen as an undependable black box” that rarely produces results that exceed business expectations. Traditional financial models have limited success exposing the numerous product-development risks that underlie the assumptions in a typical business case. Applying the same rules to development as they do to research, managers often accept unpredictable performance as normal. Most companies’ evaluation and approval processes are driven by accounting-based metrics such as discounted cash flow or net present value (NPV) that make understanding the underlying risks of development difficult for decision makers. When risk is discussed in the business case, technology uncertainty is often confused with product-development risk, and the narrative discussion of risk is designed more to persuade than inform. In this environment, decision makers are often hard-pressed to evaluate the potential commercial success of the new-product-development investment. With an approach called “net present value, risk-adjusted” (NPVR), author Craig R. Davis, CFO of product-development consulting firm Product Genesis, offers an operational framework that gives decision makers quantitative tools to evaluate relative project risks. He shows how these tools can be integrated into existing stage-gate methodologies to create a risk-adjusted NPV that considers the impacts of product portfolio, user needs, and technical and marketing risks. The framework also provides insights into the value of additional research in advance of full commitment to development. The framework provides a vocabulary appropriate for complex technology products in medical, commercial and industrial products but is easily adapted to the unique terms, methods and measures for each risk-assessment area.

    More

  • Product cover

    Reducing the Risk of Acquisition

    July 15, 2002 | STRATEGY

    Identifying and addressing the environmental factors that can affect success

    More

  • Product cover

    Strategy, Science and Management

    James Brian Quinn
    July 15, 2002 | STRATEGY

    Today’s world calls for less hypothesis testing and more systematic observation.

    More

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

SELECT `parent_id`
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `sku` IN ('strateg', 'strategP', 'strategC', 'strategX') 
AND `type_id` =  'V'
LIMIT 1 
0.0003  

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

SELECT c.parent_id, c.format_id
                    FROM products AS p, products AS c, product_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_id` AS id, `parent_id` AS 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 = 0, 1, 0) ASC , `position`, `name` 
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_id, position
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 = 0, 1, 0) ASC , `position` 
0.0155  

SELECT SQL_CALC_FOUND_ROWS p.prod_id AS parent_id, p.pool_id AS parent_pool_id, p.type_id AS parent_type_id, p.title AS parent_title, p.description AS parent_description, p.url_friendly AS parent_url_friendly, p.product_type, p.publication_date, c.prod_id, c.avail_id, c.type_id, c.sku, c.title, c.price, c.sale_price, c.toggle_inventory_api, c.qty_available, c.expected_date, product_categories__products.cat_id, COALESCE(product_categories.name, '') as category_name
FROM (`products` AS 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_date` DESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 370 
0.0001  

SELECT FOUND_ROWS() AS total 
0.0002  

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1793'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0004  

SELECT `cat_id` AS id, `parent_id` AS 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 = 0, 1, 0) ASC , `position`, `name` 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1793'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1793'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0003  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1793'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1793'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1803' 
0.0005  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1803'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1803'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1803'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1803'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1803'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1849'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1849'
ORDER BY `sort` ASC 
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1849' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1849'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0003  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1849'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1849'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1823'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0003  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1823'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1823'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1823'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1823'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

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

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

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1855'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0004  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1855'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1855'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1855'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1855'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1971'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1971'
ORDER BY `sort` ASC 
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1971' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1971'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1971'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1971'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1829' 
0.0004  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1829'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1829'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1829'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1829'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1829'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1857' 
0.0004  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1857'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1857'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1857'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1857'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1857'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1879'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1879'
ORDER BY `sort` ASC 
0.0002  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1879' 
0.0015  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1879'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1879'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1879'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '1877'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '1877'
ORDER BY `sort` ASC 
0.0001  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1877' 
0.0003  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '1877'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1877'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0003  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '1877'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '884' 
0.0005  

SELECT *
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `parent_id` =  1
AND `cat_id` NOT IN (1, 261) 
ORDER BY `name` 
0.0002  

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