バレエのレッスンを行う狛江市のダンススクール、ダンス教室

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  keyd24a3694c10c225ea38079da8f34b5eb1f41f0ef
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  e84798cf5ae8089826c14f7b4673a105879928ad1716138346
  1ae6fd759f81957701400b10f5752f0dce2a7d811716138346
  c904d36d6a5bee5e108cc6c68c790aad2bbdb8e91716138347
  655f564a0b92c3631900bf364bb82f4fe795f3c11716138347
  fe6ca3902443dc7ae084e2bb0c62461a951d93e71716138347
  2d7816d3cbe869eb2c30df635464f7aa02190c851716138347
  078b3d1e06ec827c338dadd4870dadff6f6d0c0c1716138348
  5667da542b88cc080142a2533ab62df994e26fd81716138348
  b2d0a1a55fe1eea1f61a628a99cdcea03fbd2a4c1716138348
  df3270c024b8a2498449af816ad413be2649ec7e1716138348
  3affe734dc6f50a92ec54f1d37eae2f0278747a51716138349
  914ca4a917f60803f4bbdc3b065da160a724c8131716138349
  b3eb9dcff234da29d5e5562860f4ad296af236d61716138349
  6d532486e061371de3ed7ea0e96fb42b98a9e3911716138349
  e8b76d8bb47cbf0af1891497971442ad4f6335ce1716138350
  bf569ee2792dccb81411e04fe32b93f5c0c625f01716138350
  99dabb162bcda24333479c6c609f8ab1e5fe3dfb1716138350
  87b7e1a3fc278c47b54a1fec83fc751585bb5fbe1716138350
  ea3dfb51be84035e4068553a6b86fe4a5ceb23281716138351
  7402c316abb479fcab186099874b491027ee7cef1716138351
  3d43db32811bf28c6fe0b13363c1bc0eb279cc7e1716138351
  fd16149eac8a15c4e23c30a74ad4f2e593dc835d1716138352
  2ba9afde64c2432776c00d27b6459791b5d58dad1716138352
  5349a34823d2b978587a4e9a91c8cdab6b75986c1716138352
  bac1ef6b3f9b982154580c34d49e9d16cd7204fc1716138353
  d19fd982e54ef62540525c892057daff5a35bba51716138353
  d24a3694c10c225ea38079da8f34b5eb1f41f0ef1716138353
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool_list
- actionindex
- named(empty)
- pass(empty)
- categorySlugballet
- prefectureId12
- cityId742
- _Token(array)
  keyd24a3694c10c225ea38079da8f34b5eb1f41f0ef
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

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

No.

time

query

0.001747

connect

0.000477

DESCRIBE `prefecture`

0.000317

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

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

0.000477

DESCRIBE `city`

0.000327

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

DESCRIBE `summary_count_school`

0.000707

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 = '742') 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.000437

DESCRIBE `station`

0.000347

SELECT `s`.* FROM `station` AS `s` WHERE (s.city_id = '742') 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	2	Using index condition

0.000407

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 = 1) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id IN ('5133', '5134')) 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		2	Using index condition; Using where

0.000427

DESCRIBE `station_unit`

0.000337

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ALL	prefecture_id				16	Using where

0.000627

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 = 1) 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 IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '14', '15', '16')) 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		14	Using index condition; Using where

0.000407

DESCRIBE `major_city`

0.000327

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

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

DESCRIBE `school`

0.000437

DESCRIBE `category_school`

0.002207

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

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	691

0.003067

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 ('3013181', '3013182', '3013183', '3013184', '3013185', '3013187', '3013188', '3013189', '3013191', '3013200', '3013201', '3013207', '3013211', '3013212', '3013213', '3013214', '3013215', '3013225', '3013228', '3013229', '3013230', '3013234', '3013235', '3013236', '3013238', '3013239', '3013243', '3013246', '3013247', '3013253', '3013254', '3013255', '3013264', '3013265', '3013266', '3013275', '3013293', '3013292', '3013288', '3013294', '3013297', '3013303', '3013305', '3013306', '3013309', '3013315', '3013322', '3013323', '3013328', '3013350', '3013361', '3013365', '3013367', '3013374', '3013380', '3013382', '3013384', '3013385', '3013388', '3013391', '3013414', '3013423', '3013432', '3013433', '3013436', '3013438', '3013442', '3013446', '3013448', '3013449', '3013450', '3013467', '3013490', '3013491', '3013494', '3013499', '3013502', '3013503', '3013504', '3013509', '3013514', '3013524', '3013535', '3013536', '3013542', '3013901', '3013904', '3013932', '3013935', '3013936', '3013940', '3013941', '3013942', '3013943', '3013944', '3013945', '3013948', '3013951', '3013956', '3013959', '3013960', '3013963', '3013968', '3013975', '3013976', '3013978', '3013979', '3013982', '3013984', '3013985', '3013989', '3013992', '3013994', '3013999', '3014001', '3014003', '3014005', '3014011', '3014012', '3014015', '3014018', '3014022', '3014023', '3014030', '3014031', '3014034', '3014036', '3014037', '3014043', '3014045', '3014048', '3014052', '3014053', '3014055', '3014056', '3014057', '3014059', '3014062', '3014068', '3014070', '3014072', '3014074', '3014075', '3014078', '3014084', '3014088', '3014095', '3014098', '3014099', '3014100', '3014111', '3014112', '3014115', '3014116', '3014117', '3014118', '3014121', '3014125', '3014130', '3014134', '3014136', '3014140', '3014146', '3014141', '3014153', '3014160', '3014164', '3014165', '3014167', '3014168', '3014169', '3014171', '3014113', '3014173', '3014176', '3014182', '3014184', '3014185', '3014186', '3014187', '3014188', '3014202', '3014212', '3014226', '3014248', '3014252', '3014254', '3014193', '3014255', '3014256', '3014257', '3014262', '3014263', '3014264', '3014265', '3014272', '3014273', '3014274', '3014279', '3014284', '3014285', '3014287', '3014292', '3014294', '3014296', '3014300', '3014301', '3014302', '3014307', '3014308', '3014311', '3014313', '3014315', '3014316', '3014317', '3014318', '3014195', '3014329', '3014331', '3014334', '3014335', '3014336', '3014340', '3014344', '3014346', '3014351', '3014352', '3014353', '3014354', '3014356', '3014365', '3014369', '3014377', '3014025', '3014384', '3014194', '3014393', '3014362', '3014395', '3014397', '3014403', '3014399', '3014415', '3014416', '3014418', '3014420', '3014421', '3014094', '3014060', '3014429', '3014432', '3014433', '3014436', '3014437', '3014439', '3014441', '3014442', '3014444', '3014451', '3014455', '3014360', '3014452', '3014461', '3014462', '3014467', '3014469', '3014470', '3014475', '3014266', '3014477', '3014478', '3014479', '3014487', '3014370', '3014492', '3014464', '3014500', '3014502', '3014504', '3014507', '3014511', '3014532', '3014533', '3014534', '3014536', '3014476', '3014552', '3014562', '3014563', '3014447', '3013298', '3014570', '3014573', '3014577', '3014581', '3014583', '3014588', '3014590', '3014597', '3014601', '3014604', '3014607', '3014611', '3014618', '3014623', '3014627', '3014629', '3014638', '3014640', '3014408', '3014642', '3014643', '3014644', '3014647', '3014658', '3014661', '3014657', '3014673', '3014200', '3014678', '3014685', '3014686', '3014696', '3014706', '3014712', '3014721', '3014722', '3014702', '3014725', '3014731', '3014738', '3014742', '3014746', '3014749', '3014759', '3014760', '3014764', '3014769', '3014771', '3014772', '3014780', '3014894', '3014783', '3014786', '3014787', '3014790', '3014796', '3014797', '3014802', '3014810', '3014821', '3014823', '3014826', '3014830', '3014927', '3014831', '3014832', '3014849', '3014857', '3014858', '3014859', '3014861', '3014871', '3014873', '3014882', '3014886', '3014887', '3014898', '3014899', '3014909', '3014910', '3014925', '3014933', '3014936', '3014948', '3014960', '3014963', '3014965', '3014967', '3014969', '3014972', '3014977', '3014978', '3014979', '3014980', '3015031', '3014985', '3014989', '3014994', '3014337', '3015026', '3015027', '3015029', '3015036', '3015042', '3015049', '3015051', '3015053', '3015060', '3015063', '3015080', '3015082', '3015083', '3015086', '3015087', '3015091', '3015100', '3015110', '3015112', '3015122', '3015137', '3015143', '3015145', '3015156', '3015157', '3015158', '3015165', '3015173', '3015174', '3015178', '3015182', '3015183', '3015190', '3015284', '3015285', '3015291', '3014423', '3015295', '3015296', '3015306', '3015308', '3015309', '3015311', '3015313', '3015314', '3015315', '3015327', '3015330', '3015331', '3014805', '3015333', '3015335', '3015337', '3015336', '3014926', '3015356', '3015369', '3015371', '3015378', '3015386', '3015389', '3015401', '3015403', '3015405', '3015410', '3015416', '3015417', '3015424', '3015430', '3015436', '3015452', '3015462', '3015463', '3015464', '3015473', '3015476', '3015481', '3015505', '3015512', '3015522', '3015529', '3015531', '3015532', '3015537', '3015544', '3015547', '3015548', '3015553', '3015560', '3015564', '3015565', '3015566', '3015569', '3015570', '3015576', '3015580', '3015582', '3015590', '3015595', '3015596', '3015598', '3015601', '3015606', '3015619', '3015620', '3015622', '3015623', '3015629', '3015630', '3015633', '3015636', '3015645', '3015374', '3015650', '3015654', '3015607', '3015659', '3015660', '3015662', '3014677', '3015674', '3015684', '3015688', '3015694', '3015695', '3015699', '3015700', '3015701', '3015708', '3015712', '3015713', '3015714', '3015716', '3015718', '3015723', '3015724', '3015725', '3015739', '3015740', '3015751', '3015758', '3015762', '3015764', '3015765', '3015770', '3015785', '3015787', '3015797', '3015798', '3015806', '3015811', '3015813', '3015814', '3015822', '3015823', '3015829', '3015831', '3015517', '3015834', '3015837', '3015841', '3015842', '3015843', '3014952', '3015857', '3015864', '3015866', '3015868', '3015880', '3015886', '3015893', '3015902', '3015903', '3015907', '3015910', '3015927', '3015929', '3015930', '3015935', '3015937', '3015939', '3015940', '3015942', '3015957', '3015960', '3015968', '3015972', '3015980', '3015985', '3015986', '3015989', '3015990', '3015991', '3016002', '3016003', '3016004', '3016012', '3016013', '3016014', '3016015', '3016020', '3016027', '3016035', '3016040', '3016049', '3016055', '3016068', '3016074', '3015953', '3016080', '3016114', '3016115', '3016118', '3016140', '3016146', '3016147', '3016148', '3016149', '3016151', '3016153', '3016154', '3016155', '3016157', '3016159', '3014459', '3016160', '3016164', '3016167', '3016174', '3016175', '3016182', '3016184', '3016186', '3016190', '3016191', '3016193', '3016196', '3016201', '3016220', '3016223', '3016225', '3016230', '3016233', '3016236', '3016120', '3016252', '3016255', '3016269', '3016273', '3016279', '3016286', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016314', '3016315', '3016316', '3016319', '3016322', '3016324', '3016331', '3016333', '3016338', '3016341', '3016342', '3016343', '3016347', '3016359', '3016360', '3016369', '3016370', '3016373', '3016374', '3016375', '3014446', '3016383', '3016384', '3016363', '3016385', '3016388', '3016392', '3016401', '3016403', '3016404', '3016407', '3016408', '3016409', '3016278', '3016420', '3016426', '3016429', '3016431', '3016433', '3016438', '3016439')) AND (s.city_id = '742')

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

0.002727

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013181', '3013182', '3013183', '3013184', '3013185', '3013187', '3013188', '3013189', '3013191', '3013200', '3013201', '3013207', '3013211', '3013212', '3013213', '3013214', '3013215', '3013225', '3013228', '3013229', '3013230', '3013234', '3013235', '3013236', '3013238', '3013239', '3013243', '3013246', '3013247', '3013253', '3013254', '3013255', '3013264', '3013265', '3013266', '3013275', '3013293', '3013292', '3013288', '3013294', '3013297', '3013303', '3013305', '3013306', '3013309', '3013315', '3013322', '3013323', '3013328', '3013350', '3013361', '3013365', '3013367', '3013374', '3013380', '3013382', '3013384', '3013385', '3013388', '3013391', '3013414', '3013423', '3013432', '3013433', '3013436', '3013438', '3013442', '3013446', '3013448', '3013449', '3013450', '3013467', '3013490', '3013491', '3013494', '3013499', '3013502', '3013503', '3013504', '3013509', '3013514', '3013524', '3013535', '3013536', '3013542', '3013901', '3013904', '3013932', '3013935', '3013936', '3013940', '3013941', '3013942', '3013943', '3013944', '3013945', '3013948', '3013951', '3013956', '3013959', '3013960', '3013963', '3013968', '3013975', '3013976', '3013978', '3013979', '3013982', '3013984', '3013985', '3013989', '3013992', '3013994', '3013999', '3014001', '3014003', '3014005', '3014011', '3014012', '3014015', '3014018', '3014022', '3014023', '3014030', '3014031', '3014034', '3014036', '3014037', '3014043', '3014045', '3014048', '3014052', '3014053', '3014055', '3014056', '3014057', '3014059', '3014062', '3014068', '3014070', '3014072', '3014074', '3014075', '3014078', '3014084', '3014088', '3014095', '3014098', '3014099', '3014100', '3014111', '3014112', '3014115', '3014116', '3014117', '3014118', '3014121', '3014125', '3014130', '3014134', '3014136', '3014140', '3014146', '3014141', '3014153', '3014160', '3014164', '3014165', '3014167', '3014168', '3014169', '3014171', '3014113', '3014173', '3014176', '3014182', '3014184', '3014185', '3014186', '3014187', '3014188', '3014202', '3014212', '3014226', '3014248', '3014252', '3014254', '3014193', '3014255', '3014256', '3014257', '3014262', '3014263', '3014264', '3014265', '3014272', '3014273', '3014274', '3014279', '3014284', '3014285', '3014287', '3014292', '3014294', '3014296', '3014300', '3014301', '3014302', '3014307', '3014308', '3014311', '3014313', '3014315', '3014316', '3014317', '3014318', '3014195', '3014329', '3014331', '3014334', '3014335', '3014336', '3014340', '3014344', '3014346', '3014351', '3014352', '3014353', '3014354', '3014356', '3014365', '3014369', '3014377', '3014025', '3014384', '3014194', '3014393', '3014362', '3014395', '3014397', '3014403', '3014399', '3014415', '3014416', '3014418', '3014420', '3014421', '3014094', '3014060', '3014429', '3014432', '3014433', '3014436', '3014437', '3014439', '3014441', '3014442', '3014444', '3014451', '3014455', '3014360', '3014452', '3014461', '3014462', '3014467', '3014469', '3014470', '3014475', '3014266', '3014477', '3014478', '3014479', '3014487', '3014370', '3014492', '3014464', '3014500', '3014502', '3014504', '3014507', '3014511', '3014532', '3014533', '3014534', '3014536', '3014476', '3014552', '3014562', '3014563', '3014447', '3013298', '3014570', '3014573', '3014577', '3014581', '3014583', '3014588', '3014590', '3014597', '3014601', '3014604', '3014607', '3014611', '3014618', '3014623', '3014627', '3014629', '3014638', '3014640', '3014408', '3014642', '3014643', '3014644', '3014647', '3014658', '3014661', '3014657', '3014673', '3014200', '3014678', '3014685', '3014686', '3014696', '3014706', '3014712', '3014721', '3014722', '3014702', '3014725', '3014731', '3014738', '3014742', '3014746', '3014749', '3014759', '3014760', '3014764', '3014769', '3014771', '3014772', '3014780', '3014894', '3014783', '3014786', '3014787', '3014790', '3014796', '3014797', '3014802', '3014810', '3014821', '3014823', '3014826', '3014830', '3014927', '3014831', '3014832', '3014849', '3014857', '3014858', '3014859', '3014861', '3014871', '3014873', '3014882', '3014886', '3014887', '3014898', '3014899', '3014909', '3014910', '3014925', '3014933', '3014936', '3014948', '3014960', '3014963', '3014965', '3014967', '3014969', '3014972', '3014977', '3014978', '3014979', '3014980', '3015031', '3014985', '3014989', '3014994', '3014337', '3015026', '3015027', '3015029', '3015036', '3015042', '3015049', '3015051', '3015053', '3015060', '3015063', '3015080', '3015082', '3015083', '3015086', '3015087', '3015091', '3015100', '3015110', '3015112', '3015122', '3015137', '3015143', '3015145', '3015156', '3015157', '3015158', '3015165', '3015173', '3015174', '3015178', '3015182', '3015183', '3015190', '3015284', '3015285', '3015291', '3014423', '3015295', '3015296', '3015306', '3015308', '3015309', '3015311', '3015313', '3015314', '3015315', '3015327', '3015330', '3015331', '3014805', '3015333', '3015335', '3015337', '3015336', '3014926', '3015356', '3015369', '3015371', '3015378', '3015386', '3015389', '3015401', '3015403', '3015405', '3015410', '3015416', '3015417', '3015424', '3015430', '3015436', '3015452', '3015462', '3015463', '3015464', '3015473', '3015476', '3015481', '3015505', '3015512', '3015522', '3015529', '3015531', '3015532', '3015537', '3015544', '3015547', '3015548', '3015553', '3015560', '3015564', '3015565', '3015566', '3015569', '3015570', '3015576', '3015580', '3015582', '3015590', '3015595', '3015596', '3015598', '3015601', '3015606', '3015619', '3015620', '3015622', '3015623', '3015629', '3015630', '3015633', '3015636', '3015645', '3015374', '3015650', '3015654', '3015607', '3015659', '3015660', '3015662', '3014677', '3015674', '3015684', '3015688', '3015694', '3015695', '3015699', '3015700', '3015701', '3015708', '3015712', '3015713', '3015714', '3015716', '3015718', '3015723', '3015724', '3015725', '3015739', '3015740', '3015751', '3015758', '3015762', '3015764', '3015765', '3015770', '3015785', '3015787', '3015797', '3015798', '3015806', '3015811', '3015813', '3015814', '3015822', '3015823', '3015829', '3015831', '3015517', '3015834', '3015837', '3015841', '3015842', '3015843', '3014952', '3015857', '3015864', '3015866', '3015868', '3015880', '3015886', '3015893', '3015902', '3015903', '3015907', '3015910', '3015927', '3015929', '3015930', '3015935', '3015937', '3015939', '3015940', '3015942', '3015957', '3015960', '3015968', '3015972', '3015980', '3015985', '3015986', '3015989', '3015990', '3015991', '3016002', '3016003', '3016004', '3016012', '3016013', '3016014', '3016015', '3016020', '3016027', '3016035', '3016040', '3016049', '3016055', '3016068', '3016074', '3015953', '3016080', '3016114', '3016115', '3016118', '3016140', '3016146', '3016147', '3016148', '3016149', '3016151', '3016153', '3016154', '3016155', '3016157', '3016159', '3014459', '3016160', '3016164', '3016167', '3016174', '3016175', '3016182', '3016184', '3016186', '3016190', '3016191', '3016193', '3016196', '3016201', '3016220', '3016223', '3016225', '3016230', '3016233', '3016236', '3016120', '3016252', '3016255', '3016269', '3016273', '3016279', '3016286', '3016298', '3016299', '3016300', '3016301', '3016302', '3016303', '3016304', '3016305', '3016306', '3016314', '3016315', '3016316', '3016319', '3016322', '3016324', '3016331', '3016333', '3016338', '3016341', '3016342', '3016343', '3016347', '3016359', '3016360', '3016369', '3016370', '3016373', '3016374', '3016375', '3014446', '3016383', '3016384', '3016363', '3016385', '3016388', '3016392', '3016401', '3016403', '3016404', '3016407', '3016408', '3016409', '3016278', '3016420', '3016426', '3016429', '3016431', '3016433', '3016438', '3016439')) AND (s.city_id = '742') 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	city_id	9		691	Using index condition; Using where; Using filesort

0.003537

connect

0.001417

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

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

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

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

0.000597

DESCRIBE `summary_count_kuchikomi`

0.000427

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 = 1) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = '742') 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.000527

DESCRIBE `dancer`

0.000497

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

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

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

0.000447

DESCRIBE `dancer_column`

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

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

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

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

0.000377

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

Message	Memory use
Component initialization	2.17 MB
Controller action start	2.40 MB
Controller render start	4.37 MB
View render complete	5.08 MB

Timers

Total Request Time: 119 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	6.87
Event: Controller.initialize	0.56
Event: Controller.startup	0.30
Controller action	49.76
Event: Controller.beforeRender	16.57
» Processing toolbar data	11.02
Rendering View	23.40
» Event: View.beforeRender	2.86
» Rendering APP/View/SchoolList/index.ctp	9.27
» » Rendering APP/View/Elements/breadcrumb.ctp	0.25
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.08
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	5.73
» » Rendering APP/View/Elements/__searchlink/main-column-station-unit.ctp	0.42
» » Rendering APP/View/Elements/__searchlink/main-column-station.ctp	0.11
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.07
» » Rendering APP/View/Elements/paginator.ctp	0.07
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	10.41
» » Rendering APP/View/Elements/header.ctp	0.34
» » Rendering APP/View/Elements/menu.ctp	7.77
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	7.60
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.07
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	6.91
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.08
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.07
» » Rendering APP/View/Elements/rtt.ctp	0.11
» » Rendering APP/View/Elements/footer.ctp	0.87
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.08
Event: View.afterLayout	0.00

====

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
  categorySlugballet
  2(array)
  name東京都
  link(array)
  controllerschool_list
  actionindex
  categorySlugballet
  prefectureId12
  3(array)
  name狛江市
  link
- metaKeywordStringバレエ,狛江市,東京都,ダンススクール,ダンス教室
- headString狛江市のバレエ　ダンススクール、ダンス教室
- metaDescription狛江市にあるバレエスクール、バレエ教室の口コミ評判ランキング。ダンスレッスン体験談からあなたに合った狛江市のバレエスクールを探し出せます！
- title_for_layoutバレエのレッスンを行う狛江市のダンススクール、ダンス教室
- SchoolSet(object)
- SchoolPager(object)
- SearchTransitableToStationUnitPage(object)
- StationUnitSet(array)
  0(object)
  id1
  name銀座・有楽町・新橋
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id2
  name六本木・青山・麻布・赤坂
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id3
  name渋谷・原宿・表参道
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  3(object)
  id4
  name恵比寿・目黒
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  4(object)
  id5
  name新宿・代々木・中野
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  5(object)
  id6
  name池袋・目白・大塚
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  6(object)
  id7
  name上野・秋葉原・錦糸町
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  7(object)
  id8
  name品川・田町・蒲田
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  8(object)
  id9
  name自由が丘・中目黒・二子玉川
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  9(object)
  id10
  name三鷹・調布・吉祥寺
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  10(object)
  id11
  name町田・多摩・相模原
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  11(object)
  id14
  name飯田橋・市ヶ谷・四ッ谷
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  12(object)
  id15
  name国立・府中・国分寺
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  13(object)
  id16
  name立川・八王子・青梅
  prefecture_id12
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToStationPage(object)
- StationSet(array)
  0(object)
  id5134
  name和泉多摩川
  city_id742
  lat35.627349000000
  lon139.573695000000
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToCategoryPage(object)
- 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.19.244.187'
	)
)
$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.19.244.187

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	/ballet/pref_12/city_742
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/ballet/pref_12/city_742
Remote Port	44172
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.19.244.187
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http Cookie	PHPSESSID=8f7gu0p0jvlo8vffhamuu5cr9ktms4eq
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	3.19.244.187
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	www.dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	3.19.244.187
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZkoqaXaopBNBFEfDXxorugAAAZE
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	ZkoqaXaopBNBFEfDXxorugAAAZE
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1716136553.5028
Request Time	1716136553

====

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/ToStationUnitPage.php
  14APP/class/Sgv/Front/SearchTransitable/ToStationUnitPage.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/InputForm/Auth/Login.php
  30APP/class/Sgv/Front/InputItem/Auth/Login.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 東京都の主要なエリア

»Area Search 駅で絞る

School List 狛江市(東京都)のダンススクールランキング(バレエ)

Special Column

Memory

Timers

狛江市のバレエ ダンススクール、ダンス教室

Search Result 検索結果

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

»Popular Area 東京都の主要なエリア

»Area Search 駅で絞る

School List 狛江市(東京都)のダンススクールランキング(バレエ)

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

狛江市のバレエ　ダンススクール、ダンス教室