LogoDonMilaniLibroAperto

Piano annuale della formazione - Unità formative 2018-2019

Il LabTD della Scuola don Milani è soggetto qualificato a offrire formazione al personale scolastico ai sensi dell’art. 1, co. 6 del Direttiva 170/2016.

Il piano della formazione 2018-2019 e il calendario delle iniziative sono in via di definizione. E' possibile consultare le unità formative programmate cliccando sul Leggi tutto, si verrà indirizzati alla piattaforma di comunicazione del LabTD

Per i docenti a tempo indeterminato presso le scuole statali interessati a iscriversi ai corsi è possibile farlo attraverso la piattaforma SOFIA del MIUR (qui un breve tutorial sulle funzionalità della piattaforma), oppure via Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo. indicando titolo del corso, nome e cognome, istituzione scolastica/educativa di servizio. Sarà inviata conferma alla chiusura delle iscrizioni.

Per i corsi che prevedono un contributo tramite la carta del docente (contrassegnati con un asterisco*), è necessario inserire anche il codice del relativo buono (esercizio fisico -> formazione e aggiornamento -> percorsi formativi istituzioni scolastiche).

I docenti a tempo determinato o in servizio presso scuole non statali e il personale educativo possono inviare richiesta di iscrizione alla iniziative gratuite a Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo., indicando titolo del corso, nome e cognome, istituzione scolastica/educativa di servizio. Sarà inviata conferma entro alla chiusura delle iscrizioni.

Per richiedere informazioni e attestati di partecipazione scrivere a Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.

CALENDARIO

Problem Solving: come migliorare l'apprendimento di una competenza complessa,
date 21 e 28 novembre; 12 dicembre, ore 15-17

Metacognizione a scuola. Sviluppare la metacognizione per migliorare l’apprendimento
date 27 novembre, 4 e 18 dicembre ore 16-18 + project work online

Body percussion* (iscrizioni aperte dal 30/10 al 18/11),
data da definire, ore 9-15

Giochi coreografici
date 18 gennaio 2019

Comunicazione empatica: apprendere ed utilizzare il linguaggio non violento
date da definire - ore 10-18

Questo indirizzo email è protetto dagli spambots. È necessario abilitare JavaScript per vederlo.Strumenti e tecniche per audiovisivi
date 14, 21, 28 gennaio, ore 15-18

Natura morta come genere di pittura: dall’interpretazione iconografica alla realizzazione tecnico-pittorica
data da definire

Progettare e realizzare ebook a scuola
date da definire tra marzo e aprile, orario 16,30 -18

Newsletter Labtd

Video Seminari LabTD

Seminari 2013-2014

Seminari 2012-2013

Piattaforma Labtd

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1596751251,
                "last": 1596751251,
                "now": 1596751251
            },
            "token": "d285oWXNintiyY1qkuzo2wrvZA0CwzP8"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "c453689dd9913c783d31d59142390e95ed3a0a66": {
                    "link": "https:\/\/donmilani.wikischool.it\/index.php\/centro-risorse-labtd\/131-piano-della-formazione-del-labtd",
                    "expiry": 1596751251
                }
            }
        },
        "gantry-current-template": "cloudbase3",
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-name": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-logo-type": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-logo-custom-image": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-background": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-button-bgcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-button-textcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-button-bordercolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-body-pattern": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-header-style": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-menu-border-width": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-showcase-gradient-direction": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-showcase-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-showcase-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-showcase-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-showcase-pattern": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-feature-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-feature-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-feature-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-maintop-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-maintop-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-maintop-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-bottom-gradient-direction": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-bottom-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-bottom-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-bottom-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-bottom-pattern": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-footer-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-footer-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-footer-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-footer-pattern": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-copyright-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-copyright-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-copyright-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-copyright-pattern": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-linkcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-heading": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-button-bgcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-button-textcolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-box3-button-bordercolor": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-title3-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-title4-text": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-socialicons-border": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-branding-logo": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-font-family": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-font-size-is": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-menu-type": null,
        "gantry-57cbbb1fea70910cbddbd2e94c8ed87e-layout-mode": null
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 3.90 ms / 3.90 ms Memoria: 0.560 MB / 0.89 MB Application: afterLoad

Tempo: 74.10 ms / 78.00 ms Memoria: 0.824 MB / 1.72 MB Application: afterInitialise

Tempo: 15.66 ms / 93.66 ms Memoria: 0.312 MB / 2.03 MB Application: afterRoute

Tempo: 9.36 ms / 103.02 ms Memoria: 0.129 MB / 2.16 MB Application: beforeRenderComponent com_content

Tempo: 2.50 ms / 105.52 ms Memoria: 0.115 MB / 2.27 MB Application: Before Access::preloadComponents (all components)

Tempo: 2.67 ms / 108.19 ms Memoria: 0.056 MB / 2.33 MB Application: After Access::preloadComponents (all components)

Tempo: 0.06 ms / 108.26 ms Memoria: 0.000 MB / 2.33 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Tempo: 0.44 ms / 108.69 ms Memoria: 0.009 MB / 2.33 MB Application: After Access::getAssetRules (id:8 name:com_content)

Tempo: 45.64 ms / 154.33 ms Memoria: 1.795 MB / 4.13 MB Application: afterRenderComponent com_content

Tempo: 10.74 ms / 165.07 ms Memoria: 0.178 MB / 4.31 MB Application: afterDispatch

Tempo: 11.91 ms / 176.98 ms Memoria: 0.073 MB / 4.38 MB Application: beforeRenderModule mod_roknavmenu ()

Tempo: 13.46 ms / 190.44 ms Memoria: 0.376 MB / 4.76 MB Application: afterRenderModule mod_roknavmenu ()

Tempo: 13.65 ms / 204.09 ms Memoria: 0.004 MB / 4.76 MB Application: beforeRenderModule mod_jnews (Newsletter Labtd)

Tempo: 8.31 ms / 212.39 ms Memoria: 0.259 MB / 5.02 MB Application: afterRenderModule mod_jnews (Newsletter Labtd)

Tempo: 0.12 ms / 212.52 ms Memoria: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_custom (Video Seminari LabTD )

Tempo: 0.90 ms / 213.42 ms Memoria: 0.005 MB / 4.99 MB Application: afterRenderModule mod_custom (Video Seminari LabTD )

Tempo: 0.09 ms / 213.51 ms Memoria: 0.000 MB / 4.99 MB Application: beforeRenderModule mod_custom (Piattaforma labtd (copia))

Tempo: 0.50 ms / 214.01 ms Memoria: 0.005 MB / 5.00 MB Application: afterRenderModule mod_custom (Piattaforma labtd (copia))

Tempo: 0.16 ms / 214.17 ms Memoria: 0.001 MB / 5.00 MB Application: beforeRenderModule mod_custom (logo prova (copia))

Tempo: 0.31 ms / 214.48 ms Memoria: 0.003 MB / 5.00 MB Application: afterRenderModule mod_custom (logo prova (copia))

Tempo: 3.57 ms / 218.06 ms Memoria: 0.141 MB / 5.14 MB Application: afterRender

Query totali del database: 75.23 ms

Utilizzo memoria

Query Database

28 query eseguite 75.23 ms

Trovati 2 duplicati!

2 duplicati: #14 #22

Tempo della query: 31.05 ms Memoria query: 0.027 MB memoria prima della query: 1.159 MB Righe restituite: 0

SELECT `data`

  FROM `labtd_session`

  WHERE `session_id` = 'j9mlme40885lmdp7jr18kp7kd1'

Explain

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

Profilo

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.22 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	30.12 ms
executing	0.05 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.80 ms Dopo l'ultima query: 1.08 ms Memoria query: 0.023 MB memoria prima della query: 1.177 MB Righe restituite: 0

SELECT `session_id`

  FROM `labtd_session`

  WHERE `session_id` = 'j9mlme40885lmdp7jr18kp7kd1' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.07 ms

Call Stack

#	Caller	File e numero di linea
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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: 2.73 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.005 MB memoria prima della query: 1.184 MB

