No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
参考:explainの見方
No. | time | query | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.001747 |
connect
|
||||||||||||||||||||||||||||||
2 | 0.000467 |
DESCRIBE `prefecture`
|
||||||||||||||||||||||||||||||
3 | 0.000317 |
SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '37') LIMIT 1
|
||||||||||||||||||||||||||||||
4 | 0.000597 |
DESCRIBE `city`
|
||||||||||||||||||||||||||||||
5 | 0.000317 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1825') LIMIT 1
|
||||||||||||||||||||||||||||||
6 | 0.000467 |
DESCRIBE `summary_count_school`
|
||||||||||||||||||||||||||||||
7 | 0.000757 |
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 = 0) AND (s_c_s.city_id = '1825') 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)
|
||||||||||||||||||||||||||||||
8 | 0.000507 |
DESCRIBE `station`
|
||||||||||||||||||||||||||||||
9 | 0.000517 |
SELECT `s`.* FROM `station` AS `s` WHERE (s.city_id = '1825') GROUP BY `s`.`id`
|
||||||||||||||||||||||||||||||
10 | 0.022947 |
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 IN ('3947', '3948', '3949', '3950', '3951', '3952', '3953', '3954', '3955', '3956', '3957', '4036', '4037', '4038', '4039', '8604', '8605', '8606', '8607', '8608', '8609', '8610', '8611', '8612', '8613', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8638', '8639', '8640', '8641', '8642', '8643', '8644', '8645', '8646', '8647', '8648', '8649', '8650')) AND (s_c_s.station_unit_id = 0) AND (s_c_s.major_city_id = 0) AND (s_c_s.count > 0)
|
||||||||||||||||||||||||||||||
11 | 0.000497 |
DESCRIBE `station_unit`
|
||||||||||||||||||||||||||||||
12 | 0.000327 |
SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '37')
|
||||||||||||||||||||||||||||||
13 | 0.000427 |
DESCRIBE `major_city`
|
||||||||||||||||||||||||||||||
14 | 0.000317 |
SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '37')
|
||||||||||||||||||||||||||||||
15 | 0.000657 |
DESCRIBE `school`
|
||||||||||||||||||||||||||||||
16 | 0.000417 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.city_id = '1825')
|
||||||||||||||||||||||||||||||
17 | 0.000497 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.city_id = '1825') ORDER BY `s`.`is_charged` DESC, `s`.`score` DESC LIMIT 20
|
||||||||||||||||||||||||||||||
18 | 0.000347 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.id IN ('1825', '1825', '1825'))
|
||||||||||||||||||||||||||||||
19 | 0.000437 |
SELECT `p`.* FROM `prefecture` AS `p`
|
||||||||||||||||||||||||||||||
20 | 0.000517 |
DESCRIBE `school_station`
|
||||||||||||||||||||||||||||||
21 | 0.000407 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015448', '3015449', '3014018'))
|
||||||||||||||||||||||||||||||
22 | 0.000457 |
DESCRIBE `station_station_unit`
|
||||||||||||||||||||||||||||||
23 | 0.000337 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id IN ('3947', '3948', '8604', '8605', '3947', '3948', '8604', '8605'))
|
||||||||||||||||||||||||||||||
24 | 0.000557 |
DESCRIBE `city_major_city`
|
||||||||||||||||||||||||||||||
25 | 0.000317 |
SELECT `c_m_c`.* FROM `city_major_city` AS `c_m_c` WHERE (c_m_c.city_id IN ('1825', '1825', '1825'))
|
||||||||||||||||||||||||||||||
26 | 0.000407 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id IN ('3015448', '3015449', '3014018'))
|
||||||||||||||||||||||||||||||
27 | 0.000377 |
SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('3947', '3947')) GROUP BY `s`.`id`
|
||||||||||||||||||||||||||||||
28 | 0.000507 |
DESCRIBE `school_score`
|
||||||||||||||||||||||||||||||
29 | 0.000407 |
SELECT `s_s`.* FROM `school_score` AS `s_s` WHERE (s_s.school_id IN ('3015448', '3015449', '3014018')) AND (s_s.is_latest = 1)
|
||||||||||||||||||||||||||||||
30 | 0.000507 |
DESCRIBE `category_school`
|
||||||||||||||||||||||||||||||
31 | 0.000387 |
SELECT `c_s`.* FROM `category_school` AS `c_s` WHERE (c_s.school_id IN ('3015448', '3015449', '3014018'))
|
||||||||||||||||||||||||||||||
32 | 0.001927 |
connect
|
||||||||||||||||||||||||||||||
33 | 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
|
||||||||||||||||||||||||||||||
34 | 0.000447 |
SELECT `p`.* FROM `prefecture` AS `p`
|
||||||||||||||||||||||||||||||
35 | 0.000457 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '37')
|
||||||||||||||||||||||||||||||
36 | 0.000657 |
DESCRIBE `summary_count_kuchikomi`
|
||||||||||||||||||||||||||||||
37 | 0.000447 |
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 = 0) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = '1825') AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = 0) LIMIT 1
|
||||||||||||||||||||||||||||||
38 | 0.000517 |
DESCRIBE `dancer`
|
||||||||||||||||||||||||||||||
39 | 0.000407 |
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
|
||||||||||||||||||||||||||||||
40 | 0.000337 |
SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))
|
||||||||||||||||||||||||||||||
41 | 0.000477 |
DESCRIBE `dancer_column`
|
||||||||||||||||||||||||||||||
42 | 0.000397 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
43 | 0.000387 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
44 | 0.000357 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
45 | 0.000367 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
46 | 0.000437 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC
|
Peak Memory Use 10.36 MB
Message | Memory use |
---|---|
Component initialization | 2.16 MB |
Controller action start | 2.39 MB |
Controller render start | 4.98 MB |
View render complete | 5.64 MB |
Total Request Time: 158 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.31 | |
Event: Controller.initialize | 0.65 | |
Event: Controller.startup | 0.30 | |
Controller action | 62.52 | |
Event: Controller.beforeRender | 43.01 | |
» Processing toolbar data | 39.90 | |
Rendering View | 23.82 | |
» Event: View.beforeRender | 0.96 | |
» Rendering APP/View/SchoolList/index.ctp | 11.54 | |
» » Rendering APP/View/Elements/breadcrumb.ctp | 0.26 | |
» » Rendering APP/View/Elements/school_list/category-description.ctp | 0.08 | |
» » Rendering APP/View/Elements/school_list/search-inputform.ctp | 5.53 | |
» » Rendering APP/View/Elements/__searchlink/main-column-station.ctp | 0.23 | |
» » Rendering APP/View/Elements/__searchlink/main-column-category.ctp | 0.21 | |
» » Rendering APP/View/Elements/school-box.ctp | 1.01 | |
» » » Rendering APP/View/Elements/adsense/336_288.ctp | 0.09 | |
» » Rendering APP/View/Elements/school-box.ctp #2 | 0.34 | |
» » Rendering APP/View/Elements/school-box.ctp #3 | 0.38 | |
» » Rendering APP/View/Elements/paginator.ctp | 0.08 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 10.28 | |
» » Rendering APP/View/Elements/header.ctp | 0.38 | |
» » Rendering APP/View/Elements/menu.ctp | 7.51 | |
» » » Rendering APP/View/Elements/school_list/right-menu.ctp | 7.33 | |
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp | 0.08 | |
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp | 6.59 | |
» » » » 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.87 | |
» » 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.133.139.28 |
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 | /pref_37/city_1825 |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.1 |
Gateway Interface | CGI/1.1 |
Redirect Url | /pref_37/city_1825 |
Remote Port | 38372 |
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.133.139.28 |
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.133.139.28 |
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.133.139.28 |
Http Host | dance-schoolgv.net |
Ngx Cache Staticmode | 1 |
Ngx Cache Normalfile | 1 |
Failurecachetime | 0 |
Https | on |
Unique Id | Zz8JEHpl3aPtNMcOlsBuRAAAAeQ |
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 | Zz8JEHpl3aPtNMcOlsBuRAAAAeQ |
Redirect Mef Proxy Addr | 183.90.231.12 |
Fcgi Role | RESPONDER |
Php Self | /index.php |
Request Time Float | 1732184336.1489 |
Request Time | 1732184336 |