SA Directory

2 listings found

Home > SA

There were no suburb level results...

MAPA

Extend Building Services
P.O Box 305, Unley, SA 5061

Phone Number

*Please mention that you found them on consult.com.au

View Details

MAPB

Renown Building Designs
7 Tait St, Renown Park, SA 5008

Phone Number

*Please mention that you found them on consult.com.au

View Details

Constants

(30) :

Globals

Php

Files

Log and debug messages

#	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 = 'sa' ) [value] => Array ( [0] => state-sa ) [operand] => OR [sphinx] => Array ( [attrs] => businesslisting_state [value] => sa ) ) [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] => sa [state] => [postcode] => ) [1] => Array ( [loc] => [state] => sa [postcode] => ) )
# 12	Variable dump	businesslisting_search.php	865	businesslisting_search	buildQuery()	dump of 'Sphinx Search Term' (string) : (@listing_document dom_32848 ) @location_document (state_5)
# 13	PHP error	comp_objects.class.php	2460	comp_objects	generate_result_rows2()	PHP notice : Undefined variable: title
# 14	PHP error	functions.inc.php	10		somg_stats_beacon()	PHP notice : Undefined index: tracker_omg
# 15	PHP error	functions.inc.php	10		somg_stats_beacon()	PHP notice : Undefined index: tracker_omg
# 16	PHP error	core.class.php	178	core	setModules()	PHP notice : Undefined property: stdClass::$write_cache
# 17	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 18	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 19	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 20	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 21	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 22	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 23	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 24	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompiledEval: 1 object left on the stack /!\
# 25	PHP error			XSLTProcessor	transformToXml()	/!\ PHP WARNING : XSLTProcessor::transformToXml() [function.XSLTProcessor-transformToXml]: xmlXPathCompOpEval: function functionString bound to undefined prefix php /!\
# 26	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-sa', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-sa', 'group_85_directory', 'group_85_', 'group_263_directory/state-sa', 'group_263_directory', 'group_263_', 'group_268_directory/state-sa', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-sa', '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-sa/' AND expiry > NOW()
[< 1 ms] SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 27177 AND cached_rightseq >= 31991
[< 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 (1000950, 5912331, 'state', 0, 0),(1000950, 5917700, '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
[< 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) = 'sa', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20
[< 1 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) = 'sa', 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 = 5912331
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5912331
[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 = 5912331
[< 1 ms] SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5917700
[< 1 ms] SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5917700
[< 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 = 5917700
[< 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-sa/', keyword = 'state sa', 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
[57 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	8830.4	100%
PHP	8763.8	99.25%
SQL	66.6	0.75% : 37 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-sa', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-sa', 'group_85_directory', 'group_85_', 'group_263_directory/state-sa', 'group_263_directory', 'group_263_', 'group_268_directory/state-sa', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-sa', 'runofnetwork_0_directory', 'runofnetwork_0_' ) ORDER BY site_priority LIMIT 1	< 1 ms	0.02%
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-sa/' AND expiry > NOW()	< 1 ms	0%
SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 27177 AND cached_rightseq >= 31991	< 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.01%
INSERT IGNORE INTO norep.businesslisting_temp VALUES (1000950, 5912331, 'state', 0, 0),(1000950, 5917700, 'state', 0, 0)	< 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.01%
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) = 'sa', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20	< 1 ms	0.01%
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) = 'sa', 0, 1) , ((businesslisting_id + 50) - 75) % 50	< 1 ms	0%
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 = 5912331	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5912331	< 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 = 5912331	3 ms	0.04%
SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5917700	< 1 ms	0%
SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5917700	< 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 = 5917700	< 1 ms	0%
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-sa/', keyword = 'state sa', 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	57 ms	0.64%
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

8830.4

100%

PHP

8763.8

99.25%

SQL

66.6

0.75% : 37 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-sa', 'domain_32848_directory', 'domain_32848_', 'group_85_directory/state-sa', 'group_85_directory', 'group_85_', 'group_263_directory/state-sa', 'group_263_directory', 'group_263_', 'group_268_directory/state-sa', 'group_268_directory', 'group_268_', 'runofnetwork_0_directory/state-sa', 'runofnetwork_0_directory', 'runofnetwork_0_' ) ORDER BY site_priority LIMIT 1

< 1 ms

0.02%

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-sa/' AND expiry > NOW()

< 1 ms

SELECT * FROM secure_omg.regionmap WHERE cached_leftseq <= 27177 AND cached_rightseq >= 31991

< 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

0.01%

INSERT IGNORE INTO norep.businesslisting_temp VALUES (1000950, 5912331, 'state', 0, 0),(1000950, 5917700, '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

0.01%

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) = 'sa', 0, 1) , ((businesslisting_id + 50) - 75) % 50 LIMIT 0, 20

< 1 ms

0.01%

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) = 'sa', 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 = 5912331

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5912331

< 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 = 5912331

3 ms

0.04%

SELECT * FROM secure_omg.co_businesslisting_files WHERE businesslisting_files_businesslisting_co = 5917700

< 1 ms

SELECT * FROM secure_omg.coupons WHERE business_listing_id = 5917700

< 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-sa/', keyword = 'state sa', 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

57 ms

0.64%

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

SA Directory

2 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

SA Directory

2 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