Gillroy's Udder Cream:

Click here for 132 Items ON SALE

Browse What We Got!

Brands That We Got!

Shop by Brand


Search What We Got!

Enter a keyword to search

How To Do It!

Faucet: Leaks Water

More DIY Projects...

Gillroys Newsletter Signup

Home > Farm & Ranch > Udder Cream

Page 1 of 0 | Pages:

Department: Udder Cream

There are 0 items in this department

Page 1 of 0 | Pages:

Email this page to a friend


	Home	Customer Care	Newsletter	About Us	UPS Order Tracking	Shopping Cart

Gillroy's Udder Cream:

Building Materials

Ceiling Tile & Grids : Dowel Rods : Driveway Coatings & Concrete Sealants : Insulation & House Wrap : Kids Build it Yourself Kits : Mortar & Cement : Plastic Sheeting & Vapor Barriers : More...

Electrical

Antenna Wire & Fittings : Connectors : Doorbells & Push Buttons : Electrical Boxes & Connectors : Electrical Conduit : Electrical Tape : Electrical Tools : Extension Cord Holders : Extension Cords : Ground Rods : More...

Hand Tools

Axes & hatchets : Bolt taps and dies : Buffing wheels and compound : Carpet stretchers and linoleum rollers : Chisels : Drywall tools : Files and rasps : Gear puller : Hand Drills : Jointers & Rakers : More...

Hardware

Cabinet hardware : Door Hardware : Door Springs : Hinges : Metal Sheets : More...

Housewares

Curtain Rods and accessories : Vacuums & Accessories : More...

Lawn and Garden

Fencing & Gates : Flags & Flag Pole Accessories : Lawn Ornaments : More...

Paint and Supplies

Adhesives & Caulk : Patching & Drywall Compound : Stencils - Letters & Numbers : Wood Filler & Putty : More...

Plumbing

Boiler Drains : Copper Fittings : Drain Fittings : Garbage Disposers : Septic Tank Product : Washing Machine Outlet Boxes : Washing Machine Valves : Water Heaters : Water Meters : Water Softener & Filters : More...

Power Tools

Air Compressors & Air Tools : Battery Packs & Chargers : Bench Grinders : Cordless Tool Combos : Cords : Drill Presses : Generators : Grinders & Sanders : Grinding Wheels & Stones : Propane Torches & Accessories : More...

Website hosted and developed by

Debugging Information

ColdFusion Server Standard	7,0,2,142559
Template	/products/show_dept_prods2.cfm
Time Stamp	02-Dec-08 04:22 AM
Locale	English (US)
User Agent	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP	38.103.63.55
Host Name	38.103.63.55

Execution Time

Total Time	Avg Time	Count	Template
3040 ms	3040 ms	1	/home/gilluser/public_html/products/farm_ranch/products/show_dept_prods2.cfm
2706 ms	2706 ms	1	/home/gilluser/public_html/common/masterfooter.cfm
2696 ms	300 ms	9	/home/gilluser/public_html/inc_subsubdept_list.cfm
2538 ms	42 ms	61	/home/gilluser/public_html/products/dept_url.cfm
38 ms	38 ms	1	/home/gilluser/public_html/common/masterheader.cfm
36 ms	36 ms	1	/home/gilluser/public_html/common/sidenav.cfm
3 ms	3 ms	1	/home/gilluser/public_html/products/farm_ranch/products/Application.cfm
2 ms	2 ms	1	/home/gilluser/public_html/Application.cfm
0 ms	0 ms	1	/home/gilluser/public_html/common/copyright.cfm
0 ms	0 ms	1	/home/gilluser/public_html/common/language_english.cfm
3 ms			STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
3046 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

SQL Queries

parent (Datasource=gillroys, Time=118ms, Records=1) in /home/gilluser/public_html/products/farm_ranch/products/show_dept_prods2.cfm @ 04:22:42.042

 
		select * from dept where dept_id = 66938

dept_prods (Datasource=gillroys, Time=173ms, Records=0) in /home/gilluser/public_html/products/farm_ranch/products/show_dept_prods2.cfm @ 04:22:43.043

 
			SELECT p.vendor, p.desc24mf, p.vendornum, p2.sku, p2.name, p.image_file, p.image_height, p.image_width, p.mfg, p.mfgnum, p.mult, p.uofm, p.short_desc, p.description, p.mfgnum, pp.*, pc.*, COUNT(pc.sku) AS skucount, d.*, pd.*
				FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
				WHERE pd.dept_id = 66938 AND pp.web='y'
				
				GROUP BY pc.super_id
				ORDER BY p2.vendor, p.mfgnum

getsaleitems_sn (Datasource=gillroys, Time=1ms, Records=132, Cached Query) in /home/gilluser/public_html/common/sidenav.cfm @ 04:22:43.043

	SELECT p.sku, p.name, p.description, p.vendor, p.desc24mf, p.image_file, p.image_width, p.image_height, p.mfg, p.mult, p.uofm, pp.*, pc.* 
		FROM ((((product p INNER JOIN product_price pp ON p.sku=pp.sku) INNER JOIN parent_child pc ON p.sku=pc.sku) INNER JOIN product_dept pd ON p.sku=pd.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id
	 WHERE pp.web="y" AND now()>=pp.sale_start AND now()<=pp.sale_end 
	  AND pp.sale_price < pp.list_price 
GROUP BY pc.super_id
ORDER BY pp.sale_price

dept (Datasource=gillroys, Time=9ms, Records=26) in /home/gilluser/public_html/common/sidenav.cfm @ 04:22:43.043

	SELECT *
		FROM navigation_gillroys
	 WHERE subdept = 0 OR dept_id =5
	ORDER BY deptname

bsbrands (Datasource=gillroys, Time=0ms, Records=20, Cached Query) in /home/gilluser/public_html/common/sidenav.cfm @ 04:22:43.043

	SELECT bs.*, p.mfg, p.vendornum, p.vendor, p.mfgnum 
		FROM product p inner join product_bestseller bs on p.sku=bs.sku 
ORDER BY bs.rank 
	 LIMIT 20

get_howto (Datasource=gillroys, Time=23ms, Records=1) in /home/gilluser/public_html/common/sidenav.cfm @ 04:22:43.043

		SELECT b.*, i.*, c.* 
			FROM (howto_body b INNER JOIN howto_cat_index i ON b.id=i.id) INNER JOIN howto_cat c ON i.cat=c.id  
		 WHERE (b.id=102 AND i.cat=100)
		 		OR (b.id=202 AND i.cat=200) 
				OR (b.id=302 AND i.cat=300) 
				OR (b.id=402 AND i.cat=400)
				OR (b.id=502 AND i.cat=500) 
				OR (b.id=602 AND i.cat=600) 
				OR (b.id=702 AND i.cat=700) 
				OR (b.id=802 AND i.cat=800)

get_nav (Datasource=gillroys, Time=1ms, Records=9, Cached Query) in /home/gilluser/public_html/common/masterfooter.cfm @ 04:22:43.043

				SELECT *
				FROM navigation_gillroys
				WHERE home_subdept = 1
				ORDER BY deptname

get_sub_dept (Datasource=gillroys, Time=17ms, Records=22) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66787
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=7, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66863,66867,66852,66851,66856,70964,66866,66850,66849,73735,66857,66864,74763,66854,66853,66855,66865,66859,77847,66861,66860,70972)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=23ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=17ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=26ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=40ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=49ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=139ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

gettopdept (Datasource=gillroys, Time=4ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66787

geturl (Datasource=gillroys, Time=90ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66787

get_sub_dept (Datasource=gillroys, Time=1ms, Records=17) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66784
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=10, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66821,66810,66814,66816,66813,66818,66826,66815,66812,66825,77838,77139,66817,66819,66823,66824,66820)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=4ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=52ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=11ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=19ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66784

geturl (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66784

get_sub_dept (Datasource=gillroys, Time=2ms, Records=51) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66797
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=10, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66997,66975,66974,67013,67018,67014,66976,67005,66998,67007,67021,67003,76322,67006,67008,66980,76324,66991,67002,76323,66987,66986,66981,67001,66982,67019,67009,66992,66984,66979,66989,66993,67016,66994,67017,66996,70884,67010,66983,66915,67011,70927,67020,66990,66977,67004,66978,66985,66988,67000,66995)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=13ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=32ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=49ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66797

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66797

get_sub_dept (Datasource=gillroys, Time=1ms, Records=14) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66798
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=5, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:43.043

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (67028,67027,67032,67033,67029,67034,67025,67024,67023,67022,67031,67026,74401,67030)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798

geturl (Datasource=gillroys, Time=27ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798

gettopdept (Datasource=gillroys, Time=32ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:43.043

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798

geturl (Datasource=gillroys, Time=28ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798

gettopdept (Datasource=gillroys, Time=21ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66798

geturl (Datasource=gillroys, Time=10ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66798

get_sub_dept (Datasource=gillroys, Time=3ms, Records=22) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 70812
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=2, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (73430,73262,67142,67125,67895,67143,67135,67132,70933,67131,67137,67139,67140,67128,67134,67138,67146,67144,67136,67147,67133,67141)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=29ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 70812

geturl (Datasource=gillroys, Time=22ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 70812

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 70812

geturl (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 70812

get_sub_dept (Datasource=gillroys, Time=2ms, Records=24) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66792
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=3, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (66931,67126,73985,66937,77906,66926,66920,66919,66936,66917,66927,66929,67433,66923,66933,66921,66928,77843,66924,77891,66934,66925,74397,66932)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792

geturl (Datasource=gillroys, Time=10ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792

gettopdept (Datasource=gillroys, Time=4ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792

geturl (Datasource=gillroys, Time=67ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66792

geturl (Datasource=gillroys, Time=69ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66792

get_sub_dept (Datasource=gillroys, Time=20ms, Records=23) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66808
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=4, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (67197,67206,67205,67993,67202,74609,67199,70922,76576,67200,76101,67966,67207,67963,67204,74329,67208,67969,76104,67201,67203,67198,66868)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808

geturl (Datasource=gillroys, Time=82ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808

gettopdept (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808

geturl (Datasource=gillroys, Time=10ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66808

geturl (Datasource=gillroys, Time=35ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66808

get_sub_dept (Datasource=gillroys, Time=13ms, Records=20) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66796
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=10, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:44.044

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (77945,66964,66972,67584,66966,67529,66967,77942,66971,66963,66973,66969,76144,66970,66965,77949,66961,67530,66968,67531)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=49ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=52ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=29ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=26ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=7ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=54ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=12ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=9ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=74ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=81ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=12ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=34ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=10ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:44.044

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=31ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

gettopdept (Datasource=gillroys, Time=5ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66796

geturl (Datasource=gillroys, Time=51ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66796

get_sub_dept (Datasource=gillroys, Time=14ms, Records=22) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:45.045

	SELECT dept_id
		FROM dept 
	 WHERE parent_id = 66805
		 AND dept_display = 1
ORDER BY dept_name

GetDepts (Datasource=gillroys, Time=0ms, Records=10, Cached Query) in /home/gilluser/public_html/inc_subsubdept_list.cfm @ 04:22:45.045

	SELECT DISTINCT d.*
		FROM ((((parent_child pc INNER JOIN product_dept pd ON pc.sku=pd.sku) INNER JOIN product_price pp ON pc.sku=pp.sku) INNER JOIN product p ON pc.sku=p.sku) INNER JOIN dept d ON pd.dept_id=d.dept_id) INNER JOIN product p2 ON p2.sku = pc.super_id 
	WHERE pd.dept_id IN (73884,67166,67151,74037,76561,67165,67163,66930,67162,67158,73878,73796,67159,67161,67150,73952,76087,73882,67852,74032,76568,74044)
		AND pp.web = 'y'
	GROUP BY pc.super_id
	ORDER by dept_name
	LIMIT 10

gettopdept (Datasource=gillroys, Time=37ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=42ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=3ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=74ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=4ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=118ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=14ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=80ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=32ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=41ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=69ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=6ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=2ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=8ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

gettopdept (Datasource=gillroys, Time=4ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT dept_name, dept_id
		FROM dept
		WHERE dept_id = 66805

geturl (Datasource=gillroys, Time=71ms, Records=1) in /home/gilluser/public_html/products/dept_url.cfm @ 04:22:45.045

		SELECT *
		FROM navigation_gillroys
		WHERE dept_id = 66805

Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/gilluser/public_html/products/farm_ranch/products/show_dept_prods2.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=farm-ranch.gillroys.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/gilluser/public_html/products/farm_ranch/products/show_dept_prods2.cfm
QUERY_STRING=dept_id=66938
REMOTE_ADDR=38.103.63.55
REMOTE_HOST=38.103.63.55
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/products/show_dept_prods2.cfm
SERVER_NAME=farm-ranch.gillroys.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Client Variables:
cfid=8543667
cftoken=92910568
hitcount=1
lastvisit={ts '2008-12-02 04:22:42'}
timecreated={ts '2008-12-02 04:22:42'}
urltoken=CFID=8543667&CFTOKEN=92910568

Cookie Variables:
CFID=8543667
CFTOKEN=92910568
LANGUAGE=english

Session Variables:
cfid=8543667
cftoken=92910568
sessionid=GILLROYS_8543667_92910568
urltoken=CFID=8543667&CFTOKEN=92910568

URL Parameters:
DEPT_ID=66938

Debug Rendering Time: 84 ms