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

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

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 68 queries / 0.076747 sec

No.

time

query

0.001687

connect

0.000767

DESCRIBE `school`

0.000427

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

DESCRIBE `access_log_school`

0.002207

SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.135.246.193') AND (school_id = '3013297') AND (timestamp_created >= '2024-05-06 16:54:36') 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.000757

DESCRIBE `access_count_school`

0.000337

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

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

0.000347

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

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` = 12142503) 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.000587

DESCRIBE `school_station`

0.000647

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

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

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

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

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

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

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

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

DESCRIBE `station`

0.000307

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

DESCRIBE `station_unit`

0.000337

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

DESCRIBE `station_station_unit`

0.000307