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

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key7ee961188108f3b1a468526fe2f861e4b562823f
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  7ee961188108f3b1a468526fe2f861e4b562823f1632716447
====
Request
+
Request

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

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerhome
  actionindex
  plugin(null)
- template/
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 72 queries / 0.062227 sec

No.

time

query

0.001507

connect

0.000577

DESCRIBE `summary_count_school`

0.001087

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

DESCRIBE `school`

0.020747

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

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

0.000467

DESCRIBE `category_school`

0.000337

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

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

0.000347

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

0.000417

DESCRIBE `city`

0.000307

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('634', '1974', '1470'))

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

0.000397

DESCRIBE `prefecture`

0.000357

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 ('3015568', '3016175', '3015654'))

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

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					4032	Using where; Using filesort

0.000327

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('1373', '731', '1450', '1450', '1467'))

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

0.000357

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3016321', '3016320', '3016319', '3016318', '3016317'))

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

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					4032	Using where

0.000527

DESCRIBE `kuchikomi`

0.005417

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', '3014181', '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', '3014356', '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', '3014525', '3014526', '3014532', '3014533', '3014534', '3014535', '3014536', '3014537', '3014538', '3014539', '3014541', '3014542', '3014543', '3014544', '3014545', '3014546', '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', '3014696', '3014697', '3014698', '3014700', '3014701', '3014702', '3014703', '3014704', '3014705', '3014706', '3014709', '3014710', '3014711', '3014712', '3014713', '3014714', '3014715', '3014716', '3014717', '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', '3014968', '3014969', '3014970', '3014972', '3014973', '3014975', '3014976', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3014984', '3014985', '3014989', '3014991', '3014992', '3014993', '3015001', '3015004', '3015007', '3015010', '3015018', '3015019', '3015020', '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', '3015121', '3015122', '3015123', '3015125', '3015127', '3015128', '3015129', '3015130', '3015131', '3015133', '3015134', '3015135', '3015136', '3015139', '3015140', '3015141', '3015142', '3015143', '3015144', '3015145', '3015146', '3015147', '3015149', '3015150', '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', '3015437', '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', '3015661', '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', '3015822', '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', '3015945', '3015947', '3015948', '3015949', '3015950', '3015951', '3015952', '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', '3016017', '3016018', '3016019', '3016020', '3016021', '3016022', '3016023', '3016024', '3016025', '3016026', '3016027', '3016028', '3016029', '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', '3016221', '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', '3016252', '3016253', '3016254', '3016255', '3016256', '3016257', '3016258', '3016260', '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')) 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.000577

DESCRIBE `member`

0.000357

SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('3149', '3111', '3602', '3099', '3099'))

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

0.000427

DESCRIBE `access_count_kuchikomi`

0.000337

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1338', '1335', '1351', '1333', '1334'))

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

DESCRIBE `basic_knowledge`

0.000277

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

DESCRIBE `event_audition`

0.000427

SELECT `e_a`.* FROM `event_audition` AS `e_a` WHERE (e_a.valid = 1) AND (e_a.close_date >= '2021-09-27') 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		3	Using index condition; Using where; Using filesort

0.000417

DESCRIBE `dancer`

0.000507

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

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

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

0.001557

connect

0.000437

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

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

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

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

DESCRIBE `school_station`

0.000377

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

0.000437

DESCRIBE `station`

0.000327

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

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

0.000417

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

0.000297

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

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

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

0.000297

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

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

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

0.000277

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

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

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

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

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

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

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

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

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

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

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

DESCRIBE `dancer_column`

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

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

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

0.000397

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

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

0.000377

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

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

0.000497

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

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC

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

0.000397

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC

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

0.000337

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

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

Message	Memory use
Component initialization	2.13 MB
Controller action start	2.36 MB
Controller render start	5.76 MB
View render complete	6.71 MB

Timers

Total Request Time: 202 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.04
Event: Controller.initialize	0.54
Event: Controller.startup	0.21
Controller action	79.02
Event: Controller.beforeRender	41.71
» Processing toolbar data	36.03
Rendering View	40.46
» Event: View.beforeRender	0.39
» Rendering APP/View/Home/index.ctp	30.78
» » Rendering APP/View/Elements/home/pick-up-school.ctp	13.42
» » Rendering APP/View/Elements/__searchlink/main-column-prefecture.ctp	0.49
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp	0.38
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	3.75
» » Rendering APP/View/Elements/home/new-arrival-school.ctp	2.38
» » » Rendering APP/View/Elements/school-box.ctp	0.42
» » » Rendering APP/View/Elements/school-box.ctp #2	0.36
» » » Rendering APP/View/Elements/school-box.ctp #3	0.28
» » » Rendering APP/View/Elements/school-box.ctp #4	0.24
» » » Rendering APP/View/Elements/school-box.ctp #5	0.21
» » Rendering APP/View/Elements/home/pick-up-kuchikomi.ctp	1.40
» » » Rendering APP/View/Elements/kuchikomi-box.ctp	0.25
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #2	0.16
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #3	0.14
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #4	0.14
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #5	0.14
» » Rendering APP/View/Elements/event/event-box.ctp	1.64
» » Rendering APP/View/Elements/event/event-box.ctp #2	1.09
» » Rendering APP/View/Elements/event/event-box.ctp #3	1.04
» » Rendering APP/View/Elements/home/column.ctp	1.65
» » Rendering APP/View/Elements/home/column.ctp #2	0.81
» » Rendering APP/View/Elements/home/column.ctp #3	0.68
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	8.44
» » Rendering APP/View/Elements/header.ctp	0.40
» » Rendering APP/View/Elements/menu.ctp	6.09
» » » Rendering APP/View/Elements/home/right-menu.ctp	5.89
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.10
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	5.08
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.08
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.07
» » Rendering APP/View/Elements/rtt.ctp	0.10
» » Rendering APP/View/Elements/footer.ctp	0.76
» » 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)
  id14
  name河邉こずえ
  description3歳からクラシックバレエを始め、国内外で数々の賞を受賞。現在は、自ら舞踊創作も行う河邉こずえが語るダンスへの想いとは─
  valid1
  timestamp_created2014-04-24 21:27:25
  timestamp_modified2014-04-24 21:27:25
  1(object)
  id7
  nameスヌーピーJ
  descriptionダンス番組「スーパーチャンプル」（中京テレビ）でEGU-SPLOSION（エグスプローション）として「チャンプルダンサーランキング」初代殿堂入り。TVやショーなどで活動しながら、ダンス大会の審査員などを務める。
  valid1
  timestamp_created2013-08-24 04:19:38
  timestamp_modified2013-08-24 04:19:38
  2(object)
  id13
  nameMatsuya
  description19才の時に上福し、Entartaiment Dance Team『Majestic-5』を結成。様々なコンテストやイベントに出演。マルチな活動でダンス業界と他業種界の架け橋となり、『九州ストリートダンス界のアイコン』として活動中。
  valid1
  timestamp_created2014-03-19 21:11:18
  timestamp_modified2014-03-19 21:15:09
- EventAuditionSet(object)
  0(object)
  id101
  member_id4534
  title仮装でダンス「渋谷ハロウィン世界仮装大会」
  descriptionhttps://note.com/kukkey165/n/na79cc79d94c0 応募
  application_conditionshttps://note.com/kukkey165/n/na79cc79d94c0
  open_date2021-10-01 09:00:00
  close_date2021-10-01 09:00:00
  timetable18時から20時
  price規定曲の代金のみ。謝礼とフランス料理付き。
  organizer渋谷ハロウィン世界仮装大会
  organizer_mail_addresskukkey170@yahoo.co.jp
  organizer_phone_number(null)
  city_id744
  town_address渋谷区宇田川町３－７ヒューリック渋谷公園通ビル 7階
  lat(null)
  lon(null)
  located_place渋谷の結婚式場【ラグナヴェール　アトリエ】渋谷駅徒歩5分 https://atelier.lagunaveil.com/access/
  category_id3
  event_type2
  image_hash(null)
  image_extension_type(null)
  valid1
  timestamp_created2021-05-10 05:22:52
  timestamp_modified2021-05-10 05:22:52
  1(object)
  id100
  member_id4534
  title仮装でダンス「渋谷ハロウィン世界仮装大会」
  description出場者募集。コロナで暗い時世を芸能で明るくしたい方「渋谷ハロウィン世界仮装大会」10月1日優勝3万円仮装でダンサー＆歌手＆商店PRのイベント
  application_conditions20歳以上。プロの方優先。ダンス曲は規定曲のみ
  open_date2021-10-01 09:00:00
  close_date2021-10-01 09:00:00
  timetable18時から20時
  price規定曲の代金のみ。謝礼とフランス料理付き。
  organizer渋谷ハロウィン世界仮装大会
  organizer_mail_addresskukkey170@yahoo.co.jp
  organizer_phone_number(null)
  city_id744
  town_address渋谷区宇田川町３－７ヒューリック渋谷公園通ビル 7階
  lat(null)
  lon(null)
  located_place渋谷の結婚式場【ラグナヴェール　アトリエ】渋谷駅徒歩5分 https://atelier.lagunaveil.com/access/
  category_id3
  event_type2
  image_hash(null)
  image_extension_type(null)
  valid1
  timestamp_created2021-05-09 04:59:50
  timestamp_modified2021-05-09 04:59:50
  2(object)
  id99
  member_id4534
  title仮装でダンス「渋谷ハロウィン世界仮装大会」
  description出場者募集。コロナで暗い時世を芸能で明るくしたい方「渋谷ハロウィン世界仮装大会」10月1日優勝3万円仮装でダンサー＆歌手＆商店PRのイベント
  application_conditions20歳以上。プロの方優先。ダンス曲は規定曲のみ
  open_date2021-10-01 09:00:00
  close_date2021-10-01 09:00:00
  timetable18時から20時
  price規定曲の代金のみ。謝礼とフランス料理付き。
  organizer渋谷ハロウィン世界仮装大会
  organizer_mail_addresskukkey170@yahoo.co.jp
  organizer_phone_number(null)
  city_id744
  town_address渋谷区宇田川町３－７ヒューリック渋谷公園通ビル 7階
  lat(null)
  lon(null)
  located_place渋谷の結婚式場【ラグナヴェール　アトリエ】渋谷駅徒歩5分 https://atelier.lagunaveil.com/access/
  category_id3
  event_type3
  image_hash(null)
  image_extension_type(null)
  valid1
  timestamp_created2021-05-09 04:55:30
  timestamp_modified2021-05-09 04:55:30
- 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)
  id1338
  member_id3149
  school_id3016076
  title初めてでも安心です！
  bodyダンスを習うのが初めてだったので緊張していたんですが、とてもわかりやすく教えてくれるし、教えてくれる人も凄く面白い人だったから凄く楽しかったです！
  score5
  reviewer_nickname
  enrollment_year2016
  level_at_enrollment1
  attending_period2
  ip_address10.4.1.99
  hostname10.4.1.99
  posted_at2016-10-11 20:18:05
  valid1
  timestamp_created2016-10-12 05:18:05
  timestamp_modified2016-10-12 05:18:05
  1(object)
  id1335
  member_id3111
  school_id3016051
  titleようやくたどり着いた本物のタンゴ
  body昔からタンゴが好きで色々なレッスンに通ったり、ミロンガに通ったりしていましたがなかなか上達しませんでした。タンゴレアルは仕事の途中で偶然見つけた場所ですが、大当たりでした。今まで上達しなかった原因を１つ１つ丁寧に教えてくれました。そして、タンゴの醍醐味は新しいステップを闇雲に覚える事ではなく覚えたステップをきれいに正確に踊り、男性のリ－ドを感じる事だと学びました。本場アルゼンチンの雰囲気のスタジオに毎回レッスンに通うのが楽しみです。
  score5
  reviewer_nickname
  enrollment_year2014
  level_at_enrollment1
  attending_period4
  ip_address10.4.1.99
  hostname10.4.1.99
  posted_at2016-08-10 08:51:52
  valid1
  timestamp_created2016-08-10 17:51:52
  timestamp_modified2016-08-10 17:51:52
  2(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
  3(object)
  id1333
  member_id3099
  school_id3015214
  title無くなって悲しい
  body今は、閉館されてしまいました。インストラクターとスタジオプログラムのバラエティさに大変満足していたのですが。再会ならないかな。
  score5
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment2
  attending_period4
  ip_address10.4.1.99
  hostname10.4.1.99
  posted_at2016-07-24 18:26:17
  valid1
  timestamp_created2016-07-25 03:26:17
  timestamp_modified2016-07-25 03:26:17
  4(object)
  id1334
  member_id3099
  school_id3016035
  title子供が大喜びです。
  body子供を体験に連れて行きましたが、インターナショナルに溢れた教室でした。皆さんの評価にある様に、参加の生徒さんも、先生も、ハイレベルです。今後が楽しみです。
  score4
  reviewer_nickname
  enrollment_year2016
  level_at_enrollment1
  attending_period1
  ip_address10.4.1.99
  hostname10.4.1.99
  posted_at2016-07-24 18:41:43
  valid1
  timestamp_created2016-07-25 03:41:43
  timestamp_modified2016-07-25 03:41:43
- NewArrivalSchoolSet(object)
  0(object)
  id3016321
  nameDDPダンススクール
  branch_name
  city_id1373
  schoolgroup_id(null)
  mail_addressinfo.ddpmusic@gmail.com
  lat(null)
  lon(null)
  telephone_number0775486283
  homepage_urlhttps://www.ddp-dance.com
  mobile_homepage_url
  blog_url
  open_hour平日13:00〜22:00 土曜日10:00~22:00
  holiday日曜日
  post_code520-0242
  town_address本堅田4-15-25
  buildingグラン・ドムール大津堅田B102号
  image_hash8d8460dcda1d34c1
  image_extension_type2
  message_image_hash37b59ad6b08e3601
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title大津市堅田にあるDDPダンススクール
  message_body滋賀県大津市堅田にあるダンススクール「DDPダンススクール」です。堅田駅徒歩4分の好立地に2021年11月に新しくオープン！HIP HOP・K-POP・LOCK・Girls HIP HOPなど様々なジャンルと経験豊富なインストラクターが楽しくレッスンしていきます。無料体験・見学随時受け付けております。お気軽にお申し込みください。
  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_created2021-09-19 22:15:43
  timestamp_modified2021-09-19 22:25:45
  memo(null)
  1(object)
  id3016320
  name大田区リトルクーガーズ
  branch_name
  city_id731
  schoolgroup_id(null)
  mail_addresshiphop@little-step.com
  lat
  lon
  telephone_number0367158540
  homepage_urlhttps://little-step.com/dance/
  mobile_homepage_urlhttps://little-step.com/dance/
  blog_urlhttps://little-step.com/blog/
  open_hour9：00～20：00
  holidayなし
  post_code144-0045
  town_address南六郷３－１４－１１
  buildingタケザワビル1階
  image_hashc39a4eb330972df2
  image_extension_type2
  message_image_hash61d2521886fe5470
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title未経験さんでも♪1レッスンで必ず踊れるK-POPやってます♪
  message_bodyK-POPクラスは、小学校・中学生・高校生・大学生・専門学生が対象です！ TWICE/NiziU/ITZY/BTS/SEVENTEEN/BLACKPINK/Stray Kids/etc…様々なK-POPアーティストの最新曲から大人気のを毎回楽しくレッスンしております。リトルクーガーズK-POPクラス体験レッスン随時開催中です♪完全未経験さんでも、先生のマネをし、楽しみながら1レッスンで必ず踊れる様になります♪ 楽しいダンスを目指してダンススクールは敷居が高いとおもっていませんか？？？リトルクーガーズに入ってくれる生徒さんは約10割が未経験でスタートしてます！未経験さんが完璧よりも皆で楽しむ♪ 初心者でも伸び伸び楽しめるダンススクールを目指しています。勉強の息抜きにもおすすめなんです！気持ちさえあれば今すぐ参加してみよう。無料体験レッスンを随時行っております♪ 本当に通わせやすい♪ダンススクールなのでお気軽にお問い合わせ下さい♪ ■ジャンル K-POPクラス、HIPHOPクラス、JAZZHIPHOPクラス、HIPHOP&STREET（HOUSE）クラス対象：幼児（4歳～）小学校・小学校・中学生・高校生・大学生・専門学生 ※K-POPクラスは、小学生からとなっております。リトルクーガーズK-POPクラス大田区南六郷3－14－11　タケザワビル１階 03-6715-8540 こちらのサイトからLINEで簡単にお問い合わせ可能です♪ 体験、詳細などのご不明点が御座いましたらお気軽にLINEください♪ 担当：すずき
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleスタッフ詳細
  whole_staff_introductionホームページにて、全ダンサー（講師）の顔写真とプロフィールが確認できます♪
  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
  score0.00
  kuchikomi_count0
  timestamp_created2021-09-14 12:12:25
  timestamp_modified2021-09-14 13:33:49
  memo(null)
  2(object)
  id3016319
  name地主薫エコール・ド・バレエ梅田北教室
  branch_name
  city_id1450
  schoolgroup_id(null)
  mail_addressyuchan217217@gmail.com
  lat(null)
  lon(null)
  telephone_number0649770095
  homepage_urlhttps://www.jinushi-ballet.com/
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code531-0041
  town_address天神橋7-15-5
  building7F
  image_hash
  image_extension_type0
  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_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2021-09-13 12:55:42
  timestamp_modified2021-09-13 12:55:42
  memo(null)
  3(object)
  id3016318
  nameResoundタップダンスアイリッシュダンスレッスン
  branch_name天満橋スタジオ
  city_id1450
  schoolgroup_id(null)
  mail_addressh.21one8.y@gmail.com
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://resound2021.wixsite.com/tapirishlesson
  mobile_homepage_urlhttps://resound2021.wixsite.com/tapirishlesson
  blog_url
  open_hour
  holiday
  post_code(null)
  town_address天満1丁目6－8
  building六甲天満ビル6階
  image_hash61793a1a522cab6d
  image_extension_type2
  message_image_hash65245f31abf07cf8
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title楽しい音を響かせましょう！
  message_body2021年8月開講！！！大阪福島と天満橋でタップダンスとアイリッシュダンスのレッスンがスタート！お仕事終わりにひと汗流しませんか？？タップアイリッシュダンスの講師歴12年のプロダンサーによるレッスン。楽しみながら、おしゃれにかっこよく踊りましょう！
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title夢
  whole_staff_introduction宝塚歌劇団出身の祖母の影響で、3歳から10年間クラシックバレエを習う。コンクール、フェスティバルに参加。 12歳からタップダンス、アイリッシュダンスを始める。2008年、高校2年生でプロタップダンスユニットに加入。日本各地でショー、イベントに出演。テレビラジオ新聞の取材を受ける。同年、インストラクターとしての活動を開始。現在プレイヤー兼インストラクターとして活動。タップ・アイリッシュダンス歴17年インストラクター歴12年
  whole_staff_image_hash06e8ba80af9dc5a8
  whole_staff_image_extension_type2
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2021-07-24 06:50:34
  timestamp_modified2021-08-03 15:08:28
  memo(null)
  4(object)
  id3016317
  nameResound タップダンスアイリッシュダンスレッスン
  branch_name大阪福島スタジオ
  city_id1467
  schoolgroup_id(null)
  mail_addressh.21one8.y@gmail.com
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://resound2021.wixsite.com/tapirishlesson
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code560-0011
  town_address福島5‐15‐2
  buildingYoshikawa.Bild 203
  image_hash4a8c5fadc7534c6c
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_title楽しい音を響かせましょう！
  message_body2021年8月開講！！！大阪福島と天満橋でタップダンスとアイリッシュダンスのレッスンがスタート！お仕事終わりにひと汗流しませんか？？タップアイリッシュダンスの講師歴12年のプロダンサーによるレッスン。楽しみながら、おしゃれにかっこよく踊りましょう！
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title夢
  whole_staff_introduction宝塚歌劇団出身の祖母の影響で、3歳から10年間クラシックバレエを習う。コンクール、フェスティバルに参加。 12歳からタップダンス、アイリッシュダンスを始める。2008年、高校2年生でプロタップダンスユニットに加入。日本各地でショー、イベントに出演。テレビラジオ新聞の取材を受ける。同年、インストラクターとしての活動を開始。現在プレイヤー兼インストラクターとして活動。タップ・アイリッシュダンス歴17年インストラクター歴12年
  whole_staff_image_hash81dcd676203d0f2d
  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_created2021-07-21 19:04:13
  timestamp_modified2021-08-03 15:08:28
  memo(null)
- PickupSchoolSet(array)
  0(object)
  id3015568
  nameMeary
  branch_name上尾
  city_id634
  schoolgroup_id(null)
  mail_addressmeary.kids.dance@gmail.com
  lat35.9725392
  lon139.5874424
  telephone_number
  homepage_url
  mobile_homepage_url
  blog_urlhttp://ameblo.jp/dncmaho/
  open_hour毎週木曜日 18:30~20:00
  holiday
  post_code
  town_address谷津２-１-50-24
  buildingモリビル３F
  image_hashc7ce13c506078e2a
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_titleアットホームだけど、本格指導☆
  message_bodyあなたもmearyの仲間になって、ダンスをはじめてみませんか？踊りを通して子供の成長、ダンスのスキルアップの２つを考えたレッスンをしていきます。ダンスの楽しさを知る事から、本格指導まで子供達の可能性を引き出します☆ 年に数回の発表会もありますので練習する事の大切さダンスをする楽しさを知る事もできます☆ 体験レッスン無料で行っています！見学だけももちろんOK! お気軽にお問い合わせ下さい。お問い合わせ　meary.kids.dance@gmail.com
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title現役ダンサーが指導致します☆
  whole_staff_introduction■講師　川口眞穂　―経歴― 《コンサート》「TUBE LIVE 2010、2011」バックダンサー KARA 両国国技館　バックダンサー《バックダンサー》「第５９回NHK紅白歌合戦氷川きよし」バックダンサー「第60回NHK紅白歌合戦 GIRL NEXT DOOR」バックダンサー《CM》「AKB48（Beginner）×NTTフレッツ光」振付サポート「AKB48×ぷっちょ」振付けサポート「AKB48(ギンガムチェック)×ぷっちょ」振付けサポート「AKB48(永遠プレッシャー)×ぷっちょ」振付けサポート渋谷DSクリニック CMダンサー au モリ娘振り付けサポート《PV》仮面ライダー主題歌「DIVE INTO THE MIRROR」 AKB48「風は吹いている」振付けアシスタント《コンテスト》 TOKYO　DANCE 　COLLECTION 予選　準優勝《資格》全米ヨガアライアンス
  whole_staff_image_hashe4f6207bf0b7bf12
  whole_staff_image_extension_type2
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score5.00
  kuchikomi_count1
  timestamp_created2014-04-08 09:19:36
  timestamp_modified2021-08-03 15:07:39
  memo(null)
  1(object)
  id3016175
  nameスタジオ　ダンス＆ドリーム
  branch_name
  city_id1974
  schoolgroup_id(null)
  mail_addressy.haya8842@gmail.com
  lat33.593071
  lon130.4015599
  telephone_number092-712-3313
  homepage_urlhttps://www.dance-d.com
  mobile_homepage_urlhttps://www.dance-d.com
  blog_urlhttps://www.facebook.com/danceanddream2017/
  open_hour
  holiday
  post_code810-0001
  town_address天神１丁目１５－２５
  building昭和通り橋口ビルＢ１
  image_hashbee4ab450d200f63
  image_extension_type2
  message_image_hash1932acf748f733a9
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleテーマパーク、ミュージカルダンサー養成
  message_body大手テーマパークダンサー、元劇団四季ダンサーが指導します。ショーダンサーに必要な　バレエ、発声、演劇、ダンスの基礎レッスン（柔軟、ターン、バク宙、側宙）も行います。ダンスの基礎レッスン（体操、柔軟）は、生後６カ月からの親子リズムダンス、小学生コース、中高生コースを備えています。健康志向のヨガも好評です。https://www.dance-d.com
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title講師の集合写真
  whole_staff_introductionこのメンバが指導いたします詳細は、http://www.dance-d.com
  whole_staff_image_hashe6e89df48c1945bc
  whole_staff_image_extension_type2
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score5.00
  kuchikomi_count2
  timestamp_created2017-07-16 03:49:31
  timestamp_modified2021-08-03 15:08:19
  memo(null)
  2(object)
  id3015654
  namemake-B studio
  branch_name
  city_id1470
  schoolgroup_id(null)
  mail_addressinfo@make-b.jp
  lat34.7290391
  lon135.5008232
  telephone_number06-6308-4777
  homepage_urlhttp://www.make-b.jp
  mobile_homepage_urlhttp://www.make-b.jp
  blog_urlhttp://make-b-school.jugem.jp
  open_hour10：00～23：00
  holiday祝日
  post_code532-0011
  town_address西中島5-8-26
  building竹内ビル2Ｆ
  image_hash679a8ca239f4a21a
  image_extension_type2
  message_image_hash52012a74bc125aa1
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title女性限定！マンツーマンor最大５名までの少人数制スクール
  message_body当スクールは女性限定のマンツーマンから少人数制（最大５名まで）の、スキルに合わせたレッスンを提供させて頂いております！インストラクターはアーティストバックダンサーを始め、様々なジャンル（ジャズ、バーレスク、ヒップホップ、ガールズ、バレエ、ロックなど）で現役活躍中のダンサー９名で構成しております。少人数制、プライベート制ですので、ダンス未経験の方からプロを目指す方、多くのジャンルを習いたいなど、年齢に関わらず安心して受講して頂いております。多人数レッスンにありがちな他の受講生とのスキル差や、年齢差、レッスンスケジュール（平日23時まで開講）のご心配などなく受講して頂けます。また、プライベートレッスンだからこそできる、ダンスを習得しながらダイエットや、有名アーティストの振付け完全コピー（ビデオコンボ）も人気のコースです。まずは、お気軽に体験レッスン６０分（１６２０円）を受講して頂き、スクールの楽しさを体感下さい！ ※月～土：10時～23時まで開講　　日曜：要相談　祝日：休講
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title☆経験豊富な実力派講師陣☆
  whole_staff_introductionHIPHOP、Girl's HIPHOP、Street JAZZ、バーレスク、Street DANCEなど･･･様々なジャンルが可能な総勢９名のインストラクターが皆様をお待ちしております！！有名アーティストのバックダンサーや舞台等で活躍中の経験、実力を兼ね備えたインストラクターが個々のスキルとニーズに合わせたレッスンを行います。まずは楽しく！優しく丁寧に！！未経験の方でも安心して受講して頂けます！！
  whole_staff_image_hash3f22f9f07e59fc00
  whole_staff_image_extension_type3
  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_created2014-07-11 23:54:52
  timestamp_modified2021-08-03 15:07:44
  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.235.175.15'
	)
)
$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.235.175.15

CakePHP Constants

Constant	Value
APP	/home/jobikai/dance-schoolgv.net/cakephp/app/
APP_DIR	app
APPLIBS	/home/jobikai/dance-schoolgv.net/cakephp/app/Lib/
CACHE	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/cache/
CAKE	/home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib
CORE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/
CAKE_VERSION	2.3.1
CSS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.dance-schoolgv.net
IMAGES	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/img/
IMAGES_URL	img/
JS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/js/
JS_URL	js/
LOGS	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/logs/
ROOT	/home/jobikai/dance-schoolgv.net/cakephp
TESTS	/home/jobikai/dance-schoolgv.net/cakephp/app/Test/
TMP	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/
VENDORS	/home/jobikai/dance-schoolgv.net/cakephp/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Pwd	/home/userfastcgi/jobikai/dance-schoolgv.net
Shlvl	0
Script Name	/index.php
Request Uri	/
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Remote Port	52004
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.235.175.15
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	3.235.175.15
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	www.dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	3.235.175.15
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	YVE-l0YBWvqV7dB-uiwg8QAAAes
Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1632714647.276
Request Time	1632714647

====

Include
+
Included Files

Include Paths
- 0/home/jobikai/dance-schoolgv.net/cakephp/lib/ZendFramework/library/
- 1/home/jobikai/dance-schoolgv.net/vendor/phpunit/dbunit
- 6/home/jobikai/dance-schoolgv.net/vendor/symfony/yaml
- 3/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-code-coverage
- 4/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-token-stream
- 5/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit
- 7/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-mock-objects
- 8/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-selenium
- 9/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-story
- 10/home/jobikai/dance-schoolgv.net/cakephp/lib
- 12/opt/php-5.6.40-webp/data/pear
- 13-> /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SecurityComponent.php
  1CORE/Controller/Component/SessionComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/Security.php
  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/ToMajorCityPage.php
  24APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.php
  25APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  26APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
  27APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
  28APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  29APP/class/Sgv/Front/InputForm/Auth/Login.php
  30APP/class/Sgv/Front/InputItem/Auth/Login.php
  31APP/class/Sgv/Front/SchoolListPageLink/ToCityPage.php
  32APP/class/Sgv/Front/SearchTransitable/ToCityPage.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 注目のダンススクール・ダンス教室紹介登録はこちらから

