{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1729566716,
                "last": 1729566718,
                "now": 1729566718
            },
            "token": "dcuxNIbf22MHDx3QqwO9gVA5XeVMpi8Y"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            }
        },
        "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
        },
        "jd_allowed_create_categories": [],
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-name": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-logo-type": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-logo-custom-image": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-headerstyle": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-backgroundstyle": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-linkcolor": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-font-family": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-font-size-is": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-menu-type": null,
        "gantry-d5249b7b1d68eddf9e45593a1c8612c8-layout-mode": null,
        "jd_fileid": "MTE0",
        "jd_random_id": null,
        "jd_list": null,
        "jd_catid": "MTA="
    }
}

Tempo

Memoria

68 query eseguite 222.82 ms

1. Tempo della query: 0.35 ms Memoria query: 0.027 MB memoria prima della query: 1.285 MB Righe restituite: 1

   SELECT `data`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'3539643431613561303766323030313536353963663938313036623134386661'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profilo

   Status	Duration
   starting	0.07 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   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:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.42 ms Dopo l'ultima query: 1.30 ms Memoria query: 0.037 MB memoria prima della query: 1.342 MB Righe restituite: 43

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	43	1.00	Using where

   Profilo

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 ms
   executing	0.09 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   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:196
   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]

   ---

