Sućuraj - Noćni život - Nightlife - 2009.

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1772525768,
                "last": 1772525768,
                "now": 1772525768
            },
            "token": "uk7U0IUn9oTzbDzoeUWCbxBG3dkIsjck"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "it-IT"
        },
        "com_mailto": {
            "links": {
                "7c0b592a12c9456ea5198ff666c9707c71cc0b69": {
                    "link": "https://www.sucuraj.com/it/nocni-zivot/2009",
                    "expiry": 1772525769
                }
            }
        }
    }
}

Tempo

Memoria

27 query eseguite 47.52 ms

1. Tempo della query: 1.53 ms Memoria query: 0.023 MB memoria prima della query: 4.171 MB Righe restituite: 0

   SELECT `data`
   
     FROM `suc_session`
   
     WHERE `session_id` = X'3830643061326138366331393234343837383934386333653839366335303132'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profilo

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.93 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 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.08 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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]

   ---

2. Tempo della query: 0.56 ms Dopo l'ultima query: 5.55 ms Memoria query: 0.020 MB memoria prima della query: 4.266 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `suc_session`
   
     WHERE `session_id` = X'3830643061326138366331393234343837383934386333653839366335303132' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

   Profilo

   Status	Duration
   starting	0.13 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 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.08 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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]

   ---

3. Tempo della query: 1.47 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.004 MB memoria prima della query: 4.271 MB

   INSERT INTO `suc_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3830643061326138366331393234343837383934386333653839366335303132', 1, 1772525768, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `suc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3830643061326138366331393234343837383934386333653839366335303132', 1, 1772525768, 0, '', 0)

   Profilo

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   update	0.14 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.92 ms
   closing tables	0.01 ms
   freeing items	0.09 ms
   cleaning up	0.01 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:386
   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]

   ---

4. Tempo della query: 1.54 ms Dopo l'ultima query: 15.82 ms Memoria query: 0.021 MB memoria prima della query: 4.832 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `suc_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_viewlevels	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	NULL

   Profilo

   Status	Duration
   starting	0.12 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	1.07 ms
   init	0.04 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 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.07 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   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:318
   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:225
   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]

   ---

5. Tempo della query: 1.30 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.021 MB memoria prima della query: 4.844 MB Righe restituite: 2

   SELECT b.id
   
     FROM suc_usergroups AS a
   
     LEFT JOIN suc_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profilo

   Status	Duration
   starting	0.13 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.76 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.02 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.07 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   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:318
   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:225
   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]

   ---

6. Tempo della query: 1.66 ms Dopo l'ultima query: 3.13 ms Memoria query: 0.092 MB memoria prima della query: 4.915 MB Righe restituite: 68

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM suc_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1,5)
   
     ORDER BY ordering

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_extensions	NULL	ref	extension	extension	82	const	112	0.60	Using where; Using filesort

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   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:356
   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:225
   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]

   ---

7. Tempo della query: 0.89 ms Dopo l'ultima query: 41.85 ms Memoria query: 0.024 MB memoria prima della query: 10.809 MB Righe restituite: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `suc_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	suc_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{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/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
   8	plgSystemK2->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:1190
   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:225
   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]

   ---

8. Tempo della query: 3.12 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.006 MB memoria prima della query: 10.801 MB

   UPDATE `suc_extensions`
   
     SET `params` = '{\"mediaversion\":\"369480d6c5230c5e658a7b11db4ce760\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `suc_extensions` SET `params` = '{\"mediaversion\":\"369480d6c5230c5e658a7b11db4ce760\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profilo

   Status	Duration
   starting	0.35 ms
   Executing hook on transaction	0.01 ms
   starting	0.02 ms
   checking permissions	0.02 ms
   Opening tables	0.08 ms
   init	0.01 ms
   System lock	0.25 ms
   updating	0.25 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	1.70 ms
   closing tables	0.06 ms
   freeing items	0.19 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:374
   8	plgSystemK2->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:1190
   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:225
   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]

   ---

9. Tempo della query: 3.61 ms Dopo l'ultima query: 4.90 ms Memoria query: 0.026 MB memoria prima della query: 11.468 MB Righe restituite: 4

   SELECT id, home, template, s.params
   
     FROM suc_template_styles as s
   
     LEFT JOIN suc_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

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	16.67	Using where
   1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sucurajh_sucuraj_v2.s.template,const	1	4.50	Using index condition; Using where

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
   19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
   18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
   17	Joomla\CMS\HTML\HTMLHelper::script()	Chiamata uguale alla linea sottostante.
   16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
   13	JHtmlJquery::framework()	Chiamata uguale alla linea sottostante.
   12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
   11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
   10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_k2/helpers/html.php:268
   9	K2HelperHTML::loadHeadIncludes()	JROOT/plugins/system/k2/k2.php:390
   8	plgSystemK2->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:1190
   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:225
   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]

   ---

10. Tempo della query: 1.62 ms Dopo l'ultima query: 6.72 ms Memoria query: 0.025 MB memoria prima della query: 11.573 MB Righe restituite: 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `suc_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_fpss','com_installer','com_jce','com_jckman','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_plugins','com_postinstall','com_redirect','com_redj','com_search','com_sigpro','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	42	100.00	Using index condition

    Profilo

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.78 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.22 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.08 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:15
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

11. Tempo della query: 1.76 ms Dopo l'ultima query: 14.32 ms Memoria query: 0.023 MB memoria prima della query: 12.733 MB Righe restituite: 23

    SELECT id 
      FROM suc_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_categories	NULL	ref	category,published,access,trash,idx_category	trash	2	const	23	96.55	Using where

    Profilo

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.92 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.10 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.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:225
    13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:37
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

12. Tempo della query: 1.51 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.023 MB memoria prima della query: 12.740 MB Righe restituite: 1

    SELECT * 
      FROM suc_k2_items 
      WHERE id=70 
      AND language IN ('it-IT', '*') 
      LIMIT 0, 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_items	NULL	const	PRIMARY,language	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.11 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.97 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 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.03 ms
    freeing items	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:33
    13	K2ModelItem->getData()	JROOT/components/com_k2/views/item/view.html.php:44
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

13. Tempo della query: 1.38 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.027 MB memoria prima della query: 12.787 MB Righe restituite: 14

    SHOW FULL COLUMNS 
      FROM `suc_k2_categories`

    Explain

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

    Profilo

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.00 ms
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.49 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.05 ms
    executing	0.08 ms
    checking permissions	0.06 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.03 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.02 ms
    closing tables	0.03 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
    15	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:328
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:64
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

14. Tempo della query: 0.32 ms Dopo l'ultima query: 0.47 ms Memoria query: 0.023 MB memoria prima della query: 12.825 MB Righe restituite: 1

    SELECT * 
      FROM suc_k2_categories 
      WHERE id = '4'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    init	0.00 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 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.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
    14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:65
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

15. Tempo della query: 0.44 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.025 MB memoria prima della query: 12.915 MB Righe restituite: 8

    SELECT id, name, parent 
      FROM suc_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1,5) 
      AND language IN('it-IT', '*') 
      ORDER BY parent

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_categories	NULL	ref	category,published,access,trash,language,idx_category	trash	2	const	23	39.95	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.08 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.08 ms
    preparing	0.02 ms
    executing	0.07 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.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:932
    16	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:261
    15	K2HelperRoute::findMenuItem()	JROOT/components/com_k2/helpers/route.php:56
    14	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:68
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

16. Tempo della query: 1.08 ms Dopo l'ultima query: 0.68 ms Memoria query: 0.023 MB memoria prima della query: 12.966 MB Righe restituite: 1

    SELECT * 
      FROM suc_k2_categories 
      WHERE id = '1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:61
    14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:87
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

17. Tempo della query: 2.39 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.024 MB memoria prima della query: 12.988 MB Righe restituite: 0

    SELECT * 
      FROM suc_k2_attachments 
      WHERE itemID=70

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_attachments	NULL	ref	itemID	itemID	4	const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1429
    14	K2ModelItem->getItemAttachments()	JROOT/components/com_k2/models/item.php:163
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

18. Tempo della query: 6.44 ms Dopo l'ultima query: 0.67 ms Memoria query: 0.029 MB memoria prima della query: 13.061 MB Righe restituite: 16

    SHOW FULL COLUMNS 
      FROM `suc_users`

    Explain

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

    Profilo

    Status	Duration
    starting	0.33 ms
    Executing hook on transaction	0.01 ms
    starting	1.61 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    Opening tables	1.66 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.07 ms
    statistics	0.29 ms
    preparing	0.09 ms
    Creating tmp table	0.19 ms
    executing	0.23 ms
    checking permissions	0.17 ms
    checking permissions	0.07 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.10 ms
    checking permissions	0.06 ms
    checking permissions	0.07 ms
    checking permissions	0.05 ms
    checking permissions	0.04 ms
    checking permissions	0.05 ms
    checking permissions	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.12 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.05 ms
    closing tables	0.13 ms
    freeing items	0.33 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File e numero di linea
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    20	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
    19	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    18	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

19. Tempo della query: 1.66 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.025 MB memoria prima della query: 13.091 MB Righe restituite: 1

    SELECT *
    
      FROM `suc_users`
    
      WHERE `id` = 404

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

20. Tempo della query: 1.08 ms Dopo l'ultima query: 7.47 ms Memoria query: 0.025 MB memoria prima della query: 13.845 MB Righe restituite: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `suc_usergroups` AS g
    
      INNER JOIN `suc_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 404

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	sucurajh_sucuraj_v2.m.group_id	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.67 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.02 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.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    18	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    17	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    16	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    15	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    14	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:208
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

21. Tempo della query: 1.20 ms Dopo l'ultima query: 2.13 ms Memoria query: 0.024 MB memoria prima della query: 14.025 MB Righe restituite: 1

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM suc_k2_users 
      WHERE userID=404

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_users	NULL	ref	userID	userID	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.23 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.63 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 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.12 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1681
    15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:45
    14	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:211
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

22. Tempo della query: 0.94 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.023 MB memoria prima della query: 14.034 MB Righe restituite: 1

    SELECT COUNT(*) 
      FROM suc_k2_comments 
      WHERE itemID=70 
      AND published=1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_k2_comments	NULL	ref	itemID,published,latestComments,countComments	itemID	4	const	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.55 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.04 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.06 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1468
    14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:225
    13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:83
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

23. Tempo della query: 2.20 ms Dopo l'ultima query: 8.88 ms Memoria query: 0.033 MB memoria prima della query: 14.726 MB Righe restituite: 36

    SHOW FULL COLUMNS 
      FROM `suc_k2_items`

    Explain

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

    Profilo

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.01 ms
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.64 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.11 ms
    preparing	0.03 ms
    Creating tmp table	0.05 ms
    executing	0.09 ms
    checking permissions	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 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.05 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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.10 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:56
    15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:839
    13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

24. Tempo della query: 1.31 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.007 MB memoria prima della query: 14.772 MB

    UPDATE suc_k2_items
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '70'

    Explain

    EXPLAIN non possibile sulla query: UPDATE suc_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '70'

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    14	Joomla\CMS\Table\Table->hit()	JROOT/components/com_k2/models/item.php:840
    13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:146
    12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
    11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:78
    8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:57
    6	require_once JROOT/components/com_k2/k2.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:225
    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]

    ---

25. Tempo della query: 1.62 ms Dopo l'ultima query: 3.99 ms Memoria query: 0.021 MB memoria prima della query: 14.974 MB Righe restituite: 9

    SELECT language,id
    
      FROM `suc_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	suc_menu	NULL	ALL	idx_client_id_parent_id_alias_language	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	810	0.93	Using where

    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.80 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.36 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.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
    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:225
    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]

    ---

26. Tempo della query: 3.50 ms Dopo l'ultima query: 4.25 ms Memoria query: 0.021 MB memoria prima della query: 15.056 MB Righe restituite: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `suc_menu` AS `c`
    
      INNER JOIN `suc_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `suc_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `suc_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 235

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
    9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
    7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
    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:225
    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]

    ---

27. Tempo della query: 1.37 ms Dopo l'ultima query: 12.04 ms Memoria query: 0.024 MB memoria prima della query: 15.580 MB Righe restituite: 5

    SELECT a.*
    
      FROM suc_djimageslider AS a
    
      WHERE a.catid = 13 
      AND a.published = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-03-03 08:16:08') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-03-03 08:16:08')
    
      ORDER BY a.ordering ASC 
      LIMIT 5

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	catid	catid	5	const,const	3	16.00	Using where; Using filesort

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_djimageslider/helper.php:90
    14	modDJImageSliderHelper::getImagesFromDJImageSlider()	JROOT/modules/mod_djimageslider/mod_djimageslider.php:43
    13	include JROOT/modules/mod_djimageslider/mod_djimageslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Chiamata uguale alla linea sottostante.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    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:231
    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]

    ---

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 2 × SELECT * 
     FROM suc_k2_categories

2. 1 × SELECT id, name, parent 
     FROM suc_k2_categories

3. 1 × SELECT `c2`.`language`,`c2`.`id` 
     FROM `suc_menu` AS `c` 
     INNER JOIN `suc_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item' 
     INNER JOIN `suc_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key` 
     INNER JOIN `suc_menu` AS `c2` 
     ON a2.id = c2.`id`

4. 1 × SELECT language,id 
     FROM `suc_menu`

5. 1 × SELECT COUNT(*) 
     FROM suc_k2_comments

6. 1 × SELECT id, gender, description, image, url, `
     group`, plugins 
     FROM suc_k2_users

7. 1 × SELECT `g`.`id`,`g`.`title` 
     FROM `suc_usergroups` AS g 
     INNER JOIN `suc_user_usergroup_map` AS m 
     ON m.group_id = g.id

8. 1 × SELECT * 
     FROM `suc_users`

9. 1 × SELECT * 
     FROM suc_k2_attachments

10. 1 × SELECT `data` 
      FROM `suc_session`

11. 1 × SELECT `session_id` 
      FROM `suc_session`

12. 1 × SELECT * 
      FROM suc_k2_items

13. 1 × SELECT id 
      FROM suc_k2_categories

14. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `suc_assets`

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

16. 1 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
      FROM `suc_extensions`

17. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
      FROM suc_extensions

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

19. 1 × SELECT id, rules 
      FROM `suc_viewlevels

20. 1 × SELECT a.* 
      FROM suc_djimageslider AS a