Instone | Metal Lath

Notice (8): Undefined index: store_id [APP/controllers/categories_controller.php, line 60]

        $this->Product->recursive = -1;

        $product = $this->Product->find('all', array('conditions' => array('Product.category_id' => $id,'Product.status'=>'1','Product.store_id'=> $categoryname['Category']['store_id']),'fields'=>array('Product.id','Product.name','Product.product_main_image'), 'order'=>array('Product.name'=>'asc')));

$zone_name	=	"NE"
$id	=	"93"
$categoryname	=	array(
	"Category" => array(
	"id" => "93",
	"name" => "Metal Lath",
	"image" => "MetalLath.jpg",
	"description" => "Instone distribute a full line of self furring metal lath products. 
"
),
	"Product" => array(
	array(),
	array()
),
	"Catalog" => array(),
	"Installation" => array()
)
$catname	=	"Metal Lath"

CategoriesController::index() - APP/controllers/categories_controller.php, line 60
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

PO Box 36, 1 Red Valley Road Millstone Twp., New Jersey 08510 (800) 867-0922 | © Instone 2011 | Sitemap | info@instoneco.com |

Notice (8): Undefined index:  id [APP/views/elements/footer_main.ctp, line 6]Code | Context<div style="width:900px; margin:auto">

    PO Box 36, 1 Red Valley Road Millstone Twp., New Jersey 08510 (800) 867-0922 | &copy; Instone 2011 | <a href="<?php echo $html->url(array('controller' => 'sitemap', 'action' => 'index',$zone_code)); ?>">Sitemap</a> | <a href="mailto:info@instoneco.com">info@instoneco.com</a> |

      <?php if(!isset($_SESSION['id']) && $_SESSION['id']==''){ ?>
$___viewFn	=	"/home/content/33/7424733/html/app/views/elements/footer_main.ctp"
$___dataForView	=	array(
	"categoryname" => array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	"product" => array(),
	"title" => "Instone | Metal Lath",
	"model_label" => "Product",
	"product_label" => "Product Model",
	"headergallerycategory" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"headercategory" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"storearr" => array(
	"Chicago",
	"New Jersey",
	"Virginia",
	"Connecticut"
),
	"session" => SessionHelper
SessionHelper::$helpers = array
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "8de6c3618a7ea4e56b37d98cceee9868"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1337348793
SessionHelper::$sessionTime = 1337360793
SessionHelper::$cookieLifeTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$host = NULL
SessionHelper::$timeout = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/categories/index/NE/93"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$theme = NULL
SessionHelper::$plugin = NULL,
	"javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$theme = NULL
JavascriptHelper::$here = "/categories/index/NE/93"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL,
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$_crumbs = array
HtmlHelper::$__includedScripts = array
HtmlHelper::$_scriptBlockOptions = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$base = ""
HtmlHelper::$webroot = "/"
HtmlHelper::$theme = NULL
HtmlHelper::$here = "/categories/index/NE/93"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
HtmlHelper::$plugin = NULL
HtmlHelper::$data = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$defaultModel = NULL
FormHelper::$_inputDefaults = array
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$theme = NULL
FormHelper::$here = "/categories/index/NE/93"
FormHelper::$params = array
FormHelper::$action = "index"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$Html = HtmlHelper object
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$categoryname	=	array(
	"Category" => array(
	"id" => "93",
	"name" => "Metal Lath",
	"image" => "MetalLath.jpg",
	"description" => "Instone distribute a full line of self furring metal lath products. 
"
),
	"Product" => array(
	array(),
	array()
),
	"Catalog" => array(),
	"Installation" => array()
)
$product	=	array()
$title	=	"Instone | Metal Lath"
$model_label	=	"Product"
$product_label	=	"Product Model"
$headergallerycategory	=	array(
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
),
	array(
	"GalleryCategory" => array(),
	"Gallery" => array()
)
)
$headercategory	=	array(
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
),
	array(
	"Category" => array(),
	"Product" => array(),
	"Catalog" => array(),
	"Installation" => array()
)
)
$storearr	=	array(
	"Chicago",
	"New Jersey",
	"Virginia",
	"Connecticut"
)
$session	=	SessionHelper
SessionHelper::$helpers = array
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "8de6c3618a7ea4e56b37d98cceee9868"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "medium"
SessionHelper::$time = 1337348793
SessionHelper::$sessionTime = 1337360793
SessionHelper::$cookieLifeTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$host = NULL
SessionHelper::$timeout = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/categories/index/NE/93"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$theme = NULL
SessionHelper::$plugin = NULL
$javascript	=	JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$theme = NULL
JavascriptHelper::$here = "/categories/index/NE/93"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$_crumbs = array
HtmlHelper::$__includedScripts = array
HtmlHelper::$_scriptBlockOptions = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$base = ""
HtmlHelper::$webroot = "/"
HtmlHelper::$theme = NULL
HtmlHelper::$here = "/categories/index/NE/93"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
HtmlHelper::$plugin = NULL
HtmlHelper::$data = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$defaultModel = NULL
FormHelper::$_inputDefaults = array
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$theme = NULL
FormHelper::$here = "/categories/index/NE/93"
FormHelper::$params = array
FormHelper::$action = "index"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$Html = HtmlHelper object
$zone_code	=	"NE"
include - APP/views/elements/footer_main.ctp, line 6
View::_render() - CORE/cake/libs/view/view.php, line 724
View::element() - CORE/cake/libs/view/view.php, line 385
include - APP/views/layouts/default.ctp, line 92
View::_render() - CORE/cake/libs/view/view.php, line 724
View::renderLayout() - CORE/cake/libs/view/view.php, line 482
View::render() - CORE/cake/libs/view/view.php, line 428
Controller::render() - CORE/cake/libs/controller/controller.php, line 913
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

(default) 46 queries took 75 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `categories`	12	12	3
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	1
3	SHOW FULL COLUMNS FROM `stores`	8	8	2
4	SHOW FULL COLUMNS FROM `zones`	3	3	1
5	SHOW FULL COLUMNS FROM `contents`	11	11	2
6	SHOW FULL COLUMNS FROM `drawings`	14	14	2
7	SHOW FULL COLUMNS FROM `drawing_categories`	4	4	1
8	SHOW FULL COLUMNS FROM `brand_studies`	10	10	2
9	SHOW FULL COLUMNS FROM `technical_datas`	10	10	2
10	SHOW FULL COLUMNS FROM `catalogs`	12	12	2
11	SHOW FULL COLUMNS FROM `installations`	11	11	1
12	SHOW FULL COLUMNS FROM `galleries`	8	8	1
13	SHOW FULL COLUMNS FROM `gallery_categories`	4	4	2
14	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';	1	1	1
15	SHOW FULL COLUMNS FROM `home_images`	6	6	1
16	SHOW FULL COLUMNS FROM `products`	25	25	2
17	SHOW FULL COLUMNS FROM `product_colors`	4	4	1
18	SHOW FULL COLUMNS FROM `productmodels`	19	19	2
19	SHOW FULL COLUMNS FROM `dealer_basket`	7	7	2
20	SHOW FULL COLUMNS FROM `orders_products`	5	5	1
21	SHOW FULL COLUMNS FROM `orders`	27	27	2
22	SHOW FULL COLUMNS FROM `dealers`	90	90	3
23	SHOW FULL COLUMNS FROM `installers`	91	91	3
24	SELECT `Store`.`id`, `Store`.`name` FROM `stores` AS `Store` WHERE `Store`.`delete` = 'N' AND `Store`.`status` = 1	4	4	0
25	SELECT `Zone`.`id`, `Zone`.`zone_name`, `Zone`.`zone_caption` FROM `zones` AS `Zone` WHERE `Zone`.`zone_name` = 'NE' LIMIT 1	1	1	1
26	SELECT `Store`.`id`, `Store`.`name`, `Store`.`state_code`, `Store`.`zone_id`, `Store`.`status`, `Store`.`delete`, `Store`.`created`, `Store`.`modified` FROM `stores` AS `Store` WHERE `Store`.`zone_id` = 2 AND `Store`.`delete` = 'N'	3	3	1
27	SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`store_id` = 2 AND `Category`.`status` = 1 ORDER BY `Category`.`order_no` asc, `Category`.`name` asc	14	14	0
28	SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`store_id`, `Product`.`sku`, `Product`.`name`, `Product`.`description`, `Product`.`weight`, `Product`.`sale_product`, `Product`.`stock`, `Product`.`status`, `Product`.`special`, `Product`.`featured`, `Product`.`sort_order`, `Product`.`tax_exempt`, `Product`.`allow_review`, `Product`.`price`, `Product`.`types`, `Product`.`product_main_image`, `Product`.`shot1`, `Product`.`shot2`, `Product`.`shot3`, `Product`.`shot4`, `Product`.`shot5`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)	149	149	11
29	SELECT `Catalog`.`id`, `Catalog`.`store_id`, `Catalog`.`zone_id`, `Catalog`.`category_id`, `Catalog`.`name`, `Catalog`.`upload_file`, `Catalog`.`upload_image`, `Catalog`.`status`, `Catalog`.`delete`, `Catalog`.`sort_id`, `Catalog`.`created`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE `Catalog`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157) ORDER BY `Catalog`.`name` ASC	30	30	1
30	SELECT `Installation`.`id`, `Installation`.`store_id`, `Installation`.`zone_id`, `Installation`.`category_id`, `Installation`.`name`, `Installation`.`upload_file`, `Installation`.`upload_image`, `Installation`.`status`, `Installation`.`delete`, `Installation`.`created`, `Installation`.`modified` FROM `installations` AS `Installation` WHERE `Installation`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)	16	16	1
31	SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`store_id` = 2 AND `Category`.`status` = 1 ORDER BY `Category`.`order_no` asc, `Category`.`name` asc	14	14	0
32	SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`store_id`, `Product`.`sku`, `Product`.`name`, `Product`.`description`, `Product`.`weight`, `Product`.`sale_product`, `Product`.`stock`, `Product`.`status`, `Product`.`special`, `Product`.`featured`, `Product`.`sort_order`, `Product`.`tax_exempt`, `Product`.`allow_review`, `Product`.`price`, `Product`.`types`, `Product`.`product_main_image`, `Product`.`shot1`, `Product`.`shot2`, `Product`.`shot3`, `Product`.`shot4`, `Product`.`shot5`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)	149	149	6
33	SELECT `Catalog`.`id`, `Catalog`.`store_id`, `Catalog`.`zone_id`, `Catalog`.`category_id`, `Catalog`.`name`, `Catalog`.`upload_file`, `Catalog`.`upload_image`, `Catalog`.`status`, `Catalog`.`delete`, `Catalog`.`sort_id`, `Catalog`.`created`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE `Catalog`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157) ORDER BY `Catalog`.`name` ASC	30	30	1
34	SELECT `Installation`.`id`, `Installation`.`store_id`, `Installation`.`zone_id`, `Installation`.`category_id`, `Installation`.`name`, `Installation`.`upload_file`, `Installation`.`upload_image`, `Installation`.`status`, `Installation`.`delete`, `Installation`.`created`, `Installation`.`modified` FROM `installations` AS `Installation` WHERE `Installation`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)	16	16	0
35	SELECT `Category`.`name`, `Category`.`id` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`store_id` != 2 AND `Category`.`name` NOT IN ('Cultured Stone','ProStone','Semco Natural Stone Thin Veneer','Buechel Natural Stone','Versetta Stone','Stone Transitions Stone Trim & Hearthstone','Isokern Modular Fireplace Systems','ArcCast','Masonry Chemicals & Mortar Coloring','SpiderLath','AMICO Self Furring Metal Lath','Drainage & Moisture Control, Flashing Products','Foundation & Brick Vents','Architectural Stone Trim by Cultured Stone','Architectural Stone Trim by Cultured Stone') AND `Category`.`status` = 1 GROUP BY `Category`.`name` ORDER BY `Category`.`order_no` asc, `Category`.`name` asc	0	0	1
36	SELECT `GalleryCategory`.`id`, `GalleryCategory`.`name` FROM `gallery_categories` AS `GalleryCategory` WHERE `GalleryCategory`.`status` = 1 AND `GalleryCategory`.`delete` = 'N' ORDER BY `GalleryCategory`.`name` ASC	10	10	0
37	SELECT `Gallery`.`id`, `Gallery`.`gallery_category_id`, `Gallery`.`image_name`, `Gallery`.`store_id`, `Gallery`.`zone_id`, `Gallery`.`image_category`, `Gallery`.`status`, `Gallery`.`is_delete` FROM `galleries` AS `Gallery` WHERE `Gallery`.`gallery_category_id` IN (17, 18, 14, 1, 16, 3, 15, 4, 2, 5)	130	130	1
38	SHOW FULL COLUMNS FROM `directors`	10	10	2
39	SHOW FULL COLUMNS FROM `privileges`	2	2	1
40	SHOW FULL COLUMNS FROM `customer_details`	42	42	2
41	SELECT `Director`.`id`, `Director`.`username`, `Director`.`password`, `Director`.`hidpass`, `Director`.`name`, `Director`.`email`, `Director`.`privilege_id`, `Director`.`status`, `Director`.`created`, `Director`.`modified`, `Privilege`.`id`, `Privilege`.`name`, `CustomerDetail`.`id`, `CustomerDetail`.`director_id`, `CustomerDetail`.`status`, `CustomerDetail`.`company`, `CustomerDetail`.`phone`, `CustomerDetail`.`fax`, `CustomerDetail`.`newsletter`, `CustomerDetail`.`terms`, `CustomerDetail`.`sales`, `CustomerDetail`.`establish_date`, `CustomerDetail`.`sales_dollar`, `CustomerDetail`.`year`, `CustomerDetail`.`weburl`, `CustomerDetail`.`decision_contactname`, `CustomerDetail`.`decision_title`, `CustomerDetail`.`office_address`, `CustomerDetail`.`office_city`, `CustomerDetail`.`office_state_code`, `CustomerDetail`.`office_zip`, `CustomerDetail`.`office_phone`, `CustomerDetail`.`office_cell`, `CustomerDetail`.`office_email`, `CustomerDetail`.`account_contactname`, `CustomerDetail`.`account_phone`, `CustomerDetail`.`account_fax`, `CustomerDetail`.`account_email`, `CustomerDetail`.`other_business`, `CustomerDetail`.`yr_business`, `CustomerDetail`.`total_revenue`, `CustomerDetail`.`no_employee`, `CustomerDetail`.`sqft`, `CustomerDetail`.`no_outside_rep`, `CustomerDetail`.`inside_rep`, `CustomerDetail`.`sales_tax`, `CustomerDetail`.`personal_guarantee`, `CustomerDetail`.`credit_status`, `CustomerDetail`.`marketing_aggressive`, `CustomerDetail`.`marketing_little`, `CustomerDetail`.`marketing_none`, `CustomerDetail`.`delete`, `CustomerDetail`.`created`, `CustomerDetail`.`modified` FROM `directors` AS `Director` LEFT JOIN `privileges` AS `Privilege` ON (`Director`.`privilege_id` = `Privilege`.`id`) LEFT JOIN `customer_details` AS `CustomerDetail` ON (`CustomerDetail`.`director_id` = `Director`.`id`) WHERE `Director`.`id` IS NULL LIMIT 1	0	0	1
42	SELECT `Category`.`id`, `Category`.`name`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`id` = 93 LIMIT 1	1	1	1
43	SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`store_id`, `Product`.`sku`, `Product`.`name`, `Product`.`description`, `Product`.`weight`, `Product`.`sale_product`, `Product`.`stock`, `Product`.`status`, `Product`.`special`, `Product`.`featured`, `Product`.`sort_order`, `Product`.`tax_exempt`, `Product`.`allow_review`, `Product`.`price`, `Product`.`types`, `Product`.`product_main_image`, `Product`.`shot1`, `Product`.`shot2`, `Product`.`shot3`, `Product`.`shot4`, `Product`.`shot5`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`category_id` = (93)	2	2	1
44	SELECT `Catalog`.`id`, `Catalog`.`store_id`, `Catalog`.`zone_id`, `Catalog`.`category_id`, `Catalog`.`name`, `Catalog`.`upload_file`, `Catalog`.`upload_image`, `Catalog`.`status`, `Catalog`.`delete`, `Catalog`.`sort_id`, `Catalog`.`created`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE `Catalog`.`category_id` = (93) ORDER BY `Catalog`.`name` ASC	0	0	0
45	SELECT `Installation`.`id`, `Installation`.`store_id`, `Installation`.`zone_id`, `Installation`.`category_id`, `Installation`.`name`, `Installation`.`upload_file`, `Installation`.`upload_image`, `Installation`.`status`, `Installation`.`delete`, `Installation`.`created`, `Installation`.`modified` FROM `installations` AS `Installation` WHERE `Installation`.`category_id` = (93)	0	0	2
46	SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_main_image` FROM `products` AS `Product` WHERE `Product`.`category_id` = 93 AND `Product`.`status` = 1 AND `Product`.`store_id` IS NULL ORDER BY `Product`.`name` asc	0	0	1

(default) 46 queries took 75 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `categories`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SHOW FULL COLUMNS FROM `stores`

SHOW FULL COLUMNS FROM `zones`

SHOW FULL COLUMNS FROM `contents`

SHOW FULL COLUMNS FROM `drawings`

SHOW FULL COLUMNS FROM `drawing_categories`

SHOW FULL COLUMNS FROM `brand_studies`

SHOW FULL COLUMNS FROM `technical_datas`

SHOW FULL COLUMNS FROM `catalogs`

SHOW FULL COLUMNS FROM `installations`

SHOW FULL COLUMNS FROM `galleries`

SHOW FULL COLUMNS FROM `gallery_categories`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';

SHOW FULL COLUMNS FROM `home_images`

SHOW FULL COLUMNS FROM `products`

SHOW FULL COLUMNS FROM `product_colors`

SHOW FULL COLUMNS FROM `productmodels`

SHOW FULL COLUMNS FROM `dealer_basket`

SHOW FULL COLUMNS FROM `orders_products`

SHOW FULL COLUMNS FROM `orders`

SHOW FULL COLUMNS FROM `dealers`

SHOW FULL COLUMNS FROM `installers`

SELECT `Store`.`id`, `Store`.`name` FROM `stores` AS `Store` WHERE `Store`.`delete` = 'N' AND `Store`.`status` = 1

SELECT `Zone`.`id`, `Zone`.`zone_name`, `Zone`.`zone_caption` FROM `zones` AS `Zone` WHERE `Zone`.`zone_name` = 'NE' LIMIT 1

SELECT `Store`.`id`, `Store`.`name`, `Store`.`state_code`, `Store`.`zone_id`, `Store`.`status`, `Store`.`delete`, `Store`.`created`, `Store`.`modified` FROM `stores` AS `Store` WHERE `Store`.`zone_id` = 2 AND `Store`.`delete` = 'N'

SELECT `Category`.`id`, `Category`.`name` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`store_id` = 2 AND `Category`.`status` = 1 ORDER BY `Category`.`order_no` asc, `Category`.`name` asc

SELECT `Product`.`id`, `Product`.`category_id`, `Product`.`store_id`, `Product`.`sku`, `Product`.`name`, `Product`.`description`, `Product`.`weight`, `Product`.`sale_product`, `Product`.`stock`, `Product`.`status`, `Product`.`special`, `Product`.`featured`, `Product`.`sort_order`, `Product`.`tax_exempt`, `Product`.`allow_review`, `Product`.`price`, `Product`.`types`, `Product`.`product_main_image`, `Product`.`shot1`, `Product`.`shot2`, `Product`.`shot3`, `Product`.`shot4`, `Product`.`shot5`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)

149

SELECT `Catalog`.`id`, `Catalog`.`store_id`, `Catalog`.`zone_id`, `Catalog`.`category_id`, `Catalog`.`name`, `Catalog`.`upload_file`, `Catalog`.`upload_image`, `Catalog`.`status`, `Catalog`.`delete`, `Catalog`.`sort_id`, `Catalog`.`created`, `Catalog`.`modified` FROM `catalogs` AS `Catalog` WHERE `Catalog`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157) ORDER BY `Catalog`.`name` ASC

SELECT `Installation`.`id`, `Installation`.`store_id`, `Installation`.`zone_id`, `Installation`.`category_id`, `Installation`.`name`, `Installation`.`upload_file`, `Installation`.`upload_image`, `Installation`.`status`, `Installation`.`delete`, `Installation`.`created`, `Installation`.`modified` FROM `installations` AS `Installation` WHERE `Installation`.`category_id` IN (38, 13, 125, 161, 58, 126, 46, 22, 47, 21, 45, 48, 49, 157)

149

SELECT `Category`.`name`, `Category`.`id` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`store_id` != 2 AND `Category`.`name` NOT IN ('Cultured Stone','ProStone','Semco Natural Stone Thin Veneer','Buechel Natural Stone','Versetta Stone','Stone Transitions Stone Trim & Hearthstone','Isokern Modular Fireplace Systems','ArcCast','Masonry Chemicals & Mortar Coloring','SpiderLath','AMICO Self Furring Metal Lath','Drainage & Moisture Control, Flashing Products','Foundation & Brick Vents','Architectural Stone Trim by Cultured Stone','Architectural Stone Trim by Cultured Stone') AND `Category`.`status` = 1 GROUP BY `Category`.`name` ORDER BY `Category`.`order_no` asc, `Category`.`name` asc

SELECT `GalleryCategory`.`id`, `GalleryCategory`.`name` FROM `gallery_categories` AS `GalleryCategory` WHERE `GalleryCategory`.`status` = 1 AND `GalleryCategory`.`delete` = 'N' ORDER BY `GalleryCategory`.`name` ASC

SELECT `Gallery`.`id`, `Gallery`.`gallery_category_id`, `Gallery`.`image_name`, `Gallery`.`store_id`, `Gallery`.`zone_id`, `Gallery`.`image_category`, `Gallery`.`status`, `Gallery`.`is_delete` FROM `galleries` AS `Gallery` WHERE `Gallery`.`gallery_category_id` IN (17, 18, 14, 1, 16, 3, 15, 4, 2, 5)

130

SHOW FULL COLUMNS FROM `directors`

SHOW FULL COLUMNS FROM `privileges`

SHOW FULL COLUMNS FROM `customer_details`

SELECT `Director`.`id`, `Director`.`username`, `Director`.`password`, `Director`.`hidpass`, `Director`.`name`, `Director`.`email`, `Director`.`privilege_id`, `Director`.`status`, `Director`.`created`, `Director`.`modified`, `Privilege`.`id`, `Privilege`.`name`, `CustomerDetail`.`id`, `CustomerDetail`.`director_id`, `CustomerDetail`.`status`, `CustomerDetail`.`company`, `CustomerDetail`.`phone`, `CustomerDetail`.`fax`, `CustomerDetail`.`newsletter`, `CustomerDetail`.`terms`, `CustomerDetail`.`sales`, `CustomerDetail`.`establish_date`, `CustomerDetail`.`sales_dollar`, `CustomerDetail`.`year`, `CustomerDetail`.`weburl`, `CustomerDetail`.`decision_contactname`, `CustomerDetail`.`decision_title`, `CustomerDetail`.`office_address`, `CustomerDetail`.`office_city`, `CustomerDetail`.`office_state_code`, `CustomerDetail`.`office_zip`, `CustomerDetail`.`office_phone`, `CustomerDetail`.`office_cell`, `CustomerDetail`.`office_email`, `CustomerDetail`.`account_contactname`, `CustomerDetail`.`account_phone`, `CustomerDetail`.`account_fax`, `CustomerDetail`.`account_email`, `CustomerDetail`.`other_business`, `CustomerDetail`.`yr_business`, `CustomerDetail`.`total_revenue`, `CustomerDetail`.`no_employee`, `CustomerDetail`.`sqft`, `CustomerDetail`.`no_outside_rep`, `CustomerDetail`.`inside_rep`, `CustomerDetail`.`sales_tax`, `CustomerDetail`.`personal_guarantee`, `CustomerDetail`.`credit_status`, `CustomerDetail`.`marketing_aggressive`, `CustomerDetail`.`marketing_little`, `CustomerDetail`.`marketing_none`, `CustomerDetail`.`delete`, `CustomerDetail`.`created`, `CustomerDetail`.`modified` FROM `directors` AS `Director` LEFT JOIN `privileges` AS `Privilege` ON (`Director`.`privilege_id` = `Privilege`.`id`) LEFT JOIN `customer_details` AS `CustomerDetail` ON (`CustomerDetail`.`director_id` = `Director`.`id`) WHERE `Director`.`id` IS NULL LIMIT 1

SELECT `Category`.`id`, `Category`.`name`, `Category`.`image`, `Category`.`description` FROM `categories` AS `Category` LEFT JOIN `stores` AS `Store` ON (`Category`.`store_id` = `Store`.`id`) WHERE `Category`.`id` = 93 LIMIT 1

SELECT `Product`.`id`, `Product`.`name`, `Product`.`product_main_image` FROM `products` AS `Product` WHERE `Product`.`category_id` = 93 AND `Product`.`status` = 1 AND `Product`.`store_id` IS NULL ORDER BY `Product`.`name` asc