Shirecare
ABN:93296723595 (Check ABN)
P: 0422505065
john@shirecare.net.au
Facebook Facebook

Shirecare

Services Regular Pool Maintenance From $40.00 Casual Pool Cleaning Services From $50.00 Equipment Upgrades & Servicing Green Pool Cleaning. Pool Equipment Fault Finding Pool Plumbing Repairs Pool Heating Quotes Obligation Free New Light Installation and Repairs to the old ones Pump Repairs Pool Covers and Roller Installation and Supply Home Delivery of any chemicals call up for a quote today! New Pool Owner handover, learn everything you need to know about a swimming pool! All equipment new Equipment Quote Obligation Free!

Services provided Pool Cleaning Pool Gates Pool Maintenance Pools & Spas
Service Areas Alfords point-2234(NSW) Bangor-2234(NSW) Barden ridge-2234(NSW) Blakehurst-2221(NSW) Bonnet bay-2226(NSW) Brighton-le-sands-2216(NSW) Bundeena-2230(NSW) Burraneer-2230(NSW) Caringbah-2229(NSW) Carss park-2221(NSW) Como-2226(NSW) Connells point-2221(NSW) Cronulla-2230(NSW) Dolans bay-2229(NSW) Dolls point-2219(NSW) Engadine-2233(NSW) Grays point-2232(NSW) Gymea-2227(NSW) Gymea bay-2227(NSW) Heathcote-2233(NSW) Hurstville-2220(NSW) Hurstville grove-2220(NSW) Illawong-2234(NSW) Jannali-2226(NSW) Kangaroo point-2224(NSW) Kareela-2232(NSW) Kirrawee-2232(NSW) Kurnell-2231(NSW) Kyle bay-2221(NSW) Lilli pilli-2229(NSW) Loftus-2232(NSW) Lucas heights-2234(NSW) Maianbar-2230(NSW) Menai-2234(NSW) Miranda-2228(NSW) Monterey-2217(NSW) Oyster bay-2225(NSW) Port hacking-2229(NSW) Ramsgate-2217(NSW) Ramsgate beach-2217(NSW) Sandy point-2172(NSW) Sans souci-2219(NSW) South hurstville-2221(NSW) Sutherland-2232(NSW) Sylvania-2224(NSW) Sylvania southgate-2224(NSW) Sylvania waters-2224(NSW) Taren point-2229(NSW) Waterfall-2233(NSW) Woolooware-2230(NSW) Woronora-2232(NSW) Woronora dam-2508(NSW) Woronora heights-2233(NSW) Yarrawarrah-2233(NSW) Yowie bay-2228(NSW)
Licenses & Certificates

No addresses

  BENCHMARKS  
Loading Time: Base Classes  0.0086
Controller Execution Time ( Profile / Index )  0.2386
Total Execution Time  0.2473
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,864,016 bytes
  POST DATA  
No POST data exists
  URI STRING  
profile/80915/shirecare
  CLASS/METHOD  
profile/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0004   SELECT *
FROM (`settings`) 
0.0005   SELECT `p`.*, `m`.`random_code` as image_code
FROM 
(`service_profiles` as p)
LEFT JOIN `mediaAS ON `m`.`id` = `p`.`profile_image_id`
WHERE `p`.`random_code` =  '80915'
AND `url` =  'shirecare' 
0.0007   SELECT *
FROM (`service_profile_categories`)
JOIN `categoriesON `categories`.`id` = `service_profile_categories`.`category_id`
WHERE `service_profile_id` =  '1400'
ORDER BY `categories`.`nameasc 
0.0025   SELECT service_profiles_suburbs.suburb_idsuburbs.nameconcat(suburbs.name'-'suburbs.postcode'('states.shortname')') as descriptionstates.shortnamesuburbs.postcode
FROM 
(`service_profiles_suburbs`)
JOIN `suburbsON `suburbs`.`id` = `service_profiles_suburbs`.`suburb_id`
JOIN `statesON `states`.`id` = `suburbs`.`state_id`
WHERE `service_profile_id` =  '1400'
ORDER BY `states`.`shortnameasc, `suburbs`.`nameasc 
0.0005   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` =  '1400'
ORDER BY `idDESC 
0.0003   SELECT `l`.`id`, `l`.`license_body_id`, `l`.`value`, `b`.`name`
FROM (`service_profile_licensesl)
JOIN `license_bodiesON `b`.`id` = `l`.`license_body_id`
WHERE `l`.`service_profile_id` =  '1400' 
0.0003   SELECT *
FROM (`service_profile_links`)
WHERE `service_profile_id` =  '1400' 
0.0005   SELECT `id`, `name`
FROM (`categories`)
WHERE `parent_id` =  
0.0004   SELECT idparent_idname FROM categories WHERE parent_id != 
0.0006   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 ='7b170f9c0df94661458fbafa3091fd88' 
0.0001   SELECT `id`
FROM (`reviews`)
WHERE `customer_user_idIS NULL
AND `service_provider_user_id` =  '6411'
AND `job_id` =  
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 ='7b170f9c0df94661458fbafa3091fd88' 
0.0002   SELECT `id`, `label`
FROM (`rating_criteria`) 
0.0004   SELECT `RC`.`id`, `RC`.`label`, AVG(`RR`.`rating_number`) AS rating_number
FROM 
(`ratingsRR)
JOIN `reviewsON `R`.`id` = `RR`.`review_id`
JOIN `rating_criteriaRC ON `RC`.`id` = `RR`.`rating_id`
WHERE `RR`.`service_provider_user_id` =  '6411'
AND `R`.`active` =  '1'
GROUP BY `RR`.`rating_id
0.0002   SELECT *
FROM (`settings`) 
0.0004   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 ='7b170f9c0df94661458fbafa3091fd88' 
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 ='7b170f9c0df94661458fbafa3091fd88' 
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)