ACT Directory

#	type	file	line	class	function	message
# 1	Credits					PHP_Debug [V1.0.3] \| By COil (2008) \| http://www.strangebuzz.com \| PHP_Debug Project Home \| Original idea from the symfony framework
# 2	PHP error	core.class.php	178	core	setModules()	PHP notice : Undefined property: stdClass::$write_cache
# 3	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: input line 12 and div in Entity, line: 14 /!\
# 4	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: input line 18 and div in Entity, line: 20 /!\
# 5	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: div line 16 and form in Entity, line: 29 /!\
# 6	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: form line 9 and div in Entity, line: 31 /!\
# 7	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Opening and ending tag mismatch: div line 2 and body in Entity, line: 39 /!\
# 8	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Premature end of data in tag div line 1 in Entity, line: 39 /!\
# 9	PHP error			DOMDocument	loadXML()	/!\ PHP WARNING : DOMDocument::loadXML() [function.DOMDocument-loadXML]: Premature end of data in tag body line 1 in Entity, line: 39 /!\
# 10	Variable dump	businesslisting_search.php	59	businesslisting_search	__construct()	dump of 'Active Fields' (array) : Array ( [State] => Array ( [sql] => Array ( [0] => businesslisting_state = 'act' ) [value] => Array ( [0] => state-act ) [operand] => OR [sphinx] => Array ( [attrs] => businesslisting_state [value] => act ) ) [FORM_VARS] => Array ( [sql] => Array ( [0] => ) [operand] => AND ) )
# 11	Variable dump	businesslisting_search.php	204	businesslisting_search	getLocation()	dump of 'Location searches:' (array) : Array ( [0] => Array ( [loc] => act [state] => [postcode] => ) )
# 12	Variable dump	businesslisting_search.php	865	businesslisting_search	buildQuery()	dump of 'Sphinx Search Term' (string) : (@listing_document dom_32848 ) @location_document (state_1)
# 13	Variable dump	businesslisting_search.php	865	businesslisting_search	buildQuery()	dump of 'Sphinx Search Term' (string) : (@listing_document dom_32848 ) @location_document (state_1)
# 14	PHP error	comp_objects.class.php	2460	comp_objects	generate_result_rows2()	PHP notice : Undefined variable: title
# 15	PHP error	functions.inc.php	10		somg_stats_beacon()	PHP notice : Undefined index: tracker_omg
# 16	PHP error	functions.inc.php	10		somg_stats_beacon()	PHP notice : Undefined index: tracker_omg
# 17	PHP error	core.class.php	178	core	setModules()	PHP notice : Undefined property: stdClass::$write_cache
# 18	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 19	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 20	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 21	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 22	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 23	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 24	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 25	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 26	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 27	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\

Database / SQL queries

