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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer_first_0a409ab6db9aeadf4c78a4524ee78ced'
$value = array(
	'version' => (int) 0,
	'data' => array(
		'Employer' => array(
			'company_name' => 'Blue Ribbon Restaurant',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Schenectady',
			'state' => 'NY',
			'lat' => '42.78030014',
			'lon' => '-73.91000366',
			'street_address' => '',
			'id' => '29847',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '12304',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => 'w15380994302064103712_small.jpg',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'New York'
		),
		'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_19bff2ad04e32a1fa3bbdfd9b2271173' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employersjob_all_19bff2ad04e32a1fa3bbdfd9b2271173'
$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_0865f504f82282c5d11b21e46aca2b91' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage_first_0865f504f82282c5d11b21e46aca2b91'
$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 Blue Ribbon Restaurant in <span class='locality'>Schenectady</span>, <span class='region'>New York</span>.',
	'title_for_layout' => 'Work for Blue Ribbon Restaurant in Schenectady, NY',
	'company_images' => array(),
	'employer_info' => array(
		'Employer' => array(
			'company_name' => 'Blue Ribbon Restaurant',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Schenectady',
			'state' => 'NY',
			'lat' => '42.78030014',
			'lon' => '-73.91000366',
			'street_address' => '',
			'id' => '29847',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '12304',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => 'w15380994302064103712_small.jpg',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'New York'
		),
		'User' => array(
			'email_validated' => '0',
			'active' => '1'
		)
	),
	'open_positions' => array(
		(int) 0 => array(
			'EmployersJob' => array(
				[maximum depth reached]
			)
		)
	),
	'display_company_title' => 'Jobs at Blue Ribbon Restaurant',
	'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="Blue Ribbon Restaurant" alt="Blue Ribbon Restaurant" src="https://d2qez73695kjfi.cloudfront.net/w15380994302064103712_small.jpg" width="90" border="0" class="img-responsive center-block" />
                                                                            </div>
                                </div>
                                <div class="col-xs-12 col-sm-10">
                                    <h1>Blue Ribbon Restaurant</h1>

                                    <p class="text-muted">Schenectady, NY</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 29, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44814" job_id="44814" href="/jobs/view/44814" title="Servers - We are hiring now!"><strong>Servers - We are hiring now!</strong></a>
            </h2>
            <div class="job-location">Albany</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Seeking friendly, knowledgeable, service-oriented waiter with a passion for hospitality to join our team.  As the primary point of contact for guest interactions in the dining room, the server is responsible for selling and serving food and beverages using their knowledge, hospitality and service...</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 Blue Ribbon Restaurant in <span class='locality'>Schenectady</span>, <span class='region'>New York</span>.'
$title_for_layout = 'Work for Blue Ribbon Restaurant in Schenectady, NY'
$company_images = array()
$employer_info = array(
	'Employer' => array(
		'company_name' => 'Blue Ribbon Restaurant',
		'founded_date' => '0000-00-00 00:00:00',
		'city' => 'Schenectady',
		'state' => 'NY',
		'lat' => '42.78030014',
		'lon' => '-73.91000366',
		'street_address' => '',
		'id' => '29847',
		'about_us' => '',
		'company_benefits' => '',
		'other_information' => '',
		'cultural_description' => '',
		'company_expectations' => '',
		'recruitment_video' => '',
		'looking_for' => '',
		'zipcode' => '12304',
		'yelp_page' => '',
		'facebook_page' => '',
		'website' => null,
		'company_logo' => 'w15380994302064103712_small.jpg',
		'twitter_name' => ''
	),
	'State' => array(
		'name' => 'New York'
	),
	'User' => array(
		'email_validated' => '0',
		'active' => '1'
	)
)
$open_positions = array(
	(int) 0 => array(
		'EmployersJob' => array(
			'id' => '44814',
			'open' => '1',
			'title' => 'Servers - We are hiring now!',
			'unique_name' => '',
			'description' => '<p>Seeking friendly, knowledgeable, service-oriented waiter with a passion for hospitality to join our team.</p>
<p>As the primary point of contact for guest interactions in the dining room, the server is responsible for selling and serving food and beverages using their knowledge, hospitality and service skills.</p>
<p><strong>Responsibilities include</strong>:</p>
<ul>
<li>Making menu suggestions and describing the dishes to guests</li>
<li>Delivering food to tables</li>
<li>Overseeing table maintenance</li>
<li>Monitoring guest satisfaction</li>
<li>Familiar with POS</li>
<li>Able to carry multiple&nbsp;dishes without the use of trays</li>
<li>Able to work in a fast paced environment</li>
<li>Familiar with taking to go orders over the phone and packaging the order</li>
<li>minimum of 2-3 years prior experience.</li>
</ul>
<p>Must have a flexible schedule. &nbsp;</p>
<p>Interested applicants please submit your resume.</p>',
			'post_date' => '2018-12-29 19:36:14',
			'compensation' => '',
			'craigslist_city' => 'albany',
			'craigslist_sub_city' => '',
			'craigslist_sub_sub_city' => '',
			'craigslist_state' => 'New York'
		)
	)
)
$display_company_title = 'Jobs at Blue Ribbon Restaurant'
$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="Blue Ribbon Restaurant" alt="Blue Ribbon Restaurant" src="https://d2qez73695kjfi.cloudfront.net/w15380994302064103712_small.jpg" width="90" border="0" class="img-responsive center-block" />
                                                                            </div>
                                </div>
                                <div class="col-xs-12 col-sm-10">
                                    <h1>Blue Ribbon Restaurant</h1>

                                    <p class="text-muted">Schenectady, NY</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 29, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44814" job_id="44814" href="/jobs/view/44814" title="Servers - We are hiring now!"><strong>Servers - We are hiring now!</strong></a>
            </h2>
            <div class="job-location">Albany</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Seeking friendly, knowledgeable, service-oriented waiter with a passion for hospitality to join our team.  As the primary point of contact for guest interactions in the dining room, the server is responsible for selling and serving food and beverages using their knowledge, hospitality and service...</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

Blue Ribbon Restaurant

Schenectady, NY

Open Positions

December 29, 2018

Servers - We are hiring now!

Albany

Seeking friendly, knowledgeable, service-oriented waiter with a passion for hospitality to join our team. As the primary point of contact for guest interactions in the dining room, the server is responsible for selling and serving food and beverages using their knowledge, hospitality and service...

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` = 29847 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` = 29847 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` = 29847 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` = 29847 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` = 29847 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` = 29847 LIMIT 1