Informazioni principali:

Comunicazione ai sensi dir. 2009/136/CE: questo sito utilizza cookies tecnici anche di terze parti.

Note:

L'uso del sito costituisce accettazione implicità dell'uso dei cookies. Per revocare il consenso è sufficiente cancellare i cookies di dominio dal browser.

PRIVACY

QUARTE ONLINE

Lista degli articoli nella categoria QUARTE ONLINE
Titolo	Data pubblicazione	Autore
Portali primaria 4	Lun Mar 2020	Scritto da Domenico Cozzolino
Link primaria 4	Lun Mar 2020	Scritto da Domenico Cozzolino
Lezioni primaria 4	Lun Mar 2020	Scritto da Domenico Cozzolino

Citazione Malala

"Un bambino, un maestro, una penna e un libro possono cambiare il mondo."

Malala Yousafzai, 15 luglio 2013.

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1632374580,
                "last": 1632374580,
                "now": 1632374580
            },
            "token": "ThWH3fd0a8ULdMof1y9Pbtqc2wQTiFaW"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaWMyOGFsaW90dGEuZWR1Lml0L2luZGV4LnBocC9kaWRhdHRpY2Etb25saW5lL3NjdW9sYS1wcmltYXJpYS1kaXBhcnRpbWVudG8tbGluZ3VlL3F1YXJ0ZS1vbmxpbmU%2F"
            }
        },
        "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
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 38.33 ms / 38.33 ms Memoria: 0.189 MB / 0.42 MB Application: afterLoad

Tempo: 186.59 ms / 224.92 ms Memoria: 1.431 MB / 1.85 MB Application: afterInitialise

Tempo: 60.65 ms / 285.56 ms Memoria: 0.941 MB / 2.79 MB Application: afterRoute

Tempo: 16.95 ms / 302.51 ms Memoria: 0.056 MB / 2.85 MB Application: beforeRenderComponent com_content

Tempo: 38.57 ms / 341.08 ms Memoria: 0.311 MB / 3.16 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 1.30 ms / 342.38 ms Memoria: 0.099 MB / 3.26 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.04 ms / 342.42 ms Memoria: 0.000 MB / 3.26 MB Application: Before JAccess::preloadPermissions (com_content)

Tempo: 6.12 ms / 348.54 ms Memoria: 1.644 MB / 4.90 MB Application: After JAccess::preloadPermissions (com_content)

Tempo: 0.23 ms / 348.77 ms Memoria: 0.000 MB / 4.81 MB Application: Before JAccess::getAssetRules (id:1068 name:com_content.category.166)

Tempo: 4.60 ms / 353.36 ms Memoria: 0.022 MB / 4.83 MB Application: After JAccess::getAssetRules (id:1068 name:com_content.category.166)

Tempo: 16.17 ms / 369.54 ms Memoria: 0.123 MB / 4.95 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Tempo: 0.03 ms / 369.57 ms Memoria: 0.003 MB / 4.96 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Tempo: 67.13 ms / 436.70 ms Memoria: 0.540 MB / 5.50 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.18 ms / 436.89 ms Memoria: 0.013 MB / 5.51 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 300.97 ms / 737.85 ms Memoria: 1.423 MB / 6.93 MB Application: Before JAccess::getAssetRules (id:1067 name:com_content.article.724)

Tempo: 0.15 ms / 738.00 ms Memoria: 0.014 MB / 6.95 MB Application: After JAccess::getAssetRules (id:1067 name:com_content.article.724)

Tempo: 9.13 ms / 747.14 ms Memoria: 0.068 MB / 7.01 MB Application: Before JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 0.17 ms / 747.31 ms Memoria: 0.013 MB / 7.03 MB Application: After JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 20.06 ms / 767.37 ms Memoria: 0.069 MB / 7.10 MB Application: Before JAccess::getAssetRules (id:1066 name:com_content.article.723)

Tempo: 0.04 ms / 767.41 ms Memoria: 0.003 MB / 7.10 MB Application: After JAccess::getAssetRules (id:1066 name:com_content.article.723)

Tempo: 17.40 ms / 784.81 ms Memoria: 0.075 MB / 7.17 MB Application: Before JAccess::getAssetRules (id:1065 name:com_content.article.722)

Tempo: 0.04 ms / 784.85 ms Memoria: 0.003 MB / 7.18 MB Application: After JAccess::getAssetRules (id:1065 name:com_content.article.722)

Tempo: 74.20 ms / 859.04 ms Memoria: 0.918 MB / 8.10 MB Application: Before JAccess::getAssetRules (id:419 name:com_content.article.166)

Tempo: 0.04 ms / 859.08 ms Memoria: 0.003 MB / 8.10 MB Application: After JAccess::getAssetRules (id:419 name:com_content.article.166)

Tempo: 41.49 ms / 900.57 ms Memoria: 0.356 MB / 8.46 MB Application: afterRenderComponent com_content

Tempo: 0.74 ms / 901.31 ms Memoria: 0.006 MB / 8.46 MB Application: afterDispatch

Tempo: 50.39 ms / 951.69 ms Memoria: 0.134 MB / 8.60 MB Application: beforeRenderModule mod_menu (foot2)

Tempo: 21.63 ms / 973.33 ms Memoria: 0.080 MB / 8.67 MB Application: afterRenderModule mod_menu (foot2)

Tempo: 3.07 ms / 976.40 ms Memoria: 0.000 MB / 8.64 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 9.63 ms / 986.02 ms Memoria: 0.026 MB / 8.67 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 5.78 ms / 991.81 ms Memoria: 0.016 MB / 8.69 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 139.58 ms / 1131.38 ms Memoria: 0.827 MB / 9.51 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 22.48 ms / 1153.86 ms Memoria: 0.031 MB / 9.54 MB Application: afterRender

Query totali del database: 118.42 ms

Utilizzo memoria

Query Database

59 query eseguite 118.42 ms

Trovati 18 duplicati!

18 duplicati: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

Tempo della query: 47.94 ms Memoria query: 0.021 MB memoria prima della query: 0.930 MB Righe restituite: 0

SELECT `data`

  FROM `i9hrp_session`

  WHERE `session_id` = 'n7m0r8u4359ebvoi229aku3fl6'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	47.45 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.16 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 0.63 ms Dopo l'ultima query: 4.25 ms Memoria query: 0.012 MB memoria prima della query: 0.984 MB Righe restituite: 0

SELECT `session_id`

  FROM `i9hrp_session`

  WHERE `session_id` = 'n7m0r8u4359ebvoi229aku3fl6' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i9hrp_session	NULL	const	PRIMARY	PRIMARY	766	const	1	100.00	Using index

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.14 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 0.41 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.009 MB memoria prima della query: 0.999 MB

INSERT INTO `i9hrp_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('n7m0r8u4359ebvoi229aku3fl6', 1, '1632374580', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('n7m0r8u4359ebvoi229aku3fl6', 1, '1632374580', 0, '', 0)

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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: 0.34 ms Dopo l'ultima query: 12.04 ms Memoria query: 0.015 MB memoria prima della query: 1.163 MB Righe restituite: 2

SELECT b.id

  FROM i9hrp_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.47 ms Dopo l'ultima query: 1.43 ms Memoria query: 0.014 MB memoria prima della query: 1.183 MB Righe restituite: 5

SELECT id, rules

  FROM `i9hrp_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.05 ms Dopo l'ultima query: 138.04 ms Memoria query: 0.018 MB memoria prima della query: 2.715 MB

UPDATE `i9hrp_extensions`

  SET `params` = '{\"mediaversion\":\"fc2ff0a41bf6370f5870608107ca0534\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	i9hrp_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.16 ms
updating	0.10 ms
end	0.01 ms
Waiting for query cache lock	0.00 ms
end	0.16 ms
query end	0.06 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/jqueryeasy/jqueryeasy.php:53
9	plgSystemJqueryeasy->onAfterRoute()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.62 ms Dopo l'ultima query: 59.20 ms Memoria query: 0.030 MB memoria prima della query: 3.169 MB Righe restituite: 39

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

  FROM `i9hrp_assets`

  WHERE `name` IN ('com_accesskeys','com_admin','com_ajax','com_akeeba','com_albopretorio','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oziogallery3','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i9hrp_assets	NULL	index_merge	idx_asset_name,idx_parent_id	idx_asset_name,idx_parent_id	202,4	NULL	40	100.00	Using sort_union(idx_asset_name,idx_parent_id); Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
19	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.23 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.066 MB memoria prima della query: 3.258 MB Righe restituite: 1005

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

  FROM `i9hrp_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	1.42 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:357
19	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
18	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
17	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
16	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
15	JUser->authorise()	JROOT/components/com_content/models/category.php:142
14	ContentModelCategory->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/libraries/legacy/view/category.php:115
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 3.41 ms Dopo l'ultima query: 16.29 ms Memoria query: 0.031 MB memoria prima della query: 4.866 MB Righe restituite: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems

  FROM i9hrp_categories as c

  LEFT JOIN i9hrp_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN `i9hrp_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id=166

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	114	45.32	Using where
1	SIMPLE	i	NULL	ref	idx_state,idx_catid	idx_catid	4	Sql1464388_2.c.id	10	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.02 ms
checking query cache for query	0.30 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.17 ms
System lock	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.24 ms
preparing	0.06 ms
Creating tmp table	0.17 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	1.31 ms
Creating sort index	0.13 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.09 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
16	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
15	JCategories->get()	JROOT/components/com_content/models/category.php:355
14	ContentModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:121
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 13.45 ms Dopo l'ultima query: 5.23 ms Memoria query: 0.041 MB memoria prima della query: 4.951 MB Righe restituite: 3

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating, 
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM i9hrp_content AS a

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

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

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

  LEFT JOIN i9hrp_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN i9hrp_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 166 OR a.catid IN (
SELECT sub.id

  FROM i9hrp_categories as sub

  INNER JOIN i9hrp_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 166)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-23 05:23:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-23 05:23:00')

  ORDER BY  c.lft,  a.ordering,  a.created   
  LIMIT 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	114	9.74	Using where; Using temporary; Using filesort
1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	Sql1464388_2.c.id	10	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	Using where
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.c.parent_id	1	100.00	Using where
1	PRIMARY	v	NULL	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	5	33.33	Using where; Using index

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.04 ms
checking query cache for query	0.55 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.33 ms
init	0.30 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.12 ms
optimizing	0.06 ms
statistics	0.30 ms
preparing	0.12 ms
Creating tmp table	0.31 ms
Sorting result	0.01 ms
optimizing	0.02 ms
statistics	0.24 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.24 ms
executing	0.01 ms
Sending data	9.67 ms
Creating sort index	0.11 ms
end	0.00 ms
query end	0.08 ms
removing tmp table	0.07 ms
query end	0.01 ms
closing tables	0.08 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
17	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
16	JModelList->getItems()	JROOT/components/com_content/models/articles.php:536
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.70 ms Dopo l'ultima query: 4.48 ms Memoria query: 0.030 MB memoria prima della query: 5.078 MB Righe restituite: 0

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

  FROM `i9hrp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 724 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql1464388_2.m.tag_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.16 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.68 ms Dopo l'ultima query: 0.53 ms Memoria query: 0.030 MB memoria prima della query: 5.119 MB Righe restituite: 0

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

  FROM `i9hrp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 723 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql1464388_2.m.tag_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.12 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.59 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.030 MB memoria prima della query: 5.160 MB Righe restituite: 0

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

  FROM `i9hrp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 722 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql1464388_2.m.tag_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
16	JHelperTags->getItemTags()	JROOT/components/com_content/models/articles.php:662
15	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 4.54 ms Dopo l'ultima query: 1.89 ms Memoria query: 0.025 MB memoria prima della query: 5.204 MB Righe restituite: 1

SELECT COUNT(*)

  FROM i9hrp_content AS a

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

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

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

  LEFT JOIN i9hrp_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN i9hrp_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 166 OR a.catid IN (
SELECT sub.id

  FROM i9hrp_categories as sub

  INNER JOIN i9hrp_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 166)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-09-23 05:23:00') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-09-23 05:23:00')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	NULL	ALL	PRIMARY,idx_access	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	114	9.74	Using where
1	PRIMARY	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	Sql1464388_2.c.id	10	16.00	Using index condition; Using where
1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.id	1	100.00	Using where; Using index
2	SUBQUERY	this	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	NULL	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	5	33.33	Using where; Using index

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.15 ms
executing	0.00 ms
Sending data	3.52 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.09 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:334
17	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:281
16	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:231
15	JModelList->getPagination()	JROOT/components/com_content/models/category.php:265
14	ContentModelCategory->getItems()	JROOT/libraries/legacy/view/legacy.php:422
13	JViewLegacy->get()	JROOT/libraries/legacy/view/category.php:143
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.07 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.027 MB memoria prima della query: 5.217 MB Righe restituite: 0

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

  FROM `i9hrp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 166 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	Sql1464388_2.m.tag_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.04 ms
starting	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
13	JHelperTags->getItemTags()	JROOT/libraries/legacy/view/category.php:225
12	JViewCategory->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:72
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.56 ms Dopo l'ultima query: 35.04 ms Memoria query: 0.035 MB memoria prima della query: 5.453 MB Righe restituite: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM i9hrp_categories as c

  LEFT JOIN i9hrp_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=166

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	114	44.34	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.02 ms
checking query cache for query	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.21 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.06 ms
optimizing	0.03 ms
statistics	0.31 ms
preparing	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.60 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.13 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
20	JCategories->get()	JROOT/administrator/components/com_fields/models/fields.php:197
19	FieldsModelFields->getListQuery()	JROOT/libraries/legacy/model/list.php:132
18	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.34 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.033 MB memoria prima della query: 5.507 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM i9hrp_fields AS a

  LEFT JOIN `i9hrp_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN i9hrp_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN i9hrp_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN i9hrp_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN i9hrp_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `i9hrp_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (166,0)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Sql1464388_2.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.id	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.02 ms
checking query cache for query	0.33 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
init	0.18 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.08 ms
optimizing	0.05 ms
statistics	0.20 ms
preparing	0.08 ms
Creating tmp table	0.11 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.39 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.07 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
19	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
18	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
17	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
15	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 286.00 ms Memoria query: 0.023 MB memoria prima della query: 6.739 MB Righe restituite: 0

SELECT id

  FROM i9hrp_categories

  WHERE id = 724 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
executing	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:196
15	plgContentAttachments->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.89 ms Dopo l'ultima query: 0.35 ms Memoria query: 0.024 MB memoria prima della query: 6.764 MB Righe restituite: 1

SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid

  FROM `i9hrp_contact_details` AS `contact`

  WHERE contact.published = 1 
  AND contact.user_id = 459

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT/plugins/content/contact/contact.php:108
16	PlgContentContact->getContactId()	JROOT/plugins/content/contact/contact.php:60
15	PlgContentContact->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 3.40 ms Memoria query: 0.032 MB memoria prima della query: 6.798 MB Righe restituite: 0

SELECT `alias`

  FROM `i9hrp_contact_details`

  WHERE id = '0'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
25	JDatabaseDriver->loadResult()	JROOT/components/com_contact/router.php:121
24	ContactRouter->getContactSegment()	Chiamata uguale alla linea sottostante.
23	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/content/contact/contact.php:66
15	PlgContentContact->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 1.69 ms Memoria query: 0.042 MB memoria prima della query: 6.841 MB Righe restituite: 5

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM i9hrp_categories as c

  WHERE (c.extension='com_contact' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	range	cat_idx,idx_access	cat_idx	207	NULL	7	100.00	Using index condition; Using filesort

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
26	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
25	JCategories->get()	JROOT/components/com_contact/router.php:68
24	ContactRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
23	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
22	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
21	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
20	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
19	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
18	JRouter->build()	JROOT/libraries/cms/router/site.php:149
17	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
16	JRoute::_()	JROOT/plugins/content/contact/contact.php:66
15	PlgContentContact->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.52 ms Dopo l'ultima query: 2.07 ms Memoria query: 0.024 MB memoria prima della query: 6.906 MB Righe restituite: 1

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 724

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:312
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.01 ms Dopo l'ultima query: 11.72 ms Memoria query: 0.033 MB memoria prima della query: 7.027 MB Righe restituite: 0

SELECT a.*, u.name as creator_name

  FROM i9hrp_attachments AS a

  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=724 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article'

  ORDER BY created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1889	0.05	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	1.24 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.16 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 14.49 ms Memoria query: 0.023 MB memoria prima della query: 7.051 MB Righe restituite: 0

SELECT id

  FROM i9hrp_categories

  WHERE id = 723 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:196
15	plgContentAttachments->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.46 ms Dopo l'ultima query: 1.68 ms Memoria query: 0.024 MB memoria prima della query: 7.074 MB Righe restituite: 1

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 723

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.00 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:312
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.70 ms Dopo l'ultima query: 1.35 ms Memoria query: 0.033 MB memoria prima della query: 7.110 MB Righe restituite: 0

SELECT a.*, u.name as creator_name

  FROM i9hrp_attachments AS a

  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=723 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article'

  ORDER BY created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1889	0.05	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.94 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.12 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.59 ms Dopo l'ultima query: 11.62 ms Memoria query: 0.023 MB memoria prima della query: 7.129 MB Righe restituite: 0

SELECT id

  FROM i9hrp_categories

  WHERE id = 722 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.03 ms
executing	0.00 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:196
15	plgContentAttachments->onContentPrepare()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:108
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.64 ms Dopo l'ultima query: 1.56 ms Memoria query: 0.024 MB memoria prima della query: 7.152 MB Righe restituite: 1

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 722

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:312
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.67 ms Dopo l'ultima query: 1.24 ms Memoria query: 0.034 MB memoria prima della query: 7.187 MB Righe restituite: 6

SELECT a.*, u.name as creator_name

  FROM i9hrp_attachments AS a

  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=722 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article'

  ORDER BY created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1889	0.05	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	NULL

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
starting	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	1.05 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.10 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.63 ms Dopo l'ultima query: 5.48 ms Memoria query: 0.041 MB memoria prima della query: 7.489 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `i9hrp_assets`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
28	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
27	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
26	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:311
25	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:781
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 6.76 ms Memoria query: 0.035 MB memoria prima della query: 7.559 MB Righe restituite: 0

Query duplicate: #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.81 ms Memoria query: 0.035 MB memoria prima della query: 7.592 MB Righe restituite: 0

Query duplicate: #31 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.32 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.036 MB memoria prima della query: 7.625 MB Righe restituite: 0

Query duplicate: #31 #32 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.30 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.035 MB memoria prima della query: 7.659 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.32 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.035 MB memoria prima della query: 7.692 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.31 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.035 MB memoria prima della query: 7.725 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.29 ms Dopo l'ultima query: 0.70 ms Memoria query: 0.035 MB memoria prima della query: 7.758 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.31 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.035 MB memoria prima della query: 7.791 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #39 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.48 ms Dopo l'ultima query: 0.72 ms Memoria query: 0.035 MB memoria prima della query: 7.824 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #40 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.46 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.035 MB memoria prima della query: 7.857 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #41 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.40 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.035 MB memoria prima della query: 7.890 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #42 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.32 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.035 MB memoria prima della query: 7.923 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #50 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
25	JTable->load()	JROOT/libraries/joomla/access/access.php:782
24	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
23	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
22	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
21	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.68 ms Dopo l'ultima query: 3.86 ms Memoria query: 0.029 MB memoria prima della query: 7.797 MB Righe restituite: 1

SELECT id

  FROM i9hrp_content

  WHERE id=722 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:648
21	AttachmentsPlugin->parentExists()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:344
20	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
19	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
18	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:133
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.52 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.028 MB memoria prima della query: 7.826 MB Righe restituite: 1

SELECT title

  FROM i9hrp_content

  WHERE id=722

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
21	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:359
20	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
19	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
18	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:133
17	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
15	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.96 ms Dopo l'ultima query: 20.72 ms Memoria query: 0.042 MB memoria prima della query: 7.960 MB Righe restituite: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state

  FROM i9hrp_fields AS a

  LEFT JOIN `i9hrp_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN i9hrp_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN i9hrp_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN i9hrp_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN i9hrp_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `i9hrp_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.categories' 
  AND (fc.category_id IS NULL OR fc.category_id IN (166,0)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  GROUP BY a.id, l.title, l.image, uc.name, ag.title, ua.name, g.title, g.access, g.state

  ORDER BY a.ordering DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	Sql1464388_2.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.id	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.02 ms
checking query cache for query	0.22 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
init	0.15 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.07 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.06 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.29 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
26	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
25	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
24	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
22	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 10.70 ms Memoria query: 0.032 MB memoria prima della query: 7.997 MB Righe restituite: 1

SELECT id

  FROM i9hrp_categories

  WHERE id = 166 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
24	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:790
23	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:196
22	plgContentAttachments->onContentPrepare()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 3.46 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.042 MB memoria prima della query: 8.038 MB Righe restituite: 0

SELECT a.*, u.name as creator_name

  FROM i9hrp_attachments AS a

  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=166 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='category'

  ORDER BY created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1889	0.05	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	NULL

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	2.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:212
22	plgContentAttachments->onContentPrepare()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 2.01 ms Memoria query: 0.032 MB memoria prima della query: 8.065 MB Righe restituite: 1

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 166

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:809
23	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:312
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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: 3.60 ms Dopo l'ultima query: 1.18 ms Memoria query: 0.042 MB memoria prima della query: 8.108 MB Righe restituite: 3

SELECT a.*, u.name as creator_name

  FROM i9hrp_attachments AS a

  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=166 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article'

  ORDER BY created DESC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1889	0.05	Using where; Using filesort
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1464388_2.a.created_by	1	100.00	NULL

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	2.53 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.03 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
27	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.79 ms Memoria query: 0.044 MB memoria prima della query: 8.343 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #51 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
27	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.42 ms Dopo l'ultima query: 0.74 ms Memoria query: 0.044 MB memoria prima della query: 8.385 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #52 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.03 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
27	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.46 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.044 MB memoria prima della query: 8.427 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #53 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
27	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.40 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.044 MB memoria prima della query: 8.469 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #54 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
27	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.40 ms Dopo l'ultima query: 0.63 ms Memoria query: 0.044 MB memoria prima della query: 8.510 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #55

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1006
27	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
26	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
25	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
24	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
23	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:318
22	plgContentAttachments->onContentBeforeDisplay()	Chiamata uguale alla linea sottostante.
21	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
18	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/cms/layout/file.php:121
17	JLayoutFile->render()	JROOT/libraries/cms/layout/helper.php:72
16	JLayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
15	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:694
14	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:229
13	JViewLegacy->display()	JROOT/libraries/legacy/view/category.php:241
12	JViewCategory->display()	JROOT/components/com_content/views/category/view.html.php:260
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->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.40 ms Dopo l'ultima query: 0.60 ms Memoria query: 0.044 MB memoria prima della query: 8.552 MB Righe restituite: 0

Query duplicate: #31 #32 #33 #34 #35 #36 #37 #38 #39 #40 #41 #42 #50 #51 #52 #53 #54

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
starting	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
33	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
32	JTable->load()	JROOT/libraries/joomla/access/access.php:782
31	JAccess::getAssetId()	JROOT/libraries/joomla/access/access.php:542
30	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
29	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
28	JUser->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:913
27	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/mo