AmarilloArt

Italian Film Food Stories

Milano, dal 26 ottobre al 22 novembre 2015
Il cinema italiano ha sempre documentato lo snodarsi della storia del nostro Paese, le sue tradizioni, gli usi e, non per ultimi, i suoi riti alimentari. Attraverso il cibo e la tavola, con l'aiuto imprescindibile dei volti dei nostri grandi attori, il cinema ha raccontato i cambiamenti socioeconomici dell'ultimo secolo. La mostra Italian Film Food Stories è un viaggio per immagini tra cinema e cibo.

La tavola italiana si è trasformata rapidamente, passando dalle usanze contadine alle buone maniere borghesi: da Catene (1949) a L'audace colpo dei soliti ignoti (1959), da Il Gattopardo (1963) a Maccheroni (1985), il cibo al cinema è stato veicolo di recuperi affettivi, solidarietà, trasmissione culturale. I protagonisti del cinema italiano si ritrovano grazie al cibo, valido strumento di trasmissione valoriale, che ha il potere di ricucire senza dolore le naturali separazioni e i contrasti quotidiani tra generazioni diverse. È infatti nel sedersi a tavola che il cinema italiano ritrova tradizioni culturali, slancio vitale, solidarietà, piacere dell'incontro e del confronto, comunicazione e senso vero della condivisione.

Italian Film Food Stories3

La mostra, organizzata dalla Fondazione Ente dello Spettacolo, in collaborazione con il Centro Sperimentale di Cinematografia - Cineteca Nazionale, dopo essere stata in esposizione in questi mesi all’Edicola Caritas Internationalis - Padiglione Vaticano all’interno di Expo Milano, continua, in versione ampliata nel Chiostro del Museo Diocesano di Milano.
La mostra, composta di 48 fotografie scelte attraverso un attento lavoro di selezione all'interno della Fototeca del Centro Sperimentale, è realizzata con il sostegno della Direzione Generale Cinema del Ministero dei Beni e delle Attività Culturali e del Turismo e con la collaborazione di «Avvenire», TV2000 e Radio InBlu.

Italian Film Food Stories1

L'esposizione fotografica si propone di raccontare, attraverso il cibo e la tavola e con l'aiuto imprescindibile dei volti più noti del nostro cinema, i cambiamenti socioeconomici quanto il forte slancio di solidarietà che hanno caratterizzato la società italiana nell'ultimo secolo. Attraverso scene di film indimenticabili e scatti rubati sul set dalla maestria dei direttori della fotografia, Italian Film Food Stories ci propone una galleria di personaggi - da Amedeo Nazzari a Walter Chiari, da Isa Miranda a Vittorio De Sica, da Nino Manfredi a Vittorio Gassman e Ugo Tognazzi, da Sophia Loren a Claudia Cardinale - capaci con l'intensità delle loro interpretazioni di accompagnarci nel ripercorrere la storia del nostro Paese.

Italian Film Food Stories2
(Nelle foto, alcune immagini della mostra).

Info

Italian Film Food Stories
dal 26 ottobre al 22 novembre 2015
Chiostro del Museo Diocesano
Corso di Porta Ticinese, 95
ingresso gratuito
www.italianfilmfoodstories.com
www.fondazionecsc.it

Console Debug Joomla!

Tempo

Memoria

Tempo: 0.0 ms / 0.0 ms Memoria: 0.758 MB / 0.76 MB Application: afterLoad

Tempo: 89.6 ms / 89.6 ms Memoria: 5.382 MB / 6.14 MB Application: afterInitialise

Tempo: 26.0 ms / 115.6 ms Memoria: 1.849 MB / 7.99 MB Application: afterRoute

Tempo: 123.1 ms / 238.6 ms Memoria: 6.272 MB / 14.26 MB Application: afterDispatch

Tempo: 20.1 ms / 258.7 ms Memoria: 0.338 MB / 14.60 MB Application: beforeRenderModule mod_roknavmenu ()

