Skip to content

Marketing P. 9

Page 21 of 21

  • Product cover

    First to Market, First to Fail? Real Causes of Enduring Market Leadership

    Gerard J. Tellis, Peter N. Golder
    January 15, 1996 | MARKETING

    Using a historical method, the authors try to determine why pioneeers fail and early leaders succeed.

    More

  • Product cover

    How Should National Brands Think about Private Labels?

    Stephen J. Hoch
    January 15, 1996 | MARKETING

    \/-0

    More

  • Product cover

    Speeding High-Tech Producer, Meet the Balking Customer

    Anirudh Dhebar
    January 15, 1996 | MARKETING

    Increasingly, hardware producers and software developers are falling over each other to be first to market with even newer and even more improved versions. To use IT-intensive products effectively, consumers often must make long-term financial and nonfinancial investments in the product or in the overall system; they expect to be able to use the product for an extended period before having to repeat the investment. The rapid introduction of new and improved versions can make a consumer regret a previous purchase, hesitate over any new purchase, and agonize over similar purchases in the future. It is not in a producer's long-term interest if consumers balk. The author articulates the underlying reasons for -- and the consequences of -- adverse consumer reaction to rapid product improvement and offers suggestions for mitigating some of these reactions.

    More

  • Product cover

    Marketing Strategies for the Ethics Era

    N. Craig Smith
    July 15, 1995 | MARKETING

    Marketing strategies are increasingly subject to public scrutiny and are being held to higher standards. Caveat emptor is no longer acceptable as a basis for justifying marketing practices. The author's "marketing ethics continuum" explains the shift in society's expectations of marketers and provides benchmarks against which marketers can evaluate their practices and perspectives. Today, consumers' interests are increasingly favored over producers'; consumers can make more informed choices, and less capable consumers are offered special protection. The author provides a practical framework - including the consumer sovereignty test - for marketers to apply to their decision making. The framework attempts to answer the question: What constitutes ethical marketing practice? The test examines consumer capability, information provision, and consumer choice.

    More

  • Product cover

    How to Address the Gray Market Threat Using Price Coordination

    Gert Assmus , Carsten Wiese
    April 15, 1995 | MARKETING

    Gray market goods are brand name products sold through unauthorized channels. Gray markets have recently become more threatening to multinational companies as a result of the increasing number of global products available and easily accessible price information about them. The authors present a framework to select the right approach to the gray market threat by coordinating price-setting decisions based on the subsidiary's local resources and the complexity of the product's market. Through examples from their sample of companies that have dealt with gray markets, they show how price coordination methods have been implemented.

    More

  • Product cover

    Best Practice for Customer Satisfaction in Manufacturing Firms

    Abbie Griffin , Greg Gleason , Rick Preiss , Dave Shevenaugh
    January 15, 1995 | MARKETING

    Although researchers have concentrated on various measures of customer satisfaction (CS) and the relationship of CS to firm performance, they have done little to determine what constitutes the best practices of firms focusing on CS as a corporate strategy. These authors report the results of their investigation into the best practices of four manufacturing firms with reputations for delivering high levels of customer satisfaction. They found that, although the firms developed a CS strategy for different reasons, each had similar characteristics that enabled them to concentrate on satisfying the customer. While the firms generally outperformed the average firm in their industry in profits and asset utilization after adopting a customer satisfaction strategy, they were not as successful in increasing market share; nor has the market valued them as highly as it has valued others in their industry. Finally, the authors suggest ways companies can improve their customer satisfaction measures and practices.

    More

  • Product cover

    Financial Analysis for Profit-Driven Pricing

    Gerald E. Smith, Thomas T. Nagle
    April 15, 1994 | MARKETING

    An effective pricing decision should involve an optimal blending of internal financial constraints and external market conditions.

    More

  • Product cover

    Understanding Customer Expectations of Service

    A. Parasuraman , Leonard L. Berry, Valarie A. Zeithaml
    April 15, 1991 | MARKETING

    Some companies have more than just a competitive advantage in customer service, they have unwavering customer loyalty. How do they do it? The authors argue that the key to providing superior service is understanding and responding to customer expectations. Through their research, two different kinds of expectations emerged, both of which can change over time and from one service encounter to the next for the same customer. By responding appropriately to these expectations, managers can be on their way to developing a “customer franchise.”

    More

  • Product cover

    Five Imperatives for Improving Service Quality

    Leonard L. Berry, Valarie A. Zeithaml, A. Parasuraman
    July 15, 1990 | MARKETING

    It is time for U.S. companies to raise their service aspirations significantly and for U.S. executives to declare war on mediocre service and set their sights on consistently excellent service, say the authors. This goal is within reach if managers will provide the necessary leadership, remember that the sole judge of service quality is the customer, and implement what the authors call the "five service imperatives."

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0006
My Controller Construct  0.0003
Build Nav  0.0005
Controller Execution Time ( Products / Route )  0.0638
Total Execution Time  0.0644
  GET DATA  
$_GET['cat_id']   247
$_GET['offset']   200
  MEMORY USAGE  
1.7897 MB
  POST DATA  
No POST data exists
  URI STRING  
store/marketing
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 147  (Hide)
0.0008  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `sku` IN ('marketin', 'marketinP', 'marketinC', 'marketinX') 
AND `type_id` =  'V'
LIMIT 1 
0.0002  

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

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 = 247 AND
                        (
                            c.sku = 'marketing' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'marketing'
                        )
                    LIMIT 1 
0.0005  

SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name` 
0.0003  

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` =  '247'
AND `kind` =  'hero_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0081  

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 ('247','282','285','283','299','296')
GROUP BY `c`.`parent_id`
ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_date` DESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 200 
0.0012  

SELECT FOUND_ROWS() AS total 
0.0002  

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

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

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

SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name` 
0.0008  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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)