Campaign 特典
キャンペーンは実施しておりません
キャンペーンは実施しておりません
No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
参考:explainの見方
No. | time | query | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.001897 |
connect
|
||||||||||||||||||||||||||||||
2 | 0.002427 |
DESCRIBE `school`
|
||||||||||||||||||||||||||||||
3 | 0.000467 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.id = '3016486') AND (s.registration_status = 1) AND (s.is_opening = 1) LIMIT 1
|
||||||||||||||||||||||||||||||
4 | 0.000587 |
DESCRIBE `school_score`
|
||||||||||||||||||||||||||||||
5 | 0.000407 |
SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id = '3016486') AND (s_s.is_latest = 1)
|
||||||||||||||||||||||||||||||
6 | 0.000587 |
DESCRIBE `access_log_school`
|
||||||||||||||||||||||||||||||
7 | 0.049437 |
SELECT `access_log_school`.`id` FROM `access_log_school` WHERE (ip_address = '3.136.18.38') AND (school_id = '3016486') AND (timestamp_created >= '2024-12-11 06:17:06') LIMIT 1
|
||||||||||||||||||||||||||||||
8 | 0.003507 |
DESCRIBE `access_count_school`
|
||||||||||||||||||||||||||||||
9 | 0.000657 |
SELECT `acs`.* FROM `access_count_school` AS `acs` WHERE (acs.school_id = '3016486') LIMIT 1
|
||||||||||||||||||||||||||||||
10 | 0.062337 |
UPDATE `access_count_school` SET `count` = ?, `timestamp_modified` = ? WHERE (`access_count_school`.`id` = 3016)
|
||||||||||||||||||||||||||||||
11 | 0.000367 |
SELECT `access_count_school`.* FROM `access_count_school` WHERE (`access_count_school`.`id` = 3016) LIMIT 1
|
||||||||||||||||||||||||||||||
12 | 0.059587 |
INSERT INTO `access_log_school` (`school_id`, `ip_address`, `timestamp_created`, `timestamp_modified`) VALUES (?, ?, ?, ?)
|
||||||||||||||||||||||||||||||
13 | 0.002467 |
SELECT `access_log_school`.* FROM `access_log_school` WHERE (`access_log_school`.`id` = 12955712) LIMIT 1
|
||||||||||||||||||||||||||||||
14 | 0.000607 |
DESCRIBE `school_station`
|
||||||||||||||||||||||||||||||
15 | 0.000357 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016486') LIMIT 1
|
||||||||||||||||||||||||||||||
16 | 0.000977 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id = '745') AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)
|
||||||||||||||||||||||||||||||
17 | 0.000857 |
DESCRIBE `city`
|
||||||||||||||||||||||||||||||
18 | 0.000497 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '745') LIMIT 1
|
||||||||||||||||||||||||||||||
19 | 0.000557 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '12')
|
||||||||||||||||||||||||||||||
20 | 0.012637 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.city_id IN ('721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '744', '745', '746', '747', '748', '749', '750', '751', '752', '753', '754', '755', '756', '757', '758', '759', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '774', '775', '776', '777', '778', '779', '780', '781', '782')) AND (s.is_charged = 1) AND (s.registration_status = 1) AND (s.is_opening = 1)
|
||||||||||||||||||||||||||||||
21 | 0.003677 |
DESCRIBE `prefecture`
|
||||||||||||||||||||||||||||||
22 | 0.003317 |
SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '12') LIMIT 1
|
||||||||||||||||||||||||||||||
23 | 0.003247 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016486') ORDER BY `distance` ASC LIMIT 1
|
||||||||||||||||||||||||||||||
24 | 0.004027 |
DESCRIBE `station_unit`
|
||||||||||||||||||||||||||||||
25 | 0.003207 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016486')
|
||||||||||||||||||||||||||||||
26 | 0.002107 |
SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (false)
|
||||||||||||||||||||||||||||||
27 | 0.000577 |
DESCRIBE `major_city`
|
||||||||||||||||||||||||||||||
28 | 0.001687 |
DESCRIBE `city_major_city`
|
||||||||||||||||||||||||||||||
29 | 0.002077 |
SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id = '745')
|
||||||||||||||||||||||||||||||
30 | 0.003617 |
SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (false)
|
||||||||||||||||||||||||||||||
31 | 0.000727 |
DESCRIBE `summary_count_school`
|
||||||||||||||||||||||||||||||
32 | 0.000497 |
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
|
||||||||||||||||||||||||||||||
33 | 0.000997 |
DESCRIBE `campaign_school`
|
||||||||||||||||||||||||||||||
34 | 0.003097 |
SELECT `c_s`.* FROM `campaign_school` AS `c_s` WHERE (c_s.school_id = '3016486') AND (c_s.valid = 1) AND (c_s.expiration_date = "0000-00-00" || c_s.expiration_date IS NULL || c_s.expiration_date >= 2024-12-12) ORDER BY `timestamp_created` DESC
|
||||||||||||||||||||||||||||||
35 | 0.000757 |
DESCRIBE `category_school`
|
||||||||||||||||||||||||||||||
36 | 0.000417 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016486') AND (c_s.valid = 1) LIMIT 5
|
||||||||||||||||||||||||||||||
37 | 0.000397 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016486') AND (c_s.valid = 1) LIMIT 5
|
||||||||||||||||||||||||||||||
38 | 0.000387 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016486') AND (c_s.valid = 1) LIMIT 5
|
||||||||||||||||||||||||||||||
39 | 0.000367 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id = '3016486') AND (c_s.valid = 1) LIMIT 6
|
||||||||||||||||||||||||||||||
40 | 0.000367 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3016486') ORDER BY `time` ASC, `distance` ASC LIMIT 3
|
||||||||||||||||||||||||||||||
41 | 0.000637 |
DESCRIBE `dancer`
|
||||||||||||||||||||||||||||||
42 | 0.000527 |
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
|
||||||||||||||||||||||||||||||
43 | 0.000407 |
SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))
|
||||||||||||||||||||||||||||||
44 | 0.000587 |
DESCRIBE `dancer_column`
|
||||||||||||||||||||||||||||||
45 | 0.003847 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
46 | 0.000397 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
47 | 0.000387 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
48 | 0.000377 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
49 | 0.001397 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC
|
Peak Memory Use 9.14 MB
Message | Memory use |
---|---|
Component initialization | 2.14 MB |
Controller action start | 3.93 MB |
Controller render start | 4.55 MB |
View render complete | 5.55 MB |
Total Request Time: 345 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.29 | |
Event: Controller.initialize | 245.88 | |
Event: Controller.startup | 0.56 | |
Controller action | 0.21 | |
Event: Controller.beforeRender | 37.86 | |
» Processing toolbar data | 30.35 | |
Rendering View | 31.02 | |
» Event: View.beforeRender | 0.76 | |
» Rendering APP/View/School/map_and_coupon.ctp | 5.19 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.02 | |
» Rendering APP/View/Layouts/default.ctp | 24.10 | |
» » Rendering APP/View/Elements/header.ctp | 0.37 | |
» » Rendering APP/View/Elements/school/detailHeader.ctp | 7.78 | |
» » » Rendering APP/View/Elements/common/bookmark_school.ctp | 0.11 | |
» » » Rendering APP/View/Elements/breadcrumb.ctp | 0.21 | |
» » Rendering APP/View/Elements/menu.ctp | 13.41 | |
» » » Rendering APP/View/Elements/school/right-menu.ctp | 13.23 | |
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp | 0.07 | |
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp | 0.06 | |
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp | 12.24 | |
» » » » Rendering APP/View/Elements/school/right-menu-neighbor-school.ctp | 0.10 | |
» » » » Rendering APP/View/Elements/adsense/300_250.ctp | 0.09 | |
» » Rendering APP/View/Elements/rtt.ctp | 0.11 | |
» » Rendering APP/View/Elements/footer.ctp | 0.90 | |
» » Rendering APP/View/Elements/common/scoreEx.ctp | 0.07 | |
Event: View.afterLayout | 0.00 |
Notice (8): Undefined offset: 1 [CORE/Cake/View/Helper/HtmlHelper.php, line 867]
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.136.18.38 |
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 | /detail/L_3016486/map_and_coupon |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.1 |
Gateway Interface | CGI/1.1 |
Redirect Url | /detail/L_3016486/map_and_coupon |
Remote Port | 59720 |
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.136.18.38 |
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.136.18.38 |
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.136.18.38 |
Http Host | dance-schoolgv.net |
Ngx Cache Staticmode | 1 |
Ngx Cache Normalfile | 1 |
Failurecachetime | 0 |
Https | on |
Unique Id | Z1oBUTD-5Jr5r3EUSBHLEwAAALM |
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 | Z1oBUTD-5Jr5r3EUSBHLEwAAALM |
Redirect Mef Proxy Addr | 183.90.231.12 |
Fcgi Role | RESPONDER |
Php Self | /index.php |
Request Time Float | 1733951825.9861 |
Request Time | 1733951825 |