LogoBttmtrans
 

Search Medical Companies Hiring

Select a letter to perform a job search by employer

Spotlight Employers

Advertisement

Advertisement

Advertisement

$_SESSION

Progname: basics.php
Line:312
Array
(
    [Config] => Array
        (
            [userAgent] => 
            [time] => 31329948747
            [timeout] => 10
        )

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

            [named] => Array
                (
                )

            [controller] => companies
            [action] => getSpotlights
            [plugin] => 
            [form] => Array
                (
                )

            [url] => Array
                (
                    [url] => companies/getSpotlights/8
                )

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

)

$this->params

Progname: basics.php
Line:312
Array
(
    [pass] => Array
        (
        )

    [named] => Array
        (
        )

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

    [url] => Array
        (
            [url] => browse-employer
        )

    [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) 19 queries took 292 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES12712715
2SELECT 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'8813
3SELECT 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'5510
4SELECT 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'5510
5SELECT 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'313114
6SELECT 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'7713
7SELECT 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'272714
8SELECT 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'5512
9SELECT 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'191912
10SELECT 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'252512
11SELECT 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'111111
12SELECT 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'5510
13SELECT 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'9910
14SELECT 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'111113
15SELECT 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 = 'browseEmployers' AND status = 'A' ORDER BY [level] DESC,weight DESC2211
16SELECT c.[id], c.[name], c.[status], COUNT(j.[id]) as [total_jobs] FROM [job] j (NOLOCK) JOIN [recruiter] r (NOLOCK) ON j.[recruiter_id] = r.[id] JOIN [company] c (NOLOCK) ON r.[company_id] = c.[id] AND c.[name] like 'A%' WHERE c.[is_confidential] <> 1 AND j.[status] = 'A' GROUP BY c.[id], c.[name], c.[status] ORDER BY c.[name] 131324
17SELECT 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 DESC0010
18SELECT 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 DESC1110
19EXEC webuser.usp_get_spotlight_employer_cron @top_count = 8-1868