Tempo: 28.3 ms / 287.0 ms Memoria: 0.929 MB / 15.53 MB Application: afterRenderModule mod_roknavmenu ()

Tempo: 6.7 ms / 293.8 ms Memoria: 0.014 MB / 15.54 MB Application: beforeRenderModule mod_roknavmenu (Main menu2)

Tempo: 13.8 ms / 307.6 ms Memoria: 0.035 MB / 15.58 MB Application: afterRenderModule mod_roknavmenu (Main menu2)

Tempo: 0.1 ms / 307.7 ms Memoria: 0.000 MB / 15.54 MB Application: beforeRenderModule mod_custom (logo)

Tempo: 1.4 ms / 309.1 ms Memoria: 0.010 MB / 15.55 MB Application: afterRenderModule mod_custom (logo)

Tempo: 0.1 ms / 309.2 ms Memoria: 0.000 MB / 15.55 MB Application: beforeRenderModule mod_custom (Contatti)

Tempo: 2.2 ms / 311.4 ms Memoria: 0.031 MB / 15.58 MB Application: afterRenderModule mod_custom (Contatti)

Tempo: 0.1 ms / 311.5 ms Memoria: 0.000 MB / 15.58 MB Application: beforeRenderModule mod_custom (AmarilloArt)

Tempo: 1.0 ms / 312.5 ms Memoria: 0.007 MB / 15.59 MB Application: afterRenderModule mod_custom (AmarilloArt)

Tempo: 0.1 ms / 312.6 ms Memoria: 0.000 MB / 15.58 MB Application: beforeRenderModule mod_custom (Cerca con google)

Tempo: 0.4 ms / 313.0 ms Memoria: 0.007 MB / 15.59 MB Application: afterRenderModule mod_custom (Cerca con google)

Tempo: 0.0 ms / 313.0 ms Memoria: 0.000 MB / 15.59 MB Application: beforeRenderModule mod_articles_categories (Magazine)

Tempo: 5.3 ms / 318.4 ms Memoria: 0.077 MB / 15.67 MB Application: afterRenderModule mod_articles_categories (Magazine)

Tempo: 0.1 ms / 318.5 ms Memoria: 0.001 MB / 15.67 MB Application: beforeRenderModule mod_rokgallery (Giornate della Terra e del Libro 2023)

Tempo: 244.8 ms / 563.3 ms Memoria: 9.006 MB / 24.67 MB Application: afterRenderModule mod_rokgallery (Giornate della Terra e del Libro 2023)

Tempo: 24.3 ms / 587.6 ms Memoria: 0.186 MB / 24.86 MB Application: afterRender

Query totali del database: 59.5 ms

31 query eseguite 59.5 ms

Trovati 6 duplicati!

2 duplicati: #8 #9

2 duplicati: #15 #24

2 duplicati: #19 #28

Tempo della query: 0.77 ms Memoria query: 0.015 MB memoria prima della query: 2.518 MB Righe restituite: 0
```
SELECT `data`

  FROM `rnek3_session`

  WHERE `session_id` = 'raonfacpv674t7r3q7gail5bs2'
```
Explain
EXPLAIN non possibile sulla query: SELECT `data` FROM `rnek3_session` WHERE `session_id` = 'raonfacpv674t7r3q7gail5bs2'
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:37
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.65 ms Dopo l'ultima query: 2.22 ms Memoria query: 0.012 MB memoria prima della query: 2.709 MB Righe restituite: 0
```
SELECT `session_id`

  FROM `rnek3_session`

  WHERE `session_id` = 'raonfacpv674t7r3q7gail5bs2' 
  LIMIT 0, 1
```
Explain
EXPLAIN non possibile sulla query: SELECT `session_id` FROM `rnek3_session` WHERE `session_id` = 'raonfacpv674t7r3q7gail5bs2' 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:37
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 3.05 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.009 MB memoria prima della query: 2.722 MB
```
INSERT INTO `rnek3_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('raonfacpv674t7r3q7gail5bs2', 0, '1695469834')
```
Explain
EXPLAIN non possibile sulla query: INSERT INTO `rnek3_session` (`session_id`, `client_id`, `time`) VALUES ('raonfacpv674t7r3q7gail5bs2', 0, '1695469834')
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:37
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 4.13 ms Dopo l'ultima query: 4.68 ms Memoria query: 0.018 MB memoria prima della query: 3.090 MB Righe restituite: 39
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM rnek3_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN non possibile sulla query: SELECT extension_id AS id, element AS "option", params, enabled FROM rnek3_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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.06 ms Dopo l'ultima query: 1.56 ms Memoria query: 0.014 MB memoria prima della query: 3.239 MB Righe restituite: 1
```
SELECT b.id

  FROM rnek3_usergroups AS a

  LEFT JOIN rnek3_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 rnek3_usergroups AS a LEFT JOIN rnek3_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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.83 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.013 MB memoria prima della query: 3.295 MB Righe restituite: 4
