Notice (8): MemcachePool::get(): Server proven-cache.kmvdqz.cfg.use1.cache.amazonaws.com (tcp 11211, udp 0) failed with: Connection timed out (110) [CORE/Cake/Cache/Engine/MemcacheEngine.php, line 152]

 */
    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_8be3b725ac4ef6cc755a8bf2bc00e4da' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer_first_8be3b725ac4ef6cc755a8bf2bc00e4da'
$value = array(
	'version' => (int) 0,
	'data' => array(
		'Employer' => array(
			'company_name' => 'Scottsdale Community Bank (in organization)',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Scottsdale',
			'state' => 'AZ',
			'lat' => '33.57239914',
			'lon' => '-111.89900208',
			'street_address' => '',
			'id' => '30269',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '85258',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => '',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'Arizona'
		),
		'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]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer'
$value = (int) 0
$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 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_28aabef24bcb2a86f53fb1c7c9e52a63' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employersjob_all_28aabef24bcb2a86f53fb1c7c9e52a63'
$value = array(
	'version' => (int) 0,
	'data' => array(
		(int) 0 => array(
			'EmployersJob' => array(
				[maximum depth reached]
			)
		)
	)
)
$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
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]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employersjob'
$value = (int) 0
$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 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_a3b20d2f44bf04cec0466c9fe0d3eb51' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage_first_a3b20d2f44bf04cec0466c9fe0d3eb51'
$value = array(
	'version' => (int) 0,
	'data' => array()
)
$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
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]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage'
$value = (int) 0
$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 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

Code Context

          <? endif; ?>

          <link rel="stylesheet" href="/css/proven.responsive.min.css?<?= filemtime(__DIR__.'/../../webroot/css/proven.responsive.min.css'); ?>" type="text/css" />

$viewFile = '/var/app/current/app/View/Layouts/responsive.ctp'
$dataForView = array(
	'metatag_description' => 'Find work and jobs at Scottsdale Community Bank (in organization) in <span class='locality'>Scottsdale</span>, <span class='region'>Arizona</span>.',
	'title_for_layout' => 'Work for Scottsdale Community Bank (in organization) in Scottsdale, AZ',
	'company_images' => array(),
	'employer_info' => array(
		'Employer' => array(
			'company_name' => 'Scottsdale Community Bank (in organization)',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Scottsdale',
			'state' => 'AZ',
			'lat' => '33.57239914',
			'lon' => '-111.89900208',
			'street_address' => '',
			'id' => '30269',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '85258',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => '',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'Arizona'
		),
		'User' => array(
			'email_validated' => '0',
			'active' => '1'
		)
	),
	'open_positions' => array(
		(int) 0 => array(
			'EmployersJob' => array(
				[maximum depth reached]
			)
		)
	),
	'display_company_title' => 'Jobs at Scottsdale Community Bank (in organization)',
	'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">
                                                                                    
    <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>Scottsdale Community Bank (in organization)</h1>

                                    <p class="text-muted">Scottsdale, AZ</p>

                                    <div class="vertical-spacer">
                                        <script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
                                    </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">December 20, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44793" job_id="44793" href="/jobs/view/44793" title="Chief Lending Officer"><strong>Chief Lending Officer</strong></a>
            </h2>
            <div class="job-location">East Valley</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Scottsdale Community Bank (in organization), a dynamic new bank for a dynamic community, is seeking a Chief Lending Officer to share our vision and play a key role in the preparation of our launch, upon federal and state approval, and our continued operations. The qualifications and responsibilities...</p>
        </div>
    </div>
    
        </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 Scottsdale Community Bank (in organization) in <span class='locality'>Scottsdale</span>, <span class='region'>Arizona</span>.'
$title_for_layout = 'Work for Scottsdale Community Bank (in organization) in Scottsdale, AZ'
$company_images = array()
$employer_info = array(
	'Employer' => array(
		'company_name' => 'Scottsdale Community Bank (in organization)',
		'founded_date' => '0000-00-00 00:00:00',
		'city' => 'Scottsdale',
		'state' => 'AZ',
		'lat' => '33.57239914',
		'lon' => '-111.89900208',
		'street_address' => '',
		'id' => '30269',
		'about_us' => '',
		'company_benefits' => '',
		'other_information' => '',
		'cultural_description' => '',
		'company_expectations' => '',
		'recruitment_video' => '',
		'looking_for' => '',
		'zipcode' => '85258',
		'yelp_page' => '',
		'facebook_page' => '',
		'website' => null,
		'company_logo' => '',
		'twitter_name' => ''
	),
	'State' => array(
		'name' => 'Arizona'
	),
	'User' => array(
		'email_validated' => '0',
		'active' => '1'
	)
)
$open_positions = array(
	(int) 0 => array(
		'EmployersJob' => array(
			'id' => '44793',
			'open' => '1',
			'title' => 'Chief Lending Officer',
			'unique_name' => '',
			'description' => '<p>Scottsdale Community Bank (in organization), a dynamic new bank for a dynamic community, is seeking a Chief Lending Officer to share our vision and play a key role in the preparation of our launch, upon federal and state approval, and our continued operations. The qualifications and responsibilities include:</p>
<p>*Formal credit training with strong credit skills</p>
<p>*Experienced commercial lender with 10+ years of lending experience</p>
<p>*Lender in the metro Phoenix, Arizona, area for at least 5 years</p>
<p>*Experienced in real estate and commercial lending</p>
<p>*Ability to source new loan opportunities from new and existing clients</p>
<p>*Supervisory experience</p>
<p>*Experience with managing a loan portfolio</p>
<p>*Experience in formulating loan commitment letters and loan documentation</p>
<p>*Strategic portfolio management skills including risk, pricing, and profitability</p>
<p>*Strong leadership skills</p>
<p>* Will interface with federal and state authorities</p>
<p>*Will interface with the banking industry and the community</p>
<p>&nbsp;</p>',
			'post_date' => '2018-12-21 05:35:15',
			'compensation' => '',
			'craigslist_city' => 'phoenix',
			'craigslist_sub_city' => 'east valley',
			'craigslist_sub_sub_city' => '',
			'craigslist_state' => 'Arizona'
		)
	)
)
$display_company_title = 'Jobs at Scottsdale Community Bank (in organization)'
$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">
                                                                                    
    <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>Scottsdale Community Bank (in organization)</h1>

                                    <p class="text-muted">Scottsdale, AZ</p>

                                    <div class="vertical-spacer">
                                        <script type="text/javascript" src="https://s7.addthis.com/js/250/addthis_widget.js#pubid=seanfalconer"></script>
                                    </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">December 20, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44793" job_id="44793" href="/jobs/view/44793" title="Chief Lending Officer"><strong>Chief Lending Officer</strong></a>
            </h2>
            <div class="job-location">East Valley</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Scottsdale Community Bank (in organization), a dynamic new bank for a dynamic community, is seeking a Chief Lending Officer to share our vision and play a key role in the preparation of our launch, upon federal and state approval, and our continued operations. The qualifications and responsibilities...</p>
        </div>
    </div>
    
        </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

← View All Jobs

Scottsdale Community Bank (in organization)

Scottsdale, AZ

Open Positions

December 20, 2018

Chief Lending Officer

East Valley

Scottsdale Community Bank (in organization), a dynamic new bank for a dynamic community, is seeking a Chief Lending Officer to share our vision and play a key role in the preparation of our launch, upon federal and state approval, and our continued operations. The qualifications and responsibilities...

Search, browse and apply to jobs on iOS and Android

(default) 3 queries took 2 ms
Nr	Query	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` = 30269 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` = 30269 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` = 30269 LIMIT 1	0	0	0

(default) 3 queries took 2 ms

Query

Error

Affected

Num. rows

Took (ms)

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` = 30269 AND `Employer`.`active` = 1 LIMIT 1

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` = 30269 AND `EmployersJob`.`open` = 1 AND `EmployersJob`.`anonymous_post` = 0 GROUP BY `EmployersJob`.`id` ORDER BY `EmployersJob`.`post_date` DESC

SELECT `EmployerMobileImage`.`file_name` FROM `proven_production`.`employer_mobile_images` AS `EmployerMobileImage` WHERE `EmployerMobileImage`.`employer_id` = 30269 LIMIT 1