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) 5 queries took 363 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` = 'sacramento') OR (`UtZipcode`.`state_name` = 'sacramento') OR (`UtZipcode`.`state_prefix` = 'sacramento') OR (`UtZipcode`.`county` = 'sacramento') OR (`UtZipcode`.`zipcode` = 'sacramento')) GROUP BY `UtZipcode`.`city`, `UtZipcode`.`state_prefix` ORDER BY `size` DESC, `UtZipcode`.`city` ASC, `UtZipcode`.`state_prefix` ASC LIMIT 111354
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 `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 `CustomerSupportedLocation`.`lat` >= 37.859762318841 AND `CustomerSupportedLocation`.`lat` <= 39.309037681159 AND `CustomerSupportedLocation`.`lon` >= -122.42101377226 AND `CustomerSupportedLocation`.`lon` <= -120.56698622774 ORDER BY rad_distance(`CustomerSupportedLocation`.`lat`, `CustomerSupportedLocation`.`lon`, 38.5844, -121.494) ASC LIMIT 1111
4SELECT `Employer`.`id`, `Employer`.`company_name`, `EmployersJob`.`craigslist_city`, `EmployersJob`.`craigslist_sub_city`, `EmployersJob`.`craigslist_sub_sub_city`, `EmployersJob`.`craigslist_state`, `Employer`.`company_logo`, `Employer`.`lat`, `Employer`.`lon`, `EmployersJob`.`ats_url`, `EmployersJob`.`title`, `EmployersJob`.`company_name`, `EmployersJob`.`featured`, `EmployersJob`.`description`, `EmployersJob`.`open`, `EmployersJob`.`anonymous_post`, `EmployersJob`.`post_date`, `EmployersJob`.`id`, `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`) LEFT JOIN `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` ON (`EmployerMobileImage`.`employer_id` = `EmployersJob`.`employer_id`) WHERE `EmployersJob`.`id` IN (45974, 46171, 44203, 39481, 46185, 17022, 16794, 24314, 40864, 39830, 23373, 23925, 46160, 46157, 46159, 46158, 45253, 45575, 45773, 45890, 19929, 46134, 32600, 15740, 45190, 45454, 44490, 46111, 46107, 45209, 46105, 45578, 45581, 46095, 46092, 37305, 46081, 13469, 40190, 15203, 45993, 38634, 46054, 45439, 46050, 46049, 46048, 26053, 44406, 46041, 46040, 46039, 44943, 25073, 23449, 27617, 19631, 17666, 17522, 17458, 45150, 46079, 45530, 46138, 46058, 44290, 46184, 40079, 44759, 44432, 13207, 18027, 44780, 30891, 45587, 44644, 23964, 46178, 17151, 26193, 16892, 24585, 23863, 46175, 44127, 17975, 24481, 46168, 46167, 20012, 44654, 42998, 17184, 20893, 46014, 24542, 44263, 46153, 29090, 45495) ORDER BY `EmployersJob`.`featured` DESC, `EmployersJob`.`post_date` DESC1001003
5SELECT `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` ASC4274272