ダンス２Ｆ１(ダンスツーフォーワン)のコース・レッスン料金｜ダンススクール・ダンス教室の口コミ検索ネット

団体レッスンおすすめ初級一時間1500円中級一時間1500円	1,500円
個人レッスン 30分3000円 60分6000円	3,000円

団体レッスンおすすめ初級一時間1500円中級一時間1500円	1,500円
個人レッスン 30分3000円 60分6000円	3,000円

グループレッスン 1時間　2000円(1人)	2,000円
個人レッスン 1時間　5000円(1人又はカップル)	5,000円

住所	〒599-8114 大阪府堺市東区日置壮西町5丁19-20
スクール	ダンス２Ｆ１(ダンスツーフォーワン)
ブログ	http://profiles.yahoo.co.jp/-/my_profile/?prv=10&sp=CMIo6ZAieqo8iwFm.g3MebGD&.src=blog
TEL	08053347944

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  keye3beb2592d3c394e215b811b8e95e8b672629421
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  004174b3b83375259c9f4ca3cc4374f6ef7113a41780966397
  133e598c028fc514c6c684295d650d04692fa06d1780966398
  4c96ada459969734123c9413bfbcabfcda4106d01780966398
  1542e087176242ba6d4353e7a806fc050a83a6511780966398
  a921c9ceacab2c18185f1d7d9c7432695f98e9c81780966398
  db6008f24cc4c51399fb8188ec4da4d703c73c1b1780966399
  3e935a8a5e824f5f3314c6f7bd41476f6076b2981780966399
  ee42e6e1d9faea77aa650204677e97f9e9f7c2a71780966399
  ba4be3a88ed1ea2ff21760bd09d9a1d64ffaf9c31780966399
  fd07d5a2cdd3b701710e7ee6ded4c18dc9c92b3a1780966399
  625a964e33eebca9ac3bf17a952260cf80c400691780966400
  c97c0f76ba3891caf83ed0485aa27aa606481e5e1780966400
  eae9bd3b22865fa14343c40eeca5cdef1b5a3d951780966400
  840258b7e0ff2c5e5261ebef99f4fae310a88bb61780966401
  589f07b93f0b0e7931bae7f709e07d14cbc8e9e71780966401
  dec93deba4df605d3d8fdf51d6959e081e3cd5951780966401
  30649e08f5ce36adb0fef773a0e64613ed51d1781780966401
  93a05699f46f18a126ad75d17b3ea4e75703a9231780966402
  1285c0bf3f2176666387a93ea56ea21c46e68c071780966402
  753a4aa998da9cb4cb5a749b1dc1ca41c0a97c201780966402
  bbc3269bef730ef69861cde92220411e0e813ad21780966403
  381ce3ba25f07d1bf059e8b30db6b2fdf018fd261780966403
  46d37dd810f64b491ef0738a76485dd7c0f140681780966403
  0ece837b763d56f02d1bd9da7fcd31b0a42a7c9f1780966403
  e7c9a5fd6a7b2bf18adcf8eceed5c4dd5f780b8e1780966403
  940c69b916cdb95a256d3a65e132ea22a60f80be1780966404
  adb4d361b859d1e736df65c915f1c3ef8c32ab521780966404
  c90071978c3a511205b1f807b77ce9ca2be177f01780966404
  6ac4e6401b885265d311463fed4c62d7ec2894241780966404
  e691b98aa76a7a95f3fe659ab73cf88d765924d51780966404
  594f55b1f24eec1b55f65b3e6dac37b510d7d1441780966405
  5b792ca06fc3ce7be362c59deb4ef02d05088d651780966405
  cd3b02a69e1b4a2fb1e72441847a6423987b42f01780966405
  8c61959575a5766e4823d1ebf592a1668d59dc041780966406
  b5d81ad72e865da348fd483cd670ced27f5365fc1780966406
  82faa3eb4c57f25a4119d42286f2f264e1c184fd1780966406
  b643053ec3bf66355c70518f9885a6de30a2e9681780966406
  9aee73ec5b9bdf485b105371dabe57290f08b7471780966406
  744e3c75ee3f1e30fe6e311d8367517b5cd9e9771780966407
  0348e06e7e5b921b7b50d6ecdd7eedffd474f0841780966407
  1e82ac38276391270285e9ff67758a28009eb1251780966407
  d7790bc36f42d5790040c250aae73a6e34d9fd791780966408
  e0467fdc30c1b5dfaf5d7d77f234cca70ecd1c481780966408
  b7d9f1c766da760731d67fe4486b8a855f3c1d971780966408
  de38be85fdcd08e2643e258bcb6166d07aac27ad1780966408
  62ff8ac9c9b6e416b1233ab503edc75d0bd4ff171780966408
  73197c2c044f8dc048a88d62c14b21778aee14ca1780966409
  e176ae7ab56adefcdfecd78baee14709ad3c05c01780966409
  355c49023611472e611da5025eaf62211861b6911780966409
  5a2a8155a263831f748e9e440c19cb916862cdc41780966409
  fc2c93b0865e1782680df1ca534009b93bac10531780966410
  4c73411cc23f73ba80efa13876f46bdbb92423a91780966410
  f222b1fbc3bb9442162629d64485745887d20cff1780966410
  c0f8d5fe1d7004534396eb5884f0f82d655258921780966410
  ef83c281a0d432e75555da0746df3f2ab012fa7f1780966410
  6675e1d5793c0f166de753c7d05c55ffeba0299c1780966411
  feddcb7376e5439922341a5071d44a0aeeb8157d1780966411
  a9e4bb1bcec4e5311e34e65be4d3ebcebccd34f01780966411
  23daca7997383e4b233e80e65c4c11b67bba91af1780966411
  b7aa4d87d283d6d8973300e81892b1389e0d47b11780966411
  728e6be9e0880db56ee71ab99bb73d13b130c65a1780966412
  49aaf5f2fa11c838856e3b28e2f8b9735710f0e71780966412
  8b1b3e73eb1a12c8da8e0cb961a2f4e67544c4b11780966412
  8c4c71dd0053f418d033dc831da4b60aa066e1d01780966412
  6278389e7bcd730c94b4802377b57ca0accd50951780966412
  51ffd785895b2a0a0bb5b8236b5449e91880501f1780966413
  f3e9767387c7e46261652e307b4ac445e78dbdbb1780966413
  b7c2ced496d1298d49a02bb1eec33c9a206d50f51780966413
  a133509d0ad0b0b5147e20952e458cd844bdc0bd1780966413
  82f84bbadd094566e11ea245925b5a95cbc9c3ba1780966413
  a5257b53ad277931a9e0d474455638321690cfc71780966413
  19dc8368ad361336939420948053f2d249d53c651780966414
  dd2f4e7c52f5c9d28831a744d1840052f8005a6f1780966414
  e47aa4b69a52acd12d767dd97eb0392a8eb491f01780966414
  a7b6edebb963d494f9cbdd891945ed3a41759b231780966414
  02922eca99807746041a5b266b917f90b52811031780966414
  70279b786254026ad16e2c8b903dcb54e6b257301780966415
  6f65cb3a5ffd48312ee4ca55bf649a7403102eb51780966415
  7dcae68ff57bebc47af42ab9af3a64fae87f4fe51780966415
  2df625455c65f72292fff422105461b0925297a31780966415
  cb16c89c4390945b4b67db1b0db8ce265161c4351780966415
  d7f738c44c88f6ff453b30eba0234d74647fa8c71780966416
  eff4354b417cd259e77d4305b673dbfbd61bf2e81780966416
  bd39992e1d3b52e168fd3fe7b6b407546cc360351780966416
  d89bd033d412fad15cb087511d15ffe1a25db7781780966416
  5cc87d38b00bb63775b657f8ecab40e5acd589391780966416
  897d3912c134a288387189e70af4329e008868db1780966417
  2a9db097db0140fcbd1e99821d28cb27eac916851780966417
  a42824c5039f9a7822c92829e44454703823d7551780966417
  9f58af92655b065fcd8a0d840c45228dfe8f97cc1780966417
  0b1007267fb71fda8f739a6bc108937a8b3ab96b1780966418
  6c252b93c550899bdbd4c50bb42985b5767795701780966418
  c3a16ac9d2775ea8e91fdcf7bc3c1710e8774a5a1780966418
  85fb2b71a6fd948554fe39d71310c6598c3ba3311780966419
  e3beb2592d3c394e215b811b8e95e8b6726294211780966419
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschool
- actionservice
- named(empty)
- pass(empty)
- schoolId3015551
- _Token(array)
  keye3beb2592d3c394e215b811b8e95e8b672629421
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0schoolId
- options(array)
  schoolId[0-9]+
- defaults(array)
  controllerschool
  actionservice
  plugin(null)
- template/detail/L_:schoolId/service
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 61 queries / 0.517257 sec

No.

time

query

0.001807

connect

0.000867

DESCRIBE `school`

0.000507

SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3015551') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1

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

0.000617

DESCRIBE `school_score`

0.000417

SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3015551') 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.000547

DESCRIBE `access_log_school`

0.003907

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '216.73.216.32') AND (school_id = '3015551') AND (timestamp_created >= '2026-06-08 09:23:39') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_school	index_merge	school_id,ix_ip_address_access_log_school	ix_ip_address_access_log_school,school_id	767,4		1	Using intersect(ix_ip_address_access_log_school,school_id); Using where

0.000537

DESCRIBE `access_count_school`

0.000407

SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3015551') LIMIT 1

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

0.464557

UPDATE `access_count_school` SET `count` = ?, `timestamp_modified` = ? WHERE (`access_count_school`.`id` = 2087)

0.000467

SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 2087) LIMIT 1

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

0.000597

INSERT INTO `access_log_school` (`school_id`, `ip_address`, `timestamp_created`, `timestamp_modified`) VALUES (?, ?, ?, ?)

0.006107

SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 15695800) LIMIT 1

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

0.000667

DESCRIBE `school_station`

