Arci Perugia - Arci Perugia

La libertà non consiste banalmente nel fare ciò che si vuole, ma nasce dall’aggregazione tra gli individui, sorge quando ci si sente soggetti attivi nelle decisioni.

Console Debug Joomla!

Tempo

Memoria

Tempo: 0.0 ms / 0.0 ms Memoria: 0.379 MB / 0.38 MB Application: afterLoad

Tempo: 36.0 ms / 36.0 ms Memoria: 2.008 MB / 2.39 MB Application: afterInitialise

Tempo: 27.6 ms / 63.6 ms Memoria: 1.549 MB / 3.94 MB Application: afterRoute

Tempo: 23.2 ms / 86.8 ms Memoria: 0.660 MB / 4.60 MB Application: afterDispatch

Tempo: 29.8 ms / 116.6 ms Memoria: 0.979 MB / 5.57 MB Application: beforeRenderModule mod_custom (Felicità è partecipazione)

Tempo: 2.8 ms / 119.4 ms Memoria: 0.012 MB / 5.59 MB Application: afterRenderModule mod_custom (Felicità è partecipazione)

Tempo: 0.2 ms / 119.7 ms Memoria: 0.000 MB / 5.59 MB Application: beforeRenderModule mod_custom (Tesseramento 2017/2018)

Tempo: 0.3 ms / 119.9 ms Memoria: 0.007 MB / 5.59 MB Application: afterRenderModule mod_custom (Tesseramento 2017/2018)

Tempo: 0.1 ms / 120.0 ms Memoria: 0.000 MB / 5.59 MB Application: beforeRenderModule mod_menu (Arci Perugia)

Tempo: 5.3 ms / 125.3 ms Memoria: 0.058 MB / 5.65 MB Application: afterRenderModule mod_menu (Arci Perugia)

Tempo: 0.1 ms / 125.4 ms Memoria: 0.000 MB / 5.64 MB Application: beforeRenderModule mod_menu (Il Mondo Arci)

Tempo: 1.9 ms / 127.3 ms Memoria: 0.031 MB / 5.67 MB Application: afterRenderModule mod_menu (Il Mondo Arci)

Tempo: 0.1 ms / 127.4 ms Memoria: 0.000 MB / 5.67 MB Application: beforeRenderModule mod_custom (Progetti)

Tempo: 0.3 ms / 127.7 ms Memoria: 0.007 MB / 5.67 MB Application: afterRenderModule mod_custom (Progetti)

Tempo: 0.1 ms / 127.8 ms Memoria: 0.000 MB / 5.67 MB Application: beforeRenderModule mod_ohanahrelatedinfo (Informazione correlate evento)

Tempo: 38.5 ms / 166.4 ms Memoria: 0.694 MB / 6.36 MB Application: afterRenderModule mod_ohanahrelatedinfo (Informazione correlate evento)

Tempo: 0.1 ms / 166.5 ms Memoria: 0.001 MB / 6.36 MB Application: beforeRenderModule mod_ohanahcalendar2 (Calendario Eventi)

Tempo: 15.3 ms / 181.8 ms Memoria: 0.111 MB / 6.48 MB Application: afterRenderModule mod_ohanahcalendar2 (Calendario Eventi)

Tempo: 0.2 ms / 182.0 ms Memoria: 0.006 MB / 6.48 MB Application: beforeRenderModule mod_sp_facebook (Seguici su Facebook)

Tempo: 4.0 ms / 186.0 ms Memoria: 0.039 MB / 6.52 MB Application: afterRenderModule mod_sp_facebook (Seguici su Facebook)

Tempo: 0.3 ms / 186.2 ms Memoria: 0.000 MB / 6.50 MB Application: beforeRenderModule mod_acymailing (Newsletter)

Tempo: 2.1 ms / 188.3 ms Memoria: 0.077 MB / 6.58 MB Application: afterRenderModule mod_acymailing (Newsletter)

Tempo: 0.2 ms / 188.5 ms Memoria: 0.000 MB / 6.55 MB Application: beforeRenderModule mod_ohanaheventmap (Mappa Evento)

Tempo: 14.3 ms / 202.8 ms Memoria: 0.082 MB / 6.63 MB Application: afterRenderModule mod_ohanaheventmap (Mappa Evento)

Tempo: 0.2 ms / 203.0 ms Memoria: 0.000 MB / 6.63 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 3.7 ms / 206.6 ms Memoria: 0.028 MB / 6.66 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 0.2 ms / 206.8 ms Memoria: 0.000 MB / 6.66 MB Application: beforeRenderModule mod_custom (Social Icon)

Tempo: 0.2 ms / 207.0 ms Memoria: 0.006 MB / 6.66 MB Application: afterRenderModule mod_custom (Social Icon)

Tempo: 42.2 ms / 249.2 ms Memoria: 0.117 MB / 6.78 MB Application: afterRender

Query totali del database: 10.5 ms

17 query eseguite 10.5 ms

Tempo della query: 0.33 ms Memoria query: 0.013 MB memoria prima della query: 0.834 MB Righe restituite: 0
```
SELECT `data`

  FROM `arciPG_session`

  WHERE `session_id` = 'hvevnbuje3h62oh8fq9drq6q92'
```
Explain
EXPLAIN non possibile sulla query: SELECT `data` FROM `arciPG_session` WHERE `session_id` = 'hvevnbuje3h62oh8fq9drq6q92'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.32 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.010 MB memoria prima della query: 0.891 MB Righe restituite: 0
```
SELECT `session_id`

  FROM `arciPG_session`

  WHERE `session_id` = 'hvevnbuje3h62oh8fq9drq6q92' 
  LIMIT 0, 1
```
Explain
EXPLAIN non possibile sulla query: SELECT `session_id` FROM `arciPG_session` WHERE `session_id` = 'hvevnbuje3h62oh8fq9drq6q92' LIMIT 0, 1
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[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.17 ms Memoria query: 0.009 MB memoria prima della query: 0.904 MB
```
INSERT INTO `arciPG_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('hvevnbuje3h62oh8fq9drq6q92', 0, '1524586146')
```
Explain
EXPLAIN non possibile sulla query: INSERT INTO `arciPG_session` (`session_id`, `client_id`, `time`) VALUES ('hvevnbuje3h62oh8fq9drq6q92', 0, '1524586146')
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.62 ms Dopo l'ultima query: 0.99 ms Memoria query: 0.012 MB memoria prima della query: 0.985 MB Righe restituite: 39
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM arciPG_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN non possibile sulla query: SELECT extension_id AS id, element AS "option", params, enabled FROM arciPG_extensions WHERE `type` = 'component'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.10 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.012 MB memoria prima della query: 1.055 MB Righe restituite: 1
```
SELECT b.id

  FROM arciPG_usergroups AS a

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

  WHERE a.id = 1
```
Explain
EXPLAIN non possibile sulla query: SELECT b.id FROM arciPG_usergroups AS a LEFT JOIN arciPG_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.08 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.011 MB memoria prima della query: 1.074 MB Righe restituite: 3
```
SELECT id, rules

  FROM `arciPG_viewlevels`
```
Explain
EXPLAIN non possibile sulla query: SELECT id, rules FROM `arciPG_viewlevels`
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.16 ms Dopo l'ultima query: 0.31 ms Memoria query: 0.009 MB memoria prima della query: 1.092 MB Righe restituite: 72
```
SELECT folder AS type, element AS name, params

  FROM arciPG_extensions

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

  ORDER BY ordering
```
Explain
EXPLAIN non possibile sulla query: SELECT folder AS type, element AS name, params FROM arciPG_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.54 ms Dopo l'ultima query: 12.37 ms Memoria query: 0.012 MB memoria prima della query: 1.869 MB Righe restituite: 1
```
SELECT `enabled`

  FROM `arciPG_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
```
Explain
EXPLAIN non possibile sulla query: SELECT `enabled` FROM `arciPG_extensions` WHERE `element` = 'com_akeeba' AND `type` = 'component'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/plugins/system/backuponupdate/backuponupdate.php:50
JROOT/libraries/cms/plugin/helper.php:230
JROOT/libraries/cms/plugin/helper.php:170
JROOT/libraries/cms/application/cms.php:653
JROOT/libraries/cms/application/site.php:663
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.70 ms Dopo l'ultima query: 12.39 ms Memoria query: 0.019 MB memoria prima della query: 2.440 MB Righe restituite: 40
```
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 arciPG_menu AS m

  LEFT JOIN arciPG_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
EXPLAIN non possibile sulla query: 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 arciPG_menu AS m LEFT JOIN arciPG_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
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.52 ms Dopo l'ultima query: 4.03 ms Memoria query: 0.022 MB memoria prima della query: 2.879 MB Righe restituite: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM arciPG_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN non possibile sulla query: SELECT extension_id AS id, element AS "option", params, enabled FROM arciPG_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/advancedmodules/advancedmodules.php:43
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[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.40 ms Memoria query: 0.018 MB memoria prima della query: 2.887 MB
```
UPDATE `arciPG_extensions`

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

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN non possibile sulla query: UPDATE `arciPG_extensions` SET `params` = '{\"mediaversion\":\"bfa0e062ec74f5abb36567ee0f680c55\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/advancedmodules/advancedmodules.php:43
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.13 ms Dopo l'ultima query: 3.64 ms Memoria query: 0.018 MB memoria prima della query: 3.053 MB Righe restituite: 2
```
SELECT *

  FROM arciPG_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM arciPG_languages WHERE published=1 ORDER BY ordering ASC
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/components/com_k2/helpers/utilities.php:315
JROOT/administrator/components/com_k2/helpers/html.php:56
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.60 ms Dopo l'ultima query: 0.69 ms Memoria query: 0.024 MB memoria prima della query: 3.112 MB Righe restituite: 2
```
SELECT id, home, template, s.params

  FROM arciPG_template_styles as s

  LEFT JOIN arciPG_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
EXPLAIN non possibile sulla query: SELECT id, home, template, s.params FROM arciPG_template_styles as s LEFT JOIN arciPG_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
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/html/html.php:334
JROOT/libraries/cms/html/html.php:680
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/libraries/cms/html/behavior.php:61
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/administrator/components/com_k2/helpers/html.php:76
JROOT/plugins/system/k2/k2.php:55
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.20 ms Dopo l'ultima query: 10.37 ms Memoria query: 0.016 MB memoria prima della query: 3.615 MB Righe restituite: 80
```
SELECT * 
  FROM arciPG_acymailing_config
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM arciPG_acymailing_config
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
JROOT/administrator/components/com_acymailing/helpers/helper.php:454
JROOT/administrator/components/com_acymailing/helpers/helper.php:1128
JROOT/plugins/system/regacymailing/regacymailing.php:38
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.15 ms Dopo l'ultima query: 2.49 ms Memoria query: 0.014 MB memoria prima della query: 3.907 MB Righe restituite: 0
```
SELECT * 
  FROM `arciPG_acymailing_fields` as a 
  WHERE a.`published` = 1 
  AND a.`frontjoomlaregistration` = 1 
  AND a.`type` != 'category'  
  ORDER BY a.`ordering` ASC
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM `arciPG_acymailing_fields` as a WHERE a.`published` = 1 AND a.`frontjoomlaregistration` = 1 AND a.`type` != 'category' ORDER BY a.`ordering` ASC
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/administrator/components/com_acymailing/classes/fields.php:94
JROOT/plugins/system/regacymailing/regacymailing.php:52
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.34 ms Dopo l'ultima query: 28.64 ms Memoria query: 0.026 MB memoria prima della query: 4.839 MB Righe restituite: 51
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down

  FROM arciPG_modules AS m

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

  LEFT JOIN arciPG_advancedmodules as am 
  ON am.moduleid = m.id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND m.access IN (1,1) 
  AND m.client_id = 0

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN non possibile sulla query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down FROM arciPG_modules AS m LEFT JOIN arciPG_extensions AS e ON e.element = m.module AND e.client_id = m.client_id LEFT JOIN arciPG_advancedmodules as am ON am.moduleid = m.id WHERE m.published = 1 AND e.enabled = 1 AND m.access IN (1,1) AND m.client_id = 0 ORDER BY m.position, m.ordering
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:375
JROOT/plugins/system/advancedmodules/advancedmodulehelper.php:127
JROOT/libraries/joomla/event/dispatcher.php:165
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/module/helper.php:345
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/gk_musicstate/lib/framework/helper.api.php:36
JROOT/templates/gk_musicstate/lib/framework/helper.layout.php:55
JROOT/templates/gk_musicstate/layouts/default.php:62
JROOT/templates/gk_musicstate/lib/gk.framework.php:139
JROOT/templates/gk_musicstate/lib/gk.framework.php:89
JROOT/templates/gk_musicstate/index.php:26
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.23 ms Dopo l'ultima query: 93.77 ms Memoria query: 0.017 MB memoria prima della query: 6.571 MB Righe restituite: 1
```
SELECT * 
  FROM arciPG_acymailing_list 
  WHERE type = 'list'  
  ORDER BY ordering ASC
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM arciPG_acymailing_list WHERE type = 'list' ORDER BY ordering ASC
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/administrator/components/com_acymailing/classes/list.php:29
JROOT/modules/mod_acymailing/mod_acymailing.php:121
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/libraries/joomla/document/html/renderer/modules.php:43
JROOT/libraries/joomla/document/html/html.php:411
JROOT/libraries/joomla/document/html/html.php:697
JROOT/libraries/joomla/document/html/html.php:477
JROOT/libraries/cms/application/cms.php:1059
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

16 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM arciPG_extensions

1 × SELECT * 
  FROM arciPG_acymailing_confi

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

1 × SELECT * 
  FROM `arciPG_acymailing_fields` as a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params as advancedparams, 0 as menuid, m.publish_up, m.publish_down 
  FROM arciPG_modules AS m 
  LEFT JOIN arciPG_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  LEFT JOIN arciPG_advancedmodules as am 
  ON am.moduleid = m.id

1 × SELECT * 
  FROM arciPG_acymailing_list

```
1 × SELECT * 
  FROM arciPG_languages
```

1 × SELECT `enabled` 
  FROM `arciPG_extensions`

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

1 × SELECT `session_id` 
  FROM `arciPG_session`

1 × SELECT id, rules 
  FROM `arciPG_viewlevels

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

1 × SELECT `data` 
  FROM `arciPG_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 arciPG_menu AS m 
  LEFT JOIN arciPG_extensions AS e 
  ON m.component_id = e.extension_id

ALTRE tabelle:

1 × UPDATE `arciPG_extensions` 
  SET `params` = '{\"mediaversion\":\"bfa0e062ec74f5abb36567ee0f680c55\"}'

1 × INSERT INTO `arciPG_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('hvevnbuje3h62oh8fq9drq6q92', 0, '1524586146'

Felicità è partecipazione

La libertà non consiste banalmente nel fare ciò che si vuole, ma nasce dall’aggregazione tra gli individui, sorge quando ci si sente soggetti attivi nelle decisioni.

Console Debug Joomla!

Sessione

Informazioni profilo