Warning:

Toys & Games

Coupons / Everything / Toys & Games

Toys & Games Coupon Codes

STAY IN THE KNOW

Coupons, promo codes and discounts email newsletter

BIGWORDS COMPARES EVERY PRODUCTION IN THE UNIVERSE
AND MAXIMIZES COUPONS AT THE SAME TIME!

Store

BIGWORDS compares the best online textbook stores at once finding the sweetest, cheapest textbooks on the planet.
Multi-Item Price Optimization™ saves up to 90%*, including coupons, promotions, and shipping. 35-45% cheaper textbooks than other online stores, and way cheaper than bookstores.

Bigwords Newsletter
Coupons, Promo Codes & Discount.
Now use your favorite uber-bot to search your favorite sites and products for coupons, promo codes and discounts.

Hot Deals Newsletter

Questions? Feedback?Olark live chat software

ZFDebug v1.5

The project is hosted at http://zfdebug.googlecode.com and released under the BSD License
Includes images from the Silk Icon set by Mark James

File Information

254 Files Included
Total Size: 2452.7K
Basepath: /home/stage_bigwords_com/application

Application Files

/Bootstrap.php
/default/controllers/CouponsController.php
/default/views/layouts/main.phtml
/default/views/partials/analytics.phtml
/default/views/partials/footer.phtml
/default/views/partials/header.phtml
/default/views/partials/offerbar.phtml
/default/views/partials/olark.phtml
/default/views/scripts/coupons/bigdealsform.phtml
/default/views/scripts/coupons/categorycoupon.phtml
/home/stage_bigwords_com/httpdocs/index.php
/home/stage_bigwords_com/library/Bigwords/BaseController.php
/home/stage_bigwords_com/library/Bigwords/Bookbag.php
/home/stage_bigwords_com/library/Bigwords/ClientContent.php
/home/stage_bigwords_com/library/Bigwords/ClientVars.php
/home/stage_bigwords_com/library/Bigwords/Debug.php
/home/stage_bigwords_com/library/Bigwords/Debug/LogFormatterSimpleMaxLength.php
/home/stage_bigwords_com/library/Bigwords/Models/Db.php
/home/stage_bigwords_com/library/Bigwords/Models/Db/Main/Browsenodes.php
/home/stage_bigwords_com/library/Bigwords/Models/Db/Main/Deals.php
/home/stage_bigwords_com/library/Bigwords/Models/Db/Main/Pricingsavings.php
/home/stage_bigwords_com/library/Bigwords/Models/Db/Main/Products.php
/home/stage_bigwords_com/library/Bigwords/Models/Db/Main/Store.php
/home/stage_bigwords_com/library/Bigwords/Models/External/Search/Popshops.php
/home/stage_bigwords_com/library/Bigwords/Plugins/Initialize.php
/home/stage_bigwords_com/library/Bigwords/Scraper.php
/home/stage_bigwords_com/library/Bigwords/Search/Provider/Amazon.php
/home/stage_bigwords_com/library/Bigwords/Search/ProviderInterface.php
/home/stage_bigwords_com/library/Bigwords/Tools/Global.php
/home/stage_bigwords_com/library/Bigwords/View/Helper/BetterSearch.php
/home/stage_bigwords_com/library/Rediska/Autoloader.php
/home/stage_bigwords_com/library/Rediska/Command/Abstract.php
/home/stage_bigwords_com/library/Rediska/Command/DeleteFromSet.php
/home/stage_bigwords_com/library/Rediska/Command/Expire.php
/home/stage_bigwords_com/library/Rediska/Command/Get.php
/home/stage_bigwords_com/library/Rediska/Command/GetFromHash.php
/home/stage_bigwords_com/library/Rediska/Command/GetSet.php
/home/stage_bigwords_com/library/Rediska/Command/Interface.php
/home/stage_bigwords_com/library/Rediska/Command/SetToHash.php
/home/stage_bigwords_com/library/Rediska/Commands.php
/home/stage_bigwords_com/library/Rediska/Connection.php
/home/stage_bigwords_com/library/Rediska/Connection/Exec.php
/home/stage_bigwords_com/library/Rediska/Connection/Specified.php
/home/stage_bigwords_com/library/Rediska/Key/Abstract.php
/home/stage_bigwords_com/library/Rediska/Key/SortedSet.php
/home/stage_bigwords_com/library/Rediska/KeyDistributor/ConsistentHashing.php
/home/stage_bigwords_com/library/Rediska/KeyDistributor/Interface.php
/home/stage_bigwords_com/library/Rediska/Manager.php
/home/stage_bigwords_com/library/Rediska/Options.php
/home/stage_bigwords_com/library/Rediska/Options/RediskaInstance.php
/home/stage_bigwords_com/library/Rediska/Profiler/Interface.php
/home/stage_bigwords_com/library/Rediska/Profiler/Null.php
/home/stage_bigwords_com/library/Rediska/Rediska.php
/home/stage_bigwords_com/library/Rediska/Serializer.php
/home/stage_bigwords_com/library/Rediska/Serializer/Adapter/Interface.php
/home/stage_bigwords_com/library/Rediska/Serializer/Adapter/PhpSerialize.php
/home/stage_bigwords_com/library/Rediska/Serializer/Adapter/ToString.php
/home/stage_bigwords_com/library/Rediska/Transaction.php

Zend Library Files

/home/stage_bigwords_com/library/Rediska/Zend/Cache/Backend/Redis.php
/home/stage_bigwords_com/library/Rediska/Zend/Session/SaveHandler/Redis.php
/home/stage_bigwords_com/library/Rediska/Zend/Session/Set.php
/home/stage_bigwords_com/library/Zend/Application.php
/home/stage_bigwords_com/library/Zend/Application/Bootstrap/Bootstrap.php
/home/stage_bigwords_com/library/Zend/Application/Bootstrap/BootstrapAbstract.php
/home/stage_bigwords_com/library/Zend/Application/Bootstrap/Bootstrapper.php
/home/stage_bigwords_com/library/Zend/Application/Bootstrap/ResourceBootstrapper.php
/home/stage_bigwords_com/library/Zend/Application/Module/Autoloader.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Cachemanager.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Frontcontroller.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Layout.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Log.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Mail.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Multidb.php
/home/stage_bigwords_com/library/Zend/Application/Resource/Resource.php
/home/stage_bigwords_com/library/Zend/Application/Resource/ResourceAbstract.php
/home/stage_bigwords_com/library/Zend/Auth.php
/home/stage_bigwords_com/library/Zend/Auth/Storage/Interface.php
/home/stage_bigwords_com/library/Zend/Auth/Storage/Session.php
/home/stage_bigwords_com/library/Zend/Cache.php
/home/stage_bigwords_com/library/Zend/Cache/Backend.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/Apc.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/ExtendedInterface.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/File.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/Interface.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/Static.php
/home/stage_bigwords_com/library/Zend/Cache/Backend/TwoLevels.php
/home/stage_bigwords_com/library/Zend/Cache/Core.php
/home/stage_bigwords_com/library/Zend/Cache/Exception.php
/home/stage_bigwords_com/library/Zend/Cache/Frontend/Capture.php
/home/stage_bigwords_com/library/Zend/Cache/Frontend/File.php
/home/stage_bigwords_com/library/Zend/Cache/Manager.php
/home/stage_bigwords_com/library/Zend/Config.php
/home/stage_bigwords_com/library/Zend/Config/Ini.php
/home/stage_bigwords_com/library/Zend/Controller/Action.php
/home/stage_bigwords_com/library/Zend/Controller/Action/Helper/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Action/Helper/ViewRenderer.php
/home/stage_bigwords_com/library/Zend/Controller/Action/HelperBroker.php
/home/stage_bigwords_com/library/Zend/Controller/Action/HelperBroker/PriorityStack.php
/home/stage_bigwords_com/library/Zend/Controller/Action/Interface.php
/home/stage_bigwords_com/library/Zend/Controller/Dispatcher/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Dispatcher/Interface.php
/home/stage_bigwords_com/library/Zend/Controller/Dispatcher/Standard.php
/home/stage_bigwords_com/library/Zend/Controller/Exception.php
/home/stage_bigwords_com/library/Zend/Controller/Front.php
/home/stage_bigwords_com/library/Zend/Controller/Plugin/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Plugin/Broker.php
/home/stage_bigwords_com/library/Zend/Controller/Plugin/ErrorHandler.php
/home/stage_bigwords_com/library/Zend/Controller/Request/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Request/Http.php
/home/stage_bigwords_com/library/Zend/Controller/Response/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Response/Http.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Interface.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Rewrite.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Route.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Route/Abstract.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Route/Interface.php
/home/stage_bigwords_com/library/Zend/Controller/Router/Route/Module.php
/home/stage_bigwords_com/library/Zend/Db.php
/home/stage_bigwords_com/library/Zend/Db/Adapter/Abstract.php
/home/stage_bigwords_com/library/Zend/Db/Adapter/Pdo/Abstract.php
/home/stage_bigwords_com/library/Zend/Db/Adapter/Pdo/Mysql.php
/home/stage_bigwords_com/library/Zend/Db/Expr.php
/home/stage_bigwords_com/library/Zend/Db/Profiler.php
/home/stage_bigwords_com/library/Zend/Db/Profiler/Firebug.php
/home/stage_bigwords_com/library/Zend/Db/Profiler/Query.php
/home/stage_bigwords_com/library/Zend/Db/Select.php
/home/stage_bigwords_com/library/Zend/Db/Statement.php
/home/stage_bigwords_com/library/Zend/Db/Statement/Interface.php
/home/stage_bigwords_com/library/Zend/Db/Statement/Pdo.php
/home/stage_bigwords_com/library/Zend/Db/Table.php
/home/stage_bigwords_com/library/Zend/Db/Table/Abstract.php
/home/stage_bigwords_com/library/Zend/Db/Table/Definition.php
/home/stage_bigwords_com/library/Zend/Exception.php
/home/stage_bigwords_com/library/Zend/Filter.php
/home/stage_bigwords_com/library/Zend/Filter/Inflector.php
/home/stage_bigwords_com/library/Zend/Filter/Interface.php
/home/stage_bigwords_com/library/Zend/Filter/PregReplace.php
/home/stage_bigwords_com/library/Zend/Filter/StringToLower.php
/home/stage_bigwords_com/library/Zend/Filter/Word/CamelCaseToDash.php
/home/stage_bigwords_com/library/Zend/Filter/Word/CamelCaseToSeparator.php
/home/stage_bigwords_com/library/Zend/Filter/Word/Separator/Abstract.php
/home/stage_bigwords_com/library/Zend/Filter/Word/SeparatorToSeparator.php
/home/stage_bigwords_com/library/Zend/Filter/Word/UnderscoreToSeparator.php
/home/stage_bigwords_com/library/Zend/Http/Client.php
/home/stage_bigwords_com/library/Zend/Http/Client/Adapter/Interface.php
/home/stage_bigwords_com/library/Zend/Http/Response.php
/home/stage_bigwords_com/library/Zend/Http/Response/Stream.php
/home/stage_bigwords_com/library/Zend/Json.php
/home/stage_bigwords_com/library/Zend/Json/Expr.php
/home/stage_bigwords_com/library/Zend/Layout.php
/home/stage_bigwords_com/library/Zend/Layout/Controller/Action/Helper/Layout.php
/home/stage_bigwords_com/library/Zend/Layout/Controller/Plugin/Layout.php
/home/stage_bigwords_com/library/Zend/Loader.php
/home/stage_bigwords_com/library/Zend/Loader/Autoloader.php
/home/stage_bigwords_com/library/Zend/Loader/Autoloader/Interface.php
/home/stage_bigwords_com/library/Zend/Loader/Autoloader/Resource.php
/home/stage_bigwords_com/library/Zend/Loader/PluginLoader.php
/home/stage_bigwords_com/library/Zend/Loader/PluginLoader/Interface.php
/home/stage_bigwords_com/library/Zend/Log.php
/home/stage_bigwords_com/library/Zend/Log/Exception.php
/home/stage_bigwords_com/library/Zend/Log/FactoryInterface.php
/home/stage_bigwords_com/library/Zend/Log/Filter/Abstract.php
/home/stage_bigwords_com/library/Zend/Log/Filter/Interface.php
/home/stage_bigwords_com/library/Zend/Log/Filter/Priority.php
/home/stage_bigwords_com/library/Zend/Log/Formatter/Abstract.php
/home/stage_bigwords_com/library/Zend/Log/Formatter/Firebug.php
/home/stage_bigwords_com/library/Zend/Log/Formatter/Interface.php
/home/stage_bigwords_com/library/Zend/Log/Formatter/Simple.php
/home/stage_bigwords_com/library/Zend/Log/Writer/Abstract.php
/home/stage_bigwords_com/library/Zend/Log/Writer/Firebug.php
/home/stage_bigwords_com/library/Zend/Log/Writer/Mail.php
/home/stage_bigwords_com/library/Zend/Log/Writer/Stream.php
/home/stage_bigwords_com/library/Zend/Mail.php
/home/stage_bigwords_com/library/Zend/Mail/Protocol/Abstract.php
/home/stage_bigwords_com/library/Zend/Mail/Protocol/Smtp.php
/home/stage_bigwords_com/library/Zend/Mail/Transport/Abstract.php
/home/stage_bigwords_com/library/Zend/Mail/Transport/Smtp.php
/home/stage_bigwords_com/library/Zend/Mime.php
/home/stage_bigwords_com/library/Zend/Mime/Message.php
/home/stage_bigwords_com/library/Zend/Mime/Part.php
/home/stage_bigwords_com/library/Zend/Registry.php
/home/stage_bigwords_com/library/Zend/Rest/Client.php
/home/stage_bigwords_com/library/Zend/Rest/Client/Result.php
/home/stage_bigwords_com/library/Zend/Service/Abstract.php
/home/stage_bigwords_com/library/Zend/Service/Amazon.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/autoload.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/composer/ClassLoader.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/composer/autoload_real.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/composer/autoload_static.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/guzzle/src/functions.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/guzzle/src/functions_include.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/promises/src/functions.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/promises/src/functions_include.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/psr7/src/functions.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/guzzlehttp/psr7/src/functions_include.php
/home/stage_bigwords_com/library/Zend/Service/Amazon/Paapi5/vendor/ralouphie/getallheaders/src/getallheaders.php
/home/stage_bigwords_com/library/Zend/Session.php
/home/stage_bigwords_com/library/Zend/Session/Abstract.php
/home/stage_bigwords_com/library/Zend/Session/Exception.php
/home/stage_bigwords_com/library/Zend/Session/Namespace.php
/home/stage_bigwords_com/library/Zend/Session/SaveHandler/Exception.php
/home/stage_bigwords_com/library/Zend/Session/SaveHandler/Interface.php
/home/stage_bigwords_com/library/Zend/Uri.php
/home/stage_bigwords_com/library/Zend/Validate.php
/home/stage_bigwords_com/library/Zend/Validate/Abstract.php
/home/stage_bigwords_com/library/Zend/Validate/Barcode.php
/home/stage_bigwords_com/library/Zend/Validate/Barcode/AdapterAbstract.php
/home/stage_bigwords_com/library/Zend/Validate/Barcode/AdapterInterface.php
/home/stage_bigwords_com/library/Zend/Validate/Barcode/Ean13.php
/home/stage_bigwords_com/library/Zend/Validate/Hostname.php
/home/stage_bigwords_com/library/Zend/Validate/Interface.php
/home/stage_bigwords_com/library/Zend/Validate/Ip.php
/home/stage_bigwords_com/library/Zend/Version.php
/home/stage_bigwords_com/library/Zend/View.php
/home/stage_bigwords_com/library/Zend/View/Abstract.php
/home/stage_bigwords_com/library/Zend/View/Helper/Abstract.php
/home/stage_bigwords_com/library/Zend/View/Helper/Doctype.php
/home/stage_bigwords_com/library/Zend/View/Helper/HeadLink.php
/home/stage_bigwords_com/library/Zend/View/Helper/HeadMeta.php
/home/stage_bigwords_com/library/Zend/View/Helper/HeadScript.php
/home/stage_bigwords_com/library/Zend/View/Helper/HeadStyle.php
/home/stage_bigwords_com/library/Zend/View/Helper/HeadTitle.php
/home/stage_bigwords_com/library/Zend/View/Helper/InlineScript.php
/home/stage_bigwords_com/library/Zend/View/Helper/Interface.php
/home/stage_bigwords_com/library/Zend/View/Helper/Layout.php
/home/stage_bigwords_com/library/Zend/View/Helper/Partial.php
/home/stage_bigwords_com/library/Zend/View/Helper/Placeholder/Container.php
/home/stage_bigwords_com/library/Zend/View/Helper/Placeholder/Container/Abstract.php
/home/stage_bigwords_com/library/Zend/View/Helper/Placeholder/Container/Standalone.php
/home/stage_bigwords_com/library/Zend/View/Helper/Placeholder/Registry.php
/home/stage_bigwords_com/library/Zend/View/Helper/Url.php
/home/stage_bigwords_com/library/Zend/View/Interface.php
/home/stage_bigwords_com/library/Zend/Wildfire/Channel/HttpHeaders.php
/home/stage_bigwords_com/library/Zend/Wildfire/Channel/Interface.php
/home/stage_bigwords_com/library/Zend/Wildfire/Plugin/FirePhp.php
/home/stage_bigwords_com/library/Zend/Wildfire/Plugin/FirePhp/Message.php
/home/stage_bigwords_com/library/Zend/Wildfire/Plugin/FirePhp/TableMessage.php
/home/stage_bigwords_com/library/Zend/Wildfire/Plugin/Interface.php
/home/stage_bigwords_com/library/Zend/Wildfire/Protocol/JsonStream.php
/home/stage_bigwords_com/library/Zend/Xml/Security.php

ZFDebug Library Files

/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Cache.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Database.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Exception.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/File.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Html.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Interface.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Memory.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Registry.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Text.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Time.php
/home/stage_bigwords_com/library/ZFDebug/Controller/Plugin/Debug/Plugin/Variables.php

HTML Information

Tags
HTML Size: 31.04K
Stylesheet Files
Javascript Files
Images

Memory Usage

Controller: 1820.13K

Registered Instances

Zend_View_Helper_Doctype => ArrayObject Object()
Zend_View_Helper_Placeholder_Registry => Zend_View_Helper_Placeholder_Registry Object()
config => Zend_Config Object()
dbprofiler => Zend_Db_Profiler_Firebug Object()
debug => NULL

Custom Timers

Controller: 110.29 ms

Overall Timers

default

coupons

categorycoupon

Avg: 449.79 ms / 1 requests
Min: 449.79 ms
Max: 449.79 ms

Reset timers by sending ZFDEBUG_RESET as a GET/POST parameter

$_COOKIE

Request

Category => 'toys-games'
action => 'categorycoupon'
controller => 'coupons'

View vars

HTTPS_SUFFIX => 'https://'
action_name => 'categorycoupon'
bigSavings =>

bigwords => 19.70
number => 1
retail => 158.11
saveDollar => 138.41
savePerItem => 138.41
savePercent => 0.87
updateDTS => '2023-08-28 09:44:07'

bookbag => Bigwords_Bookbag Object()
cdnServer => 'stage.bigwords.com'
clientSource => 'direct'
clientVars => Bigwords_ClientVars Object()
cpopshopproduct => NULL
csrc_amazon => 'interverse'
csrc_cj => '&SID=555ac3f36e361ccee8f0bb8a6a020e29'
csrc_half => '555ac3f36e361ccee8f0bb8a6a020e29'
csrc_ls => '&u1=555ac3f36e361ccee8f0bb8a6a020e29'
csrc_mbs => '&SID=555ac3f36e361ccee8f0bb8a6a020e29'
csrc_tbrus => ''
env => 'stage'
likedislike =>

=> 'd'

likedislikestore =>

olark => 1
oneStoreDeals => 1
popshopproduct => 'Error reading XML string'
primary_server => 'stage.bigwords.com'
searcheverythingsite => 'Amazon'
searchsite => 'Amazon'
settings => Zend_Config Object()
storedetails =>

browsenode => 165793011
browsenodedescription => ' Toys & Games'

trending =>

viewPref => 'desktop'
www => 'stage.BIGWORDS.com'

Debug mode can be enabled/disabled here.
You can reset the server cache by clicking here.
phpinfo(); is here.

APC 4.0.11 Enabled

30.8M available, 1.2M used
140 Files cached (1.2M)
182619 Hits (77.7%)
0 Expunges (cache full count)

