ベリーダンスのレッスンを行う六本木,青山,麻布,赤坂のダンススクール、ダンス教室

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key58949ce2cd0de499468e221eec34c5143f5e9a95
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  58949ce2cd0de499468e221eec34c5143f5e9a951713430628
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool_list
- actionindex
- named(empty)
- pass(empty)
- categorySlugbelly
- prefectureId12
- stationUnitId2
- _Token(array)
  key58949ce2cd0de499468e221eec34c5143f5e9a95
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0categorySlug
  1prefectureId
  2stationUnitId
- options(array)
  categorySlug[a-z]+
  prefectureId[0-9]+
  stationUnitId[0-9]+
- defaults(array)
  controllerschool_list
  actionindex
  plugin(null)
- template/:categorySlug/pref_:prefectureId/area_su:stationUnitId
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 52 queries / 0.042107 sec

No.

time

query

0.001777

connect

0.000577

DESCRIBE `prefecture`

0.000347

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

DESCRIBE `station_unit`

0.000347

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.id = '2') LIMIT 1

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

0.000557

DESCRIBE `summary_count_school`

0.001027

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 IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) 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 = '2') AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	range	multi	multi	28		17	Using index condition; Using where

0.000617

DESCRIBE `station`

0.011507

DESCRIBE `station_station_unit`

0.000367

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_unit_id = '2')

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

0.000477

SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('5375', '5342', '5427', '5398')) GROUP BY `s`.`id`

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

0.000817

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 = 9) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id IN ('5342', '5375', '5398', '5427')) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	range	multi	multi	28		4	Using index condition; Using where

0.000437

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '12')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ALL	prefecture_id				16	Using where

0.000887

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 = 9) 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 IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '14', '15', '16')) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	range	multi	multi	28		14	Using index condition; Using where

0.000607

DESCRIBE `major_city`

0.000357

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '12')

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

0.000797

DESCRIBE `school`

0.000597

DESCRIBE `category_school`

0.001687

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.category_id = 9)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	ix_category_id_category_school	ix_category_id_category_school	4	const	343

0.000477

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_unit_id = '2')

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

0.000647

DESCRIBE `school_station`

0.000687

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id IN ('5375', '5342', '5427', '5398'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	range	station_id	station_id	4		58	Using index condition

0.001147

SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013181', '3013182', '3013187', '3013188', '3013189', '3013190', '3013191', '3013194', '3013195', '3013196', '3013197', '3013202', '3013206', '3013208', '3013226', '3013236', '3013237', '3013238', '3013240', '3013247', '3013254', '3013256', '3013264', '3013265', '3013266', '3013293', '3013292', '3013289', '3013301', '3013302', '3013438', '3013467', '3013948', '3013949', '3013950', '3013959', '3013960', '3014015', '3014019', '3014020', '3014022', '3014026', '3014041', '3014046', '3014048', '3014052', '3014065', '3014075', '3014082', '3014088', '3014099', '3014112', '3014114', '3014171', '3014113', '3014188', '3014212', '3014217', '3014218', '3014219', '3014226', '3014250', '3014295', '3014313', '3014315', '3014322', '3014367', '3014372', '3014373', '3014387', '3014392', '3014393', '3014398', '3014416', '3014094', '3014426', '3014428', '3014429', '3014439', '3014441', '3014442', '3014445', '3014446', '3014459', '3014462', '3014463', '3014465', '3014467', '3014475', '3014492', '3014464', '3014498', '3014499', '3014521', '3014522', '3014523', '3014534', '3014563', '3014565', '3014566', '3014567', '3014560', '3014122', '3014571', '3014579', '3014581', '3014583', '3014586', '3014588', '3014608', '3014609', '3014613', '3014618', '3014619', '3014622', '3014627', '3014628', '3014621', '3014646', '3014647', '3014676', '3014692', '3014693', '3014705', '3014712', '3014725', '3014735', '3014759', '3014762', '3014763', '3014771', '3014773', '3014778', '3014796', '3014798', '3014800', '3014806', '3014809', '3014815', '3014826', '3014834', '3014841', '3014844', '3014849', '3014850', '3014854', '3014856', '3014861', '3014862', '3014883', '3014886', '3014889', '3014890', '3014891', '3014892', '3014901', '3014909', '3014911', '3014922', '3014961', '3014963', '3014967', '3014972', '3014977', '3014979', '3014980', '3014981', '3014985', '3014994', '3015020', '3015026', '3015053', '3015058', '3015063', '3015076', '3015077', '3015078', '3015079', '3015082', '3015115', '3015122', '3013312', '3015125', '3015142', '3015145', '3015156', '3015157', '3015158', '3015165', '3015178', '3015277', '3015278', '3015284', '3014423', '3015295', '3015296', '3015297', '3015298', '3015310', '3015313', '3015314', '3015353', '3015354', '3015355', '3015356', '3013268', '3015365', '3015366', '3015369', '3015378', '3015395', '3015396', '3015400', '3015413', '3015416', '3015425', '3015427', '3015428', '3015429', '3015431', '3015444', '3015445', '3015450', '3015463', '3015465', '3015475', '3015498', '3015499', '3015508', '3015511', '3015523', '3015531', '3015532', '3015534', '3015535', '3015543', '3015545', '3015554', '3015555', '3015562', '3015571', '3015572', '3015584', '3015588', '3015589', '3015601', '3015607', '3015612', '3015629', '3015634', '3015635', '3015639', '3015640', '3015651', '3015658', '3015663', '3015527', '3015686', '3015688', '3015696', '3015697', '3015700', '3015701', '3015707', '3015716', '3015734', '3015743', '3015749', '3015750', '3015757', '3015773', '3015796', '3015802', '3015805', '3015809', '3015830', '3015836', '3015838', '3015335', '3015854', '3015864', '3015880', '3015882', '3015889', '3015660', '3015929', '3015954', '3015963', '3015985', '3015989', '3015990', '3015993', '3015994', '3015995', '3015996', '3016006', '3016030', '3016033', '3016040', '3016058', '3016061', '3016074', '3016085', '3014716', '3016119', '3016146', '3016147', '3016167', '3016176', '3016179', '3016180', '3016182', '3016187', '3016198', '3016199', '3016200', '3016202', '3016215', '3016216', '3016222', '3016236', '3016254', '3016259', '3016267', '3016279', '3016286', '3016290', '3016291', '3016313', '3016323', '3016330', '3016337', '3016359', '3016361', '3016370', '3016383', '3016384', '3016385', '3016392', '3016427', '3016430', '3016440', '3016444')) AND (s.id IN ('3014784', '3014697', '3014270', '3014270', '3014270', '3014270', '3015048', '3015030', '3015114', '3015241', '3015214', '3015212', '3015316', '3015378', '3015526', '3015975', '3016093', '3015030', '3013188', '3015048', '3015114', '3013285', '3014171', '3014582', '3014582', '3013224', '3014790', '3014906', '3014697', '3014784', '3015214', '3015316', '3015378', '3014998', '3015526', '3015718', '3015742', '3016068', '3016093', '3013206', '3014254', '3014906', '3013172', '3013224', '3013190', '3014811', '3015030', '3015214', '3015316', '3015378', '3014998', '3015526', '3015658', '3015733', '3015742', '3014790', '3015537', '3015718'))

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

0.001047

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013181', '3013182', '3013187', '3013188', '3013189', '3013190', '3013191', '3013194', '3013195', '3013196', '3013197', '3013202', '3013206', '3013208', '3013226', '3013236', '3013237', '3013238', '3013240', '3013247', '3013254', '3013256', '3013264', '3013265', '3013266', '3013293', '3013292', '3013289', '3013301', '3013302', '3013438', '3013467', '3013948', '3013949', '3013950', '3013959', '3013960', '3014015', '3014019', '3014020', '3014022', '3014026', '3014041', '3014046', '3014048', '3014052', '3014065', '3014075', '3014082', '3014088', '3014099', '3014112', '3014114', '3014171', '3014113', '3014188', '3014212', '3014217', '3014218', '3014219', '3014226', '3014250', '3014295', '3014313', '3014315', '3014322', '3014367', '3014372', '3014373', '3014387', '3014392', '3014393', '3014398', '3014416', '3014094', '3014426', '3014428', '3014429', '3014439', '3014441', '3014442', '3014445', '3014446', '3014459', '3014462', '3014463', '3014465', '3014467', '3014475', '3014492', '3014464', '3014498', '3014499', '3014521', '3014522', '3014523', '3014534', '3014563', '3014565', '3014566', '3014567', '3014560', '3014122', '3014571', '3014579', '3014581', '3014583', '3014586', '3014588', '3014608', '3014609', '3014613', '3014618', '3014619', '3014622', '3014627', '3014628', '3014621', '3014646', '3014647', '3014676', '3014692', '3014693', '3014705', '3014712', '3014725', '3014735', '3014759', '3014762', '3014763', '3014771', '3014773', '3014778', '3014796', '3014798', '3014800', '3014806', '3014809', '3014815', '3014826', '3014834', '3014841', '3014844', '3014849', '3014850', '3014854', '3014856', '3014861', '3014862', '3014883', '3014886', '3014889', '3014890', '3014891', '3014892', '3014901', '3014909', '3014911', '3014922', '3014961', '3014963', '3014967', '3014972', '3014977', '3014979', '3014980', '3014981', '3014985', '3014994', '3015020', '3015026', '3015053', '3015058', '3015063', '3015076', '3015077', '3015078', '3015079', '3015082', '3015115', '3015122', '3013312', '3015125', '3015142', '3015145', '3015156', '3015157', '3015158', '3015165', '3015178', '3015277', '3015278', '3015284', '3014423', '3015295', '3015296', '3015297', '3015298', '3015310', '3015313', '3015314', '3015353', '3015354', '3015355', '3015356', '3013268', '3015365', '3015366', '3015369', '3015378', '3015395', '3015396', '3015400', '3015413', '3015416', '3015425', '3015427', '3015428', '3015429', '3015431', '3015444', '3015445', '3015450', '3015463', '3015465', '3015475', '3015498', '3015499', '3015508', '3015511', '3015523', '3015531', '3015532', '3015534', '3015535', '3015543', '3015545', '3015554', '3015555', '3015562', '3015571', '3015572', '3015584', '3015588', '3015589', '3015601', '3015607', '3015612', '3015629', '3015634', '3015635', '3015639', '3015640', '3015651', '3015658', '3015663', '3015527', '3015686', '3015688', '3015696', '3015697', '3015700', '3015701', '3015707', '3015716', '3015734', '3015743', '3015749', '3015750', '3015757', '3015773', '3015796', '3015802', '3015805', '3015809', '3015830', '3015836', '3015838', '3015335', '3015854', '3015864', '3015880', '3015882', '3015889', '3015660', '3015929', '3015954', '3015963', '3015985', '3015989', '3015990', '3015993', '3015994', '3015995', '3015996', '3016006', '3016030', '3016033', '3016040', '3016058', '3016061', '3016074', '3016085', '3014716', '3016119', '3016146', '3016147', '3016167', '3016176', '3016179', '3016180', '3016182', '3016187', '3016198', '3016199', '3016200', '3016202', '3016215', '3016216', '3016222', '3016236', '3016254', '3016259', '3016267', '3016279', '3016286', '3016290', '3016291', '3016313', '3016323', '3016330', '3016337', '3016359', '3016361', '3016370', '3016383', '3016384', '3016385', '3016392', '3016427', '3016430', '3016440', '3016444')) AND (s.id IN ('3014784', '3014697', '3014270', '3014270', '3014270', '3014270', '3015048', '3015030', '3015114', '3015241', '3015214', '3015212', '3015316', '3015378', '3015526', '3015975', '3016093', '3015030', '3013188', '3015048', '3015114', '3013285', '3014171', '3014582', '3014582', '3013224', '3014790', '3014906', '3014697', '3014784', '3015214', '3015316', '3015378', '3014998', '3015526', '3015718', '3015742', '3016068', '3016093', '3013206', '3014254', '3014906', '3013172', '3013224', '3013190', '3014811', '3015030', '3015214', '3015316', '3015378', '3014998', '3015526', '3015658', '3015733', '3015742', '3014790', '3015537', '3015718')) ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20

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

0.000557

DESCRIBE `city`

0.000357

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('778', '778', '778', '778', '778'))

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

0.000457

SELECT `p`.* FROM `prefecture` AS `p`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL					47

0.000517

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3014171', '3013188', '3013190', '3015378', '3015658'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	range	school_id	school_id	4		21	Using index condition

0.000377

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id IN ('5375', '5426', '5426', '5374', '5398', '5339', '5399', '5375', '5340', '5341', '5342', '5375', '5398', '5399', '5426', '5339', '5340', '5341', '5353', '5398', '5426'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ALL	station_id				46	Using where

0.000317

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

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

0.000567

DESCRIBE `city_major_city`

0.000387

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id IN ('778', '778', '778', '778', '778'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_m_c	range	city_id	city_id	4		1	Using index condition

0.000457

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3014171', '3013188', '3013190', '3015378', '3015658'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	range	school_id	school_id	4		21	Using index condition

0.000417

SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('5375', '5426', '5399', '5399', '5398')) GROUP BY `s`.`id`

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

0.000497

DESCRIBE `school_score`

0.000437

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id IN ('3014171', '3013188', '3013190', '3015378', '3015658')) AND (s_s.is_latest = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	range	school_id	school_id	4		5	Using index condition; Using where

0.000527

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3014171', '3013188', '3013190', '3015378', '3015658'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	range	school_id	school_id	4		22	Using index condition

0.001697

connect

0.000457

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

SELECT `p`.* FROM `prefecture` AS `p`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL					47

0.000627

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

DESCRIBE `summary_count_kuchikomi`

0.000427

SELECT `s_c_k`.* FROM `summary_count_kuchikomi` AS `s_c_k` WHERE (s_c_k.is_latest = 1) AND (s_c_k.category_id = 9) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = '2') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_k	ref	multi	multi	20	const,const,const,const,const	1	Using index condition

0.000577

DESCRIBE `dancer`

0.000477

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

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

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

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

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

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

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

Message	Memory use
Component initialization	2.16 MB
Controller action start	2.39 MB
Controller render start	4.99 MB
View render complete	5.89 MB

Timers

Total Request Time: 189 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	8.18
Event: Controller.initialize	0.68
Event: Controller.startup	0.31
Controller action	74.85
Event: Controller.beforeRender	55.04
» Processing toolbar data	52.26
Rendering View	27.32
» Event: View.beforeRender	1.23
» Rendering APP/View/SchoolList/index.ctp	13.73
» » Rendering APP/View/Elements/breadcrumb.ctp	0.26
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.08
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	6.75
» » Rendering APP/View/Elements/__searchlink/main-column-station-unit.ctp	0.47
» » Rendering APP/View/Elements/__searchlink/main-column-station.ctp	0.15
» » Rendering APP/View/Elements/school-box.ctp	0.93
» » » Rendering APP/View/Elements/adsense/336_288.ctp	0.08
» » Rendering APP/View/Elements/school-box.ctp #2	0.35
» » Rendering APP/View/Elements/school-box.ctp #3	0.26
» » Rendering APP/View/Elements/school-box.ctp #4	0.36
» » Rendering APP/View/Elements/school-box.ctp #5	0.47
» » » Rendering APP/View/Elements/adsense/336_288.ctp #2	0.08
» » Rendering APP/View/Elements/paginator.ctp	0.09
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	11.17
» » Rendering APP/View/Elements/header.ctp	0.37
» » Rendering APP/View/Elements/menu.ctp	8.43
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	8.23
» » » » Rendering APP/View/Elements/__searchlink/right-menu-category.ctp	0.41
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.08
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	6.97
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.10
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.08
» » Rendering APP/View/Elements/rtt.ctp	0.12
» » Rendering APP/View/Elements/footer.ctp	0.89
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.09
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
  categorySlugbelly
  2(array)
  name東京都
  link(array)
  controllerschool_list
  actionindex
  categorySlugbelly
  prefectureId12
  3(array)
  name六本木・青山・麻布・赤坂
  link
- metaKeywordStringベリーダンス,六本木,青山,麻布,赤坂,東京都,ダンススクール,ダンス教室
- headString六本木,青山,麻布,赤坂のベリーダンス　ダンススクール、ダンス教室
- metaDescriptionベリーダンスのレッスンを行う六本木,青山,麻布,赤坂（東京都）のダンススクール、ダンス教室(5件)の口コミ評判ランキング。5件のダンスレッスン体験談からあなたに合った六本木,青山,麻布,赤坂のスクールを探し出せます！
- title_for_layoutベリーダンスのレッスンを行う六本木,青山,麻布,赤坂のダンススクール、ダンス教室
- SchoolSet(object)
  0(object)
  id3014171
  nameスタイルアーバン
  branch_nameスタイルアーバン六本木
  city_id778
  schoolgroup_id(null)
  mail_addressinfo@styleurban.com
  lat35.665867000000
  lon139.728623000000
  telephone_number0334082332
  homepage_urlhttp://www.styleurban.com
  mobile_homepage_url
  blog_urlhttp://ameblo.jp/styleurban/
  open_hour12:00～22:00
  holiday日曜日
  post_code1060032
  town_address六本木7-3-13
  building(1FにBAGEL&BAGELがあるビルの2F)
  image_hash164fa6164ac1c841
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title六本木駅から徒歩5分のスタジオで、バレエ、サルサ、タンゴ、ベリーダンスなどを楽しく学ぶことができます。
  message_body六本木駅から徒歩5分のスタジオで、バレエ、サルサ、タンゴ、ベリーダンスなどを楽しく学ぶことができます。仲間たちが集う楽しいクローズドパーティーを企画。交流会や情報交換、習ったダンスも披露できるミニ発表会も開催。（自由参加）おしゃべりを楽しんだり、ペアダンスを踊ったり、楽しみ方は色々です。（URBAN party、紹介制パーティー、ビューティー座談会）
  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:06:07
  memo(null)
  1(object)
  id3013188
  nameDanceStudioCasino
  branch_name(null)
  city_id778
  schoolgroup_id(null)
  mail_addressinfo@studio-casino.com
  lat35.662250000000
  lon139.733845000000
  telephone_number03-5771-7046
  homepage_urlhttp://www.studio-casino.com
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code1060032
  town_address六本木5-2-4
  building第2鳥勝ビル4F
  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:02
  memo(null)
  2(object)
  id3013190
  nameDHC PRIVATE SALON
  branch_name(null)
  city_id778
  schoolgroup_id(null)
  mail_address
  lat35.667083000000
  lon139.739997000000
  telephone_number03-5570-3207
  homepage_urlhttp://top.dhc.co.jp/salon/index.html
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code1070052
  town_address赤坂1-12-32
  buildingア-ク森ビル24F
  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:03
  memo(null)
  3(object)
  id3015378
  nameStudio Muku　スタジオミューク
  branch_name
  city_id778
  schoolgroup_id(null)
  mail_addressinfo@muku.com
  lat35.6700604
  lon139.7299758
  telephone_number0334088131
  homepage_urlhttp://www.muku.com
  mobile_homepage_url
  blog_urlhttp://studiomuku.blog109.fc2.com/
  open_hour10:00-22:30
  holiday無し
  post_code107-0052
  town_address赤坂8-12-12
  buildingAkasaka Residence1/3 B1
  image_hash13202fb96bb98860
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_titleインターナショナル　エンターティメント　スタジオ！
  message_body子供（2歳半）から大人まで楽しめるエンターティメントスタジオです！ダンス以外にボーカル（大人/子供）、子供の体操、チアダンス、アクロバットなどのクラスもあります。工作や絵のアートクラスもあります！小学生前のお子さんには総合クラス（体操・英語・歌・ダンス・お絵描きなど）が大人気です。また近隣保育園へのお迎えサービスもあります。今年より小学１年から４年生までのAfter Schoolでは、14:30-19:00までのお預かりが可能で、各種ダンスなどのレッスンに加え、学習、英語のレッスンもできます！また堀北真希、黒木メイサが所属するSweet Powerと提携したタレントスクールも併設しています！
  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_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2013-10-08 07:40:29
  timestamp_modified2021-08-03 15:07:26
  memo(null)
  4(object)
  id3015658
  nameSHIVAベリーダンススタジオ
  branch_name
  city_id778
  schoolgroup_id(null)
  mail_addressinfo@shiva-belly.com
  lat35.6731908
  lon139.7373611
  telephone_number09084333904
  homepage_urlhttp://www.shiva-belly.com
  mobile_homepage_url
  blog_url
  open_hour12:00~22:00
  holiday夏期・年末年始
  post_code107-0052
  town_address赤坂3丁目13－12
  building吉池ビル３F
  image_hash43e51412cd68195b
  image_extension_type2
  message_image_hash19a74147c4677570
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title体験1000円キャンペーン！
  message_bodyベリーダンスが初めて★ビギナークラス NEWスタート！（水）２０：４５～（木）１９：００～（日）１２：００～ 70分の基本的な初心者向けのクラスです♪ ストレッチで自分の身体に意識を向け、基本となる腕・腰・胸の動きや顔の表情・首・指先への意識の向け方アラブのリズムにノッて♪ステップ＆ターン気づくと身体すっきり、シェイプ！翌朝すっきり目覚め＆お通じ更に日常の表情やしぐさまで　エレガントに女性らしくセクシーに！！！婚活＆妊活にも強力な効果のSHIVAセンセイのメソッドを是非！体験ください♪ 「Let's be dancerから」の一言添えて申し込みで体験レッスン2000円→1000円です！
  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_created2014-07-14 14:03:25
  timestamp_modified2021-08-03 15:07:44
  memo(null)
- SchoolPager(object)
  0(object) - recursion
  1(object) - recursion
  2(object) - recursion
  3(object) - recursion
  4(object) - recursion
