札幌ダンススクールリアンのコース・レッスン料金｜ダンススクール・ダンス教室の口コミ検索ネット

住所	〒063-0811 北海道札幌市西区琴似１条５丁目４－１８
スクール	札幌ダンススクールリアン
HP	https://hokkaidolian.biz/
携帯HP	https://hokkaidolian.biz/
ブログ	https://hokkaidolian.biz/category/sapporo-dance-school/
TEL	050-3126-2728

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key61fc6160d16ae3ef04875ebf2be51129e9859689
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  35e6156d1dc63997282791c6835c5f8c27e24d9b1715933119
  60cbe2669e9e529ced2b974b2220286b673c93f31715933119
  17a192012f7b722c7f03833c4a86184eb1d836c31715933119
  353cf572935a3f46ae71292acf1385afd4e512301715933120
  1c09f560ed8de6b25ebf7eb398ebe9e327181aaa1715933120
  4c5eb4c5708d05c103ab2e920a00b91f64e9d7ab1715933120
  7d11189a2aa6b77d46df7409f2c0fc15a8bafe3a1715933120
  128b12ac3795e09b7ef74f89f2ee12f1c15d0ae51715933121
  3d17b4e211d069f50db349cb259d43cbece70cbf1715933121
  b72dc5a68621fc95e5d2249513ecb4bd66f440521715933121
  1047d1af418c535f2e255e226955b9ae237707281715933121
  4a090d04410363266f94d7903dbbd67e39776f101715933122
  0f7f9fd451ace2bc627a1d25c5f8eb1ccc9ec7b11715933122
  d75143dae3e1a2f8911535d5f2ebb5d8bf1db2db1715933122
  ddd1aec898865863e979b5159030b8a7a92930c31715933123
  b18859de9283a2ab00e822db46b12866f3a072851715933123
  ca793326e347a02aacd21b58aca153620d0a71ee1715933123
  d25ae6aabf97d05e4e204031e07467e7df5314521715933123
  6f4a0382c94cd77180e7d4951ecae037315964511715933124
  c3a8f8f92afc3dbc522a60b7225590b23069fa871715933124
  960cb4ac065c34c989697a49aa626c2405ee7d491715933124
  1f0cfd9afa93acb29936e6c9824e7b753f44fd941715933125
  331689131b0aeaddb9f153f27e33ab4153b275321715933125
  7946ca8c97585da6c661e354b3d47a93b4a1b4c31715933125
  e2f20fe66a145ddd861f5361c1fbdd8cb9a17e001715933126
  9d1715b5e64ec1540792feebaf3c21283699c0fe1715933126
  91b61b5a3bb4316236efe10e17b96111269f5c6a1715933127
  334634762a493040e295cc11f30c3166786b4f7d1715933127
  e537469d3e977f1b87008df857818f0318b627bb1715933127
  3b07f64f1bf2d8064cf03b2f0cf90df3b4dda6451715933128
  f914b1cc791025b13ee0487f82d0e2aedbebe10b1715933128
  989aa552122e56cc41b761ce7cc4a2481a455e7c1715933128
  d86efad581ae03d3b7b1409f644197ab832232371715933129
  71f4337ca8355b2d93cc5fafaa6ef2d4942f82821715933129
  910c24374a64ff051556af93409f5b99c2c1fde21715933129
  e8e9f0b2d9f8cb38a2911176838b07c945da59d71715933129
  4313e105319b46b6d2170b0d2228d1f4d50ead121715933130
  ad1c345f655a9dd27e7e60a9afd6299af80f21db1715933130
  bed48c8dc6d06e69130c8c139bba6a5fff35be091715933130
  9808c2a00f7abe6a839c5ac0582ccdc35cb174fa1715933131
  c837b3b5cb07ad2597bdcff272bd055ad74aadbd1715933132
  53d59672083030393299267eb01844fcf19525881715933133
  63b382d0e2463ba07fe4cb09a7a25e495390bbef1715933134
  e0127bb9f27da3f08671720b8cf713a2dd7091fe1715933135
  7708d5950f7c7dc6fec969ffb4155c34ad6b98c21715933136
  4e0565a6c4a1b42faa0581dd330d6c12316a671a1715933137
  8b5cdd65380725fb58310a96678c5c832cf305981715933138
  d2430c23ac592fc0af2823178cb4123810622d0a1715933139
  a5b67b85d558e6444d278b2dec55e3c846dfd5b41715933139
  28d5c5b118a3f94720ce3579790672d9ff60fe5b1715933140
  f24379f846d82646b3df234077cd9893954b989b1715933141
  860dba42775e090730858389162c1f114cb6cd171715933142
  27ec4e40b3a6213c9c59b75fed12381ee4581a331715933143
  6eb387a465c3d947f95877edb066eae94ed0e8e81715933144
  c05179bef9fdf8fb2e931be081040e3441a2545b1715933145
  190a7a690bb294465a9a7c467d4814c80a1a0e5b1715933145
  21c347ad7d3777a0a42a9ae84103490f5d34f4e41715933146
  d55d01019fae2ec0d01f48c43633b6dab48d28291715933147
  baef949565923d254ec0a7e4dd6e9f40a886d9321715933148
  a89b59c95244e2c957e5230d825d40f3c80d0bd51715933149
  58481d2e10620fb429040f4162740d3f8eb5d0711715933150
  7440005a3914a31a0407118e8c7459e03423b4081715933152
  f5fe242e638039baea8a7fc8fa78be13e7026bd61715933152
  d55a8c41c211ab0f04e540c1062c6ff52ada77831715933153
  6e168b64b881a39c64200776b0c6f13e8229e1941715933153
  0aabde8d1aae78c9029b63c7b58a01c493e122491715933155
  a9d57480f7e8d69953e7bb3fd8ccd40d764ddd2c1715933156
  ee3fe7990b39ae7e62ac204eb87117559d87ed1c1715933157
  07126cb41905aba7b9225dea26bd2f78b021f0871715933158
  8ff17af57110211d3b2a9e7b578715a720cf87291715933159
  63691a9109ecae9da1894013fe76c6344fc3a0f21715933160
  92599b390f8c4efabcb37704cf3468db4832e0b31715933161
  18a5ae2ce0f7d4f5005aaaa50a13d136411c631e1715933162
  f151df1489fd0289f0b1ad87dcdd80165471c0781715933163
  586dd0d99f220930f4823ecd6b3f35c378b694d51715933164
  b858c4b8e293aff4bd68a90820d953cb8f3885851715933165
  094b23cb244a73b771df83fad04e683b011c8d7d1715933166
  9284a49ed22355fe4760211fdb15faaf3fd625c81715933166
  e884a57925fb8409274ffabdbaaf565b9c1ba2941715933167
  cd83e7158beeebb6d01893f2bf29b2f9ac03ccd21715933168
  671cb2bdcf177faa7585a242a379a7d5f34d9d801715933168
  c5f41dd2ec8b68beb8c502481e1d0ebfef0ebefe1715933169
  576d33fc1a8838d134fc8faf25b3eb1847012ca41715933170
  dc097386b9859f7d6b4b2ce1025d5154380868841715933171
  9873469d12ccae4c45f9c559dd9a1f4c1e6ca21a1715933172
  471702b5894940a0defdcdf1e4b023a591b4dded1715933173
  a9a5d154916fa2380ef5b8f0f4fee22ab14464461715933174
  2af96a445091909bf37bd2b68a6aaddd0e844fd01715933174
  9023dd4db2c8b11af18f37d6b1d9900bdc55e60e1715933175
  f8e2cdf0f4c765121f3abdce44afb3eb33fcafda1715933175
  c317a554f4b032932857c931bcaa1c53dd20c35b1715933176
  b1676656f5b45f22a504343ea12d39d4313704851715933177
  88ad73e7d8d48c0acf9f2fbec54075c08bec08d01715933178
  1c992c2565326cf73b9ec10c7ef1d13f51a0d0f41715933178
  cd19e6766a199decc9cd9de1cb8bd9a08671b9f71715933180
  5a193bbd2bb793bc8e13ad518d116006dcd72e661715933181
  595eccb7f909f08a3fde10f45d31bcd76c6c67141715933181
  40858d972d8f2d57ebbc5ecb3e2a8369cb59367b1715933182
  8331f271432353c9a68ad7386ffaadd844d533bd1715933183
  fe9ef1967af9d9dac6efbf48d9751603835ed3d61715933184
  61fc6160d16ae3ef04875ebf2be51129e98596891715933185
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool
- actionservice
- named(empty)
- pass(empty)
- schoolId3016447
- _Token(array)
  key61fc6160d16ae3ef04875ebf2be51129e9859689
  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
  actionservice
  plugin(null)
- template/detail/L_:schoolId/service
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 48 queries / 0.023727 sec

No.

time

query

0.001567

connect

0.000707

DESCRIBE `school`

0.000437

SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3016447') 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.000587

DESCRIBE `school_score`

0.000397

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016447') 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.000527

DESCRIBE `access_log_school`

0.000637

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.135.198.7') AND (school_id = '3016447') AND (timestamp_created >= '2024-05-16 16:36:25') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_school	index_merge	school_id,ix_ip_address_access_log_school	ix_ip_address_access_log_school,school_id	767,4		1	Using intersect(ix_ip_address_access_log_school,school_id); Using where

0.000497

DESCRIBE `school_station`

0.000367

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016447') 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	1

0.000737

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '94') 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	7	Using where

0.000477

DESCRIBE `city`

0.000337

SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '94') 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.000677

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

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

0.001547

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1', '2', '3', '4', '5', '7', '9', '13', '14', '23', '25', '26', '27', '29', '30', '32', '33', '34', '40', '44', '45', '46', '47', '48', '49', '52', '56', '59', '62', '76', '78', '80', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '101', '102', '104', '105', '106', '107', '110', '111', '112', '114', '115', '116', '117', '125', '126', '127', '128', '132', '133', '139', '140', '143', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '164', '165', '166', '167', '169', '170', '171', '172', '174', '175', '176', '177', '178', '185', '186', '187', '190', '191', '197', '200', '202', '203', '204', '205')) 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	city_id	city_id	5		143	Using index condition; Using where

0.000547

DESCRIBE `prefecture`

0.000347

SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '1') 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 = '3016447') 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	1	Using index condition; Using filesort

0.000507

DESCRIBE `station_unit`

0.000347

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

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

0.000287

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000477

DESCRIBE `major_city`

0.000467

DESCRIBE `city_major_city`

0.000347

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '94')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_m_c	ref	city_id	city_id	4	const	1

0.000327

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000667

DESCRIBE `summary_count_school`

0.000417

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.000857

DESCRIBE `category_school`

0.000687

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

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

0.000637

DESCRIBE `menu_school`

0.000417

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8035') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	1	Using index condition; Using where; Using filesort

0.000377

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8036') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	1	Using index condition; Using where; Using filesort

0.000377

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8037') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	1	Using index condition; Using where; Using filesort

0.000357

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8038') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	1	Using index condition; Using where; Using filesort

0.000347

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '8039') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	1	Using index condition; Using where; Using filesort

0.000417

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016447') 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	5	Using where

0.000347

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016447') 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	5	Using where

0.000347

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016447') 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	5	Using where

0.000387

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016447') 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	5	Using where

0.000357

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016447') 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	1	Using index condition; Using filesort

0.000467

DESCRIBE `dancer`

0.000417

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.000437

DESCRIBE `dancer_column`

0.000367

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.000367

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.000347

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.000347

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.000327

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.24 MB

Message	Memory use
Component initialization	2.16 MB
Controller action start	3.87 MB
Controller render start	4.14 MB
View render complete	5.16 MB

Timers

Total Request Time: 207 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.41
Event: Controller.initialize	26.19
Event: Controller.startup	0.39
Controller action	0.12
Event: Controller.beforeRender	27.74
» Processing toolbar data	20.55
Rendering View	125.00
» Event: View.beforeRender	96.61
» Rendering APP/View/School/service.ctp	8.94
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.09
» » Rendering APP/View/Elements/school/menu-school.ctp	0.15
» » Rendering APP/View/Elements/school/menu-school.ctp #2	0.19
» » Rendering APP/View/Elements/adsense/336_288.ctp #2	0.05
» » Rendering APP/View/Elements/school/access.ctp	0.28
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	18.40
» » Rendering APP/View/Elements/header.ctp	0.38
» » Rendering APP/View/Elements/school/detailHeader.ctp	6.64
» » » Rendering APP/View/Elements/common/bookmark_school.ctp	0.10
» » » Rendering APP/View/Elements/breadcrumb.ctp	0.23
» » Rendering APP/View/Elements/menu.ctp	8.65
» » » Rendering APP/View/Elements/school/right-menu.ctp	8.47
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.06
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.05
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	7.48
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp	0.11
» » » » Rendering APP/View/Elements/adsense/300_250.ctp	0.06
» » Rendering APP/View/Elements/rtt.ctp	0.10
» » Rendering APP/View/Elements/footer.ctp	1.06
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.06
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
  prefectureId1
  2(array)
  name札幌
  link(array)
  controllerschool_list
  actionindex
  prefectureId1
  majorCityId9
  3(array)
  name札幌市西区
  link(array)
  controllerschool_list
  actionindex
  prefectureId1
  cityId94
  4(array)
  name札幌ダンススクールリアン
  link
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
- School(object)
  id3016447
  name札幌ダンススクールリアン
  branch_name
  city_id94
  schoolgroup_id(null)
  mail_addresssapporolian@gmail.com
  lat(null)
  lon(null)
  telephone_number050-3126-2728
  homepage_urlhttps://hokkaidolian.biz/
  mobile_homepage_urlhttps://hokkaidolian.biz/
  blog_urlhttps://hokkaidolian.biz/category/sapporo-dance-school/
  open_hour
  holiday
  post_code063-0811
  town_address琴似１条５丁目４－１８
  building
  image_hash0143bdfba7f4f9f6
  image_extension_type3
  message_image_hashc89e2df4b44d4f34
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title札幌・大通・琴似・宮の沢の初心限定ダンススクールです！
  message_body札幌、大通、すすきの、琴似、宮の沢で初心者が安心して通えるダンススクールをお探しではありませんか？札幌ダンススクールリアンは【ダンス初心者限定】です！ ★K-POP ★ヒップホップ ★アイドルコピーダンス ★ジャズダンス ★ガールズヒップホップ ★テーマパークダンスが習えますよ！札幌市内に複数のスタジオがあるので通いやすいスタジオをお選び頂けます。徹底した少人数制、初心者に特化したレッスンであなたのダンスデビューを全力でサポート致します！アットホームなダンスレッスンでダンスを趣味にしてみませんか？
  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_receiving0
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2024-04-02 12:06:53
  timestamp_modified2024-04-02 12:14:37
  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 => '3.135.198.7'
	)
)
$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	3.135.198.7

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://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_3016447/service
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/detail/L_3016447/service
Remote Port	53304
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	3.135.198.7
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http Cookie	PHPSESSID=vhvfan69b9rsa2li8i2ao3gdeo6657ep
Http Referer	http://dance-schoolgv.net/detail/L_3016447/service
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	3.135.198.7
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	3.135.198.7
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZkcI-Wyj3EPYKztQh30cfAAAARA
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	ZkcI-Wyj3EPYKztQh30cfAAAARA
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1715931385.3213
Request Time	1715931385

====

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
  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
  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
- 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
====

札幌ダンススクールリアンのコース・レッスン料金