ALLURE dance studio ジャズダンス,その他のダンスのレッスン体験レポート｜ダンススクール・ダンス教室の口コミ検索ネット

住所	〒660-0876 兵庫県尼崎市竹谷町2-76 カンサイビル２Ｆ
スクール	ALLURE dance studio
HP	http://sjdance.net
携帯HP	http://sjdance.net
TEL	0664121223

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  keyc16db224d25780f3247457d437b1b8c90192863c
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  c16db224d25780f3247457d437b1b8c90192863c1627892684
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool
- actionkuchikomi_detail
- named(empty)
- pass(empty)
- schoolId3016167
- kuchikomiId1343
- _Token(array)
  keyc16db224d25780f3247457d437b1b8c90192863c
  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
  1kuchikomiId
- options(array)
  schoolId[0-9]+
- defaults(array)
  controllerschool
  actionkuchikomi_detail
  plugin(null)
- template/detail/L_:schoolId/review_detail/R_:kuchikomiId
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 77 queries / 0.063207 sec

No.

time

query

0.001567

connect

0.000637

DESCRIBE `school`

0.000387

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

DESCRIBE `school_score`

0.011187

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016167') 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	8826	Using where

0.000447

DESCRIBE `access_log_school`

0.000367

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '34.204.180.223') AND (school_id = '3016167') AND (timestamp_created >= '2021-08-01 16:54:44') 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	2	Using where

0.000397

DESCRIBE `access_count_school`

0.000317

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

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

0.000297

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

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

0.000287

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

DESCRIBE `school_station`

0.000307

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

0.000307

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

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

0.000357

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3016167')) 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								Impossible WHERE noticed after reading const tables

0.000487

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

0.000397

DESCRIBE `city`

0.000297

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

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

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

0.001857

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1507', '1508', '1509', '1510', '1511', '1512', '1513', '1514', '1515', '1516', '1517', '1518', '1519', '1521', '1522', '1525', '1526', '1531', '1532', '1533', '1534', '1535', '1536', '1537', '1538', '1539', '1540', '1541', '1542', '1543', '1545', '1546', '1547', '1548', '1549', '1550', '1551', '1552', '1553', '1554', '1555', '1556', '1557', '1558', '1560', '1561', '1562', '2307')) 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		334	Using index condition; Using where

0.000417

DESCRIBE `prefecture`

0.000297

SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '28') 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.000327

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

0.000407

DESCRIBE `station`

0.000287

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

DESCRIBE `station_unit`

0.000327

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

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

0.000397

DESCRIBE `station_station_unit`

0.000297

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

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

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

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

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

DESCRIBE `major_city`

0.000387

DESCRIBE `city_major_city`

0.000307

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

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

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

DESCRIBE `kuchikomi`

0.000337

SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.id = '1343') AND (k.school_id = '3016167') AND (k.valid = 1) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k	const	PRIMARY,ix_school_id_kuchikomi	PRIMARY	4	const	1

0.000427

DESCRIBE `kuchikomi_category`

0.000317

SELECT `k_c`.* FROM `kuchikomi_category` AS `k_c` WHERE (k_c.kuchikomi_id = '1343')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k_c	ref	kuchikomi_id	kuchikomi_id	4	const	2

0.000457

DESCRIBE `access_log_kuchikomi`

0.000337

SELECT `access_log_kuchikomi`.`id` FROM `access_log_kuchikomi` WHERE (ip_address = '34.204.180.223') AND (kuchikomi_id = '1343') AND (timestamp_created >= '2021-08-01 16:54:44') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_kuchikomi	ref	kuchikomi_id,ix_ip_address_access_log_kuchikomi	ix_ip_address_access_log_kuchikomi	767	const	1	Using where

0.000417

DESCRIBE `access_count_kuchikomi`

0.000317

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id = '1343') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a_c_k	ref	kuchikomi_id	kuchikomi_id	4	const	1

0.006027

UPDATE `access_count_kuchikomi` SET `count` = ?, `timestamp_modified` = ? WHERE (`access_count_kuchikomi`.`id` = 431)

0.000297

SELECT `access_count_kuchikomi`.* FROM `access_count_kuchikomi` WHERE (`access_count_kuchikomi`.`id` = 431) LIMIT 1

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

0.011087

INSERT INTO `access_log_kuchikomi` (`kuchikomi_id`, `ip_address`, `timestamp_created`, `timestamp_modified`) VALUES (?, ?, ?, ?)

0.000317

SELECT `access_log_kuchikomi`.* FROM `access_log_kuchikomi` WHERE (`access_log_kuchikomi`.`id` = 236146) LIMIT 1

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

0.000517

DESCRIBE `summary_count_school`

0.000387

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

DESCRIBE `member`

0.000347

SELECT `m`.* FROM `member` AS `m` WHERE (m.id = '3322') LIMIT 1

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

0.000317

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id = '1343') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a_c_k	ref	kuchikomi_id	kuchikomi_id	4	const	1

0.000447

DESCRIBE `kuchikomi_questionnaire_answer`

0.000337

SELECT `k_q_a`.* FROM `kuchikomi_questionnaire_answer` AS `k_q_a` WHERE (k_q_a.kuchikomi_id = '1343')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k_q_a	ref	ix_kuchikomi_id_kuchikomi_questionnaire_answer	ix_kuchikomi_id_kuchikomi_questionnaire_answer	4	const	6

0.000467

DESCRIBE `kuchikomi_comment`

0.000317

SELECT `k_c`.* FROM `kuchikomi_comment` AS `k_c` WHERE (k_c.kuchikomi_id = '1343') AND (k_c.valid = 1)

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

0.000447

DESCRIBE `kuchikomi_school_comment`

0.000307

SELECT `k_s_c`.* FROM `kuchikomi_school_comment` AS `k_s_c` WHERE (k_s_c.kuchikomi_id = '1343') AND (k_s_c.valid = 1) LIMIT 1

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

0.000477

DESCRIBE `category_school`

0.000367

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

0.000327

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

0.000317

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

0.000337

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

0.000327

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

0.000297

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

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

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

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

DESCRIBE `dancer_column`

0.000347

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

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

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

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

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 8.39 MB

Message	Memory use
Component initialization	2.14 MB
Controller action start	4.03 MB
Controller render start	4.98 MB
View render complete	6.27 MB

Timers

Total Request Time: 142 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	5.65
Event: Controller.initialize	43.12
Event: Controller.startup	0.25
Controller action	23.83
Event: Controller.beforeRender	21.61
» Processing toolbar data	16.62
Rendering View	25.43
» Event: View.beforeRender	0.67
» Rendering APP/View/School/kuchikomi_detail.ctp	7.93
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.06
» » Rendering APP/View/Elements/school/access.ctp	0.23
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.05
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	16.20
» » Rendering APP/View/Elements/header.ctp	0.29
» » Rendering APP/View/Elements/school/detailHeader.ctp	7.52
» » » Rendering APP/View/Elements/common/bookmark_school.ctp	0.10
» » » Rendering APP/View/Elements/breadcrumb.ctp	0.17
» » Rendering APP/View/Elements/menu.ctp	6.58
» » » Rendering APP/View/Elements/school/right-menu.ctp	6.46
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.05
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.05
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	5.86
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp	0.06
» » » » Rendering APP/View/Elements/adsense/300_250.ctp	0.06
» » Rendering APP/View/Elements/rtt.ctp	0.08
» » Rendering APP/View/Elements/footer.ctp	0.71
» » Rendering APP/View/Elements/common/scoreEx.ctp #2	0.04
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- Kuchikomi(object)
  id1343
  member_id3322
  school_id3016167
  titleレッスンの内容が濃い
  body去年から小学校の娘が本格的にダンスを習いたいと言い出したので色んな所に体験にいきましたが、１年越しにやっと出会えました。ダンスの指導とセンスが最高に良い！迷いなく入会しました。週二でモダンとホットダンス！どれぐらい成長するか楽しみです。オープンしたばかりで入会金も無料でとてもお得でした！
  score5
  reviewer_nickname
  enrollment_year2017
  level_at_enrollment2
  attending_period1
  ip_address10.4.1.11
  hostname10.4.1.11
  posted_at2017-06-13 08:03:09
  valid1
  timestamp_created2017-06-13 17:03:09
  timestamp_modified2017-06-13 17:03:09
- breadcrumb(array)
  0(array)
  nameスクール検索
  link(array)
  controllerschool_list
  actionindex
  1(array)
  name兵庫
  link(array)
  controllerschool_list
  actionindex
  prefectureId28
  2(array)
  name尼崎市
  link(array)
  controllerschool_list
  actionindex
  prefectureId28
  cityId1513
  3(array)
  name出屋敷駅
  link(array)
  controllerschool_list
  actionindex
  stationId6309
  4(array)
  nameALLURE dance studio
  link
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
  0(object)
  id3746320
  school_id3016167
  kuchikomi_questionnaire_item_id1
  score4.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
  1(object)
  id3746321
  school_id3016167
  kuchikomi_questionnaire_item_id2
  score4.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
  2(object)
  id3746322
  school_id3016167
  kuchikomi_questionnaire_item_id3
  score5.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
  3(object)
  id3746323
  school_id3016167
  kuchikomi_questionnaire_item_id4
  score4.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
  4(object)
  id3746324
  school_id3016167
  kuchikomi_questionnaire_item_id5
  score4.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
  5(object)
  id3746325
  school_id3016167
  kuchikomi_questionnaire_item_id6
  score4.00
  is_latest1
  timestamp_created2021-06-22 15:08:08
  timestamp_modified2021-06-22 15:08:08
- School(object)
  id3016167
  nameALLURE dance studio
  branch_name
  city_id1513
  schoolgroup_id(null)
  mail_addressallure@sjdance.net
  lat34.7191379
  lon135.4044931
  telephone_number0664121223
  homepage_urlhttp://sjdance.net
  mobile_homepage_urlhttp://sjdance.net
  blog_url
  open_hour11:00〜22:00
  holiday土日祝、お盆、GW
  post_code660-0876
  town_address竹谷町2-76
  buildingカンサイビル２Ｆ
  image_hash12791a2c53abc0b2
  image_extension_type2
  message_image_hashc737dcb5fa6adc3c
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title子供から大人まで楽しい時間を共に過ごしましょう(^^)
  message_bodyYOGA, JAZZ, MODERN, BALLET, BELLY, KIDS DANCE 東京、大阪、海外で実力派ダンサーとして、様々な舞台、ミュージカル、LIVE、海外公演に出演、またアイドルの育成やタレント、アーティストの振付指導、ステージング等の仕事に携わってきた講師が阪神「出屋敷駅」徒歩１分！！にスタジオオープン！！初心者〜プロの卵達、キッズ〜ミセスまで幅広いジャンルでのレッスンを設定しております。新しいスタジオ、新しい空間、新しいライフスタイルを始めませんか？講師、生徒、共に楽しくアットホームなスタジオです♪ また、昼ヨガクラスでは就学前のお子様をお連れのママさんも子連れ参加OK！で、みなさまに喜んでいただいてます(^^)ぜひお気軽にお問い合わせください。 http://sjdance.net ※インストラクター随時募集
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleホームページをご覧ください
  whole_staff_introductionALLURE dance studio →　http://sjdance.net
  whole_staff_image_hash
  whole_staff_image_extension_type0
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score5.00
  kuchikomi_count1
  timestamp_created2017-06-08 03:10:03
  timestamp_modified2021-06-22 15:08:08
  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 => '34.204.180.223'
	)
)
$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	34.204.180.223

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_3016167/review_detail/R_1343
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/detail/L_3016167/review_detail/R_1343
Remote Port	46670
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	34.204.180.223
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
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	34.204.180.223
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	34.204.180.223
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	YQekxF2VtapS9DAIR1QF6AAAAB4
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	YQekxF2VtapS9DAIR1QF6AAAAB4
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1627890884.6418
Request Time	1627890884

====

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-webp/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/ToStationUnitPage.php
  6APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.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/SchoolListPageLink/ToCategoryPage.php
  12APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
  13APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
  14APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
  15APP/class/Sgv/Front/InputForm/SchoolSearch.php
  16APP/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
====

ALLURE dance studio ジャズダンス,その他のダンスの口コミ、評判、体験談