千葉で１番のDANCE STUDIO　BEAT　THE　MIXの地図・アクセス・最寄駅・特典｜ダンススクール・ダンス教室の口コミ検索ネット

千葉で１番のDANCE STUDIO　BEAT　THE　MIX
地図・特典

Campaign 特典

キャンペーンは実施しておりません

Access 千葉で１番のDANCE STUDIO　BEAT　THE　MIXの地図・交通案内

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key05038ddefeacc3bdfea0a79387685788556954e4
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  05038ddefeacc3bdfea0a79387685788556954e41746674159
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschoolgroup
- actionmap_and_coupon
- named(empty)
- pass(empty)
- schoolgroupId95
- _Token(array)
  key05038ddefeacc3bdfea0a79387685788556954e4
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0schoolgroupId
- options(array)
  schoolgroupId[0-9]+
- defaults(array)
  controllerschoolgroup
  actionmap_and_coupon
  plugin(null)
- template/group/LG_:schoolgroupId/map_and_coupon
====

Sql Log

Sql Logs

参考：explainの見方

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 36 queries / 0.017477 sec

No.

time

query

0.001937

connect

0.000667

DESCRIBE `schoolgroup`

0.000427

SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '95') AND (sg.registration_status = 1) LIMIT 1

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

0.000697

DESCRIBE `school`

0.000497

SELECT COUNT(*) AS `cnt` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.schoolgroup_id = '95') LIMIT 1

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

0.000717

DESCRIBE `schoolgroup_score`

0.000287

SELECT `s_s`.* FROM `schoolgroup_score` AS `s_s` WHERE (s_s.schoolgroup_id = '95') AND (s_s.is_latest = 1)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	schoolgroup_id	schoolgroup_id	4	const	1	Using where

0.000637

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '95') AND (s.is_detail_address_opening = 1) AND (s.lat IS NOT NULL) AND (s.lon IS NOT NULL)

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

0.000707

DESCRIBE `summary_count_school`

0.000507

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

DESCRIBE `campaign_schoolgroup`

0.000467

SELECT `c_sg`.* FROM `campaign_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '95') AND (c_sg.valid = 1) AND (c_sg.expiration_date = "0000-00-00" || c_sg.expiration_date IS NULL || c_sg.expiration_date >= 2025-05-08) ORDER BY `timestamp_created` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_sg	ref	schoolgroup_id,ix_expiration_date_campaign_schoolgroup	schoolgroup_id	4	const	1	Using index condition; Using where; Using filesort

0.000567

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '95') AND (s.is_detail_address_opening = 1) AND (s.lat IS NOT NULL) AND (s.lon IS NOT NULL)

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

0.000507

DESCRIBE `city`

0.000407

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

DESCRIBE `prefecture`

0.000327