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' => 'home', 'action' => 'buildersearch',)
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 "homeActions->executeBuildersearch()"
12	View	initialize view for "home/buildersearch"
13	ViewConfig	set component "header" (main/header)
14	ViewConfig	set component "left" (main/left)
15	ViewConfig	set component "center" (main/center)
16	ViewConfig	set component "right" (main/right)
17	ViewConfig	set component "footer" (main/footer)
18	View	render "sf_app_dir/modules/home/templates/buildersearchSuccess.php"
19	PartialHelper	call "main->executeState()"
20	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
21	Creole	prepareStatement(): SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=?
22	Creole	executeQuery(): [41.62 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
23	View	initialize view for "main/_State"
24	View	render "sf_app_dir/modules/main/templates/_State.php"
25	View	decorate content with "sf_app_dir/templates/layout.php"
26	View	render "sf_app_dir/templates/layout.php"
27	PartialHelper	call "main->executeHeader()"
28	View	initialize view for "main/_header"
29	View	render "sf_app_dir/modules/main/templates/_header.php"
30	PartialHelper	call "main->executeLeft()"
31	Creole	prepareStatement(): SELECT picture_gallery.ID, picture_gallery.BANNER_NAME, picture_gallery.TOOLTIP, picture_gallery.USER_ID, picture_gallery.NO_CLIKCS, picture_gallery.URL, picture_gallery.PRODUCT_ID, picture_gallery.ACTIVE FROM picture_gallery, sub_details WHERE picture_gallery.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND picture_gallery.PRODUCT_ID=sub_details.ID
32	Creole	applyLimit(): SELECT picture_gallery.ID, picture_gallery.BANNER_NAME, picture_gallery.TOOLTIP, picture_gallery.USER_ID, picture_gallery.NO_CLIKCS, picture_gallery.URL, picture_gallery.PRODUCT_ID, picture_gallery.ACTIVE FROM picture_gallery, sub_details WHERE picture_gallery.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND picture_gallery.PRODUCT_ID=sub_details.ID, offset: 0, limit: 20
33	Creole	executeQuery(): [48.63 ms] SELECT picture_gallery.ID, picture_gallery.BANNER_NAME, picture_gallery.TOOLTIP, picture_gallery.USER_ID, picture_gallery.NO_CLIKCS, picture_gallery.URL, picture_gallery.PRODUCT_ID, picture_gallery.ACTIVE FROM picture_gallery, sub_details WHERE picture_gallery.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND picture_gallery.PRODUCT_ID=sub_details.ID LIMIT 20
34	View	initialize view for "main/_left"
35	View	render "sf_app_dir/modules/main/templates/_left.php"
36	PartialHelper	call "main->executeCenterlayer()"
37	View	initialize view for "main/_centerlayer"
38	View	render "sf_app_dir/modules/main/templates/_centerlayer.php"
39	View	initialize view for "main/_loginLayer"
40	View	render "sf_app_dir/modules/main/templates/_loginLayer.php"
41	View	initialize view for "search/_search"
42	View	render "sf_app_dir/modules/search/templates/_search.php"
43	PartialHelper	call "main->executePropType()"
44	Creole	prepareStatement(): SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
45	Creole	executeQuery(): [53.96 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
46	View	initialize view for "main/_PropType"
47	View	render "sf_app_dir/modules/main/templates/_PropType.php"
48	PartialHelper	call "main->executeState()"
49	Creole	prepareStatement(): SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=?
50	Creole	executeQuery(): [54.87 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
51	View	initialize view for "main/_State"
52	View	render "sf_app_dir/modules/main/templates/_State.php"
53	PartialHelper	call "main->executeCenter()"
54	View	initialize view for "main/_center"
55	View	render "sf_app_dir/modules/main/templates/_center.php"
56	PartialHelper	call "main->executePropType()"
57	Creole	prepareStatement(): SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
58	Creole	executeQuery(): [57.78 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
59	View	initialize view for "main/_PropType"
60	View	render "sf_app_dir/modules/main/templates/_PropType.php"
61	PartialHelper	call "main->executePicture()"
62	Creole	prepareStatement(): SELECT sponsored_builders.ID, sponsored_builders.LOGO_NAME, sponsored_builders.TOOLTIP, sponsored_builders.USER_ID, sponsored_builders.NO_CLIKCS, sponsored_builders.URL, sponsored_builders.PRODUCT_ID, sponsored_builders.ACTIVE FROM sponsored_builders, sub_details WHERE sponsored_builders.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND sponsored_builders.PRODUCT_ID=sub_details.ID
63	Creole	applyLimit(): SELECT sponsored_builders.ID, sponsored_builders.LOGO_NAME, sponsored_builders.TOOLTIP, sponsored_builders.USER_ID, sponsored_builders.NO_CLIKCS, sponsored_builders.URL, sponsored_builders.PRODUCT_ID, sponsored_builders.ACTIVE FROM sponsored_builders, sub_details WHERE sponsored_builders.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND sponsored_builders.PRODUCT_ID=sub_details.ID, offset: 0, limit: 10
64	Creole	executeQuery(): [66.90 ms] SELECT sponsored_builders.ID, sponsored_builders.LOGO_NAME, sponsored_builders.TOOLTIP, sponsored_builders.USER_ID, sponsored_builders.NO_CLIKCS, sponsored_builders.URL, sponsored_builders.PRODUCT_ID, sponsored_builders.ACTIVE FROM sponsored_builders, sub_details WHERE sponsored_builders.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND sponsored_builders.PRODUCT_ID=sub_details.ID LIMIT 10
65	View	initialize view for "main/_Picture"
66	View	render "sf_app_dir/modules/main/templates/_Picture.php"
67	PartialHelper	call "main->executeHyd()"
68	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
69	Creole	executeQuery(): [63.73 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='1' AND featured_projects.PRODUCT_ID=sub_details.ID
70	View	initialize view for "main/_Hyd"
71	View	render "sf_app_dir/modules/main/templates/_Hyd.php"
72	PartialHelper	call "main->executeBan()"
73	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
74	Creole	executeQuery(): [58.22 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='102' AND featured_projects.PRODUCT_ID=sub_details.ID
75	View	initialize view for "main/_Ban"
76	View	render "sf_app_dir/modules/main/templates/_Ban.php"
77	PartialHelper	call "main->executeChennai()"
78	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
79	Creole	executeQuery(): [59.35 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='200' AND featured_projects.PRODUCT_ID=sub_details.ID
80	View	initialize view for "main/_Chennai"
81	View	render "sf_app_dir/modules/main/templates/_Chennai.php"
82	PartialHelper	call "main->executePune()"
83	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
84	Creole	executeQuery(): [52.02 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='154' AND featured_projects.PRODUCT_ID=sub_details.ID
85	View	initialize view for "main/_Pune"
86	View	render "sf_app_dir/modules/main/templates/_Pune.php"
87	PartialHelper	call "main->executeGurgoan()"
88	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
89	Creole	executeQuery(): [46.21 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='78' AND featured_projects.PRODUCT_ID=sub_details.ID
90	View	initialize view for "main/_Gurgoan"
91	View	render "sf_app_dir/modules/main/templates/_Gurgoan.php"
92	PartialHelper	call "main->executeMumbai()"
93	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
94	Creole	executeQuery(): [41.84 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='134' AND featured_projects.PRODUCT_ID=sub_details.ID
95	View	initialize view for "main/_Mumbai"
96	View	render "sf_app_dir/modules/main/templates/_Mumbai.php"
97	PartialHelper	call "main->executeDelhi()"
98	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
99	Creole	executeQuery(): [35.72 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='242' AND featured_projects.PRODUCT_ID=sub_details.ID
100	View	initialize view for "main/_Delhi"
101	View	render "sf_app_dir/modules/main/templates/_Delhi.php"
102	PartialHelper	call "main->executeKolkata()"
103	Creole	prepareStatement(): SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=? AND sub_details.EXPIRY_DATE>=? AND featured_projects.PROJECT_CITY=? AND featured_projects.PRODUCT_ID=sub_details.ID
104	Creole	executeQuery(): [36.03 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='232' AND featured_projects.PRODUCT_ID=sub_details.ID
105	View	initialize view for "main/_Kolkata"
106	View	render "sf_app_dir/modules/main/templates/_Kolkata.php"
107	PartialHelper	call "main->executeRhyd()"
108	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.ROLE_ID=? AND users.CITY=?
109	Creole	executeQuery(): [26.04 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.ROLE_ID=3 AND users.CITY=1
110	View	initialize view for "main/_rhyd"
111	View	render "sf_app_dir/modules/main/templates/_rhyd.php"
112	PartialHelper	call "main->executeRbgl()"
113	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.ROLE_ID=? AND users.CITY=?
114	Creole	executeQuery(): [28.46 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.ROLE_ID=3 AND users.CITY=102
115	View	initialize view for "main/_rbgl"
116	View	render "sf_app_dir/modules/main/templates/_rbgl.php"
117	PartialHelper	call "main->executeRchennai()"
118	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.ROLE_ID=? AND users.CITY=?
119	Creole	executeQuery(): [29.81 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.ROLE_ID=3 AND users.CITY=200
120	View	initialize view for "main/_rchennai"
121	View	render "sf_app_dir/modules/main/templates/_rchennai.php"
122	PartialHelper	call "main->executeRpune()"
123	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.ROLE_ID=? AND users.CITY=?
124	Creole	executeQuery(): [21.04 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.ROLE_ID=3 AND users.CITY=154
125	View	initialize view for "main/_rpune"
126	View	render "sf_app_dir/modules/main/templates/_rpune.php"
127	PartialHelper	call "main->executeRgurgn()"
128	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.ROLE_ID=? AND users.CITY=?
129	Creole	executeQuery(): [22.11 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.ROLE_ID=3 AND users.CITY=78
130	View	initialize view for "main/_rgurgn"
131	View	render "sf_app_dir/modules/main/templates/_rgurgn.php"
132	PartialHelper	call "main->executeRmumbai()"
133	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.ROLE_ID=? AND users.CITY=?
134	Creole	executeQuery(): [21.49 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.ROLE_ID=3 AND users.CITY=134
135	View	initialize view for "main/_rmumbai"
136	View	render "sf_app_dir/modules/main/templates/_rmumbai.php"
137	PartialHelper	call "main->executeRight()"
138	View	initialize view for "main/_right"
139	View	render "sf_app_dir/modules/main/templates/_right.php"
140	PartialHelper	call "main->executeAbservices()"
141	Creole	prepareStatement(): SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types WHERE abs_types.ID=?
142	Creole	applyLimit(): SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types WHERE abs_types.ID=1, offset: 0, limit: 1
143	Creole	executeQuery(): [23.85 ms] SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types WHERE abs_types.ID=1 LIMIT 1
144	View	initialize view for "main/_abservices"
145	View	render "sf_app_dir/modules/main/templates/_abservices.php"
146	Creole	prepareStatement(): SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types
147	Creole	executeQuery(): [23.19 ms] SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types
148	PartialHelper	call "main->executeConstcity()"
149	Creole	prepareStatement(): SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities
150	Creole	executeQuery(): [-1729.99 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities
151	View	initialize view for "main/_Constcity"
152	View	render "sf_app_dir/modules/main/templates/_Constcity.php"
153	PartialHelper	call "main->executeFooter()"
154	View	initialize view for "main/_footer"
155	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: buildersearch
    module: home
attributeHolder: 
  symfony/default: 
    referer:

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: symfony project
    keywords: symfony, project
    language: en
    robots: index, follow
    title: symfony project
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    main: 
  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_home_enabled: 1
mod_home_is_internal: 
mod_home_view_class: sfPHP
mod_main_enabled: 1
mod_main_is_internal: 
mod_main_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/apps/frontend
sf_app_i18n_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/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/GharExpo/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/GharExpo/cache/frontend
sf_bin_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/cache/frontend/dev/config
sf_config_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/config
sf_config_dir_name: config
sf_data_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/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/GharExpo/cache/frontend/dev/i18n
sf_lib_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/lib
sf_lib_dir_name: lib
sf_log_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/lib/model
sf_module_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/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/GharExpo/cache
sf_root_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo
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/GharExpo/cache/frontend/dev/template
sf_test: 
sf_test_cache_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/cache/frontend/dev/test
sf_test_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1170691760.2456
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: >
  /home/.mccoy/balakrishna/gharinfo.com/GharExpo/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/GharExpo/web
sf_web_dir_name: web

Globals

---
cookie: 
env: 
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: /home/balakrishna/gharinfo.com
  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: >
    /GharExpo/web/frontend_dev.php/home/buildersearch
  ORIG_PATH_TRANSLATED: >
    /home/balakrishna/gharinfo.com/GharExpo/web/frontend_dev.php/home/buildersearch
  ORIG_SCRIPT_FILENAME: /dh/cgi-system/php5.cgi
  ORIG_SCRIPT_NAME: /cgi-system/php5.cgi
  PATH: /usr/local/bin:/usr/bin:/bin
  PATH_INFO: /home/buildersearch
  PATH_TRANSLATED: >
    /home/balakrishna/gharinfo.com/home/buildersearch
  PHP_SELF: /GharExpo/web/frontend_dev.php
  QUERY_STRING: 
  REDIRECT_STATUS: 200
  REDIRECT_URL: >
    /GharExpo/web/frontend_dev.php/home/buildersearch
  REMOTE_ADDR: 64.208.172.179
  REMOTE_PORT: 49515
  REQUEST_METHOD: GET
  REQUEST_TIME: 1170691760
  REQUEST_URI: >
    /GharExpo/web/frontend_dev.php/home/buildersearch
  SCRIPT_FILENAME: >
    /home/balakrishna/gharinfo.com/GharExpo/web/frontend_dev.php
  SCRIPT_NAME: /GharExpo/web/frontend_dev.php
  SCRIPT_URI: >
    http://www.gharinfo.com/GharExpo/web/frontend_dev.php/home/buildersearch
  SCRIPT_URL: >
    /GharExpo/web/frontend_dev.php/home/buildersearch
  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.4
    mod_ssl/2.0.54 OpenSSL/0.9.7e
    mod_fastcgi/2.4.2 DAV/2 SVN/1.3.2
  argc: 0
  argv: 
session:

Php

---
php: 5.1.2
os: >
  Linux silk
  2.4.32-grsec+f6b+gr217+nfs+a32+fuse23+++686+c6+gr6b-v6.192
  #1 SMP Wed Jan 11 14:25:02 PST 2006 i686
extensions: 
  - libxml
  - xsl
  - xmlwriter
  - dom
  - xmlreader
  - xml
  - tokenizer
  - standard
  - SimpleXML
  - SPL
  - session
  - PDO
  - SQLite
  - Reflection
  - pspell
  - posix
  - pdo_sqlite
  - pdo_mysql
  - mysqli
  - mysql
  - mcrypt
  - mbstring
  - iconv
  - hash
  - gettext
  - gd
  - ftp
  - exif
  - date
  - curl
  - ctype
  - calendar
  - zlib
  - pcre
  - openssl

SQL queries

[41.62 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
[48.63 ms] SELECT picture_gallery.ID, picture_gallery.BANNER_NAME, picture_gallery.TOOLTIP, picture_gallery.USER_ID, picture_gallery.NO_CLIKCS, picture_gallery.URL, picture_gallery.PRODUCT_ID, picture_gallery.ACTIVE FROM picture_gallery, sub_details WHERE picture_gallery.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND picture_gallery.PRODUCT_ID=sub_details.ID LIMIT 20
[53.96 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
[54.87 ms] SELECT states.ID, states.STATE_NAME, states.COUNTRY_ID FROM states WHERE states.COUNTRY_ID=1
[57.78 ms] SELECT property_types.ID, property_types.PROPERTY_TYPE FROM property_types
[66.90 ms] SELECT sponsored_builders.ID, sponsored_builders.LOGO_NAME, sponsored_builders.TOOLTIP, sponsored_builders.USER_ID, sponsored_builders.NO_CLIKCS, sponsored_builders.URL, sponsored_builders.PRODUCT_ID, sponsored_builders.ACTIVE FROM sponsored_builders, sub_details WHERE sponsored_builders.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND sponsored_builders.PRODUCT_ID=sub_details.ID LIMIT 10
[63.73 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='1' AND featured_projects.PRODUCT_ID=sub_details.ID
[58.22 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='102' AND featured_projects.PRODUCT_ID=sub_details.ID
[59.35 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='200' AND featured_projects.PRODUCT_ID=sub_details.ID
[52.02 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='154' AND featured_projects.PRODUCT_ID=sub_details.ID
[46.21 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='78' AND featured_projects.PRODUCT_ID=sub_details.ID
[41.84 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='134' AND featured_projects.PRODUCT_ID=sub_details.ID
[35.72 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='242' AND featured_projects.PRODUCT_ID=sub_details.ID
[36.03 ms] SELECT featured_projects.ID, featured_projects.USER_ID, featured_projects.PROJECT_NAME, featured_projects.PROJECT_CITY, featured_projects.NO_CLICKS, featured_projects.URL, featured_projects.PRODUCT_ID, featured_projects.ACTIVE, featured_projects.DESCRIPTION FROM featured_projects, sub_details WHERE featured_projects.ACTIVE=1 AND sub_details.EXPIRY_DATE>='2007-02-05' AND featured_projects.PROJECT_CITY='232' AND featured_projects.PRODUCT_ID=sub_details.ID
[26.04 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.ROLE_ID=3 AND users.CITY=1
[28.46 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.ROLE_ID=3 AND users.CITY=102
[29.81 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.ROLE_ID=3 AND users.CITY=200
[21.04 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.ROLE_ID=3 AND users.CITY=154
[22.11 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.ROLE_ID=3 AND users.CITY=78
[21.49 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.ROLE_ID=3 AND users.CITY=134
[23.85 ms] SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types WHERE abs_types.ID=1 LIMIT 1
[23.19 ms] SELECT abs_types.ID, abs_types.ABSERVICE_NAME FROM abs_types
[-1729.99 ms] SELECT cities.ID, cities.CITY_NAME, cities.STATE_ID FROM cities

type	calls	time (ms)
Configuration	38	31.13
Action "home/buildersearch"	1	0.08
View "Success" for "home/buildersearch"	1	-434.90
Component "main/State"	2	-1532.14
Database	23	-817.16
Partial "main/_State"	2	8.50
Component "main/header"	1	0.04
Partial "main/_header"	1	1.55
Component "main/left"	1	1832.20
Partial "main/_left"	1	-1625.27
Component "main/centerlayer"	1	0.01
Partial "main/_centerlayer"	1	-1629.56
Partial "main/_loginLayer"	1	2.14
Partial "search/_search"	1	-1633.40
Component "main/PropType"	2	119.67
Partial "main/_PropType"	2	5.77
Component "main/center"	1	0.01
Partial "main/_center"	1	2538.92
Component "main/Picture"	1	75.30
Partial "main/_Picture"	1	0.68
Component "main/Hyd"	1	72.42
Partial "main/_Hyd"	1	0.74
Component "main/Ban"	1	59.89
Partial "main/_Ban"	1	0.55
Component "main/Chennai"	1	60.86
Partial "main/_Chennai"	1	0.57
Component "main/Pune"	1	53.49
Partial "main/_Pune"	1	0.58
Component "main/Gurgoan"	1	47.77
Partial "main/_Gurgoan"	1	0.50
Component "main/Mumbai"	1	43.76
Partial "main/_Mumbai"	1	0.53
Component "main/Delhi"	1	37.72
Partial "main/_Delhi"	1	0.58
Component "main/Kolkata"	1	37.43
Partial "main/_Kolkata"	1	0.49
Component "main/rhyd"	1	1808.55
Partial "main/_rhyd"	1	0.82
Component "main/rbgl"	1	29.93
Partial "main/_rbgl"	1	0.76
Component "main/rchennai"	1	31.20
Partial "main/_rchennai"	1	0.56
Component "main/rpune"	1	22.44
Partial "main/_rpune"	1	0.55
Component "main/rgurgn"	1	23.49
Partial "main/_rgurgn"	1	0.49
Component "main/rmumbai"	1	22.83
Partial "main/_rmumbai"	1	0.62
Component "main/right"	1	0.01
Partial "main/_right"	1	-1641.04
Component "main/abservices"	1	29.27
Partial "main/_abservices"	1	26.94
Component "main/Constcity"	1	-1714.19
Partial "main/_Constcity"	1	8.34
Component "main/footer"	1	0.01
Partial "main/_footer"	1	0.56

Search Builder

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers

State:
City:
Key Words: