Plumber Sydney

Sydney,NSW,2000

Looking for a plumber in Sydney? Metropolitan Plumbing have Plumber Sydney ready to remedy your plumbing or drainage

Plumbing & Gasfitting

Adelaide suburban plumbing

Plumbing Services

General Plumbing Plumbing & Gasfitting

Plumber Sydney

Sydney,NSW,2000

There’s a kind of hush all over Sydney, the kind of hush which means the toilets won’t flush. There is

Plumbing & Gasfitting

Enviro Plus Plumbing

Aberfoyle park,SA,5159

Enviro Plus Plumbing - "More than just plumbing !" A small family based "Plumbing & Gas Fitting" business servicing customers

Bathroom Renovations Building & Strata Maintenance Commercial Waste Gas Fitting & Piping General Plumbing Home Renovations Hot Water Systems Plumbing & Gasfitting Property Maintenance Renovations & Extensions

All phase plumbing p/l

Plumbing,drainage and gas fitting

Plumbing & Gasfitting

ISINITBITS

Melbourne,VIC,3000

INSTANT BOILING WATER UNIT REPAIRS. ALL MAKES AND MODELS. CHILLERS AND BOILERS. FILTERS CHANGED. SERVICING (ZIP, BIRKO, WHEELAN, CROWN, RHEEM, WILSON, HAVVA CUPPA, BILLI,

General Plumbing

Plumbmaster Plumbing

Riverstone,NSW,2765

Plumbmaster Plumbing are a locally based business providing you with a honest, reliable plumbing service. We specialise in all areas

Bathroom Renovations Building & Strata Maintenance Gas Fitting & Piping General Plumbing Guttering Home Renovations Hot Water Systems Kitchen Renovations Plumbing & Gasfitting Renovations & Extensions

You Plumbing

Bronte,NSW,2024

Australia's Most Trusted Plumbing Service and Products Supplier YOU PLUMBING is your one-stop shop for great hot water systems, bathroom, kitchen,

Bathroom Renovations Fixtures & Fittings Gas Fitting & Piping General Plumbing Home Renovations Kitchen Renovations Plumbing & Gasfitting Renovations & Extensions

Wee Plumb

Nerang,QLD,4211

Wee Plumb Bidets :)

If you have been interested in an Electronic Bidet, but are not sure if it will Suite

General Plumbing

Mad 4 It Plumbing

Cranebrook,NSW,2749

Your Local Plumber.Repairs and maintenance on all systems With over 12 years experience i can help manage all your plumbing needs. Services

Bathroom Renovations Gas Fitting & Piping General Plumbing Hot Water Systems Kitchen Appliance Repair Kitchen Renovations Plumbing & Gasfitting Roof Repairs Water Recycling

  BENCHMARKS  
Loading Time: Base Classes  0.0052
Controller Execution Time ( Search / Index )  0.3282
Total Execution Time  0.3334
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,556,240 bytes
  POST DATA  
No POST data exists
  URI STRING  
service/plumbing-gasfitting
  CLASS/METHOD  
