Strategy P. 11

Page 26 of 46

How to Manage Alliances Better Than One at a Time

Ulrich Wassmer, Pierre Dussauge, Marcel Planellas

April 1, 2010 | STRATEGY

Systematizing the analysis process should produce more gain and less pain when forming strategic partnerships.

More
What Every CEO Needs to Know About Nonmarket Strategy

David Bach, David Bruce Allen

April 1, 2010 | STRATEGY

In a global economy, sustained competitive advantage arises from tackling social, political and environmental issues as part of a corporate strategy.

More
Why Forecasts Fail. What to Do Instead

Spyros Makridakis, Robin M. Hogarth, Anil Gaba

January 1, 2010 | STRATEGY

Managers need to learn from history about what they can and cannot predict, and develop plans that are sensitive to surprises.

More
Do You Have A "Plan B"?

Alden M. Hayashi

October 1, 2009 | STRATEGY

Many companies have trouble making the transition from a failing business model to one that works. Often, one culprit is an inability to experiment.

More
The Advantage of Tolerating Failure

Martha E. Mangelsdorf

October 1, 2009 | STRATEGY

When venture capitalists are more tolerant of failure, the successful companies in their portfolio tend to be more innovative.

More
The Benefits Of Commitment

Andreas B. Eisingerich, Matthias Seifert

October 1, 2009 | STRATEGY

More
Innovation From the Inside Out

Erik Simanis, Stuart Hart

July 1, 2009 | STRATEGY

Grameen Bank and others know that you get the best answers by burying yourself in the questions.

More
What Lead Directors Do

Joseph J. Penbera

July 1, 2009 | STRATEGY

New research offers insights into an increasingly important boardroom role.

More
A Dearth of Exit Strategies

Joshua Gans

April 1, 2009 | STRATEGY

Fallout from the financial crisis could hinder innovation—by limiting options for technology start-ups.

More
How to Rethink Your Business During Uncertainty

Rita Gunther McGrath, Ian C. MacMillan

April 1, 2009 | STRATEGY

Leaders of many of today's mature organizations don't have the right mind-set or practices to help their organizations survive. They grew up with management practices that are suited to a different age--one with higher barriers to entry, greater transaction costs, fewer capable competitors, growing and increasingly affluent markets and less information. But today's business environments are less predictable, more complicated and more volatile. The result is that many core businesses are themselves becoming more uncertain and in need of renewal. Established management tools, such as net present value, are built on a foundation of assumed certainty that it's realistic to forecast likely cash flows into the future and discount them to today. In volatile business environments, though, such thinking is no longer practical. As an alternative, the authors offer practices used by successful growth companies, entrepreneurs and corporate new-business-development groups to navigate unpredictable, resource-constrained and surprising environments. In an unpredictable world, trying to be right can lead managers terribly astray. The "discovery-driven" approach outlined in this article emphasizes finding the right answers and reducing the assumption-to-knowledge ratio.

More

Loading Time: Base Classes	0.0008
My Controller Construct	0.0003
Build Nav	0.0009
Controller Execution Time ( Products / Route )	0.0921
Total Execution Time	0.0930

$_GET['cat_id']	249
$_GET['offset']	250

