{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685488373,
                "last": 1685488373,
                "now": 1685488373
            },
            "token": "Jz8S1QLLAaXbB6ZETBZZXfymAoFu6JVc"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9jYWxlbmRhcmlvL2RldHRhZ2xpZXZlbnRvLzYwOC8tL2lubnNicnVjay1hbHBpbmUtdHJhaWxydW4tZmVzdGl2YWwtazg1Pw%3D%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": {
                "18626d697898d931232e85f1627200ef5d610813": {
                    "link": "https:\/\/www.crageneralirunners.it\/index.php\/calendario\/dettaglievento\/608\/-\/-",
                    "expiry": 1685488374
                }
            }
        },
        "btl_captcha_image_path": "cjRqZmd1Z3MyczViajVocjRsNWplMHZyM3AxNjg1NDg4Mzc2.png",
        "btl_captcha": "sYNLg1"
    }
}

Tempo

Memoria

75 query eseguite 166.31 ms

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

   SELECT `data`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = 'r4jfgugs2s5bj5hr4l5je0vr3p'

   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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   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
   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: 0.31 ms Dopo l'ultima query: 5.49 ms Memoria query: 0.022 MB memoria prima della query: 1.302 MB Righe restituite: 0
   Query duplicate: #56

   SELECT `session_id`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = 'r4jfgugs2s5bj5hr4l5je0vr3p' 
     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.01 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.01 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.01 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: 0.36 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.004 MB memoria prima della query: 1.308 MB

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

   Explain

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

   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
   update	0.04 ms
   Waiting for query cache lock	0.00 ms
   update	0.00 ms
   end	0.00 ms
   query end	0.02 ms
   closing tables	0.01 ms
   freeing items	0.01 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: 0.45 ms Dopo l'ultima query: 33.95 ms Memoria query: 0.023 MB memoria prima della query: 1.420 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.02 ms
   Opening tables	0.01 ms
   System lock	0.02 ms
   init	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.00 ms
   executing	0.00 ms
   Sending data	0.03 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: 0.45 ms Dopo l'ultima query: 0.16 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.02 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.06 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: 0.56 ms Dopo l'ultima query: 235.06 ms Memoria query: 0.006 MB memoria prima della query: 2.669 MB

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.00 ms
   init	0.06 ms
   Updating	0.09 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.01 ms
   query end	0.04 ms
   closing tables	0.03 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: 1.16 ms Dopo l'ultima query: 5.15 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.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.07 ms
   optimizing	0.01 ms
   statistics	0.13 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.42 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/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.86 ms Dopo l'ultima query: 174.44 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.03 ms
   checking permissions	0.01 ms
   Opening tables	0.30 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.03 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.56 ms Dopo l'ultima query: 16.83 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.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]

   ---

10. Tempo della query: 0.35 ms Dopo l'ultima query: 5.00 ms Memoria query: 0.024 MB memoria prima della query: 3.820 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.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]

    ---

11. Tempo della query: 0.53 ms Dopo l'ultima query: 4.67 ms Memoria query: 0.024 MB memoria prima della query: 3.835 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: 0.32 ms Dopo l'ultima query: 4.51 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.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]

    ---

13. Tempo della query: 0.37 ms Dopo l'ultima query: 8.27 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: 1.77 ms Dopo l'ultima query: 29.45 ms Memoria query: 0.032 MB memoria prima della query: 3.989 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.28 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.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.78 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.17 ms Dopo l'ultima query: 117.66 ms Memoria query: 0.032 MB memoria prima della query: 4.063 MB Righe restituite: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM un5gf_modules AS m
    
      LEFT JOIN un5gf_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN un5gf_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-30 23:12:53') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-30 23:12:53') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 321 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	17	Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql936528_1.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql936528_1.m.module,const	1	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.00 ms
    Sorting result	0.15 ms
    Sending data	0.30 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 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:1695
    20	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:22
    15	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:66
    14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
    13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:581
    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.87 ms Dopo l'ultima query: 34.16 ms Memoria query: 0.039 MB memoria prima della query: 4.198 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.08 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.09 ms
    end	0.00 ms
    query end	0.01 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
    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]

    ---

17. Tempo della query: 0.50 ms Dopo l'ultima query: 1.56 ms Memoria query: 0.025 MB memoria prima della query: 4.234 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.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.05 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]

    ---

18. Tempo della query: 3.00 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.050 MB memoria prima della query: 4.243 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 = '608'
     
      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	rr	ref	eventid	eventid	4	const	1
    1	SIMPLE	atd	ref	ev_id,ev_id_2,ev_id_3	ev_id	4	const	1	Using where
    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.16 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
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    init	0.10 ms
    optimizing	0.04 ms
    statistics	1.05 ms
    preparing	0.13 ms
    executing	0.09 ms
    Sending data	0.77 ms
    end	0.01 ms
    removing tmp table	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.05 ms
    freeing items	0.06 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]

    ---

19. Tempo della query: 0.39 ms Dopo l'ultima query: 3.38 ms Memoria query: 0.027 MB memoria prima della query: 4.374 MB Righe restituite: 0

    SELECT *, summary as title, description as content 
      FROM un5gf_jevents_translation 
      WHERE evdet_id IN(608) 
      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.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.01 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
    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]

    ---

20. Tempo della query: 0.78 ms Dopo l'ultima query: 1.28 ms Memoria query: 0.026 MB memoria prima della query: 4.367 MB Righe restituite: 1

    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 = 143

    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.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.22 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
    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]

    ---

21. Tempo della query: 0.92 ms Dopo l'ultima query: 3.35 ms Memoria query: 0.040 MB memoria prima della query: 4.393 MB Righe restituite: 2

    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 `s`
    
      INNER JOIN `un5gf_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_contact' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 45
    
      ORDER BY c.lft

    Explain

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

    Profilo

    Status	Duration
    starting	0.11 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.05 ms
    optimizing	0.02 ms
    statistics	0.13 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.12 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.03 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/src/Categories/Categories.php:324
    24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/router.php:68
    22	ContactRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    13	Joomla\CMS\Router\Route::_()	JROOT/components/com_jevents/libraries/jeventshtml.php:772
    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.53 ms Dopo l'ultima query: 53.90 ms Memoria query: 0.006 MB memoria prima della query: 4.582 MB

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.02 ms
    Updating	0.04 ms
    end	0.00 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.16 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]

    ---

23. Tempo della query: 0.68 ms Dopo l'ultima query: 17.36 ms Memoria query: 0.040 MB memoria prima della query: 4.730 MB Righe restituite: 1

    SELECT * 
      FROM un5gf_jev_attendance 
      WHERE ev_id=608

    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	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.03 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.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
    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]

    ---

24. Tempo della query: 4.22 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.030 MB memoria prima della query: 4.745 MB Righe restituite: 0

    SELECT * 
      FROM un5gf_jev_attendance_translations 
      WHERE atd_id=608 
      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.02 ms
    checking permissions	0.00 ms
    Opening tables	3.70 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.14 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:1656
    20	JDatabaseDriver->loadObject()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:101
    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]

    ---

25. Tempo della query: 0.80 ms Dopo l'ultima query: 27.88 ms Memoria query: 0.028 MB memoria prima della query: 4.781 MB Righe restituite: 1

    SELECT atdcount 
      FROM un5gf_jev_attendeecount as a 
      WHERE a.at_id=608

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	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.20 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    21	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:324
    20	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:330
    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: 1.01 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.033 MB memoria prima della query: 4.792 MB Righe restituite: 1

    Select params 
      from un5gf_jev_rsvp_templates 
      where id=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_jev_rsvp_templates	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

    Profilo

    Status	Duration
    starting	0.01 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.16 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    21	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:344
    20	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:330
    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]

    ---

27. Tempo della query: 1.32 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.814 MB Righe restituite: 1