北海道のダンススクール・ダンス教室の口コミ・評判・体験談｜ダンススクール・ダンス教室の口コミ検索ネット

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key8453e6261e67b9e670c126f0343ebc6c51920cac
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  8453e6261e67b9e670c126f0343ebc6c51920cac1713945428
====
Request
+
Request

Cake Params
- plugin(null)
- controllerkuchikomi_list
- actionindex
- named(empty)
- pass(empty)
- prefectureId1
- _Token(array)
  key8453e6261e67b9e670c126f0343ebc6c51920cac
  unlockedFields(empty)
Post data

No post data.

Query string
- page2
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0prefectureId
- options(array)
  prefectureId[0-9]+
- defaults(array)
  controllerkuchikomi_list
  actionindex
  plugin(null)
- template/kuchikomi/pref_:prefectureId
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 95 queries / 0.062177 sec

No.

time

query

0.001897

connect

0.000557

DESCRIBE `prefecture`

0.000337

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

DESCRIBE `summary_count_kuchikomi`

0.000707

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 IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) AND (s_c_k.prefecture_id = '1') AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_k	range	multi	multi	28		17	Using index condition; Using where

0.000447

DESCRIBE `city`

0.000687

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

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

0.001137

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 = 0) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id IN ('1', '2', '3', '4', '5', '7', '9', '13', '14', '23', '25', '26', '27', '29', '30', '32', '33', '34', '40', '44', '45', '46', '47', '48', '49', '52', '56', '59', '62', '76', '78', '80', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '101', '102', '104', '105', '106', '107', '110', '111', '112', '114', '115', '116', '117', '125', '126', '127', '128', '132', '133', '139', '140', '143', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '164', '165', '166', '167', '169', '170', '171', '172', '174', '175', '176', '177', '178', '185', '186', '187', '190', '191', '197', '200', '202', '203', '204', '205')) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_k	range	multi	multi	28		105	Using index condition; Using where

0.000517

DESCRIBE `station_unit`

0.000347

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

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

DESCRIBE `major_city`

0.000417

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

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

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 = 0) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) AND (s_c_k.major_city_id IN ('9')) AND (s_c_k.count > 0)

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

0.001017

DESCRIBE `school`

0.000597

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

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

0.001047

SELECT `s`.`id` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.city_id IN ('1', '2', '3', '4', '5', '7', '9', '13', '14', '23', '25', '26', '27', '29', '30', '32', '33', '34', '40', '44', '45', '46', '47', '48', '49', '52', '56', '59', '62', '76', '78', '80', '82', '83', '84', '85', '86', '87', '88', '89', '90', '91', '92', '93', '94', '95', '96', '97', '98', '101', '102', '104', '105', '106', '107', '110', '111', '112', '114', '115', '116', '117', '125', '126', '127', '128', '132', '133', '139', '140', '143', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '164', '165', '166', '167', '169', '170', '171', '172', '174', '175', '176', '177', '178', '185', '186', '187', '190', '191', '197', '200', '202', '203', '204', '205'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	city_id	city_id	5		143	Using index condition; Using where

0.000527

DESCRIBE `kuchikomi`

0.000537

SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013998', '3014765', '3014705', '3015502', '3013282', '3013313', '3014602', '3014934', '3015159', '3015257', '3015273', '3015457', '3015715', '3015793', '3015830', '3014940', '3015249', '3015899', '3016116', '3016242', '3016447', '3014347', '3014394', '3016117'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k	range	ix_school_id_kuchikomi	ix_school_id_kuchikomi	4		36	Using index condition; Using where

0.000627

SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013998', '3014765', '3014705', '3015502', '3013282', '3013313', '3014602', '3014934', '3015159', '3015257', '3015273', '3015457', '3015715', '3015793', '3015830', '3014940', '3015249', '3015899', '3016116', '3016242', '3016447', '3014347', '3014394', '3016117')) ORDER BY `k`.`posted_at` DESC LIMIT 10 OFFSET 10

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k	range	ix_school_id_kuchikomi	ix_school_id_kuchikomi	4		36	Using index condition; Using where; Using filesort

0.019157

DESCRIBE `kuchikomi_category`

0.001007

SELECT `k_c`.* FROM `kuchikomi_category` AS `k_c` WHERE (k_c.kuchikomi_id IN ('1198', '1195', '1194', '1193', '1179', '1178', '175', '162'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k_c	range	kuchikomi_id	kuchikomi_id	4		14	Using index condition

0.000797

DESCRIBE `member`

0.000437

SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('2844', '2844', '2844', '2844', '2631', '2631', '', ''))

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

0.000477

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3015249', '3014940', '3015502', '3014934', '3014347', '3015502', '3014347', '3013998'))

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

0.000577

DESCRIBE `access_count_kuchikomi`

0.000447

SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1198', '1195', '1194', '1193', '1179', '1178', '175', '162'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a_c_k	range	kuchikomi_id	kuchikomi_id	4		8	Using index condition

0.000787

DESCRIBE `kuchikomi_questionnaire_answer`

0.000697

SELECT `k_q_a`.* FROM `kuchikomi_questionnaire_answer` AS `k_q_a` WHERE (k_q_a.kuchikomi_id IN ('1198', '1195', '1194', '1193', '1179', '1178', '175', '162'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	k_q_a	range	ix_kuchikomi_id_kuchikomi_questionnaire_answer	ix_kuchikomi_id_kuchikomi_questionnaire_answer	4		48	Using index condition

0.001727

connect

0.000597

DESCRIBE `summary_count_school`

0.000397

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

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

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

0.000397

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

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

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

0.000497

DESCRIBE `school_station`

0.000387

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015249')

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

DESCRIBE `station_station_unit`

0.000307

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6416')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000427

DESCRIBE `city_major_city`

0.000307

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '94')

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 `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000817

DESCRIBE `schoolgroup`

0.000377

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

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

0.000317

SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '94') LIMIT 1

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

0.000307

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

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

0.000377

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014940')

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

0.000347

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6417')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '69')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6418')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000317

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '94')

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000317

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

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015502')

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

0.000307

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6436')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6437')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000327

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '88')

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000317

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

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014934')

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

0.000317

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6420')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6419')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6421')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000307

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '91')

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000327

SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '95') LIMIT 1

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

0.000307

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014347')

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

0.000297

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6448')

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

SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '6448')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000317

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '95')

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.id IN ('9'))

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

0.000337

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

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3013998')

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

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000297

SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '85')

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

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (false)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE

0.000947

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 = '1') AND (s_c_s.city_id = 0) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_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	20	const,const,const,const,const	2632	Using index condition

0.000547

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

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

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

0.000357

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

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

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

Message	Memory use
Component initialization	2.14 MB
Controller action start	2.38 MB
Controller render start	5.33 MB
View render complete	6.81 MB

Timers

Total Request Time: 198 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	7.69
Event: Controller.initialize	1.02
Event: Controller.startup	0.38
Controller action	66.68
Event: Controller.beforeRender	22.19
» Processing toolbar data	18.40
Rendering View	61.93
» Event: View.beforeRender	0.81
» Rendering APP/View/KuchikomiList/index.ctp	47.89
» » Rendering APP/View/Elements/breadcrumb.ctp	0.22
» » Rendering APP/View/Elements/kuchikomi_list/search-inputform.ctp	8.09
» » Rendering APP/View/Elements/__searchlink/main-column-major-city.ctp	0.13
» » Rendering APP/View/Elements/__searchlink/main-column-city.ctp	0.20
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp	0.27
» » Rendering APP/View/Elements/kuchikomi-box.ctp	10.48
» » » Rendering APP/View/Elements/adsense/336_288.ctp	0.10
» » Rendering APP/View/Elements/kuchikomi-box.ctp #2	5.54
» » Rendering APP/View/Elements/kuchikomi-box.ctp #3	4.66
» » Rendering APP/View/Elements/kuchikomi-box.ctp #4	5.23
» » Rendering APP/View/Elements/kuchikomi-box.ctp #5	4.51
» » Rendering APP/View/Elements/kuchikomi-box.ctp #6	0.63
» » Rendering APP/View/Elements/kuchikomi-box.ctp #7	0.46
» » Rendering APP/View/Elements/kuchikomi-box.ctp #8	3.67
» » » Rendering APP/View/Elements/adsense/336_288.ctp #2	0.08
» » Rendering APP/View/Elements/paginator.ctp	0.15
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	12.17
» » Rendering APP/View/Elements/header.ctp	0.42
» » Rendering APP/View/Elements/menu.ctp	8.59
» » » Rendering APP/View/Elements/kuchikomi_list/right-menu.ctp	8.38
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.08
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	7.35
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.11
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.11
» » Rendering APP/View/Elements/rtt.ctp	0.17
» » Rendering APP/View/Elements/footer.ctp	1.45
» » 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)
  controllerkuchikomi_list
  actionindex
  1(array)
  name北海道
  link
- metaKeywordString北海道,ダンススクール,ダンス教室,口コミ,検索,クチコミ,評判
- headString北海道のダンススクール・ダンス教室の口コミ・評判・体験談
- metaDescription北海道のダンススクール・ダンス教室の口コミ・体験談を掲載。気になる教室の情報を地域やジャンルから検索できます。
- title_for_layout北海道のダンススクール・ダンス教室の口コミ・評判・体験談｜ダンススクール・ダンス教室の口コミ検索ネット
- KuchikomiSet(object)
  0(object)
  id1198
  member_id2844
  school_id3015249
  title子供たちが真剣に取り組む環境を提供していました
  body子供の趣味になればと思い、無料の体験スクールに通わせました。本格的に通うのは体験が終わった後に子供が楽しめたかどうか判断してからのほうがよいと思います。それはなぜかと言うと、実際に通うことになればそれなりの費用が掛かるからです。庶民には大きな負担になりますので楽しめないのに無理に通わせて途中で辞められたら意味がないと思います。ですが、ここのスクールは子供が打ち込めるような工夫がされていてよい印象を持ちました。今後、息子と相談して入学するか決めたいと思います。
  score4
  reviewer_nickname
  enrollment_year2015
  level_at_enrollment1
  attending_period1
  ip_address14.9.148.160
  hostnameM014009148160.v4.enabler.ne.jp
  posted_at2015-08-04 22:46:44
  valid1
  timestamp_created2015-08-05 07:46:44
  timestamp_modified2015-08-05 07:46:44
  1(object)
  id1195
  member_id2844
  school_id3014940
  title見ても踊っても楽しめます
  body娘が習いたいというので通うことになりました。駅近くで利便性がよいので親子で楽しく通うことができたと思います。娘とのコミュニケーションもダンススコールに通うことで以前よりも増えたと思います。帰り際に近くにあるレストランに寄ってその日の反省会をすることが日課になっていました。先生たちとも気軽に仲良くなれるので友達などを誘っていくと楽しみも増えると思いますのでお勧めかと思います。費用はかさみましたがよい体験ができたので満足しています。
  score3
  reviewer_nickname
  enrollment_year2014
  level_at_enrollment1
  attending_period3
  ip_address14.9.148.160
  hostnameM014009148160.v4.enabler.ne.jp
  posted_at2015-06-09 23:50:21
  valid1
  timestamp_created2015-06-10 08:50:21
  timestamp_modified2015-06-10 08:50:21
  2(object)
  id1194
  member_id2844
  school_id3015502
  title流行りのダンスを学べます
  body前からあこがれていたヒッピホップ系のダンスを習うことができて満足しています。体験入学のみでしたが少しは上達d来たと思います。ほかの生徒さんと交流が持てたことがよかったと思います。ダンスに関する情報など共有できたことが憂いかったです。
  score4
  reviewer_nickname
  enrollment_year2014
  level_at_enrollment1
  attending_period1
  ip_address114.180.242.184
  hostnamei114-180-242-184.s04.a001.ap.plala.or.jp
  posted_at2015-06-09 09:06:21
  valid1
  timestamp_created2015-06-09 18:06:21
  timestamp_modified2015-06-09 18:06:21
  3(object)
  id1193
  member_id2844
  school_id3014934
  title円山エリアのお洒落な社屋ダンス教室
  body社交ダンスにあこがれていたので昔習っていました。近場に教室があることを知ったために再度習うことになりました。この教室で素敵な講師の方に巡り合えたのと様々な人たちと交流が持てたことが収穫になっています。時間を持て余している方などいたら是非お勧めします。
  score4
  reviewer_nickname
  enrollment_year2014
  level_at_enrollment2
  attending_period3
  ip_address114.180.242.184
  hostnamei114-180-242-184.s04.a001.ap.plala.or.jp
  posted_at2015-06-08 19:18:03
  valid1
  timestamp_created2015-06-09 04:18:03
  timestamp_modified2015-06-09 04:18:03
  4(object)
  id1179
  member_id2631
  school_id3014347
  title趣味を充実させたい方におすすめ
  body札幌市の東区にあるおすすめなダンス教室です。まず、立地条件が最高によくて地下鉄駅から徒歩で２分程度で行けるのが魅力です。講師の方々も気さくなかたばかりでアットホームな雰囲気で社交ダンスの腕前もみるみる上達しました。友人も誘い数人で通っていました。料金も比較的リーズナブルで趣味に費やすにはちょうど良い金額だと思います。このようなダンス教室ならほかの方にもぜひ知ってもらいたいし通ってい頂きたいと思い口コミを投稿しました。興味を持っていただけたら嬉しい限りです。
  score5
  reviewer_nickname
  enrollment_year2014
  level_at_enrollment2
  attending_period3
  ip_address121.115.48.133
  hostnamei121-115-48-133.s04.a001.ap.plala.or.jp
  posted_at2014-12-20 02:09:09
  valid1
  timestamp_created2014-12-20 11:09:09
  timestamp_modified2014-12-20 11:09:09
  5(object)
  id1178
  member_id2631
  school_id3015502
  title北のすすきのの社交場
  body札幌市の北24条といえば札幌市内でも有数な繁華街です。その繁華街の中にここのダンススクールがあり広いスタ次をで気持ち良いダンスを練習できるのが魅力だと思います。たくさんの生徒がいて他の年代の方との交流もできる楽しみがあります。ここに通うようになり日々の生活が充実するようになりました。期間は短かったですが自分自身のスキルアップのために良い体験ができたとおもいます。
  score4
  reviewer_nickname
  enrollment_year2013
  level_at_enrollment1
  attending_period2
  ip_address121.115.48.133
  hostnamei121-115-48-133.s04.a001.ap.plala.or.jp
  posted_at2014-12-18 08:31:48
  valid1
  timestamp_created2014-12-18 17:31:48
  timestamp_modified2014-12-18 17:31:48
  6(object)
  id175
  member_id(null)
  school_id3014347
  titleとても親切な教室です！！
  body【生まれ変わった私。】友達に薦められ、この教室に通うようになってから毎日が楽しく、私自身、明るくなりました。最初は分からない事だらけで不安もありましたが、ダンスを通して友達も増えて良い先生に出会いました！姿勢も良くなり、実際の年齢よりも若く見られるようになりました!! これからも、続けて行こうと思います！
  score5
  reviewer_nicknameトマト
  enrollment_year2005
  level_at_enrollment1
  attending_period5
  ip_address163.139.83.177
  hostnameed177.BFL8.vectant.ne.jp
  posted_at2010-10-16 13:38:57
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  7(object)
  id162
  member_id(null)
  school_id3013998
  titleプロの先生指導の下、丁寧に初心者から上級者までスキルに合わせて学べる教室です。
  body【教室の良いところ、お勧めな所。】この教室の良い所は、何といっても講師陣やスタッフさんがフレンドリーで、レッスンの内容がしっかりと体系付けられている所です。ただダンスをするだけではなくて目標をしっかり定めてから、どういう順序で体を使っていくかや今の自分の苦手な部分をしっかり説明して貰えるので、効果も実感出来てやる気が出ます。レッスンが終わった後でも、一人一人にどうやったらうまく出来るか時間を作って熱心に指導いただける機会が多いので、上達のスピードが早いです。現在は、北大通り店はビル取り壊しになってしまいありませんが、仮スタジオが新富士町駅すぐそばにあります！2010年今年の夏いよいよ本スタジオがOPENするみたいですよ、今からとても楽しみです。
  score4
  reviewer_nicknameさっと
  enrollment_year2007
  level_at_enrollment1
  attending_period3
  ip_address220.159.31.100
  hostnameu531100.xgsfm1.imtp.yokohama.mopera.net
  posted_at2010-02-26 20:07:12
  valid1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- KuchikomiPager(object)
  0(object) - recursion
  1(object) - recursion
  2(object) - recursion
  3(object) - recursion
  4(object) - recursion
  5(object) - recursion
  6(object) - recursion
  7(object) - recursion
- SearchTransitableToMajorCityPage(object)
- MajorCitySet(array)
  0(object)
  id9
  name札幌
  prefecture_id1
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToCityPage(object)
- CitySet(array)
  0(object)
  id85
  prefecture_id1
  name釧路市
  old_id36
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  1(object)
  id88
  prefecture_id1
  name札幌市北区
  old_id39
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  2(object)
  id91
  prefecture_id1
  name札幌市中央区
  old_id42
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  3(object)
  id94
  prefecture_id1
  name札幌市西区
  old_id45
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
  4(object)
  id95
  prefecture_id1
  name札幌市東区
  old_id46
  timestamp_created0000-00-00 00:00:00
  timestamp_modified0000-00-00 00:00:00
- SearchTransitableToCategoryPage(object)
- CategorySet(array)
  0(object)
  id3
  nameヒップホップ
  slughiphop
  description元々はヒップホップ＝70年代にアメリカで生まれたブラックカルチャー全般の事で、ラップやDJといった文化の事をさします。そのため、ヒップホップをダンスの種類としてではなく文化の総称として考えると、ストリートダンスは全てヒップホップとえます。ダンスの種類としてのヒップホップは、ブレイクダンスとソウルダンスを融合したもので、比較的新しいスタイルのものです。動きとしてはアップ、ダウンのリズムの取り方を基本としていて、ランニングマンやクラブステップといったような大き目の動きをする動作が多いダンスです。
  1(object)
  id4
  nameストリートダンス
  slugstreet
  descriptionストリート（路上）で踊られる事から発生したダンスで、比較的最近登場したジャンルのダンスです。元々はギャングの抗争を銃撃戦の代わりにブレイクダンスによって行われたものが始まりとされていて、ヒップホップ文化から出てきたダンス全般をストリートダンスと言います。現在ではジャズダンスなど様々なダンスがストリートダンスとして取り入れられ、ストリートダンス＝現代的なダンスという形の認識が強くなってきています。
  2(object)
  id5
  nameタップダンス
  slugtap
  descriptionつま先やかかとを床に打ち付ける事で音を出し、ステップによってリズムを作るダンスの事をタップダンスと言います。ブロードウェイミュージカルに見られるような上半身での振り付けもしっかりとしているものをミュージカルタップといい、ステップによるリズムを重視したものをリズムタップといいます。
  3(object)
  id6
  nameサルサ
  slugsalsa
  descriptionサルサとはキューバ発祥のラテン音楽の一つで、サルサミュージックに合わせて踊るダンスの事をサルサダンスといいます。サルサダンスは男女がペアになって男性リードで踊るペアダンスで、ペアダンスの中でも踊るスピードが速いのが特徴です。キューバンスタイルやNYスタイル、LAスタイルなど、ダンスや音楽の特徴でいくつかの種類に分かれます。
  4(object)
  id10
  name社交ダンス
  slugsocial
  description儀式や舞台(ショー)向けのダンスではなく、男女のペアで楽曲に合わせて踊るペアダンスの事を社交ダンスと言います。社交ダンスは大きく分けるとワルツやタンゴに代表されるようなスタンダードと呼ばれるものと、サンバやルンバ、パソドブレといったラテンダンスに分類されます。社交ダンスという名称は元々sociality dancingの誤訳からできた言葉で、日本国内でのみSocial Danceという言葉が利用されています。英語では一般的にBallroom Dance(ボールルームダンス＝舞踏室の踊り)とあらわされ、競技ダンスなども社交ダンスと言われます。
  5(object)
  id11
  nameタンゴ
  slugtango
  descriptionアルゼンチンのブエノスアイレスやウルグアイのモンテビデオ発祥のダンス。元々のタンゴをアルゼンチン・タンゴと言い、これがヨーロッパに渡って変化したものをコンチネンタル・タンゴと言います。現在では社交ダンスの一つとしても人気が高いダンスで、全体的に短いスタッカートを多用する音楽に合わせた上下動の少ない力強いダンスが特徴的です。
  6(object)
  id12
  name民族舞踊・フォークダンス
  slugfolk
  description民族間で伝承されてきたダンス全般の事を指して、民族舞踏といいます。日本においては日本舞踏のほか、盆踊りやよさこいなどの伝統的なものも全て民族舞踏の一つで、ハワイにおけるフラや中東におけるベリーダンスも民族舞踏です。民族舞踏はそれぞれの地域における地理的な環境や言語的な特徴など、様々な要因によって作られてきており、民族舞踏を学習する事でその国の文化などに触れ、理解をする事が出来ます。
  7(object)
  id13
  nameキッズダンス教室
  slugkids
  descriptionダンスは言葉を用いないで自己表現をするための一つの手段であり、ダンスを学ぶ事で表現力を養う事や自信を持つことが出来る等点から、キッズダンスを習得させる家庭は増加傾向にあります。また、小中学校におけるダンスの教育義務化などもあり、習い事の一つとしてダンス教室はとても重要なものとなってきています。最近ではキッズダンサー向けのダンス大会なども頻繁に開催されていて、ただ習うだけではなく活躍する機会も今後さらに増えていくのではないでしょうか。
  8(object)
  id14
  nameその他のダンス
  slugother
  description
- TransitionalLinkShowDescidableKuchikomiList(object)
- SearchStateExplainableKuchikomiList(object)
- SearchConditionKuchikomiList(object)
- InputItemKuchikomiSearch(object)
  useTable(false)
  useDbConfigdefault
  displayField(null)
  id(false)
  data(empty)
  schemaName(null)
  tablesgv__front__input_form__kuchikomi_searches
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  validationDomain(null)
  plugin(null)
  nameSgv_Front_InputForm_KuchikomiSearch
  aliasSgv_Front_InputForm_KuchikomiSearch
  tableToModel(empty)
  cacheQueries(false)
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  actsAs(null)
  Behaviors(object)
  modelNameSgv_Front_InputForm_KuchikomiSearch
  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)
- MemberIconManageable(object)
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(array)
  Sgv_Front_InputForm_KuchikomiSearch(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.216.32.116'
	)
)
$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.216.32.116

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	/kuchikomi/pref_1?page=2
Query String	page=2
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Query String	page=2
Redirect Url	/kuchikomi/pref_1
Remote Port	37362
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.216.32.116
Server Port	443
Server Addr	183.90.231.12
Server Name	www.dance-schoolgv.net
Server Software	Apache
Server Signature
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	18.216.32.116
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.216.32.116
Http Host	www.dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	Zii0TPQtxIpFcs1R11n-2wAAAhg
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	Zii0TPQtxIpFcs1R11n-2wAAAhg
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713943628.3482
Request Time	1713943628

====

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/KuchikomiListController.php
  1APP/Controller/AppController.php
  Other(array)
  0APP/webroot/index.php
  1APP/class/Sgv/Front/InputForm/KuchikomiSearch.php
  2APP/class/Sgv/Front/InputItem/KuchikomiSearch.php
  3APP/class/Sgv/Front/SearchUrlParameter/KuchikomiList.php
  4APP/class/Sgv/Front/SearchCondition/KuchikomiList.php
  5APP/class/Sgv/Front/SearchState/KuchikomiList.php
  6APP/class/Sgv/Front/SearchStateExplainable/KuchikomiList.php
  7APP/class/Sgv/Front/TransitionalLinkShower/KuchikomiList.php
  8APP/class/Sgv/Front/TransitionalLinkShowDescidable/KuchikomiList.php
  9APP/class/Sgv/Front/KuchikomiListPageLink/ToCategoryPage.php
  10APP/class/Sgv/Front/SearchTransitable/ToCategoryPage.php
  11APP/class/Sgv/Front/KuchikomiListPageLink/ToCityPage.php
  12APP/class/Sgv/Front/SearchTransitable/ToCityPage.php
  13APP/class/Sgv/Front/KuchikomiListPageLink/ToMajorCityPage.php
  14APP/class/Sgv/Front/SearchTransitable/ToMajorCityPage.php
  15APP/class/Sgv/Front/KuchikomiCategoryAttachment/ToKuchikomiSet.php
  16APP/class/Sgv/Front/AttachableToDataSet/KuchikomiCategory.php
  17APP/class/Sgv/Front/MemberAttachment/ToKuchikomiSet.php
  18APP/class/Sgv/Front/AttachableToDataSet/Member.php
  19APP/class/Sgv/Front/SchoolAttachment/ToKuchikomiSet.php
  20APP/class/Sgv/Front/AttachableToDataSet/School.php
  21APP/class/Sgv/Front/AccessCountKuchikomiAttachment/ToKuchikomiSet.php
  22APP/class/Sgv/Front/AttachableToDataSet/AccessCountKuchikomi.php
  23APP/class/Sgv/Front/KuchikomiQuestionnaireAnswerAttachment/ToKuchikomiSet.php
  24APP/class/Sgv/Front/AttachableToDataSet/KuchikomiQuestionnaireAnswer.php
  25APP/class/Sgv/Front/SchoolListPageLink/ToMajorCityPage.php
  26APP/class/Sgv/Front/SearchState/SchoolList.php
  27APP/class/Sgv/Front/SearchStateExplainable/SchoolList.php
  28APP/class/Sgv/Front/SearchUrlParameter/SchoolList.php
  29APP/class/Sgv/Front/SearchCondition/SchoolList.php
  30APP/class/Sgv/Front/SchoolListPageLink/ToStationPage.php
  31APP/class/Sgv/Front/SearchTransitable/ToStationPage.php
  32APP/class/Sgv/Front/SchoolListPageLink/ToCategoryPage.php
  33APP/class/Sgv/Front/TransitionalLinkShower/SchoolList.php
  34APP/class/Sgv/Front/TransitionalLinkShowDescidable/SchoolList.php
  35APP/class/Sgv/Front/InputForm/SchoolSearch.php
  36APP/class/Sgv/Front/InputItem/SchoolSearch.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
====

北海道のダンススクール・ダンス教室の口コミ・評判・体験談

Voice Search 口コミ検索

»Filtering Search ダンス口コミの絞り込み検索

»Popular Area 北海道の主要なエリア

»Area Search 市区町村で絞る

»Category Search カテゴリーで口コミを検索

Voice List 北海道の口コミ一覧
11〜18件を表示／18件

子供たちが真剣に取り組む環境を提供していました (view: 788 投稿日: 2015/08/04)

SPORTS CLUB NAS 札幌店

見ても踊っても楽しめます (view: 1103 投稿日: 2015/06/09)

MIST DANCE ACADEMY CREAM

流行りのダンスを学べます (view: 831 投稿日: 2015/06/09)

Studio Dice1

円山エリアのお洒落な社屋ダンス教室 (view: 1051 投稿日: 2015/06/08)

アリス・ダンス・スタジオ

趣味を充実させたい方におすすめ (view: 998 投稿日: 2014/12/20)

広川ダンススクール栄町教室

北のすすきのの社交場 (view: 920 投稿日: 2014/12/18)

Studio Dice1

とても親切な教室です！！ (view: 1313 投稿日: 2010/10/16)

広川ダンススクール栄町教室

プロの先生指導の下、丁寧に初心者から上級者までスキルに合わせて学べる教室です。 (view: 1434 投稿日: 2010/02/26)

@787(釧路NAVANA DANCE STUDIO)

この地域・カテゴリのダンススクールを探す

Special Column

Memory

Timers

北海道のダンススクール・ダンス教室の口コミ・評判・体験談

Voice Search 口コミ検索

»Filtering Search ダンス口コミの絞り込み検索

»Popular Area 北海道の主要なエリア

»Area Search 市区町村で絞る

»Category Search カテゴリーで口コミを検索

Voice List 北海道の口コミ一覧 11〜18件を表示／18件

子供たちが真剣に取り組む環境を提供していました (view: 788 投稿日: 2015/08/04)

見ても踊っても楽しめます (view: 1103 投稿日: 2015/06/09)

流行りのダンスを学べます (view: 831 投稿日: 2015/06/09)

円山エリアのお洒落な社屋ダンス教室 (view: 1051 投稿日: 2015/06/08)

趣味を充実させたい方におすすめ (view: 998 投稿日: 2014/12/20)

北のすすきのの社交場 (view: 920 投稿日: 2014/12/18)

とても親切な教室です！！ (view: 1313 投稿日: 2010/10/16)

プロの先生指導の下、丁寧に初心者から上級者までスキルに合わせて学べる教室です。 (view: 1434 投稿日: 2010/02/26)

この地域・カテゴリのダンススクールを探す

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

Voice List 北海道の口コミ一覧
11〜18件を表示／18件