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] "/property/:seotitle"
8	Request	request parameters array ( 'seotitle' => 'time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale', 'module' => 'property', 'action' => 'show',)
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->executeShow()"
16	Creole	connect(): DSN: array ( 'database' => '**', 'encoding' => '', 'hostspec' => '', 'password' => '', 'persistent' => '', 'phptype' => '', 'port' => '', 'protocol' => '', 'username' => '**', ), FLAGS: 0
17	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.SEOTITLE=?
18	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.SEOTITLE='time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale', offset: 0, limit: 1
19	Creole	executeQuery(): [2.27 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.SEOTITLE='time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale' LIMIT 1
20	Creole	prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE=?
21	Creole	executeQuery(): [0.37 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='MEX'
22	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP=? AND detail.PROPERTY_ID=?
23	Creole	executeQuery(): [1.00 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Location' AND detail.PROPERTY_ID=821
24	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP=? AND detail.PROPERTY_ID=?
25	Creole	executeQuery(): [0.64 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Data' AND detail.PROPERTY_ID=821
26	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP=? AND detail.PROPERTY_ID=?
27	Creole	executeQuery(): [0.58 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Required' AND detail.PROPERTY_ID=821
28	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP=? AND detail.PROPERTY_ID=?
29	Creole	executeQuery(): [0.84 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Pricing' AND detail.PROPERTY_ID=821
30	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP=? AND detail.PROPERTY_ID=?
31	Creole	executeQuery(): [0.71 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Features' AND detail.PROPERTY_ID=821
32	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.PROPERTY_ID=?
33	Creole	executeQuery(): [0.97 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.PROPERTY_ID=821
34	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.PROPERTY_ID=?
35	Creole	executeQuery(): [0.72 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.PROPERTY_ID=821
36	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.ACTIVE IS NULL AND property.COUNTRY_CODE=? ORDER BY property.CREATED_AT DESC
37	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.ACTIVE IS NULL AND property.COUNTRY_CODE='MEX' ORDER BY property.CREATED_AT DESC, offset: 0, limit: 12
38	Creole	executeQuery(): [0.90 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.ACTIVE IS NULL AND property.COUNTRY_CODE='MEX' ORDER BY property.CREATED_AT DESC LIMIT 12
39	View	initialize view for "property/show"
40	View	render "sf_app_dir/modules/property/templates/showSuccess.php"
41	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
42	Creole	executeQuery(): [0.29 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
43	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
44	Creole	executeQuery(): [0.23 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
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.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
47	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
48	Creole	executeQuery(): [0.24 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=821
49	View	initialize view for "property/_property_bread"
50	View	render "sf_app_dir/modules/property/templates/_property_bread.php"
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.27 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
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.24 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
55	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
56	Creole	executeQuery(): [0.35 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
57	View	initialize view for "property/_property_picture"
58	View	render "sf_app_dir/modules/property/templates/_property_picture.php"
59	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=?
60	Creole	executeQuery(): [0.28 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=821
61	View	initialize view for "property/_property_picture"
62	View	render "sf_app_dir/modules/property/templates/_property_picture.php"
63	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.PROPERTY_ID=?
64	Creole	executeQuery(): [0.58 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.PROPERTY_ID=821
65	View	initialize view for "property/_property_contact_form"
66	View	render "sf_app_dir/modules/property/templates/_property_contact_form.php"
67	Creole	prepareStatement(): SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_guard_user WHERE sf_guard_user.ID=?
68	Creole	executeQuery(): [0.59 ms] SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_guard_user WHERE sf_guard_user.ID=133
69	Creole	prepareStatement(): SELECT sf_guard_user_profile.ID, sf_guard_user_profile.USER_ID, sf_guard_user_profile.FIRSTNAME, sf_guard_user_profile.LASTNAME, sf_guard_user_profile.MIDDLENAME, sf_guard_user_profile.EMAIL, sf_guard_user_profile.EMAILOPTIN, sf_guard_user_profile.PHONE FROM sf_guard_user_profile WHERE sf_guard_user_profile.USER_ID=?
70	Creole	applyLimit(): SELECT sf_guard_user_profile.ID, sf_guard_user_profile.USER_ID, sf_guard_user_profile.FIRSTNAME, sf_guard_user_profile.LASTNAME, sf_guard_user_profile.MIDDLENAME, sf_guard_user_profile.EMAIL, sf_guard_user_profile.EMAILOPTIN, sf_guard_user_profile.PHONE FROM sf_guard_user_profile WHERE sf_guard_user_profile.USER_ID=133, offset: 0, limit: 1
71	Creole	executeQuery(): [0.84 ms] SELECT sf_guard_user_profile.ID, sf_guard_user_profile.USER_ID, sf_guard_user_profile.FIRSTNAME, sf_guard_user_profile.LASTNAME, sf_guard_user_profile.MIDDLENAME, sf_guard_user_profile.EMAIL, sf_guard_user_profile.EMAILOPTIN, sf_guard_user_profile.PHONE FROM sf_guard_user_profile WHERE sf_guard_user_profile.USER_ID=133 LIMIT 1
72	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
73	Creole	executeQuery(): [0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
74	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
75	Creole	executeQuery(): [0.34 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
76	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
77	Creole	executeQuery(): [0.33 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
78	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
79	Creole	executeQuery(): [0.28 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
80	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
81	Creole	executeQuery(): [0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
82	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
83	Creole	executeQuery(): [0.42 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
84	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
85	Creole	executeQuery(): [0.25 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
86	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
87	Creole	executeQuery(): [0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
88	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
89	Creole	executeQuery(): [0.32 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
90	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=?
91	Creole	executeQuery(): [0.36 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='MEX'
92	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
93	Creole	executeQuery(): [0.43 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=821
94	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
95	Creole	executeQuery(): [0.37 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=820
96	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
97	Creole	executeQuery(): [0.63 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=820
98	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
99	Creole	executeQuery(): [0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=820
100	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=?
101	Creole	executeQuery(): [0.30 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='MEX'
102	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
103	Creole	executeQuery(): [0.16 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=820
104	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
105	Creole	executeQuery(): [0.54 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=751
106	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
107	Creole	executeQuery(): [0.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=751
108	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
109	Creole	executeQuery(): [0.38 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=751
110	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=?
111	Creole	executeQuery(): [0.22 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='MEX'
112	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
113	Creole	executeQuery(): [0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=751
114	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
115	Creole	executeQuery(): [0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=748
116	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
117	Creole	executeQuery(): [0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=748
118	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
119	Creole	executeQuery(): [0.37 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=748
120	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=?
121	Creole	executeQuery(): [0.21 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='MEX'
122	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
123	Creole	executeQuery(): [0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=748
124	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
125	Creole	executeQuery(): [0.67 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=745
126	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
127	Creole	executeQuery(): [0.44 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=745
128	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
129	Creole	executeQuery(): [0.64 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=745
130	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=?
131	Creole	executeQuery(): [0.21 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='MEX'
132	Creole	prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=?
133	Creole	executeQuery(): [0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=745
134	View	decorate content with "sf_app_dir/templates/layout.php"
135	View	render "sf_app_dir/templates/layout.php"
136	PartialHelper	call "property->executeTopCountry()"
137	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
138	Creole	executeQuery(): [1.36 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
139	View	initialize view for "property/_topCountry"
140	View	render "sf_app_dir/modules/property/templates/_topCountry.php"
141	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
142	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
143	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
144	Creole	executeQuery(): [0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
145	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
146	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
147	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
148	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
149	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
150	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
151	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
152	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
153	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
154	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
155	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
156	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
157	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
158	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
159	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
160	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
161	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
162	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
163	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
164	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
165	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
166	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
167	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
168	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ABW'
169	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
170	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUS'
171	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
172	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
173	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
174	Creole	executeQuery(): [0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
175	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
176	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
177	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
178	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
179	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
180	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
181	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
182	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
183	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
184	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLZ'
185	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
186	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEN'
187	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
188	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BMU'
189	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
190	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BTN'
191	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
192	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
193	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
194	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
195	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
196	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
197	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
198	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
199	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
200	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
201	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
202	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
203	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
204	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
205	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
206	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
207	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
208	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
209	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
210	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
211	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
212	Creole	executeQuery(): [0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
213	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
214	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
215	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
216	Creole	executeQuery(): [0.60 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COK'
217	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
218	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CRI'
219	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
220	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
221	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
222	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
223	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
224	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
225	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
226	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
227	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
228	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
229	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
230	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
231	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
232	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
233	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
234	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESP'
235	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
236	Creole	executeQuery(): [0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZAF'
237	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
238	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ETH'
239	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
240	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FLK'
241	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
242	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
243	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
244	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
245	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
246	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
247	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
248	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
249	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
250	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
251	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
252	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
253	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
254	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
255	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
256	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
257	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
258	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
259	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
260	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
261	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
262	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
263	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
264	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
265	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
266	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
267	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
268	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
269	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
270	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
271	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
272	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
273	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
274	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
275	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
276	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
277	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
278	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
279	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
280	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
281	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
282	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
283	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
284	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
285	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
286	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
287	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
288	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
289	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
290	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
291	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
292	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
293	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
294	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
295	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
296	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
297	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
298	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
299	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
300	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
301	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
302	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
303	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
304	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
305	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
306	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
307	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
308	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
309	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
310	Creole	executeQuery(): [0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
311	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
312	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
313	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
314	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
315	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
316	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
317	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
318	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
319	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
320	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
321	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
322	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
323	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
324	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
325	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
326	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
327	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
328	Creole	executeQuery(): [0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
329	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
330	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
331	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
332	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
333	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
334	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
335	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
336	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
337	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
338	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
339	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
340	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
341	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
342	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
343	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
344	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRK'
345	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
346	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KOR'
347	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
348	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
349	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
350	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
351	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
352	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
353	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
354	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
355	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
356	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
357	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
358	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
359	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
360	Creole	executeQuery(): [0.61 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
361	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
362	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
363	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
364	Creole	executeQuery(): [0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
365	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
366	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
367	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
368	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBY'
369	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
370	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LIE'
371	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
372	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
373	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
374	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
375	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
376	Creole	executeQuery(): [0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
377	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
378	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
379	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
380	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
381	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
382	Creole	executeQuery(): [0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
383	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
384	Creole	executeQuery(): [0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
385	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
386	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
387	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
388	Creole	executeQuery(): [0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
389	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
390	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
391	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
392	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
393	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
394	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
395	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
396	Creole	executeQuery(): [0.56 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
397	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
398	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MTQ'
399	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
400	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MRT'
401	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
402	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MUS'
403	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
404	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
405	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
406	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
407	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
408	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
409	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
410	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
411	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
412	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
413	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
414	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
415	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
416	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
417	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
418	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
419	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
420	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
421	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
422	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
423	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
424	Creole	executeQuery(): [0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
425	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
426	Creole	executeQuery(): [0.61 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
427	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
428	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
429	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
430	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
431	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
432	Creole	executeQuery(): [0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
433	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
434	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
435	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
436	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
437	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
438	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
439	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
440	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
441	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
442	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
443	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
444	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
445	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
446	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
447	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
448	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
449	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
450	Creole	executeQuery(): [0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
451	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
452	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
453	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
454	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PER'
455	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
456	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PCN'
457	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
458	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
459	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
460	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
461	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
462	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
463	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
464	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
465	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
466	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
467	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
468	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
469	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
470	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
471	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
472	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
473	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
474	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
475	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
476	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
477	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
478	Creole	executeQuery(): [0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
479	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
480	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
481	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
482	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
483	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
484	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
485	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
486	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
487	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
488	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
489	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
490	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
491	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
492	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
493	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
494	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
495	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
496	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
497	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
498	Creole	executeQuery(): [0.47 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
499	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
500	Creole	executeQuery(): [0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
501	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
502	Creole	executeQuery(): [0.57 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
503	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
504	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
505	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
506	Creole	executeQuery(): [0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
507	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
508	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
509	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
510	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
511	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
512	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
513	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
514	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
515	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
516	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
517	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
518	Creole	executeQuery(): [0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
519	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
520	Creole	executeQuery(): [0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
521	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
522	Creole	executeQuery(): [0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
523	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
524	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SDN'
525	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
526	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FIN'
527	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
528	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SUR'
529	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
530	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
531	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
532	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
533	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
534	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
535	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
536	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
537	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
538	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
539	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
540	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
541	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
542	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
543	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
544	Creole	executeQuery(): [0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
545	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
546	Creole	executeQuery(): [0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
547	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
548	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
549	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
550	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
551	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
552	Creole	executeQuery(): [0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
553	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
554	Creole	executeQuery(): [0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
555	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
556	Creole	executeQuery(): [0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
557	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
558	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
559	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
560	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
561	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
562	Creole	executeQuery(): [0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
563	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
564	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
565	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
566	Creole	executeQuery(): [0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
567	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
568	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
569	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
570	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
571	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
572	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
573	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
574	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
575	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
576	Creole	executeQuery(): [0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
577	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
578	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
579	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
580	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
581	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
582	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
583	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
584	Creole	executeQuery(): [0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
585	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
586	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
587	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
588	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
589	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
590	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
591	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
592	Creole	executeQuery(): [0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
593	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
594	Creole	executeQuery(): [0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
595	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
596	Creole	executeQuery(): [0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
597	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
598	Creole	executeQuery(): [0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
599	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
600	Creole	executeQuery(): [0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
601	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
602	Creole	executeQuery(): [0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
603	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
604	Creole	executeQuery(): [0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PSE'
605	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
606	Creole	executeQuery(): [0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATA'
607	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
608	Creole	executeQuery(): [0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
609	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
610	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
611	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
612	Creole	executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
613	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
614	Creole	executeQuery(): [0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HMD'
615	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
616	Creole	executeQuery(): [0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATF'
617	Creole	prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE=?
618	Creole	executeQuery(): [0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
619	PartialHelper	call "property->executeRecentlyAdded()"
620	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
621	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
622	Creole	executeQuery(): [0.43 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
623	View	initialize view for "property/_recentlyAdded"
624	View	render "sf_app_dir/modules/property/templates/_recentlyAdded.php"
625	View	initialize view for "property/_googleads"
626	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: show
    module: property
    seotitle: >
      time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale
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/prototype/js/effects: /sf/prototype/js/effects
    /sf/prototype/js/prototype: /sf/prototype/js/prototype
    /sf/sf_web_debug/js/main: /sf/sf_web_debug/js/main
    /sfLightboxPlugin/js/lightbox.js: /sfLightboxPlugin/js/lightbox.js
  helper/asset/auto/meta: 
    description: |
      2 Bedroom 2 Bathroom,Penthose.
      All Furnished.
      Air Conditioning.
      Sun Roof with Private Pool and Jacuzzi.
      2 Pools in the development.
      T.V. DVD Included.
      Modern Custom Kitchen full Equiped.
      Telephone Line.
      24 Hrs. Security System.
      322 ft.away from where all Gorgeous Girls GO. Mamitas Beach!
      
      
      
    keywords: >
      Fun, Sun and Relaxation with Security,
      deffenitly an Opportunity. , real estate
      Mexico
    language: en
    robots: index, follow
    title: >
      Time of Opportunities Ripe me Off, Playa
      del Carmen Q. Roo SALE!!!!!, Mexico -
      SamuelsonGuide.com Overseas real estate
      investment guide
    verify-v1: >
      GLy3YwV5L9RczGbaeSFt5uFxurJL+dt0YCNAymYRp/Y=
  helper/asset/auto/stylesheet: 
    /sf/sf_web_debug/css/main: 
    /sfLightboxPlugin/css/lightbox.css: 
    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: 1268346683.3958
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: atkl22cfrd6nc56kllg4esilp0
env: 
  CONSOLE: /dev/null
  HOME: /
  INIT_VERSION: sysvinit-2.85
  LANG: C
  PATH: >
    /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
  PREVLEVEL: N
  PWD: /
  RUNLEVEL: 3
  SELINUX_INIT: YES
  SHLVL: 2
  TERM: linux
  _: /sbin/initlog
  previous: N
  runlevel: 3
files: 
get: 
post: 
server: 
  DOCUMENT_ROOT: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: >
    text/xml,application/xhtml+xml,text/html;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=atkl22cfrd6nc56kllg4esilp0
  HTTP_HOST: www.samuelsonguide.com
  HTTP_PRAGMA: no-cache
  HTTP_USER_AGENT: >
    CCBot/1.0
    (+http://www.commoncrawl.org/bot.html)
  HTTP_X_CC_ID: ccc01-02
  PATH: >
    /sbin:/usr/sbin:/bin:/usr/bin:/usr/X11R6/bin
  PATH_INFO: >
    /property/time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale.html
  PATH_TRANSLATED: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web/property/time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale.html
  PHP_SELF: >
    /index.php/property/time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale.html
  QUERY_STRING: 
  REMOTE_ADDR: 38.107.191.97
  REMOTE_PORT: 50814
  REQUEST_METHOD: GET
  REQUEST_TIME: 1268346683
  REQUEST_URI: >
    /index.php/property/time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale.html
  SCRIPT_FILENAME: >
    /var/www/vhosts/samuelsonguide.com/httpdocs/web/index.php
  SCRIPT_NAME: /index.php
  SERVER_ADDR: 207.58.188.148
  SERVER_ADMIN: SAMUEL.MORHAIM@GMAIL.COM
  SERVER_NAME: www.samuelsonguide.com
  SERVER_PORT: 80
  SERVER_PROTOCOL: HTTP/1.1
  SERVER_SIGNATURE: |
    <address>Apache/2.0.52 (CentOS) Server at www.samuelsonguide.com Port 80</address>
    
  SERVER_SOFTWARE: Apache/2.0.52 (CentOS)
session: 
  symfony/user/sfUser/attributes: 
  symfony/user/sfUser/authenticated: 
  symfony/user/sfUser/credentials: 
  symfony/user/sfUser/culture: en
  symfony/user/sfUser/lastRequest: 1268346675

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

[2.27 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.SEOTITLE='time-of-opportunities-ripe-me-off-playa-del-carmen-q-roo-sale' LIMIT 1
[0.37 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='MEX'
[1.00 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Location' AND detail.PROPERTY_ID=821
[0.64 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Data' AND detail.PROPERTY_ID=821
[0.58 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Required' AND detail.PROPERTY_ID=821
[0.84 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Pricing' AND detail.PROPERTY_ID=821
[0.71 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.DGROUP='Features' AND detail.PROPERTY_ID=821
[0.97 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.PROPERTY_ID=821
[0.72 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.PROPERTY_ID=821
[0.90 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.ACTIVE IS NULL AND property.COUNTRY_CODE='MEX' ORDER BY property.CREATED_AT DESC LIMIT 12
[0.29 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
[0.23 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
[0.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
[0.24 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=821
[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=821
[0.24 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
[0.35 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
[0.28 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=821
[0.58 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.PROPERTY_ID=821
[0.59 ms] SELECT sf_guard_user.ID, sf_guard_user.USERNAME, sf_guard_user.ALGORITHM, sf_guard_user.SALT, sf_guard_user.PASSWORD, sf_guard_user.CREATED_AT, sf_guard_user.LAST_LOGIN, sf_guard_user.IS_ACTIVE, sf_guard_user.IS_SUPER_ADMIN FROM sf_guard_user WHERE sf_guard_user.ID=133
[0.84 ms] SELECT sf_guard_user_profile.ID, sf_guard_user_profile.USER_ID, sf_guard_user_profile.FIRSTNAME, sf_guard_user_profile.LASTNAME, sf_guard_user_profile.MIDDLENAME, sf_guard_user_profile.EMAIL, sf_guard_user_profile.EMAILOPTIN, sf_guard_user_profile.PHONE FROM sf_guard_user_profile WHERE sf_guard_user_profile.USER_ID=133 LIMIT 1
[0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
[0.34 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
[0.33 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
[0.28 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
[0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
[0.42 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
[0.25 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821
[0.30 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821
[0.32 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=821
[0.36 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='MEX'
[0.43 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=821
[0.37 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=820
[0.63 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=820
[0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=820
[0.30 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='MEX'
[0.16 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=820
[0.54 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=751
[0.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=751
[0.38 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=751
[0.22 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='MEX'
[0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=751
[0.39 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=748
[0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=748
[0.37 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=748
[0.21 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='MEX'
[0.36 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=748
[0.67 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=745
[0.44 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=745
[0.64 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=745
[0.21 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='MEX'
[0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=745
[1.36 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.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AFG'
[0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NLD'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ANT'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ALB'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DZA'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ASM'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AND'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AGO'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AIA'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATG'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARE'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARG'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ARM'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ABW'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUS'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AZE'
[0.44 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHS'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BHR'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGD'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRB'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BEL'
[0.40 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.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BMU'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BTN'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BOL'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BIH'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BWA'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRA'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GBR'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VGB'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BRN'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BGR'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BFA'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BDI'
[0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYM'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHL'
[0.60 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.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DJI'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DMA'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DOM'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ECU'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EGY'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLV'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ERI'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESP'
[0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZAF'
[0.39 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.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FJI'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PHL'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRO'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GAB'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GMB'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GEO'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GHA'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIB'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRD'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRL'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GLP'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUM'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GTM'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GIN'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNB'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUY'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HTI'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HND'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HKG'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SJM'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IDN'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IND'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRQ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRN'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IRL'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISL'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ISR'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ITA'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TMP'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='AUT'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JAM'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JPN'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YEM'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='JOR'
[0.45 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CXR'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='YUG'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KHM'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CMR'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAN'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CPV'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KAZ'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KEN'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CAF'
[0.17 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHN'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KGZ'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KIR'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COL'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COM'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COG'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='COD'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CCK'
[0.29 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.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GRC'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HRV'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CUB'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KWT'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CYP'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LAO'
[0.61 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LVA'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LSO'
[0.38 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBN'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LBY'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LIE'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LTU'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LUX'
[0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ESH'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAC'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDG'
[0.48 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MKD'
[0.50 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MWI'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDV'
[0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYS'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLI'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MLT'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MAR'
[0.56 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MHL'
[0.24 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.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MUS'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MYT'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MEX'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FSM'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MDA'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MCO'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNG'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MSR'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MOZ'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MMR'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NAM'
[0.15 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NRU'
[0.61 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NPL'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIC'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NER'
[0.53 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NGA'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NIU'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NFK'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NOR'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CIV'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='OMN'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAK'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PLW'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PAN'
[0.35 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PNG'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRY'
[0.25 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.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='MNP'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRT'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PRI'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='POL'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GNQ'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='QAT'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='FRA'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='GUF'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PYF'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='REU'
[0.20 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ROM'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RWA'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWE'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SHN'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='KNA'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LCA'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VCT'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SPM'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DEU'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLB'
[0.47 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZMB'
[0.46 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WSM'
[0.57 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SMR'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='STP'
[0.16 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SAU'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SEN'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYC'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SLE'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGP'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVK'
[0.36 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SVN'
[0.40 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SOM'
[0.51 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='LKA'
[0.24 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.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SUR'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SWZ'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CHE'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SYR'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TJK'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TWN'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TZA'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='DNK'
[0.27 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='THA'
[0.43 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TGO'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKL'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TON'
[0.41 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TTO'
[0.42 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCD'
[0.23 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='CZE'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUN'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUR'
[0.33 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TKM'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TCA'
[0.18 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='TUV'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UGA'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UKR'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HUN'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='URY'
[0.30 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NCL'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='NZL'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UZB'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BLR'
[0.21 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='WLF'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VUT'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VAT'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VEN'
[0.37 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='RUS'
[0.14 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VNM'
[0.22 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='EST'
[0.32 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='USA'
[0.31 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='VIR'
[0.19 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ZWE'
[0.39 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='PSE'
[0.34 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATA'
[0.26 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='BVT'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='IOT'
[0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='SGS'
[0.29 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='HMD'
[0.25 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='ATF'
[0.28 ms] SELECT COUNT(property.ID) FROM property WHERE property.COUNTRY_CODE='UMI'
[0.43 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.26
Action "property/show"	1	76.91
Database	293	94.21
View "Success" for "property/show"	1	466.59
Partial "property/_property_bread"	1	7.58
Partial "property/_property_picture"	2	12.06
Partial "property/_property_contact_form"	1	32.35
Component "property/topCountry"	1	22.59
Partial "property/_topCountry"	1	303.78
Component "property/recentlyAdded"	1	2.44
Partial "property/_recentlyAdded"	1	2.28
Partial "property/_googleads"	1	0.38

International luxury real estate guide

Top Countries

Recent Properties

Go to...

Residential Apartment For Sale in Mexico

Time of Opportunities Ripe me Off, Playa del Carmen Q. Roo SALE!!!!!

US$470,000.00

Listing Contact Information

People that looked at this property were also interested in:

Log and debug messages

Configuration and request variables

Request

Response

Settings

Globals

Php

SQL queries

Timers