その他のダンスのレッスンを行う新宿三丁目付近のダンススクール、ダンス教室

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

Cake Params
- plugin(null)
- controllerschool_list
- actionindex
- named(empty)
- pass(empty)
- categorySlugother
- stationId5356
- _Token(array)
  keyffd1ed06e5863876d10434cc283fdf453874bb84
  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
  1stationId
- options(array)
  categorySlug[a-z]+
  stationId[0-9]+
- defaults(array)
  controllerschool_list
  actionindex
  plugin(null)
- template/:categorySlug/station_:stationId
====

Sql Log

Sql Logs

参考：explainの見方

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

No.

time

query

0.001797

connect

0.000517

DESCRIBE `station`

0.000317

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

DESCRIBE `summary_count_school`

0.000987

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 = '5356') 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		17	Using index condition; Using where

0.000367

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

DESCRIBE `city`

0.000297

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

DESCRIBE `prefecture`

0.000337

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

DESCRIBE `station_unit`

0.000387

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

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 = 14) 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.000517

DESCRIBE `major_city`

0.000347

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

DESCRIBE `school`

0.000437

DESCRIBE `category_school`

0.003387

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

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	844

0.000547

DESCRIBE `school_station`

0.000467

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

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

0.001717

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 ('3013173', '3013188', '3013206', '3013238', '3013277', '3013278', '3013297', '3013299', '3013303', '3013305', '3013309', '3013311', '3013312', '3013937', '3013942', '3013943', '3013945', '3013948', '3013951', '3013956', '3013959', '3013960', '3013962', '3013964', '3013966', '3013973', '3013988', '3013989', '3013994', '3013998', '3014004', '3014011', '3014015', '3014020', '3014022', '3014023', '3014029', '3014031', '3014034', '3014033', '3014035', '3014037', '3014040', '3014042', '3014045', '3014052', '3014055', '3014056', '3014057', '3014062', '3014064', '3013929', '3014068', '3014070', '3014073', '3014074', '3014075', '3014079', '3014090', '3014099', '3014100', '3014102', '3014106', '3014117', '3014119', '3014120', '3014125', '3014130', '3014131', '3014133', '3014134', '3014136', '3014137', '3014138', '3014139', '3014146', '3014141', '3014153', '3014169', '3014170', '3014113', '3014176', '3014178', '3014179', '3014180', '3014181', '3014202', '3014208', '3014209', '3014216', '3014227', '3014247', '3014248', '3014249', '3014256', '3014257', '3014262', '3014265', '3014267', '3014271', '3014281', '3014287', '3014291', '3014294', '3014295', '3014297', '3014308', '3014313', '3014314', '3014315', '3014316', '3014319', '3014322', '3014327', '3014328', '3014331', '3014342', '3014343', '3014347', '3014367', '3014368', '3014376', '3014390', '3014393', '3014396', '3014404', '3014406', '3014399', '3014417', '3014419', '3014094', '3014425', '3014432', '3014433', '3014437', '3014441', '3014444', '3014445', '3014446', '3014449', '3014451', '3014459', '3014460', '3014462', '3014466', '3014467', '3014471', '3014475', '3014394', '3014477', '3014478', '3014479', '3014481', '3014492', '3014464', '3014500', '3014505', '3014506', '3014507', '3014497', '3014534', '3014535', '3014543', '3014562', '3014564', '3014565', '3014560', '3013298', '3014570', '3014572', '3014573', '3014576', '3014578', '3014581', '3014582', '3014583', '3014588', '3014598', '3014599', '3014600', '3014603', '3014607', '3014613', '3014615', '3014618', '3014619', '3014623', '3014626', '3014627', '3014628', '3014630', '3014631', '3014635', '3014636', '3014640', '3014641', '3014642', '3014643', '3014647', '3014651', '3014652', '3014654', '3014658', '3014660', '3014661', '3014662', '3014670', '3014673', '3014674', '3014675', '3014676', '3014200', '3014677', '3014685', '3014686', '3014690', '3014483', '3014705', '3014707', '3014708', '3014712', '3014715', '3014716', '3014721', '3014722', '3014723', '3014725', '3014727', '3014729', '3014735', '3014739', '3014610', '3014659', '3014743', '3014744', '3014759', '3014763', '3014766', '3014767', '3014771', '3014773', '3014774', '3014779', '3014780', '3014781', '3014782', '3014893', '3015194', '3014783', '3014784', '3014786', '3014184', '3014787', '3014788', '3014664', '3014793', '3014795', '3014811', '3014796', '3014797', '3014798', '3014800', '3014810', '3014815', '3014819', '3014802', '3014826', '3014827', '3014830', '3014832', '3014834', '3014823', '3014835', '3014836', '3014838', '3014841', '3014844', '3014846', '3014849', '3014850', '3014851', '3014856', '3014857', '3014858', '3014859', '3014861', '3014869', '3014871', '3014873', '3014875', '3014882', '3014883', '3014884', '3014887', '3014888', '3014890', '3014896', '3014897', '3014898', '3014899', '3014905', '3014906', '3014909', '3014915', '3014920', '3014922', '3014923', '3014924', '3014933', '3014935', '3014936', '3014937', '3014938', '3014941', '3014942', '3014943', '3014945', '3014946', '3014948', '3014949', '3014952', '3014955', '3014957', '3014958', '3014959', '3014960', '3014961', '3014963', '3014964', '3014965', '3014966', '3014969', '3014608', '3014972', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3014984', '3014990', '3014992', '3014998', '3015001', '3015007', '3015008', '3015009', '3015010', '3015011', '3015012', '3015013', '3015014', '3015015', '3015016', '3015017', '3014337', '3015023', '3015024', '3015027', '3015033', '3014442', '3015042', '3015051', '3015053', '3015054', '3015056', '3015060', '3015068', '3015070', '3015073', '3014806', '3015074', '3015080', '3015082', '3015083', '3015091', '3015094', '3015095', '3015100', '3015102', '3015111', '3015112', '3015120', '3015121', '3014580', '3015131', '3015140', '3015143', '3015144', '3015145', '3015147', '3015148', '3015149', '3015150', '3015151', '3015155', '3015157', '3015158', '3015162', '3015165', '3014415', '3015170', '3015172', '3015173', '3015174', '3015175', '3015176', '3015178', '3015180', '3015182', '3015184', '3015187', '3015188', '3015195', '3015198', '3015197', '3015204', '3014440', '3015205', '3015208', '3015261', '3015264', '3015266', '3015284', '3014423', '3015292', '3015293', '3015294', '3015297', '3015300', '3015303', '3015306', '3015307', '3015251', '3015221', '3015222', '3015224', '3015225', '3015244', '3015245', '3015246', '3015247', '3015248', '3015276', '3015313', '3015314', '3015315', '3015316', '3015317', '3015318', '3015319', '3015320', '3015325', '3015328', '3015329', '3015331', '3015333', '3014926', '3015356', '3015357', '3015360', '3013268', '3015365', '3015369', '3015370', '3015371', '3015377', '3015378', '3015384', '3015385', '3014867', '3015393', '3015394', '3015395', '3015396', '3015399', '3015401', '3015403', '3015404', '3015405', '3015409', '3015413', '3015414', '3015417', '3015424', '3015425', '3015426', '3015429', '3015432', '3015437', '3015443', '3015132', '3015451', '3015452', '3015453', '3015457', '3015460', '3014644', '3015464', '3015469', '3015473', '3015477', '3015475', '3015481', '3015482', '3015484', '3015499', '3015500', '3015501', '3015502', '3015508', '3015514', '3015521', '3015523', '3015525', '3015529', '3015531', '3015532', '3015537', '3015538', '3015540', '3015542', '3015547', '3015548', '3015549', '3015550', '3015554', '3015555', '3015558', '3015559', '3015562', '3015563', '3015564', '3015570', '3015571', '3015572', '3015575', '3015576', '3015580', '3015582', '3015584', '3015590', '3015596', '3015600', '3015601', '3015605', '3015607', '3015608', '3015402', '3015610', '3015615', '3015616', '3015621', '3014820', '3015623', '3015624', '3015628', '3015629', '3015631', '3015635', '3015636', '3015638', '3015639', '3015642', '3015374', '3015649', '3015650', '3015653', '3015654', '3015655', '3015657', '3015659', '3015662', '3015668', '3015674', '3015681', '3015684', '3015687', '3015688', '3015695', '3015699', '3015700', '3015701', '3015702', '3015703', '3015704', '3015705', '3015706', '3015708', '3015710', '3015712', '3015709', '3015716', '3015718', '3015721', '3015722', '3015723', '3015724', '3015725', '3015730', '3015733', '3015740', '3015748', '3015753', '3015754', '3015755', '3015764', '3015765', '3015766', '3015769', '3015768', '3015772', '3015774', '3015775', '3015776', '3015780', '3015781', '3015785', '3015789', '3015792', '3015797', '3015801', '3015804', '3015598', '3015807', '3015811', '3015813', '3015814', '3015817', '3015822', '3015827', '3015833', '3015517', '3015835', '3015843', '3015335', '3015857', '3015861', '3015864', '3015867', '3015875', '3014657', '3015879', '3015880', '3015882', '3015887', '3015891', '3015893', '3015897', '3015899', '3015902', '3015904', '3015900', '3015507', '3015903', '3015911', '3015820', '3015912', '3015918', '3015923', '3015927', '3015930', '3015932', '3015935', '3015942', '3015944', '3015956', '3015959', '3015960', '3015962', '3015968', '3015981', '3015982', '3015985', '3015988', '3015989', '3015990', '3015991', '3015998', '3016010', '3016020', '3016025', '3016024', '3016026', '3016027', '3016030', '3016033', '3016036', '3016039', '3016040', '3016055', '3016058', '3016061', '3016062', '3016064', '3016066', '3016069', '3013940', '3016074', '3016079', '3016080', '3016088', '3016093', '3016097', '3016104', '3016108', '3016114', '3016115', '3016118', '3013984', '3016131', '3016134', '3016135', '3016136', '3016137', '3016138', '3016140', '3016146', '3016147', '3016149', '3016151', '3016153', '3016154', '3016157', '3014624', '3016158', '3016159', '3016160', '3015518', '3016162', '3016166', '3016167', '3016174', '3014822', '3016175', '3016181', '3016182', '3016184', '3016186', '3015898', '3016190', '3016194', '3016196', '3016201', '3016211', '3016212', '3016213', '3016219', '3016225', '3016226', '3016230', '3013194', '3016239', '3016241', '3016243', '3016120', '3016223', '3016254', '3016255', '3015527', '3015528', '3016257', '3016258', '3016259', '3016268', '3016269', '3016272', '3016273', '3016274', '3016276', '3016279', '3016286', '3016288', '3016289', '3016291', '3016296', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016314', '3016315', '3016316', '3016320', '3016321', '3016322', '3016323', '3016324', '3016328', '3016330', '3016334', '3016337', '3016338', '3016341', '3016342', '3016343', '3016344', '3016354', '3016359', '3016360', '3016362', '3016369', '3016370', '3016371', '3016372', '3016373', '3016374', '3016375', '3016383', '3016384', '3016363', '3016385', '3015231', '3016389', '3016392', '3016393', '3016394', '3016395', '3016396', '3016397', '3016398', '3016399', '3016402', '3016404', '3016412', '3016414', '3016416', '3016420', '3016423', '3016429', '3016430', '3015146', '3016436', '3016437', '3016440', '3016445', '3016446', '3016447')) AND (s.id IN ('3014947', '3013213', '3014589', '3014841', '3013244', '3014783', '3013284', '3013251', '3014748', '3013974', '3013279', '3013271', '3013202', '3014897', '3015209', '3015349', '3015442', '3015035', '3015523', '3015402', '3015766', '3015833', '3016182', '3016183', '3014822', '3014785'))

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

