ダンススクール・ダンス教室の口コミやレッスン情報探すなら口コミ検索ネット

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key956261c398e451b81bf6dafbe39ec4dfbde6c4f0
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  506579cbf060de54bfb7b0be0abb9eee9e3def8c1765708360
  6366552d11f5faa1ca236fcbb4f28b2db569cb4b1765708361
  3cde1ea34a5724e913b551a81c6fb5f0ec28abfa1765708362
  78df099469f49d81ab582b928054d0efe7dd01481765708362
  8616f3ecd1d78c27c75a65a736ba09c9be1a0d6e1765708362
  956261c398e451b81bf6dafbe39ec4dfbde6c4f01765708363
====
Request
+
Request

Cake Params
- plugin(null)
- controllerhome
- actionindex
- named(array)
  prefectureId18
- pass(empty)
- _Token(array)
  key956261c398e451b81bf6dafbe39ec4dfbde6c4f0
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(empty)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 65 queries / 0.097857 sec

No.

time

query

0.001827

connect

0.000587

DESCRIBE `summary_count_school`

0.001117

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

DESCRIBE `school`

0.020857

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.is_charged = 1) AND (s.image_hash IS NOT NULL) AND (s.image_extension_type IS NOT NULL) AND (s.message_title IS NOT NULL) AND (s.message_body IS NOT NULL) ORDER BY `s`.`score` DESC LIMIT 50

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index		ix_score_school	6		50	Using where

0.002007

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.image_hash IS NOT NULL) AND (s.image_extension_type IS NOT NULL) AND (s.message_title IS NOT NULL) AND (s.message_body IS NOT NULL) AND (s.score >= 3) AND (s.is_charged = 0) ORDER BY `s`.`score` DESC LIMIT 50

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	ix_score_school	ix_score_school	6		234	Using index condition; Using where

0.000667

DESCRIBE `category_school`

0.000427

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

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

0.000527

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

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

0.000397

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

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

0.000517

DESCRIBE `city`

0.000387

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('1938', '921', '782'))

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

0.001467

DESCRIBE `prefecture`

0.000487

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3015076', '3015167', '3015110'))

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

0.005407

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) ORDER BY `timestamp_created` DESC LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL					4031	Using where; Using filesort

0.000447

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('724', '1189', '782', '884', '1413'))

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

0.000477

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3016525', '3016524', '3016523', '3016522', '3016521'))

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

0.003567

SELECT `s`.`id` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL					4031	Using where

0.000667

DESCRIBE `kuchikomi`

0.006127

SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013172', '3013173', '3013175', '3013176', '3013177', '3013179', '3013180', '3013181', '3013182', '3013183', '3013184', '3013185', '3013186', '3013187', '3013188', '3013189', '3013190', '3013191', '3013192', '3013193', '3013194', '3013195', '3013198', '3013199', '3013200', '3013201', '3013208', '3013209', '3013210', '3013211', '3013212', '3013213', '3013214', '3013215', '3013216', '3013219', '3013220', '3013221', '3013222', '3013223', '3013224', '3013225', '3013226', '3013227', '3013228', '3013229', '3013230', '3013234', '3013235', '3013236', '3013237', '3013238', '3013239', '3013240', '3013241', '3013242', '3013243', '3013244', '3013245', '3013246', '3013247', '3013248', '3013250', '3013252', '3013253', '3013254', '3013256', '3013258', '3013259', '3013260', '3013261', '3013262', '3013264', '3013265', '3013266', '3013268', '3013269', '3013271', '3013272', '3013275', '3013276', '3013277', '3013278', '3013279', '3013280', '3013281', '3013282', '3013283', '3013284', '3013285', '3013286', '3013287', '3013288', '3013290', '3013291', '3013292', '3013294', '3013295', '3013296', '3013297', '3013298', '3013301', '3013302', '3013303', '3013304', '3013306', '3013309', '3013311', '3013312', '3013313', '3013314', '3013315', '3013316', '3013317', '3013318', '3013319', '3013320', '3013321', '3013322', '3013324', '3013325', '3013326', '3013327', '3013328', '3013329', '3013330', '3013331', '3013332', '3013333', '3013334', '3013335', '3013336', '3013337', '3013338', '3013339', '3013340', '3013341', '3013342', '3013343', '3013344', '3013345', '3013346', '3013347', '3013348', '3013350', '3013351', '3013352', '3013353', '3013354', '3013355', '3013356', '3013357', '3013359', '3013360', '3013361', '3013362', '3013363', '3013364', '3013365', '3013366', '3013367', '3013368', '3013369', '3013370', '3013371', '3013372', '3013373', '3013374', '3013375', '3013376', '3013377', '3013378', '3013379', '3013380', '3013381', '3013382', '3013383', '3013384', '3013385', '3013386', '3013387', '3013388', '3013389', '3013390', '3013391', '3013392', '3013393', '3013394', '3013395', '3013396', '3013397', '3013398', '3013399', '3013400', '3013401', '3013402', '3013404', '3013405', '3013406', '3013407', '3013408', '3013409', '3013410', '3013411', '3013412', '3013413', '3013415', '3013416', '3013418', '3013419', '3013420', '3013421', '3013422', '3013423', '3013424', '3013425', '3013426', '3013427', '3013428', '3013429', '3013430', '3013431', '3013432', '3013433', '3013434', '3013435', '3013436', '3013437', '3013438', '3013440', '3013441', '3013442', '3013443', '3013444', '3013445', '3013446', '3013447', '3013448', '3013449', '3013450', '3013451', '3013452', '3013454', '3013455', '3013456', '3013457', '3013459', '3013460', '3013461', '3013463', '3013464', '3013465', '3013466', '3013467', '3013468', '3013469', '3013470', '3013471', '3013472', '3013473', '3013474', '3013475', '3013476', '3013477', '3013478', '3013479', '3013480', '3013482', '3013483', '3013484', '3013485', '3013486', '3013487', '3013488', '3013489', '3013490', '3013491', '3013492', '3013493', '3013494', '3013495', '3013496', '3013497', '3013498', '3013499', '3013500', '3013501', '3013502', '3013503', '3013504', '3013505', '3013506', '3013507', '3013508', '3013509', '3013510', '3013511', '3013512', '3013513', '3013514', '3013515', '3013516', '3013517', '3013518', '3013519', '3013520', '3013521', '3013522', '3013523', '3013524', '3013525', '3013526', '3013527', '3013528', '3013529', '3013530', '3013531', '3013532', '3013533', '3013534', '3013535', '3013536', '3013537', '3013538', '3013539', '3013540', '3013541', '3013542', '3013543', '3013544', '3013545', '3013546', '3013547', '3013548', '3013549', '3013551', '3013552', '3013553', '3013554', '3013555', '3013556', '3013557', '3013558', '3013559', '3013560', '3013561', '3013562', '3013563', '3013564', '3013565', '3013566', '3013567', '3013568', '3013569', '3013570', '3013571', '3013572', '3013573', '3013574', '3013575', '3013576', '3013577', '3013578', '3013579', '3013581', '3013582', '3013583', '3013584', '3013586', '3013587', '3013588', '3013589', '3013590', '3013591', '3013592', '3013593', '3013594', '3013595', '3013596', '3013597', '3013599', '3013600', '3013601', '3013602', '3013603', '3013604', '3013606', '3013607', '3013608', '3013609', '3013610', '3013611', '3013613', '3013614', '3013615', '3013616', '3013618', '3013619', '3013620', '3013621', '3013622', '3013623', '3013624', '3013625', '3013626', '3013627', '3013629', '3013630', '3013631', '3013632', '3013633', '3013634', '3013635', '3013636', '3013637', '3013638', '3013639', '3013640', '3013641', '3013642', '3013643', '3013644', '3013645', '3013646', '3013648', '3013649', '3013650', '3013651', '3013652', '3013653', '3013654', '3013655', '3013656', '3013657', '3013658', '3013659', '3013660', '3013661', '3013662', '3013663', '3013664', '3013665', '3013666', '3013667', '3013668', '3013669', '3013670', '3013671', '3013672', '3013673', '3013674', '3013675', '3013676', '3013677', '3013678', '3013679', '3013680', '3013681', '3013684', '3013685', '3013686', '3013687', '3013688', '3013689', '3013690', '3013691', '3013692', '3013693', '3013694', '3013695', '3013696', '3013697', '3013698', '3013699', '3013700', '3013701', '3013702', '3013703', '3013704', '3013705', '3013706', '3013707', '3013708', '3013709', '3013710', '3013711', '3013712', '3013713', '3013714', '3013715', '3013716', '3013717', '3013718', '3013719', '3013720', '3013721', '3013722', '3013723', '3013724', '3013725', '3013726', '3013727', '3013728', '3013729', '3013730', '3013731', '3013733', '3013734', '3013735', '3013736', '3013737', '3013738', '3013739', '3013740', '3013741', '3013742', '3013743', '3013744', '3013745', '3013746', '3013747', '3013748', '3013749', '3013750', '3013751', '3013752', '3013753', '3013754', '3013755', '3013756', '3013758', '3013759', '3013760', '3013762', '3013763', '3013764', '3013765', '3013766', '3013767', '3013768', '3013769', '3013770', '3013771', '3013772', '3013773', '3013774', '3013775', '3013776', '3013777', '3013778', '3013779', '3013780', '3013781', '3013782', '3013783', '3013784', '3013785', '3013786', '3013787', '3013788', '3013789', '3013790', '3013791', '3013792', '3013793', '3013794', '3013795', '3013796', '3013797', '3013798', '3013799', '3013800', '3013801', '3013802', '3013803', '3013804', '3013805', '3013806', '3013807', '3013808', '3013809', '3013810', '3013811', '3013812', '3013813', '3013814', '3013815', '3013816', '3013817', '3013818', '3013820', '3013821', '3013823', '3013824', '3013827', '3013828', '3013829', '3013830', '3013831', '3013832', '3013833', '3013834', '3013836', '3013837', '3013838', '3013840', '3013841', '3013842', '3013843', '3013844', '3013845', '3013846', '3013847', '3013849', '3013850', '3013851', '3013852', '3013853', '3013854', '3013855', '3013856', '3013857', '3013858', '3013859', '3013860', '3013861', '3013862', '3013863', '3013864', '3013865', '3013866', '3013867', '3013868', '3013869', '3013870', '3013871', '3013872', '3013873', '3013874', '3013875', '3013876', '3013877', '3013878', '3013879', '3013880', '3013881', '3013883', '3013884', '3013885', '3013886', '3013887', '3013888', '3013889', '3013890', '3013891', '3013893', '3013894', '3013895', '3013896', '3013898', '3013899', '3013902', '3013903', '3013905', '3013906', '3013907', '3013908', '3013909', '3013910', '3013911', '3013912', '3013913', '3013914', '3013915', '3013917', '3013918', '3013919', '3013920', '3013921', '3013922', '3013923', '3013924', '3013925', '3013926', '3013927', '3013928', '3013929', '3013932', '3013934', '3013935', '3013936', '3013937', '3013938', '3013939', '3013940', '3013941', '3013942', '3013945', '3013948', '3013949', '3013950', '3013952', '3013953', '3013954', '3013956', '3013961', '3013962', '3013963', '3013964', '3013965', '3013966', '3013967', '3013968', '3013969', '3013970', '3013971', '3013972', '3013973', '3013974', '3013975', '3013976', '3013977', '3013978', '3013979', '3013980', '3013982', '3013984', '3013985', '3013986', '3013988', '3013989', '3013990', '3013991', '3013993', '3013994', '3013995', '3013996', '3013997', '3013998', '3013999', '3014000', '3014001', '3014003', '3014004', '3014005', '3014006', '3014007', '3014008', '3014010', '3014012', '3014013', '3014014', '3014017', '3014018', '3014019', '3014020', '3014021', '3014022', '3014023', '3014024', '3014026', '3014027', '3014028', '3014029', '3014030', '3014031', '3014032', '3014033', '3014034', '3014035', '3014036', '3014038', '3014039', '3014040', '3014041', '3014042', '3014043', '3014045', '3014047', '3014048', '3014049', '3014050', '3014051', '3014054', '3014055', '3014056', '3014057', '3014058', '3014060', '3014061', '3014063', '3014064', '3014065', '3014066', '3014067', '3014068', '3014070', '3014071', '3014072', '3014073', '3014074', '3014075', '3014076', '3014078', '3014079', '3014081', '3014082', '3014083', '3014087', '3014089', '3014090', '3014091', '3014092', '3014093', '3014094', '3014095', '3014096', '3014097', '3014099', '3014100', '3014101', '3014102', '3014104', '3014107', '3014110', '3014111', '3014112', '3014113', '3014114', '3014115', '3014116', '3014117', '3014118', '3014119', '3014120', '3014121', '3014122', '3014124', '3014125', '3014127', '3014128', '3014129', '3014130', '3014131', '3014133', '3014134', '3014135', '3014137', '3014138', '3014139', '3014140', '3014142', '3014143', '3014144', '3014148', '3014149', '3014150', '3014152', '3014155', '3014156', '3014158', '3014161', '3014162', '3014163', '3014164', '3014165', '3014168', '3014170', '3014171', '3014172', '3014173', '3014174', '3014175', '3014176', '3014177', '3014178', '3014179', '3014180', '3014182', '3014183', '3014184', '3014185', '3014186', '3014187', '3014193', '3014194', '3014195', '3014196', '3014198', '3014199', '3014200', '3014202', '3014203', '3014204', '3014206', '3014207', '3014208', '3014210', '3014211', '3014212', '3014213', '3014214', '3014215', '3014217', '3014218', '3014219', '3014220', '3014221', '3014222', '3014223', '3014224', '3014225', '3014226', '3014227', '3014229', '3014232', '3014233', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014248', '3014250', '3014252', '3014253', '3014254', '3014255', '3014256', '3014257', '3014258', '3014259', '3014260', '3014262', '3014263', '3014264', '3014265', '3014267', '3014268', '3014269', '3014270', '3014271', '3014272', '3014273', '3014275', '3014279', '3014280', '3014281', '3014285', '3014286', '3014287', '3014288', '3014289', '3014291', '3014292', '3014293', '3014294', '3014295', '3014296', '3014297', '3014298', '3014300', '3014301', '3014302', '3014303', '3014304', '3014305', '3014306', '3014307', '3014308', '3014309', '3014311', '3014312', '3014314', '3014315', '3014317', '3014318', '3014319', '3014322', '3014323', '3014324', '3014327', '3014328', '3014329', '3014332', '3014333', '3014334', '3014335', '3014336', '3014337', '3014338', '3014340', '3014341', '3014342', '3014343', '3014344', '3014346', '3014347', '3014348', '3014350', '3014354', '3014355', '3014357', '3014358', '3014359', '3014360', '3014361', '3014363', '3014364', '3014365', '3014366', '3014367', '3014368', '3014369', '3014370', '3014374', '3014375', '3014376', '3014377', '3014378', '3014379', '3014380', '3014384', '3014385', '3014386', '3014388', '3014390', '3014392', '3014394', '3014396', '3014398', '3014399', '3014401', '3014402', '3014403', '3014404', '3014406', '3014407', '3014408', '3014409', '3014415', '3014416', '3014417', '3014418', '3014421', '3014422', '3014423', '3014424', '3014425', '3014426', '3014429', '3014430', '3014431', '3014432', '3014433', '3014435', '3014436', '3014437', '3014438', '3014439', '3014440', '3014442', '3014443', '3014444', '3014445', '3014446', '3014447', '3014448', '3014450', '3014451', '3014452', '3014453', '3014454', '3014455', '3014456', '3014458', '3014459', '3014460', '3014461', '3014462', '3014463', '3014464', '3014465', '3014466', '3014467', '3014468', '3014469', '3014470', '3014471', '3014472', '3014473', '3014475', '3014476', '3014477', '3014478', '3014479', '3014480', '3014481', '3014482', '3014483', '3014485', '3014486', '3014488', '3014490', '3014491', '3014492', '3014493', '3014494', '3014495', '3014497', '3014499', '3014500', '3014502', '3014503', '3014504', '3014505', '3014506', '3014508', '3014509', '3014510', '3014511', '3014512', '3014520', '3014521', '3014522', '3014525', '3014526', '3014532', '3014533', '3014534', '3014535', '3014536', '3014537', '3014538', '3014539', '3014541', '3014542', '3014543', '3014544', '3014545', '3014547', '3014548', '3014549', '3014552', '3014554', '3014555', '3014556', '3014557', '3014559', '3014560', '3014561', '3014562', '3014563', '3014564', '3014565', '3014567', '3014568', '3014569', '3014570', '3014571', '3014572', '3014573', '3014574', '3014576', '3014577', '3014579', '3014580', '3014581', '3014582', '3014583', '3014588', '3014589', '3014590', '3014591', '3014593', '3014595', '3014596', '3014597', '3014598', '3014599', '3014600', '3014601', '3014602', '3014604', '3014605', '3014606', '3014607', '3014608', '3014609', '3014610', '3014611', '3014613', '3014614', '3014615', '3014618', '3014619', '3014620', '3014621', '3014622', '3014623', '3014624', '3014625', '3014626', '3014627', '3014628', '3014630', '3014631', '3014632', '3014633', '3014635', '3014636', '3014637', '3014638', '3014639', '3014641', '3014642', '3014643', '3014644', '3014645', '3014646', '3014647', '3014648', '3014649', '3014651', '3014654', '3014655', '3014656', '3014657', '3014659', '3014661', '3014662', '3014663', '3014664', '3014665', '3014666', '3014667', '3014668', '3014669', '3014670', '3014674', '3014675', '3014676', '3014677', '3014679', '3014681', '3014682', '3014683', '3014684', '3014686', '3014687', '3014689', '3014691', '3014692', '3014693', '3014696', '3014697', '3014698', '3014700', '3014701', '3014702', '3014703', '3014704', '3014705', '3014706', '3014709', '3014710', '3014711', '3014712', '3014713', '3014714', '3014715', '3014716', '3014718', '3014719', '3014720', '3014723', '3014725', '3014726', '3014728', '3014731', '3014733', '3014734', '3014735', '3014739', '3014741', '3014742', '3014743', '3014744', '3014745', '3014746', '3014748', '3014749', '3014752', '3014754', '3014755', '3014756', '3014757', '3014761', '3014762', '3014763', '3014764', '3014765', '3014766', '3014767', '3014768', '3014770', '3014771', '3014772', '3014773', '3014774', '3014775', '3014778', '3014779', '3014780', '3014781', '3014782', '3014783', '3014784', '3014785', '3014786', '3014787', '3014788', '3014789', '3014790', '3014791', '3014792', '3014793', '3014795', '3014796', '3014797', '3014798', '3014799', '3014800', '3014801', '3014802', '3014803', '3014804', '3014805', '3014806', '3014807', '3014810', '3014812', '3014813', '3014814', '3014815', '3014816', '3014817', '3014818', '3014819', '3014820', '3014821', '3014822', '3014823', '3014824', '3014826', '3014828', '3014829', '3014830', '3014832', '3014834', '3014835', '3014836', '3014837', '3014839', '3014840', '3014841', '3014842', '3014844', '3014845', '3014846', '3014848', '3014849', '3014850', '3014851', '3014852', '3014853', '3014854', '3014855', '3014856', '3014857', '3014858', '3014859', '3014860', '3014861', '3014862', '3014863', '3014864', '3014865', '3014866', '3014867', '3014868', '3014869', '3014870', '3014871', '3014872', '3014873', '3014874', '3014875', '3014876', '3014877', '3014879', '3014880', '3014882', '3014883', '3014884', '3014885', '3014886', '3014887', '3014888', '3014889', '3014890', '3014891', '3014892', '3014893', '3014894', '3014895', '3014896', '3014897', '3014899', '3014901', '3014903', '3014905', '3014906', '3014908', '3014909', '3014910', '3014911', '3014912', '3014913', '3014914', '3014915', '3014916', '3014917', '3014919', '3014920', '3014921', '3014922', '3014923', '3014924', '3014926', '3014927', '3014928', '3014929', '3014930', '3014931', '3014932', '3014933', '3014934', '3014935', '3014936', '3014939', '3014940', '3014942', '3014943', '3014945', '3014949', '3014950', '3014952', '3014953', '3014954', '3014955', '3014956', '3014957', '3014958', '3014959', '3014960', '3014961', '3014962', '3014963', '3014964', '3014965', '3014966', '3014967', '3014969', '3014970', '3014972', '3014973', '3014975', '3014976', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3014984', '3014985', '3014989', '3014991', '3014992', '3014993', '3015001', '3015004', '3015007', '3015010', '3015018', '3015019', '3015021', '3015023', '3015024', '3015025', '3015027', '3015028', '3015029', '3015030', '3015031', '3015032', '3015033', '3015034', '3015035', '3015036', '3015037', '3015042', '3015049', '3015051', '3015052', '3015053', '3015054', '3015055', '3015056', '3015059', '3015063', '3015064', '3015065', '3015066', '3015067', '3015069', '3015070', '3015071', '3015072', '3015073', '3015074', '3015075', '3015076', '3015077', '3015078', '3015079', '3015080', '3015081', '3015082', '3015083', '3015084', '3015086', '3015087', '3015089', '3015091', '3015092', '3015093', '3015094', '3015095', '3015096', '3015097', '3015098', '3015101', '3015102', '3015103', '3015104', '3015105', '3015106', '3015107', '3015108', '3015110', '3015111', '3015112', '3015113', '3015116', '3015118', '3015119', '3015120', '3015122', '3015123', '3015125', '3015127', '3015128', '3015129', '3015130', '3015131', '3015133', '3015134', '3015135', '3015136', '3015139', '3015140', '3015141', '3015142', '3015143', '3015145', '3015146', '3015147', '3015149', '3015152', '3015153', '3015157', '3015158', '3015159', '3015161', '3015162', '3015163', '3015164', '3015166', '3015167', '3015169', '3015170', '3015171', '3015172', '3015173', '3015174', '3015175', '3015178', '3015179', '3015180', '3015182', '3015184', '3015186', '3015187', '3015188', '3015190', '3015195', '3015197', '3015198', '3015202', '3015204', '3015205', '3015206', '3015208', '3015209', '3015210', '3015211', '3015212', '3015213', '3015214', '3015215', '3015217', '3015220', '3015221', '3015222', '3015224', '3015225', '3015226', '3015231', '3015232', '3015235', '3015236', '3015237', '3015238', '3015244', '3015245', '3015246', '3015247', '3015248', '3015249', '3015251', '3015252', '3015253', '3015254', '3015255', '3015256', '3015257', '3015258', '3015259', '3015261', '3015263', '3015264', '3015265', '3015266', '3015268', '3015269', '3015270', '3015271', '3015272', '3015273', '3015276', '3015278', '3015279', '3015280', '3015281', '3015282', '3015283', '3015284', '3015285', '3015286', '3015288', '3015289', '3015290', '3015292', '3015293', '3015294', '3015295', '3015296', '3015297', '3015298', '3015300', '3015302', '3015303', '3015304', '3015305', '3015307', '3015308', '3015309', '3015310', '3015311', '3015312', '3015313', '3015314', '3015316', '3015317', '3015320', '3015321', '3015322', '3015323', '3015324', '3015325', '3015326', '3015327', '3015328', '3015329', '3015330', '3015331', '3015332', '3015333', '3015334', '3015335', '3015337', '3015338', '3015339', '3015340', '3015341', '3015342', '3015343', '3015344', '3015345', '3015346', '3015347', '3015348', '3015350', '3015352', '3015353', '3015354', '3015355', '3015356', '3015357', '3015358', '3015360', '3015361', '3015362', '3015363', '3015366', '3015367', '3015372', '3015373', '3015374', '3015375', '3015376', '3015377', '3015378', '3015379', '3015380', '3015382', '3015383', '3015384', '3015385', '3015386', '3015389', '3015391', '3015392', '3015394', '3015395', '3015396', '3015398', '3015401', '3015402', '3015403', '3015404', '3015405', '3015406', '3015407', '3015408', '3015409', '3015410', '3015411', '3015413', '3015414', '3015415', '3015416', '3015417', '3015418', '3015419', '3015420', '3015421', '3015422', '3015426', '3015427', '3015428', '3015429', '3015430', '3015432', '3015433', '3015434', '3015435', '3015436', '3015438', '3015439', '3015440', '3015441', '3015442', '3015443', '3015444', '3015445', '3015446', '3015447', '3015448', '3015449', '3015451', '3015452', '3015453', '3015455', '3015457', '3015458', '3015459', '3015460', '3015461', '3015462', '3015463', '3015465', '3015466', '3015468', '3015469', '3015470', '3015471', '3015472', '3015473', '3015474', '3015475', '3015476', '3015477', '3015478', '3015479', '3015480', '3015481', '3015482', '3015483', '3015484', '3015485', '3015486', '3015487', '3015488', '3015489', '3015490', '3015491', '3015492', '3015493', '3015494', '3015495', '3015497', '3015498', '3015499', '3015500', '3015501', '3015502', '3015503', '3015505', '3015506', '3015507', '3015508', '3015509', '3015510', '3015514', '3015516', '3015517', '3015518', '3015519', '3015520', '3015521', '3015522', '3015523', '3015525', '3015526', '3015527', '3015528', '3015529', '3015530', '3015531', '3015532', '3015533', '3015536', '3015537', '3015538', '3015539', '3015540', '3015541', '3015542', '3015544', '3015545', '3015546', '3015547', '3015548', '3015549', '3015550', '3015551', '3015552', '3015553', '3015554', '3015555', '3015556', '3015557', '3015558', '3015559', '3015560', '3015561', '3015562', '3015564', '3015565', '3015566', '3015568', '3015569', '3015570', '3015571', '3015572', '3015573', '3015574', '3015575', '3015576', '3015580', '3015581', '3015582', '3015583', '3015586', '3015587', '3015588', '3015589', '3015590', '3015591', '3015592', '3015593', '3015594', '3015595', '3015596', '3015597', '3015598', '3015600', '3015601', '3015602', '3015603', '3015604', '3015605', '3015606', '3015608', '3015609', '3015610', '3015611', '3015612', '3015613', '3015614', '3015615', '3015616', '3015617', '3015618', '3015619', '3015620', '3015621', '3015622', '3015623', '3015624', '3015625', '3015626', '3015627', '3015628', '3015629', '3015630', '3015632', '3015633', '3015634', '3015635', '3015636', '3015637', '3015638', '3015639', '3015640', '3015641', '3015642', '3015643', '3015645', '3015647', '3015648', '3015649', '3015650', '3015651', '3015652', '3015653', '3015654', '3015655', '3015656', '3015657', '3015658', '3015659', '3015660', '3015662', '3015664', '3015665', '3015666', '3015667', '3015668', '3015669', '3015670', '3015671', '3015672', '3015673', '3015674', '3015675', '3015678', '3015679', '3015680', '3015681', '3015682', '3015684', '3015685', '3015686', '3015687', '3015688', '3015689', '3015690', '3015692', '3015693', '3015694', '3015695', '3015696', '3015697', '3015698', '3015699', '3015702', '3015703', '3015704', '3015705', '3015706', '3015707', '3015708', '3015709', '3015710', '3015711', '3015712', '3015713', '3015714', '3015715', '3015716', '3015717', '3015718', '3015719', '3015720', '3015721', '3015723', '3015724', '3015725', '3015726', '3015727', '3015728', '3015730', '3015732', '3015733', '3015735', '3015736', '3015737', '3015738', '3015739', '3015740', '3015742', '3015743', '3015744', '3015745', '3015746', '3015747', '3015748', '3015749', '3015750', '3015751', '3015754', '3015755', '3015756', '3015757', '3015758', '3015759', '3015760', '3015761', '3015762', '3015764', '3015765', '3015766', '3015767', '3015768', '3015769', '3015770', '3015771', '3015772', '3015773', '3015774', '3015775', '3015776', '3015777', '3015778', '3015780', '3015781', '3015782', '3015783', '3015784', '3015786', '3015787', '3015789', '3015792', '3015793', '3015794', '3015795', '3015796', '3015797', '3015798', '3015800', '3015801', '3015803', '3015804', '3015805', '3015806', '3015807', '3015808', '3015809', '3015810', '3015811', '3015812', '3015813', '3015814', '3015815', '3015816', '3015817', '3015818', '3015819', '3015820', '3015821', '3015823', '3015824', '3015825', '3015826', '3015827', '3015828', '3015829', '3015830', '3015831', '3015832', '3015833', '3015834', '3015836', '3015837', '3015839', '3015840', '3015841', '3015842', '3015843', '3015844', '3015848', '3015849', '3015851', '3015852', '3015853', '3015854', '3015855', '3015856', '3015857', '3015858', '3015859', '3015860', '3015861', '3015862', '3015863', '3015864', '3015865', '3015866', '3015867', '3015868', '3015869', '3015870', '3015871', '3015873', '3015876', '3015877', '3015878', '3015879', '3015880', '3015881', '3015882', '3015883', '3015884', '3015885', '3015886', '3015889', '3015890', '3015891', '3015892', '3015893', '3015894', '3015895', '3015896', '3015897', '3015899', '3015900', '3015901', '3015902', '3015903', '3015905', '3015906', '3015907', '3015908', '3015911', '3015912', '3015913', '3015914', '3015915', '3015916', '3015918', '3015919', '3015920', '3015921', '3015922', '3015923', '3015924', '3015925', '3015926', '3015927', '3015928', '3015929', '3015930', '3015931', '3015932', '3015933', '3015934', '3015935', '3015937', '3015938', '3015941', '3015942', '3015943', '3015944', '3015947', '3015948', '3015949', '3015950', '3015954', '3015955', '3015956', '3015957', '3015958', '3015959', '3015960', '3015961', '3015962', '3015963', '3015964', '3015965', '3015967', '3015968', '3015969', '3015970', '3015971', '3015972', '3015973', '3015974', '3015975', '3015977', '3015979', '3015980', '3015981', '3015982', '3015983', '3015984', '3015985', '3015986', '3015987', '3015988', '3015989', '3015990', '3015991', '3015992', '3015993', '3015994', '3015995', '3015996', '3015997', '3015998', '3015999', '3016001', '3016003', '3016005', '3016006', '3016007', '3016008', '3016009', '3016012', '3016013', '3016014', '3016015', '3016016', '3016018', '3016019', '3016020', '3016022', '3016023', '3016024', '3016025', '3016026', '3016027', '3016028', '3016030', '3016031', '3016032', '3016033', '3016034', '3016035', '3016036', '3016037', '3016038', '3016039', '3016040', '3016041', '3016042', '3016043', '3016044', '3016045', '3016046', '3016047', '3016048', '3016049', '3016050', '3016051', '3016053', '3016054', '3016055', '3016056', '3016057', '3016058', '3016059', '3016060', '3016061', '3016062', '3016063', '3016064', '3016065', '3016066', '3016067', '3016068', '3016069', '3016070', '3016071', '3016074', '3016075', '3016076', '3016078', '3016079', '3016080', '3016081', '3016082', '3016083', '3016084', '3016085', '3016086', '3016087', '3016088', '3016089', '3016090', '3016091', '3016092', '3016094', '3016096', '3016097', '3016098', '3016099', '3016100', '3016101', '3016102', '3016103', '3016104', '3016105', '3016106', '3016107', '3016108', '3016109', '3016110', '3016111', '3016112', '3016113', '3016114', '3016115', '3016116', '3016117', '3016118', '3016119', '3016120', '3016121', '3016122', '3016123', '3016124', '3016125', '3016126', '3016127', '3016128', '3016130', '3016132', '3016134', '3016135', '3016136', '3016137', '3016138', '3016139', '3016140', '3016142', '3016143', '3016144', '3016145', '3016146', '3016147', '3016148', '3016149', '3016151', '3016152', '3016153', '3016154', '3016155', '3016156', '3016157', '3016159', '3016160', '3016162', '3016163', '3016164', '3016165', '3016166', '3016167', '3016168', '3016169', '3016170', '3016171', '3016172', '3016173', '3016174', '3016175', '3016176', '3016177', '3016178', '3016179', '3016180', '3016181', '3016182', '3016183', '3016184', '3016185', '3016186', '3016187', '3016188', '3016189', '3016190', '3016191', '3016192', '3016193', '3016196', '3016197', '3016201', '3016202', '3016203', '3016204', '3016205', '3016206', '3016207', '3016208', '3016209', '3016210', '3016211', '3016212', '3016213', '3016217', '3016218', '3016219', '3016220', '3016222', '3016224', '3016225', '3016226', '3016227', '3016228', '3016230', '3016231', '3016232', '3016233', '3016234', '3016235', '3016236', '3016238', '3016239', '3016240', '3016241', '3016242', '3016244', '3016245', '3016246', '3016247', '3016248', '3016249', '3016253', '3016254', '3016255', '3016256', '3016257', '3016258', '3016261', '3016262', '3016263', '3016265', '3016266', '3016267', '3016268', '3016269', '3016270', '3016271', '3016272', '3016273', '3016274', '3016275', '3016276', '3016277', '3016278', '3016279', '3016280', '3016281', '3016282', '3016283', '3016284', '3016285', '3016286', '3016287', '3016288', '3016289', '3016290', '3016291', '3016292', '3016293', '3016294', '3016295', '3016296', '3016297', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016307', '3016308', '3016309', '3016311', '3016312', '3016313', '3016314', '3016315', '3016316', '3016317', '3016318', '3016319', '3016320', '3016321', '3016322', '3016323', '3016324', '3016325', '3016326', '3016328', '3016329', '3016330', '3016331', '3016333', '3016334', '3016335', '3016336', '3016337', '3016339', '3016340', '3016341', '3016342', '3016343', '3016344', '3016345', '3016346', '3016347', '3016348', '3016349', '3016350', '3016351', '3016353', '3016354', '3016355', '3016356', '3016357', '3016358', '3016359', '3016360', '3016361', '3016362', '3016363', '3016364', '3016365', '3016366', '3016367', '3016368', '3016369', '3016370', '3016371', '3016372', '3016373', '3016374', '3016375', '3016376', '3016377', '3016378', '3016379', '3016380', '3016381', '3016382', '3016383', '3016384', '3016385', '3016386', '3016387', '3016388', '3016389', '3016390', '3016391', '3016392', '3016393', '3016394', '3016395', '3016396', '3016397', '3016398', '3016399', '3016400', '3016401', '3016402', '3016403', '3016404', '3016405', '3016407', '3016408', '3016409', '3016410', '3016411', '3016412', '3016413', '3016414', '3016415', '3016416', '3016417', '3016418', '3016419', '3016420', '3016421', '3016422', '3016424', '3016425', '3016426', '3016427', '3016428', '3016433', '3016434', '3016435', '3016436', '3016437', '3016438', '3016440', '3016441', '3016442', '3016443', '3016444', '3016445', '3016446', '3016447', '3016448', '3016449', '3016450', '3016454', '3016455', '3016456', '3016457', '3016458', '3016459', '3016460', '3016461', '3016462', '3016463', '3016464', '3016465', '3016466', '3016467', '3016468', '3016469', '3016470', '3016471', '3016472', '3016473', '3016474', '3016475', '3016476', '3016477', '3016478', '3016479', '3016480', '3016481', '3016482', '3016483', '3016484', '3016485', '3016486', '3016487', '3016488', '3016489', '3016490', '3016491', '3016492', '3016493', '3016494', '3016495', '3016496', '3016497', '3016498', '3016499', '3016500', '3016501', '3016502', '3016503', '3016504', '3016505', '3016506', '3016507', '3016508', '3016509', '3016510', '3016511', '3016512', '3016513', '3016514', '3016515', '3016516', '3016517', '3016518', '3016519', '3016520', '3016521', '3016522', '3016523', '3016524', '3016525')) ORDER BY `posted_at` DESC LIMIT 50

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k	ALL	ix_school_id_kuchikomi				809	Using where; Using filesort

0.000697

DESCRIBE `member`

0.000837

SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('3022', '2954', '4302', '3603', '3601'))

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

0.000527

DESCRIBE `access_count_kuchikomi`

0.000427

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1322', '1306', '1355', '1352', '1350'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a_c_k	range	kuchikomi_id	kuchikomi_id	4		5	Using index condition

0.000557

DESCRIBE `basic_knowledge`

0.000417

SELECT `b_k`.* FROM `basic_knowledge` AS `b_k` WHERE (b_k.valid = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b_k	ALL					8	Using where

0.008737

DESCRIBE `event_audition`

0.000517

SELECT `e_a`.* FROM `event_audition` AS `e_a` WHERE (e_a.valid = 1) AND (e_a.close_date >= '2025-12-14') ORDER BY `timestamp_created` DESC LIMIT 5

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e_a	range	ix_close_date_event_audition	ix_close_date_event_audition	5		1	Using index condition; Using where; Using filesort

0.000577

DESCRIBE `dancer`

0.000707

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 GROUP BY `c`.`id`

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 temporary; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	jobikai_dance.d_c.dancer_id	1	Using index

0.000417

SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('8', '14', '1'))

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

0.001977

connect

0.000547

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

DESCRIBE `schoolgroup`

0.000457

SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '134') AND (sg.registration_status = 1) LIMIT 1

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

0.000837

DESCRIBE `category_schoolgroup`

0.000417

SELECT `c_sg`.* FROM `category_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '134') AND (c_sg.valid = 1)

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

0.000407

SELECT `c_sg`.* FROM `category_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '134') AND (c_sg.valid = 1) LIMIT 3

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

0.000537

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '134') AND (s.is_opening = 1) LIMIT 3

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

0.002097

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

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

0.000427

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

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

DESCRIBE `school_station`

0.000887

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015167') ORDER BY `time` ASC, `distance` ASC LIMIT 3

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

0.011437

DESCRIBE `station`

0.003417

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

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '5287') LIMIT 1

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

0.000437

SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '136') AND (sg.registration_status = 1) LIMIT 1

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

0.000447

SELECT `c_sg`.* FROM `category_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '136') AND (c_sg.valid = 1)

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

0.000487

SELECT `c_sg`.* FROM `category_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '136') AND (c_sg.valid = 1) LIMIT 3

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

0.001487

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '136') AND (s.is_opening = 1) LIMIT 3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	ix_schoolgroup_id_school	ix_schoolgroup_id_school	5	const	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.000667

DESCRIBE `dancer_column`

0.000497

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '1') 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	3	Using index condition; Using where; Using filesort

0.000457

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

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '8') 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

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

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

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

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

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

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

