404 Bradford Court,
United States, New Jersey, Somerset
8844
0 active job
Plattsburgh, New York,
United States, New York, Plattsburgh
12901
0 active job
Virginia beach, Virginia,
United States, Virginia, Virginia beach
23320
0 active job
575 E. Big Beaver Rd.,
United States, Michigan, Sterling heights
48083
0 active job
1100 San Leandro Boulevard,
United States, California, San francisco
94577
0 active job
Nr | Query | Error | 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 `Agency`.`name`, `Agency`.`address`, `Agency`.`zipcode`, `Agency`.`logo`, `Country`.`name`, `Region`.`name`, `City`.`name`, `Agency`.`id` FROM `prod_jobcluster`.`agencies` AS `Agency` LEFT JOIN `prod_jobcluster`.`countries` AS `Country` ON (`Agency`.`country_id` = `Country`.`id`) LEFT JOIN `prod_jobcluster`.`regions` AS `Region` ON (`Agency`.`region_id` = `Region`.`id`) LEFT JOIN `prod_jobcluster`.`cities` AS `City` ON (`Agency`.`city_id` = `City`.`id`) WHERE `Agency`.`status` = 1 ORDER BY `Agency`.`created` Desc LIMIT 21 | 19 | 19 | 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`.`agency_id` IN (19, 18, 17, 16, 15, 14, 13, 12, 11, 10, 9, 8, 7, 6, 5, 4, 3, 2, 1) | 19 | 19 | 3 | |
7 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 161 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
8 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 156 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
9 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 155 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
10 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 152 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
11 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 151 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
12 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 150 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
13 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 149 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
14 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 148 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
15 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 147 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
16 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 146 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
17 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 145 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
18 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 144 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
19 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 143 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
20 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 142 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
21 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 141 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
22 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 140 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
23 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 139 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
24 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 138 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
25 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 137 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
26 | SELECT `Country`.`id`, `Country`.`name`, `Country`.`id_country`, `Country`.`zone_id`, `Country`.`lat`, `Country`.`long`, `Zone`.`id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prod_jobcluster`.`countries` AS `Country` LEFT JOIN `prod_jobcluster`.`zones` AS `Zone` ON (`Country`.`zone_id` = `Zone`.`id`) WHERE 1 = 1 ORDER BY `Country`.`name` ASC | 225 | 225 | 1 |