0.000447

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015551') LIMIT 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	2

0.000417

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id = '6107')

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

0.000487

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3015551')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

0.000687

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '1477') AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

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

0.000607

DESCRIBE `city`

0.000367

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

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

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

0.006047

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('1277', '1441', '1442', '1443', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1458', '1459', '1460', '1461', '1462', '1463', '1464', '1465', '1466', '1467', '1468', '1469', '1470', '1471', '1472', '1473', '1474', '1475', '1476', '1477', '1478', '1479', '1480', '1481', '1484', '1485', '1486', '1487', '1488', '1489', '1490', '1492', '1493', '1494', '1495', '1496', '1497', '1498', '1499', '1501', '1504', '1505', '1506')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)

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

0.000587

DESCRIBE `prefecture`

0.000377

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

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

0.000567

DESCRIBE `station`

0.000277

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6108') LIMIT 1

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

0.000517

DESCRIBE `station_unit`

0.002427

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

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

DESCRIBE `station_station_unit`

0.000377

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

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

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

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

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

DESCRIBE `major_city`

0.000717

DESCRIBE `city_major_city`

0.000377

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

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

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

DESCRIBE `summary_count_school`

0.000487

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

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

0.000657

DESCRIBE `category_school`

0.000397

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015551') AND (c_s.valid = 1)

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

0.000677

DESCRIBE `menu_school`

0.000457

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '4993') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	2	Using index condition; Using where; Using filesort

0.000407

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '4994') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	2	Using index condition; Using where; Using filesort

0.000517

SELECT `m_s`.* FROM `menu_school` AS `m_s` WHERE (m_s.category_school_id = '4995') AND (m_s.valid = 1) ORDER BY `is_recommended` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_s	ref	ix_category_school_id_menu_school	ix_category_school_id_menu_school	4	const	2	Using index condition; Using where; Using filesort

0.000517

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015551') AND (c_s.valid = 1) LIMIT 5

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

0.005027

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015551') AND (c_s.valid = 1) LIMIT 5

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

0.000597

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015551') AND (c_s.valid = 1) LIMIT 5

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

0.000507

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3015551') AND (c_s.valid = 1) LIMIT 6

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

0.001357

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3015551') ORDER BY `time` ASC, `distance` ASC LIMIT 3

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	school_id	school_id	4	const	2	Using index condition; Using filesort

0.000417

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6108') LIMIT 1

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

0.000347

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6107') LIMIT 1

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

0.000567

DESCRIBE `dancer`

0.000447

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

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

DESCRIBE `dancer_column`

0.000407

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

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

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

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

0.000367

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

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

0.000487

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

Message	Memory use
Component initialization	2.16 MB
Controller action start	4.03 MB
Controller render start	4.18 MB
View render complete	5.21 MB

Timers

Total Request Time: 2734 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	2111.13
Event: Controller.initialize	519.47
Event: Controller.startup	0.40
Controller action	0.12
Event: Controller.beforeRender	21.06
» Processing toolbar data	13.04
Rendering View	45.22
» Event: View.beforeRender	1.27
» Rendering APP/View/School/service.ctp	7.85
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.08
» » Rendering APP/View/Elements/school/menu-school.ctp	0.37
» » Rendering APP/View/Elements/school/menu-school.ctp #2	0.34
» » Rendering APP/View/Elements/adsense/336_288.ctp #2	0.06
» » Rendering APP/View/Elements/school/access.ctp	0.27
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/default.ctp	34.70
» » Rendering APP/View/Elements/header.ctp	0.38
» » Rendering APP/View/Elements/school/detailHeader.ctp	18.11
» » » Rendering APP/View/Elements/common/bookmark_school.ctp	0.11
» » » Rendering APP/View/Elements/breadcrumb.ctp	0.22
» » Rendering APP/View/Elements/menu.ctp	12.96
» » » Rendering APP/View/Elements/school/right-menu.ctp	12.77
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.09
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.06
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	11.83
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp	0.09
» » » » Rendering APP/View/Elements/adsense/300_250.ctp	0.07
» » Rendering APP/View/Elements/rtt.ctp	0.11
» » Rendering APP/View/Elements/footer.ctp	0.90
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.07
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
  prefectureId27
  2(array)
  name堺市
  link(array)
  controllerschool_list
  actionindex
  prefectureId27
  cityId1477
  3(array)
  name萩原天神駅
  link(array)
  controllerschool_list
  actionindex
  stationId6108
  4(array)
  nameダンス２Ｆ１(ダンスツーフォーワン)
  link
- ChargedNeighborSchoolSet(empty)
- SchoolScoreSet(object)
- School(object)
  id3015551
  nameダンス２Ｆ１(ダンスツーフォーワン)
  branch_name
  city_id1477
  schoolgroup_id(null)
  mail_addressdance2f1@yahoo.co.jp
  lat34.538811
  lon135.5320161
  telephone_number08053347944
  homepage_url
  mobile_homepage_url
  blog_urlhttp://profiles.yahoo.co.jp/-/my_profile/?prv=10&sp=CMIo6ZAieqo8iwFm.g3MebGD&.src=blog
  open_hour10時～22時
  holiday不定休
  post_code599-8114
  town_address東区日置壮西町5丁19-20
  building
  image_hash4e62f88cbb941170
  image_extension_type2
  message_image_hash8aa17e1e3a7efb44
  message_image_extension_type2
  is_registered_by_not_owner0
  is_opening1
  message_titleアルゼンチンタンゴ・サルサ・社交ダンス
  message_bodyスタジオではグループレッスン・個人レッス *出張ダンスパートーナーも行っています。年中無休ＡＭ１０時～ＰＭ１０時完全予約制ご予約、お問合せは携帯０８０５３３４７９４４　タンサー祥(しょう) ダンス２Ｆ１(ダンスツーフォーワン)　　　　　　　　　　　堺市東区日置荘西町５丁１９－２０南海高野線初芝駅・萩原天神駅の中間徒歩約６分　　線路沿いの緑色の店舗
  is_detail_address_opening1
  is_charged0
  registration_status1
  whole_staff_titleタンサー祥(しょう)
  whole_staff_introductionタンサー祥(しょう)は、社交ダンスのアマチュアメダルテストに上級合格しているダンスのキャリアのある大ベテランシです。ダンステクニックのアドバイスもいたします。あなた様は、エレガンスなダンスを楽しみながら知らず知らずパーティーの花形になっているでしょう。
  whole_staff_image_hash
  whole_staff_image_extension_type0
  is_kuchikomi_notice_mail_receiving1
  banner_image_hash(null)
  banner_image_extension_type(null)
  school_type1
  has_kids_course0
  has_beginner_course1
  score0.00
  kuchikomi_count0
  timestamp_created2014-03-22 21:08:35
  timestamp_modified2026-05-23 15:12:51
  memo(null)
- adsenseCount0
- $request->data(empty)
- $this->validationErrors(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 => '216.73.216.32'
	)
)
$oddTrOptions = array(
	'class' => 'odd'
)
$evenTrOptions = array(
	'class' => 'even'
)
$useCount = false
$continueOddEven = false
$count = (int) 18
$line = array(
	(int) 0 => 'QWINTET_IP',
	(int) 1 => array(
		(int) 0 => '122.216.11.82'
	)
)
$cellsOut = array(
	(int) 0 => '<td>QWINTET_IP</td>'
)
$i = (int) 0
$cell = array(
	(int) 0 => '122.216.11.82'
)
$cellOptions = array()
$options = ' class="odd"'
$out = array(
	(int) 0 => '<tr class="odd"><td>SGV_ENV</td> <td>development</td></tr>',
	(int) 1 => '<tr class="even"><td>DEBUGKIT_ON</td> <td>1</td></tr>',
	(int) 2 => '<tr class="odd"><td>MENTE_FLAG</td> <td></td></tr>',
	(int) 3 => '<tr class="even"><td>SGV_APP_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/</td></tr>',
	(int) 4 => '<tr class="odd"><td>CONFIG_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Config/</td></tr>',
	(int) 5 => '<tr class="even"><td>LIB_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/</td></tr>',
	(int) 6 => '<tr class="odd"><td>MODEL_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/Model/</td></tr>',
	(int) 7 => '<tr class="even"><td>CLASS_DIR</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/class/</td></tr>',
	(int) 8 => '<tr class="odd"><td>THUMBLIB_BASE_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb</td></tr>',
	(int) 9 => '<tr class="even"><td>THUMBLIB_PLUGIN_PATH</td> <td>/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/</td></tr>',
	(int) 10 => '<tr class="odd"><td>DEFAULT_THUMBLIB_IMPLEMENTATION</td> <td>gd</td></tr>',
	(int) 11 => '<tr class="even"><td>USER_STATIC_SALT</td> <td>Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z</td></tr>',
	(int) 12 => '<tr class="odd"><td>SITE_TITLE</td> <td>ダンススクール・ダンス教室口コミ検索ネット</td></tr>',
	(int) 13 => '<tr class="even"><td>OPERATOR_MAIL_ADDRESS</td> <td>info@kuchi.info</td></tr>',
	(int) 14 => '<tr class="odd"><td>NO_REPLY_MAIL_ADDRESS</td> <td>no-reply@kuchi.info</td></tr>',
	(int) 15 => '<tr class="even"><td>RETURN_PATH__MAIL_ADDRESS</td> <td>errors@kuchi.info</td></tr>',
	(int) 16 => '<tr class="odd"><td>GOOGLE_API_KEY</td> <td>AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0</td></tr>'
)
HtmlHelper::tableCells() - CORE/Cake/View/Helper/HtmlHelper.php, line 867
HtmlToolbarHelper::table() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 160
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 125
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108
ToolbarHelper::table() - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
include - ROOT/plugins/DebugKit/View/Elements/environment_panel.ctp, line 31
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
include - ROOT/plugins/DebugKit/View/Elements/debug_toolbar.ctp, line 45
View::_evaluate() - CORE/Cake/View/View.php, line 948
View::_render() - CORE/Cake/View/View.php, line 910
View::_renderElement() - CORE/Cake/View/View.php, line 1211
View::element() - CORE/Cake/View/View.php, line 414
HtmlToolbarHelper::send() - ROOT/plugins/DebugKit/View/Helper/HtmlToolbarHelper.php, line 193
Object::dispatchMethod() - CORE/Cake/Core/Object.php, line 119
ToolbarHelper::__call() - ROOT/plugins/DebugKit/View/Helper/ToolbarHelper.php, line 108

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

CakePHP Constants

Constant	Value
APP	/home/jobikai/dance-schoolgv.net/cakephp/app/
APP_DIR	app
APPLIBS	/home/jobikai/dance-schoolgv.net/cakephp/app/Lib/
CACHE	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/cache/
CAKE	/home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib
CORE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/
CAKE_VERSION	2.3.1
CSS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dance-schoolgv.net
IMAGES	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/img/
IMAGES_URL	img/
JS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/js/
JS_URL	js/
LOGS	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/logs/
ROOT	/home/jobikai/dance-schoolgv.net/cakephp
TESTS	/home/jobikai/dance-schoolgv.net/cakephp/app/Test/
TMP	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/
VENDORS	/home/jobikai/dance-schoolgv.net/cakephp/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Pwd	/home/userfastcgi/jobikai/dance-schoolgv.net
Shlvl	0
Script Name	/index.php
Request Uri	/detail/L_3015551/service
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/detail/L_3015551/service
Remote Port	43620
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	216.73.216.32
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http Cookie	PHPSESSID=g4msqk6aavkl4op2sg0ncov4j8vb1k4a
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	216.73.216.32
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	216.73.216.32
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Mmdb Addr	216.73.216.32
Unique Id	aiddCZPQu8j6CkFm-TWUCQAAAc4
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 Mmdb Addr	216.73.216.32
Redirect Unique Id	aiddCZPQu8j6CkFm-TWUCQAAAc4
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1780964617.1897
Request Time	1780964617

====

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
  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
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  Controller(array)
  0APP/Controller/SchoolController.php
  1APP/Controller/AppController.php
  Other(array)
  0APP/webroot/index.php
  1APP/class/Sgv/Front/CityAttachment/ToSchoolSet.php
  2APP/class/Sgv/Front/AttachableToDataSet/City.php
  3APP/class/Sgv/Front/StationAttachment/ToSchoolSet.php
  4APP/class/Sgv/Front/AttachableToDataSet/Station.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
====

ダンス２Ｆ１(ダンスツーフォーワン)のコース・レッスン料金