Ankens

案件情報TOP ＞詳細画面


IMA-0020
タイトル	急募！　AccessVBA　ExcelVBA
業種
案件名	システム開発支援
作業場所	東京都/23区以外
作業工程	詳細設計プログラミングテスト
作業期間	3ヶ月～半年未満
開始時期	即日翌月以降
職種	プログラマ
作業内容	詳細～テスト
年齢制限
募集人数	1名
必須スキル	AccessVBA、ExcelVBA、SQL
備考
掲載日	2018/11/21

〜特集から探す〜

〜工程から探す〜

〜期間から探す〜

〜職種から探す〜

〜業種から探す〜

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

〜勤務場所から探す〜

↑

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

Cake Params
- plugin(null)
- controllerankens
- actionview
- named(empty)
- pass(array)
  020
  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` = 20 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` = 20 AND `AnkensFeature`.`feature_id` = `Feature`.`id`)	1	1
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` = 20 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` = 20 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` = 20 AND `AnkensCategory`.`category_id` = `Category`.`id`)	1	1
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` = 20 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` = 20 AND `AnkensStart`.`start_id` = `Start`.`id`)	2	2
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.46 MB

Timers

Total Request Time: 58 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	3.94
Event: Controller.initialize	0.04
Event: Controller.startup	0.36
Controller action	27.19
Event: Controller.beforeRender	9.73
» Processing toolbar data	5.68
Rendering View	4.98
» Event: View.beforeRender	0.03
» Rendering APP/View/Ankens/view.ctp	0.45
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/Main.ctp	3.88
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- ankenData(array)
  Anken(array)
  id20
  nameシステム開発支援
  title急募！　AccessVBA　ExcelVBA　
  contents詳細～テスト
  age
  people1名
  skillAccessVBA、ExcelVBA、SQL
  note
  company_id12
  employee_id3
  location_id2
  release_id1
  created2018-11-21 13:33:22
  modified2018-11-21 13:33:22
  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)
  id2
  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)
  id33
  anken_id20
  feature_id1
  Step(array)
  0(array)
  id4
  name詳細設計
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id39
  anken_id20
  step_id4
  1(array)
  id5
  nameプログラミング
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id40
  anken_id20
  step_id5
  2(array)
  id6
  nameテスト
  created2018-10-01 17:57:16
  modified0000-00-00 00:00:00
  AnkensStep(array)
  id41
  anken_id20
  step_id6
  Period(array)
  0(array)
  id2
  name3ヶ月～半年未満
  created2018-10-01 17:54:46
  modified0000-00-00 00:00:00
  AnkensPeriod(array)
  id20
  anken_id20
  period_id2
  Category(array)
  0(array)
  id5
  nameプログラマ
  created2018-10-01 17:44:42
  modified0000-00-00 00:00:00
  AnkensCategory(array)
  id46
  anken_id20
  category_id5
  Type(empty)
  Start(array)
  0(array)
  id1
  name即日
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id18
  anken_id20
  start_id1
  1(array)
  id2
  name翌月以降
  created2018-10-01 17:55:23
  modified0000-00-00 00:00:00
  AnkensStart(array)
  id19
  anken_id20
  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/20/Anken'
Query String	''
Request Method	'GET'
Server Protocol	'HTTP/1.1'
Gateway Interface	'CGI/1.1'
Redirect Url	'/ankens/view/20/Anken'
Remote Port	'41144'
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	'3.147.27.154'
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	'3.147.27.154'
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	'3.147.27.154'
Http Host	'imaengineer.com'
Ngx Cache Staticmode	'1'
Ngx Cache Normalfile	'1'
Failurecachetime	'0'
Https	'on'
Unique Id	'Z2io3nx6h5QjT_tKCW_tvQAAAkY'
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	'Z2io3nx6h5QjT_tKCW_tvQAAAkY'
Redirect Mef Proxy Addr	'183.90.242.27'
Fcgi Role	'RESPONDER'
Php Self	'/index.php'
Request Time Float	(float) 1734912222.5328
Request Time	(int) 1734912222

====

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