{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685489232,
                "last": 1685489232,
                "now": 1685489232
            },
            "token": "LzGXZmO5KemRXsX66wzTm2qGFO8hZj60"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9jYWxlbmRhcmlvL2RldHRhZ2xpZXZlbnRvLzYzMi8tLzQtcGFzLWluLWRvaT8%3D"
            },
            "justmine_fv_ses": "0"
        },
        "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
        },
        "jsn_original_id": 0,
        "redirectAfterLogin": null,
        "com_mailto": {
            "links": {
                "6a2797bd94406771b6fea6ba2121b3eb43fde303": {
                    "link": "https:\/\/www.crageneralirunners.it\/index.php\/calendario\/dettaglievento\/632\/-\/-",
                    "expiry": 1685489232
                }
            }
        },
        "btl_captcha_image_path": "MGxxbDFsZDJtZmYydDVjcGkwMGhlczlzc24xNjg1NDg5MjM0.png",
        "btl_captcha": "tK2UG8"
    }
}

Tempo

Memoria

82 query eseguite 203.19 ms

1. Tempo della query: 3.87 ms Memoria query: 0.025 MB memoria prima della query: 1.224 MB Righe restituite: 0

   SELECT `data`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = '0lql1ld2mff2t5cpi00hes9ssn'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_session	const	PRIMARY	PRIMARY	194	const	1

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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/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:765
   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:351
   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: 3.87 ms Dopo l'ultima query: 1.49 ms Memoria query: 0.022 MB memoria prima della query: 1.302 MB Righe restituite: 0
   Query duplicate: #64

   SELECT `session_id`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = '0lql1ld2mff2t5cpi00hes9ssn' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_session	const	PRIMARY	PRIMARY	194	const	1	Using index

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.03 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
   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:351
   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: 3.98 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.004 MB memoria prima della query: 1.307 MB

   INSERT INTO `un5gf_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('0lql1ld2mff2t5cpi00hes9ssn', 1, 1685489232, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0lql1ld2mff2t5cpi00hes9ssn', 1, 1685489232, 0, '', 0)

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.01 ms
   update	0.05 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
   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:351
   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: 4.21 ms Dopo l'ultima query: 13.65 ms Memoria query: 0.023 MB memoria prima della query: 1.419 MB Righe restituite: 7

   SELECT id, rules
   
     FROM `un5gf_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.05 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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:203
   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: 4.29 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 1.433 MB Righe restituite: 2

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   logging slow query	0.00 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:203
   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: 2.00 ms Dopo l'ultima query: 132.19 ms Memoria query: 0.006 MB memoria prima della query: 2.669 MB

   UPDATE `un5gf_extensions`
   
     SET `params` = '{\"mediaversion\":\"fb91dcb94292b40d8d356e28daec6871\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.07 ms
   Updating	0.05 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.01 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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/jcomments/jcomments.php:111
   8	plgSystemJComments->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:1129
   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:203
   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: 2.41 ms Dopo l'ultima query: 2.40 ms Memoria query: 0.030 MB memoria prima della query: 2.699 MB Righe restituite: 44

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `un5gf_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativecontactform','com_fields','com_finder','com_gantry','com_igallery','com_installer','com_jce','com_jcomments','com_jevents','com_joomlaupdate','com_jsn','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsvppro','com_search','com_tags','com_templates','com_users','com_wrapper')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_assets	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	261	Using where

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.05 ms
   optimizing	0.01 ms
   statistics	0.13 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.33 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 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/Access/Access.php:429
   13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:140
   8	plgSystemJsn_System->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:1129
   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:203
   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: 0.37 ms Dopo l'ultima query: 78.86 ms Memoria query: 0.024 MB memoria prima della query: 3.775 MB Righe restituite: 1

   SELECT `id`
   
     FROM `un5gf_finder_types`
   
     WHERE `title` = 'Event'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 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/administrator/components/com_finder/helpers/indexer/adapter.php:729
   13	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
   12	FinderIndexerAdapter->__construct()	JROOT/plugins/finder/jevents/jevents3.php:87
   11	plgFinderJEvents->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
   8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
   7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
   6	require_once JROOT/components/com_jevents/jevents.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:203
   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: 0.40 ms Dopo l'ultima query: 14.64 ms Memoria query: 0.024 MB memoria prima della query: 3.805 MB Righe restituite: 1

   SELECT `id`
   
     FROM `un5gf_finder_types`
   
     WHERE `title` = 'Tag'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
   12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
   11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
   8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
   7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
   6	require_once JROOT/components/com_jevents/jevents.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:203
   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: 0.38 ms Dopo l'ultima query: 4.90 ms Memoria query: 0.024 MB memoria prima della query: 3.819 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_finder_types`
    
      WHERE `title` = 'Category'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
    12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
    11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
    8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
    7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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.43 ms Dopo l'ultima query: 5.19 ms Memoria query: 0.024 MB memoria prima della query: 3.834 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_finder_types`
    
      WHERE `title` = 'Contact'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
    12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
    11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
    8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
    7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 4.07 ms Dopo l'ultima query: 8.45 ms Memoria query: 0.024 MB memoria prima della query: 3.849 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_finder_types`
    
      WHERE `title` = 'Article'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
    12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
    11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
    8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
    7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 6.07 ms Dopo l'ultima query: 5.17 ms Memoria query: 0.024 MB memoria prima della query: 3.863 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_finder_types`
    
      WHERE `title` = 'News Feed'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_finder_types	const	title	title	402	const	1	Using index

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
    12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
    11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
    8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
    7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:270
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 6.21 ms Dopo l'ultima query: 12.19 ms Memoria query: 0.032 MB memoria prima della query: 3.988 MB Righe restituite: 18

    SHOW FULL COLUMNS 
      FROM `un5gf_jev_users`

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.20 ms
    System lock	0.01 ms
    init	0.00 ms
    optimizing	0.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.01 ms
    Opening tables	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
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.55 ms
    closing tables	0.00 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
    15	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1544
    14	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:2083
    13	JEVHelper::isEventPublisher()	JROOT/components/com_jevents/libraries/dbmodel.php:553
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 1.01 ms Dopo l'ultima query: 100.71 ms Memoria query: 0.039 MB memoria prima della query: 4.190 MB Righe restituite: 5

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `un5gf_categories` AS `c`
    
      WHERE (c.extension='com_jevents' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	cat_idx,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	28	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.09 ms
    Sending data	0.12 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    16	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
    15	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:401
    13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:587
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.51 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.024 MB memoria prima della query: 4.224 MB Righe restituite: 4

    SELECT c.id
    
      FROM un5gf_categories AS c
    
      WHERE c.access   IN (1,1,5)
     
      AND c.published = 1
      
      AND c.language in ('it-IT','*')
     
      AND c.extension = 'com_jevents'
     
    
      ORDER BY c.lft asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	5	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.06 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
    13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:587
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 15.31 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.057 MB memoria prima della query: 4.234 MB Righe restituite: 1

    SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , GROUP_CONCAT(DISTINCT catmapcat.id 
      ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids, ev.created as created 
     , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
     , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
     , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
     , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn 
     , ev.state as state 
     
      FROM (un5gf_jevents_vevent as ev )
     
      INNER JOIN un5gf_jevents_repetition as rpt 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN un5gf_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN un5gf_jevents_rrule as rr 
      ON rr.eventid = ev.ev_id
     
      INNER JOIN un5gf_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid  
     
      LEFT JOIN un5gf_jev_attendance as atd 
      ON ev.ev_id=atd.ev_id 
      LEFT JOIN un5gf_jev_invitees as inv 
      ON inv.at_id=atd.id 
     
      LEFT JOIN 
     un5gf_jevents_catmap as catmap 
      ON catmap.evid = rpt.eventid 
     
      LEFT JOIN 
     un5gf_categories AS catmapcat 
      ON catmap.catid = catmapcat.id
     
      WHERE 1 
     
      AND ev.access IN (1,1,5) 
      AND icsf.access IN (1,1,5) 
      AND (atd.hidenoninvitees IS NULL
    					OR ev.created_by=0
    					OR atd.hidenoninvitees=0 
    					OR atd.invites=0 
    					OR (atd.invites=1 
      AND atd.hidenoninvitees=1 
      AND inv.email_address='FALSE' 
      AND ((atd.allinvites=1 
      AND inv.rp_id=0) OR (atd.allinvites=0 
      AND inv.rp_id=rpt.rp_id)))) 
      AND  catmap.catid IN(-1,44,49,50,51)
     
      AND rpt.rp_id = '632'
     
      GROUP BY rpt.rp_id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	rpt	const	PRIMARY,eventid,eventstart,eventend,eventdetail	PRIMARY	4	const	1
    1	SIMPLE	det	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ev	const	PRIMARY,icsid,evaccess	PRIMARY	4	const	1
    1	SIMPLE	icsf	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	atd	ref	ev_id,ev_id_2,ev_id_3	ev_id_2	4	const	1	Using where
    1	SIMPLE	rr	ref	eventid	eventid	4	const	4
    1	SIMPLE	catmap	range	key_event_category,key_evid	key_event_category	8	NULL	5	Using where; Using index; Using join buffer
    1	SIMPLE	catmapcat	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.catmap.catid	1
    1	SIMPLE	inv	ref	at_id,at_id_2	at_id	4	Sql936528_1.atd.id	11	Using where

    Profilo

    Status	Duration
    starting	0.17 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	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
    System lock	0.01 ms
    init	0.14 ms
    optimizing	0.04 ms
    statistics	1.24 ms
    preparing	0.07 ms
    executing	12.01 ms
    Sending data	0.85 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.11 ms
    freeing items	0.10 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:634
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.45 ms Dopo l'ultima query: 2.02 ms Memoria query: 0.027 MB memoria prima della query: 4.373 MB Righe restituite: 0

    SELECT *, summary as title, description as content 
      FROM un5gf_jevents_translation 
      WHERE evdet_id IN(632) 
      AND language='it-IT'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:708
    13	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:656
    12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:834
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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.03 ms Dopo l'ultima query: 0.68 ms Memoria query: 0.026 MB memoria prima della query: 4.365 MB Righe restituite: 0

    SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
      CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
      CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug  
     
      FROM un5gf_users AS ju
     
      LEFT JOIN un5gf_contact_details AS cd 
      ON cd.user_id = ju.id 
     
      LEFT JOIN un5gf_categories AS cat 
      ON cat.id = cd.catid 
     
      WHERE block ='0'
     
      AND cd.published =1 
     
      AND cd.access   IN (1,1,5)
     
      AND cat.access   IN (1,1,5)
     
      AND ju.id = 253

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ju	const	PRIMARY,idx_block	PRIMARY	4	const	1
    1	SIMPLE	cd	ref	idx_access,idx_state,idx_catid	idx_state	1	const	98	Using where
    1	SIMPLE	cat	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql936528_1.cd.catid	1	Using where

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sending data	0.32 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 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/components/com_jevents/libraries/helper.php:2649
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:765
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.38 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.025 MB memoria prima della query: 4.375 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_users`
    
      WHERE `id` = '253' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_users	const	PRIMARY	PRIMARY	4	const	1	Using index

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 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/components/com_jevents/libraries/helper.php:2708
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2654
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:765
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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.68 ms Dopo l'ultima query: 2.54 ms Memoria query: 0.034 MB memoria prima della query: 4.388 MB Righe restituite: 16

    SHOW FULL COLUMNS 
      FROM `un5gf_users`

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.31 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.09 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
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.71 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2654
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:765
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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.38 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.031 MB memoria prima della query: 4.428 MB Righe restituite: 1

    SELECT *
    
      FROM `un5gf_users`
    
      WHERE `id` = 253

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_users	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2654
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:765
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.52 ms Dopo l'ultima query: 5.34 ms Memoria query: 0.027 MB memoria prima della query: 4.452 MB Righe restituite: 5

    SELECT `g`.`id`,`g`.`title`
    
      FROM `un5gf_usergroups` AS g
    
      INNER JOIN `un5gf_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 253

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	5	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.m.group_id	1

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2654
    13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:765
    12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:872
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.61 ms Dopo l'ultima query: 38.79 ms Memoria query: 0.006 MB memoria prima della query: 4.631 MB

    UPDATE un5gf_jevents_vevdetail 
      SET hits=(hits+1) 
      WHERE evdet_id='632'

    Explain

    EXPLAIN non possibile sulla query: UPDATE un5gf_jevents_vevdetail SET hits=(hits+1) WHERE evdet_id='632'

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.03 ms
    Updating	0.05 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.19 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/jicaleventdb.php:1101
    12	jIcalEventDB->updateHits()	JROOT/components/com_jevents/libraries/datamodel.php:974
    11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/flat/icalevent/view.html.php:41
    10	flatViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.59 ms Dopo l'ultima query: 28.57 ms Memoria query: 0.040 MB memoria prima della query: 4.779 MB Righe restituite: 1

    SELECT * 
      FROM un5gf_jev_attendance 
      WHERE ev_id=632

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_jev_attendance	ref	ev_id,ev_id_2,ev_id_3	ev_id_2	4	const	1

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    20	JDatabaseDriver->loadObject()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:94
    19	JevRsvpDisplayAttendance->displayCustomFields()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:477
    18	plgJEventsJevrsvppro->onDisplayCustomFields()	JROOT/libraries/joomla/event/event.php:70
    17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php:38
    14	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php:5
    12	include JROOT/components/com_jevents/views/flat/icalevent/tmpl/detail.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:126
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:167
    8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:320
    6	require_once JROOT/components/com_jevents/jevents.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:203
    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: 0.35 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.030 MB memoria prima della query: 4.794 MB Righe restituite: 0