SELECT `r`.`id`, `b`.`building_name`, `r`.`room_name`, DATE_FORMAT(r.created_at, '%Y/%m/%d') AS created_at FROM `buildings` AS `b` INNER JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id` AND `r`.`use_flg` IN (0, 1, 3, 4)) INNER JOIN `mst_user` AS `owner` ON (`owner`.`id` = `b`.`owner_id` AND `owner`.`del_flg` = 0) INNER JOIN `mst_user` AS `agent` ON (`agent`.`id` = `b`.`agent_id` AND `agent`.`del_flg` = 0 AND `agent`.`agent_approval` = 2) WHERE `b`.`use_flg` = 0Speed: 21.084 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg · Key Used: use_flg · Type: ref · Rows: 495 (Using where) · Query: SIMPLE on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where) Call trace for this query:File: APPPATH/modules/client/classes/controller/list.php, line 76File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT `r`.`id`, `b`.`building_name`, `r`.`room_name`, DATE_FORMAT(r.created_at, '%Y/%m/%d') AS created_at FROM `buildings` AS `b` INNER JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id` AND `r`.`use_flg` IN (0, 1, 3, 4)) INNER JOIN `mst_user` AS `owner` ON (`owner`.`id` = `b`.`owner_id` AND `owner`.`del_flg` = 0) INNER JOIN `mst_user` AS `agent` ON (`agent`.`id` = `b`.`agent_id` AND `agent`.`del_flg` = 0 AND `agent`.`agent_approval` = 2) WHERE `b`.`use_flg` = 0 AND `b`.`type` = '1' ORDER BY `r`.`updated_at` DESC LIMIT 500 OFFSET 0Speed: 10.408 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,type · Key Used: use_flg,type · Type: index_merge · Rows: 183 (Using intersect(use_flg,type); Using where; Using temporary; Using filesort) · Query: SIMPLE on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where) Call trace for this query:File: APPPATH/modules/client/classes/controller/list.php, line 120File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT COUNT(*) AS `total_rows` FROM (SELECT `r`.`id`, `b`.`building_name`, `r`.`room_name`, DATE_FORMAT(r.created_at, '%Y/%m/%d') AS created_at FROM `buildings` AS `b` INNER JOIN `rooms` AS `r` ON (`r`.`building_id` = `b`.`id` AND `r`.`use_flg` IN (0, 1, 3, 4)) INNER JOIN `mst_user` AS `owner` ON (`owner`.`id` = `b`.`owner_id` AND `owner`.`del_flg` = 0) INNER JOIN `mst_user` AS `agent` ON (`agent`.`id` = `b`.`agent_id` AND `agent`.`del_flg` = 0 AND `agent`.`agent_approval` = 2) WHERE `b`.`use_flg` = 0 AND `b`.`type` = '1' ORDER BY `r`.`updated_at` DESC) AS `counted_results`Speed: 9.133 ms Query analysis: · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,agent_id,use_flg,type · Key Used: use_flg,type · Type: index_merge · Rows: 183 (Using intersect(use_flg,type); Using where) · Query: SIMPLE on agent · Possible keys: PRIMARY,del_flg,agent_approval · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: eq_ref · Rows: 1 (Using where) · Query: SIMPLE on r · Possible keys: building_id,use_flg · Key Used: building_id · Type: ref · Rows: 2 (Using where) Call trace for this query:File: COREPATH/classes/db.php, line 334File: APPPATH/modules/client/classes/controller/list.php, line 122File: COREPATH/classes/controller.php, line 66File: COREPATH/classes/request.php, line 428File: DOCROOT/index.php, line 139 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29564Speed: 2.348 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29562Speed: 2.466 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29515Speed: 9.654 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29144Speed: 22.521 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29140Speed: 2.412 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29139Speed: 3.871 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29138Speed: 8.429 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29137Speed: 2.492 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29136Speed: 13.128 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29131Speed: 3.756 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29130Speed: 2.479 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29129Speed: 13.067 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29128Speed: 12.997 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29122Speed: 2.454 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29362Speed: 2.437 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29361Speed: 13.199 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=29344Speed: 2.477 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=27008Speed: 2.551 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=27009Speed: 2.421 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=27057Speed: 5.521 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=27010Speed: 5.142 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28621Speed: 2.639 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28620Speed: 7.638 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28619Speed: 13.957 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28618Speed: 4.196 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28616Speed: 6.465 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=28613Speed: 9.817 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=20993Speed: 2.209 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |
SELECT b.id,b.pref_id,ar.area_cd FROM buildings AS b INNER JOIN rooms AS r ON r.building_id=b.id INNER JOIN mst_user AS owner ON owner.id=b.owner_id AND owner.del_flg=0 LEFT JOIN mst_zip AS ar ON ar.zip=b.zip_code WHERE b.use_flg = 0 AND r.id=24020Speed: 2.596 ms Query analysis: · Query: SIMPLE on r · Possible keys: PRIMARY,building_id · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on b · Possible keys: PRIMARY,owner_id,use_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on owner · Possible keys: PRIMARY,del_flg · Key Used: PRIMARY · Type: const · Rows: 1 · Query: SIMPLE on ar · Possible keys: zip · Key Used: zip · Type: ref · Rows: 1 (Using where) Call trace for this query:File: APPPATH/classes/core/view.php, line 349File: APPPATH/modules/client/views/2017_pc/list/_roomtype.php, line 6File: COREPATH/classes/view.php, line 240File: COREPATH/classes/view.php, line 254File: COREPATH/classes/view.php, line 565File: COREPATH/base.php, line 194File: APPPATH/modules/client/views/2017_pc/list/index.php, line 27File: 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 |