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: 14.080 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` = 2 ORDER BY `r`.`updated_at` DESC LIMIT 500 OFFSET 0Speed: 12.690 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: 233 (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` = 2 ORDER BY `r`.`updated_at` DESC) AS `counted_results`Speed: 9.901 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: 233 (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=29114Speed: 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 index condition) 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=29322Speed: 2.460 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 index condition) 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=29254Speed: 2.504 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 index condition) 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=29012Speed: 2.445 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 index condition) 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=29153Speed: 2.491 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 index condition) 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=29095Speed: 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 index condition) 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=29041Speed: 2.499 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 index condition) 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=29061Speed: 2.480 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 index condition) 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=29048Speed: 2.495 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 index condition) 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=29034Speed: 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 index condition) 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=29025Speed: 2.441 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 index condition) 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=29027Speed: 2.434 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 index condition) 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=29026Speed: 2.484 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 index condition) 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=28960Speed: 2.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 index condition) 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=28961Speed: 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 index condition) 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=28962Speed: 2.394 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 index condition) 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=28963Speed: 2.335 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 index condition) 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=28964Speed: 2.319 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 index condition) 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=29001Speed: 2.426 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 index condition) 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=5636Speed: 2.593 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 index condition) 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=26264Speed: 2.478 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 index condition) 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=26493Speed: 2.383 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 index condition) 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=26488Speed: 2.668 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 index condition) 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=26452Speed: 2.417 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 index condition) 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=26570Speed: 2.372 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 index condition) 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=26569Speed: 2.289 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 index condition) 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=26505Speed: 8.364 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 index condition) 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=26504Speed: 2.491 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 index condition) 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=26503Speed: 2.860 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 index condition) 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=26502Speed: 2.442 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 index condition) 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=26501Speed: 2.323 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 index condition) 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=26500Speed: 2.268 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 index condition) 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=26499Speed: 2.301 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 index condition) 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=26496Speed: 2.603 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 index condition) 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=26409Speed: 2.386 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 index condition) 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=13087Speed: 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 index condition) 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=28166Speed: 2.625 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 index condition) 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=27737Speed: 2.460 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 index condition) 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=17922Speed: 2.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 index condition) 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=27736Speed: 2.458 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 index condition) 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=26866Speed: 2.441 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 index condition) 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=2822Speed: 2.496 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 index condition) 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 |