ミュージカルスクール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)
  key7f467566c348d6af86f07b5a27d15c757ad8f546
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  7f467566c348d6af86f07b5a27d15c757ad8f5461714148544
====
Request
+
Request

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

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 78 queries / 0.047207 sec

No.

time

query

0.001737

connect

0.000717

DESCRIBE `school`

0.000437

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

DESCRIBE `school_score`

0.000347

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

DESCRIBE `access_log_school`

0.000407

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '18.216.83.240') AND (school_id = '3013297') AND (timestamp_created >= '2024-04-26 00:52:24') LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	access_log_school	ref	school_id,ix_ip_address_access_log_school	ix_ip_address_access_log_school	767	const	2	Using where

0.000467

DESCRIBE `access_count_school`

0.000387

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

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

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

0.000337

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

DESCRIBE `school_station`

0.000387

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

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

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

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

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

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

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

DESCRIBE `prefecture`

0.000327

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

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

DESCRIBE `station_unit`

0.000377

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

DESCRIBE `station_station_unit`

0.000307