LX Ideal Painting
P: 0430297737
nightingale91@126.com

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 a FREE quote now! Contact Mark:0430297737

Services provided Painting
Service Areas Merrylands-2160(NSW)
Licenses & Certificates

No addresses

  BENCHMARKS  
Loading Time: Base Classes  0.0063
Controller Execution Time ( Profile / Index )  0.2020
Total Execution Time  0.2084
  GET DATA  
No GET data exists
  MEMORY USAGE  
4,782,560 bytes
  POST DATA  
No POST data exists
  URI STRING  
profile/64dcf/lx.ideal.painting
  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` =  '64dcf'
AND `url` =  'lx.ideal.painting' 
0.0005   SELECT *
FROM (`service_profile_categories`)
JOIN `categoriesON `categories`.`id` = `service_profile_categories`.`category_id`
WHERE `service_profile_id` =  '1491'
ORDER BY `categories`.`nameasc 
0.0007   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` =  '1491'
ORDER BY `states`.`shortnameasc, `suburbs`.`nameasc 
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` =  '1491'
ORDER BY `idDESC 
0.0002   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` =  '1491' 
0.0002   SELECT *
FROM (`service_profile_links`)
WHERE `service_profile_id` =  '1491' 
0.0004   SELECT `id`, `name`
FROM (`categories`)
WHERE `parent_id` =  
0.0004   SELECT idparent_idname FROM categories WHERE parent_id != 
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 ='818de8d35914eba3b8d3928ff0da3256' 
0.0001   SELECT `id`
FROM (`reviews`)
WHERE `customer_user_idIS NULL
AND `service_provider_user_id` =  '6503'
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 ='818de8d35914eba3b8d3928ff0da3256' 
0.0002   SELECT `id`, `label`
FROM (`rating_criteria`) 
0.0003   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` =  '6503'
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 ='818de8d35914eba3b8d3928ff0da3256' 
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 ='818de8d35914eba3b8d3928ff0da3256' 
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)