HUNJAN TECHNOLOGIES PTY LTD

We are fully Certified & Licensed Electrical Company, covering all suburbs of Sydney. We expert team of approved electricians provide

Electrical Services Security Systems

THiNK Adelaide Electrical

Think Adelaide Electrical is a young vibrant business based on quality and honesty. We listen to clients wants and needs

Air Conditioning & Heating Electrical Services Electricians

Inverted Air

Arundel,QLD,4214

Inverted Air can take care of all your air conditioning needs. We are also licenced in the fields of electrical,

Air Conditioning & Heating Data Cabling Electrical Services Electricians

ATY Electrical

Fairy meadow,NSW,2519

Small job Specialist. Ceiling fans. Bathroom fans. All general lighting and power indoor and outdoor. General electrical installations. Fuseboard upgrades.

Electrical Services Electricians

MJ Hill Electrical

Hallett cove,SA,5158

I have nearly ten years experience in the electrical industry. Having worked predominantly within the residential and commercial sectors for

Electricians

Avolt Electrical

Sydney,NSW,2000

At Avolt Electrical we aim to deliver WOW through service and provide our customers with professional service, a competitive price

Appliance Installation Electrical Services Electricians

Eversource Electrical

Belmore,NSW,2192

At Eversource we provide solutions for all types of electrical work. We deliver Expert & Quick Service at a Fair

Data Cabling Electrical Services Electricians

TSJ Electrical Pty Ltd

Harrington park,NSW,2567

Electrical contracting business specialising in domestic home electrical work: - Down light installation - Security light installation - Feature and pendant light installation -

Electrical Services Electricians

Greenamite Electrical

Data Cabling

SSK ELECTRICAL PTY LTD

Pakenham,VIC,3810

We are specialized in all electrical services and split system air conditioning installation .

Air Conditioning & Heating Electrical Services

  BENCHMARKS  
Loading Time: Base Classes  0.0058
Controller Execution Time ( Search / Index )  0.3260
Total Execution Time  0.3319
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,546,440 bytes
  POST DATA  
No POST data exists
  URI STRING  
service/electrical-services
  CLASS/METHOD  
search/index
  DATABASE:  quotlyco_prod   QUERIES: 18  (Hide)
0.0003   SELECT *
FROM (`settings`) 
0.0004   SELECT *
FROM (`categories`)
WHERE `url` =  'electrical-services' 
0.0003   SELECT `c`.`id`, `c`.`name`
FROM (`categoriesc)
WHERE `c`.`idIN ('133')  
0.0117   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 ('133') OR c.parent_id IN ('133'))
AND `
s`.`active` = 1
GROUP BY 
`s`.`user_id`
ORDER BY `ratingDESC
LIMIT 10 
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` =  '1388'
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` =  '1389'
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` =  '1392'
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` =  '1415'
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` =  '1434'
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` =  '1442'
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` =  '1455'
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` =  '1466'
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` =  '1471'
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` =  '1474'
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 ='1a671f3a5244ecba05896fb75691e2ac' 
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 ='1a671f3a5244ecba05896fb75691e2ac' 
0.0004   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)