{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1652952780,
                "last": 1652952780,
                "now": 1652952780
            },
            "token": "ZDMWWKFj8XBYogYnsoPoNR9lMAFhKJ02"
        },
        "registry": {},
        "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
        }
    },
    "__sige": {
        "sigcount": null,
        "sigcountarticles": null
    }
}

Tempo

Memoria

22 query eseguite 16.53 ms

1. Tempo della query: 0.48 ms Memoria query: 0.023 MB memoria prima della query: 1.039 MB Righe restituite: 0

   SELECT `data`
   
     FROM `vlm_session`
   
     WHERE `session_id` = X'7132637568766139646362396f6c633367327030617062736535'

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:765
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Tempo della query: 0.39 ms Dopo l'ultima query: 3.22 ms Memoria query: 0.020 MB memoria prima della query: 1.053 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `vlm_session`
   
     WHERE `session_id` = X'7132637568766139646362396f6c633367327030617062736535' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	vlm_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.00 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Tempo della query: 0.43 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.004 MB memoria prima della query: 1.058 MB

   INSERT INTO `vlm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'7132637568766139646362396f6c633367327030617062736535', 1, 1652952780, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `vlm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7132637568766139646362396f6c633367327030617062736535', 1, 1652952780, 0, '', 0)

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:767
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:351
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Tempo della query: 0.43 ms Dopo l'ultima query: 15.03 ms Memoria query: 0.021 MB memoria prima della query: 1.136 MB Righe restituite: 7

   SELECT id, rules
   
     FROM `vlm_viewlevels`

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Tempo della query: 0.43 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 1.150 MB Righe restituite: 1

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

   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	2	Using where; Using index

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Tempo della query: 0.55 ms Dopo l'ultima query: 143.34 ms Memoria query: 0.005 MB memoria prima della query: 4.975 MB

   UPDATE `vlm_extensions`
   
     SET `params` = '{\"mediaversion\":\"3d29cc24463edcf49a333f38344ab8f5\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `vlm_extensions` SET `params` = '{\"mediaversion\":\"3d29cc24463edcf49a333f38344ab8f5\"}' 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.07 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.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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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]

   ---

7. Tempo della query: 1.18 ms Dopo l'ultima query: 26.25 ms Memoria query: 0.023 MB memoria prima della query: 5.174 MB Righe restituite: 0

   SELECT p.*,t.value AS `type`,d.value AS department,town.value AS town,area.value AS area,c.value AS `condition`,u.username AS author,s.value AS slogan
   
     FROM vlm_jea_properties AS p
   
     LEFT JOIN vlm_jea_types AS t 
     ON t.id = p.type_id
   
     LEFT JOIN vlm_jea_departments AS d 
     ON d.id = p.department_id
   
     LEFT JOIN vlm_jea_towns AS town 
     ON town.id = p.town_id
   
     LEFT JOIN vlm_jea_areas AS area 
     ON area.id = p.area_id
   
     LEFT JOIN vlm_jea_conditions AS c 
     ON c.id = p.condition_id
   
     LEFT JOIN vlm_users AS u 
     ON u.id = p.created_by
   
     LEFT JOIN vlm_jea_slogans AS s 
     ON s.id = p.slogan_id
   
     WHERE p.published=1 
     AND p.access IN (1,1) 
     AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2022-05-19 09:33:00') 
     AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2022-05-19 09:33:00') 
     AND p.transaction_type ='RENTING' 
     AND p.department_id =1 
     AND p.town_id =1 
     AND p.area_id =2
   
     ORDER BY created desc 
     LIMIT 10

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	p	ref	idx_jea_transactiontype,idx_jea_departmentid,idx_jea_townid	idx_jea_townid	4	const	1	Using where; Using filesort
   1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.type_id	1
   1	SIMPLE	d	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	town	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	area	const	PRIMARY	PRIMARY	4	const	1
   1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.condition_id	1
   1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.created_by	1
   1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.slogan_id	1

   Profilo

   Status	Duration
   starting	0.09 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.02 ms
   Opening tables	0.06 ms
   System lock	0.02 ms
   init	0.12 ms
   optimizing	0.04 ms
   statistics	0.12 ms
   preparing	0.05 ms
   executing	0.00 ms
   Sorting result	0.03 ms
   Sending data	0.06 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   logging slow query	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jea/views/properties/view.html.php:50
   10	JeaViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jea/controllers/default.php:83
   8	JeaControllerDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jea/jea.php:22
   6	require_once JROOT/components/com_jea/jea.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]

   ---

8. Tempo della query: 0.73 ms Dopo l'ultima query: 1.32 ms Memoria query: 0.023 MB memoria prima della query: 5.197 MB Righe restituite: 1

   SELECT COUNT(*)
   
     FROM vlm_jea_properties AS p
   
     LEFT JOIN vlm_jea_types AS t 
     ON t.id = p.type_id
   
     LEFT JOIN vlm_jea_departments AS d 
     ON d.id = p.department_id
   
     LEFT JOIN vlm_jea_towns AS town 
     ON town.id = p.town_id
   
     LEFT JOIN vlm_jea_areas AS area 
     ON area.id = p.area_id
   
     LEFT JOIN vlm_jea_conditions AS c 
     ON c.id = p.condition_id
   
     LEFT JOIN vlm_users AS u 
     ON u.id = p.created_by
   
     LEFT JOIN vlm_jea_slogans AS s 
     ON s.id = p.slogan_id
   
     WHERE p.published=1 
     AND p.access IN (1,1) 
     AND (p.publish_up = '0000-00-00 00:00:00' OR p.publish_up <= '2022-05-19 09:33:00') 
     AND (p.publish_down = '0000-00-00 00:00:00' OR p.publish_down >= '2022-05-19 09:33:00') 
     AND p.transaction_type ='RENTING' 
     AND p.department_id =1 
     AND p.town_id =1 
     AND p.area_id =2

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	p	ref	idx_jea_transactiontype,idx_jea_departmentid,idx_jea_townid	idx_jea_townid	4	const	1	Using where
   1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.type_id	1	Using index
   1	SIMPLE	d	const	PRIMARY	PRIMARY	4	const	1	Using index
   1	SIMPLE	town	const	PRIMARY	PRIMARY	4	const	1	Using index
   1	SIMPLE	area	const	PRIMARY	PRIMARY	4	const	1	Using index
   1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.condition_id	1	Using index
   1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.created_by	1	Using index
   1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	Sql796834_4.p.slogan_id	1	Using index

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.06 ms
   System lock	0.01 ms
   init	0.04 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   preparing	0.03 ms
   executing	0.00 ms
   Sending data	0.03 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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
   14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
   13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
   12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jea/views/properties/view.html.php:53
   10	JeaViewProperties->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jea/controllers/default.php:83
   8	JeaControllerDefault->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jea/jea.php:22
   6	require_once JROOT/components/com_jea/jea.php	JROOT/libraries/src/Component/ComponentHelper.php:402
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
   4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tempo della query: 1.21 ms Dopo l'ultima query: 17.04 ms Memoria query: 0.027 MB memoria prima della query: 5.278 MB Righe restituite: 43

   SELECT `id`,`name`,`rules`,`parent_id`
   
     FROM `vlm_assets`
   
     WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_adsmanager','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jea','com_jem','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_osgallery','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_rspagebuilder','com_search','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	vlm_assets	range	idx_asset_name	idx_asset_name	202	NULL	44	Using where

   Profilo

   Status	Duration
   starting	0.05 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   System lock	0.01 ms
   init	0.05 ms
   optimizing	0.01 ms
   statistics	0.18 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.39 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
   17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
   15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
   14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
   13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
   12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
   11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
   10	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Plugin.php:167
   9	RegularLabs\Plugin\System\Sourcerer\Plugin->passChecks()	JROOT/plugins/system/sourcerer/src/Plugin.php:57
   8	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:57
   7	PlgSystemSourcerer->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
   6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
   3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tempo della query: 0.88 ms Dopo l'ultima query: 8.69 ms Memoria query: 0.023 MB memoria prima della query: 5.369 MB Righe restituite: 1

    SELECT params 
      FROM vlm_extensions AS e 
      WHERE e.element='com_widgetkit'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using where

    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.06 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:1740
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
    13	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    12	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    11	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    10	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    9	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 0.52 ms Dopo l'ultima query: 1.67 ms Memoria query: 0.021 MB memoria prima della query: 5.379 MB Righe restituite: 1

    SELECT id,template 
      FROM vlm_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vlm_template_styles	ALL	idx_client_id,idx_client_id_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.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
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    9	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    8	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    7	plgSystemWidgetkit_System->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 3.39 ms Dopo l'ultima query: 59.16 ms Memoria query: 0.105 MB memoria prima della query: 5.710 MB Righe restituite: 109

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM vlm_modules AS m
    
      LEFT JOIN vlm_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN vlm_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 <= '2022-05-19 09:33:00') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-19 09:33:00') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 314 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	67	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql796834_4.m.module,const	1	Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql796834_4.m.id	28	Using where; Using index

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:49
    11	ModulesWarpHelper->count()	JROOT/templates/fontaine_j3/layouts/template.config.php:136
    10	include JROOT/templates/fontaine_j3/layouts/template.config.php	JROOT/templates/fontaine_j3/layouts/template.php:10
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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]

    ---

13. Tempo della query: 0.48 ms Dopo l'ultima query: 33.24 ms Memoria query: 0.026 MB memoria prima della query: 5.911 MB Righe restituite: 1

    SELECT * 
      FROM vlm_widgetkit_widget 
      WHERE id=2

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.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:1662
    19	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:42
    18	WidgetWidgetkitHelper->get()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:160
    17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
    16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:134
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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]

    ---

14. Tempo della query: 1.36 ms Dopo l'ultima query: 7.10 ms Memoria query: 0.037 MB memoria prima della query: 5.994 MB Righe restituite: 31

    SHOW FULL COLUMNS 
      FROM `vlm_content`

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    23	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    22	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/widgetkit_joomla/widgetkit_joomla.php:101
    21	plgSystemWidgetkit_Joomla->_applycontentplugins()	JROOT/administrator/components/com_widgetkit/classes/helper.php:64
    20	WidgetkitHelper->_call()	JROOT/administrator/components/com_widgetkit/helpers/event.php:53
    19	EventWidgetkitHelper->trigger()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:190
    18	WidgetWidgetkitHelper->renderWidgetObject()	JROOT/administrator/components/com_widgetkit/helpers/widget.php:161
    17	WidgetWidgetkitHelper->render()	JROOT/modules/mod_widgetkit/mod_widgetkit.php:22
    16	include JROOT/modules/mod_widgetkit/mod_widgetkit.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:134
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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]

    ---

15. Tempo della query: 0.47 ms Dopo l'ultima query: 59.25 ms Memoria query: 0.028 MB memoria prima della query: 6.293 MB Righe restituite: 9

    SELECT f.id , f.value
    
      FROM vlm_jea_types AS f
    
      WHERE f.language in ('it-IT','*')
    
      ORDER BY f.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where; Using filesort

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:211
    22	JHtmlFeatures::getHTMLSelectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:36
    21	JHtmlFeatures::types()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jea_search/tmpl/default.php:38
    17	require JROOT/modules/mod_jea_search/tmpl/default.php	JROOT/modules/mod_jea_search/mod_jea_search.php:84
    16	include JROOT/modules/mod_jea_search/mod_jea_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:218
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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]

    ---

16. Tempo della query: 0.44 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.028 MB memoria prima della query: 6.306 MB Righe restituite: 8

    SELECT f.id , f.value
    
      FROM vlm_jea_towns AS f
    
      ORDER BY f.value asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	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.00 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.02 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:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:211
    22	JHtmlFeatures::getHTMLSelectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:78
    21	JHtmlFeatures::towns()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jea_search/tmpl/default.php:66
    17	require JROOT/modules/mod_jea_search/tmpl/default.php	JROOT/modules/mod_jea_search/mod_jea_search.php:84
    16	include JROOT/modules/mod_jea_search/mod_jea_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:218
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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]

    ---

17. Tempo della query: 0.93 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.034 MB memoria prima della query: 6.320 MB Righe restituite: 105

    SELECT f.id , f.value
    
      FROM vlm_jea_areas AS f
    
      ORDER BY f.value asc

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	105	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.00 ms
    statistics	0.00 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sorting result	0.10 ms
    Sending data	0.40 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    logging slow query	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:211
    22	JHtmlFeatures::getHTMLSelectList()	JROOT/administrator/components/com_jea/helpers/html/features.php:105
    21	JHtmlFeatures::areas()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jea_search/tmpl/default.php:70
    17	require JROOT/modules/mod_jea_search/tmpl/default.php	JROOT/modules/mod_jea_search/mod_jea_search.php:84
    16	include JROOT/modules/mod_jea_search/mod_jea_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:218
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 0.49 ms Dopo l'ultima query: 2.12 ms Memoria query: 0.028 MB memoria prima della query: 6.334 MB Righe restituite: 8

    SELECT a.id , a.value
    
      FROM vlm_jea_amenities AS a
    
      WHERE a.language in ('it-IT','*')
    
      ORDER BY a.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sorting result	0.03 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:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jea/helpers/html/amenities.php:137
    22	JHtmlAmenities::getAmenities()	JROOT/components/com_jea/helpers/html/amenities.php:92
    21	JHtmlAmenities::checkboxes()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_jea_search/tmpl/default.php:205
    17	require JROOT/modules/mod_jea_search/tmpl/default.php	JROOT/modules/mod_jea_search/mod_jea_search.php:84
    16	include JROOT/modules/mod_jea_search/mod_jea_search.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:218
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 0.65 ms Dopo l'ultima query: 82.81 ms Memoria query: 0.050 MB memoria prima della query: 6.623 MB Righe restituite: 1

    SELECT * 
      FROM vlm_adsmanager_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	vlm_adsmanager_config	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    32	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/configuration.php:26
    31	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
    30	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
    29	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:64
    28	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    27	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    20	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    19	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:327
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 0.36 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.033 MB memoria prima della query: 6.662 MB Righe restituite: 0

    SELECT group_id 
      FROM vlm_user_usergroup_map
                                
      WHERE user_id = 0

    Explain

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

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    System lock	0.01 ms
    init	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.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
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    33	JDatabaseDriver->loadColumn()	JROOT/components/com_adsmanager/helpers/usergroups.php:28
    32	JHTMLAdsmanagerUserGroups::getUserGroup()	JROOT/administrator/components/com_adsmanager/models/configuration.php:62
    31	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
    30	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
    29	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:64
    28	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    27	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    26	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    25	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    24	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    23	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    22	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    21	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    20	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    19	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    18	Joomla\CMS\Helper\ModuleHelper::renderModule()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
    15	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:86
    13	ModulesWarpHelper->load()	JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php:10
    12	include JROOT/templates/fontaine_j3/warp/systems/joomla/layouts/modules.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    11	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/warp/systems/joomla/helpers/modules.php:64
    10	ModulesWarpHelper->render()	JROOT/templates/fontaine_j3/layouts/template.php:327
    9	include JROOT/templates/fontaine_j3/layouts/template.php	JROOT/templates/fontaine_j3/warp/helpers/template.php:49
    8	TemplateWarpHelper->render()	JROOT/templates/fontaine_j3/index.php:19
    7	require JROOT/templates/fontaine_j3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    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.42 ms Dopo l'ultima query: 66.33 ms Memoria query: 0.027 MB memoria prima della query: 6.947 MB Righe restituite: 1

    SELECT id,parent_id 
      FROM vlm_menu 
      WHERE id = 314

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    23	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:82
    22	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    21	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
    20	modIceMegamenuHelper::buildXML()	Chiamata uguale alla linea sottostante.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    17	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_icemegamenu/helper.php:113
    16	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:154
    15	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:16
    14	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    13	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Chiamata uguale alla linea sottostante.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tempo della query: 0.30 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.027 MB memoria prima della query: 6.958 MB Righe restituite: 1

    SELECT id,parent_id 
      FROM vlm_menu 
      WHERE id = 1

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    23	JDatabaseDriver->loadObject()	JROOT/modules/mod_icemegamenu/libs/menucore.php:82
    22	IceMenuTree->getCurrentMenuItem()	JROOT/modules/mod_icemegamenu/libs/menucore.php:67
    21	IceMenuTree->__construct()	JROOT/modules/mod_icemegamenu/helper.php:45
    20	modIceMegamenuHelper::buildXML()	Chiamata uguale alla linea sottostante.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    17	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/modules/mod_icemegamenu/helper.php:113
    16	modIceMegamenuHelper->getXML()	JROOT/modules/mod_icemegamenu/helper.php:154
    15	modIceMegamenuHelper->render()	JROOT/modules/mod_icemegamenu/tmpl/default.php:16
    14	require JROOT/modules/mod_icemegamenu/tmpl/default.php	JROOT/modules/mod_icemegamenu/mod_icemegamenu.php:65
    13	include JROOT/modules/mod_icemegamenu/mod_icemegamenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Chiamata uguale alla linea sottostante.
    11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:617
    9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
    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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 2 × SELECT id,parent_id 
     FROM vlm_menu

2. 1 × SELECT * 
     FROM vlm_widgetkit_widget

3. 1 × SELECT group_id 
     FROM vlm_user_usergroup_map

4. 1 × SELECT * 
     FROM vlm_adsmanager_confi

5. 1 × SELECT a.id , a.value 
     FROM vlm_jea_amenities AS a

6. 1 × SELECT f.id , f.value 
     FROM vlm_jea_areas AS f

7. 1 × SELECT f.id , f.value 
     FROM vlm_jea_towns AS f

8. 1 × SELECT f.id , f.value 
     FROM vlm_jea_types AS f

9. 1 × SELECT `data` 
     FROM `vlm_session`

10. 1 × SELECT `session_id` 
      FROM `vlm_session`

11. 1 × SELECT id,template 
      FROM vlm_template_styles

12. 1 × SELECT params 
      FROM vlm_extensions AS e

13. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
      FROM `vlm_assets`

14. 1 × SELECT COUNT(*) 
      FROM vlm_jea_properties AS p 
      LEFT JOIN vlm_jea_types AS t 
      ON t.id = p.type_id 
      LEFT JOIN vlm_jea_departments AS d 
      ON d.id = p.department_id 
      LEFT JOIN vlm_jea_towns AS town 
      ON town.id = p.town_id 
      LEFT JOIN vlm_jea_areas AS area 
      ON area.id = p.area_id 
      LEFT JOIN vlm_jea_conditions AS c 
      ON c.id = p.condition_id 
      LEFT JOIN vlm_users AS u 
      ON u.id = p.created_by 
      LEFT JOIN vlm_jea_slogans AS s 
      ON s.id = p.slogan_id

15. 1 × SELECT p.*,t.value AS `type`,d.value AS department,town.value AS town,area.value AS area,c.value AS `condition`,u.username AS author,s.value AS slogan 
      FROM vlm_jea_properties AS p 
      LEFT JOIN vlm_jea_types AS t 
      ON t.id = p.type_id 
      LEFT JOIN vlm_jea_departments AS d 
      ON d.id = p.department_id 
      LEFT JOIN vlm_jea_towns AS town 
      ON town.id = p.town_id 
      LEFT JOIN vlm_jea_areas AS area 
      ON area.id = p.area_id 
      LEFT JOIN vlm_jea_conditions AS c 
      ON c.id = p.condition_id 
      LEFT JOIN vlm_users AS u 
      ON u.id = p.created_by 
      LEFT JOIN vlm_jea_slogans AS s 
      ON s.id = p.slogan_id

16. 1 × SELECT b.id 
      FROM vlm_usergroups AS a 
      LEFT JOIN vlm_usergroups AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt

17. 1 × SELECT id, rules 
      FROM `vlm_viewlevels

18. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
      FROM vlm_modules AS m 
      LEFT JOIN vlm_modules_menu AS mm 
      ON mm.moduleid = m.id 
      LEFT JOIN vlm_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id

ALTRE tabelle:

1. 1 × INSERT INTO `vlm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  (X'7132637568766139646362396f6c633367327030617062736535', 1, 1652952780, 0, '', 0

2. 1 × UPDATE `vlm_extensions` 
     SET `params` = '{\"mediaversion\":\"3d29cc24463edcf49a333f38344ab8f5\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `vlm_content