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 [property_search] "/s/:scountry/"
8	Request	request parameters array ( 'scountry' => 'COL', 'module' => 'property', 'action' => 'list',)
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->executeList()"
16	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
17	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE LIKE ? AND property.ACTIVE IS NULL
18	Creole	executeQuery(): [0.89 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL
19	View	initialize view for "property/list"
20	View	render "sf_app_dir/modules/property/templates/listSuccess.php"
21	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 WHERE property.COUNTRY_CODE LIKE ? AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC
22	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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC, offset: 0, limit: 12
23	Creole	executeQuery(): [1.08 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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC LIMIT 12
24	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 WHERE property.COUNTRY_CODE LIKE ? AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC
25	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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC, offset: 0, limit: 12
26	Creole	executeQuery(): [0.36 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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC LIMIT 12
27	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=?
28	Creole	executeQuery(): [0.44 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='COL'
29	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
30	Creole	executeQuery(): [0.40 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=816
31	View	initialize view for "property/_property_bread"
32	View	render "sf_app_dir/modules/property/templates/_property_bread.php"
33	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
34	Creole	executeQuery(): [0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=816
35	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
36	Creole	executeQuery(): [0.27 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=816
37	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
38	Creole	executeQuery(): [0.56 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=816
39	View	initialize view for "property/_property_picture"
40	View	render "sf_app_dir/modules/property/templates/_property_picture.php"
41	Creole	prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=?
42	Creole	executeQuery(): [0.55 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=816
43	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=?
44	Creole	executeQuery(): [0.50 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='COL'
45	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
46	Creole	executeQuery(): [0.25 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=706
47	View	initialize view for "property/_property_bread"
48	View	render "sf_app_dir/modules/property/templates/_property_bread.php"
49	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
50	Creole	executeQuery(): [0.34 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=706
51	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
52	Creole	executeQuery(): [0.18 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=706
53	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
54	Creole	executeQuery(): [0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=706
55	View	initialize view for "property/_property_picture"
56	View	render "sf_app_dir/modules/property/templates/_property_picture.php"
57	Creole	prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=?
58	Creole	executeQuery(): [0.75 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=706
59	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=?
60	Creole	executeQuery(): [0.58 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='COL'
61	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
62	Creole	executeQuery(): [0.31 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=705
63	View	initialize view for "property/_property_bread"
64	View	render "sf_app_dir/modules/property/templates/_property_bread.php"
65	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
66	Creole	executeQuery(): [0.27 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=705
67	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
68	Creole	executeQuery(): [0.26 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=705
69	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
70	Creole	executeQuery(): [0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=705
71	View	initialize view for "property/_property_picture"
72	View	render "sf_app_dir/modules/property/templates/_property_picture.php"
73	Creole	prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=?
74	Creole	executeQuery(): [0.47 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=705
75	View	initialize view for "property/_property_pager"
76	View	render "sf_app_dir/modules/property/templates/_property_pager.php"
77	View	decorate content with "sf_app_dir/templates/layout.php"
78	View	render "sf_app_dir/templates/layout.php"
79	PartialHelper	call "property->executeTopCountry()"
80	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
81	Creole	executeQuery(): [1.32 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
82	View	initialize view for "property/_topCountry"
83	View	render "sf_app_dir/modules/property/templates/_topCountry.php"
84	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
85	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
86	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
87	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
88	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
89	Creole	executeQuery(): [0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
90	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
91	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
92	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
93	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
94	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
95	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
96	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
97	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
98	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
99	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
100	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
101	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
102	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
103	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
104	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
105	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
106	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
107	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
108	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
109	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
110	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
111	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ABW'
112	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
113	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUS'
114	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
115	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
116	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
117	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
118	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
119	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
120	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
121	Creole	executeQuery(): [0.77 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
122	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
123	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
124	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
125	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
126	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
127	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLZ'
128	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
129	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEN'
130	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
131	Creole	executeQuery(): [0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BMU'
132	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
133	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BTN'
134	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
135	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
136	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
137	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
138	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
139	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
140	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
141	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
142	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
143	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
144	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
145	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
146	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
147	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
148	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
149	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
150	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
151	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
152	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
153	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
154	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
155	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
156	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
157	Creole	executeQuery(): [0.76 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
158	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
159	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COK'
160	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
161	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CRI'
162	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
163	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
164	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
165	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
166	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
167	Creole	executeQuery(): [0.56 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
168	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
169	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
170	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
171	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
172	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
173	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
174	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
175	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
176	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
177	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESP'
178	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
179	Creole	executeQuery(): [0.59 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZAF'
180	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
181	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ETH'
182	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
183	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FLK'
184	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
185	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
186	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
187	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
188	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
189	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
190	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
191	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
192	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
193	Creole	executeQuery(): [0.63 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
194	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
195	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
196	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
197	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
198	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
199	Creole	executeQuery(): [0.89 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
200	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
201	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
202	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
203	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
204	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
205	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
206	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
207	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
208	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
209	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
210	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
211	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
212	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
213	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
214	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
215	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
216	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
217	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
218	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
219	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
220	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
221	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
222	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
223	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
224	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
225	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
226	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
227	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
228	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
229	Creole	executeQuery(): [0.75 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
230	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
231	Creole	executeQuery(): [0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
232	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
233	Creole	executeQuery(): [0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
234	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
235	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
236	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
237	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
238	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
239	Creole	executeQuery(): [0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
240	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
241	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
242	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
243	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
244	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
245	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
246	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
247	Creole	executeQuery(): [0.85 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
248	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
249	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
250	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
251	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
252	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
253	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
254	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
255	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
256	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
257	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
258	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
259	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
260	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
261	Creole	executeQuery(): [0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
262	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
263	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
264	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
265	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
266	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
267	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
268	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
269	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
270	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
271	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
272	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
273	Creole	executeQuery(): [0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
274	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
275	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
276	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
277	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
278	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
279	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
280	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
281	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
282	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
283	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
284	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
285	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
286	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
287	Creole	executeQuery(): [0.84 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRK'
288	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
289	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KOR'
290	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
291	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
292	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
293	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
294	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
295	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
296	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
297	Creole	executeQuery(): [1.03 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
298	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
299	Creole	executeQuery(): [1.00 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
300	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
301	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
302	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
303	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
304	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
305	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
306	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
307	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
308	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
309	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
310	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
311	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBY'
312	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
313	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LIE'
314	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
315	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
316	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
317	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
318	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
319	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
320	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
321	Creole	executeQuery(): [0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
322	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
323	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
324	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
325	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
326	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
327	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
328	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
329	Creole	executeQuery(): [0.49 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
330	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
331	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
332	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
333	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
334	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
335	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
336	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
337	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
338	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
339	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
340	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
341	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MTQ'
342	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
343	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MRT'
344	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
345	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MUS'
346	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
347	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
348	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
349	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
350	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
351	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
352	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
353	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
354	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
355	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
356	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
357	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
358	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
359	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
360	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
361	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
362	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
363	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
364	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
365	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
366	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
367	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
368	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
369	Creole	executeQuery(): [0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
370	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
371	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
372	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
373	Creole	executeQuery(): [0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
374	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
375	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
376	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
377	Creole	executeQuery(): [0.49 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
378	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
379	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
380	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
381	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
382	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
383	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
384	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
385	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
386	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
387	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
388	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
389	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
390	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
391	Creole	executeQuery(): [0.58 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
392	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
393	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
394	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
395	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
396	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
397	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PER'
398	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
399	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PCN'
400	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
401	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
402	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
403	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
404	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
405	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
406	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
407	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
408	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
409	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
410	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
411	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
412	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
413	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
414	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
415	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
416	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
417	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
418	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
419	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
420	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
421	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
422	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
423	Creole	executeQuery(): [0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
424	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
425	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
426	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
427	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
428	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
429	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
430	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
431	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
432	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
433	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
434	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
435	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
436	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
437	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
438	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
439	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
440	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
441	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
442	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
443	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
444	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
445	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
446	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
447	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
448	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
449	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
450	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
451	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
452	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
453	Creole	executeQuery(): [0.58 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
454	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
455	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
456	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
457	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
458	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
459	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
460	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
461	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
462	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
463	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
464	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
465	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
466	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
467	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SDN'
468	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
469	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FIN'
470	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
471	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SUR'
472	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
473	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
474	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
475	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
476	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
477	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
478	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
479	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
480	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
481	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
482	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
483	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
484	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
485	Creole	executeQuery(): [0.66 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
486	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
487	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
488	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
489	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
490	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
491	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
492	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
493	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
494	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
495	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
496	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
497	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
498	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
499	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
500	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
501	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
502	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
503	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
504	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
505	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
506	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
507	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
508	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
509	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
510	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
511	Creole	executeQuery(): [0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
512	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
513	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
514	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
515	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
516	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
517	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
518	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
519	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
520	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
521	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
522	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
523	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
524	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
525	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
526	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
527	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
528	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
529	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
530	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
531	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
532	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
533	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
534	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
535	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
536	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
537	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
538	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
539	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
540	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
541	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
542	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
543	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
544	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
545	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
546	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
547	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PSE'
548	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
549	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATA'
550	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
551	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
552	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
553	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
554	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
555	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
556	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
557	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HMD'
558	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
559	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATF'
560	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
561	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
562	PartialHelper	call "property->executeRecentlyAdded()"
563	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
564	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
565	Creole	executeQuery(): [0.38 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
566	View	initialize view for "property/_recentlyAdded"
567	View	render "sf_app_dir/modules/property/templates/_recentlyAdded.php"
568	View	initialize view for "property/_googleads"
569	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: list
    module: property
    scountry: COL
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: >
      International Real Estate, Luxury Real
      Estate - Florida, Costa Rica, Panama,
      Dominican Republic, Rio De Janeiro -
      Samuelson 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: 1280537765.0786
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: 2vu3ptnn7ch2o35kdvrkt14430
env: 
  G_BROKEN_FILENAMES: 1
  HISTFILE: /dev/null
  HISTSIZE: 1000
  HOME: /
  HOSTNAME: vpw.whprices.com
  INPUTRC: /etc/inputrc
  LANG: C
  LESSOPEN: |/usr/bin/lesspipe.sh %s
  LOGNAME: root
  LS_COLORS: >
    no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
  MAIL: /var/spool/mail/root
  MANPATH: //man:
  PATH: >
    /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
  PWD: /etc/httpd/conf.d
  SHELL: /bin/bash
  SHLVL: 2
  TERM: linux
  USER: root
  _: /sbin/initlog
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=2vu3ptnn7ch2o35kdvrkt14430
  HTTP_HOST: www.samuelsonguide.com
  HTTP_IF_MODIFIED_SINCE: Fri, 02 Apr 2010 14:23:56 GMT
  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: /s/COL/
  PATH_TRANSLATED: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web/s/COL/
  PHP_SELF: /index.php/s/COL/
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.191.97
  REMOTE_PORT: 51051
  REQUEST_METHOD: GET
  REQUEST_TIME: 1280537765
  REQUEST_URI: /index.php/s/COL/
  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/attributes: 
      iData: 63535
      captcha: 63535
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1280537759

Php

---
php: 5.2.6
os: >
  Linux vpw.whprices.com
  2.6.18-028stab064.7 #1 SMP Wed Aug 26
  13:11:07 MSD 2009 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.89 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL
[1.08 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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC LIMIT 12
[0.36 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 WHERE property.COUNTRY_CODE LIKE 'COL' AND property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC LIMIT 12
[0.44 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='COL'
[0.40 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=816
[0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=816
[0.27 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=816
[0.56 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=816
[0.55 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=816
[0.50 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='COL'
[0.25 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=706
[0.34 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=706
[0.18 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=706
[0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=706
[0.75 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=706
[0.58 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='COL'
[0.31 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=705
[0.27 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=705
[0.26 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=705
[0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=705
[0.47 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=705
[1.32 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.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
[0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
[0.25 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.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
[0.77 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLZ'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEN'
[0.45 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.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
[0.76 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COK'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CRI'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
[0.56 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
[0.27 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.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ETH'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FLK'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
[0.63 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
[0.89 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
[0.75 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
[0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
[0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
[0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
[0.85 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
[0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
[0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
[0.84 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRK'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KOR'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
[1.03 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
[1.00 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
[0.33 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.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
[0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
[0.49 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MTQ'
[0.22 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.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
[0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
[0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
[0.49 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
[0.58 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PER'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PCN'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
[0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
[0.58 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SDN'
[0.25 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.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
[0.66 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
[0.52 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
[0.19 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.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
[0.20 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.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
[0.38 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.36
Action "property/list"	1	30.80
Database	262	82.79
View "Success" for "property/list"	1	452.90
Partial "property/_property_bread"	3	22.75
Partial "property/_property_picture"	3	21.59
Partial "property/_property_pager"	1	0.64
Component "property/topCountry"	1	23.33
Partial "property/_topCountry"	1	305.11
Component "property/recentlyAdded"	1	2.11
Partial "property/_recentlyAdded"	1	2.17
Partial "property/_googleads"	1	0.36

International luxury real estate guide

Top Countries

Recent Properties

Go to...

Latest Real Estate Listings

INVEST IN BOGOTA COLOMBIA "NEW APARTMENT" BEST AREA IN CITY, REAL STATE IS GOOD HERE IS GROWING

US$260,000.00

Cartagena Laguna Club

US$90,000.00

Edificio El Faro

US$125,000.00

SMS Marketing and Mobile Solutions Miami

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers