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

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

Cake Params
- plugin(null)
- controllerhome
- actionindex
- named(array)
  prefectureId12
  cityId743
- pass(empty)
- _Token(array)
  key4f1d09772c091f2df91872e1340a0bbd9458cd5d
  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: 71 queries / 0.095827 sec

No.

time

query

0.001797

connect

0.000577

DESCRIBE `summary_count_school`

0.000747

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

DESCRIBE `school`

0.016537

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

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		233	Using index condition; Using where

0.000577

DESCRIBE `category_school`

0.000397

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

0.000337

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

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

0.000557

DESCRIBE `city`

0.000357

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('752', '1450', '906'))

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

0.000437

DESCRIBE `prefecture`

0.000407

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3014977', '3015720', '3015775'))

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

0.003367

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

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('1492', '771', '1066', '1066', '383'))

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

0.000367

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3016430', '3016429', '3016428', '3016427', '3016426'))

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

0.003217

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

DESCRIBE `kuchikomi`

0.005527

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', '3013992', '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', '3014098', '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', '3014261', '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', '3014501', '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', '3015191', '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', '3015315', '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', '3015359', '3015360', '3015361', '3015362', '3015363', '3015366', '3015367', '3015372', '3015373', '3015374', '3015375', '3015376', '3015377', '3015378', '3015379', '3015380', '3015382', '3015383', '3015384', '3015385', '3015386', '3015389', '3015391', '3015392', '3015393', '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', '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', '3015898', '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', '3016131', '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', '3016229', '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', '3016406', '3016407', '3016408', '3016409', '3016410', '3016411', '3016412', '3016413', '3016414', '3016415', '3016416', '3016417', '3016418', '3016419', '3016420', '3016421', '3016422', '3016423', '3016424', '3016425', '3016426', '3016427', '3016428', '3016429', '3016430')) 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.000817

DESCRIBE `member`

0.000497

SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('4513', '3084', '2844', '3602', '4783'))

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

0.000537

DESCRIBE `access_count_kuchikomi`

0.000417

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1358', '1330', '1300', '1351', '1363'))

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

DESCRIBE `basic_knowledge`

0.000367

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

DESCRIBE `event_audition`

0.000477

SELECT `e_a`.* FROM `event_audition` AS `e_a` WHERE (e_a.valid = 1) AND (e_a.close_date >= '2023-10-03') 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		2	Using index condition; Using where; Using filesort

0.000497

DESCRIBE `dancer`

0.000657

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

SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('4', '7', '10'))

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

0.001727

connect

0.000477

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

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

0.000347

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

SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') LIMIT 1

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

0.000487

DESCRIBE `school_station`

0.000387

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

0.000457

DESCRIBE `station`

0.000327

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

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

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

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

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

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

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

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

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

0.007387

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

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

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

0.000327

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

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

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

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

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

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

DESCRIBE `dancer_column`

0.000387

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '4') 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 = '10') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000357

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

SELECT `c`.`id` FROM `dancer` AS `c` INNER JOIN `dancer_column` AS `d_c` ON c.id = d_c.dancer_id AND d_c.valid = 1 ORDER BY `d_c`.`timestamp_created` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d_c	ALL	ix_dancer_id_dancer_column				29	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	jobikai_dance.d_c.dancer_id	1	Using index

0.000347

SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))

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

0.000397

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

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

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

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

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

Message	Memory use
Component initialization	2.18 MB
Controller action start	2.41 MB
Controller render start	5.76 MB
View render complete	6.69 MB

Timers

Total Request Time: 297 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	11.77
Event: Controller.initialize	0.96
Event: Controller.startup	0.38
Controller action	113.54
Event: Controller.beforeRender	53.85
» Processing toolbar data	46.32
Rendering View	72.80
» Event: View.beforeRender	5.28
» Rendering APP/View/Home/index.ctp	48.18
» » Rendering APP/View/Elements/home/pick-up-school.ctp	26.46
» » Rendering APP/View/Elements/__searchlink/main-column-prefecture.ctp	0.60
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp	0.45
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	4.51
» » Rendering APP/View/Elements/home/new-arrival-school.ctp	2.72
» » » Rendering APP/View/Elements/school-box.ctp	0.45
» » » Rendering APP/View/Elements/school-box.ctp #2	0.34
» » » Rendering APP/View/Elements/school-box.ctp #3	0.30
» » » Rendering APP/View/Elements/school-box.ctp #4	0.28
» » » Rendering APP/View/Elements/school-box.ctp #5	0.28
» » Rendering APP/View/Elements/home/pick-up-kuchikomi.ctp	2.23
» » » Rendering APP/View/Elements/kuchikomi-box.ctp	0.39
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #2	0.24
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #3	0.23
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #4	0.23
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #5	0.22
» » Rendering APP/View/Elements/event/event-box.ctp	2.55
» » Rendering APP/View/Elements/event/event-box.ctp #2	1.55
» » Rendering APP/View/Elements/home/column.ctp	2.45
» » Rendering APP/View/Elements/home/column.ctp #2	0.98
» » Rendering APP/View/Elements/home/column.ctp #3	0.90
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	17.92
» » Rendering APP/View/Elements/header.ctp	0.47
» » Rendering APP/View/Elements/menu.ctp	14.32
» » » Rendering APP/View/Elements/home/right-menu.ctp	14.08
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.11
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	12.84
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.14
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.10
» » Rendering APP/View/Elements/rtt.ctp	0.17
» » Rendering APP/View/Elements/footer.ctp	1.29
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.11
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- DancerSet(array)
  0(object)
  id4
  nameプラクルティ
  descriptionボリウッドダンスプロダクション"Bollywood grooves"のオーディションを突破しU.K.各地のイベント、カジノ、TVなどでステージの経験を積む。インド領事館公認のボリウッドダンサーであり関西最大級のインド祭り”インディアメーラー”で主要ステージや、国の独立記念セレモニーでのダンスを務めるなどインド文化を担って活動している。
  valid1
  timestamp_created2013-06-26 02:31:59
  timestamp_modified2013-06-29 03:08:46
  1(object)
  id10
  nameU-ki (CRAZY BOMB)
  descriptionDANCE歴11年CRAZY BOMB として数々のコンテスト、ショーにゲスト出演、ブランドプロデュースなど幅広く活動中、またジャーク、ドギーなどの最新のノリを自分のフィルターを通したオリジナルなノリは、中毒性が高い！またアメリカ村Goodiesにて、ＧORILLA CAMPというクルーを作ってイベントにも精力的に活動中。
  valid1
  timestamp_created2013-12-17 20:10:40
  timestamp_modified2013-12-17 20:10:40
  2(object)
  id7
  nameスヌーピーJ
  descriptionダンス番組「スーパーチャンプル」（中京テレビ）でEGU-SPLOSION（エグスプローション）として「チャンプルダンサーランキング」初代殿堂入り。TVやショーなどで活動しながら、ダンス大会の審査員などを務める。
  valid1
  timestamp_created2013-08-24 04:19:38
  timestamp_modified2013-08-24 04:19:38
- EventAuditionSet(object)
  0(object)
  id103
  member_id228
  titleHolo holo hawaii ハワイアンミュージック＆フラ　<na hoa>
  descriptionハワイで絶大な人気と実力をもつna hoaの来日　ジャパンコンサート。 11/11　静岡/森町文化会館ミキホール 11/12　東京/品川　大井町きゅりあん大ホールグラミー賞ノミネート、ナホクハノハノアワードでも多数ノミネートのナーホア。ハワイ、フラが好きな方も、3人の迫力のある歌声と演奏で、ハワイを感じていただけます。 MCには、TV 「ハワイに恋して」の内野亮さんの楽しいトークもお楽しみください。　ハワイアンミュージックが初めての方、音楽好きな方も、迫力ある演奏は、とても楽しめます。 mcには、テレビ「ハワイに恋して」の内野亮さんの楽しいトークもお楽しみください。皆様のお越しをお待ちしております。 https://magicisland808.com/
  application_conditionsどなたでも
  open_date2023-11-11 00:00:00
  close_date2023-11-11 00:00:00
  timetable(null)
  priceプレミアムシート１１０００円、SS席７５９０円、S席７０４０円、A席６４９０円
  organizerMAGIC ISLAND
  organizer_mail_addressmagicisland414@yahoo.co.jp
  organizer_phone_number08010363686
  city_id1116
  town_address森町森1485
  lat(null)
  lon(null)
  located_place森町文化会館ミキホール
  category_id8
  event_type3
  image_hash(null)
  image_extension_type(null)
  valid1
  timestamp_created2023-06-26 17:05:20
  timestamp_modified2023-06-26 17:05:20
  1(object)
  id102
  member_id228
  titleHolo holo hawaii ハワイアンミュージック＆フラ　<na hoa>
  descriptionハワイで絶大な人気と実力をもつna hoaの来日　ジャパンコンサート。 11/11　静岡/森町文化会館ミキホール 11/12　東京/品川　大井町きゅりあん大ホールグラミー賞ノミネート、ナホクハノハノアワードでも多数ノミネートのナーホア。ハワイ、フラが好きな方も、3人の迫力のある歌声と演奏で、ハワイを感じていただけます。 MCには、TV 「ハワイに恋して」の内野亮さんの楽しいトークもお楽しみください。　ハワイアンミュージックが初めての方、音楽好きな方も、迫力ある演奏は、とても楽しめます。 mcには、テレビ「ハワイに恋して」の内野亮さんの楽しいトークもお楽しみください。皆様のお越しをお待ちしております。 https://magicisland808.com/
  application_conditionsどなたでも
  open_date2023-11-12 00:00:00
  close_date2023-11-12 00:00:00
  timetable(null)
  priceプレミアムシート１１０００円、SS席７５９０円、S席７０４０円、A席６４９０円
  organizerMAGIC ISLAND
  organizer_mail_addressmagicisland414@yahoo.co.jp
  organizer_phone_number08010363686
  city_id743
  town_address東大井5-18-1
  lat(null)
  lon(null)
  located_place品川　大井町きゅりあん　大ホール
  category_id8
  event_type3
  image_hash(null)
  image_extension_type(null)
  valid1
  timestamp_created2023-06-26 17:00:58
  timestamp_modified2023-06-26 17:00:58
- 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)
  id1358
  member_id4513
  school_id3015019
  title出会えて良かった
  body初心者の私にも優しくわかりやすかったです。このフラダンス教室、吉田先生で出会えて良かったです。
  score5
  reviewer_nickname
  enrollment_year2018
  level_at_enrollment1
  attending_period4
  ip_address10.0.1.146
  hostname10.0.1.146
  posted_at2021-04-11 14:41:17
  valid1
  timestamp_created2021-04-11 23:41:17
  timestamp_modified2021-04-11 23:41:17
  1(object)
  id1330
  member_id3084
  school_id3016035
  title一流のダンス&英語レッスン
  body小学生の娘がGWの体験に参加しました。娘は楽しい楽しいと繰り返し言っており、親の目からもダンスを習いながら、英語も耳、目、身体で習得していく娘を見ると、このカリキュラムは効果が大きいと感じました。一流のダンサーさんの自然な英語と丁寧なダンスレッスンは、とても魅力的で、50歳の私も受講予定です。
  score5
  reviewer_nickname
  enrollment_year2016
  level_at_enrollment1
  attending_period1
  ip_address10.4.1.99
  hostname10.4.1.99
  posted_at2016-07-05 00:31:16
  valid1
  timestamp_created2016-07-05 09:31:16
  timestamp_modified2016-07-05 09:31:16
  2(object)
  id1300
  member_id2844
  school_id3014932
  titleアットホームな雰囲気でダンスを楽しむことができます
  body職場の知人に誘われてダンスを習うことになりました。ひっっぷホップはハードな動きで疲れそうなイメージでしたけど、やり始めは戸惑いましたけど、講師の方が丁寧に指導してくださったので覚えも早くてダンスが楽しくなりました。今では通うことが楽しくなり日々の生活も充実するようになりました。リーズナブルな料金で誰でも気軽に参加できるスクールの雰囲気もとても良いと感じています。ダンスに興味がある方には是非お勧めのダンススクールです。
  score3
  reviewer_nickname
  enrollment_year2013
  level_at_enrollment1
  attending_period2
  ip_address14.9.148.160
  hostnameM014009148160.v4.enabler.ne.jp
  posted_at2015-12-01 18:33:52
  valid1
  timestamp_created2015-12-02 03:33:52
  timestamp_modified2015-12-02 03:33:52
  3(object)
  id1351
  member_id3602
  school_id3014495
  titleマリ先生に憧れて通い出した教室です！
  body3回完結コースでは、そう難しくはないのに、かっこいい振りで、エネルギー溢れるマリ先生と音楽にのせられ、とてもわくわく胸踊る時間を過ごすことができます。フラメンコのノリを感じさせてくれるとても面白い時間を提供してくださいます。先生の鍛え上げられた筋肉も必見です。
  score5
  reviewer_nickname
  enrollment_year2016
  level_at_enrollment2
  attending_period5
  ip_address10.4.1.16
  hostname10.4.1.16
  posted_at2019-12-13 10:38:37
  valid1
  timestamp_created2019-12-13 19:38:37
  timestamp_modified2019-12-13 19:38:37
  4(object)
  id1363
  member_id4783
  school_id3014056
  title行きたくなる場所(^-^)
  body毎回のレッスンを楽しみにしています。発表会に向けての練習はもちろん、ハロウィンやクリスマスの踊りも楽しいです✨
  score5
  reviewer_nickname
  enrollment_year2018
  level_at_enrollment1
  attending_period5
  ip_address106.73.14.99
  hostnameM106073014099.v4.enabler.ne.jp
  posted_at2021-10-22 16:06:50
  valid1
  timestamp_created2021-10-22 16:06:50
  timestamp_modified2021-10-22 16:06:50
- NewArrivalSchoolSet(object)
  0(object)
  id3016430
  nameひかり
  branch_name
  city_id1492
  schoolgroup_id(null)
  mail_addressrurireno7@gmail.com
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://rurireno7.wixsite.com/hikari
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code584-0026
  town_address緑ヶ丘町5-37
  building
  image_hash2dca531eed508546
  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_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_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2023-09-29 18:38:00
  timestamp_modified2023-09-30 13:43:13
  memo(null)
  1(object)
  id3016429
  nameYURIエコール・ド・バレエ・コンテンポラ
  branch_name
  city_id771
  schoolgroup_id(null)
  mail_addresslayuri77@msn.com
  lat(null)
  lon(null)
  telephone_number0367558385
  homepage_urlhttps://yuriecoledeballet.amebaownd.com/
  mobile_homepage_url
  blog_url
  open_hour
  holiday木曜・日曜
  post_code191-0031
  town_address高幡1006-1
  buildingヴィラ・フェレイロ102
  image_hash7ae4607a93d921d9
  image_extension_type2
  message_image_hashecaf1e91ec18a768
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title日野市高幡不動バレエスクール
  message_body どんなことでも、高いレベルができるようになるには基礎が重要となりすべてのダンスにおいて上達のために重要なのは筋力と体幹の強化です。 YURIエコール・ド・バレエ・コンテンポラではクラシックバレエの正しい基礎を身につけながらバレエをベースにより自由で現代的なコンテンポラリーダンスを学ぶことができます。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title代表・講師　
  whole_staff_introduction田中ゆり小川亜矢子、木佐貫邦子に師事。木佐貫邦子＋ｎｅｏのメンバーとして「ダンスの場所Vol1」　ラフォーレミュージアム赤坂「忘れた記憶は私を覚えているか」さいたま芸術劇場、アートスフィア、シアタードラマシティー「ダンスの場所Vol2」新宿パークタワーホール「ダンスの場所Vol3　Cat Cat Dog Dog」北沢タウンホールほか数々の舞台で踊る。フランスへ短期留学。イヴ・カサッティに師事する。パリ・オペラ座バレエ学校教授法（ペタゴジー）修了。ローザンヌバレエコンクール日本事業部主催バレエセミナーにて解剖学的アプローチによるバレエ指導法と解剖学を学ぶ。1997年より指導を始め2009年高幡不動に移りユリ・エコール・ド・バレエ・コンテンポラを設立。2010年　東京オペラシティ近江楽堂「リュミエール　Bach et Danse」でヴィオロンチェロ・ダ・スパラの演奏家ディミトリー・バディアロフと共演。バー・アスティエ指導者資格認定。NPO法人バー・アスティエ協会よりディプロマ認定、ディプロマ取得。THE ASSOTIATION OF DANCE TEACHERS会員。
  whole_staff_image_hash12d9b79c2bc4126e
  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_created2023-09-29 14:31:59
  timestamp_modified2023-09-29 14:49:49
  memo(null)
  2(object)
  id3016428
  name中高年と初心者のアルゼンチンタンゴ教室サロンミロンガ
  branch_name岐阜教室
  city_id1066
  schoolgroup_id(null)
  mail_addresssoy-andaluz@r2.dion.ne.jp
  lat(null)
  lon(null)
  telephone_number09056299101
  homepage_urlhttps://soy-andaluz.wixsite.com/milongagifu
  mobile_homepage_urlhttps://soy-andaluz.wixsite.com/milongagifu
  blog_url
  open_hour13:30〜14:30
  holiday
  post_code500-8838
  town_address八幡町33
  building三輪ビル3階
  image_hash45b8a074f5248ae7
  image_extension_type2
  message_image_hash92a5e0043ecc9031
  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_course1
  score0.00
  kuchikomi_count0
  timestamp_created2023-09-23 22:49:27
  timestamp_modified2023-09-23 22:54:34
  memo(null)
  3(object)
  id3016427
  nameベリーダンス教室イスタンブール
  branch_name岐阜教室
  city_id1066
  schoolgroup_id(null)
  mail_addresssoy-andaluz@r2.dion.ne.jp
  lat
  lon
  telephone_number09056299101
  homepage_urlhttps://soy-andaluz.wixsite.com/bellydanceistanbul/lessonandfee
  mobile_homepage_urlhttps://soy-andaluz.wixsite.com/bellydanceistanbul/lessonandfee
  blog_url
  open_hour19:00〜21:00
  holiday
  post_code500-8838
  town_address八幡町33
  building三輪ビル3階
  image_hasha12e3bac0e8b2c00
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_title大人女子のベリーダンス教室
  message_body岐阜市八幡町(金公園そば)にあるあなたが楽しめるベリーダンス教室イスタンブールです。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title私が教えています
  whole_staff_introduction「岐阜の妖精」と呼ばれるアイリ先生。とても親切で親しみやすいので、レッスンがとても楽しくなります
  whole_staff_image_hashff57bc4a2ca0373f
  whole_staff_image_extension_type2
  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_created2023-09-23 22:11:40
  timestamp_modified2023-09-23 22:21:02
  memo(null)
  4(object)
  id3016426
  nameレーヴ・バレエスタジオ
  branch_name
  city_id383
  schoolgroup_id(null)
  mail_addressreveballetstudio@gmail.com
  lat
  lon
  telephone_number
  homepage_urlhttp://reveballetstudio.com/
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code997-0016
  town_address日和田町7-10
  buildingレンタルスタジオFalajSpace(ファラジスペース)
  image_hash487b536d0bd7bdc3
  image_extension_type2
  message_image_hashab25c310295b97c3
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleバレエ好きが集まるスタジオです！
  message_body2021年7月にスタートしたクラシックバレエ教室です。場所は鶴岡市日和田町にあるレンタルスタジオ FalajSpace(ファラジスペース)様をお借りしています。踊ることが好きな方、始めてみたい方なら年齢性別問わず丁寧に指導いたします。まずはお問い合わせください。
  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_created2023-08-06 02:26:33
  timestamp_modified2023-08-06 02:53:33
  memo(null)
- PickupSchoolSet(array)
  0(object)
  id3014977
  nameヒラソル銀座ダンススクール
  branch_name
  city_id752
  schoolgroup_id(null)
  mail_addressyoikonodance@hotmail.co.jp
  lat35.670647600000
  lon139.768592200000
  telephone_number03-6226-4500
  homepage_urlhttp://girasolginza.jp/
  mobile_homepage_url
  blog_urlhttp://ameblo.jp/girasolginza/
  open_hour平日17：00～22：00　土日11：00～19：00
  holidayなし
  post_code(null)
  town_address銀座３－１１－８
  building第六丸嘉ビル４F５F
  image_hash2c9e87c60c31c318
  image_extension_type2
  message_image_hasha082b9563c46108a
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title民族舞踊系に強い！銀座のダンススクールです。
  message_bodyあなたのやりたかったことがここにあります。ありそうでなかった、民族舞踊系に強い！ジャンル豊富な銀座のダンススクールです。銀座のど真ん中で各国の文化が学べるスクールです。入門・初心者大歓迎！最初は誰でも初心者です。安心してどうぞ扉を開いてください。レッスンジャンル・バーレスク・サルサ・タンゴ・ベリーダンス・ハワイアン・タヒチアン・ミュージカル・JAZZ・ロックダンス・アフロ・ヒールダンス・ストリート・バレエ・ラテンJAZZ等… ・各オーディション対応の芸能コースもあります。自分磨きは楽しいです。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title朗らかで家庭的なスタッフ陣
  whole_staff_introductionきめの細かいサービスを心掛けております。ご意見ご要望ございましたらお気軽にお申し付けくださいませ。
  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:00
  memo(null)
  1(object)
  id3015720
  nameごとうフラメンコアカデミー学院
  branch_name
  city_id1450
  schoolgroup_id(null)
  mail_addressminami@clover-salon.com
  lat34.6932103
  lon135.5142307
  telephone_number
  homepage_urlhttp://www.estudio-primavera.net/
  mobile_homepage_url
  blog_url
  open_hour10時～22時
  holiday
  post_code(null)
  town_address天満4-5-20
  building
  image_hasha41d6a13ef99ad45
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  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_course1
  score5.00
  kuchikomi_count1
  timestamp_created2014-10-18 04:42:57
  timestamp_modified2021-08-03 15:07:49
  memo(null)
  2(object)
  id3015775
  name大沢キッズ＆ガールズダンス教室
  branch_name
  city_id906
  schoolgroup_id(null)
  mail_addressosawadance2015@gmail.com
  lat35.411603
  lon139.4910419
  telephone_number
  homepage_urlhttp://osawadance2015.wix.com/osawa-kidsdance#!home/mainPage
  mobile_homepage_urlhttp://osawadance2015.wix.com/osawa-kidsdance#!home/mainPage
  blog_url
  open_hour
  holiday
  post_code
  town_address3511-9
  buildingテアトルフォンテ内
  image_hash35cef08f4608a8fb
  image_extension_type2
  message_image_hash031d07b1fe25c384
  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大沢先生
  whole_staff_introduction泉区戸塚区を中心に20年以上、ジャズダンスの指導実績があります。
  whole_staff_image_hash
  whole_staff_image_extension_type0
  is_kuchikomi_notice_mail_receiving0
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score5.00
  kuchikomi_count3
  timestamp_created2015-01-26 10:12:53
  timestamp_modified2021-08-03 15:07:53
  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 => '3.237.31.191'
	)
)
$oddTrOptions = array(
	'class' => 'odd'
)
$evenTrOptions = array(
	'class' => 'even'
)
$useCount = false
$continueOddEven = false
$count = (int) 18
$line = array(
	(int) 0 => 'QWINTET_IP',
	(int) 1 => array(
		(int) 0 => '122.216.11.82'
	)
)
$cellsOut = array(
	(int) 0 => '<td>QWINTET_IP</td>'
)
$i = (int) 0
$cell = array(
	(int) 0 => '122.216.11.82'
)
$cellOptions = array()
$options = ' class="odd"'
$out = array(
	(int) 0 => '<tr class="odd"><td>SGV_ENV</td> <td>development</td></tr>',
	(int) 1 => '<tr class="even"><td>DEBUGKIT_ON</td> <td>1</td></tr>',
	(int) 2 => '<tr class="odd"><td>MENTE_FLAG</td> <td></td></tr>',
	(int) 3 => '<tr class="even"><td>SGV_APP_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/</td></tr>',
	(int) 4 => '<tr class="odd"><td>CONFIG_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Config/</td></tr>',
	(int) 5 => '<tr class="even"><td>LIB_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/</td></tr>',
	(int) 6 => '<tr class="odd"><td>MODEL_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Model/</td></tr>',
	(int) 7 => '<tr class="even"><td>CLASS_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/class/</td></tr>',
	(int) 8 => '<tr class="odd"><td>THUMBLIB_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb</td></tr>',
	(int) 9 => '<tr class="even"><td>THUMBLIB_PLUGIN_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/</td></tr>',
	(int) 10 => '<tr class="odd"><td>DEFAULT_THUMBLIB_IMPLEMENTATION</td> <td>gd</td></tr>',
	(int) 11 => '<tr class="even"><td>USER_STATIC_SALT</td> <td>Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z</td></tr>',
	(int) 12 => '<tr class="odd"><td>SITE_TITLE</td> <td>ダンススクール・ダンス教室口コミ検索ネット</td></tr>',
	(int) 13 => '<tr class="even"><td>OPERATOR_MAIL_ADDRESS</td> <td>info@kuchi.info</td></tr>',
	(int) 14 => '<tr class="odd"><td>NO_REPLY_MAIL_ADDRESS</td> <td>no-reply@kuchi.info</td></tr>',
	(int) 15 => '<tr class="even"><td>RETURN_PATH__MAIL_ADDRESS</td> <td>errors@kuchi.info</td></tr>',
	(int) 16 => '<tr class="odd"><td>GOOGLE_API_KEY</td> <td>AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0</td></tr>'
)
HtmlHelper::tableCells() - CORE/Cake/View/Helper/HtmlHelper.php, line 867
HtmlToolbarHelper::table() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 160
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 125
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108
ToolbarHelper::table() - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
include - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
include - ROOT/plugins/DebugKit/View/Elements/debug_toolbar.ctp, line 45
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
HtmlToolbarHelper::send() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 193
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 119
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108

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

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:12/cityId:743
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/home/index/prefectureId:12/cityId:743
Remote Port	39810
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	3.237.31.191
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	3.237.31.191
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	3.237.31.191
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZRrkj0f8RWx5r6aF0xQvIQAAAbI
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	ZRrkj0f8RWx5r6aF0xQvIQAAAbI
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1696261263.3158
Request Time	1696261263

