Skip to content

Strategy P. 17

Page 39 of 46

  • Product cover

    The Organizational Identity Trap

    July 15, 2002 | STRATEGY

    The answer to the question, "Who are we?" is complex, elusive and can confound strategic change.

    More

  • Product cover

    Is Global Software an Oxymoron?

    April 15, 2002 | STRATEGY

    More

  • Product cover

    Is Your E-Business Plan Radical Enough?

    Glenn Rifkin , Joel Kurtzman
    April 15, 2002 | STRATEGY

    During the dot-com frenzy of the late 1990s, most large, traditional companies had trouble finding successful e-business strategies to fight off aggressive new challengers. Many turned over their Internet efforts to the CIO and the information-technology organization. But that was not always a good idea, say management thinkers Glenn Rifkin and Joel Kurtzman. Enlightened corporations, they say, have made the Internet work for them by assigning e-business efforts to senior-level executives who know the business side intimately & #8212; and by getting the most out of technology-focused CIOs in the role of partner. They contend that someday all business will be e-business, so even in an economic downturn it’s important for companies to keep moving forward by integrating e-channels with their other business channels. The authors maintain that a downturn offers laggards a chance to get back into the game. Thus large companies with ineffective Web presences should take advantage of the current window of opportunity to make improvements. That means resisting the temptation to fob off e-business onto the IT department and instead treating it as a long-term, strategic, integral part of the enterprise. The authors report on the rare traditional companies that offer these valuable lessons: Integrate the new channel with other channels, build on your strengths, don’t let technical considerations be the tail that wags the dog, find a CIO who thinks like a business leader, and have a business expert head the operation. As Meg Whitman, the president and CEO of Internet star eBay, has said, “You can teach the dot-com stuff quickly, but you can’t teach the business quickly, so hire someone who knows the business.”

    More

  • Product cover

    Maximizing Value in the Digital World

    Elliot Maltz , Vincent Chiappetta
    April 15, 2002 | STRATEGY

    The information age has created a host of digitized products & #8212; in the realms of software, databases, music, videos and electronic books & #8212; for which the potential for piracy, defined as duplication and distribution of a product without the permission of or payment to the content owner, is extremely high. Up to now, efforts to control piracy have been primarily legal in nature, relying upon the assumption that creators of digital products have absolute ownership rights to the content they create. Under the same assumption, companies have also sought to limit piracy with technological safeguards such as click-wrap contracts, encryption, password-limited access to distribution sites and copy proofing. However, say the authors, the belief in absolute ownership of digital content is incorrect from a legal standpoint, and antipiracy tactics that rely upon it will ultimately prove ineffective. What’s more, these tactics may even reduce authorized usage by paying customers. A far better solution, the authors suggest, is to recognize the dynamics of the marketplace, segment that market into innovators (potential pirates) and the mainstream (potential paying customers), and address each segment differently to gather information and establish market leadership. The authors use a variety of cases to illustrate the tactics whereby content creators can coexist with the innovator segment of their audiences while still controlling product price and distribution standards. The key to setting an effective, “priced” value proposition for majority users lies in incorporating the innovator’s technology before it reaches the mainstream. In such a scenario, brand identity encourages the majority to recognize quickly the content provider as the standard source for the product. Brand strength is then enhanced through fair pricing, product enhancement and superior distribution mechanisms.

    More

  • Product cover

    The Elements of Platform Leadership

    Michael A. Cusumano, Dr. Annabelle Gawer a.gawer@imperial.ac.uk
    April 15, 2002 | STRATEGY

    Platform leadership is the ability of a company to drive innovation around a particular platform technology at the broad industry level.

    More

  • Product cover

    The Perils of Power

    April 15, 2002 | STRATEGY

    Farsighted investors can check wayward founder-CEOs by creating strong and independent boards.

    More

  • Product cover

    What's the Best Commercialization Strategy for Startups?

    April 15, 2002 | STRATEGY

    More

  • Product cover

    Adding Value in the Boardroom

    Edward E. Lawler III, David Finegold , George Benson , Jay Conger
    January 15, 2002 | STRATEGY

    More

  • Product cover

    Has Strategy Changed?

    Kathleen M. Eisenhardt
    January 15, 2002 | STRATEGY

    What shapes strategy today and how has it changed? While many executives were focused on the implications of the Internet, a more powerful force was at work, contends Stanford University professor Kathleen M. Eisenhardt: globalization. Globalization has quietly transformed the economic playing field. The traditional strategic paradigms (positioning, core competence and the like) are not dead, but they are less germane than they were. Schumpeter’s “creative destruction” and similar economic views are coming into their own. The new economics is more entrepreneurial. It centers on disequilibrium, fleeting opportunities to capture competitive advantage, and the creation and destruction of wealth. Successful strategy in today’s world is simple; it uses a few clear guidelines and allows for flexibility. It is supported by organizational design; it is not handed down from on high. And timing is everything. Eisenhardt cites Colgate’s use of simplicity in a key strategic process, global product management. Colgate has found success through allowing product managers considerable freedom within a couple of simple guidelines (Maintain the Brand; Keep Relative Product Positioning Stable). That thinking also has been a boon to Ispat International, which uses uncomplicated rules for choosing and integrating acquisitions and has thus become one of the world’s fastest-growing steel companies. In contrast, Intel and SAP stumbled with their joint venture for e-commerce services, Pandesic. Although the companies had ample resources and a clear vision of their desired strategic position, their plan’s complexity kept them from adjusting as the market unfolded. Eisenhardt explains how managers can refocus their strategy on key processes and simple rules, mapping their individual businesses to market opportunities and employing an evolutionary form of timing to move from one competitive advantage to the next.

    More

  • Product cover

    Maximizing Value Through Diversification

    January 15, 2002 | STRATEGY

    Diversifying can be the best way for companies to match their capabilities to the marketplace.

    More

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0011  

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0004  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0005  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0013  

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0004  

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0004  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0010  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0016  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0004  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0005  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '559f973ead0c09a2db7db926d881e435'
ORDER BY `created_at` DESC 
0.0008  

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

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

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

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

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

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 380 
0.0029  

SELECT FOUND_ROWS() AS total 
0.0018  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1890' 
0.0007  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1889' 
0.0006  

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

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

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

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

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` =  '1889' 
0.0006  

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1916' 
0.0006  

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

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1915' 
0.0013  

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

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` =  '1915' 
0.0011  

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1899'
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` =  '1899'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0006  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '887' 
0.0014  

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1903'
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` =  '1903'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1901'
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` =  '1901'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1923'
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` =  '1923'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1917'
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` =  '1917'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1951'
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` =  '1951'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0001  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '906' 
0.0003  

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1933'
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` =  '1933'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '1957'
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` =  '1957'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0004  

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)