formazione

Chi Siamo

Written by Super User on 02 Maggio 2011.

Antares Project srlè una società indipendente di Consulenza specialistica in ambito Sicurezza e Salute sui luoghi di lavoro operante su tutto il territorio nazionale.

Nell’ambito delle proprie attività, grazie alle competenze multidisciplinari e all’esperienza dei professionisti di cui si avvale, è in grado di supportare le imprese nella realizzazione di progetti a diversi livelli di complessità con un’ampia gamma di servizi, facendo leva sulle persone, le competenze e le tecnologie più adatte alle specifiche esigenze.

Antares Project srlè sede territoriale ANFOS- Associazione nazionale formatori della sicurezza su lavoro – accreditato con il numero 01921, ed è perciò in grado di fornire alle imprese formazione specialistica accreditata e riconosciuta a livello nazionale.

La nostra mission è partecipare allo sviluppo degli individui e delle aziende per aiutarli a realizzare i propri obiettivi in ambito di sicurezza e salute sui luoghi di lavoro.

Antares Project srl è certificata secondo la ISO 9001:15,l’azienda adotta un sistema di regole, responsabilità, controlli e procedure conforme alla famiglia di norme ISO 9000 valido in tutto il mondo, per evidenziare inoltre l’attenzione alle necessità dei clienti e la voglia di migliorare continuativamente il servizio offerto. Il fulcro della nostra mission è quello di partecipare allo sviluppo degli individui e delle aziende per aiutarli a realizzare i propri obiettivi.

Su di noi

Antares Project srl nasce nel 2019 da un’idea imprenditoriale dei suoi soci con l’obiettivo primario di creare una società multi servizi assolutamente unica nel panorama locale e nazionale.

Sfruttando l’elevata esperienza e competenza dei soci fondatori nei vari settori industriali, Antares Project srl è così in grado di rispondere alle più varie e singolari esigenze dei suo clienti, offrendo servizi come corsi di formazione, assistenza alle imprese, progettazione ed altro.

Indirizzo

Antares Project srl

Via E. Azimonti 54

Marsicovetere (PZ)

85050

info@pec.antares-project.it

info@antares-project.it

+39 351 674 6696

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1734932089,
                "last": 1734932089,
                "now": 1734932089
            }
        },
        "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: 50.09 ms / 50.09 ms Memoria: 0.049 MB / 0.40 MB Application: afterLoad

Tempo: 423.83 ms / 473.92 ms Memoria: 1.223 MB / 1.62 MB Application: afterInitialise

Tempo: 31.15 ms / 505.07 ms Memoria: 0.263 MB / 1.89 MB Application: afterRoute

Tempo: 10.83 ms / 515.90 ms Memoria: 0.036 MB / 1.92 MB Application: beforeRenderComponent com_tags

Tempo: 76.19 ms / 592.08 ms Memoria: 0.645 MB / 2.57 MB Application: afterRenderComponent com_tags

Tempo: 5.48 ms / 597.56 ms Memoria: 0.011 MB / 2.58 MB Application: afterDispatch

Tempo: 10.51 ms / 608.07 ms Memoria: 0.074 MB / 2.65 MB Application: beforeRenderModule mod_custom (Su di noi)

Tempo: 6.40 ms / 614.47 ms Memoria: 0.014 MB / 2.67 MB Application: afterRenderModule mod_custom (Su di noi)

Tempo: 0.07 ms / 614.54 ms Memoria: 0.000 MB / 2.67 MB Application: beforeRenderModule mod_custom (Indirizzo)

Tempo: 0.20 ms / 614.74 ms Memoria: 0.004 MB / 2.67 MB Application: afterRenderModule mod_custom (Indirizzo)

Tempo: 0.05 ms / 614.79 ms Memoria: 0.000 MB / 2.67 MB Application: beforeRenderModule mod_custom (Logo footer)

Tempo: 0.19 ms / 614.98 ms Memoria: 0.004 MB / 2.67 MB Application: afterRenderModule mod_custom (Logo footer)

Tempo: 15.53 ms / 630.51 ms Memoria: 0.033 MB / 2.71 MB Application: beforeRenderModule mod_custom (Logo Left)

Tempo: 0.53 ms / 631.04 ms Memoria: 0.004 MB / 2.71 MB Application: afterRenderModule mod_custom (Logo Left)

Tempo: 0.96 ms / 632.01 ms Memoria: 0.003 MB / 2.71 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 9.18 ms / 641.19 ms Memoria: 0.022 MB / 2.74 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 13.30 ms / 654.48 ms Memoria: 0.078 MB / 2.81 MB Application: beforeRenderModule mod_custom (Logo Mobile)

Tempo: 0.28 ms / 654.76 ms Memoria: 0.005 MB / 2.82 MB Application: afterRenderModule mod_custom (Logo Mobile)

Tempo: 2.88 ms / 657.64 ms Memoria: 0.002 MB / 2.82 MB Application: beforeRenderModule mod_custom (Copyright)

Tempo: 0.25 ms / 657.89 ms Memoria: 0.004 MB / 2.82 MB Application: afterRenderModule mod_custom (Copyright)

Tempo: 0.06 ms / 657.95 ms Memoria: 0.000 MB / 2.82 MB Application: beforeRenderModule mod_custom (Social Icons)

Tempo: 0.19 ms / 658.13 ms Memoria: 0.004 MB / 2.83 MB Application: afterRenderModule mod_custom (Social Icons)

Tempo: 0.79 ms / 658.93 ms Memoria: 0.003 MB / 2.83 MB Application: beforeRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 1.09 ms / 660.02 ms Memoria: 0.006 MB / 2.84 MB Application: afterRenderModule mod_menu (Main Menu Offcanvas)

Tempo: 7.26 ms / 667.28 ms Memoria: 0.000 MB / 2.82 MB Application: afterRender

Query totali del database: 44.90 ms

Utilizzo memoria

Query Database

30 query eseguite 44.90 ms

Trovati 6 duplicati!

2 duplicati: #9 #10

2 duplicati: #14 #16

2 duplicati: #25 #27

Tempo della query: 0.81 ms Memoria query: 0.022 MB memoria prima della query: 0.674 MB Righe restituite: 0

SELECT `data`

  FROM `w2bao_session`

  WHERE `session_id` = 'to8f6d07j3mrmm27tiper2gjfr'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.06 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
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:408
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.43 ms Dopo l'ultima query: 4.40 ms Memoria query: 0.003 MB memoria prima della query: 0.691 MB

DELETE 

  FROM `w2bao_session`

  WHERE `time` < '1734931189'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	w2bao_session	NULL	range	time	time	59	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.02 ms
System lock	0.04 ms
updating	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
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:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Tempo della query: 0.47 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.019 MB memoria prima della query: 0.696 MB Righe restituite: 0

SELECT `session_id`

  FROM `w2bao_session`

  WHERE `session_id` = 'to8f6d07j3mrmm27tiper2gjfr' 
  LIMIT 1

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
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.64 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.003 MB memoria prima della query: 0.700 MB

INSERT INTO `w2bao_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('to8f6d07j3mrmm27tiper2gjfr', 0, 1, '1734932089', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('to8f6d07j3mrmm27tiper2gjfr', 0, 1, '1734932089', 0, '')

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
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.98 ms Dopo l'ultima query: 3.24 ms Memoria query: 0.022 MB memoria prima della query: 0.723 MB Righe restituite: 32

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

  FROM `w2bao_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	32	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.30 ms Dopo l'ultima query: 1.83 ms Memoria query: 0.021 MB memoria prima della query: 0.737 MB Righe restituite: 1

SELECT b.id

  FROM w2bao_usergroups AS a

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

  WHERE a.id = 1

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	1	100.00	Using where; Using index

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.28 ms Dopo l'ultima query: 1.11 ms Memoria query: 0.021 MB memoria prima della query: 0.742 MB Righe restituite: 3

SELECT id, rules

  FROM `w2bao_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_viewlevels	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.08 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.023 MB memoria prima della query: 0.749 MB Righe restituite: 49

SELECT folder AS type, element AS name, params

  FROM w2bao_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	extension	extension	82	const	63	0.62	Using index condition; Using where; Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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: 31.95 ms Memoria query: 0.023 MB memoria prima della query: 1.154 MB Righe restituite: 1

Query duplicate: #10

SELECT template

  FROM w2bao_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.28 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.023 MB memoria prima della query: 1.161 MB Righe restituite: 1

Query duplicate: #9

SELECT template

  FROM w2bao_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	33.33	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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: 7.78 ms Memoria query: 0.021 MB memoria prima della query: 1.289 MB Righe restituite: 2

SELECT extension, file, type

  FROM w2bao_rokcommon_configs

  ORDER BY priority

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_rokcommon_configs	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using filesort

Profilo

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

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.64 ms Dopo l'ultima query: 21.58 ms Memoria query: 0.025 MB memoria prima della query: 1.432 MB Righe restituite: 17

SHOW FULL COLUMNS 
  FROM `w2bao_extensions`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
12	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
11	JTable->__construct()	JROOT/libraries/joomla/table/extension.php:31
10	JTableExtension->__construct()	JROOT/libraries/joomla/table/table.php:308
9	JTable::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.68 ms Dopo l'ultima query: 1.96 ms Memoria query: 0.021 MB memoria prima della query: 1.459 MB Righe restituite: 1

SELECT `extension_id`

  FROM `w2bao_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.05 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 1.466 MB Righe restituite: 1

Query duplicate: #16

SELECT *

  FROM w2bao_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.75 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.021 MB memoria prima della query: 1.470 MB Righe restituite: 1

SELECT `extension_id`

  FROM `w2bao_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/table/extension.php:109
9	JTableExtension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.41 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.021 MB memoria prima della query: 1.476 MB Righe restituite: 1

Query duplicate: #14

SELECT *

  FROM w2bao_extensions

  WHERE `extension_id` = '10057'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
9	JTable->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.16 ms Dopo l'ultima query: 296.26 ms Memoria query: 0.067 MB memoria prima della query: 1.634 MB Righe restituite: 38

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM w2bao_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	1	5.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.component_id	1	100.00	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.43 ms Dopo l'ultima query: 25.06 ms Memoria query: 0.022 MB memoria prima della query: 1.904 MB Righe restituite: 1

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

  FROM `w2bao_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 1.96 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.005 MB memoria prima della query: 1.894 MB

UPDATE `w2bao_extensions`

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

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

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.48 ms
updating	0.14 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.81 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:977
4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.56 ms Dopo l'ultima query: 2.54 ms Memoria query: 0.019 MB memoria prima della query: 1.909 MB Righe restituite: 1

SELECT *

  FROM w2bao_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_languages	NULL	system	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.71 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.019 MB memoria prima della query: 1.917 MB Righe restituite: 2

SELECT id, home, template, s.params

  FROM w2bao_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	1.67	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	Sql1535287_1.e.element	2	33.33	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.76 ms Dopo l'ultima query: 12.29 ms Memoria query: 0.043 MB memoria prima della query: 2.046 MB Righe restituite: 15

SELECT *

  FROM `w2bao_content_types`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	w2bao_content_types	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	15	100.00	NULL

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/cms/helper/tags.php:775
17	JHelperTags::getTypes()	JROOT/libraries/cms/helper/tags.php:609
16	JHelperTags->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:148
15	TagsModelTag->getListQuery()	JROOT/libraries/legacy/model/list.php:129
14	JModelList->_getListQuery()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.45 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.023 MB memoria prima della query: 2.056 MB Righe restituite: 1

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM w2bao_contentitem_tag_map AS m

  INNER JOIN w2bao_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-12-23 05:34:50')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-12-23 05:34:50')

  INNER JOIN w2bao_content_types AS ct 
  ON ct.type_alias = m.type_alias

  INNER JOIN w2bao_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1

  LEFT JOIN w2bao_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (2) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	system	PRIMARY,tag_idx,idx_access,idx_content_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	tc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	1	16.67	Using index condition; Using where
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	Sql1535287_1.m.type_alias	2	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
starting	0.03 ms
checking query cache for query	0.54 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
Opening tables	1.13 ms
init	0.40 ms
System lock	0.02 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
System lock	0.10 ms
optimizing	0.06 ms
statistics	0.42 ms
preparing	0.10 ms
Creating tmp table	0.24 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.51 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.06 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.05 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.07 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.01 ms
freeing items	0.01 ms
storing result in query cache	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
13	JModelList->getItems()	JROOT/components/com_tags/models/tag.php:86
12	TagsModelTag->getItems()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:51
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.33 ms Dopo l'ultima query: 2.42 ms Memoria query: 0.033 MB memoria prima della query: 2.096 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `w2bao_tags`

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:28
14	TagsTableTag->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/components/com_tags/models/tag.php:281
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.75 ms Dopo l'ultima query: 2.61 ms Memoria query: 0.023 MB memoria prima della query: 2.143 MB Righe restituite: 1

Query duplicate: #27

SELECT *

  FROM w2bao_tags

  WHERE `id` = '2'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/components/com_tags/models/tag.php:290
12	TagsModelTag->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:52
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 2.23 ms Dopo l'ultima query: 1.33 ms Memoria query: 0.023 MB memoria prima della query: 2.167 MB Righe restituite: 1

SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM w2bao_contentitem_tag_map AS m

  INNER JOIN w2bao_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-12-23 05:34:50')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-12-23 05:34:50')

  INNER JOIN w2bao_content_types AS ct 
  ON ct.type_alias = m.type_alias

  INNER JOIN w2bao_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1

  LEFT JOIN w2bao_users AS ua 
  ON ua.id = c.core_created_user_id

  WHERE m.tag_id IN (2) 
  AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category') 
  AND c.core_access IN (0,1)

  GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, name, author_email

  ORDER BY MAX(`c`.`core_title`) ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	system	PRIMARY,tag_idx,idx_access,idx_content_type	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using temporary; Using filesort
1	SIMPLE	tc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	1	16.67	Using index condition; Using where
1	SIMPLE	ct	NULL	ref	idx_alias	idx_alias	402	Sql1535287_1.m.type_alias	2	100.00	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
starting	0.02 ms
checking query cache for query	0.31 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 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.09 ms
optimizing	0.04 ms
statistics	0.20 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.33 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.04 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.05 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
storing result in query cache	0.09 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/legacy/model/legacy.php:350
14	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:278
13	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:228
12	JModelList->getPagination()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_tags/views/tag/view.html.php:55
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 7.50 ms Memoria query: 0.023 MB memoria prima della query: 2.188 MB Righe restituite: 1

Query duplicate: #25

SELECT *

  FROM w2bao_tags

  WHERE `id` = '2'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_tags/models/tag.php:335
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:184
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.64 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.006 MB memoria prima della query: 2.194 MB

UPDATE w2bao_tags

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

  WHERE `id` = '2'

Explain

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

Profilo

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

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_tags/models/tag.php:336
11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:184
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 0.72 ms Dopo l'ultima query: 35.46 ms Memoria query: 0.028 MB memoria prima della query: 2.581 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 w2bao_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN w2bao_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) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=10

  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	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	range	cat_idx,idx_access,idx_left_right	cat_idx	208	NULL	4	55.55	Using index condition; Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	Sql1535287_1.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	ALL	PRIMARY,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	12	11.11	Range checked for each record (index map: 0x11)

Profilo

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

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
21	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
20	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
19	ContentHelperRoute::getArticleRoute()	JROOT/components/com_tags/helpers/route.php:55
18	TagsHelperRoute::getItemRoute()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/com_tags/tag/default_items.php:74
17	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/com_tags/tag/default_items.php	JROOT/templates/jp-rooms/html/com_tags/tag/default_items.php:12
16	include JROOT/templates/jp-rooms/html/com_tags/tag/default_items.php	JROOT/libraries/legacy/view/legacy.php:677
15	JViewLegacy->loadTemplate()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/com_tags/tag/default.php:51
14	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/com_tags/tag/default.php	JROOT/templates/jp-rooms/html/com_tags/tag/default.php:12
13	include JROOT/templates/jp-rooms/html/com_tags/tag/default.php	JROOT/libraries/legacy/view/legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
11	JViewLegacy->display()	JROOT/components/com_tags/views/tag/view.html.php:188
10	TagsViewTag->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_tags/controller.php:52
8	TagsController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_tags/tags.php:15
6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Tempo della query: 5.13 ms Dopo l'ultima query: 12.34 ms Memoria query: 0.026 MB memoria prima della query: 2.638 MB Righe restituite: 9

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

  FROM w2bao_modules AS m

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

  LEFT JOIN w2bao_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-12-23 05:34:50') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-23 05:34:50') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	9	1.15	Using index condition; Using where; Using filesort
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	Sql1535287_1.m.id	1	40.00	Using where; Using index
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_folder_clientid	402	Sql1535287_1.m.module	11	1.00	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:434
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:370
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
12	JDocumentHtml->countModules()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-rooms/layouts/theme.config.php:28
10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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]

24 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

```
2 × SELECT * 
  FROM w2bao_extensions
```

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

```
2 × SELECT * 
  FROM w2bao_tags
```

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM w2bao_contentitem_tag_map AS m 
  INNER JOIN w2bao_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-12-23 05:34:50')  
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-12-23 05:34:50') 
  INNER JOIN w2bao_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  INNER JOIN w2bao_categories AS tc 
  ON tc.id = c.core_catid 
  AND tc.published = 1 
  LEFT JOIN w2bao_users AS ua 
  ON ua.id = c.core_created_user_id

2 × SELECT template 
  FROM w2bao_template_styles as s

2 × SELECT `extension_id` 
  FROM `w2bao_extensions`

```
1 × SELECT * 
  FROM w2bao_languages
```

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 w2bao_categories as c 
  LEFT JOIN  (SELECT cat.id as id 
  FROM w2bao_categories AS cat JOIN w2bao_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT * 
  FROM `w2bao_content_types

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

1 × SELECT `data` 
  FROM `w2bao_session`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM w2bao_menu AS m 
  LEFT JOIN w2bao_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `session_id` 
  FROM `w2bao_session`

1 × SELECT extension, file, type 
  FROM w2bao_rokcommon_configs

1 × SELECT folder AS type, element AS name, params 
  FROM w2bao_extensions

1 × SELECT id, rules 
  FROM `w2bao_viewlevels

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

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

ALTRE tabelle:

```
1 × DELETE  
  FROM `w2bao_session`
```

1 × INSERT INTO `w2bao_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('to8f6d07j3mrmm27tiper2gjfr', 0, 1, '1734932089', 0, ''

1 × SHOW FULL COLUMNS 
  FROM `w2bao_extensions

1 × UPDATE `w2bao_extensions` 
  SET `params` = '{\"mediaversion\":\"f42f3bdce8ae78de785e5669084576da\"}'

1 × SHOW FULL COLUMNS 
  FROM `w2bao_tags

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