Ankens

案件情報TOP ＞詳細画面


IMA-0043
タイトル	急募　大量！ツール開発サポート　AccessVBA　ExcelVBA
業種
案件名	システム移行ツール開発管理サポート　AccessVBA　ExcelVBA
作業場所	東京都/23区内
作業工程	詳細設計プログラミングテスト
作業期間	半年～1年未満
開始時期	翌月以降
職種	プログラマ運用/保守
作業内容	ツール開発管理サポート
年齢制限
募集人数	数名
必須スキル	AccessVBA　ExcelVBA 　実務経験者
備考
掲載日	2020/07/16

〜特集から探す〜

〜工程から探す〜

〜期間から探す〜

〜職種から探す〜

〜業種から探す〜

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

〜勤務場所から探す〜

↑

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

Cake Params
- plugin(null)
- controllerankens
- actionview
- named(empty)
- pass(array)
  043
  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` = 43 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` = 43 AND `AnkensFeature`.`feature_id` = `Feature`.`id`)	3	3
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` = 43 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` = 43 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` = 43 AND `AnkensCategory`.`category_id` = `Category`.`id`)	2	2
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` = 43 AND `AnkensType`.`type_id` = `Type`.`id`)	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` = 43 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.81 MB

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

Timers

Total Request Time: 79 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.13
Event: Controller.initialize	0.04
Event: Controller.startup	0.35
Controller action	51.42
Event: Controller.beforeRender	8.14
» Processing toolbar data	4.76
Rendering View	4.45
» Event: View.beforeRender	0.02
» Rendering APP/View/Ankens/view.ctp	0.36
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/Main.ctp	3.62
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- ankenData(array)
  Anken(array)
  id43
  nameシステム移行ツール開発管理サポート　AccessVBA　ExcelVBA
  title急募　大量！ツール開発サポート　AccessVBA　ExcelVBA
  contentsツール開発管理サポート
  age
  people数名
  skillAccessVBA　ExcelVBA 　実務経験者
  note
  company_id23
  employee_id3
  location_id1
  release_id1
  created2020-07-16 13:55:29
  modified2020-07-16 13:55:29
  Company(array)
  id23
  nameインターリンク
  created2020-04-03 16:01:29
  modified2020-04-03 16:01:29
  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)
  id96
  anken_id43
  feature_id1
  1(array)
  id2
  name大量募集案件
  release_id1
  created2018-10-01 17:53:32
  modified2018-11-05 17:58:23
  AnkensFeature(array)
  id97
  anken_id43
  feature_id2
  2(array)
  id5
  name長期継続案件
  release_id1
  created2018-10-01 17:53:32
  modified2018-11-05 17:58:39
  AnkensFeature(array)
  id98
  anken_id43
  feature_id5
  Step(array)
  0(array)
  id4
  name詳細設計
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id99
  anken_id43
  step_id4
  1(array)
  id5
  nameプログラミング
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id100
  anken_id43
  step_id5
  2(array)
  id6
  nameテスト
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id101
  anken_id43
  step_id6
  Period(array)
  0(array)
  id3
  name半年～1年未満
  created2018-10-01 17:54:46
  modified0000-00-00 00:00:00
  AnkensPeriod(array)
  id44
  anken_id43
  period_id3
  Category(array)
  0(array)
  id5
  nameプログラマ
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id81
  anken_id43
  category_id5
  1(array)
  id16
  name運用/保守
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id82
  anken_id43
  category_id16
  Type(empty)
  Start(array)
  0(array)
  id2
  name翌月以降
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id45
  anken_id43
  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/43/Anken'
Query String	''
Request Method	'GET'
Server Protocol	'HTTP/1.1'
Gateway Interface	'CGI/1.1'
Redirect Url	'/ankens/view/43/Anken'
Remote Port	'44638'
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.116.89.70'
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.116.89.70'
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.116.89.70'
Http Host	'imaengineer.com'
Ngx Cache Staticmode	'1'
Ngx Cache Normalfile	'1'
Failurecachetime	'0'
Https	'on'
Unique Id	'Z2imj6To8uW0Ta3vr0vazQAAAEI'
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	'Z2imj6To8uW0Ta3vr0vazQAAAEI'
Redirect Mef Proxy Addr	'183.90.242.27'
Fcgi Role	'RESPONDER'
Php Self	'/index.php'
Request Time Float	(float) 1734911631.0402
Request Time	(int) 1734911631

====

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