Console de débogage Joomla!

50 requêtes exécutées 42.3 ms

4 doubles découverts!

2 requêtes dupliquées: #10 #40

2 requêtes dupliquées: #22 #24

Temps de requête : 0.49 ms Mémoire de requête : 0.015 MB mémoire avant requête : 2.496 MB Rangées retournées : 0
```
SELECT `data`

  FROM `joom_session`

  WHERE `session_id` = '4f2a5a1bd0i52r5gemruabegu6'
```
Explication
EXPLAIN impossible sur la requête : SELECT `data` FROM `joom_session` WHERE `session_id` = '4f2a5a1bd0i52r5gemruabegu6'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:665
JROOT/libraries/joomla/session/session.php:603
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 2.26 ms Après la dernière requête : 1.56 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.685 MB
```
DELETE 

  FROM `joom_session`

  WHERE `time` < '1714042425'
```
Explication
EXPLAIN impossible sur la requête : DELETE FROM `joom_session` WHERE `time` < '1714042425'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/cms/application/cms.php:756
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.57 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.012 MB mémoire avant requête : 2.697 MB Rangées retournées : 0
```
SELECT `session_id`

  FROM `joom_session`

  WHERE `session_id` = '4f2a5a1bd0i52r5gemruabegu6' 
  LIMIT 0, 1
```
Explication
EXPLAIN impossible sur la requête : SELECT `session_id` FROM `joom_session` WHERE `session_id` = '4f2a5a1bd0i52r5gemruabegu6' LIMIT 0, 1
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 7.14 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.710 MB
```
INSERT INTO `joom_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('4f2a5a1bd0i52r5gemruabegu6', 0, '1714132425')
```
Explication
EXPLAIN impossible sur la requête : INSERT INTO `joom_session` (`session_id`, `client_id`, `time`) VALUES ('4f2a5a1bd0i52r5gemruabegu6', 0, '1714132425')
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.06 ms Après la dernière requête : 2.56 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.076 MB Rangées retournées : 44
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM joom_extensions

  WHERE `type` = 'component'
```
Explication
EXPLAIN impossible sur la requête : SELECT extension_id AS id, element AS "option", params, enabled FROM joom_extensions WHERE `type` = 'component'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.30 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.014 MB mémoire avant requête : 3.247 MB Rangées retournées : 1
```
SELECT b.id

  FROM joom_usergroups AS a

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

  WHERE a.id = 1
```
Explication
EXPLAIN impossible sur la requête : SELECT b.id FROM joom_usergroups AS a LEFT JOIN joom_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.12 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.303 MB Rangées retournées : 12
```
SELECT id, rules

  FROM `joom_viewlevels`
```
Explication
EXPLAIN impossible sur la requête : SELECT id, rules FROM `joom_viewlevels`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.08 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.042 MB mémoire avant requête : 3.325 MB Rangées retournées : 74
```
SELECT folder AS type, element AS name, params

  FROM joom_extensions

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

  ORDER BY ordering
```
Explication
EXPLAIN impossible sur la requête : SELECT folder AS type, element AS name, params FROM joom_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1) ORDER BY ordering
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.45 ms Après la dernière requête : 20.03 ms Mémoire de requête : 0.042 MB mémoire avant requête : 6.015 MB Rangées retournées : 44
```
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 joom_menu AS m

  LEFT JOIN joom_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
```
Explication
EXPLAIN impossible sur la requête : 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 joom_menu AS m LEFT JOIN joom_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
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/application/site.php:438
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/plugins/system/jckmodal/jckmodal.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:654
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.19 ms Après la dernière requête : 2.58 ms Mémoire de requête : 0.026 MB mémoire avant requête : 6.625 MB Rangées retournées : 12
Requêtes dupliquées: #40
```
SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_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
```
Explication
EXPLAIN impossible sur la requête : SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_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
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/plugins/system/jckmodal/jckmodal.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:654
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.73 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.032 MB mémoire avant requête : 6.822 MB Rangées retournées : 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM joom_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explication
EXPLAIN impossible sur la requête : SELECT extension_id AS id, element AS "option", params, enabled FROM joom_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/libraries/cms/html/html.php:701
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/plugins/system/jckmodal/jckmodal.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:654
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 7.07 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.026 MB mémoire avant requête : 6.838 MB
```
UPDATE `joom_extensions`

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

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explication
EXPLAIN impossible sur la requête : UPDATE `joom_extensions` SET `params` = '{\"mediaversion\":\"d9c02b1335f19d577dce287238329e89\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/libraries/cms/html/html.php:701
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/plugins/system/jckmodal/jckmodal.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:654
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.14 ms Après la dernière requête : 9.32 ms Mémoire de requête : 0.025 MB mémoire avant requête : 8.069 MB Rangées retournées : 1
```
SELECT * 
  FROM joom_kunena_configuration 
  WHERE id=1
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_configuration WHERE id=1
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/config.php:1227
JROOT/libraries/kunena/config.php:1174
JROOT/libraries/kunena/factory.php:28
JROOT/libraries/kunena/route/route.php:429
JROOT/libraries/kunena/route/route.php:17
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:275
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.42 ms Après la dernière requête : 5.35 ms Mémoire de requête : 0.018 MB mémoire avant requête : 8.840 MB Rangées retournées : 1
```
SELECT * 
  FROM joom_kunena_aliases 
  WHERE alias LIKE 'les-cellules-audio%'
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_aliases WHERE alias LIKE 'les-cellules-audio%'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/route/route.php:403
JROOT/components/com_kunena/router.php:290
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.12 ms Après la dernière requête : 5.68 ms Mémoire de requête : 0.017 MB mémoire avant requête : 9.671 MB Rangées retournées : 1
```
SELECT a.rules

  FROM joom_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explication
EXPLAIN impossible sur la requête : SELECT a.rules FROM joom_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/plugins/system/jqueryeasy/jqueryeasy.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: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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.77 ms Après la dernière requête : 1.88 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.020 MB Rangées retournées : 8
```
SHOW FULL COLUMNS 
  FROM `joom_assets`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_assets`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/joomla/table/asset.php:61
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/joomla/access/access.php:100
JROOT/libraries/joomla/user/user.php:393
JROOT/plugins/system/jqueryeasy/jqueryeasy.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: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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.15 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.018 MB mémoire avant requête : 10.083 MB Rangées retournées : 1
```
SELECT id

  FROM joom_assets

  WHERE parent_id = 0
```
Explication
EXPLAIN impossible sur la requête : SELECT id FROM joom_assets WHERE parent_id = 0
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/nested.php:1226
JROOT/libraries/joomla/access/access.php:101
JROOT/libraries/joomla/user/user.php:393
JROOT/plugins/system/jqueryeasy/jqueryeasy.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: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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.11 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.018 MB mémoire avant requête : 10.102 MB Rangées retournées : 1
```
SELECT b.rules

  FROM joom_assets AS a

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

  WHERE (a.id = 1)

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

  ORDER BY b.lft
```
Explication
EXPLAIN impossible sur la requête : SELECT b.rules FROM joom_assets AS a LEFT JOIN joom_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.id = 1) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/plugins/system/jqueryeasy/jqueryeasy.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: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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.79 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.015 MB mémoire avant requête : 10.125 MB Rangées retournées : 1
```
SELECT params

  FROM joom_extensions

  WHERE folder ='editors' 
  AND element ='jckeditor'
```
Explication
EXPLAIN impossible sur la requête : SELECT params FROM joom_extensions WHERE folder ='editors' AND element ='jckeditor'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/plugins/system/jcktypography/jcktypography.php:61
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.16 ms Après la dernière requête : 1.78 ms Mémoire de requête : 0.057 MB mémoire avant requête : 10.365 MB Rangées retournées : 71
```
SELECT * 
  FROM joom_kunena_categories 
  ORDER BY ordering, name
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_categories ORDER BY ordering, name
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/category/helper.php:805
JROOT/libraries/kunena/forum/category/helper.php:42
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.14 ms Après la dernière requête : 7.07 ms Mémoire de requête : 0.051 MB mémoire avant requête : 12.155 MB Rangées retournées : 42
```
SHOW FULL COLUMNS 
  FROM `joom_kunena_users`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_kunena_users`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/kunena/tables/kunenausers.php:278
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/kunena/user/user.php:246
JROOT/libraries/kunena/user/user.php:269
JROOT/libraries/kunena/user/user.php:92
JROOT/libraries/kunena/user/helper.php:46
JROOT/libraries/kunena/user/helper.php:13
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/libraries/kunena/access.php:103
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.13 ms Après la dernière requête : 0.81 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.327 MB Rangées retournées : 2
Requêtes dupliquées: #24
```
SELECT b.rules

  FROM joom_assets AS a

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

  WHERE (a.name = 'com_kunena')

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

  ORDER BY b.lft
```
Explication
EXPLAIN impossible sur la requête : SELECT b.rules FROM joom_assets AS a LEFT JOIN joom_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_kunena') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/access/access.php:246
JROOT/plugins/kunena/joomla/access.php:454
JROOT/plugins/kunena/joomla/access.php:229
JROOT/libraries/kunena/access.php:111
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.12 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.369 MB Rangées retournées : 3
```
SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (8,15,12)
```
Explication
EXPLAIN impossible sur la requête : SELECT DISTINCT(user_id) FROM joom_usergroups as ug1 INNER JOIN joom_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN joom_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id IN (8,15,12)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/plugins/kunena/joomla/access.php:435
JROOT/plugins/kunena/joomla/access.php:485
JROOT/plugins/kunena/joomla/access.php:229
JROOT/libraries/kunena/access.php:111
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.11 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.396 MB Rangées retournées : 2
Requêtes dupliquées: #22
```
SELECT b.rules

  FROM joom_assets AS a

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

  WHERE (a.name = 'com_kunena')

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

  ORDER BY b.lft
```
Explication
EXPLAIN impossible sur la requête : SELECT b.rules FROM joom_assets AS a LEFT JOIN joom_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_kunena') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/access/access.php:246
JROOT/plugins/kunena/joomla/access.php:454
JROOT/plugins/kunena/joomla/access.php:229
JROOT/libraries/kunena/access.php:111
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.12 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.438 MB Rangées retournées : 2
```
SELECT DISTINCT(user_id)

  FROM joom_usergroups as ug1

  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt

  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

  WHERE ug1.id IN (15,12)
```
Explication
EXPLAIN impossible sur la requête : SELECT DISTINCT(user_id) FROM joom_usergroups as ug1 INNER JOIN joom_usergroups AS ug2 ON ug2.lft>=ug1.lft AND ug1.rgt>=ug2.rgt INNER JOIN joom_user_usergroup_map AS m ON ug2.id=m.group_id WHERE ug1.id IN (15,12)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/plugins/kunena/joomla/access.php:435
JROOT/plugins/kunena/joomla/access.php:485
JROOT/plugins/kunena/joomla/access.php:229
JROOT/libraries/kunena/access.php:111
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.10 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.034 MB mémoire avant requête : 12.461 MB Rangées retournées : 55
```
SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories 
  WHERE role IN (1,2)
```
Explication
EXPLAIN impossible sur la requête : SELECT user_id, category_id, role FROM joom_kunena_user_categories WHERE role IN (1,2)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/access.php:119
JROOT/libraries/kunena/access.php:75
JROOT/libraries/kunena/access.php:87
JROOT/libraries/kunena/forum/category/helper.php:50
JROOT/libraries/kunena/forum/category/helper.php:892
JROOT/libraries/loader.php:601
JROOT/libraries/loader.php:568
JROOT/components/com_kunena/router.php:107
JROOT/libraries/cms/component/router/legacy.php:68
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:46
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.11 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.014 MB mémoire avant requête : 12.559 MB Rangées retournées : 2
```
SELECT *

  FROM joom_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_languages WHERE published=1 ORDER BY ordering ASC
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.61 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.872 MB Rangées retournées : 5
```
SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_kunena_sessions`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/kunena/tables/kunenasessions.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/kunena/session.php:85
JROOT/libraries/kunena/session.php:99
JROOT/libraries/kunena/session.php:25
JROOT/libraries/kunena/session.php:49
JROOT/libraries/kunena/factory.php:96
JROOT/components/com_kunena/kunena.php:61
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.08 ms Après la dernière requête : 21.21 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.792 MB Rangées retournées : 1
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM joom_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-26 11:53:45') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 11:53:45') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 160 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
```
Explication
EXPLAIN impossible sur la requête : SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM joom_modules AS m LEFT JOIN joom_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN joom_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-26 11:53:45') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-26 11:53:45') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 160 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/kunena/view.php:286
JROOT/components/com_kunena/views/common/view.html.php:476
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/views/common/view.html.php:34
JROOT/libraries/kunena/view.php:524
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:17
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.60 ms Après la dernière requête : 3.96 ms Mémoire de requête : 0.025 MB mémoire avant requête : 16.088 MB Rangées retournées : 1
```
SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (31)
```
Explication
EXPLAIN impossible sur la requête : SELECT COUNT(*) FROM joom_kunena_topics AS tt WHERE tt.hold IN (0) AND tt.category_id IN (31)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/helper.php:291
JROOT/components/com_kunena/models/category.php:275
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 2.14 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.036 MB mémoire avant requête : 16.113 MB Rangées retournées : 20
```
SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
				
  FROM joom_kunena_topics AS tt
				
  LEFT JOIN joom_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'
				
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (31)    
  ORDER BY tt.ordering DESC, tt.last_post_time DESC 
  LIMIT 20, 20
```
Explication
EXPLAIN impossible sur la requête : SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread FROM joom_kunena_topics AS tt LEFT JOIN joom_kunena_user_topics AS ut ON tt.id=ut.topic_id AND ut.user_id='0' WHERE tt.hold IN (0) AND tt.category_id IN (31) ORDER BY tt.ordering DESC, tt.last_post_time DESC LIMIT 20, 20
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/helper.php:322
JROOT/components/com_kunena/models/category.php:275
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.90 ms Après la dernière requête : 2.23 ms Mémoire de requête : 0.044 MB mémoire avant requête : 16.627 MB Rangées retournées : 20
```
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
				
  FROM joom_users AS u
				
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
				
  WHERE u.id IN (670,637,1146,649,1062,1039,1057,646,954,672,578,911,669,663,647,654,652,640,653,642,737)
```
Explication
EXPLAIN impossible sur la requête : SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid WHERE u.id IN (670,637,1146,649,1062,1039,1057,646,954,672,578,911,669,663,647,654,652,640,653,642,737)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/user/helper.php:182
JROOT/components/com_kunena/models/category.php:293
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.47 ms Après la dernière requête : 1.27 ms Mémoire de requête : 0.030 MB mémoire avant requête : 16.921 MB Rangées retournées : 0
```
SELECT * 
  FROM joom_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (2393,2357,2275,2137,2200,2164,1780,1940,1987,1978,1939,1873,1675,1664,1590,1527,1505,1459,1457,1440)
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_user_topics WHERE user_id='0' AND topic_id IN (2393,2357,2275,2137,2200,2164,1780,1940,1987,1978,1939,1873,1675,1664,1590,1527,1505,1459,1457,1440)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/user/helper.php:344
JROOT/libraries/kunena/forum/topic/user/helper.php:86
JROOT/libraries/kunena/forum/topic/helper.php:168
JROOT/components/com_kunena/models/category.php:296
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.74 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.038 MB mémoire avant requête : 17.023 MB Rangées retournées : 9
```
SHOW FULL COLUMNS 
  FROM `joom_kunena_user_topics`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_kunena_user_topics`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/kunena/tables/kunenausertopics.php:33
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/kunena/forum/topic/user/user.php:112
JROOT/libraries/kunena/forum/topic/user/user.php:45
JROOT/libraries/kunena/forum/topic/user/helper.php:358
JROOT/libraries/kunena/forum/topic/user/helper.php:86
JROOT/libraries/kunena/forum/topic/helper.php:168
JROOT/components/com_kunena/models/category.php:296
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.46 ms Après la dernière requête : 2.59 ms Mémoire de requête : 0.029 MB mémoire avant requête : 17.164 MB Rangées retournées : 0
```
SELECT * 
  FROM joom_kunena_keywords_map AS m 
  INNER JOIN joom_kunena_keywords AS k 
  ON m.keyword_id=k.id 
  WHERE m.topic_id IN (2393,2357,2275,2137,2200,2164,1780,1940,1987,1978,1939,1873,1675,1664,1590,1527,1505,1459,1457,1440) 
  AND m.user_id IN (0,0)
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_keywords_map AS m INNER JOIN joom_kunena_keywords AS k ON m.keyword_id=k.id WHERE m.topic_id IN (2393,2357,2275,2137,2200,2164,1780,1940,1987,1978,1939,1873,1675,1664,1590,1527,1505,1459,1457,1440) AND m.user_id IN (0,0)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/keyword/helper.php:267
JROOT/libraries/kunena/keyword/helper.php:150
JROOT/libraries/kunena/forum/topic/helper.php:184
JROOT/components/com_kunena/models/category.php:297
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/category/view.html.php:31
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.19 ms Après la dernière requête : 11.78 ms Mémoire de requête : 0.036 MB mémoire avant requête : 19.179 MB Rangées retournées : 60
```
SELECT code, location 
  FROM joom_kunena_smileys
```
Explication
EXPLAIN impossible sur la requête : SELECT code, location FROM joom_kunena_smileys
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/bbcode/bbcode.php:1002
JROOT/libraries/kunena/bbcode/bbcode.php:42
JROOT/libraries/kunena/bbcode/bbcode.php:75
JROOT/libraries/kunena/html/parser.php:130
JROOT/components/com_kunena/template/blue_eagle/html/category/default_row.php:50
JROOT/libraries/kunena/view.php:706
JROOT/components/com_kunena/views/category/view.html.php:523
JROOT/components/com_kunena/template/blue_eagle/html/category/default.php:62
JROOT/libraries/legacy/view/legacy.php:670
JROOT/libraries/legacy/view/legacy.php:209
JROOT/libraries/kunena/view.php:265
JROOT/components/com_kunena/views/category/view.html.php:55
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.56 ms Après la dernière requête : 26.28 ms Mémoire de requête : 0.044 MB mémoire avant requête : 19.382 MB Rangées retournées : 0
```
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
			
  FROM joom_users AS u
			
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
			
  WHERE u.id = 654
```
Explication
EXPLAIN impossible sur la requête : SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid WHERE u.id = 654
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/tables/kunenausers.php:308
JROOT/libraries/kunena/user/user.php:274
JROOT/libraries/kunena/user/user.php:92
JROOT/libraries/kunena/user/helper.php:101
JROOT/libraries/kunena/user/helper.php:132
JROOT/libraries/kunena/forum/topic/topic.php:456
JROOT/components/com_kunena/views/category/view.html.php:498
JROOT/components/com_kunena/template/blue_eagle/html/category/default.php:62
JROOT/libraries/legacy/view/legacy.php:670
JROOT/libraries/legacy/view/legacy.php:209
JROOT/libraries/kunena/view.php:265
JROOT/components/com_kunena/views/category/view.html.php:55
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.20 ms Après la dernière requête : 19.79 ms Mémoire de requête : 0.049 MB mémoire avant requête : 19.610 MB Rangées retournées : 34
```
SHOW FULL COLUMNS 
  FROM `joom_kunena_categories`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_kunena_categories`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/kunena/tables/kunenacategories.php:58
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/kunena/database/object.php:282
JROOT/libraries/kunena/database/object.php:100
JROOT/libraries/kunena/forum/category/category.php:1012
JROOT/libraries/kunena/forum/category/helper.php:87
JROOT/libraries/kunena/html/html/kunenaforum.php:51
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/components/com_kunena/views/common/view.html.php:134
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/views/common/view.html.php:34
JROOT/libraries/kunena/view.php:543
JROOT/components/com_kunena/template/blue_eagle/html/category/default.php:101
JROOT/libraries/legacy/view/legacy.php:670
JROOT/libraries/legacy/view/legacy.php:209
JROOT/libraries/kunena/view.php:265
JROOT/components/com_kunena/views/category/view.html.php:55
JROOT/libraries/kunena/view.php:195
JROOT/components/com_kunena/template/jf_business_ku_3/html/display.php:21
JROOT/libraries/kunena/view.php:116
JROOT/libraries/kunena/controller.php:398
JROOT/libraries/kunena/controller.php:157
JROOT/libraries/kunena/controller.php:215
JROOT/components/com_kunena/kunena.php:104
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.23 ms Après la dernière requête : 12.58 ms Mémoire de requête : 0.020 MB mémoire avant requête : 21.187 MB Rangées retournées : 12
```
SELECT id, home, template, params

  FROM joom_template_styles

  WHERE client_id = 0
```
Explication
EXPLAIN impossible sur la requête : SELECT id, home, template, params FROM joom_template_styles WHERE client_id = 0
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/gantry/gantry.php:148
JROOT/libraries/gantry/gantry.php:125
JROOT/libraries/gantry/gantry.php:206
JROOT/libraries/gantry/gantry.php:264
JROOT/libraries/gantry/gantry.php:432
JROOT/templates/jf_corporate/lib/gantry/gantry.php:21
JROOT/templates/jf_corporate/index.php:13
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.96 ms Après la dernière requête : 8.36 ms Mémoire de requête : 0.025 MB mémoire avant requête : 22.551 MB Rangées retournées : 12
Requêtes dupliquées: #10
```
SELECT id, home, template, s.params

  FROM joom_template_styles as s

  LEFT JOIN joom_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
```
Explication
EXPLAIN impossible sur la requête : SELECT id, home, template, s.params FROM joom_template_styles as s LEFT JOIN joom_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
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/jf_corporate/lib/gantry/gantry.php:21
JROOT/templates/jf_corporate/index.php:13
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.28 ms Après la dernière requête : 33.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 24.360 MB Rangées retournées : 0
```
SELECT ts.template

  FROM joom_template_styles AS ts

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

  WHERE m.id = 160 
  AND m.template_style_id != 0
```
Explication
EXPLAIN impossible sur la requête : SELECT ts.template FROM joom_template_styles AS ts INNER JOIN joom_menu AS m ON ts.id=m.template_style_id WHERE m.id = 160 AND m.template_style_id != 0
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/jf_corporate/features/dropdownmenu.php:56
JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65
JROOT/libraries/gantry/core/gantry.class.php:867
JROOT/templates/jf_corporate/index.php:68
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.13 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.025 MB mémoire avant requête : 24.383 MB Rangées retournées : 1
```
SELECT template

  FROM joom_template_styles

  WHERE home = 1 
  AND client_id = 0
```
Explication
EXPLAIN impossible sur la requête : SELECT template FROM joom_template_styles WHERE home = 1 AND client_id = 0
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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/jf_corporate/features/dropdownmenu.php:56
JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:65
JROOT/libraries/gantry/core/gantry.class.php:867
JROOT/templates/jf_corporate/index.php:68
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.22 ms Après la dernière requête : 12.23 ms Mémoire de requête : 0.017 MB mémoire avant requête : 24.774 MB Rangées retournées : 2
```
SELECT b.rules

  FROM joom_assets AS a

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

  WHERE (a.name = 'com_menus')

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

  ORDER BY b.lft
```
Explication
EXPLAIN impossible sur la requête : SELECT b.rules FROM joom_assets AS a LEFT JOIN joom_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_menus') GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/libraries/joomla/document/html/renderer/modules.php:39
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.99 ms Après la dernière requête : 4.56 ms Mémoire de requête : 0.029 MB mémoire avant requête : 25.279 MB Rangées retournées : 1
```
SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt 
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (36,41,35,30,45,25,11,6,12,5,13,24,31,37,26,40,46,7,42,43,15,64,44,32,27,29,14,18,66,20,71,72,21,68,22,16,17,19,69,23)   
  AND tt.last_post_time>'1682596425'  
  AND tt.moved_id='0'
```
Explication
EXPLAIN impossible sur la requête : SELECT COUNT(*) FROM joom_kunena_topics AS tt WHERE tt.hold IN (0) AND tt.category_id IN (36,41,35,30,45,25,11,6,12,5,13,24,31,37,26,40,46,7,42,43,15,64,44,32,27,29,14,18,66,20,71,72,21,68,22,16,17,19,69,23) AND tt.last_post_time>'1682596425' AND tt.moved_id='0'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/helper.php:291
JROOT/components/com_kunena/models/topics.php:302
JROOT/components/com_kunena/models/topics.php:213
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/topics/view.html.php:24
JROOT/libraries/kunena/view.php:195
JROOT/libraries/kunena/forum/forum.php:394
JROOT/modules/mod_kunenalatest/class.php:92
JROOT/libraries/kunena/module/module.php:81
JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:29
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 1.02 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.038 MB mémoire avant requête : 25.308 MB Rangées retournées : 12
```
SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
				
  FROM joom_kunena_topics AS tt
				
  LEFT JOIN joom_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'
				
  WHERE tt.hold IN (0) 
  AND tt.category_id IN (36,41,35,30,45,25,11,6,12,5,13,24,31,37,26,40,46,7,42,43,15,64,44,32,27,29,14,18,66,20,71,72,21,68,22,16,17,19,69,23)   
  AND tt.last_post_time>'1682596425'  
  AND tt.moved_id='0' 
  ORDER BY tt.last_post_time DESC 
  LIMIT 0, 12
```
Explication
EXPLAIN impossible sur la requête : SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread FROM joom_kunena_topics AS tt LEFT JOIN joom_kunena_user_topics AS ut ON tt.id=ut.topic_id AND ut.user_id='0' WHERE tt.hold IN (0) AND tt.category_id IN (36,41,35,30,45,25,11,6,12,5,13,24,31,37,26,40,46,7,42,43,15,64,44,32,27,29,14,18,66,20,71,72,21,68,22,16,17,19,69,23) AND tt.last_post_time>'1682596425' AND tt.moved_id='0' ORDER BY tt.last_post_time DESC LIMIT 0, 12
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/helper.php:322
JROOT/components/com_kunena/models/topics.php:302
JROOT/components/com_kunena/models/topics.php:213
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/topics/view.html.php:24
JROOT/libraries/kunena/view.php:195
JROOT/libraries/kunena/forum/forum.php:394
JROOT/modules/mod_kunenalatest/class.php:92
JROOT/libraries/kunena/module/module.php:81
JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:29
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.47 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.041 MB mémoire avant requête : 25.441 MB Rangées retournées : 2
```
SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
				
  FROM joom_users AS u
				
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid
				
  WHERE u.id IN (1221,1428)
```
Explication
EXPLAIN impossible sur la requête : SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM joom_users AS u LEFT JOIN joom_kunena_users AS ku ON u.id = ku.userid WHERE u.id IN (1221,1428)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/user/helper.php:182
JROOT/components/com_kunena/models/topics.php:425
JROOT/components/com_kunena/models/topics.php:304
JROOT/components/com_kunena/models/topics.php:213
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/topics/view.html.php:24
JROOT/libraries/kunena/view.php:195
JROOT/libraries/kunena/forum/forum.php:394
JROOT/modules/mod_kunenalatest/class.php:92
JROOT/libraries/kunena/module/module.php:81
JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:29
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.11 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.034 MB mémoire avant requête : 25.494 MB Rangées retournées : 0
```
SELECT * 
  FROM joom_kunena_user_topics 
  WHERE user_id='0' 
  AND topic_id IN (2842,2837,2828,2814,2797,2826,2784,2783,2781,855,2824,2820)
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_user_topics WHERE user_id='0' AND topic_id IN (2842,2837,2828,2814,2797,2826,2784,2783,2781,855,2824,2820)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/forum/topic/user/helper.php:344
JROOT/libraries/kunena/forum/topic/user/helper.php:86
JROOT/libraries/kunena/forum/topic/helper.php:168
JROOT/components/com_kunena/models/topics.php:428
JROOT/components/com_kunena/models/topics.php:304
JROOT/components/com_kunena/models/topics.php:213
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/topics/view.html.php:24
JROOT/libraries/kunena/view.php:195
JROOT/libraries/kunena/forum/forum.php:394
JROOT/modules/mod_kunenalatest/class.php:92
JROOT/libraries/kunena/module/module.php:81
JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:29
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.12 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.034 MB mémoire avant requête : 25.555 MB Rangées retournées : 0
```
SELECT * 
  FROM joom_kunena_keywords_map AS m 
  INNER JOIN joom_kunena_keywords AS k 
  ON m.keyword_id=k.id 
  WHERE m.topic_id IN (2842,2837,2828,2814,2797,2826,2784,2783,2781,855,2824,2820) 
  AND m.user_id IN (0,0)
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_kunena_keywords_map AS m INNER JOIN joom_kunena_keywords AS k ON m.keyword_id=k.id WHERE m.topic_id IN (2842,2837,2828,2814,2797,2826,2784,2783,2781,855,2824,2820) AND m.user_id IN (0,0)
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
JROOT/libraries/kunena/keyword/helper.php:267
JROOT/libraries/kunena/keyword/helper.php:150
JROOT/libraries/kunena/forum/topic/helper.php:184
JROOT/components/com_kunena/models/topics.php:429
JROOT/components/com_kunena/models/topics.php:304
JROOT/components/com_kunena/models/topics.php:213
JROOT/libraries/legacy/view/legacy.php:401
JROOT/libraries/kunena/view.php:335
JROOT/components/com_kunena/views/topics/view.html.php:24
JROOT/libraries/kunena/view.php:195
JROOT/libraries/kunena/forum/forum.php:394
JROOT/modules/mod_kunenalatest/class.php:92
JROOT/libraries/kunena/module/module.php:81
JROOT/modules/mod_kunenalatest/mod_kunenalatest.php:29
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
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.76 ms Après la dernière requête : 18.12 ms Mémoire de requête : 0.030 MB mémoire avant requête : 26.107 MB Rangées retournées : 6
```
SHOW FULL COLUMNS 
  FROM `joom_template_styles`
```
Explication
EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `joom_template_styles`
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]
Temps de requête : 0.11 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 26.150 MB Rangées retournées : 1
```
SELECT *

  FROM joom_template_styles

  WHERE `id` = '12'
```
Explication
EXPLAIN impossible sur la requête : SELECT * FROM joom_template_styles WHERE `id` = '12'
Profil
No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)
Pile d'appels
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:45
[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

39 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

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

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

2 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid
     
  FROM joom_users AS u
     
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid

2 × SELECT * 
  FROM joom_kunena_keywords_map AS m 
  INNER JOIN joom_kunena_keywords AS k 
  ON m.keyword_id=k.id

2 × SELECT tt.*, ut.posts AS myposts, ut.last_post_id AS my_last_post_id, ut.favorite, tt.last_post_id AS lastread, 0 AS unread
     
  FROM joom_kunena_topics AS tt
     
  LEFT JOIN joom_kunena_user_topics AS ut 
  ON tt.id=ut.topic_id 
  AND ut.user_id='0'

2 × SELECT COUNT(*) 
  FROM joom_kunena_topics AS tt

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

2 × SELECT DISTINCT(user_id) 
  FROM joom_usergroups as ug1 
  INNER JOIN joom_usergroups AS ug2 
  ON ug2.lft>=ug1.lft 
  AND ug1.rgt>=ug2.rgt 
  INNER JOIN joom_user_usergroup_map AS m 
  ON ug2.id=m.group_id

2 × SELECT * 
  FROM joom_kunena_user_topics

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

1 × SELECT code, location 
  FROM joom_kunena_smiley

1 × SELECT template 
  FROM joom_template_styles

1 × SELECT * 
  FROM joom_template_styles

1 × SELECT ts.template 
  FROM joom_template_styles AS ts 
  INNER JOIN joom_menu AS m 
  ON ts.id=m.template_style_id

1 × SELECT id, home, template, params 
  FROM joom_template_styles

1 × SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.*
    
  FROM joom_users AS u
    
  LEFT JOIN joom_kunena_users AS ku 
  ON u.id = ku.userid

```
1 × SELECT * 
  FROM joom_languages
```

1 × SELECT * 
  FROM joom_kunena_categories

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

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

1 × SELECT id, rules 
  FROM `joom_viewlevels

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

1 × SELECT `session_id` 
  FROM `joom_session`

1 × SELECT * 
  FROM joom_kunena_configuration

1 × SELECT * 
  FROM joom_kunena_aliases

1 × SELECT `data` 
  FROM `joom_session`

1 × SELECT params 
  FROM joom_extensions

```
1 × SELECT id 
  FROM joom_assets
```

1 × SELECT a.rules 
  FROM joom_assets AS a

1 × SELECT user_id, category_id, role 
  FROM joom_kunena_user_categories

Autres tables :

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_user_topics

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_categories

1 × SHOW FULL COLUMNS 
  FROM `joom_template_styles

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_sessions

1 × SHOW FULL COLUMNS 
  FROM `joom_kunena_users

1 × INSERT INTO `joom_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('4f2a5a1bd0i52r5gemruabegu6', 0, '1714132425'

1 × UPDATE `joom_extensions` 
  SET `params` = '{\"mediaversion\":\"d9c02b1335f19d577dce287238329e89\"}'

1 × SHOW FULL COLUMNS 
  FROM `joom_assets

```
1 × DELETE  
  FROM `joom_session`
```

11 Réponses	Petite contrariété... Sujet démarré le 17 Avr 2021 11:30 par conrad29	1966 Vues	Dernier message par Le bleu 20 Avr 2021 10:31
14 Réponses	Cellule Ronette Mono à passer en Stéréo Sujet démarré le 03 Fév 2021 19:37 par StefCas	2997 Vues	Dernier message par Le bleu 24 Fév 2021 18:38
9 Réponses	Incursion dans l'exotique Sujet démarré le 19 Sep 2020 19:15 par ThierryN	2191 Vues	Dernier message par ThierryN 01 Nov 2020 10:35
10 Réponses	Avis cellules audio Sujet démarré le 03 Avr 2020 16:23 par luc	2167 Vues	Dernier message par Analog Addict 03 Oct 2020 20:02
7 Réponses	Je me demandais... Tip ou pas retip Sujet démarré le 27 Mai 2020 14:55 par Time window	2063 Vues	Dernier message par vincent 01 Jui 2020 00:56
5 Réponses	Cellule mystère Sujet démarré le 27 Avr 2020 20:59 par sylvain	1713 Vues	Dernier message par Analog Addict 28 Avr 2020 13:59
11 Réponses	Ou faire réparer ma cellule ORTOFON 2M RED ? Sujet démarré le 27 Fév 2019 11:48 par JPR_Project	2491 Vues	Dernier message par JPR_Project 21 Nov 2019 21:04
12 Réponses	DECCA London Sujet démarré le 26 Sep 2019 10:30 par ThierryN	1851 Vues	Dernier message par Analog Addict 10 Nov 2019 09:01
1 Réponses	Pickering U38 AT Sujet démarré le 06 Nov 2019 16:56 par User578	1390 Vues	Dernier message par Ramutch 06 Nov 2019 22:15
11 Réponses	Stylet pour Shure V15 III Sujet démarré le 28 Oct 2019 12:17 par sylvain	1695 Vues	Dernier message par GUEPARDAPHY 30 Oct 2019 15:12
5 Réponses	Porte cellule ORTOFON et logo... Sujet démarré le 25 Sep 2019 17:06 par Le bleu	1554 Vues	Dernier message par Le bleu 27 Sep 2019 08:35
5 Réponses	Shure M95 .... Shure ... mais laquelle ? Sujet démarré le 22 Juil 2019 23:34 par User578	2053 Vues	Dernier message par Analog Addict 23 Juil 2019 01:14
8 Réponses	Préampli pour Clément Sujet démarré le 22 Nov 2018 13:16 par Jotarra	1972 Vues	Dernier message par ThierryN 28 Nov 2018 19:49
18 Réponses	Produit pour nettoyer le stylet Sujet démarré le 16 Nov 2018 18:28 par mulanee Page : 1 2	3915 Vues	Dernier message par vincent 26 Nov 2018 22:41
12 Réponses	Cellule MC Haut Niveau Sujet démarré le 07 Sep 2018 19:41 par pm56	2649 Vues	Dernier message par papamano 19 Sep 2018 13:53
24 Réponses	Cellule Mono ? ??? Sujet démarré le 01 Juil 2018 21:54 par vincent Page : 1 2	3844 Vues	Dernier message par ThierryN 04 Juil 2018 23:55
9 Réponses	Cellule Pickering - Stanton FLUXVALVE 350-370 Sujet démarré le 07 Jui 2018 10:42 par Le bleu	2524 Vues	Dernier message par Le bleu 09 Jui 2018 16:19
4 Réponses	Ortofon Rondo blue Sujet démarré le 02 Mai 2018 09:42 par balooh	1703 Vues	Dernier message par bushi 02 Mai 2018 20:21
3 Réponses	end of Shure ! Sujet démarré le 01 Mai 2018 19:27 par JGN	1489 Vues	Dernier message par E.P 02 Mai 2018 11:16
18 Réponses	Decca Deram Sujet démarré le 14 Avr 2018 11:59 par User578 Page : 1 2	3858 Vues	Dernier message par User578 17 Avr 2018 19:28

Sujet de la catégorie: Les cellules audio

Messages non lus

Console de débogage Joomla!

Session

__default

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

50 requêtes exécutées 42.3 ms

4 doubles découverts!

39 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

Autres tables :