search/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0004   SELECT *
FROM (`settings`) 
0.0005   SELECT *
FROM (`categories`)
WHERE `url` =  'plumbing-gasfitting' 
0.0002   SELECT `c`.`id`, `c`.`name`
FROM (`categoriesc)
WHERE `c`.`idIN ('265')  
0.0172   SELECT s.ids.names.descriptions.random_codes.urlua.postcodeCONCAT_WS(', 'ua.street_addresssu.nameua.postcode) AS addressGROUP_CONCAT(DISTINCT c.name ORDER BY c.name SEPARATOR ', ') AS categoriesm.random_code as image_codeavg(ra.rating_number) rating
FROM 
(`service_profiless)
JOIN `service_profile_categoriessc ON `sc`.`service_profile_id` = `s`.`id`
JOIN `service_profile_categoriessci ON `sci`.`service_profile_id` = `s`.`id`
JOIN `user_accountsua ON `ua`.`id` = `s`.`user_idAND ua.verified 1
LEFT JOIN 
`service_profiles_suburbsss ON `ss`.`service_profile_id` = `s`.`id`
LEFT JOIN `service_profile_addressessa ON `sa`.`service_profile_id` = `s`.`id`
LEFT JOIN `suburbssu ON `su`.`id` = `ua`.`suburb_id`
LEFT JOIN `suburbssua ON `sua`.`id` = `sa`.`suburb_id`
JOIN `categoriesON `c`.`id` = `sc`.`category_id`
LEFT JOIN `mediaAS ON `m`.`id` = `s`.`profile_image_id`
LEFT JOIN `reviewsON `r`.`service_provider_user_id` = `s`.`user_idAND r.active 1
LEFT JOIN 
`ratingsra ON `ra`.`review_id` = `r`.`id`
WHERE (sci.category_id IN ('265') OR c.parent_id IN ('265'))
AND `
s`.`active` = 1
GROUP BY 
`s`.`user_id`
ORDER BY `ratingDESC
LIMIT 10 
0.0007   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1386'
ORDER BY `idDESC 
0.0003   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1387'
ORDER BY `idDESC 
0.0003   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1435'
ORDER BY `idDESC 
0.0003   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1446'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1447'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1448'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1457'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1464'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1479'
ORDER BY `idDESC 
0.0002   SELECT service_profile_addresses.idservice_profile_addresses.postcodestreet_addresscountry.name country_namesuburbs.id suburb_idsuburbs.name suburb_namestates.id state_idstates.name state_namestates.shortnameCONCAT(suburbs.name'-'suburbs.postcode'('states.shortname')') AS suburb_text
FROM 
(`service_profile_addresses`)
JOIN `suburbsON `suburbs`.`id` = `service_profile_addresses`.`suburb_id`
JOIN `statesON `states`.`id` = `service_profile_addresses`.`state_id`
JOIN `countryON `country`.`country_code` = `service_profile_addresses`.`country_code`
WHERE `service_profile_id` =  '1489'
ORDER BY `idDESC 
0.0003   SELECT *
FROM (`settings`) 
0.0003   SELECT
                 user_accounts
.id as user_id,
                 
first_name,
                 
last_name,
                 
email,
                 
service_provider
                FROM
                    sessions
                    JOIN user_accounts ON
                      sessions
.user_id user_accounts.id
                WHERE
                    sessions
.active AND sessions.expiry NOW() AND
                    
sessions.id ='0534380582b8f5ab837d23a775baa6af' 
0.0002   SELECT
                 user_accounts
.id as user_id,
                 
first_name,
                 
last_name,
                 
email,
                 
service_provider
                FROM
                    sessions
                    JOIN user_accounts ON
                      sessions
.user_id user_accounts.id
                WHERE
                    sessions
.active AND sessions.expiry NOW() AND
                    
sessions.id ='0534380582b8f5ab837d23a775baa6af' 
0.0006   SELECT `M`.`msg_group_id`
                
FROM (`messagesM)
                
JOIN (SELECT  `MSS`.`msg_group_id`,
                    
MAX(`MSS`.`msg_id`) msg_id,                
                    
MAX(`MSS`.`created`) created
                    
Count(MSS.msg_group_id) AS child_count 
                    FROM 
(`messagesMSS) 
                    
WHERE MSS.read_status='Unread' AND (MSS.sender_deleted != '' AND MSS.reciever_deleted != '' )  
                    
GROUP BY `MSS`.`msg_group_id`   ) MSG 
                ON MSG
.msg_group_id=`M`.`msg_group_id`  AND M.created MSG.`created
                
JOIN `messagesMS ON `MS`.`msg_id` = `M`.`msg_group_id
                
WHERE  (`M`.`msg_to` =  '' OR `M`.`msg_from` =  '' ) AND NOT (MSG.child_count AND `M`.`msg_from` = '' )  
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)