{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685491637,
                "last": 1685491637,
                "now": 1685491637
            },
            "token": "mrL9vn7JETbirtu10xzooxq4xnBrmixR"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuY3JhZ2VuZXJhbGlydW5uZXJzLml0L2luZGV4LnBocC9sb2dpbj92aWV3PXJlZ2lzdHJhdGlvbg%3D%3D"
            },
            "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,
        "_tmp_img_avatar": ""
    }
}

Tempo

Memoria

107 query eseguite 86.07 ms

1. Tempo della query: 2.18 ms Memoria query: 0.025 MB memoria prima della query: 1.226 MB Righe restituite: 0

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

   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: 2.05 ms Dopo l'ultima query: 15.52 ms Memoria query: 0.022 MB memoria prima della query: 1.303 MB Righe restituite: 0
   Query duplicate: #22

   SELECT `session_id`
   
     FROM `un5gf_session`
   
     WHERE `session_id` = '0qute8ambfqkuskm60bji3h5pg' 
     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: 2.18 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.004 MB memoria prima della query: 1.309 MB

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

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `un5gf_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('0qute8ambfqkuskm60bji3h5pg', 1, 1685491637, 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: 1.76 ms Dopo l'ultima query: 25.36 ms Memoria query: 0.051 MB memoria prima della query: 1.354 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.86 ms Dopo l'ultima query: 15.89 ms Memoria query: 0.023 MB memoria prima della query: 1.421 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

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

   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.96 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.022 MB memoria prima della query: 1.434 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

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

   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: 2.20 ms Dopo l'ultima query: 5.71 ms Memoria query: 0.035 MB memoria prima della query: 1.521 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

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

   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.38 ms Dopo l'ultima query: 152.67 ms Memoria query: 0.076 MB memoria prima della query: 2.150 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

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

   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.53 ms Dopo l'ultima query: 97.05 ms Memoria query: 0.027 MB memoria prima della query: 2.495 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.01 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   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.49 ms Dopo l'ultima query: 4.40 ms Memoria query: 0.006 MB memoria prima della query: 2.488 MB

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

    Explain

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

    Profilo

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

    Call Stack

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

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

    ---

11. Tempo della query: 1.27 ms Dopo l'ultima query: 11.87 ms Memoria query: 0.029 MB memoria prima della query: 2.518 MB Righe restituite: 44

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:140
    8	plgSystemJsn_System->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1129
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 0.49 ms Dopo l'ultima query: 10.93 ms Memoria query: 0.025 MB memoria prima della query: 2.679 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.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.02 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.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.03 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.73 ms Dopo l'ultima query: 8.51 ms Memoria query: 0.033 MB memoria prima della query: 2.696 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.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    System lock	0.02 ms
    init	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    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: 1.52 ms Dopo l'ultima query: 492.83 ms Memoria query: 0.040 MB memoria prima della query: 3.241 MB Righe restituite: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM un5gf_fields AS a
    
      LEFT JOIN `un5gf_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN un5gf_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN un5gf_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN un5gf_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN un5gf_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_users.user' 
      AND a.access IN (1,1,5) 
      AND (a.group_id = 0 OR g.access IN (1,1,5)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Sql936528_1.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.access	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.created_user_id	1
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql936528_1.a.group_id	1	Using where

    Profilo

    Status	Duration
    starting	0.11 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.08 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    Creating tmp table	0.37 ms
    executing	0.00 ms
    Copying to tmp table	0.03 ms
    Sorting result	0.01 ms
    Sending data	0.03 ms
    end	0.00 ms
    removing tmp table	0.25 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:1695
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    23	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
    22	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:298
    21	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 0.77 ms Dopo l'ultima query: 4.90 ms Memoria query: 0.042 MB memoria prima della query: 3.271 MB Righe restituite: 4

    SELECT a.*
    
      FROM un5gf_jsn_fields AS a
    
      WHERE a.level = 1 
      AND a.published = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	field_idx	field_idx	1	const	30	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.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.10 ms
    Sending data	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsn_system/jsn_system.php:875
    21	plgSystemJsn_System->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.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.89 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.051 MB memoria prima della query: 3.317 MB Righe restituite: 7

    SELECT a.*
    
      FROM un5gf_jsn_fields AS a
    
      WHERE a.level = 2 
      AND a.published = 1 
      AND a.parent_id = 2 
      AND register = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	field_idx	field_idx	1	const	30	Using where; Using filesort

    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.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.08 ms
    Sending data	0.11 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsn_system/jsn_system.php:885
    21	plgSystemJsn_System->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tempo della query: 0.72 ms Dopo l'ultima query: 11.96 ms Memoria query: 0.040 MB memoria prima della query: 3.555 MB Righe restituite: 0

    SELECT a.*
    
      FROM un5gf_jsn_fields AS a
    
      WHERE a.level = 2 
      AND a.published = 1 
      AND a.parent_id = 17 
      AND register = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	field_idx	field_idx	1	const	30	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.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.09 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsn_system/jsn_system.php:885
    21	plgSystemJsn_System->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 0.67 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.040 MB memoria prima della query: 3.435 MB Righe restituite: 0

    SELECT a.*
    
      FROM un5gf_jsn_fields AS a
    
      WHERE a.level = 2 
      AND a.published = 1 
      AND a.parent_id = 18 
      AND register = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	field_idx	field_idx	1	const	30	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.10 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsn_system/jsn_system.php:885
    21	plgSystemJsn_System->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 0.59 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.040 MB memoria prima della query: 3.445 MB Righe restituite: 0

    SELECT a.*
    
      FROM un5gf_jsn_fields AS a
    
      WHERE a.level = 2 
      AND a.published = 1 
      AND a.parent_id = 29 
      AND register = 1
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	field_idx	field_idx	1	const	30	Using where; Using filesort

    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.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.06 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jsn_system/jsn_system.php:885
    21	plgSystemJsn_System->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
    20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    19	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
    18	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/registration.php:390
    17	UsersModelRegistration->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
    16	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    15	UsersModelRegistration->getForm()	JROOT/components/com_users/models/registration.php:262
    14	UsersModelRegistration->getData()	JROOT/components/com_users/models/registration.php:356
    13	UsersModelRegistration->loadFormData()	JROOT/libraries/src/MVC/Model/FormModel.php:233
    12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/registration.php:331
    11	UsersModelRegistration->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/registration/view.html.php:41
    9	UsersViewRegistration->display()	JROOT/components/com_users/controller.php:139
    8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
    6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 1.07 ms Dopo l'ultima query: 1528.27 ms Memoria query: 0.031 MB memoria prima della query: 3.801 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:07:20') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 00:07:20') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 162 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.03 ms
    statistics	0.05 ms
    preparing	0.06 ms
    executing	0.00 ms
    Sorting result	0.13 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]

    ---

