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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer_first_f1419bad5c77c163c606e92215fbc734'
$value = array(
	'version' => (int) 0,
	'data' => array(
		'Employer' => array(
			'company_name' => 'Abrolat Law pc',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'El Segundo',
			'state' => 'CA',
			'lat' => '33.92380142',
			'lon' => '-118.40599823',
			'street_address' => '',
			'id' => '30029',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '90245',
			'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_64cce253e143c410c9f00f1aedee8bf0' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage_first_9408c31f4079bef482355e7373ce581b'
$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 Abrolat Law pc in <span class='locality'>El Segundo</span>, <span class='region'>California</span>.',
	'title_for_layout' => 'Work for Abrolat Law pc in El Segundo, CA',
	'company_images' => array(),
	'employer_info' => array(
		'Employer' => array(
			'company_name' => 'Abrolat Law pc',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'El Segundo',
			'state' => 'CA',
			'lat' => '33.92380142',
			'lon' => '-118.40599823',
			'street_address' => '',
			'id' => '30029',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '90245',
			'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 Abrolat Law pc',
	'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>Abrolat Law pc</h1>

                                    <p class="text-muted">El Segundo, 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">October 24, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44419" job_id="44419" href="/jobs/view/44419" title="Associate Attorney"><strong>Associate Attorney</strong></a>
            </h2>
            <div class="job-location">Westside-southbay-310</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">South Bay employment law boutique firm seeks motivated California licensed associate attorney with 2-5 years of experience looking for a growth and development opportunity. Firm specializes in employment litigation and trials.   Strong academic credentials and analytic skills are required for an associate...</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 Abrolat Law pc in <span class='locality'>El Segundo</span>, <span class='region'>California</span>.'
$title_for_layout = 'Work for Abrolat Law pc in El Segundo, CA'
$company_images = array()
$employer_info = array(
	'Employer' => array(
		'company_name' => 'Abrolat Law pc',
		'founded_date' => '0000-00-00 00:00:00',
		'city' => 'El Segundo',
		'state' => 'CA',
		'lat' => '33.92380142',
		'lon' => '-118.40599823',
		'street_address' => '',
		'id' => '30029',
		'about_us' => '',
		'company_benefits' => '',
		'other_information' => '',
		'cultural_description' => '',
		'company_expectations' => '',
		'recruitment_video' => '',
		'looking_for' => '',
		'zipcode' => '90245',
		'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' => '44419',
			'open' => '1',
			'title' => 'Associate Attorney',
			'unique_name' => '',
			'description' => '<p>South Bay employment law boutique firm seeks motivated California licensed associate attorney with 2-5 years of experience looking for a growth and development opportunity. Firm specializes in employment litigation and trials.</p>
<ul>
<li>Strong academic credentials and analytic skills are required for an associate attorney.</li>
<li>Ability to handle a high case load and a willingness to meet personally with all clients.</li>
<li>Communicating with clients to learn about their legal needs and concerns and providing them with advice.</li>
<li>Developing strategies to resolve cases favorably and cost-effectively for clients.</li>
<li>Explaining legal options to clients and bringing possible outcomes or threats to their attention.</li>
<li>Building relationships with clients based on trust.</li>
<li>Developing arguments and representing clients in civil legal proceedings.</li>
<li>Preparing legal documents, such as contracts, dispositions, and pleadings, accurately and in a timely manner.</li>
<li>Staying informed about current legislation, especially concerning legal specialties.</li>
<li>Finding ethical solutions to legal matters.</li>
</ul>',
			'post_date' => '2018-10-25 01:21:37',
			'compensation' => '',
			'craigslist_city' => 'los angeles',
			'craigslist_sub_city' => 'westside-southbay-310',
			'craigslist_sub_sub_city' => '',
			'craigslist_state' => 'California'
		)
	)
)
$display_company_title = 'Jobs at Abrolat Law pc'
$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>Abrolat Law pc</h1>

                                    <p class="text-muted">El Segundo, 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">October 24, 2018</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="44419" job_id="44419" href="/jobs/view/44419" title="Associate Attorney"><strong>Associate Attorney</strong></a>
            </h2>
            <div class="job-location">Westside-southbay-310</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">South Bay employment law boutique firm seeks motivated California licensed associate attorney with 2-5 years of experience looking for a growth and development opportunity. Firm specializes in employment litigation and trials.   Strong academic credentials and analytic skills are required for an associate...</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

Abrolat Law pc

El Segundo, CA

Open Positions

October 24, 2018

Associate Attorney

Westside-southbay-310

South Bay employment law boutique firm seeks motivated California licensed associate attorney with 2-5 years of experience looking for a growth and development opportunity. Firm specializes in employment litigation and trials. Strong academic credentials and analytic skills are required for an associate...

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