====

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/ToStationUnitPage.php
  24APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  25APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  26APP/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
====

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

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

ヒラソル銀座ダンススクール

ごとうフラメンコアカデミー学院

大沢キッズ＆ガールズダンス教室

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

ひかり

YURIエコール・ド・バレエ・コンテンポラ

中高年と初心者のアルゼンチンタンゴ教室サロンミロンガ岐阜教室

ベリーダンス教室イスタンブール岐阜教室

レーヴ・バレエスタジオ

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

出会えて良かった (view: 560 投稿日: 2021/04/11)

一流のダンス&英語レッスン (view: 1041 投稿日: 2016/07/05)

アットホームな雰囲気でダンスを楽しむことができます (view: 1194 投稿日: 2015/12/01)

マリ先生に憧れて通い出した教室です！ (view: 764 投稿日: 2019/12/13)

行きたくなる場所(^-^) (view: 501 投稿日: 2021/10/22)

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

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Audition/Event オーディション・イベント

Holo holo hawaii ハワイアンミュージック＆フラ　<na hoa>

Holo holo hawaii ハワイアンミュージック＆フラ　<na hoa>

Dancers Special Column スペシャルコラム

プラクルティさんのコラム

U-ki (CRAZY BOMB) さんのコラム

スヌーピーJさんのコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

Special Column

Memory

Timers

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

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

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

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

出会えて良かった (view: 560 投稿日: 2021/04/11)

一流のダンス&英語レッスン (view: 1041 投稿日: 2016/07/05)

アットホームな雰囲気でダンスを楽しむことができます (view: 1194 投稿日: 2015/12/01)

マリ先生に憧れて通い出した教室です！ (view: 764 投稿日: 2019/12/13)

行きたくなる場所(^-^) (view: 501 投稿日: 2021/10/22)

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

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Audition/Event オーディション・イベント

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 最近登録されたダンススクール登録(無料)