Skip to content

Workplace, Teams, & Culture P. 9

Page 19 of 21

  • How to Build Collaborative Advantage

    For many years, multinational corporations could compete successfully by exploiting scale and scope economies or by taking advantage of imperfections in the world's goods, labor and capital markets. But these ways of competing are no longer as profitable as they once were. In most industries, multinationals no longer compete primarily with companies whose boundaries are confined to a single nation. Rather, they go head-to- head with a handful of other giants. Against such global competitors, it is hard to sustain an advantage based on traditional economies of scale and scope. MNCs must seek new sources of competitive advantage. While multinationals in the past realized economies of scope principally by utilizing physical assets and exploiting a companywide brand, the new economies of scope are based on the ability of business units, subsidiaries and functional departments within the company to collaborate successfully by sharing knowledge and jointly developing new products and services. Collaboration can be an MNC's source of competitive advantage because it does not occur automatically -- far from it. Indeed, several barriers impede collaboration within complex multiunit organizations. And in order to overcome those barriers, companies will have to develop distinct organizing capabilities that cannot be easily imitated. The authors develop a framework that links managerial action, barriers to interunit collaboration and value creation in MNCs to help managers understand how collaborative advantage can work. The framework conceptualizes collaboration as a set of management levers that reduce four specific barriers to collaboration, leading in turn to several types of value creation. They draw on BP's experience to illustrate the effectiveness of a collaborative approach.

    More

  • How to Lead a Self-Managing Team

    Many companies organize employees into self-managing teams that are basically left to run themselves with some guidance from an external leader. In fact, comprehensive surveys report that 79% of companies in the Fortune 1,000 currently deploy such “empowered,” “self-directed” or “autonomous” teams. Because of their widespread use, much research has been devoted to understanding how best to set up self-managing teams to maximize their effectiveness. Interestingly, though, relatively little attention has been paid to the leaders who must oversee such working groups. At first, it seems contradictory: Why should a self-managing team require any leadership at all? But the authors’ research has shown that self-managing teams require a particular kind of leadership. Specifically, the external leaders who contribute most to their team’s success tend to excel at one skill: managing the boundary between the team and the larger organization. That process requires specific behaviors that can be grouped into four basic functions: (1) moving back and forth between the team and the broader organization to build relationships, (2) scouting necessary information, (3) persuading the team and outside constituents to support one another, and (4) empowering team members.

    More

  • The Balance of Power

    A corporate sphere of influence is not just a platform for a company’s offensive or defensive initiatives. It is the basis upon which the company builds market power over rivals so it can maneuver freely without fear of retaliation.

    More

  • Leaders Who Inspire Commitment

    Tapping traditional Asian values can instill cross-cultural managerial capabilities.

    More

  • Avoiding Repetitive Change Syndrome

    Most management advice today -- whether it's from books or articles, prescribed in courses or by consultants -- says that change is good and more change is better. Advice on how to change varies quite a bit, but it has three features in common: "Creative destruction" is its motto. "Change or perish" is its justification. And "no pain, no change" is its rationale for overcoming a purportedly innate human resistance to change. The author admits that creative destruction may be necessary, and even preferable, in certain situations. Companies that have enjoyed captive markets, docile suppliers and government support may need the rude awakening it provides. In such instances, organizational stability is so ingrained that creative destruction may even be the best way to achieve change with the least amount of pain. But for every change avoider today, he says, there are many more "change-aholics" -- companies that have changed more aggressively, quickly and repeatedly than any organization could hope to do successfully. In the process, they have often suffered from "more pain, less change." The author urges executives at such companies to continually monitor their organizations for symptoms of repetitive change syndrome: initiative overload, change-related chaos, employee cynicism and burnout.

    More

  • Building Better Teams

    The value of external knowledge sharing increases when work groups are more structurally diverse.

    More

  • Don't Blame the Engineers

    Several recent spectacular management failures call into doubt the ability of nontechnical managers to supervise the complex engineered systems for which they are increasingly responsible. However, the author of this article believes effective generalist managers in technical fields need to understand the risks faced and must sufficiently grasp the technology to effectively "talk the talk" with their staff and colleagues. To accomplish this, he contends that managers should focus relentlessly on key corporate priorities, continuously measuring employee performance to emphasize these crucial metrics. The author also recommends establishing official and unofficial pathways for collecting unfiltered and accurate information -- in particular, by developing a "back channel" of direct personal contact with one or two trusted technical staff with real insight into the unvarnished truth. In the end, the author contends, an insistence on facts rigorously applied, along with a cultivation of a "push back" culture that encourages people to raise concerns must underlie the commitments a technical organization makes. In this way, the author insists, a healthy organization can effectively handle both routine activities and serious crises regardless of who's in charge.

    More

  • The Social Side of Performance

    What separates high-performing knowledge workers from their more-average peers? Superior ability is part of the answer, as is superior expertise. But according to the authors, what really distinguishes high performers from the rest of the pack is their ability to maintain and leverage personal networks. The most effective knowledge workers create and tap large, diversified networks that are rich in experience and span all organizational boundaries. Contrary to the popular image of the networker, the authors say, the building and use of such networks is rarely motivated by explicit political or career-driven motives. In addition, they posit that high performers are much more than "social butterflies," who tend to have numerous relationships that don't scratch below the surface. Effective knowledge workers focus on building deeper relationships that will be mutually beneficial over time. The authors discuss the three tactics used by high performers to build and maintain their networks. Ideally, they say, organizations should use tools and readily available human-resources practices to hire people who are likely to develop large, widespread networks. Once on board, people should be encouraged through incentives to maintain their networks. Such important work -- and it is work, even if isn't usually visible -- shouldn't be left strictly to chance.

    More

  • Managing Partner Relations in Joint Ventures

    Between 1991 and 2001, the average number of joint-venture deals announced each year increased from 1,000 to 7,000. Executives are clearly setting great store by these temporary partnerships as a way of achieving both short-term and longer-term goals. As with any type of alliance, however, success can be elusive, and a poor relationship between the partners is often at the root of difficulties within a venture. A negative cycle frequently develops in which poor partner relations lead to poor performance, which in turn puts the partner relations under greater pressure. In the course of her work with executives from joint ventures and their parent companies, the author identified five minefields that can explode and damage the relationships in an otherwise fruitful operation. Since joint ventures are here to stay -- they are still sometimes the only way for a company to enter a new market or to gain access to key technology or people -- managers must learn to avoid the minefields if they are to realize the full potential of these strategic partnerships.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0016
My Controller Construct  0.0003
Build Nav  0.0007
Controller Execution Time ( Products / Route )  0.1334
Total Execution Time  0.1351
  GET DATA  
$_GET['cat_id']   244
$_GET['offset']   180
  MEMORY USAGE  
1.9288 MB
  POST DATA  
No POST data exists
  URI STRING  
store/workplace-teams-culture
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 149  (Hide)
0.0010  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0004  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0011  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0016  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0004  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0013  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0011  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '43b7f4054846971bf6305f8c496c3406'
ORDER BY `created_atDESC 
0.0003  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM 
(`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'workplace-teams-culture'
AND `parent_id` =  
0.0065  

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 244 AND
                        (
                            
c.sku 'workplace-teams-culture' OR
                            if(
c.format_id 'Certificate'''p.url_friendly) = 'workplace-teams-culture'
                        
)
                    
LIMIT 1 
0.0063  

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

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` =  '244'
AND `kind` =  'hero_image'
ORDER BY IF(position 010) AS, `position
0.0144  

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 ('244','253','288','255')
GROUP BY `c`.`parent_id`
ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_dateDESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 180 
0.0004  

SELECT FOUND_ROWS() AS total 

0.0006  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1554' 
0.0004  

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

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` =  '1553'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0026  

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

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

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

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

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

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

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

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '762' 
0.0015  

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1572' 
0.0020  

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

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` =  '1571'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0015  

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1571' 
0.0006  

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

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

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

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '767' 
0.0004  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1585' 
0.0007  

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` =  '1585'
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` =  '1585'
ORDER BY `sortAS
0.0003  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1585' 
0.0005  

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

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` =  '1585' 
0.0004  

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

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

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '774' 
0.0011  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1601' 
0.0010  

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` =  '1601'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0004  

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1601' 
0.0005  

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

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

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1658' 
0.0009  

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

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` =  '1657'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0017  

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1657' 
0.0006  

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

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` =  '1657' 
0.0009  

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

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

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '806' 
0.0008  

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '806' 
0.0025  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '1666' 
0.0016  

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

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` =  '1665'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_idNOT IN (1261)  
0.0017  

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

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '1665' 
0.0006  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '837' 
0.0003  

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

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

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

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

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

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

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

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

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