Skip to content

Managing Technology P. 7

Page 15 of 15

  • Product cover

    Improve Software Quality by Reusing Knowledge and Experience

    Victor R. Basili , Gianluigi Caldiera
    October 15, 1995 | MANAGING TECHNOLOGY

    The approaches for improving quality in manufacturing processes don't work especially well for software development. The authors provide a quality improvement paradigm for the software industry that builds on manufacturing models but focuses on reused learning and experience by establishing "experience factories." Their iterative process enables an organization to acquire core competencies to support its strategic capabilities.

    More

  • Product cover

    Hurdle the Cross-Functional Barriers to Strategic Change

    Michael D. Hutt , Beth A. Walker , Gary L. Frankwick
    April 15, 1995 | MANAGING TECHNOLOGY

    More

  • Product cover

    Electronic Markets and Virtual Value Chains on the Information Superhighway

    Robert Benjamin , Rolf Wigand
    January 15, 1995 | MANAGING TECHNOLOGY

    How will future traffic on the information superhighway affect each segment of an industry value chain? Will electronic markets provide new areas of opportunity for retailers, producers, and consumers as well? The authors suggest that the NII, or national infrastructure, will give consumers increased access to a vast selection of goods but will cause a restructuring and redistribution of profits among the stakeholders along the chain. There will also be an evolution from single-source sales channels to electronic markets. And electronic markets may lower coordination costs for producers and retailers, lower physical distribution costs, or eliminate retailers and wholesalers entirely, as consumers directly access manufacturers. Consumers' full access to the market will also be an issue that policymakers need to explore.

    More

  • Product cover

    How to Manage an IT Outsourcing Alliance

    F. Warren McFarlan , Richard L. Nolan
    January 15, 1995 | MANAGING TECHNOLOGY

    Companies are increasingly outsourcing information technology for a variety of reasons, such as concern for cost and quality, lagging IT performance, supplier pressure, and other financial factors. The outsourcing solution is acceptable to large and small firms alike because strategic alliances are now more common and the IT environment is changing rapidly. The authors offer their suggestions for determining when to outsource and how to structure and manage the resulting alliance. Most important, they suggest, is to view the outsourcing agreement as a strategic alliance and manage it as such.

    More

  • Product cover

    The Case for Expressive Systems

    Richard Pawson , Jean-Louis Bravard , Lorette Cameron
    January 15, 1995 | MANAGING TECHNOLOGY

    A new kind of information system is emerging that will reduce the time to market, help tailor products and services to customers' needs, and make processes more responsive to unexpected events. Expressive systems allow users to adapt quickly and easily to exceptions from standard operating procedure. The authors describe how expressive systems work and suggest ways of modifying the roles and structure of IS departments to implement the new technology.

    More

  • Product cover

    Exploiting Opportunities for Technological Improvement in Organizations

    Marcie J. Tyre , Wanda J. Orlikowski
    October 15, 1993 | MANAGING TECHNOLOGY

    Managers have learned that, to exploit the advantages of new process technologies, they must adapt those technologies to fit the organization and its strategy. But exactly how and when to make those changes is not well understood. The authors argue that technological improvement is seldom a steady process but instead alternates between short episodes of intensive change activity and longer periods of routine use. Data from European and U.S. firms show that adaptation to new technologies often occurs in a "lumpy" or episodic pattern. Examination of several leading Japanese organizations reveals a similar pattern, with one important difference: managers in these operations actively exploit the episodic pattern of adaptation around a given technology. Drawing on these observations, the authors suggest that managing the uneven pace of adaptation can yield important benefits to firms pursuing both efficiency and change.

    More

  • Product cover

    Adoption of Software Engineering Process Innovations: The Case of Object Orientation

    Robert G. Fichman , Chris F. Kemerer
    January 15, 1993 | MANAGING TECHNOLOGY

    CIOs seeking advice on new software process technologies can learn from other domains.

    More

  • Product cover

    The New Industrial Engineering: Information Technology and Business Process Redesign

    Thomas H. Davenport, James E. Short
    July 15, 1990 | MANAGING TECHNOLOGY

    A new type of industrial engineering blends technological capabilities with business process redesign.

    More

  • Product cover

    Technical Debt Might Be Hindering Your Digital Transformation

    Adam Burden, Edwin Van der Ouderaa, Ramnath Venkataraman, Tomas Nyström, Prashant P. Shukla
    | MANAGING TECHNOLOGY

    Digital decoupling is a key to combating technical debt and unlocking strategic agility.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0014
My Controller Construct  0.0004
Build Nav  0.0006
Controller Execution Time ( Products / Route )  0.0496
Total Execution Time  0.0510
  GET DATA  
$_GET['cat_id']   243
$_GET['offset']   140
  MEMORY USAGE  
1.8870 MB
  POST DATA  
No POST data exists
  URI STRING  
store/managing-technology
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 143  (Hide)
0.0003  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'c3d18dee5a54bf4814a91ae5e065c9ed'
ORDER BY `created_at` DESC 
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.0023  

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

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 140 
0.0001  

SELECT FOUND_ROWS() AS total 
0.0001  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'D') 
AND `parent_id` =  '3725'
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` =  '3725'
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)