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

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key1c5aec9cddff194ccce27fd03c237815557c7215
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  1c5aec9cddff194ccce27fd03c237815557c72151653463885
====
Request
+
Request

Cake Params
- plugin(null)
- controllerhome
- actionindex
- named(empty)
- pass(empty)
- _Token(array)
  key1c5aec9cddff194ccce27fd03c237815557c7215
  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: 66 queries / 0.060187 sec

No.

time

query

0.001797

connect

0.000617

DESCRIBE `summary_count_school`

0.000877

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

DESCRIBE `school`

0.018957

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

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

0.000507

DESCRIBE `category_school`

0.000357

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

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

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

0.000447

DESCRIBE `city`

0.000327

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

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

0.000427

DESCRIBE `prefecture`

0.000347

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3015568', '3014899', '3015173'))

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

0.003327

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

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('921', '744', '907', '2111', '904'))

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

0.000417

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

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3016351', '3016350', '3016349', '3016348', '3016347'))

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.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					4031	Using where

0.000627

DESCRIBE `kuchikomi`

0.005387

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', '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', '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', '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', '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', '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', '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', '3016322', '3016323', '3016324', '3016325', '3016326', '3016327', '3016328', '3016329', '3016330', '3016331', '3016333', '3016334', '3016335', '3016336', '3016337', '3016339', '3016340', '3016341', '3016342', '3016343', '3016344', '3016345', '3016346', '3016347', '3016348', '3016349', '3016350', '3016351')) 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.000667

DESCRIBE `member`

0.000387

SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('2996', '3006', '3099', '3601', '3022'))

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

0.000457

DESCRIBE `access_count_kuchikomi`

0.000357

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1313', '1314', '1333', '1350', '1322'))

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

DESCRIBE `basic_knowledge`

0.000387

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

DESCRIBE `event_audition`

0.000407

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

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

0.000477

DESCRIBE `dancer`

0.000627

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

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

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

0.001747

connect

0.000417

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

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

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

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

DESCRIBE `school_station`

0.000347

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

DESCRIBE `station`

0.000297

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

DESCRIBE `schoolgroup`

0.000377

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

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

0.000497

DESCRIBE `category_schoolgroup`

0.000357

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

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

0.000327

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

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

0.000357

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

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

0.000387

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

0.000297

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

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

0.000327

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

DESCRIBE `dancer_column`

0.000347

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

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

0.000347

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

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

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

0.000427

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

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

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

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

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

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

====

Timer

Memory

Peak Memory Use 14.31 MB

Message	Memory use
Component initialization	2.12 MB
Controller action start	2.36 MB
Controller render start	5.57 MB
View render complete	6.98 MB

Timers

Total Request Time: 201 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.35
Event: Controller.initialize	0.76
Event: Controller.startup	0.31
Controller action	78.15
Event: Controller.beforeRender	51.39
» Processing toolbar data	45.29
Rendering View	33.71
» Event: View.beforeRender	0.44
» Rendering APP/View/Home/index.ctp	25.37
» » Rendering APP/View/Elements/home/pick-up-school.ctp	15.21
» » Rendering APP/View/Elements/__searchlink/main-column-prefecture.ctp	0.36
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp	0.28
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	2.89
» » Rendering APP/View/Elements/home/new-arrival-school.ctp	1.47
» » » Rendering APP/View/Elements/school-box.ctp	0.25
» » » Rendering APP/View/Elements/school-box.ctp #2	0.22
» » » Rendering APP/View/Elements/school-box.ctp #3	0.19
» » » Rendering APP/View/Elements/school-box.ctp #4	0.18
» » » Rendering APP/View/Elements/school-box.ctp #5	0.21
» » Rendering APP/View/Elements/home/pick-up-kuchikomi.ctp	1.22
» » » Rendering APP/View/Elements/kuchikomi-box.ctp	0.24
» » » Rendering APP/View/Elements/kuchikomi-box.ctp #2	0.15
» » » 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.16
» » Rendering APP/View/Elements/home/column.ctp	1.46
» » Rendering APP/View/Elements/home/column.ctp #2	0.70
» » Rendering APP/View/Elements/home/column.ctp #3	0.71
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	6.93
» » Rendering APP/View/Elements/header.ctp	0.29
» » Rendering APP/View/Elements/menu.ctp	4.85
» » » Rendering APP/View/Elements/home/right-menu.ctp	4.71
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.07
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	4.16
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.08
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.06
» » Rendering APP/View/Elements/rtt.ctp	0.09
» » Rendering APP/View/Elements/footer.ctp	0.71
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.06
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- DancerSet(array)
  0(object)
  id11
  nameSAYAKA
  description18歳で武富士CMダンサーを務め、数々なアーティストバックアップダンサー・PV・CM出演・雑誌モデル・インストラクターとして活動中。
  valid1
  timestamp_created2014-01-10 19:46:01
  timestamp_modified2014-01-10 19:46:01
  1(object)
  id13
  nameMatsuya
  description19才の時に上福し、Entartaiment Dance Team『Majestic-5』を結成。様々なコンテストやイベントに出演。マルチな活動でダンス業界と他業種界の架け橋となり、『九州ストリートダンス界のアイコン』として活動中。
  valid1
  timestamp_created2014-03-19 21:11:18
  timestamp_modified2014-03-19 21:15:09
  2(object)
  id17
  nameMILO
  description日本とジャマイカで活躍するレゲエダンサー。所属しているATTACK DEM SQUADでは2013年にレゲエの世界大会であるWRDCで優勝し、TV出演やDVDの出版、スクールの講師など広く活動している。
  valid1
  timestamp_created2014-08-21 04:11:09
  timestamp_modified2014-08-21 04:11:09
- EventAuditionSet(object)
- BasicKnowledgeSet(array)
  0(object)
  id1
  titleバレエの種類・特徴
  summaryバレエと一口に言っても、実はその中にはいくつかの種類があります。
  category_id1
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id2
  titleストリートダンスの種類・特徴
  summaryストリートダンスとは路上で自由に踊るダンス全般の事を指し、社交ダンス(ボールルームダンス)のようにダンスホールで踊るようなダンスや、バレエやベリーダンスのように観客に見せるダンス（ショーダンス）ではないものの事です。ストリートダンスと一口に言っても、ステップやフリ、音楽の違いなどによってその種類は様々。分類の方法は場合によって変わってきますが、主な特徴から大体以下の種類に分類されます。
  category_id4
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id3
  titleタップダンスの種類・特徴
  summaryリズミカルなステップでリズムを作りながら踊るのが特徴的なタップダンス。タップダンスは大きく分けると2種類のダンスに分ける事が出来ます。
  category_id5
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  3(object)
  id4
  titleサルサの種類・特徴
  summaryサルサダンスはキューバ発祥のラテンダンスの一つで、サルサミュージックに合わせて踊るものです。サルサダンスは男女ペア、男性リードで踊るダンスのため社交ダンスの一つとして認識されがちですが、基本姿勢やパートナーの考え方などから基本的には別物とされています。サルサの中にもいくつかのダンススタイルがあります。
  category_id6
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  4(object)
  id5
  titleフラメンコの種類・特徴
  summaryフラメンコとはスペイン南部のアンダルシア地方の歌・楽曲と、それに合わせたダンスの事で、踊りながら手や足を使って音を鳴らしていく事が特徴です。フラメンコはコンパスと呼ばれるリズムや曲調によって多くの種類に分かれており、これをパロと言います。踊る際は楽曲の引手と踊り手がパロを決め、それに合わせて踊る形になります。
  category_id7
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  5(object)
  id6
  titleフラダンス・タヒチアンダンスの種類・特徴
  summaryフラダンスとタヒチアンダンスはそれぞれ衣装も動きも似ているため、全て同じダンスだと思われがちですが、実はその中でもいくつかの種類に分かれています。
  category_id8
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  6(object)
  id7
  titleベリーダンスの種類・特徴
  summaryベリーダンスはその踊りの特徴や発祥によっていくつかの種類に分ける事が出来ます。オリエンタルスタイル・エジプシャンスタイル中東地域のベリーダンスを総称してオリエンタルスタイルと呼び、その中でも主要なものがエジプシャンスタイルです。エジプシャンスタイルは基本はソロが多く、優雅で細やかな動きが特徴的なダンスで、エジプトの民族舞踊の動きを取り入れた振りが多いダンスです。音楽は打楽器中心で、衣装は肌の露出が少ないものが基本スタイルとなります。アサヤと呼ばれるステッキを使うのも特徴的です。
  category_id9
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  7(object)
  id8
  title社交ダンス・ボールルームダンスの種類・特徴
  summary社交ダンスとは男女のペアで曲に合わせて踊るダンスで、英語では一般的にBallroom Dance（ボールルームダンス）と呼ばれるものです。社交ダンスのダンススタイルの内、踊られる機会の多いものを紹介します。
  category_id10
  image_hash(null)
  image_extension_type0
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- MemberIconManageable(object)
- PickupKuchikomiSet(array)
  0(object)
  id1313
  member_id2996
  school_id3015775
  title練習風景を観て毎回感激してます。
  bodyまだ1年と経ってませんが、先生と出会ってダンス以外にも、礼儀、礼節、気配り、すべてが勉強なんだと繰り返し子供達に教えている姿を観て、私も色々勉強させてもらえてます。娘が楽しくて頑張るぞと毎回張り切って通ってます。週に1回ですが、毎回2時間みっちり教えてくださり、まだ足りないわよと少し延長してレッスンしてくださるなど、ほんとに熱心で素敵な先生です。月謝は3000円です。娘と私で先生にずっと付いて行きたいです。
  score5
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment1
  attending_period3
  ip_address10.4.1.200
  hostname10.4.1.200
  posted_at2016-03-04 21:53:48
  valid1
  timestamp_created2016-03-05 06:53:48
  timestamp_modified2016-03-05 06:53:48
  1(object)
  id1314
  member_id3006
  school_id3015960
  title明るく清潔感があり、親切。
  body見ているのと、やってみるのではかなりのギャップを感じてしまいました。頭と体がついていかないです(^^; ミュージカルが好きなので、とても華やかで楽しかったです。とても親切に教えてもらい、出来ないところも見ていただき分かりやすく指導いただきました。まわりの上手な人たちも止めてしまうと申し訳ないと思いながらも、わかるように対応していただけました。
  score4
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment1
  attending_period1
  ip_address10.4.1.32
  hostname10.4.1.32
  posted_at2016-03-20 11:09:45
  valid1
  timestamp_created2016-03-20 20:09:45
  timestamp_modified2016-03-20 20:09:45
  2(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
  3(object)
  id1350
  member_id3601
  school_id3014495
  title上達が早いです
  body3回完結コースはフラメンコの雰囲気を楽しめるコースでした。3回で1曲を完成させるので、最初は大変かなと思いましたが、音楽に乗って動けて楽しかったです。
  score5
  reviewer_nickname
  enrollment_year2013
  level_at_enrollment1
  attending_period5
  ip_address10.4.1.16
  hostname10.4.1.16
  posted_at2019-12-10 16:30:39
  valid1
  timestamp_created2019-12-11 01:30:39
  timestamp_modified2019-12-11 01:30:39
  4(object)
  id1322
  member_id3022
  school_id3013291
  titleスタッフの対応が…
  bodyスクールの講師や生徒の雰囲気はまずまずといったところでしたが、スタッフの接客が残念でした。言葉遣いもなっていない中説明も足りず…契約時も選択クラスに関する詳しい説明が無く、後になってから休会すると初心者クラスには復帰ができないだとか、トラブルが起こってはじめてルールの説明があり、質が良く無いと感じました。スタッフの対応でこんなにも教室の印象が変わるのだと感じました。
  score1
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment1
  attending_period2
  ip_address10.4.1.108
  hostname10.4.1.108
  posted_at2016-04-08 19:11:11
  valid1
  timestamp_created2016-04-09 04:11:11
  timestamp_modified2016-04-09 04:11:11
- NewArrivalSchoolSet(object)
  0(object)
  id3016351
  nameワールドステップ
  branch_name
  city_id921
  schoolgroup_id(null)
  mail_addresskx151tetsu@yahoo.co.jp
  lat
  lon
  telephone_number0457151888
  homepage_urlhttps://worldstep.info
  mobile_homepage_urlhttps://worldstep.info
  blog_url
  open_hour13:00~21:00
  holiday日曜日
  post_code232-0052
  town_address横浜市南区井土ヶ谷中町161-3-301
  buildingパークノヴァ横浜井土ヶ谷3F
  image_hash11fec2163973c762
  image_extension_type2
  message_image_hash
  message_image_extension_type0
  is_registered_by_not_owner0
  is_opening1
  message_title初めてでも安心の社交ダンススクール
  message_body【ワールドステップ】は京急井土ヶ谷駅徒歩1分の場所にある社交ダンス教室です。年齢・体力・センスは関係ありません！若い方から80代以上の方まで、たくさんの方に楽しんでいただいています。もちろんダンスのレベルも問いません。「踊ってみたい」という気持ちがあればどなた様でも大歓迎です♪ 楽しいダンスライフのスタートを【ワールドステップ】で切りましょう！♪ 　“楽しく踊れること”にこだわったレッスン♪ ダンスやダンス教室と聞くと「チャレンジしづらい」「入りにくい」と思われる方もたくさんいらっしゃると思います。【ワールドステップ】はそんな方に気軽に入っていただける教室を目指しこだわったレッスンを展開しています。【ワールドステップ】 ▼レベルを問わず上達が見込めるカリキュラム▼ 　レッスンは一人ひとりの年齢や体力、　目的、目標に合わせて進めます。　レベルに応じたわかりやすいカリキュラムですので　まったく初めての方でも　無理なく社交ダンスデビュー可能。　綺麗に踊れるようになります。 ▼レッスン前後に自由時間あり▼ 　せっかくもっと踊りたいと思っても　ご自宅ではなかなか難しいのが社交ダンスです。　そこで【ワールドステップ】では　体操・練習が可能な時間を　レッスン前後に無制限で設けています！（ココ大事なポイントです）　レッスン前に体操をして身体を温めたり、　レッスン後に自主練習をして　習った内容を復習したり、　広いフロアで思う存分ダンスを楽しんでください。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title代表　勝山哲史です
  whole_staff_introduction楽しいレッスンで確実な上達を目指しましょう！
  whole_staff_image_hash636cf83ef1596a53
  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_created2022-04-14 14:58:31
  timestamp_modified2022-04-14 15:29:27
  memo(null)
  1(object)
  id3016350
  nameAGNI Dance school
  branch_name
  city_id744
  schoolgroup_id(null)
  mail_addressdance@agniyoga.jp
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://www.agniyoga.jp/dance/
  mobile_homepage_urlhttps://www.agniyoga.jp/dance/
  blog_url
  open_hour平日10時～17時
  holiday土日祝日
  post_code(null)
  town_address笹塚2丁目18-3
  buildingVORT笹塚ビル8階
  image_hash1ac5e204942e8e69
  image_extension_type3
  message_image_hash2a57b64cc1b26e97
  message_image_extension_type3
  is_registered_by_not_owner0
  is_opening1
  message_titlenewスタジオスタート！
  message_bodyアグニダンススクールです、はじめまして！笹塚駅から徒歩3分のスタジオです。この度ダンススクールをオープンすることになり、新規生徒を大大大募集しています！ ■キッズクラス（3歳～未就学児）毎週水曜　15：30ー16：10 ■ジュニアクラス（6歳～）毎週水曜　16：30ー17：30 なんと！4月中は体験レッスンが何度でも500円/回入会なら入会金無料キャンペーン中！どんなことでもまずはお問い合わせください★ お問い合わせ先：dance@agniyoga.jp
  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_created2022-04-12 22:06:54
  timestamp_modified2022-04-12 22:11:07
  memo(null)
  2(object)
  id3016349
  name満若ダンススタジオin杉田
  branch_name杉田
  city_id907
  schoolgroup_id(null)
  mail_addressmitsuwaka@mitsuwakadance.com
  lat(null)
  lon(null)
  telephone_number0457750584
  homepage_urlhttps://mitsuwakadance.com/
  mobile_homepage_urlhttps://mitsuwakadance.com/
  blog_urlhttps://mitsuwakadance.livedoor.blog/
  open_hour１３：００～２１：００
  holiday日曜日
  post_code235-0033
  town_address杉田１－１９－９
  building吉野ビル４F
  image_hash799b51f61018b9b7
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title(null)
  message_body(null)
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title現在３名のスペシャリストが在籍中です。
  whole_staff_introductionスタッフ全員留学経験豊富なスペシャリストです。初心者から、競技者まで幅広く対応いたします。キッズから、年配者（９０代）まで幅広い年齢層の方が通っておられます。
  whole_staff_image_hash28f3afbcb34fea77
  whole_staff_image_extension_type2
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2022-04-07 17:59:03
  timestamp_modified2022-04-07 18:08:58
  memo(null)
  3(object)
  id3016348
  name熊本サルサ　アマンダ
  branch_name
  city_id2111
  schoolgroup_id(null)
  mail_addresscocobonita9@yahoo.co.jp
  lat(null)
  lon(null)
  telephone_number
  homepage_urlhttps://cocobonita9.wixsite.com/salsa
  mobile_homepage_url
  blog_url
  open_hour
  holiday
  post_code860-0804
  town_address中央区北千反畑町
  building碩台コミュニティセンター
  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_course0
  has_beginner_course0
  score0.00
  kuchikomi_count0
  timestamp_created2022-04-03 17:33:42
  timestamp_modified2022-04-03 17:33:42
  memo(null)
  4(object)
  id3016347
  name横浜青葉ダンススクール YADS
  branch_name
  city_id904
  schoolgroup_id(null)
  mail_addressyokohama.aoba.dance@gmail.com
  lat
  lon
  telephone_number0459125155
  homepage_urlhttps://yokohama-aoba-dance-school.jimdosite.com/
  mobile_homepage_url
  blog_url
  open_hour火曜、金曜 10:00～13:00
  holiday
  post_code225-0013
  town_address荏田北3丁目3番地12号
  buildingコミュニティーホールACT2階
  image_hash085420a1a1b1bfd7
  image_extension_type2
  message_image_hasha3f30ef01be7ed51
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title１人１人が自由に自分を表現できる世界を
  message_bodyバレエやダンスを通して、１人１人が自分自身の身体の変化や表現の楽しさを味わってもらえる場をつくりたいという想いから 2022年3月横浜青葉ダンススクール YADSを開校致しました。まずは、ぜひ体験レッスンにいらしてください。 1人でも多くの方々と出会えることを楽しみにしております。
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title代表小幡朱里
  whole_staff_introduction３歳からクラシックバレエを始める。押領司博子に師事。日本ジュニアバレエ入所、AMスチューデンツ26期生、牧阿佐美に師事。 17歳でフランスカンヌロゼラハイタワーバレエスクールに留学。モニク・ルディエールに師事。 2013年劇団四季研究所入所。同年9月ミュージカル『李香蘭』で初舞台を踏む。『オペラ座の怪人』『クレイジー・フォー・ユー』『アラジン』その他ファミリーミュージカルなど数々の舞台に出演。プレイヤーとして活動しながらクラシックバレエ、ジャズダンス、子どもミュージカル等幅広く指導にあたる。
  whole_staff_image_hash0350f9c898f0438c
  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_created2022-04-02 10:29:01
  timestamp_modified2022-04-02 11:18:39
  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)
  id3014899
  nameCCチアダンススクール
  branch_name大田区羽田校
  city_id731
  schoolgroup_id112
  mail_addressmomocandy.cheer200@gmail.com
  lat35.5508227
  lon139.7347031
  telephone_number08066552476
  homepage_urlhttp://www.cc-cheerdanceschool.com/
  mobile_homepage_urlhttp://www.cc-cheerdanceschool.com/
  blog_urlhttp://ameblo.jp/cheercheer200/
  open_hour
  holidayなし
  post_code
  town_address萩中3丁目
  building
  image_hash7e3d01fcf438d8d5
  image_extension_type2
  message_image_hashe3c211059d5e9ee9
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_title大人気！CCチアダンススクールが生徒募集中‼️
  message_body京浜急行線大鳥居駅から徒歩3分。公園前にある体育館にて楽しくレッスンしています。講師は、全員チアダンスインストラクターの資格を持ち、指導のプロ。チアダンスを通して、礼儀、積極性、協調性を養います。多くのイベント出演、メディア出演ができるのもCCチアの人気の理由です。【いちおしポイント】・豊富なイベント出演ができる！プロ野球試合@東京ドーム、神宮球場、台場ジョイポリスなど。・講師がチアダンスインストラクター有資格者、保育士資格、プロチアリーダー。テレビでも活躍中。【主なイベント出演】プロ野球@東京ドームアンダーアーマー少年野球@神宮球場ガールズチアフェス@お台場ジョイポリスダンスラッシュ@東京ドーム後楽園ステージ目黒川桜まつり@目黒川特設ステージ【開講科目】リトルチアダンス（3歳〜園児）キッズチアダンス（小学生）【場所】東京都大田区萩中 ※詳細問い合わせアクセス京浜急行線大鳥居駅3分【日時】 HP参照（CCチアダンススクール検索）【料金】 HP参照（CCチアダンススクール検索）
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleCCチアダンススクール代表井尻ももこ
  whole_staff_introduction 2012年　CC Cheer Dance School設立。現役のプロフェッショナルチアリーディング協会AllStarメンバーとしての活動も続け、チアダンスの普及に貢献を続けている。自身の持つ、保育士・骨盤ビューティーインストラクター（骨盤調整）、美姿勢トーニングの資格も活かし、キッズチアダンスのみならず、大人チアダンスエクササイズ、美ストレッチ骨盤調整レッスンと幅広い層の女性に支持を受け、講座はいつも満員・予約数ヶ月待ちの盛況ぶりをみせている。【井尻ももこの主なメデイア出演】日本テレビ　「シューイチ」「ヒルナンデス」「SKE48」 ◯TOKYO MX「週末メトロポリシャン」「ちょいDisco」 ◯テレビ東京　「たけしのニッポンのミカタ」 ◯雑誌「GLOW」「BODY プラス」「ヤセる！JELLY」
  whole_staff_image_hash58e79252bda144e6
  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_count5
  timestamp_created0000-00-00 00:00:00
  timestamp_modified2021-08-03 15:06:54
  memo(null)
  2(object)
  id3015173
  nameライフウェル相模大野
  branch_name
  city_id887
  schoolgroup_id(null)
  mail_addresss.takei@life-well.jp
  lat35.533374500000
  lon139.436713600000
  telephone_number042-767-3733
  homepage_urlhttp://www.life-well.jp
  mobile_homepage_url
  blog_urlhttp://ameblo.jp/life-well-sagamiono/
  open_hour月～金9時～２３時半、土9時～21時、日・祝10時～20時
  holiday毎月15日
  post_code
  town_address南区相模大野3-22-1　2Ｆ
  building
  image_hash7b71e467cd1d1dd2
  image_extension_type2
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title
  message_body
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title畑　久美子　/ ＨＩＰＨＯＰ
  whole_staff_introduction8歳よりバレエを始め、JAZZダンス、HIPHOP、TAPダンスを学ぶ。現在は、大手テーマパークやプロ野球のチアチーム等、現役ダンサーとして幅広く活躍中！！まずは、音楽に合わせて自由に身体を動かしてみよう！誰でも初めの一歩は勇気が必要ですが、そのお手伝いをしていきたいと思っています。一人ひとりに合ったアドバイスを通じ、踊る事に慣れて来たら、個性や表現力も学びます。ダンスに決まりはありません！自分に合ったスタイルで「自由」「楽しく」「思い切り」そしてカッコ良く踊ってみましょう。
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash
  banner_image_extension_type0
  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:13
  memo
- 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.176.80'
	)
)
$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.176.80

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	/
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Remote Port	56976
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.176.80
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.235.176.80
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.235.176.80
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	Yo3URZtuyrN@9LNcHbRrOQAAAa4
Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1653462085.3319
Request Time	1653462085

====

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/ToStationUnitPage.php
  24APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
  25APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  26APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
====

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

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

Meary 上尾

子供～大人 ★CC★チアダンススクール

ライフウェル相模大野

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

ワールドステップ

AGNI Dance school

満若ダンススタジオin杉田杉田

熊本サルサ　アマンダ

横浜青葉ダンススクール YADS

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

練習風景を観て毎回感激してます。 (view: 881 投稿日: 2016/03/04)

明るく清潔感があり、親切。 (view: 659 投稿日: 2016/03/20)

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

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

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

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

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Dancers Special Column スペシャルコラム

SAYAKAさんのコラム

Matsuyaさんのコラム

MILOさんのコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

Special Column

Memory

Timers

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

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

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

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

»Area Search エリア検索

»Category Search カテゴリー検索

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

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

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

練習風景を観て毎回感激してます。 (view: 881 投稿日: 2016/03/04)

明るく清潔感があり、親切。 (view: 659 投稿日: 2016/03/20)

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

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

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

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

ダンススクール・教室

フィットネスクラブ

専門学校・専門校

Dancers Special Column スペシャルコラム

Dance Clip ダンスクリップ

» ダンス情報の基礎知識

Special Column

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

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

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