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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer_first_27313586ce3129948dad95b0525212bc'
$value = array(
	'version' => (int) 0,
	'data' => array(
		'Employer' => array(
			'company_name' => 'DH Drywall Inc.',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'San Jose',
			'state' => 'CA',
			'lat' => '37.25690079',
			'lon' => '-121.92299652',
			'street_address' => '',
			'id' => '30134',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '95124',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'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]

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

Code Context

                ),
                E_USER_WARNING
            );

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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage_first_3d7e118c17be56e4f000a027a7d9b62d'
$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 DH Drywall Inc. in <span class='locality'>San Jose</span>, <span class='region'>California</span>.',
	'title_for_layout' => 'Work for DH Drywall Inc. in San Jose, CA',
	'company_images' => array(),
	'employer_info' => array(
		'Employer' => array(
			'company_name' => 'DH Drywall Inc.',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'San Jose',
			'state' => 'CA',
			'lat' => '37.25690079',
			'lon' => '-121.92299652',
			'street_address' => '',
			'id' => '30134',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '95124',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'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 DH Drywall 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">
                                                                                    
    <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>DH Drywall Inc.</h1>

                                    <p class="text-muted">San Jose, CA</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">November 16, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44587" job_id="44587" href="/jobs/view/44587" title="Drywall-Journeyman Taper & Finisher Wanted"><strong>Drywall-Journeyman Taper & Finisher Wanted</strong></a>
            </h2>
            <div class="job-location">San Jose North</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Small, reputable drywall company has an immediate opening for an experienced taper and finish journeyman. Part time or full time. Must haves are transportation, good communication skills, some tools, good strong work ethic and a clean background. 20-30$ per hour depending on experience.   Job duties...</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 DH Drywall Inc. in <span class='locality'>San Jose</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for DH Drywall Inc. in San Jose, CA'
$company_images = array()
$employer_info = array(
	'Employer' => array(
		'company_name' => 'DH Drywall Inc.',
		'founded_date' => '0000-00-00 00:00:00',
		'city' => 'San Jose',
		'state' => 'CA',
		'lat' => '37.25690079',
		'lon' => '-121.92299652',
		'street_address' => '',
		'id' => '30134',
		'about_us' => '',
		'company_benefits' => '',
		'other_information' => '',
		'cultural_description' => '',
		'company_expectations' => '',
		'recruitment_video' => '',
		'looking_for' => '',
		'zipcode' => '95124',
		'yelp_page' => '',
		'facebook_page' => '',
		'website' => null,
		'company_logo' => '',
		'twitter_name' => ''
	),
	'State' => array(
		'name' => 'California'
	),
	'User' => array(
		'email_validated' => '0',
		'active' => '1'
	)
)
$open_positions = array(
	(int) 0 => array(
		'EmployersJob' => array(
			'id' => '44587',
			'open' => '1',
			'title' => 'Drywall-Journeyman Taper & Finisher Wanted',
			'unique_name' => '',
			'description' => '<p>Small, reputable drywall company has an immediate opening for an experienced taper and finish journeyman. Part time or full time. Must haves are transportation, good communication skills, some tools, good strong work ethic and a clean background. 20-30$ per hour depending on experience.&nbsp;</p>
<p>Job duties include patch work, texturing, Sheetrock patch installation, use of hot mud, corner bead installation and clean up.</p>
<p>Jobs are mostly based in the San Jose area to the Mountain View area. Lots of 1-2 day jobs and then move on to the next job.</p>',
			'post_date' => '2018-11-16 17:20:25',
			'compensation' => '',
			'craigslist_city' => 'san francisco bay area',
			'craigslist_sub_city' => 'south bay area',
			'craigslist_sub_sub_city' => 'san jose north',
			'craigslist_state' => 'California'
		)
	)
)
$display_company_title = 'Jobs at DH Drywall 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">
                                                                                    
    <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>DH Drywall Inc.</h1>

                                    <p class="text-muted">San Jose, CA</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">November 16, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44587" job_id="44587" href="/jobs/view/44587" title="Drywall-Journeyman Taper & Finisher Wanted"><strong>Drywall-Journeyman Taper & Finisher Wanted</strong></a>
            </h2>
            <div class="job-location">San Jose North</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Small, reputable drywall company has an immediate opening for an experienced taper and finish journeyman. Part time or full time. Must haves are transportation, good communication skills, some tools, good strong work ethic and a clean background. 20-30$ per hour depending on experience.   Job duties...</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

DH Drywall Inc.

San Jose, CA

Open Positions

November 16, 2018

Drywall-Journeyman Taper & Finisher Wanted

San Jose North

Small, reputable drywall company has an immediate opening for an experienced taper and finish journeyman. Part time or full time. Must haves are transportation, good communication skills, some tools, good strong work ethic and a clean background. 20-30$ per hour depending on experience. Job duties...

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