- SearchTransitableToStationUnitPage(object)
- StationUnitSet(array)
  0(object)
  id1
  name銀座・有楽町・新橋
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id2
  name六本木・青山・麻布・赤坂
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id3
  name渋谷・原宿・表参道
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  3(object)
  id4
  name恵比寿・目黒
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  4(object)
  id5
  name新宿・代々木・中野
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  5(object)
  id6
  name池袋・目白・大塚
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  6(object)
  id7
  name上野・秋葉原・錦糸町
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  7(object)
  id8
  name品川・田町・蒲田
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  8(object)
  id9
  name自由が丘・中目黒・二子玉川
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  9(object)
  id10
  name三鷹・調布・吉祥寺
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  10(object)
  id11
  name町田・多摩・相模原
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  11(object)
  id14
  name飯田橋・市ヶ谷・四ッ谷
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  12(object)
  id16
  name立川・八王子・青梅
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToStationPage(object)
- StationSet(array)
  0(object)
  id5342
  name青山一丁目
  city_id778
  lat35.672765000000
  lon139.724159000000
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id5375
  name六本木
  city_id778
  lat35.662836000000
  lon139.731443000000
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id5398
  name赤坂
  city_id778
  lat35.673230000000
  lon139.738348000000
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToCategoryPage(object)
- CategorySet(array)
  0(object)
  id1
  nameバレエ
  slugballet
  description歌詞やセリフを伴わず、楽曲に合わせたダンスによって表現を行う舞台のダンスを指してバレエと言います。西ヨーロッパで発生し広まってきたもので元はオペラの一部として発達してきました。ダンスの特徴などからロマンティック・バレエ、クラシック・バレエ、モダン・バレエと大きく3種類に分類され、それぞれ異なった特徴を持ちます。ダンスとしての基礎になる部分が多く、ストリートダンスやジャズダンス、社交ダンスを習う時でも表現の幅を広げるため、一緒にバレエの習得が行われる場合もあります。
  1(object)
  id2
  nameジャズダンス
  slugjazz
  description元々はジャズミュージックに合わせて踊るダンス全般の事をジャズダンスと言いましたが、現在ではジャズミュージックに限らず、色々な音楽に合わせて踊ります。バレエの動きをベースにした動作が特徴的で、TVやライブなどでのタレントやアーティストの多くのダンスはジャズダンスがベースとなっています。幅が広く、自由度の高いダンススタイルで、非常に人気の高いダンススタイルです。
  2(object)
  id3
  nameヒップホップ
  slughiphop
  description元々はヒップホップ＝70年代にアメリカで生まれたブラックカルチャー全般の事で、ラップやDJといった文化の事をさします。そのため、ヒップホップをダンスの種類としてではなく文化の総称として考えると、ストリートダンスは全てヒップホップとえます。ダンスの種類としてのヒップホップは、ブレイクダンスとソウルダンスを融合したもので、比較的新しいスタイルのものです。動きとしてはアップ、ダウンのリズムの取り方を基本としていて、ランニングマンやクラブステップといったような大き目の動きをする動作が多いダンスです。
  3(object)
  id4
  nameストリートダンス
  slugstreet
  descriptionストリート（路上）で踊られる事から発生したダンスで、比較的最近登場したジャンルのダンスです。元々はギャングの抗争を銃撃戦の代わりにブレイクダンスによって行われたものが始まりとされていて、ヒップホップ文化から出てきたダンス全般をストリートダンスと言います。現在ではジャズダンスなど様々なダンスがストリートダンスとして取り入れられ、ストリートダンス＝現代的なダンスという形の認識が強くなってきています。
  4(object)
  id5
  nameタップダンス
  slugtap
  descriptionつま先やかかとを床に打ち付ける事で音を出し、ステップによってリズムを作るダンスの事をタップダンスと言います。ブロードウェイミュージカルに見られるような上半身での振り付けもしっかりとしているものをミュージカルタップといい、ステップによるリズムを重視したものをリズムタップといいます。
  5(object)
  id6
  nameサルサ
  slugsalsa
  descriptionサルサとはキューバ発祥のラテン音楽の一つで、サルサミュージックに合わせて踊るダンスの事をサルサダンスといいます。サルサダンスは男女がペアになって男性リードで踊るペアダンスで、ペアダンスの中でも踊るスピードが速いのが特徴です。キューバンスタイルやNYスタイル、LAスタイルなど、ダンスや音楽の特徴でいくつかの種類に分かれます。
  6(object)
  id7
  nameフラメンコ
  slugflamenco
  descriptionスペイン南部のアンダルシア地方に伝わる文化で、歌・踊り・ギターによる伴奏の総称をフラメンコと言います。日本ではフラメンコ＝踊りという印象が強いですが、元々はフラメンコの真髄は歌だと言われています。手足またはカスタネットを使って音を出しリズムを作りながら情熱的に踊ります。観客による掛け声での合いの手による盛り上げなども重要な要素と言わており、逆に手拍子などは音楽の妨げになる事からやってはいけない事とされています。
  7(object)
  id8
  nameフラダンス・タヒチアンダンス
  slughula
  descriptionハワイにおける民族舞踊をフラ、タヒチにおける民族舞踊をタヒチアンダンスと言い、両方ともポリネシアン地域の踊りです。フラとは「ダンス」を意味する言葉で、歌・踊り・楽曲を総称してフラと言います。フラは元々宗教的・教訓的な側面の強い踊りで、文字文化の無いハワイにおいて物語や教訓を後世に伝えていくという面も持ち合わせています。タヒチアンダンスは現地の言葉でオリタヒチと言い、このオリという言葉もやはり現地語でダンスという意味です。フラもオリタヒチもその内容によって更に種類が細分化されますが、一般的にはフラは複数人数でゆったりと優雅に踊るもの、タヒチアンダンスは腰を激しく振りながら踊るものという違いがあります。
  8(object)
  id9
  nameベリーダンス
  slugbelly
  description中東・アラブ地域で発展したダンススタイルの事を指し、アラブ文化圏ではラクス・シャルキー(東方の踊りの意味)やラクス・バラディ（民族舞踏の意味）と呼ばれる。ベリーダンスのベリーとはお腹を意味するbellyだとされ、お腹の動きが特徴的だという事からこの名称で呼ばれるようになったとされています。ベリーダンスは中東・アラブ地域のダンスの総称であるため、同じベリーダンスでもスタイルによっては衣装や音楽など、多くの面で違うものとなります。
  9(object)
  id10
  name社交ダンス
  slugsocial
  description儀式や舞台(ショー)向けのダンスではなく、男女のペアで楽曲に合わせて踊るペアダンスの事を社交ダンスと言います。社交ダンスは大きく分けるとワルツやタンゴに代表されるようなスタンダードと呼ばれるものと、サンバやルンバ、パソドブレといったラテンダンスに分類されます。社交ダンスという名称は元々sociality dancingの誤訳からできた言葉で、日本国内でのみSocial Danceという言葉が利用されています。英語では一般的にBallroom Dance(ボールルームダンス＝舞踏室の踊り)とあらわされ、競技ダンスなども社交ダンスと言われます。
  10(object)
  id11
  nameタンゴ
  slugtango
  descriptionアルゼンチンのブエノスアイレスやウルグアイのモンテビデオ発祥のダンス。元々のタンゴをアルゼンチン・タンゴと言い、これがヨーロッパに渡って変化したものをコンチネンタル・タンゴと言います。現在では社交ダンスの一つとしても人気が高いダンスで、全体的に短いスタッカートを多用する音楽に合わせた上下動の少ない力強いダンスが特徴的です。
  11(object)
  id12
  name民族舞踊・フォークダンス
  slugfolk
  description民族間で伝承されてきたダンス全般の事を指して、民族舞踏といいます。日本においては日本舞踏のほか、盆踊りやよさこいなどの伝統的なものも全て民族舞踏の一つで、ハワイにおけるフラや中東におけるベリーダンスも民族舞踏です。民族舞踏はそれぞれの地域における地理的な環境や言語的な特徴など、様々な要因によって作られてきており、民族舞踏を学習する事でその国の文化などに触れ、理解をする事が出来ます。
  12(object)
  id13
  nameキッズダンス教室
  slugkids
  descriptionダンスは言葉を用いないで自己表現をするための一つの手段であり、ダンスを学ぶ事で表現力を養う事や自信を持つことが出来る等点から、キッズダンスを習得させる家庭は増加傾向にあります。また、小中学校におけるダンスの教育義務化などもあり、習い事の一つとしてダンス教室はとても重要なものとなってきています。最近ではキッズダンサー向けのダンス大会なども頻繁に開催されていて、ただ習うだけではなく活躍する機会も今後さらに増えていくのではないでしょうか。
  13(object)
  id14
  nameその他のダンス
  slugother
  description