21. Tempo della query: 0.74 ms Dopo l'ultima query: 13.51 ms Memoria query: 0.028 MB memoria prima della query: 3.990 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:07:20') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-05-31 00:07:20') 
      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.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 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
    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]

    ---

22. Tempo della query: 0.38 ms Dopo l'ultima query: 89.71 ms Memoria query: 0.024 MB memoria prima della query: 4.297 MB Righe restituite: 1
    Query duplicate: #2

    SELECT `session_id`
    
      FROM `un5gf_session`
    
      WHERE `session_id` = '0qute8ambfqkuskm60bji3h5pg' 
      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.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
    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]

    ---

23. Tempo della query: 1.86 ms Dopo l'ultima query: 39.71 ms Memoria query: 0.024 MB memoria prima della query: 4.363 MB Righe restituite: 4
    Query duplicate: #26

    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.06 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    System lock	0.02 ms
    init	0.03 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.59 ms
    Sending data	0.69 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.01 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]

    ---

24. Tempo della query: 2.48 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.035 MB memoria prima della query: 4.373 MB Righe restituite: 1
    Query duplicate: #27

    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.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	1.85 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
    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]

    ---

25. Tempo della query: 0.77 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.041 MB memoria prima della query: 4.390 MB Righe restituite: 4
    Query duplicate: #28

    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.02 ms
    init	0.06 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 ms
    Sending data	0.09 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: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]

    ---

26. Tempo della query: 0.43 ms Dopo l'ultima query: 1.46 ms Memoria query: 0.025 MB memoria prima della query: 4.452 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.02 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.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
    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]

    ---

