OZI GREEN PROPERTY SERVICE
ABN:32965700551 (Check ABN)
P: 0431366611
michaeldib70@optusnet.com
Facebook

OZI GREEN PROPERTY SERVICE

LAWN MOWING ⁄ WHIPPERSNIPING ⁄ BRUSH-CUTTING ⁄ CHAINSAW ⁄ HEDGING ⁄ EDGING ⁄ WEED CONTROL ⁄ TREE & BUSH TRIMMING ⁄ RUBBISH REMOVAL ⁄ FURNITURE ASSEMBLY & ALL ODD JOBS ⁄ GUTTER CLEANING SERVICE IN THE HUME & MORELAND reign FOR A FREE QUOTE CALL MIKE.. Handyman & furniture assembler All brands,makes & models. ( Super Amart ⁄ Ikea ⁄ exetra) Where ever the jobs at home ⁄ office ⁄schools ⁄ factory ⁄ shops exetra Contact for a free quote with some details of furniture, and location. Kind Regards. Mike..

Services provided Furniture Assembly General Gardening Handy Man Lawnmowing Outdoor Cleaning Rubbish Removal Tree Lopping
Service Areas Broadmeadows-3047(VIC) Brunswick-3056(VIC) Campbellfield-3061(VIC) Coburg-3058(VIC) Craigieburn-3064(VIC) Epping-3076(VIC) Fawkner-3060(VIC) Glenroy-3046(VIC) Hadfield-3046(VIC) Lalor-3075(VIC) Oak park-3046(VIC) Pascoe vale-3044(VIC) Reservoir-3073(VIC) Thomastown-3074(VIC) Wollert-3750(VIC)
Licenses & Certificates H07418 (WorkSafe VIC)
7
Campbellfield,3061
Victoria,Australia
P: 0431366611
  BENCHMARKS  
Loading Time: Base Classes  0.0056
Controller Execution Time ( Profile / Index )  0.1891
Total Execution Time  0.1948
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,819,608 bytes
  POST DATA  
No POST data exists
  URI STRING  
profile/6affe/ozi.green.property.service
  CLASS/METHOD  
profile/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0003   SELECT *
FROM (`settings`) 
0.0004   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` =  '6affe'
AND `url` =  'ozi.green.property.service' 
0.0003   SELECT *
FROM (`service_profile_categories`)
JOIN `categoriesON `categories`.`id` = `service_profile_categories`.`category_id`
WHERE `service_profile_id` =  '1475'
ORDER BY `categories`.`nameasc 
0.0015   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` =  '1475'
ORDER BY `states`.`shortnameasc, `suburbs`.`nameasc 
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` =  '1475'
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` =  '1475' 
0.0002   SELECT *
FROM (`service_profile_links`)
WHERE `service_profile_id` =  '1475' 
0.0002   SELECT `id`, `name`
FROM (`categories`)
WHERE `parent_id` =  
0.0004   SELECT idparent_idname FROM categories WHERE parent_id != 
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 ='5917501c39c39c70793adcce746c5e04' 
0.0001   SELECT `id`
FROM (`reviews`)
WHERE `customer_user_idIS NULL
AND `service_provider_user_id` =  '6486'
AND `job_id` =  
0.0001   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 ='5917501c39c39c70793adcce746c5e04' 
0.0001   SELECT `id`, `label`
FROM (`rating_criteria`) 
0.0002   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` =  '6486'
AND `R`.`active` =  '1'
GROUP BY `RR`.`rating_id
0.0002   SELECT *
FROM (`settings`) 
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 ='5917501c39c39c70793adcce746c5e04' 
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 ='5917501c39c39c70793adcce746c5e04' 
0.0003   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)