- TransitionalLinkShowDescidableSchoolList(object)
- SearchStateExplainableSchoolList(object)
- SearchConditionSchoolList(object)
- InputItemSchoolSearch(object)
  useTable(false)
  useDbConfigdefault
  displayField(null)
  id(false)
  data(empty)
  schemaName(null)
  tablesgv__front__input_form__school_searches
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  validationDomain(null)
  plugin(null)
  nameSgv_Front_InputForm_SchoolSearch
  aliasSgv_Front_InputForm_SchoolSearch
  tableToModel(empty)
  cacheQueries(false)
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  actsAs(null)
  Behaviors(object)
  modelNameSgv_Front_InputForm_SchoolSearch
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  recursive1
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(array)
  Sgv_Front_InputForm_SchoolSearch(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.138.122.195'
	)
)
$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.138.122.195

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	/belly/pref_12/area_su2
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/belly/pref_12/area_su2
Remote Port	52112
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.138.122.195
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http User Agent	claudebot
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.138.122.195
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.138.122.195
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZiDZXEfPB9x3FO07cWLeogAAASY
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	ZiDZXEfPB9x3FO07cWLeogAAASY
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713428828.2142
Request Time	1713428828

====

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
  6CORE/Utility/ClassRegistry.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/SchoolListController.php
  1APP/Controller/AppController.php
  Other(array)
  0APP/webroot/index.php
  1APP/class/Sgv/Front/InputForm/SchoolSearch.php
  2APP/class/Sgv/Front/InputItem/SchoolSearch.php
  3APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
  4APP/class/Sgv/Front/SearchCondition/SchoolList.php
  5APP/class/Sgv/Front/SearchState/SchoolList.php
  6APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
  7APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
  8APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
  9APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
  10APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
  11APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  12APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
  13APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
  14APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  15APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
  16APP/class/Sgv/Front/AttachableToDataSet/City.php
  17APP/class/Sgv/Front/PrefectureAttachment/ToSchoolSet.php
  18APP/class/Sgv/Front/AttachableToDataSet/Prefecture.php
  19APP/class/Sgv/Front/StationUnitAttachment/ToSchoolSet.php
  20APP/class/Sgv/Front/AttachableToDataSet/StationUnit.php
  21APP/class/Sgv/Front/MajorCityAttachment/ToSchoolSet.php
  22APP/class/Sgv/Front/AttachableToDataSet/MajorCity.php
  23APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
  24APP/class/Sgv/Front/AttachableToDataSet/Station.php
  25APP/class/Sgv/Front/SchoolScoreAttachment/ToSchoolSet.php
  26APP/class/Sgv/Front/AttachableToDataSet/SchoolScore.php
  27APP/class/Sgv/Front/CategorySchoolAttachment/ToSchoolSet.php
  28APP/class/Sgv/Front/AttachableToDataSet/CategorySchool.php
  29APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  30APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.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
====

六本木,青山,麻布,赤坂のベリーダンス　ダンススクール、ダンス教室

Search Result 検索結果

»Filtering Search ダンススクール・ダンス教室の絞り込み検索

»Popular Area 東京都の主要なエリア

»Area Search 駅で絞る

School List 六本木・青山・麻布・赤坂(東京都)のダンススクールランキング(ベリーダンス)
1〜5件を表示／5件

スタイルアーバンスタイルアーバン六本木

DanceStudioCasino

DHC PRIVATE SALON

Studio Muku　スタジオミューク

SHIVAベリーダンススタジオ

»Category Search カテゴリー検索

Special Column

Memory

Timers

六本木,青山,麻布,赤坂のベリーダンス ダンススクール、ダンス教室

Search Result 検索結果

»Filtering Search ダンススクール・ダンス教室の絞り込み検索

»Popular Area 東京都の主要なエリア

»Area Search 駅で絞る

School List 六本木・青山・麻布・赤坂(東京都)のダンススクールランキング(ベリーダンス) 1〜5件を表示／5件

スタイルアーバン スタイルアーバン六本木

DanceStudioCasino

DHC PRIVATE SALON

Studio Muku スタジオミューク

SHIVAベリーダンススタジオ

»Category Search カテゴリー検索

Special Column

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

六本木,青山,麻布,赤坂のベリーダンス　ダンススクール、ダンス教室

School List 六本木・青山・麻布・赤坂(東京都)のダンススクールランキング(ベリーダンス)
1〜5件を表示／5件

スタイルアーバンスタイルアーバン六本木

Studio Muku　スタジオミューク