0.002317

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013173', '3013188', '3013206', '3013238', '3013277', '3013278', '3013297', '3013299', '3013303', '3013305', '3013309', '3013311', '3013312', '3013937', '3013942', '3013943', '3013945', '3013948', '3013951', '3013956', '3013959', '3013960', '3013962', '3013964', '3013966', '3013973', '3013988', '3013989', '3013994', '3013998', '3014004', '3014011', '3014015', '3014020', '3014022', '3014023', '3014029', '3014031', '3014034', '3014033', '3014035', '3014037', '3014040', '3014042', '3014045', '3014052', '3014055', '3014056', '3014057', '3014062', '3014064', '3013929', '3014068', '3014070', '3014073', '3014074', '3014075', '3014079', '3014090', '3014099', '3014100', '3014102', '3014106', '3014117', '3014119', '3014120', '3014125', '3014130', '3014131', '3014133', '3014134', '3014136', '3014137', '3014138', '3014139', '3014146', '3014141', '3014153', '3014169', '3014170', '3014113', '3014176', '3014178', '3014179', '3014180', '3014181', '3014202', '3014208', '3014209', '3014216', '3014227', '3014247', '3014248', '3014249', '3014256', '3014257', '3014262', '3014265', '3014267', '3014271', '3014281', '3014287', '3014291', '3014294', '3014295', '3014297', '3014308', '3014313', '3014314', '3014315', '3014316', '3014319', '3014322', '3014327', '3014328', '3014331', '3014342', '3014343', '3014347', '3014367', '3014368', '3014376', '3014390', '3014393', '3014396', '3014404', '3014406', '3014399', '3014417', '3014419', '3014094', '3014425', '3014432', '3014433', '3014437', '3014441', '3014444', '3014445', '3014446', '3014449', '3014451', '3014459', '3014460', '3014462', '3014466', '3014467', '3014471', '3014475', '3014394', '3014477', '3014478', '3014479', '3014481', '3014492', '3014464', '3014500', '3014505', '3014506', '3014507', '3014497', '3014534', '3014535', '3014543', '3014562', '3014564', '3014565', '3014560', '3013298', '3014570', '3014572', '3014573', '3014576', '3014578', '3014581', '3014582', '3014583', '3014588', '3014598', '3014599', '3014600', '3014603', '3014607', '3014613', '3014615', '3014618', '3014619', '3014623', '3014626', '3014627', '3014628', '3014630', '3014631', '3014635', '3014636', '3014640', '3014641', '3014642', '3014643', '3014647', '3014651', '3014652', '3014654', '3014658', '3014660', '3014661', '3014662', '3014670', '3014673', '3014674', '3014675', '3014676', '3014200', '3014677', '3014685', '3014686', '3014690', '3014483', '3014705', '3014707', '3014708', '3014712', '3014715', '3014716', '3014721', '3014722', '3014723', '3014725', '3014727', '3014729', '3014735', '3014739', '3014610', '3014659', '3014743', '3014744', '3014759', '3014763', '3014766', '3014767', '3014771', '3014773', '3014774', '3014779', '3014780', '3014781', '3014782', '3014893', '3015194', '3014783', '3014784', '3014786', '3014184', '3014787', '3014788', '3014664', '3014793', '3014795', '3014811', '3014796', '3014797', '3014798', '3014800', '3014810', '3014815', '3014819', '3014802', '3014826', '3014827', '3014830', '3014832', '3014834', '3014823', '3014835', '3014836', '3014838', '3014841', '3014844', '3014846', '3014849', '3014850', '3014851', '3014856', '3014857', '3014858', '3014859', '3014861', '3014869', '3014871', '3014873', '3014875', '3014882', '3014883', '3014884', '3014887', '3014888', '3014890', '3014896', '3014897', '3014898', '3014899', '3014905', '3014906', '3014909', '3014915', '3014920', '3014922', '3014923', '3014924', '3014933', '3014935', '3014936', '3014937', '3014938', '3014941', '3014942', '3014943', '3014945', '3014946', '3014948', '3014949', '3014952', '3014955', '3014957', '3014958', '3014959', '3014960', '3014961', '3014963', '3014964', '3014965', '3014966', '3014969', '3014608', '3014972', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3014984', '3014990', '3014992', '3014998', '3015001', '3015007', '3015008', '3015009', '3015010', '3015011', '3015012', '3015013', '3015014', '3015015', '3015016', '3015017', '3014337', '3015023', '3015024', '3015027', '3015033', '3014442', '3015042', '3015051', '3015053', '3015054', '3015056', '3015060', '3015068', '3015070', '3015073', '3014806', '3015074', '3015080', '3015082', '3015083', '3015091', '3015094', '3015095', '3015100', '3015102', '3015111', '3015112', '3015120', '3015121', '3014580', '3015131', '3015140', '3015143', '3015144', '3015145', '3015147', '3015148', '3015149', '3015150', '3015151', '3015155', '3015157', '3015158', '3015162', '3015165', '3014415', '3015170', '3015172', '3015173', '3015174', '3015175', '3015176', '3015178', '3015180', '3015182', '3015184', '3015187', '3015188', '3015195', '3015198', '3015197', '3015204', '3014440', '3015205', '3015208', '3015261', '3015264', '3015266', '3015284', '3014423', '3015292', '3015293', '3015294', '3015297', '3015300', '3015303', '3015306', '3015307', '3015251', '3015221', '3015222', '3015224', '3015225', '3015244', '3015245', '3015246', '3015247', '3015248', '3015276', '3015313', '3015314', '3015315', '3015316', '3015317', '3015318', '3015319', '3015320', '3015325', '3015328', '3015329', '3015331', '3015333', '3014926', '3015356', '3015357', '3015360', '3013268', '3015365', '3015369', '3015370', '3015371', '3015377', '3015378', '3015384', '3015385', '3014867', '3015393', '3015394', '3015395', '3015396', '3015399', '3015401', '3015403', '3015404', '3015405', '3015409', '3015413', '3015414', '3015417', '3015424', '3015425', '3015426', '3015429', '3015432', '3015437', '3015443', '3015132', '3015451', '3015452', '3015453', '3015457', '3015460', '3014644', '3015464', '3015469', '3015473', '3015477', '3015475', '3015481', '3015482', '3015484', '3015499', '3015500', '3015501', '3015502', '3015508', '3015514', '3015521', '3015523', '3015525', '3015529', '3015531', '3015532', '3015537', '3015538', '3015540', '3015542', '3015547', '3015548', '3015549', '3015550', '3015554', '3015555', '3015558', '3015559', '3015562', '3015563', '3015564', '3015570', '3015571', '3015572', '3015575', '3015576', '3015580', '3015582', '3015584', '3015590', '3015596', '3015600', '3015601', '3015605', '3015607', '3015608', '3015402', '3015610', '3015615', '3015616', '3015621', '3014820', '3015623', '3015624', '3015628', '3015629', '3015631', '3015635', '3015636', '3015638', '3015639', '3015642', '3015374', '3015649', '3015650', '3015653', '3015654', '3015655', '3015657', '3015659', '3015662', '3015668', '3015674', '3015681', '3015684', '3015687', '3015688', '3015695', '3015699', '3015700', '3015701', '3015702', '3015703', '3015704', '3015705', '3015706', '3015708', '3015710', '3015712', '3015709', '3015716', '3015718', '3015721', '3015722', '3015723', '3015724', '3015725', '3015730', '3015733', '3015740', '3015748', '3015753', '3015754', '3015755', '3015764', '3015765', '3015766', '3015769', '3015768', '3015772', '3015774', '3015775', '3015776', '3015780', '3015781', '3015785', '3015789', '3015792', '3015797', '3015801', '3015804', '3015598', '3015807', '3015811', '3015813', '3015814', '3015817', '3015822', '3015827', '3015833', '3015517', '3015835', '3015843', '3015335', '3015857', '3015861', '3015864', '3015867', '3015875', '3014657', '3015879', '3015880', '3015882', '3015887', '3015891', '3015893', '3015897', '3015899', '3015902', '3015904', '3015900', '3015507', '3015903', '3015911', '3015820', '3015912', '3015918', '3015923', '3015927', '3015930', '3015932', '3015935', '3015942', '3015944', '3015956', '3015959', '3015960', '3015962', '3015968', '3015981', '3015982', '3015985', '3015988', '3015989', '3015990', '3015991', '3015998', '3016010', '3016020', '3016025', '3016024', '3016026', '3016027', '3016030', '3016033', '3016036', '3016039', '3016040', '3016055', '3016058', '3016061', '3016062', '3016064', '3016066', '3016069', '3013940', '3016074', '3016079', '3016080', '3016088', '3016093', '3016097', '3016104', '3016108', '3016114', '3016115', '3016118', '3013984', '3016131', '3016134', '3016135', '3016136', '3016137', '3016138', '3016140', '3016146', '3016147', '3016149', '3016151', '3016153', '3016154', '3016157', '3014624', '3016158', '3016159', '3016160', '3015518', '3016162', '3016166', '3016167', '3016174', '3014822', '3016175', '3016181', '3016182', '3016184', '3016186', '3015898', '3016190', '3016194', '3016196', '3016201', '3016211', '3016212', '3016213', '3016219', '3016225', '3016226', '3016230', '3013194', '3016239', '3016241', '3016243', '3016120', '3016223', '3016254', '3016255', '3015527', '3015528', '3016257', '3016258', '3016259', '3016268', '3016269', '3016272', '3016273', '3016274', '3016276', '3016279', '3016286', '3016288', '3016289', '3016291', '3016296', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016314', '3016315', '3016316', '3016320', '3016321', '3016322', '3016323', '3016324', '3016328', '3016330', '3016334', '3016337', '3016338', '3016341', '3016342', '3016343', '3016344', '3016354', '3016359', '3016360', '3016362', '3016369', '3016370', '3016371', '3016372', '3016373', '3016374', '3016375', '3016383', '3016384', '3016363', '3016385', '3015231', '3016389', '3016392', '3016393', '3016394', '3016395', '3016396', '3016397', '3016398', '3016399', '3016402', '3016404', '3016412', '3016414', '3016416', '3016420', '3016423', '3016429', '3016430', '3015146', '3016436', '3016437', '3016440', '3016445', '3016446', '3016447')) AND (s.id IN ('3014947', '3013213', '3014589', '3014841', '3013244', '3014783', '3013284', '3013251', '3014748', '3013974', '3013279', '3013271', '3013202', '3014897', '3015209', '3015349', '3015442', '3015035', '3015523', '3015402', '3015766', '3015833', '3016182', '3016183', '3014822', '3014785')) 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		9	Using where; Using filesort

