Ankens

案件情報TOP ＞詳細画面


IMA-0045
タイトル	OracleEBS　PL/SQL開発
業種	情報・通信
案件名	OracleEBS、アドオン設計、開発、テスト
作業場所	東京都/23区内
作業工程	詳細設計プログラミングテスト
作業期間	3ヶ月～半年未満
開始時期	翌月以降
職種	システムエンジニアプログラマ DBA 運用/保守
作業内容	PL/SQLを用いた新規開発・単体テスト
年齢制限
募集人数	10
必須スキル	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)
  045
  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: 0 ms
Total Queries: 17 queries

Query	Affected	Num. rows
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` = 45 LIMIT 1	1	1
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` = 45 AND `AnkensFeature`.`feature_id` = `Feature`.`id`)	2	2
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` = 45 AND `AnkensStep`.`step_id` = `Step`.`id`)	3	3
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` = 45 AND `AnkensPeriod`.`period_id` = `Period`.`id`)	1	1
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` = 45 AND `AnkensCategory`.`category_id` = `Category`.`id`)	4	4
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` = 45 AND `AnkensType`.`type_id` = `Type`.`id`)	1	1
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` = 45 AND `AnkensStart`.`start_id` = `Start`.`id`)	1	1
SELECT `Feature`.`id`, `Feature`.`name` FROM `imagine628_imaengineer`.`features` AS `Feature` WHERE 1 = 1	7	7
SELECT `Step`.`id`, `Step`.`name` FROM `imagine628_imaengineer`.`steps` AS `Step` WHERE 1 = 1	8	8
SELECT `Period`.`id`, `Period`.`name` FROM `imagine628_imaengineer`.`periods` AS `Period` WHERE 1 = 1	4	4
SELECT `Category`.`id`, `Category`.`name` FROM `imagine628_imaengineer`.`categories` AS `Category` WHERE 1 = 1	19	19
SELECT `Type`.`id`, `Type`.`name` FROM `imagine628_imaengineer`.`types` AS `Type` WHERE 1 = 1	10	10
SELECT `Start`.`id`, `Start`.`name` FROM `imagine628_imaengineer`.`starts` AS `Start` WHERE 1 = 1	2	2
SELECT `Company`.`id`, `Company`.`name` FROM `imagine628_imaengineer`.`companies` AS `Company` WHERE 1 = 1	24	24
SELECT `Employee`.`id`, `Employee`.`name` FROM `imagine628_imaengineer`.`employees` AS `Employee` WHERE 1 = 1	3	3
SELECT `Location`.`id`, `Location`.`name` FROM `imagine628_imaengineer`.`locations` AS `Location` WHERE 1 = 1	7	7
SELECT `Release`.`id`, `Release`.`name` FROM `imagine628_imaengineer`.`releases` AS `Release` WHERE 1 = 1	2	2

Query Explain:

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

====

Timer

Memory

Peak Memory Use 4.91 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: 73 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.26
Event: Controller.initialize	0.04
Event: Controller.startup	1.02
Controller action	43.89
Event: Controller.beforeRender	8.47
» Processing toolbar data	4.82
Rendering View	4.85
» 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.82
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- ankenData(array)
  Anken(array)
  id45
  nameOracleEBS、アドオン設計、開発、テスト
  titleOracleEBS　PL/SQL開発
  contentsPL/SQLを用いた新規開発・単体テスト
  age
  people10
  skillPL/SQL開発経験者
  note
  company_id12
  employee_id3
  location_id1
  release_id1
  created2021-11-16 15:42:08
  modified2021-11-16 15:42:08
  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)
  id1
  name緊急案件
  release_id1
  created2018-10-01 17:53:32
  modified2018-11-05 18:22:54
  AnkensFeature(array)
  id101
  anken_id45
  feature_id1
  1(array)
  id2
  name大量募集案件
  release_id1
  created2018-10-01 17:53:32
  modified2018-11-05 17:58:23
  AnkensFeature(array)
  id102
  anken_id45
  feature_id2
  Step(array)
  0(array)
  id4
  name詳細設計
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id104
  anken_id45
  step_id4
  1(array)
  id5
  nameプログラミング
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id105
  anken_id45
  step_id5
  2(array)
  id6
  nameテスト
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id106
  anken_id45
  step_id6
  Period(array)
  0(array)
  id2
  name3ヶ月～半年未満
  created2018-10-01 17:54:46
  modified0000-00-00 00:00:00
  AnkensPeriod(array)
  id46
  anken_id45
  period_id2
  Category(array)
  0(array)
  id4
  nameシステムエンジニア
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id84
  anken_id45
  category_id4
  1(array)
  id5
  nameプログラマ
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id85
  anken_id45
  category_id5
  2(array)
  id15
  nameDBA
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id86
  anken_id45
  category_id15
  3(array)
  id16
  name運用/保守
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id87
  anken_id45
  category_id16
  Type(array)
  0(array)
  id3
  name情報・通信
  created2018-10-01 17:50:32
  modified0000-00-00 00:00:00
  AnkensType(array)
  id35
  anken_id45
  type_id3
  Start(array)
  0(array)
  id2
  name翌月以降
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id48
  anken_id45
  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/45/Anken'
Query String	''
Request Method	'GET'
Server Protocol	'HTTP/1.1'
Gateway Interface	'CGI/1.1'
Redirect Url	'/ankens/view/45/Anken'
Remote Port	'54580'
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	'18.118.28.31'
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	'18.118.28.31'
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	'18.118.28.31'
Http Host	'imaengineer.com'
Ngx Cache Staticmode	'1'
Ngx Cache Normalfile	'1'
Failurecachetime	'0'
Https	'on'
Unique Id	'Z2idDPMbtvgqkvttab9zHgAAAG0'
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	'Z2idDPMbtvgqkvttab9zHgAAAG0'
Redirect Mef Proxy Addr	'183.90.242.27'
Fcgi Role	'RESPONDER'
Php Self	'/index.php'
Request Time Float	(float) 1734909196.6262
Request Time	(int) 1734909196

====

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: 0 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: 0 ms
Total Queries: 17 queries