```
SELECT id, rules

  FROM `rnek3_viewlevels`
```
Explain
EXPLAIN non possibile sulla query: SELECT id, rules FROM `rnek3_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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.00 ms Dopo l'ultima query: 0.20 ms Memoria query: 0.017 MB memoria prima della query: 3.314 MB Righe restituite: 89
```
SELECT folder AS type, element AS name, params

  FROM rnek3_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 rnek3_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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.79 ms Dopo l'ultima query: 15.27 ms Memoria query: 0.019 MB memoria prima della query: 4.282 MB Righe restituite: 1
Query duplicate: #9
```
SELECT template

  FROM rnek3_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
EXPLAIN non possibile sulla query: SELECT template FROM rnek3_template_styles as s WHERE s.client_id = 0 AND s.home = 1
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:96
JROOT/plugins/system/rokcommon/rokcommon.php:54
JROOT/libraries/cms/plugin/helper.php:255
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.19 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.021 MB memoria prima della query: 4.301 MB Righe restituite: 1
Query duplicate: #8
```
SELECT template

  FROM rnek3_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
```
Explain
EXPLAIN non possibile sulla query: SELECT template FROM rnek3_template_styles as s WHERE s.client_id = 0 AND s.home = 1
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
JROOT/libraries/rokcommon/RokCommon/Service.php:71
JROOT/libraries/rokcommon/include.php:38
JROOT/plugins/system/rokcommon/rokcommon.php:96
JROOT/plugins/system/rokcommon/rokcommon.php:54
JROOT/libraries/cms/plugin/helper.php:255
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.82 ms Dopo l'ultima query: 4.79 ms Memoria query: 0.015 MB memoria prima della query: 4.482 MB Righe restituite: 2
```
SELECT extension, file, type

  FROM rnek3_rokcommon_configs

  ORDER BY priority