INSERT INTO `labtd_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('j9mlme40885lmdp7jr18kp7kd1', 1, '1596751251', 0, '', 0)

Explain

EXPLAIN non possibile sulla query: INSERT INTO `labtd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('j9mlme40885lmdp7jr18kp7kd1', 1, '1596751251', 0, '', 0)

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.04 ms
System lock	0.02 ms
update	0.28 ms
end	0.03 ms
query end	1.94 ms
closing tables	0.06 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::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.63 ms Dopo l'ultima query: 1.22 ms Memoria query: 0.032 MB memoria prima della query: 1.283 MB Righe restituite: 35

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

  FROM `labtd_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	labtd_extensions	NULL	ref	extension	extension	82	const	37	1.00	Using where

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.55 ms
end	0.03 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:425
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:433
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:499
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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: 1.12 ms Memoria query: 0.024 MB memoria prima della query: 1.316 MB Righe restituite: 4

SELECT id, rules

  FROM `labtd_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.19 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.96 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.024 MB memoria prima della query: 1.330 MB Righe restituite: 1

SELECT b.id

  FROM labtd_usergroups AS a

  LEFT JOIN labtd_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.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.032 MB memoria prima della query: 1.354 MB Righe restituite: 57

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM labtd_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	labtd_extensions	NULL	ref	extension	extension	82	const	95	0.50	Using index condition; Using where; Using filesort

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	4.45 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.17 ms Dopo l'ultima query: 19.84 ms Memoria query: 0.066 MB memoria prima della query: 1.750 MB Righe restituite: 25

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 labtd_menu AS m

  LEFT JOIN labtd_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	46	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	libroaperto.m.component_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.64 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.91 ms Dopo l'ultima query: 8.40 ms Memoria query: 0.037 MB memoria prima della query: 2.015 MB Righe restituite: 0

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

  FROM `labtd_categories` AS `s`

  INNER JOIN `labtd_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 s.id = 131

  ORDER BY c.lft

Explain

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

Profilo

Status	Duration
starting	0.41 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Opening tables	0.49 ms
init	0.15 ms
System lock	0.05 ms
optimizing	0.05 ms
statistics	0.20 ms
executing	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.79 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.025 MB memoria prima della query: 2.022 MB Righe restituite: 1

SELECT `alias`,`catid`

  FROM `labtd_content`

  WHERE `id` = 131

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.22 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.15 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1071
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.78 ms Dopo l'ultima query: 0.59 ms Memoria query: 0.027 MB memoria prima della query: 2.049 MB Righe restituite: 1

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

  FROM `labtd_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	labtd_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.97 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.007 MB memoria prima della query: 2.042 MB

UPDATE `labtd_extensions`

  SET `params` = '{\"mediaversion\":\"79ba3736d891e18d4dd57d872fd2b7bb\"}'

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	labtd_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.03 ms
init	0.03 ms
System lock	0.16 ms
updating	0.17 ms
end	0.02 ms
query end	2.28 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.93 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.026 MB memoria prima della query: 2.081 MB Righe restituite: 2

SELECT *

  FROM labtd_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	labtd_languages	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.19 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.05 ms
Sending data	0.05 ms
Creating sort index	0.16 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.23 ms Dopo l'ultima query: 0.61 ms Memoria query: 0.028 MB memoria prima della query: 2.104 MB Righe restituite: 6

Query duplicate: #22

SELECT id, home, template, s.params

  FROM labtd_template_styles as s

  LEFT JOIN labtd_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	s	NULL	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	libroaperto.s.template,const	1	4.60	Using index condition; Using where

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.16 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.32 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.20 ms Dopo l'ultima query: 4.16 ms Memoria query: 0.034 MB memoria prima della query: 2.276 MB Righe restituite: 34

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

  FROM `labtd_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jnews','com_joomlaupdate','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_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	labtd_assets	NULL	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	200	18.00	Using where

Profilo

Status	Duration
starting	0.15 ms
checking permissions	0.02 ms
Opening tables	0.20 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.27 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	1.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:248
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.81 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.039 MB memoria prima della query: 2.337 MB Righe restituite: 30

SHOW FULL COLUMNS 
  FROM `labtd_content`

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.36 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.05 ms
checking permissions	0.07 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.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.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.03 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.14 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:250
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.78 ms Dopo l'ultima query: 2.23 ms Memoria query: 0.069 MB memoria prima della query: 2.413 MB Righe restituite: 1

SELECT *

  FROM labtd_content

  WHERE `id` = '131'

Explain

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

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.31 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.007 MB memoria prima della query: 2.457 MB

UPDATE labtd_content

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

  WHERE `id` = '131'

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.08 ms
updating	0.15 ms
end	0.03 ms
query end	1.70 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1242
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:252
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.11 ms Dopo l'ultima query: 1.16 ms Memoria query: 0.054 MB memoria prima della query: 2.484 MB Righe restituite: 1

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

  FROM labtd_content AS a

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

  LEFT JOIN labtd_users AS u 
  on u.id = a.created_by

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

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

  WHERE a.id = 131 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-08-06 22:00:51') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-08-06 22:00:51') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profilo

Status	Duration
starting	0.45 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
Opening tables	0.34 ms
init	0.15 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.35 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.11 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:148
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.52 ms Dopo l'ultima query: 1.71 ms Memoria query: 0.043 MB memoria prima della query: 2.610 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 `labtd_categories` AS `s`

  INNER JOIN `labtd_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.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 s.id = 34

  ORDER BY c.lft

Explain

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

Profilo

Status	Duration
starting	0.24 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.13 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.28 ms
preparing	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.28 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:312
21	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
20	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
19	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
18	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
17	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
16	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
15	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
14	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.24 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.037 MB memoria prima della query: 2.654 MB Righe restituite: 0

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

  FROM `labtd_contentitem_tag_map` AS m 

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

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

Explain

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

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.29 ms
init	0.11 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.37 ms Dopo l'ultima query: 24.62 ms Memoria query: 0.035 MB memoria prima della query: 4.118 MB Righe restituite: 6

Query duplicate: #14

SELECT id, home, template, s.params

  FROM labtd_template_styles as s

  LEFT JOIN labtd_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	s	NULL	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	11.11	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	libroaperto.s.template,const	1	4.60	Using index condition; Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry/core/gantrytemplate.class.php:638
23	GantryTemplate::getAllTemplates()	JROOT/libraries/gantry/core/gantrytemplate.class.php:590
22	GantryTemplate::getTemplateParams()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
21	GantryMenuItemParamOverride::_populateSingleItem()	JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
20	GantryMenuItemParamOverride::populate()	JROOT/libraries/gantry/core/gantry.class.php:1843
19	Gantry->populateParams()	JROOT/libraries/gantry/core/gantry.class.php:392
18	Gantry->init()	JROOT/libraries/gantry/gantry.php:275
17	gantry_setup()	JROOT/libraries/gantry/gantry.php:432
16	include JROOT/libraries/gantry/gantry.php	JROOT/templates/cloudbase3/html/com_content/article/default_links.php:14
15	include JROOT/templates/cloudbase3/html/com_content/article/default_links.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/cloudbase3/html/com_content/article/default.php:106
13	include JROOT/templates/cloudbase3/html/com_content/article/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:695
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_content/views/article/view.html.php:210
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->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.89 ms Dopo l'ultima query: 18.20 ms Memoria query: 0.031 MB memoria prima della query: 4.366 MB Righe restituite: 5

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

  FROM labtd_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-08-06 22:00:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-08-06 22:00:51') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 226 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	range	PRIMARY,published,newsfeeds	published	5	NULL	42	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	libroaperto.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	libroaperto.m.id	5	40.00	Using where; Using index

Profilo

Status	Duration
starting	0.24 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.37 ms
init	0.12 ms
System lock	0.04 ms
optimizing	0.06 ms
statistics	0.23 ms
preparing	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	3.29 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.06 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
13	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
8	Gantry->countModules()	JROOT/templates/cloudbase3/index.php:56
7	require JROOT/templates/cloudbase3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->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.78 ms Dopo l'ultima query: 5.34 ms Memoria query: 0.030 MB memoria prima della query: 4.502 MB Righe restituite: 0

SELECT ts.template

  FROM labtd_template_styles AS ts

  INNER JOIN labtd_menu AS m 
  ON ts.id=m.template_style_id

  WHERE m.id = 226 
  AND m.template_style_id != 0

Explain

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

Profilo

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.14 ms
executing	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/cloudbase3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/cloudbase3/index.php:80
7	require JROOT/templates/cloudbase3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 0.71 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.030 MB memoria prima della query: 4.514 MB Righe restituite: 1

SELECT template

  FROM labtd_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	labtd_template_styles	NULL	ALL	idx_home	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	11.11	Using where

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113
16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/cloudbase3/features/dropdownmenu.php:56
10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
8	Gantry->displayModules()	JROOT/templates/cloudbase3/index.php:80
7	require JROOT/templates/cloudbase3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->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.82 ms Dopo l'ultima query: 24.32 ms Memoria query: 0.032 MB memoria prima della query: 4.913 MB Righe restituite: 3

SHOW FULL COLUMNS 
  FROM `labtd_jnews_xonfig`

Explain

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

Profilo

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.42 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.33 ms
checking permissions	0.12 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
Sending data	0.11 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.13 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:441
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:14
12	jNews_Config->jNews_Config()	JROOT/administrator/components/com_jnews/classes/class.jnews.php:42
11	require_once JROOT/administrator/components/com_jnews/classes/class.jnews.php	JROOT/modules/mod_jnews/mod_jnews.php:26
10	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Tempo della query: 1.25 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.058 MB memoria prima della query: 4.930 MB Righe restituite: 278

SELECT * 
  FROM `labtd_jnews_xonfig`

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.56 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jnews/classes/class.xonfig15.php:53
12	jNews_Config->loadConfig()	JROOT/administrator/components/com_jnews/classes/class.jnews.php:43
11	require_once JROOT/administrator/components/com_jnews/classes/class.jnews.php	JROOT/modules/mod_jnews/mod_jnews.php:26
10	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->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.03 ms Dopo l'ultima query: 1.48 ms Memoria query: 0.040 MB memoria prima della query: 4.983 MB Righe restituite: 2

SELECT * 
  FROM `labtd_jnews_lists` 
  WHERE `published` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	labtd_jnews_lists	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	50.00	Using where

Profilo

Status	Duration
starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.25 ms
init	0.08 ms
System lock	0.03 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jnews/classes/class.lists.php:284
12	jNews_Lists::getSpecifiedLists()	JROOT/administrator/components/com_jnews/classes/class.module.php:124
11	jnews_module->normal()	JROOT/modules/mod_jnews/mod_jnews.php:32
10	include JROOT/modules/mod_jnews/mod_jnews.php	JROOT/libraries/src/Helper/ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

25 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT id, home, template, s.params 
  FROM labtd_template_styles as s 
  LEFT JOIN labtd_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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

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 `labtd_categories` AS `s` 
  INNER JOIN `labtd_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

```
1 × SELECT * 
  FROM labtd_content
```

1 × SELECT * 
  FROM `labtd_jnews_xonfig

1 × SELECT template 
  FROM labtd_template_styles

1 × SELECT ts.template 
  FROM labtd_template_styles AS ts 
  INNER JOIN labtd_menu AS m 
  ON ts.id=m.template_style_id

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

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

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

1 × SELECT `data` 
  FROM `labtd_session`

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

1 × SELECT `session_id` 
  FROM `labtd_session`

```
1 × SELECT * 
  FROM labtd_languages
```

1 × SELECT `alias`,`catid` 
  FROM `labtd_content`

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 labtd_menu AS m 
  LEFT JOIN labtd_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM labtd_extensions

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

1 × SELECT id, rules 
  FROM `labtd_viewlevels

1 × SELECT * 
  FROM `labtd_jnews_lists`

ALTRE tabelle:

1 × INSERT INTO `labtd_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('j9mlme40885lmdp7jr18kp7kd1', 1, '1596751251', 0, '', 0

1 × UPDATE `labtd_extensions` 
  SET `params` = '{\"mediaversion\":\"79ba3736d891e18d4dd57d872fd2b7bb\"}'

1 × SHOW FULL COLUMNS 
  FROM `labtd_content

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

1 × SHOW FULL COLUMNS 
  FROM `labtd_jnews_xonfig