タンゴのレッスンを行う宮崎県のダンススクール・ダンス教室

Search Result 検索結果

Host: mysql202.xbiz.ne.jp
DB: jobikai_dance
total: 33 queries / 0.050507 sec

No.

time

query

0.001587

connect

0.000507

DESCRIBE `prefecture`

0.000307

SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '45') 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.000477

DESCRIBE `summary_count_school`

0.000667

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 IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) AND (s_c_s.prefecture_id = '45') 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) AND (s_c_s.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	range	multi	multi	28		17	Using index condition; Using where

0.000467

DESCRIBE `city`

0.000367

SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '45')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	prefecture_id	prefecture_id	5	const	17

0.031897

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 = 11) AND (s_c_s.prefecture_id = 0) AND (s_c_s.city_id IN ('2148', '2149', '2154', '2155', '2156', '2162', '2163', '2166', '2169', '2170', '2171', '2181', '2184', '2185', '2187', '2188', '2191')) AND (s_c_s.station_id = 0) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_s	range	multi	multi	28		17	Using index condition; Using where

0.000557

DESCRIBE `station_unit`

0.000347

SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '45')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_s	ref	prefecture_id	prefecture_id	4	const	1

0.000447

DESCRIBE `major_city`

0.000317

SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '45')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m_c	ref	prefecture_id	prefecture_id	4	const	1

0.000687

DESCRIBE `school`

0.000477

DESCRIBE `category_school`

0.001217

SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.category_id = 11)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c_s	ref	ix_category_id_category_school	ix_category_id_category_school	4	const	133

0.000407

SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '45')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	prefecture_id	prefecture_id	5	const	17

0.001207

SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013182', '3013187', '3013188', '3013189', '3013230', '3013236', '3013254', '3013256', '3013265', '3013266', '3013269', '3013311', '3013316', '3013327', '3013361', '3013429', '3013450', '3013459', '3013467', '3013469', '3013474', '3013490', '3013504', '3013519', '3013534', '3013540', '3013947', '3013959', '3013960', '3013996', '3013997', '3014015', '3014022', '3014047', '3014052', '3014069', '3014096', '3014099', '3014134', '3014151', '3014171', '3014180', '3014202', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014193', '3014295', '3014313', '3014298', '3014316', '3014333', '3014423', '3014428', '3014429', '3014439', '3014445', '3014487', '3014553', '3014583', '3014584', '3014595', '3014615', '3014618', '3014637', '3014647', '3014705', '3014697', '3014832', '3014834', '3014846', '3014848', '3014849', '3014861', '3014867', '3014882', '3014890', '3014909', '3014923', '3014934', '3014977', '3015034', '3015053', '3015059', '3015203', '3015265', '3015304', '3015305', '3015365', '3015387', '3015388', '3015396', '3015454', '3015456', '3014644', '3015471', '3015494', '3015495', '3015531', '3015551', '3015674', '3014802', '3015715', '3015718', '3015729', '3015607', '3015793', '3015834', '3015880', '3015965', '3015989', '3015990', '3016030', '3016051', '3016082', '3016146', '3016147', '3016241', '3016243', '3016328', '3016359', '3016360', '3016420', '3015991')) AND (s.city_id IN ('2148', '2149', '2154', '2155', '2156', '2162', '2163', '2166', '2169', '2170', '2171', '2181', '2184', '2185', '2187', '2188', '2191'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	PRIMARY,city_id	PRIMARY	4		133	Using where

0.001217

SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3013182', '3013187', '3013188', '3013189', '3013230', '3013236', '3013254', '3013256', '3013265', '3013266', '3013269', '3013311', '3013316', '3013327', '3013361', '3013429', '3013450', '3013459', '3013467', '3013469', '3013474', '3013490', '3013504', '3013519', '3013534', '3013540', '3013947', '3013959', '3013960', '3013996', '3013997', '3014015', '3014022', '3014047', '3014052', '3014069', '3014096', '3014099', '3014134', '3014151', '3014171', '3014180', '3014202', '3014234', '3014235', '3014236', '3014237', '3014238', '3014239', '3014240', '3014241', '3014242', '3014243', '3014244', '3014247', '3014193', '3014295', '3014313', '3014298', '3014316', '3014333', '3014423', '3014428', '3014429', '3014439', '3014445', '3014487', '3014553', '3014583', '3014584', '3014595', '3014615', '3014618', '3014637', '3014647', '3014705', '3014697', '3014832', '3014834', '3014846', '3014848', '3014849', '3014861', '3014867', '3014882', '3014890', '3014909', '3014923', '3014934', '3014977', '3015034', '3015053', '3015059', '3015203', '3015265', '3015304', '3015305', '3015365', '3015387', '3015388', '3015396', '3015454', '3015456', '3014644', '3015471', '3015494', '3015495', '3015531', '3015551', '3015674', '3014802', '3015715', '3015718', '3015729', '3015607', '3015793', '3015834', '3015880', '3015965', '3015989', '3015990', '3016030', '3016051', '3016082', '3016146', '3016147', '3016241', '3016243', '3016328', '3016359', '3016360', '3016420', '3015991')) AND (s.city_id IN ('2148', '2149', '2154', '2155', '2156', '2162', '2163', '2166', '2169', '2170', '2171', '2181', '2184', '2185', '2187', '2188', '2191')) ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	range	PRIMARY,city_id	PRIMARY	4		133	Using where; Using filesort

0.001797

connect

0.000427

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

SELECT `p`.* FROM `prefecture` AS `p`

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	ALL					47

0.000377

SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '45')

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	prefecture_id	prefecture_id	5	const	17

0.000607

DESCRIBE `summary_count_kuchikomi`

0.000377

SELECT `s_c_k`.* FROM `summary_count_kuchikomi` AS `s_c_k` WHERE (s_c_k.is_latest = 1) AND (s_c_k.category_id = 11) AND (s_c_k.prefecture_id = '45') AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s_c_k	ref	multi	multi	20	const,const,const,const,const	1	Using index condition

0.000557

DESCRIBE `dancer`

0.000467

SELECT `c`.`id` FROM `dancer` AS `c` INNER JOIN `dancer_column` AS `d_c` ON c.id = d_c.dancer_id AND d_c.valid = 1 ORDER BY `d_c`.`timestamp_created` DESC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d_c	ALL	ix_dancer_id_dancer_column				29	Using where; Using filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	jobikai_dance.d_c.dancer_id	1	Using index

0.000347

SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	PRIMARY	PRIMARY	4		5	Using where

0.000487

DESCRIBE `dancer_column`

0.000407

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000347

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000337

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000327

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	2	Using index condition; Using where; Using filesort

0.000317

SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	ix_dancer_id_dancer_column	ix_dancer_id_dancer_column	5	const	1	Using index condition; Using where; Using filesort

Message	Memory use
Component initialization	2.16 MB
Controller action start	2.39 MB
Controller render start	4.35 MB
View render complete	5.05 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	7.08
Event: Controller.initialize	0.63
Event: Controller.startup	0.28
Controller action	60.70
Event: Controller.beforeRender	25.74
» Processing toolbar data	22.95
Rendering View	19.27
» Event: View.beforeRender	0.57
» Rendering APP/View/SchoolList/index.ctp	7.37
» » Rendering APP/View/Elements/breadcrumb.ctp	0.22
» » Rendering APP/View/Elements/school_list/category-description.ctp	0.08
» » Rendering APP/View/Elements/school_list/search-inputform.ctp	4.68
» » Rendering APP/View/Elements/adsense/336_288.ctp	0.08
» » Rendering APP/View/Elements/paginator.ctp	0.07
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	10.24
» » Rendering APP/View/Elements/header.ctp	0.36
» » Rendering APP/View/Elements/menu.ctp	7.58
» » » Rendering APP/View/Elements/school_list/right-menu.ctp	7.42
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp	0.10
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp	6.72
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp	0.08
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp	0.07
» » Rendering APP/View/Elements/rtt.ctp	0.11
» » Rendering APP/View/Elements/footer.ctp	0.88
» » Rendering APP/View/Elements/common/scoreEx.ctp	0.07
Event: View.afterLayout	0.00

Constant	Value
SGV_ENV	development
DEBUGKIT_ON	1
MENTE_FLAG
SGV_APP_BASE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/
CONFIG_DIR	/home/jobikai/dance-schoolgv.net/cakephp/Config/
LIB_DIR	/home/jobikai/dance-schoolgv.net/cakephp/lib/
MODEL_DIR	/home/jobikai/dance-schoolgv.net/cakephp/Model/
CLASS_DIR	/home/jobikai/dance-schoolgv.net/cakephp/class/
THUMBLIB_BASE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb
THUMBLIB_PLUGIN_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/Thumb/thumb_plugins/
DEFAULT_THUMBLIB_IMPLEMENTATION	gd
USER_STATIC_SALT	Sq9kzVMPFA6rw2QKY1zlyg1To5mIV1Wp6eMOLewYT7gSibg3Jpi0GZd1xQOXQZ7Z
SITE_TITLE	ダンススクール・ダンス教室口コミ検索ネット
OPERATOR_MAIL_ADDRESS	info@kuchi.info
NO_REPLY_MAIL_ADDRESS	no-reply@kuchi.info
RETURN_PATH__MAIL_ADDRESS	errors@kuchi.info
GOOGLE_API_KEY	AIzaSyB9NDKQP4NIyM3rSlp7d4QwY5b2L9XYBs0
QWINTET_IP	122.216.11.82
ADSENSE_ID	ca-pub-7408087519812416
CLIENT_IP	3.142.35.75

Constant	Value
APP	/home/jobikai/dance-schoolgv.net/cakephp/app/
APP_DIR	app
APPLIBS	/home/jobikai/dance-schoolgv.net/cakephp/app/Lib/
CACHE	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/cache/
CAKE	/home/jobikai/dance-schoolgv.net/cakephp/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib
CORE_PATH	/home/jobikai/dance-schoolgv.net/cakephp/lib/
CAKE_VERSION	2.3.1
CSS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://dance-schoolgv.net
IMAGES	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/img/
IMAGES_URL	img/
JS	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/js/
JS_URL	js/
LOGS	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/logs/
ROOT	/home/jobikai/dance-schoolgv.net/cakephp
TESTS	/home/jobikai/dance-schoolgv.net/cakephp/app/Test/
TMP	/home/jobikai/dance-schoolgv.net/cakephp/app/tmp/
VENDORS	/home/jobikai/dance-schoolgv.net/cakephp/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/jobikai/dance-schoolgv.net/cakephp/app/webroot/

Environment Variable	Value
Php Version	5.6.40
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Pwd	/home/userfastcgi/jobikai/dance-schoolgv.net
Shlvl	0
Script Name	/index.php
Request Uri	/tango/pref_45
Query String
Request Method	GET
Server Protocol	HTTP/1.1
Gateway Interface	CGI/1.1
Redirect Url	/tango/pref_45
Remote Port	50536
Script Filename	/home/jobikai/dance-schoolgv.net/public_html/index.php
Server Admin	webmaster@dance-schoolgv.net
Context Document Root	/home/jobikai/dance-schoolgv.net/public_html
Context Prefix
Request Scheme	https
Document Root	/home/jobikai/dance-schoolgv.net/public_html
Remote Addr	3.142.35.75
Server Port	443
Server Addr	183.90.231.12
Server Name	dance-schoolgv.net
Server Software	Apache
Server Signature
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X File Type	normal
Http X Ua Device	pc
Http X Failure Cache Time	0
Http X Accel Expires	60
Http X Wp Access	0
Http X Server Address	183.90.231.12
Http X Real Ip	3.142.35.75
Http X Forwarded Ssl	on
Http X Forwarded Port	443
Http X Forwarded Host	dance-schoolgv.net
Http X Forwarded Proto	https
Http X Forwarded For	3.142.35.75
Http Host	dance-schoolgv.net
Ngx Cache Staticmode	1
Ngx Cache Normalfile	1
Failurecachetime	0
Https	on
Unique Id	ZiJz5Ew42qcXCyd6uCyqxwAAANc
Mef Proxy Addr	183.90.231.12
Redirect Status	200
Redirect Ngx Cache Staticmode	1
Redirect Ngx Cache Normalfile	1
Redirect Failurecachetime	0
Redirect Https	on
Redirect Unique Id	ZiJz5Ew42qcXCyd6uCyqxwAAANc
Redirect Mef Proxy Addr	183.90.231.12
Fcgi Role	RESPONDER
Php Self	/index.php
Request Time Float	1713533924.173
Request Time	1713533924

宮崎県のタンゴ　ダンススクール・ダンス教室

Search Result 検索結果

»Filtering Search ダンススクール・ダンス教室の絞り込み検索

School List 宮崎県のダンススクールランキング(タンゴ)

Special Column

Memory

Timers

宮崎県のタンゴ ダンススクール・ダンス教室

Search Result 検索結果

»Filtering Search ダンススクール・ダンス教室の絞り込み検索

School List 宮崎県のダンススクールランキング(タンゴ)

Special Column

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

宮崎県のタンゴ　ダンススクール・ダンス教室