Gestione Patentini fitofarmaci

L'accesso all'applicazione e' consentito solo agli utenti autorizzati

ENTRA

Apri il form per il login con username e password

Registra nuovo utente

Informazioni su CakePhp

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent3a82a44ae91d4ff114d61f04f0132cf0
  time1736464176
  countdown10
- _Token(array)
  key0960ca4aa17911bf5c1a6484c0539d9d47aef92b
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  0960ca4aa17911bf5c1a6484c0539d9d47aef92b1736451576
====
Request
+
Request

Cake Params
- plugin(null)
- controllerpages
- actiondisplay
- named(empty)
- pass(array)
  0home
- _Token(array)
  key0960ca4aa17911bf5c1a6484c0539d9d47aef92b
  unlockedFields(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  controllerpages
  actiondisplay
  plugin(null)
- template/pages/*
====

Sql Log

Sql Logs

default

Total Time: 2 ms
Total Queries: 3 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `ReportSql`.`id`, `ReportSql`.`name`, `ReportSql`.`strsql`, `ReportSql`.`menu` FROM `0067-DB-FITOFARMACI`.`fs_report_sqls` AS `ReportSql` WHERE `menu` = 1	4	4	1	maybe slow
SELECT `Chart`.`id`, `Chart`.`name`, `Chart`.`chartkinds_id`, `Chart`.`report_sqls_id`, `Chart`.`nomeX`, `Chart`.`nomeY`, `Chart`.`nomeZ`, `Chart`.`menu` FROM `0067-DB-FITOFARMACI`.`fs_charts` AS `Chart` WHERE `Chart`.`report_sqls_id` IN (1, 2, 4, 5)	0	0	1	maybe slow
SELECT `Chart`.`id`, `Chart`.`name`, `Chart`.`chartkinds_id`, `Chart`.`report_sqls_id`, `Chart`.`nomeX`, `Chart`.`nomeY`, `Chart`.`nomeZ`, `Chart`.`menu` FROM `0067-DB-FITOFARMACI`.`fs_charts` AS `Chart` WHERE `Chart`.`menu` = 1	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 4.49 MB

Message	Memory use
Component initialization	1.44 MB
Controller action start	2.69 MB
Controller render start	2.83 MB
View render complete	3.37 MB

Timers

Total Request Time: 28 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	4.65
Event: Controller.initialize	7.93
Event: Controller.startup	0.65
Controller action	0.64
Event: Controller.beforeRender	4.31
» Processing toolbar data	4.21
Rendering View	2.09
» Event: View.beforeRender	0.03
» Rendering APP/View/Pages/home.ctp	0.56
» Event: View.afterRender	0.03
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.01
» » Rendering APP/View/Elements/menu.ctp	0.09
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- pagehome
- subpage(null)
- title_for_layoutHome
- cha(empty)
- rep(array)
  0(array)
  ReportSql(array)
  id1
  nameNuovi rilasci abilitazione
  strsqlSelect count(*) as 'Numero domande' from fs_domandes WHERE tipo_domanda='NUOVO RILASCIO ABILITAZIONE' AND ufficio_territoriale='<tag>ufficio_territoriale</tag>' AND data_rilascio >= DATE_FORMAT(STR_TO_DATE('<tag>inizio_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d') AND data_rilascio <= DATE_FORMAT(STR_TO_DATE('<tag>fine_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d')
  menu1
  Chart(empty)
  1(array)
  ReportSql(array)
  id2
  nameRinnovi rilasci abilitazione
  strsqlSelect count(*) as 'Numero domande' from fs_domandes WHERE tipo_domanda='RINNOVO RILASCIO ABILITAZIONE' AND ufficio_territoriale='<tag>ufficio_territoriale</tag>' AND data_rilascio >= DATE_FORMAT(STR_TO_DATE('<tag>inizio_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d') AND data_rilascio <= DATE_FORMAT(STR_TO_DATE('<tag>fine_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d')
  menu1
  Chart(empty)
  2(array)
  ReportSql(array)
  id4
  nameNuovi rilasci consulente
  strsqlSelect count(*) as 'Numero domande' from fs_domandes WHERE tipo_domanda='NUOVO RILASCIO CONSULENTE' AND ufficio_territoriale='<tag>ufficio_territoriale</tag>' AND data_rilascio >= DATE_FORMAT(STR_TO_DATE('<tag>inizio_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d') AND data_rilascio <= DATE_FORMAT(STR_TO_DATE('<tag>fine_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d')
  menu1
  Chart(empty)
  3(array)
  ReportSql(array)
  id5
  nameRinnovi rilasci consulente
  strsqlSelect count(*) as 'Numero domande' from fs_domandes WHERE tipo_domanda='RINNOVO RILASCIO CONSULENTE' AND ufficio_territoriale='<tag>ufficio_territoriale</tag>' AND data_rilascio >= DATE_FORMAT(STR_TO_DATE('<tag>inizio_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d') AND data_rilascio <= DATE_FORMAT(STR_TO_DATE('<tag>fine_periodo(gg/mm/aaaa)</tag>', '%d/%m/%Y'), '%Y-%m-%d')
  menu1
  Chart(empty)
- $request->data(empty)
- $this->validationErrors(array)
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Page(empty)
  ReportSql(empty)
  Chart(empty)
- Loaded Helpers(array)
  0Js
  1Html
  2Form
  3Session
  4CssMenu
  5Number
  6Ajax
  7SimpleGraph
  8DebugTimer
  9Toolbar
  10Flash
  11HtmlToolbar
====

Environment

App Constants

Constant	Value
MYAPP	/production

CakePHP Constants

Constant	Value
APP	/home/fitofarmaci/public_html/production/
APP_DIR	production
APPLIBS	/home/fitofarmaci/public_html/production/Lib/
CACHE	/home/fitofarmaci/public_html/production/tmp/cache/
CAKE	/home/fitofarmaci/public_html/cake28/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/fitofarmaci/public_html/cake28/lib
CORE_PATH	/home/fitofarmaci/public_html/cake28/lib/
CAKE_VERSION	2.8.0
CSS	/home/fitofarmaci/public_html/production/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://fitofarmaci.ac20.regione.toscana.it
IMAGES	/home/fitofarmaci/public_html/production/webroot/img/
IMAGES_URL	img/
JS	/home/fitofarmaci/public_html/production/webroot/js/
JS_URL	js/
LOGS	/home/fitofarmaci/public_html/production/tmp/logs/
ROOT	/home/fitofarmaci/public_html
TESTS	/home/fitofarmaci/public_html/production/Test/
TMP	/home/fitofarmaci/public_html/production/tmp/
VENDORS	/home/fitofarmaci/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/fitofarmaci/public_html/production/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40-70+ubuntu22.04.1+deb.sury.org+1
User	fitofarmaci
Home	/home/fitofarmaci
Fcgi Role	RESPONDER
Redirect Redirect Script Url	/production/pages/home
Redirect Redirect Script Uri	https://fitofarmaci.ac20.regione.toscana.it/production/pages/home
Redirect Redirect Http2	on
Redirect Redirect H2push	off
Redirect Redirect H2 Push	off
Redirect Redirect H2 Pushed
Redirect Redirect H2 Pushed On
Redirect Redirect H2 Stream Id	3
Redirect Redirect H2 Stream Tag	855233-10545-3
Redirect Redirect Https	on
Redirect Redirect Ssl Tls Sni	fitofarmaci.ac20.regione.toscana.it
Redirect Redirect Status	200
Redirect Script Url	/production/pages/home
Redirect Script Uri	https://fitofarmaci.ac20.regione.toscana.it/production/pages/home
Redirect Http2	on
Redirect H2push	off
Redirect H2 Push	off
Redirect H2 Pushed
Redirect H2 Pushed On
Redirect H2 Stream Id	3
Redirect H2 Stream Tag	855233-10545-3
Redirect Https	on
Redirect Ssl Tls Sni	fitofarmaci.ac20.regione.toscana.it
Redirect Status	200
Script Url	/production/pages/home
Script Uri	https://fitofarmaci.ac20.regione.toscana.it/production/pages/home
Http2	on
H2push	off
H2 Push	off
H2 Pushed
H2 Pushed On
H2 Stream Id	3
H2 Stream Tag	855233-10545-3
Https	on
Ssl Tls Sni	fitofarmaci.ac20.regione.toscana.it
Proxy-nokeepalive	1
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Host	fitofarmaci.ac20.regione.toscana.it
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Server Signature
Server Software	Apache
Server Name	fitofarmaci.ac20.regione.toscana.it
Server Addr	10.157.73.244
Server Port	443
Remote Addr	3.138.123.149
Document Root	/home/fitofarmaci/public_html
Request Scheme	https
Context Prefix
Context Document Root	/home/fitofarmaci/public_html
Server Admin	[no address given]
Script Filename	/home/fitofarmaci/public_html/production/webroot/index.php
Remote Port	62438
Redirect Url	/production/webroot/pages/home
Gateway Interface	CGI/1.1
Server Protocol	HTTP/2.0
Request Method	GET
Query String
Request Uri	/production/pages/home
Script Name	/production/webroot/index.php
Php Self	/production/webroot/index.php
Request Time Float	1736449776.2784
Request Time	1736449776

====

Include
+
Included Files

Include Paths
- 1/usr/share/php
- 2-> /home/fitofarmaci/public_html/cake28/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  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/SecurityComponent.php
  2CORE/Controller/Component/FlashComponent.php
  3CORE/Controller/Component/AuthComponent.php
  4CORE/Controller/Component/AclComponent.php
  5CORE/Controller/Component/Acl/DbAcl.php
  6CORE/Controller/Component/Acl/AclInterface.php
  7CORE/Controller/Component/RequestHandlerComponent.php
  8CORE/Controller/Component/CookieComponent.php
  9CORE/Controller/Component/Auth/CrudAuthorize.php
  10CORE/Controller/Component/Auth/BaseAuthorize.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.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/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/L10n.php
  1CORE/I18n/I18n.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/Permission.php
  1CORE/Model/Model.php
  2CORE/Model/BehaviorCollection.php
  3CORE/Model/Aro.php
  4CORE/Model/AclNode.php
  5CORE/Model/Aco.php
  6CORE/Model/ModelBehavior.php
  7CORE/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/CakeText.php
  5CORE/Utility/ClassRegistry.php
  6CORE/Utility/Security.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/DataTableComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/common.php
  3APP/Config/RegTosc.php
  4APP/Config/routes.php
  5APP/Config/database.php
  Controller(array)
  0APP/Controller/PagesController.php
  1APP/Controller/AppController.php
  Datasource(array)
  0APP/Lib/Model/Datasource/DboSource.php
  Model(array)
  0APP/Model/AppModel.php
  Other(array)
  0APP/webroot/index.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
  Reports(array)
  Model(array)
  0Reports/Model/ReportSql.php
====

Gestione Patentini fitofarmaci

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 2 ms Total Queries: 3 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 2 ms
Total Queries: 3 queries