{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685493901,
                "last": 1685493901,
                "now": 1685493901
            },
            "token": "GxmrJeQAQFiyNppCgDfXmMhVIY5ctCS0"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "jevents": {
                "moduleid115": {
                    "shownEventIds": [
                        [
                            "608",
                            "632",
                            "609"
                        ]
                    ],
                    "page": 0,
                    "firstEventDate": "2023-06-03 00:00:00",
                    "lastEventDate": "2023-06-22 00:00:00"
                }
            },
            "published_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,
        "btl_captcha_image_path": "dWZ0MTAzdnBibmM5bDdzNTFpY25nZ2w0dmwxNjg1NDkzOTAz.png",
        "btl_captcha": "81LSut"
    }
}

Tempo

Memoria

103 query eseguite 66.95 ms

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

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

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

   SELECT `session_id`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = 'uft103vpbnc9l7s51icnggl4vl' 
     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.37 ms Dopo l'ultima query: 0.21 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 
   ('uft103vpbnc9l7s51icnggl4vl', 1, 1685493901, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('uft103vpbnc9l7s51icnggl4vl', 1, 1685493901, 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.91 ms Dopo l'ultima query: 186.93 ms Memoria query: 0.051 MB memoria prima della query: 1.352 MB Righe restituite: 44

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `un5gf_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_extensions	ref	extension	extension	82	const	44	Using where

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.37 ms Dopo l'ultima query: 24.08 ms Memoria query: 0.023 MB memoria prima della query: 1.419 MB Righe restituite: 7

   SELECT id, rules
   
     FROM `un5gf_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.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.00 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]

   ---

6. Tempo della query: 0.46 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.022 MB memoria prima della query: 1.432 MB Righe restituite: 2

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

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   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]

   ---

7. Tempo della query: 1.47 ms Dopo l'ultima query: 22.69 ms Memoria query: 0.035 MB memoria prima della query: 1.519 MB Righe restituite: 121

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_extensions	ref	extension	extension	82	const	160	Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.04 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sorting result	0.43 ms
   Sending data	0.34 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.56 ms Dopo l'ultima query: 206.07 ms Memoria query: 0.076 MB memoria prima della query: 2.148 MB Righe restituite: 41

   SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
   
     FROM un5gf_menu AS m
   
     LEFT JOIN un5gf_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	45	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.m.component_id	1

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
   14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
   13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
   12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
   11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:382
   10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
   9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
   8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
   7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:498
   6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
   5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1080
   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]

   ---

9. Tempo della query: 0.48 ms Dopo l'ultima query: 93.49 ms Memoria query: 0.027 MB memoria prima della query: 2.493 MB Righe restituite: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	un5gf_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 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
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
   16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/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]

   ---

10. Tempo della query: 0.50 ms Dopo l'ultima query: 4.58 ms Memoria query: 0.006 MB memoria prima della query: 2.486 MB

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
    8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1129
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 1.03 ms Dopo l'ultima query: 4.87 ms Memoria query: 0.029 MB memoria prima della query: 2.516 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.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.00 ms
    statistics	0.11 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.29 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]

    ---

12. Tempo della query: 0.57 ms Dopo l'ultima query: 10.67 ms Memoria query: 0.025 MB memoria prima della query: 2.675 MB Righe restituite: 2

    SELECT *
    
      FROM un5gf_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	un5gf_languages	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where; Using filesort

    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.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 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
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tempo della query: 0.70 ms Dopo l'ultima query: 34.09 ms Memoria query: 0.033 MB memoria prima della query: 2.690 MB Righe restituite: 4

    SELECT id, home, template, s.params
    
      FROM un5gf_template_styles as s
    
      LEFT JOIN un5gf_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Sql936528_1.s.template,const	1	Using where

    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.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 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
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.52 ms Dopo l'ultima query: 131.68 ms Memoria query: 0.026 MB memoria prima della query: 3.030 MB Righe restituite: 0

    SELECT
    					sp.id,
    					st.name as type
    					
      FROM
    					`un5gf_creative_fields` sp
    					JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    					
      WHERE sp.published = '1'
    					
      AND sp.id_form = '6'
    					
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	1	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 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
    Sorting result	0.02 ms
    Sending data	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    16	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
    15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
    13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
    10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_creativecontactform/controller.php:34
    8	CreativeContactFormController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
    6	require_once JROOT/components/com_creativecontactform/creativecontactform.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 1.09 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.037 MB memoria prima della query: 3.040 MB Righe restituite: 0

    SELECT
    					sp.`id_template`,
    					sp.name,
    					sp.top_text,
    					sp.pre_text,
    					sp.thank_you_text,
    					sp.send_text,
    					sp.send_new_text,
    					sp.close_alert_text,
    					sp.form_width,
    					sp.redirect,
    					sp.redirect_itemid,
    					sp.redirect_url,
    					sp.redirect_delay,
    					sp.shake_count,
    					sp.shake_distanse,
    					sp.send_copy_enable,
    					sp.send_copy_text,
    					sp.shake_duration,
    					sp.custom_css,
    					st.styles,
    
    					sp.render_type,
    					sp.popup_button_text,
    					sp.static_button_position,
    					sp.static_button_offset,
    					sp.appear_animation_type,
    					sp.check_token,
    					sp.next_button_text,
    					sp.prev_button_text
    
    					
      FROM
    					`un5gf_creative_forms` sp
    					
      LEFT JOIN `un5gf_contact_templates` st 
      ON st.id = sp.id_template
    					
      WHERE sp.published = '1'
    					
      AND sp.id = '6'

    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.09 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.49 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    16	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
    15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
    13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
    10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_creativecontactform/controller.php:34
    8	CreativeContactFormController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
    6	require_once JROOT/components/com_creativecontactform/creativecontactform.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.65 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.040 MB memoria prima della query: 3.050 MB Righe restituite: 0

    SELECT
    					sp.id,
    					sp.name,
    					sp.tooltip_text,
    					sp.required,
    					sp.ordering_field,
    					sp.select_default_text,
    					sp.show_parent_label,
    					sp.select_no_match_text,
    					sp.width,
    					sp.field_margin_top,
    					sp.select_show_scroll_after,
    					sp.select_show_search_after,
    					sp.upload_button_text,
    					sp.upload_minfilesize,
    					sp.upload_maxfilesize,
    					sp.upload_acceptfiletypes,
    					sp.upload_minfilesize_message,
    					sp.upload_maxfilesize_message,
    					sp.upload_acceptfiletypes_message,
    					sp.captcha_wrong_message,
    
    					sp.datepicker_date_format,
    					sp.datepicker_animation,
    					sp.datepicker_style,
    					sp.datepicker_icon_style,
    					sp.datepicker_show_icon,
    					sp.datepicker_input_readonly,
    					sp.datepicker_number_months,
    					sp.datepicker_mindate,
    					sp.datepicker_maxdate,
    					sp.datepicker_changemonths,
    					sp.datepicker_changeyears,
    					sp.column_type,
    					sp.custom_html,
    					sp.google_maps,
    					sp.heading,
    					sp.recaptcha_site_key,
    					sp.recaptcha_wrong_message,
    					sp.recaptcha_theme,
    					sp.recaptcha_type,
    					sp.contact_data,
    					sp.contact_data_width,
    					sp.creative_popup,
    					sp.creative_popup_embed,
    
    					st.name as type
    				
      FROM
    					`un5gf_creative_fields` sp
    				JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    				
      WHERE sp.published = '1'
    				
      AND sp.id_form = '6'
    				
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	1	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.05 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.03 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:1500
    16	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:344
    15	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    14	CreativecontactformHelper->render_html()	JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php:23
    13	include JROOT/components/com_creativecontactform/views/creativecontactform/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_creativecontactform/views/creativecontactform/view.html.php:21
    10	CreativeContactFormViewCreativecontactform->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_creativecontactform/controller.php:34
    8	CreativeContactFormController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_creativecontactform/creativecontactform.php:32
    6	require_once JROOT/components/com_creativecontactform/creativecontactform.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: 1.16 ms Dopo l'ultima query: 53.98 ms Memoria query: 0.032 MB memoria prima della query: 3.183 MB Righe restituite: 14

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM un5gf_modules AS m
    
      LEFT JOIN un5gf_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN un5gf_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-31 00:45:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 00:45:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 269 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.02 ms
    executing	0.00 ms
    Sorting result	0.12 ms
    Sending data	0.19 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.04 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    16	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    15	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    14	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:335
    12	sboostHelper->hasModule()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:354
    11	sboostHelper->getModules()	JROOT/templates/mx_joomla180/lib/framework/features/cpanel.php:13
    10	require_once JROOT/templates/mx_joomla180/lib/framework/features/cpanel.php	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:54
    9	sboostHelper->import()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:146
    8	sboostHelper->addFeatures()	JROOT/templates/mx_joomla180/index.php:65
    7	require JROOT/templates/mx_joomla180/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.48 ms Dopo l'ultima query: 12.11 ms Memoria query: 0.028 MB memoria prima della query: 3.319 MB Righe restituite: 1

    SELECT id, title, module, position, content, showtitle, params
    
      FROM un5gf_modules AS m
    
      WHERE m.published = 1 
      AND m.id = 131 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-05-31 00:45:02') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 00:45:02') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0
    
      ORDER BY position, ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:627
    16	SboostMenu->loadModule()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:253
    15	SboostMenu->loadSubContent()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:236
    14	SboostMenu->genMenuItem()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:558
    13	SboostMenu->genMenuItems()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:479
    12	SboostMenu->genMenu()	JROOT/templates/mx_joomla180/lib/framework/base/frame.menu.php:510
    11	SboostMenu->showMenu()	JROOT/templates/mx_joomla180/lib/framework/features/hormenu.php:13
    10	require_once JROOT/templates/mx_joomla180/lib/framework/features/hormenu.php	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:54
    9	sboostHelper->import()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:146
    8	sboostHelper->addFeatures()	JROOT/templates/mx_joomla180/index.php:86
    7	require JROOT/templates/mx_joomla180/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.42 ms Dopo l'ultima query: 85.71 ms Memoria query: 0.024 MB memoria prima della query: 3.629 MB Righe restituite: 1
    Query duplicate: #2

    SELECT `session_id`
    
      FROM `un5gf_session`
    
      WHERE `session_id` = 'uft103vpbnc9l7s51icnggl4vl' 
      LIMIT 1

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.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.02 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
    13	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
    12	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
    11	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
    10	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
    9	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/templates/mx_joomla180/lib/framework/base/frame.helper.php:220
    8	sboostHelper->showSlideItem()	JROOT/templates/mx_joomla180/index.php:95
    7	require JROOT/templates/mx_joomla180/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.86 ms Dopo l'ultima query: 30.36 ms Memoria query: 0.024 MB memoria prima della query: 3.694 MB Righe restituite: 4
    Query duplicate: #23

    SELECT
    					sp.id,
    					st.name as type
    					
      FROM
    					`un5gf_creative_fields` sp
    					JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    					
      WHERE sp.published = '1'
    					
      AND sp.id_form = '1'
    					
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    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.26 ms
    Sending data	0.16 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
    12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.62 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.035 MB memoria prima della query: 3.704 MB Righe restituite: 1
    Query duplicate: #24

    SELECT
    					sp.`id_template`,
    					sp.name,
    					sp.top_text,
    					sp.pre_text,
    					sp.thank_you_text,
    					sp.send_text,
    					sp.send_new_text,
    					sp.close_alert_text,
    					sp.form_width,
    					sp.redirect,
    					sp.redirect_itemid,
    					sp.redirect_url,
    					sp.redirect_delay,
    					sp.shake_count,
    					sp.shake_distanse,
    					sp.send_copy_enable,
    					sp.send_copy_text,
    					sp.shake_duration,
    					sp.custom_css,
    					st.styles,
    
    					sp.render_type,
    					sp.popup_button_text,
    					sp.static_button_position,
    					sp.static_button_offset,
    					sp.appear_animation_type,
    					sp.check_token,
    					sp.next_button_text,
    					sp.prev_button_text
    
    					
      FROM
    					`un5gf_creative_forms` sp
    					
      LEFT JOIN `un5gf_contact_templates` st 
      ON st.id = sp.id_template
    					
      WHERE sp.published = '1'
    					
      AND sp.id = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1
    1	SIMPLE	st	const	PRIMARY	PRIMARY	3	const	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.00 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
    12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.73 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.041 MB memoria prima della query: 3.721 MB Righe restituite: 4
    Query duplicate: #25

    SELECT
    					sp.id,
    					sp.name,
    					sp.tooltip_text,
    					sp.required,
    					sp.ordering_field,
    					sp.select_default_text,
    					sp.show_parent_label,
    					sp.select_no_match_text,
    					sp.width,
    					sp.field_margin_top,
    					sp.select_show_scroll_after,
    					sp.select_show_search_after,
    					sp.upload_button_text,
    					sp.upload_minfilesize,
    					sp.upload_maxfilesize,
    					sp.upload_acceptfiletypes,
    					sp.upload_minfilesize_message,
    					sp.upload_maxfilesize_message,
    					sp.upload_acceptfiletypes_message,
    					sp.captcha_wrong_message,
    
    					sp.datepicker_date_format,
    					sp.datepicker_animation,
    					sp.datepicker_style,
    					sp.datepicker_icon_style,
    					sp.datepicker_show_icon,
    					sp.datepicker_input_readonly,
    					sp.datepicker_number_months,
    					sp.datepicker_mindate,
    					sp.datepicker_maxdate,
    					sp.datepicker_changemonths,
    					sp.datepicker_changeyears,
    					sp.column_type,
    					sp.custom_html,
    					sp.google_maps,
    					sp.heading,
    					sp.recaptcha_site_key,
    					sp.recaptcha_wrong_message,
    					sp.recaptcha_theme,
    					sp.recaptcha_type,
    					sp.contact_data,
    					sp.contact_data_width,
    					sp.creative_popup,
    					sp.creative_popup_embed,
    
    					st.name as type
    				
      FROM
    					`un5gf_creative_fields` sp
    				JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    				
      WHERE sp.published = '1'
    				
      AND sp.id_form = '1'
    				
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    Profilo

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.04 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.08 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:344
    12	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:739
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.48 ms Dopo l'ultima query: 0.57 ms Memoria query: 0.025 MB memoria prima della query: 3.780 MB Righe restituite: 4
    Query duplicate: #20

    SELECT
    					sp.id,
    					st.name as type
    					
      FROM
    					`un5gf_creative_fields` sp
    					JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    					
      WHERE sp.published = '1'
    					
      AND sp.id_form = '1'
    					
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    14	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:229
    13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
    12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.64 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.036 MB memoria prima della query: 3.790 MB Righe restituite: 1
    Query duplicate: #21

    SELECT
    					sp.`id_template`,
    					sp.name,
    					sp.top_text,
    					sp.pre_text,
    					sp.thank_you_text,
    					sp.send_text,
    					sp.send_new_text,
    					sp.close_alert_text,
    					sp.form_width,
    					sp.redirect,
    					sp.redirect_itemid,
    					sp.redirect_url,
    					sp.redirect_delay,
    					sp.shake_count,
    					sp.shake_distanse,
    					sp.send_copy_enable,
    					sp.send_copy_text,
    					sp.shake_duration,
    					sp.custom_css,
    					st.styles,
    
    					sp.render_type,
    					sp.popup_button_text,
    					sp.static_button_position,
    					sp.static_button_offset,
    					sp.appear_animation_type,
    					sp.check_token,
    					sp.next_button_text,
    					sp.prev_button_text
    
    					
      FROM
    					`un5gf_creative_forms` sp
    					
      LEFT JOIN `un5gf_contact_templates` st 
      ON st.id = sp.id_template
    					
      WHERE sp.published = '1'
    					
      AND sp.id = '1'

    Explain

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

    Profilo

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.02 ms
    optimizing	0.01 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.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    14	JDatabaseDriver->loadAssoc()	JROOT/components/com_creativecontactform/helpers/helper.php:283
    13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
    12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.72 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.041 MB memoria prima della query: 3.807 MB Righe restituite: 4
    Query duplicate: #22

    SELECT
    					sp.id,
    					sp.name,
    					sp.tooltip_text,
    					sp.required,
    					sp.ordering_field,
    					sp.select_default_text,
    					sp.show_parent_label,
    					sp.select_no_match_text,
    					sp.width,
    					sp.field_margin_top,
    					sp.select_show_scroll_after,
    					sp.select_show_search_after,
    					sp.upload_button_text,
    					sp.upload_minfilesize,
    					sp.upload_maxfilesize,
    					sp.upload_acceptfiletypes,
    					sp.upload_minfilesize_message,
    					sp.upload_maxfilesize_message,
    					sp.upload_acceptfiletypes_message,
    					sp.captcha_wrong_message,
    
    					sp.datepicker_date_format,
    					sp.datepicker_animation,
    					sp.datepicker_style,
    					sp.datepicker_icon_style,
    					sp.datepicker_show_icon,
    					sp.datepicker_input_readonly,
    					sp.datepicker_number_months,
    					sp.datepicker_mindate,
    					sp.datepicker_maxdate,
    					sp.datepicker_changemonths,
    					sp.datepicker_changeyears,
    					sp.column_type,
    					sp.custom_html,
    					sp.google_maps,
    					sp.heading,
    					sp.recaptcha_site_key,
    					sp.recaptcha_wrong_message,
    					sp.recaptcha_theme,
    					sp.recaptcha_type,
    					sp.contact_data,
    					sp.contact_data_width,
    					sp.creative_popup,
    					sp.creative_popup_embed,
    
    					st.name as type
    				
      FROM
    					`un5gf_creative_fields` sp
    				JOIN `un5gf_creative_field_types` st 
      ON st.id = sp.id_type
    				
      WHERE sp.published = '1'
    				
      AND sp.id_form = '1'
    				
      ORDER BY sp.ordering,sp.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	sp	ref	id_form	id_form	3	const	3	Using where; Using filesort
    1	SIMPLE	st	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.sp.id_type	1	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.05 ms
    Sending data	0.06 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:1500
    14	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:344
    13	CreativecontactformHelper->get_data()	JROOT/components/com_creativecontactform/helpers/helper.php:430
    12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.77 ms Dopo l'ultima query: 0.50 ms Memoria query: 0.025 MB memoria prima della query: 3.847 MB Righe restituite: 4

    SELECT
     							spo.name,
     							spo.id,
     							spo.value,
     							spo.selected
    							
      FROM
    								`un5gf_creative_form_options` spo
    							
      WHERE spo.id_parent = '4'
    							
      AND spo.showrow = '1'
    							
      ORDER BY spo.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	spo	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	499	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.00 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.35 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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    13	JDatabaseDriver->loadAssocList()	JROOT/components/com_creativecontactform/helpers/helper.php:575
    12	CreativecontactformHelper->print_fields_array_html()	JROOT/components/com_creativecontactform/helpers/helper.php:947
    11	CreativecontactformHelper->render_html()	JROOT/modules/mod_creativecontactform/mod_creativecontactform.php:29
    10	include JROOT/modules/mod_creativecontactform/mod_creativecontactform.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.97 ms Dopo l'ultima query: 345.73 ms Memoria query: 0.034 MB memoria prima della query: 4.055 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.17 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.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.21 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:1205
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.73 ms Dopo l'ultima query: 12.47 ms Memoria query: 0.041 MB memoria prima della query: 4.121 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.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 ms
    Sending data	0.11 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
    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:1205
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 3.34 ms Dopo l'ultima query: 1.59 ms Memoria query: 0.027 MB memoria prima della query: 4.157 MB Righe restituite: 4

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.04 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
    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:1205
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 6.84 ms Dopo l'ultima query: 23.67 ms Memoria query: 0.059 MB memoria prima della query: 4.213 MB Righe restituite: 3

    SELECT rpt.*, ev.*, 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-31 02:45:03' 
      AND rpt.startrepeat <= '2023-06-30 23:59:59'
     
      AND (rpt.startrepeat >= '2023-05-31 02:45:03' OR  det.multiday=1) 
      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)
     
      AND rpt.startrepeat=(
    				SELECT MIN(startrepeat) 
      FROM un5gf_jevents_repetition as rpt2
    				
      WHERE rpt2.eventid=rpt.eventid
    				
      AND  (
    					(rpt2.startrepeat >= '2023-05-31 02:45:03' 
      AND rpt2.startrepeat <= '2023-06-30 23:59:59')
    					OR (rpt2.startrepeat <= '2023-05-31 02:45:03' 
      AND rpt2.endrepeat  > '2023-05-31 02:45:03'  
      AND det.multiday=1)
    					)
    				
    			) 
    			
      GROUP BY ev.ev_id
    			
    			
      ORDER BY rpt.startrepeat 
      LIMIT 5

    Explain

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

    Profilo

    Status	Duration
    starting	0.19 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
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    System lock	0.01 ms
    init	0.32 ms
    optimizing	0.06 ms
    statistics	0.27 ms
    preparing	0.14 ms
    Creating tmp table	0.43 ms
    executing	0.00 ms
    Copying to tmp table	1.18 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	1.52 ms
    executing	0.00 ms
    Sending data	0.42 ms
    executing	0.00 ms
    Sending data	0.57 ms
    Creating sort index	0.03 ms
    Copying to group table	0.14 ms
    Sorting result	0.02 ms
    Sending data	0.27 ms
    end	0.01 ms
    removing tmp table	0.24 ms
    end	0.00 ms
    removing tmp table	0.39 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.07 ms
    freeing items	0.02 ms
    removing tmp table	0.01 ms
    freeing items	0.04 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:2933
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.46 ms Dopo l'ultima query: 3.31 ms Memoria query: 0.029 MB memoria prima della query: 4.357 MB Righe restituite: 0
    Query duplicate: #99

    SELECT *, summary as title, description as content 
      FROM un5gf_jevents_translation 
      WHERE evdet_id IN(608,632,609) 
      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.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.00 ms
    executing	0.04 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:708
    16	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:2968
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.66 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.041 MB memoria prima della query: 4.367 MB Righe restituite: 3

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

    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	4	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.02 ms
    optimizing	0.00 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.06 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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:494
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.37 ms Dopo l'ultima query: 14.31 ms Memoria query: 0.029 MB memoria prima della query: 4.491 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.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.01 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:1734
    23	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:324
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.66 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.504 MB Righe restituite: 1
    Query duplicate: #55  #79

    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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.20 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.03 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:1656
    23	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:344
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.54 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.028 MB memoria prima della query: 4.521 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.17 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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    23	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:358
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.60 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.033 MB memoria prima della query: 4.533 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.04 ms
    preparing	0.02 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.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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:432
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.48 ms Dopo l'ultima query: 9.74 ms Memoria query: 0.034 MB memoria prima della query: 4.586 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.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_rsvppro/models/template.php:417
    26	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    25	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    24	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    23	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.94 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.038 MB memoria prima della query: 4.606 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.19 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.03 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.19 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
    35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    34	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    33	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    32	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    31	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsvppro/tables/template.php:94
    30	TableTemplate->__construct()	JROOT/libraries/src/Table/Table.php:312
    29	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:382
    28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:468
    27	Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable()	JROOT/administrator/components/com_rsvppro/models/template.php:421
    26	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    25	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    24	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    23	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.63 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.037 MB memoria prima della query: 4.647 MB Righe restituite: 1
    Query duplicate: #41

    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.16 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.03 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:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/models/template.php:426
    26	TemplatesModelTemplate->_loadData()	JROOT/administrator/components/com_rsvppro/models/template.php:98
    25	TemplatesModelTemplate->getData()	JROOT/administrator/components/com_rsvppro/models/template.php:582
    24	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    23	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.36 ms Dopo l'ultima query: 9.40 ms Memoria query: 0.031 MB memoria prima della query: 4.746 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.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.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    25	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_rsvppro/models/template.php:587
    24	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    23	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.40 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.036 MB memoria prima della query: 4.760 MB Righe restituite: 1
    Query duplicate: #39

    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.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsvppro/models/template.php:615
    24	TemplatesModelTemplate->getTranslation()	JROOT/administrator/components/com_rsvppro/libraries/jevrsvpparameter.php:54
    23	JevRsvpParameter->__construct()	JROOT/administrator/components/com_rsvppro/libraries/jevrattendees.php:452
    22	JevRsvpAttendees->showAttendees()	JROOT/plugins/jevents/jevrsvppro/rsvppro/jevrdisplayattendance.php:592
    21	JevRsvpDisplayAttendance->displayCustomFieldsMultiRow()	JROOT/plugins/jevents/jevrsvppro/jevrsvppro.php:523
    20	plgJEventsJevrsvppro->onDisplayCustomFieldsMultiRow()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/libraries/helper.php:4058
    16	JEVHelper::onDisplayCustomFieldsMultiRow()	JROOT/components/com_jevents/libraries/dbmodel.php:2970
    15	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
    14	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:1375
    13	JEventsDBModel->listLatestIcalEvents()	JROOT/modules/mod_jevents_latest/tmpl/default/latest.php:600
    12	DefaultModLatestView->getLatestEventsData()	JROOT/modules/mod_jevents_latest/tmpl/flat/latest.php:32
    11	FlatModLatestView->displayLatestEvents()	JROOT/modules/mod_jevents_latest/mod_jevents_latest.php:54
    10	include JROOT/modules/mod_jevents_latest/mod_jevents_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.38 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.032 MB memoria prima della query: 4.775 MB Righe restituite: 0

    SELECT w.* 
      FROM un5gf_jev_rsvp_fields_translation AS w 
      WHERE w.template_id = 1