{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685493552,
                "last": 1685493552,
                "now": 1685493552
            },
            "token": "NBhZZZmCBmrnNdDpKBbNfHFMpuPLM0xm"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9ldmVudGkvZWxlbmNvLWV2ZW50aS1pbi1jYWxlbmRhcmlvPw%3D%3D"
            },
            "published_fv_ses": "0",
            "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": {
                "af1cf46f88e8b9318f494791622a95445ccc6f6b": {
                    "link": "https:\/\/www.crageneralirunners.it\/index.php\/eventi\/elenco-eventi-in-calendario\/list.events\/-?year=2023&month=05&day=31",
                    "expiry": 1685493555
                }
            }
        },
        "btl_captcha_image_path": "ODM3NGd2dGtlOTllb2cyaGNncWNiaTlzZG8xNjg1NDkzNTU2.png",
        "btl_captcha": "BYpCIr"
    }
}

Tempo

Memoria

102 query eseguite 68.65 ms

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

   SELECT `data`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = '8374gvtke99eog2hcgqcbi9sdo'

   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

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   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.34 ms Dopo l'ultima query: 7.52 ms Memoria query: 0.022 MB memoria prima della query: 1.302 MB Righe restituite: 0
   Query duplicate: #92

   SELECT `session_id`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = '8374gvtke99eog2hcgqcbi9sdo' 
     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

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   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.40 ms Dopo l'ultima query: 0.11 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 
   ('8374gvtke99eog2hcgqcbi9sdo', 1, 1685493552, 0, '', 0)

   Explain

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

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   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.40 ms Dopo l'ultima query: 57.09 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.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.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.39 ms Dopo l'ultima query: 0.13 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.00 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.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.02 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.53 ms Dopo l'ultima query: 292.79 ms Memoria query: 0.006 MB memoria prima della query: 2.527 MB

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

   Explain

   EXPLAIN non possibile sulla query: UPDATE `un5gf_extensions` SET `params` = '{\"mediaversion\":\"ed7d6c7834bcb3abc2e91a2a7b9f3e62\"}' 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.08 ms
   Updating	0.07 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.00 ms
   query end	0.03 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
   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.01 ms Dopo l'ultima query: 5.06 ms Memoria query: 0.030 MB memoria prima della query: 2.557 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.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.02 ms
   init	0.05 ms
   optimizing	0.01 ms
   statistics	0.13 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.32 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: 1.04 ms Dopo l'ultima query: 1436.50 ms Memoria query: 0.032 MB memoria prima della query: 3.824 MB Righe restituite: 13

   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-31 00:39:14') 
     AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 00:39:14') 
     AND m.access IN (1,1,5) 
     AND m.client_id = 0 
     AND (mm.menuid = 267 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.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.02 ms
   statistics	0.04 ms
   preparing	0.04 ms
   executing	0.00 ms
   Sorting result	0.10 ms
   Sending data	0.19 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   logging slow query	0.00 ms
   cleaning up	0.01 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/views/default/helpers/defaultgetstartenddates.php:17
   12	Defaultgetstartenddates()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
   11	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/list/view.html.php:33
   10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
   9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
   8	ListController->events()	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]

   ---

9. Tempo della query: 1.08 ms Dopo l'ultima query: 440.28 ms Memoria query: 0.034 MB memoria prima della query: 3.940 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.21 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.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.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.26 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
   24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
   19	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1544
   18	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1399
   17	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
   16	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
   15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
   14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3317
   13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3267
   12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:624
   11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
   10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
   9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
   8	ListController->events()	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]

   ---

10. Tempo della query: 0.91 ms Dopo l'ultima query: 15.82 ms Memoria query: 0.041 MB memoria prima della query: 3.996 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.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.11 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    21	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
    20	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:401
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3317
    13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3267
    12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:624
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

11. Tempo della query: 0.57 ms Dopo l'ultima query: 1.76 ms Memoria query: 0.027 MB memoria prima della query: 4.032 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.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.10 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3317
    13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3267
    12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:624
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

12. Tempo della query: 3.73 ms Dopo l'ultima query: 33.61 ms Memoria query: 0.024 MB memoria prima della query: 4.070 MB Righe restituite: 1

    SELECT count(distinct rpt.rp_id)
     
      FROM un5gf_jevents_repetition as rpt 
     
      INNER JOIN un5gf_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN un5gf_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN un5gf_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN un5gf_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid 
     
      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_jev_attendeecount as atdcnt 
      ON atdcnt.at_id=atd.id 
      AND (atd.allrepeats=1 OR atdcnt.rp_id=rpt.rp_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 rpt.endrepeat >= '2023-05-30 00:00:00' 
      AND rpt.startrepeat <= '2023-07-01 23:59:59'
     
      AND NOT (rpt.startrepeat < '2023-05-30 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1 
      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 ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/dbmodel.php:3451
    13	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/dbmodel.php:3267
    12	JEventsDBModel->countIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:624
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

13. Tempo della query: 3.92 ms Dopo l'ultima query: 1.42 ms Memoria query: 0.063 MB memoria prima della query: 4.097 MB Righe restituite: 4

    SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published, ev.created as created , 
     atdcnt.atdcount as attendeeCount, atd.capacity, atd.waitingcapacity, atdcnt.atdcount as registrationguestcount , 
     atd.regopen, atd.regclose, atd.allrepeats,  atd.allowregistration, GROUP_CONCAT(DISTINCT catmapcat.id 
      ORDER BY catmapcat.lft ASC SEPARATOR ',' ) as catids
     , 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
     
      FROM un5gf_jevents_repetition as rpt 
     
      INNER JOIN un5gf_jevents_vevent as ev 
      ON rpt.eventid = ev.ev_id
     
      INNER JOIN un5gf_jevents_icsfile as icsf 
      ON icsf.ics_id=ev.icsid 
     
      INNER JOIN un5gf_jevents_vevdetail as det 
      ON det.evdet_id = rpt.eventdetail_id
     
      LEFT JOIN un5gf_jevents_rrule as rr 
      ON rr.eventid = rpt.eventid 
     
      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_jev_attendeecount as atdcnt 
      ON atdcnt.at_id=atd.id 
      AND (atd.allrepeats=1 OR atdcnt.rp_id=rpt.rp_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 rpt.endrepeat >= '2023-05-30 00:00:00' 
      AND rpt.startrepeat <= '2023-07-01 23:59:59'
     
      AND NOT (rpt.startrepeat < '2023-05-30 00:00:00' 
      AND det.multiday=0)  
      AND ev.state=1 
      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 ev.access IN (1,1,5)  
      AND icsf.state=1 
      AND icsf.access IN (1,1,5)
     
      GROUP BY rpt.rp_id 
      ORDER BY rpt.startrepeat asc, rpt.endrepeat ASC, det.summary ASC 
      LIMIT 50

    Explain

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

    Profilo

    Status	Duration
    starting	0.23 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
    checking permissions	0.00 ms
    Opening tables	0.04 ms
    System lock	0.01 ms
    init	0.19 ms
    optimizing	0.05 ms
    statistics	0.25 ms
    preparing	0.12 ms
    Creating tmp table	0.54 ms
    executing	0.00 ms
    Copying to tmp table	1.14 ms
    Creating sort index	0.04 ms
    Copying to group table	0.20 ms
    Sorting result	0.03 ms
    Sending data	0.26 ms
    end	0.02 ms
    removing tmp table	0.22 ms
    end	0.00 ms
    removing tmp table	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.05 ms
    freeing items	0.02 ms
    removing tmp table	0.00 ms
    freeing items	0.04 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:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

14. Tempo della query: 0.40 ms Dopo l'ultima query: 4.47 ms Memoria query: 0.028 MB memoria prima della query: 4.257 MB Righe restituite: 0

    SELECT *, summary as title, description as content 
      FROM un5gf_jevents_translation 
      WHERE evdet_id IN(608,632,609,610) 
      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.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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:708
    15	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2968
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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: 0.62 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.041 MB memoria prima della query: 4.267 MB Righe restituite: 4

    SELECT * 
      FROM un5gf_jev_attendance 
      WHERE ev_id in (0,608,632,609,610)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_jev_attendance	range	ev_id,ev_id_2,ev_id_3	ev_id_2	4	NULL	5	Using where

    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.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.07 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:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:494
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.49 ms Dopo l'ultima query: 9.71 ms Memoria query: 0.028 MB memoria prima della query: 4.396 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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:324
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.52 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.028 MB memoria prima della query: 4.408 MB Righe restituite: 1
    Query duplicate: #38  #62  #82

    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.00 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:344
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.53 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.426 MB Righe restituite: 1

    SELECT sum(atdees.atdcount) as waitingcount  
      FROM un5gf_jev_attendees AS atdees 
      WHERE atdees.at_id =608 
      and atdees.waiting=1 
      and atdees.rp_id=0 
      AND (atdees.attendstate=1 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	atdees	ref	at_id,at_id_2	at_id_2	4	const	1	Using where

    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.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.18 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:358
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.55 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.033 MB memoria prima della query: 4.437 MB Righe restituite: 1

    SELECT u.name as name, u.username, a.* 
      FROM un5gf_jev_attendees as a 
      LEFT JOIN un5gf_users as u 
      on u.id=a.user_id 
      WHERE a.at_id=608 
      and a.attendstate!=2 
      and a.attendstate!=3 
      and a.attendstate!=0 
      ORDER BY a.confirmed DESC, a.created asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	at_id,at_id_2	at_id_2	4	const	1	Using where; Using filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.user_id	1

    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.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:432
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.47 ms Dopo l'ultima query: 12.48 ms Memoria query: 0.033 MB memoria prima della query: 4.491 MB Righe restituite: 1

    SELECT w.* 
      FROM un5gf_jev_rsvp_templates AS w 
      WHERE w.id = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	w	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	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.01 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.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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    26	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/models/template.php:417
    25	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    24	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.99 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.038 MB memoria prima della query: 4.510 MB Righe restituite: 16

    SHOW FULL COLUMNS 
      FROM `un5gf_jev_rsvp_templates`

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.23 ms
    System lock	0.01 ms
    init	0.02 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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.18 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
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    31	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    30	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsvppro/tables/template.php:94
    29	TableTemplate->__construct()	JROOT/libraries/src/Table/Table.php:312
    28	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_rsvppro/models/template.php:421
    25	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    24	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.64 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.036 MB memoria prima della query: 4.551 MB Righe restituite: 1
    Query duplicate: #24

    SELECT w.* 
      FROM un5gf_jev_rsvp_fields AS w 
      WHERE w.template_id = 1 
      ORDER BY ordering ASC

    Explain

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

    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
    optimizing	0.00 ms
    statistics	0.21 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.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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/models/template.php:426
    25	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    24	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.43 ms Dopo l'ultima query: 22.61 ms Memoria query: 0.031 MB memoria prima della query: 4.649 MB Righe restituite: 0

    SELECT * 
      FROM un5gf_jev_rsvp_template_translation 
      where template_id = 0 
      AND language = '1'

    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.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.01 ms
    preparing	0.00 ms
    executing	0.01 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    24	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_rsvppro/models/template.php:587
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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: 1.18 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.036 MB memoria prima della query: 4.663 MB Righe restituite: 1
    Query duplicate: #22

    SELECT w.* 
      FROM un5gf_jev_rsvp_fields AS w 
      WHERE w.template_id = 1 
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	w	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	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.02 ms
    preparing	0.01 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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/models/template.php:615
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.38 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.031 MB memoria prima della query: 4.678 MB Righe restituite: 0

    SELECT w.* 
      FROM un5gf_jev_rsvp_fields_translation AS w 
      WHERE w.template_id = 1 
      AND w.language = '1'

    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.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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/models/template.php:620
    23	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    22	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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.40 ms Dopo l'ultima query: 3.45 ms Memoria query: 0.033 MB memoria prima della query: 4.755 MB Righe restituite: 0
    Query duplicate: #34

    SELECT trans.* 
      FROM un5gf_jev_rsvp_transactions AS trans  
      WHERE trans.attendee_id=1772 
      AND trans.paymentstate=1 
      ORDER BY trans.transaction_date DESC

    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.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.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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_rsvppro/models/transactions.php:228
    26	TransactionsModelTransactions->getFeesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1327
    25	JevRsvpParameter->feesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:982
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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: 0.33 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.029 MB memoria prima della query: 4.769 MB Righe restituite: 1

    SELECT `id`
    
      FROM `un5gf_users`
    
      WHERE `id` = '143' 
      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.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.01 ms
    executing	0.00 ms
    Sending data	0.00 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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    27	JDatabaseDriver->loadResult()	JROOT/components/com_jevents/libraries/helper.php:2708
    26	JEVHelper::getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:2144
    25	JevRsvpParameter->getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:985
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

28. Tempo della query: 1.16 ms Dopo l'ultima query: 1.50 ms Memoria query: 0.039 MB memoria prima della query: 4.788 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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.24 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
    Sending data	0.04 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.40 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
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    37	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    36	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    35	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    34	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    33	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    32	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    31	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    30	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    29	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    28	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    27	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    26	JEVHelper::getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:2144
    25	JevRsvpParameter->getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:985
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

29. Tempo della query: 0.38 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.037 MB memoria prima della query: 4.833 MB Righe restituite: 1

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

    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.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.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
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    32	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    31	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    30	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    29	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    28	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    27	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    26	JEVHelper::getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:2144
    25	JevRsvpParameter->getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:985
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

30. Tempo della query: 0.49 ms Dopo l'ultima query: 5.24 ms Memoria query: 0.033 MB memoria prima della query: 4.855 MB Righe restituite: 10

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.05 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.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    logging slow query	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    32	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    31	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    30	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    29	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    28	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    27	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:2715
    26	JEVHelper::getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:2144
    25	JevRsvpParameter->getUser()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:985
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

31. Tempo della query: 0.56 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.031 MB memoria prima della query: 4.868 MB Righe restituite: 27

    SELECT b.id
    
      FROM un5gf_user_usergroup_map AS map
    
      LEFT JOIN un5gf_usergroups AS a 
      ON a.id = map.group_id
    
      LEFT JOIN un5gf_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE map.user_id = 143

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	10	Using index
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.map.group_id	1
    1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	14	Using index

    Profilo

    Status	Duration
    starting	0.04 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.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.15 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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    28	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
    27	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
    26	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
    25	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:996
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

32. Tempo della query: 0.47 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.033 MB memoria prima della query: 4.882 MB Righe restituite: 1
    Query duplicate: #35  #46  #53  #56  #59  #70  #73  #76  #79

    Select * 
      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.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.02 ms
    preparing	0.01 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1120
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

33. Tempo della query: 0.32 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.012 MB memoria prima della query: 4.907 MB
    Query duplicate: #36

    UPDATE un5gf_jev_attendees 
      set attendstate=1, modified='2023-05-31 02:39:14' 
      WHERE id=1772 
      AND attendstate=4

    Explain

    EXPLAIN non possibile sulla query: UPDATE un5gf_jev_attendees set attendstate=1, modified='2023-05-31 02:39:14' WHERE id=1772 AND attendstate=4

    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.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
    25	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1190
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

34. Tempo della query: 0.39 ms Dopo l'ultima query: 10.28 ms Memoria query: 0.033 MB memoria prima della query: 4.963 MB Righe restituite: 0
    Query duplicate: #26

    SELECT trans.* 
      FROM un5gf_jev_rsvp_transactions AS trans  
      WHERE trans.attendee_id=1772 
      AND trans.paymentstate=1 
      ORDER BY trans.transaction_date DESC

    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.02 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.00 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_rsvppro/models/transactions.php:228
    26	TransactionsModelTransactions->getFeesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1327
    25	JevRsvpParameter->feesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:982
    24	JevRsvpParameter->outstandingBalance()	JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php:126
    23	include JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:534
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

35. Tempo della query: 0.46 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.034 MB memoria prima della query: 4.979 MB Righe restituite: 1
    Query duplicate: #32  #46  #53  #56  #59  #70  #73  #76  #79

    Select * 
      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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.02 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.01 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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    25	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1120
    24	JevRsvpParameter->outstandingBalance()	JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php:126
    23	include JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:534
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

36. Tempo della query: 0.32 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.011 MB memoria prima della query: 4.998 MB
    Query duplicate: #33

    UPDATE un5gf_jev_attendees 
      set attendstate=1, modified='2023-05-31 02:39:14' 
      WHERE id=1772 
      AND attendstate=4

    Explain

    EXPLAIN non possibile sulla query: UPDATE un5gf_jev_attendees set attendstate=1, modified='2023-05-31 02:39:14' WHERE id=1772 AND attendstate=4

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.03 ms
    Updating	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
    25	JDatabaseDriverMysqli->execute()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1190
    24	JevRsvpParameter->outstandingBalance()	JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php:126
    23	include JROOT/plugins/jevents/jevrsvppro/rsvppro/tmpl/default/attendee_attendees.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    22	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:534
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

37. Tempo della query: 0.36 ms Dopo l'ultima query: 1.79 ms Memoria query: 0.028 MB memoria prima della query: 4.986 MB Righe restituite: 1

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

    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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:324
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

38. Tempo della query: 0.41 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.028 MB memoria prima della query: 4.997 MB Righe restituite: 1
    Query duplicate: #17  #62  #82

    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.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.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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    22	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:344
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

39. Tempo della query: 0.47 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.028 MB memoria prima della query: 5.014 MB Righe restituite: 1

    SELECT sum(atdees.atdcount) as waitingcount  
      FROM un5gf_jev_attendees AS atdees 
      WHERE atdees.at_id =632 
      and atdees.waiting=1 
      and atdees.rp_id=0 
      AND (atdees.attendstate=1 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	atdees	ref	at_id,at_id_2	at_id	4	const	3	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.10 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    22	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:358
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

40. Tempo della query: 0.56 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.033 MB memoria prima della query: 5.024 MB Righe restituite: 2

    SELECT u.name as name, u.username, a.* 
      FROM un5gf_jev_attendees as a 
      LEFT JOIN un5gf_users as u 
      on u.id=a.user_id 
      WHERE a.at_id=632 
      and a.attendstate!=2 
      and a.attendstate!=3 
      and a.attendstate!=0 
      ORDER BY a.confirmed DESC, a.created asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	at_id,at_id_2	at_id	4	const	3	Using where; Using filesort
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.user_id	1

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 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
    Sorting result	0.03 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.01 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:432
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

41. Tempo della query: 0.36 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.033 MB memoria prima della query: 5.108 MB Righe restituite: 0
    Query duplicate: #55

    SELECT trans.* 
      FROM un5gf_jev_rsvp_transactions AS trans  
      WHERE trans.attendee_id=1809 
      AND trans.paymentstate=1 
      ORDER BY trans.transaction_date DESC

    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.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.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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_rsvppro/models/transactions.php:228
    26	TransactionsModelTransactions->getFeesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:1327
    25	JevRsvpParameter->feesPaid()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:982
    24	JevRsvpParameter->outstandingBalance()	JROOT/administrator/components/com_rsvppro/libraries/attendeehelper.php:1483
    23	RsvpAttendeeHelper->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:799
    22	JevRsvpAttendees->analyseGuests()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:468
    21	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    20	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    19	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    15	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    14	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    13	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3459
    12	JEventsDBModel->listIcalEventsByRange()	JROOT/components/com_jevents/libraries/datamodel.php:641
    11	JEventsDataModel->getRangeData()	JROOT/components/com_jevents/views/default/list/view.html.php:50
    10	DefaultViewList->events()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:91
    9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/list.php:92
    8	ListController->events()	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]

    ---

42. Tempo della query: 0.36 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.029 MB memoria prima della query: 5.122 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