{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733988532,
                "last": 1733988532,
                "now": 1733988532
            },
            "token": "gyzoP6G2zs8ePWXQO8AO1W4lnTII8yhD"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "",
                "abbr": "",
                "name": ""
            }
        },
        "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
    }
}

Tempo

Memoria

112 query eseguite 92.25 ms

1. Tempo della query: 1.13 ms Memoria query: 0.025 MB memoria prima della query: 1.553 MB Righe restituite: 0

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

   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

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

   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: 15.39 ms Dopo l'ultima query: 1.80 ms Memoria query: 0.022 MB memoria prima della query: 1.631 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `jos_session`
   
     WHERE `session_id` = X'3836616335633236653739666136366665636230653563353631643263623439' 
     LIMIT 1

   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	Using index

   Profilo

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   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]

   ---

3. Tempo della query: 22.93 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.004 MB memoria prima della query: 1.636 MB

   INSERT INTO `jos_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3836616335633236653739666136366665636230653563353631643263623439', 1, 1733988532, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3836616335633236653739666136366665636230653563353631643263623439', 1, 1733988532, 0, '', 0)

   Profilo

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   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]

   ---

4. Tempo della query: 1.67 ms Dopo l'ultima query: 4.76 ms Memoria query: 0.039 MB memoria prima della query: 1.673 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

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

   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]

   ---

5. Tempo della query: 1.62 ms Dopo l'ultima query: 3.85 ms Memoria query: 0.023 MB memoria prima della query: 1.789 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

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

   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]

   ---

6. Tempo della query: 0.80 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.022 MB memoria prima della query: 1.802 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

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

   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]

   ---

7. Tempo della query: 0.61 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.034 MB memoria prima della query: 1.824 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

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

   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]

   ---

8. Tempo della query: 2.30 ms Dopo l'ultima query: 120.66 ms Memoria query: 0.028 MB memoria prima della query: 2.366 MB Righe restituite: 119
   Query duplicate: #12  #112

   SHOW TABLES

   Explain

   EXPLAIN non possibile sulla query: SHOW TABLES

   Profilo

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

   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]

   ---

9. Tempo della query: 1.87 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.022 MB memoria prima della query: 2.387 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-12-12 08:28:53'

   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

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

   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]

   ---

10. Tempo della query: 0.23 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.022 MB memoria prima della query: 2.393 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-12-12 08:28:53'

    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

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

    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]

    ---

11. Tempo della query: 1.32 ms Dopo l'ultima query: 6.35 ms Memoria query: 0.096 MB memoria prima della query: 2.483 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

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

    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]

    ---

12. Tempo della query: 2.07 ms Dopo l'ultima query: 16.32 ms Memoria query: 0.028 MB memoria prima della query: 2.921 MB Righe restituite: 119
    Query duplicate: #8  #112

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

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

    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]

    ---

13. Tempo della query: 0.27 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.025 MB memoria prima della query: 2.947 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

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

    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]

    ---

14. Tempo della query: 0.73 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.005 MB memoria prima della query: 2.937 MB

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

    Explain

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

    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.03 ms
    updating	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.51 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]

    ---

15. Tempo della query: 0.86 ms Dopo l'ultima query: 2.70 ms Memoria query: 0.025 MB memoria prima della query: 3.024 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.02 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.60 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 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]

    ---

16. Tempo della query: 0.80 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.021 MB memoria prima della query: 3.039 MB Righe restituite: 3
    Query duplicate: #102  #103

    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.05 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.44 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.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 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]

    ---

17. Tempo della query: 1.03 ms Dopo l'ultima query: 9.69 ms Memoria query: 0.086 MB memoria prima della query: 3.162 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.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.58 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.15 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.02 ms
    cleaning up	0.02 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]

    ---

18. Tempo della query: 2.62 ms Dopo l'ultima query: 7.97 ms Memoria query: 0.025 MB memoria prima della query: 3.349 MB Righe restituite: 12
    Query duplicate: #69

    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.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	2.11 ms
    init	0.02 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.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.23 ms
    freeing items	0.02 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/category/view.html.php:40
    10	JdownloadsViewCategory->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.31 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.078 MB memoria prima della query: 3.361 MB Righe restituite: 1
    Query duplicate: #70

    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.03 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.10 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
    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/category/view.html.php:40
    10	JdownloadsViewCategory->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.82 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.032 MB memoria prima della query: 3.405 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.42 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.15 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.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/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_jdownloads/models/category.php:184
    13	JdownloadsModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:44
    10	JdownloadsViewCategory->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.10 ms Dopo l'ultima query: 1.30 ms Memoria query: 0.007 MB memoria prima della query: 3.466 MB

    
      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
    16	JDatabaseDriverMysqli->execute()	JROOT/components/com_jdownloads/helpers/categories.php:219
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 5.96 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.049 MB memoria prima della query: 3.481 MB Righe restituite: 16

    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=2
    
      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.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.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.09 ms
    init	0.02 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.03 ms
    Creating tmp table	0.07 ms
    executing	4.25 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.11 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_jdownloads/helpers/categories.php:328
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.25 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.026 MB memoria prima della query: 3.627 MB Righe restituite: 20

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.37 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.026 MB memoria prima della query: 3.637 MB Righe restituite: 1

    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.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.06 ms
    preparing	0.02 ms
    executing	0.14 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 0.21 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.645 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 49 
      AND 50 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.03 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.21 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.652 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (10) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	1	77.60	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.02 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.19 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.661 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 51 
      AND 52 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 0.20 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.668 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (3) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	11	77.60	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.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.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.18 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.677 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 53 
      AND 54 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.19 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.685 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (7) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	3	77.60	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.03 ms
    preparing	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.18 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.694 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 55 
      AND 56 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.18 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.701 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (8) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	1	77.60	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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.18 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.027 MB memoria prima della query: 3.717 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 57 
      AND 58 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 ms
    preparing	0.01 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.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.19 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.726 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (12) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	16	77.60	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.02 ms
    preparing	0.01 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.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.18 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.734 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 59 
      AND 60 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 ms
    preparing	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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.21 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.742 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (11) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	29	77.60	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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 0.17 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.751 MB Righe restituite: 1

    SELECT cat.id
    
      FROM jos_jdownloads_categories as cat
    
      WHERE cat.lft BETWEEN 61 
      AND 62 
      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	range	idx_access,idx_left_right	idx_left_right	4	NULL	1	5.91	Using index condition; Using where; 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.02 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/components/com_jdownloads/helpers/categories.php:364
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 0.21 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.759 MB Righe restituite: 1

    SELECT COUNT(*)
    
      FROM jos_jdownloads_files as files
    
      WHERE files.cat_id IN (9) 
      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	ref	idx_cat_id,idx_access,idx_published	idx_cat_id	4	const	28	77.60	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.02 ms
    preparing	0.01 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.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    16	JDatabaseDriver->loadResult()	JROOT/components/com_jdownloads/helpers/categories.php:380
    15	JDCategories->_load()	JROOT/components/com_jdownloads/helpers/categories.php:181
    14	JDCategories->get()	JROOT/components/com_jdownloads/models/category.php:440
    13	JdownloadsModelCategory->getCategory()	JROOT/components/com_jdownloads/models/category.php:326
    12	JdownloadsModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_jdownloads/views/category/view.html.php:46
    10	JdownloadsViewCategory->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: 0.17 ms Dopo l'ultima query: 0.02 ms Memoria query: 0.026 MB memoria prima della query: 3.767 MB Righe restituite: 1