Skip to content

Innovation P. 5

Page 10 of 15

  • Implementing a Learning Plan to Counter Project Uncertainty

    Project managers need a systematic, disciplined framework for turning uncertainty into useful learning.

    More

  • The Benefits of City Locations

    Urban environments can substitute for internal resources in driving process innovation.

    More

  • What Was Obvious No Longer Is

    Recent Supreme Court rulings have changed IP protections.

    More

  • Breakthroughs and the 'Long Tail' of Innovation

    To understand how breakthroughs in creativity occur, managers must understand how most collaborations work.

    More

  • Designing the Right Product Offerings

    How can companies design products and product lines to maximize profits? Out of all the potential configurations available to them, how should they decide which ones to offer? The authors have developed a framework for balancing the costs of developing and offering a rich line of products and services against customer demand for additional choice. Their methodology helps managers make informed decisions about which features to include in the product; which variations to include in a product line; and how the offerings should evolve with technology and competition. Using examples from the music, software and media industries and citing companies including Apple, Dell, Microsoft, The New York Times, and ESPN, the authors describe five basic types of product offerings: the _ la carte offering, the specialization offering, the all-in-one offering, the basic/premium offering, and the have-it-your-way offering. By highlighting how costs influence product design, they depart from the standard product-success metrics, such as revenue and market share, which are the main focus of most of the work on product bundling. The authors note that the decision to offer a product and how it is designed generally affects both the fixed costs and the marginal costs. They argue that product architects need to expand their definition of fixed and marginal costs beyond those that they typically track and account for to cover costs across the entire supply chain. Although some of these costs may be hard to quantify, they are often too significant to ignore.

    More

  • Learning to Innovate

    Organizations can teach themselves to grow.

    More

  • Strategic Innovation at the Base of the Pyramid

    Innovation in developing markets has less to do with finding new customers than addressing issues of product acceptability, affordability, availability and awareness.

    More

  • In Praise of Resource Constraints

    IBM discovered decades ago that adding programmers to a software project that was late did not help. Indeed, progress slowed even more. The "resource-driven mindset," sometimes known as "throw more money at the problem," is limited, the authors argue. Yet this mindset has so dominated the research agenda that it has clouded our consideration of many situations in which scarce resources (precisely because they are scarce) are desirable, potentially leading to breakthrough performance. Resource constraints fuel innovation in two ways: through entrepreneurial, social-network approaches to securing the missing funds or the required personnel, and because teams often produce better results as a direct result of the constraints. The human mind is most productive when restricted, the authors maintain. Limited -- or better focused -- by specific rules and constraints, we are more likely to recognize an unexpected idea. Witness the outcome of a Cold War-era race between General Electric and BMW teams to design adequately cooled jet engines. The U.S. team had a virtual blank check, used the most advanced materials and spent nearly twice as much as the Manhattan Project did. The German team, which had significantly less funding at its disposal, came up with a simple yet elegant design principle that remains in use to this day.

    More

  • The Myth of Commoditization

    Conventional wisdom has it that most innovations eventually become commodities, bought on the basis of price and nothing else. Citing a quotation by a Columbia Business School professor that epitomizes that point of view -- "In the long run, everything is a toaster" -- the author uses the technological history of toast to persuasively undermine that notion. Drawing on the wisdom of economists Ronald Coase, Paul Samuelson, John Maynard Keynes and Adam Smith, he makes a historical case that commodity is not destiny, and uses brands such as Starbucks, Evian, Dasani, Scott Paper, Yahoo and Google, Hoover and Dyson to illustrate the point. The danger, he says, is that executives, entrepreneurs and investors may buy into the commodity designation far more often than they should, making the commodity ideology a self-fulfilling prophecy. Businesses that believe that today's breakthrough is tomorrow's toaster understandably fear rapidly diminishing returns from their innovation investments, and the economics of "good enough" innovation become good enough. The potential of ideas is inherently undervalued. Sustainable innovation opportunities are either missed or dismissed. Intense price competition, the author argues, may not signal the prolific presence of substitutable commodities but rather an arid absence of innovation. That signal, he says, should give a clear and present incentive for executives and entrepreneurs to innovate in order to differentiate; to identify hidden or untapped potential for new value creation.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0004
My Controller Construct  0.0003
Build Nav  0.0007
Controller Execution Time ( Products / Route )  0.1212
Total Execution Time  0.1216
  GET DATA  
$_GET['cat_id']   245
$_GET['offset']   90
  MEMORY USAGE  
1.8974 MB
  POST DATA  
No POST data exists
  URI STRING  
store/innovation
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 131  (Hide)
0.0002  

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

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

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

SELECT FOUND_ROWS() AS total 

0.0002  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1073' 
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` =  '1073'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0004  

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.0002  

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1073'
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` =  '1073'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0002  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1095'
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` =  '1095'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1113'
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` =  '1113'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1133'
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` =  '1133'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1145'
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` =  '1145'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1151'
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` =  '1151'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1143'
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` =  '1143'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1209'
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` =  '1209'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_idIN ('A''B''D') 
AND `
parent_id` =  '1249'
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` =  '1249'
AND `kind` =  'image_600x600'
ORDER BY IF(position 010) AS, `position
0.0001  

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

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

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

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)