```
Explain
EXPLAIN non possibile sulla query: SELECT extension, file, type FROM rnek3_rokcommon_configs ORDER BY priority
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/plugins/system/rokcommon/rokcommon.php:132
JROOT/plugins/system/rokcommon/rokcommon.php:76
JROOT/libraries/cms/plugin/helper.php:255
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:40
[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: 26.30 ms Memoria query: 0.035 MB memoria prima della query: 6.367 MB Righe restituite: 69
```
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 rnek3_menu AS m

  LEFT JOIN rnek3_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 rnek3_menu AS m LEFT JOIN rnek3_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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.92 ms Dopo l'ultima query: 15.16 ms Memoria query: 0.024 MB memoria prima della query: 7.750 MB Righe restituite: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM rnek3_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN non possibile sulla query: SELECT extension_id AS id, element AS "option", params, enabled FROM rnek3_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/sef/sef.php:29
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.78 ms Dopo l'ultima query: 0.34 ms Memoria query: 0.018 MB memoria prima della query: 7.758 MB
```
UPDATE `rnek3_extensions`

  SET `params` = '{\"mediaversion\":\"006aed7d1a23063ec7c8b1f7458fb0d3\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN non possibile sulla query: UPDATE `rnek3_extensions` SET `params` = '{\"mediaversion\":\"006aed7d1a23063ec7c8b1f7458fb0d3\"}' 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/sef/sef.php:29
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.68 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.014 MB memoria prima della query: 8.035 MB Righe restituite: 2
```
SELECT *

  FROM rnek3_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM rnek3_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/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[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.46 ms Memoria query: 0.010 MB memoria prima della query: 8.059 MB Righe restituite: 8
Query duplicate: #24
```
SELECT id, home, template, s.params

  FROM rnek3_template_styles as s

  LEFT JOIN rnek3_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 rnek3_template_styles as s LEFT JOIN rnek3_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/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[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: 9.81 ms Memoria query: 0.024 MB memoria prima della query: 8.864 MB Righe restituite: 1
```
SELECT a.rules

  FROM rnek3_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN non possibile sulla query: SELECT a.rules FROM rnek3_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.16 ms Dopo l'ultima query: 1.01 ms Memoria query: 0.025 MB memoria prima della query: 8.921 MB Righe restituite: 2
```
SELECT b.rules

  FROM rnek3_assets AS a

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

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Explain
EXPLAIN non possibile sulla query: SELECT b.rules FROM rnek3_assets AS a LEFT JOIN rnek3_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.77 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.033 MB memoria prima della query: 8.968 MB Righe restituite: 1
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 rnek3_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM rnek3_categories AS cat JOIN rnek3_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 652 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-23 11:50:34') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-23 11:50:34') 
  AND (a.state = 1 OR a.state =2)
```
Explain
EXPLAIN non possibile sulla query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 rnek3_content AS a LEFT JOIN rnek3_categories AS c on c.id = a.catid LEFT JOIN rnek3_users AS u on u.id = a.created_by LEFT JOIN rnek3_categories as parent ON parent.id = c.parent_id LEFT JOIN rnek3_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM rnek3_categories AS cat JOIN rnek3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE a.id = 652 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-09-23 11:50:34') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-09-23 11:50:34') AND (a.state = 1 OR a.state =2)
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.87 ms Dopo l'ultima query: 2.86 ms Memoria query: 0.027 MB memoria prima della query: 9.194 MB Righe restituite: 3
Query duplicate: #28
```
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 rnek3_categories as c

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

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=27 
  AND badcats.id is null

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

  ORDER BY c.lft
```
Explain
EXPLAIN non possibile sulla query: 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 rnek3_categories as c LEFT JOIN rnek3_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM rnek3_categories AS cat JOIN rnek3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=27 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.94 ms Dopo l'ultima query: 3.86 ms Memoria query: 0.026 MB memoria prima della query: 9.554 MB Righe restituite: 6
```
SELECT `m`.`tag_id`,`t`.*

  FROM `rnek3_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 652 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)
```
Explain
EXPLAIN non possibile sulla query: SELECT `m`.`tag_id`,`t`.* FROM `rnek3_contentitem_tag_map` AS m INNER JOIN `rnek3_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 652 AND `t`.`published` = 1 AND t.access IN (1,1)
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.15 ms Dopo l'ultima query: 12.13 ms Memoria query: 0.028 MB memoria prima della query: 10.600 MB Righe restituite: 30
```
SHOW FULL COLUMNS 
  FROM `rnek3_content`
```
Explain
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `rnek3_content`
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.04 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.026 MB memoria prima della query: 10.802 MB Righe restituite: 1
```
SELECT *

  FROM rnek3_content

  WHERE `id` = '652'
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM rnek3_content WHERE `id` = '652'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 3.33 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.016 MB memoria prima della query: 10.823 MB
```
UPDATE rnek3_content

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

  WHERE `id` = '652'
```
Explain
EXPLAIN non possibile sulla query: UPDATE rnek3_content SET `hits` = (`hits` + 1) WHERE `id` = '652'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 2.08 ms Dopo l'ultima query: 28.16 ms Memoria query: 0.031 MB memoria prima della query: 12.876 MB Righe restituite: 8
Query duplicate: #15
```
SELECT id, home, template, s.params

  FROM rnek3_template_styles as s

  LEFT JOIN rnek3_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 rnek3_template_styles as s LEFT JOIN rnek3_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/gantry/core/gantrytemplate.class.php:638
JROOT/libraries/gantry/core/gantrytemplate.class.php:590
JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:69
JROOT/libraries/gantry/core/params/overrides/gantrymenuitemparamoverride.class.php:36
JROOT/libraries/gantry/core/gantry.class.php:1843
JROOT/libraries/gantry/core/gantry.class.php:392
JROOT/libraries/gantry/gantry.php:275
JROOT/libraries/gantry/gantry.php:432
JROOT/templates/rt_afterburner2_ki/html/com_content/article/default.php:14
JROOT/libraries/legacy/view/legacy.php:670
JROOT/libraries/legacy/view/legacy.php:209
JROOT/components/com_content/views/article/view.html.php:184
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 5.95 ms Dopo l'ultima query: 51.85 ms Memoria query: 0.033 MB memoria prima della query: 14.496 MB Righe restituite: 162
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM rnek3_modules AS m

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

  LEFT JOIN rnek3_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 <= '2023-09-23 11:50:34') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-23 11:50:34') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 288 OR mm.menuid <= 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, mm.menuid FROM rnek3_modules AS m LEFT JOIN rnek3_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN rnek3_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 <= '2023-09-23 11:50:34') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-23 11:50:34') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 288 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/libraries/gantry/core/gantry.class.php:804
JROOT/libraries/gantry/core/gantry.class.php:757
JROOT/templates/rt_afterburner2_ki/index.php:55
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.26 ms Dopo l'ultima query: 12.75 ms Memoria query: 0.024 MB memoria prima della query: 15.378 MB Righe restituite: 0
```
SELECT ts.template

  FROM rnek3_template_styles AS ts

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

  WHERE m.id = 288 
  AND m.template_style_id != 0
```
Explain
EXPLAIN non possibile sulla query: SELECT ts.template FROM rnek3_template_styles AS ts INNER JOIN rnek3_menu AS m ON ts.id=m.template_style_id WHERE m.id = 288 AND m.template_style_id != 0
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:98
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/rt_afterburner2_ki/features/dropdownmenu.php:56
JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
JROOT/libraries/gantry/core/gantry.class.php:867
JROOT/templates/rt_afterburner2_ki/index.php:60
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.99 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.024 MB memoria prima della query: 15.401 MB Righe restituite: 1
```
SELECT template

  FROM rnek3_template_styles

  WHERE home = 1 
  AND client_id = 0
```
Explain
EXPLAIN non possibile sulla query: SELECT template FROM rnek3_template_styles WHERE home = 1 AND client_id = 0
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:113
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:71
JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:22
JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/rt_afterburner2_ki/features/dropdownmenu.php:56
JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
JROOT/libraries/gantry/core/gantry.class.php:867
JROOT/templates/rt_afterburner2_ki/index.php:60
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 3.24 ms Dopo l'ultima query: 43.59 ms Memoria query: 0.030 MB memoria prima della query: 15.665 MB Righe restituite: 3
Query duplicate: #19
```
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 rnek3_categories as c

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

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=27 
  AND badcats.id is null

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

  ORDER BY c.lft
```
Explain
EXPLAIN non possibile sulla query: 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 rnek3_categories as c LEFT JOIN rnek3_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM rnek3_categories AS cat JOIN rnek3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=27 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/modules/mod_articles_categories/helper.php:34
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/module/helper.php:532
JROOT/modules/mod_articles_categories/mod_articles_categories.php:28
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 1.68 ms Dopo l'ultima query: 248.25 ms Memoria query: 0.030 MB memoria prima della query: 24.602 MB Righe restituite: 6
```
SHOW FULL COLUMNS 
  FROM `rnek3_template_styles`
```
Explain
EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `rnek3_template_styles`
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/administrator/components/com_templates/tables/style.php:30
JROOT/libraries/joomla/table/table.php:305
JROOT/plugins/system/gantry/gantry.php:194
JROOT/plugins/system/gantry/gantry.php:165
JROOT/plugins/system/gantry/gantry.php:234
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/joomla/document/html/renderer/head.php:57
JROOT/libraries/joomla/document/html/renderer/head.php:34
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 0.74 ms Dopo l'ultima query: 0.61 ms Memoria query: 0.024 MB memoria prima della query: 24.645 MB Righe restituite: 1
```
SELECT *

  FROM rnek3_template_styles

  WHERE `id` = '16'
```
Explain
EXPLAIN non possibile sulla query: SELECT * FROM rnek3_template_styles WHERE `id` = '16'
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/plugins/system/gantry/gantry.php:168
JROOT/plugins/system/gantry/gantry.php:234
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/joomla/document/html/renderer/head.php:57
JROOT/libraries/joomla/document/html/renderer/head.php:34
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:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]
Tempo della query: 3.83 ms Dopo l'ultima query: 8.48 ms Memoria query: 0.031 MB memoria prima della query: 24.927 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 rnek3_categories as c

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

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

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id=32 
  AND badcats.id is null

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

  ORDER BY c.lft
