| # |
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 [homepage] "/" |
| 8 | Request | request parameters array ( 'module' => 'property', 'action' => 'list',) |
| 9 | Controller | dispatch request |
| 10 | Filter | executing filter "sfRenderingFilter" |
| 11 | Filter | executing filter "sfWebDebugFilter" |
| 12 | Filter | executing filter "sfCommonFilter" |
| 13 | Filter | executing filter "sfFlashFilter" |
| 14 | Filter | executing filter "sfExecutionFilter" |
| 15 | Action | call "propertyActions->executeList()" |
| 16 | Creole | connect(): DSN: array ( 'database' => '****', 'encoding' => '****', 'hostspec' => '****', 'password' => '****', 'persistent' => '****', 'phptype' => '****', 'port' => '****', 'protocol' => '****', 'username' => '****', ), FLAGS: 0 |
| 17 | Creole | prepareStatement(): SELECT COUNT(property.ID) FROM property WHERE property.ACTIVE IS NULL |
| 18 | Creole | executeQuery(): [0.24 ms] SELECT COUNT(property.ID) FROM property WHERE property.ACTIVE IS NULL |
| 19 | View | initialize view for "property/list" |
| 20 | View | render "sf_app_dir/modules/property/templates/listSuccess.php" |
| 21 | Creole | prepareStatement(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property WHERE property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC |
| 22 | Creole | applyLimit(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property WHERE property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC, offset: 0, limit: 12 |
| 23 | Creole | executeQuery(): [3.21 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 ORDER BY property.CREATED_AT DESC LIMIT 12 |
| 24 | Creole | prepareStatement(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property WHERE property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC |
| 25 | Creole | applyLimit(): SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property WHERE property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC, offset: 0, limit: 12 |
| 26 | Creole | executeQuery(): [0.36 ms] SELECT property.ID, property.TITLE, property.SEOTITLE, property.TAGS, property.DESCRIPTION, property.COUNTRY_CODE, property.PRICE, property.EMAIL, property.CREATED_AT, property.UPDATED_AT, property.ACTIVE, property.EXTERNAL_PROPERTY_ID, property.EXTERNAL_SITE_ID, property.FEATURED FROM property WHERE property.ACTIVE IS NULL ORDER BY property.CREATED_AT DESC LIMIT 12 |
| 27 | Creole | prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE=? |
| 28 | Creole | executeQuery(): [0.85 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='CRI' |
| 29 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 30 | Creole | executeQuery(): [0.97 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=822 |
| 31 | View | initialize view for "property/_property_bread" |
| 32 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 33 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 34 | Creole | executeQuery(): [0.63 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=822 |
| 35 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 36 | Creole | executeQuery(): [0.86 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=822 |
| 37 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 38 | Creole | executeQuery(): [0.81 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=822 |
| 39 | View | initialize view for "property/_property_picture" |
| 40 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 41 | Creole | prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=? |
| 42 | Creole | executeQuery(): [0.56 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=822 |
| 43 | Creole | prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE=? |
| 44 | Creole | executeQuery(): [0.69 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' |
| 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.54 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=821 |
| 47 | View | initialize view for "property/_property_bread" |
| 48 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 49 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 50 | Creole | executeQuery(): [0.47 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=821 |
| 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.62 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' 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.79 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=821 |
| 55 | View | initialize view for "property/_property_picture" |
| 56 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 57 | Creole | prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=? |
| 58 | Creole | executeQuery(): [0.83 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 |
| 59 | Creole | prepareStatement(): SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE=? |
| 60 | Creole | executeQuery(): [0.26 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' |
| 61 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 62 | Creole | executeQuery(): [0.94 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=820 |
| 63 | View | initialize view for "property/_property_bread" |
| 64 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 65 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 66 | Creole | executeQuery(): [0.53 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=820 |
| 67 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 68 | Creole | executeQuery(): [0.62 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=820 |
| 69 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 70 | Creole | executeQuery(): [0.51 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=820 |
| 71 | View | initialize view for "property/_property_picture" |
| 72 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 73 | Creole | prepareStatement(): SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=? AND picture.PROPERTY_ID=? |
| 74 | Creole | executeQuery(): [0.52 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=820 |
| 75 | 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=? |
| 76 | 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='USA' |
| 77 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 78 | 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=819 |
| 79 | View | initialize view for "property/_property_bread" |
| 80 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 81 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 82 | Creole | executeQuery(): [0.22 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=819 |
| 83 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 84 | Creole | executeQuery(): [0.16 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=819 |
| 85 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 86 | 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=819 |
| 87 | View | initialize view for "property/_property_picture" |
| 88 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 89 | 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=? |
| 90 | Creole | executeQuery(): [0.81 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=819 |
| 91 | 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=? |
| 92 | Creole | executeQuery(): [0.28 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='PAN' |
| 93 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 94 | Creole | executeQuery(): [0.52 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=818 |
| 95 | View | initialize view for "property/_property_bread" |
| 96 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 97 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 98 | 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=818 |
| 99 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 100 | Creole | executeQuery(): [0.23 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=818 |
| 101 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 102 | Creole | executeQuery(): [0.90 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=818 |
| 103 | View | initialize view for "property/_property_picture" |
| 104 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 105 | 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=? |
| 106 | Creole | executeQuery(): [0.68 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=818 |
| 107 | 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=? |
| 108 | Creole | executeQuery(): [0.27 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='PAN' |
| 109 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 110 | Creole | executeQuery(): [0.45 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=817 |
| 111 | View | initialize view for "property/_property_bread" |
| 112 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 113 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 114 | Creole | executeQuery(): [0.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=817 |
| 115 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 116 | Creole | executeQuery(): [0.55 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=817 |
| 117 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 118 | 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=817 |
| 119 | View | initialize view for "property/_property_picture" |
| 120 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 121 | 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=? |
| 122 | Creole | executeQuery(): [0.62 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=817 |
| 123 | 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=? |
| 124 | Creole | executeQuery(): [1.08 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE='COL' |
| 125 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 126 | Creole | executeQuery(): [0.73 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=816 |
| 127 | View | initialize view for "property/_property_bread" |
| 128 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 129 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 130 | Creole | executeQuery(): [0.81 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=816 |
| 131 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 132 | Creole | executeQuery(): [0.66 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=816 |
| 133 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 134 | Creole | executeQuery(): [0.46 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=816 |
| 135 | View | initialize view for "property/_property_picture" |
| 136 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 137 | 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=? |
| 138 | Creole | executeQuery(): [0.43 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=816 |
| 139 | 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=? |
| 140 | Creole | executeQuery(): [0.34 ms] SELECT country.CODE, country.NAME, country.CONTINENT, country.REGION, country.SURFACEAREA, country.INDEPYEAR, country.POPULATION, country.LIFEEXPECTANCY, country.GNP, country.GNPOLD, country.LOCALNAME, country.GOVERNMENTFORM, country.HEADOFSTATE, country.CAPITAL, country.CODE2, country.SORDER FROM country WHERE country.CODE='PAN' |
| 141 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 142 | Creole | executeQuery(): [0.26 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=815 |
| 143 | View | initialize view for "property/_property_bread" |
| 144 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 145 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 146 | 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=815 |
| 147 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 148 | Creole | executeQuery(): [0.26 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=815 |
| 149 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 150 | Creole | executeQuery(): [0.67 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=815 |
| 151 | View | initialize view for "property/_property_picture" |
| 152 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 153 | 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=? |
| 154 | Creole | executeQuery(): [0.63 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=815 |
| 155 | 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=? |
| 156 | Creole | executeQuery(): [0.26 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='BGR' |
| 157 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 158 | Creole | executeQuery(): [0.41 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=814 |
| 159 | View | initialize view for "property/_property_bread" |
| 160 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 161 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 162 | 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=814 |
| 163 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 164 | Creole | executeQuery(): [0.44 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=814 |
| 165 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 166 | Creole | executeQuery(): [0.56 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=814 |
| 167 | View | initialize view for "property/_property_picture" |
| 168 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 169 | 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=? |
| 170 | Creole | executeQuery(): [0.47 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=814 |
| 171 | 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=? |
| 172 | Creole | executeQuery(): [0.24 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='BGR' |
| 173 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 174 | Creole | executeQuery(): [1.02 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='Currency' AND detail.PROPERTY_ID=813 |
| 175 | View | initialize view for "property/_property_bread" |
| 176 | View | render "sf_app_dir/modules/property/templates/_property_bread.php" |
| 177 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 178 | Creole | executeQuery(): [0.81 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyType' AND detail.PROPERTY_ID=813 |
| 179 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 180 | Creole | executeQuery(): [0.47 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='ListingType' AND detail.PROPERTY_ID=813 |
| 181 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
| 182 | Creole | executeQuery(): [0.48 ms] SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME='PropertyCategory' AND detail.PROPERTY_ID=813 |
| 183 | View | initialize view for "property/_property_picture" |
| 184 | View | render "sf_app_dir/modules/property/templates/_property_picture.php" |
| 185 | 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=? |
| 186 | Creole | executeQuery(): [0.55 ms] SELECT picture.ID, picture.PROPERTY_ID, picture.FILENAME, picture.THUMB, picture.DESCRIPTION, picture.SEOTITLE, picture.TAGS, picture.FEATURED, picture.CREATED_AT, picture.UPDATED_AT FROM picture WHERE picture.FEATURED=1 AND picture.PROPERTY_ID=813 |
| 187 | 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=? |
| 188 | Creole | executeQuery(): [0.28 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='BGR' |
| 189 | Creole | prepareStatement(): SELECT detail.ID, detail.PROPERTY_ID, detail.DGROUP, detail.NAME, detail.VALUE FROM detail WHERE detail.NAME=? AND detail.PROPERTY_ID=? |
|