ミュージカルスクールSTAGE21 大阪校のダンスインストラクター・講師紹介｜ダンススクール・ダンス教室の口コミ検索ネット

住所	〒5400037 大阪府大阪市中央区内平野町2-1-9 シグナスビル1F
スクール	ミュージカルスクールSTAGE21 大阪校
HP	http://www.stage21.tv
携帯HP	http://www.stage21.tv/m/index_m.html
ブログ	http://blog.livedoor.jp/stage21blog
TEL	06-6945-0707

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

Cake Params
- plugin(null)
- controllerschool
- actionstaff
- named(empty)
- pass(empty)
- schoolId3013297
- _Token(array)
  keybbdb2ab93abfaf42feb154cbf72c56e2ea81c83e
  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
  actionstaff
  plugin(null)
- template/detail/L_:schoolId/staff
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 66 queries / 0.050167 sec

No.

time

query

0.001897

connect

0.000717

DESCRIBE `school`

0.000497

SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3013297') 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.000597

DESCRIBE `school_score`

0.000367

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

DESCRIBE `access_log_school`

0.002767

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.139.107.241') AND (school_id = '3013297') AND (timestamp_created >= '2024-05-06 16:47:20') 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.000567

DESCRIBE `access_count_school`

0.000377

SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3013297') 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.004187

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

0.000357

SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 582) 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.005017

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

0.000387

SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 12142482) 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.007467

DESCRIBE `school_station`

0.000407

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

0.000447

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

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

0.000637

SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014182', '3014615', '3014615', '3015117', '3015118', '3013297', '3013297', '3013297', '3013297', '3013297', '3013297', '3013297', '3013297', '3013297', '3015116', '3014838', '3013241', '3013182', '3014970', '3015355', '3015128', '3015720', '3015882', '3015850', '3016058', '3014055', '3016100', '3016165', '3015539', '3015885')) 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	PRIMARY	PRIMARY	4		21	Using where

0.000717

SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '1456') 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	65	Using where

0.000497

DESCRIBE `city`

0.000387

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

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

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		660	Using index condition; Using where

0.000457

DESCRIBE `prefecture`

0.000307

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

SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3013297') 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	9	Using index condition; Using filesort

0.000437

DESCRIBE `station`

0.000317

SELECT `s`.* FROM `station` AS `s` WHERE (s.id = '6174') 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.000417

DESCRIBE `station_unit`

0.000367

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

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

0.000427

DESCRIBE `station_station_unit`

0.000327