No post data.
No querystring data.
To view Cookies, add CookieComponent to Controller
参考:explainの見方
No. | time | query | ||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.001717 |
connect
|
||||||||||||||||||||||||||||||
2 | 0.000507 |
DESCRIBE `prefecture`
|
||||||||||||||||||||||||||||||
3 | 0.000307 |
SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '27') LIMIT 1
|
||||||||||||||||||||||||||||||
4 | 0.000427 |
DESCRIBE `station_unit`
|
||||||||||||||||||||||||||||||
5 | 0.000297 |
SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.id = '13') LIMIT 1
|
||||||||||||||||||||||||||||||
6 | 0.000437 |
DESCRIBE `summary_count_kuchikomi`
|
||||||||||||||||||||||||||||||
7 | 0.000587 |
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 IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id = '13') AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)
|
||||||||||||||||||||||||||||||
8 | 0.000767 |
DESCRIBE `station`
|
||||||||||||||||||||||||||||||
9 | 0.000917 |
DESCRIBE `station_station_unit`
|
||||||||||||||||||||||||||||||
10 | 0.000317 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_unit_id = '13')
|
||||||||||||||||||||||||||||||
11 | 0.000327 |
SELECT `s`.* FROM `station` AS `s` WHERE (s.id IN ('8146', '6040', '2910')) GROUP BY `s`.`id`
|
||||||||||||||||||||||||||||||
12 | 0.000387 |
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 = 4) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id IN ('2910', '6040', '8146')) AND (s_c_k.station_unit_id = 0) AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)
|
||||||||||||||||||||||||||||||
13 | 0.000307 |
SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.prefecture_id = '27')
|
||||||||||||||||||||||||||||||
14 | 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 = 4) AND (s_c_k.prefecture_id = 0) AND (s_c_k.city_id = 0) AND (s_c_k.station_id = 0) AND (s_c_k.station_unit_id IN ('12', '13')) AND (s_c_k.major_city_id = 0) AND (s_c_k.count > 0)
|
||||||||||||||||||||||||||||||
15 | 0.000437 |
DESCRIBE `major_city`
|
||||||||||||||||||||||||||||||
16 | 0.000327 |
SELECT `m_c`.* FROM `major_city` AS `m_c` WHERE (m_c.prefecture_id = '27')
|
||||||||||||||||||||||||||||||
17 | 0.000617 |
DESCRIBE `school`
|
||||||||||||||||||||||||||||||
18 | 0.000337 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_unit_id = '13')
|
||||||||||||||||||||||||||||||
19 | 0.000427 |
DESCRIBE `school_station`
|
||||||||||||||||||||||||||||||
20 | 0.000497 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.station_id IN ('8146', '6040', '2910'))
|
||||||||||||||||||||||||||||||
21 | 0.000497 |
SELECT `s`.`id` FROM `school` AS `s` WHERE (s.registration_status = 1) AND (s.is_opening = 1) AND (s.id IN ('3015152', '3013231', '3014854', '3013751', '3013752', '3015061', '3015071', '3016105', '3016007', '3015474', '3016305', '3015236', '3014440', '3015254', '3015494', '3015408', '3015912', '3016041', '3015362', '3014205', '3014271', '3015010', '3013762', '3015040', '3013768', '3013179', '3015080', '3014566', '3013763', '3014428', '3014445', '3014630', '3015236', '3015494', '3015681', '3015408', '3014565', '3015882', '3015955', '3016041', '3016058', '3016100', '3015885', '3015362'))
|
||||||||||||||||||||||||||||||
22 | 0.000767 |
DESCRIBE `kuchikomi`
|
||||||||||||||||||||||||||||||
23 | 0.000587 |
DESCRIBE `kuchikomi_category`
|
||||||||||||||||||||||||||||||
24 | 0.000427 |
SELECT `k_c`.`kuchikomi_id` FROM `kuchikomi_category` AS `k_c` WHERE (k_c.category_id = 4)
|
||||||||||||||||||||||||||||||
25 | 0.000807 |
SELECT COUNT(1) AS `zend_paginator_row_count` FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013179', '3013751', '3013752', '3013762', '3013763', '3013768', '3014271', '3014440', '3014445', '3014565', '3014630', '3014854', '3015010', '3015071', '3015080', '3015152', '3015236', '3015254', '3015362', '3015408', '3015474', '3015494', '3015681', '3015882', '3015885', '3015912', '3015955', '3016007', '3016041', '3016058', '3016100', '3016105', '3016305')) AND (k.id IN ('2', '3', '10', '24', '35', '36', '37', '39', '40', '45', '47', '51', '54', '57', '59', '62', '65', '70', '85', '91', '96', '97', '100', '101', '108', '113', '115', '116', '117', '118', '123', '131', '132', '152', '153', '154', '162', '168', '179', '181', '182', '189', '190', '195', '196', '200', '207', '208', '222', '223', '225', '227', '228', '360', '364', '453', '475', '716', '763', '882', '917', '954', '1063', '1074', '1108', '1130', '1133', '1137', '1138', '1141', '1144', '1145', '1146', '1147', '1148', '1150', '1163', '1180', '1206', '1324', '1325', '1329', '1368'))
|
||||||||||||||||||||||||||||||
26 | 0.000807 |
SELECT `k`.* FROM `kuchikomi` AS `k` WHERE (k.valid = 1) AND (k.school_id IN ('3013179', '3013751', '3013752', '3013762', '3013763', '3013768', '3014271', '3014440', '3014445', '3014565', '3014630', '3014854', '3015010', '3015071', '3015080', '3015152', '3015236', '3015254', '3015362', '3015408', '3015474', '3015494', '3015681', '3015882', '3015885', '3015912', '3015955', '3016007', '3016041', '3016058', '3016100', '3016105', '3016305')) AND (k.id IN ('2', '3', '10', '24', '35', '36', '37', '39', '40', '45', '47', '51', '54', '57', '59', '62', '65', '70', '85', '91', '96', '97', '100', '101', '108', '113', '115', '116', '117', '118', '123', '131', '132', '152', '153', '154', '162', '168', '179', '181', '182', '189', '190', '195', '196', '200', '207', '208', '222', '223', '225', '227', '228', '360', '364', '453', '475', '716', '763', '882', '917', '954', '1063', '1074', '1108', '1130', '1133', '1137', '1138', '1141', '1144', '1145', '1146', '1147', '1148', '1150', '1163', '1180', '1206', '1324', '1325', '1329', '1368')) ORDER BY `k`.`posted_at` DESC LIMIT 10
|
||||||||||||||||||||||||||||||
27 | 0.000387 |
SELECT `k_c`.* FROM `kuchikomi_category` AS `k_c` WHERE (k_c.kuchikomi_id IN ('1138'))
|
||||||||||||||||||||||||||||||
28 | 0.000697 |
DESCRIBE `member`
|
||||||||||||||||||||||||||||||
29 | 0.000377 |
SELECT `m`.* FROM `member` AS `m` WHERE (m.id IN ('2280'))
|
||||||||||||||||||||||||||||||
30 | 0.000757 |
SELECT `s`.* FROM `school` AS `s` WHERE (s.id IN ('3014271'))
|
||||||||||||||||||||||||||||||
31 | 0.000577 |
DESCRIBE `access_count_kuchikomi`
|
||||||||||||||||||||||||||||||
32 | 0.000757 |
SELECT `a_c_k`.* FROM `access_count_kuchikomi` AS `a_c_k` WHERE (a_c_k.kuchikomi_id IN ('1138'))
|
||||||||||||||||||||||||||||||
33 | 0.000547 |
DESCRIBE `kuchikomi_questionnaire_answer`
|
||||||||||||||||||||||||||||||
34 | 0.000347 |
SELECT `k_q_a`.* FROM `kuchikomi_questionnaire_answer` AS `k_q_a` WHERE (k_q_a.kuchikomi_id IN ('1138'))
|
||||||||||||||||||||||||||||||
35 | 0.001817 |
connect
|
||||||||||||||||||||||||||||||
36 | 0.000607 |
DESCRIBE `summary_count_school`
|
||||||||||||||||||||||||||||||
37 | 0.000457 |
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
|
||||||||||||||||||||||||||||||
38 | 0.000457 |
SELECT `p`.* FROM `prefecture` AS `p`
|
||||||||||||||||||||||||||||||
39 | 0.000537 |
DESCRIBE `city`
|
||||||||||||||||||||||||||||||
40 | 0.000567 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.prefecture_id = '27')
|
||||||||||||||||||||||||||||||
41 | 0.000357 |
SELECT `c`.* FROM `city` AS `c` WHERE (c.id = '1460') LIMIT 1
|
||||||||||||||||||||||||||||||
42 | 0.000317 |
SELECT `p`.* FROM `prefecture` AS `p` WHERE (p.id = '27') LIMIT 1
|
||||||||||||||||||||||||||||||
43 | 0.000367 |
SELECT `s_s`.* FROM `school_station` AS `s_s` WHERE (s_s.school_id = '3014271')
|
||||||||||||||||||||||||||||||
44 | 0.000327 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8174')
|
||||||||||||||||||||||||||||||
45 | 0.000317 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8146')
|
||||||||||||||||||||||||||||||
46 | 0.000297 |
SELECT `s_s_s`.* FROM `station_station_unit` AS `s_s_s` WHERE (s_s_s.station_id = '8195')
|
||||||||||||||||||||||||||||||
47 | 0.000307 |
SELECT `s_s`.* FROM `station_unit` AS `s_s` WHERE (s_s.id IN ('13'))
|
||||||||||||||||||||||||||||||
48 | 0.003197 |
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 = 4) 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 = '13') LIMIT 1
|
||||||||||||||||||||||||||||||
49 | 0.000547 |
DESCRIBE `dancer`
|
||||||||||||||||||||||||||||||
50 | 0.000477 |
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
|
||||||||||||||||||||||||||||||
51 | 0.000387 |
SELECT `c`.* FROM `dancer` AS `c` WHERE (c.id IN ('17', '16', '15', '14', '13'))
|
||||||||||||||||||||||||||||||
52 | 0.000507 |
DESCRIBE `dancer_column`
|
||||||||||||||||||||||||||||||
53 | 0.000427 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '17') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
54 | 0.000397 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '16') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
55 | 0.000377 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '15') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
56 | 0.000367 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '14') ORDER BY `timestamp_created` ASC
|
||||||||||||||||||||||||||||||
57 | 0.000367 |
SELECT `c`.* FROM `dancer_column` AS `c` WHERE (c.valid = 1) AND (c.dancer_id = '13') ORDER BY `timestamp_created` ASC
|
Peak Memory Use 14.27 MB
Message | Memory use |
---|---|
Component initialization | 2.15 MB |
Controller action start | 2.39 MB |
Controller render start | 5.33 MB |
View render complete | 6.18 MB |
Total Request Time: 166 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.20 | |
Event: Controller.initialize | 0.68 | |
Event: Controller.startup | 0.25 | |
Controller action | 41.84 | |
Event: Controller.beforeRender | 57.20 | |
» Processing toolbar data | 53.26 | |
Rendering View | 35.86 | |
» Event: View.beforeRender | 6.18 | |
» Rendering APP/View/KuchikomiList/index.ctp | 17.79 | |
» » Rendering APP/View/Elements/breadcrumb.ctp | 0.27 | |
» » Rendering APP/View/Elements/kuchikomi_list/search-inputform.ctp | 7.88 | |
» » Rendering APP/View/Elements/__searchlink/main-column-station-unit.ctp | 0.16 | |
» » Rendering APP/View/Elements/__searchlink/main-column-station.ctp | 0.10 | |
» » Rendering APP/View/Elements/kuchikomi-box.ctp | 4.80 | |
» » » Rendering APP/View/Elements/adsense/336_288.ctp | 0.08 | |
» » Rendering APP/View/Elements/paginator.ctp | 0.06 | |
» Event: View.afterRender | 0.03 | |
» Event: View.beforeLayout | 0.03 | |
» Rendering APP/View/Layouts/default.ctp | 11.07 | |
» » Rendering APP/View/Elements/header.ctp | 0.35 | |
» » Rendering APP/View/Elements/menu.ctp | 8.16 | |
» » » Rendering APP/View/Elements/kuchikomi_list/right-menu.ctp | 8.01 | |
» » » » Rendering APP/View/Elements/__searchlink/right-menu-category.ctp | 0.21 | |
» » » » Rendering APP/View/Elements/common/menu_danceClip.ctp | 0.07 | |
» » » » Rendering APP/View/Elements/common/menu_danceSpColumn.ctp | 7.05 | |
» » » » Rendering APP/View/Elements/common/menu_twitter.ctp | 0.09 | |
» » » » Rendering APP/View/Elements/adsense/movable-adsense.ctp | 0.07 | |
» » Rendering APP/View/Elements/rtt.ctp | 0.13 | |
» » Rendering APP/View/Elements/footer.ctp | 1.19 | |
» » 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.235.145.252 |
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://www.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 | /kuchikomi/street/pref_27/area_su13 |
Query String | |
Request Method | GET |
Server Protocol | HTTP/1.1 |
Gateway Interface | CGI/1.1 |
Redirect Url | /kuchikomi/street/pref_27/area_su13 |
Remote Port | 36704 |
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.235.145.252 |
Server Port | 443 |
Server Addr | 183.90.231.12 |
Server Name | www.dance-schoolgv.net |
Server Software | Apache |
Server Signature | |
Http Accept Language | en-US,en;q=0.5 |
Http Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Http User Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
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.235.145.252 |
Http X Forwarded Ssl | on |
Http X Forwarded Port | 443 |
Http X Forwarded Host | www.dance-schoolgv.net |
Http X Forwarded Proto | https |
Http X Forwarded For | 3.235.145.252 |
Http Host | www.dance-schoolgv.net |
Ngx Cache Staticmode | 1 |
Ngx Cache Normalfile | 1 |
Failurecachetime | 0 |
Https | on |
Unique Id | ZzXpSyIg0uja6pN_AKL7xwAAAPo |
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 | ZzXpSyIg0uja6pN_AKL7xwAAAPo |
Redirect Mef Proxy Addr | 183.90.231.12 |
Fcgi Role | RESPONDER |
Php Self | /index.php |
Request Time Float | 1731586379.2854 |
Request Time | 1731586379 |