道央自動車道&東北自動車道編 秋の交通安全週間&行楽シーズンに向け特別大公開! 高速道路&有料道路別オービスMAP part1【交通取締情報】
- 2017/09/26
- 「東新宿交通取締情報局」
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `SerialStory`.`id`, `SerialStory`.`title`, `SerialStory`.`url_text`, `SerialStory`.`description`, `SerialStory`.`main_image_file_name`, `SerialStory`.`article_top_flag`, `SerialStory`.`article_detail_flag`, `SerialStory`.`tech_top_flag`, `SerialStory`.`tech_detail_flag`, `SerialStory`.`bikes_top_flag`, `SerialStory`.`bikes_detail_flag`, `SerialStory`.`sort_no`, `SerialStory`.`delete_flg`, `SerialStory`.`created`, `SerialStory`.`creator`, `SerialStory`.`modified`, `SerialStory`.`modifier` FROM `mfdb`.`tb_serial_stories` AS `SerialStory` WHERE `SerialStory`.`delete_flg` = '0' ORDER BY `SerialStory`.`sort_no` asc | 28 | 28 | 12 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1019 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 2 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1032 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 1 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1026 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 9 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1013 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 13 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1014 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 9 | maybe slow |
| SELECT SerialStoryDetail.sort_no, News.id, News.title, News.lead, News.pr_flag, News.main_image_file_name, News.parent_category_id, News.public_date, News.category_id, News.tech_flag, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', ParentCategory.category_name, Category.category_name FROM tb_serial_story_detail AS SerialStoryDetail LEFT JOIN tb_news AS News ON (SerialStoryDetail.article_id = News.id) LEFT JOIN tb_news_category AS ParentCategory ON (News.parent_category_id = ParentCategory.id) LEFT JOIN tb_news_category AS Category ON (News.category_id = Category.id) LEFT JOIN tb_users_master AS User ON (News.request_user_id = User.id) LEFT JOIN tb_groups_master AS `Group` ON (News.request_group_id = Group.id) WHERE News.delete_flg = '0' AND News.public_flag = '1' AND News.status = 2 AND SerialStoryDetail.story_id=1015 AND ((News.public_date <= '2026-05-20 22:21:19') OR (News.public_date IS NULL)) ORDER BY SerialStoryDetail.sort_no ASC LIMIT 6 | 6 | 6 | 6 | |
| SELECT COUNT(*) AS `count` FROM `mfdb`.`tb_news` AS `News` WHERE `News`.`id` = 10001071 | 1 | 1 | 12 | maybe slow |
| SELECT `News`.`id`, `News`.`tech_flag`, `News`.`parent_category_id`, `News`.`category_id`, `News`.`type_id`, `News`.`title`, `News`.`sub_title`, `News`.`lead`, `News`.`main_image_file_name`, `News`.`main_image_caption`, `News`.`body_text`, `News`.`written_name_flag`, `News`.`pv`, `News`.`prev_day_pv`, `News`.`current_day_pv`, `News`.`show_rank_flag`, `News`.`request_group_id`, `News`.`request_user_id`, `News`.`request_date`, `News`.`approval_user_id`, `News`.`approval_date`, `News`.`reject_user_id`, `News`.`reject_date`, `News`.`reject_reason`, `News`.`status`, `News`.`public_flag`, `News`.`pr_flag`, `News`.`tc_flag`, `News`.`display_flag`, `News`.`ad_flag`, `News`.`feed`, `News`.`media_feed`, `News`.`embargo_flag`, `News`.`embargo_date`, `News`.`public_date`, `News`.`public_status`, `News`.`rss_flag`, `News`.`rss_url`, `News`.`redirect_flag`, `News`.`redirect_url`, `News`.`job_keyword`, `News`.`feature_id`, `News`.`autosalon_flag`, `News`.`tas_p_category_id`, `News`.`tas_category_id`, `News`.`guid`, `News`.`delete_flg`, `News`.`created`, `News`.`creator`, `News`.`modified`, `News`.`modifier`, `ParentCategory`.`category_name`, `Category`.`category_name`, `User`.`user_name`, `User`.`nick_name`, `Group`.`group_name`, `Group`.`intro_text`, `Group`.`groupimage_file_name` FROM `mfdb`.`tb_news` AS `News` LEFT JOIN `mfdb`.`tb_news_category` AS `ParentCategory` ON (`News`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_news_category` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`News`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`News`.`request_group_id` = `Group`.`id`) WHERE `News`.`id` = 10001071 LIMIT 1 | 1 | 1 | 12 | maybe slow |
| SELECT `NewsDetail`.`id`, `NewsDetail`.`articles_id`, `NewsDetail`.`detail_type`, `NewsDetail`.`detail_title`, `NewsDetail`.`detail_image_file_name`, `NewsDetail`.`detail_image2_file_name`, `NewsDetail`.`detail_link`, `NewsDetail`.`detail_text`, `NewsDetail`.`sort_no` FROM `mfdb`.`tb_news_detail` AS `NewsDetail` WHERE `NewsDetail`.`articles_id` = (10001071) ORDER BY `sort_no` ASC | 19 | 19 | 7 | maybe slow |
| SELECT `NewsImage`.`id`, `NewsImage`.`articles_id`, `NewsImage`.`detail_type`, `NewsImage`.`image_file_name`, `NewsImage`.`image_file_ext`, `NewsImage`.`image_caption`, `NewsImage`.`image_alttext`, `NewsImage`.`image_link`, `NewsImage`.`sort_no`, `NewsImage`.`created`, `NewsImage`.`creator` FROM `mfdb`.`tb_news_images` AS `NewsImage` WHERE `NewsImage`.`articles_id` = 10001071 ORDER BY `NewsImage`.`created` ASC | 0 | 0 | 15 | maybe slow |
| SELECT `LinkInfo`.`id`, `LinkInfo`.`article_id`, `LinkInfo`.`article_flag`, `LinkInfo`.`target_flag`, `LinkInfo`.`target_id` FROM `mfdb`.`tb_link_info` AS `LinkInfo` WHERE `LinkInfo`.`article_flag` = 1 AND `LinkInfo`.`article_id` = 10001071 ORDER BY `LinkInfo`.`target_flag` ASC, `LinkInfo`.`id` ASC | 3 | 3 | 8 | maybe slow |
| SELECT `KeywordDictionary`.`id`, `KeywordDictionary`.`title` FROM `mfdb`.`tb_keyword_dictionary` AS `KeywordDictionary` WHERE ((`KeywordDictionary`.`delete_flg` = '0') AND (`KeywordDictionary`.`public_flag` = '1') AND (`KeywordDictionary`.`status` = 2) AND (`KeywordDictionary`.`id` = 30001314)) | 1 | 1 | 6 | maybe slow |
| SELECT `KeywordOther`.`id`, `KeywordOther`.`title` FROM `mfdb`.`tb_keyword_other` AS `KeywordOther` WHERE ((`KeywordOther`.`delete_flg` = '0') AND (`KeywordOther`.`public_flag` = '1') AND (`KeywordOther`.`status` = 2) AND (((`KeywordOther`.`id` = 70000029) OR (`KeywordOther`.`id` = 70000034)))) | 2 | 2 | 13 | maybe slow |
| SELECT `LinkInfo`.`id`, `LinkInfo`.`article_id`, `LinkInfo`.`article_flag`, `LinkInfo`.`target_flag`, `LinkInfo`.`target_id` FROM `mfdb`.`tb_link_info` AS `LinkInfo` WHERE `LinkInfo`.`article_flag` = 1 AND `LinkInfo`.`target_id` IN (1,30001314,70000029,70000034,1) AND `LinkInfo`.`article_id`<>10001071 | 312 | 312 | 13 | |
| SELECT `News`.`id`, `News`.`title`, `News`.`lead`, `News`.`pr_flag`, `News`.`tech_flag`, `News`.`main_image_file_name`, `News`.`parent_category_id`, `News`.`public_date`, `News`.`category_id`, (CASE News.written_name_flag WHEN 1 THEN CONCAT(Group.group_name,' ',User.nick_name) WHEN 2 THEN Group.group_name WHEN 3 THEN User.nick_name ELSE Group.group_name END) AS 'writer_name', `ParentCategory`.`category_name`, `Category`.`category_name` FROM `mfdb`.`tb_news` AS `News` LEFT JOIN `mfdb`.`tb_news_category` AS `ParentCategory` ON (`News`.`parent_category_id` = `ParentCategory`.`id`) LEFT JOIN `mfdb`.`tb_news_category` AS `Category` ON (`News`.`category_id` = `Category`.`id`) LEFT JOIN `mfdb`.`tb_users_master` AS `User` ON (`News`.`request_user_id` = `User`.`id`) LEFT JOIN `mfdb`.`tb_groups_master` AS `Group` ON (`News`.`request_group_id` = `Group`.`id`) WHERE ((`News`.`delete_flg` = '0') AND (`News`.`public_flag` = '1') AND (`News`.`status` = 2) AND (`News`.`public_status` = '1') AND (`News`.`id` IN (1,10000509,10000531,10000589,10000725,10000590,10000624,10000767,10000794,10000845,10000883,10000977,10000936,10000822,10001234,10001209,10001107,10001252,10001378,10001226,10000790,10001816,10001661,10001469,10001845,10001879,10001989,10001993,10002055,10002063,10002110,10002160,10002181,10002159,10002136,10002161,10002248,10002993,10002733,10002253,10002218,10002216,10002998,10003124,10003063,10003213,10003307,10003411,10002875,10002914,10003633,10003683,10003548,10003763,10003847,10003808,10003789,10003883,10003899,10003933,10004005,10004045,10004007,10004047,10003948,10003779,10004173,10004227,10004172,10004384,10004395,10004432,10004472,10004499,10004533,10004574,10004611,10004637,10004701,10004734,10004766,10004807,10004821,10004879,10004911,10004963,10005005,10005050,10004953,10005141,10005164,10005189,10005244,10005266,10005316,10005543,10005427,10005643,10005541,10005680,10005674,10005793,10005844,10005938,10006014,10005712,10006152,10006298,10006219,10006330,10006439,10006486,10006559,10006581,10006635,10006698,10006776,10006903,10007090,10007117,10007141,10007156,10007193,10007350,10007349,10007348,10007443,10007411,10007390,10007663,10007674,10007714,10007790,10007750,10007823,10007857,10007933,10007962,10007993,10008034,10008030,10005963,10008152,10008161,10005638,10008249,10008089,10008338,10008389,10008362,10008514,10008543,10008561,10008562,10008617,10008669,10008647,10008565,10008705,10008828,10008893,10008944,10000767,10000790,10000774,10000794,10000845,10000826,10000822,10001234,10001252,10001469,10001845,10001989,10002055,10002110,10001226,10002160,10002159,10002136,10002161,10002216,10002248,10002733,10002253,10002993,10002998,10003213,10016989,10000624,10000767,10000725,10000590,10000589,10000531,10000509,10000494,10000774,10000826,10000822,10000794,10000790,10000936,10001378,10001469,10001226,10001661,10001816,10001879,10001845,10001989,10001993,10002055,10002063,10002110,10001252,10001234,10001209,10002136,10002159,10002181,10002160,10002161,10002216,10002218,10002248,10002253,10002733,10002993,10002998,10003124,10003063,10003213,10003307,10003411,10002875,10002914,10003413,10003633,10003683,10003548,10003763,10003847,10003808,10003883,10003899,10003933,10004005,10004045,10004007,10004047,10003948,10003779,10004173,10004227,10004172,10001107,10004384,10004395,10004432,10004472,10004499,10004533,10004611,10004574,10004637,10004701,10004734,10004766,10004879,10004911,10004963,10005005,10005050,10004953,10005141,10005189,10005164,10005244,10005266,10005316,10005543,10005427,10005643,10005541,10005674,10005680,10005793,10005844,10005938,10005887,10005933,10006014,10006152,10006298,10006219,10006330,10006439,10006486,10006559,10006581,10006635,10006903,10006962,10007018,10007062,10007090,10007117,10007141,10007267,10007349,10007348,10007350,1))) ORDER BY `News`.`public_date` DESC, `News`.`approval_date` DESC LIMIT 8 | 8 | 8 | 51 | maybe slow |
Peak Memory Use 8.90 MB
| Message | Memory use |
|---|---|
| Component initialization | 784 KB |
| Controller action start | 1.78 MB |
| Controller render start | 2.25 MB |
| View render complete | 2.68 MB |
Total Request Time: 1048 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 493.41 | |
| Event: Controller.initialize | 55.99 | |
| Event: Controller.startup | 0.32 | |
| Controller action | 142.91 | |
| Event: Controller.beforeRender | 115.41 | |
| » Processing toolbar data | 115.32 | |
| Rendering View | 3.50 | |
| » Event: View.beforeRender | 0.01 | |
| » Rendering APP/View/Article/photo.ctp | 0.45 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/View/Layouts/default.ctp | 2.72 | |
| » » Rendering APP/View/Elements/common_header.ctp | 0.03 | |
| » » Rendering APP/View/Elements/common_footer.ctp | 0.02 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | /var/www/html/staging/app/Config/ |
| HISTORY_LOG | history_log |
| Constant | Value |
|---|---|
| APP | /var/www/html/staging/app/ |
| APP_DIR | app |
| APPLIBS | /var/www/html/staging/app/Lib/ |
| CACHE | /var/www/html/staging/app/tmp/cache/ |
| CAKE | /var/www/html/staging/lib/Cake/ |
| CAKE_CORE_INCLUDE_PATH | /var/www/html/staging/lib |
| CORE_PATH | /var/www/html/staging/lib/ |
| CAKE_VERSION | 2.10.24 |
| CSS | /var/www/html/staging/app/webroot/css/ |
| CSS_URL | css/ |
| DS | / |
| FULL_BASE_URL | https://car-stg.motor-fan.jp |
| IMAGES | /var/www/html/staging/app/webroot/img/ |
| IMAGES_URL | img/ |
| JS | /var/www/html/staging/app/webroot/js/ |
| JS_URL | js/ |
| LOGS | /var/www/html/staging/app/tmp/logs/ |
| ROOT | /var/www/html/staging |
| TESTS | /var/www/html/staging/app/Test/ |
| TMP | /var/www/html/staging/app/tmp/ |
| VENDORS | /var/www/html/staging/vendors/ |
| WEBROOT_DIR | webroot |
| WWW_ROOT | /var/www/html/staging/app/webroot/ |
| Environment Variable | Value |
|---|---|
| Php Version | 7.4.33 |
| User | apache |
| Home | /usr/share/httpd |
| Script Name | /app/webroot/index.php |
| Request Uri | /article/photo/10001071/105964201709261052370000001 |
| Query String | |
| Request Method | GET |
| Server Protocol | HTTP/1.1 |
| Gateway Interface | CGI/1.1 |
| Redirect Url | /app/webroot/article/photo/10001071/105964201709261052370000001 |
| Remote Port | 5391 |
| Script Filename | /var/www/html/staging/app/webroot/index.php |
| Server Admin | root@localhost |
| Context Document Root | /var/www/html/staging |
| Context Prefix | |
| Request Scheme | https |
| Document Root | /var/www/html/staging |
| Remote Addr | 216.73.216.196 |
| Server Port | 443 |
| Server Addr | 160.251.200.204 |
| Server Name | car-stg.motor-fan.jp |
| Server Software | Apache |
| Server Signature | |
| Path | /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin |
| Http Host | car-stg.motor-fan.jp |
| Http Accept Encoding | gzip, br, zstd, deflate |
| Http Cookie | car_mf_app=6q1r6pl7gobv6j39bht8trn0k1 |
| Http User Agent | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| Http Accept | */* |
| Proxy-nokeepalive | 1 |
| Ssl Tls Sni | car-stg.motor-fan.jp |
| Https | on |
| Unique Id | ag21S5AH5VrIJH7nidq3dAAAAQs |
| Redirect Status | 200 |
| Redirect Ssl Tls Sni | car-stg.motor-fan.jp |
| Redirect Https | on |
| Redirect Unique Id | ag21S5AH5VrIJH7nidq3dAAAAQs |
| Redirect Redirect Status | 200 |
| Redirect Redirect Ssl Tls Sni | car-stg.motor-fan.jp |
| Redirect Redirect Https | on |
| Redirect Redirect Unique Id | ag21S5AH5VrIJH7nidq3dAAAAQs |
| Fcgi Role | RESPONDER |
| Php Self | /app/webroot/index.php |
| Request Time Float | 1779283278.5785 |
| Request Time | 1779283278 |