SELECT `t0`.`id` AS `t0_c0`, `t0`.`type` AS `t0_c1`, `t0`.`business_type` AS `t0_c2`, `t0`.`img_id` AS `t0_c3`, `t0`.`owner_img_id` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`caption` AS `t0_c6`, `t0`.`body` AS `t0_c7`, `t0`.`owner_title` AS `t0_c8`, `t0`.`owner_body` AS `t0_c9`, `t0`.`owner_name` AS `t0_c10`, `t0`.`owner_degree` AS `t0_c11`, `t0`.`address` AS `t0_c12`, `t0`.`station` AS `t0_c13`, `t0`.`price` AS `t0_c14`, `t0`.`yield` AS `t0_c15`, `t0`.`income` AS `t0_c16`, `t0`.`structure` AS `t0_c17`, `t0`.`floor` AS `t0_c18`, `t0`.`build_year` AS `t0_c19`, `t0`.`area` AS `t0_c20`, `t0`.`floor_plan` AS `t0_c21`, `t0`.`number_of_house` AS `t0_c22`, `t0`.`car_parking` AS `t0_c23`, `t0`.`land_area` AS `t0_c24`, `t0`.`land_rights` AS `t0_c25`, `t0`.`land_category` AS `t0_c26`, `t0`.`city_planning_area` AS `t0_c27`, `t0`.`use_district` AS `t0_c28`, `t0`.`building_coverage` AS `t0_c29`, `t0`.`volume_ratio` AS `t0_c30`, `t0`.`land_law_notification` AS `t0_c31`, `t0`.`contact_road_situation` AS `t0_c32`, `t0`.`status_quo` AS `t0_c33`, `t0`.`delivery` AS `t0_c34`, `t0`.`update_date` AS `t0_c35`, `t0`.`date_of_renovation` AS `t0_c36`, `t0`.`control_number` AS `t0_c37`, `t0`.`notes` AS `t0_c38`, `t0`.`transaction_form` AS `t0_c39`, `t0`.`lat` AS `t0_c40`, `t0`.`lng` AS `t0_c41`, `t0`.`company_name` AS `t0_c42`, `t0`.`company_address` AS `t0_c43`, `t0`.`company_contactname` AS `t0_c44`, `t0`.`house_body` AS `t0_c45`, `t0`.`rent_guarantee` AS `t0_c46`, `t0`.`read_string` AS `t0_c47`, `t0`.`delete_flag` AS `t0_c48`, `t0`.`created_at` AS `t0_c49`, `t0`.`updated_at` AS `t0_c50`, `t0`.`small_category_id` AS `t0_c51`, `t0`.`status` AS `t0_c52`, `t0`.`intro` AS `t0_c53` FROM `houses` AS `t0` WHERE `t0`.`type` = 'rent' AND `t0`.`delete_flag` = '0' GROUP BY `t0`.`business_type`Connection name: default Speed: 4.000 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 28 (Using where; Using temporary; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/model/house.php, line 310File: APPPATH/classes/view/frontend/house/index.php, line 12File: COREPATH/classes/presenter.php, line 332File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`type` AS `t0_c1`, `t0`.`business_type` AS `t0_c2`, `t0`.`img_id` AS `t0_c3`, `t0`.`owner_img_id` AS `t0_c4`, `t0`.`name` AS `t0_c5`, `t0`.`caption` AS `t0_c6`, `t0`.`body` AS `t0_c7`, `t0`.`owner_title` AS `t0_c8`, `t0`.`owner_body` AS `t0_c9`, `t0`.`owner_name` AS `t0_c10`, `t0`.`owner_degree` AS `t0_c11`, `t0`.`address` AS `t0_c12`, `t0`.`station` AS `t0_c13`, `t0`.`price` AS `t0_c14`, `t0`.`yield` AS `t0_c15`, `t0`.`income` AS `t0_c16`, `t0`.`structure` AS `t0_c17`, `t0`.`floor` AS `t0_c18`, `t0`.`build_year` AS `t0_c19`, `t0`.`area` AS `t0_c20`, `t0`.`floor_plan` AS `t0_c21`, `t0`.`number_of_house` AS `t0_c22`, `t0`.`car_parking` AS `t0_c23`, `t0`.`land_area` AS `t0_c24`, `t0`.`land_rights` AS `t0_c25`, `t0`.`land_category` AS `t0_c26`, `t0`.`city_planning_area` AS `t0_c27`, `t0`.`use_district` AS `t0_c28`, `t0`.`building_coverage` AS `t0_c29`, `t0`.`volume_ratio` AS `t0_c30`, `t0`.`land_law_notification` AS `t0_c31`, `t0`.`contact_road_situation` AS `t0_c32`, `t0`.`status_quo` AS `t0_c33`, `t0`.`delivery` AS `t0_c34`, `t0`.`update_date` AS `t0_c35`, `t0`.`date_of_renovation` AS `t0_c36`, `t0`.`control_number` AS `t0_c37`, `t0`.`notes` AS `t0_c38`, `t0`.`transaction_form` AS `t0_c39`, `t0`.`lat` AS `t0_c40`, `t0`.`lng` AS `t0_c41`, `t0`.`company_name` AS `t0_c42`, `t0`.`company_address` AS `t0_c43`, `t0`.`company_contactname` AS `t0_c44`, `t0`.`house_body` AS `t0_c45`, `t0`.`rent_guarantee` AS `t0_c46`, `t0`.`read_string` AS `t0_c47`, `t0`.`delete_flag` AS `t0_c48`, `t0`.`created_at` AS `t0_c49`, `t0`.`updated_at` AS `t0_c50`, `t0`.`small_category_id` AS `t0_c51`, `t0`.`status` AS `t0_c52`, `t0`.`intro` AS `t0_c53` FROM `houses` AS `t0` WHERE `t0`.`delete_flag` = '0' AND `t0`.`type` = 'rent' ORDER BY `t0`.`created_at` DESC LIMIT 3Connection name: default Speed: 0.688 ms Query analysis: · Query: SIMPLE on t0 · Type: ALL · Rows: 28 (Using where; Using filesort) Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/model/house.php, line 338File: APPPATH/classes/view/frontend/house/index.php, line 13File: COREPATH/classes/presenter.php, line 332File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '69' LIMIT 1Connection name: default Speed: 1.812 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '21' LIMIT 1Connection name: default Speed: 0.422 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '23' LIMIT 1Connection name: default Speed: 0.381 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '32' LIMIT 1Connection name: default Speed: 0.371 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '31' LIMIT 1Connection name: default Speed: 0.398 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '48' LIMIT 1Connection name: default Speed: 0.411 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 44File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '138' LIMIT 1Connection name: default Speed: 0.850 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 68File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`path` AS `t0_c1`, `t0`.`name` AS `t0_c2`, `t0`.`ext` AS `t0_c3`, `t0`.`created_at` AS `t0_c4`, `t0`.`updated_at` AS `t0_c5` FROM `imgs` AS `t0` WHERE `t0`.`id` = '135' LIMIT 1Connection name: default Speed: 0.391 ms Query analysis: · Query: SIMPLE on t0 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: PKGPATH/orm/classes/query.php, line 1641File: PKGPATH/orm/classes/belongsto.php, line 66File: PKGPATH/orm/classes/model.php, line 1214File: PKGPATH/orm/classes/model.php, line 1050File: APPPATH/classes/model/house.php, line 208File: APPPATH/views/frontend/house/index.php, line 68File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/presenter.php, line 335File: COREPATH/classes/presenter.php, line 352File: APPPATH/views/frontend/common/layout.php, line 12File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: COREPATH/classes/response.php, line 382File: COREPATH/classes/response.php, line 362File: DOCROOT/index.php, line 148 |