Search Thousands of Health Care Jobs

Jobs

Browse Jobs > by Employer >

No jobs found.

Spotlight Employers

Sign Up For Job Alerts

$_SESSION

Progname: basics.php
Line:312

Array
(
    [Config] => Array
        (
            [userAgent] => 
            [time] => 31329950739
            [timeout] => 10
        )

    [oldParams] => Array
        (
            [pass] => Array
                (
                )

            [named] => Array
                (
                )

            [controller] => profession
            [action] => getActive
            [plugin] => 
            [form] => Array
                (
                )

            [url] => Array
                (
                    [url] => /profession/getActive/
                )

            [autoRender] => 0
            [return] => 1
            [bare] => 1
            [requested] => 1
        )

)

$this->params

Progname: basics.php
Line:312

Array
(
    [pass] => Array
        (
            [0] => compid-6264
            [1] => capital-nursing-solutions
        )

    [named] => Array
        (
        )

    [plugin] => 
    [controller] => jobs
    [action] => browseEmployerJobs
    [form] => Array
        (
        )

    [url] => Array
        (
            [url] => browse-by-employer/compid-6264/capital-nursing-solutions
        )

    [models] => Array
        (
            [0] => Job
            [1] => State
            [2] => City
            [3] => Profession
            [4] => GsaLocation
            [5] => Company
            [6] => SavedJob
            [7] => Specialty
            [8] => Application
            [9] => Availability
            [10] => UploadFile
            [11] => User
            [12] => JacJob
            [13] => Recruiter
        )

)

(default) 22 queries took 542 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES	127	127	23
2	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('State', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('State'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'State'	8	8	10
3	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('city', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('city'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'city'	5	5	9
4	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Profession', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Profession'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Profession'	5	5	11
5	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Company', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Company'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Company'	31	31	15
6	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Saved_Job', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Saved_Job'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Saved_Job'	7	7	11
7	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Application', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Application'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Application'	27	27	13
8	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Availability', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Availability'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Availability'	5	5	9
9	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter_Profile', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter_Profile'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter_Profile'	19	19	11
10	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter'	25	25	12
11	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login'	11	11	10
12	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login_Type'	5	5	17
13	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Member', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Member'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Member'	9	9	17
14	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Files', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Files'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Files'	11	11	11
15	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'jobs' AND action = 'browseEmployerJobs' AND status = 'A' ORDER BY [level] DESC,weight DESC	1	1	11
16	select name from company where id = '6264'	0	0	10
17	exec [webuser].[usp_browse_company] @company_id = '6264', @sortby = 'NULL', @top_count = '100000', @result_count = '20', @start = '1'	-1	0	193
18	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'companies' AND action = 'getSpotlights' AND status = 'A' ORDER BY [level] DESC,weight DESC	0	0	31
19	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'home' AND action = 'index' AND status = 'A' ORDER BY [level] DESC,weight DESC	1	1	37
20	EXEC webuser.usp_get_spotlight_employer_cron @top_count = 8	-1	8	60
21	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'profession' AND action = 'getActive' AND status = 'A' ORDER BY [level] DESC,weight DESC	0	0	10
22	SELECT id, name FROM Profession (NOLOCK) where status = 'A' and id > 0 ORDER BY name	4	4	11

(default) 22 queries took 542 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

127

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('State', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('State'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'State'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('city', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('city'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'city'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Profession', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Profession'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Profession'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Company', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Company'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Company'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Saved_Job', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Saved_Job'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Saved_Job'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Application', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Application'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Application'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Availability', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Availability'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Availability'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter_Profile', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter_Profile'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter_Profile'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Recruiter'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Login_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Login_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Login_Type'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Member', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Member'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Member'

SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Files', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Files'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Files'

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'jobs' AND action = 'browseEmployerJobs' AND status = 'A' ORDER BY [level] DESC,weight DESC

select name from company where id = '6264'

exec [webuser].[usp_browse_company] @company_id = '6264', @sortby = 'NULL', @top_count = '100000', @result_count = '20', @start = '1'

-1

193

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'companies' AND action = 'getSpotlights' AND status = 'A' ORDER BY [level] DESC,weight DESC

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'home' AND action = 'index' AND status = 'A' ORDER BY [level] DESC,weight DESC

EXEC webuser.usp_get_spotlight_employer_cron @top_count = 8

-1

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'profession' AND action = 'getActive' AND status = 'A' ORDER BY [level] DESC,weight DESC

SELECT id, name FROM Profession (NOLOCK) where status = 'A' and id > 0 ORDER BY name

Jobs

Browse Jobs > by Employer >

Spotlight Employers

Sign Up For Job Alerts

Members

Employers

Site

$_SESSION

$this->params