SELECT `t0`.`id` AS `t0_c0`, `t0`.`ukey` AS `t0_c1`, `t0`.`user_kbn` AS `t0_c2`, `t0`.`login_id` AS `t0_c3`, `t0`.`password` AS `t0_c4`, `t0`.`user_name_kj` AS `t0_c5`, `t0`.`user_name_kn` AS `t0_c6`, `t0`.`face_image` AS `t0_c7`, `t0`.`birthday` AS `t0_c8`, `t0`.`sex` AS `t0_c9`, `t0`.`zip_code` AS `t0_c10`, `t0`.`pref_id` AS `t0_c11`, `t0`.`address` AS `t0_c12`, `t0`.`address2` AS `t0_c13`, `t0`.`tel_no` AS `t0_c14`, `t0`.`mobile_no` AS `t0_c15`, `t0`.`fax_no` AS `t0_c16`, `t0`.`email` AS `t0_c17`, `t0`.`email2` AS `t0_c18`, `t0`.`devotion_years` AS `t0_c19`, `t0`.`takken_no` AS `t0_c20`, `t0`.`takken_no_kbn` AS `t0_c21`, `t0`.`company_name` AS `t0_c22`, `t0`.`company_kana` AS `t0_c23`, `t0`.`trade_name` AS `t0_c24`, `t0`.`corporation_email` AS `t0_c25`, `t0`.`corporation_zip_code` AS `t0_c26`, `t0`.`corporation_address` AS `t0_c27`, `t0`.`corporation_tel` AS `t0_c28`, `t0`.`corporation_fax` AS `t0_c29`, `t0`.`corporation_representative_name` AS `t0_c30`, `t0`.`takken_license_no` AS `t0_c31`, `t0`.`takken_license_no_num` AS `t0_c32`, `t0`.`takken_license_kbn` AS `t0_c33`, `t0`.`takken_license_get_date` AS `t0_c34`, `t0`.`takken_license_valid_from_date` AS `t0_c35`, `t0`.`takken_license_valid_to_date` AS `t0_c36`, `t0`.`activity_area` AS `t0_c37`, `t0`.`pr_memo` AS `t0_c38`, `t0`.`ent_family` AS `t0_c39`, `t0`.`ent_hobby` AS `t0_c40`, `t0`.`ent_hometown` AS `t0_c41`, `t0`.`cognition_id` AS `t0_c42`, `t0`.`cognition_memo` AS `t0_c43`, `t0`.`afukey` AS `t0_c44`, `t0`.`route` AS `t0_c45`, `t0`.`route2` AS `t0_c46`, `t0`.`is_face` AS `t0_c47`, `t0`.`is_manage` AS `t0_c48`, `t0`.`building_last_open_date` AS `t0_c49`, `t0`.`building_checked_at` AS `t0_c50`, `t0`.`admin_user_id` AS `t0_c51`, `t0`.`owner_agree_fee` AS `t0_c52`, `t0`.`owner_agree_fee_date` AS `t0_c53`, `t0`.`leave_ques` AS `t0_c54`, `t0`.`leave_note` AS `t0_c55`, `t0`.`owner_is_rental` AS `t0_c56`, `t0`.`owner_is_sale` AS `t0_c57`, `t0`.`owner_is_buy` AS `t0_c58`, `t0`.`owner_agree_201511` AS `t0_c59`, `t0`.`bill_type` AS `t0_c60`, `t0`.`bill_email` AS `t0_c61`, `t0`.`bill_label` AS `t0_c62`, `t0`.`bill_name` AS `t0_c63`, `t0`.`created_at` AS `t0_c64`, `t0`.`register_at` AS `t0_c65`, `t0`.`updated_at` AS `t0_c66`, `t0`.`del_flg` AS `t0_c67`, `t0`.`uchicomitimes_flg` AS `t0_c68`, `t0`.`is_card_read_agree` AS `t0_c69`, `t0`.`card_agree_date` AS `t0_c70`, `t0`.`is_appealed` AS `t0_c71`, `t0`.`login_destination` AS `t0_c72`, `t0`.`tel_memo` AS `t0_c73`, `t0`.`login_destination_main` AS `t0_c74`, `t0`.`login_destination_sub` AS `t0_c75`, `t0`.`login_destination_other` AS `t0_c76`, `t0`.`is_introduction` AS `t0_c77`, `t0`.`introduction_name` AS `t0_c78`, `t0`.`agent_business_hours` AS `t0_c79`, `t0`.`agent_holiday` AS `t0_c80`, `t0`.`agent_access` AS `t0_c81`, `t0`.`agent_homepage` AS `t0_c82`, `t0`.`agent_approval` AS `t0_c83`, `t0`.`agent_approval_date` AS `t0_c84`, `t0`.`agent_approval_admin_id` AS `t0_c85`, `t0`.`license_kanrishi` AS `t0_c86`, `t0`.`license_shuninsya` AS `t0_c87`, `t0`.`license_mansion` AS `t0_c88`, `t0`.`evidence_kanrishi` AS `t0_c89`, `t0`.`evidence_shuninsya` AS `t0_c90`, `t0`.`evidence_mansion` AS `t0_c91`, `t0`.`license_kanrishi_valid` AS `t0_c92`, `t0`.`license_shuninsya_valid` AS `t0_c93`, `t0`.`license_mansion_valid` AS `t0_c94`, `t0`.`agent_bank_holder` AS `t0_c95`, `t0`.`agent_new_plan` AS `t0_c96`, `t0`.`agree_202101` AS `t0_c97`, `t0`.`agent_passed_year` AS `t0_c98`, `t0`.`agent_weighted` AS `t0_c99`, `t0`.`agent_not_selection` AS `t0_c100`, `t0`.`agent_managed_property` AS `t0_c101`, `t0`.`skip_message` AS `t0_c102` FROM `mst_user` AS `t0` WHERE `t0`.`id` = '41934' AND `t0`.`user_kbn` = 2 AND `t0`.`del_flg` = 0 LIMIT 1Speed: 2.439 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY,user_kbn,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/modules/client/classes/controller/ownersearch.php, line 640File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(id) AS `cnt` FROM `owner_attributes` WHERE `del_flg` = 0 AND `id` = '41934'Speed: 2.029 ms
Query analysis:
· Query: SIMPLE on owner_attributes · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/model/owner/attribute.php, line 124File: APPPATH/classes/model/owner/attribute.php, line 133File: APPPATH/modules/client/classes/controller/ownersearch.php, line 648File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`nickname` AS `t0_c1`, `t0`.`birthday` AS `t0_c2`, `t0`.`sex` AS `t0_c3`, `t0`.`history` AS `t0_c4`, `t0`.`pref` AS `t0_c5`, `t0`.`area_cd` AS `t0_c6`, `t0`.`shop` AS `t0_c7`, `t0`.`live_people_kind` AS `t0_c8`, `t0`.`ques1` AS `t0_c9`, `t0`.`ques2` AS `t0_c10`, `t0`.`ques3` AS `t0_c11`, `t0`.`ques4` AS `t0_c12`, `t0`.`ques5` AS `t0_c13`, `t0`.`ques5_note` AS `t0_c14`, `t0`.`ques6` AS `t0_c15`, `t0`.`ques6_note` AS `t0_c16`, `t0`.`ques7` AS `t0_c17`, `t0`.`ques7_note` AS `t0_c18`, `t0`.`ques8` AS `t0_c19`, `t0`.`ques8_note` AS `t0_c20`, `t0`.`ques9` AS `t0_c21`, `t0`.`ques9_note` AS `t0_c22`, `t0`.`ques10` AS `t0_c23`, `t0`.`ques10_note` AS `t0_c24`, `t0`.`ques11` AS `t0_c25`, `t0`.`ques11_note` AS `t0_c26`, `t0`.`ques12` AS `t0_c27`, `t0`.`ques12_note` AS `t0_c28`, `t0`.`ques13` AS `t0_c29`, `t0`.`ques13_note` AS `t0_c30`, `t0`.`ques14` AS `t0_c31`, `t0`.`ques14_note` AS `t0_c32`, `t0`.`ques15` AS `t0_c33`, `t0`.`ques15_note` AS `t0_c34`, `t0`.`ques16` AS `t0_c35`, `t0`.`ques16_note` AS `t0_c36`, `t0`.`ques17` AS `t0_c37`, `t0`.`ques17_note` AS `t0_c38`, `t0`.`ques18` AS `t0_c39`, `t0`.`ques18_note` AS `t0_c40`, `t0`.`ques19` AS `t0_c41`, `t0`.`ques19_note` AS `t0_c42`, `t0`.`ques20` AS `t0_c43`, `t0`.`ques20_note` AS `t0_c44`, `t0`.`ques21` AS `t0_c45`, `t0`.`ques21_note` AS `t0_c46`, `t0`.`ques22` AS `t0_c47`, `t0`.`ques22_note` AS `t0_c48`, `t0`.`ques23` AS `t0_c49`, `t0`.`ques23_note` AS `t0_c50`, `t0`.`del_flg` AS `t0_c51`, `t0`.`created_at` AS `t0_c52`, `t0`.`updated_at` AS `t0_c53` FROM `owner_attributes` AS `t0` WHERE `t0`.`id` = '41934' AND `t0`.`del_flg` = 0 LIMIT 1Speed: 2.132 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/classes/model/owner/attribute.php, line 137File: APPPATH/modules/client/classes/controller/ownersearch.php, line 648File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`pref` AS `t0_c1`, `t0`.`vehicular` AS `t0_c2`, `t0`.`sport` AS `t0_c3`, `t0`.`art` AS `t0_c4`, `t0`.`tobacco` AS `t0_c5`, `t0`.`interior` AS `t0_c6`, `t0`.`animal` AS `t0_c7`, `t0`.`wall` AS `t0_c8`, `t0`.`cook` AS `t0_c9`, `t0`.`bath` AS `t0_c10`, `t0`.`cleanup` AS `t0_c11`, `t0`.`dust` AS `t0_c12`, `t0`.`security` AS `t0_c13`, `t0`.`noise` AS `t0_c14`, `t0`.`plumbing` AS `t0_c15`, `t0`.`del_flg` AS `t0_c16`, `t0`.`created_at` AS `t0_c17`, `t0`.`updated_at` AS `t0_c18` FROM `owner_search` AS `t0` WHERE `t0`.`del_flg` = 0 AND `t0`.`id` = '41934' LIMIT 1Speed: 2.014 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/classes/core/orm/query.php, line 1252File: APPPATH/modules/client/classes/controller/ownersearch.php, line 652File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT DISTINCT b.id AS building_id FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id AND ( r.use_flg = 0 OR r.use_flg = 3 OR ( r.use_flg = 4 AND r.seiyaku_date > (NOW() - INTERVAL 72 HOUR) ) OR (r.building_id IN (SELECT DISTINCT building_id FROM wait_room WHERE del_flg=0 AND enabled=1)) ) INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN wait_room AS wr ON wr.building_id=b.id AND wr.del_flg=0 AND wr.enabled=1 WHERE b.use_flg = 0 AND b.owner_id = 41934 ORDER BY (SELECT COUNT(1) FROM rooms WHERE building_id=b.id AND (use_flg = 0 OR r.use_flg = 3 OR ( r.use_flg = 4 AND r.seiyaku_date > (NOW() - INTERVAL 72 HOUR))))=0 ASC, r.updated_at DESCSpeed: 2.745 ms
Query analysis:
· Query: PRIMARY on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort)
· Query: PRIMARY on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,zip_code,pref_id,area_cd,type,structure,ownership_type,car_parking,motorcycle_parking,bicycles_parking,lat,geohash · Key Used: owner_id · Type: ref · Rows: 2 (Using where)
· Query: PRIMARY on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where; Distinct)
· Query: PRIMARY on wr · Type: ALL · Rows: 99 (Using where; Distinct; Using join buffer (hash join))
· Query: DEPENDENT SUBQUERY on rooms · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where)
· Query: DEPENDENT SUBQUERY on wait_room · Type: ALL · Rows: 99 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/controller/ownersearch.php, line 775File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `b`.`id`, `b`.`owner_id`, `b`.`agent_id`, `b`.`use_flg`, `b`.`building_name`, `b`.`zip_code`, `b`.`pref_id`, `b`.`area_cd`, `c`.`address2` AS `address`, `b`.`address_other`, `b`.`construction_year`, `b`.`construction_month`, `b`.`floor_max`, `b`.`floor_under_max`, `b`.`type`, `b`.`structure`, `b`.`ownership_type`, `b`.`car_parking`, `b`.`car_space`, `b`.`car_price`, `b`.`motorcycle_parking`, `b`.`motorcycle_space`, `b`.`motorcycle_price`, `b`.`bicycles_parking`, `b`.`bicycles_space`, `b`.`bicycles_price`, `b`.`movie_url`, `b`.`lat`, `b`.`lng`, `b`.`initial_cost`, `b`.`created_at`, `b`.`updated_at`, `o`.`id` AS `owner_id`, `o`.`face_image` AS `owner_face_image`, `o`.`building_checked_at` AS `owner_building_checked_at`, `o`.`is_card_read_agree`, `o`.`card_agree_date`, `o`.`is_appealed`, `oa`.`nickname`, `agent`.`id` AS `agent_id`, `agent`.`del_flg` AS `agent_del_flg`, `agent`.`agent_approval` AS `agent_approval`, `wr`.`id` AS `wait_room_id`, `wr`.`lower_limit` AS `wait_room_lower_limit`, `wr`.`upper_limit` AS `wait_room_upper_limit`, `wr`.`pr_building_title` AS `wait_room_pr_building_title`, `wr`.`pr_building_comment` AS `wait_room_pr_building_comment` FROM `buildings` AS `b` LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id` AND `o`.`del_flg` = 0) LEFT JOIN `mst_user` AS `agent` ON (`b`.`agent_id` = `agent`.`id`) LEFT JOIN `mst_city` AS `c` ON (`b`.`area_cd` = `c`.`area_cd`) LEFT JOIN `owner_attributes` AS `oa` ON (`b`.`owner_id` = `oa`.`id` AND `oa`.`del_flg` = 0) LEFT JOIN `wait_room` AS `wr` ON (`b`.`id` = `wr`.`building_id` AND `wr`.`del_flg` = 0 AND `wr`.`enabled` = 1) LEFT JOIN `rooms` AS `r1` ON (`b`.`id` = `r1`.`building_id`) LEFT JOIN `rooms` AS `r2` ON (`r1`.`id` = `r2`.`id` AND `r1`.`updated_at` < `r2`.`updated_at` AND `r1`.`use_flg` IN (0,3,4)) WHERE `b`.`use_flg` = 0 AND `b`.`id` IN ('11616') ORDER BY `r1`.`updated_at` DESCSpeed: 3.785 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort)
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on c · Possible keys: mst_city_idx2 · Key Used: mst_city_idx2 · Type: ref · Rows: 1
· Query: SIMPLE on oa · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 (Using where)
· Query: SIMPLE on wr · Type: ALL · Rows: 99 (Using where; Using join buffer (hash join))
· Query: SIMPLE on r1 · Possible keys: building_id · Key Used: building_id · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on r2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 607File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT DISTINCT `ln`.`line_cd`, `ln`.`line_name`, `st`.`station_cd`, `st`.`station_g_cd`, `st`.`station_name`, `br`.`move_kbn`, `br`.`walk_time`, `br`.`bus_time`, `br`.`building_id` FROM `buildings_root` AS `br` LEFT JOIN `mst_station` AS `st` ON (`br`.`station_cd` = `st`.`station_cd`) LEFT JOIN `mst_line` AS `ln` ON (`st`.`line_cd` = `ln`.`line_cd`) WHERE `br`.`building_id` IN ('11616') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.279 ms
Query analysis:
· Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary)
· Query: SIMPLE on st · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1 (Using index condition)
· Query: SIMPLE on ln · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 642File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 1 AND `af`.`article_id` IN ('11616') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.314 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 10 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 74File: APPPATH/modules/client/classes/model/buildings.php, line 657File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 1 AND `ai`.`article_id` IN ('11616') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.296 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 7 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `id` FROM `owner_search` WHERE `del_flg` = 0 AND `id` IN ('41934')Speed: 1.981 ms
Query analysis:
· Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/model/owner/search.php, line 49File: APPPATH/modules/client/classes/model/buildings.php, line 708File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '11616' ORDER BY `room_name` ASCSpeed: 2.412 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('29429') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.387 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 17 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('29429') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.293 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('29429')Speed: 2.044 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 10
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '11616'Speed: 2.185 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 197File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `b`.`id`, `b`.`owner_id`, `b`.`agent_id`, `b`.`use_flg`, `b`.`building_name`, `b`.`zip_code`, `b`.`pref_id`, `b`.`area_cd`, `c`.`address2` AS `address`, `b`.`address_other`, `b`.`construction_year`, `b`.`construction_month`, `b`.`floor_max`, `b`.`floor_under_max`, `b`.`type`, `b`.`structure`, `b`.`ownership_type`, `b`.`car_parking`, `b`.`car_space`, `b`.`car_price`, `b`.`motorcycle_parking`, `b`.`motorcycle_space`, `b`.`motorcycle_price`, `b`.`bicycles_parking`, `b`.`bicycles_space`, `b`.`bicycles_price`, `b`.`movie_url`, `b`.`lat`, `b`.`lng`, `b`.`initial_cost`, `b`.`created_at`, `b`.`updated_at`, `o`.`id` AS `owner_id`, `o`.`face_image` AS `owner_face_image`, `o`.`building_checked_at` AS `owner_building_checked_at`, `o`.`is_card_read_agree`, `o`.`card_agree_date`, `o`.`is_appealed`, `oa`.`nickname`, `agent`.`id` AS `agent_id`, `agent`.`del_flg` AS `agent_del_flg`, `agent`.`agent_approval` AS `agent_approval`, `wr`.`id` AS `wait_room_id`, `wr`.`lower_limit` AS `wait_room_lower_limit`, `wr`.`upper_limit` AS `wait_room_upper_limit`, `wr`.`pr_building_title` AS `wait_room_pr_building_title`, `wr`.`pr_building_comment` AS `wait_room_pr_building_comment` FROM `buildings` AS `b` LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id` AND `o`.`del_flg` = 0) LEFT JOIN `mst_user` AS `agent` ON (`b`.`agent_id` = `agent`.`id`) LEFT JOIN `mst_city` AS `c` ON (`b`.`area_cd` = `c`.`area_cd`) LEFT JOIN `owner_attributes` AS `oa` ON (`b`.`owner_id` = `oa`.`id` AND `oa`.`del_flg` = 0) LEFT JOIN `wait_room` AS `wr` ON (`b`.`id` = `wr`.`building_id` AND `wr`.`del_flg` = 0 AND `wr`.`enabled` = 1) LEFT JOIN `rooms` AS `r1` ON (`b`.`id` = `r1`.`building_id`) LEFT JOIN `rooms` AS `r2` ON (`r1`.`id` = `r2`.`id` AND `r1`.`updated_at` < `r2`.`updated_at` AND `r1`.`use_flg` IN (0,3,4)) WHERE `b`.`use_flg` = 0 AND `b`.`id` IN ('11096') ORDER BY `r1`.`updated_at` DESCSpeed: 2.833 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 (Using temporary; Using filesort)
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on agent · Possible keys: PRIMARY · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on c · Possible keys: mst_city_idx2 · Key Used: mst_city_idx2 · Type: ref · Rows: 1
· Query: SIMPLE on oa · Possible keys: PRIMARY,owner_attributes_idx1 · Key Used: PRIMARY · Type: const · Rows: 1 (Using where)
· Query: SIMPLE on wr · Type: ALL · Rows: 99 (Using where; Using join buffer (hash join))
· Query: SIMPLE on r1 · Possible keys: building_id · Key Used: building_id · Type: ref · Rows: 1 (Using where)
· Query: SIMPLE on r2 · Possible keys: PRIMARY · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 607File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT DISTINCT `ln`.`line_cd`, `ln`.`line_name`, `st`.`station_cd`, `st`.`station_g_cd`, `st`.`station_name`, `br`.`move_kbn`, `br`.`walk_time`, `br`.`bus_time`, `br`.`building_id` FROM `buildings_root` AS `br` LEFT JOIN `mst_station` AS `st` ON (`br`.`station_cd` = `st`.`station_cd`) LEFT JOIN `mst_line` AS `ln` ON (`st`.`line_cd` = `ln`.`line_cd`) WHERE `br`.`building_id` IN ('11096') AND `st`.`station_cd` IS NOT null ORDER BY `br`.`id` ASCSpeed: 2.289 ms
Query analysis:
· Query: SIMPLE on br · Possible keys: building_id,station_cd · Key Used: building_id · Type: ref · Rows: 3 (Using index condition; Using temporary)
· Query: SIMPLE on st · Possible keys: station_cd · Key Used: station_cd · Type: ref · Rows: 1 (Using index condition)
· Query: SIMPLE on ln · Possible keys: line_cd · Key Used: line_cd · Type: ref · Rows: 1
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 642File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 1 AND `af`.`article_id` IN ('11096') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.269 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 9 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 74File: APPPATH/modules/client/classes/model/buildings.php, line 657File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 1 AND `ai`.`article_id` IN ('11096') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.318 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 32File: APPPATH/modules/client/classes/model/buildings.php, line 670File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `id` FROM `owner_search` WHERE `del_flg` = 0 AND `id` IN ('41934')Speed: 2.010 ms · DUPLICATE
Query analysis:
· Query: SIMPLE on owner_search · Possible keys: PRIMARY,owner_search_idx1 · Key Used: PRIMARY · Type: const · Rows: 1
Call trace for this query:File: APPPATH/classes/model/owner/search.php, line 49File: APPPATH/modules/client/classes/model/buildings.php, line 708File: APPPATH/modules/client/classes/model/buildings.php, line 187File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `r`.*, `rd`.`start_date` AS `discount_start_date`, `rd`.`finish_date` AS `discount_finish_date`, `rd`.`kind` AS `discount_kind`, `rd`.`summary` AS `discount_summary`, `rd`.`agree` AS `discount_agree`, `rd`.`agree_date` AS `discount_agree_date`, `rd`.`diy_type` AS `discount_diy_type`, `rd`.`diy_agree_date` AS `discount_diy_agree_date`, `rd`.`is_initial_installment` AS `discount_is_initial_installment`, `rd`.`is_freerent_daily` AS `discount_is_freerent_daily`, `rd`.`is_freerent_monthly` AS `discount_is_freerent_monthly`, `rd`.`freerent_month` AS `discount_freerent_month`, `rd`.`is_freerent` AS `discount_is_freerent`, `rd`.`is_internet` AS `discount_is_internet`, `rd`.`is_card` AS `discount_is_card`, `rd`.`legal_check` AS `discount_legal_check`, `rd`.`legal_check_date` AS `discount_legal_check_date`, `rd`.`legal_note` AS `discount_legal_note`, `rd`.`legal_note2` AS `discount_legal_note2` FROM `rooms` AS `r` LEFT JOIN `rooms_discount` AS `rd` ON (`rd`.`room_id` = `r`.`id` AND `rd`.`del_flg` = 0 AND `rd`.`legal_check` != 2 AND `rd`.`legal_check` != 3) WHERE (`r`.`use_flg` IN (0, 3) OR (`r`.`use_flg` = 4 AND `r`.`seiyaku_date` > (NOW() - INTERVAL 72 HOUR))) AND `r`.`building_id` = '11096' ORDER BY `room_name` ASCSpeed: 2.461 ms
Query analysis:
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where; Using filesort)
· Query: SIMPLE on rd · Possible keys: PRIMARY,del_flg,legal_check · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 353File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `af`.`id` AS `af_id`, `af`.`article_id` AS `article_id`, `afi`.`id` AS `afi_id`, `afd`.`id` AS `afd_id`, `afi`.`article_item_name`, `afi`.`is_share`, `afd`.`article_division_name`, `afd`.`article_type` FROM `article_facility` AS `af` LEFT JOIN `article_facility_item` AS `afi` ON (`af`.`article_item_id` = `afi`.`id` AND `afi`.`del_flg` = 0) LEFT JOIN `article_facility_division` AS `afd` ON (`afi`.`article_facility_division_id` = `afd`.`id` AND `afd`.`del_flg` = 0) WHERE `af`.`article_type` = 2 AND `af`.`article_id` IN ('28012') AND `af`.`del_flg` = 0 ORDER BY `afd`.`disp_rank` ASC, `afi`.`disp_rank` ASCSpeed: 2.390 ms
Query analysis:
· Query: SIMPLE on af · Possible keys: article_type,article_id,del_flg · Key Used: article_id · Type: ref · Rows: 18 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on afi · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
· Query: SIMPLE on afd · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/facility.php, line 176File: APPPATH/modules/client/classes/model/buildings.php, line 363File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `ai`.`id` AS `ai_id`, `aii`.`id` AS `aii_id`, `ai`.`article_id` AS `article_id`, `ai`.`file_path` AS `ai_file_path`, `ai`.`file_comment` AS `ai_file_comment`, `ai`.`image_width` AS `ai_image_width`, `ai`.`image_height` AS `ai_image_height`, `ai`.`mime_type` AS `ai_mime_type`, `aii`.`category` AS `aii_category`, `aii`.`item_column_name` AS `aii_item_column_name` FROM `article_image` AS `ai` LEFT JOIN `article_image_item` AS `aii` ON (`ai`.`article_image_item_id` = `aii`.`id` AND `aii`.`del_flg` = 0) WHERE `ai`.`article_type` = 2 AND `ai`.`article_id` IN ('28012') AND `ai`.`del_flg` = 0 ORDER BY `aii`.`sort_num` ASCSpeed: 2.298 ms
Query analysis:
· Query: SIMPLE on ai · Possible keys: article_type,article_id · Key Used: article_id · Type: ref · Rows: 14 (Using index condition; Using where; Using temporary; Using filesort)
· Query: SIMPLE on aii · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/article/image.php, line 88File: APPPATH/modules/client/classes/model/buildings.php, line 369File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `feature_id`, `room_id` FROM `room_feature` WHERE `room_id` IN ('28012')Speed: 2.058 ms
Query analysis:
· Query: SIMPLE on room_feature · Possible keys: room_feature_idx2 · Key Used: room_feature_idx2 · Type: ref · Rows: 9
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 396File: APPPATH/modules/client/classes/model/buildings.php, line 194File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(r.id) AS `cnt` FROM `rooms` AS `r` LEFT JOIN `buildings` AS `b` ON (`r`.`building_id` = `b`.`id`) LEFT JOIN `mst_user` AS `o` ON (`b`.`owner_id` = `o`.`id`) WHERE `b`.`use_flg` = 0 AND `o`.`del_flg` = 0 AND `r`.`use_flg` IN (0, 3) AND `r`.`building_id` = '11096'Speed: 2.202 ms
Query analysis:
· Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on o · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1
· Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 1 (Using index condition; Using where)
Call trace for this query:File: APPPATH/modules/client/classes/model/buildings.php, line 173File: APPPATH/modules/client/classes/model/buildings.php, line 197File: APPPATH/modules/client/classes/controller/ownersearch.php, line 784File: APPPATH/modules/client/classes/controller/ownersearch.php, line 653File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `t0`.`id` AS `t0_c0`, `t0`.`validity` AS `t0_c1`, `t0`.`is_hidden` AS `t0_c2`, `t0`.`name` AS `t0_c3`, `t0`.`urlkey` AS `t0_c4`, `t0`.`lead` AS `t0_c5`, `t0`.`image` AS `t0_c6`, `t0`.`image_sp` AS `t0_c7`, `t0`.`summary` AS `t0_c8`, `t0`.`is_icon` AS `t0_c9`, `t0`.`icon_text` AS `t0_c10`, `t0`.`image_head` AS `t0_c11`, `t0`.`image_head_sp` AS `t0_c12`, `t0`.`priority` AS `t0_c13`, `t0`.`del_flg` AS `t0_c14`, `t0`.`created_at` AS `t0_c15`, `t0`.`updated_at` AS `t0_c16` FROM `feature` AS `t0` WHERE `t0`.`del_flg` = 0 AND `t0`.`is_icon` = 1 ORDER BY `t0`.`priority` DESCSpeed: 2.659 ms
Query analysis:
· Query: SIMPLE on t0 · Possible keys: del_flg,is_icon · Key Used: is_icon · Type: ref · Rows: 9 (Using where; Using filesort)
Call trace for this query:File: APPPATH/classes/core/orm/query.php, line 1182File: APPPATH/modules/client/classes/controller/ownersearch.php, line 670File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `area_cd`, `address2` FROM `mst_city` WHERE `pref_cd` = '42' AND `is_target_city` = 1 GROUP BY `address2` ORDER BY `area_cd` ASC, `address2` ASCSpeed: 2.428 ms
Query analysis:
· Query: SIMPLE on mst_city · Possible keys: mst_city_idx1,is_target_city · Key Used: mst_city_idx1 · Type: ref · Rows: 21 (Using where; Using temporary; Using filesort)
Call trace for this query:File: APPPATH/classes/common/ddlist.php, line 3572File: APPPATH/classes/common/ddlist.php, line 15File: APPPATH/modules/client/views/2017_pc/ownersearch/detail.php, line 33File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/viewmodel.php, line 270File: COREPATH/classes/viewmodel.php, line 287File: APPPATH/modules/client/views/2017_pc/layout_simple.php, line 114File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/classes/view.php, line 207File: DOCROOT/index.php, line 172 |
