Elite Asia

Elite Asia

Location : 67 Ayer Rajah Crescent #02-10/17, Launchpad @ One North Singapore 139950, Singapore, No region, Singapore

Jobs Listing

Vacancy not available.

(default) 10 queries took 14 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1	0	0	4
2	SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1	1	1	0
3	SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1	1	1	0
4	SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`description`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_jobcluster`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1	1	1	0
5	SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 85 AND `Company`.`status` = 1 LIMIT 1	1	1	1
6	SELECT `User`.`id`, `User`.`group_id`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`password`, `User`.`confirm`, `User`.`status`, `User`.`address`, `User`.`country_id`, `User`.`region_id`, `User`.`city_id`, `User`.`zipcode`, `User`.`phone`, `User`.`company_id`, `User`.`agency_id`, `User`.`usertype`, `User`.`typeid`, `User`.`superuser`, `User`.`parent_id`, `User`.`lastlogin`, `User`.`lastlogin2`, `User`.`notification`, `User`.`iagreed`, `User`.`ipaddress`, `User`.`created`, `User`.`modified` FROM `prod_jobcluster`.`users` AS `User` WHERE `User`.`company_id` = (85)	1	1	4
7	SELECT `User`.`id`, `User`.`group_id`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`password`, `User`.`confirm`, `User`.`status`, `User`.`address`, `User`.`country_id`, `User`.`region_id`, `User`.`city_id`, `User`.`zipcode`, `User`.`phone`, `User`.`company_id`, `User`.`agency_id`, `User`.`usertype`, `User`.`typeid`, `User`.`superuser`, `User`.`parent_id`, `User`.`lastlogin`, `User`.`lastlogin2`, `User`.`notification`, `User`.`iagreed`, `User`.`ipaddress`, `User`.`created`, `User`.`modified`, `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Agency`.`id`, `Agency`.`name`, `Agency`.`email`, `Agency`.`address`, `Agency`.`country_id`, `Agency`.`region_id`, `Agency`.`city_id`, `Agency`.`zipcode`, `Agency`.`phone`, `Agency`.`fax`, `Agency`.`logo`, `Agency`.`description`, `Agency`.`lat`, `Agency`.`lon`, `Agency`.`status`, `Agency`.`created`, `Agency`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`users` AS `User` LEFT JOIN `prod_jobcluster`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `prod_jobcluster`.`agencies` AS `Agency` ON (`User`.`agency_id` = `Agency`.`id`) LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`User`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`User`.`city_id` = `City`.`id`) WHERE `User`.`id` = 2179 LIMIT 1	1	1	1
8	SELECT `Vacancy`.`id`, `Vacancy`.`user_id`, `Vacancy`.`package_id`, `Vacancy`.`jobtitle`, `Vacancy`.`industry_id`, `Vacancy`.`address`, `Vacancy`.`country_id`, `Vacancy`.`region_id`, `Vacancy`.`city_id`, `Vacancy`.`lat`, `Vacancy`.`lon`, `Vacancy`.`qualification_id`, `Vacancy`.`specialization_id`, `Vacancy`.`currancy`, `Vacancy`.`minimumsalary`, `Vacancy`.`maximumsalary`, `Vacancy`.`duration`, `Vacancy`.`hidesal`, `Vacancy`.`experienceyear`, `Vacancy`.`employmenttype`, `Vacancy`.`keyskills`, `Vacancy`.`responsibilities`, `Vacancy`.`description`, `Vacancy`.`candidateindustry_id`, `Vacancy`.`candidatecountry_id`, `Vacancy`.`candidateregion_id`, `Vacancy`.`candidatecity_id`, `Vacancy`.`candidatecurrancy`, `Vacancy`.`currentannualminsal`, `Vacancy`.`currentannualmaxsal`, `Vacancy`.`candidateduration`, `Vacancy`.`teamsize`, `Vacancy`.`includecompany`, `Vacancy`.`excludecompany`, `Vacancy`.`referenceid`, `Vacancy`.`status`, `Vacancy`.`keywordgenerated`, `Vacancy`.`isdisclaimer`, `Vacancy`.`ipaddress`, `Vacancy`.`created`, `Vacancy`.`modified` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = (2179)	0	0	1
9	SELECT `Testimonial`.`id`, `Testimonial`.`user_id`, `Testimonial`.`description`, `Testimonial`.`status`, `Testimonial`.`created`, `Testimonial`.`modified` FROM `prod_jobcluster`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`user_id` = (2179)	0	0	0
10	SELECT `Subuser`.`id`, `Subuser`.`group_id`, `Subuser`.`firstname`, `Subuser`.`lastname`, `Subuser`.`email`, `Subuser`.`password`, `Subuser`.`confirm`, `Subuser`.`status`, `Subuser`.`address`, `Subuser`.`country_id`, `Subuser`.`region_id`, `Subuser`.`city_id`, `Subuser`.`zipcode`, `Subuser`.`phone`, `Subuser`.`company_id`, `Subuser`.`agency_id`, `Subuser`.`usertype`, `Subuser`.`typeid`, `Subuser`.`superuser`, `Subuser`.`parent_id`, `Subuser`.`lastlogin`, `Subuser`.`lastlogin2`, `Subuser`.`notification`, `Subuser`.`iagreed`, `Subuser`.`ipaddress`, `Subuser`.`created`, `Subuser`.`modified` FROM `prod_jobcluster`.`users` AS `Subuser` WHERE `Subuser`.`parent_id` = (2179)	0	0	3

(default) 10 queries took 14 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'admin_contact_no' LIMIT 1

SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'ContactEmail' LIMIT 1

SELECT `Sitesetting`.`value` FROM `prod_jobcluster`.`sitesettings` AS `Sitesetting` WHERE `key` = 'SiteDomain' LIMIT 1

SELECT `Faqcategory`.`id`, `Faqcategory`.`name`, `Faqcategory`.`description`, `Faqcategory`.`status`, `Faqcategory`.`created`, `Faqcategory`.`modified` FROM `prod_jobcluster`.`faqcategories` AS `Faqcategory` WHERE `status` = 1 LIMIT 1

SELECT `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`companies` AS `Company` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Company`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) WHERE `Company`.`id` = 85 AND `Company`.`status` = 1 LIMIT 1

SELECT `User`.`id`, `User`.`group_id`, `User`.`firstname`, `User`.`lastname`, `User`.`email`, `User`.`password`, `User`.`confirm`, `User`.`status`, `User`.`address`, `User`.`country_id`, `User`.`region_id`, `User`.`city_id`, `User`.`zipcode`, `User`.`phone`, `User`.`company_id`, `User`.`agency_id`, `User`.`usertype`, `User`.`typeid`, `User`.`superuser`, `User`.`parent_id`, `User`.`lastlogin`, `User`.`lastlogin2`, `User`.`notification`, `User`.`iagreed`, `User`.`ipaddress`, `User`.`created`, `User`.`modified`, `Company`.`id`, `Company`.`name`, `Company`.`email`, `Company`.`address`, `Company`.`country_id`, `Company`.`region_id`, `Company`.`city_id`, `Company`.`zipcode`, `Company`.`phone`, `Company`.`fax`, `Company`.`logo`, `Company`.`description`, `Company`.`lat`, `Company`.`lon`, `Company`.`empstrength`, `Company`.`website`, `Company`.`status`, `Company`.`created`, `Company`.`modified`, `Agency`.`id`, `Agency`.`name`, `Agency`.`email`, `Agency`.`address`, `Agency`.`country_id`, `Agency`.`region_id`, `Agency`.`city_id`, `Agency`.`zipcode`, `Agency`.`phone`, `Agency`.`fax`, `Agency`.`logo`, `Agency`.`description`, `Agency`.`lat`, `Agency`.`lon`, `Agency`.`status`, `Agency`.`created`, `Agency`.`modified`, `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`id_country`, `Region`.`lat`, `Region`.`long`, `City`.`id`, `City`.`country_id`, `City`.`name`, `City`.`zip_code`, `City`.`region_code`, `City`.`region_id`, `City`.`lat`, `City`.`lon`, `City`.`id_country` FROM `prod_jobcluster`.`users` AS `User` LEFT JOIN `prod_jobcluster`.`companies` AS `Company` ON (`User`.`company_id` = `Company`.`id`) LEFT JOIN `prod_jobcluster`.`agencies` AS `Agency` ON (`User`.`agency_id` = `Agency`.`id`) LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`User`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`User`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`User`.`city_id` = `City`.`id`) WHERE `User`.`id` = 2179 LIMIT 1

SELECT `Vacancy`.`id`, `Vacancy`.`user_id`, `Vacancy`.`package_id`, `Vacancy`.`jobtitle`, `Vacancy`.`industry_id`, `Vacancy`.`address`, `Vacancy`.`country_id`, `Vacancy`.`region_id`, `Vacancy`.`city_id`, `Vacancy`.`lat`, `Vacancy`.`lon`, `Vacancy`.`qualification_id`, `Vacancy`.`specialization_id`, `Vacancy`.`currancy`, `Vacancy`.`minimumsalary`, `Vacancy`.`maximumsalary`, `Vacancy`.`duration`, `Vacancy`.`hidesal`, `Vacancy`.`experienceyear`, `Vacancy`.`employmenttype`, `Vacancy`.`keyskills`, `Vacancy`.`responsibilities`, `Vacancy`.`description`, `Vacancy`.`candidateindustry_id`, `Vacancy`.`candidatecountry_id`, `Vacancy`.`candidateregion_id`, `Vacancy`.`candidatecity_id`, `Vacancy`.`candidatecurrancy`, `Vacancy`.`currentannualminsal`, `Vacancy`.`currentannualmaxsal`, `Vacancy`.`candidateduration`, `Vacancy`.`teamsize`, `Vacancy`.`includecompany`, `Vacancy`.`excludecompany`, `Vacancy`.`referenceid`, `Vacancy`.`status`, `Vacancy`.`keywordgenerated`, `Vacancy`.`isdisclaimer`, `Vacancy`.`ipaddress`, `Vacancy`.`created`, `Vacancy`.`modified` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = (2179)

SELECT `Testimonial`.`id`, `Testimonial`.`user_id`, `Testimonial`.`description`, `Testimonial`.`status`, `Testimonial`.`created`, `Testimonial`.`modified` FROM `prod_jobcluster`.`testimonials` AS `Testimonial` WHERE `Testimonial`.`user_id` = (2179)

SELECT `Subuser`.`id`, `Subuser`.`group_id`, `Subuser`.`firstname`, `Subuser`.`lastname`, `Subuser`.`email`, `Subuser`.`password`, `Subuser`.`confirm`, `Subuser`.`status`, `Subuser`.`address`, `Subuser`.`country_id`, `Subuser`.`region_id`, `Subuser`.`city_id`, `Subuser`.`zipcode`, `Subuser`.`phone`, `Subuser`.`company_id`, `Subuser`.`agency_id`, `Subuser`.`usertype`, `Subuser`.`typeid`, `Subuser`.`superuser`, `Subuser`.`parent_id`, `Subuser`.`lastlogin`, `Subuser`.`lastlogin2`, `Subuser`.`notification`, `Subuser`.`iagreed`, `Subuser`.`ipaddress`, `Subuser`.`created`, `Subuser`.`modified` FROM `prod_jobcluster`.`users` AS `Subuser` WHERE `Subuser`.`parent_id` = (2179)