Skip to content

Data, AI, & Machine Learning P. 9

Page 21 of 21

  • Product cover

    Are You Ready to Reengineer Your Decision Making?

    Thomas H. Davenport, Michael S. Hopkins
    October 1, 2010 | DATA, AI, & MACHINE LEARNING

    Five years ago, analytics practitioners spent about 95% of their time reporting on the past and only about 5% on analysis. Most companies were not really focused on the issue of analytics. While reporting is good, it's not enough. Companies need to understand why those data turned out the way they did, what it might do in the future and how they might optimize a particular one of those variables. Thomas H. Davenport, President's Chair in Information Technology and Management at Babson College, says the potential for analytics to become a critical tie to decision making remains an untapped opportunity for most companies. In a new MIT SMR interview, Davenport explores why the proliferation of data has not led to better decision-making. Davenport looks at the challenges that lie in the way of analytics being embraced by executives and how they can use analysis to understand and manage their business more effectively.

    More

  • Product cover

    Problem Solving By Design

    Michael S. Hopkins, John Shook
    July 1, 2009 | DATA, AI, & MACHINE LEARNING

    In his book Managing to Learn, John Shook deconstructs the problem-solving journey of one manager and his mentor, and the management mechanism that guided them. The backstory? Shook knows the journey firsthand.

    More

  • Product cover

    The Prediction Lover’s Handbook

    Thomas H. Davenport, Jeanne G. Harris
    January 7, 2009 | DATA, AI, & MACHINE LEARNING

    Assessment tools for better-informing decisions have proliferated. Which ones work?

    More

  • Product cover

    Wanted: Time to Think

    October 1, 2008 | DATA, AI, & MACHINE LEARNING

    Creative insights require time "Ò and a pace at odds with today’s accelerated economy.

    More

  • Product cover

    Delight or Despair

    July 1, 2007 | DATA, AI, & MACHINE LEARNING

    Avoiding the pitfalls in leveraging customer data.

    More

  • Product cover

    Double Agents

    Gerald HÌ_ubl, Kyle B. Murray
    April 1, 2006 | DATA, AI, & MACHINE LEARNING

    INTELLIGENCE: RESEARCH BRIEF: Assessing the role of electronic product-recommendation systems.

    More

  • Product cover

    Managing Codified Knowledge

    Michael H. Zack
    July 15, 1999 | DATA, AI, & MACHINE LEARNING

    Firms can derive significant benefits from consciously, proactively, and aggressively managing their explicit and explicable knowledge, which many consider the most important factor of production in the knowledge economy. Doing this in a coherent manner requires aligning a firm's organizational and technical resources and capabilities with its knowledge strategy. However, appropriately explicating tacit knowledge so it can be efficiently and meaningfully shared and reapplied -- especially outside the originating community -- is one of the least understood aspects of knowledge management. This suggests a more fundamental challenge, namely, determining which knowledge an organization should make explicit and which it should leave tacit -- a balance that can affect competitive performance. The management of explicit knowledge utilizes four primary resources that the author details: repositories of explicit knowledge; refineries for accumulating, refining, managing, and distributing the knowledge; organization roles to execute and manage the refining process; and information technologies to support the repositories and processes. On the basis of this concept of knowledge management architecture, a firm can segment knowledge processing into two broad classes: integrative and interactive -- each addressing different knowledge management objectives. Together, these approaches provide a broad set of knowledge-processing capabilities. They support well-structured repositories for managing explicit knowledge, while enabling interaction to integrate tacit knowledge. The author presents two case studies of managing explicit knowledge. One is an example of an integrative architecture for the electronic publishing of knowledge gleaned by industry research analysts. The second illustrates the effective use of an interactive architecture for discussion forums to support servicing customers. Zack also discusses several key issues about the broader organizational context for knowledge management, the design and management of knowledge-processing applications, and the benefits that must accrue to be successful. In summary, organizations that are managing knowledge effectively (1) understand their strategic knowledge requirements, (2) devise a knowledge strategy appropriate to their business strategy, and (3) implement an organizational and technical architecture appropriate to the firm's knowledge-processing needs.

    More

  • Product cover

    Data as a Resource: Properties, Implications, and Prescriptions

    Anany V. Levitin , Thomas C. Redman
    October 15, 1998 | DATA, AI, & MACHINE LEARNING

    Almost every activity in which the enterprise engages, from the most mundane operation to the most far-reaching decision, requires data. Yet data are rarely managed well: few enterprises know what data they have; people cannot access or use data; and data quality is often low. Furthermore, individuals and business units often hoard data, leading to political battles over ownership. To help enterprises manage data as a business resource, the authors survey the fundamental properties of data and explore the special challenges and opportunities involved in working with data. "Data" consist of "data models," which are the organization's definitions of entities, their attributes, and the relationships among them, and "data values," which are the specific realizations of an attribute of the data model for particular entities. "Data records" are the physical manifestations of data stored in paper files, spreadsheets, and databases. Data have many distinctive qualities: for example, they are intangible; easy to copy, share, and transport; can be destroyed or lost inadvertently; are used for a variety of purposes; and are renewable. These and other properties of data have management implications in five key areas: making arrangements to supply the needs of data users; ensuring that individuals can access data; protecting data security; improving and maintaining data quality; and employing data effectively in operations and strategy. The authors offer a set of prescriptions to help enterprises meet these challenges: institute data quality and data supplier management programs, hone data needs, identify and manage critical information chains, recognize the proper role of technology, develop and disseminate an inventory of data resources, specify the terms under which data can be shared, avoid futile political battles, delineate management accountabilities, and ensure that senior executives lead the data management program.

    More

  • Product cover

    Improve Data Quality for Competitive Advantage

    Thomas C. Redman
    January 15, 1995 | DATA, AI, & MACHINE LEARNING

    Errors in data can cost a company millions of dollars, alienate customers, and make implementing new strategies difficult or impossible. The author describes a process AT&;T uses to recognize poor data and improve their quality. He proposes a three-step method for identifying data-quality problems, treating data as an asset, and applying quality systems to the processes that create data.

    More

  BENCHMARKS  
Loading Time: Base Classes  0.0005
My Controller Construct  0.0004
Build Nav  0.0005
Controller Execution Time ( Products / Route )  0.0937
Total Execution Time  0.0942
  GET DATA  
$_GET['cat_id']   276
$_GET['offset']   200
  MEMORY USAGE  
1.7972 MB
  POST DATA  
No POST data exists
  URI STRING  
store/data-ai-machine-learning
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 143  (Hide)
0.0022  

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8ba0cc924403c66f7e1a498ff256f2c0'
ORDER BY `created_at` DESC 
0.0007  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8ba0cc924403c66f7e1a498ff256f2c0'
ORDER BY `created_at` DESC 
0.0015  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '8ba0cc924403c66f7e1a498ff256f2c0'
ORDER BY `created_at` DESC 
0.0009  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'data-ai-machine-learning'
AND `parent_id` =  1 
0.0028  

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 = 276 AND
                        (
                            c.sku = 'data-ai-machine-learning' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'data-ai-machine-learning'
                        )
                    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` =  '276'
AND `kind` =  'hero_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0362  

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 ('276','274','280','289','275','294')
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.0002  

SELECT FOUND_ROWS() AS total 
0.0002  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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