キッズダンス教室のレッスンを行う神戸市西区のダンススクール、ダンス教室

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key7151ed511199bbb96d7fab59aff3200299b238cc
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  7151ed511199bbb96d7fab59aff3200299b238cc1752528816
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool_list
- actionindex
- named(empty)
- pass(empty)
- categorySlugkids
- prefectureId28
- cityId1537
- _Token(array)
  key7151ed511199bbb96d7fab59aff3200299b238cc
  unlockedFields(empty)
Post data

No post data.

Query string
- beginner1
- st11
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0categorySlug
  1prefectureId
  2cityId
- options(array)
  categorySlug[a-z]+
  prefectureId[0-9]+
  cityId[0-9]+
- defaults(array)
  controllerschool_list
  actionindex
  plugin(null)
- template/:categorySlug/pref_:prefectureId/city_:cityId
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 35 queries / 0.199037 sec

No.

time

query

0.014337

connect

0.068347

DESCRIBE `prefecture`

0.003707

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

DESCRIBE `city`

0.002117

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

DESCRIBE `summary_count_school`

0.010847

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 = '1537') 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.001137

DESCRIBE `station`

0.000757

SELECT `s`.* FROM `station` AS `s` WHERE (s.city_id = '1537') GROUP BY `s`.`id`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	PRIMARY,city_id,ix_lat_lon_station	city_id	4	const	8	Using index condition

0.042007

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 = 13) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id IN ('8293', '8294', '8295', '8296', '8381', '8382', '8383', '8384')) 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		8	Using index condition; Using where

0.000677

DESCRIBE `station_unit`

0.006067

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '28')

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

0.001427

DESCRIBE `major_city`

0.003737

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '28')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_c	ref	prefecture_id	prefecture_id	4	const	1

0.001217

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 = 13) 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 IN ('8')) AND (s_c_s.count > 0)

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

0.002207

DESCRIBE `school`

0.000967

DESCRIBE `category_school`

0.009547

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	ix_category_id_category_school	ix_category_id_category_school	4	const	1291

0.010947

SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013173', '3013183', '3013184', '3013185', '3013187', '3013194', '3013195', '3013196', '3013197', '3013202', '3013211', '3013212', '3013213', '3013214', '3013215', '3013220', '3013221', '3013222', '3013223', '3013225', '3013227', '3013228', '3013229', '3013234', '3013236', '3013246', '3013249', '3013250', '3013251', '3013252', '3013253', '3013255', '3013259', '3013268', '3013277', '3013278', '3013294', '3013297', '3013299', '3013300', '3013301', '3013302', '3013304', '3013305', '3013309', '3013311', '3013312', '3013320', '3013322', '3013323', '3013424', '3013463', '3013509', '3013536', '3013901', '3013938', '3013939', '3013940', '3013942', '3013943', '3013944', '3013945', '3013946', '3013948', '3013933', '3013953', '3013954', '3013956', '3013959', '3013960', '3013962', '3013966', '3013972', '3013973', '3013974', '3013979', '3013984', '3013988', '3013989', '3013993', '3013994', '3013998', '3013999', '3014000', '3014001', '3014010', '3014011', '3014013', '3014014', '3014015', '3014018', '3014022', '3014024', '3014031', '3014034', '3014036', '3014037', '3014039', '3014045', '3014047', '3014049', '3014050', '3014051', '3014052', '3014056', '3014057', '3014058', '3014061', '3014062', '3014064', '3014068', '3014072', '3014073', '3014074', '3014075', '3014076', '3014080', '3014085', '3014086', '3014089', '3014090', '3014093', '3014099', '3014100', '3014103', '3014106', '3014107', '3014109', '3014110', '3014115', '3014125', '3014129', '3014130', '3014132', '3014134', '3014135', '3014136', '3014138', '3014139', '3014157', '3014169', '3014170', '3014113', '3014174', '3014177', '3014178', '3014180', '3014184', '3014185', '3014186', '3014202', '3014222', '3014223', '3014224', '3014227', '3014245', '3014248', '3014249', '3014252', '3014193', '3014255', '3014256', '3014262', '3014265', '3014278', '3014282', '3014287', '3014289', '3014291', '3014293', '3014307', '3014308', '3014309', '3014312', '3014313', '3014314', '3014315', '3014322', '3014323', '3014327', '3014331', '3014332', '3014337', '3014340', '3014341', '3014199', '3014363', '3014368', '3014374', '3014376', '3014377', '3014378', '3014381', '3014388', '3014390', '3014393', '3014396', '3014397', '3014401', '3014402', '3014404', '3014406', '3014407', '3014399', '3014410', '3014414', '3014415', '3014419', '3014422', '3014426', '3014429', '3014431', '3014432', '3014433', '3014437', '3014439', '3014443', '3014444', '3014446', '3014448', '3014449', '3014451', '3014452', '3014459', '3014460', '3014462', '3014467', '3014471', '3014472', '3014473', '3014474', '3014475', '3014394', '3014478', '3014480', '3014481', '3014482', '3014487', '3014492', '3014490', '3014486', '3014464', '3014498', '3014500', '3014494', '3014504', '3014505', '3014506', '3014507', '3014497', '3014508', '3014512', '3014514', '3014515', '3014516', '3014517', '3014518', '3014519', '3014528', '3014532', '3014534', '3014537', '3014538', '3014539', '3014540', '3014543', '3014552', '3014553', '3014555', '3014556', '3014561', '3014562', '3014564', '3014560', '3013298', '3014570', '3014569', '3014572', '3014573', '3014581', '3014582', '3014587', '3014589', '3014594', '3014598', '3014602', '3014605', '3014607', '3014609', '3014614', '3014618', '3014619', '3014623', '3014624', '3014625', '3014627', '3014628', '3014631', '3014632', '3014635', '3014636', '3014638', '3014640', '3014408', '3014641', '3014643', '3014647', '3014648', '3014649', '3014651', '3014658', '3014660', '3014661', '3014662', '3014663', '3014657', '3014665', '3014666', '3014667', '3014670', '3014673', '3014674', '3014675', '3014200', '3014677', '3014682', '3014683', '3014684', '3014685', '3014686', '3014695', '3014701', '3014483', '3014704', '3014707', '3014708', '3014712', '3014716', '3014669', '3014720', '3014722', '3014723', '3014725', '3014727', '3014728', '3014729', '3014735', '3014738', '3014739', '3014741', '3014610', '3014744', '3014749', '3014761', '3014763', '3014766', '3014767', '3014771', '3014772', '3014773', '3014774', '3014356', '3014778', '3014779', '3014780', '3014781', '3014782', '3014893', '3014931', '3014786', '3014787', '3014788', '3014790', '3014791', '3014795', '3014796', '3014797', '3014798', '3014800', '3014802', '3014803', '3014805', '3014806', '3014807', '3014809', '3014812', '3014815', '3014817', '3014820', '3014823', '3014826', '3014829', '3014830', '3014927', '3014832', '3014834', '3014835', '3014836', '3014837', '3014840', '3014844', '3014846', '3014849', '3014851', '3014852', '3014853', '3014854', '3014855', '3014856', '3014857', '3014858', '3014859', '3014861', '3014862', '3014863', '3014866', '3014867', '3014868', '3014871', '3014873', '3014874', '3014875', '3014876', '3014884', '3014887', '3014888', '3014890', '3014895', '3014898', '3014899', '3014900', '3014903', '3014905', '3014909', '3014911', '3014914', '3014919', '3014920', '3014921', '3014933', '3014935', '3014936', '3014937', '3014938', '3014940', '3014941', '3014942', '3014943', '3014946', '3014948', '3014949', '3014950', '3014956', '3014957', '3014958', '3014959', '3014960', '3014964', '3014965', '3014966', '3014969', '3014972', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3015031', '3014984', '3014985', '3014986', '3014987', '3014988', '3014989', '3014990', '3014993', '3014994', '3014996', '3014997', '3014998', '3014999', '3015000', '3015001', '3015002', '3015003', '3015007', '3015008', '3015009', '3015011', '3015012', '3015013', '3015014', '3015015', '3015016', '3015017', '3015025', '3015027', '3015028', '3015029', '3015033', '3015034', '3014442', '3015036', '3015037', '3015042', '3015052', '3015053', '3015056', '3015061', '3015068', '3015070', '3015069', '3015072', '3015073', '3015082', '3015083', '3015086', '3015087', '3015084', '3015088', '3015089', '3015091', '3015094', '3015097', '3015098', '3015100', '3015102', '3015103', '3015104', '3015105', '3015106', '3015107', '3015108', '3015109', '3015112', '3015113', '3015119', '3015120', '3015121', '3015122', '3014580', '3015127', '3015128', '3015131', '3015133', '3015134', '3015135', '3014910', '3015136', '3015139', '3015140', '3015141', '3015143', '3015144', '3015145', '3015146', '3015147', '3015148', '3015149', '3015150', '3015151', '3015152', '3015155', '3015156', '3015157', '3015158', '3015164', '3015165', '3015170', '3015171', '3015172', '3015173', '3015174', '3015176', '3015180', '3015182', '3015184', '3015186', '3015187', '3015188', '3015189', '3015190', '3015191', '3015192', '3015195', '3015198', '3015197', '3014440', '3015205', '3015206', '3015208', '3015264', '3015280', '3015281', '3015282', '3015279', '3015289', '3015288', '3015290', '3015211', '3015235', '3015237', '3015236', '3014423', '3015292', '3015293', '3015295', '3015296', '3015300', '3015301', '3015302', '3015303', '3015307', '3015257', '3015259', '3015217', '3015269', '3015220', '3015268', '3015271', '3015249', '3015214', '3015252', '3015258', '3015215', '3015270', '3015272', '3015273', '3015308', '3015310', '3015311', '3015312', '3015313', '3015314', '3015316', '3015317', '3015318', '3015319', '3015320', '3015321', '3015323', '3015325', '3015326', '3015327', '3015328', '3015329', '3015330', '3015331', '3015332', '3015333', '3015334', '3015335', '3015343', '3015345', '3015346', '3015347', '3015350', '3015356', '3015357', '3015360', '3015361', '3015363', '3015367', '3015371', '3015377', '3015378', '3015380', '3015381', '3015384', '3015390', '3015391', '3015393', '3015394', '3015395', '3015401', '3015403', '3015404', '3015406', '3015407', '3015408', '3015409', '3015410', '3015411', '3015412', '3015413', '3015414', '3015417', '3015418', '3015419', '3015420', '3015421', '3015422', '3015424', '3015425', '3015429', '3015430', '3015432', '3015433', '3015434', '3015437', '3015438', '3015441', '3015446', '3015451', '3015453', '3015455', '3015459', '3015461', '3014644', '3015463', '3015467', '3015466', '3015470', '3015472', '3015473', '3015474', '3015477', '3015475', '3015462', '3015482', '3015483', '3015484', '3015487', '3015489', '3015490', '3015491', '3015492', '3015496', '3015500', '3015501', '3015502', '3015503', '3015506', '3015507', '3015508', '3015512', '3015513', '3015514', '3015518', '3015519', '3015520', '3015521', '3015527', '3015528', '3015529', '3015531', '3015532', '3015536', '3015537', '3015538', '3015540', '3015542', '3015545', '3015546', '3015547', '3015549', '3015550', '3015554', '3015555', '3015561', '3015562', '3015564', '3015567', '3015568', '3015570', '3015577', '3015578', '3015580', '3015581', '3015582', '3015584', '3015583', '3015586', '3015587', '3015588', '3015590', '3015592', '3015596', '3015597', '3015598', '3015600', '3015601', '3015605', '3015607', '3015609', '3015611', '3015612', '3015075', '3015613', '3015614', '3015615', '3015616', '3015617', '3015618', '3015621', '3015625', '3015627', '3015628', '3015629', '3015630', '3015624', '3015631', '3015635', '3015638', '3015639', '3015642', '3015645', '3015648', '3015649', '3015650', '3015652', '3015653', '3015655', '3015657', '3015659', '3015660', '3015662', '3015667', '3015668', '3015673', '3015677', '3015678', '3015681', '3015684', '3015686', '3015688', '3015690', '3015691', '3015692', '3015694', '3015695', '3015699', '3015700', '3015702', '3015703', '3015704', '3015705', '3015706', '3015707', '3015708', '3015710', '3015712', '3015709', '3015716', '3015717', '3015721', '3015722', '3015725', '3015726', '3015727', '3015728', '3015730', '3015732', '3015737', '3015738', '3015740', '3015744', '3015745', '3015748', '3015752', '3015753', '3015755', '3015758', '3015760', '3015763', '3015764', '3015765', '3015766', '3015769', '3015768', '3015772', '3015774', '3015775', '3015776', '3015781', '3015782', '3015787', '3015792', '3015797', '3015798', '3015801', '3015804', '3015806', '3015807', '3015812', '3015814', '3015819', '3015820', '3015821', '3015822', '3015824', '3015825', '3015826', '3015827', '3015831', '3015517', '3015835', '3015836', '3015837', '3014541', '3015843', '3015850', '3015853', '3015854', '3014952', '3015857', '3015861', '3015862', '3015863', '3015864', '3015868', '3015870', '3015871', '3015872', '3015873', '3015880', '3015884', '3015887', '3015898', '3015899', '3015902', '3015903', '3015904', '3015905', '3015908', '3015911', '3015916', '3015918', '3014932', '3015924', '3015926', '3015925', '3015928', '3015930', '3015932', '3015935', '3015936', '3015938', '3015179', '3015941', '3015943', '3015944', '3015945', '3015947', '3015948', '3015949', '3015951', '3015952', '3015956', '3015957', '3015959', '3015962', '3015964', '3015968', '3015973', '3015979', '3015981', '3015982', '3015983', '3015984', '3015989', '3015990', '3015991', '3015992', '3015997', '3015998', '3015999', '3016002', '3016003', '3016004', '3016005', '3015985', '3016007', '3016008', '3016009', '3016010', '3016011', '3016012', '3016020', '3016021', '3016022', '3016025', '3016024', '3016026', '3016034', '3016035', '3016036', '3016038', '3016037', '3016040', '3016041', '3016045', '3016046', '3016048', '3016055', '3016058', '3016059', '3016060', '3015799', '3016061', '3016062', '3016064', '3016066', '3016068', '3016069', '3016072', '3016073', '3016074', '3016075', '3016080', '3016083', '3016086', '3016088', '3016084', '3016089', '3016090', '3016091', '3016092', '3016094', '3016095', '3016096', '3016097', '3016098', '3016099', '3016100', '3016101', '3016102', '3016103', '3016105', '3016106', '3016107', '3016108', '3016109', '3016110', '3016111', '3016112', '3016113', '3016115', '3016116', '3016117', '3016118', '3016121', '3015573', '3016122', '3016123', '3016124', '3016125', '3016127', '3016129', '3016131', '3016128', '3016134', '3016135', '3016136', '3016137', '3016138', '3016140', '3016142', '3016143', '3016144', '3016146', '3016147', '3016148', '3016149', '3016151', '3016152', '3016153', '3016154', '3016157', '3016158', '3016159', '3016160', '3016162', '3016163', '3016166', '3016167', '3016067', '3016170', '3016171', '3016172', '3016174', '3016175', '3016181', '3016182', '3016184', '3016186', '3016190', '3016191', '3016192', '3016196', '3016201', '3016203', '3016204', '3016205', '3016206', '3016208', '3016210', '3016211', '3016213', '3016214', '3016218', '3016219', '3016221', '3016222', '3016223', '3014912', '3016224', '3016225', '3016226', '3016234', '3016236', '3016239', '3016240', '3016241', '3016242', '3016243', '3016244', '3016245', '3016246', '3016247', '3016248', '3016120', '3016250', '3014926', '3016251', '3016252', '3016253', '3016254', '3016255', '3016257', '3016258', '3016259', '3016260', '3016262', '3016263', '3016264', '3016265', '3016268', '3016269', '3016271', '3016272', '3016273', '3016274', '3016275', '3016277', '3016279', '3016282', '3016283', '3016284', '3016281', '3016285', '3016286', '3016288', '3016289', '3016291', '3016292', '3016293', '3016294', '3016295', '3016296', '3016297', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016307', '3016311', '3016312', '3016314', '3016315', '3016316', '3016320', '3016321', '3013977', '3016322', '3016324', '3016323', '3016332', '3016333', '3016334', '3016335', '3016336', '3016338', '3016339', '3016340', '3016341', '3016344', '3016350', '3015130', '3016354', '3016355', '3016359', '3016362', '3016364', '3016368', '3016369', '3016370', '3016372', '3016373', '3016374', '3016375', '3016376', '3016379', '3016380', '3016381', '3016382', '3016383', '3016384', '3016363', '3016385', '3016386', '3016387', '3016389', '3016391', '3016392', '3016393', '3016394', '3016395', '3016396', '3016397', '3016398', '3016399', '3016402', '3016403', '3016407', '3016408', '3016409', '3016410', '3016411', '3016412', '3016413', '3016414', '3016416', '3016417', '3016418', '3016278', '3016420', '3016423', '3016424', '3016425', '3016434', '3016435', '3016436', '3016437', '3016443', '3016444', '3016442', '3016448', '3016454', '3016455', '3016456', '3016457', '3016458', '3016459', '3016460', '3016461', '3016462', '3016463', '3016464', '3016465', '3016466', '3016467', '3016468', '3016469', '3016470', '3016471', '3016472', '3016473', '3016474', '3016475', '3016476', '3016477', '3016478', '3016479', '3016480', '3016481', '3016482', '3016483', '3016484', '3016485', '3016487', '3016489', '3016517', '3016518', '3016519')) AND (s.city_id = '1537') AND (s.school_type IN (1)) AND (s.has_beginner_course = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	PRIMARY,city_id,ix_school_type_school	city_id	9		1291	Using index condition; Using where

0.007427

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013173', '3013183', '3013184', '3013185', '3013187', '3013194', '3013195', '3013196', '3013197', '3013202', '3013211', '3013212', '3013213', '3013214', '3013215', '3013220', '3013221', '3013222', '3013223', '3013225', '3013227', '3013228', '3013229', '3013234', '3013236', '3013246', '3013249', '3013250', '3013251', '3013252', '3013253', '3013255', '3013259', '3013268', '3013277', '3013278', '3013294', '3013297', '3013299', '3013300', '3013301', '3013302', '3013304', '3013305', '3013309', '3013311', '3013312', '3013320', '3013322', '3013323', '3013424', '3013463', '3013509', '3013536', '3013901', '3013938', '3013939', '3013940', '3013942', '3013943', '3013944', '3013945', '3013946', '3013948', '3013933', '3013953', '3013954', '3013956', '3013959', '3013960', '3013962', '3013966', '3013972', '3013973', '3013974', '3013979', '3013984', '3013988', '3013989', '3013993', '3013994', '3013998', '3013999', '3014000', '3014001', '3014010', '3014011', '3014013', '3014014', '3014015', '3014018', '3014022', '3014024', '3014031', '3014034', '3014036', '3014037', '3014039', '3014045', '3014047', '3014049', '3014050', '3014051', '3014052', '3014056', '3014057', '3014058', '3014061', '3014062', '3014064', '3014068', '3014072', '3014073', '3014074', '3014075', '3014076', '3014080', '3014085', '3014086', '3014089', '3014090', '3014093', '3014099', '3014100', '3014103', '3014106', '3014107', '3014109', '3014110', '3014115', '3014125', '3014129', '3014130', '3014132', '3014134', '3014135', '3014136', '3014138', '3014139', '3014157', '3014169', '3014170', '3014113', '3014174', '3014177', '3014178', '3014180', '3014184', '3014185', '3014186', '3014202', '3014222', '3014223', '3014224', '3014227', '3014245', '3014248', '3014249', '3014252', '3014193', '3014255', '3014256', '3014262', '3014265', '3014278', '3014282', '3014287', '3014289', '3014291', '3014293', '3014307', '3014308', '3014309', '3014312', '3014313', '3014314', '3014315', '3014322', '3014323', '3014327', '3014331', '3014332', '3014337', '3014340', '3014341', '3014199', '3014363', '3014368', '3014374', '3014376', '3014377', '3014378', '3014381', '3014388', '3014390', '3014393', '3014396', '3014397', '3014401', '3014402', '3014404', '3014406', '3014407', '3014399', '3014410', '3014414', '3014415', '3014419', '3014422', '3014426', '3014429', '3014431', '3014432', '3014433', '3014437', '3014439', '3014443', '3014444', '3014446', '3014448', '3014449', '3014451', '3014452', '3014459', '3014460', '3014462', '3014467', '3014471', '3014472', '3014473', '3014474', '3014475', '3014394', '3014478', '3014480', '3014481', '3014482', '3014487', '3014492', '3014490', '3014486', '3014464', '3014498', '3014500', '3014494', '3014504', '3014505', '3014506', '3014507', '3014497', '3014508', '3014512', '3014514', '3014515', '3014516', '3014517', '3014518', '3014519', '3014528', '3014532', '3014534', '3014537', '3014538', '3014539', '3014540', '3014543', '3014552', '3014553', '3014555', '3014556', '3014561', '3014562', '3014564', '3014560', '3013298', '3014570', '3014569', '3014572', '3014573', '3014581', '3014582', '3014587', '3014589', '3014594', '3014598', '3014602', '3014605', '3014607', '3014609', '3014614', '3014618', '3014619', '3014623', '3014624', '3014625', '3014627', '3014628', '3014631', '3014632', '3014635', '3014636', '3014638', '3014640', '3014408', '3014641', '3014643', '3014647', '3014648', '3014649', '3014651', '3014658', '3014660', '3014661', '3014662', '3014663', '3014657', '3014665', '3014666', '3014667', '3014670', '3014673', '3014674', '3014675', '3014200', '3014677', '3014682', '3014683', '3014684', '3014685', '3014686', '3014695', '3014701', '3014483', '3014704', '3014707', '3014708', '3014712', '3014716', '3014669', '3014720', '3014722', '3014723', '3014725', '3014727', '3014728', '3014729', '3014735', '3014738', '3014739', '3014741', '3014610', '3014744', '3014749', '3014761', '3014763', '3014766', '3014767', '3014771', '3014772', '3014773', '3014774', '3014356', '3014778', '3014779', '3014780', '3014781', '3014782', '3014893', '3014931', '3014786', '3014787', '3014788', '3014790', '3014791', '3014795', '3014796', '3014797', '3014798', '3014800', '3014802', '3014803', '3014805', '3014806', '3014807', '3014809', '3014812', '3014815', '3014817', '3014820', '3014823', '3014826', '3014829', '3014830', '3014927', '3014832', '3014834', '3014835', '3014836', '3014837', '3014840', '3014844', '3014846', '3014849', '3014851', '3014852', '3014853', '3014854', '3014855', '3014856', '3014857', '3014858', '3014859', '3014861', '3014862', '3014863', '3014866', '3014867', '3014868', '3014871', '3014873', '3014874', '3014875', '3014876', '3014884', '3014887', '3014888', '3014890', '3014895', '3014898', '3014899', '3014900', '3014903', '3014905', '3014909', '3014911', '3014914', '3014919', '3014920', '3014921', '3014933', '3014935', '3014936', '3014937', '3014938', '3014940', '3014941', '3014942', '3014943', '3014946', '3014948', '3014949', '3014950', '3014956', '3014957', '3014958', '3014959', '3014960', '3014964', '3014965', '3014966', '3014969', '3014972', '3014977', '3014978', '3014979', '3014980', '3014981', '3014982', '3015031', '3014984', '3014985', '3014986', '3014987', '3014988', '3014989', '3014990', '3014993', '3014994', '3014996', '3014997', '3014998', '3014999', '3015000', '3015001', '3015002', '3015003', '3015007', '3015008', '3015009', '3015011', '3015012', '3015013', '3015014', '3015015', '3015016', '3015017', '3015025', '3015027', '3015028', '3015029', '3015033', '3015034', '3014442', '3015036', '3015037', '3015042', '3015052', '3015053', '3015056', '3015061', '3015068', '3015070', '3015069', '3015072', '3015073', '3015082', '3015083', '3015086', '3015087', '3015084', '3015088', '3015089', '3015091', '3015094', '3015097', '3015098', '3015100', '3015102', '3015103', '3015104', '3015105', '3015106', '3015107', '3015108', '3015109', '3015112', '3015113', '3015119', '3015120', '3015121', '3015122', '3014580', '3015127', '3015128', '3015131', '3015133', '3015134', '3015135', '3014910', '3015136', '3015139', '3015140', '3015141', '3015143', '3015144', '3015145', '3015146', '3015147', '3015148', '3015149', '3015150', '3015151', '3015152', '3015155', '3015156', '3015157', '3015158', '3015164', '3015165', '3015170', '3015171', '3015172', '3015173', '3015174', '3015176', '3015180', '3015182', '3015184', '3015186', '3015187', '3015188', '3015189', '3015190', '3015191', '3015192', '3015195', '3015198', '3015197', '3014440', '3015205', '3015206', '3015208', '3015264', '3015280', '3015281', '3015282', '3015279', '3015289', '3015288', '3015290', '3015211', '3015235', '3015237', '3015236', '3014423', '3015292', '3015293', '3015295', '3015296', '3015300', '3015301', '3015302', '3015303', '3015307', '3015257', '3015259', '3015217', '3015269', '3015220', '3015268', '3015271', '3015249', '3015214', '3015252', '3015258', '3015215', '3015270', '3015272', '3015273', '3015308', '3015310', '3015311', '3015312', '3015313', '3015314', '3015316', '3015317', '3015318', '3015319', '3015320', '3015321', '3015323', '3015325', '3015326', '3015327', '3015328', '3015329', '3015330', '3015331', '3015332', '3015333', '3015334', '3015335', '3015343', '3015345', '3015346', '3015347', '3015350', '3015356', '3015357', '3015360', '3015361', '3015363', '3015367', '3015371', '3015377', '3015378', '3015380', '3015381', '3015384', '3015390', '3015391', '3015393', '3015394', '3015395', '3015401', '3015403', '3015404', '3015406', '3015407', '3015408', '3015409', '3015410', '3015411', '3015412', '3015413', '3015414', '3015417', '3015418', '3015419', '3015420', '3015421', '3015422', '3015424', '3015425', '3015429', '3015430', '3015432', '3015433', '3015434', '3015437', '3015438', '3015441', '3015446', '3015451', '3015453', '3015455', '3015459', '3015461', '3014644', '3015463', '3015467', '3015466', '3015470', '3015472', '3015473', '3015474', '3015477', '3015475', '3015462', '3015482', '3015483', '3015484', '3015487', '3015489', '3015490', '3015491', '3015492', '3015496', '3015500', '3015501', '3015502', '3015503', '3015506', '3015507', '3015508', '3015512', '3015513', '3015514', '3015518', '3015519', '3015520', '3015521', '3015527', '3015528', '3015529', '3015531', '3015532', '3015536', '3015537', '3015538', '3015540', '3015542', '3015545', '3015546', '3015547', '3015549', '3015550', '3015554', '3015555', '3015561', '3015562', '3015564', '3015567', '3015568', '3015570', '3015577', '3015578', '3015580', '3015581', '3015582', '3015584', '3015583', '3015586', '3015587', '3015588', '3015590', '3015592', '3015596', '3015597', '3015598', '3015600', '3015601', '3015605', '3015607', '3015609', '3015611', '3015612', '3015075', '3015613', '3015614', '3015615', '3015616', '3015617', '3015618', '3015621', '3015625', '3015627', '3015628', '3015629', '3015630', '3015624', '3015631', '3015635', '3015638', '3015639', '3015642', '3015645', '3015648', '3015649', '3015650', '3015652', '3015653', '3015655', '3015657', '3015659', '3015660', '3015662', '3015667', '3015668', '3015673', '3015677', '3015678', '3015681', '3015684', '3015686', '3015688', '3015690', '3015691', '3015692', '3015694', '3015695', '3015699', '3015700', '3015702', '3015703', '3015704', '3015705', '3015706', '3015707', '3015708', '3015710', '3015712', '3015709', '3015716', '3015717', '3015721', '3015722', '3015725', '3015726', '3015727', '3015728', '3015730', '3015732', '3015737', '3015738', '3015740', '3015744', '3015745', '3015748', '3015752', '3015753', '3015755', '3015758', '3015760', '3015763', '3015764', '3015765', '3015766', '3015769', '3015768', '3015772', '3015774', '3015775', '3015776', '3015781', '3015782', '3015787', '3015792', '3015797', '3015798', '3015801', '3015804', '3015806', '3015807', '3015812', '3015814', '3015819', '3015820', '3015821', '3015822', '3015824', '3015825', '3015826', '3015827', '3015831', '3015517', '3015835', '3015836', '3015837', '3014541', '3015843', '3015850', '3015853', '3015854', '3014952', '3015857', '3015861', '3015862', '3015863', '3015864', '3015868', '3015870', '3015871', '3015872', '3015873', '3015880', '3015884', '3015887', '3015898', '3015899', '3015902', '3015903', '3015904', '3015905', '3015908', '3015911', '3015916', '3015918', '3014932', '3015924', '3015926', '3015925', '3015928', '3015930', '3015932', '3015935', '3015936', '3015938', '3015179', '3015941', '3015943', '3015944', '3015945', '3015947', '3015948', '3015949', '3015951', '3015952', '3015956', '3015957', '3015959', '3015962', '3015964', '3015968', '3015973', '3015979', '3015981', '3015982', '3015983', '3015984', '3015989', '3015990', '3015991', '3015992', '3015997', '3015998', '3015999', '3016002', '3016003', '3016004', '3016005', '3015985', '3016007', '3016008', '3016009', '3016010', '3016011', '3016012', '3016020', '3016021', '3016022', '3016025', '3016024', '3016026', '3016034', '3016035', '3016036', '3016038', '3016037', '3016040', '3016041', '3016045', '3016046', '3016048', '3016055', '3016058', '3016059', '3016060', '3015799', '3016061', '3016062', '3016064', '3016066', '3016068', '3016069', '3016072', '3016073', '3016074', '3016075', '3016080', '3016083', '3016086', '3016088', '3016084', '3016089', '3016090', '3016091', '3016092', '3016094', '3016095', '3016096', '3016097', '3016098', '3016099', '3016100', '3016101', '3016102', '3016103', '3016105', '3016106', '3016107', '3016108', '3016109', '3016110', '3016111', '3016112', '3016113', '3016115', '3016116', '3016117', '3016118', '3016121', '3015573', '3016122', '3016123', '3016124', '3016125', '3016127', '3016129', '3016131', '3016128', '3016134', '3016135', '3016136', '3016137', '3016138', '3016140', '3016142', '3016143', '3016144', '3016146', '3016147', '3016148', '3016149', '3016151', '3016152', '3016153', '3016154', '3016157', '3016158', '3016159', '3016160', '3016162', '3016163', '3016166', '3016167', '3016067', '3016170', '3016171', '3016172', '3016174', '3016175', '3016181', '3016182', '3016184', '3016186', '3016190', '3016191', '3016192', '3016196', '3016201', '3016203', '3016204', '3016205', '3016206', '3016208', '3016210', '3016211', '3016213', '3016214', '3016218', '3016219', '3016221', '3016222', '3016223', '3014912', '3016224', '3016225', '3016226', '3016234', '3016236', '3016239', '3016240', '3016241', '3016242', '3016243', '3016244', '3016245', '3016246', '3016247', '3016248', '3016120', '3016250', '3014926', '3016251', '3016252', '3016253', '3016254', '3016255', '3016257', '3016258', '3016259', '3016260', '3016262', '3016263', '3016264', '3016265', '3016268', '3016269', '3016271', '3016272', '3016273', '3016274', '3016275', '3016277', '3016279', '3016282', '3016283', '3016284', '3016281', '3016285', '3016286', '3016288', '3016289', '3016291', '3016292', '3016293', '3016294', '3016295', '3016296', '3016297', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016307', '3016311', '3016312', '3016314', '3016315', '3016316', '3016320', '3016321', '3013977', '3016322', '3016324', '3016323', '3016332', '3016333', '3016334', '3016335', '3016336', '3016338', '3016339', '3016340', '3016341', '3016344', '3016350', '3015130', '3016354', '3016355', '3016359', '3016362', '3016364', '3016368', '3016369', '3016370', '3016372', '3016373', '3016374', '3016375', '3016376', '3016379', '3016380', '3016381', '3016382', '3016383', '3016384', '3016363', '3016385', '3016386', '3016387', '3016389', '3016391', '3016392', '3016393', '3016394', '3016395', '3016396', '3016397', '3016398', '3016399', '3016402', '3016403', '3016407', '3016408', '3016409', '3016410', '3016411', '3016412', '3016413', '3016414', '3016416', '3016417', '3016418', '3016278', '3016420', '3016423', '3016424', '3016425', '3016434', '3016435', '3016436', '3016437', '3016443', '3016444', '3016442', '3016448', '3016454', '3016455', '3016456', '3016457', '3016458', '3016459', '3016460', '3016461', '3016462', '3016463', '3016464', '3016465', '3016466', '3016467', '3016468', '3016469', '3016470', '3016471', '3016472', '3016473', '3016474', '3016475', '3016476', '3016477', '3016478', '3016479', '3016480', '3016481', '3016482', '3016483', '3016484', '3016485', '3016487', '3016489', '3016517', '3016518', '3016519')) AND (s.city_id = '1537') AND (s.school_type IN (1)) AND (s.has_beginner_course = 1) ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	PRIMARY,city_id,ix_school_type_school	city_id	9		1291	Using index condition; Using where; Using filesort

0.003257

connect

0.000487

SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 0) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	ref	multi	multi	28	const,const,const,const,const,const,const	1

0.000507

SELECT `p`.* FROM `prefecture` AS `p`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL					47

0.000567

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

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

0.000587

DESCRIBE `summary_count_kuchikomi`

0.000457

SELECT `s_c_k`.* FROM `summary_count_kuchikomi` AS `s_c_k` WHERE (s_c_k.is_latest = 1) AND (s_c_k.category_id = 13) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = '1537') AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_k	ref	multi	multi	20	const,const,const,const,const	1	Using index condition

0.000597

DESCRIBE `dancer`

0.000487

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

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

0.000417

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

DESCRIBE `dancer_column`

0.000387

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

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

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

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

0.000367

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

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

0.000357

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

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- breadcrumb(array)
  0(array)
  nameスクール検索
  link(array)
  controllerschool_list
  actionindex
  1(array)
  nameキッズダンス教室
  link(array)
  controllerschool_list
  actionindex
  categorySlugkids
  2(array)
  name兵庫県
  link(array)
  controllerschool_list
  actionindex
  categorySlugkids
  prefectureId28
  3(array)
  name神戸市西区
  link
- metaKeywordStringキッズダンス教室,神戸市西区,兵庫県,ダンススクール,ダンス教室
- headString神戸市西区のキッズダンス教室　ダンススクール、ダンス教室
- metaDescription神戸市西区にあるキッズダンス教室スクール、キッズダンス教室教室の口コミ評判ランキング。ダンスレッスン体験談からあなたに合った神戸市西区のキッズダンス教室スクールを探し出せます！
- title_for_layoutキッズダンス教室のレッスンを行う神戸市西区のダンススクール、ダンス教室
- SchoolSet(object)
- SchoolPager(object)
- SearchTransitableToMajorCityPage(object)
- MajorCitySet(array)
  0(object)
  id8
  name神戸・三宮
  prefecture_id28
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToStationPage(object)
- SearchTransitableToCategoryPage(object)
- CategorySet(array)
  0(object)
  id2
  nameジャズダンス
  slugjazz
  description元々はジャズミュージックに合わせて踊るダンス全般の事をジャズダンスと言いましたが、現在ではジャズミュージックに限らず、色々な音楽に合わせて踊ります。バレエの動きをベースにした動作が特徴的で、TVやライブなどでのタレントやアーティストの多くのダンスはジャズダンスがベースとなっています。幅が広く、自由度の高いダンススタイルで、非常に人気の高いダンススタイルです。
  1(object)
  id3
  nameヒップホップ
  slughiphop
  description元々はヒップホップ＝70年代にアメリカで生まれたブラックカルチャー全般の事で、ラップやDJといった文化の事をさします。そのため、ヒップホップをダンスの種類としてではなく文化の総称として考えると、ストリートダンスは全てヒップホップとえます。ダンスの種類としてのヒップホップは、ブレイクダンスとソウルダンスを融合したもので、比較的新しいスタイルのものです。動きとしてはアップ、ダウンのリズムの取り方を基本としていて、ランニングマンやクラブステップといったような大き目の動きをする動作が多いダンスです。
  2(object)
  id4
  nameストリートダンス
  slugstreet
  descriptionストリート（路上）で踊られる事から発生したダンスで、比較的最近登場したジャンルのダンスです。元々はギャングの抗争を銃撃戦の代わりにブレイクダンスによって行われたものが始まりとされていて、ヒップホップ文化から出てきたダンス全般をストリートダンスと言います。現在ではジャズダンスなど様々なダンスがストリートダンスとして取り入れられ、ストリートダンス＝現代的なダンスという形の認識が強くなってきています。
  3(object)
  id8
  nameフラダンス・タヒチアンダンス
  slughula
  descriptionハワイにおける民族舞踊をフラ、タヒチにおける民族舞踊をタヒチアンダンスと言い、両方ともポリネシアン地域の踊りです。フラとは「ダンス」を意味する言葉で、歌・踊り・楽曲を総称してフラと言います。フラは元々宗教的・教訓的な側面の強い踊りで、文字文化の無いハワイにおいて物語や教訓を後世に伝えていくという面も持ち合わせています。タヒチアンダンスは現地の言葉でオリタヒチと言い、このオリという言葉もやはり現地語でダンスという意味です。フラもオリタヒチもその内容によって更に種類が細分化されますが、一般的にはフラは複数人数でゆったりと優雅に踊るもの、タヒチアンダンスは腰を激しく振りながら踊るものという違いがあります。
  4(object)
  id9
  nameベリーダンス
  slugbelly
  description中東・アラブ地域で発展したダンススタイルの事を指し、アラブ文化圏ではラクス・シャルキー(東方の踊りの意味)やラクス・バラディ（民族舞踏の意味）と呼ばれる。ベリーダンスのベリーとはお腹を意味するbellyだとされ、お腹の動きが特徴的だという事からこの名称で呼ばれるようになったとされています。ベリーダンスは中東・アラブ地域のダンスの総称であるため、同じベリーダンスでもスタイルによっては衣装や音楽など、多くの面で違うものとなります。
  5(object)
  id13
  nameキッズダンス教室
  slugkids
  descriptionダンスは言葉を用いないで自己表現をするための一つの手段であり、ダンスを学ぶ事で表現力を養う事や自信を持つことが出来る等点から、キッズダンスを習得させる家庭は増加傾向にあります。また、小中学校におけるダンスの教育義務化などもあり、習い事の一つとしてダンス教室はとても重要なものとなってきています。最近ではキッズダンサー向けのダンス大会なども頻繁に開催されていて、ただ習うだけではなく活躍する機会も今後さらに増えていくのではないでしょうか。
  6(object)
  id14
  nameその他のダンス
  slugother
  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
====

Message	Memory use
Component initialization	2.17 MB
Controller action start	2.41 MB
Controller render start	4.35 MB
View render complete	5.07 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	10.26
Event: Controller.initialize	1.03
Event: Controller.startup	0.45
Controller action	257.20
Event: Controller.beforeRender	63.46
» Processing toolbar data	58.94
Rendering View	24.91
» Event: View.beforeRender	0.94
» Rendering APP/View/SchoolList/index.ctp	9.19
» » Rendering APP/View/Elements/breadcrumb.ctp	0.31
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.10
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	5.91
» » Rendering APP/View/Elements/__searchlink/main-column-major-city.ctp	0.13
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.06
» » Rendering APP/View/Elements/paginator.ctp	0.06
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.04
» Rendering APP/View/Layouts/default.ctp	13.56
» » Rendering APP/View/Elements/header.ctp	0.56
» » Rendering APP/View/Elements/menu.ctp	10.12
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	9.90
» » » » Rendering APP/View/Elements/__searchlink/right-menu-category.ctp	0.44
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.16
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	8.32
» » » » 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.10
» » Rendering APP/View/Elements/footer.ctp	0.91
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.09
Event: View.afterLayout	0.00

Environment

App Constants

Notice (8): Undefined offset: 1 [CORE/Cake/View/Helper/HtmlHelper.php, line 867]Code Context
                if (is_array($cell)) {
                    $cellOptions = $cell[1];
$data = array(
	(int) 0 => array(
		(int) 0 => 'SGV_ENV',
		(int) 1 => 'development'
	),
	(int) 1 => array(
		(int) 0 => 'DEBUGKIT_ON',
		(int) 1 => true
	),
	(int) 2 => array(
		(int) 0 => 'MENTE_FLAG',
		(int) 1 => false
	),
	(int) 3 => array(
		(int) 0 => 'SGV_APP_BASE_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/'
	),
	(int) 4 => array(
		(int) 0 => 'CONFIG_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/Config/'
	),
	(int) 5 => array(
		(int) 0 => 'LIB_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/'
	),
	(int) 6 => array(
		(int) 0 => 'MODEL_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/Model/'
	),
	(int) 7 => array(
		(int) 0 => 'CLASS_DIR',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/class/'
	),
	(int) 8 => array(
		(int) 0 => 'THUMBLIB_BASE_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb'
	),
	(int) 9 => array(
		(int) 0 => 'THUMBLIB_PLUGIN_PATH',
		(int) 1 => '/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/'
	),
	(int) 10 => array(
		(int) 0 => 'DEFAULT_THUMBLIB_IMPLEMENTATION',
		(int) 1 => 'gd'
	),
	(int) 11 => array(
		(int) 0 => 'USER_STATIC_SALT',
		(int) 1 => 'Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z'
	),
	(int) 12 => array(
		(int) 0 => 'SITE_TITLE',
		(int) 1 => 'ダンススクール・ダンス教室口コミ検索ネット'
	),
	(int) 13 => array(
		(int) 0 => 'OPERATOR_MAIL_ADDRESS',
		(int) 1 => 'info@kuchi.info'
	),
	(int) 14 => array(
		(int) 0 => 'NO_REPLY_MAIL_ADDRESS',
		(int) 1 => 'no-reply@kuchi.info'
	),
	(int) 15 => array(
		(int) 0 => 'RETURN_PATH__MAIL_ADDRESS',
		(int) 1 => 'errors@kuchi.info'
	),
	(int) 16 => array(
		(int) 0 => 'GOOGLE_API_KEY',
		(int) 1 => 'AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0'
	),
	(int) 17 => array(
		(int) 0 => 'QWINTET_IP',
		(int) 1 => array(
			(int) 0 => '122.216.11.82'
		)
	),
	(int) 18 => array(
		(int) 0 => 'ADSENSE_ID',
		(int) 1 => 'ca-pub-7408087519812416'
	),
	(int) 19 => array(
		(int) 0 => 'CLIENT_IP',
		(int) 1 => '216.73.216.214'
	)
)
$oddTrOptions = array(
	'class' => 'odd'
)
$evenTrOptions = array(
	'class' => 'even'
)
$useCount = false
$continueOddEven = false
$count = (int) 18
$line = array(
	(int) 0 => 'QWINTET_IP',
	(int) 1 => array(
		(int) 0 => '122.216.11.82'
	)
)
$cellsOut = array(
	(int) 0 => '<td>QWINTET_IP</td>'
)
$i = (int) 0
$cell = array(
	(int) 0 => '122.216.11.82'
)
$cellOptions = array()
$options = ' class="odd"'
$out = array(
	(int) 0 => '<tr class="odd"><td>SGV_ENV</td> <td>development</td></tr>',
	(int) 1 => '<tr class="even"><td>DEBUGKIT_ON</td> <td>1</td></tr>',
	(int) 2 => '<tr class="odd"><td>MENTE_FLAG</td> <td></td></tr>',
	(int) 3 => '<tr class="even"><td>SGV_APP_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/</td></tr>',
	(int) 4 => '<tr class="odd"><td>CONFIG_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Config/</td></tr>',
	(int) 5 => '<tr class="even"><td>LIB_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/</td></tr>',
	(int) 6 => '<tr class="odd"><td>MODEL_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Model/</td></tr>',
	(int) 7 => '<tr class="even"><td>CLASS_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/class/</td></tr>',
	(int) 8 => '<tr class="odd"><td>THUMBLIB_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb</td></tr>',
	(int) 9 => '<tr class="even"><td>THUMBLIB_PLUGIN_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/</td></tr>',
	(int) 10 => '<tr class="odd"><td>DEFAULT_THUMBLIB_IMPLEMENTATION</td> <td>gd</td></tr>',
	(int) 11 => '<tr class="even"><td>USER_STATIC_SALT</td> <td>Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z</td></tr>',
	(int) 12 => '<tr class="odd"><td>SITE_TITLE</td> <td>ダンススクール・ダンス教室口コミ検索ネット</td></tr>',
	(int) 13 => '<tr class="even"><td>OPERATOR_MAIL_ADDRESS</td> <td>info@kuchi.info</td></tr>',
	(int) 14 => '<tr class="odd"><td>NO_REPLY_MAIL_ADDRESS</td> <td>no-reply@kuchi.info</td></tr>',
	(int) 15 => '<tr class="even"><td>RETURN_PATH__MAIL_ADDRESS</td> <td>errors@kuchi.info</td></tr>',
	(int) 16 => '<tr class="odd"><td>GOOGLE_API_KEY</td> <td>AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0</td></tr>'
)
HtmlHelper::tableCells() - CORE/Cake/View/Helper/HtmlHelper.php, line 867
HtmlToolbarHelper::table() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 160
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 125
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108
ToolbarHelper::table() - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
include - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
include - ROOT/plugins/DebugKit/View/Elements/debug_toolbar.ctp, line 45
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
HtmlToolbarHelper::send() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 193
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 119
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108

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

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	/kids/pref_28/city_1537?beginner=1&st1=1
Query String	beginner=1&st1=1
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Query String	beginner=1&st1=1
Redirect Url	/kids/pref_28/city_1537
Remote Port	48156
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	216.73.216.214
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http Priority	u=0, i
Http Sec Fetch Dest	document
Http Sec Fetch User	?1
Http Sec Fetch Mode	navigate
Http Sec Fetch Site	none
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.7
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Upgrade Insecure Requests	1
Http Sec Ch Ua Platform	"Windows"
Http Sec Ch Ua Mobile	?0
Http Sec Ch Ua	"Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"
Http Cache Control	no-cache
Http Pragma	no-cache
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	216.73.216.214
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	216.73.216.214
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	aHVwqJ0ZIk-olUBx3GQ2xAAAAWA
Mef Proxy Addr	183.90.231.12
Redirect Status	200
Redirect Ngx Cache Staticmode	1
Redirect Ngx Cache Normalfile	1
Redirect Failurecachetime	0
Redirect Https	on
Redirect Unique Id	aHVwqJ0ZIk-olUBx3GQ2xAAAAWA
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1752527016.8182
Request Time	1752527016

====

Include
+
Included Files

Include Paths
- 0/home/jobikai/dance-schoolgv.net/cakephp/lib/ZendFramework/library/
- 1/home/jobikai/dance-schoolgv.net/vendor/phpunit/dbunit
- 6/home/jobikai/dance-schoolgv.net/vendor/symfony/yaml
- 3/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-code-coverage
- 4/home/jobikai/dance-schoolgv.net/vendor/phpunit/php-token-stream
- 5/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit
- 7/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-mock-objects
- 8/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-selenium
- 9/home/jobikai/dance-schoolgv.net/vendor/phpunit/phpunit-story
- 10/home/jobikai/dance-schoolgv.net/cakephp/lib
- 12/opt/php-5.6.40-3/data/pear
- 13-> /home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SecurityComponent.php
  1CORE/Controller/Component/SessionComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/Security.php
  6CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/SchoolListController.php
  1APP/Controller/AppController.php
  Other(array)
  0APP/webroot/index.php
  1APP/class/Sgv/Front/InputForm/SchoolSearch.php
  2APP/class/Sgv/Front/InputItem/SchoolSearch.php
  3APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
  4APP/class/Sgv/Front/SearchCondition/SchoolList.php
  5APP/class/Sgv/Front/SearchState/SchoolList.php
  6APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
  7APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
  8APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
  9APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
  10APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
  11APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  12APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
  13APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  14APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.php
  15APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
  16APP/class/Sgv/Front/AttachableToDataSet/City.php
  17APP/class/Sgv/Front/PrefectureAttachment/ToSchoolSet.php
  18APP/class/Sgv/Front/AttachableToDataSet/Prefecture.php
  19APP/class/Sgv/Front/StationUnitAttachment/ToSchoolSet.php
  20APP/class/Sgv/Front/AttachableToDataSet/StationUnit.php
  21APP/class/Sgv/Front/MajorCityAttachment/ToSchoolSet.php
  22APP/class/Sgv/Front/AttachableToDataSet/MajorCity.php
  23APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
  24APP/class/Sgv/Front/AttachableToDataSet/Station.php
  25APP/class/Sgv/Front/SchoolScoreAttachment/ToSchoolSet.php
  26APP/class/Sgv/Front/AttachableToDataSet/SchoolScore.php
  27APP/class/Sgv/Front/CategorySchoolAttachment/ToSchoolSet.php
  28APP/class/Sgv/Front/AttachableToDataSet/CategorySchool.php
  29APP/class/Sgv/Front/SchoolListPageLink/ToStationUnitPage.php
  30APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
====

神戸市西区のキッズダンス教室　ダンススクール、ダンス教室

Search Result 検索結果

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

»Popular Area 兵庫県の主要なエリア

School List 神戸市西区(兵庫県)のダンススクールランキング(キッズダンス教室)

»Category Search カテゴリー検索

Special Column

Memory

Timers

神戸市西区のキッズダンス教室 ダンススクール、ダンス教室

Search Result 検索結果

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

»Popular Area 兵庫県の主要なエリア

School List 神戸市西区(兵庫県)のダンススクールランキング(キッズダンス教室)

»Category Search カテゴリー検索

Special Column

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

神戸市西区のキッズダンス教室　ダンススクール、ダンス教室