Mat's Lawn Mowing Services

Kellyville,NSW,2155

Lawns from $ 30 depending on lawn size "You Grow it We'll Mow It" No lawn too big or too small. All work

Landscaping & Gardening

JB Yard & Mowing Service

Pimpama,QLD,4209

My lawn care business is professional & affordable. The work carried out is always done to the highest quality and

General Gardening Landscaping & Gardening Lawnmowing

F M Garden Services

Garden Clean Ups Lawn Mowing all types General Landscaping Garden Maintenance Commercial and residential 20 years experience For personalized service that takes

General Gardening Landscaping & Gardening Lawnmowing

Dream Clean perth

Perth,WA,6000

Why Choose Us: - 100% Bond Back Guarantee - Lowest Rates and Highest quality of Service - 24⁄7 days operations with same prices -

Carpet Steam Cleaning End of Lease Cleaning High Pressure Cleaning House Cleaning Landscaping & Gardening Window Cleaning

Groundy's Trees Garden & Lawn

Capalaba,QLD,4157

At GROUNDY'S we specialize in all aspects of trees including total removal, pruning, lopping, thinning and dead limbs. All

Fence Installation Fencing General Gardening Landscaping & Gardening Lawnmowing Timber Fence Tree Lopping Tree Stumping

Tree Walkers Tree & Stump Removal

Bayswater,VIC,3153

The cost of tree removal depends on the size, health and access of the tree. Due to our experience in

Demolition Landscaping Landscaping & Gardening Rubbish Removal Tree Lopping Tree Stumping

Home Cleaning Sydney

We offer fast, effective and reliable cleaning services at reasonable prices. We hire only qualified professionals and this is the

Carpet Steam Cleaning End of Lease Cleaning House Cleaning Household Services Landscaping & Gardening Office Cleaning

RT landscaping and excavations

All landscaping including design and construct. Retaining walls. Paving. Turf from minor garden makeovers to complete yard landscaping Specialising in

Excavation & Earthmoving Landscaping Landscaping & Gardening

OZI GREEN PROPERTY SERVICE

Campbellfield,VIC,3061

LAWN MOWING ⁄ WHIPPERSNIPING ⁄ BRUSH-CUTTING ⁄ CHAINSAW ⁄ HEDGING ⁄ EDGING ⁄ WEED CONTROL ⁄ TREE & BUSH TRIMMING

General Gardening Lawnmowing Tree Lopping

Mosman Gardening, Home Maintenance and Cleaning Services

Experienced handyperson resides in Mosman. All types of gardening, home maintenance and cleaning work for local residents and businesses at

General Gardening

  BENCHMARKS  
Loading Time: Base Classes  0.0058
Controller Execution Time ( Search / Index )  0.4964
Total Execution Time  0.5022
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,553,584 bytes
  POST DATA  
No POST data exists
  URI STRING  
service/landscaping-gardening
  CLASS/METHOD  
search/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0003   SELECT *
FROM (`settings`) 
0.0003   SELECT *
FROM (`categories`)
WHERE `url` =  'landscaping-gardening' 
0.0002   SELECT `c`.`id`, `c`.`name`
FROM (`categoriesc)
WHERE `c`.`idIN ('201')  
0.0240   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 ('201') OR c.parent_id IN ('201'))
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` =  '1395'
ORDER BY `idDESC 
0.0004   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` =  '1396'
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` =  '1402'
ORDER BY `idDESC 
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` =  '1408'
ORDER BY `idDESC 
0.0004   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` =  '1422'
ORDER BY `idDESC 
0.0004   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` =  '1430'
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` =  '1439'
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` =  '1456'
ORDER BY `idDESC 
0.0004   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.0004   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` =  '1506'
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 ='0c040a614758d5a17b6491ebf2c41931' 
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 ='0c040a614758d5a17b6491ebf2c41931' 
0.0005   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)