社交ダンスのレッスンを行う袖ケ浦市のダンススクール、ダンス教室

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

Cake Params
- plugin(null)
- controllerschool_list
- actionindex
- named(empty)
- pass(empty)
- categorySlugsocial
- prefectureId13
- cityId833
- _Token(array)
  key4d3daa418d3db6aaa3a0f7390aaeef4ed67c5175
  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: 48 queries / 0.027667 sec

No.

time

query

0.001847

connect

0.000457

DESCRIBE `prefecture`

0.000317

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

DESCRIBE `city`

0.000307

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

DESCRIBE `summary_count_school`

0.000727

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 = '833') 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.000457

DESCRIBE `station`

0.000347

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

0.000437

SELECT `s_c_s`.* FROM `summary_count_school` AS `s_c_s` WHERE (s_c_s.is_latest = 1) AND (s_c_s.category_id = 10) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id = 0) AND (s_c_s.station_id IN ('1737', '1738', '1809', '1810')) 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		4	Using index condition; Using where

0.000477

DESCRIBE `station_unit`

0.000317

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

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

DESCRIBE `major_city`

0.000377

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

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

0.000517

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 = 10) 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 ('2', '3', '4')) 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		3	Using index condition; Using where

0.000787

DESCRIBE `school`

0.000537

DESCRIBE `category_school`

0.001137

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

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	227

0.001797

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 ('3013182', '3013189', '3013265', '3013266', '3013269', '3013276', '3013307', '3013311', '3013316', '3013327', '3013334', '3013354', '3013381', '3013396', '3013447', '3013469', '3013470', '3013474', '3013490', '3013504', '3013513', '3013514', '3013519', '3013534', '3013540', '3013904', '3013934', '3013940', '3013947', '3013959', '3013960', '3013961', '3013967', '3013974', '3013985', '3013990', '3013991', '3013993', '3013996', '3013997', '3014009', '3014015', '3014018', '3014022', '3014028', '3014042', '3014045', '3014047', '3014048', '3014052', '3014066', '3014083', '3014096', '3014097', '3014099', '3014108', '3014109', '3014110', '3014134', '3014151', '3014156', '3014161', '3014163', '3014180', '3014182', '3014202', '3014207', '3014210', '3014247', '3014248', '3014253', '3014193', '3014258', '3014259', '3014260', '3014304', '3014313', '3014324', '3014333', '3014344', '3014345', '3014347', '3014349', '3014350', '3014355', '3014357', '3014359', '3014383', '3014409', '3014094', '3014425', '3014434', '3014438', '3014439', '3014462', '3014492', '3014496', '3014534', '3014541', '3014544', '3014545', '3014547', '3014553', '3014576', '3014581', '3014583', '3014593', '3014615', '3014618', '3014620', '3014624', '3014644', '3014646', '3014647', '3014694', '3014700', '3014705', '3014711', '3014722', '3014725', '3014755', '3014765', '3014772', '3014789', '3014813', '3014814', '3014926', '3014832', '3014834', '3014842', '3014844', '3014846', '3014849', '3014860', '3014861', '3014867', '3014909', '3014923', '3014932', '3014934', '3014968', '3014973', '3015034', '3015053', '3015071', '3015094', '3015122', '3015132', '3015143', '3015156', '3015166', '3013268', '3015365', '3015373', '3015391', '3015396', '3015425', '3015448', '3015449', '3015463', '3015470', '3015488', '3015504', '3015529', '3015531', '3015544', '3015551', '3015552', '3015553', '3015588', '3015594', '3015608', '3015617', '3015629', '3015632', '3015641', '3015650', '3015660', '3015667', '3015685', '3015699', '3014802', '3015711', '3015756', '3015765', '3015815', '3015818', '3015827', '3015832', '3015834', '3015861', '3015890', '3015892', '3015901', '3015917', '3015942', '3015969', '3015975', '3015989', '3015990', '3016016', '3016019', '3016030', '3016031', '3016052', '3016114', '3016132', '3015082', '3016146', '3016147', '3016185', '3016197', '3016241', '3016243', '3016266', '3016335', '3016345', '3016349', '3016351', '3016359', '3016378', '3016401', '3016419', '3016420', '3016428', '3016433', '3016438')) AND (s.city_id = '833')

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

0.001617

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013182', '3013189', '3013265', '3013266', '3013269', '3013276', '3013307', '3013311', '3013316', '3013327', '3013334', '3013354', '3013381', '3013396', '3013447', '3013469', '3013470', '3013474', '3013490', '3013504', '3013513', '3013514', '3013519', '3013534', '3013540', '3013904', '3013934', '3013940', '3013947', '3013959', '3013960', '3013961', '3013967', '3013974', '3013985', '3013990', '3013991', '3013993', '3013996', '3013997', '3014009', '3014015', '3014018', '3014022', '3014028', '3014042', '3014045', '3014047', '3014048', '3014052', '3014066', '3014083', '3014096', '3014097', '3014099', '3014108', '3014109', '3014110', '3014134', '3014151', '3014156', '3014161', '3014163', '3014180', '3014182', '3014202', '3014207', '3014210', '3014247', '3014248', '3014253', '3014193', '3014258', '3014259', '3014260', '3014304', '3014313', '3014324', '3014333', '3014344', '3014345', '3014347', '3014349', '3014350', '3014355', '3014357', '3014359', '3014383', '3014409', '3014094', '3014425', '3014434', '3014438', '3014439', '3014462', '3014492', '3014496', '3014534', '3014541', '3014544', '3014545', '3014547', '3014553', '3014576', '3014581', '3014583', '3014593', '3014615', '3014618', '3014620', '3014624', '3014644', '3014646', '3014647', '3014694', '3014700', '3014705', '3014711', '3014722', '3014725', '3014755', '3014765', '3014772', '3014789', '3014813', '3014814', '3014926', '3014832', '3014834', '3014842', '3014844', '3014846', '3014849', '3014860', '3014861', '3014867', '3014909', '3014923', '3014932', '3014934', '3014968', '3014973', '3015034', '3015053', '3015071', '3015094', '3015122', '3015132', '3015143', '3015156', '3015166', '3013268', '3015365', '3015373', '3015391', '3015396', '3015425', '3015448', '3015449', '3015463', '3015470', '3015488', '3015504', '3015529', '3015531', '3015544', '3015551', '3015552', '3015553', '3015588', '3015594', '3015608', '3015617', '3015629', '3015632', '3015641', '3015650', '3015660', '3015667', '3015685', '3015699', '3014802', '3015711', '3015756', '3015765', '3015815', '3015818', '3015827', '3015832', '3015834', '3015861', '3015890', '3015892', '3015901', '3015917', '3015942', '3015969', '3015975', '3015989', '3015990', '3016016', '3016019', '3016030', '3016031', '3016052', '3016114', '3016132', '3015082', '3016146', '3016147', '3016185', '3016197', '3016241', '3016243', '3016266', '3016335', '3016345', '3016349', '3016351', '3016359', '3016378', '3016401', '3016419', '3016420', '3016428', '3016433', '3016438')) AND (s.city_id = '833') 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		227	Using index condition; Using where; Using filesort

0.000357

SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('833'))

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

0.000467

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

DESCRIBE `school_station`

0.000377

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015632'))

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

0.000587

DESCRIBE `station_station_unit`

0.000357

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id IN ('1737'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s_s	ref	station_id	station_id	4	const	1

0.000517

DESCRIBE `city_major_city`

0.000357

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id IN ('833'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_m_c	ref	city_id	city_id	4	const	1

0.000327

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015632'))

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

0.000307

SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('1737')) GROUP BY `s`.`id`

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

0.000497

DESCRIBE `school_score`

0.000367

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id IN ('3015632')) AND (s_s.is_latest = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	1	Using where

0.000357

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3015632'))

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

0.001687

connect

0.000727

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

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

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

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

0.000657

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 = 10) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = '833') 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.000607

DESCRIBE `dancer`

0.000587

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

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

0.000377

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

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

0.000477

DESCRIBE `dancer_column`

0.000427

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

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

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

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

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

Message	Memory use
Component initialization	2.16 MB
Controller action start	2.40 MB
Controller render start	4.86 MB
View render complete	5.58 MB

Timers

Total Request Time: 152 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	7.60
Event: Controller.initialize	0.72
Event: Controller.startup	0.30
Controller action	46.21
Event: Controller.beforeRender	41.77
» Processing toolbar data	38.57
Rendering View	25.57
» Event: View.beforeRender	0.91
» Rendering APP/View/SchoolList/index.ctp	11.34
» » Rendering APP/View/Elements/breadcrumb.ctp	0.30
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.13
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	7.07
» » Rendering APP/View/Elements/__searchlink/main-column-major-city.ctp	0.18
» » Rendering APP/View/Elements/__searchlink/main-column-station.ctp	0.11
» » Rendering APP/View/Elements/school-box.ctp	0.50
» » » Rendering APP/View/Elements/adsense/336_288.ctp	0.08
» » Rendering APP/View/Elements/paginator.ctp	0.07
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	12.22
» » Rendering APP/View/Elements/header.ctp	0.38
» » Rendering APP/View/Elements/menu.ctp	9.37
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	9.17
» » » » Rendering APP/View/Elements/__searchlink/right-menu-category.ctp	0.13
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.08
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	8.16
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.09
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.09
» » Rendering APP/View/Elements/rtt.ctp	0.15
» » Rendering APP/View/Elements/footer.ctp	0.83
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.09
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
  categorySlugsocial
  2(array)
  name千葉県
  link(array)
  controllerschool_list
  actionindex
  categorySlugsocial
  prefectureId13
  3(array)
  name袖ケ浦市
  link
- metaKeywordString社交ダンス,袖ケ浦市,千葉県,ダンススクール,ダンス教室
- headString袖ケ浦市の社交ダンス　ダンススクール、ダンス教室
- metaDescription社交ダンスのレッスンを行う袖ケ浦市（千葉県）のダンススクール、ダンス教室(1件)の口コミ評判ランキング。1件のダンスレッスン体験談からあなたに合った袖ケ浦市のスクールを探し出せます！
- title_for_layout社交ダンスのレッスンを行う袖ケ浦市のダンススクール、ダンス教室
- SchoolSet(object)
  0(object)
  id3015632
  nameとくらダンススクール
  branch_name
  city_id833
  schoolgroup_id(null)
  mail_addresspiy.tk1090@gmail.com
  lat35.4424758
  lon139.985571
  telephone_number0438-62-3100
  homepage_urlhttp://dance-tokura.com/
  mobile_homepage_urlhttp://dance-tokura.com/
  blog_url
  open_hour10:00～22:00
  holiday日・祝
  post_code299-0245
  town_address蔵波台 1-3-3
  building
  image_hash
  image_extension_type0
  message_image_hash(null)
  message_image_extension_type(null)
  is_registered_by_not_owner0
  is_opening1
  message_title(null)
  message_body(null)
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_title(null)
  whole_staff_introduction(null)
  whole_staff_image_hash(null)
  whole_staff_image_extension_type(null)
  is_kuchikomi_notice_mail_receiving0
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course1
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2014-06-08 21:45:30
  timestamp_modified2021-08-03 15:07:43
  memo(null)
- SchoolPager(object)
  0(object) - recursion
- SearchTransitableToMajorCityPage(object)
- MajorCitySet(array)
  0(object)
  id2
  name千葉
  prefecture_id13
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id3
  name柏・松戸
  prefecture_id13
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToStationPage(object)
- StationSet(array)
  0(object)
  id1737
  name長浦
  city_id833
  lat35.450234000000
  lon139.995478000000
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToCategoryPage(object)
- CategorySet(array)
  0(object)
  id10
  name社交ダンス
  slugsocial
  description儀式や舞台(ショー)向けのダンスではなく、男女のペアで楽曲に合わせて踊るペアダンスの事を社交ダンスと言います。社交ダンスは大きく分けるとワルツやタンゴに代表されるようなスタンダードと呼ばれるものと、サンバやルンバ、パソドブレといったラテンダンスに分類されます。社交ダンスという名称は元々sociality dancingの誤訳からできた言葉で、日本国内でのみSocial Danceという言葉が利用されています。英語では一般的にBallroom Dance(ボールルームダンス＝舞踏室の踊り)とあらわされ、競技ダンスなども社交ダンスと言われます。
- 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 => '18.188.20.56'
	)
)
$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	18.188.20.56

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	/social/pref_13/city_833
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/social/pref_13/city_833
Remote Port	51486
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	18.188.20.56
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
Http User Agent	claudebot
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	18.188.20.56
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	18.188.20.56
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	Zh4ZkB8817QOUVV8_dl5-gAAAnM
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	Zh4ZkB8817QOUVV8_dl5-gAAAnM
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713248656.5979
Request Time	1713248656

====

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
  31APP/class/Sgv/Front/InputForm/Auth/Login.php
  32APP/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 袖ケ浦市(千葉県)のダンススクールランキング(社交ダンス)
1〜1件を表示／1件

とくらダンススクール

»Category Search カテゴリー検索

Special Column

Memory

Timers

袖ケ浦市の社交ダンス ダンススクール、ダンス教室

Search Result 検索結果

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

»Popular Area 千葉県の主要なエリア

»Area Search 駅で絞る

School List 袖ケ浦市(千葉県)のダンススクールランキング(社交ダンス) 1〜1件を表示／1件

とくらダンススクール

»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

袖ケ浦市の社交ダンス　ダンススクール、ダンス教室

School List 袖ケ浦市(千葉県)のダンススクールランキング(社交ダンス)
1〜1件を表示／1件