Eventi

Informativa

Questo sito o gli strumenti terzi da questo utilizzati si avvalgono di cookie necessari al funzionamento ed utili alle finalità illustrate nella cookie policy. Se vuoi saperne di più o negare il consenso a tutti o ad alcuni cookie, consulta la cookie policy.
Chiudendo questo banner, scorrendo questa pagina, cliccando su un link o proseguendo la navigazione in altra maniera, acconsenti all’uso dei cookie.

Calendario Eventi

Anno Precedente Mese Precedente Anno successivo Mese successivo

Dicembre 2024

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734831365,
                "last": 1734831365,
                "now": 1734831365
            },
            "token": "kXpqKvZffYLKPMLod91QvPZN3s4TKnmR"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 14.20 ms / 14.20 ms Memoria: 1.804 MB / 2.18 MB Application: afterLoad

Tempo: 97.67 ms / 111.87 ms Memoria: 5.495 MB / 7.68 MB Application: afterInitialise

Tempo: 14.84 ms / 126.70 ms Memoria: 1.229 MB / 8.90 MB Application: afterRoute

Tempo: 4.34 ms / 131.04 ms Memoria: 0.336 MB / 9.24 MB Application: beforeRenderComponent com_icagenda

Tempo: 359.80 ms / 490.85 ms Memoria: 3.248 MB / 12.49 MB Application: afterRenderComponent com_icagenda

Tempo: 0.47 ms / 491.32 ms Memoria: 0.006 MB / 12.49 MB Application: afterDispatch

Tempo: 14.91 ms / 506.23 ms Memoria: 1.249 MB / 13.74 MB Application: beforeRenderModule mod_custom (Credits)

Tempo: 0.78 ms / 507.01 ms Memoria: 0.023 MB / 13.77 MB Application: afterRenderModule mod_custom (Credits)

Tempo: 0.04 ms / 507.05 ms Memoria: 0.000 MB / 13.77 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tempo: 2.14 ms / 509.19 ms Memoria: 0.093 MB / 13.86 MB Application: afterRenderModule mod_menu (Footer Menu)

Tempo: 0.03 ms / 509.22 ms Memoria: 0.000 MB / 13.86 MB Application: beforeRenderModule mod_custom (Footer)

Tempo: 0.16 ms / 509.38 ms Memoria: 0.003 MB / 13.86 MB Application: afterRenderModule mod_custom (Footer)

Tempo: 0.03 ms / 509.41 ms Memoria: 0.000 MB / 13.86 MB Application: beforeRenderModule mod_login (Accesso Utenti)

Tempo: 2.92 ms / 512.33 ms Memoria: 0.298 MB / 14.16 MB Application: afterRenderModule mod_login (Accesso Utenti)

Tempo: 0.04 ms / 512.37 ms Memoria: 0.002 MB / 14.16 MB Application: beforeRenderModule mod_iccalendar (Calendario Eventi)

Tempo: 11.84 ms / 524.20 ms Memoria: 0.439 MB / 14.60 MB Application: afterRenderModule mod_iccalendar (Calendario Eventi)

Tempo: 0.05 ms / 524.25 ms Memoria: 0.000 MB / 14.53 MB Application: beforeRenderModule mod_search (Cerca)

Tempo: 1.09 ms / 525.34 ms Memoria: 0.020 MB / 14.55 MB Application: afterRenderModule mod_search (Cerca)

Tempo: 0.04 ms / 525.38 ms Memoria: 0.000 MB / 14.55 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 1.21 ms / 526.59 ms Memoria: 0.039 MB / 14.59 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 0.04 ms / 526.63 ms Memoria: 0.000 MB / 14.58 MB Application: beforeRenderModule mod_custom (Slogan)

Tempo: 0.18 ms / 526.81 ms Memoria: 0.003 MB / 14.59 MB Application: afterRenderModule mod_custom (Slogan)

Tempo: 0.03 ms / 526.84 ms Memoria: 0.000 MB / 14.59 MB Application: beforeRenderModule mod_menu (Regione Sicilia)

Tempo: 0.41 ms / 527.25 ms Memoria: 0.007 MB / 14.59 MB Application: afterRenderModule mod_menu (Regione Sicilia)

Tempo: 0.04 ms / 527.29 ms Memoria: 0.000 MB / 14.59 MB Application: beforeRenderModule mod_custom (Cookie)

Tempo: 0.17 ms / 527.46 ms Memoria: 0.003 MB / 14.60 MB Application: afterRenderModule mod_custom (Cookie)

Tempo: 6.65 ms / 534.11 ms Memoria: 0.520 MB / 15.12 MB Application: afterRender

Query totali del database: 30.98 ms

Utilizzo memoria

Query Database

39 query eseguite 30.98 ms

Trovati 9 duplicati!

2 duplicati: #8 #9

3 duplicati: #11 #20 #39

2 duplicati: #16 #18

2 duplicati: #25 #32

Tempo della query: 0.27 ms Memoria query: 0.023 MB memoria prima della query: 3.908 MB Righe restituite: 0

SELECT `data`

  FROM `gran2_session`

  WHERE `session_id` = 'mjuupgcvrnt8f3ha20el8jqcsq'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `data` FROM `#__session` WHERE `session_id` = 'mjuupgcvrnt8f3ha20el8' at line 1

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT\libraries\joomla\session\handler\native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:50
11	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT\libraries\src\Session\Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.19 ms Dopo l'ultima query: 1.06 ms Memoria query: 0.020 MB memoria prima della query: 4.066 MB Righe restituite: 0

SELECT `session_id`

  FROM `gran2_session`

  WHERE `session_id` = 'mjuupgcvrnt8f3ha20el8jqcsq' 
  LIMIT 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `session_id` FROM `#__session` WHERE `session_id` = 'mjuupgcvrnt8f3h' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT\libraries\src\Session\MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.55 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.004 MB memoria prima della query: 4.071 MB

INSERT INTO `gran2_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('mjuupgcvrnt8f3ha20el8jqcsq', 1, 1734831365, 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `gran2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('mjuupgcvrnt8f3ha20el8jqcsq', 1, 1734831365, 0, '', 0)

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
update	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.30 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Session\MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT\libraries\src\Application\CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.35 ms Dopo l'ultima query: 2.50 ms Memoria query: 0.025 MB memoria prima della query: 4.285 MB Righe restituite: 42

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `gran2_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `gr' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.09 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Component\ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT\libraries\src\Component\ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT\libraries\src\Component\ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT\libraries\src\Application\SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.28 ms Dopo l'ultima query: 1.85 ms Memoria query: 0.021 MB memoria prima della query: 4.483 MB Righe restituite: 5

SELECT id, rules

  FROM `gran2_viewlevels`

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, rules FROM `#__viewlevels`' at line 1

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT\libraries\src\Access\Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.26 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.021 MB memoria prima della query: 4.495 MB Righe restituite: 2

SELECT b.id

  FROM gran2_usergroups AS a

  LEFT JOIN gran2_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT b.id FROM #__usergroups AS a LEFT JOIN #__usergroups AS b ON b.lf' at line 1

Profilo

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT\libraries\src\Access\Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT\libraries\src\Access\Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.44 ms Dopo l'ultima query: 0.49 ms Memoria query: 0.030 MB memoria prima della query: 4.564 MB Righe restituite: 82

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM gran2_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.21 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.36 ms Dopo l'ultima query: 13.80 ms Memoria query: 0.022 MB memoria prima della query: 5.666 MB Righe restituite: 1

Query duplicate: #9

SELECT template

  FROM gran2_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT template FROM #__template_styles as s WHERE s.client_id = 0 AND s.ho' at line 1

Profilo

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.41 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.023 MB memoria prima della query: 5.674 MB Righe restituite: 1

Query duplicate: #8

SELECT template

  FROM gran2_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT template FROM #__template_styles as s WHERE s.client_id = 0 AND s.ho' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.19 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT\libraries\rokcommon\RokCommon\PlatformInfo\Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT\libraries\rokcommon\RokCommon\Service.php:71
10	RokCommon_Service::getContainer()	JROOT\libraries\rokcommon\include.php:38
9	require_once JROOT\libraries\rokcommon\include.php	JROOT\plugins\system\rokcommon\rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT\plugins\system\rokcommon\rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.25 ms Dopo l'ultima query: 3.26 ms Memoria query: 0.021 MB memoria prima della query: 5.907 MB Righe restituite: 2

SELECT extension, file, type

  FROM gran2_rokcommon_configs

  ORDER BY priority

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT extension, file, type FROM #__rokcommon_configs ORDER BY priority' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.00 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT\plugins\system\rokcommon\rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT\plugins\system\rokcommon\rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.63 ms Dopo l'ultima query: 8.62 ms Memoria query: 0.026 MB memoria prima della query: 6.893 MB Righe restituite: 151

Query duplicate: #20 #39

SHOW TABLES

Explain

EXPLAIN non possibile sulla query: SHOW TABLES

Profilo

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\database\driver\mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT\plugins\system\jdownloads\jdownloads.php:78
8	plgSystemjdownloads->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 8.15 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.020 MB memoria prima della query: 6.920 MB Righe restituite: 0

SELECT file_id 
  from gran2_jdownloads_files 
  WHERE published = 1 
  AND use_timeframe = 1 
  AND publish_to != '0000-00-00 00:00:00' 
  AND publish_to <= '2024-12-22 04:36:05'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT file_id from #__jdownloads_files WHERE published = 1 AND use_timeframe' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	7.92 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT\plugins\system\jdownloads\jdownloads.php:106
8	plgSystemjdownloads->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.22 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.020 MB memoria prima della query: 6.925 MB Righe restituite: 0

SELECT file_id 
  from gran2_jdownloads_files 
  WHERE published = 0 
  AND use_timeframe = 1 
  AND publish_from != '0000-00-00 00:00:00' 
  AND publish_from <= '2024-12-22 04:36:05'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT file_id from #__jdownloads_files WHERE published = 0 AND use_timeframe' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT\plugins\system\jdownloads\jdownloads.php:114
8	plgSystemjdownloads->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.92 ms Dopo l'ultima query: 2.23 ms Memoria query: 0.026 MB memoria prima della query: 7.083 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `gran2_extensions`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `gran2_extensions`

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.26 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
executing	0.06 ms
checking permissions	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT\libraries\src\Table\Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT\libraries\src\Table\Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\roksprocket\roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.73 ms Memoria query: 0.021 MB memoria prima della query: 7.126 MB Righe restituite: 1

SELECT `extension_id`

  FROM `gran2_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` FROM `#__extensions` WHERE type = 'component' AND ele' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.20 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.021 MB memoria prima della query: 7.133 MB Righe restituite: 1

Query duplicate: #18

SELECT *

  FROM gran2_extensions

  WHERE `extension_id` = '10046'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__extensions WHERE `extension_id` = '10046'' at line 1

Profilo

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.20 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.021 MB memoria prima della query: 7.139 MB Righe restituite: 1

SELECT `extension_id`

  FROM `gran2_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` FROM `#__extensions` WHERE type = 'module' AND elemen' at line 1

Profilo

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT\libraries\src\Table\Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT\plugins\system\roksprocket\roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.19 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.021 MB memoria prima della query: 7.145 MB Righe restituite: 1

Query duplicate: #16

SELECT *

  FROM gran2_extensions

  WHERE `extension_id` = '10046'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__extensions WHERE `extension_id` = '10046'' at line 1

Profilo

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\roksprocket\roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.83 ms Dopo l'ultima query: 22.38 ms Memoria query: 0.136 MB memoria prima della query: 7.859 MB Righe restituite: 99

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM gran2_menu AS m

  LEFT JOIN gran2_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.ty' at line 1

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.43 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\libraries\src\Application\CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.56 ms Dopo l'ultima query: 10.52 ms Memoria query: 0.026 MB memoria prima della query: 8.901 MB Righe restituite: 151

Query duplicate: #11 #39

SHOW TABLES

Explain

EXPLAIN non possibile sulla query: SHOW TABLES

Profilo

Status	Duration
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\database\driver\mysqli.php:502
9	JDatabaseDriverMysqli->getTableList()	JROOT\plugins\system\jdownloads\jdownloads.php:353
8	plgSystemjdownloads->onAfterRoute()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT\libraries\src\Application\SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.23 ms Dopo l'ultima query: 0.50 ms Memoria query: 0.022 MB memoria prima della query: 8.942 MB Righe restituite: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `gran2_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `gr' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1656
14	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.03 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.005 MB memoria prima della query: 8.932 MB

UPDATE `gran2_extensions`

  SET `params` = '{\"mediaversion\":\"c18c7fa779125da71c1e61e187f77a07\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE `#__extensions` SET `params` = '{\"mediaversion\":\"c18c7fa779125da71' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.03 ms
updating	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.77 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1129
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.23 ms Dopo l'ultima query: 1.47 ms Memoria query: 0.020 MB memoria prima della query: 9.149 MB Righe restituite: 2

SELECT *

  FROM gran2_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT * FROM #__languages WHERE published=1 ORDER BY ordering ASC' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\libraries\src\Application\SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT\libraries\src\Application\SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.29 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.081 MB memoria prima della query: 9.161 MB Righe restituite: 3

SELECT id, home, template, s.params

  FROM gran2_template_styles as s

  LEFT JOIN gran2_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN ' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.10 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\Application\SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.83 ms Dopo l'ultima query: 89.25 ms Memoria query: 0.027 MB memoria prima della query: 10.222 MB Righe restituite: 3

Query duplicate: #32

SELECT e.*

  FROM gran2_icagenda_events AS e

  LEFT JOIN gran2_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN gran2_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('it-IT','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

  GROUP BY e.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.* FROM #__icagenda_events AS e LEFT JOIN #__icagenda_category A' at line 1

Profilo

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	3.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.05 ms
executing	0.10 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_icagenda\utilities\events\data.php:257
15	icagendaEventsData::getAllDates()	JROOT\components\com_icagenda\models\list.php:310
14	iCagendaModelList->getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:133
13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_icagenda\models\list.php:382
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.025 MB memoria prima della query: 10.273 MB Righe restituite: 3

SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features

  FROM `gran2_icagenda_events` AS e

  LEFT JOIN gran2_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM gran2_icagenda_feature_xref AS fx

  INNER JOIN gran2_icagenda_feature AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'

  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

  WHERE c.state = 1 
  AND  TRUE  
  AND (e.state IN (0, 1)) 
  AND e.approval <> 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.t' at line 1

Profilo

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
statistics	0.03 ms
preparing	0.08 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_icagenda\models\list.php:382
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.56 ms Dopo l'ultima query: 43.82 ms Memoria query: 0.027 MB memoria prima della query: 10.951 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM gran2_fields AS a

  LEFT JOIN `gran2_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN gran2_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN gran2_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN gran2_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN gran2_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_icagenda.list' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state' at line 1

Profilo

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:333
21	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:135
19	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:488
18	PlgSystemFields->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
17	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
15	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\components\com_icagenda\models\list.php:394
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.33 ms Dopo l'ultima query: 9.10 ms Memoria query: 0.029 MB memoria prima della query: 11.788 MB Righe restituite: 1

SELECT id,template 
  FROM gran2_template_styles 
  WHERE client_id=0 
  AND home=1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id,template FROM #__template_styles WHERE client_id=0 AND home=1' at line 1

Profilo

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1656
27	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_widgetkit\widgetkit.php:23
26	plgContentWidgetkit->{closure}()	JROOT\administrator\components\com_widgetkit\vendor\yootheme\framework\src\Container.php:240
25	YOOtheme\Framework\Container->offsetGet()	JROOT\administrator\components\com_widgetkit\src\Application.php:48
24	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Chiamata uguale alla linea sottostante.
23	call_user_func_array()	JROOT\administrator\components\com_widgetkit\vendor\yootheme\framework\src\Event\EventDispatcher.php:113
22	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT\administrator\components\com_widgetkit\vendor\yootheme\framework\src\Application.php:149
21	YOOtheme\Framework\Application->boot()	JROOT\administrator\components\com_widgetkit\widgetkit.php:67
20	include JROOT\administrator\components\com_widgetkit\widgetkit.php	JROOT\administrator\components\com_widgetkit\widgetkit-app.php:6
19	include JROOT\administrator\components\com_widgetkit\widgetkit-app.php	JROOT\plugins\content\widgetkit\widgetkit.php:9
18	plgContentWidgetkit->onContentPrepare()	JROOT\libraries\joomla\event\event.php:70
17	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT\libraries\cms\html\content.php:41
15	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
13	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
12	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\components\com_icagenda\models\list.php:394
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.30 ms Dopo l'ultima query: 5.91 ms Memoria query: 0.023 MB memoria prima della query: 12.256 MB Righe restituite: 1

SELECT e.params

  FROM `gran2_icagenda_events` AS `e`

  WHERE `e`.`id` = 6

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.params FROM `#__icagenda_events` AS `e` WHERE `e`.`id` = 6' at line 1

Profilo

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:1118
14	icagendaEvent::getParams()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:232
13	icagendaEvent::cancelledButton()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:215
12	icagendaEvent::titleBar()	JROOT\components\com_icagenda\models\list.php:403
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.22 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.023 MB memoria prima della query: 12.265 MB Righe restituite: 1

SELECT e.params

  FROM `gran2_icagenda_events` AS `e`

  WHERE `e`.`id` = 7

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.params FROM `#__icagenda_events` AS `e` WHERE `e`.`id` = 7' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:1118
14	icagendaEvent::getParams()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:232
13	icagendaEvent::cancelledButton()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:215
12	icagendaEvent::titleBar()	JROOT\components\com_icagenda\models\list.php:403
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.19 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 12.275 MB Righe restituite: 1

SELECT e.params

  FROM `gran2_icagenda_events` AS `e`

  WHERE `e`.`id` = 8

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.params FROM `#__icagenda_events` AS `e` WHERE `e`.`id` = 8' at line 1

Profilo

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.02 ms
preparing	0.00 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:1118
14	icagendaEvent::getParams()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:232
13	icagendaEvent::cancelledButton()	JROOT\administrator\components\com_icagenda\utilities\event\event.php:215
12	icagendaEvent::titleBar()	JROOT\components\com_icagenda\models\list.php:403
11	iCagendaModelList->getItems()	JROOT\components\com_icagenda\views\list\view.html.php:64
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.44 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 12.285 MB Righe restituite: 3

Query duplicate: #25

SELECT e.*

  FROM gran2_icagenda_events AS e

  LEFT JOIN gran2_icagenda_category AS c 
  ON c.id = e.catid

  LEFT JOIN gran2_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

  WHERE c.state = 1 
  AND e.state = 1 
  AND  TRUE  
  AND e.language IN ('it-IT','*') 
  AND e.access IN (1, 1, 5) 
  AND e.approval <> 1

  GROUP BY e.id

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.* FROM #__icagenda_events AS e LEFT JOIN #__icagenda_category A' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Creating tmp table	0.05 ms
executing	0.08 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_icagenda\utilities\events\data.php:257
11	icagendaEventsData::getAllDates()	JROOT\components\com_icagenda\views\list\view.html.php:67
10	icagendaViewList->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_icagenda\controller.php:54
8	iCagendaController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_icagenda\icagenda.php:139
6	require_once JROOT\components\com_icagenda\icagenda.php	JROOT\libraries\src\Component\ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.83 ms Dopo l'ultima query: 208.35 ms Memoria query: 0.027 MB memoria prima della query: 13.584 MB Righe restituite: 11

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM gran2_modules AS m

  LEFT JOIN gran2_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN gran2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-12-22 01:36:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 01:36:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 377 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm' at line 1

Profilo

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.06 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.33 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:432
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:362
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:581
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\templates\simpledot\zf\application\gatherers\joomla\guest-views-parameters.php:19
10	require JROOT\templates\simpledot\zf\application\gatherers\joomla\guest-views-parameters.php	JROOT\templates\simpledot\zf\application\ZhongFramework.php:234
9	ZhongFramework->gatherers__joomla__guestViewsParameters()	JROOT\templates\simpledot\zf\application\ZhongFramework.php:72
8	ZhongFramework->__construct()	JROOT\templates\simpledot\index.php:16
7	require JROOT\templates\simpledot\index.php	JROOT\libraries\src\Document\HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.42 ms Dopo l'ultima query: 18.88 ms Memoria query: 0.022 MB memoria prima della query: 14.414 MB Righe restituite: 0

SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
						weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess

  FROM gran2_icagenda_events AS e

  WHERE e.state = 1 
  AND e.next < '2024-12-22 01:36:05' 
  AND e.next > (DATE(NOW() - INTERVAL 2 MONTH))

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEndd' at line 1

Profilo

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_icagenda\utilities\events\data.php:1170
11	icagendaEventsData::getNext()	JROOT\modules\mod_iccalendar\mod_iccalendar.php:131
10	include JROOT\modules\mod_iccalendar\mod_iccalendar.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.21 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.022 MB memoria prima della query: 14.420 MB Righe restituite: 3

SELECT id AS nbevt

  FROM `gran2_icagenda_events` AS e

  WHERE e.state = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT id AS nbevt FROM `#__icagenda_events` AS e WHERE e.state = 1' at line 1

Profilo

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1734
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_iccalendar\helper.php:119
11	modiCcalendarHelper->getStamp()	JROOT\modules\mod_iccalendar\mod_iccalendar.php:175
10	include JROOT\modules\mod_iccalendar\mod_iccalendar.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.38 ms Dopo l'ultima query: 0.44 ms Memoria query: 0.022 MB memoria prima della query: 14.465 MB Righe restituite: 1

SELECT m.title, m.published, m.id, m.params, m.language

  FROM gran2_menu AS m

  WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
  AND (m.published = 1)

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT m.title, m.published, m.id, m.params, m.language FROM #__menu AS m W' at line 1

Profilo

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_icagenda\utilities\menus\menus.php:56
12	icagendaMenus::iClistMenuItemsInfo()	JROOT\modules\mod_iccalendar\helper.php:154
11	modiCcalendarHelper->getStamp()	JROOT\modules\mod_iccalendar\mod_iccalendar.php:175
10	include JROOT\modules\mod_iccalendar\mod_iccalendar.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.54 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 14.480 MB Righe restituite: 0

SELECT e.*,
				e.place as place_name,
				c.title as cat_title,
				c.alias as cat_alias,
				c.color as cat_color,
				c.ordering as cat_order
			,feat.count AS features,r.count AS reg_people, r.date AS reg_date

  FROM `gran2_icagenda_events` AS e

  LEFT JOIN `gran2_icagenda_category` AS c 
  ON `c`.`id` = `e`.`catid`

  LEFT JOIN (
SELECT fx.event_id, COUNT(*) AS count

  FROM `gran2_icagenda_feature_xref` AS fx

  INNER JOIN `gran2_icagenda_feature` AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'

  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

  LEFT JOIN (
SELECT r.eventid, sum(r.people) AS count, r.date AS date

  FROM `gran2_icagenda_registration` AS r

  WHERE r.state > 0

  GROUP BY r.eventid) AS r 
  ON e.id=r.eventid

  WHERE c.state = 1 
  AND e.state = 1 
  AND e.approval = 0 
  AND e.next >= '2024-12-01' 
  AND e.access IN (1, 1, 5) 
  AND e.language IN ('it-IT','*')

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT e.*, e.place as place_name, c.title as cat_title, c.alias as ' at line 1

Profilo

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.07 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.00 ms
optimizing	0.00 ms
statistics	0.00 ms
executing	0.01 ms
statistics	0.04 ms
preparing	0.11 ms
executing	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT\modules\mod_iccalendar\helper.php:272
11	modiCcalendarHelper->getStamp()	JROOT\modules\mod_iccalendar\mod_iccalendar.php:175
10	include JROOT\modules\mod_iccalendar\mod_iccalendar.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.20 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 14.489 MB Righe restituite: 0

SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people

  FROM gran2_icagenda_registration AS r

  WHERE r.state = 1

Explain

Error
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS peo' at line 1

Profilo

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT\administrator\components\com_icagenda\utilities\events\data.php:1565
12	icagendaEventsData::registeredList()	JROOT\modules\mod_iccalendar\helper.php:274
11	modiCcalendarHelper->getStamp()	JROOT\modules\mod_iccalendar\mod_iccalendar.php:175
10	include JROOT\modules\mod_iccalendar\mod_iccalendar.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.71 ms Dopo l'ultima query: 14.53 ms Memoria query: 0.025 MB memoria prima della query: 14.984 MB Righe restituite: 151

Query duplicate: #11 #20

SHOW TABLES

Explain

EXPLAIN non possibile sulla query: SHOW TABLES

Profilo

Status	Duration
checking permissions	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1544
9	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\database\driver\mysqli.php:502
8	JDatabaseDriverMysqli->getTableList()	JROOT\plugins\system\jdownloads\jdownloads.php:253
7	plgSystemjdownloads->onAfterRender()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:1050
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

29 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT e.params
 
  FROM `gran2_icagenda_events` AS `e`

2 × SELECT template
 
  FROM gran2_template_styles as s

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
 
  FROM `gran2_extensions`

2 × SELECT file_id 
  from gran2_jdownloads_files

2 × SELECT `extension_id`
 
  FROM `gran2_extensions`

2 × SELECT *
 
  FROM gran2_extensions

2 × SELECT e.*
 
  FROM gran2_icagenda_events AS e
 
  LEFT JOIN gran2_icagenda_category AS c 
  ON c.id = e.catid
 
  LEFT JOIN gran2_icagenda_customfields_data AS cfd 
  ON cfd.parent_id = e.id

1 × SELECT `data`
 
  FROM `gran2_session`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
 
  FROM gran2_fields AS a
 
  LEFT JOIN `gran2_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN gran2_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN gran2_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN gran2_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN gran2_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT e.*,     e.place as place_name,     c.title as cat_title,     c.alias as cat_alias,     c.color as cat_color,     c.ordering as cat_order    ,feat.count AS features,r.count AS reg_people, r.date AS reg_date
 
  FROM `gran2_icagenda_events` AS e
 
  LEFT JOIN `gran2_icagenda_category` AS c 
  ON `c`.`id` = `e`.`catid`
 
  LEFT JOIN (
 SELECT fx.event_id, COUNT(*) AS count
 
  FROM `gran2_icagenda_feature_xref` AS fx
 
  INNER JOIN `gran2_icagenda_feature` AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'
 
  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id
 
  LEFT JOIN (
 SELECT r.eventid, sum(r.people) AS count, r.date AS date
 
  FROM `gran2_icagenda_registration` AS r

1 × SELECT m.title, m.published, m.id, m.params, m.language
 
  FROM gran2_menu AS m

1 × SELECT id AS nbevt
 
  FROM `gran2_icagenda_events` AS e

1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,       weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
 
  FROM gran2_icagenda_events AS e

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM gran2_modules AS m
 
  LEFT JOIN gran2_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN gran2_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id,template 
  FROM gran2_template_styles

```
1 × SELECT *
 
  FROM gran2_languages
```

1 × SELECT e.*, e.name AS contact_name, e.email AS contact_email,c.id AS cat_id, c.title AS cat_title, c.color AS cat_color, c.desc AS cat_desc,feat.count AS features
 
  FROM `gran2_icagenda_events` AS e
 
  LEFT JOIN gran2_icagenda_category AS c 
  ON c.id = e.catid
 
  LEFT JOIN (
 SELECT fx.event_id, COUNT(*) AS count
 
  FROM gran2_icagenda_feature_xref AS fx
 
  INNER JOIN gran2_icagenda_feature AS f 
  ON fx.feature_id=f.id 
  AND f.state=1 
  AND f.icon<>'-1'
 
  GROUP BY fx.event_id) AS feat 
  ON e.id=feat.event_id

1 × SELECT id, home, template, s.params
 
  FROM gran2_template_styles as s
 
  LEFT JOIN gran2_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `session_id`
 
  FROM `gran2_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
 
  FROM gran2_menu AS m
 
  LEFT JOIN gran2_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT extension, file, type
 
  FROM gran2_rokcommon_configs

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
 
  FROM gran2_extensions

1 × SELECT b.id
 
  FROM gran2_usergroups AS a
 
  LEFT JOIN gran2_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules
 
  FROM `gran2_viewlevels

1 × SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
 
  FROM gran2_icagenda_registration AS r

ALTRE tabelle:

```
3 × SHOW TABLE
```

1 × INSERT INTO `gran2_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('mjuupgcvrnt8f3ha20el8jqcsq', 1, 1734831365, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `gran2_extensions

1 × UPDATE `gran2_extensions`
 
  SET `params` = '{\"mediaversion\":\"c18c7fa779125da71c1e61e187f77a07\"}'

Sito Istituzionale

Eventi Prossimi

Calendario Eventi

Accesso Utenti

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

39 query eseguite 30.98 ms

Trovati 9 duplicati!

29 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

Lun	Mar	Mer	Gio	Ven	Sab	Dom
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30	31

Messaggio di avviso

Sito Istituzionale

Eventi Prossimi

Calendario Eventi

Accesso Utenti

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

39 query eseguite 30.98 ms

Trovati 9 duplicati!

29 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: