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

Cake Params
- plugin(null)
- controllerschool
- actionservice
- named(empty)
- pass(empty)
- schoolId3013297
- _Token(array)
  key40a16c91405100fe98f515b779a3eb8dd40572aa
  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: 71 queries / 0.077357 sec

No.

time

query

0.001777

connect

0.000757

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

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

DESCRIBE `access_log_school`

0.001757

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.149.213.209') AND (school_id = '3013297') AND (timestamp_created >= '2024-05-07 08:05:09') 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.000857

DESCRIBE `access_count_school`

0.000357

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

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

0.000397

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

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

0.000327

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

DESCRIBE `school_station`

0.000347

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

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

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

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

DESCRIBE `city`

0.000317

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

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

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

DESCRIBE `station`

0.000297

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

DESCRIBE `station_unit`

0.000327

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

DESCRIBE `station_station_unit`

0.000287