*/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_316b5a3602155f98de3438ce74767bc1' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]
$key = '_employer_first_316b5a3602155f98de3438ce74767bc1'
$value = array(
'version' => (int) 0,
'data' => array(
'Employer' => array(
'company_name' => 'Green Lady Shoppe, Inc',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Olympia',
'state' => 'WA',
'lat' => '47.00979996',
'lon' => '-122.87300110',
'street_address' => '',
'id' => '30033',
'about_us' => 'Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS! ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team. ',
'zipcode' => '98501',
'yelp_page' => '',
'facebook_page' => 'greenladyshoppe',
'website' => 'http://www.greenladyinc.com',
'company_logo' => 'w15405822081376521277_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Washington'
),
'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_a541e2c1941192bd4812957bbab058ea' 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_58bc563dd2ac997f6327dcb4838ab080' 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 Green Lady Shoppe, Inc in Olympia, WAWarning (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 Green Lady Shoppe, Inc in <span class='locality'>Olympia</span>, <span class='region'>Washington</span>.',
'title_for_layout' => 'Work for Green Lady Shoppe, Inc in Olympia, WA',
'company_images' => array(),
'employer_info' => array(
'Employer' => array(
'company_name' => 'Green Lady Shoppe, Inc',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Olympia',
'state' => 'WA',
'lat' => '47.00979996',
'lon' => '-122.87300110',
'street_address' => '',
'id' => '30033',
'about_us' => 'Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS! ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team. ',
'zipcode' => '98501',
'yelp_page' => '',
'facebook_page' => 'greenladyshoppe',
'website' => 'http://www.greenladyinc.com',
'company_logo' => 'w15405822081376521277_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Washington'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
),
'open_positions' => array(
(int) 0 => array(
'EmployersJob' => array(
[maximum depth reached]
)
)
),
'display_company_title' => 'Jobs at Green Lady Shoppe, Inc',
'employers_own_page' => false,
'mobile_image' => '',
'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">
<img title="Green Lady Shoppe, Inc" alt="Green Lady Shoppe, Inc" src="https://d2qez73695kjfi.cloudfront.net/w15405822081376521277_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Green Lady Shoppe, Inc</h1>
<p class="text-muted">Olympia, WA</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.greenladyinc.com" target="_blank">http://www.greenladyinc.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://greenladyshoppe" target="_new" title="Green Lady Shoppe, Inc Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</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">October 26, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44435" job_id="44435" href="/jobs/view/44435" title="Baristas - We are hiring now!"><strong>Baristas - We are hiring now!</strong></a>
</h2>
<div class="job-location">Olympia / Thurston</div>
</div>
<div class="col-xs-12">
<p class="description">Seeking baristas for popular espresso bar and glass & cbd shop. Responsibilities include: Making and serving hot and cold beverages including coffee and espresso Taking orders Opening and closing the station Maintaining inventory Sales Must have a flexible schedule. Must be 21 year old...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS! </p>
</div>
</div>
<div id="cultural_description">
<h3>Company Culture</h3>
<div class="content-panel ui-box-shadow">
<p>Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you. </p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team. </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 Green Lady Shoppe, Inc in <span class='locality'>Olympia</span>, <span class='region'>Washington</span>.'
$title_for_layout = 'Work for Green Lady Shoppe, Inc in Olympia, WA'
$company_images = array()
$employer_info = array(
'Employer' => array(
'company_name' => 'Green Lady Shoppe, Inc',
'founded_date' => '0000-00-00 00:00:00',
'city' => 'Olympia',
'state' => 'WA',
'lat' => '47.00979996',
'lon' => '-122.87300110',
'street_address' => '',
'id' => '30033',
'about_us' => 'Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS! ',
'company_benefits' => '',
'other_information' => '',
'cultural_description' => 'Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you. ',
'company_expectations' => '',
'recruitment_video' => '',
'looking_for' => 'We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team. ',
'zipcode' => '98501',
'yelp_page' => '',
'facebook_page' => 'greenladyshoppe',
'website' => 'http://www.greenladyinc.com',
'company_logo' => 'w15405822081376521277_small.jpg',
'twitter_name' => ''
),
'State' => array(
'name' => 'Washington'
),
'User' => array(
'email_validated' => '0',
'active' => '1'
)
)
$open_positions = array(
(int) 0 => array(
'EmployersJob' => array(
'id' => '44435',
'open' => '1',
'title' => 'Baristas - We are hiring now!',
'unique_name' => '',
'description' => '<p>Seeking baristas for popular espresso bar and glass & cbd shop.</p>
<p><strong>Responsibilities include</strong>:</p>
<ul>
<li>Making and serving hot and cold beverages including coffee and espresso</li>
<li>Taking orders</li>
<li>Opening and closing the station</li>
<li>Maintaining inventory</li>
<li>Sales</li>
</ul>
<p>Must have a flexible schedule. Must be 21 year old or older.</p>
<p>Interested applicants please submit your resume with current photo.</p>
<p> </p>
<p> </p>',
'post_date' => '2018-10-26 19:26:38',
'compensation' => '',
'craigslist_city' => 'seattle',
'craigslist_sub_city' => 'olympia / thurston',
'craigslist_sub_sub_city' => '',
'craigslist_state' => 'Washington'
)
)
)
$display_company_title = 'Jobs at Green Lady Shoppe, Inc'
$employers_own_page = false
$mobile_image = ''
$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">
<img title="Green Lady Shoppe, Inc" alt="Green Lady Shoppe, Inc" src="https://d2qez73695kjfi.cloudfront.net/w15405822081376521277_small.jpg" width="90" border="0" class="img-responsive center-block" />
</div>
</div>
<div class="col-xs-12 col-sm-10">
<h1>Green Lady Shoppe, Inc</h1>
<p class="text-muted">Olympia, WA</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.greenladyinc.com" target="_blank">http://www.greenladyinc.com</a></p>
<div class="filter-options">
<div class="map-panel">
<ul class="list-inline" style="margin-top:10px;">
<li>
<a rel="nofollow" href="http://greenladyshoppe" target="_new" title="Green Lady Shoppe, Inc Facebook Page">
<img width="32" src="/css/images/facebook-round-large.png" alt="" />
</a></li>
</ul>
</div>
</div>
</div>
</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">October 26, 2018</div>
</div>
<div class="col-xs-12 col-sm-8 col-sm-pull-4">
<h2>
<a class="job-link blue-link" id="44435" job_id="44435" href="/jobs/view/44435" title="Baristas - We are hiring now!"><strong>Baristas - We are hiring now!</strong></a>
</h2>
<div class="job-location">Olympia / Thurston</div>
</div>
<div class="col-xs-12">
<p class="description">Seeking baristas for popular espresso bar and glass & cbd shop. Responsibilities include: Making and serving hot and cold beverages including coffee and espresso Taking orders Opening and closing the station Maintaining inventory Sales Must have a flexible schedule. Must be 21 year old...</p>
</div>
</div>
</div>
</div>
<div id="about_us">
<h3>About Us</h3>
<div class="content-panel ui-box-shadow">
<p>Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS! </p>
</div>
</div>
<div id="cultural_description">
<h3>Company Culture</h3>
<div class="content-panel ui-box-shadow">
<p>Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you. </p>
</div>
</div>
<div id="looking_for">
<h3>What We Look For</h3>
<div class="content-panel ui-box-shadow">
<p>We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team. </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
Seeking baristas for popular espresso bar and glass & cbd shop. Responsibilities include: Making and serving hot and cold beverages including coffee and espresso Taking orders Opening and closing the station Maintaining inventory Sales Must have a flexible schedule. Must be 21 year old...
About Us
Opened in 2014, the Green Lady Shoppe is your one stop shopping experience! COFFEE, CBD, LOCAL GLASS! Local events! We offer a wide variety of hemp derived cbd products (contains no thc), bongs, pipes, vapes, dab rigs, papers, small batch locally roasted coffee, clothing, and more!!! Our expert team is always excited to talk with you about all things COFFEE, CBD and CANNABIS!
Company Culture
Green Lady Shoppe is a unique environment where coffee meets the hemp extract world. We are an ever growing company with lots of changes in store. If you thrive on growth and change, this is the company for you.
What We Look For
We are looking for hard working, dependable people who can take charge and get the job done to join our expanding team.
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` = 30033 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` = 30033 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` = 30033 LIMIT 1