```
Explain
EXPLAIN non possibile sulla query: 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 rnek3_categories as c LEFT JOIN rnek3_categories AS s ON (s.lft <= c.lft AND s.rgt >= c.rgt) OR (s.lft > c.lft AND s.rgt < c.rgt) LEFT JOIN (SELECT cat.id as id FROM rnek3_categories AS cat JOIN rnek3_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1) AND c.published = 1 AND s.id=32 AND badcats.id is null GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version ORDER BY c.lft
Profilo
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/router.php:145
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:157
JROOT/plugins/system/sef/sef.php:73
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:1065
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:40
[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

26 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × 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 rnek3_categories as c 
  LEFT JOIN rnek3_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM rnek3_categories AS cat JOIN rnek3_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT template 
  FROM rnek3_template_styles as s

2 × SELECT id, home, template, s.params 
  FROM rnek3_template_styles as s 
  LEFT JOIN rnek3_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 rnek3_extensions

```
1 × SELECT * 
  FROM rnek3_content
```

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

1 × SELECT `session_id` 
  FROM `rnek3_session`

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

1 × SELECT ts.template 
  FROM rnek3_template_styles AS ts 
  INNER JOIN rnek3_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT * 
  FROM rnek3_template_styles

1 × SELECT template 
  FROM rnek3_template_styles

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 rnek3_content AS a 
  LEFT JOIN rnek3_categories AS c 
  on c.id = a.catid 
  LEFT JOIN rnek3_users AS u 
  on u.id = a.created_by 
  LEFT JOIN rnek3_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN rnek3_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM rnek3_categories AS cat JOIN rnek3_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.rules 
  FROM rnek3_assets AS a

1 × SELECT extension, file, type 
  FROM rnek3_rokcommon_configs

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

1 × SELECT id, rules 
  FROM `rnek3_viewlevels

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

```
1 × SELECT * 
  FROM rnek3_languages
```

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

1 × SELECT `data` 
  FROM `rnek3_session`

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

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `rnek3_template_styles

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

1 × SHOW FULL COLUMNS 
  FROM `rnek3_content

1 × UPDATE `rnek3_extensions` 
  SET `params` = '{\"mediaversion\":\"006aed7d1a23063ec7c8b1f7458fb0d3\"}'

1 × INSERT INTO `rnek3_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('raonfacpv674t7r3q7gail5bs2', 0, '1695469834'

Italian Film Food Stories

Contatti

Console Debug Joomla!

Sessione

Informazioni profilo