0.000357

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

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

0.000387

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3014783', '3015766', '3015523', '3015833', '3014822', '3014841', '3015402', '3014897', '3016182'))

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

0.000517

DESCRIBE `station_station_unit`

0.000567

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id IN ('6763', '4953', '1300', '5357', '6762', '5356', '1511', '1301', '5433', '1301', '1511', '4953', '5356', '5357', '5433', '6762', '6763', '1300', '5356', '1299', '5118', '5355', '6763', '4953', '5434', '1510', '6763', '4953', '5357', '1300', '6762', '1511', '5356', '1301', '5433', '1300', '1301', '1511', '4953', '5356', '5357', '6762', '6763', '1299', '1509', '1510', '5354', '5355', '5356', '6776', '1300', '1301', '1511', '4953', '5356', '5357', '5433', '6762', '6763', '1300', '1301', '1511', '4953', '5356', '5357', '5433', '6762', '6763', '1299', '1300', '1510', '5118', '5119', '5355', '5356', '5434', '6762', '6763'))

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

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

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

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

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

0.000797

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3014783', '3015766', '3015523', '3015833', '3014822', '3014841', '3015402', '3014897', '3016182'))

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

0.000417

SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('6763', '1301', '1300', '6763', '5357', '5355', '6763', '6763', '1299')) 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		6	Using where

0.000557

DESCRIBE `school_score`

0.030537

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id IN ('3014783', '3015766', '3015523', '3015833', '3014822', '3014841', '3015402', '3014897', '3016182')) 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		33408	Using index condition; Using where

0.000677

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3014783', '3015766', '3015523', '3015833', '3014822', '3014841', '3015402', '3014897', '3016182'))

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

0.000337

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

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

connect

0.000507

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

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

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

0.000647

DESCRIBE `summary_count_kuchikomi`

0.000437

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 = 14) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id = '5356') AND (s_c_k.station_unit_id = 0) 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.000487

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

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

DESCRIBE `dancer_column`

0.000437

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

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

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

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

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

Message	Memory use
Component initialization	2.16 MB
Controller action start	2.40 MB
Controller render start	5.33 MB
View render complete	6.20 MB

Timers

Total Request Time: 231 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	7.72
Event: Controller.initialize	0.67
Event: Controller.startup	0.30
Controller action	112.70
Event: Controller.beforeRender	53.89
» Processing toolbar data	50.76
Rendering View	29.57
» Event: View.beforeRender	0.75
» Rendering APP/View/SchoolList/index.ctp	15.95
» » Rendering APP/View/Elements/breadcrumb.ctp	0.27
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.08
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	7.10
» » Rendering APP/View/Elements/__searchlink/main-column-station-unit.ctp	0.57
» » Rendering APP/View/Elements/school-box.ctp	1.30
» » » Rendering APP/View/Elements/adsense/336_288.ctp	0.09
» » Rendering APP/View/Elements/school-box.ctp #2	0.35
» » Rendering APP/View/Elements/school-box.ctp #3	0.37
» » Rendering APP/View/Elements/school-box.ctp #4	0.37
» » Rendering APP/View/Elements/school-box.ctp #5	0.33
» » Rendering APP/View/Elements/school-box.ctp #6	0.35
» » Rendering APP/View/Elements/school-box.ctp #7	0.35
» » Rendering APP/View/Elements/school-box.ctp #8	0.26
» » Rendering APP/View/Elements/school-box.ctp #9	0.48
» » » Rendering APP/View/Elements/adsense/336_288.ctp #2	0.06
» » Rendering APP/View/Elements/paginator.ctp	0.07
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	11.80
» » Rendering APP/View/Elements/header.ctp	0.34
» » Rendering APP/View/Elements/menu.ctp	9.01
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	8.81
» » » » Rendering APP/View/Elements/__searchlink/right-menu-category.ctp	0.27
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.08
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	7.62
» » » » 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.91
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.08
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
  categorySlugother
  2(array)
  name東京都
  link(array)
  controllerschool_list
  actionindex
  categorySlugother
  prefectureId12
  3(array)
  name新宿区
  link(array)
  controllerschool_list
  actionindex
  categorySlugother
  prefectureId12
  cityId745
  4(array)
  name新宿三丁目駅周辺
  link
- metaKeywordStringその他のダンス,新宿三丁目,新宿区,東京都,ダンススクール,ダンス教室
- headString新宿三丁目付近のその他のダンス　ダンススクール、ダンス教室
- metaDescriptionその他のダンスのレッスンを行う新宿三丁目（東京都新宿区）付近のダンススクール、ダンス教室(9件)の口コミ評判ランキング。9件のダンスレッスン体験談からあなたに合ったスクールを探し出せます！
- title_for_layoutその他のダンスのレッスンを行う新宿三丁目付近のダンススクール、ダンス教室
- SchoolSet(object)
  0(object)
  id3014783
  nameNOAダンスアカデミー新宿校
  branch_name
  city_id745
  schoolgroup_id(null)
  mail_addressdesigner@kknoah.co.jp
  lat35.693298400000
  lon139.698236100000
  telephone_number03-3344-5600
  homepage_urlhttp://www.noadance.com/
  mobile_homepage_urlhttp://www.noadance.com/i
  blog_url
  open_hour
  holiday
  post_code(null)
  town_address西新宿1-3-14
  building新宿プラザ2F
  image_hash9a057f837710345f
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title都営大江戸線　新宿西口駅D4出口すぐ！
  message_bodyJR新宿西口を出て、駅構内右方向に進み、都営大江戸線内にあるD4出口から地上に出ればもう目の前！地上からでも大ガード交差点のすぐ近くと好立地！今、シーンで注目の人気ダンサーによる満足度十分のレッスンが勢揃いなので中〜上級者はさらなるレベルアップ間違いなしです。もちろん超入門や入門クラスもあるので、ダンスがはじめての方でも安心して楽しく通うことができます。ぜひ一度スタジオまで遊びに来て下さい。
  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
  score3.67
  kuchikomi_count3
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:06:46
  memo(null)
  1(object)
  id3015766
  nameチアダンススクール SKY WINGS
  branch_name新宿 noa スタジオ
  city_id745
  schoolgroup_id(null)
  mail_addressskywings1085@gmail.com
  lat35.6933123
  lon139.6982638
  telephone_number03-6908-9922
  homepage_urlhttp://skywings.net/
  mobile_homepage_url
  blog_urlhttp://skywings.net/blog/
  open_hour16:00～21:00
  holiday
  post_code160-0023
  town_address西新宿1-3-14
  building新宿プラザ 3F
  image_hash367848fc2998cd68
  image_extension_type2
  message_image_hash3860511a80415ffe
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title園児から大人まで皆様がチアダンスを体験できます!!
  message_bodySKY WINGSは新宿区を活動拠点とするチアダンススクール(Cheer Dance School)です。初心者の方が多く、和気あいあいとした雰囲気でレッスンを行っております。プロ野球チームのチアダンサーや、歌手のバックダンサーを経験したインストラクターと一緒に踊る楽しさ、応援する楽しさを体感できます。チアダンスは他人を元気にできる数少ないダンスジャンルです。他人を元気にするためには自分も元気でなくてはなりません。故に、チアダンスは自らを元気に保ってくれるダンスではないでしょうか。昨今中学校でダンスが教育プログラムとして導入され、日本ではダンスを始めるお子様がが増えています。チアダンスはダンスが苦手な方でも誰でも踊ることができるダンスですので、皆様もぜひSKY WINGSでチアダンスを始めてみませんか！？
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleAYAKA
  whole_staff_introduction15歳でJAZZ＆ヒップホップダンスを始め、バレエ、コンテンポラリーダンスを経験。 ■Lavieバックダンサー出演 ■AED普及ミュージカル出演 ■現在野球球団にてプロチアダンサーとして活躍中趣味はディズニーランドに行くことです!!
  whole_staff_image_hash11a93dd0905cad1f
  whole_staff_image_extension_type2
  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_created2015-01-09 02:01:26
  timestamp_modified2021-08-03 15:07:52
  memo(null)
  2(object)
  id3015523
  nameフィットネスクラブ　モンキージム
  branch_name
  city_id745
  schoolgroup_id(null)
  mail_addressgym@monkeygym.jp
  lat35.6881772
  lon139.7116321
  telephone_number0363805906
  homepage_urlhttp://monkeygym.jp/
  mobile_homepage_urlhttp://monkeygym.jp/
  blog_url
  open_hour朝7時～深夜1時（土、日、祝を除く）
  holiday第３日曜日
  post_code162-0022
  town_address新宿1-4-13
  building溝呂木ビル2階
  image_hashb121bcecc32daf71
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_titleスタジオ充実のフィットネスクラブ
  message_body新宿御苑駅徒歩1分！駅前のフィットネスクラブ　モンキージムですジム内には、スタジオエリアを設けておりHIPHOP教室、ジャズダンス、ベリーダンス、ヨガ等充実したプログラムをご用意しております。無料見学・体験もできますので是非1度お問い合わせ下さい ※詳細についてはホームページをご覧下さい。レンタルスタジオも行ってます。メンバーやお友達とのレッスンにもご利用頂けます。 1時間２，０００円～（別途消費税）
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title(null)
  whole_staff_introduction(null)
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type3
  has_kids_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2014-02-28 22:23:16
  timestamp_modified2021-08-03 15:07:36
  memo(null)
  3(object)
  id3015833
  nameburlesque & jazzhiphop
  branch_name
  city_id745
  schoolgroup_id(null)
  mail_addressmds@aecy.com
  lat35.6944776
  lon139.6990748
  telephone_number08090910103
  homepage_urlhttp://youtu.be/sFP4InhTReg
  mobile_homepage_url
  blog_urlhttp://mds@aecy.com
  open_hour毎週火曜日11時〜12時。毎週木曜日11時〜12時半。
  holiday
  post_code(null)
  town_address西新宿1-3-14 新宿プラザ3F
  building
  image_hashc13c055f331e68dc
  image_extension_type2
  message_image_hash0078a6f17bfc38f0
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleburlesque & jazzhiphop
  message_bodytokiko & mina のダンスレッスンが5月より始まります！セクシーなバーレスクダンスとla仕込みのジャズヒップホップを融合させたレッスンで、あなたの女性らしさや、魅力をゆっくりしっかり引き出します。毎週火曜 11時〜12時バーレクササイズ（初心者や、体を動かしたい人向け）バーレスクの動きをメインに60分ノンストップの動きで練習していきます。日頃体を動かすことがあまりない人も、週一回しっかり汗をかけます。楽しみながらダンスをしていくクラスなので、ダンス未経験者さんや初心者さんにも安心！ダイエットにも自分磨きにもなるはず。毎週木曜 11時〜12時半 jazz hiphop & バーレクササイズ（ダンス経験者向けの振付クラス）かっこよくパワフルなジャズヒップホップの動きと、セクシーなバーレスクを混ぜて、大人の女性ならではの洗練されたダンスを目指します。アップでは、ダンサーに必要な体作りをしっかり行います。踊っているときの目線やウォーキング、指先から足先までを意識しながら、その人の持っている良さを引き出し、女性らしいダンスを習得していくクラスです。料金体制入会手数料 3000yen ／体験レッスン 1000yen／1レッスン2500yen お財布にも優しい、月謝制もあり！しかも振替可能。火曜6000yen/木曜8000yen 注: 料金は税抜き表示となっております。注：祝日、第5週目を除く毎週となります。月謝は4回分のおまとめ料金です。講師：tokiko ロサンゼルスではアーティストmv、2003 beyonce dancer audition 最終選考、mtv movie award 「t.a.t.u」ダンサー。日本では数々の舞台、cm : 武富士（1995-2001）ジムケリー、ダイエットcokeに出演。倖田來未: キューティーハニー、crazy4U、chase、selfishなど振付、ダンサー。その他数々のアーティスト、ダンサーの指導。講師；mina ダンス歴20年、講師歴10年。本場アメリカで6年間ダンスを学び、現地では全米放送tv番組 soul train、mtv2 cmなどに出演。帰国後は倖田來未pv、b'z ドームツアー、girl next doorダンサーとして紅白歌合戦などに出演。振付は川島海荷率いるガールズユニット9nineの20曲など。過去500人以上のダンサーやタレント、モデル、歌手に指導。経験豊富な2人の講師が、生徒さんの個性を生かしつつ、ダンス上達のお手伝いをします。初心者から上級者まで対応可。楽しみながらダンスを練習しましょう！開催場所新宿ノアスタジオ東京都新宿区西新宿1-3-14 新宿プラザ3階アクセス快適！新宿駅西口より徒歩4分！連絡先 tel: 080-9091-0103 生徒の声（n.mさん）レッスンを習い始めてから、自分に自信を持てるようになりました。レッスンで習う事を身につければ、普段の生活シーンでも自然とキレイでいられるのではと考えるようになり、もはやダンスという観点ではなく、私の人生にとってとても奥深いものに変わっていきました。今ではなくてはならない大切なものです。
  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_course0
  score0.00
  kuchikomi_count0
  timestamp_created2015-04-16 07:14:14
  timestamp_modified2021-08-03 15:07:56
  memo(null)
  4(object)
  id3014822
  nameアロック・DD・C
  branch_name
  city_id745
  schoolgroup_id(null)
  mail_addressalok@art.email.ne.jp
  lat35.6990394
  lon139.6989969
  telephone_number03-5386-8192
  homepage_urlhttps://alok7513.wixsite.com/mysite
  mobile_homepage_urlhttps://alok7513.wixsite.com/mysite
  blog_url
  open_hourダンストレーニングレッスン水・土13～16時/リフレッシュダンスレッスン土17:15～19:15
  holiday
  post_code169-0073
  town_address百人町1-13-9
  buildingアロック
  image_hash127fba60c28182d3
  image_extension_type2
  message_image_hash335190d2827dfca8
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleただいま体験1000円キャンペーン中！ 2018/4月末まで
  message_body二種類のレッスン★体験キャンペーン中！（2018/4月末まで） ★初回体験料1000円！　さらに体験当日入会金半額！基礎もしっかり習える教室をお探しの方へ二種類のレッスン★初心者対応・プロも通うダンスクラスアクセス抜群◎新宿の通いやすい好立地！詳しくはお問い合わせください（体験レッスン：要予約） https://alok7513.wixsite.com/mysite/dance-lesson ①アロックダンストレーニングレッスンあらゆる表現に必要不可欠な体創りのレッスンアロックオリジナルメソッド【柔流（ジュール）】による、体軸を鍛える事に特化した基礎トレーニングクラスです。 ◆もっと上達したい ◆基礎をしっかりやりたい ◆身体の使い方を見直したい ◆さらに動けるようになりたい ◆リズム感をよくしたい ◆ターンが回れるようになりたい ◆体で表現したい ◆パフォーマンス度をあげたい ◆健全な体が欲しい　　etc...の希望に即した、マンツーマンのような丁寧な指導が好評です。全ては自分の身体を知ることから始まります。どんなモノにも必ずバランスがある様に、人の体にもバランスはあります。その一番の核となるセンターを意識して鍛える事で『自由な身体』に近づけます。一緒に自身の『カラダ』の発見をしませんか？ ■日時毎週水･土13:00～16:00（アロック公演前は12:00～15:00へ時間変動あり） ■料金 ★キャンペーン期間（～2018/4月末）★初回体験レッスン1,000円☆体験当日入会金5,000円！《通常時》 ☆ビジター（一回）　※入会者2800円／未入会3500円 ☆月謝（※入会者のみ）　8回分20,000円/半月謝（4回分）10000円 ※入会金10000円 ②リフレッシュダンスレッスン ★初回体験料500円！☆さらに体験日入会金0円！アロックオリジナルメソッド【柔流（ジュール）】を取り入れ、「呼吸する」事を意識したダンスを接点に身体の活性化を目的とした楽しいクラス。【こんな方々に！】　　　　　　　　 ◎体がかたい ◎運動不足やストレスを解消したい ◎ダンスで若々しく ◎踊って楽しく健康になりたいお気軽にお越しください。一緒に『カラダ』を楽しみましょう！ ■内容 ☆ストレッチ ☆アロックオリジナル基礎エクササイズ「柔流（ジュール）」 ☆ダンスウォーキング・コンビネーション ☆振付など ■日時：毎週土曜日夕方17:15～19:00 ■料金 ★キャンペーン期間（～2018/4月末）★初回体験レッスン1,000円☆体験当日入会金5,000円！《通常時》 ☆ビジター（一回）　※入会者2,200円／未入会2,700円 ☆5回チケット（※入会者のみ）　10,000円 ※入会金10,000円お気軽にお越しください。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title須貝哲也（アロック代表/ダンサー/演出・振付・構成家）
  whole_staff_introduction確かな表現力と存在感に定評を持ち、長身と中性的な雰囲気で魔物的な役柄を得意とする個性派ダンサー。 1984年よりALOK入団以降、国内外（ニューヨーク、シドニー、シンガポール、ロシア、台湾、等）のALOK全公演に出演、1990年から主役・ストーリーテラーの役割を担ってきた。 1998年からアトリエ公演を中心に振付・演出・構成家としても活動。暖かくもシニカルに人間味を深く掘り下げる独特の世界観に評価が高い。 1987年銀座博品館劇場主催第1回ダンスコンクール金賞（出演） 1998年日本振付家協会主催　第3回全日本振付コンクール第3位（振付） 1999年Tokyo Public Theatre「Theatre Punk」（振付及び審査員）現在は新宿アトリエにて作品創りおよび後続育成、外部ではコラボや振付活動を精力的に展開中。
  whole_staff_image_hashb85a26ada73ce32a
  whole_staff_image_extension_type2
  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:48
  memo(null)
  5(object)
  id3014841
  nameスタジオアルグール
  branch_name
  city_id744
  schoolgroup_id(null)
  mail_addressushas@alghul.com
  lat35.687318700000
  lon139.703710700000
  telephone_number090-6118-9736
  homepage_urlhttp://alghul.com
  mobile_homepage_urlhttp://alghul.com
  blog_urlhttp://ameblo.jp/studioalghul
  open_hour13:00-22:00
  holiday日曜日
  post_code(null)
  town_address千駄ヶ谷5-33-16
  buildingシャトレー新宿御苑I、204号
  image_hashf637f03f6e7b0119
  image_extension_type2
  message_image_hash6a36ce3ebfbe8b0b
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleダンス未経験・運動が苦手・・・だけど踊りた～い!!!方へ☆
  message_bodyベリーダンススクール「スタジオアルグール」 JR新宿駅新南口から徒歩3分！地下鉄副都心線新宿三丁目駅・大江戸線orJR代々木駅からも便利な立地。ベリーダンサーUSHAS主宰少人数制・完全予約制。アットホームな雰囲気です。一人一人の個性やお身体の癖に合わせた丁寧な指導を心がけています。わからないことがありましたら気軽にスタッフにお問い合わせください！皆さんが踊れる・見られるパーティなどたくさんございます♪ 楽しみながら学びましょう～☆彡
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleUSHAS
  whole_staff_introduction名前：USHAS（ウシャス、ウシャ）職業：舞踊家、インストラクター、振付師、Studio Alghul主宰、株式会社Alghul代表取締役 WEBSITE: http://ushas.jp/ BLOG： http://blog.ushas.jp/ ☆経歴：東京外国語大学在学中にベリーダンスに出会い、小松芳はじめ国内外のダンサーに師事。エジプシャンスタイルを基礎に置きつつ、トライバルフュージョンやジプシースタイルのパフォーマンスなども行う。持ち前の身体能力と想像力を活かした表現には定評がある。 2005年ダンサー、インストラクター活動開始 2009年3月株式会社Alghul設立 2009年4月Alghul studio & cafebar（六本木）開始 2010年7月六本木から新宿（代々木）に拠点を移し名称をStudio Alghulに変更 2010年〜現在国内外各地でレッスン・ショー・イベントを展開
  whole_staff_image_hash14ff3e01ce6fb0f1
  whole_staff_image_extension_type2
  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:50
  memo(null)
  6(object)
  id3015402
  nameONEゴスペルダンススクール
  branch_name
  city_id745
  schoolgroup_id(null)
  mail_addressonegospel1@gmail.com
  lat35.694621744831174
  lon139.69643779052967
  telephone_number
  homepage_urlhttp://onegospel.wix.com/dance
  mobile_homepage_url
  blog_url
  open_hour土11:00~14:00 日17:00~19:00
  holiday
  post_code
  town_address西新宿７ー９－１７
  building
  image_hash9fd3fc21588bef08
  image_extension_type2
  message_image_hashd59aaf5a837a45c8
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title日本で初めての総合ゴスペルダンススクール！
  message_bodyゴスペルダンスとは聖書のメッセージを込めたダンスのことで、ゴスペルダンスとして誕生したジャンルに、アメリカで良く踊られているマイムやプレイズダンス、ハワイのサインダンスやゴスペルフラ、シンガポールで盛んなタンバリンやフラッグなどがありますが日本ではほとんど知られていません。他にも、日本でも大流行のフラダンスやヒップホップもゴスペルのメッセージを込めて踊ると、インパクトがあり感動的な「ゴスペルダンス」に生まれ変わります。 ONEゴスペルダンススクールはそんなゴスペルダンスのすばらしさを日本に紹介するため、また次世代のリーダーたちを育成するために誕生しました！
  is_detail_address_opening0
  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_created2013-10-30 01:22:01
  timestamp_modified2021-08-03 15:07:27
  memo(null)
  7(object)
  id3014897
  nameアイドル合衆国
  branch_nameしんじゅく教室
  city_id745
  schoolgroup_id114
  mail_addressh-hasegawa@studio-evah.com
  lat35.694572020903
  lon139.698099151282
  telephone_number048-782-9960
  homepage_urlhttp://idol.studio-evah.com/price_shinjuku.html
  mobile_homepage_url
  blog_url
  open_hour第2第4日曜日　14時～15時　歌　　　15時～16時　振り付け
  holiday
  post_code(null)
  town_address東京都新宿区西新宿７丁目９－１７
  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(null)
  message_body(null)
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title(null)
  whole_staff_introduction(null)
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:06:54
  memo(null)
  8(object)
  id3016182
  namemillionDANCESTUDIOTOKYO
  branch_name
  city_id744
  schoolgroup_id(null)
  mail_addressinfo@million.tokyo
  lat35.6849384
  lon139.701475
  telephone_number03-6300-7642
  homepage_urlhttp://million.tokyo/
  mobile_homepage_urlhttp://million.tokyo/
  blog_urlhttps://www.instagram.com/million__tokyo/
  open_hour10:30-23:00
  holiday年末年始
  post_code151-0053
  town_address代々木1-57-1
  building代々木センタービル3F&4F
  image_hashf73cf1188a01f962
  image_extension_type2
  message_image_hash7e929f66fd897cf1
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titlemillionとは…
  message_bodymillion DANCE STUDIO TOKYOは、繋がりや広がりを大切にし、常に広い視野を持ち、前進しながらも、安心してダンスを感じられる環境づくりを目指しています。 ★LESSONが毎週約120クラス。 ★ダンスジャンルは15種類!! ★120名以上の有名講師が在籍。 ★個人ロッカー有り。 ★シャワールーム有り。 ★更衣室、パウダールーム有り。 ★未経験者、経験者共に歓迎!! ☆アクセスも良好☆ 新宿駅新南口⇒徒歩5分代々木駅北口⇒徒歩1分通常LESSON以外にも、ワークショップやイベント等を定期的に開催中!! 「ダンス」というものが秘めたパワーを、是非、million DANCE STUDIO TOKYOでご体感下さい!! お客様・講師・スタッフ・全ての人にとって、価値あるダンスライフをご提供致します。
  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_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2017-09-26 22:33:32
  timestamp_modified2021-08-03 15:08:19
  memo(null)
- SchoolPager(object)
  0(object) - recursion
  1(object) - recursion
  2(object) - recursion
  3(object) - recursion
  4(object) - recursion
  5(object) - recursion
  6(object) - recursion
  7(object) - recursion
  8(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)
  id15
  name国立・府中・国分寺
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  13(object)
  id16
  name立川・八王子・青梅
  prefecture_id12
  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)
  id6
  nameサルサ
  slugsalsa
  descriptionサルサとはキューバ発祥のラテン音楽の一つで、サルサミュージックに合わせて踊るダンスの事をサルサダンスといいます。サルサダンスは男女がペアになって男性リードで踊るペアダンスで、ペアダンスの中でも踊るスピードが速いのが特徴です。キューバンスタイルやNYスタイル、LAスタイルなど、ダンスや音楽の特徴でいくつかの種類に分かれます。
  5(object)
  id7
  nameフラメンコ
  slugflamenco
  descriptionスペイン南部のアンダルシア地方に伝わる文化で、歌・踊り・ギターによる伴奏の総称をフラメンコと言います。日本ではフラメンコ＝踊りという印象が強いですが、元々はフラメンコの真髄は歌だと言われています。手足またはカスタネットを使って音を出しリズムを作りながら情熱的に踊ります。観客による掛け声での合いの手による盛り上げなども重要な要素と言わており、逆に手拍子などは音楽の妨げになる事からやってはいけない事とされています。
  6(object)
  id8
  nameフラダンス・タヒチアンダンス
  slughula
  descriptionハワイにおける民族舞踊をフラ、タヒチにおける民族舞踊をタヒチアンダンスと言い、両方ともポリネシアン地域の踊りです。フラとは「ダンス」を意味する言葉で、歌・踊り・楽曲を総称してフラと言います。フラは元々宗教的・教訓的な側面の強い踊りで、文字文化の無いハワイにおいて物語や教訓を後世に伝えていくという面も持ち合わせています。タヒチアンダンスは現地の言葉でオリタヒチと言い、このオリという言葉もやはり現地語でダンスという意味です。フラもオリタヒチもその内容によって更に種類が細分化されますが、一般的にはフラは複数人数でゆったりと優雅に踊るもの、タヒチアンダンスは腰を激しく振りながら踊るものという違いがあります。
  7(object)
  id9
  nameベリーダンス
  slugbelly
  description中東・アラブ地域で発展したダンススタイルの事を指し、アラブ文化圏ではラクス・シャルキー(東方の踊りの意味)やラクス・バラディ（民族舞踏の意味）と呼ばれる。ベリーダンスのベリーとはお腹を意味するbellyだとされ、お腹の動きが特徴的だという事からこの名称で呼ばれるようになったとされています。ベリーダンスは中東・アラブ地域のダンスの総称であるため、同じベリーダンスでもスタイルによっては衣装や音楽など、多くの面で違うものとなります。
  8(object)
  id10
  name社交ダンス
  slugsocial
  description儀式や舞台(ショー)向けのダンスではなく、男女のペアで楽曲に合わせて踊るペアダンスの事を社交ダンスと言います。社交ダンスは大きく分けるとワルツやタンゴに代表されるようなスタンダードと呼ばれるものと、サンバやルンバ、パソドブレといったラテンダンスに分類されます。社交ダンスという名称は元々sociality dancingの誤訳からできた言葉で、日本国内でのみSocial Danceという言葉が利用されています。英語では一般的にBallroom Dance(ボールルームダンス＝舞踏室の踊り)とあらわされ、競技ダンスなども社交ダンスと言われます。
  9(object)
  id12
  name民族舞踊・フォークダンス
  slugfolk
  description民族間で伝承されてきたダンス全般の事を指して、民族舞踏といいます。日本においては日本舞踏のほか、盆踊りやよさこいなどの伝統的なものも全て民族舞踏の一つで、ハワイにおけるフラや中東におけるベリーダンスも民族舞踏です。民族舞踏はそれぞれの地域における地理的な環境や言語的な特徴など、様々な要因によって作られてきており、民族舞踏を学習する事でその国の文化などに触れ、理解をする事が出来ます。
  10(object)
  id13
  nameキッズダンス教室
  slugkids
  descriptionダンスは言葉を用いないで自己表現をするための一つの手段であり、ダンスを学ぶ事で表現力を養う事や自信を持つことが出来る等点から、キッズダンスを習得させる家庭は増加傾向にあります。また、小中学校におけるダンスの教育義務化などもあり、習い事の一つとしてダンス教室はとても重要なものとなってきています。最近ではキッズダンサー向けのダンス大会なども頻繁に開催されていて、ただ習うだけではなく活躍する機会も今後さらに増えていくのではないでしょうか。
  11(object)
  id14
  nameその他のダンス
  slugother
  description
  12(object)
  id17
  nameK-POP
  slugkpop
  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 => '18.216.190.167'
	)
)
$oddTrOptions = array(
	'class' => 'odd'
)
$evenTrOptions = array(
	'class' => 'even'
)
$useCount = false
$continueOddEven = false
$count = (int) 18
$line = array(
	(int) 0 => 'QWINTET_IP',
	(int) 1 => array(
		(int) 0 => '122.216.11.82'
	)
)
$cellsOut = array(
	(int) 0 => '<td>QWINTET_IP</td>'
)
$i = (int) 0
$cell = array(
	(int) 0 => '122.216.11.82'
)
$cellOptions = array()
$options = ' class="odd"'
$out = array(
	(int) 0 => '<tr class="odd"><td>SGV_ENV</td> <td>development</td></tr>',
	(int) 1 => '<tr class="even"><td>DEBUGKIT_ON</td> <td>1</td></tr>',
	(int) 2 => '<tr class="odd"><td>MENTE_FLAG</td> <td></td></tr>',
	(int) 3 => '<tr class="even"><td>SGV_APP_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/</td></tr>',
	(int) 4 => '<tr class="odd"><td>CONFIG_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Config/</td></tr>',
	(int) 5 => '<tr class="even"><td>LIB_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/</td></tr>',
	(int) 6 => '<tr class="odd"><td>MODEL_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Model/</td></tr>',
	(int) 7 => '<tr class="even"><td>CLASS_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/class/</td></tr>',
	(int) 8 => '<tr class="odd"><td>THUMBLIB_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb</td></tr>',
	(int) 9 => '<tr class="even"><td>THUMBLIB_PLUGIN_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/</td></tr>',
	(int) 10 => '<tr class="odd"><td>DEFAULT_THUMBLIB_IMPLEMENTATION</td> <td>gd</td></tr>',
	(int) 11 => '<tr class="even"><td>USER_STATIC_SALT</td> <td>Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z</td></tr>',
	(int) 12 => '<tr class="odd"><td>SITE_TITLE</td> <td>ダンススクール・ダンス教室口コミ検索ネット</td></tr>',
	(int) 13 => '<tr class="even"><td>OPERATOR_MAIL_ADDRESS</td> <td>info@kuchi.info</td></tr>',
	(int) 14 => '<tr class="odd"><td>NO_REPLY_MAIL_ADDRESS</td> <td>no-reply@kuchi.info</td></tr>',
	(int) 15 => '<tr class="even"><td>RETURN_PATH__MAIL_ADDRESS</td> <td>errors@kuchi.info</td></tr>',
	(int) 16 => '<tr class="odd"><td>GOOGLE_API_KEY</td> <td>AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0</td></tr>'
)
HtmlHelper::tableCells() - CORE/Cake/View/Helper/HtmlHelper.php, line 867
HtmlToolbarHelper::table() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 160
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 125
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108
ToolbarHelper::table() - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
include - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
include - ROOT/plugins/DebugKit/View/Elements/debug_toolbar.ctp, line 45
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
HtmlToolbarHelper::send() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 193
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 119
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108

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

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	/other/station_5356
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/other/station_5356
Remote Port	56018
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	18.216.190.167
Server Port	443
Server Addr	183.90.231.12
Server Name	www.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	18.216.190.167
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	www.dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	18.216.190.167
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZiGXSZRiaD0IWFads-S18AAAAQ8
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	ZiGXSZRiaD0IWFads-S18AAAAQ8
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713477449.1955
Request Time	1713477449

