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`.`id` = '16' LIMIT 1Connection name: default Speed: 3.161 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/model.php, line 660File: APPPATH/classes/controller/frontend/house.php, line 42File: COREPATH/classes/request.php, line 483File: DOCROOT/index.php, line 81 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`house_id` AS `t0_c1`, `t0`.`img_id` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`title` AS `t0_c4`, `t0`.`body` AS `t0_c5`, `t0`.`created_at` AS `t0_c6`, `t0`.`updated_at` AS `t0_c7`, `t1`.`id` AS `t1_c0`, `t1`.`path` AS `t1_c1`, `t1`.`name` AS `t1_c2`, `t1`.`ext` AS `t1_c3`, `t1`.`created_at` AS `t1_c4`, `t1`.`updated_at` AS `t1_c5` FROM `house_texts` AS `t0` LEFT JOIN `imgs` AS `t1` ON (`t0`.`img_id` = `t1`.`id`) WHERE `t0`.`house_id` = '16' ORDER BY `t0`.`id` ASCConnection name: default Speed: 3.012 ms Query analysis: · Query: SIMPLE on t0 · Key Used: PRIMARY · Type: index · Rows: 69 (Using where) · Query: SIMPLE on t1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/model/house.php, line 510File: APPPATH/classes/view/frontend/house/show.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`.`house_id` AS `t0_c1`, `t0`.`img_id` AS `t0_c2`, `t0`.`type` AS `t0_c3`, `t0`.`title` AS `t0_c4`, `t0`.`body` AS `t0_c5`, `t0`.`created_at` AS `t0_c6`, `t0`.`updated_at` AS `t0_c7`, `t1`.`id` AS `t1_c0`, `t1`.`path` AS `t1_c1`, `t1`.`name` AS `t1_c2`, `t1`.`ext` AS `t1_c3`, `t1`.`created_at` AS `t1_c4`, `t1`.`updated_at` AS `t1_c5` FROM `house_texts` AS `t0` LEFT JOIN `imgs` AS `t1` ON (`t0`.`img_id` = `t1`.`id`) WHERE `t0`.`house_id` = '16' ORDER BY `t0`.`id` ASCConnection name: default Speed: 0.646 ms · DUPLICATE Query analysis: · Query: SIMPLE on t0 · Key Used: PRIMARY · Type: index · Rows: 69 (Using where) · Query: SIMPLE on t1 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 Call trace for this query:File: PKGPATH/orm/classes/query.php, line 1564File: APPPATH/classes/model/house.php, line 510File: APPPATH/views/frontend/house/show.php, line 32File: 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`.`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 RAND() ASC LIMIT 3Connection name: default Speed: 1.675 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 292File: APPPATH/views/frontend/home/pickup.php, line 6File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: APPPATH/views/frontend/house/show.php, line 178File: 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` = '83' LIMIT 1Connection name: default Speed: 3.268 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/home/pickup.php, line 18File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: APPPATH/views/frontend/house/show.php, line 178File: 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.926 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/home/pickup.php, line 18File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: APPPATH/views/frontend/house/show.php, line 178File: 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` = '69' LIMIT 1Connection name: default Speed: 0.466 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/home/pickup.php, line 18File: COREPATH/classes/view.php, line 258File: COREPATH/classes/view.php, line 274File: COREPATH/classes/view.php, line 680File: COREPATH/classes/view.php, line 227File: APPPATH/views/frontend/house/show.php, line 178File: 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 |