[< 1 ms] SELECT domain.domain_id, domain.name, IF(domain.template_id = 0,1,domain.template_id) AS template_id, domain.description AS phrase_break, domain.primary_keyword, domain.redirect, domain.ollority, domain.portfolio_id, template.name AS template_name, domain.navigation_id AS domain_navigation_id, template.navigation_id AS template_navigation_id, domain.last_published, domain.last_modified FROM boomerang_domains.domain LEFT JOIN boomerang_domains.template ON domain.template_id = template.template_id WHERE domain.name = "consult.com.au" AND domain.exclude = 0
[< 1 ms] SELECT last_published FROM boomerang_domains.domain where domain_id=32848
[< 1 ms] SELECT * FROM boomerang_domains.openx_sites WHERE site_key IN ( 'domain_32848_directory/state-act', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-act', 'group_85_directory', 'group_85_', 'group_263_directory/state-act', 'group_263_directory', 'group_263_', 'group_268_directory/state-act', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-act', 'runofnetwork_0_directory', 'runofnetwork_0_' ) ORDER BY site_priority LIMIT 1
[< 1 ms] SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 628;
[< 1 ms] SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 410;
[< 1 ms] SELECT * FROM sys_objects WHERE id = ( SELECT object_id FROM sys_search_comparisson_search WHERE sys_search_comparisson_search.id = 46 )
[< 1 ms] SELECT svf.*, IF(NOT svf2.id IS NULL, 1, 0) as is_parent, svf3.field_title as parent_name FROM sys_search_view_field svf LEFT JOIN sys_search_view_field svf2 ON svf.id = svf2.field_parent_id LEFT JOIN sys_search_view_field svf3 ON svf.field_parent_id = svf3.id WHERE svf.id IN ( SELECT sys_search_view_field_map.search_field_id FROM sys_search_view_field_map, sys_search_view_group WHERE sys_search_view_group.id = sys_search_view_field_map.search_group_id AND sys_search_view_field_map.search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46 AND search_view_id != 1) ORDER BY sys_search_view_group.group_display_order ASC, sys_search_view_field_map.sort_id)
[< 1 ms] SELECT search_form_sql, search_form_where_sql, search_form_order_sql FROM sys_search_form WHERE id = (SELECT search_form_id FROM sys_search_comparisson_search WHERE id = 46)
[< 1 ms] SELECT * FROM secure_omg.dead_pages WHERE url = 'http://www.consult.com.au/directory/state-act/' AND expiry > NOW()
[< 1 ms] SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 1 AND cached_rightseq >= 439
[< 1 ms] CREATE TEMPORARY TABLE IF NOT EXISTS norep.businesslisting_temp ( score integer NOT NULL, listing_id integer NOT NULL, zone varchar(100) NULL, verified integer, documents integer, PRIMARY KEY (listing_id), KEY(score))
[< 1 ms] INSERT IGNORE INTO norep.businesslisting_temp VALUES (950, 4002219, 'state', 0, 0),(950, 4018468, 'state', 0, 0),(950, 4022515, 'state', 0, 0),(950, 4044538, 'state', 0, 0),(950, 4044760, 'state', 0, 0),(950, 4069587, 'state', 0, 0),(950, 4085397, 'state', 0, 0),(950, 4091454, 'state', 0, 0),(950, 4103485, 'state', 0, 0),(950, 4103487, 'state', 0, 0),(950, 4112631, 'state', 0, 0),(950, 4126131, 'state', 0, 0),(950, 4133244, 'state', 0, 0),(950, 4221495, 'state', 0, 0),(950, 4230332, 'state', 0, 0),(950, 4244174, 'state', 0, 0),(950, 4290104, 'state', 0, 0),(950, 4305198, 'state', 0, 0),(950, 4337659, 'state', 0, 0),(950, 4349254, 'state', 0, 0),(950, 4351781, 'state', 0, 0),(950, 4355507, 'state', 0, 0),(950, 4365999, 'state', 0, 0),(950, 4366764, 'state', 0, 0),(950, 4394301, 'state', 0, 0),(950, 4414342, 'state', 0, 0),(950, 4451503, 'state', 0, 0),(950, 4454884, 'state', 0, 0),(950, 4526007, 'state', 0, 0),(950, 4579703, 'state', 0, 0),(950, 4596136, 'state', 0, 0),(950, 4653147, 'state', 0, 0),(950, 4668421, 'state', 0, 0),(950, 4685533, 'state', 0, 0),(950, 4692464, 'state', 0, 0),(950, 4732762, 'state', 0, 0),(950, 4734335, 'state', 0, 0),(950, 4740497, 'state', 0, 0),(950, 4747880, 'state', 0, 0),(950, 4767433, 'state', 0, 0),(950, 4768046, 'state', 0, 0),(950, 4800184, 'state', 0, 0),(950, 4800839, 'state', 0, 0),(950, 4810382, 'state', 0, 0),(950, 4815571, 'state', 0, 0),(950, 4821288, 'state', 0, 0),(950, 4893274, 'state', 0, 0),(950, 4912772, 'state', 0, 0),(950, 4930412, 'state', 0, 0),(950, 4934250, 'state', 0, 0),(950, 4939751, 'state', 0, 0),(950, 4974002, 'state', 0, 0),(950, 4976486, 'state', 0, 0),(950, 4990658, 'state', 0, 0),(950, 5010089, 'state', 0, 0),(950, 5011111, 'state', 0, 0),(950, 5019306, 'state', 0, 0),(950, 5051696, 'state', 0, 0),(950, 5066922, 'state', 0, 0),(950, 5068947, 'state', 0, 0),(950, 5080488, 'state', 0, 0),(950, 5096757, 'state', 0, 0),(950, 5099903, 'state', 0, 0),(950, 5113001, 'state', 0, 0),(950, 5130088, 'state', 0, 0),(950, 5149473, 'state', 0, 0),(950, 5182343, 'state', 0, 0),(950, 5199046, 'state', 0, 0),(950, 5218976, 'state', 0, 0),(950, 5232301, 'state', 0, 0),(950, 5240911, 'state', 0, 0),(950, 5253892, 'state', 0, 0),(950, 5262409, 'state', 0, 0),(950, 5279108, 'state', 0, 0),(950, 5324760, 'state', 0, 0),(950, 5346001, 'state', 0, 0),(950, 5358132, 'state', 0, 0),(950, 5393753, 'state', 0, 0),(950, 5403663, 'state', 0, 0),(950, 5421757, 'state', 0, 0),(950, 5433544, 'state', 0, 0),(950, 5485547, 'state', 0, 0),(950, 5494211, 'state', 0, 0),(950, 5494766, 'state', 0, 0),(950, 5503993, 'state', 0, 0),(950, 5505532, 'state', 0, 0),(950, 5538507, 'state', 0, 0),(950, 5546435, 'state', 0, 0),(950, 5564404, 'state', 0, 0),(950, 5576666, 'state', 0, 0),(950, 5590261, 'state', 0, 0),(950, 5606000, 'state', 0, 0),(950, 5608557, 'state', 0, 0),(950, 5631980, 'state', 0, 0),(950, 5634424, 'state', 0, 0),(950, 5654955, 'state', 0, 0),(950, 5662357, 'state', 0, 0),(950, 5690558, 'state', 0, 0),(950, 5694101, 'state', 0, 0),(950, 5697430, 'state', 0, 0),(950, 5750266, 'state', 0, 0),(950, 5760259, 'state', 0, 0),(950, 5786646, 'state', 0, 0),(950, 5803385, 'state', 0, 0),(950, 5814403, 'state', 0, 0),(950, 5824054, 'state', 0, 0),(950, 5846406, 'state', 0, 0),(950, 5858033, 'state', 0, 0),(950, 5928251, 'state', 0, 0),(950, 5930463, 'state', 0, 0),(950, 5941144, 'state', 0, 0),(950, 5941326, 'state', 0, 0),(950, 5946280, 'state', 0, 0),(950, 5948382, 'state', 0, 0),(950, 5949548, 'state', 0, 0),(950, 5958160, 'state', 0, 0),(950, 5959089, 'state', 0, 0),(950, 5965430, 'state', 0, 0),(950, 6193985, 'state', 0, 0),(950, 6197533, 'state', 0, 0),(950, 6199063, 'state', 0, 0),(950, 6202662, 'state', 0, 0),(950, 6235579, 'state', 0, 0),(950, 6236194, 'state', 0, 0),(950, 6237571, 'state', 0, 0),(950, 6238712, 'state', 0, 0),(950, 6242744, 'state', 0, 0),(950, 6260855, 'state', 0, 0),(950, 6264617, 'state', 0, 0),(950, 6272831, 'state', 0, 0),(950, 6288487, 'state', 0, 0),(950, 6296135, 'state', 0, 0),(950, 6297239, 'state', 0, 0),(950, 6360065, 'state', 0, 0)
[< 1 ms] SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"
[< 1 ms] SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8
[< 1 ms] SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8
[< 1 ms] SELECT * FROM boomerang_domains.domain WHERE domain_id = 32848
[< 1 ms] SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"
[< 1 ms] SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8
[< 1 ms] SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8
[359 ms] SELECT * FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20
[6 ms] SELECT COUNT(*) AS total FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50
[< 1 ms] SELECT name FROM sys_search_comparisson_search WHERE id = 46
[< 1 ms] SELECT * FROM sys_objects_tables WHERE co_id = (SELECT object_id FROM sys_search_comparisson_search WHERE id = 46)
[< 1 ms] SELECT output_type FROM sys_search_comparisson_search WHERE id = 46 AND output_type IS NOT NULL
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5218976
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5218976
[9 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5218976
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5941326
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5941326
[4 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5941326
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6235579
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6235579
[2 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6235579
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4747880
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4747880
[< 1 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4747880
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5631980
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5631980
[6 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5631980
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5697430
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5697430
[9 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5697430
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5946280
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5946280
[7 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5946280
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5965430
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5965430
[5 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5965430
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4112631
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4112631
[7 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4112631
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4126131
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4126131
[< 1 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4126131
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4351781
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4351781
[2 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4351781
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6272831
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6272831
[3 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6272831
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4810382
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4810382
[2 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4810382
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5358132
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5358132
[5 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5358132
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5505532
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5505532
[7 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5505532
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5948382
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5948382
[7 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5948382
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4767433
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4767433
[2 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4767433
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5858033
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5858033
[8 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5858033
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6197533
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6197533
[6 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6197533
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4454884
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4454884
[5 ms] SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4454884
[< 1 ms] SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 307;
[< 1 ms] SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 308;
[< 1 ms] INSERT INTO boomerang_ad_logger.log SET uri = 'www.consult.com.au/directory/state-act/', keyword = 'state act', ad_code = 'google - 0 ads', ad_count = '0'
[< 1 ms] SELECT value as state FROM secure_omg.regionmap WHERE type = 'state' ORDER BY value ASC
[10 ms] SELECT scd.categorymap_id, scd.uri, sc.category_title FROM secure_omg.sys_category_domain as scd INNER JOIN secure_omg.sys_category as sc ON sc.category_id = scd.category_co INNER JOIN secure_omg.co_businesslisting_category as cbc ON businesslisting_category_category_co = sc.category_id WHERE domain_id = 32848 AND (sc.category_status = 'active' OR sc.category_status = 'collection') GROUP BY 1 ORDER BY sc.category_title ASC
[< 1 ms] SELECT * FROM sys_search_view_field_map WHERE search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46) ORDER BY sort_id ASC
[< 1 ms] SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 631;

Timers

type	time (ms)	percent
Global execution time	16285.7	100%
PHP	15803.6	97.04%
SQL	482.1	2.96% : 91 queries
message	time (ms)	percent
SELECT domain.domain_id, domain.name, IF(domain.template_id = 0,1,domain.template_id) AS template_id, domain.description AS phrase_break, domain.primary_keyword, domain.redirect, domain.ollority, domain.portfolio_id, template.name AS template_name, domain.navigation_id AS domain_navigation_id, template.navigation_id AS template_navigation_id, domain.last_published, domain.last_modified FROM boomerang_domains.domain LEFT JOIN boomerang_domains.template ON domain.template_id = template.template_id WHERE domain.name = "consult.com.au" AND domain.exclude = 0	< 1 ms	0%
SELECT last_published FROM boomerang_domains.domain where domain_id=32848	< 1 ms	0%
SELECT * FROM boomerang_domains.openx_sites WHERE site_key IN ( 'domain_32848_directory/state-act', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-act', 'group_85_directory', 'group_85_', 'group_263_directory/state-act', 'group_263_directory', 'group_263_', 'group_268_directory/state-act', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-act', 'runofnetwork_0_directory', 'runofnetwork_0_' ) ORDER BY site_priority LIMIT 1	< 1 ms	0.01%
SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 628;	< 1 ms	0%
SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 410;	< 1 ms	0%
SELECT * FROM sys_objects WHERE id = ( SELECT object_id FROM sys_search_comparisson_search WHERE sys_search_comparisson_search.id = 46 )	< 1 ms	0%
SELECT svf.*, IF(NOT svf2.id IS NULL, 1, 0) as is_parent, svf3.field_title as parent_name FROM sys_search_view_field svf LEFT JOIN sys_search_view_field svf2 ON svf.id = svf2.field_parent_id LEFT JOIN sys_search_view_field svf3 ON svf.field_parent_id = svf3.id WHERE svf.id IN ( SELECT sys_search_view_field_map.search_field_id FROM sys_search_view_field_map, sys_search_view_group WHERE sys_search_view_group.id = sys_search_view_field_map.search_group_id AND sys_search_view_field_map.search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46 AND search_view_id != 1) ORDER BY sys_search_view_group.group_display_order ASC, sys_search_view_field_map.sort_id)	< 1 ms	0%
SELECT search_form_sql, search_form_where_sql, search_form_order_sql FROM sys_search_form WHERE id = (SELECT search_form_id FROM sys_search_comparisson_search WHERE id = 46)	< 1 ms	0%
SELECT * FROM secure_omg.dead_pages WHERE url = 'http://www.consult.com.au/directory/state-act/' AND expiry > NOW()	< 1 ms	0%
SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 1 AND cached_rightseq >= 439	< 1 ms	0%
CREATE TEMPORARY TABLE IF NOT EXISTS norep.businesslisting_temp ( score integer NOT NULL, listing_id integer NOT NULL, zone varchar(100) NULL, verified integer, documents integer, PRIMARY KEY (listing_id), KEY(score))	< 1 ms	0%
INSERT IGNORE INTO norep.businesslisting_temp VALUES (950, 4002219, 'state', 0, 0),(950, 4018468, 'state', 0, 0),(950, 4022515, 'state', 0, 0),(950, 4044538, 'state', 0, 0),(950, 4044760, 'state', 0, 0),(950, 4069587, 'state', 0, 0),(950, 4085397, 'state', 0, 0),(950, 4091454, 'state', 0, 0),(950, 4103485, 'state', 0, 0),(950, 4103487, 'state', 0, 0),(950, 4112631, 'state', 0, 0),(950, 4126131, 'state', 0, 0),(950, 4133244, 'state', 0, 0),(950, 4221495, 'state', 0, 0),(950, 4230332, 'state', 0, 0),(950, 4244174, 'state', 0, 0),(950, 4290104, 'state', 0, 0),(950, 4305198, 'state', 0, 0),(950, 4337659, 'state', 0, 0),(950, 4349254, 'state', 0, 0),(950, 4351781, 'state', 0, 0),(950, 4355507, 'state', 0, 0),(950, 4365999, 'state', 0, 0),(950, 4366764, 'state', 0, 0),(950, 4394301, 'state', 0, 0),(950, 4414342, 'state', 0, 0),(950, 4451503, 'state', 0, 0),(950, 4454884, 'state', 0, 0),(950, 4526007, 'state', 0, 0),(950, 4579703, 'state', 0, 0),(950, 4596136, 'state', 0, 0),(950, 4653147, 'state', 0, 0),(950, 4668421, 'state', 0, 0),(950, 4685533, 'state', 0, 0),(950, 4692464, 'state', 0, 0),(950, 4732762, 'state', 0, 0),(950, 4734335, 'state', 0, 0),(950, 4740497, 'state', 0, 0),(950, 4747880, 'state', 0, 0),(950, 4767433, 'state', 0, 0),(950, 4768046, 'state', 0, 0),(950, 4800184, 'state', 0, 0),(950, 4800839, 'state', 0, 0),(950, 4810382, 'state', 0, 0),(950, 4815571, 'state', 0, 0),(950, 4821288, 'state', 0, 0),(950, 4893274, 'state', 0, 0),(950, 4912772, 'state', 0, 0),(950, 4930412, 'state', 0, 0),(950, 4934250, 'state', 0, 0),(950, 4939751, 'state', 0, 0),(950, 4974002, 'state', 0, 0),(950, 4976486, 'state', 0, 0),(950, 4990658, 'state', 0, 0),(950, 5010089, 'state', 0, 0),(950, 5011111, 'state', 0, 0),(950, 5019306, 'state', 0, 0),(950, 5051696, 'state', 0, 0),(950, 5066922, 'state', 0, 0),(950, 5068947, 'state', 0, 0),(950, 5080488, 'state', 0, 0),(950, 5096757, 'state', 0, 0),(950, 5099903, 'state', 0, 0),(950, 5113001, 'state', 0, 0),(950, 5130088, 'state', 0, 0),(950, 5149473, 'state', 0, 0),(950, 5182343, 'state', 0, 0),(950, 5199046, 'state', 0, 0),(950, 5218976, 'state', 0, 0),(950, 5232301, 'state', 0, 0),(950, 5240911, 'state', 0, 0),(950, 5253892, 'state', 0, 0),(950, 5262409, 'state', 0, 0),(950, 5279108, 'state', 0, 0),(950, 5324760, 'state', 0, 0),(950, 5346001, 'state', 0, 0),(950, 5358132, 'state', 0, 0),(950, 5393753, 'state', 0, 0),(950, 5403663, 'state', 0, 0),(950, 5421757, 'state', 0, 0),(950, 5433544, 'state', 0, 0),(950, 5485547, 'state', 0, 0),(950, 5494211, 'state', 0, 0),(950, 5494766, 'state', 0, 0),(950, 5503993, 'state', 0, 0),(950, 5505532, 'state', 0, 0),(950, 5538507, 'state', 0, 0),(950, 5546435, 'state', 0, 0),(950, 5564404, 'state', 0, 0),(950, 5576666, 'state', 0, 0),(950, 5590261, 'state', 0, 0),(950, 5606000, 'state', 0, 0),(950, 5608557, 'state', 0, 0),(950, 5631980, 'state', 0, 0),(950, 5634424, 'state', 0, 0),(950, 5654955, 'state', 0, 0),(950, 5662357, 'state', 0, 0),(950, 5690558, 'state', 0, 0),(950, 5694101, 'state', 0, 0),(950, 5697430, 'state', 0, 0),(950, 5750266, 'state', 0, 0),(950, 5760259, 'state', 0, 0),(950, 5786646, 'state', 0, 0),(950, 5803385, 'state', 0, 0),(950, 5814403, 'state', 0, 0),(950, 5824054, 'state', 0, 0),(950, 5846406, 'state', 0, 0),(950, 5858033, 'state', 0, 0),(950, 5928251, 'state', 0, 0),(950, 5930463, 'state', 0, 0),(950, 5941144, 'state', 0, 0),(950, 5941326, 'state', 0, 0),(950, 5946280, 'state', 0, 0),(950, 5948382, 'state', 0, 0),(950, 5949548, 'state', 0, 0),(950, 5958160, 'state', 0, 0),(950, 5959089, 'state', 0, 0),(950, 5965430, 'state', 0, 0),(950, 6193985, 'state', 0, 0),(950, 6197533, 'state', 0, 0),(950, 6199063, 'state', 0, 0),(950, 6202662, 'state', 0, 0),(950, 6235579, 'state', 0, 0),(950, 6236194, 'state', 0, 0),(950, 6237571, 'state', 0, 0),(950, 6238712, 'state', 0, 0),(950, 6242744, 'state', 0, 0),(950, 6260855, 'state', 0, 0),(950, 6264617, 'state', 0, 0),(950, 6272831, 'state', 0, 0),(950, 6288487, 'state', 0, 0),(950, 6296135, 'state', 0, 0),(950, 6297239, 'state', 0, 0),(950, 6360065, 'state', 0, 0)	< 1 ms	0.01%
SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"	< 1 ms	0%
SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8	< 1 ms	0%
SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8	< 1 ms	0%
SELECT * FROM boomerang_domains.domain WHERE domain_id = 32848	< 1 ms	0%
SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"	< 1 ms	0%
SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8	< 1 ms	0%
SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8	< 1 ms	0%
SELECT * FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20	359 ms	2.2%
SELECT COUNT(*) AS total FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50	6 ms	0.03%
SELECT name FROM sys_search_comparisson_search WHERE id = 46	< 1 ms	0%
SELECT * FROM sys_objects_tables WHERE co_id = (SELECT object_id FROM sys_search_comparisson_search WHERE id = 46)	< 1 ms	0%
SELECT output_type FROM sys_search_comparisson_search WHERE id = 46 AND output_type IS NOT NULL	< 1 ms	0%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5218976	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5218976	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5218976	9 ms	0.05%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5941326	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5941326	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5941326	4 ms	0.02%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6235579	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6235579	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6235579	2 ms	0.01%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4747880	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4747880	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4747880	< 1 ms	0%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5631980	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5631980	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5631980	6 ms	0.04%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5697430	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5697430	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5697430	9 ms	0.06%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5946280	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5946280	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5946280	7 ms	0.04%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5965430	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5965430	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5965430	5 ms	0.03%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4112631	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4112631	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4112631	7 ms	0.05%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4126131	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4126131	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4126131	< 1 ms	0%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4351781	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4351781	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4351781	2 ms	0.01%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6272831	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6272831	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6272831	3 ms	0.02%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4810382	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4810382	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4810382	2 ms	0.01%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5358132	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5358132	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5358132	5 ms	0.03%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5505532	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5505532	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5505532	7 ms	0.04%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5948382	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5948382	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5948382	7 ms	0.04%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4767433	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4767433	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4767433	2 ms	0.01%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5858033	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5858033	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5858033	8 ms	0.05%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6197533	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6197533	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 6197533	6 ms	0.03%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4454884	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4454884	< 1 ms	0%
SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 4454884	5 ms	0.03%
SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 307;	< 1 ms	0%
SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 308;	< 1 ms	0%
INSERT INTO boomerang_ad_logger.log SET uri = 'www.consult.com.au/directory/state-act/', keyword = 'state act', ad_code = 'google - 0 ads', ad_count = '0'	< 1 ms	0%
SELECT value as state FROM secure_omg.regionmap WHERE type = 'state' ORDER BY value ASC	< 1 ms	0%
SELECT scd.categorymap_id, scd.uri, sc.category_title FROM secure_omg.sys_category_domain as scd INNER JOIN secure_omg.sys_category as sc ON sc.category_id = scd.category_co INNER JOIN secure_omg.co_businesslisting_category as cbc ON businesslisting_category_category_co = sc.category_id WHERE domain_id = 32848 AND (sc.category_status = 'active' OR sc.category_status = 'collection') GROUP BY 1 ORDER BY sc.category_title ASC	10 ms	0.06%
SELECT * FROM sys_search_view_field_map WHERE search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46) ORDER BY sort_id ASC	< 1 ms	0%
SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 631;	< 1 ms	0%

type

time (ms)

percent

Global execution time

16285.7

100%

PHP

15803.6

97.04%

SQL

482.1

2.96% : 91 queries

message

time (ms)

percent

SELECT domain.domain_id, domain.name, IF(domain.template_id = 0,1,domain.template_id) AS template_id, domain.description AS phrase_break, domain.primary_keyword, domain.redirect, domain.ollority, domain.portfolio_id, template.name AS template_name, domain.navigation_id AS domain_navigation_id, template.navigation_id AS template_navigation_id, domain.last_published, domain.last_modified FROM boomerang_domains.domain LEFT JOIN boomerang_domains.template ON domain.template_id = template.template_id WHERE domain.name = "consult.com.au" AND domain.exclude = 0

< 1 ms

SELECT last_published FROM boomerang_domains.domain where domain_id=32848

< 1 ms

SELECT * FROM boomerang_domains.openx_sites WHERE site_key IN ( 'domain_32848_directory/state-act', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-act', 'group_85_directory', 'group_85_', 'group_263_directory/state-act', 'group_263_directory', 'group_263_', 'group_268_directory/state-act', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-act', 'runofnetwork_0_directory', 'runofnetwork_0_' ) ORDER BY site_priority LIMIT 1

< 1 ms

0.01%

SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 628;

< 1 ms

SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 410;

< 1 ms

SELECT * FROM sys_objects WHERE id = ( SELECT object_id FROM sys_search_comparisson_search WHERE sys_search_comparisson_search.id = 46 )

< 1 ms

SELECT svf.*, IF(NOT svf2.id IS NULL, 1, 0) as is_parent, svf3.field_title as parent_name FROM sys_search_view_field svf LEFT JOIN sys_search_view_field svf2 ON svf.id = svf2.field_parent_id LEFT JOIN sys_search_view_field svf3 ON svf.field_parent_id = svf3.id WHERE svf.id IN ( SELECT sys_search_view_field_map.search_field_id FROM sys_search_view_field_map, sys_search_view_group WHERE sys_search_view_group.id = sys_search_view_field_map.search_group_id AND sys_search_view_field_map.search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46 AND search_view_id != 1) ORDER BY sys_search_view_group.group_display_order ASC, sys_search_view_field_map.sort_id)

< 1 ms

SELECT search_form_sql, search_form_where_sql, search_form_order_sql FROM sys_search_form WHERE id = (SELECT search_form_id FROM sys_search_comparisson_search WHERE id = 46)

< 1 ms

SELECT * FROM secure_omg.dead_pages WHERE url = 'http://www.consult.com.au/directory/state-act/' AND expiry > NOW()

< 1 ms

SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 1 AND cached_rightseq >= 439

< 1 ms

CREATE TEMPORARY TABLE IF NOT EXISTS norep.businesslisting_temp ( score integer NOT NULL, listing_id integer NOT NULL, zone varchar(100) NULL, verified integer, documents integer, PRIMARY KEY (listing_id), KEY(score))

< 1 ms

INSERT IGNORE INTO norep.businesslisting_temp VALUES (950, 4002219, 'state', 0, 0),(950, 4018468, 'state', 0, 0),(950, 4022515, 'state', 0, 0),(950, 4044538, 'state', 0, 0),(950, 4044760, 'state', 0, 0),(950, 4069587, 'state', 0, 0),(950, 4085397, 'state', 0, 0),(950, 4091454, 'state', 0, 0),(950, 4103485, 'state', 0, 0),(950, 4103487, 'state', 0, 0),(950, 4112631, 'state', 0, 0),(950, 4126131, 'state', 0, 0),(950, 4133244, 'state', 0, 0),(950, 4221495, 'state', 0, 0),(950, 4230332, 'state', 0, 0),(950, 4244174, 'state', 0, 0),(950, 4290104, 'state', 0, 0),(950, 4305198, 'state', 0, 0),(950, 4337659, 'state', 0, 0),(950, 4349254, 'state', 0, 0),(950, 4351781, 'state', 0, 0),(950, 4355507, 'state', 0, 0),(950, 4365999, 'state', 0, 0),(950, 4366764, 'state', 0, 0),(950, 4394301, 'state', 0, 0),(950, 4414342, 'state', 0, 0),(950, 4451503, 'state', 0, 0),(950, 4454884, 'state', 0, 0),(950, 4526007, 'state', 0, 0),(950, 4579703, 'state', 0, 0),(950, 4596136, 'state', 0, 0),(950, 4653147, 'state', 0, 0),(950, 4668421, 'state', 0, 0),(950, 4685533, 'state', 0, 0),(950, 4692464, 'state', 0, 0),(950, 4732762, 'state', 0, 0),(950, 4734335, 'state', 0, 0),(950, 4740497, 'state', 0, 0),(950, 4747880, 'state', 0, 0),(950, 4767433, 'state', 0, 0),(950, 4768046, 'state', 0, 0),(950, 4800184, 'state', 0, 0),(950, 4800839, 'state', 0, 0),(950, 4810382, 'state', 0, 0),(950, 4815571, 'state', 0, 0),(950, 4821288, 'state', 0, 0),(950, 4893274, 'state', 0, 0),(950, 4912772, 'state', 0, 0),(950, 4930412, 'state', 0, 0),(950, 4934250, 'state', 0, 0),(950, 4939751, 'state', 0, 0),(950, 4974002, 'state', 0, 0),(950, 4976486, 'state', 0, 0),(950, 4990658, 'state', 0, 0),(950, 5010089, 'state', 0, 0),(950, 5011111, 'state', 0, 0),(950, 5019306, 'state', 0, 0),(950, 5051696, 'state', 0, 0),(950, 5066922, 'state', 0, 0),(950, 5068947, 'state', 0, 0),(950, 5080488, 'state', 0, 0),(950, 5096757, 'state', 0, 0),(950, 5099903, 'state', 0, 0),(950, 5113001, 'state', 0, 0),(950, 5130088, 'state', 0, 0),(950, 5149473, 'state', 0, 0),(950, 5182343, 'state', 0, 0),(950, 5199046, 'state', 0, 0),(950, 5218976, 'state', 0, 0),(950, 5232301, 'state', 0, 0),(950, 5240911, 'state', 0, 0),(950, 5253892, 'state', 0, 0),(950, 5262409, 'state', 0, 0),(950, 5279108, 'state', 0, 0),(950, 5324760, 'state', 0, 0),(950, 5346001, 'state', 0, 0),(950, 5358132, 'state', 0, 0),(950, 5393753, 'state', 0, 0),(950, 5403663, 'state', 0, 0),(950, 5421757, 'state', 0, 0),(950, 5433544, 'state', 0, 0),(950, 5485547, 'state', 0, 0),(950, 5494211, 'state', 0, 0),(950, 5494766, 'state', 0, 0),(950, 5503993, 'state', 0, 0),(950, 5505532, 'state', 0, 0),(950, 5538507, 'state', 0, 0),(950, 5546435, 'state', 0, 0),(950, 5564404, 'state', 0, 0),(950, 5576666, 'state', 0, 0),(950, 5590261, 'state', 0, 0),(950, 5606000, 'state', 0, 0),(950, 5608557, 'state', 0, 0),(950, 5631980, 'state', 0, 0),(950, 5634424, 'state', 0, 0),(950, 5654955, 'state', 0, 0),(950, 5662357, 'state', 0, 0),(950, 5690558, 'state', 0, 0),(950, 5694101, 'state', 0, 0),(950, 5697430, 'state', 0, 0),(950, 5750266, 'state', 0, 0),(950, 5760259, 'state', 0, 0),(950, 5786646, 'state', 0, 0),(950, 5803385, 'state', 0, 0),(950, 5814403, 'state', 0, 0),(950, 5824054, 'state', 0, 0),(950, 5846406, 'state', 0, 0),(950, 5858033, 'state', 0, 0),(950, 5928251, 'state', 0, 0),(950, 5930463, 'state', 0, 0),(950, 5941144, 'state', 0, 0),(950, 5941326, 'state', 0, 0),(950, 5946280, 'state', 0, 0),(950, 5948382, 'state', 0, 0),(950, 5949548, 'state', 0, 0),(950, 5958160, 'state', 0, 0),(950, 5959089, 'state', 0, 0),(950, 5965430, 'state', 0, 0),(950, 6193985, 'state', 0, 0),(950, 6197533, 'state', 0, 0),(950, 6199063, 'state', 0, 0),(950, 6202662, 'state', 0, 0),(950, 6235579, 'state', 0, 0),(950, 6236194, 'state', 0, 0),(950, 6237571, 'state', 0, 0),(950, 6238712, 'state', 0, 0),(950, 6242744, 'state', 0, 0),(950, 6260855, 'state', 0, 0),(950, 6264617, 'state', 0, 0),(950, 6272831, 'state', 0, 0),(950, 6288487, 'state', 0, 0),(950, 6296135, 'state', 0, 0),(950, 6297239, 'state', 0, 0),(950, 6360065, 'state', 0, 0)

< 1 ms

0.01%

SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"

< 1 ms

SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8

< 1 ms

SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8

< 1 ms

SELECT * FROM boomerang_domains.domain WHERE domain_id = 32848

< 1 ms

SELECT GROUP_CONCAT(regionmap_id SEPARATOR ",") AS regions FROM secure_omg.regionmap WHERE type = "state"

< 1 ms

SELECT type, value, uri FROM secure_omg.regionmap WHERE regionmap_id IN (1,2,3,4,5,6,7,8) LIMIT 8

< 1 ms

SELECT DISTINCT category_id FROM secure_omg.co_businesslisting_catloc_density WHERE regionmap_id = AND category_id > 1 LIMIT 8

< 1 ms

SELECT * FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20

359 ms

2.2%

SELECT COUNT(*) AS total FROM secure_omg.co_businesslisting l INNER JOIN norep.businesslisting_temp t ON t.listing_id = l.businesslisting_id WHERE (businesslisting_cstatus IN ('active', 'paymentpending') AND businesslisting_ostatus IN ('new', 'active', 'claim_pending')) AND businesslisting_id NOT IN (5880036) ORDER BY IF(zone='suburb' OR zone='area', 0, 1), score DESC , IF(LOWER(businesslisting_suburb) = 'act', 0, 1) , ((businesslisting_id + 50) - 75) % 50

6 ms

0.03%

SELECT name FROM sys_search_comparisson_search WHERE id = 46

< 1 ms

SELECT * FROM sys_objects_tables WHERE co_id = (SELECT object_id FROM sys_search_comparisson_search WHERE id = 46)

< 1 ms

SELECT output_type FROM sys_search_comparisson_search WHERE id = 46 AND output_type IS NOT NULL

< 1 ms

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5218976

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5218976

< 1 ms

SELECT category_title FROM secure_omg.sys_category, secure_omg.co_businesslisting_category WHERE category_id = businesslisting_category_category_co AND businesslisting_category_businesslisting_co = 5218976

9 ms

0.05%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5941326

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5941326

< 1 ms

4 ms

0.02%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6235579

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6235579

< 1 ms

2 ms

0.01%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4747880

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4747880

< 1 ms

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5631980

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5631980

< 1 ms

6 ms

0.04%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5697430

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5697430

< 1 ms

9 ms

0.06%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5946280

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5946280

< 1 ms

7 ms

0.04%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5965430

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5965430

< 1 ms

5 ms

0.03%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4112631

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4112631

< 1 ms

7 ms

0.05%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4126131

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4126131

< 1 ms

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4351781

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4351781

< 1 ms

2 ms

0.01%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6272831

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6272831

< 1 ms

3 ms

0.02%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4810382

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4810382

< 1 ms

2 ms

0.01%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5358132

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5358132

< 1 ms

5 ms

0.03%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5505532

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5505532

< 1 ms

7 ms

0.04%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5948382

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5948382

< 1 ms

7 ms

0.04%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4767433

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4767433

< 1 ms

2 ms

0.01%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5858033

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5858033

< 1 ms

8 ms

0.05%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 6197533

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 6197533

< 1 ms

6 ms

0.03%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 4454884

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 4454884

< 1 ms

5 ms

0.03%

SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 307;

< 1 ms

SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 308;

< 1 ms

INSERT INTO boomerang_ad_logger.log SET uri = 'www.consult.com.au/directory/state-act/', keyword = 'state act', ad_code = 'google - 0 ads', ad_count = '0'

< 1 ms

SELECT value as state FROM secure_omg.regionmap WHERE type = 'state' ORDER BY value ASC

< 1 ms

SELECT scd.categorymap_id, scd.uri, sc.category_title FROM secure_omg.sys_category_domain as scd INNER JOIN secure_omg.sys_category as sc ON sc.category_id = scd.category_co INNER JOIN secure_omg.co_businesslisting_category as cbc ON businesslisting_category_category_co = sc.category_id WHERE domain_id = 32848 AND (sc.category_status = 'active' OR sc.category_status = 'collection') GROUP BY 1 ORDER BY sc.category_title ASC

10 ms

0.06%

SELECT * FROM sys_search_view_field_map WHERE search_view_id = (SELECT search_view_id FROM sys_search_comparisson_search WHERE id = 46) ORDER BY sort_id ASC

< 1 ms

SELECT `thing_id`, `name`, `content` FROM `boomerang_stuff`.`thing` WHERE `thing_id` = 631;

< 1 ms

User Login

ACT Directory

126 listings found

Directory Map

Business Location

Refine Search Results

Category

Location / Area

Company

Location

Configuration and request variables

Request

Response

Settings

Constants

Globals

Php

Files

Log and debug messages

Database / SQL queries

W3C validation

Timers

User Login

ACT Directory

126 listings found

Directory Map

Business Location

Advertise with Consult.com.au

Refine Search Results

Category

Location / Area

Company

Location

Configuration and request variables

Request

Response

Settings

Constants

Globals

Php

Files

Log and debug messages

Database / SQL queries

W3C validation

Timers