0.0007	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0002	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0002	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0003	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0001	SELECT * FROM (`carts`) WHERE `cart_id` = '695d629b49133c6df62118ec01b95abe' ORDER BY `created_at` DESC
0.0003	SELECT `parent_id` FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `sku` IN ('strateg', 'strategP', 'strategC', 'strategX') 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` = 'strategy' AND `parent_id` = 1
0.0072	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 = 249 AND ( c.sku = 'strategy' OR if(c.format_id = 'Certificate', '', p.url_friendly) = 'strategy' ) LIMIT 1
0.0007	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` = '249' AND `kind` = 'hero_image' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0200	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 ('249','284','270','279','254','260') GROUP BY `c`.`parent_id` ORDER BY `p`.`pool_id`, `p`.`position`, `p`.`publication_date` DESC, `p`.`title`, `c`.`title` LIMIT 10 OFFSET 250
0.0001	SELECT FOUND_ROWS() AS total
0.0002	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '808'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '807'
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` = '807' AND `product_categories`.`parent_id` = 1 AND `product_categories__products`.`cat_id` NOT IN (1, 261)
0.0010	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.0007	SELECT * FROM (`authors`) JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id` WHERE `products__authors`.`prod_id` = '807' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '807'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '807' 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` = '807'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '807' 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` = '807' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '392'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '392'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '786'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '785'
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` = '785' 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` = '785' ORDER BY `sort` ASC
0.0002	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '785'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '785' 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` = '785'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '785' 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` = '785' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '382'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '382'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '832'
0.0001	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '831'
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` = '831' 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` = '831' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '831'
0.0002	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '831' 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` = '831'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '831' 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` = '831' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '404'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '404'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '866'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '865'
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` = '865' 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` = '865' ORDER BY `sort` ASC
0.0008	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '865'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '865' 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` = '865'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '865' 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` = '865' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '421'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '421'
0.0002	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '874'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '873'
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` = '873' 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` = '873' ORDER BY `sort` ASC
0.0002	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '873'
0.0002	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '873' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0004	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` = '873'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '873' 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` = '873' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '425'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0002	SELECT * FROM (`media_metadata`) WHERE `media_id` = '425'
0.0002	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '872'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '871'
0.0006	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` = '871' 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` = '871' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '871'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '871' 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` = '871'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '871' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0015	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` = '871' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '424'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '424'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '904'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '903'
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` = '903' 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` = '903' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '903'
0.0003	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '903' 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` = '903'
0.0004	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '903' AND `type_id` = 'V' ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title`
0.0015	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` = '903' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '440'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '440'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '886'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '885'
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` = '885' 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` = '885' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '885'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '885' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0004	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` = '885'
0.0002	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '885' 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` = '885' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '431'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '431'
0.0001	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '944'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '943'
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` = '943' 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` = '943' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '943'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '943' 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` = '943'
0.0003	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '943' 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` = '943' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0002	SELECT * FROM (`media`) WHERE `media`.`media_id` = '459'
0.0001	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0003	SELECT * FROM (`media_metadata`) WHERE `media_id` = '459'
0.0002	SELECT `parent_id` FROM (`products`) WHERE `prod_id` = '938'
0.0002	SELECT * FROM (`products`) WHERE `products`.`prod_id` = '937'
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` = '937' 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` = '937' ORDER BY `sort` ASC
0.0001	SELECT * FROM (`product_flags__products`) WHERE `prod_id` = '937'
0.0001	SELECT `sku` FROM (`products__xsell`) WHERE `prod_id` = '937' 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` = '937'
0.0004	SELECT * FROM (`products`) WHERE `avail_id` IN ('A', 'B', 'D') AND `parent_id` = '937' 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` = '937' AND `kind` = 'image_600x600' ORDER BY IF(position = 0, 1, 0) ASC , `position`
0.0001	SELECT * FROM (`media`) WHERE `media`.`media_id` = '456'
0.0002	SELECT * FROM (`mime_types`) WHERE `mime_types`.`extension` = 'jpg'
0.0001	SELECT * FROM (`media_metadata`) WHERE `media_id` = '456'
0.0006	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_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION
SERVER_PORT	443
SERVER_NAME	mit-sloan.rarebirdinc.com
REMOTE_ADDR	3.148.109.104
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/2.0
QUERY_STRING	cat_id=249&offset=250
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR

session_id	4d882f692c64c346a0d87219ef37ef20
ip_address	3.148.109.104
user_agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
last_activity	1740216169
user_data
cart	Array ( [cart_id] => 695d629b49133c6df62118ec01b95abe [subtotal] => Array ( [Physical] => 0 [PDF] => 0 [Zip] => 0 [Audio] => 0 [Video] => 0 [Digital Replica] => 0 [eBook] => 0 [Certificate] => 0 [Print Sub] => 0 [Digital Sub] => 0 [Combo Sub] => 0 [Shippable] => 0 ) [item_count] => Array ( [Physical] => 0 [PDF] => 0 [Zip] => 0 [Audio] => 0 [Video] => 0 [Digital Replica] => 0 [eBook] => 0 [Certificate] => 0 [Print Sub] => 0 [Digital Sub] => 0 [Combo Sub] => 0 [Shippable] => 0 ) [contains_books] => 0 )

base_url	https://mit-sloan.rarebirdinc.com/
index_page
uri_protocol	AUTO
url_suffix
url_allowed_suffixes	Array ( [0] => html )
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
permitted_uri_chars	a-z 0-9~%.:_\-
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	4
log_path	/var/www/mit-sloan.com/logs/
log_date_format	Y-m-d H:i:s
cache_path
encryption_key	pIck\|3j@rZ
sess_cookie_name	ci_session
sess_expiration	7200
sess_expire_on_close
sess_encrypt_cookie
sess_use_database	1
sess_table_name	sessions
sess_match_ip
sess_match_useragent
sess_time_to_update	3000
cookie_prefix
cookie_domain	.mit-sloan.rarebirdinc.com
cookie_path	/
cookie_secure
global_xss_filtering
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
globals	Array ( [org] => SMR [company_name] => MIT Sloan Management Review [cs_address_1] => 238 Main Street E48-570 [cs_address_2] => [cs_city] => Cambridge [cs_state] => MA [cs_zip] => 02142 [cs_phone] => 617-253-7170 [cs_fax] => 617-258-9739 [cs_hours] => 8 a.m. - 5 p.m. [EST] Mon. - Fri. [cs_email] => smr-help@mit.edu [triliteral_email] => orders@triliteral.org [mit_issues_email] => smr-issues@mit.edu [order_confirm_email] => smr-noreply@sloan.mit.edu [webmaster_email] => webmaster@rarebirdinc.com [inventory_recips] => developer@rarebirdinc.com [meta_description] => MIT Sloan Management Review's online store [meta_keywords] => [copyright] => Copyright © Massachusetts Institute of Technology, 2025. All rights reserved. [ga_account] => [recaptcha] => Array ( [public_key] => [private_key] => ) [enable_users] => [doc_root] => /var/www/mit-sloan.com/web [media_path] => /var/www/mit-sloan.com/web/media [data_path] => /var/www/mit-sloan.com/web/../data [csv_path] => /var/www/mit-sloan.com/web/../data/csv [ini_path] => /var/www/mit-sloan.com/web/../data/ini [pdf_path] => /var/www/mit-sloan.com/web/../data/pdf [certificate_pdf_path] => /var/www/mit-sloan.com/web/../data/certificate_pdf [audio_path] => /var/www/mit-sloan.com/web/../data/audio [video_path] => /var/www/mit-sloan.com/web/../data/video [zip_path] => /var/www/mit-sloan.com/web/../data/zip [epub_path] => /var/www/mit-sloan.com/web/../data/epub [mobi_path] => /var/www/mit-sloan.com/web/../data/mobi [cli_path] => /var/www/mit-sloan.com/application/controllers/cli [title_suffix] => - MIT SMR Store [seo] => Array ( [default_title] => MIT SMR Store [og_image] => http://mit-sloan.rarebirdinc.com/assets/images/mit-smr-social-default.png ) [default_meta] => Array ( [description] => MIT Sloan Management Review's online store [keywords] => [copyright] => Copyright © Massachusetts Institute of Technology, 2025. All rights reserved. [author] => MIT Sloan Management Review ) [main_site_url] => http://sloanreview.mit.edu [license_agreement_pdf_url] => /pdf/MgmtReportLicensingAgreement.pdf [permission_to_copy_min_qty] => 5 [adminbghex] => #c9c9c9 [adminfghex] => #e9e9e9 [adminac1hex] => #a9a9a9 [default_product_thumbnail] => /assets/images/MITSMR_cover.jpg [default_product_cover] => /assets/images/MITSMR_cover.jpg [sendgrid_api_key] => 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 )
template	Array ( [default_layout] => layouts/application [enable_view_path_comment] => 1 )
sfg	Array ( [debug] => 0 [log] => 1 [notify] => 1 [timeout] => 10 [test_mode] => [remote_host] => api.sfgnetwork.com [remote_port] => 443 [remote_uri] => /websvcapps/services/https/process_xmlrpc.php [remote_method] => process_xmlrpc [services] => Array ( [ecommerce_order] => Array ( [user] => 122f2eb252faa4e4b86193e483bd2b52 [pass] => 21598fa307e843648856f0c3f41bfbc5 ) [product_status] => Array ( [user] => 1ec0e02302ef35e38fb75f6d13670357 [pass] => 36375bce7741df326faec39f71240d5e ) ) )