Browse ads: Automotive- Alcoholic beverages- Clothing- Cosmetics- Entertainment- Food- Travel- Telecommunications- More...

Best TV of the week

07 May 2025

Best TV archive


More

Gold sponsors

Silver sponsors

The Best Ad Jobs
Retrieving latest jobs

Visit Campaign Brief for Australian creative
advertising news


== PHP_Debug [V1.1.0] | By COil (2005) | qrf_coil@yahoo.fr | PHP_Debug Project Home
== Search in Debug Infos :
Search for : Case sensitive :   Select only info of type :
[best.php,159]DEBUG INFO
[best.php,160]
SELECT SQL_CACHE spots.id, spots.product, spots.active, spots.handle, IF(COALESCE(spots.position
,0)=0,999,spots.position) as pos, spots.title, spots.description, spots.bestDate, agencies.AgencyNam
e AS agency, IFNULL(thumbs.filename,'images/nothumb.jpg') as filename, IFNULL(thumbs.typeId,1) as typeId,
UNIX_TIMESTAMP(GREATEST(spots.modifiedDate, spots.createdDate)) as filetime, c.name AS ad_category FROM s
pots INNER JOIN spotcategories sc ON (sc.spotId = spots.id) INNER JOIN categories c ON (c.id = sc.categoryId
AND c.type = 'ad') LEFT JOIN agencies ON (spots.agencyId = agencies.id) LEFT JOIN files thumbs ON (spots.id = t
humbs.spotid) WHERE (spots.active = 1
OR spots.bestDate IS NOT NULL)
AND spottype = 1
AND (typeId < 2)
ORDER BY YEAR(spots.bestDate) DESC, WEEKOFYEAR(spots.bestDate) DESC, pos ASC, productionDate DESC LIMIT 30 [ Explain ] [ Query ]
== Execution Time Global : 0.4292s [ PHP, 0.4292s, 100% ] - [ SQL, 0s, 0%, 0 Query ]
== Included/Required files (31) :
/var/www/html/best.php [ View Source ] [ Edit ]
/var/www/html/includes/config.php [ View Source ] [ Edit ]
/var/www/html/includes/bootstrap.php [ View Source ] [ Edit ]
/var/www/html/includes/functions.php [ View Source ] [ Edit ]
/var/www/html/includes/debug/debug.php [ View Source ] [ Edit ]
/var/www/html/includes/Smarty.Bestads.class.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/Smarty.class.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.rm_auto.php [ View Source ] [ Edit ]
/var/www/html/includes/pear/DB.php [ View Source ] [ Edit ]
/var/www/html/includes/pear/PEAR.php [ View Source ] [ Edit ]
/var/www/html/includes/pear/DB/mysql.php [ View Source ] [ Edit ]
/var/www/html/includes/pear/DB/common.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/Smarty_Compiler.class.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.assemble_plugin_filepath.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.get_include_path.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/plugins/function.lookup_link.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.write_compiled_resource.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.write_file.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.create_dir_structure.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%F7^F7F^F7F34188%%header.tpl.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/internals/core.load_plugins.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/plugins/modifier.nl2br.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/plugins/compiler.assign.php [ View Source ] [ Edit ]
/var/www/html/includes/smarty/plugins/function.ad_list_item.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%D7^D7A^D7A86E89%%best.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%95^959^95947A62%%inc_large_ad.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%BF^BFA^BFA609BE%%inc_sponsors.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%A1^A17^A1745F53%%inc_latest_jobs.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%5C^5C0^5C0C084B%%inc_best_recruiters.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%BD^BDB^BDBB42AB%%inc_facebook_like.tpl.php [ View Source ] [ Edit ]
/var/www/html/templates_c/%%0E^0E4^0E407559%%footer.tpl.php [ View Source ] [ Edit ]
== _POST Var (0) : -- NO VARIABLE --
== _GET Var (1) :
_GET :
Array
(
    [adtype] => 1
)
== _FILES Var (0) : -- NO VARIABLE --
== _COOKIE Var (0) : -- NO VARIABLE --