SPORTS CLUB NAS 銀座店のダンスインストラクター・講師紹介｜ダンススクール・ダンス教室の口コミ検索ネット

住所	東京都中央区銀座2-4-18 ALBORE　GINZA 10F-11F
スクール	SPORTS CLUB NAS 銀座店
HP	http://nas-club.co.jp/ginza/
TEL	03-6228-6611

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key4283dfe46c1f74bf16b78c17884625adf73f3783
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  4283dfe46c1f74bf16b78c17884625adf73f37831713859383
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool
- actionstaff
- named(empty)
- pass(empty)
- schoolId3015251
- _Token(array)
  key4283dfe46c1f74bf16b78c17884625adf73f3783
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0schoolId
- options(array)
  schoolId[0-9]+
- defaults(array)
  controllerschool
  actionstaff
  plugin(null)
- template/detail/L_:schoolId/staff
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 71 queries / 0.075017 sec

No.

time

query

0.001827

connect

0.000827

DESCRIBE `school`

0.000447

SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3015251') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

0.001067

DESCRIBE `schoolgroup`

0.000427

SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '158') AND (sg.registration_status = 1) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sg	const	PRIMARY	PRIMARY	4	const	1

0.000457

SELECT COUNT(*) AS `cnt` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.schoolgroup_id = '158') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	ix_schoolgroup_id_school	ix_schoolgroup_id_school	5	const	8	Using where

0.000597

DESCRIBE `school_score`

0.000377

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3015251') AND (s_s.is_latest = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	1	Using where

0.000637

DESCRIBE `access_log_school`

0.000477

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '18.117.107.90') AND (school_id = '3015251') AND (timestamp_created >= '2024-04-22 16:33:03') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_school	ref	school_id,ix_ip_address_access_log_school	ix_ip_address_access_log_school	767	const	4	Using where

0.000517

DESCRIBE `access_count_school`

0.000387

SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3015251') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	acs	ref	school_id	school_id	4	const	1

0.008067

UPDATE `access_count_school` SET `count` = ?, `timestamp_modified` = ? WHERE (`access_count_school`.`id` = 567)

0.000387

SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 567) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_count_school	const	PRIMARY	PRIMARY	4	const	1

0.000957

INSERT INTO `access_log_school` (`school_id`, `ip_address`, `timestamp_created`, `timestamp_modified`) VALUES (?, ?, ?, ?)

0.000417

SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 12077392) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_school	const	PRIMARY	PRIMARY	4	const	1

0.000727

DESCRIBE `school_station`

0.000757

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015251') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	15

0.000477

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '1271')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	station_id	station_id	4	const	8

0.001027

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3015250', '3014423', '3015251', '3015569', '3015619', '3015620', '3015674', '3015834')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	PRIMARY	PRIMARY	4		8	Using where

0.000937

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '752') AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	city_id	city_id	5	const	44	Using where

0.000607

DESCRIBE `city`

0.003457

SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '752') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

0.000637

SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '12')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	prefecture_id	prefecture_id	5	const	59

0.014527

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	city_id				4031	Using where

0.000677

DESCRIBE `prefecture`

0.000277

SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1

0.000407

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015251') ORDER BY `distance` ASC LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	15	Using index condition; Using filesort

0.000567

DESCRIBE `station`

0.000337

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5410') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

0.000797

DESCRIBE `station_unit`

0.000437

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015251')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	15

0.000487

DESCRIBE `station_station_unit`

0.000327

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1271')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000367

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1272')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000357

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1321')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.001597

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '1761')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.001067

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5334')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000327

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5335')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000387

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5336')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.001247

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5337')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.003757

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5371')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000817

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5372')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000337

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5373')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.001387

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5397')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000357

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5410')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.003847

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '5411')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.003437

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6789')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000557

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.id IN ('1', '1', '1'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	range	PRIMARY	PRIMARY	4		1	Using where

0.000627

DESCRIBE `summary_count_school`

0.000427

SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 0) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	ref	multi	multi	28	const,const,const,const,const,const,const	1

0.000727

DESCRIBE `staff_school`

0.000377

SELECT `s`.* FROM `staff_school` AS `s` WHERE (s.school_id = '3015251') AND (s.valid = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	school_id	school_id	4	const	1	Using where

0.000637

DESCRIBE `category_school`

0.000467

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015251') AND (c_s.valid = 1) LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	school_id	school_id	4	const	1	Using where

0.000337

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015251') AND (c_s.valid = 1) LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	school_id	school_id	4	const	1	Using where

0.000317

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015251') AND (c_s.valid = 1) LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	school_id	school_id	4	const	1	Using where

0.000327

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015251') AND (c_s.valid = 1) LIMIT 6

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	school_id	school_id	4	const	1	Using where

0.000367

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015251') ORDER BY `time` ASC, `distance` ASC LIMIT 3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	15	Using index condition; Using filesort

0.000357

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5410') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

0.000307

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '1321') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

0.000307

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5337') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY	PRIMARY	4	const	1

0.000537

DESCRIBE `dancer`

0.000507

SELECT `c`.`id` FROM `dancer` AS `c` INNER JOIN `dancer_column` AS `d_c` ON c.id = d_c.dancer_id AND d_c.valid = 1 ORDER BY `d_c`.`timestamp_created` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d_c	ALL	ix_dancer_id_dancer_column				29	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	jobikai_dance.d_c.dancer_id	1	Using index

0.000367

SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY	PRIMARY	4		5	Using where

0.000507

DESCRIBE `dancer_column`

0.000397

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.001287

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000377

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000407

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000377

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	1	Using index condition; Using where; Using filesort

====

Timer

Memory

Peak Memory Use 7.02 MB

Message	Memory use
Component initialization	2.13 MB
Controller action start	4.28 MB
Controller render start	4.80 MB
View render complete	5.84 MB

Timers

Total Request Time: 223 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	7.97
Event: Controller.initialize	88.72
Event: Controller.startup	0.42
Controller action	0.15
Event: Controller.beforeRender	25.42
» Processing toolbar data	18.38
Rendering View	28.28
» Event: View.beforeRender	0.67
» Rendering APP/View/School/staff.ctp	2.84
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.10
» » Rendering APP/View/Elements/school/access.ctp	0.29
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	23.69
» » Rendering APP/View/Elements/header.ctp	0.37
» » Rendering APP/View/Elements/school/detailHeader.ctp	9.97
» » » Rendering APP/View/Elements/common/bookmark_school.ctp	0.12
» » » Rendering APP/View/Elements/breadcrumb.ctp	0.25
» » Rendering APP/View/Elements/menu.ctp	10.37
» » » Rendering APP/View/Elements/school/right-menu.ctp	10.12
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.09
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.09
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	8.96
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp	0.11
» » » » Rendering APP/View/Elements/adsense/300_250.ctp	0.09
» » Rendering APP/View/Elements/rtt.ctp	0.16
» » Rendering APP/View/Elements/footer.ctp	1.01
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.10
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- breadcrumb(array)
  0(array)
  nameスクール検索
  link(array)
  controllerschool_list
  actionindex
  1(array)
  name東京
  link(array)
  controllerschool_list
  actionindex
  prefectureId12
  2(array)
  name中央区
  link(array)
  controllerschool_list
  actionindex
  prefectureId12
  cityId752
  3(array)
  name銀座・有楽町・新橋
  link(array)
  controllerschool_list
  actionindex
  prefectureId12
  stationUnitId1
  4(array)
  name銀座一丁目駅
  link(array)
  controllerschool_list
  actionindex
  stationId5410
  5(array)
  nameSPORTS CLUB NAS 銀座店
  link
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
- SchoolCount8
- Schoolgroup(object)
  id158
  nameSPORTS CLUB NAS
  admin_member_id1810
  mail_addressyoutaro22+7@gmail.com
  telephone_number03-6447-0571
  homepage_urlhttp://www.nas-club.co.jp/
  mobile_homepage_url
  summary
  message_titleスポーツクラブのNASが提供するダンススクールです。
  message_bodyスポーツクラブをご利用されるお客様には、様々な目的があります。「ウエストのぜい肉を落としたい」「かっこいい体型になりたい」「心身ともにリラックスしたい」「腰痛を改善したい」「フルマラソンを完走したい」・・・。このようなお客様の目的を実現するよう、NASは「快適な施設」「プログラムの充実」「スタッフの細やかなコミュニケーション」を通じて、全力でサポートしていきたいと考えます。さらにNASでは「スポーツによる楽しさ」と「継続」に力を入れています。スポーツによる歓びと、夢の実現がお客様の心と身体
  registration_status1
  image_hash400de1cecefdec45
  image_extension_type2
  message_image_hashd9d4741be7a4053c
  message_image_extension_type2
  whole_staff_title(null)
  whole_staff_introduction(null)
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  score4.50
  kuchikomi_count2
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:10:05
- School(object)
  id3015251
  nameSPORTS CLUB NAS
  branch_name銀座店
  city_id752
  schoolgroup_id158
  mail_addressyoutaro22+7@gmail.com
  lat35.6742277
  lon139.7666422
  telephone_number03-6228-6611
  homepage_urlhttp://nas-club.co.jp/ginza/
  mobile_homepage_url
  blog_url
  open_hour平日11:00-23:30　土 11:00-20:00
  holiday日曜日、祝祭日
  post_code
  town_address銀座2-4-18
  buildingALBORE　GINZA 10F-11F
  image_hasha1ee88a1bdfc42f8
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title(null)
  message_body(null)
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title(null)
  whole_staff_introduction(null)
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type3
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:07:17
  memo(null)
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Number
  3SimpleGraph
  4DebugTimer
  5Toolbar
  6HtmlToolbar
====

Environment

App Constants

Notice (8): Undefined offset: 1 [CORE/Cake/View/Helper/HtmlHelper.php, line 867]Code Context
                if (is_array($cell)) {
                    $cellOptions = $cell[1];
$data = array(
	(int) 0 => array(
		(int) 0 => 'SGV_ENV',
		(int) 1 => 'development'
	),
	(int) 1 => array(
		(int) 0 => 'DEBUGKIT_ON',
		(int) 1 => true
	),
	(int) 2 => array(
		(int) 0 => 'MENTE_FLAG',
		(int) 1 => false
	),
	(int) 3 => array(
		(int) 0 => 'SGV_APP_BASE_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/'
	),
	(int) 4 => array(
		(int) 0 => 'CONFIG_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/Config/'
	),
	(int) 5 => array(
		(int) 0 => 'LIB_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/'
	),
	(int) 6 => array(
		(int) 0 => 'MODEL_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/Model/'
	),
	(int) 7 => array(
		(int) 0 => 'CLASS_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/class/'
	),
	(int) 8 => array(
		(int) 0 => 'THUMBLIB_BASE_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb'
	),
	(int) 9 => array(
		(int) 0 => 'THUMBLIB_PLUGIN_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/'
	),
	(int) 10 => array(
		(int) 0 => 'DEFAULT_THUMBLIB_IMPLEMENTATION',
		(int) 1 => 'gd'
	),
	(int) 11 => array(
		(int) 0 => 'USER_STATIC_SALT',
		(int) 1 => 'Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z'
	),
	(int) 12 => array(
		(int) 0 => 'SITE_TITLE',
		(int) 1 => 'ダンススクール・ダンス教室口コミ検索ネット'
	),
	(int) 13 => array(
		(int) 0 => 'OPERATOR_MAIL_ADDRESS',
		(int) 1 => 'info@kuchi.info'
	),
	(int) 14 => array(
		(int) 0 => 'NO_REPLY_MAIL_ADDRESS',
		(int) 1 => 'no-reply@kuchi.info'
	),
	(int) 15 => array(
		(int) 0 => 'RETURN_PATH__MAIL_ADDRESS',
		(int) 1 => 'errors@kuchi.info'
	),
	(int) 16 => array(
		(int) 0 => 'GOOGLE_API_KEY',
		(int) 1 => 'AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0'
	),
	(int) 17 => array(
		(int) 0 => 'QWINTET_IP',
		(int) 1 => array(
			(int) 0 => '122.216.11.82'
		)
	),
	(int) 18 => array(
		(int) 0 => 'ADSENSE_ID',
		(int) 1 => 'ca-pub-7408087519812416'
	),
	(int) 19 => array(
		(int) 0 => 'CLIENT_IP',
		(int) 1 => '18.117.107.90'
	)
)
$oddTrOptions = array(
	'class' => 'odd'
)
$evenTrOptions = array(
	'class' => 'even'
)
$useCount = false
$continueOddEven = false
$count = (int) 18
$line = array(
	(int) 0 => 'QWINTET_IP',
	(int) 1 => array(
		(int) 0 => '122.216.11.82'
	)
)
$cellsOut = array(
	(int) 0 => '<td>QWINTET_IP</td>'
)
$i = (int) 0
$cell = array(
	(int) 0 => '122.216.11.82'
)
$cellOptions = array()
$options = ' class="odd"'
$out = array(
	(int) 0 => '<tr class="odd"><td>SGV_ENV</td> <td>development</td></tr>',
	(int) 1 => '<tr class="even"><td>DEBUGKIT_ON</td> <td>1</td></tr>',
	(int) 2 => '<tr class="odd"><td>MENTE_FLAG</td> <td></td></tr>',
	(int) 3 => '<tr class="even"><td>SGV_APP_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/</td></tr>',
	(int) 4 => '<tr class="odd"><td>CONFIG_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Config/</td></tr>',
	(int) 5 => '<tr class="even"><td>LIB_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/</td></tr>',
	(int) 6 => '<tr class="odd"><td>MODEL_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Model/</td></tr>',
	(int) 7 => '<tr class="even"><td>CLASS_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/class/</td></tr>',
	(int) 8 => '<tr class="odd"><td>THUMBLIB_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb</td></tr>',
	(int) 9 => '<tr class="even"><td>THUMBLIB_PLUGIN_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/</td></tr>',
	(int) 10 => '<tr class="odd"><td>DEFAULT_THUMBLIB_IMPLEMENTATION</td> <td>gd</td></tr>',
	(int) 11 => '<tr class="even"><td>USER_STATIC_SALT</td> <td>Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z</td></tr>',
	(int) 12 => '<tr class="odd"><td>SITE_TITLE</td> <td>ダンススクール・ダンス教室口コミ検索ネット</td></tr>',
	(int) 13 => '<tr class="even"><td>OPERATOR_MAIL_ADDRESS</td> <td>info@kuchi.info</td></tr>',
	(int) 14 => '<tr class="odd"><td>NO_REPLY_MAIL_ADDRESS</td> <td>no-reply@kuchi.info</td></tr>',
	(int) 15 => '<tr class="even"><td>RETURN_PATH__MAIL_ADDRESS</td> <td>errors@kuchi.info</td></tr>',
	(int) 16 => '<tr class="odd"><td>GOOGLE_API_KEY</td> <td>AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0</td></tr>'
)
HtmlHelper::tableCells() - CORE/Cake/View/Helper/HtmlHelper.php, line 867
HtmlToolbarHelper::table() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 160
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 125
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108
ToolbarHelper::table() - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
include - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
include - ROOT/plugins/DebugKit/View/Elements/debug_toolbar.ctp, line 45
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
HtmlToolbarHelper::send() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 193
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 119
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108

Constant	Value
SGV_ENV	development
DEBUGKIT_ON	1
MENTE_FLAG
SGV_APP_BASE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/
CONFIG_DIR	/home/jobikai/dance-schoolgv.net/cakephp/Config/
LIB_DIR	/home/jobikai/dance-schoolgv.net/cakephp/lib/
MODEL_DIR	/home/jobikai/dance-schoolgv.net/cakephp/Model/
CLASS_DIR	/home/jobikai/dance-schoolgv.net/cakephp/class/
THUMBLIB_BASE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb
THUMBLIB_PLUGIN_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/
DEFAULT_THUMBLIB_IMPLEMENTATION	gd
USER_STATIC_SALT	Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z
SITE_TITLE	ダンススクール・ダンス教室口コミ検索ネット
OPERATOR_MAIL_ADDRESS	info@kuchi.info
NO_REPLY_MAIL_ADDRESS	no-reply@kuchi.info
RETURN_PATH__MAIL_ADDRESS	errors@kuchi.info
GOOGLE_API_KEY	AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0
QWINTET_IP	122.216.11.82
ADSENSE_ID	ca-pub-7408087519812416
CLIENT_IP	18.117.107.90

CakePHP Constants

Constant	Value
APP	/home/jobikai/dance-schoolgv.net/cakephp/app/
APP_DIR	app
APPLIBS	/home/jobikai/dance-schoolgv.net/cakephp/app/Lib/
CACHE	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/cache/
CAKE	/home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib
CORE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/
CAKE_VERSION	2.3.1
CSS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.dance-schoolgv.net
IMAGES	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/img/
IMAGES_URL	img/
JS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/js/
JS_URL	js/
LOGS	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/logs/
ROOT	/home/jobikai/dance-schoolgv.net/cakephp
TESTS	/home/jobikai/dance-schoolgv.net/cakephp/app/Test/
TMP	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/
VENDORS	/home/jobikai/dance-schoolgv.net/cakephp/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Pwd	/home/userfastcgi/jobikai/dance-schoolgv.net
Shlvl	0
Script Name	/index.php
Request Uri	/detail/L_3015251/staff
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/detail/L_3015251/staff
Remote Port	46304
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	18.117.107.90
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	18.117.107.90
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	www.dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	18.117.107.90
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZidkL5ze_tUFG1f9bc6AoQAAADE
Mef Proxy Addr	183.90.231.12
Redirect Status	200
Redirect Ngx Cache Staticmode	1
Redirect Ngx Cache Normalfile	1
Redirect Failurecachetime	0
Redirect Https	on
Redirect Unique Id	ZidkL5ze_tUFG1f9bc6AoQAAADE
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713857583.1116
Request Time	1713857583

====

Include
+
Included Files

Include Paths
- 0/home/jobikai/dance-schoolgv.net/cakephp/lib/ZendFramework/library/
- 1/home/jobikai/dance-schoolgv.net/vendor/phpunit/dbunit
- 6/home/jobikai/dance-schoolgv.net/vendor/symfony/yaml
- 3/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-code-coverage
- 4/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-token-stream
- 5/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit
- 7/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-mock-objects
- 8/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-selenium
- 9/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-story
- 10/home/jobikai/dance-schoolgv.net/cakephp/lib
- 12/opt/php-5.6.40-3/data/pear
- 13-> /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SecurityComponent.php
  1CORE/Controller/Component/SessionComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/SchoolController.php
  1APP/Controller/AppController.php
  Other(array)
  0APP/webroot/index.php
  1APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
  2APP/class/Sgv/Front/AttachableToDataSet/City.php
  3APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
  4APP/class/Sgv/Front/AttachableToDataSet/Station.php
  5APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
  6APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
  7APP/class/Sgv/Front/SearchState/SchoolList.php
  8APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
  9APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
  10APP/class/Sgv/Front/SearchCondition/SchoolList.php
  11APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
  12APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
  13APP/class/Sgv/Front/InputForm/SchoolSearch.php
  14APP/class/Sgv/Front/InputItem/SchoolSearch.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
====

SPORTS CLUB NAS 銀座店のダンスインストラクター・講師紹介