Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1726671968,
                "last": 1726671968,
                "now": 1726671968
            },
            "token": "e4BiVD5oDaIQeUi27jtA3SNm3iRDCBRh"
        },
        "registry": {},
        "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: 101.64 ms / 101.64 ms Memoria: 0.202 MB / 0.58 MB Application: afterLoad

Tempo: 270.14 ms / 371.78 ms Memoria: 1.208 MB / 1.79 MB Application: afterInitialise

Tempo: 202.00 ms / 573.78 ms Memoria: 1.296 MB / 3.08 MB Application: afterRoute

Tempo: 3.00 ms / 576.78 ms Memoria: 0.035 MB / 3.12 MB Application: beforeRenderComponent com_contact

Tempo: 31.38 ms / 608.16 ms Memoria: 0.612 MB / 3.73 MB Application: Before JAccess::preloadComponents (all components)

Tempo: 4.01 ms / 612.17 ms Memoria: 0.058 MB / 3.79 MB Application: After JAccess::preloadComponents (all components)

Tempo: 0.06 ms / 612.23 ms Memoria: 0.000 MB / 3.78 MB Application: Before JAccess::getAssetRules (id:7 name:com_contact)

Tempo: 2.64 ms / 614.86 ms Memoria: 0.027 MB / 3.81 MB Application: After JAccess::getAssetRules (id:7 name:com_contact)

Tempo: 177.87 ms / 792.73 ms Memoria: 2.608 MB / 6.42 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

Tempo: 0.11 ms / 792.84 ms Memoria: 0.007 MB / 6.43 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

Tempo: 94.73 ms / 887.57 ms Memoria: 0.871 MB / 7.30 MB Application: afterRenderComponent com_contact

Tempo: 6.05 ms / 893.62 ms Memoria: 0.020 MB / 7.32 MB Application: afterDispatch

Tempo: 126.86 ms / 1020.48 ms Memoria: 12.199 MB / 19.52 MB Application: beforeRenderModule mod_menu (Footer Menu)

Tempo: 20.61 ms / 1041.10 ms Memoria: 0.119 MB / 19.63 MB Application: afterRenderModule mod_menu (Footer Menu)

Tempo: 3.20 ms / 1044.30 ms Memoria: 0.000 MB / 19.61 MB Application: beforeRenderModule mod_mylivechat (MyLiveChat)

Tempo: 4.20 ms / 1048.49 ms Memoria: 0.020 MB / 19.63 MB Application: afterRenderModule mod_mylivechat (MyLiveChat)

Tempo: 270.88 ms / 1319.37 ms Memoria: 0.156 MB / 19.79 MB Application: beforeRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 37.28 ms / 1356.65 ms Memoria: 0.658 MB / 20.45 MB Application: afterRenderModule mod_tz_news_pro (Cosa fa Sandrini?)

Tempo: 257.25 ms / 1613.91 ms Memoria: 0.075 MB / 20.52 MB Application: beforeRenderModule mod_tz_statistic (Indirizzo recapiti sandrini 3 box animati pagina contatti)

Tempo: 6.56 ms / 1620.47 ms Memoria: 0.046 MB / 20.57 MB Application: afterRenderModule mod_tz_statistic (Indirizzo recapiti sandrini 3 box animati pagina contatti)

Tempo: 92.21 ms / 1712.68 ms Memoria: 0.027 MB / 20.60 MB Application: beforeRenderModule mod_custom (Scrivi a Sandrini Impianti contatti)

Tempo: 4.04 ms / 1716.72 ms Memoria: 0.005 MB / 20.60 MB Application: afterRenderModule mod_custom (Scrivi a Sandrini Impianti contatti)

Tempo: 97.29 ms / 1814.01 ms Memoria: 0.000 MB / 9.20 MB Application: afterRender

Query totali del database: 77.87 ms

Utilizzo memoria

Query Database

19 query eseguite 77.87 ms

Trovati 3 duplicati!

3 duplicati: #9 #12 #13

Tempo della query: 0.92 ms Memoria query: 0.025 MB memoria prima della query: 0.970 MB Righe restituite: 0

SELECT `data`

  FROM `ecw3r_session`

  WHERE `session_id` = '27q46bph675bub0gilnpsr9vh8'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	NULL

Profilo

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:82
10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:832
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.13 ms Dopo l'ultima query: 4.99 ms Memoria query: 0.021 MB memoria prima della query: 0.985 MB Righe restituite: 0

SELECT `session_id`

  FROM `ecw3r_session`

  WHERE `session_id` = '27q46bph675bub0gilnpsr9vh8' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_session	const	PRIMARY	PRIMARY	575	const	1	100.00	Using index

Profilo

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

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:177
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.87 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.003 MB memoria prima della query: 0.989 MB

INSERT INTO `ecw3r_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('27q46bph675bub0gilnpsr9vh8', 1, '1726671968', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('27q46bph675bub0gilnpsr9vh8', 1, '1726671968', 0, '', 0)

Profilo

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:217
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:834
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:132
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:419
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.35 ms Dopo l'ultima query: 39.79 ms Memoria query: 0.022 MB memoria prima della query: 1.205 MB Righe restituite: 2

SELECT b.id

  FROM ecw3r_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.14 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.00 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.31 ms
freeing items	0.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1047
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.91 ms Dopo l'ultima query: 4.17 ms Memoria query: 0.023 MB memoria prima della query: 1.211 MB Righe restituite: 5

SELECT id, rules

  FROM `ecw3r_viewlevels`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1064
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:293
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 4.25 ms Dopo l'ultima query: 264.54 ms Memoria query: 0.006 MB memoria prima della query: 2.672 MB

UPDATE `ecw3r_extensions`

  SET `params` = '{\"mediaversion\":\"0e154a8970cfb392c31644c090d5aac6\"}'

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
8	plgSystemJComments->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1158
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.48 ms Dopo l'ultima query: 89.82 ms Memoria query: 0.032 MB memoria prima della query: 3.733 MB Righe restituite: 39

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

  FROM `ecw3r_assets`

  WHERE `name` IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_foxcontact','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_tz_multipurpose','com_tz_portfolio','com_uniterevolution2','com_users','com_weblinks','com_wrapper','com_xmap') OR `parent_id` = 0

Explain

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

Profilo

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.11 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.11 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.03 ms
System lock	0.05 ms
optimizing	0.02 ms
statistics	0.31 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	1.44 ms
end	0.02 ms
query end	0.00 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.10 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.11 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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_contact/models/contact.php:67
14	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:434
13	JModelLegacy->getState()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.05 ms Dopo l'ultima query: 3.23 ms Memoria query: 0.040 MB memoria prima della query: 3.815 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM ecw3r_contact_details AS a

  LEFT JOIN ecw3r_categories AS c 
  on c.id = a.catid

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

  WHERE a.id = 1 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-09-18 15:06:08') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-09-18 15:06:08')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	system	PRIMARY,idx_state	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:199
13	ContactModelContact->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 34.06 ms Dopo l'ultima query: 4.97 ms Memoria query: 0.036 MB memoria prima della query: 3.993 MB Righe restituite: 0

Query duplicate: #12 #13

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

  FROM `ecw3r_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
14	JHelperTags->getItemTags()	JROOT/components/com_contact/models/contact.php:221
13	ContactModelContact->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 3.64 ms Dopo l'ultima query: 12.08 ms Memoria query: 0.033 MB memoria prima della query: 4.389 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `ecw3r_users`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
21	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
20	JTable->__construct()	JROOT/libraries/joomla/table/user.php:40
19	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:311
18	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:64
17	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:899
16	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:89
15	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:361
14	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:257
13	ContactModelContact->getItem()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:394
12	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.95 ms Dopo l'ultima query: 95.80 ms Memoria query: 0.038 MB memoria prima della query: 5.743 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `ecw3r_contact_details` AS a

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

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

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

  WHERE a.access IN (1,1,5) 
  AND a.catid = 4 
  AND c.access IN (1,1,5) 
  AND a.published = 1

  ORDER BY a.name asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	system	idx_access,idx_state,idx_catid	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	uam	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profilo

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 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.05 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.07 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.21 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:186
13	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
12	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.43 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.035 MB memoria prima della query: 5.770 MB Righe restituite: 0

Query duplicate: #9 #13

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

  FROM `ecw3r_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
13	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:102
12	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.46 ms Dopo l'ultima query: 31.08 ms Memoria query: 0.035 MB memoria prima della query: 6.523 MB Righe restituite: 0

Query duplicate: #9 #12

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

  FROM `ecw3r_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:450
12	JHelperTags->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:291
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.69 ms Dopo l'ultima query: 3.57 ms Memoria query: 0.037 MB memoria prima della query: 6.570 MB Righe restituite: 43

SHOW FULL COLUMNS 
  FROM `ecw3r_contact_details`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
15	JTable->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:39
14	ContactTableContact->__construct()	JROOT/libraries/joomla/table/table.php:311
13	JTable::getInstance()	JROOT/components/com_contact/models/contact.php:587
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:311
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.42 ms Dopo l'ultima query: 7.12 ms Memoria query: 0.038 MB memoria prima della query: 6.775 MB Righe restituite: 1

SELECT *

  FROM ecw3r_contact_details

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
13	JTable->load()	JROOT/components/com_contact/models/contact.php:588
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:311
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.30 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.006 MB memoria prima della query: 6.781 MB

UPDATE ecw3r_contact_details

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

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ecw3r_contact_details	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1240
13	JTable->hit()	JROOT/components/com_contact/models/contact.php:589
12	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:311
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 7.56 ms Dopo l'ultima query: 7.18 ms Memoria query: 0.034 MB memoria prima della query: 6.906 MB Righe restituite: 16

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

  FROM ecw3r_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-09-18 15:06:08') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-09-18 15:06:08') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 268 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	191	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	Sql1009297_1.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Sql1009297_1.m.id	3	100.00	Using where; Using index

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:424
16	JModuleHelper::_load()	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:102
15	JModuleHelper::getModules()	JROOT/templates/tz_jollyany_joomla/html/com_contact/contact/default.php:16
14	include JROOT/templates/tz_jollyany_joomla/html/com_contact/contact/default.php	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:661
13	JViewLegacy->loadTemplate()	JROOT/plugins/system/plazart/includes/joomla30/viewlegacy.php:207
12	JViewLegacy->display()	JROOT/components/com_contact/views/contact/view.html.php:325
11	ContactViewContact->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_contact/controller.php:68
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:709
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:28
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:394
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:369
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:272
1	JApplicationCms->execute()	JROOT/index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 8.85 ms Dopo l'ultima query: 497.71 ms Memoria query: 0.062 MB memoria prima della query: 20.022 MB Righe restituite: 6

SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.*

  FROM ecw3r_content as ct

  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid

  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by

  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

  WHERE (tz_xc.type not in('audio','quote','link') or tz_xc.type is null) 
  AND  ct.catid IN(8) 
  and ct.state = 1  
  ORDER BY ct.created DESC 
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ct	index_merge	idx_state,idx_catid	idx_catid,idx_state	4,1	NULL	5	80.00	Using intersect(idx_catid,idx_state); Using where; Using temporary; Using filesort
1	SIMPLE	cat	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	us	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	tz_xc	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	92	100.00	Using where; Using join buffer (Block Nested Loop)

Profilo

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_tz_news_pro/helper.php:105
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
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.54 ms Dopo l'ultima query: 12.00 ms Memoria query: 0.036 MB memoria prima della query: 20.447 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 ecw3r_categories as c

  LEFT JOIN ecw3r_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=8

  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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	17	70.59	Using where

Profilo

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:301
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:182
13	JCategories->get()	JROOT/components/com_tz_portfolio/helpers/route.php:45
12	TZ_PortfolioHelperRoute::getArticleRoute()	JROOT/modules/mod_tz_news_pro/helper.php:148
11	modTzNewsHelper::getList()	JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php:45
10	include JROOT/modules/mod_tz_news_pro/mod_tz_news_pro.php	JROOT/plugins/system/plazart/includes/joomla30/modulehelper.php:191
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:474
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1119
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:278
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]

17 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT `m`.`tag_id`,`t`.* 
  FROM `ecw3r_contentitem_tag_map` AS m  
  INNER JOIN `ecw3r_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT `data` 
  FROM `ecw3r_session`

1 × SELECT `session_id` 
  FROM `ecw3r_session`

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

1 × SELECT id, rules 
  FROM `ecw3r_viewlevels

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

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM ecw3r_contact_details AS a 
  LEFT JOIN ecw3r_categories AS c 
  on c.id = a.catid 
  LEFT JOIN ecw3r_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `ecw3r_contact_details` AS a 
  LEFT JOIN ecw3r_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN ecw3r_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN ecw3r_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT * 
  FROM ecw3r_contact_details

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

1 × SELECT ct.*,cat.title as category_title,cat.id as catid, cat.alias as category_alias,us.id,us.name as author,tz_xc.type as type_media,tz_xc.* 
  FROM ecw3r_content as ct 
  LEFT JOIN ecw3r_categories as cat 
  on cat.id = ct.catid 
  LEFT JOIN ecw3r_users as us 
  on us.id = ct.created_by 
  LEFT JOIN ecw3r_tz_portfolio_xref_content as tz_xc 
  on tz_xc.contentid = ct.id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM ecw3r_categories as c 
  LEFT JOIN ecw3r_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

ALTRE tabelle:

1 × INSERT INTO `ecw3r_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('27q46bph675bub0gilnpsr9vh8', 1, '1726671968', 0, '', 0

1 × UPDATE `ecw3r_extensions` 
  SET `params` = '{\"mediaversion\":\"0e154a8970cfb392c31644c090d5aac6\"}'

1 × SHOW FULL COLUMNS 
  FROM `ecw3r_users

1 × SHOW FULL COLUMNS 
  FROM `ecw3r_contact_details

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

Scrivi a Sandrini Impianti

Seguici su Facebook

Cosa fa Sandrini?

Resta aggiornato

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

19 query eseguite 77.87 ms

Trovati 3 duplicati!

17 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: