Lake Los Angeles, California,
United States, California, Lake los angeles
90003
0 active job
800 Gessner Road, Suit 900,
United States, Texas, Hobson
77024
0 active job
100 South Ashley Drive, Suite 650, Tampa, FL 33602,
United States, Florida, Tampa
33602
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 | 1 | |
5 | SELECT `Company`.`name`, `Company`.`address`, `Company`.`zipcode`, `Company`.`logo`, `Country`.`name`, `Region`.`name`, `City`.`name`, `Company`.`id` 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`.`status` = 1 ORDER BY `Company`.`created` Desc LIMIT 42, 21 | 21 | 21 | 1 | |
6 | SELECT `Professional`.`id`, `Professional`.`user_id`, `Professional`.`company_id`, `Professional`.`othercompany`, `Professional`.`address`, `Professional`.`country_id`, `Professional`.`region_id`, `Professional`.`city_id`, `Professional`.`designation_id`, `Professional`.`otherdesignation`, `Professional`.`startdate`, `Professional`.`enddate`, `Professional`.`created`, `Professional`.`modified` FROM `prod_jobcluster`.`professionals` AS `Professional` WHERE `Professional`.`company_id` IN (44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24) | 5 | 5 | 1 | |
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` FROM `prod_jobcluster`.`users` AS `User` WHERE `User`.`company_id` IN (44, 43, 42, 41, 40, 39, 38, 37, 36, 35, 34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24) | 26 | 26 | 4 | |
8 | SELECT COUNT(*) AS `count` 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`.`status` = 1 | 1 | 1 | 1 | |
9 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 116 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
10 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 115 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
11 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 114 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
12 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 113 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
13 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 112 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
14 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 111 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
15 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 110 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
16 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 1036 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
17 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 109 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
18 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 2254 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
19 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 108 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
20 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 107 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
21 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 106 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
22 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 105 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
23 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 104 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
24 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 103 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
25 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 904 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
26 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 2193 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
27 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 102 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
28 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 101 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
29 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 100 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
30 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 911 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
31 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 99 AND `Vacancy`.`status` = 1 | 1 | 1 | 1 | |
32 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 98 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
33 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 97 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
34 | SELECT COUNT(*) AS `count` FROM `prod_jobcluster`.`vacancies` AS `Vacancy` WHERE `Vacancy`.`user_id` = 96 AND `Vacancy`.`status` = 1 | 1 | 1 | 0 | |
35 | 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 |