キッズ＆リトルキッズジャズダンス国立☆の地図・アクセス・最寄駅・特典｜ダンススクール・ダンス教室の口コミ検索ネット

キッズ＆リトルキッズジャズダンス国立☆
地図・特典

Campaign 特典

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

Access キッズ＆リトルキッズジャズダンス国立☆の地図・交通案内

History
+
Request History
4 previous requests available
====
Session
+
Session
- _Token(array)
  key813b8368aa6682df46fa0b5af2d4e2ed283561b4
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  cb20076d6253f59efac3faae83491b3165ec19391746600716
  efc292499de390c513df913b95a3cb52b0d477201746600717
  813b8368aa6682df46fa0b5af2d4e2ed283561b41746600717
====
Request
+
Request

Cake Params
- plugin(null)
- controllerschoolgroup
- actionmap_and_coupon
- named(empty)
- pass(empty)
- schoolgroupId93
- _Token(array)
  key813b8368aa6682df46fa0b5af2d4e2ed283561b4
  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: 34 queries / 0.029537 sec

No.

time

query

0.004227

connect

0.000797

DESCRIBE `schoolgroup`

0.000457

SELECT `sg`.* FROM `schoolgroup` AS `sg` WHERE (sg.id = '93') 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.000907

DESCRIBE `school`

0.000507

SELECT COUNT(*) AS `cnt` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.schoolgroup_id = '93') 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	6	Using where

0.000817

DESCRIBE `schoolgroup_score`

0.000377

SELECT `s_s`.* FROM `schoolgroup_score` AS `s_s` WHERE (s_s.schoolgroup_id = '93') 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.000757

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '93') 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	6	Using where

0.000837

DESCRIBE `summary_count_school`

0.000527

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

DESCRIBE `campaign_schoolgroup`

0.000547

SELECT `c_sg`.* FROM `campaign_schoolgroup` AS `c_sg` WHERE (c_sg.schoolgroup_id = '93') 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-07) 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.000637

SELECT `s`.* FROM `school` AS `s` WHERE (s.schoolgroup_id = '93') 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	6	Using where

0.000647

DESCRIBE `city`

0.000367

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

DESCRIBE `prefecture`

0.000367