Log and debug messages

#	type	message
1	Context	initialization
2	Controller	initialization
3	Routing	match route [default] "/:module/:action/*"
4	Request	request parameters array ( 'module' => 'search', 'action' => 'listingByPerson', 'usr_id' => '14',)
5	Controller	dispatch request
6	Filter	executing filter "sfRenderingFilter"
7	Filter	executing filter "sfWebDebugFilter"
8	Filter	executing filter "sfCommonFilter"
9	Filter	executing filter "sfFlashFilter"
10	Filter	executing filter "sfExecutionFilter"
11	Action	call "searchActions->executeListingByPerson()"
12	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
13	Creole	prepareStatement(): SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=?
14	Creole	executeQuery(): [60.81 ms] SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=14
15	Creole	prepareStatement(): SELECT COUNT(property_listings.ID) FROM property_listings WHERE property_listings.USER_ID=?
16	Creole	executeQuery(): [0.90 ms] SELECT COUNT(property_listings.ID) FROM property_listings WHERE property_listings.USER_ID=14
17	Action	change template to "showListings"
18	View	initialize view for "search/listingByPerson"
19	ViewConfig	set component "header" (main/header)
20	ViewConfig	set component "left" (search/filters)
21	ViewConfig	set component "center" (/)
22	ViewConfig	set component "right" (main/right)
23	ViewConfig	set component "footer" (main/footer)
24	View	render "sf_app_dir/modules/search/templates/showListingsSuccess.php"
25	Creole	prepareStatement(): SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=?
26	Creole	applyLimit(): SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=14, offset: 0, limit: 10
27	Creole	executeQuery(): [2.73 ms] SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=14 LIMIT 10
28	Creole	prepareStatement(): SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=?
29	Creole	executeQuery(): [16.35 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=3
30	Creole	prepareStatement(): SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=?
31	Creole	executeQuery(): [11.88 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
32	PartialHelper	call "main->executeUserFullInfo()"
33	Creole	prepareStatement(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=?
34	Creole	applyLimit(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14, offset: 0, limit: 1
35	Creole	executeQuery(): [65.10 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
36	View	initialize view for "main/_UserFullInfo"
37	View	render "sf_app_dir/modules/main/templates/_UserFullInfo.php"
38	Creole	prepareStatement(): SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=?
39	Creole	executeQuery(): [4.56 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=3
40	Creole	prepareStatement(): SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=?
41	Creole	executeQuery(): [0.99 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
42	PartialHelper	call "main->executeUserFullInfo()"
43	Creole	prepareStatement(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=?
44	Creole	applyLimit(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14, offset: 0, limit: 1
45	Creole	executeQuery(): [1.28 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
46	View	initialize view for "main/_UserFullInfo"
47	View	render "sf_app_dir/modules/main/templates/_UserFullInfo.php"
48	Creole	prepareStatement(): SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=?
49	Creole	executeQuery(): [1.07 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=5
50	Creole	prepareStatement(): SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=?
51	Creole	executeQuery(): [0.95 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
52	PartialHelper	call "main->executeUserFullInfo()"
53	Creole	prepareStatement(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=?
54	Creole	applyLimit(): SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14, offset: 0, limit: 1
55	Creole	executeQuery(): [28.80 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
56	View	initialize view for "main/_UserFullInfo"
57	View	render "sf_app_dir/modules/main/templates/_UserFullInfo.php"
58	View	decorate content with "sf_app_dir/templates/layout.php"
59	View	render "sf_app_dir/templates/layout.php"
60	PartialHelper	call "main->executeHeader()"
61	View	initialize view for "main/_header"
62	View	render "sf_app_dir/modules/main/templates/_header.php"
63	PartialHelper	call "search->executeFilters()"
64	View	initialize view for "search/_filters"
65	View	render "sf_app_dir/modules/search/templates/_filters.php"
66	PartialHelper	call "main->executeCenterlayer()"
67	View	initialize view for "main/_centerlayer"
68	View	render "sf_app_dir/modules/main/templates/_centerlayer.php"
69	View	initialize view for "main/_loginLayer"
70	View	render "sf_app_dir/modules/main/templates/_loginLayer.php"
71	View	initialize view for "search/_search"
72	View	render "sf_app_dir/modules/search/templates/_search.php"
73	PartialHelper	call "main->executePropType()"
74	Creole	prepareStatement(): SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
75	Creole	executeQuery(): [26.13 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
76	View	initialize view for "main/_PropType"
77	View	render "sf_app_dir/modules/main/templates/_PropType.php"
78	PartialHelper	call "main->executeState()"
79	Creole	prepareStatement(): SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=?
80	Creole	executeQuery(): [7.94 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
81	View	initialize view for "main/_State"
82	View	render "sf_app_dir/modules/main/templates/_State.php"
83	View	initialize view for "search/_agents"
84	View	render "sf_app_dir/modules/search/templates/_agents.php"
85	PartialHelper	call "main->executeState()"
86	Creole	prepareStatement(): SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=?
87	Creole	executeQuery(): [1.24 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
88	View	initialize view for "main/_State"
89	View	render "sf_app_dir/modules/main/templates/_State.php"
90	View	initialize view for "search/_builders"
91	View	render "sf_app_dir/modules/search/templates/_builders.php"
92	PartialHelper	call "main->executeState()"
93	Creole	prepareStatement(): SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=?
94	Creole	executeQuery(): [1.28 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
95	View	initialize view for "main/_State"
96	View	render "sf_app_dir/modules/main/templates/_State.php"
97	View	initialize view for "listings/_postrequirement"
98	View	render "sf_app_dir/modules/listings/templates/_postrequirement.php"
99	PartialHelper	call "main->executePostproperty()"
100	Creole	prepareStatement(): SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
101	Creole	executeQuery(): [1.12 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
102	View	initialize view for "main/_postproperty"
103	View	render "sf_app_dir/modules/main/templates/_postproperty.php"
104	PartialHelper	call "main->executeConstcity()"
105	Creole	prepareStatement(): SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities
106	Creole	executeQuery(): [2.74 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities
107	View	initialize view for "main/_Constcity"
108	View	render "sf_app_dir/modules/main/templates/_Constcity.php"
109	PartialHelper	call "main->executeRight()"
110	Creole	prepareStatement(): SELECT news.ID, news.TITLE, news.MESSAGE, news.POSTBY, news.POST_DATE, news.ACTIVE FROM news
111	Creole	executeQuery(): [3.55 ms] SELECT news.ID, news.TITLE, news.MESSAGE, news.POSTBY, news.POST_DATE, news.ACTIVE FROM news
112	View	initialize view for "main/_right"
113	View	render "sf_app_dir/modules/main/templates/_right.php"
114	PartialHelper	call "main->executeFooter()"
115	View	initialize view for "main/_footer"
116	View	render "sf_app_dir/modules/main/templates/_footer.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: listingByPerson
    module: search
    usr_id: 14
attributeHolder: 
  symfony/default: 
    listcmp: 
      - GePropertyListing
      - GePropertyListing
      - GePropertyListing
    qrystrcmp: usr_id=14&
    referer: 
    typecmp:

Response

---
cookies: 
httpHeaders: 
  Content-Type: text/html; charset=utf-8
parameterHolder: 
  helper/asset/auto/httpmeta: 
    Content-Type: text/html; charset=utf-8
  helper/asset/auto/javascript: 
    /sf/prototype/js/builder: /sf/prototype/js/builder
    /sf/prototype/js/effects: /sf/prototype/js/effects
    /sf/prototype/js/prototype: /sf/prototype/js/prototype
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    description: Properties in india,
    keywords: >
      A Real Estate Web Site,Real 
      Estate,Houses,Homes,Condos,Flats,Apartments,Apts,Buy,Sell,Rent,Farm
      Houses,Karnataka Realtors,India
      Realtors,India Property ,Properties in
      India,Hyderabad, Mumbai,
      Chennai,Builders,Agents,Residential,Commercial,Independent
      houses,Rentals,buying Property,Selling 
      Property,Lease Property,India Real
      estate,Search real estate 
      Property,Office Space,Advertise
      Property,Sale Your Property,Other
      Property in India,Property 
      Agents,Property  dealers,Holiday
      Resorts,Lease Properties,Acres Of Lands
    language: en
    robots: index, follow
    title: >
      Home Page of GharInfo.com  New way to
      find a real estate Property
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    main: 
  symfony/action/view: 
    search_listingByPerson_template: showListings
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_listing_age: 30
app_listing_bathroom: 10
app_listing_bedroom: 25
app_listing_floor: 25
app_listing_furnished: 
  - YAMLString
  - YAMLString
  - YAMLString
app_listing_sf_upload_dir: SF_ROOT_DIR/uploads
app_tax: 12.5
mod_main_enabled: 1
mod_main_is_internal: 
mod_main_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/.mccoy/balakrishna/gharinfo.com/GharInfo/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/apps/frontend
sf_app_i18n_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/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/.mccoy/balakrishna/gharinfo.com/GharInfo/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/.mccoy/balakrishna/gharinfo.com/GharInfo/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/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend
sf_bin_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/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/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend/dev/config
sf_config_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/config
sf_config_dir_name: config
sf_data_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 4095
sf_escaping_method: ESC_ENTITIES
sf_escaping_strategy: bc
sf_etag: 
sf_i18n: 
sf_i18n_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend/dev/i18n
sf_lib_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/lib
sf_lib_dir_name: lib
sf_log_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/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: members
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/lib/model
sf_module_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: 
sf_path_info_array: SERVER
sf_path_info_key: PATH_INFO
sf_plugins_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/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/.mccoy/balakrishna/gharinfo.com/GharInfo/cache
sf_root_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo
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/balakrishna/pear/data/symfony
sf_symfony_lib_dir: /home/balakrishna/pear/php/symfony
sf_template_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend/dev/template
sf_test: 
sf_test_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/cache/frontend/dev/test
sf_test_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1181101703.1217
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/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:  ↓ 
sf_validation_error_suffix:   ↓
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharInfo/web
sf_web_dir_name: web

Globals

---
cookie: 
env: 
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: >
    /home/balakrishna/gharinfo.com/GharInfo/web
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_CONNECTION: close
  HTTP_FROM: [email protected]
  HTTP_HOST: www.gharinfo.com
  HTTP_USER_AGENT: ia_archiver
  ORIG_PATH_INFO: >
    /gi_dev.php/search/listingByPerson/usr_id/14
  ORIG_PATH_TRANSLATED: >
    /home/balakrishna/gharinfo.com/GharInfo/web/gi_dev.php/search/listingByPerson/usr_id/14
  ORIG_SCRIPT_FILENAME: /dh/cgi-system/php5.cgi
  ORIG_SCRIPT_NAME: /cgi-system/php5.cgi
  PATH: /usr/local/bin:/usr/bin:/bin
  PATH_INFO: /search/listingByPerson/usr_id/14
  PATH_TRANSLATED: >
    /home/balakrishna/gharinfo.com/GharInfo/web/search/listingByPerson/usr_id/14
  PHP_SELF: /gi_dev.php
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REDIRECT_URL: >
    /gi_dev.php/search/listingByPerson/usr_id/14
  REMOTE_ADDR: 64.208.172.179
  REMOTE_PORT: 35937
  REQUEST_METHOD: GET
  REQUEST_TIME: 1181101704
  REQUEST_URI: >
    /gi_dev.php/search/listingByPerson/usr_id/14
  SCRIPT_FILENAME: >
    /home/balakrishna/gharinfo.com/GharInfo/web/gi_dev.php
  SCRIPT_NAME: /gi_dev.php
  SCRIPT_URI: >
    http://www.gharinfo.com/gi_dev.php/search/listingByPerson/usr_id/14
  SCRIPT_URL: >
    /gi_dev.php/search/listingByPerson/usr_id/14
  SERVER_ADDR: 208.113.162.92
  SERVER_ADMIN: [email protected]
  SERVER_NAME: www.gharinfo.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: 
  SERVER_SOFTWARE: >
    Apache/2.0.54 (Unix) PHP/4.4.7
    mod_ssl/2.0.54 OpenSSL/0.9.7e
    mod_fastcgi/2.4.2 DAV/2 SVN/1.4.2
  argc: 0
  argv: 
session:

Php

---
php: 5.2.2
os: >
  Linux silk
  2.4.32-grsec+f6b+gr217+nfs+a32+fuse23+tg+++opt+c8+gr2b-v6.194
  #1 SMP Tue Jun 6 15:52:09 PDT 2006 i686
extensions: 
  - libxml
  - xsl
  - xmlwriter
  - dom
  - xmlreader
  - xml
  - tokenizer
  - session
  - pcre
  - SimpleXML
  - SPL
  - PDO
  - SQLite
  - standard
  - Reflection
  - pspell
  - posix
  - pdo_sqlite
  - pdo_mysql
  - mysqli
  - mysql
  - mcrypt
  - mbstring
  - json
  - iconv
  - hash
  - gettext
  - gd
  - ftp
  - filter
  - exif
  - date
  - curl
  - ctype
  - calendar
  - zlib
  - openssl
  - cgi-fcgi
  - Zend Optimizer

SQL queries

[60.81 ms] SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=14
[0.90 ms] SELECT COUNT(property_listings.ID) FROM property_listings WHERE property_listings.USER_ID=14
[2.73 ms] SELECT property_listings.ID, property_listings.PROPERTY_CODE, property_listings.USER_ID, property_listings.CATEGORY, property_listings.PROPERTY_TYPE, property_listings.SUBTYPE, property_listings.LANDMARK, property_listings.LOCALITY, property_listings.ADDRESS, property_listings.STATE, property_listings.CITY, property_listings.ZIPCODE, property_listings.BUDGET, property_listings.COVEREDAREA, property_listings.PLOTAREA, property_listings.RBEDROOM, property_listings.RBATHROOM, property_listings.FURNISHED, property_listings.AGE, property_listings.LEASEYEARS, property_listings.FLOOR, property_listings.TOTALFLOOR, property_listings.FACING, property_listings.OWNERSHIP, property_listings.TRANSACTION, property_listings.RHOSPTIAL, property_listings.RRLYSTN, property_listings.RSCHOOL, property_listings.RCITYCENTER, property_listings.RAIRPORT, property_listings.RSHOPINGMALS, property_listings.RENTERTAINMENT, property_listings.DESCRIPTION, property_listings.CLUB, property_listings.LIFT, property_listings.RRAIN, property_listings.POWER, property_listings.GYM, property_listings.RPOOL, property_listings.SECURITY, property_listings.PARK, property_listings.GARDEN, property_listings.RWATERSTORAGE, property_listings.RSERVANTQUARTER, property_listings.RLANDROMART, property_listings.RMODULARKITCHEN, property_listings.RSOLARWATER, property_listings.VASTU, property_listings.PARKING, property_listings.AC, property_listings.CATM, property_listings.CFOODCOURT, property_listings.PHOTO, property_listings.VIEWS, property_listings.CREATED_AT, property_listings.EXPIRYDATE, property_listings.UPDATED_AT, property_listings.PRODUCT_ID, property_listings.ACTIVE, property_listings.PIC_PATH, property_listings.PIC_PATH1, property_listings.PIC_PATH2, property_listings.PIC_PATH3, property_listings.PIC_PATH4, property_listings.WALKTHROUGH_PATH, property_listings.LOCALITY_NAME, property_listings.USER_ROLE FROM property_listings WHERE property_listings.USER_ID=14 LIMIT 10
[16.35 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=3
[11.88 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
[65.10 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
[4.56 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=3
[0.99 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
[1.28 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
[1.07 ms] SELECT property_subtypes.ID, property_subtypes.SUBTYPE_NAME, property_subtypes.TYPE_ID FROM property_subtypes WHERE property_subtypes.ID=5
[0.95 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities WHERE cities.ID=1
[28.80 ms] SELECT users.ID, users.ROLE_ID, users.USERNAME, users.PASSWORD, users.FIRSTNAME, users.LASTNAME, users.EMAIL, users.ADDRESS1, users.ADDRESS2, users.STATE, users.CITY, users.ZIPCODE, users.PHONE, users.MOBILE, users.FAX, users.CONTACT, users.COMPANYNAME, users.LOCATION, users.PROJECTS, users.DESCRIPTION, users.URL, users.ACTIVE, users.LASTLOGIN, users.BLOCKED, users.AC_CODE, users.CREATED_AT FROM users WHERE users.ID=14 LIMIT 1
[26.13 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
[7.94 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
[1.24 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
[1.28 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
[1.12 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
[2.74 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities
[3.55 ms] SELECT news.ID, news.TITLE, news.MESSAGE, news.POSTBY, news.POST_DATE, news.ACTIVE FROM news

Property Type:
Property Subtype:

State:
City:
Price:

	↓ ↓
State:
City:
Key Words:

Username:
Phone Number:
E-mail:
Property Type:
Property Subtype:
Budget:
City:

type	calls	time (ms)
Configuration	25	251.00
Action "search/listingByPerson"	1	658.66
Database	19	239.39
View "Success" for "search/listingByPerson"	1	1051.47
Component "main/UserFullInfo"	3	193.43
Partial "main/_UserFullInfo"	3	7.19
Component "main/header"	1	0.06
Partial "main/_header"	1	6.65
Component "search/filters"	1	0.07
Partial "search/_filters"	1	227.22
Component "main/centerlayer"	1	0.02
Partial "main/_centerlayer"	1	201.79
Partial "main/_loginLayer"	1	1.49
Partial "search/_search"	1	95.16
Component "main/PropType"	1	34.54
Partial "main/_PropType"	1	5.01
Component "main/State"	3	25.66
Partial "main/_State"	3	18.81
Partial "search/_agents"	1	19.58
Partial "search/_builders"	1	13.67
Partial "listings/_postrequirement"	1	54.17
Component "main/postproperty"	1	2.16
Partial "main/_postproperty"	1	7.58
Component "main/Constcity"	1	9.46
Partial "main/_Constcity"	1	9.54
Component "main/right"	1	25.26
Partial "main/_right"	1	2.80
Component "main/footer"	1	0.02
Partial "main/_footer"	1	0.57

Adavanced Search

Search - Agents

Search Builder

Post Your Requirement

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers

Members Log In

	Username: Password: New User \| Forgot Password