The Premiere Health Care Recruitment Solution

Nearly 14 million people are employed in the health care industry today. The Bureau of Labor Statistics estimates the health care industry will outgrow all other industries in the next ten years, with a 27% growth resulting in 3 million more jobs. This trend is attributed to the aging population along with changes in the managerial aspects of the industry.

Benefits of Our All-Inclusive

Site Free Membership
Resume Posting
MedCom, a social network for the medical community
Medical Forums
Health Care Event Information
Industry-Specific Video Center

Finding the Best Health Care Professional

Targeted Marketing
Powerful Platform
Occupational Resources

Meeting Industry Needs

Reference Video Center
Top Organic Search Results
Social Networking Platforms

Healthy Return on Investment

Incredibly Low Rates
Customized Packages that Fit Individual Business Needs
National Candidate Searches
Specialized Employment Fields
Information on Current Industry Trends

Employer Sign In

$this->params

Progname: basics.php
Line:312

Array
(
    [pass] => Array
        (
        )

    [named] => Array
        (
        )

    [controller] => Recruiters
    [plugin] => 
    [action] => index
    [form] => Array
        (
        )

    [url] => Array
        (
            [url] => Recruiters
        )

    [models] => Array
        (
            [0] => Recruiter
            [1] => LoginRecruiter
            [2] => User
            [3] => Profession
            [4] => Company
            [5] => JobType
            [6] => Job
            [7] => State
            [8] => Application
            [9] => VideoDmc
            [10] => VideoPurchaseHistory
            [11] => VideoDmcChild
            [12] => Login
            [13] => PackagePurchase
            [14] => Specialty
        )

)

(default) 22 queries took 1513 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES	115	115	99
2	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	47
3	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	47
4	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	46
5	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'	8	8	46
6	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	47
7	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('vw_login_recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('vw_login_recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'vw_login_recruiter'	16	16	243
8	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	52
9	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'	29	29	50
10	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('Job_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Job_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Job_Type'	6	6	58
11	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	48
12	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	50
13	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_dmc', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_dmc'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_dmc'	22	22	61
14	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_package', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_package'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_package'	7	7	61
15	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_hosts', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_hosts'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_hosts'	4	4	63
16	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_category', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_category'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_category'	8	8	142
17	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_creator', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_creator'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_creator'	4	4	64
18	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_purchase_history', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_purchase_history'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_purchase_history'	6	6	68
19	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('video_dmc_child', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_dmc_child'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_dmc_child'	6	6	62
20	SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('package_purchase', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('package_purchase'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'package_purchase'	12	12	56
21	SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'Recruiters' AND action = 'index' AND status = 'A' ORDER BY [level] DESC,weight DESC	0	0	52
22	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	51

(default) 22 queries took 1513 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES

115

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('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('vw_login_recruiter', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('vw_login_recruiter'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'vw_login_recruiter'

243

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('Job_Type', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('Job_Type'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Job_Type'

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('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('video_dmc', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('video_dmc'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'video_dmc'

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

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

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

142

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

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

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

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

SELECT id,controller,action,condition,level,title, seo_heading,seo_text,no_cache,keywords, description,robots,googlebot,weight,status FROM seo WHERE controller = 'Recruiters' AND action = 'index' 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

The Premiere Health Care Recruitment Solution

Benefits of Our All-Inclusive

Finding the Best Health Care Professional

Meeting Industry Needs

Healthy Return on Investment

Employer Sign In

Members

Employers

Site

$_SESSION

$this->params