====

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/ToStationUnitPage.php
  12APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  13APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
  14APP/class/Sgv/Front/AttachableToDataSet/City.php
  15APP/class/Sgv/Front/PrefectureAttachment/ToSchoolSet.php
  16APP/class/Sgv/Front/AttachableToDataSet/Prefecture.php
  17APP/class/Sgv/Front/StationUnitAttachment/ToSchoolSet.php
  18APP/class/Sgv/Front/AttachableToDataSet/StationUnit.php
  19APP/class/Sgv/Front/MajorCityAttachment/ToSchoolSet.php
  20APP/class/Sgv/Front/AttachableToDataSet/MajorCity.php
  21APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
  22APP/class/Sgv/Front/AttachableToDataSet/Station.php
  23APP/class/Sgv/Front/SchoolScoreAttachment/ToSchoolSet.php
  24APP/class/Sgv/Front/AttachableToDataSet/SchoolScore.php
  25APP/class/Sgv/Front/CategorySchoolAttachment/ToSchoolSet.php
  26APP/class/Sgv/Front/AttachableToDataSet/CategorySchool.php
  27APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  28APP/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 東京都の主要なエリア

School List 新宿三丁目(東京都)のダンススクールランキング(その他のダンス)
1〜9件を表示／9件

NOAダンスアカデミー新宿校

チアダンススクール SKY WINGS 新宿 noa スタジオ

フィットネスクラブ　モンキージム

burlesque & jazzhiphop

アロック・DD・C

スタジオアルグール

ONEゴスペルダンススクール

アイドル合衆国しんじゅく教室

millionDANCESTUDIOTOKYO

»Category Search カテゴリー検索

Special Column

Memory

Timers

新宿三丁目付近のその他のダンス ダンススクール、ダンス教室

Search Result 検索結果

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

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

School List 新宿三丁目(東京都)のダンススクールランキング(その他のダンス) 1〜9件を表示／9件

»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〜9件を表示／9件