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

Modulistica

Lista degli articoli nella categoria Modulistica
Titolo	Data pubblicazione	Autore
Modulistica per ATA	Gio Giu 2017	Scritto da Domenico Cozzolino
Modulistica per Genitori	Gio Giu 2017	Scritto da Domenico Cozzolino
Modulistica per Docenti	Gio Giu 2017	Scritto da Domenico Cozzolino

Citazione Malala

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

Malala Yousafzai, 15 luglio 2013.

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606387138,
                "last": 1606387138,
                "now": 1606387138
            },
            "token": "q7gsJJ8zia7pysGNF51WI4GEl9f8V2fT"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly93d3cuaWMyOGFsaW90dGEuZWR1Lml0L2luZGV4LnBocC9tb2R1bGlzdGljYT8%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
        }
    }
}

Informazioni profilo

Tempo

Memoria

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

Tempo: 175.48 ms / 230.45 ms Memoria: 4.981 MB / 5.94 MB Application: afterInitialise

Tempo: 55.19 ms / 285.64 ms Memoria: 1.859 MB / 7.80 MB Application: afterRoute

Tempo: 6.48 ms / 292.12 ms Memoria: 0.057 MB / 7.86 MB Application: beforeRenderComponent com_content

Tempo: 35.58 ms / 327.70 ms Memoria: 0.997 MB / 8.86 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 1.57 ms / 329.27 ms Memoria: 0.099 MB / 8.96 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.05 ms / 329.31 ms Memoria: 0.000 MB / 8.95 MB Application: Before JAccess::preloadPermissions (com_content)

Tempo: 7.97 ms / 337.29 ms Memoria: 1.350 MB / 10.30 MB Application: After JAccess::preloadPermissions (com_content)

Tempo: 0.28 ms / 337.56 ms Memoria: 0.000 MB / 10.23 MB Application: Before JAccess::getAssetRules (id:315 name:com_content.category.85)

Tempo: 2.80 ms / 340.36 ms Memoria: 0.046 MB / 10.27 MB Application: After JAccess::getAssetRules (id:315 name:com_content.category.85)

Tempo: 11.34 ms / 351.71 ms Memoria: 0.365 MB / 10.64 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

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

Tempo: 66.14 ms / 417.88 ms Memoria: 1.590 MB / 12.23 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.12 ms / 418.00 ms Memoria: 0.013 MB / 12.24 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 245.84 ms / 663.84 ms Memoria: 3.576 MB / 15.82 MB Application: Before JAccess::getAssetRules (id:462 name:com_content.article.195)

Tempo: 0.17 ms / 664.02 ms Memoria: 0.014 MB / 15.83 MB Application: After JAccess::getAssetRules (id:462 name:com_content.article.195)

Tempo: 6.48 ms / 670.50 ms Memoria: 0.152 MB / 15.99 MB Application: Before JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 0.13 ms / 670.63 ms Memoria: 0.014 MB / 16.00 MB Application: After JAccess::getAssetRules (id:98 name:com_attachments)

Tempo: 41.81 ms / 712.44 ms Memoria: 0.757 MB / 16.76 MB Application: Before JAccess::getAssetRules (id:461 name:com_content.article.194)

Tempo: 0.06 ms / 712.50 ms Memoria: 0.003 MB / 16.76 MB Application: After JAccess::getAssetRules (id:461 name:com_content.article.194)

Tempo: 34.18 ms / 746.67 ms Memoria: 0.412 MB / 17.17 MB Application: Before JAccess::getAssetRules (id:460 name:com_content.article.193)

Tempo: 0.06 ms / 746.73 ms Memoria: 0.003 MB / 17.17 MB Application: After JAccess::getAssetRules (id:460 name:com_content.article.193)

Tempo: 135.21 ms / 881.94 ms Memoria: 3.179 MB / 20.35 MB Application: Before JAccess::getAssetRules (id:269 name:com_content.article.85)

Tempo: 0.04 ms / 881.98 ms Memoria: 0.003 MB / 20.36 MB Application: After JAccess::getAssetRules (id:269 name:com_content.article.85)

Tempo: 44.82 ms / 926.80 ms Memoria: 0.248 MB / 20.60 MB Application: afterRenderComponent com_content

Tempo: 0.75 ms / 927.55 ms Memoria: 0.007 MB / 20.61 MB Application: afterDispatch

Tempo: 28.25 ms / 955.80 ms Memoria: 0.265 MB / 20.88 MB Application: beforeRenderModule mod_menu (foot2)

Tempo: 31.18 ms / 986.97 ms Memoria: 0.189 MB / 21.06 MB Application: afterRenderModule mod_menu (foot2)

Tempo: 2.54 ms / 989.51 ms Memoria: 0.000 MB / 21.03 MB Application: beforeRenderModule mod_breadcrumbs (Percorso)

Tempo: 6.57 ms / 996.08 ms Memoria: 0.034 MB / 21.07 MB Application: afterRenderModule mod_breadcrumbs (Percorso)

Tempo: 3.01 ms / 999.09 ms Memoria: 0.018 MB / 21.09 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 107.03 ms / 1106.12 ms Memoria: 0.840 MB / 21.93 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 14.60 ms / 1120.71 ms Memoria: 0.107 MB / 22.03 MB Application: afterRender

Query totali del database: 114.74 ms

Utilizzo memoria

Query Database

131 query eseguite 114.74 ms

Trovati 86 duplicati!

86 duplicati: #25 #26 #27 #28 #34 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

Tempo della query: 1.57 ms Memoria query: 0.021 MB memoria prima della query: 3.061 MB Righe restituite: 0

SELECT `data`

  FROM `i9hrp_session`

  WHERE `session_id` = 'ssqs3nrbcl00e6i0p3526eebd1'

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

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

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: 1.57 ms Dopo l'ultima query: 4.58 ms Memoria query: 0.012 MB memoria prima della query: 3.203 MB Righe restituite: 0

SELECT `session_id`

  FROM `i9hrp_session`

  WHERE `session_id` = 'ssqs3nrbcl00e6i0p3526eebd1' 
  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

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

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.55 ms Dopo l'ultima query: 0.27 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 
('ssqs3nrbcl00e6i0p3526eebd1', 1, '1606387138', 0, '', 0)

Explain

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

Profilo

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

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.52 ms Dopo l'ultima query: 29.93 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

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

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: 2.82 ms Memoria query: 0.014 MB memoria prima della query: 3.945 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

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

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.92 ms Dopo l'ultima query: 98.15 ms Memoria query: 0.018 MB memoria prima della query: 7.551 MB

UPDATE `i9hrp_extensions`

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

  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

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

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.71 ms Dopo l'ultima query: 49.95 ms Memoria query: 0.030 MB memoria prima della query: 8.864 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

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

Call Stack

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

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

Call Stack

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

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

  FROM i9hrp_categories as c

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

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

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

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

  ORDER BY c.lft

Explain

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

Profilo

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

Call Stack

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

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

  FROM i9hrp_content AS a

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

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

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

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

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

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

  FROM i9hrp_categories as sub

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

  WHERE this.id = 85)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-26 10:38:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-26 10:38:58')

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

Explain

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

Profilo

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

Call Stack

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

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

Call Stack

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

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

Call Stack

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

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

Call Stack

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

SELECT COUNT(*)

  FROM i9hrp_content AS a

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

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

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

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

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

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

  FROM i9hrp_categories as sub

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

  WHERE this.id = 85)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-26 10:38:58') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-26 10:38:58')

Explain

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

Profilo

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

Call Stack

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

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

  FROM `i9hrp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 85 
  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

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

Call Stack

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

  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

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

Call Stack

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

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

Call Stack

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

SELECT id

  FROM i9hrp_categories

  WHERE id = 195 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

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

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

Call Stack

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

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

Call Stack

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

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

Call Stack

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

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 195

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

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

Call Stack

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

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

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

Call Stack

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

SHOW FULL COLUMNS 
  FROM `i9hrp_assets`

Explain

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

Profilo

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

Call Stack

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

Query duplicate: #26 #27 #28 #34 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

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

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

Call Stack

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

Query duplicate: #25 #27 #28 #34 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

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

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

Call Stack

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

Query duplicate: #25 #26 #28 #34 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

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

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

Call Stack

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

Query duplicate: #25 #26 #27 #34 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

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

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

Call Stack

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

SELECT id

  FROM i9hrp_content

  WHERE id=195 
  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

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

Call Stack

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

SELECT title

  FROM i9hrp_content

  WHERE id=195

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

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

Call Stack

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

SELECT id

  FROM i9hrp_categories

  WHERE id = 194 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

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

SELECT created_by, catid

  FROM i9hrp_content

  WHERE id = 194

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

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

Call Stack

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

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=194 
  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.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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.07 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
Creating sort index	2.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.04 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

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

Query duplicate: #25 #26 #27 #28 #35 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

SELECT *

  FROM i9hrp_assets

  WHERE `name` = 'edit'

Explain

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

Profilo

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

Call Stack

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

Query duplicate: #25 #26 #27 #28 #34 #36 #37 #38 #39 #40 #41 #47 #48 #49 #50 #51 #52 #53 #54 #55 #56 #57 #58 #59 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #71 #72 #73 #74 #75 #76 #77 #78 #79 #80 #81 #82 #83 #84 #85 #86 #87 #88 #89 #90 #91 #92 #93 #94 #95 #96 #97 #98 #99 #100 #101 #102 #103 #104 #105 #106 #107 #108 #109 #110 #111 #112 #113 #114 #115 #116 #117 #118 #126 #127

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.00 ms
starting	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 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/category/view.html.php:116
11	ContentViewCategory->display()	JROOT/libraries/joomla/cache/controller/view.php:98
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:662
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:39
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php: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: 0.67 ms Memoria query: 0.035 MB memoria prima della query: 17.032 MB Righe restituite: 0