27. Tempo della query: 0.57 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.036 MB memoria prima della query: 4.463 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.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.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: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]

    ---

28. Tempo della query: 0.66 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.041 MB memoria prima della query: 4.480 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.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

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

    ---

29. Tempo della query: 1.06 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.025 MB memoria prima della query: 4.520 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.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.67 ms
    Sending data	0.03 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
    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]

    ---

30. Tempo della query: 1.79 ms Dopo l'ultima query: 354.87 ms Memoria query: 0.034 MB memoria prima della query: 4.866 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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.23 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.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
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.42 ms
    closing tables	0.00 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

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

    ---

31. Tempo della query: 1.45 ms Dopo l'ultima query: 12.13 ms Memoria query: 0.041 MB memoria prima della query: 4.922 MB Righe restituite: 5

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.04 ms
    optimizing	0.01 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sorting result	0.07 ms
    Sending data	0.12 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]

    ---

32. Tempo della query: 0.54 ms Dopo l'ultima query: 1.91 ms Memoria query: 0.027 MB memoria prima della query: 4.958 MB Righe restituite: 4

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    19	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:514
    18	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1019
    17	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
    16	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
    15	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
    14	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php: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]

    ---

33. Tempo della query: 11.67 ms Dopo l'ultima query: 17.79 ms Memoria query: 0.061 MB memoria prima della query: 5.021 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:07:20' 
      AND rpt.startrepeat <= '2023-06-30 23:59:59'
     
      AND (rpt.startrepeat >= '2023-05-31 02:07:20' 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:07:20' 
      AND rpt2.startrepeat <= '2023-06-30 23:59:59')
    					OR (rpt2.startrepeat <= '2023-05-31 02:07:20' 
      AND rpt2.endrepeat  > '2023-05-31 02:07:20'  
      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.28 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.07 ms
    System lock	0.02 ms
    init	0.25 ms
    optimizing	0.03 ms
    statistics	0.19 ms
    preparing	0.09 ms
    Creating tmp table	0.36 ms
    executing	0.00 ms
    Copying to tmp table	3.71 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	3.52 ms
    executing	0.00 ms
    Sending data	1.04 ms
    executing	0.00 ms
    Sending data	0.65 ms
    Creating sort index	0.03 ms
    Copying to group table	0.14 ms
    Sorting result	0.02 ms
    Sending data	0.26 ms
    end	0.01 ms
    removing tmp table	0.16 ms
    end	0.00 ms
    removing tmp table	0.28 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.08 ms
    freeing items	0.03 ms
    removing tmp table	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.01 ms

    Call Stack

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

    ---

34. Tempo della query: 0.42 ms Dopo l'ultima query: 2.89 ms Memoria query: 0.029 MB memoria prima della query: 5.166 MB Righe restituite: 0
    Query duplicate: #102

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

    Call Stack

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

    ---

35. Tempo della query: 0.52 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.041 MB memoria prima della query: 5.177 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.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.05 ms
    preparing	0.00 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.02 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

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

    ---

36. Tempo della query: 0.35 ms Dopo l'ultima query: 11.03 ms Memoria query: 0.028 MB memoria prima della query: 5.289 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.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: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]

    ---

37. Tempo della query: 1.20 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.028 MB memoria prima della query: 5.299 MB Righe restituite: 1
    Query duplicate: #58  #82

    Select params 
      from un5gf_jev_rsvp_templates 
      where id=1

    Explain

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

    Profilo

    Status	Duration
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.00 ms
    init	0.01 ms
    optimizing	0.00 ms
    statistics	0.83 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
    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]

    ---

38. Tempo della query: 0.84 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.028 MB memoria prima della query: 5.317 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.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.47 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: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]

    ---

39. Tempo della query: 0.50 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.033 MB memoria prima della query: 5.329 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.00 ms
    init	0.02 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.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
    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]

    ---

40. Tempo della query: 0.45 ms Dopo l'ultima query: 6.00 ms Memoria query: 0.034 MB memoria prima della query: 5.376 MB Righe restituite: 1

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

    Explain

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

    Profilo

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

    ---

41. Tempo della query: 0.81 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.038 MB memoria prima della query: 5.396 MB Righe restituite: 16