ハワイアン・フラダンス・ナニフラスタジオのダンスインストラクター・講師紹介

住所	〒1540015 東京都世田谷区桜新町2-1-14 栗原ビル
スクール	ハワイアン・フラダンス・ナニフラスタジオ
HP	http://www.nani-hula-studio.com/
TEL	03-5477-8439

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key3b80cead8217b3b598832128151d6d86a5a74a27
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  fa70e486dc7189d9c01ba5e9713b51f1158c3c4c1715943582
  cede449fda27e2693ad3553009fabc25e10811d81715943584
  7efe44d0c27ab695ae1745a159b0dad4b9b08b0b1715943585
  44efca48b0d06acffbc1ee66794f28721b30d50e1715943586
  e28e61c8eed0a1e5246f2e36f401cbbb57bbb58a1715943587
  73ff2efd7e4050363efbd17a31305616a42437f71715943588
  e58f097dc6d4294901e671c85a09df3f0a5cab511715943589
  91fed83cf16832727dfd04ba7780cff8d63621591715943590
  15447a78e923feab7ebef08d683faf986f9092071715943590
  9397348194745c91c1e2de10ddab8033cd86b35f1715943591
  7c51cafe4f9a2de5a0f20e41da9f4d0eaee6687b1715943592
  441ef37984ace81d7be5d9d5e844f4647837aed11715943593
  581b84a798ea2ed2b22e66bf8a6c3f383b6cf19e1715943593
  5e323fce08aeab7285b2e6312f29db2eaac6606f1715943594
  765759961dfad61f39b68eed2b32d64387d753fc1715943595
  4b27b39b3218725a41abfadff9ccdaf5adbf50ea1715943595
  fa1f274ca12a8315cc6c0430d246603025d0d2451715943596
  d702b2d7514902212ce5127d9241c6be9ab717181715943597
  2b7af87140f09446911e716cc020b2e43691943d1715943598
  25ddf526ddd28f75ee43838dbd8609ff560967351715943598
  09f2960889e325a13261bddade8b45d60d2ced751715943599
  23325c3dfcff65b55b120d80184842b348d0a8841715943602
  f7dac82cb8b3ed87d9b7c889d7c57442d33952ca1715943603
  881599a02a37e5e84554ed8af70d6382dc5fb2e81715943604
  759c1508751006335864b95a2b3fb9c0e8ca282b1715943605
  d86ef11f20ac3b36bb3766aade33515b6c2ec2d31715943605
  75630ebafd18ff995da2c4417303e6e5291f9ef21715943606
  145e2dcbd9fc56444a53072a4af90e0a9a26beb11715943607
  ee2214eaa23dda97daaf632f4cb76ae5ce12aa251715943608
  f4016615da96bf31ba9d6c50b3772a4ddc324e531715943609
  69a726ce44d30b567b780d494caaf255b5c00ed91715943610
  20873d09a724685b2f7976f850e98be96f465fb71715943611
  384851eb978d29bf360640c3e4bb6f427298496b1715943612
  44aca358beaf9849d4dde65f9e75312c8af02f541715943613
  fbf52773c1cb041f3dcc0bd355fb97a704f44d9b1715943614
  f062a170c5151916d086cdd6d0ba45cf89f42b851715943614
  9da05a014e688f5816508dab9054a3a4c77288971715943616
  11713946cab2a33b321ec15fcff84f5446f8c1d91715943616
  5c376fbbf3194c17698f94160e64c8d7994aec101715943617
  4f28e9b6b69aae87baad5c98db3b2455930f9ae01715943618
  686c43812dea05455fd338a70d0b19dbaa79b49c1715943619
  4bb1896d99f4e61283bd72a739b3d2eab58a842d1715943619
  1715f11abeb149606b9d709c142db920716c1c981715943620
  c322e3ef85ba44adb07fb680bb64a2ebc86418961715943621
  afaba019e6d4b3dfa84fb2b2bbcfe39adc5201f41715943622
  bbf91a869033686e4624c70903d46f5b9df7a1b81715943623
  371efa0701e6f8769ec4c5aa12bb3780c058db7f1715943624
  b29c809efac15233cfbcc4816bd989c7d68e6e361715943624
  a0960739ac20ed77050cc9743c0af383ac7f95561715943625
  ab6fcd44eae2ede3ece6df35eef9b2435a2accc01715943625
  07b8f6d0cf78eb45b23ec33c64bb25fac06c250b1715943626
  db194dd0b99c4c4c645a427f6e31fafe1e0ef6e91715943627
  2f3055a420a941b3c650b60450b6a95bef9ef3de1715943628
  dfb24c12644ebcfd7ead53dff535a73ac0c9fe9a1715943628
  b28d6be377915e342c849fdad50524bd67c642561715943629
  61bd6ee4861f4f7262872d35d89a78d6f7206d2b1715943630
  df5b77c1ff5aae581414d0fd6f8ef5c0c82d6a061715943630
  e8d754d4ced36b20862f9c3d7d59706540f775f91715943631
  933e5b5f82f9557daa0804bfb81db39b1f46c6b71715943632
  5470bd30866d412accdcef0ad5c38f500ee94b671715943633
  0c91ff4c516b19415c4699c5f4e6875c576b2e211715943633
  07f3e364348ec1314cc5e5527dc2aca17df65c981715943634
  9e10323da45a6614f4692fc54e77cbc6e21ecca01715943635
  e440219408568353d626fa65f2c991723724b13e1715943635
  f4d3456773f585689308659b84120810822a3ee91715943636
  63fb754ae98d93b7b9b9176b7c2ee6113cd39e651715943637
  893b8a4b5c37ec987db3d05de1712412ad7c50621715943637
  db24b757431d7a04ecdaa8e9881d3f28668736f01715943639
  1b9a253c42c048d5a8434dda39352d4f957823551715943640
  77bf21bf5b60c56a9f32c752aaa7feade4f58d191715943640
  8e29a5e014e38eded58c96e85bbc0a77ed59205c1715943641
  af8d1718c726dcb87dcc08a8f9cc16856dcb56001715943642
  d7d4fdaa10f8433eb41180a26a42c472510429891715943643
  379c95310f0e2f033cbe93681a985546cdb732451715943644
  06195bd408e9d65023627bf5a5c736a212691d431715943644
  789e746c41299bac89217516fe9fb2bef16a102d1715943645
  28e4e7efdcb9004c9034af754ab4fd09cfeba7561715943646
  0fc325c7c46d1eda1d25b5baf70e9e12e4097f7d1715943646
  c558570e260759b9a3a03fb417ea86ccc21cce381715943647
  f5f4540542cfc541e3f8001a980cfe8578c347d81715943648
  4f5ebb37fa8e68bc72a08b6357ed1aaa1336a4411715943649
  cb6c20dfc360cb11cd42c794c66f4123ab541bef1715943649
  27159e1475bdd3dbdcdf651df084cbf4487099a41715943650
  34ea308a1c0deb64427c4201f2e88cfcbb7b90531715943651
  a908d657f148e56cd02aa963bb1d285605568b131715943651
  cc345f6b686c59110b491c455923a64b83858e281715943652
  ec8af147040b8a32d86ec9632049ab35a82789cc1715943652
  6791e7d6a115655f2ac93c965a381a52fd326dc01715943653
  9df24b304db4fb92e80fb17a020258e0e1f0dee21715943653
  f066f6cd101ff59f47db71552b1b18059c78ce611715943653
  89cb61c25b69bab19e85cda741bd595786e28a211715943653
  bf168d3449b31f8e6a68379e089e5737dca87d181715943654
  50e6af9ad68d53f16f1e938593aec615c97697a91715943654
  076574483ffce97ac3a4cb248b669641c45f015d1715943654
  8ed68a2aec30b97dd3ba9e14713580dfc38c0ec91715943655
  7cddee3dc291ab4c3f182e92fbc4140fdd4d5ddc1715943655
  85d8cae53a8ec38e58e079926c399f2a7adcbee51715943655
  f0eb069c60f3be5537f5f2b84b07a53acb4ee60a1715943655
  68086470eb1cc52e2259b5da5ae24dd5e7e585cb1715943656
  3b80cead8217b3b598832128151d6d86a5a74a271715943656
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool
- actionstaff
- named(empty)
- pass(empty)
- schoolId3013435
- _Token(array)
  key3b80cead8217b3b598832128151d6d86a5a74a27
  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: 56 queries / 0.040957 sec

No.

time

query

0.001707

connect

0.000687

DESCRIBE `school`

0.000407

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

DESCRIBE `school_score`

0.000337

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

DESCRIBE `access_log_school`

0.001317

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.145.203.15') AND (school_id = '3013435') AND (timestamp_created >= '2024-05-16 19:30:56') 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.000407

DESCRIBE `access_count_school`

0.000337

SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3013435') 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.004217

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

0.000337

SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 1551) 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.001077

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

0.000327

SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 12185798) 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.000447

DESCRIBE `school_station`

0.000317

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

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

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

0.000447

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3013435', '3013436', '3014989', '3015111', '3015461', '3015633')) 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		6	Using where

0.001077

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

0.000447

DESCRIBE `city`

0.000297

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

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

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

DESCRIBE `prefecture`

0.000327

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

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

DESCRIBE `station`

0.000327

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5206') 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.000447

DESCRIBE `station_unit`

0.000347

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

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

DESCRIBE `station_station_unit`

0.000317

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

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

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

DESCRIBE `major_city`

0.000437

DESCRIBE `city_major_city`

0.000327

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

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (false)

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

0.000507

DESCRIBE `summary_count_school`

0.000447

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

DESCRIBE `staff_school`

0.000367

SELECT `s`.* FROM `staff_school` AS `s` WHERE (s.school_id = '3013435') 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.000527

DESCRIBE `category_school`

0.000367

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3013435') 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.000467

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3013435') 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 = '3013435') 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.000357

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3013435') 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 = '3013435') 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.000347

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5206') 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.000457

DESCRIBE `dancer`

0.000457

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

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

DESCRIBE `dancer_column`

0.000357

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

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

Message	Memory use
Component initialization	2.15 MB
Controller action start	4.03 MB
Controller render start	4.39 MB
View render complete	5.38 MB

Timers

Total Request Time: 108 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	5.73
Event: Controller.initialize	45.68
Event: Controller.startup	0.35
Controller action	0.12
Event: Controller.beforeRender	14.91
» Processing toolbar data	8.95
Rendering View	21.20
» Event: View.beforeRender	0.62
» Rendering APP/View/School/staff.ctp	2.31
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.07
» » Rendering APP/View/Elements/school/access.ctp	0.24
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	17.49
» » Rendering APP/View/Elements/header.ctp	0.34
» » Rendering APP/View/Elements/school/detailHeader.ctp	7.54
» » » Rendering APP/View/Elements/common/bookmark_school.ctp	0.10
» » » Rendering APP/View/Elements/breadcrumb.ctp	0.19
» » Rendering APP/View/Elements/menu.ctp	7.38
» » » Rendering APP/View/Elements/school/right-menu.ctp	7.23
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.06
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.07
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	6.45
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp	0.06
» » » » Rendering APP/View/Elements/adsense/300_250.ctp	0.05
» » Rendering APP/View/Elements/rtt.ctp	0.10
» » Rendering APP/View/Elements/footer.ctp	0.80
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.05
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
  cityId748
  3(array)
  name桜新町駅
  link(array)
  controllerschool_list
  actionindex
  stationId5206
  4(array)
  nameハワイアン・フラダンス・ナニフラスタジオ
  link
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
- School(object)
  id3013435
  nameハワイアン・フラダンス・ナニフラスタジオ
  branch_name(null)
  city_id748
  schoolgroup_id(null)
  mail_address
  lat35.632216000000
  lon139.645626000000
  telephone_number03-5477-8439
  homepage_urlhttp://www.nani-hula-studio.com/
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code1540015
  town_address桜新町2-1-14
  building栗原ビル
  image_hash(null)
  image_extension_type(null)
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title
  message_body
  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_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:05:20
  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.145.203.15'
	)
)
$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.145.203.15

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_3013435/staff
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/detail/L_3013435/staff
Remote Port	41794
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.145.203.15
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http Cookie	PHPSESSID=d1uq35644ihqmsrr5pt37q0unpa306m2
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.145.203.15
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.145.203.15
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	Zkcx4CME6BeDfPVeKXZ1qQAAAMI
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	Zkcx4CME6BeDfPVeKXZ1qQAAAMI
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1715941856.4933
Request Time	1715941856

====

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/InputForm/Auth/Login.php
  6APP/class/Sgv/Front/InputItem/Auth/Login.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
====

ハワイアン・フラダンス・ナニフラスタジオのダンスインストラクター・講師紹介