State: Arizona Change state

Search Online Colleges Instead

Arizona Campuses : Massage, Healing & Health

Apollo College

Accreditation:

Accrediting Bureau of Health Education Schools (ABHES)

Campuses

Apollo College - Mesa, AZ

Programs

Cert./Diploma/ Massage Therapy

Apollo College - Phoenix, AZ

Programs

Cert./Diploma/ Massage Therapy

Apollo College - Tucson, AZ

Programs

Cert./Diploma/ Massage Therapy

Arizona School of Massage

Accreditation:

Accrediting Council for Continuing Education and Training (ACCET)

Campuses

Arizona School of Massage Therapy - Phoenix
Arizona School of Massage Therapy - Tempe

Cortiva Institute

Accreditation:

Commission on Massage Therapy Accreditation (COMTA)

Campuses

Cortiva Institute - School of Massage Therapy - Scottsdale
Cortiva Institute - Tucson

Online Business Colleges | Online Business schools | Business Colleges

Log and debug messages

#	type	message
1	PhpConfigHandler	php.ini "register_globals" key is better set to "false" (current value is "'1'" - php.ini location: "/usr/local/lib/php.ini")
2	Context	initialization
3	Controller	initialization
4	Routing	match route [search-results-state-program-slug] "/campus-schools/state/:state/program/:slug"
5	Request	request parameters array ( 'state' => 'arizona-colleges', 'slug' => 'massage-healing-and-health', 'module' => 'search', 'action' => 'perma_state_program',)
6	Controller	dispatch request
7	Filter	executing filter "sfRenderingFilter"
8	Filter	executing filter "sfWebDebugFilter"
9	Filter	executing filter "sfCommonFilter"
10	Filter	executing filter "sfFlashFilter"
11	Filter	flag old flash messages ("zipCode", "degree_id", "program_id", "state_id")
12	Filter	executing filter "sfExecutionFilter"
13	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
14	Creole	prepareStatement(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=?
15	Creole	applyLimit(): SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6, offset: 0, limit: 1
16	Creole	executeQuery(): [0.33 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 LIMIT 1
17	Action	call "searchActions->executePerma_state_program()"
18	Creole	prepareStatement(): SELECT state.ID, state.NAME FROM state WHERE state.NAME=?
19	Creole	applyLimit(): SELECT state.ID, state.NAME FROM state WHERE state.NAME='Arizona', offset: 0, limit: 1
20	Creole	executeQuery(): [0.51 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='Arizona' LIMIT 1
21	Creole	prepareStatement(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL=?
22	Creole	applyLimit(): SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health', offset: 0, limit: 1
23	Creole	executeQuery(): [0.32 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1
24	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
25	Creole	executeQuery(): [5.70 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
26	Creole	prepareStatement(): SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (?,?,?,?,?,?,?) ORDER BY UPPER(college.NAME) ASC
27	Creole	executeQuery(): [0.80 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (507,507,507,300,300,808,808) ORDER BY UPPER(college.NAME) ASC
28	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
29	Creole	executeQuery(): [5.37 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=507 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
30	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
31	Creole	executeQuery(): [3.51 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=510 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
32	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
33	Creole	executeQuery(): [3.27 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=512 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
34	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
35	Creole	executeQuery(): [2.08 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=514 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
36	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
37	Creole	executeQuery(): [5.59 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=300 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
38	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
39	Creole	executeQuery(): [1.19 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=302 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
40	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
41	Creole	executeQuery(): [0.92 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=301 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
42	Creole	prepareStatement(): SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college.COLLEGE_MAIN_ID=? AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
43	Creole	executeQuery(): [5.54 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=808 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
44	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
45	Creole	executeQuery(): [1.22 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=813 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
46	Creole	prepareStatement(): SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=? AND college.ID=? AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
47	Creole	executeQuery(): [0.94 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=816 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
48	Action	change template to "myCampusSearchResults"
49	View	initialize view for "search/perma_state_program"
50	View	render "sf_app_dir/modules/search/templates/myCampusSearchResultsSuccess.php"
51	PartialHelper	set slot "side"
52	PartialHelper	call "search->executeCampusSearchRightNav()"
53	Creole	prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college.STATUS=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
54	Creole	executeQuery(): [12.41 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
55	View	initialize view for "search/_campusSearchRightNav"
56	View	render "sf_app_dir/modules/search/templates/_campusSearchRightNav.php"
57	PartialHelper	call "featured->executeFeaturedSites()"
58	Creole	prepareStatement(): SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE=? AND content_module.NAME=? AND content_page.MODULE_NAME=? AND content_page.ACTION_NAME=? AND content_page.SITE_ID=? AND content_page.ID=content_module.CONTENT_PAGE_ID
59	Creole	executeQuery(): [0.38 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='site' AND content_module.NAME='layout' AND content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 AND content_page.ID=content_module.CONTENT_PAGE_ID
60	Creole	prepareStatement(): SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=? AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
61	Creole	executeQuery(): [0.36 ms] SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=6 AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
62	View	initialize view for "featured/_featuredSites"
63	View	render "sf_app_dir/modules/featured/templates/_featuredSites.php"
64	PartialHelper	call "search->executeSearchBoxSmall()"
65	Creole	prepareStatement(): SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_program.PROGRAM_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
66	Creole	executeQuery(): [1.85 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=103 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
67	Creole	prepareStatement(): SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE=? AND college_state.STATE_ID=? AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC
68	Creole	executeQuery(): [5.47 ms] SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=6 AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC
69	View	initialize view for "search/_searchBoxSmall"
70	View	render "sf_app_dir/modules/search/templates/_searchBoxSmall.php"
71	View	decorate content with "sf_app_dir/templates/mySearchResultsLayout.php"
72	View	render "sf_app_dir/templates/mySearchResultsLayout.php"
73	View	initialize view for "global/_vista"
74	View	render "sf_app_dir/templates/_vista.php"
75	View	initialize view for "global/_header"
76	View	render "sf_app_dir/templates/_header.php"
77	View	initialize view for "global/_footer"
78	View	render "sf_app_dir/templates/_footer.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: perma_state_program
    module: search
    slug: massage-healing-and-health
    state: arizona-colleges
attributeHolder: 
  symfony/default:

Response

---
cookies: 
httpHeaders: 
parameterHolder: 
  helper/asset/auto/javascript: 
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    description: >
      Online Business College degrees and
      accredited college recommendations
      through MyBusinessColleges.com. Online
      college programs for continuing buniness
      education.
    keywords: >
      business schools, business degrees,
      online business degrees
    robots: no index, no follow
    title: >
      Online Business Schools and Business
      Programs : myBusinessCollege.com
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
  helper/asset/auto/stylesheet/first: 
    global: 
  helper/asset/auto/stylesheet/last: 
    layoutMySearchResults: 
    modules: 
    mySearchResults: 
  symfony/action/view: 
    search_perma_state_program_template: myCampusSearchResults
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included: 
  symfony/view/sfView/slot: 
    slot_names: 
    slots: 
      side: |
        <div id="contnets_right">
        <div class="featured_programs">
        <h3>Featured Programs</h3>
        <p><img src="/images/../images/global/right_menuimg2.gif" alt="Right_menuimg2" /></p>
        <p class="title_pink">Degrees for this state and program</p>
        <ul>
        <li>
        <a href="/index.php/campus-schools/state/arizona-colleges/degrees/graduate-certificates-dip-program/massage-healing-and-health.html">Graduate Certificates & Diplomas</a>           </li>
        </ul>
        </div>
        </div>

Settings

---
app_cid: 1248
app_college_logo: >
  http://mycollegesolution.com/images/college_logos/
app_description: >
  Online Business College degrees and
  accredited college recommendations
  through MyBusinessColleges.com. Online
  college programs for continuing buniness
  education.
app_keywords: >
  business schools, business degrees,
  online business degrees
app_program_id: 103
app_site_fullname: myBusinessColleges.com
app_site_id: 6
app_site_type: program
app_title: >
  Online Business Schools and Business
  Programs : myBusinessCollege.com
mod_featured_enabled: 1
mod_featured_is_internal: 
mod_featured_view_class: sfPHP
mod_search_enabled: 1
mod_search_is_internal: 
mod_search_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend
sf_app_i18n_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/lib
sf_app_lib_dir_name: lib
sf_app_module_action_dir_name: actions
sf_app_module_config_dir_name: config
sf_app_module_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/modules
sf_app_module_dir_name: modules
sf_app_module_i18n_dir_name: i18n
sf_app_module_lib_dir_name: lib
sf_app_module_template_dir_name: templates
sf_app_module_validate_dir_name: validate
sf_app_module_view_dir_name: views
sf_app_template_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend
sf_bin_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev
sf_cache_dir_name: cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: 
sf_check_symfony_version: 
sf_compressed: 
sf_config_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/config
sf_config_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/config
sf_config_dir_name: config
sf_data_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: content
sf_doc_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
sf_environment: dev
sf_error_404_action: error
sf_error_404_module: site
sf_error_reporting: 2047
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/i18n
sf_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/lib
sf_lib_dir_name: lib
sf_log_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/log
sf_log_dir_name: log
sf_logging_enabled: 1
sf_logging_history: 10
sf_logging_level: debug
sf_logging_period: 7
sf_logging_purge: 1
sf_logging_rotate: 
sf_login_action: login
sf_login_module: default
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/lib/model
sf_module_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_orm: propel
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache
sf_root_dir: /home/mybiznes/mybusinesscolleges/trunk
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: default
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_strip_comments: 1
sf_suffix: .
sf_symfony_data_dir: /home/mybiznes/mysymfony/data
sf_symfony_lib_dir: /home/mybiznes/mysymfony/lib
sf_template_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/template
sf_test: 
sf_test_cache_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/cache/frontend/dev/test
sf_test_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1284137358.73
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/web/uploads
sf_upload_dir_name: uploads
sf_url_format: PATH
sf_use_database: 1
sf_use_flash: 1
sf_use_process_cache: 1
sf_use_security: 1
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix:  &darr;&nbsp;
sf_validation_error_suffix:  &nbsp;&darr;
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: >
  /home/mybiznes/mybusinesscolleges/trunk/web
sf_web_dir_name: web

Globals

---
cookie: 
  symfony: c8c94c8052654bbcbeb35ce540d9db2d
env: 
  DOCUMENT_ROOT: /home/mybiznes/public_html
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: >
    text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=c8c94c8052654bbcbeb35ce540d9db2d
  HTTP_HOST: www.mybusinesscolleges.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc03-02
  PATH: /bin:/usr/bin
  PATH_INFO: >
    /campus-schools/state/arizona-colleges/program/massage-healing-and-health.html
  PATH_TRANSLATED: /home/mybiznes/public_html/index.php
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 38.107.191.107
  REMOTE_PORT: 40885
  REQUEST_METHOD: GET
  REQUEST_URI: >
    /index.php/campus-schools/state/arizona-colleges/program/massage-healing-and-health.html
  SCRIPT_FILENAME: /home/mybiznes/public_html/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 67.18.127.7
  SERVER_ADMIN: webmaster@mybusinesscolleges.com
  SERVER_NAME: www.mybusinesscolleges.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.mybusinesscolleges.com Port 80</address>
    
  SERVER_SOFTWARE: >
    Apache mod_auth_passthrough/2.1
    mod_bwlimited/1.4 FrontPage/5.0.2.2635
  UNIQUE_ID: TIphjkUp5gcAAGHbPiEAAABM
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: /home/mybiznes/public_html
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: >
    text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
  HTTP_ACCEPT_CHARSET: ISO-8859-1,utf-8;q=0.7,*;q=0.7
  HTTP_ACCEPT_ENCODING: gzip
  HTTP_ACCEPT_LANGUAGE: en-us,en;q=0.5
  HTTP_CACHE_CONTROL: no-cache
  HTTP_CONNECTION: close
  HTTP_COOKIE: symfony=c8c94c8052654bbcbeb35ce540d9db2d
  HTTP_HOST: www.mybusinesscolleges.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc03-02
  PATH: /bin:/usr/bin
  PATH_INFO: >
    /campus-schools/state/arizona-colleges/program/massage-healing-and-health.html
  PATH_TRANSLATED: /home/mybiznes/public_html/index.php
  PHP_SELF: >
    /index.php/campus-schools/state/arizona-colleges/program/massage-healing-and-health.html
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REMOTE_ADDR: 38.107.191.107
  REMOTE_PORT: 40885
  REQUEST_METHOD: GET
  REQUEST_TIME: 1284137358
  REQUEST_URI: >
    /index.php/campus-schools/state/arizona-colleges/program/massage-healing-and-health.html
  SCRIPT_FILENAME: /home/mybiznes/public_html/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 67.18.127.7
  SERVER_ADMIN: webmaster@mybusinesscolleges.com
  SERVER_NAME: www.mybusinesscolleges.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 Server at www.mybusinesscolleges.com Port 80</address>
    
  SERVER_SOFTWARE: >
    Apache mod_auth_passthrough/2.1
    mod_bwlimited/1.4 FrontPage/5.0.2.2635
  UNIQUE_ID: TIphjkUp5gcAAGHbPiEAAABM
  argc: 0
  argv: 
session: 
  symfony/user/sfUser/attributes: 
    symfony/flash: 
      zipCode: 
      degree_id: 
      program_id: 113
      state_id: 50
    symfony/flash/remove: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1284137307

Php

---
php: 5.2.9
os: >
  Linux newyork.websitewelcome.com
  2.6.34.6 #1 SMP Fri Aug 27 18:43:47 CDT
  2010 i686
extensions: 
  - zip
  - libxml
  - xsl
  - xmlwriter
  - xmlrpc
  - dom
  - xmlreader
  - xml
  - wddx
  - tokenizer
  - tidy
  - session
  - pcre
  - SimpleXML
  - sockets
  - soap
  - SPL
  - standard
  - Reflection
  - pspell
  - posix
  - mysqli
  - mysql
  - mime_magic
  - mhash
  - mcrypt
  - mbstring
  - json
  - imap
  - iconv
  - hash
  - gettext
  - gd
  - ftp
  - filter
  - exif
  - date
  - curl
  - ctype
  - calendar
  - bcmath
  - zlib
  - openssl
  - cgi-fcgi
  - PDO
  - pdo_sqlite
  - SQLite
  - pdo_mysql
  - uploadprogress
  - ionCube Loader
  - Zend Optimizer

SQL queries

[0.33 ms] SELECT content_page.ID, content_page.NAME, content_page.SITE_ID, content_page.MODULE_NAME, content_page.ACTION_NAME, content_page.TITLETAG, content_page.KEYWORDS, content_page.DESCRIPTION FROM content_page WHERE content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 LIMIT 1
[0.51 ms] SELECT state.ID, state.NAME FROM state WHERE state.NAME='Arizona' LIMIT 1
[0.32 ms] SELECT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL FROM program WHERE program.SEO_URL='massage-healing-and-health' LIMIT 1
[5.70 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[0.80 ms] SELECT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME) FROM college WHERE college.ID IN (507,507,507,300,300,808,808) ORDER BY UPPER(college.NAME) ASC
[5.37 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=507 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[3.51 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=510 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[3.27 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=512 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[2.08 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=514 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[5.59 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=300 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.19 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=302 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.92 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=301 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[5.54 ms] SELECT DISTINCT DISTINCT college.ID, college.COLLEGE_TYPE, college.NAME, college.SEO_NAME, college.SEO_URL, college.COLLEGE_MAIN_ID, college.ACCREDIDATION, college.STATUS, college.SHOW_LEAD_FORM, college.LEAD_FORM_URL, UPPER(college.NAME), UPPER(college.NAME) FROM college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college.COLLEGE_MAIN_ID=808 AND college.ID=college_state.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college.NAME) ASC,UPPER(college.NAME) ASC
[1.22 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=813 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[0.94 ms] SELECT college_program.ID, college_program.COLLEGE_ID, college_program.PROGRAM_ID, college_program.DEGREE_ID, college_program.SCHOOL_PROGRAM_NAME, college_program.DESCRIPTION, UPPER(college_program.SCHOOL_PROGRAM_NAME), UPPER(college_program.SCHOOL_PROGRAM_NAME) FROM college_program, college, college_zip WHERE college_program.PROGRAM_ID=113 AND college.ID=816 AND college.ID=college_zip.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC,UPPER(college_program.SCHOOL_PROGRAM_NAME) ASC
[12.41 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='Campus' AND college.STATUS=1 AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=113 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
[0.38 ms] SELECT content_module.ID, content_module.NAME, content_module.SEO_HEADING, content_module.SEO_HEADING2, content_module.DESCRIPTION, content_module.MODULE_TYPE, content_module.ISACTIVE, content_module.CONTENT_PAGE_ID, content_module.CONTENT_GROUP_ID FROM content_module, content_page WHERE content_module.MODULE_TYPE='site' AND content_module.NAME='layout' AND content_page.MODULE_NAME='search' AND content_page.ACTION_NAME='perma_state_program' AND content_page.SITE_ID=6 AND content_page.ID=content_module.CONTENT_PAGE_ID
[0.36 ms] SELECT site.ID, site.NAME, site.URL, site.DESCRIPTION FROM site, content_item WHERE content_item.CONTENT_GROUP_ID=6 AND site.ID=content_item.ITEM_ID ORDER BY content_item.RANK ASC
[1.85 ms] SELECT DISTINCT degree.ID, degree.NAME, degree.SEO_NAME, degree.SEO_URL, UPPER(degree.NAME) FROM degree, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=6 AND college_program.PROGRAM_ID=103 AND college_state.COLLEGE_ID=college.ID AND college_program.DEGREE_ID=degree.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(degree.NAME) ASC
[5.47 ms] SELECT DISTINCT program.ID, program.NAME, program.SEO_NAME, program.SEO_URL, UPPER(program.NAME) FROM program, college, college_state, college_program WHERE college.COLLEGE_TYPE='campus' AND college_state.STATE_ID=6 AND college_state.COLLEGE_ID=college.ID AND college_program.PROGRAM_ID=program.ID AND college.ID=college_program.COLLEGE_ID ORDER BY UPPER(program.NAME) ASC

type	calls	time (ms)
Configuration	14	4.21
Action "search/perma_state_program"	1	143.06
Database	20	57.69
View "Success" for "search/perma_state_program"	1	66.90
Component "search/campusSearchRightNav"	1	17.00
Partial "search/_campusSearchRightNav"	1	18.02
Component "featured/featuredSites"	1	14.36
Partial "featured/_featuredSites"	1	0.57
Component "search/searchBoxSmall"	1	10.13
Partial "search/_searchBoxSmall"	1	2.15
Partial "global/_vista"	1	0.31
Partial "global/_header"	1	0.60
Partial "global/_footer"	1	0.32

Arizona Campuses : Massage, Healing & Health

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers