Ankens

案件情報TOP ＞詳細画面


IMA-0047
タイトル	VB.NET　PLSQL　テレワークを併用
業種
案件名	システムの保守作業
作業場所	東京都/23区内
作業工程	基本設計詳細設計テスト運用
作業期間	半年～1年未満
開始時期	即日翌月以降
職種	システムエンジニアプログラマ WEB系オープン系
作業内容	詳細設計、テスト実施等
年齢制限
募集人数
必須スキル	VB.NET、Oracle（PL/SQL）開発経験
備考
掲載日	2021/11/16

〜特集から探す〜

〜工程から探す〜

〜期間から探す〜

〜職種から探す〜

〜業種から探す〜

〜スタート時期から探す〜

〜勤務場所から探す〜

↑

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerankens
- actionview
- named(empty)
- pass(array)
  047
  1Anken
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(empty)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

Sql Logs

default

Total Time: 1 ms
Total Queries: 17 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Anken`.`id`, `Anken`.`name`, `Anken`.`title`, `Anken`.`contents`, `Anken`.`age`, `Anken`.`people`, `Anken`.`skill`, `Anken`.`note`, `Anken`.`company_id`, `Anken`.`employee_id`, `Anken`.`location_id`, `Anken`.`release_id`, `Anken`.`created`, `Anken`.`modified`, `Company`.`id`, `Company`.`name`, `Company`.`created`, `Company`.`modified`, `Employee`.`id`, `Employee`.`name`, `Employee`.`created`, `Employee`.`modified`, `Location`.`id`, `Location`.`name`, `Location`.`created`, `Location`.`modified`, `Release`.`id`, `Release`.`name`, `Release`.`created`, `Release`.`modified` FROM `imagine628_imaengineer`.`ankens` AS `Anken` LEFT JOIN `imagine628_imaengineer`.`companies` AS `Company` ON (`Anken`.`company_id` = `Company`.`id`) LEFT JOIN `imagine628_imaengineer`.`employees` AS `Employee` ON (`Anken`.`employee_id` = `Employee`.`id`) LEFT JOIN `imagine628_imaengineer`.`locations` AS `Location` ON (`Anken`.`location_id` = `Location`.`id`) LEFT JOIN `imagine628_imaengineer`.`releases` AS `Release` ON (`Anken`.`release_id` = `Release`.`id`) WHERE `Anken`.`id` = 47 LIMIT 1	1	1	0
SELECT `Feature`.`id`, `Feature`.`name`, `Feature`.`release_id`, `Feature`.`created`, `Feature`.`modified`, `AnkensFeature`.`id`, `AnkensFeature`.`anken_id`, `AnkensFeature`.`feature_id` FROM `imagine628_imaengineer`.`features` AS `Feature` JOIN `imagine628_imaengineer`.`ankens_features` AS `AnkensFeature` ON (`AnkensFeature`.`anken_id` = 47 AND `AnkensFeature`.`feature_id` = `Feature`.`id`)	1	1	0
SELECT `Step`.`id`, `Step`.`name`, `Step`.`created`, `Step`.`modified`, `AnkensStep`.`id`, `AnkensStep`.`anken_id`, `AnkensStep`.`step_id` FROM `imagine628_imaengineer`.`steps` AS `Step` JOIN `imagine628_imaengineer`.`ankens_steps` AS `AnkensStep` ON (`AnkensStep`.`anken_id` = 47 AND `AnkensStep`.`step_id` = `Step`.`id`)	4	4	0
SELECT `Period`.`id`, `Period`.`name`, `Period`.`created`, `Period`.`modified`, `AnkensPeriod`.`id`, `AnkensPeriod`.`anken_id`, `AnkensPeriod`.`period_id` FROM `imagine628_imaengineer`.`periods` AS `Period` JOIN `imagine628_imaengineer`.`ankens_periods` AS `AnkensPeriod` ON (`AnkensPeriod`.`anken_id` = 47 AND `AnkensPeriod`.`period_id` = `Period`.`id`)	1	1	0
SELECT `Category`.`id`, `Category`.`name`, `Category`.`created`, `Category`.`modified`, `AnkensCategory`.`id`, `AnkensCategory`.`anken_id`, `AnkensCategory`.`category_id` FROM `imagine628_imaengineer`.`categories` AS `Category` JOIN `imagine628_imaengineer`.`ankens_categories` AS `AnkensCategory` ON (`AnkensCategory`.`anken_id` = 47 AND `AnkensCategory`.`category_id` = `Category`.`id`)	4	4	0
SELECT `Type`.`id`, `Type`.`name`, `Type`.`created`, `Type`.`modified`, `AnkensType`.`id`, `AnkensType`.`anken_id`, `AnkensType`.`type_id` FROM `imagine628_imaengineer`.`types` AS `Type` JOIN `imagine628_imaengineer`.`ankens_types` AS `AnkensType` ON (`AnkensType`.`anken_id` = 47 AND `AnkensType`.`type_id` = `Type`.`id`)	0	0	0
SELECT `Start`.`id`, `Start`.`name`, `Start`.`created`, `Start`.`modified`, `AnkensStart`.`id`, `AnkensStart`.`anken_id`, `AnkensStart`.`start_id` FROM `imagine628_imaengineer`.`starts` AS `Start` JOIN `imagine628_imaengineer`.`ankens_starts` AS `AnkensStart` ON (`AnkensStart`.`anken_id` = 47 AND `AnkensStart`.`start_id` = `Start`.`id`)	2	2	1	maybe slow
SELECT `Feature`.`id`, `Feature`.`name` FROM `imagine628_imaengineer`.`features` AS `Feature` WHERE 1 = 1	7	7	0
SELECT `Step`.`id`, `Step`.`name` FROM `imagine628_imaengineer`.`steps` AS `Step` WHERE 1 = 1	8	8	0
SELECT `Period`.`id`, `Period`.`name` FROM `imagine628_imaengineer`.`periods` AS `Period` WHERE 1 = 1	4	4	0
SELECT `Category`.`id`, `Category`.`name` FROM `imagine628_imaengineer`.`categories` AS `Category` WHERE 1 = 1	19	19	0
SELECT `Type`.`id`, `Type`.`name` FROM `imagine628_imaengineer`.`types` AS `Type` WHERE 1 = 1	10	10	0
SELECT `Start`.`id`, `Start`.`name` FROM `imagine628_imaengineer`.`starts` AS `Start` WHERE 1 = 1	2	2	0
SELECT `Company`.`id`, `Company`.`name` FROM `imagine628_imaengineer`.`companies` AS `Company` WHERE 1 = 1	24	24	0
SELECT `Employee`.`id`, `Employee`.`name` FROM `imagine628_imaengineer`.`employees` AS `Employee` WHERE 1 = 1	3	3	0
SELECT `Location`.`id`, `Location`.`name` FROM `imagine628_imaengineer`.`locations` AS `Location` WHERE 1 = 1	7	7	0
SELECT `Release`.`id`, `Release`.`name` FROM `imagine628_imaengineer`.`releases` AS `Release` WHERE 1 = 1	2	2	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 4.80 MB

Message	Memory use
Component initialization	1.37 MB
Controller action start	1.52 MB
Controller render start	2.87 MB
View render complete	3.47 MB

Timers

Total Request Time: 105 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.20
Event: Controller.initialize	0.06
Event: Controller.startup	0.41
Controller action	73.94
Event: Controller.beforeRender	9.14
» Processing toolbar data	4.92
Rendering View	4.68
» Event: View.beforeRender	0.03
» Rendering APP/View/Ankens/view.ctp	0.44
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/Main.ctp	3.64
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- ankenData(array)
  Anken(array)
  id47
  nameシステムの保守作業
  titleVB.NET　PLSQL　テレワークを併用
  contents詳細設計、テスト実施等
  age
  people
  skillVB.NET、Oracle（PL/SQL）開発経験
  note
  company_id12
  employee_id3
  location_id1
  release_id1
  created2021-11-16 15:48:54
  modified2021-11-16 15:48:54
  Company(array)
  id12
  nameセプト
  created2018-11-21 13:28:58
  modified2018-11-21 13:28:58
  Employee(array)
  id3
  name青木孝徳
  created2018-10-01 17:45:56
  modified0000-00-00 00:00:00
  Location(array)
  id1
  name東京都/23区内
  created2018-10-01 18:20:48
  modified0000-00-00 00:00:00
  Release(array)
  id1
  name公開
  created2018-11-05 18:03:42
  modified0000-00-00 00:00:00
  Feature(array)
  0(array)
  id5
  name長期継続案件
  release_id1
  created2018-10-01 17:53:32
  modified2018-11-05 17:58:39
  AnkensFeature(array)
  id103
  anken_id47
  feature_id5
  Step(array)
  0(array)
  id3
  name基本設計
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id115
  anken_id47
  step_id3
  1(array)
  id4
  name詳細設計
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id116
  anken_id47
  step_id4
  2(array)
  id6
  nameテスト
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id117
  anken_id47
  step_id6
  3(array)
  id7
  name運用
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id118
  anken_id47
  step_id7
  Period(array)
  0(array)
  id3
  name半年～1年未満
  created2018-10-01 17:54:46
  modified0000-00-00 00:00:00
  AnkensPeriod(array)
  id48
  anken_id47
  period_id3
  Category(array)
  0(array)
  id4
  nameシステムエンジニア
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id93
  anken_id47
  category_id4
  1(array)
  id5
  nameプログラマ
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id94
  anken_id47
  category_id5
  2(array)
  id9
  nameWEB系
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id95
  anken_id47
  category_id9
  3(array)
  id10
  nameオープン系
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id96
  anken_id47
  category_id10
  Type(empty)
  Start(array)
  0(array)
  id1
  name即日
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id50
  anken_id47
  start_id1
  1(array)
  id2
  name翌月以降
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id51
  anken_id47
  start_id2
- tablenameAnken
- $request->data(empty)
- $this->validationErrors(array)
  Anken(empty)
  Feature(empty)
  Step(empty)
  Period(empty)
  Category(empty)
  Type(empty)
  Start(empty)
  Company(empty)
  Employee(empty)
  Location(empty)
  Release(empty)
  AnkensFeature(empty)
  AnkensStep(empty)
  AnkensPeriod(empty)
  AnkensCategory(empty)
  AnkensType(empty)
  AnkensStart(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Number
  3SimpleGraph
  4DebugTimer
  5Toolbar
  6html
  7HtmlToolbar
====

Environment

App Constants

No application environment available.

CakePHP Constants

Constant	Value
APP	'/home/imagine628/imaengineer.com/cake/app/'
APP_DIR	'app'
APPLIBS	'/home/imagine628/imaengineer.com/cake/app/Lib/'
CACHE	'/home/imagine628/imaengineer.com/cake/app/tmp/cache/'
CAKE	'/home/imagine628/imaengineer.com/cake/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/home/imagine628/imaengineer.com/cake/lib'
CORE_PATH	'/home/imagine628/imaengineer.com/cake/lib/'
CAKE_VERSION	'2.5.5'
CSS	'/home/imagine628/imaengineer.com/public_html/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'https://imaengineer.com'
IMAGES	'/home/imagine628/imaengineer.com/public_html/img/'
IMAGES_URL	'img/'
JS	'/home/imagine628/imaengineer.com/public_html/js/'
JS_URL	'js/'
LOGS	'/home/imagine628/imaengineer.com/cake/app/tmp/logs/'
ROOT	'/home/imagine628/imaengineer.com/cake'
TESTS	'/home/imagine628/imaengineer.com/cake/app/Test/'
TMP	'/home/imagine628/imaengineer.com/cake/app/tmp/'
VENDORS	'/home/imagine628/imaengineer.com/cake/vendors/'
WEBROOT_DIR	'public_html'
WWW_ROOT	'/home/imagine628/imaengineer.com/public_html/'

PHP Environment

Environment Variable	Value
Php Version	'5.6.40'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin'
Pwd	'/home/userfastcgi/imagine628/imaengineer.com'
Shlvl	'0'
Script Name	'/index.php'
Request Uri	'/ankens/view/47/Anken'
Query String	''
Request Method	'GET'
Server Protocol	'HTTP/1.1'
Gateway Interface	'CGI/1.1'
Redirect Url	'/ankens/view/47/Anken'
Remote Port	'55970'
Script Filename	'/home/imagine628/imaengineer.com/public_html/index.php'
Server Admin	'webmaster@imaengineer.com'
Context Document Root	'/home/imagine628/imaengineer.com/public_html'
Context Prefix	''
Request Scheme	'https'
Document Root	'/home/imagine628/imaengineer.com/public_html'
Remote Addr	'13.58.221.124'
Server Port	'443'
Server Addr	'183.90.242.27'
Server Name	'imaengineer.com'
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.242.27'
Http X Real Ip	'13.58.221.124'
Http X Forwarded Ssl	'on'
Http X Forwarded Port	'443'
Http X Forwarded Host	'imaengineer.com'
Http X Forwarded Proto	'https'
Http X Forwarded For	'13.58.221.124'
Http Host	'imaengineer.com'
Ngx Cache Staticmode	'1'
Ngx Cache Normalfile	'1'
Failurecachetime	'0'
Https	'on'
Unique Id	'Z2ic_a2KsfWwbEGxAPKqFgAACMo'
Mef Proxy Addr	'183.90.242.27'
Redirect Status	'200'
Redirect Ngx Cache Staticmode	'1'
Redirect Ngx Cache Normalfile	'1'
Redirect Failurecachetime	'0'
Redirect Https	'on'
Redirect Unique Id	'Z2ic_a2KsfWwbEGxAPKqFgAACMo'
Redirect Mef Proxy Addr	'183.90.242.27'
Fcgi Role	'RESPONDER'
Php Self	'/index.php'
Request Time Float	(float) 1734909181.4857
Request Time	(int) 1734909181

====

Include
+
Included Files

Include Paths
- 0/home/imagine628/imaengineer.com/cake/lib
- 2/opt/php-5.6.40-3/data/pear
- 3-> /home/imagine628/imaengineer.com/cake/lib/Cake/
Included Files
- core(array)
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/AuthComponent.php
  2CORE/Controller/Component/PaginatorComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/Object.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/AnkensController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/Anken.php
  1APP/Model/AppModel.php
  2APP/Model/Feature.php
  3APP/Model/Step.php
  4APP/Model/Period.php
  5APP/Model/Category.php
  6APP/Model/Type.php
  7APP/Model/Start.php
  8APP/Model/Company.php
  9APP/Model/Employee.php
  10APP/Model/Location.php
  11APP/Model/Release.php
- plugins(array)
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

〜特集から探す〜

〜工程から探す〜

〜期間から探す〜

〜職種から探す〜

〜業種から探す〜

〜スタート時期から探す〜

〜勤務場所から探す〜

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 1 ms Total Queries: 17 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 1 ms
Total Queries: 17 queries