Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 14,
            "timer": {
                "start": 1793217072,
                "last": 1793217100,
                "now": 1793217102
            },
            "token": "iJVWmPilZ9YL9j72vIzEyOCB2aUUyMjr"
        },
        "registry": {
            "com_users": {
                "edit": {
                    "profile": {
                        "id": 0
                    }
                }
            },
            "com_kunena": {
                "user0_read": {
                    "4": 4,
                    "20": 20,
                    "10": 10,
                    "14": 14,
                    "2": 2,
                    "1": 1,
                    "7": 7,
                    "3": 3,
                    "15": 15,
                    "11": 11,
                    "5": 5,
                    "21": 21,
                    "22": 22,
                    "12": 12,
                    "8": 8,
                    "9": 9,
                    "16": 16,
                    "18": 18,
                    "13": 13,
                    "17": 17,
                    "19": 19
                }
            },
            "com_easyblog": {
                "blogs": {
                    "limitstart": 60
                },
                "tags": {
                    "limitstart": 60
                },
                "categories": {
                    "limitstart": 60
                },
                "revisions": {
                    "limitstart": 60
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "jsn_original_id": 0,
        "989f51698c774368872661177b246abe": 1,
        "jsn_profile_item_id_1215": "510",
        "5781d0b084f047c459cbd129ceba1746": 1,
        "jsn_profile_item_id_1591": "510",
        "com_mailto": {
            "links": {
                "123a410e748352fa5ccc1bcdd0f4839ef2f8f4f0": {
                    "link": "https:\/\/pc-crash.marcellinux.com\/pc-crash\/formazione\/programmi-pratici-intermedi\/83-compatibilita-dei-danni",
                    "expiry": 1793217082
                }
            }
        },
        "624f96f6fba1bec1b58ca167f6c55447": 1,
        "jsn_profile_item_id_1510": "510",
        "eb_device_type": "desktop"
    },
    "__easyblog": {
        "site": {
            "messages": null
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 6.76 ms / 6.76 ms Memoria: 0.477 MB / 0.82 MB Application: afterLoad

Tempo: 120.35 ms / 127.10 ms Memoria: 2.353 MB / 3.17 MB Application: afterInitialise

Tempo: 8.75 ms / 135.85 ms Memoria: 0.487 MB / 3.66 MB Application: Before Access::preloadComponents (all components)

Tempo: 1.55 ms / 137.40 ms Memoria: 0.066 MB / 3.72 MB Application: After Access::preloadComponents (all components)

Tempo: 0.04 ms / 137.44 ms Memoria: 0.000 MB / 3.72 MB Application: Before Access::getAssetRules (id:24 name:com_users)

Tempo: 0.31 ms / 137.75 ms Memoria: 0.009 MB / 3.73 MB Application: After Access::getAssetRules (id:24 name:com_users)

Tempo: 81.76 ms / 219.51 ms Memoria: 0.355 MB / 4.08 MB Application: afterRoute

Tempo: 1.84 ms / 221.35 ms Memoria: 0.023 MB / 4.11 MB Application: beforeRenderComponent com_eventbooking

Tempo: 118.62 ms / 339.97 ms Memoria: 0.841 MB / 4.95 MB Application: afterRenderComponent com_eventbooking

Tempo: 0.77 ms / 340.74 ms Memoria: 0.009 MB / 4.96 MB Application: afterDispatch

Tempo: 78.12 ms / 418.86 ms Memoria: 1.412 MB / 6.37 MB Application: beforeRenderModule mod_footer (Footer)

Tempo: 1.22 ms / 420.07 ms Memoria: 0.007 MB / 6.38 MB Application: afterRenderModule mod_footer (Footer)

Tempo: 0.10 ms / 420.17 ms Memoria: 0.000 MB / 6.38 MB Application: beforeRenderModule mod_weblinks (LINK UTILI)

Tempo: 8.53 ms / 428.70 ms Memoria: 0.153 MB / 6.53 MB Application: afterRenderModule mod_weblinks (LINK UTILI)

Tempo: 0.16 ms / 428.86 ms Memoria: 0.000 MB / 6.46 MB Application: beforeRenderModule mod_menu (Sito Web)

Tempo: 3.16 ms / 432.03 ms Memoria: 0.040 MB / 6.50 MB Application: afterRenderModule mod_menu (Sito Web)

Tempo: 0.10 ms / 432.13 ms Memoria: 0.000 MB / 6.50 MB Application: beforeRenderModule mod_menu (PC-CRASH)

Tempo: 2.48 ms / 434.61 ms Memoria: 0.029 MB / 6.53 MB Application: afterRenderModule mod_menu (PC-CRASH)

Tempo: 0.09 ms / 434.70 ms Memoria: 0.000 MB / 6.53 MB Application: beforeRenderModule mod_menu (Azienda)

Tempo: 1.90 ms / 436.60 ms Memoria: 0.021 MB / 6.55 MB Application: afterRenderModule mod_menu (Azienda)

Tempo: 0.09 ms / 436.69 ms Memoria: 0.000 MB / 6.55 MB Application: beforeRenderModule mod_custom (Chi Siamo)

Tempo: 0.81 ms / 437.49 ms Memoria: 0.005 MB / 6.55 MB Application: afterRenderModule mod_custom (Chi Siamo)

Tempo: 0.08 ms / 437.57 ms Memoria: 0.001 MB / 6.55 MB Application: beforeRenderModule mod_custom (Maggiori informazioni)

Tempo: 0.29 ms / 437.86 ms Memoria: 0.003 MB / 6.56 MB Application: afterRenderModule mod_custom (Maggiori informazioni)

Tempo: 0.09 ms / 437.95 ms Memoria: 0.000 MB / 6.56 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 1.58 ms / 439.54 ms Memoria: 0.013 MB / 6.57 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 0.07 ms / 439.60 ms Memoria: 0.000 MB / 6.57 MB Application: beforeRenderModule mod_login (Accesso Utenti)

Tempo: 1.81 ms / 441.41 ms Memoria: 0.084 MB / 6.65 MB Application: afterRenderModule mod_login (Accesso Utenti)

Tempo: 9.87 ms / 451.28 ms Memoria: 0.629 MB / 7.28 MB Application: Before Access::getAssetRules (id:285 name:com_kunena)

Tempo: 0.06 ms / 451.34 ms Memoria: 0.007 MB / 7.29 MB Application: After Access::getAssetRules (id:285 name:com_kunena)

Tempo: 84.91 ms / 536.25 ms Memoria: 0.733 MB / 8.02 MB Application: afterRender

Query totali del database: 260.41 ms

Utilizzo memoria

Query Database

61 query eseguite 260.41 ms

Tempo della query: 0.71 ms Memoria query: 0.027 MB memoria prima della query: 1.147 MB Righe restituite: 1

SELECT `data`

  FROM `avjbq_session`

  WHERE `session_id` = 'b777a7f3e334de5f428f3a8ed3adf0b6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_session	const	PRIMARY	PRIMARY	766	const	1

Profilo

Status	Duration
Starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:861
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
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:458
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]

Tempo della query: 1.01 ms Dopo l'ultima query: 1.95 ms Memoria query: 0.042 MB memoria prima della query: 1.274 MB Righe restituite: 48

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `avjbq_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_extensions	ref	extension	extension	82	const	48	Using index condition

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.32 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
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:596
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:310
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]

Tempo della query: 0.65 ms Dopo l'ultima query: 1.22 ms Memoria query: 0.023 MB memoria prima della query: 1.336 MB Righe restituite: 13

SELECT id, rules

  FROM `avjbq_viewlevels`

Explain

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

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

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

Tempo della query: 0.72 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.023 MB memoria prima della query: 1.351 MB Righe restituite: 2

SELECT b.id

  FROM avjbq_usergroups AS a

  LEFT JOIN avjbq_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.03 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

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

Tempo della query: 1.89 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.041 MB memoria prima della query: 1.373 MB Righe restituite: 182

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM avjbq_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

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

Profilo

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	1.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
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:606
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:310
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]

Tempo della query: 2.83 ms Dopo l'ultima query: 9.72 ms Memoria query: 0.179 MB memoria prima della query: 1.997 MB Righe restituite: 144

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 avjbq_menu AS m

  LEFT JOIN avjbq_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

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

Profilo

Status	Duration
Starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.91 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:489
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
11	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
10	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:594
9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jmap/jmap.php:818
7	plgSystemJMap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:728
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:310
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]

Tempo della query: 0.67 ms Dopo l'ultima query: 90.06 ms Memoria query: 0.026 MB memoria prima della query: 3.157 MB Righe restituite: 33

SELECT *

  FROM avjbq_rsform_config

Explain

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

Profilo

Status	Duration
Starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->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:729
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
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:310
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]

Tempo della query: 0.88 ms Dopo l'ultima query: 5.50 ms Memoria query: 0.024 MB memoria prima della query: 3.423 MB Righe restituite: 3

SELECT id, home, template, s.params

  FROM avjbq_template_styles as s

  LEFT JOIN avjbq_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

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

Profilo

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:307
9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
8	plgSystemT3->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:1186
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:310
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]

Tempo della query: 1.28 ms Dopo l'ultima query: 2.95 ms Memoria query: 0.029 MB memoria prima della query: 3.661 MB Righe restituite: 48

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `avjbq_assets`

  WHERE `name` IN ('root.1','com_acymailing','com_acysms','com_admin','com_advpoll','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_edocman','com_eventbooking','com_fields','com_finder','com_helpdeskpro','com_installer','com_jaextmanager','com_jce','com_jmap','com_joomailermailchimpintegration','com_joomlaupdate','com_jsn','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_assets	range	idx_asset_name	idx_asset_name	202	NULL	49	Using index condition

Profilo

Status	Duration
Starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.02 ms
Statistics	0.18 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.46 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
13	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
12	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
11	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
10	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
9	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jsn_system/jsn_system.php:116
8	plgSystemJsn_System->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1186
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:310
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]

Tempo della query: 0.71 ms Dopo l'ultima query: 77.00 ms Memoria query: 0.025 MB memoria prima della query: 4.007 MB Righe restituite: 19

SELECT * 
  FROM avjbq_acysms_config

Explain

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

Profilo

Status	Duration
Starting	0.19 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.06 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acysms/classes/cpanel.php:17
12	ACYSMScpanelClass->load()	JROOT/administrator/components/com_acysms/helpers/helper.php:265
11	ACYSMS::config()	JROOT/administrator/components/com_acysms/helpers/helper.php:774
10	include_once JROOT/administrator/components/com_acysms/helpers/helper.php	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:30
9	plgSystemAcySMSVerifNumber->init()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:48
8	plgSystemAcySMSVerifNumber->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:1186
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:310
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]

Tempo della query: 0.73 ms Dopo l'ultima query: 1.21 ms Memoria query: 0.030 MB memoria prima della query: 4.060 MB Righe restituite: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `avjbq_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.06 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
27	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
13	JHtmlBehavior::framework()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_acysms/compat/compat3.php:35
9	acysms_loadMootools()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:49
8	plgSystemAcySMSVerifNumber->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:1186
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:310
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]

Tempo della query: 1.24 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.010 MB memoria prima della query: 4.055 MB

UPDATE `avjbq_extensions`

  SET `params` = '{\"mediaversion\":\"2b4eb7240ddbaa804fd1c85178e78e91\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

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

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.12 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.58 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
21	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/behavior.php:63
13	JHtmlBehavior::framework()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/administrator/components/com_acysms/compat/compat3.php:35
9	acysms_loadMootools()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:49
8	plgSystemAcySMSVerifNumber->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:1186
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
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:310
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]

Tempo della query: 0.67 ms Dopo l'ultima query: 1.32 ms Memoria query: 0.025 MB memoria prima della query: 4.087 MB Righe restituite: 2

SELECT *

  FROM avjbq_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

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

Tempo della query: 1.11 ms Dopo l'ultima query: 1.71 ms Memoria query: 0.070 MB memoria prima della query: 4.238 MB Righe restituite: 239

SELECT `config_key`,`config_value`

  FROM avjbq_eb_configs

Explain

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

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.56 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.09 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
9	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:115
8	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:66
7	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/components/com_eventbooking/eventbooking.php:14
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.60 ms Dopo l'ultima query: 1.81 ms Memoria query: 0.027 MB memoria prima della query: 4.351 MB Righe restituite: 1

SELECT *

  FROM avjbq_eb_themes

  WHERE published = 1

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
10	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:275
9	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/controller.php:99
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 1.88 ms Dopo l'ultima query: 1.68 ms Memoria query: 0.050 MB memoria prima della query: 4.440 MB Righe restituite: 116

SHOW FULL COLUMNS 
  FROM `avjbq_eb_events`

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
checking permissions	0.49 ms
closing tables	0.02 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.15 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.06 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:79
13	RADModelList->__construct()	JROOT/components/com_eventbooking/model/list.php:115
12	EventbookingModelList->__construct()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/model.php:115
11	RADModel::getInstance()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:358
10	RADController->getModel()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:303
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 1.61 ms Dopo l'ultima query: 1.38 ms Memoria query: 0.025 MB memoria prima della query: 4.485 MB Righe restituite: 1

SELECT COUNT(*)

  FROM avjbq_eb_events AS tbl

  WHERE tbl.event_date < '2026-10-28 19:51:42' 
  AND tbl.published = 1 
  AND tbl.access IN (1,1,5) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2026-10-28 19:51:42') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2026-10-28 19:51:42')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ref	idx_access,idx_published,idx_event_date	idx_published	5	const	80	Using where

Profilo

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.15 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.76 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:202
12	RADModelList->getTotal()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:164
11	RADModelList->getData()	JROOT/components/com_eventbooking/view/archive/html.php:20
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 86.05 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.082 MB memoria prima della query: 4.491 MB Righe restituite: 5

SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2026-10-28 19:51:42') AS date_diff,DATEDIFF('2026-10-28 19:51:42', tbl.late_fee_date) AS late_fee_date_diff,DATEDIFF(tbl.event_date, '2026-10-28 19:51:42') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2026-10-28 19:51:42') AS event_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.registration_start_date, '2026-10-28 19:51:42') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2026-10-28 19:51:42') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants,u.name as creator_name

  FROM avjbq_eb_events AS tbl

  LEFT JOIN avjbq_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3))))

  LEFT JOIN avjbq_eb_locations AS c 
  ON tbl.location_id = c.id 

  LEFT JOIN avjbq_users as u 
  ON tbl.created_by = u.id

  WHERE tbl.event_date < '2026-10-28 19:51:42' 
  AND tbl.published = 1 
  AND tbl.access IN (1,1,5) 
  AND (tbl.publish_up = '0000-00-00 00:00:00' OR tbl.publish_up <= '2026-10-28 19:51:42') 
  AND (tbl.publish_down = '0000-00-00 00:00:00' OR tbl.publish_down >= '2026-10-28 19:51:42')

  GROUP BY tbl.id

  ORDER BY tbl.event_date DESC 
  LIMIT 110, 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	tbl	ref	idx_access,idx_published,idx_event_date	idx_published	5	const	80	Using where; Using temporary; Using filesort
1	SIMPLE	b	ref	jos_eb_registrants_FKIndex1,idx_published	jos_eb_registrants_FKIndex1	5	aqtpboka_pc_crash.tbl.id	9	Using where
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.tbl.location_id	1
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.tbl.created_by	1	Using where

Profilo

Status	Duration
Starting	0.28 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.15 ms
Optimizing	0.08 ms
Statistics	0.15 ms
Preparing	0.08 ms
Creating tmp table	0.13 ms
Sorting for group	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	69.47 ms
Creating sort index	1.42 ms
Removing tmp table	0.21 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	13.55 ms
Freeing items	0.11 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:178
11	RADModelList->getData()	JROOT/components/com_eventbooking/view/archive/html.php:20
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.83 ms Dopo l'ultima query: 0.51 ms Memoria query: 0.044 MB memoria prima della query: 4.594 MB Righe restituite: 28

SELECT *

  FROM avjbq_eb_locations

Explain

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

Profilo

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.32 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:537
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/model/list.php:196
12	EventbookingModelList->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:180
11	RADModelList->getData()	JROOT/components/com_eventbooking/view/archive/html.php:20
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.81 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.026 MB memoria prima della query: 4.676 MB Righe restituite: 8

SELECT a.id, a.name, a.alias, b.event_id

  FROM avjbq_eb_categories AS a

  INNER JOIN avjbq_eb_event_categories AS b 
  ON a.id = b.category_id

  WHERE b.event_id IN (20,5,14,6,13)

  ORDER BY b.id

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	range	avjbq_eb_event_categories_FKIndex1,avjbq_eb_event_categories_FKIndex2	avjbq_eb_event_categories_FKIndex1	5	NULL	8	Using index condition; Using where; Using filesort
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.b.category_id	1

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.05 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/data.php:564
13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/model/list.php:196
12	EventbookingModelList->beforeReturnData()	JROOT/administrator/components/com_eventbooking/libraries/rad/model/list.php:180
11	RADModelList->getData()	JROOT/components/com_eventbooking/view/archive/html.php:20
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.45 ms Dopo l'ultima query: 4.61 ms Memoria query: 0.025 MB memoria prima della query: 4.778 MB Righe restituite: 1

SELECT category_id

  FROM avjbq_eb_event_categories

  WHERE event_id = 20 
  AND main_category = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_event_categories	ref	avjbq_eb_event_categories_FKIndex1	avjbq_eb_event_categories_FKIndex1	5	const	2	Using where

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:62
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.027 MB memoria prima della query: 4.787 MB Righe restituite: 11

SELECT id, parent,alias

  FROM avjbq_eb_categories

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/route.php:224
15	EventbookingHelperRoute::getCategoriesPath()	JROOT/components/com_eventbooking/helper/route.php:67
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.43 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.028 MB memoria prima della query: 4.803 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_events

  WHERE id = 20

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.04 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:156
20	EventbookingHelperRoute::getEventTitle()	JROOT/components/com_eventbooking/router.php:124
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.43 ms Dopo l'ultima query: 1.14 ms Memoria query: 0.027 MB memoria prima della query: 4.876 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = '0db3b0cf2bc54e55fb0f6cda5bb4f08c'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.028 MB memoria prima della query: 4.894 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_locations

  WHERE id = 6

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:190
20	EventbookingHelperRoute::getLocationTitle()	JROOT/components/com_eventbooking/router.php:176
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.027 MB memoria prima della query: 4.906 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = '100b1cf3c307adcd40b2cd0402a47e72'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.41 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.025 MB memoria prima della query: 4.916 MB Righe restituite: 1

SELECT category_id

  FROM avjbq_eb_event_categories

  WHERE event_id = 5 
  AND main_category = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_event_categories	ref	avjbq_eb_event_categories_FKIndex1	avjbq_eb_event_categories_FKIndex1	5	const	2	Using where

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:62
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.38 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.028 MB memoria prima della query: 4.924 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_events

  WHERE id = 5

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:156
20	EventbookingHelperRoute::getEventTitle()	JROOT/components/com_eventbooking/router.php:124
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.44 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.027 MB memoria prima della query: 4.937 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = 'bb504fcaaf993086f0091e7ed630b1f7'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.028 MB memoria prima della query: 4.946 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_locations

  WHERE id = 2

Explain

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

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:190
20	EventbookingHelperRoute::getLocationTitle()	JROOT/components/com_eventbooking/router.php:176
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.027 MB memoria prima della query: 4.958 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = '5685a5541a1494972f01caa9bee6a768'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.025 MB memoria prima della query: 4.967 MB Righe restituite: 1

SELECT category_id

  FROM avjbq_eb_event_categories

  WHERE event_id = 14 
  AND main_category = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_event_categories	ref	avjbq_eb_event_categories_FKIndex1	avjbq_eb_event_categories_FKIndex1	5	const	1	Using where

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:62
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.029 MB memoria prima della query: 4.982 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_events

  WHERE id = 14

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:156
20	EventbookingHelperRoute::getEventTitle()	JROOT/components/com_eventbooking/router.php:124
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.39 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.027 MB memoria prima della query: 4.996 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = 'a2946fabd57c54b1325299bddf189a12'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.38 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.025 MB memoria prima della query: 5.005 MB Righe restituite: 1

SELECT category_id

  FROM avjbq_eb_event_categories

  WHERE event_id = 6 
  AND main_category = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_event_categories	ref	avjbq_eb_event_categories_FKIndex1	avjbq_eb_event_categories_FKIndex1	5	const	1	Using where

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:62
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.028 MB memoria prima della query: 5.014 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_events

  WHERE id = 6

Explain

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

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:156
20	EventbookingHelperRoute::getEventTitle()	JROOT/components/com_eventbooking/router.php:124
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.38 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.027 MB memoria prima della query: 5.026 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = 'ec4659a4d02743039deb9e905cd4bd93'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.33 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.028 MB memoria prima della query: 5.051 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_locations

  WHERE id = 3

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:190
20	EventbookingHelperRoute::getLocationTitle()	JROOT/components/com_eventbooking/router.php:176
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.36 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.027 MB memoria prima della query: 5.063 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = 'c91ca5f9561c755fb245b34bfeb178c5'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:289
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.37 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.025 MB memoria prima della query: 5.072 MB Righe restituite: 1

SELECT category_id

  FROM avjbq_eb_event_categories

  WHERE event_id = 13 
  AND main_category = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_event_categories	ref	avjbq_eb_event_categories_FKIndex1	avjbq_eb_event_categories_FKIndex1	5	const	2	Using where

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:62
14	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.34 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.028 MB memoria prima della query: 5.080 MB Righe restituite: 1

SELECT alias

  FROM avjbq_eb_events

  WHERE id = 13

Explain

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

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
21	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/helper/route.php:156
20	EventbookingHelperRoute::getEventTitle()	JROOT/components/com_eventbooking/router.php:124
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 0.35 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.027 MB memoria prima della query: 5.093 MB Righe restituite: 1

SELECT id

  FROM avjbq_eb_urls

  WHERE md5_key = 'b76e86df0e229470513a7f2efb2365ab'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

Profilo

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
20	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:390
19	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
14	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/archive/default.php:49
13	include JROOT/components/com_eventbooking/themes/default/archive/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:238
12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:131
11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/archive/html.php:59
10	EventbookingViewArchiveHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:308
9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:107
8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:273
7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:22
6	require_once JROOT/components/com_eventbooking/eventbooking.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
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:310
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]

Tempo della query: 1.42 ms Dopo l'ultima query: 4.15 ms Memoria query: 0.030 MB memoria prima della query: 5.027 MB Righe restituite: 11

SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM avjbq_modules AS m

  LEFT JOIN avjbq_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN avjbq_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-10-28 19:51:42') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-10-28 19:51:42') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 759 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	58	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	aqtpboka_pc_crash.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.m.id	2	Using where; Using index

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.74 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423
15	JModuleHelper::_load()	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102
14	JModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:594
13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:608
12	T3Template->countModules()	JROOT/templates/ja_sugite/tpls/blocks/header.php:28
11	include JROOT/templates/ja_sugite/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/default.php:45
9	include JROOT/templates/ja_sugite/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/ja_sugite/index.php:34
7	require JROOT/templates/ja_sugite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1133
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.61 ms Dopo l'ultima query: 3.66 ms Memoria query: 0.080 MB memoria prima della query: 5.282 MB Righe restituite: 1

SELECT *

  FROM avjbq_easyblog_configs

  WHERE `name` = 'config'

Explain

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

Profilo

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:441
19	EB::config()	JROOT/plugins/user/easyblogusers/easyblogusers.php:29
18	plgUserEasyBlogUsers->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
17	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
16	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_jsn/helpers/helper.php:532
15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
14	JsnHelper::getUser()	JROOT/templates/ja_sugite/tpls/blocks/mainbody/no-sidebar.php:18
13	include JROOT/templates/ja_sugite/tpls/blocks/mainbody/no-sidebar.php	JROOT/plugins/system/t3/includes/core/template.php:176
12	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/blocks/mainbody.php:38
11	include JROOT/templates/ja_sugite/tpls/blocks/mainbody.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/default.php:51
9	include JROOT/templates/ja_sugite/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/ja_sugite/index.php:34
7	require JROOT/templates/ja_sugite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1133
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 63.68 ms Dopo l'ultima query: 3.93 ms Memoria query: 0.260 MB memoria prima della query: 5.497 MB Righe restituite: 70

SELECT a.*,b.access as parent_access

  FROM avjbq_jsn_fields AS a

  LEFT JOIN avjbq_jsn_fields AS b 
  ON a.parent_id = b.id

  WHERE a.level = 2 
  AND a.published = 1

  ORDER BY a.lft ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	95	Using where; Using filesort
1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.parent_id	1

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.60 ms
End of update loop	57.32 ms
Query end	0.06 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	5.06 ms
Freeing items	0.07 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/components/com_jsn/helpers/helper.php:233
16	JsnHelper::excludeFromProfile()	JROOT/components/com_jsn/helpers/helper.php:545
15	JsnUser->__construct()	JROOT/components/com_jsn/helpers/helper.php:26
14	JsnHelper::getUser()	JROOT/templates/ja_sugite/tpls/blocks/mainbody/no-sidebar.php:18
13	include JROOT/templates/ja_sugite/tpls/blocks/mainbody/no-sidebar.php	JROOT/plugins/system/t3/includes/core/template.php:176
12	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/blocks/mainbody.php:38
11	include JROOT/templates/ja_sugite/tpls/blocks/mainbody.php	JROOT/plugins/system/t3/includes/core/template.php:176
10	T3Template->loadBlock()	JROOT/templates/ja_sugite/tpls/default.php:51
9	include JROOT/templates/ja_sugite/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:200
8	T3Template->loadLayout()	JROOT/templates/ja_sugite/index.php:34
7	require JROOT/templates/ja_sugite/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1133
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 1.16 ms Dopo l'ultima query: 5.50 ms Memoria query: 0.040 MB memoria prima della query: 6.422 MB Righe restituite: 6

SELECT a.*, c.published AS c_published, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `avjbq_weblinks` AS a

  LEFT JOIN avjbq_categories AS c 
  ON c.id = a.catid

  LEFT JOIN avjbq_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN avjbq_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1,5) 
  AND a.catid = 18 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-10-28 19:51:42') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-10-28 19:51:42')

  ORDER BY ordering asc 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ALL	idx_access,idx_state,idx_catid	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	Using where; Using filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	aqtpboka_pc_crash.a.created_by	1	Using where

Profilo

Status	Duration
Starting	0.28 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_weblinks/models/category.php:81
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.77 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.035 MB memoria prima della query: 6.497 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.17 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.56 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.035 MB memoria prima della query: 6.505 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.56 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.035 MB memoria prima della query: 6.513 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 6 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.05 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.53 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.035 MB memoria prima della query: 6.521 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 7 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.54 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.035 MB memoria prima della query: 6.529 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 3 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.50 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.035 MB memoria prima della query: 6.537 MB Righe restituite: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `avjbq_contentitem_tag_map` AS m 

  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_weblinks.weblink' 
  AND `m`.`content_item_id` = 5 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	range	PRIMARY,tag_idx,idx_access	idx_access	4	NULL	2	Using index condition; Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	aqtpboka_pc_crash.t.id	12	Using index condition; Using where

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
13	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_weblinks/models/category.php:95
12	WeblinksModelCategory->getItems()	JROOT/modules/mod_weblinks/helper.php:94
11	ModWeblinksHelper::getList()	JROOT/modules/mod_weblinks/mod_weblinks.php:15
10	include JROOT/modules/mod_weblinks/mod_weblinks.php	JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.55 ms Dopo l'ultima query: 17.16 ms Memoria query: 0.029 MB memoria prima della query: 6.846 MB Righe restituite: 1

SELECT * 
  FROM avjbq_kunena_configuration 
  WHERE id=1

Explain

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

Profilo

Status	Duration
Starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/kunena/config.php:1295
23	KunenaConfig->load()	JROOT/libraries/kunena/config.php:1229
22	KunenaConfig::getInstance()	JROOT/libraries/kunena/factory.php:28
21	KunenaFactory::getConfig()	JROOT/libraries/kunena/route/route.php:480
20	KunenaRoute::initialize()	JROOT/libraries/kunena/route/route.php:17
19	include_once JROOT/libraries/kunena/route/route.php	JROOT/libraries/loader.php:747
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:38
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.61 ms Dopo l'ultima query: 2.59 ms Memoria query: 0.053 MB memoria prima della query: 6.919 MB Righe restituite: 21

SELECT * 
  FROM avjbq_kunena_categories 
  ORDER BY ordering, name

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_kunena_categories	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	21	Using filesort

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/forum/category/helper.php:865
21	KunenaForumCategoryHelper::loadCategories()	JROOT/libraries/kunena/forum/category/helper.php:43
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.99 ms Dopo l'ultima query: 1.13 ms Memoria query: 0.046 MB memoria prima della query: 7.171 MB Righe restituite: 51

SHOW FULL COLUMNS 
  FROM `avjbq_kunena_users`

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.16 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.08 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
37	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
36	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
35	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
34	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/kunena/tables/kunenausers.php:329
33	TableKunenaUsers->__construct()	JROOT/libraries/src/Table/Table.php:312
32	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/kunena/user/user.php:252
31	KunenaUser->getTable()	JROOT/libraries/kunena/user/user.php:275
30	KunenaUser->load()	JROOT/libraries/kunena/user/user.php:100
29	KunenaUser->__construct()	JROOT/libraries/kunena/user/helper.php:59
28	KunenaUserHelper::initialize()	JROOT/libraries/kunena/user/helper.php:13
27	include_once JROOT/libraries/kunena/user/helper.php	JROOT/libraries/loader.php:726
26	JLoader::_load()	JROOT/libraries/loader.php:695
25	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
24	spl_autoload_call()	JROOT/libraries/kunena/access.php:116
23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 2.06 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.030 MB memoria prima della query: 7.291 MB Righe restituite: 2

SELECT DISTINCT(user_id)

  FROM avjbq_usergroups as ug1

  INNER JOIN avjbq_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN avjbq_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	ug2	range	PRIMARY,idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where; Using index
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	5642	Using where; Using index; Using join buffer (flat, BNL join)

Profilo

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Executing	0.01 ms
Sending data	1.46 ms
Removing tmp table	0.02 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
27	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
26	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
25	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
24	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 67.39 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.030 MB memoria prima della query: 7.304 MB Righe restituite: 0

SELECT DISTINCT(user_id)

  FROM avjbq_usergroups as ug1

  INNER JOIN avjbq_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN avjbq_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (7)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ug1	const	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	const	1	Using temporary
1	SIMPLE	m	index	NULL	PRIMARY	8	NULL	5642	Using index
1	SIMPLE	ug2	eq_ref	PRIMARY,idx_usergroup_nested_set_lookup	PRIMARY	4	aqtpboka_pc_crash.m.group_id	1	Using where; Distinct

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Creating tmp table	0.02 ms
Executing	0.01 ms
Sending data	55.52 ms
Removing tmp table	0.05 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	11.25 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
27	JDatabaseDriver->loadColumn()	JROOT/plugins/kunena/joomla/access.php:441
26	KunenaAccessJoomla->getUsersByGroup()	JROOT/plugins/kunena/joomla/access.php:492
25	KunenaAccessJoomla->getAuthorisedUsers()	JROOT/plugins/kunena/joomla/access.php:233
24	KunenaAccessJoomla->loadCategoryRoles()	JROOT/libraries/kunena/access.php:125
23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.49 ms Dopo l'ultima query: 0.15 ms Memoria query: 0.029 MB memoria prima della query: 7.313 MB Righe restituite: 1

SELECT user_id, category_id, role 
  FROM avjbq_kunena_user_categories 
  WHERE role IN (1,2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_kunena_user_categories	range	role	role	1	NULL	2	Using index condition

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/kunena/access.php:136
23	KunenaAccess->clearCache()	JROOT/libraries/kunena/access.php:82
22	KunenaAccess->__construct()	JROOT/libraries/kunena/access.php:97
21	KunenaAccess::getInstance()	JROOT/libraries/kunena/forum/category/helper.php:51
20	KunenaForumCategoryHelper::initialize()	JROOT/libraries/kunena/forum/category/helper.php:965
19	include_once JROOT/libraries/kunena/forum/category/helper.php	JROOT/libraries/loader.php:726
18	JLoader::_load()	JROOT/libraries/loader.php:695
17	JLoader::_autoload()	Chiamata uguale alla linea sottostante.
16	spl_autoload_call()	JROOT/components/com_kunena/router.php:113
15	KunenaBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
14	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/t3/includes/menu/megamenu.php:162
8	T3MenuMegamenu->__construct()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:87
7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.78 ms Dopo l'ultima query: 5.36 ms Memoria query: 0.026 MB memoria prima della query: 7.542 MB Righe restituite: 0

SELECT *
 
  FROM avjbq_jmap_metainfo
 
  WHERE `linkurl` = 'https://pc-crash.marcellinux.com/eventi/archivio-eventi-dal-2018'
 
  AND `published` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	avjbq_jmap_metainfo	ALL	published	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	238	Using where

Profilo

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:393
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1147
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 1.38 ms Dopo l'ultima query: 2.12 ms Memoria query: 0.042 MB memoria prima della query: 7.694 MB Righe restituite: 298

SHOW TABLES

Explain

EXPLAIN non possibile sulla query: SHOW TABLES

Profilo

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Filling schema table	0.02 ms
checking permissions	0.74 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.00 ms
Query end	0.01 ms
Starting cleanup	0.04 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
14	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:552
13	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:16
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:455
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:23
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1153
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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]

Tempo della query: 0.51 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.038 MB memoria prima della query: 7.735 MB Righe restituite: 184

SELECT * 
  FROM avjbq_acymailing_config

Explain

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

Profilo

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.03 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:21
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:455
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:23
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1153
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:316
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 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

```
8 × SELECT id 
  FROM avjbq_eb_urls
```

6 × SELECT `m`.`tag_id`,`t`.* 
  FROM `avjbq_contentitem_tag_map` AS m  
  INNER JOIN `avjbq_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

5 × SELECT alias 
  FROM avjbq_eb_events

5 × SELECT category_id 
  FROM avjbq_eb_event_categories

3 × SELECT alias 
  FROM avjbq_eb_locations

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `avjbq_extensions`

2 × SELECT DISTINCT(user_id) 
  FROM avjbq_usergroups as ug1 
  INNER JOIN avjbq_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN avjbq_user_usergroup_map AS m 
  ON ug2.id=m.group_id

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM avjbq_modules AS m 
  LEFT JOIN avjbq_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN avjbq_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id, parent,alias 
  FROM avjbq_eb_categorie

1 × SELECT `data` 
  FROM `avjbq_session`

1 × SELECT * 
  FROM avjbq_easyblog_configs

1 × SELECT a.*,b.access as parent_access 
  FROM avjbq_jsn_fields AS a 
  LEFT JOIN avjbq_jsn_fields AS b 
  ON a.parent_id = b.id

1 × SELECT * 
  FROM avjbq_kunena_configuration

1 × SELECT * 
  FROM avjbq_kunena_categories

1 × SELECT user_id, category_id, role 
  FROM avjbq_kunena_user_categories

1 × SELECT *  
  FROM avjbq_jmap_metainfo

1 × SELECT a.*, c.published AS c_published, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,DATE_FORMAT(a.created, "%Y-%m-%d") AS created,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `avjbq_weblinks` AS a 
  LEFT JOIN avjbq_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN avjbq_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN avjbq_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT a.id, a.name, a.alias, b.event_id 
  FROM avjbq_eb_categories AS a 
  INNER JOIN avjbq_eb_event_categories AS b 
  ON a.id = b.category_id

1 × SELECT * 
  FROM avjbq_eb_location

1 × SELECT tbl.id,tbl.main_category_id,tbl.location_id,tbl.title,tbl.event_type,tbl.event_date,tbl.event_end_date,tbl.short_description,tbl.description,tbl.access,tbl.registration_access,tbl.individual_price,tbl.price_text,tbl.event_capacity,tbl.created_by,tbl.cut_off_date,tbl.registration_type,tbl.min_group_number,tbl.discount_type,tbl.discount,tbl.early_bird_discount_type,tbl.early_bird_discount_date,tbl.early_bird_discount_amount,tbl.enable_cancel_registration,tbl.cancel_before_date,tbl.params,tbl.published,tbl.custom_fields,tbl.discount_groups,tbl.discount_amounts,tbl.registration_start_date,tbl.registration_handle_url,tbl.fixed_group_price,tbl.attachment,tbl.late_fee_type,tbl.late_fee_date,tbl.late_fee_amount,tbl.event_password,tbl.currency_code,tbl.currency_symbol,tbl.thumb,tbl.image,tbl.language,tbl.alias,tbl.tax_rate,tbl.featured,tbl.has_multiple_ticket_types,tbl.activate_waiting_list,tbl.collect_member_information,tbl.prevent_duplicate_registration,DATEDIFF(tbl.early_bird_discount_date, '2026-10-28 19:51:42') AS date_diff,DATEDIFF('2026-10-28 19:51:42', tbl.late_fee_date) AS late_fee_date_diff,DATEDIFF(tbl.event_date, '2026-10-28 19:51:42') AS number_event_dates,TIMESTAMPDIFF(MINUTE, tbl.event_date, '2026-10-28 19:51:42') AS event_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.registration_start_date, '2026-10-28 19:51:42') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, tbl.cut_off_date, '2026-10-28 19:51:42') AS cut_off_minutes,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address,IFNULL(SUM(b.number_registrants), 0) AS total_registrants,u.name as creator_name 
  FROM avjbq_eb_events AS tbl 
  LEFT JOIN avjbq_eb_registrants AS b 
  ON (tbl.id = b.event_id 
  AND b.group_id=0 
  AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" 
  AND b.published NOT IN (2,3)))) 
  LEFT JOIN avjbq_eb_locations AS c 
  ON tbl.location_id = c.id  
  LEFT JOIN avjbq_users as u 
  ON tbl.created_by = u.id

1 × SELECT COUNT(*) 
  FROM avjbq_eb_events AS tbl

```
1 × SELECT * 
  FROM avjbq_eb_themes
```

1 × SELECT `config_key`,`config_value` 
  FROM avjbq_eb_config

```
1 × SELECT * 
  FROM avjbq_languages
```

1 × SELECT * 
  FROM avjbq_acysms_confi

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `avjbq_assets`

1 × SELECT id, home, template, s.params 
  FROM avjbq_template_styles as s 
  LEFT JOIN avjbq_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM avjbq_rsform_confi

1 × 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 avjbq_menu AS m 
  LEFT JOIN avjbq_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM avjbq_extensions

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

1 × SELECT id, rules 
  FROM `avjbq_viewlevels

1 × SELECT * 
  FROM avjbq_acymailing_confi

ALTRE tabelle:

1 × UPDATE `avjbq_extensions` 
  SET `params` = '{\"mediaversion\":\"2b4eb7240ddbaa804fd1c85178e78e91\"}'

1 × SHOW FULL COLUMNS 
  FROM `avjbq_eb_events

1 × SHOW FULL COLUMNS 
  FROM `avjbq_kunena_users

```
1 × SHOW TABLE
```

Data evento	Venerdì 06 Aprile 2018 - Ore 16:00
Fine evento	Venerdì 06 Aprile 2018 - Ore 20:00
Chiusura iscrizioni	Giovedì 05 Aprile 2018 - Ore 20:00
Posti:	10
Disponibili	3
Costo (iva esclusa)	€63,80
Luogo:	Studio Tecnico Gaetano Esposito & Partner

Data evento	Domenica 25 Marzo 2018 - Ore 00:00
Fine evento	Martedì 27 Marzo 2018 - Ore 00:00
Chiusura iscrizioni	Venerdì 09 Marzo 2018 - Ore 20:00
Posti:	50
Disponibili	8
Costo (iva esclusa)	€150,00
Luogo:	Centro Prove DSD

Data evento	Venerdì 23 Marzo 2018 - Ore 16:00
Fine evento	Venerdì 23 Marzo 2018 - Ore 20:00
Chiusura iscrizioni	Giovedì 22 Marzo 2018 - Ore 00:00
Posti:	10
Disponibili	0
Costo (iva esclusa)	€63,80
Luogo:	Studio Tecnico Gaetano Esposito & Partner

Data evento	Venerdì 16 Marzo 2018 - Ore 09:30
Fine evento	Venerdì 16 Marzo 2018 - Ore 17:30
Chiusura iscrizioni	Mercoledì 14 Marzo 2018 - Ore 23:55
Posti:	7
Disponibili	-1
Costo (iva esclusa)	€95,70
Luogo:	Studio Tecnico Sartori

Data evento	Venerdì 09 Marzo 2018 - Ore 16:00
Fine evento	Venerdì 09 Marzo 2018 - Ore 20:00
Chiusura iscrizioni	Mercoledì 07 Marzo 2018 - Ore 00:00
Posti:	10
Disponibili	7
Costo (iva esclusa)	€63,80
Luogo:	Studio Tecnico Gaetano Esposito & Partner

Sidebar

Archivio eventi

Laboratorio Pratico PC-Crash (Parte-2)

Crash Test DSD 2018

NOVITA' ASSOLUTA PER IL 2018

Programma preliminare

Laboratorio Pratico PC-Crash Parte 1

Primi passi nell'utilizzo del software Pc-Crash

Primi Passi PC-Crash Modulo 3

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

61 query eseguite 260.41 ms

37 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

LOGIN

Archivio eventi

Laboratorio Pratico PC-Crash (Parte-2)

Crash Test DSD 2018

NOVITA' ASSOLUTA PER IL 2018

Programma preliminare

Laboratorio Pratico PC-Crash Parte 1

Primi passi nell'utilizzo del software Pc-Crash

Primi Passi PC-Crash Modulo 3

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

61 query eseguite 260.41 ms

37 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: