K G Paint Decorate

Merrylands,NSW,2160

We provide domestic and commercial painting with over 30 years of experience your job will be well done. Call or

Painting

Austech painting and maintenance

Wantirna,VIC,3152

We do painting, plastering and any other jobs. This includes working with qualified carpenters, electrician and plumbers. Fully insured. Small

Carpentry Home Renovations Painting Plastering

The Roofing Star

We deal with all aspects of roof tiling.. re bedding, re pointing, pressure cleaning, tile replacement, painting, possum proofing, gutter

Roof Painting

Perfect form painting

Perfect form Painting offers comprehensive interior and exterior painting services for both the residential and commercial markets. Service Description Perfect form painting

Exterior House Painting Interior House Painting

AOT PAINTING

Ormeau,QLD,4208

We would love to have the opportunity to quote on your next project or small renovation. This is what we

Exterior House Painting Interior House Painting

H2GO PRESSURE CLEANING

Pitt town,NSW,2756

To Whom It May Concern I would like to introduce myself to you. My name is Scott Jennison and I run a

Roof Painting

ken's roof restoration

Craigie,WA,6025

l quote all areas in perth .I repair leaks .repointed cracked ridge caps. I restore all roof tiles. anything to

Roof Painting

Bluepainter

Ryde,NSW,2112

Blue painting services Residential and commercial painting . Blue painters are rich experienced, reliable and professional. We have trustworthy team to

Painting

LX Ideal Painting

We are qualified,skillful and experienced painters that you can trust。 Lic:287813C We offer interior and exterior painting,reasonable price,perfect job。 Get

Painting

Winston Building Services

Bunbury,WA,6230

Professional Reliability at affordable rates

Carpentry Painting Plastering Tiling

  BENCHMARKS  
Loading Time: Base Classes  0.0055
Controller Execution Time ( Search / Index )  0.3223
Total Execution Time  0.3279
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,549,864 bytes
  POST DATA  
No POST data exists
  URI STRING  
service/painting
  CLASS/METHOD  
search/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0003   SELECT *
FROM (`settings`) 
0.0004   SELECT *
FROM (`categories`)
WHERE `url` =  'painting' 
0.0003   SELECT `c`.`id`, `c`.`name`
FROM (`categoriesc)
WHERE `c`.`idIN ('247')  
0.0068   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 ('247') OR c.parent_id IN ('247'))
AND `
s`.`active` = 1
GROUP BY 
`s`.`user_id`
ORDER BY `ratingDESC
LIMIT 10 
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` =  '1390'
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` =  '1421'
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` =  '1436'
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` =  '1440'
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` =  '1441'
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` =  '1443'
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` =  '1452'
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` =  '1484'
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` =  '1491'
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` =  '1507'
ORDER BY `idDESC 
0.0003   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 ='cf91ef84d642b25ea2739adac7ae21cb' 
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 ='cf91ef84d642b25ea2739adac7ae21cb' 
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)