Log and debug messages

#	type	message
1	Routing	connect "/captcha" (".html" suffix)
2	Routing	connect "/login" (".html" suffix)
3	Routing	connect "/logout" (".html" suffix)
4	Routing	connect "/request_password" (".html" suffix)
5	Context	initialization
6	Controller	initialization
7	Routing	match route [default] "/:module/:action/*"
8	Request	request parameters array ( 'module' => 'property', 'action' => 'search', 'city' => '616',)
9	Controller	dispatch request
10	Filter	executing filter "sfRenderingFilter"
11	Filter	executing filter "sfWebDebugFilter"
12	Filter	executing filter "sfCommonFilter"
13	Filter	executing filter "sfFlashFilter"
14	Filter	executing filter "sfExecutionFilter"
15	Action	call "propertyActions->executeSearch()"
16	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
17	Creole	prepareStatement(): SELECT city.ID, city.NAME, city.COUNTRY_CODE, city.DISTRICT, city.POPULATION FROM city WHERE city.ID=?
18	Creole	applyLimit(): SELECT city.ID, city.NAME, city.COUNTRY_CODE, city.DISTRICT, city.POPULATION FROM city WHERE city.ID=616, offset: 0, limit: 1
19	Creole	executeQuery(): [0.45 ms] SELECT city.ID, city.NAME, city.COUNTRY_CODE, city.DISTRICT, city.POPULATION FROM city WHERE city.ID=616 LIMIT 1
20	Creole	prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE=?
21	Creole	executeQuery(): [0.47 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE='EGY'
22	Creole	prepareStatement(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property
23	Creole	executeQuery(): [6.35 ms] SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property
24	View	initialize view for "property/search"
25	View	render "sf_app_dir/modules/property/templates/searchSuccess.php"
26	View	decorate content with "sf_app_dir/templates/layout.php"
27	View	render "sf_app_dir/templates/layout.php"
28	PartialHelper	call "property->executeTopCountry()"
29	Creole	prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country
30	Creole	executeQuery(): [1.34 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country
31	View	initialize view for "property/_topCountry"
32	View	render "sf_app_dir/modules/property/templates/_topCountry.php"
33	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
34	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
35	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
36	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
37	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
38	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
39	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
40	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
41	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
42	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
43	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
44	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
45	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
46	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
47	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
48	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
49	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
50	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
51	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
52	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
53	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
54	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
55	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
56	Creole	executeQuery(): [0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
57	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
58	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
59	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
60	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ABW'
61	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
62	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUS'
63	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
64	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
65	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
66	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
67	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
68	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
69	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
70	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
71	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
72	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
73	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
74	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
75	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
76	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLZ'
77	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
78	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEN'
79	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
80	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BMU'
81	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
82	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BTN'
83	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
84	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
85	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
86	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
87	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
88	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
89	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
90	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
91	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
92	Creole	executeQuery(): [1.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
93	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
94	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
95	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
96	Creole	executeQuery(): [0.76 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
97	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
98	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
99	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
100	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
101	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
102	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
103	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
104	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
105	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
106	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
107	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
108	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COK'
109	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
110	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CRI'
111	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
112	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
113	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
114	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
115	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
116	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
117	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
118	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
119	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
120	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
121	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
122	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
123	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
124	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
125	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
126	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESP'
127	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
128	Creole	executeQuery(): [0.59 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZAF'
129	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
130	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ETH'
131	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
132	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FLK'
133	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
134	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
135	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
136	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
137	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
138	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
139	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
140	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
141	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
142	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
143	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
144	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
145	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
146	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
147	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
148	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
149	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
150	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
151	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
152	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
153	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
154	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
155	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
156	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
157	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
158	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
159	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
160	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
161	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
162	Creole	executeQuery(): [0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
163	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
164	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
165	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
166	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
167	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
168	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
169	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
170	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
171	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
172	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
173	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
174	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
175	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
176	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
177	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
178	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
179	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
180	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
181	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
182	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
183	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
184	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
185	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
186	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
187	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
188	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
189	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
190	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
191	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
192	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
193	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
194	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
195	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
196	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
197	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
198	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
199	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
200	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
201	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
202	Creole	executeQuery(): [0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
203	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
204	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
205	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
206	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
207	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
208	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
209	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
210	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
211	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
212	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
213	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
214	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
215	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
216	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
217	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
218	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
219	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
220	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
221	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
222	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
223	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
224	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
225	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
226	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
227	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
228	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
229	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
230	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
231	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
232	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
233	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
234	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
235	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
236	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRK'
237	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
238	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KOR'
239	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
240	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
241	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
242	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
243	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
244	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
245	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
246	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
247	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
248	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
249	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
250	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
251	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
252	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
253	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
254	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
255	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
256	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
257	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
258	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
259	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
260	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBY'
261	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
262	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LIE'
263	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
264	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
265	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
266	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
267	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
268	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
269	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
270	Creole	executeQuery(): [0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
271	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
272	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
273	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
274	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
275	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
276	Creole	executeQuery(): [0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
277	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
278	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
279	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
280	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
281	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
282	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
283	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
284	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
285	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
286	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
287	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
288	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
289	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
290	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MTQ'
291	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
292	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MRT'
293	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
294	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MUS'
295	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
296	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
297	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
298	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
299	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
300	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
301	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
302	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
303	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
304	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
305	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
306	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
307	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
308	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
309	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
310	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
311	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
312	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
313	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
314	Creole	executeQuery(): [0.70 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
315	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
316	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
317	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
318	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
319	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
320	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
321	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
322	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
323	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
324	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
325	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
326	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
327	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
328	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
329	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
330	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
331	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
332	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
333	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
334	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
335	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
336	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
337	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
338	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
339	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
340	Creole	executeQuery(): [0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
341	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
342	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
343	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
344	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
345	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
346	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PER'
347	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
348	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PCN'
349	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
350	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
351	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
352	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
353	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
354	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
355	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
356	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
357	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
358	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
359	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
360	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
361	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
362	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
363	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
364	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
365	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
366	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
367	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
368	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
369	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
370	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
371	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
372	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
373	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
374	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
375	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
376	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
377	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
378	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
379	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
380	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
381	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
382	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
383	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
384	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
385	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
386	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
387	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
388	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
389	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
390	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
391	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
392	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
393	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
394	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
395	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
396	Creole	executeQuery(): [0.65 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
397	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
398	Creole	executeQuery(): [0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
399	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
400	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
401	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
402	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
403	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
404	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
405	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
406	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
407	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
408	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
409	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
410	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
411	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
412	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
413	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
414	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
415	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
416	Creole	executeQuery(): [0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SDN'
417	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
418	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FIN'
419	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
420	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SUR'
421	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
422	Creole	executeQuery(): [0.47 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
423	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
424	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
425	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
426	Creole	executeQuery(): [0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
427	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
428	Creole	executeQuery(): [0.55 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
429	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
430	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
431	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
432	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
433	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
434	Creole	executeQuery(): [0.62 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
435	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
436	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
437	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
438	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
439	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
440	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
441	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
442	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
443	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
444	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
445	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
446	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
447	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
448	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
449	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
450	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
451	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
452	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
453	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
454	Creole	executeQuery(): [0.59 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
455	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
456	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
457	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
458	Creole	executeQuery(): [0.68 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
459	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
460	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
461	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
462	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
463	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
464	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
465	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
466	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
467	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
468	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
469	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
470	Creole	executeQuery(): [0.60 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
471	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
472	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
473	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
474	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
475	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
476	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
477	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
478	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
479	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
480	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
481	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
482	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
483	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
484	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
485	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
486	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
487	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
488	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
489	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
490	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
491	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
492	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
493	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
494	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
495	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
496	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PSE'
497	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
498	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATA'
499	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
500	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
501	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
502	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
503	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
504	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
505	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
506	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HMD'
507	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
508	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATF'
509	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
510	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
511	PartialHelper	call "property->executeRecentlyAdded()"
512	Creole	prepareStatement(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property ORDER BY property.CREATED_AT DESC
513	Creole	applyLimit(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property ORDER BY property.CREATED_AT DESC, offset: 0, limit: 6
514	Creole	executeQuery(): [0.34 ms] SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property ORDER BY property.CREATED_AT DESC LIMIT 6
515	View	initialize view for "property/_recentlyAdded"
516	View	render "sf_app_dir/modules/property/templates/_recentlyAdded.php"
517	View	initialize view for "property/_googleads"
518	View	render "sf_app_dir/modules/property/templates/_googleads.php"

Configuration and request variables

debug
xdebug
logging
cache
eaccelerator
apc
xcache
compression
syck

Request

---
parameterHolder: 
  symfony/default: 
    action: search
    city: 616
    module: property
attributeHolder: 
  symfony/default:

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/sf_web_debug/js/main: /sf/sf_web_debug/js/main
  helper/asset/auto/meta: 
    description: >
      Samuelson Guide is the reliable
      international real estate and luxury
      real estate online guide with the
      properties listed in Florida, Arizona,
      California states as well as Costa Rica,
      Dominican Republic, Rio de Janeiro,
      Panama, etc.
    keywords: >
      international real estate, luxury real
      estate, florida real estate, costa rica
      real estate, dominican republic real
      estate, panama real estate, rio de
      janeiro real estate
    language: en
    robots: index, follow
    title: >
      Egypt Real Estate Listings -
      SamuelsonGuide.com Overseas real estate
      investment guide
    verify-v1: >
      GLy3YwV5L9RczGbaeSFt5uFxurJL+dt0YCNAymYRp/Y=
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    nav_menu: 
    sglayout: 
    sgmain: 
  symfony/response/http/headers: 
    Content-Type: text/html; charset=utf-8
  symfony/view/asset: 
    javascripts_included: 
    stylesheets_included:

Settings

---
app_sf_guard_plugin_success_signin_url: user/profile
app_sf_guard_plugin_success_signout_url: @homepage
app_sg_property_pictures_path: users/
app_sg_property_thumbnails_path: users/thumbs/
mod_property_enabled: 1
mod_property_is_internal: 
mod_property_view_class: sfPHP
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_config_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/apps/frontend/config
sf_app_config_dir_name: config
sf_app_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/apps/frontend
sf_app_i18n_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/apps/frontend/i18n
sf_app_i18n_dir_name: i18n
sf_app_lib_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/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: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/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: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/apps/frontend/templates
sf_app_template_dir_name: templates
sf_apps_dir_name: apps
sf_autoloading_functions: 
sf_available: 1
sf_base_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache/frontend
sf_bin_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/batch
sf_bin_dir_name: batch
sf_cache: 
sf_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/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: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache/frontend/dev/config
sf_config_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/config
sf_config_dir_name: config
sf_data_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/data
sf_data_dir_name: data
sf_debug: 1
sf_default_action: index
sf_default_module: default
sf_doc_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/data/doc
sf_doc_dir_name: doc
sf_enabled_modules: 
  - default
  - sfGuardAuth
  - sfGuardUser
  - sfGuardPermission
  - sfGuardGroup
  - sfPaypalLitePlugin
  - sfCaptcha
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: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache/frontend/dev/i18n
sf_lib_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/lib
sf_lib_dir_name: lib
sf_lightbox_css_dir: /sfLightboxPlugin/css/
sf_lightbox_js_dir: /sfLightboxPlugin/js/
sf_log_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/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: signin
sf_login_module: sfGuardAuth
sf_max_forwards: 5
sf_model_dir_name: model
sf_model_lib_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/lib/model
sf_module_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/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: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/plugins
sf_plugins_dir_name: plugins
sf_prototype_web_dir: /sf/prototype
sf_rich_text_js_dir: js/tiny_mce
sf_root_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache
sf_root_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs
sf_routing_defaults: 
  sf_culture: en
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers: 
  - Partial
  - Cache
  - Form
sf_strip_comments: 1
sf_suffix: .html
sf_symfony_data_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/config/../data/symfony
sf_symfony_lib_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/config/../lib/symfony
sf_template_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache/frontend/dev/template
sf_test: 
sf_test_cache_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/cache/frontend/dev/test
sf_test_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/test
sf_test_dir_name: test
sf_timeout: 1800
sf_timer_start: 1283897444.3612
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/web/images/users
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: >
  <span class="formErrorItem">
  &darr;&nbsp;
sf_validation_error_suffix:  &nbsp;&darr; </span>
sf_web_debug: 1
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: >
  /var/www/vhosts/samuelsonguide.com/httpdocs/web
sf_web_dir_name: web

Globals

---
cookie: 
  symfony: 8551usgm6s89f8m8de1rbv2b56
env: 
  CONSOLE: /dev/null
  HOME: /
  INIT_VERSION: sysvinit-2.85
  LANG: C
  PATH: >
    /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
  PREVLEVEL: N
  PWD: /
  RUNLEVEL: 3
  SELINUX_INIT: YES
  SHLVL: 2
  TERM: linux
  _: /sbin/initlog
  previous: N
  runlevel: 3
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web
  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=8551usgm6s89f8m8de1rbv2b56
  HTTP_HOST: www.samuelsonguide.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc02-02
  PATH: >
    /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
  PATH_INFO: /property/search/city/616.html
  PATH_TRANSLATED: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web/property/search/city/616.html
  PHP_SELF: /index.php/property/search/city/616.html
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.191.99
  REMOTE_PORT: 6684
  REQUEST_METHOD: GET
  REQUEST_TIME: 1283897444
  REQUEST_URI: /index.php/property/search/city/616.html
  SCRIPT_FILENAME: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 207.58.188.148
  SERVER_ADMIN: SAMUEL.MORHAIM@GMAIL.COM
  SERVER_NAME: www.samuelsonguide.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache/2.0.52 (CentOS) Server at www.samuelsonguide.com Port 80</address>
    
  SERVER_SOFTWARE: Apache/2.0.52 (CentOS)
session: 
  symfony/user/sfUser/attributes: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1283897390

Php

---
php: 5.2.6
os: >
  Linux vpw.whprices.com
  2.6.18-028stab069.6 #1 SMP Wed May 26
  18:10:06 MSD 2010 i686
extensions: 
  - libxml
  - xml
  - wddx
  - tokenizer
  - sysvshm
  - sysvsem
  - sysvmsg
  - session
  - pcre
  - SimpleXML
  - sockets
  - SPL
  - shmop
  - standard
  - Reflection
  - pspell
  - posix
  - iconv
  - hash
  - gmp
  - gettext
  - ftp
  - filter
  - exif
  - date
  - curl
  - ctype
  - calendar
  - bz2
  - zlib
  - openssl
  - apache2handler
  - dbase
  - dom
  - gd
  - imap
  - json
  - ldap
  - mbstring
  - mcrypt
  - mysql
  - mysqli
  - ncurses
  - odbc
  - PDO
  - pdo_mysql
  - PDO_ODBC
  - pdo_sqlite
  - snmp
  - xmlreader
  - xmlrpc
  - xmlwriter
  - xsl
  - zip
  - ionCube Loader

SQL queries

[0.45 ms] SELECT city.ID, city.NAME, city.COUNTRY_CODE, city.DISTRICT, city.POPULATION FROM city WHERE city.ID=616 LIMIT 1
[0.47 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE='EGY'
[6.35 ms] SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property
[1.34 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
[0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ABW'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUS'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLZ'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEN'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BMU'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BTN'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
[1.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
[0.76 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COK'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CRI'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESP'
[0.59 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZAF'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ETH'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FLK'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
[0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
[0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRK'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KOR'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBY'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LIE'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
[0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
[0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MTQ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MRT'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MUS'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
[0.70 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
[0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PER'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PCN'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
[0.65 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
[0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
[0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SDN'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FIN'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SUR'
[0.47 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
[0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
[0.55 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
[0.62 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
[0.59 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
[0.68 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
[0.60 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PSE'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATA'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HMD'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATF'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
[0.34 ms] SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property ORDER BY property.CREATED_AT DESC LIMIT 6

type	calls	time (ms)
Configuration	13	5.76
Action "property/search"	1	137.05
Database	244	79.29
View "Success" for "property/search"	1	559.74
Component "property/topCountry"	1	22.59
Partial "property/_topCountry"	1	317.73
Component "property/recentlyAdded"	1	2.23
Partial "property/_recentlyAdded"	1	2.22
Partial "property/_googleads"	1	0.38

International luxury real estate guide

Top Countries

Recent Properties

Go to...

Search Results

Sorry, we have no properties in that city for now. Please check back later.

SMS Marketing and Mobile Solutions Miami

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers