Skip to content

Managing Technology P. 3

Page 5 of 15

  • Product cover

    What's Your Cognitive Strategy?

    Thomas Davenport , Vikram Mahidhar
    May 8, 2018 | MANAGING TECHNOLOGY

    In the eyes of many leaders, artificial intelligence and cognitive technologies are the most disruptive forces on the horizon. But most organizations don't have a strategy to address them.

    More

  • Product cover

    Your Company Doesn’t Need a Digital Strategy

    George Westerman
    March 13, 2018 | MANAGING TECHNOLOGY

    As sexy as it is to speculate about new technologies such as AI, robots, and the internet of things, the focus on technology can steer the conversation in a dangerous direction. Because when it comes to digital transformation, digital is not the answer. Transformation is. In various industries, including banking, paint, and shipbuilding, digital leaders are finding that technology’s value comes from doing business differently because technology makes it possible.

    More

  • Product cover

    Surviving a Day Without Smartphones

    Marcello Russo, Massimo Bergami, Gabriele Morandin
    November 22, 2017 | MANAGING TECHNOLOGY

    For young adults accustomed to continually checking their cellphones, even a single day without access to them can be anxiety-producing. What are the implications for executives about managing this constantly connected generation – and their devices -- in the workplace?

    More

  • Product cover

    Could the Big Technology Companies of Today Be the Financial Advisers of Tomorrow?

    Luis Viceira, Peter Nolan, Terrance Rogers, Anthony Runco
    October 12, 2017 | MANAGING TECHNOLOGY

    Following the example of Alibaba in China, Amazon is leveraging strong trust in its brand and its broad customer base to enter the U.S. financial market. While Alibaba saw opportunity in the lack of credit cards in China, Amazon could use credit cards’ ubiquity in the U.S. to reach a large pool of potential customers.

    More

  • Product cover

    MetLife Centers Its Strategy on Digital Transformation

    Gerald C. Kane
    July 26, 2017 | MANAGING TECHNOLOGY

    As demographic changes and technological advances upend the marketplace, MetLife has responded by making digital transformation the heart of its business model.

    More

  • Product cover

    Achieving Digital Maturity

    July 12, 2017 | MANAGING TECHNOLOGY

    In the 2017 Digital Business Report, MIT SMR and Deloitte find that digitally maturing companies are achieving success by increasing collaboration, scaling innovation, and revamping their approach to talent.

    More

  • Product cover

    Choosing Scope Over Focus

    Richard D'Aveni, John Landry
    March 29, 2017 | MANAGING TECHNOLOGY

    Digital technology has already upended the media and information sectors. It’s about to do the same to the manufacturing economy, and pave the way for what can be called the “pan-industrial” strategy.

    More

  • Product cover

    The Heavy Toll of ‘Always On’ Technology

    Frieda Klotz
    February 24, 2017 | MANAGING TECHNOLOGY

    Expectations of immediate responses to digital communications negatively impact productivity.

    More

  • Product cover

    How to Develop a Great Digital Strategy

    Jeanne W. Ross, Ina M. Sebastian, Cynthia M. Beath
    November 8, 2016 | MANAGING TECHNOLOGY

    More than one strategy can lead to digital success — but solid operations support is essential.

    More

  • Product cover

    Aligning the Organization for Its Digital Future

    Gerald C. Kane, Doug Palmer, Anh Nguyen Phillips, David Kiron, Natasha Buckley
    July 26, 2016 | MANAGING TECHNOLOGY

    Digitally savvy executives are already aligning their people, processes, and culture to achieve their organizationsÃ? long-term digital success.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0004
My Controller Construct  0.0003
Build Nav  0.0005
Controller Execution Time ( Products / Route )  0.0446
Total Execution Time  0.0451
  GET DATA  
$_GET['cat_id']   243
$_GET['offset']   40
  MEMORY USAGE  
1.8069 MB
  POST DATA  
No POST data exists
  URI STRING  
store/managing-technology
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 131  (Hide)
0.0002  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'managing-technology'
AND `parent_id` =  1 
0.0025  

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 = 243 AND
                        (
                            c.sku = 'managing-technology' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'managing-technology'
                        )
                    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.0002  

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

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 ('243','259','278','262','263','264')
GROUP BY `c`.`parent_id`
ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_date` DESC, `p`.`title`, `c`.`title`
LIMIT 10 OFFSET 40 
0.0001  

SELECT FOUND_ROWS() AS total 
0.0001  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '1540' 
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)