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

Attachments:
File	Description	File size
4 E 5 PRIMARIA 16.03 celebrazione 14 marzo 2020.pdf		1397 kB
2 E 3 PRIMARIA 16.03 celebrazione 14 marzo 2020.pdf		1279 kB
2 E 3 Medie 16.03 celebrazione 14 marzo 2020.pdf		1671 kB
1 PRIMARIA 16.03 Matematica. celebrazione 14 marzo 2020 (1).pdf		896 kB
1 MEDIE 16.03 celebrazione 14 marzo 2020.pdf		1716 kB

PORTALI DI GIOCHI DI MATEMATICA

https://giochimatematici.unibocconi.it/

http://matematica.unibocconi.it/articoli/archivio-giochi

https://www.matematicamente.it/giochi-e-gare/gioca-con-la-matematica/

https://pianetabambini.it/giochi-matematica-bambini-scuola-elementare-stampare/

: Scritto da Domenico Cozzolino; Categoria: GIOCHI MATEMATICI; Pubblicato: 13 Marzo 2020

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": 1606386848,
                "last": 1606386848,
                "now": 1606386848
            },
            "token": "flL93vTTdMwwZPFQc26AOUXwkhFzYaHk"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaWMyOGFsaW90dGEuZWR1Lml0L2luZGV4LnBocC9kaWRhdHRpY2Etb25saW5lL2dpb2NoaS1tYXRlbWF0aWNpPw%3D%3D"
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "6dcdefc4ed72608166fb1ed37e17422541836bdb": {
                    "link": "https:\/\/www.ic28aliotta.edu.it\/index.php\/didattica-online\/giochi-matematici",
                    "expiry": 1606386848
                }
            }
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 55.38 ms / 55.38 ms Memoria: 0.739 MB / 0.96 MB Application: afterLoad

Tempo: 146.48 ms / 201.86 ms Memoria: 4.981 MB / 5.94 MB Application: afterInitialise

Tempo: 51.28 ms / 253.14 ms Memoria: 1.859 MB / 7.80 MB Application: afterRoute

Tempo: 7.36 ms / 260.50 ms Memoria: 0.053 MB / 7.86 MB Application: beforeRenderComponent com_content

Tempo: 25.66 ms / 286.16 ms Memoria: 0.573 MB / 8.43 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 1.25 ms / 287.41 ms Memoria: 0.096 MB / 8.52 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.07 ms / 287.48 ms Memoria: 0.000 MB / 8.52 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

Tempo: 4.14 ms / 291.63 ms Memoria: 0.046 MB / 8.56 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

Tempo: 127.27 ms / 418.90 ms Memoria: 2.185 MB / 10.75 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.15 ms / 419.05 ms Memoria: 0.013 MB / 10.76 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 382.48 ms / 801.53 ms Memoria: 3.785 MB / 14.55 MB Application: Before JAccess::preloadPermissions (com_content)

Tempo: 11.86 ms / 813.39 ms Memoria: 1.293 MB / 15.84 MB Application: After JAccess::preloadPermissions (com_content)

Tempo: 0.28 ms / 813.68 ms Memoria: 0.000 MB / 15.77 MB Application: Before JAccess::getAssetRules (id:1086 name:com_content.article.738)

Tempo: 0.15 ms / 813.82 ms Memoria: 0.014 MB / 15.78 MB Application: After JAccess::getAssetRules (id:1086 name:com_content.article.738)

Tempo: 12.62 ms / 826.44 ms Memoria: 0.151 MB / 15.93 MB Application: Before JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 0.20 ms / 826.64 ms Memoria: 0.013 MB / 15.94 MB Application: After JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 105.70 ms / 932.34 ms Memoria: 1.145 MB / 17.09 MB Application: afterRenderComponent com_content

Tempo: 0.64 ms / 932.97 ms Memoria: 0.007 MB / 17.10 MB Application: afterDispatch

Tempo: 42.82 ms / 975.79 ms Memoria: 0.262 MB / 17.36 MB Application: beforeRenderModule mod_menu (foot2)

Tempo: 31.60 ms / 1007.39 ms Memoria: 0.187 MB / 17.55 MB Application: afterRenderModule mod_menu (foot2)

Tempo: 1.87 ms / 1009.26 ms Memoria: 0.000 MB / 17.51 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 15.40 ms / 1024.66 ms Memoria: 0.095 MB / 17.61 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 3.19 ms / 1027.85 ms Memoria: 0.017 MB / 17.63 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 105.23 ms / 1133.08 ms Memoria: 0.844 MB / 18.47 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 12.87 ms / 1145.95 ms Memoria: 0.112 MB / 18.58 MB Application: afterRender

Query totali del database: 57.35 ms

Utilizzo memoria

Query Database

36 query eseguite 57.35 ms

Trovati 10 duplicati!

10 duplicati: #22 #23 #24 #25 #26 #27 #28 #29 #30 #31

Tempo della query: 0.75 ms Memoria query: 0.021 MB memoria prima della query: 3.062 MB Righe restituite: 0

SELECT `data`

  FROM `i9hrp_session`

  WHERE `session_id` = 'm99f07cs88fopfi3vmrec8nfs2'

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.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.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	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.03 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
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:825
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
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.68 ms Dopo l'ultima query: 3.87 ms Memoria query: 0.012 MB memoria prima della query: 3.204 MB Righe restituite: 0

SELECT `session_id`

  FROM `i9hrp_session`

  WHERE `session_id` = 'm99f07cs88fopfi3vmrec8nfs2' 
  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.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.06 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.02 ms
statistics	0.04 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	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.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
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
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: 1.49 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.009 MB memoria prima della query: 3.219 MB

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

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:827
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:412
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.47 ms Dopo l'ultima query: 24.40 ms Memoria query: 0.015 MB memoria prima della query: 3.869 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.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.01 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:265
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.44 ms Dopo l'ultima query: 1.99 ms Memoria query: 0.014 MB memoria prima della query: 3.946 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.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
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:265
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.83 ms Dopo l'ultima query: 94.66 ms Memoria query: 0.018 MB memoria prima della query: 7.551 MB

UPDATE `i9hrp_extensions`

  SET `params` = '{\"mediaversion\":\"515ab586bc6b2441e60c2265a1e4a87b\"}'

  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.12 ms
updating	0.10 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.01 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:1151
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:265
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: 37.95 ms Memoria query: 0.026 MB memoria prima della query: 8.435 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.01 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
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
16	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
15	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
14	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:434
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:265
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.87 ms Dopo l'ultima query: 8.91 ms Memoria query: 0.025 MB memoria prima della query: 8.642 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `i9hrp_content`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.05 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.26 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:33
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:311
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:265
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.72 ms Dopo l'ultima query: 21.52 ms Memoria query: 0.026 MB memoria prima della query: 9.016 MB Righe restituite: 1

SELECT *

  FROM i9hrp_content

  WHERE `id` = '738'

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.01 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
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 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.05 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
10	JTable->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:265
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.65 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.014 MB memoria prima della query: 9.033 MB

UPDATE i9hrp_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '738'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
10	JTable->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
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:265
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.08 ms Dopo l'ultima query: 10.75 ms Memoria query: 0.029 MB memoria prima della query: 9.277 MB Righe restituite: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM i9hrp_content AS a

  INNER JOIN i9hrp_categories AS c 
  on c.id = a.catid

  LEFT JOIN i9hrp_users AS u 
  on u.id = a.created_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.id = 738 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-26 10:34:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-26 10:34:08') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

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.16 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.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.04 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 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.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.10 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:422
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->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:265
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.34 ms Dopo l'ultima query: 14.96 ms Memoria query: 0.037 MB memoria prima della query: 9.572 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=171

  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	110	45.96	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.01 ms
checking query cache for query	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.10 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.20 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.31 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.02 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.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.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
21	JCategories->get()	JROOT/components/com_content/router.php:70
20	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
19	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->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:265
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.72 ms Dopo l'ultima query: 0.98 ms Memoria query: 0.026 MB memoria prima della query: 9.630 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` = 738 
  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.06 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 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.01 ms
statistics	0.07 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.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.12 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:180
11	ContentViewArticle->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:265
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.15 ms Dopo l'ultima query: 68.07 ms Memoria query: 0.033 MB memoria prima della query: 10.761 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 (171,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.28 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.15 ms
System lock	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.08 ms
optimizing	0.05 ms
statistics	0.24 ms
preparing	0.10 ms
Creating tmp table	0.19 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.37 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.04 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.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.04 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/article/view.html.php:190
11	ContentViewArticle->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:265
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.25 ms Dopo l'ultima query: 334.85 ms Memoria query: 0.024 MB memoria prima della query: 13.395 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.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.01 ms
checking privileges on cached	0.01 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
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/article/view.html.php:190
11	ContentViewArticle->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:265
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.20 ms Dopo l'ultima query: 2.06 ms Memoria query: 0.032 MB memoria prima della query: 13.431 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.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.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/article/view.html.php:190
11	ContentViewArticle->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:265
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.33 ms Dopo l'ultima query: 1.88 ms Memoria query: 0.042 MB memoria prima della query: 13.478 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.04 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.01 ms
checking privileges on cached	0.02 ms
checking permissions	0.01 ms
sending cached result to clien	0.06 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/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/article/view.html.php:190
11	ContentViewArticle->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:265
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.76 ms Dopo l'ultima query: 31.94 ms Memoria query: 0.024 MB memoria prima della query: 14.501 MB Righe restituite: 1

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 738

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.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 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.01 ms
freeing items	0.10 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
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/article/view.html.php:196
11	ContentViewArticle->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:265
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: 8.19 ms Dopo l'ultima query: 3.09 ms Memoria query: 0.063 MB memoria prima della query: 14.550 MB Righe restituite: 816

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	921	20.94	Using where

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.00 ms
checking permissions	0.02 ms
sending cached result to clien	5.70 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/libraries/joomla/access/access.php:357
23	JAccess::preloadPermissions()	JROOT/libraries/joomla/access/access.php:224
22	JAccess::preload()	JROOT/libraries/joomla/access/access.php:538
21	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
20	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
19	JUser->authorise()	JROOT/administrator/components/com_attachments/permissions.php:125
18	AttachmentsPermissions::userMayEditArticle()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:884
17	AttachmentsPlugin_Com_Content->userMayAddAttachment()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:862
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/article/view.html.php:196
11	ContentViewArticle->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:265
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: 5.46 ms Dopo l'ultima query: 17.03 ms Memoria query: 0.034 MB memoria prima della query: 15.943 MB Righe restituite: 5

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=738 
  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	1407	0.07	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.04 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.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	3.54 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 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.09 ms
Waiting for query cache lock	0.04 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
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/article/view.html.php:196
11	ContentViewArticle->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:265
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.97 ms Dopo l'ultima query: 6.80 ms Memoria query: 0.041 MB memoria prima della query: 16.466 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.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.00 ms
freeing items	0.03 ms
cleaning up	0.01 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/article/view.html.php:196
11	ContentViewArticle->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:265
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.19 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.035 MB memoria prima della query: 16.526 MB Righe restituite: 0

Query duplicate: #23 #24 #25 #26 #27 #28 #29 #30 #31

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.02 ms
Waiting on query cache mutex	0.01 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.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/article/view.html.php:196
11	ContentViewArticle->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:265
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.21 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.035 MB memoria prima della query: 16.560 MB Righe restituite: 0

Query duplicate: #22 #24 #25 #26 #27 #28 #29 #30 #31

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.01 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/article/view.html.php:196
11	ContentViewArticle->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:265
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.20 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.035 MB memoria prima della query: 16.593 MB Righe restituite: 0

Query duplicate: #22 #23 #25 #26 #27 #28 #29 #30 #31

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.02 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: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/article/view.html.php:196
11	ContentViewArticle->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:265
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.18 ms Dopo l'ultima query: 0.92 ms Memoria query: 0.035 MB memoria prima della query: 16.627 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #26 #27 #28 #29 #30 #31

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.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.02 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/article/view.html.php:196
11	ContentViewArticle->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:265
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.20 ms Dopo l'ultima query: 0.89 ms Memoria query: 0.035 MB memoria prima della query: 16.660 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #27 #28 #29 #30 #31

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.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: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/article/view.html.php:196
11	ContentViewArticle->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:265
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.32 ms Dopo l'ultima query: 0.81 ms Memoria query: 0.035 MB memoria prima della query: 16.693 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #26 #28 #29 #30 #31

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.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.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/article/view.html.php:196
11	ContentViewArticle->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:265
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.32 ms Dopo l'ultima query: 0.87 ms Memoria query: 0.035 MB memoria prima della query: 16.726 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #26 #27 #29 #30 #31

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.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: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/article/view.html.php:196
11	ContentViewArticle->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:265
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.33 ms Dopo l'ultima query: 0.85 ms Memoria query: 0.035 MB memoria prima della query: 16.759 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #26 #27 #28 #30 #31

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
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/article/view.html.php:196
11	ContentViewArticle->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:265
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.34 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.035 MB memoria prima della query: 16.792 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #26 #27 #28 #29 #31

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.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
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/article/view.html.php:196
11	ContentViewArticle->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:265
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.41 ms Dopo l'ultima query: 0.71 ms Memoria query: 0.035 MB memoria prima della query: 16.825 MB Righe restituite: 0

Query duplicate: #22 #23 #24 #25 #26 #27 #28 #29 #30

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.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
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/article/view.html.php:196
11	ContentViewArticle->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:265
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.56 ms Dopo l'ultima query: 7.36 ms Memoria query: 0.030 MB memoria prima della query: 16.777 MB Righe restituite: 1

SELECT id

  FROM i9hrp_content

  WHERE id=738 
  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.02 ms
starting	0.01 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
System lock	0.04 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 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.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.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/article/view.html.php:196
11	ContentViewArticle->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:265
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.47 ms Dopo l'ultima query: 0.23 ms Memoria query: 0.029 MB memoria prima della query: 16.807 MB Righe restituite: 1

SELECT title

  FROM i9hrp_content

  WHERE id=738

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.00 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.04 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.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.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/article/view.html.php:196
11	ContentViewArticle->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:265
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.70 ms Dopo l'ultima query: 71.84 ms Memoria query: 0.021 MB memoria prima della query: 17.282 MB Righe restituite: 5

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

  FROM i9hrp_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-26 10:34:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-26 10:34:08') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 298 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	47	2.13	Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	Sql1464388_2.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Sql1464388_2.m.id	5	40.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.00 ms
starting	0.01 ms
checking query cache for query	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.10 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.05 ms
optimizing	0.06 ms
statistics	0.18 ms
preparing	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.48 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.03 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 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.01 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()	Chiamata uguale alla linea sottostante.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:169
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:424
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:360
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:576
8	JDocumentHtml->countModules()	JROOT/templates/copia_protostar/index.php:108
7	require JROOT/templates/copia_protostar/index.php	JROOT/libraries/joomla/document/html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1098
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.81 ms Dopo l'ultima query: 70.66 ms Memoria query: 0.028 MB memoria prima della query: 17.566 MB Righe restituite: 1

SELECT `alias`

  FROM `i9hrp_content`

  WHERE id = '738'

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.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 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.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.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/components/com_content/router.php:123
20	ContentRouter->getArticleSegment()	Chiamata uguale alla linea sottostante.
19	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:117
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_breadcrumbs/helper.php:56
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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.28 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.036 MB memoria prima della query: 17.599 MB Righe restituite: 0

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=738

  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	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.02 ms
checking query cache for query	0.26 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.02 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.06 ms
optimizing	0.03 ms
statistics	0.10 ms
executing	0.04 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.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.10 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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
22	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
21	JCategories->get()	JROOT/components/com_content/router.php:70
20	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
19	call_user_func_array()	JROOT/libraries/cms/component/router/view.php:121
18	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
16	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
15	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
14	JRouter->build()	JROOT/libraries/cms/router/site.php:149
13	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
12	JRoute::_()	JROOT/modules/mod_breadcrumbs/helper.php:56
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/cms/module/helper.php:198
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1112
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
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]

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

```
10 × SELECT * 
  FROM i9hrp_assets
```

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)

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `i9hrp_assets`

1 × SELECT created_by, catid 
  FROM i9hrp_content

1 × 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

1 × SELECT a.*, u.name as creator_name 
  FROM i9hrp_attachments AS a 
  LEFT JOIN i9hrp_users AS u 
  ON u.id = a.created_by

```
1 × SELECT id 
  FROM i9hrp_content
```

1 × SELECT `alias` 
  FROM `i9hrp_content`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM i9hrp_modules AS m 
  LEFT JOIN i9hrp_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN i9hrp_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT title 
  FROM i9hrp_content

1 × SELECT `alias` 
  FROM `i9hrp_contact_details`

1 × 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

1 × SELECT id, rules 
  FROM `i9hrp_viewlevels

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

1 × SELECT `session_id` 
  FROM `i9hrp_session`

```
1 × SELECT * 
  FROM i9hrp_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM i9hrp_content AS a 
  INNER JOIN i9hrp_categories AS c 
  on c.id = a.catid 
  LEFT JOIN i9hrp_users AS u 
  on u.id = a.created_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

1 × SELECT `data` 
  FROM `i9hrp_session`

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `i9hrp_contentitem_tag_map` AS m  
  INNER JOIN `i9hrp_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT MAX(contact.id) AS contactid, contact.alias, contact.catid 
  FROM `i9hrp_contact_details` AS `contact`

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `i9hrp_assets

1 × UPDATE i9hrp_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `i9hrp_content

1 × UPDATE `i9hrp_extensions` 
  SET `params` = '{\"mediaversion\":\"515ab586bc6b2441e60c2265a1e4a87b\"}'

1 × INSERT INTO `i9hrp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('m99f07cs88fopfi3vmrec8nfs2', 1, '1606386848', 0, '', 0

Informazioni principali:

Note:

Giochi Matematici

PORTALI DI GIOCHI DI MATEMATICA

https://giochimatematici.unibocconi.it/

http://matematica.unibocconi.it/articoli/archivio-giochi

https://www.matematicamente.it/giochi-e-gare/gioca-con-la-matematica/

https://pianetabambini.it/giochi-matematica-bambini-scuola-elementare-stampare/

Citazione Malala

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

36 query eseguite 57.35 ms

Trovati 10 duplicati!

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: