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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employer_first_10a4b0505906015e21b7f7580c445600'
$value = array(
	'version' => (int) 0,
	'data' => array(
		'Employer' => array(
			'company_name' => 'PI Firm Fort Worth Texas',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Fort Worth',
			'state' => 'TX',
			'lat' => '32.77980042',
			'lon' => '-97.30269623',
			'street_address' => '',
			'id' => '30765',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '76111',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => '',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'Texas'
		),
		'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_09e900e2cea40efafaad647878bb9bc8' to Memcache cache [CORE/Cake/Cache/Cache.php, line 328]

Code Context

                ),
                E_USER_WARNING
            );

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

Code Context

                ),
                E_USER_WARNING
            );

$key = '_employermobileimage_first_e4ba9f208dd45f1167f9c4ab9e7b3d30'
$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 PI Firm Fort Worth Texas in <span class='locality'>Fort Worth</span>, <span class='region'>Texas</span>.',
	'title_for_layout' => 'Work for PI Firm Fort Worth Texas in Fort Worth, TX',
	'company_images' => array(),
	'employer_info' => array(
		'Employer' => array(
			'company_name' => 'PI Firm Fort Worth Texas',
			'founded_date' => '0000-00-00 00:00:00',
			'city' => 'Fort Worth',
			'state' => 'TX',
			'lat' => '32.77980042',
			'lon' => '-97.30269623',
			'street_address' => '',
			'id' => '30765',
			'about_us' => '',
			'company_benefits' => '',
			'other_information' => '',
			'cultural_description' => '',
			'company_expectations' => '',
			'recruitment_video' => '',
			'looking_for' => '',
			'zipcode' => '76111',
			'yelp_page' => '',
			'facebook_page' => '',
			'website' => null,
			'company_logo' => '',
			'twitter_name' => ''
		),
		'State' => array(
			'name' => 'Texas'
		),
		'User' => array(
			'email_validated' => '0',
			'active' => '1'
		)
	),
	'open_positions' => array(
		(int) 0 => array(
			'EmployersJob' => array(
				[maximum depth reached]
			)
		)
	),
	'display_company_title' => 'Jobs at PI Firm Fort Worth Texas',
	'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>PI Firm Fort Worth Texas</h1>

                                    <p class="text-muted">Fort Worth, TX</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">April 08, 2019</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="45484" job_id="45484" href="/jobs/view/45484" title="PI pre litigation attorney"><strong>PI pre litigation attorney</strong></a>
            </h2>
            <div class="job-location">Fort Worth</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Small 35 year old PI Firm seeks entry level associate for Pre Litigation work.  No whiners, spoiled brats, or inflated egos.  Great opportunity for the right candidate. </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 PI Firm Fort Worth Texas in <span class='locality'>Fort Worth</span>, <span class='region'>Texas</span>.'
$title_for_layout = 'Work for PI Firm Fort Worth Texas in Fort Worth, TX'
$company_images = array()
$employer_info = array(
	'Employer' => array(
		'company_name' => 'PI Firm Fort Worth Texas',
		'founded_date' => '0000-00-00 00:00:00',
		'city' => 'Fort Worth',
		'state' => 'TX',
		'lat' => '32.77980042',
		'lon' => '-97.30269623',
		'street_address' => '',
		'id' => '30765',
		'about_us' => '',
		'company_benefits' => '',
		'other_information' => '',
		'cultural_description' => '',
		'company_expectations' => '',
		'recruitment_video' => '',
		'looking_for' => '',
		'zipcode' => '76111',
		'yelp_page' => '',
		'facebook_page' => '',
		'website' => null,
		'company_logo' => '',
		'twitter_name' => ''
	),
	'State' => array(
		'name' => 'Texas'
	),
	'User' => array(
		'email_validated' => '0',
		'active' => '1'
	)
)
$open_positions = array(
	(int) 0 => array(
		'EmployersJob' => array(
			'id' => '45484',
			'open' => '1',
			'title' => 'PI pre litigation attorney',
			'unique_name' => '',
			'description' => '<p>Small 35 year old PI Firm seeks entry level associate for Pre Litigation work.</p>
<p>No whiners, spoiled brats, or inflated egos. &nbsp;Great opportunity for the right candidate.</p>',
			'post_date' => '2019-04-09 02:56:48',
			'compensation' => '',
			'craigslist_city' => 'dallas / fort worth',
			'craigslist_sub_city' => 'fort worth',
			'craigslist_sub_sub_city' => '',
			'craigslist_state' => 'Texas'
		)
	)
)
$display_company_title = 'Jobs at PI Firm Fort Worth Texas'
$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>PI Firm Fort Worth Texas</h1>

                                    <p class="text-muted">Fort Worth, TX</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">April 08, 2019</div>
                    </div>

        <div class="col-xs-12 col-sm-8 col-sm-pull-4">
            <h2>
                <a class="job-link blue-link" id="45484" job_id="45484" href="/jobs/view/45484" title="PI pre litigation attorney"><strong>PI pre litigation attorney</strong></a>
            </h2>
            <div class="job-location">Fort Worth</div>
        </div>
        
        <div class="col-xs-12">
            <p class="description">Small 35 year old PI Firm seeks entry level associate for Pre Litigation work.  No whiners, spoiled brats, or inflated egos.  Great opportunity for the right candidate. </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

PI Firm Fort Worth Texas

Fort Worth, TX

Open Positions

April 08, 2019

PI pre litigation attorney

Fort Worth

Small 35 year old PI Firm seeks entry level associate for Pre Litigation work. No whiners, spoiled brats, or inflated egos. Great opportunity for the right candidate.

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