Warning (2): filemtime(): stat failed for /var/app/current/app/View/Layouts/../../webroot/css/proven.responsive.min.css [APP/View/Layouts/responsive.ctp, line 69]" type="text/css" />

We ♥ small businesses :-)

Facebook Twitter
(default) 6 queries took 368 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `UtZipcode`.`city`, `UtZipcode`.`state_prefix`, `UtZipcode`.`state_name`, `UtZipcode`.`zipcode`, `UtZipcode`.`lat`, `UtZipcode`.`lon`, Count(*) as size FROM `proven_production`.`ut_zipcodes` AS `UtZipcode` WHERE ((`UtZipcode`.`city` = 'san-diego') OR (`UtZipcode`.`state_name` = 'san-diego') OR (`UtZipcode`.`state_prefix` = 'san-diego') OR (`UtZipcode`.`county` = 'san-diego') OR (`UtZipcode`.`zipcode` = 'san-diego')) GROUP BY `UtZipcode`.`city`, `UtZipcode`.`state_prefix` ORDER BY `size` DESC, `UtZipcode`.`city` ASC, `UtZipcode`.`state_prefix` ASC LIMIT 100354
2SELECT `CustomerSupportedLocation`.`id`, `CustomerSupportedLocation`.`name`, `CustomerSupportedLocation`.`state`, `CustomerSupportedLocation`.`state_expanded`, `CustomerSupportedLocation`.`paid_area`, `CustomerSupportedLocation`.`lat`, `CustomerSupportedLocation`.`lon`, `CustomerSupportedLocation`.`background_class`, `CustomerSupportedLocation`.`key_value`, `CustomerSupportedLocation`.`pricing_plan_id`, `CustomerSupportedLocation`.`subscription_plan_id`, `CustomerSupportedLocation`.`created_date`, `CustomerSupportedLocation`.`posting_fee`, `CustomerSupportedLocation`.`city` FROM `proven_production`.`customer_supported_locations` AS `CustomerSupportedLocation` WHERE 1 = 1 ORDER BY `name` ASC4274273
3SELECT `UtZipcode`.`id`, `UtZipcode`.`zipcode`, `UtZipcode`.`city`, `UtZipcode`.`county`, `UtZipcode`.`state_name`, `UtZipcode`.`state_prefix`, `UtZipcode`.`area_code`, `UtZipcode`.`time_zone`, `UtZipcode`.`lat`, `UtZipcode`.`lon` FROM `proven_production`.`ut_zipcodes` AS `UtZipcode` WHERE `city` = 'San Diego' AND `state_name` = 'CA' LIMIT 1001
4SELECT `User`.`last_login`, `User`.`unique_name`, `Employer`.`id`, `Employer`.`company_name`, `Employer`.`lat`, `Employer`.`lon`, `EmployersJob`.`ats_url`, `Employer`.`company_logo`, `UtZipcode`.`city`, `UtZipcode`.`state_prefix`, `UtZipcode`.`lat`, `UtZipcode`.`lon`, `EmployersJob`.`craigslist_city`, `EmployersJob`.`craigslist_sub_city`, `EmployersJob`.`craigslist_sub_sub_city`, `EmployersJob`.`craigslist_state`, `EmployersJob`.`title`, `EmployersJob`.`company_name`, `EmployersJob`.`description`, `EmployersJob`.`featured`, `EmployersJob`.`open`, `EmployersJob`.`anonymous_post`, `EmployersJob`.`post_date`, `EmployersJob`.`id`, `EmployersJob`.`unique_name`, `EmployerMobileImage`.`file_name` FROM `proven_production`.`employers_jobs` AS `EmployersJob` LEFT JOIN `proven_production`.`ut_zipcodes` AS `UtZipcode` ON (`EmployersJob`.`zip` = `UtZipcode`.`zipcode`) INNER JOIN `proven_production`.`employers` AS `Employer` ON (`Employer`.`id` = `EmployersJob`.`employer_id`) INNER JOIN `proven_production`.`users` AS `User` ON (`User`.`id` = `Employer`.`user_id` AND `User`.`active` = 1) LEFT JOIN `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` ON (`EmployerMobileImage`.`employer_id` = `EmployersJob`.`employer_id`) WHERE `Employer`.`company_name` <> '' AND `Employer`.`active` = 1 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`title` <> 'General Inquiries' AND `EmployersJob`.`craigslist_city` = 'san diego' GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`featured` DESC, `EmployersJob`.`post_date` DESC LIMIT 50774
5SELECT COUNT(*) AS `count` FROM `proven_production`.`employers_jobs` AS `EmployersJob` LEFT JOIN `proven_production`.`ut_zipcodes` AS `UtZipcode` ON (`EmployersJob`.`zip` = `UtZipcode`.`zipcode`) INNER JOIN `proven_production`.`employers` AS `Employer` ON (`Employer`.`id` = `EmployersJob`.`employer_id`) INNER JOIN `proven_production`.`users` AS `User` ON (`User`.`id` = `Employer`.`user_id` AND `User`.`active` = 1) LEFT JOIN `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` ON (`EmployerMobileImage`.`employer_id` = `EmployersJob`.`employer_id`) WHERE `Employer`.`company_name` <> '' AND `Employer`.`active` = 1 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`title` <> 'General Inquiries' AND `EmployersJob`.`craigslist_city` = 'san diego' GROUP BY `EmployersJob`.`id`773
6SELECT `CustomerSupportedLocation`.`id`, `CustomerSupportedLocation`.`name`, `CustomerSupportedLocation`.`state`, `CustomerSupportedLocation`.`state_expanded`, `CustomerSupportedLocation`.`paid_area`, `CustomerSupportedLocation`.`lat`, `CustomerSupportedLocation`.`lon`, `CustomerSupportedLocation`.`background_class`, `CustomerSupportedLocation`.`key_value`, `CustomerSupportedLocation`.`pricing_plan_id`, `CustomerSupportedLocation`.`subscription_plan_id`, `CustomerSupportedLocation`.`created_date`, `CustomerSupportedLocation`.`posting_fee`, `CustomerSupportedLocation`.`city` FROM `proven_production`.`customer_supported_locations` AS `CustomerSupportedLocation` WHERE 1 = 1 ORDER BY `name` ASC4274273