DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com | Browsing Daily Deals

Daily Deals / All
101 deals found

Wednesday, September 8, 2010 by Buy

Compare

Daily Deals / Computers and Electronics

IOGEAR GUH227 7-Port High Speed USB 2.0 Hub - Compatible wit...

IOGEAR's 7-port USB 2.0 hub provides 7 Hi-Speed USB 2.0 ports for your high-speed connectivity needs. This device is fully compliant to USB 2.0 specifications and provides a data transfer ra...

Warning (2): number_format() expects parameter 1 to be double, string given [APP/views/elements/deal/deal_elem.ctp, line 130]

Code | Context

$___viewFn	=	"/var/www/dealque/app/views/elements/deal/deal_elem.ctp"
$___dataForView	=	array(
	"zone" => "merchants",
	"zone_menu" => "merchantsmain",
	"sponsored_deals" => array(
	"none",
	"none"
),
	"filterPaging" => "rt",
	"filter" => "ratingOrdered",
	"number_of_deals" => 101,
	"page" => "1",
	"prevValue" => "1",
	"numPages" => 11,
	"nextValue" => 2,
	"sub_category" => "Computers and Electronics",
	"category" => "Daily Deals",
	"merchantArray" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"top_ques_type" => "Daily Deals",
	"top_ques_sub_type" => "All",
	"merchantTopArray" => array(
	array(),
	array(),
	array(),
	array(),
	array()
),
	"main_categories" => array(
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array(),
	array()
),
	"cakeDebug" => MerchantsController
MerchantsController::$layout = "layout1"
MerchantsController::$name = "Merchants"
MerchantsController::$uses = array
MerchantsController::$helpers = array
MerchantsController::$here = "/main/Daily Deals/All/rt/1"
MerchantsController::$webroot = "/"
MerchantsController::$action = "main"
MerchantsController::$params = array
MerchantsController::$data = NULL
MerchantsController::$paginate = array
MerchantsController::$viewPath = "merchants"
MerchantsController::$layoutPath = NULL
MerchantsController::$viewVars = array
MerchantsController::$pageTitle = "DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com | Browsing Daily Deals | All "
MerchantsController::$modelNames = array
MerchantsController::$base = ""
MerchantsController::$autoRender = false
MerchantsController::$autoLayout = true
MerchantsController::$Component = Component object
MerchantsController::$components = array
MerchantsController::$view = "View"
MerchantsController::$ext = ".ctp"
MerchantsController::$output = NULL
MerchantsController::$plugin = NULL
MerchantsController::$cacheAction = false
MerchantsController::$persistModel = false
MerchantsController::$passedArgs = array
MerchantsController::$scaffold = false
MerchantsController::$methods = array
MerchantsController::$modelClass = "Merchant"
MerchantsController::$modelKey = "merchant"
MerchantsController::$validationErrors = NULL
MerchantsController::$_log = NULL
MerchantsController::$Session = SessionComponent object
MerchantsController::$Merchant = Merchant object
MerchantsController::$Rating = Rating object
MerchantsController::$Deal = Deal object
MerchantsController::$Sponsored_deal = Sponsored_deal object
MerchantsController::$User_deals = User_deals object
MerchantsController::$User_deal_ratings = User_deal_ratings object
MerchantsController::$Category = Category object
MerchantsController::$Review = Review object
MerchantsController::$User_review = User_review object
MerchantsController::$Monster = Monster object
MerchantsController::$Verify_img = Verify_img object,
	"ident_id" => "88",
	"deal_id" => "88_0",
	"ques" => "2",
	"img" => null,
	"img_size" => null,
	"link" => "http://www.buy.com/prod/iogear-guh227-7-port-high-speed-usb-2-0-hub-iogear-minihub-7-port-high/q/loc/101/10398118.html",
	"title" => "IOGEAR GUH227 7-Port High Speed USB 2.0 Hub - Compatible wit...",
	"description" => "IOGEAR's 7-port USB 2.0 hub provides 7 Hi-Speed USB 2.0 ports for your high-speed connectivity needs. This device is fully compliant to USB 2.0 specifications and provides a data transfer ra...",
	"additional_info" => "",
	"comments" => 0,
	"price" => "price: 26.24&lt",
	"start_date" => "2010-09-08 09:09:19",
	"name" => "Buy",
	"available" => "Y",
	"que_list" => array(),
	"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/main/Daily Deals/All/rt/1"
HtmlHelper::$params = array
HtmlHelper::$action = "main"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
	"form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/main/Daily Deals/All/rt/1"
FormHelper::$params = array
FormHelper::$action = "main"
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::$_log = NULL
FormHelper::$Html = HtmlHelper object,
	"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::$themeWeb = NULL
JavascriptHelper::$here = "/main/Daily Deals/All/rt/1"
JavascriptHelper::$params = array
JavascriptHelper::$action = "main"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
	"ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/main/Daily Deals/All/rt/1"
AjaxHelper::$params = array
AjaxHelper::$action = "main"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
	"time" => TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/main/Daily Deals/All/rt/1"
TimeHelper::$params = array
TimeHelper::$action = "main"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL,
	"session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "271dbdd1862a7610f0e326d69fcb3023"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "low"
SessionHelper::$time = 1284059038
SessionHelper::$sessionTime = 1284077038
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 788940000
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/main/Daily Deals/All/rt/1"
SessionHelper::$params = array
SessionHelper::$action = "main"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$loadHelpers	=	false
$cached	=	false
$loadedHelpers	=	array()
$zone	=	"merchants"
$zone_menu	=	"merchantsmain"
$sponsored_deals	=	array(
	"none",
	"none"
)
$filterPaging	=	"rt"
$filter	=	"ratingOrdered"
$number_of_deals	=	101
$page	=	"1"
$prevValue	=	"1"
$numPages	=	11
$nextValue	=	2
$sub_category	=	"Computers and Electronics"
$category	=	"Daily Deals"
$merchantArray	=	array(
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
)
)
$top_ques_type	=	"Daily Deals"
$top_ques_sub_type	=	"All"
$merchantTopArray	=	array(
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
),
	array(
	array()
)
)
$main_categories	=	array(
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
),
	array(
	"Category" => array()
)
)
$cakeDebug	=	MerchantsController
MerchantsController::$layout = "layout1"
MerchantsController::$name = "Merchants"
MerchantsController::$uses = array
MerchantsController::$helpers = array
MerchantsController::$here = "/main/Daily Deals/All/rt/1"
MerchantsController::$webroot = "/"
MerchantsController::$action = "main"
MerchantsController::$params = array
MerchantsController::$data = NULL
MerchantsController::$paginate = array
MerchantsController::$viewPath = "merchants"
MerchantsController::$layoutPath = NULL
MerchantsController::$viewVars = array
MerchantsController::$pageTitle = "DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com | Browsing Daily Deals | All "
MerchantsController::$modelNames = array
MerchantsController::$base = ""
MerchantsController::$autoRender = false
MerchantsController::$autoLayout = true
MerchantsController::$Component = Component object
MerchantsController::$components = array
MerchantsController::$view = "View"
MerchantsController::$ext = ".ctp"
MerchantsController::$output = NULL
MerchantsController::$plugin = NULL
MerchantsController::$cacheAction = false
MerchantsController::$persistModel = false
MerchantsController::$passedArgs = array
MerchantsController::$scaffold = false
MerchantsController::$methods = array
MerchantsController::$modelClass = "Merchant"
MerchantsController::$modelKey = "merchant"
MerchantsController::$validationErrors = NULL
MerchantsController::$_log = NULL
MerchantsController::$Session = SessionComponent object
MerchantsController::$Merchant = Merchant object
MerchantsController::$Rating = Rating object
MerchantsController::$Deal = Deal object
MerchantsController::$Sponsored_deal = Sponsored_deal object
MerchantsController::$User_deals = User_deals object
MerchantsController::$User_deal_ratings = User_deal_ratings object
MerchantsController::$Category = Category object
MerchantsController::$Review = Review object
MerchantsController::$User_review = User_review object
MerchantsController::$Monster = Monster object
MerchantsController::$Verify_img = Verify_img object
$ident_id	=	"88"
$deal_id	=	"88_0"
$ques	=	"2"
$img	=	null
$img_size	=	array(
	""
)
$link	=	"http://www.buy.com/prod/iogear-guh227-7-port-high-speed-usb-2-0-hub-iogear-minihub-7-port-high/q/loc/101/10398118.html"
$title	=	"IOGEAR GUH227 7-Port High Speed USB 2.0 Hub - Compatible wit..."
$description	=	"IOGEAR's 7-port USB 2.0 hub provides 7 Hi-Speed USB 2.0 ports for your high-speed connectivity needs. This device is fully compliant to USB 2.0 specifications and provides a data transfer ra..."
$additional_info	=	""
$comments	=	0
$price	=	"price: 26.24&lt"
$start_date	=	"2010-09-08 09:09:19"
$name	=	"Buy"
$available	=	"Y"
$que_list	=	array()
$html	=	HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/main/Daily Deals/All/rt/1"
HtmlHelper::$params = array
HtmlHelper::$action = "main"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$form	=	FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/main/Daily Deals/All/rt/1"
FormHelper::$params = array
FormHelper::$action = "main"
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::$_log = NULL
FormHelper::$Html = HtmlHelper object
$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::$themeWeb = NULL
JavascriptHelper::$here = "/main/Daily Deals/All/rt/1"
JavascriptHelper::$params = array
JavascriptHelper::$action = "main"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$ajax	=	AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/main/Daily Deals/All/rt/1"
AjaxHelper::$params = array
AjaxHelper::$action = "main"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$time	=	TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/main/Daily Deals/All/rt/1"
TimeHelper::$params = array
TimeHelper::$action = "main"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL
$session	=	SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "271dbdd1862a7610f0e326d69fcb3023"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "low"
SessionHelper::$time = 1284059038
SessionHelper::$sessionTime = 1284077038
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = true
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 788940000
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/main/Daily Deals/All/rt/1"
SessionHelper::$params = array
SessionHelper::$action = "main"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$my_ip	=	"38.107.191.105"
$qued	=	"false"
$start_date_formated	=	"2010-09-08 09^09^19"
$title_formated	=	"IOGEAR_GUH227_7-Port_High_Speed_USB_2.0_Hub_-_Compatible_wit..."
$img_name	=	"2010_09_08_09_09_19"
$date_array	=	array(
	"2010",
	"09",
	"08 09:09:19"
)
$var_year	=	"2010"
$var_month	=	"09"
$var_day	=	"08 09:09:19"
$var_timestamp	=	1283904000
$image	=	"/img/icons/no_img_small.jpg"

