Skip to content

Marketing P. 8

Page 18 of 21

  • Product cover

    Creating a Superior Customer-Relating Capability

    George S. Day
    April 15, 2003 | MARKETING

    Companies with the best connections to their customers focus on the people and businesses that buy from them.

    More

  • Product cover

    Dueling Pricing Strategies

    April 15, 2003 | MARKETING

    More

  • Product cover

    Selectively Pursuing More of Your Customer's Business

    Prof. James C. Anderson jc-anderson@kellogg.northwestern.edu, James A. Naurus
    April 15, 2003 | MARKETING

    Most suppliers lack sufficient customer knowledge to implement anything but the most sales-oriented growth strategies and tactics. If they wish to achieve profitable, sustainable growth and a larger share of their customers’ wallets, they need a fine-grained, disciplined approach to obtaining, leveraging and documenting customer knowledge. James C. Anderson of Northwestern’s Kellogg School and James A. Narus of Wake Forest University have been conducting management-practice research with companies that have superior knowledge of their customers and use it to devise and implement focused, inventive strategies that create profitable growth while increasing the value delivered. Using the examples of best-practice suppliers such as Bank of America, Seghers, Technische Unie, KLM Cargo and Telindus, the authors suggest a strategic framework to guide supplier managers in the selective pursuit of a greater share, predicated on estimating the current share of each customer’s business, selecting and pursuing appropriate and inventive opportunities to increase that share, and carefully documenting the profitability efforts. According to Anderson and Narus, building the scope of the market offering, broadening collaboration and using multiple single sourcing each represent ways of growing business share selectively with a customer while improving profitability for both the supplier and customer.

    More

  • Product cover

    The Global-Brand Advantage

    April 15, 2003 | MARKETING

    Research indicates that buyers are more likely to perceive value in global brands.

    More

  • Product cover

    What Hooks M-Commerce Customers?

    April 15, 2003 | MARKETING

    Research reveals factors that affect the likelihood of transacting business over mobile phones.

    More

  • Product cover

    Lessons From Online Groceries

    January 15, 2003 | MARKETING

    How the industry's evolution can inform all e-tail enterprises.

    More

  • Product cover

    Understanding and Managing the Brand Space

    Pierre Berthon , Morris B. Holbrook , James M. Hulbert
    January 15, 2003 | MARKETING

    Brands have become increasingly difficult to manage. As many brands become more global, for instance, they are expanding beyond relationships just between manufacturers and customers to relationships that include employees, the investment community, the media, suppliers, governments & #8212; even competitors. Thus, the meaning of a brand is not merely the result of a dialogue between buyer and seller; it instead arises from a multilogue. Indeed, brand management has become a complex undertaking, requiring new approaches and models. To that end, the authors have developed a theoretical framework that companies can use to manage their brands more effectively. Specifically, the authors propose the concept of a brand space, which is based on two dimensions: the degree of abstraction (whether the brand has become independent from its associated product) and the degree of enactment (whether the brand focuses more on the meaning of a product or its functionality). By understanding the various dynamics of the brand space, companies can make wiser branding decisions, particularly as they confront escalating competition and rapidly changing markets.

    More

  • Product cover

    What Causes Markets To Take Off?

    January 15, 2003 | MARKETING

    More

  • Product cover

    Asking for Trouble

    October 15, 2002 | MARKETING

    More

  • Product cover

    New Views on Digital CRM

    Lauren Keller Johnson
    October 15, 2002 | MARKETING

    Managers' opinions vary about the goals and value of Internet marketing.

    More

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'ad79b66c4eff499c2543dba6a2f3e128'
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.0030  

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

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

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 170 
0.0002  

SELECT FOUND_ROWS() AS total 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '1763' 
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` =  '1763'
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.0002  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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