Meary 上尾

スタジオ　ダンス＆ドリーム

make-B studio

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

DDPダンススクール

大田区リトルクーガーズ

地主薫エコール・ド・バレエ梅田北教室

Resoundタップダンスアイリッシュダンスレッスン天満橋スタジオ

Resound タップダンスアイリッシュダンスレッスン大阪福島スタジオ

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

初めてでも安心です！ (view: 797 投稿日: 2016/10/11)

ようやくたどり着いた本物のタンゴ (view: 777 投稿日: 2016/08/10)

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

無くなって悲しい (view: 640 投稿日: 2016/07/24)

子供が大喜びです。 (view: 647 投稿日: 2016/07/24)

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

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

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

仮装でダンス「渋谷ハロウィン世界仮装大会」

仮装でダンス「渋谷ハロウィン世界仮装大会」

仮装でダンス「渋谷ハロウィン世界仮装大会」

Dancers Special Column スペシャルコラム

河邉こずえさんのコラム

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

Matsuyaさんのコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

Special Column

Memory

Timers

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

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

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

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

初めてでも安心です！ (view: 797 投稿日: 2016/10/11)

ようやくたどり着いた本物のタンゴ (view: 777 投稿日: 2016/08/10)

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

無くなって悲しい (view: 640 投稿日: 2016/07/24)

子供が大喜びです。 (view: 647 投稿日: 2016/07/24)

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