Skip to content

Innovation P. 7

Page 15 of 15

  • Product cover

    Competing Today While Preparing for Tomorrow

    Derek F. Abell
    April 15, 1999 | INNOVATION

    High-performing companies employ dual strategies: they maximize today's capabilities and simultaneously develop new capabilities for the future. In the past, most organizations could run and change their businesses using a single strategy; even today, most companies do not clearly discriminate between present and future. A single-strategy approach, however, cannot meet the challenges created by accelerating competition and change. Strategies for today ensure that functional and supply-chain partner activities are aligned with company strategy and harmonized with organizational structures, processes, culture, incentives, and people. They clarify segment, positioning, and resource deployment choices. Strategies for tomorrow involve decisions about how to define and position the future business. They start with visions of the future -- for example, market territory and forces that might reshape it; competitive moves; strategy options and choices; needed competencies and resources; and knowledge of how to get "there" from "here." Achieving the right balance between a present and a future orientation depends on the situation. During times of rapid or extreme change, the future component claims more attention; during more stable times, the present component predominates. In any situation, however, both components must always be addressed in parallel. Institutionalizing dual strategies requires that companies clearly define leadership responsibilities, balance organizational structures and processes, develop systems for managing duality, and redesign control mechanisms. Implementation must begin at the top. Leaders at all levels of the enterprise must promote the need for dual thinking and communicate the two agendas and their significance to people in every organizational nook and cranny. Dual strategies succeed only if those who need to implement today and change for tomorrow understand the reasons behind each.

    More

  • Product cover

    Successful Strategies for Product Rollovers

    Corey Billington , Hau L. Lee, Christopher S. Tang
    April 15, 1998 | INNOVATION

    Companies' financial strength and market position depend on successful new product introductions, which, in turn, depend on successful product rollovers. Given the low success rate of product rollovers, companies need a formal process to plan and coordinate product rollovers and to reduce risk. This article presents a framework to help companies manage product rollovers, choose the best rollover strategy, and improve product rollovers. Companies need to plan their rollovers early, when they are planning the new product's introduction. First, they choose a primary rollover strategy, based in part on assessment of the uncertainties associated with the product's manufacturing, delivery, and market potential. Then they monitor product and market conditions. Finally, as product and market conditions change, they adopt a contingency strategy if necessary. Companies can consider two primary strategies for product rollovers. Solo-product roll, a high-risk, high-return strategy, aims to have all the old products sold out worldwide at the planned new product introduction date. The less risky dual-product roll plans to sell both old and new products simultaneously for a period of time and can be implemented in a variety of ways. If changed product and market conditions increase the product's risk, companies can choose from among four contingency strategies: making significant price markdowns, postponing the new product's introduction, introducing the new product earlier than planned, or combining two or more dual-product-roll strategies. Finally, while contingency strategies enable companies to modify their primary strategies if appropriate, companies can improve their product rollovers significantly by exploiting opportunities to reduce the product and market risks of each new product in the first place.

    More

  • Product cover

    Strategic Innovation

    Constantinos Markides
    April 15, 1997 | INNOVATION

    Companies can successfully challenge industry leaders even without radical technological innovation.

    More

  • Product cover

    Integrating the Fuzzy Front End of New Product Development

    Anil Khurana , Stephen R. Rosenthal
    January 15, 1997 | INNOVATION

    Why are new products frequently canceled in midstream or introduced later than planned? Why do product developers often have no time to devote to “top priority” projects? Companies may not be integrating strategic, conceptual, and planning functions at the front end with the detailed design and development that follows. Khurana and Rosenthal isolated seven activities critical to product and project success. The foundation elements, those that require cross-functional effort and senior management support, include developing a clear product strategy, formulating a product portfolio, establishing a structure that facilitates product development, and sharing responsibilities throughout the organization. Project-specific elements, which focus on the individual project, include clarifying the product concept, defining the product and market requirements, and planning and estimating the project’s resource requirements. The authors point out that the interrelationships between the elements are as important as the elements themselves. Khurana and Rosenthal examine in detail how the eleven companies in their study implemented the seven activities. While the authors rated two companies as outstanding and two as satisfactory, they considered seven to have serious deficiencies in their development of product strategies. Some had product development teams and managers but no one in charge of formulating product strategy. Others made decisions on new product development based on project criteria rather than strategic fit. And others had an isolated R&;D department that funded projects based on technology rather than on their potential to satisfy product requirements. How can a company improve its front-end process? Khurana and Rosenthal offer a checklist and map for diagnosing a company’s integration of front-end activities. And they discuss how a company can make the transition to a better managed product development process.

    More

  • Product cover

    Improving Knowledge Work Processes

    Thomas Davenport , Sirkka Jarvenpaa , Michael Beers
    July 15, 1996 | INNOVATION

    Are traditional reengineering approaches appropriate for improving knowledge work processes? In a study of thirty organizations, the authors found that improvement methods for knowledge work ranged from the classical top-down approach to a more laissez-faire philosophy that allowed professionals to design and execute their own work. Companies should probably choose an intermediate approach that reflects the type of knowledge work, the organizational culture, and the project's business requirements. They must recognize that the nature of knowledge work is different from administrative and operational work and that the people who perform it resist structured approaches.

    More

  • Product cover

    Software-Based Innovation

    James Brian Quinn , Jordan J. Baruch , Karen Anne Zien
    July 15, 1996 | INNOVATION

    Managers need to recognize the potentials of software in their development processes and change their approaches to utilize the full potentials of software-based innovation. By doing so, they can improve innovation quality, shorten cycle times, cut costs, lower risks, enhance the results of innovation, and increase its diffusion to customers. The authors explain the powerful possibilities of software-based innovation and provide many examples of how companies develop and manage software most successfully.

    More

  • Product cover

    Organizational Learning -- The Key to Management Innovation

    Ray Stata
    April 15, 1989 | INNOVATION

    Analog Devices is a case study in how management innovation is a key to competitiveness.

    More

  • Product cover

    Manufacturing Innovation: Lessons from the Japanese Auto Industry

    Michael A. Cusumano
    October 15, 1988 | INNOVATION

    The fact that Japanese manufacturers made tremendous inroads on the global automobile market during the 1970s will surprise nobody. What may surprise many is that Toyota's productivity rates exceeded U.S. manufacturers' as long ago as the 1960s. Business historian Michael A. Cusumano details the spectacular developments in Japanese productivity, quality, and process flexibility that have occurred over the past thirty years.

    More

  • Product cover

    Managing the Internal Corporate Venturing Process

    Robert A. Burgelman
    January 15, 1984 | INNOVATION

    The strategic management of internal corporate venturing (ICV) presents a major challenge for many large established firms. The author's conceptualization of ICV suggests that vicious circles and managerial dilemmas typically emerge in the development of new ventures. These problems are exacerbated by the indeterminateness of the strategic context for ICV in the corporation, and by perverse selective pressures exerted by its structural context. This article presents four major recommendations for improving the effectiveness of a firm's ICV strategy.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0006
My Controller Construct  0.0003
Build Nav  0.0016
Controller Execution Time ( Products / Route )  0.0428
Total Execution Time  0.0434
  GET DATA  
$_GET['cat_id']   245
$_GET['offset']   140
  MEMORY USAGE  
1.8114 MB
  POST DATA  
No POST data exists
  URI STRING  
store/innovation
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 146  (Hide)
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '286380da76586a0dcc4111ce80716c6e'
ORDER BY `created_at` DESC 
0.0002  

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

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 = 245 AND
                        (
                            c.sku = 'innovation' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'innovation'
                        )
                    LIMIT 1 
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 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` =  '245'
AND `kind` =  'hero_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0045  

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 ('245','269','256','295','257','277','286')
GROUP BY `c`.`parent_id`
ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_date` DESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 140 
0.0001  

SELECT FOUND_ROWS() AS total 
0.0001  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2213' 
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` =  '2213'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0003  

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` =  '2213'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2213'
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` =  '2213' 
0.0002  

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

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` =  '2213'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2279' 
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` =  '2279'
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` =  '2279'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2279'
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` =  '2279' 
0.0002  

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

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` =  '2279'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2333' 
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` =  '2333'
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` =  '2333'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2333'
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` =  '2333' 
0.0002  

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

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` =  '2333'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2357' 
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` =  '2357'
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` =  '2357'
ORDER BY `sort` ASC 
0.0002  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2357'
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` =  '2357' 
0.0002  

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

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` =  '2357'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2385' 
0.0001  

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` =  '2385'
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` =  '2385'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2385'
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` =  '2385' 
0.0002  

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

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` =  '2385'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '1080' 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2381' 
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` =  '2381'
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` =  '2381'
ORDER BY `sort` ASC 
0.0001  

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2381'
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` =  '2381' 
0.0002  

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

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` =  '2381'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2685' 
0.0001  

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` =  '2685'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0001  

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

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

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

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` =  '2685' 
0.0002  

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

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` =  '2685'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2697' 
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` =  '2697'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0001  

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

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2697'
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` =  '2697' 
0.0002  

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

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` =  '2697'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2729' 
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` =  '2729'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0001  

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

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

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2729'
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` =  '2729' 
0.0002  

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

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` =  '2729'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '1244' 
0.0013  

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

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