*/public function read($key) {return $this->_Memcache->get($key);
$key = 'app__employer'
MemcachePool::get() - [internal], line ??
MemcacheEngine::read() - CORE/Cake/Cache/Engine/MemcacheEngine.php, line 152
Cache::read() - CORE/Cake/Cache/Cache.php, line 363
AppModel::find() - APP/Model/AppModel.php, line 53
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employer_first_fafe50218c449977a9898c7b2ec9de08' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_fafe50218c449977a9898c7b2ec9de08'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Kollar Chocolates',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Yountville',
'state' => 'CA',
'lat' => '38.40760040',
'lon' => '-122.35700226',
'street_address' => '',
'id' => '17049',
'about_us' => 'As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94599',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/Kollar-Chocolates-160070767377117/',
'website' => 'http://www.kollarchocolates.com ',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
)
$config = 'default'
$settings = array(
'prefix' => '*****',
'engine' => 'Memcache',
'duration' => (int) 3600,
'probability' => (int) 100,
'servers' => array(
(int) 0 => 'proven-cache.kmvdqz.cfg.use1.cache.amazonaws.com:11211'
),
'compress' => false,
'persistent' => true,
'groups' => array()
)
$success = false
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employer' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
Employer::getEmployerInfo() - APP/Model/Employer.php, line 83
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 44
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employersjob_all_8ff4f22a66fee72ad1857a917b57301c' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
EmployersJob::getOpenJobsForEmployer() - APP/Model/EmployersJob.php, line 207
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 53
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employersjob' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
EmployersJob::getOpenJobsForEmployer() - APP/Model/EmployersJob.php, line 207
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 53
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employermobileimage_first_326e389c729457928fff30de1d7b5f6c' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 63
DboSource::query() - CORE/Cake/Model/Datasource/DboSource.php, line 599
Model::__call() - CORE/Cake/Model/Model.php, line 827
EmployerMobileImage::findByEmployerId() - APP/Model/EmployerMobileImage.php, line 7
EmployerMobileImage::getMobileImage() - APP/Model/EmployerMobileImage.php, line 7
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 60
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Warning (512): default cache was unable to write '_employermobileimage' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
Cache::write() - CORE/Cake/Cache/Cache.php, line 328
AppModel::find() - APP/Model/AppModel.php, line 64
DboSource::query() - CORE/Cake/Model/Datasource/DboSource.php, line 599
Model::__call() - CORE/Cake/Model/Model.php, line 827
EmployerMobileImage::findByEmployerId() - APP/Model/EmployerMobileImage.php, line 7
EmployerMobileImage::getMobileImage() - APP/Model/EmployerMobileImage.php, line 7
EmployerInitializationComponent::initPublicPage() - APP/Controller/Component/EmployerInitializationComponent.php, line 60
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 766
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
Work for Kollar Chocolates in Yountville, CAWarning (2): filemtime(): stat failed for /var/app/current/app/View/Layouts/../../webroot/css/proven.responsive.min.css [APP/View/Layouts/responsive.ctp, line 69]
$viewFile = '/var/app/current/app/View/Layouts/responsive.ctp'
$dataForView = array(
'metatag_description' => 'Find work and jobs at Kollar Chocolates in <span class='locality'>Yountville</span>, <span class='region'>California</span>.',
'title_for_layout' => 'Work for Kollar Chocolates in Yountville, CA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Kollar Chocolates',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Yountville',
'state' => 'CA',
'lat' => '38.40760040',
'lon' => '-122.35700226',
'street_address' => '',
'id' => '17049',
'about_us' => 'As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94599',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/Kollar-Chocolates-160070767377117/',
'website' => 'http://www.kollarchocolates.com ',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Kollar Chocolates',
'employers_own_page' => false,
'mobile_image' => 'http://proven-employer-mobile-images.s3.amazonaws.com/w14785435631328216059_small.jpg',
'isMobile' => false,
'isWorker' => false,
'isSales' => false,
'isEducator' => false,
'adminLoggedIn' => false,
'isEmployer' => false,
'loggedIn' => false,
'isFacebookAppUser' => false,
'campaign' => 'NONE',
'content_for_layout' => '
<div id="proven-public-page">
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1 col-sm-12">
<div class="hidden-xs" style="margin-bottom:20px;">
<div class="back-button-panel">
<a class="blue-link" style="" href="/jobs/search" title="View All Jobs">← View All Jobs</a>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<div class="job-post-details">
<div class="row">
<div class="hidden-xs col-sm-2">
<div class="company-logo">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Kollar Chocolates</h1>
<p class="text-muted">Yountville, CA</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
<p class="voffset1"><a class="blue-link" href="http://www.kollarchocolates.com " target="_blank">http://www.kollarchocolates.com </a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/Kollar-Chocolates-160070767377117/" target="_new" title="Kollar Chocolates Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Kollar Chocolates" alt="Kollar Chocolates" src="http://proven-employer-mobile-images.s3.amazonaws.com/w14785435631328216059_small.jpg" class="img-responsive center-block" />
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 13, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44432" job_id="44432" href="/jobs/view/44432" title="Retail Sales Counter Position"><strong>Retail Sales Counter Position</strong></a>
</h2>
<div class="job-location">Napa County</div>
</div>
<div class="col-xs-12">
<p class="description">About UsKollar Chocolates is a chocolate shop in Yountville, CA. We create all of our truffles and chocolate confections in an open display kitchen housed in our shop. Our team is a small, efficient team, always willing to pitch in and help to get the job done. As seen in O Magazine and named Top...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. </p>
</div>
</div>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<p>
<strong>Search, browse and apply to jobs on iOS and Android</strong>
</p>
<div>
<a href="/candidates/app" target="_blank" title="Download the iPhone App">
<img src="/css/images/App_Store_available.png" width="112" />
</a>
<a href="/candidates/app/google" target="_blank" title="Download the Android App">
<img src="/css/images/google_play_badge.png" width="112" />
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>',
'scripts_for_layout' => ''
)
$metatag_description = 'Find work and jobs at Kollar Chocolates in <span class='locality'>Yountville</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Kollar Chocolates in Yountville, CA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Kollar Chocolates',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Yountville',
'state' => 'CA',
'lat' => '38.40760040',
'lon' => '-122.35700226',
'street_address' => '',
'id' => '17049',
'about_us' => 'As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => '',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => '',
'zipcode' => '94599',
'yelp_page' => '',
'facebook_page' => 'https://www.facebook.com/Kollar-Chocolates-160070767377117/',
'website' => 'http://www.kollarchocolates.com ',
'company_logo' => '',
'twitter_name' => ''
),
'State' => array(
'name' => 'California'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44432',
'open' => '1',
'title' => 'Retail Sales Counter Position',
'unique_name' => '',
'description' => '<p><strong>About Us</strong><br /><br />Kollar Chocolates is a chocolate shop in Yountville, CA. We create all of our truffles and chocolate confections in an open display kitchen housed in our shop. Our team is a small, efficient team, always willing to pitch in and help to get the job done.</p>
<p>As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. </p>
<p><strong>www.kollarchocolates.com </strong></p>
<p><br /><strong>About the Job</strong><br /><br />With the variety of guests that visit Yountville, you'll spend a lot of time discussing chocolates. Throughout the week, you'll be boxing bon bons, making coffee drinks, scooping gelato, restocking, and responding to guests' questions. We're looking for a full-time or part time team member with the flexibility to work a variety of opening and closing shifts. This position offers $15/hour, plus tips. We also provide an employee discount and the opportunity to taste lots of chocolate. </p>
<p><strong> </strong></p>
<p><strong>About You</strong><br /><br />Our ideal candidate is outgoing, organized, and enjoys interacting with guests and other employees. You don't have to be a chocolate expert; we're happy to teach you all we know about the world chocolate. Previous coffee or food retail experience is a plus.<br /><br /><strong>Responsibilities</strong><br /><br /></p>
<ul>
<li>Be on time, dress professionally, and be ready to work.</li>
<li>Ability to share your excitement for Kollar Chocolates with visitors.</li>
<li>Engage guests with our bon bon making process and an explanation of our chocolates, especially your favorites!</li>
</ul>
<p> </p>
<p><strong>Requirements</strong></p>
<ul>
<li>Availability on weekends, mornings, and some evenings.</li>
<li>A passion for chocolate!</li>
<li>Familiarity with a fast-paced work environment.</li>
<li>1-2 years of retail or customer-facing work experience.</li>
<li>Proven ability to work well within a team environment.</li>
</ul>
<p><br /><br /><strong>How to Apply</strong><br /><br />If you are interested, we'd like to see your resume. Please email it to us in the body of the email. Keep in mind we value passion, attitude, and hard work.</p>
<p> </p>
<p> </p>',
'post_date' => '2019-08-14 00:59:15',
'compensation' => '',
'craigslist_city' => 'san francisco bay area',
'craigslist_sub_city' => 'north bay / marin',
'craigslist_sub_sub_city' => 'napa county',
'craigslist_state' => 'California'
)
)
)
$display_company_title = 'Jobs at Kollar Chocolates'
$employers_own_page = false
$mobile_image = 'http://proven-employer-mobile-images.s3.amazonaws.com/w14785435631328216059_small.jpg'
$isMobile = false
$isWorker = false
$isSales = false
$isEducator = false
$adminLoggedIn = false
$isEmployer = false
$loggedIn = false
$isFacebookAppUser = false
$campaign = 'NONE'
$content_for_layout = '
<div id="proven-public-page">
<div class="container">
<div class="row">
<div class="col-md-10 col-md-offset-1 col-sm-12">
<div class="hidden-xs" style="margin-bottom:20px;">
<div class="back-button-panel">
<a class="blue-link" style="" href="/jobs/search" title="View All Jobs">← View All Jobs</a>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<div class="job-post-details">
<div class="row">
<div class="hidden-xs col-sm-2">
<div class="company-logo">
<div class="image " style="height:75px;;overflow:hidden;;height:75px;">
<img class="underlayImg" src="/css/images/proven_logo.png" width = '75' border="0" height = '75' Image style="padding: 0px 0px;" />
<div class="cover"><img src="/img/transparent.gif" height = '75' Image /></div>
</div>
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Kollar Chocolates</h1>
<p class="text-muted">Yountville, CA</p>
<div class="vertical-spacer">
<script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
</div>
<p class="voffset1"><a class="blue-link" href="http://www.kollarchocolates.com " target="_blank">http://www.kollarchocolates.com </a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="https://www.facebook.com/Kollar-Chocolates-160070767377117/" target="_new" title="Kollar Chocolates Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</div>
<hr />
<div class="company-image">
<img title="Kollar Chocolates" alt="Kollar Chocolates" src="http://proven-employer-mobile-images.s3.amazonaws.com/w14785435631328216059_small.jpg" class="img-responsive center-block" />
</div>
<hr />
<div class="open-positions">
<h3>Open Positions</h3>
<div class="job-listing ui-box-shadow">
<div class="row job-link-panel">
<div class="col-xs-12 col-sm-4 col-sm-push-8">
<div class="date">August 13, 2019</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44432" job_id="44432" href="/jobs/view/44432" title="Retail Sales Counter Position"><strong>Retail Sales Counter Position</strong></a>
</h2>
<div class="job-location">Napa County</div>
</div>
<div class="col-xs-12">
<p class="description">About UsKollar Chocolates is a chocolate shop in Yountville, CA. We create all of our truffles and chocolate confections in an open display kitchen housed in our shop. Our team is a small, efficient team, always willing to pitch in and help to get the job done. As seen in O Magazine and named Top...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients. </p>
</div>
</div>
</div>
</div>
</div>
<div class="panel panel-default">
<div class="panel-body">
<p>
<strong>Search, browse and apply to jobs on iOS and Android</strong>
</p>
<div>
<a href="/candidates/app" target="_blank" title="Download the iPhone App">
<img src="/css/images/App_Store_available.png" width="112" />
</a>
<a href="/candidates/app/google" target="_blank" title="Download the Android App">
<img src="/css/images/google_play_badge.png" width="112" />
</a>
</div>
</div>
</div>
</div>
</div>
</div>
</div>'
$scripts_for_layout = ''
$no_title_bar = false
$no_bottom_bar = false
$no_index = false
filemtime - [internal], line ??
include - APP/View/Layouts/responsive.ctp, line 69
View::_evaluate() - CORE/Cake/View/View.php, line 961
View::_render() - CORE/Cake/View/View.php, line 923
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - CORE/Cake/Controller/Controller.php, line 960
EmployersController::publicPage() - APP/Controller/EmployersController.php, line 769
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 118
About UsKollar Chocolates is a chocolate shop in Yountville, CA. We create all of our truffles and chocolate confections in an open display kitchen housed in our shop. Our team is a small, efficient team, always willing to pitch in and help to get the job done. As seen in O Magazine and named Top...
About Us
As seen in O Magazine and named Top 10 Chocolatiers in North America by Dessert Professional, Kollar Chocolates is a growing artisan chocolate shop located in Yountville, the heart of Napa Valley, where chocolatier Chris Kollar and his team develop modern hand crafted truffles and innovative chocolates made with premium, seasonal ingredients.
Search, browse and apply to jobs on iOS and Android
(default) 3 queries took 2 ms
Nr
Query
Error
Affected
Num. rows
Took (ms)
1
SELECT `Employer`.`company_name`, `Employer`.`founded_date`, `Employer`.`city`, `Employer`.`state`, `Employer`.`lat`, `Employer`.`lon`, `Employer`.`street_address`, `Employer`.`id`, `Employer`.`about_us`, `Employer`.`company_benefits`, `Employer`.`other_information`, `Employer`.`cultural_description`, `Employer`.`company_expectations`, `Employer`.`recruitment_video`, `Employer`.`looking_for`, `State`.`name`, `Employer`.`zipcode`, `Employer`.`yelp_page`, `Employer`.`facebook_page`, `Employer`.`website`, `Employer`.`company_logo`, `Employer`.`twitter_name`, `User`.`email_validated`, `User`.`active` FROM `proven_production`.`employers` AS `Employer` left JOIN `proven_production`.`states` AS `State` ON (`Employer`.`state`=`State`.`abbreviation`) LEFT JOIN `proven_production`.`users` AS `User` ON (`Employer`.`user_id` = `User`.`id`) WHERE `Employer`.`id` = 17049 AND `Employer`.`active` = 1 LIMIT 1
1
1
1
2
SELECT `EmployersJob`.`id`, `EmployersJob`.`open`, `EmployersJob`.`title`, `EmployersJob`.`unique_name`, `EmployersJob`.`description`, `EmployersJob`.`post_date`, `EmployersJob`.`compensation`, `EmployersJob`.`craigslist_city`, `EmployersJob`.`craigslist_sub_city`, `EmployersJob`.`craigslist_sub_sub_city`, `EmployersJob`.`craigslist_state` FROM `proven_production`.`employers_jobs` AS `EmployersJob` LEFT JOIN `proven_production`.`ut_zipcodes` AS `UtZipcode` ON (`EmployersJob`.`zip` = `UtZipcode`.`zipcode`) WHERE `EmployersJob`.`employer_id` = 17049 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`anonymous_post` = 0 GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`post_date` DESC
1
1
1
3
SELECT `EmployerMobileImage`.`file_name` FROM `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` WHERE `EmployerMobileImage`.`employer_id` = 17049 LIMIT 1