Cache 0 (Zend_Cache_Backend_File)

1 Entry
Filling Percentage: 51%

Database queries

Metadata cache is ENABLED

Adapter 0

[1.66 ms] connect
[2.75 ms] SELECT * FROM browse_nodes where categoryPath='toys-games' and status=1
[3.2 ms] SELECT dealProductCodes.productCodeType, dealProductCodes.productCode, deals.*,store.UIName as storeName,store.urlname as storeNameurl, store.url as storeurl, store.imageName as storeimageName, storeUnaffiliated.UIName as aname,storeUnaffiliated.urlname as anameurl, storeUnaffiliated.url as aurl, storeUnaffiliated.imageName as aimageName, dealTypes.dealTypeDescriptionsID, dealTypeDescriptions.Description as dCategory, dealCategories.browseNodesID FROM deals LEFT JOIN store ON deals.storeID=store.ID LEFT JOIN storeUnaffiliated ON deals.storeUnaffiliatedID = storeUnaffiliated.ID LEFT JOIN dealTypes ON dealTypes.dealID=deals.ID LEFT JOIN dealTypeDescriptions ON dealTypes.dealTypeDescriptionsID=dealTypeDescriptions.ID LEFT JOIN dealCategories ON dealCategories.dealID=deals.ID LEFT JOIN dealProductCodes ON dealProductCodes.dealID=deals.ID where deals.approvalStatus=1 and Now() >= deals.validOnDate AND Now() < DATE_ADD(deals.expirationDate,INTERVAL 1 DAY) and deals.ID IN (select dealID from dealCategories where browseNodesID =165793011 ) and ((storeUnaffiliated.approvalStatus=1 or storeUnaffiliated.UIName is NULL) and (store.approvalStatus=1 or store.UIName is NULL) and (storeUnaffiliated.UIName is NOT NULL or store.UIName is NOT NULL) ) order by deals.numSearches desc,deals.likes/(deals.likes+deals.dislikes) desc

1.12.11/5.6.40 file

254 Files

HTML

4482K of 128M

Registry (5) time

449.79 ms

Variables

DebugMode

Cache

3 in 7.62 ms«