3. Tempo della query: 0.26 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.023 MB memoria prima della query: 1.456 MB Righe restituite: 6

   SELECT id, rules
   
     FROM `jos_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_viewlevels	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	6	100.00	NULL

   Profilo

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:196
   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]

   ---

4. Tempo della query: 0.30 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.022 MB memoria prima della query: 1.468 MB Righe restituite: 2

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.08 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   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:196
   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.57 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.034 MB memoria prima della query: 1.491 MB Righe restituite: 93

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	125	0.60	Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.29 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   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:196
   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: 2.01 ms Dopo l'ultima query: 6.46 ms Memoria query: 0.028 MB memoria prima della query: 1.964 MB Righe restituite: 119
   Query duplicate: #10  #68

   SHOW TABLES

   Explain

   EXPLAIN non possibile sulla query: SHOW TABLES

   Profilo

   Status	Duration
   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.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
   9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:78
   8	plgSystemjdownloads->onAfterInitialise()	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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:196
   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: 0.44 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.022 MB memoria prima della query: 1.984 MB Righe restituite: 0

   SELECT file_id 
     from jos_jdownloads_files 
     WHERE published = 1 
     AND use_timeframe = 1 
     AND publish_to != '0000-00-00 00:00:00' 
     AND publish_to <= '2024-10-22 05:11:58'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_jdownloads_files	NULL	ALL	idx_published	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	249	2.99	Using where

   Profilo

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.12 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.02 ms
   executing	0.11 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:106
   8	plgSystemjdownloads->onAfterInitialise()	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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:196
   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.21 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.022 MB memoria prima della query: 1.989 MB Righe restituite: 0

   SELECT file_id 
     from jos_jdownloads_files 
     WHERE published = 0 
     AND use_timeframe = 1 
     AND publish_from != '0000-00-00 00:00:00' 
     AND publish_from <= '2024-10-22 05:11:58'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	jos_jdownloads_files	NULL	ref	idx_published	idx_published	1	const	1	5.00	Using where

   Profilo

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   9	JDatabaseDriver->loadColumn()	JROOT/plugins/system/jdownloads/jdownloads.php:114
   8	plgSystemjdownloads->onAfterInitialise()	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:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:196
   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.63 ms Dopo l'ultima query: 1.43 ms Memoria query: 0.097 MB memoria prima della query: 2.016 MB Righe restituite: 54

   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 jos_menu AS m
   
     LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	5.32	Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.m.component_id	1	100.00	Using where

   Profilo

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.09 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 ms
   executing	0.27 ms
   end	0.01 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
   17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
   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:375
   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:491
   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:1073
   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:196
   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: 1.90 ms Dopo l'ultima query: 4.08 ms Memoria query: 0.028 MB memoria prima della query: 2.389 MB Righe restituite: 119
    Query duplicate: #6  #68

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

    Status	Duration
    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.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.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.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:353
    8	plgSystemjdownloads->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:1122
    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:196
    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.28 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.025 MB memoria prima della query: 2.415 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    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:196
    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.93 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.005 MB memoria prima della query: 2.406 MB

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.04 ms
    updating	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.72 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    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:196
    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.29 ms Dopo l'ultima query: 0.50 ms Memoria query: 0.025 MB memoria prima della query: 2.492 MB Righe restituite: 2

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_languages	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 0.37 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.021 MB memoria prima della query: 2.508 MB Righe restituite: 3
    Query duplicate: #58  #59

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	knareaza_new.e.element	1	60.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    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:196
    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.43 ms Dopo l'ultima query: 1.21 ms Memoria query: 0.086 MB memoria prima della query: 2.565 MB Righe restituite: 269

    SELECT setting_name, setting_value 
      FROM jos_jdownloads_config

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_config	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	269	100.00	NULL

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:39
    7	JDHelper::buildjlistConfig()	JROOT/components/com_jdownloads/jdownloads.php:28
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.31 ms Dopo l'ultima query: 1.37 ms Memoria query: 0.025 MB memoria prima della query: 2.747 MB Righe restituite: 12
    Query duplicate: #18  #35

    SELECT group_id, importance, id
    
      FROM jos_jdownloads_usergroups_limits
    
      ORDER BY importance

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	100.00	Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:91
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/view.html.php:37
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.30 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.078 MB memoria prima della query: 2.761 MB Righe restituite: 1
    Query duplicate: #19  #36

    SELECT * 
      FROM jos_jdownloads_usergroups_limits 
      WHERE group_id IN (1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	10.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:115
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/view.html.php:37
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.17 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.025 MB memoria prima della query: 2.790 MB Righe restituite: 12
    Query duplicate: #16  #35

    SELECT group_id, importance, id
    
      FROM jos_jdownloads_usergroups_limits
    
      ORDER BY importance

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	100.00	Using filesort

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:91
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/view.html.php:40
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.26 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.078 MB memoria prima della query: 2.802 MB Righe restituite: 1
    Query duplicate: #17  #36

    SELECT * 
      FROM jos_jdownloads_usergroups_limits 
      WHERE group_id IN (1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	10.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:115
    11	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/view.html.php:40
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.49 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.032 MB memoria prima della query: 2.837 MB Righe restituite: 43

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_b2jcontact','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_edocman','com_fields','com_finder','com_gantry','com_installer','com_jce','com_jdownloads','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_quicklogout','com_redirect','com_search','com_sigpro','com_tags','com_templates','com_users','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	44	100.00	Using index condition

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.17 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_jdownloads/models/summary.php:92
    14	jdownloadsModelSummary->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_jdownloads/models/summary.php:115
    12	jdownloadsModelSummary->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:44
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.76 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.047 MB memoria prima della query: 2.906 MB Righe restituite: 1

    SELECT a.file_id, a.asset_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password_md5, a.views, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.published, 
      CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.cat_id, a.date_added, a.created_id, a.file_date, a.modified_date as modified, a.publish_from, a.publish_to, a.modified_id, a.checked_out, a.checked_out_time,  a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.downloads, a.language,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.password AS category_password,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias
    
      FROM jos_jdownloads_files AS a
    
      LEFT JOIN jos_jdownloads_categories AS c 
      on c.id = a.cat_id
    
      LEFT JOIN jos_jdownloads_licenses AS l 
      on l.id = a.license
    
      LEFT JOIN jos_jdownloads_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT 
      OUTER JOIN  (SELECT cat.id as id 
      FROM jos_jdownloads_categories AS cat JOIN jos_jdownloads_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.published <= 0 
      GROUP BY cat.id) AS badcats 
      ON badcats.id = c.id
    
      WHERE a.file_id = 114 
      AND (a.published = 1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	a	NULL	const	PRIMARY,idx_published	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	l	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
    1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	7	100.00	Using index
    2	DERIVED	parent	NULL	ALL	idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	44	33.33	Using where; Using temporary
    2	DERIVED	cat	NULL	index	PRIMARY,idx_access,idx_checked_out,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	44	11.11	Using where; Using index; Using join buffer (hash join)

    Profilo

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.23 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    statistics	0.07 ms
    preparing	0.05 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/models/summary.php:201
    12	jdownloadsModelSummary->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:44
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.45 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.083 MB memoria prima della query: 2.935 MB Righe restituite: 294

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jos_assets`
    
      WHERE `name` LIKE 'com_jdownloads.%' OR `name` = 'com_jdownloads' OR `parent_id` = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_assets	NULL	ALL	idx_asset_name,idx_parent_id	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	431	21.51	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    13	Joomla\CMS\User\User->authorise()	JROOT/components/com_jdownloads/models/summary.php:226
    12	jdownloadsModelSummary->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:44
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tempo della query: 0.31 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.028 MB memoria prima della query: 3.219 MB Righe restituite: 43

    SELECT c.id AS id, c.access, a.name AS asset_name
    
      FROM jos_jdownloads_categories AS c
    
      INNER JOIN jos_assets AS a 
      ON c.asset_id = a.id
    
      WHERE c.published = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	44	10.00	Using where
    1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.c.asset_id	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.11 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:3646
    11	JDHelper::getAuthorisedJDCategories()	JROOT/components/com_jdownloads/views/summary/view.html.php:60
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.64 ms Dopo l'ultima query: 2.39 ms Memoria query: 0.037 MB memoria prima della query: 3.453 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 jos_fields AS a
    
      LEFT JOIN `jos_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN jos_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN jos_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN jos_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN jos_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_jdownloads.download' 
      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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	knareaza_new.a.language	1	100.00	Using index condition
    1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.a.access	1	100.00	Using where
    1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.a.group_id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.19 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Creating tmp table	0.05 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
    15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
    14	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
    13	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jdownloads/views/summary/view.html.php:178
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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: 1.25 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.037 MB memoria prima della query: 3.468 MB Righe restituite: 31

    SHOW FULL COLUMNS 
      FROM `jos_content`

    Explain

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

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.30 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    executing	0.06 ms
    checking permissions	0.05 ms
    checking permissions	0.02 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.02 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.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
    15	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/content/easyopengraph/easyopengraph.php:29
    13	plgContentEasyOpenGraph->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jdownloads/views/summary/view.html.php:181
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.31 ms Dopo l'ultima query: 1.35 ms Memoria query: 0.036 MB memoria prima della query: 3.603 MB Righe restituite: 0

    SELECT *
    
      FROM jos_content
    
      WHERE `id` = '114'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.10 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    14	Joomla\CMS\Table\Table->load()	JROOT/plugins/content/easyopengraph/easyopengraph.php:30
    13	plgContentEasyOpenGraph->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_jdownloads/views/summary/view.html.php:181
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.09 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.007 MB memoria prima della query: 3.614 MB
    Query duplicate: #31

    
      SET SESSION SQL_BIG_SELECTS = 1

    Explain

    EXPLAIN non possibile sulla query: SET SESSION SQL_BIG_SELECTS = 1

    Profilo

    Status	Duration
    starting	0.03 ms
    Opening tables	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/components/com_jdownloads/helpers/categories.php:219
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    13	JDCategories->get()	JROOT/components/com_jdownloads/helpers/route.php:45
    12	JdownloadsHelperRoute::getDownloadRoute()	JROOT/components/com_jdownloads/views/summary/view.html.php:240
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tempo della query: 1.08 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.039 MB memoria prima della query: 3.629 MB Righe restituite: 4
    Query duplicate: #32

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid
    
      FROM jos_jdownloads_categories as c
    
      LEFT JOIN jos_jdownloads_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN `jos_jdownloads_files` AS files 
      ON files.`cat_id` = c.id 
      AND files.published = 1
    
      LEFT JOIN jos_users AS u 
      on u.id = files.created_id
    
      LEFT JOIN jos_users AS u2 
      on u2.id = files.modified_id
    
      LEFT JOIN (SELECT id, link, access, published 
      from jos_menu 
      GROUP BY link) AS menu 
      on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id) 
      AND menu.published = 1 
      AND menu.access IN (1,1,5)
    
      WHERE c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=10
    
      GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots,
                           c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	NULL	ALL	idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	44	3.28	Using where
    1	PRIMARY	files	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	knareaza_new.c.id	6	100.00	Using where
    1	PRIMARY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.files.created_id	1	100.00	NULL
    1	PRIMARY	u2	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.files.modified_id	1	100.00	NULL
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	100.00	Using where; Using join buffer (hash join)
    2	DERIVED	jos_menu	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	100.00	Using temporary

    Profilo

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Creating tmp table	0.07 ms
    executing	0.46 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.03 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/categories.php:328
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    13	JDCategories->get()	JROOT/components/com_jdownloads/helpers/route.php:45
    12	JdownloadsHelperRoute::getDownloadRoute()	JROOT/components/com_jdownloads/views/summary/view.html.php:240
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tempo della query: 0.26 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.025 MB memoria prima della query: 3.671 MB Righe restituite: 20
    Query duplicate: #33

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 47 
      AND 86 
      AND cat.published = 1 
      AND cat.access IN (1,1,5)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	index	idx_access,idx_left_right	PRIMARY	4	NULL	44	2.69	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    15	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    13	JDCategories->get()	JROOT/components/com_jdownloads/helpers/route.php:45
    12	JdownloadsHelperRoute::getDownloadRoute()	JROOT/components/com_jdownloads/views/summary/view.html.php:240
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tempo della query: 0.34 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.025 MB memoria prima della query: 3.680 MB Righe restituite: 1
    Query duplicate: #34

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,36,45,46,47) 
      AND files.published = 1 
      AND files.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ALL	idx_cat_id,idx_access,idx_published	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	249	59.52	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.11 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    14	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    13	JDCategories->get()	JROOT/components/com_jdownloads/helpers/route.php:45
    12	JdownloadsHelperRoute::getDownloadRoute()	JROOT/components/com_jdownloads/views/summary/view.html.php:240
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tempo della query: 0.07 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.006 MB memoria prima della query: 3.663 MB
    Query duplicate: #27

    
      SET SESSION SQL_BIG_SELECTS = 1

    Explain

    EXPLAIN non possibile sulla query: SET SESSION SQL_BIG_SELECTS = 1

    Profilo

    Status	Duration
    starting	0.02 ms
    Opening tables	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/components/com_jdownloads/helpers/categories.php:219
    13	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    12	JDCategories->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:243
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.91 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.038 MB memoria prima della query: 3.676 MB Righe restituite: 4
    Query duplicate: #28

    SELECT c.*, 
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(files.`file_id`) AS numitems,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid
    
      FROM jos_jdownloads_categories as c
    
      LEFT JOIN jos_jdownloads_categories AS s 
      ON (s.lft <= c.lft 
      AND s.rgt >= c.rgt) OR (s.lft > c.lft 
      AND s.rgt < c.rgt)
    
      LEFT JOIN `jos_jdownloads_files` AS files 
      ON files.`cat_id` = c.id 
      AND files.published = 1
    
      LEFT JOIN jos_users AS u 
      on u.id = files.created_id
    
      LEFT JOIN jos_users AS u2 
      on u2.id = files.modified_id
    
      LEFT JOIN (SELECT id, link, access, published 
      from jos_menu 
      GROUP BY link) AS menu 
      on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=',c.id) 
      AND menu.published = 1 
      AND menu.access IN (1,1,5)
    
      WHERE c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id=10
    
      GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.description, c.pic, c.access, c.metakey, c.metadesc, c.robots,
                           c.created_user_id, c.created_time, c.modified_user_id, c.modified_time, c.language, c.notes, c.views, c.params, c.password, c.password_md5, c.ordering, c.published, c.checked_out, c.checked_out_time, c.asset_id
    
      ORDER BY c.lft

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
    1	PRIMARY	c	NULL	ALL	idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	44	3.28	Using where
    1	PRIMARY	files	NULL	ref	idx_cat_id,idx_published	idx_cat_id	4	knareaza_new.c.id	6	100.00	Using where
    1	PRIMARY	u	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.files.created_id	1	100.00	NULL
    1	PRIMARY	u2	NULL	eq_ref	PRIMARY	PRIMARY	4	knareaza_new.files.modified_id	1	100.00	NULL
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	100.00	Using where; Using join buffer (hash join)
    2	DERIVED	jos_menu	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	100.00	Using temporary

    Profilo

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Creating tmp table	0.03 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Creating tmp table	0.06 ms
    executing	0.36 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/categories.php:328
    13	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    12	JDCategories->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:243
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tempo della query: 0.25 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.026 MB memoria prima della query: 3.725 MB Righe restituite: 20
    Query duplicate: #29

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 47 
      AND 86 
      AND cat.published = 1 
      AND cat.access IN (1,1,5)
    
      ORDER BY cat.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cat	NULL	index	idx_access,idx_left_right	PRIMARY	4	NULL	44	2.69	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    13	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    12	JDCategories->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:243
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.33 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.024 MB memoria prima della query: 3.735 MB Righe restituite: 1
    Query duplicate: #30

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,36,45,46,47) 
      AND files.published = 1 
      AND files.access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	files	NULL	ALL	idx_cat_id,idx_access,idx_published	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	249	59.52	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.10 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    13	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    12	JDCategories->get()	JROOT/components/com_jdownloads/views/summary/view.html.php:243
    11	jdownloadsViewSummary->_prepareDocument()	JROOT/components/com_jdownloads/views/summary/view.html.php:187
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.21 ms Dopo l'ultima query: 0.63 ms Memoria query: 0.027 MB memoria prima della query: 3.746 MB Righe restituite: 12
    Query duplicate: #16  #18

    SELECT group_id, importance, id
    
      FROM jos_jdownloads_usergroups_limits
    
      ORDER BY importance

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	100.00	Using filesort

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:91
    14	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:27
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.28 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.079 MB memoria prima della query: 3.759 MB Righe restituite: 1
    Query duplicate: #17  #19

    SELECT * 
      FROM jos_jdownloads_usergroups_limits 
      WHERE group_id IN (1)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_usergroups_limits	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	10.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.11 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:115
    14	JDHelper::getUserRules()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:27
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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: 49.17 ms Dopo l'ultima query: 7.29 ms Memoria query: 0.025 MB memoria prima della query: 3.817 MB Righe restituite: 1

    SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
    
      FROM jos_jdownloads_logs
    
      WHERE type = '1' 
      AND log_user = '0' 
      AND (log_datetime >= CURRENT_DATE 
      AND log_datetime < CURRENT_DATE + INTERVAL 1 DAY)
    
      GROUP BY log_user

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_logs	NULL	ref	idx_type,idx_log_user	idx_type	1	const	34742	5.55	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	48.74 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:1639
    14	JDHelper::getUserLimits()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:185
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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: 49.62 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.025 MB memoria prima della query: 3.825 MB Righe restituite: 1

    SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
    
      FROM jos_jdownloads_logs
    
      WHERE type = '1' 
      AND log_user = '0' 
      AND (log_datetime >= CURRENT_DATE - INTERVAL 6 DAY) 
      AND (log_datetime <= CURRENT_DATE + INTERVAL 1 DAY)
    
      GROUP BY log_user

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_logs	NULL	ref	idx_type,idx_log_user	idx_type	1	const	34742	5.55	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	49.23 ms
    end	0.04 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:1685
    14	JDHelper::getUserLimits()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:185
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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: 49.95 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.025 MB memoria prima della query: 3.834 MB Righe restituite: 1

    SELECT COUNT(log_file_id) AS sumfiles, ROUND(SUM(log_file_size)) AS sumsize
    
      FROM jos_jdownloads_logs
    
      WHERE type = '1' 
      AND log_user = '0' 
      AND (log_datetime >= CURRENT_DATE - INTERVAL 30 DAY) 
      AND (log_datetime <= CURRENT_DATE + INTERVAL 1 DAY)
    
      GROUP BY log_user

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_logs	NULL	ref	idx_type,idx_log_user	idx_type	1	const	34742	5.55	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	49.53 ms
    end	0.04 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.04 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:1732
    14	JDHelper::getUserLimits()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:185
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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.33 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.025 MB memoria prima della query: 3.842 MB Righe restituite: 0

    SELECT COUNT(log_file_id) AS sumfiles
    
      FROM jos_jdownloads_logs
    
      WHERE type = '2' 
      AND log_user = '0' 
      AND (log_datetime >= CURRENT_DATE 
      AND log_datetime < CURRENT_DATE + INTERVAL 1 DAY)
    
      GROUP BY log_user

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_logs	NULL	ref	idx_type,idx_log_user	idx_type	1	const	1	5.55	Using where

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:1778
    14	JDHelper::getUserLimits()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:185
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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: 46.01 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.025 MB memoria prima della query: 3.850 MB Righe restituite: 1

    SELECT log_file_id, COUNT(log_file_id) as count
    
      FROM jos_jdownloads_logs
    
      WHERE type = '1' 
      AND log_user = '0' 
      AND log_file_id IN (114)
    
      GROUP BY log_file_id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_logs	NULL	ref	idx_type,idx_log_user	idx_type	1	const	34742	5.00	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	45.70 ms
    end	0.04 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:1802
    14	JDHelper::getUserLimits()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:185
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Tempo della query: 0.41 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.031 MB memoria prima della query: 3.856 MB Righe restituite: 1

    SELECT * 
      FROM jos_jdownloads_templates 
      WHERE template_typ = '3' 
      AND template_active = '1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_templates	NULL	ref	idx_template_typ	idx_template_typ	1	const	1	10.00	Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.15 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:511
    14	JDHelper::getLayout()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:228
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

43. Tempo della query: 0.23 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.026 MB memoria prima della query: 3.869 MB Righe restituite: 0

    SELECT id, link, published, access, language 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads%') 
      AND published = 1 
      AND client_id = 0 
      AND language = 'it-it' 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	5.00	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:242
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

44. Tempo della query: 0.28 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.028 MB memoria prima della query: 3.876 MB Righe restituite: 18

    SELECT id, link, published, access, language 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads%') 
      AND published = 1 
      AND client_id = 0 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	75	0.72	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.12 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:247
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

45. Tempo della query: 0.19 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.025 MB memoria prima della query: 3.902 MB Righe restituite: 0
    Query duplicate: #47

    SELECT id 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
      AND published = 1 
      AND client_id = 0 
      AND language = 'it-it' 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	5.00	Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:294
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

46. Tempo della query: 0.24 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.025 MB memoria prima della query: 3.910 MB Righe restituite: 0
    Query duplicate: #48

    SELECT id 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
      AND published = 1 
      AND client_id = 0 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	75	0.72	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:298
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

47. Tempo della query: 0.16 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.025 MB memoria prima della query: 3.918 MB Righe restituite: 0
    Query duplicate: #45

    SELECT id 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
      AND published = 1 
      AND client_id = 0 
      AND language = 'it-it' 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	5.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:352
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

48. Tempo della query: 0.23 ms Dopo l'ultima query: 0.01 ms Memoria query: 0.025 MB memoria prima della query: 3.925 MB Righe restituite: 0
    Query duplicate: #46

    SELECT id 
      FROM jos_menu 
      WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories'  ) 
      AND published = 1 
      AND client_id = 0 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	75	0.72	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:356
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

49. Tempo della query: 0.16 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.025 MB memoria prima della query: 3.933 MB Righe restituite: 0

    SELECT id 
      FROM jos_menu 
      WHERE link = 'index.php?option=com_jdownloads&view=search' 
      AND published = 1 
      AND client_id = 0 
      AND language = 'it-it' 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	5.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:370
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

50. Tempo della query: 0.22 ms Dopo l'ultima query: 0.01 ms Memoria query: 0.025 MB memoria prima della query: 3.941 MB Righe restituite: 0

    SELECT id 
      FROM jos_menu 
      WHERE link = 'index.php?option=com_jdownloads&view=search' 
      AND published = 1 
      AND client_id = 0 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	75	0.72	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.08 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:374
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

51. Tempo della query: 0.16 ms Dopo l'ultima query: 0.01 ms Memoria query: 0.025 MB memoria prima della query: 3.948 MB Righe restituite: 0

    SELECT id 
      FROM jos_menu 
      WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' 
      AND published = 1 
      AND client_id = 0 
      AND language = 'it-it' 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language,idx_language	idx_language	28	const	1	5.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:380
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

52. Tempo della query: 0.21 ms Dopo l'ultima query: 0.01 ms Memoria query: 0.025 MB memoria prima della query: 3.956 MB Righe restituite: 0

    SELECT id 
      FROM jos_menu 
      WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' 
      AND published = 1 
      AND client_id = 0 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	75	0.72	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:384
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

53. Tempo della query: 0.15 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.025 MB memoria prima della query: 3.964 MB Righe restituite: 1

    SELECT parent_id 
      FROM jos_jdownloads_categories 
      WHERE id = 10 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:391
    14	JDHelper::getMenuItemids()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:240
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

54. Tempo della query: 0.22 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.953 MB Righe restituite: 18

    SELECT id, link 
      from jos_menu 
      WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' 
      AND published = 1 
      AND access IN (1,1,5)

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_menu	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	139	0.72	Using where

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/components/com_jdownloads/helpers/jdownloadshelper.php:416
    14	JDHelper::getAllJDCategoryMenuIDs()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:243
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

55. Tempo della query: 0.14 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.028 MB memoria prima della query: 3.979 MB Righe restituite: 1

    SELECT alias
    
      FROM jos_jdownloads_categories
    
      WHERE id=2

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:94
    21	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:310
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

56. Tempo della query: 0.13 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.028 MB memoria prima della query: 3.994 MB Righe restituite: 1
    Query duplicate: #64  #65

    SELECT alias
    
      FROM jos_jdownloads_categories
    
      WHERE id=10

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.00 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:293
    21	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:419
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

57. Tempo della query: 0.14 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.028 MB memoria prima della query: 4.004 MB Righe restituite: 1

    SELECT file_alias
    
      FROM jos_jdownloads_files
    
      WHERE file_id=114

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_files	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.01 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:310
    21	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    14	Joomla\CMS\Router\Route::_()	JROOT/components/com_jdownloads/views/summary/tmpl/default.php:419
    13	include JROOT/components/com_jdownloads/views/summary/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jdownloads/views/summary/view.html.php:189
    10	jdownloadsViewSummary->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_jdownloads/controller.php:92
    8	jdownloadsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jdownloads/jdownloads.php:34
    6	require_once JROOT/components/com_jdownloads/jdownloads.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:196
    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]

    ---

58. Tempo della query: 0.35 ms Dopo l'ultima query: 7.17 ms Memoria query: 0.028 MB memoria prima della query: 4.768 MB Righe restituite: 3
    Query duplicate: #14  #59

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	knareaza_new.e.element	1	60.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/gossipfx/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/gossipfx/lib/gantry/gantry.php	JROOT/templates/gossipfx/index.php:15
    7	require JROOT/templates/gossipfx/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:1030
    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:202
    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]

    ---

59. Tempo della query: 0.23 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.028 MB memoria prima della query: 4.779 MB Righe restituite: 3
    Query duplicate: #14  #58

    SELECT id, home, template, s.params
    
      FROM jos_template_styles as s
    
      LEFT JOIN jos_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	knareaza_new.e.element	1	60.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
    16	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
    15	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
    14	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
    13	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
    12	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
    11	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
    10	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
    9	include JROOT/libraries/gantry/gantry.php	JROOT/templates/gossipfx/lib/gantry/gantry.php:21
    8	require_once JROOT/templates/gossipfx/lib/gantry/gantry.php	JROOT/templates/gossipfx/index.php:15
    7	require JROOT/templates/gossipfx/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:1030
    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:202
    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]

    ---

60. Tempo della query: 0.73 ms Dopo l'ultima query: 17.43 ms Memoria query: 0.029 MB memoria prima della query: 4.950 MB Righe restituite: 8

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jos_modules AS m
    
      LEFT JOIN jos_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jos_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 <= '2024-10-22 03:11:59') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-22 03:11:59') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 309 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	14	2.08	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	knareaza_new.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	knareaza_new.m.id	1	40.00	Using where; Using index

    Profilo

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.03 ms
    executing	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    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:432
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    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/libraries/gantry/core/gantry.class.php:804
    11	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    10	Gantry->countModules()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:39
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/gossipfx/index.php:54
    7	require JROOT/templates/gossipfx/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:1030
    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:202
    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]

    ---

61. Tempo della query: 0.22 ms Dopo l'ultima query: 1.97 ms Memoria query: 0.026 MB memoria prima della query: 5.089 MB Righe restituite: 0

    SELECT ts.template
    
      FROM jos_template_styles AS ts
    
      INNER JOIN jos_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 309 
      AND m.template_style_id != 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/gossipfx/features/dropdownmenu.php:62
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/gossipfx/index.php:77
    7	require JROOT/templates/gossipfx/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:1030
    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:202
    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]

    ---

62. Tempo della query: 0.19 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.026 MB memoria prima della query: 5.097 MB Righe restituite: 1

    SELECT template
    
      FROM jos_template_styles
    
      WHERE home = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	3	20.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.00 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/gossipfx/features/dropdownmenu.php:62
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/gossipfx/index.php:77
    7	require JROOT/templates/gossipfx/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:1030
    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:202
    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]

    ---

63. Tempo della query: 0.34 ms Dopo l'ultima query: 12.32 ms Memoria query: 0.027 MB memoria prima della query: 5.419 MB Righe restituite: 1

    SELECT alias
    
      FROM jos_jdownloads_categories
    
      WHERE id=36

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:94
    19	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
    11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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: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:1044
    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:202
    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]

    ---

64. Tempo della query: 0.19 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.027 MB memoria prima della query: 5.430 MB Righe restituite: 1
    Query duplicate: #56  #65

    SELECT alias
    
      FROM jos_jdownloads_categories
    
      WHERE id=10

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:94
    19	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
    11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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: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:1044
    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:202
    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]

    ---

65. Tempo della query: 0.17 ms Dopo l'ultima query: 0.05 ms Memoria query: 0.032 MB memoria prima della query: 5.450 MB Righe restituite: 1
    Query duplicate: #56  #64

    SELECT alias
    
      FROM jos_jdownloads_categories
    
      WHERE id=10

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_jdownloads_categories	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/router.php:119
    19	JDownloadsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:54
    11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
    10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.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: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:1044
    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:202
    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]

    ---

66. Tempo della query: 1.06 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.029 MB memoria prima della query: 5.452 MB Righe restituite: 6

    SHOW FULL COLUMNS 
      FROM `jos_template_styles`

    Explain

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

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.38 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    executing	0.07 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1044
    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:202
    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]

    ---

67. Tempo della query: 0.27 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.026 MB memoria prima della query: 5.475 MB Righe restituite: 1

    SELECT *
    
      FROM jos_template_styles
    
      WHERE `id` = '10'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	jos_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->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:1044
    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:202
    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]

    ---

68. Tempo della query: 2.27 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.028 MB memoria prima della query: 5.540 MB Righe restituite: 119
    Query duplicate: #6  #10

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

    Status	Duration
    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.03 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
    8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:253
    7	plgSystemjdownloads->onAfterRender()	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/CMSApplication.php:1050
    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:202
    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]

    ---