Message	Memory use
Component initialization	2.17 MB
Controller action start	2.40 MB
Controller render start	5.65 MB
View render complete	7.03 MB

Timers

Total Request Time: 1069 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	631.00
Event: Controller.initialize	0.79
Event: Controller.startup	0.35
Controller action	125.34
Event: Controller.beforeRender	183.46
» Processing toolbar data	174.35
Rendering View	78.75
» Event: View.beforeRender	1.69
» Rendering APP/View/Home/index.ctp	64.51
» » Rendering APP/View/Elements/home/pick-up-school.ctp	44.19
» » Rendering APP/View/Elements/__searchlink/main-column-prefecture.ctp	1.45
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp	0.43
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	4.65
» » Rendering APP/View/Elements/home/new-arrival-school.ctp	2.51
» » » Rendering APP/View/Elements/school-box.ctp	0.39
» » » Rendering APP/View/Elements/school-box.ctp #2	0.34
» » » Rendering APP/View/Elements/school-box.ctp #3	0.29
» » » Rendering APP/View/Elements/school-box.ctp #4	0.27
» » » Rendering APP/View/Elements/school-box.ctp #5	0.20
» » Rendering APP/View/Elements/home/pick-up-kuchikomi.ctp	3.75
» » » Rendering APP/View/Elements/kuchikomi-box.ctp	1.67
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #2	0.28
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #3	0.24
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #4	0.23
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #5	0.26
» » Rendering APP/View/Elements/home/column.ctp	2.63
» » Rendering APP/View/Elements/home/column.ctp #2	1.13
» » Rendering APP/View/Elements/home/column.ctp #3	0.99
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	10.75
» » Rendering APP/View/Elements/header.ctp	0.45
» » Rendering APP/View/Elements/menu.ctp	7.47
» » » Rendering APP/View/Elements/home/right-menu.ctp	7.24
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.09
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	6.04
» » » » 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.17
» » Rendering APP/View/Elements/footer.ctp	1.04
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.07
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- DancerSet(array)
  0(object)
  id1
  nameユーコ・スミダ・ジャクソン
  description1966年8月5日生まれ。 24歳で単身LAへ渡米。世界中から集まったオーディションを見事に突破しマイケル・ジャクソンの「デンジャラス・ツアー」で、初の女性バックダンサー１人枠として抜擢される。マイケルと伴に世界28カ国をまわり、TV出演やショートフィルム「Ghost」出演まで6年間、マイケルのバックダンサーを務める。
  valid1
  timestamp_created2013-06-05 04:02:38
  timestamp_modified2015-12-03 21:40:50
  1(object)
  id14
  name河邉こずえ
  description3歳からクラシックバレエを始め、国内外で数々の賞を受賞。現在は、自ら舞踊創作も行う河邉こずえが語るダンスへの想いとは─
  valid1
  timestamp_created2014-04-24 21:27:25
  timestamp_modified2014-04-24 21:27:25
  2(object)
  id8
  nameマスヨシ（HOMEBOY）
  descriptionクラブ業界でのshowとダンススタジオ経営を中心にUSJやPVなど様々な活動中。メインのダンススタイルであるLOCKを中心に、様々なジャンルを取り入れた表現でのダンスを好んでいる。
  valid1
  timestamp_created2013-08-27 04:31:24
  timestamp_modified2013-08-27 04:31:24
- EventAuditionSet(object)
- BasicKnowledgeSet(array)
  0(object)
  id1
  titleバレエの種類・特徴
  summaryバレエと一口に言っても、実はその中にはいくつかの種類があります。
  category_id1
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id2
  titleストリートダンスの種類・特徴
  summaryストリートダンスとは路上で自由に踊るダンス全般の事を指し、社交ダンス(ボールルームダンス)のようにダンスホールで踊るようなダンスや、バレエやベリーダンスのように観客に見せるダンス（ショーダンス）ではないものの事です。ストリートダンスと一口に言っても、ステップやフリ、音楽の違いなどによってその種類は様々。分類の方法は場合によって変わってきますが、主な特徴から大体以下の種類に分類されます。
  category_id4
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id3
  titleタップダンスの種類・特徴
  summaryリズミカルなステップでリズムを作りながら踊るのが特徴的なタップダンス。タップダンスは大きく分けると2種類のダンスに分ける事が出来ます。
  category_id5
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  3(object)
  id4
  titleサルサの種類・特徴
  summaryサルサダンスはキューバ発祥のラテンダンスの一つで、サルサミュージックに合わせて踊るものです。サルサダンスは男女ペア、男性リードで踊るダンスのため社交ダンスの一つとして認識されがちですが、基本姿勢やパートナーの考え方などから基本的には別物とされています。サルサの中にもいくつかのダンススタイルがあります。
  category_id6
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  4(object)
  id5
  titleフラメンコの種類・特徴
  summaryフラメンコとはスペイン南部のアンダルシア地方の歌・楽曲と、それに合わせたダンスの事で、踊りながら手や足を使って音を鳴らしていく事が特徴です。フラメンコはコンパスと呼ばれるリズムや曲調によって多くの種類に分かれており、これをパロと言います。踊る際は楽曲の引手と踊り手がパロを決め、それに合わせて踊る形になります。
  category_id7
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  5(object)
  id6
  titleフラダンス・タヒチアンダンスの種類・特徴
  summaryフラダンスとタヒチアンダンスはそれぞれ衣装も動きも似ているため、全て同じダンスだと思われがちですが、実はその中でもいくつかの種類に分かれています。
  category_id8
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  6(object)
  id7
  titleベリーダンスの種類・特徴
  summaryベリーダンスはその踊りの特徴や発祥によっていくつかの種類に分ける事が出来ます。オリエンタルスタイル・エジプシャンスタイル中東地域のベリーダンスを総称してオリエンタルスタイルと呼び、その中でも主要なものがエジプシャンスタイルです。エジプシャンスタイルは基本はソロが多く、優雅で細やかな動きが特徴的なダンスで、エジプトの民族舞踊の動きを取り入れた振りが多いダンスです。音楽は打楽器中心で、衣装は肌の露出が少ないものが基本スタイルとなります。アサヤと呼ばれるステッキを使うのも特徴的です。
  category_id9
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  7(object)
  id8
  title社交ダンス・ボールルームダンスの種類・特徴
  summary社交ダンスとは男女のペアで曲に合わせて踊るダンスで、英語では一般的にBallroom Dance（ボールルームダンス）と呼ばれるものです。社交ダンスのダンススタイルの内、踊られる機会の多いものを紹介します。
  category_id10
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- MemberIconManageable(object)
- PickupKuchikomiSet(array)
  0(object)
  id1322
  member_id3022
  school_id3013291
  titleスタッフの対応が…
  bodyスクールの講師や生徒の雰囲気はまずまずといったところでしたが、スタッフの接客が残念でした。言葉遣いもなっていない中説明も足りず…契約時も選択クラスに関する詳しい説明が無く、後になってから休会すると初心者クラスには復帰ができないだとか、トラブルが起こってはじめてルールの説明があり、質が良く無いと感じました。スタッフの対応でこんなにも教室の印象が変わるのだと感じました。
  score1
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment1
  attending_period2
  ip_address10.4.1.108
  hostname10.4.1.108
  posted_at2016-04-08 19:11:11
  valid1
  timestamp_created2016-04-09 04:11:11
  timestamp_modified2016-04-09 04:11:11
  1(object)
  id1306
  member_id2954
  school_id3013256
  title環境がお勧めのダンススクールです。
  body子供のころから、タンゴダンスにはあこがれていました。たまたま職場の徒歩圏のところで教室があり日頃の運動不足を解消したい思いから参加してみることにしました。最初は無料の体験入学を利用しました。その時の雰囲気が最高に良いスクールなので入学して本格的に習うことにしました。講師の方もみな丁寧な指導で親身になって教えてくれるので覚えながらダンスが楽しくなっていきました。趣味が充実するようになり、日常生活も快適に送れるようになりました。また利便性がよいのも魅力の一つです。興味がある方は見学だけでもしてみてください。きっと理想の環境があると思います。
  score4
  reviewer_nickname
  enrollment_year2013
  level_at_enrollment1
  attending_period2
  ip_address10.4.1.231
  hostname10.4.1.231
  posted_at2015-12-08 11:35:16
  valid1
  timestamp_created2015-12-08 20:35:16
  timestamp_modified2015-12-08 20:35:16
  2(object)
  id1355
  member_id4302
  school_id3016266
  titleとても親切丁寧に教えて頂きました
  body初心者の私にも基礎から教えてくださり、社交ダンスの楽しさを学ぶことが出来ました。講師の方が分かり易く丁寧に教えてくださるので安心して通えます。
  score5
  reviewer_nickname
  enrollment_year2020
  level_at_enrollment1
  attending_period3
  ip_address10.0.1.125
  hostname10.0.1.125
  posted_at2020-12-27 21:24:32
  valid1
  timestamp_created2020-12-28 06:24:32
  timestamp_modified2020-12-28 06:24:32
  3(object)
  id1352
  member_id3603
  school_id3014495
  titleマリ先生がエレガントかつカッコいい
  body3年前、職場の先輩の発表会を観に行ったことから、未経験者対象 3回完結1曲マスターコースがあることを知り受講しました。毎回交代でマリ先生と一緒に踊っているところを録画してもらうのですが、その踊りは惨憺たるものでした。50代という年齢からの覚えの悪さもあるけれど何より猫背がひどく姿勢が悪い。でも先生のエレガントかつカッコイイ踊りに魅了され、入会することにしました。いくつになっても筋肉は努力次第でつくという先生の言葉を信じてレッスンに励んで本当に良かった。今では猫背もほぼ解消して身長が1.2センチ伸びたのにはびっくり！確実に身体が変わります。
  score5
  reviewer_nickname
  enrollment_year2016
  level_at_enrollment1
  attending_period5
  ip_address10.4.1.218
  hostname10.4.1.218
  posted_at2019-12-17 22:46:21
  valid1
  timestamp_created2019-12-18 07:46:21
  timestamp_modified2019-12-18 07:46:21
  4(object)
  id1350
  member_id3601
  school_id3014495
  title上達が早いです
  body3回完結コースはフラメンコの雰囲気を楽しめるコースでした。3回で1曲を完成させるので、最初は大変かなと思いましたが、音楽に乗って動けて楽しかったです。
  score5
  reviewer_nickname
  enrollment_year2013
  level_at_enrollment1
  attending_period5
  ip_address10.4.1.16
  hostname10.4.1.16
  posted_at2019-12-10 16:30:39
  valid1
  timestamp_created2019-12-11 01:30:39
  timestamp_modified2019-12-11 01:30:39
- NewArrivalSchoolSet(object)
  0(object)
  id3016525
  name【のとなつみ先生のアイドルダンス・レッスン】
  branch_name
  city_id724
  schoolgroup_id(null)
  mail_addressfunabashi@kenmusic.co.jp
  lat
  lon
  telephone_number
  homepage_urlhttps://www.kenmusic.co.jp/KML/noto.html
  mobile_homepage_urlhttps://www.kenmusic.co.jp/KML/noto.html
  blog_url
  open_hour10:00～22:00
  holiday月曜定休・夏季／年末年始休業あり
  post_code
  town_address栗原3-4-6
  building
  image_hash2b9d9b581f5b50af
  image_extension_type3
  message_image_hashf2ced84d118ee761
  message_image_extension_type2
  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_receiving0
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course0
  score0.00
  kuchikomi_count0
  timestamp_created2025-10-27 15:38:40
  timestamp_modified2025-10-27 15:58:47
  memo(null)
  1(object)
  id3016524
  namePersonal　Space　Boheme
  branch_name
  city_id1189
  schoolgroup_id(null)
  mail_addressdeskjam3@msn.com
  lat(null)
  lon(null)
  telephone_number09033845065
  homepage_urlhttps://ps-boheme.com/
  mobile_homepage_urlhttps://ps-boheme.com
  blog_url
  open_hour10時～21時
  holiday木曜日
  post_code453-0044
  town_address鳥居通4丁目16番
  building第二鳥居ビル2階-C
  image_hash
  image_extension_type0
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_titleボディメイクが出来るバレエ教室です
  message_bodyカテゴリーは大人バレエ、子供バレエ（3才～）、ピラティス、ヨガ、有酸素系カテゴリー、パワーヨガ、エアロビクスなどがあります。ダンス業界、スポーツ業界、共に30年の実績があるインストラクターが担当致します。他店との違いはバレエ教室の教師は解剖学や栄養学、生理学などの知識は殆どない方が多く、子供の成長過程の大切な時期に怪我をさせてしまうなんて事も多々あります。メンテナンスもしません。しかし、ウチの強みは健康運動指導士でもあるインストラクターがバレエで使う筋肉や関節のケアとエクササイズを行います。ピラティスではインナーマッスルを鍛え、機能解剖学的に指導をし、ヨガでは自律神経を調整し内臓の機能改善なども行います。トータルケアが出来るスタジオ、そして地域の皆様の健康をサポートするスタジオを目指します。何かご質問などがありましたらお気軽にご連絡して頂けたら幸いです。ホームページからもアクセス出来ます。ぜひお待ち致しております。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleinstructor
  whole_staff_introduction只今のところは担当者は1名です。Personal　Spaceですので、15名くらいの生徒さんしかスタジオに入ることが出来ません。健康運動指導士認定心理士乙第二歯科助手救急蘇生協会　First　Basic　Provider 要資格者です。色々な方向から指導が行えますし、30年の指導実績があります。宜しくお願い致します。
  whole_staff_image_hash
  whole_staff_image_extension_type0
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2025-08-10 18:53:59
  timestamp_modified2025-08-10 20:12:52
  memo(null)
  2(object)
  id3016523
  nameレンタルスペース目黒フィットネススタジオ
  branch_name
  city_id782
  schoolgroup_id(null)
  mail_addressrentalspace.meguro@gmail.com
  lat
  lon
  telephone_number050-3000-0957
  homepage_urlhttps://fit-meguro.com/
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code153-0063
  town_address目黒1-4-8
  buildingニュー目黒ビル７階
  image_hash48ebf3fca748fe86
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_titleJR目黒駅の駅近パーソナルレッスン
  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_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2025-07-17 12:00:34
  timestamp_modified2025-07-19 16:29:26
  memo(null)
  3(object)
  id3016522
  nameかっぱハウススタジオ
  branch_name
  city_id884
  schoolgroup_id(null)
  mail_addresskappa@muf.biglobe.ne.jp
  lat(null)
  lon(null)
  telephone_number0459783857
  homepage_urlhttps://kappa-st.jp/
  mobile_homepage_url
  blog_url
  open_hour10時～21時
  holiday金曜日
  post_code216-0004
  town_address鷺沼1-17-8
  buildingハイツ鷺沼B1
  image_hashc01d16d2cb9627f1
  image_extension_type2
  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_receiving0
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2025-04-02 11:47:25
  timestamp_modified2025-04-02 11:49:21
  memo(null)
  4(object)
  id3016521
  name桃山六地蔵キッズダンススクール【京都/伏見区】
  branch_name
  city_id1413
  schoolgroup_id(null)
  mail_addressalabaster.yu+dance.school@gmail.com
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://www.alabaster-ep.com/kids-rokujizo
  mobile_homepage_urlhttps://www.alabaster-ep.com/kids-rokujizo
  blog_urlhttps://amf-alabaster.hatenablog.jp/
  open_hour【金曜日】16:30～18:35
  holiday
  post_code612-8002
  town_address桃山町
  building
  image_hashfef5289abeaeac47
  image_extension_type2
  message_image_hasha5f417457837e08f
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title未経験から始めるキッズダンススクール
  message_bodyJR・京阪・地下鉄「六地蔵駅」駅桃山六地蔵キッズダンス教室です。小学1年生～小学6年生の子どもたちを対象にした【キッズクラス】小学4年生～中学生まで対象にした【キッズダンスクラス】【安心の大手スポーツクラブで開講】 ■ 現役プロダンサーがインストラクター ■ 経験豊富な指導でお子さまの成長をサポート基礎から丁寧に教えるので、初めてのダンスでも無理なく楽しく上達できる。リズム感や表現力を自然に身につけながら、自信を育む環境を大切にしたレッスン。お子さま一人ひとりの個性を尊重し、安心して通えるダンススクール。詳細はHPをご確認ください。【日時】毎週金曜日【リトルクラス】16:30～17:30 (月/4回) 【キッズダンス】17:35～18:35 (月/4回)
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleユウキ
  whole_staff_introductionユウキ大阪・神戸・京都・奈良の大手スポーツクラブのスタジオレッスンを10年以上指導。コンテストやバトルでの受賞のほか、審査員、ゲストショー・ダンス指導・舞台振付等、多方面で活動。はじめまして。ダンスインストラクターをしてるユウキです。桃山六地蔵キッズダンススクールでは、ダンスを習ったことない子たちや、体を動かすのが好きな子たち向けにダンスを楽しんでもらえるレッスンを心がけています。こどもたちには、自分の可能性や自信を身につけて成長してもらいたいと思います！！
  whole_staff_image_hash39440f8d5867d853
  whole_staff_image_extension_type2
  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_created2025-03-07 17:16:12
  timestamp_modified2025-03-09 14:09:44
  memo(null)
- PickupSchoolSet(array)
  0(object)
  id3015076
  nameアミーラベリーダンススタジオ
  branch_name小倉スタジオ
  city_id1938
  schoolgroup_id134
  mail_addressamira-studio@excite.co.jp
  lat33.883509300000
  lon130.880765800000
  telephone_number080-3957-5120
  homepage_urlhttp://www.amirabellydance.jp/
  mobile_homepage_url
  blog_url
  open_hourクラスにより異なる
  holiday
  post_code(null)
  town_address魚町2-6-1
  building小倉商工会館ビル
  image_hash3a2462f42cfdbcbd
  image_extension_type2
  message_image_hash3b9125c22533823b
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleベリーダンスで新しい自分に出会いませんか？
  message_bodyプロポーションが良くなるだけではなく、女性らしいチャーミングな動きが身につきます！ロシア出身のアミーラナスチャー、日本人講師ASAMIによる日本語でわかりやすいレッスン♪ イベントへの出演機会もあります。今まで気づかなかった貴女の魅力、見つけましょう☆ 小倉：小倉商工会館ビル4F 見学無料体験レッスン無料(但し体験は1人様1回限り) 複数レッスン受講の方はお得なアドバンスコースあります。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title楽しく、わかりやすいレッスンを行います
  whole_staff_introductionロシア出身、アミーラベリーダンススタジオ主宰のアミーラ・ナスチャー。北九州市出身アミーラベリーダンサー&インストラクター　ASAMI。いずれのレッスンも初めての人にもわかりやすくレッスンいたします。レッスンはもちろん日本語で行いますので、ご安心ください！
  whole_staff_image_hash32fef89ed4be376a
  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
  score5.00
  kuchikomi_count2
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:07:06
  memo(null)
  1(object)
  id3015167
  name和なび　日本舞踊教室
  branch_name
  city_id921
  schoolgroup_id(null)
  mail_addressinfo@wa-nabi.com
  lat35.434847800000
  lon139.618049500000
  telephone_number070-6634-0876
  homepage_urlhttp://www.wa-nabi.com/
  mobile_homepage_url
  blog_urlhttp://ameblo.jp/wanabi-official/
  open_hour11:00-21:00
  holiday不定休
  post_code(null)
  town_address新川町4-25
  building和なび　日本舞踊教室
  image_hashcd7b37371e46e108
  image_extension_type2
  message_image_hash045ea9be573a4564
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title日本の伝統文化「日本舞踊」を楽しく習える♪
  message_body普通の習い事じゃなくってもっと個性的な習い事始めませんか？和なびは和を学び和をナビゲーションするそんな場でありたいと開設されました。お子様の躾や能力開発・女性の姿勢改善やダイエット。日本の伝統文化である日本舞踊を和なびで気軽に初めてみてくださいね(o^^o) マンツーマンレッスンを中心に日本舞踊を踊ります。担当する先生は現役で活躍するプロの日本舞踊家優しく丁寧に初心者にも指導いたします。キッズからシニアまで幅広く対応しているので、お孫さんと一緒に通うこともできますよ♪ まずは30分体験レッスンにお越しください！
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title花助先生
  whole_staff_introduction■プロフィール 3歳から七々扇流家元の長女としてお稽古を開始。 18歳で名取（七々扇花寿沙）師範免許を取得。本年三代目七々扇花助を襲名。 ■性格元気で明るい。 ■ひとこと皆さんの日常の中で和なびがちょっとしたスパイスになったら嬉しく思います。楽しく和やかお時間を一緒に体感していきましょう！楽しくお稽古できるよう皆さんをサポートいたします。
  whole_staff_image_hash0af9583847ae1cde
  whole_staff_image_extension_type3
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score5.00
  kuchikomi_count1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:07:12
  memo(null)
  2(object)
  id3015110
  nameグラスコートバレエアカデミー
  branch_name東京・自由が丘スタジオ
  city_id782
  schoolgroup_id136
  mail_addressinfo@grass-court-ballet.com
  lat35.6093076
  lon139.6706163
  telephone_number03-6426-8308
  homepage_urlhttp://www.grass-court-ballet.com/
  mobile_homepage_urlhttp://www.grass-court-ballet.com/
  blog_urlhttp://ameblo.jp/grass-court-ballet/
  open_hour電話受付　11:00～21:00
  holiday日曜日・月曜日
  post_code
  town_address自由が丘1-3-22
  building
  image_hash0c91c6ef18cb1c58
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title自由が丘駅より徒歩3分！子供も、大人も、「楽しく・美しく」！
  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_course1
  has_beginner_course1
  score5.00
  kuchikomi_count1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:07:09
  memo(null)
- SearchTransitableToPrefecturePage(object)
- 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
  14(object)
  id15
  name日本舞踊
  slugjapan
  description舞踊という言葉は明治の初めに造られた翻訳造語の一つで、日本舞踊＝日本のダンスの総称となります。略して「日舞」や「邦舞」とも呼ばれます。日本舞踊には200を超える流派があり、特に花柳流・藤間流・若柳流・西川流・坂東流が「五大流派」と呼ばれています。日本舞踊の中でも、神楽や雅楽などのように舞台上を荘厳な音楽や歌に合わせて廻るものを「舞い」。盆踊りのように軽快な音楽に合わせて拍子をとりながら踊るものを「踊り」。歌舞伎のように歌や音楽に合わせて日常的な動きやしぐさを表現するものを「振り」と分類されます。
  15(object)
  id16
  nameポールダンス
  slugpole
  descriptionポールダンスとは垂直のポール（柱）を使ったダンス、エクササイズの事で、ダンスステージよりもサーカスなどでのショーとして用いられる場合が多いダンスです。ポールの上り下りや、倒立、ポールを中心にして回転するなどの動作を組み合わせてダンスを行うもので、フロアでのダンスとは大きく性質が異なります。ポールダンスはその性質上十分な筋力を必要とする技も多く、体を鍛えるためのエクササイズやトレーニングとしても注目されています。
  16(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 => '216.73.216.215'
	)
)
$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	216.73.216.215

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	/home/index/prefectureId:18
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/home/index/prefectureId:18
Remote Port	57412
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	216.73.216.215
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http Cookie	PHPSESSID=s0bo4t6n74emkcgtt78192154dqgq47f
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	216.73.216.215
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	216.73.216.215
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	aT6LQlevSqgXAju8Bva_UAAAATk
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	aT6LQlevSqgXAju8Bva_UAAAATk
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1765706562.6747
Request Time	1765706562

====

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/HomeController.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/ToPrefecturePage.php
  12APP/class/Sgv/Front/SearchTransitable/ToPrefecturePage.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/CategorySchoolAttachment/ToSchoolSet.php
  18APP/class/Sgv/Front/AttachableToDataSet/CategorySchool.php
  19APP/class/Sgv/Front/MemberAttachment/ToKuchikomiSet.php
  20APP/class/Sgv/Front/AttachableToDataSet/Member.php
  21APP/class/Sgv/Front/AccessCountKuchikomiAttachment/ToKuchikomiSet.php
  22APP/class/Sgv/Front/AttachableToDataSet/AccessCountKuchikomi.php
  23APP/class/Sgv/Front/SchoolListPageLink/ToCityPage.php
  24APP/class/Sgv/Front/SearchTransitable/ToCityPage.php
  25APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  26APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.php
  27APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
  28APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  29APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  30APP/class/Sgv/Front/SearchTransitable/ToStationPage.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
====

ダンススクール・ダンス教室の口コミ検索ネット

Pickup School 注目のダンススクール・ダンス教室紹介登録はこちらから

アミーラベリーダンススタジオ

和なび　日本舞踊教室

グラスコートバレエアカデミー

Dance School Search ダンススクール検索

全国のダンススクール・教室の中からあなたにピッタリのスクールを探してみましょう！

»Area Search エリア検索

»Category Search カテゴリー検索

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

NewSchool 最近登録されたダンススクール登録(無料)

【のとなつみ先生のアイドルダンス・レッスン】

Personal　Space　Boheme

レンタルスペース目黒フィットネススタジオ

かっぱハウススタジオ

桃山六地蔵キッズダンススクール【京都/伏見区】

Voice ダンススクール口コミ・体験談

スタッフの対応が… (view: 1827 投稿日: 2016/04/08)

環境がお勧めのダンススクールです。 (view: 1609 投稿日: 2015/12/08)

とても親切丁寧に教えて頂きました (view: 1227 投稿日: 2020/12/27)

マリ先生がエレガントかつカッコいい (view: 1256 投稿日: 2019/12/17)

上達が早いです (view: 1129 投稿日: 2019/12/10)

Select School ダンススクールの選び方

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Dancers Special Column スペシャルコラム

ユーコ・スミダ・ジャクソンさんのコラム

河邉こずえさんのコラム

マスヨシ（HOMEBOY）さんのコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

Special Column

Memory

Timers

ダンススクール・ダンス教室の口コミ検索ネット

Pickup School 注目のダンススクール・ダンス教室紹介 登録はこちらから

Dance School Search ダンススクール検索

全国のダンススクール・教室の中からあなたにピッタリのスクールを探してみましょう！

»Area Search エリア検索

»Category Search カテゴリー検索

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

NewSchool 最近登録されたダンススクール 登録(無料)

Voice ダンススクール口コミ・体験談

スタッフの対応が… (view: 1827 投稿日: 2016/04/08)

環境がお勧めのダンススクールです。 (view: 1609 投稿日: 2015/12/08)

とても親切丁寧に教えて頂きました (view: 1227 投稿日: 2020/12/27)

マリ先生がエレガントかつカッコいい (view: 1256 投稿日: 2019/12/17)

上達が早いです (view: 1129 投稿日: 2019/12/10)

Select School ダンススクールの選び方

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Dancers Special Column スペシャルコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

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

Pickup School 注目のダンススクール・ダンス教室紹介登録はこちらから

NewSchool 最近登録されたダンススクール登録(無料)