number_format - [internal], line ??
include - APP/views/elements/deal/deal_elem.ctp, line 130
View::_render() - CORE/cake/libs/view/view.php, line 665
View::element() - CORE/cake/libs/view/view.php, line 342
View::renderElement() - CORE/cake/libs/view/view.php, line 924
include - APP/views/merchants/main.ctp, line 58
View::_render() - CORE/cake/libs/view/view.php, line 665
View::render() - CORE/cake/libs/view/view.php, line 375
Controller::render() - CORE/cake/libs/controller/controller.php, line 805
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 86

FREE!

Thursday, September 9, 2010 by Joe Cigars

Compare

Daily Deals / Miscellaneous

Cigars International Xikar 6-Finger Ashtray - $19.99 + FREE ...

Xikar has taken it's revolutionary, cutting-edge technologies to the land of ashtrays. Now, you might say to yourself, "magnificent self, how great can an ashtray get?" Well, just have a loo...

$ 19.99

Thursday, September 9, 2010 by Fruper

Compare

Daily Deals / Computers and Electronics

Fruper LED Faucet Light - Temperature Sensitive - $9.95

$ 9.95

Thursday, September 9, 2010 by Titan Toys Inc

Compare

Daily Deals / Household

Titan Toys Inc NFL 8 - Steve McNair Figure - $4.00 (Reg. $9....

Steve McNair, Tennessee Titans QB, No. 9, sculpted in an action pose, featuring official team uniform and base. This figure was released as part of McFarlane NFL Sport Picks Series 8. Scu...

$ 4.00

Thursday, September 9, 2010 by tramdock

Compare

Daily Deals / Sporting Goods

Tramdock Lange Super Comp HP - Men's - $349.99 (Reg. $898.95...

Lange made the Men's Super Comp ski boot with a low volume 97mm last and a super stiff 140 flex for the most aggressive, hard charging skiers. This boot's asymmetrical volume and Shark Nose ...

$ 349.99

Thursday, September 9, 2010 by WhiskeyMilitia

Compare

Daily Deals / Apparel

Whiskey Militia Special Blend Thugby Jacket - Men's - $74.99...

Stay G'd up from the feet up in the Special Blend Thugby Jacket. Special Blend came correct with the freedom fit so you'll have more maneuverability when getting rad. They also hit the Thugb...

$ 74.99

Thursday, September 9, 2010 by Jewelry DOD

Compare

Daily Deals / Jewelry and Watches

Tiffany Inspired 14.00 carat Princess Brilliant cut Simulate...

Featuring an elegant Tiffany Inspired Princess brilliant cut simulated Diamond tennis bracelet. This stunning bracelet is hand set with 56 high grade princess brilliant cut simulated Diamond...

$ 29.99

Thursday, September 9, 2010 by mamabargains

Compare

Daily Deals / Miscellaneous

Learning Resources - Smart Safari

On sale now for only $10.80That's 63% off the retail price of $29.99!This cute reptile friend engages childrens senses with sound and light. Play 2 different ways! In Level 1 play, children...

$ 10.80

Thursday, September 9, 2010 by Hat A Day

Compare

Daily Deals / Apparel

Florida Gators One Fit Hat

Price: $�12.00Gators anyone? The Florida Gators One Fit Hat is awesome! I love the logo, the tight embroidery and detail is flawless! This hat pops with style and you will definitely get a c...

Check Price

Thursday, September 9, 2010 by Boarders Bestbuy

Compare

Daily Deals / Apparel

Academy Collective Snowboard 2009

Collective The Collective is a true twin sidewall that is the ultimate park board. With excellent torsional flex pattern that is forgiving for those not so stuck landings you will have no...

$ 159.99

...

Advertisment

Our Sponsors

Top Ques / Daily Deals / All

2
que(s)

IOGEAR GUH227 7-Port High Spee...

IOGEAR's 7-port USB 2.0 hub provides 7 Hi-Speed USB 2.0 ports for your high-speed connectivity needs......

0
que(s)

Cigars International Xikar 6-F...

Xikar has taken it's revolutionary, cutting-edge technologies to the land of ashtrays. Now, you migh......

0
que(s)

Fruper LED Faucet Light - Temp...

...

0
que(s)

Titan Toys Inc NFL 8 - Steve M...

Steve McNair, Tennessee Titans QB, No. 9, sculpted in an action pose, featuring official team unifor......

0
que(s)

Tramdock Lange Super Comp HP -...

Lange made the Men's Super Comp ski boot with a low volume 97mm last and a super stiff 140 flex for ......

Advertisment

(default) 112 queries took 1481 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `merchants`	13	13	1
2	DESCRIBE `ratings`	5	5	1
3	DESCRIBE `deals`	17	17	1
4	DESCRIBE `sponsored_deals`	4	4	1
5	DESCRIBE `user_deals`	15	15	1
6	DESCRIBE `user_deal_ratings`	5	5	1
7	DESCRIBE `categories`	3	3	1
8	DESCRIBE `reviews`	9	9	1
9	DESCRIBE `user_reviews`	7	7	1
10	DESCRIBE `monsters`	6	6	1
11	DESCRIBE `verify_imgs`	3	3	1
12	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
13	SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 19:09:57" LIMIT 2	0	0	0
14	SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Daily Deals'	6	6	0
15	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND available='Y'	1	1	0
16	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND available='Y'	1	1	147
17	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND available='Y'	1	1	0
18	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND available='Y'	1	1	0
19	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description, uid as ID, link, rating as ratingOrdered, que_count as rating, user_deals.img, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description, merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10	10	10	647
20	DESCRIBE `comments`	10	10	1
21	DESCRIBE `user_comments`	8	8	1
22	DESCRIBE `users`	11	11	1
23	DESCRIBE `report_deals`	7	7	1
24	DESCRIBE `report_comments`	8	8	1
25	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
26	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077036;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
27	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
28	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "88" AND comments.start_date = "2010-09-08 09:09:19") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "88" AND user_comments.start_date = "2010-09-08 09:09:19" )	2	2	0
29	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "88" AND date = "2010-09-08 09:09:19" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
30	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
31	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
32	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
33	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )	2	2	0
34	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
35	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
36	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
37	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059037	6		2
38	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
39	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "102" AND comments.start_date = "2010-09-09 19:09:20") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "102" AND user_comments.start_date = "2010-09-09 19:09:20" )	2	2	0
40	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "102" AND date = "2010-09-09 19:09:20" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
41	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
42	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
43	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
44	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "91" AND comments.start_date = "2010-09-09 19:09:14") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "91" AND user_comments.start_date = "2010-09-09 19:09:14" )	2	2	0
45	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "91" AND date = "2010-09-09 19:09:14" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
46	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
47	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
48	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
49	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-09 19:09:06") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-09 19:09:06" )	2	2	0
50	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-09 19:09:06" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
51	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
52	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
53	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
54	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "2" AND comments.start_date = "2010-09-09 19:09:03") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "2" AND user_comments.start_date = "2010-09-09 19:09:03" )	2	2	0
55	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "2" AND date = "2010-09-09 19:09:03" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
56	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
57	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
58	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
59	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "145" AND comments.start_date = "2010-09-09 18:09:13") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "145" AND user_comments.start_date = "2010-09-09 18:09:13" )	2	2	0
60	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "145" AND date = "2010-09-09 18:09:13" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
61	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
62	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
63	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
64	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "136" AND comments.start_date = "2010-09-09 18:09:09") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )	2	2	0
65	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
66	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
67	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
68	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
69	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "59" AND comments.start_date = "2010-09-09 17:09:43") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "59" AND user_comments.start_date = "2010-09-09 17:09:43" )	2	2	0
70	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "59" AND date = "2010-09-09 17:09:43" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
71	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
72	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
73	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059037	0		2
74	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
75	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "56" AND comments.start_date = "2010-09-09 17:09:42") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "56" AND user_comments.start_date = "2010-09-09 17:09:42" )	2	2	0
76	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "56" AND date = "2010-09-09 17:09:42" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
77	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	5	5	650
78	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
79	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
80	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
81	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "88" AND comments.start_date = "2010-09-08 09:09:19") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "88" AND user_comments.start_date = "2010-09-08 09:09:19" )	2	2	0
82	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "88" AND date = "2010-09-08 09:09:19" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
83	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
84	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
85	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
86	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )	2	2	0
87	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
88	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
89	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
90	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
91	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "102" AND comments.start_date = "2010-09-09 19:09:20") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "102" AND user_comments.start_date = "2010-09-09 19:09:20" )	2	2	0
92	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "102" AND date = "2010-09-09 19:09:20" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
93	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
94	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
95	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059038	0		2
96	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
97	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "91" AND comments.start_date = "2010-09-09 19:09:14") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "91" AND user_comments.start_date = "2010-09-09 19:09:14" )	2	2	0
98	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "91" AND date = "2010-09-09 19:09:14" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
99	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
100	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
101	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
102	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-09 19:09:06") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-09 19:09:06" )	2	2	0
103	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-09 19:09:06" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
104	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
105	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
106	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
107	SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent	18	18	0
108	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
109	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
110	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
111	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
112	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 112 queries took 1481 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `merchants`

DESCRIBE `ratings`

DESCRIBE `deals`

DESCRIBE `sponsored_deals`

DESCRIBE `user_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `categories`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

DESCRIBE `monsters`

DESCRIBE `verify_imgs`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 19:09:57" LIMIT 2

SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Daily Deals'

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND available='Y'

147

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Daily Deals' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Daily Deals' AND available='Y'

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description, uid as ID, link, rating as ratingOrdered, que_count as rating, user_deals.img, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description, merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10

647

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077036;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "88" AND comments.start_date = "2010-09-08 09:09:19") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "88" AND user_comments.start_date = "2010-09-08 09:09:19" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "88" AND date = "2010-09-08 09:09:19" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077037;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077037 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-09 19:09:23") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "109" AND user_comments.start_date = "2010-09-09 19:09:23" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059037

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "102" AND comments.start_date = "2010-09-09 19:09:20") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "102" AND user_comments.start_date = "2010-09-09 19:09:20" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "102" AND date = "2010-09-09 19:09:20" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "91" AND comments.start_date = "2010-09-09 19:09:14") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "91" AND user_comments.start_date = "2010-09-09 19:09:14" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "91" AND date = "2010-09-09 19:09:14" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "73" AND comments.start_date = "2010-09-09 19:09:06") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "73" AND user_comments.start_date = "2010-09-09 19:09:06" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-09 19:09:06" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "2" AND comments.start_date = "2010-09-09 19:09:03") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "2" AND user_comments.start_date = "2010-09-09 19:09:03" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "2" AND date = "2010-09-09 19:09:03" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "145" AND comments.start_date = "2010-09-09 18:09:13") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "145" AND user_comments.start_date = "2010-09-09 18:09:13" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "145" AND date = "2010-09-09 18:09:13" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "136" AND comments.start_date = "2010-09-09 18:09:09") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "136" AND user_comments.start_date = "2010-09-09 18:09:09" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "136" AND date = "2010-09-09 18:09:09" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "59" AND comments.start_date = "2010-09-09 17:09:43") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "59" AND user_comments.start_date = "2010-09-09 17:09:43" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "59" AND date = "2010-09-09 17:09:43" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059037

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "56" AND comments.start_date = "2010-09-09 17:09:42") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "56" AND user_comments.start_date = "2010-09-09 17:09:42" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "56" AND date = "2010-09-09 17:09:42" AND TIMEDIFF("2010-09-09 19:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

650

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "88" AND date = "2010-09-08 09:09:19" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077038;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077038 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-09 19:09:23" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "102" AND date = "2010-09-09 19:09:20" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284059038

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "91" AND date = "2010-09-09 19:09:14" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

100

101

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

102

103

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "73" AND date = "2010-09-09 19:09:06" AND TIMEDIFF("2010-09-09 19:09:58", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

104

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

105

106

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

107

SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent

108

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

109

110

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

111

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

112