Console de débogage Joomla! Session { "__default": { "session": { "counter": 1, "token": "SgIASBtEWlhaXXYOhWvBSHTFne6jyyzo" }, "registry": { "com_jdbuilder": { "edit": { "page": { "id": "1" } } }, "users": { "login": { "form": { "data": { "return": "http:\/\/romanerie.fr\/vessigaud\/" } } } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "plg_system_languagefilter": { "language": "fr-FR" }, "jdstarttime": "2021-04-25 01:03:39" } } Profil d'information Temps Mémoire Temps: 21.58 ms / 21.58 ms Mémoire: 1.835 MB / 2.21 MB Application: afterLoad Temps: 115.85 ms / 137.43 ms Mémoire: 6.766 MB / 8.98 MB Application: afterInitialise Temps: 60.19 ms / 197.62 ms Mémoire: 3.870 MB / 12.85 MB Application: afterRoute Temps: 0.65 ms / 198.27 ms Mémoire: 0.014 MB / 12.86 MB Application: beforeRenderComponent com_jdbuilder Temps: 3.82 ms / 202.09 ms Mémoire: 0.298 MB / 13.16 MB Application: Before Access::preloadComponents (all components) Temps: 2.37 ms / 204.47 ms Mémoire: 0.062 MB / 13.22 MB Application: After Access::preloadComponents (all components) Temps: 0.06 ms / 204.53 ms Mémoire: -0.003 MB / 13.22 MB Application: Before Access::getAssetRules (id:74 name:com_jdbuilder) Temps: 0.76 ms / 205.29 ms Mémoire: 0.027 MB / 13.25 MB Application: After Access::getAssetRules (id:74 name:com_jdbuilder) Temps: 8.26 ms / 213.55 ms Mémoire: 0.125 MB / 13.37 MB Application: Before Access::preloadPermissions (com_jdbuilder) Temps: 1.55 ms / 215.09 ms Mémoire: 0.026 MB / 13.40 MB Application: After Access::preloadPermissions (com_jdbuilder) Temps: 0.04 ms / 215.13 ms Mémoire: -0.000 MB / 13.40 MB Application: Before Access::getAssetRules (id:78 name:com_jdbuilder.page.1) Temps: 0.03 ms / 215.17 ms Mémoire: 0.002 MB / 13.40 MB Application: After Access::getAssetRules (id:78 name:com_jdbuilder.page.1) Temps: 0.55 ms / 215.71 ms Mémoire: 0.003 MB / 13.40 MB Application: Before Access::getAssetRules (id:78 name:com_jdbuilder.page.1) Temps: 0.02 ms / 215.74 ms Mémoire: 0.001 MB / 13.40 MB Application: After Access::getAssetRules (id:78 name:com_jdbuilder.page.1) Temps: 99.59 ms / 315.33 ms Mémoire: 5.753 MB / 19.16 MB Application: afterRenderComponent com_jdbuilder Temps: 17.23 ms / 332.56 ms Mémoire: 0.560 MB / 19.72 MB Application: afterDispatch Temps: 0.09 ms / 332.65 ms Mémoire: 0.001 MB / 19.72 MB Application: Before Access::getAssetRules (id:1 name:root.1) Temps: 0.03 ms / 332.69 ms Mémoire: 0.003 MB / 19.72 MB Application: After Access::getAssetRules (id:1 name:root.1) Temps: 15.22 ms / 347.90 ms Mémoire: 0.653 MB / 20.37 MB Application: afterRender Total de requêtes base de données : 61.51 ms Occupation de la mémoire 20,96 MB (21 974 216 Bytes) Requêtes de base de données 35 requêtes exécutées 61.51 ms 6 doubles découverts! 2 requêtes dupliquées: #1 #6 2 requêtes dupliquées: #5 #7 2 requêtes dupliquées: #8 #10 Temps de requête : 1.36 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.887 MB Rangées retournées : 1 Requêtes dupliquées: #6 SELECT `data` FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL Impossible WHERE noticed after reading const tables Profil Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.62 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.04 ms optimizing 0.04 ms statistics 0.09 ms preparing 0.02 ms Unlocking tables 0.04 ms executing 0.02 ms Sending data 0.03 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 14 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 13 session_start() JROOT/libraries/joomla/session/handler/native.php:260 12 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 11 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 10 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.59 ms Après la dernière requête : 3.61 ms Mémoire de requête : 0.009 MB mémoire avant requête : 4.272 MB Rangées retournées : 16 SHOW FULL COLUMNS FROM `josiv_users` Explication EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `josiv_users` Profil Status Duration starting 0.08 ms checking permissions 0.02 ms closing tables 0.03 ms Opening tables 0.55 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.53 ms After opening tables 0.03 ms checking permissions 0.09 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms closing tables 0.03 ms executing 0.02 ms Sending data 0.09 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms removing tmp table 0.17 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.03 ms Pile d'appels # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 15 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 13 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 12 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:943 11 Joomla\CMS\User\User->__wakeup() Même appel que celui de la ligne ci-dessous. 10 unserialize() JROOT/libraries/src/Session/Session.php:670 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.78 ms Après la dernière requête : 0.82 ms Mémoire de requête : 0.007 MB mémoire avant requête : 4.320 MB Rangées retournées : 1 SELECT * FROM `josiv_users` WHERE `id` = 652 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_users const PRIMARY PRIMARY 4 const 1 Profil Status Duration starting 0.10 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.04 ms optimizing 0.03 ms statistics 0.09 ms preparing 0.03 ms Unlocking tables 0.04 ms executing 0.02 ms Sending data 0.03 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 13 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 12 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:943 11 Joomla\CMS\User\User->__wakeup() Même appel que celui de la ligne ci-dessous. 10 unserialize() JROOT/libraries/src/Session/Session.php:670 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.94 ms Après la dernière requête : 4.06 ms Mémoire de requête : 0.007 MB mémoire avant requête : 5.072 MB Rangées retournées : 1 SELECT `g`.`id`,`g`.`title` FROM `josiv_usergroups` AS g INNER JOIN `josiv_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 652 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 romayepk_vess616.m.group_id 1 Profil Status Duration starting 0.11 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 1.01 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.06 ms optimizing 0.06 ms statistics 0.09 ms preparing 0.06 ms executing 0.02 ms Sending data 0.10 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.04 ms freeing items 0.04 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 14 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 13 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 12 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:943 11 Joomla\CMS\User\User->__wakeup() Même appel que celui de la ligne ci-dessous. 10 unserialize() JROOT/libraries/src/Session/Session.php:670 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.81 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.078 MB Requêtes dupliquées: #7 DELETE FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Explication EXPLAIN impossible sur la requête : DELETE FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Profil Status Duration starting 0.06 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms init 0.07 ms updating 0.39 ms end 0.03 ms Waiting for query cache lock 0.02 ms end 0.02 ms query end 1.86 ms closing tables 0.03 ms Unlocking tables 0.04 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:122 14 JSessionStorageDatabase->destroy() Même appel que celui de la ligne ci-dessous. 13 session_destroy() JROOT/libraries/joomla/session/handler/native.php:214 12 JSessionHandlerNative->clear() JROOT/libraries/joomla/session/handler/joomla.php:115 11 JSessionHandlerJoomla->clear() JROOT/libraries/src/Session/Session.php:733 10 Joomla\CMS\Session\Session->destroy() JROOT/libraries/src/Session/Session.php:753 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.67 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.008 MB mémoire avant requête : 5.076 MB Rangées retournées : 0 Requêtes dupliquées: #1 SELECT `data` FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL NULL Impossible WHERE noticed after reading const tables Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.03 ms executing 0.04 ms end 0.02 ms query end 0.03 ms closing tables 0.05 ms Unlocking tables 0.05 ms freeing items 0.04 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 15 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 14 session_start() JROOT/libraries/joomla/session/handler/native.php:260 13 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:50 12 JSessionHandlerNative->start() JROOT/libraries/joomla/session/handler/joomla.php:88 11 JSessionHandlerJoomla->start() JROOT/libraries/src/Session/Session.php:660 10 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:767 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.51 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.084 MB Requêtes dupliquées: #5 DELETE FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Explication EXPLAIN impossible sur la requête : DELETE FROM `josiv_session` WHERE `session_id` = X'3763386234333766303738663337343736316638656364343930303462373163' Profil Status Duration starting 0.04 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms updating 0.04 ms end 0.02 ms query end 0.04 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.03 ms updating status 0.04 ms cleaning up 0.03 ms Pile d'appels # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:122 12 JSessionStorageDatabase->destroy() Même appel que celui de la ligne ci-dessous. 11 session_regenerate_id() JROOT/libraries/joomla/session/handler/native.php:151 10 JSessionHandlerNative->regenerate() JROOT/libraries/src/Session/Session.php:768 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [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 : 0.09 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.090 MB Rangées retournées : 0 Requêtes dupliquées: #10 SELECT `data` FROM `josiv_session` WHERE `session_id` = X'3131356434653338343435346562343261666264643134616431363463353234' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_session const PRIMARY PRIMARY 194 const 1 Profil Status Duration starting 0.04 ms checking permissions 0.04 ms Opening tables 0.03 ms After opening tables 0.05 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.02 ms executing 0.04 ms end 0.04 ms query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 12 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 11 session_regenerate_id() JROOT/libraries/joomla/session/handler/native.php:151 10 JSessionHandlerNative->regenerate() JROOT/libraries/src/Session/Session.php:768 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.63 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.097 MB UPDATE `josiv_session` SET `data` = '' , `time` = 1619312619 WHERE `session_id` = X'3131356434653338343435346562343261666264643134616431363463353234' Explication EXPLAIN impossible sur la requête : UPDATE `josiv_session` SET `data` = '' , `time` = 1619312619 WHERE `session_id` = X'3131356434653338343435346562343261666264643134616431363463353234' Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms updating 0.04 ms end 0.02 ms query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.15 ms freeing items 0.04 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/session/storage/database.php:84 12 JSessionStorageDatabase->write() Même appel que celui de la ligne ci-dessous. 11 session_write_close() JROOT/libraries/joomla/session/handler/native.php:154 10 JSessionHandlerNative->regenerate() JROOT/libraries/src/Session/Session.php:768 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [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.08 ms Mémoire de requête : 0.007 MB mémoire avant requête : 5.103 MB Rangées retournées : 0 Requêtes dupliquées: #8 SELECT `data` FROM `josiv_session` WHERE `session_id` = X'3131356434653338343435346562343261666264643134616431363463353234' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_session const PRIMARY PRIMARY 194 const 1 Profil Status Duration starting 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.03 ms statistics 0.04 ms preparing 0.02 ms executing 0.04 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.08 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/libraries/joomla/session/storage/database.php:45 13 JSessionStorageDatabase->read() Même appel que celui de la ligne ci-dessous. 12 session_start() JROOT/libraries/joomla/session/handler/native.php:260 11 JSessionHandlerNative->doSessionStart() JROOT/libraries/joomla/session/handler/native.php:160 10 JSessionHandlerNative->regenerate() JROOT/libraries/src/Session/Session.php:768 9 Joomla\CMS\Session\Session->restart() JROOT/libraries/src/Session/Session.php:635 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:804 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [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 : 0.63 ms Mémoire de requête : 0.004 MB mémoire avant requête : 5.126 MB Rangées retournées : 0 SELECT `session_id` FROM `josiv_session` WHERE `session_id` = X'3131356434653338343435346562343261666264643134616431363463353234' LIMIT 1 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_session const PRIMARY PRIMARY 194 const 1 Using index Profil Status Duration starting 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.02 ms executing 0.04 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.61 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.004 MB mémoire avant requête : 5.131 MB INSERT INTO `josiv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3131356434653338343435346562343261666264643134616431363463353234', 1, 1619312619, 0, '', 0) Explication EXPLAIN impossible sur la requête : INSERT INTO `josiv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3131356434653338343435346562343261666264643134616431363463353234', 1, 1619312619, 0, '', 0) Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms update 0.11 ms Waiting for query cache lock 0.03 ms update 0.02 ms end 0.02 ms query end 2.04 ms closing tables 0.03 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:806 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:364 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.00 ms Après la dernière requête : 3.92 ms Mémoire de requête : 0.006 MB mémoire avant requête : 5.406 MB Rangées retournées : 37 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `josiv_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_extensions ref extension extension 82 const 37 Using index condition; Using where Profil Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.68 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms optimizing 0.05 ms statistics 0.15 ms preparing 0.07 ms executing 0.05 ms Sending data 0.42 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:445 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Même appel que celui de la ligne ci-dessous. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:453 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:519 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:594 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.16 ms Après la dernière requête : 2.34 ms Mémoire de requête : 0.005 MB mémoire avant requête : 5.579 MB Rangées retournées : 5 SELECT id, rules FROM `josiv_viewlevels` Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_viewlevels ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 5 Profil Status Duration starting 0.07 ms checking permissions 0.03 ms Opening tables 0.51 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.02 ms Sending data 0.10 ms end 0.03 ms query end 0.02 ms closing tables 0.03 ms Unlocking tables 0.02 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.88 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.005 MB mémoire avant requête : 5.591 MB Rangées retournées : 2 SELECT b.id FROM josiv_usergroups AS a LEFT JOIN josiv_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 9 Using where; Using index Profil Status Duration starting 0.07 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.13 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.04 ms optimizing 0.04 ms statistics 0.12 ms preparing 0.03 ms Unlocking tables 0.03 ms executing 0.02 ms Sending data 0.06 ms end 0.04 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:321 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.34 ms Après la dernière requête : 0.74 ms Mémoire de requête : 0.005 MB mémoire avant requête : 5.668 MB Rangées retournées : 112 SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM josiv_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_extensions ref extension extension 82 const 192 Using index condition; Using where; Utilisation du tri complet de type filesort Profil Status Duration starting 0.12 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.04 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.04 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.02 ms Creating sort index 1.52 ms end 0.06 ms query end 0.04 ms closing tables 0.04 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:354 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Même appel que celui de la ligne ci-dessous. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:359 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.72 ms Après la dernière requête : 33.67 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.124 MB Rangées retournées : 2 SELECT * FROM josiv_languages WHERE published=1 ORDER BY ordering ASC Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_languages ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 2 Using where; Utilisation du tri complet de type filesort Profil Status Duration starting 0.16 ms checking permissions 0.04 ms Opening tables 0.68 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms init 0.07 ms optimizing 0.06 ms statistics 0.06 ms preparing 0.04 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.03 ms Creating sort index 0.15 ms end 0.04 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 8 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:96 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:645 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.89 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.134 MB Rangées retournées : 4 SELECT `element`,`name`,`client_id`,`extension_id` FROM `josiv_extensions` WHERE `type` = 'language' AND `state` = 0 AND `enabled` = 1 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_extensions ref extension extension 82 const 4 Using index condition; Using where Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms Table lock 0.02 ms init 0.05 ms optimizing 0.04 ms statistics 0.10 ms preparing 0.07 ms executing 0.04 ms Sending data 0.11 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.05 ms cleaning up 0.04 ms Pile d'appels # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:209 8 Joomla\CMS\Language\LanguageHelper::getInstalledLanguages() JROOT/plugins/system/languagefilter/languagefilter.php:110 7 PlgSystemLanguageFilter->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:645 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.89 ms Après la dernière requête : 10.59 ms Mémoire de requête : 0.010 MB mémoire avant requête : 8.652 MB Rangées retournées : 42 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 josiv_menu AS m LEFT JOIN josiv_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 44 Using index condition; Using where; Utilisation du tri complet de type filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 romayepk_vess616.m.component_id 1 Using where Profil Status Duration starting 0.16 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.63 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.06 ms optimizing 0.05 ms statistics 0.11 ms preparing 0.06 ms Sorting result 0.03 ms executing 0.02 ms Sending data 0.03 ms Creating sort index 1.13 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Même appel que celui de la ligne ci-dessous. 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:395 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:511 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/languagefilter/languagefilter.php:145 8 PlgSystemLanguageFilter->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:646 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.78 ms Après la dernière requête : 15.05 ms Mémoire de requête : 0.006 MB mémoire avant requête : 9.812 MB Rangées retournées : 6 SELECT id, home, template, s.params FROM josiv_template_styles as s LEFT JOIN josiv_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 id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE s ref idx_template,idx_client_id,idx_client_id_home idx_client_id 1 const 6 1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 romayepk_vess616.s.template,const 1 Using index condition; Using where Profil Status Duration starting 0.16 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.47 ms After opening tables 0.04 ms System lock 0.03 ms Table lock 0.04 ms init 0.06 ms optimizing 0.05 ms statistics 0.16 ms preparing 0.06 ms executing 0.02 ms Sending data 0.36 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/libraries/astroid/framework/library/astroid/Template.php:28 10 Astroid\Template->__construct() JROOT/libraries/astroid/framework/library/astroid/Framework.php:32 9 Astroid\Framework::init() JROOT/plugins/system/astroid/astroid.php:31 8 plgSystemAstroid->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1168 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.17 ms Après la dernière requête : 27.06 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.823 MB Rangées retournées : 1 SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `josiv_extensions` WHERE `type` = 'library' AND `element` = 'joomla' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Profil Status Duration starting 0.17 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.04 ms System lock 0.03 ms Table lock 0.02 ms init 0.06 ms optimizing 0.05 ms statistics 0.17 ms preparing 0.06 ms executing 0.02 ms Sending data 0.12 ms end 0.05 ms query end 0.04 ms closing tables 0.07 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 20 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 19 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Même appel que celui de la ligne ci-dessous. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 16 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 15 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 14 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/libraries/astroid/framework/library/astroid/Document.php:42 10 Astroid\Document->__construct() JROOT/libraries/astroid/framework/library/astroid/Framework.php:33 9 Astroid\Framework::init() JROOT/plugins/system/astroid/astroid.php:31 8 plgSystemAstroid->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1168 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.25 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.007 MB mémoire avant requête : 11.816 MB UPDATE `josiv_extensions` SET `params` = '{\"mediaversion\":\"687600a8a7df37903cdce494f44b6380\"}' WHERE `type` = 'library' AND `element` = 'joomla' Explication EXPLAIN impossible sur la requête : UPDATE `josiv_extensions` SET `params` = '{\"mediaversion\":\"687600a8a7df37903cdce494f44b6380\"}' WHERE `type` = 'library' AND `element` = 'joomla' Profil Status Duration starting 0.06 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.09 ms updating 0.28 ms end 0.03 ms Waiting for query cache lock 0.05 ms end 0.04 ms query end 1.39 ms closing tables 0.03 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 16 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 15 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 14 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 13 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 12 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 11 Joomla\CMS\Factory::getDocument() JROOT/libraries/astroid/framework/library/astroid/Document.php:42 10 Astroid\Document->__construct() JROOT/libraries/astroid/framework/library/astroid/Framework.php:33 9 Astroid\Framework::init() JROOT/plugins/system/astroid/astroid.php:31 8 plgSystemAstroid->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1168 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 3.05 ms Après la dernière requête : 10.07 ms Mémoire de requête : 0.006 MB mémoire avant requête : 12.696 MB Rangées retournées : 1 SELECT * FROM `josiv_jdbuilder_configs` WHERE `type`='global' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_jdbuilder_configs system NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 1 Profil Status Duration starting 0.13 ms checking permissions 0.03 ms Opening tables 2.24 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.03 ms init 0.06 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms Unlocking tables 0.03 ms executing 0.02 ms Sending data 0.04 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Helper.php:2019 10 JDPageBuilder\Helper::globalSettings() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:56 9 JDPageBuilder\Builder::init() JROOT/plugins/system/jdbuilder/jdbuilder.php:30 8 plgSystemJDBuilder->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1168 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.05 ms Après la dernière requête : 6.66 ms Mémoire de requête : 0.009 MB mémoire avant requête : 13.167 MB Rangées retournées : 37 SELECT `id`,`name`,`rules`,`parent_id` FROM `josiv_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_hikashop','com_installer','com_jdbuilder','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_assets ALL idx_asset_name INDEX N'A PU ÊTRE UTILISÉ NULL NULL 134 Using where Profil Status Duration starting 0.11 ms checking permissions 0.02 ms Opening tables 0.76 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.02 ms init 0.07 ms optimizing 0.03 ms statistics 0.16 ms preparing 0.04 ms executing 0.02 ms Sending data 0.48 ms end 0.04 ms query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 18 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 17 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 16 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 15 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 14 Joomla\CMS\User\User->authorise() JROOT/components/com_jdbuilder/models/page.php:42 13 JdbuilderModelPage->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jdbuilder/views/page/view.html.php:39 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 3.80 ms Après la dernière requête : 2.14 ms Mémoire de requête : 0.009 MB mémoire avant requête : 13.276 MB Rangées retournées : 14 SHOW FULL COLUMNS FROM `josiv_jdbuilder_pages` Explication EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `josiv_jdbuilder_pages` Profil Status Duration starting 0.10 ms checking permissions 0.03 ms closing tables 0.02 ms Opening tables 0.58 ms After opening tables 0.04 ms System lock 0.03 ms Table lock 0.03 ms init 0.04 ms optimizing 0.04 ms statistics 0.04 ms preparing 0.03 ms executing 0.03 ms Filling schema table 0.04 ms Opening tables 1.51 ms After opening tables 0.03 ms checking permissions 0.07 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms closing tables 0.03 ms executing 0.02 ms Sending data 0.07 ms end 0.04 ms query end 0.02 ms closing tables 0.02 ms removing tmp table 0.24 ms closing tables 0.03 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jdbuilder/tables/page.php:28 15 JdbuilderTablepage->__construct() JROOT/libraries/src/Table/Table.php:312 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_jdbuilder/models/page.php:156 13 JdbuilderModelPage->getTable() JROOT/components/com_jdbuilder/models/page.php:86 12 JdbuilderModelPage->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jdbuilder/views/page/view.html.php:40 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.93 ms Après la dernière requête : 2.28 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.354 MB Rangées retournées : 1 SELECT * FROM josiv_jdbuilder_pages WHERE `id` = '1' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_jdbuilder_pages const PRIMARY PRIMARY 4 const 1 Profil Status Duration starting 0.08 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms optimizing 0.05 ms statistics 0.10 ms preparing 0.03 ms Unlocking tables 0.05 ms executing 0.03 ms Sending data 0.06 ms end 0.03 ms query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.05 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 13 Joomla\CMS\Table\Table->load() JROOT/components/com_jdbuilder/models/page.php:89 12 JdbuilderModelPage->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jdbuilder/views/page/view.html.php:40 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.32 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.010 MB mémoire avant requête : 13.375 MB Rangées retournées : 15 SELECT `id`,`name`,`rules`,`parent_id` FROM `josiv_assets` WHERE `name` LIKE 'com_jdbuilder.%' OR `name` = 'com_jdbuilder' OR `parent_id` = 0 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_assets ALL idx_asset_name,idx_parent_id INDEX N'A PU ÊTRE UTILISÉ NULL NULL 134 Using where Profil Status Duration starting 0.08 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms optimizing 0.05 ms statistics 0.20 ms preparing 0.06 ms executing 0.03 ms Sending data 0.30 ms end 0.04 ms query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.05 ms freeing items 0.04 ms updating status 0.07 ms cleaning up 0.03 ms Pile d'appels # Appel Fichier et numéro de ligne 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 19 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 18 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 17 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 16 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 15 Joomla\CMS\User\User->authorise() JROOT/administrator/components/com_jdbuilder/tables/page.php:116 14 JdbuilderTablepage->bind() JROOT/libraries/src/Table/Table.php:741 13 Joomla\CMS\Table\Table->load() JROOT/components/com_jdbuilder/models/page.php:89 12 JdbuilderModelPage->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jdbuilder/views/page/view.html.php:40 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.46 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.007 MB mémoire avant requête : 13.399 MB Rangées retournées : 0 SELECT `title` FROM `josiv_categories` WHERE FIND_IN_SET(`id`, '0') Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_categories ALL NULL INDEX N'A PU ÊTRE UTILISÉ NULL NULL 18 Using where Profil Status Duration starting 0.07 ms checking permissions 0.04 ms Opening tables 0.69 ms After opening tables 0.03 ms System lock 0.02 ms Table lock 0.04 ms init 0.04 ms optimizing 0.02 ms statistics 0.03 ms preparing 0.03 ms executing 0.03 ms Sending data 0.14 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.04 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 13 JDatabaseDriver->loadColumn() JROOT/components/com_jdbuilder/models/page.php:128 12 JdbuilderModelPage->getItem() JROOT/libraries/src/MVC/View/HtmlView.php:425 11 Joomla\CMS\MVC\View\HtmlView->get() JROOT/components/com_jdbuilder/views/page/view.html.php:40 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 4.35 ms Après la dernière requête : 1.91 ms Mémoire de requête : 0.009 MB mémoire avant requête : 13.465 MB Rangées retournées : 1 SELECT * FROM `josiv_jdbuilder_layouts` WHERE `id`='1' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_jdbuilder_layouts const PRIMARY PRIMARY 4 const 1 Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 1.33 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms init 0.05 ms optimizing 0.03 ms statistics 1.10 ms preparing 0.03 ms Unlocking tables 0.04 ms executing 0.02 ms Sending data 1.01 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.02 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Helper.php:119 15 JDPageBuilder\Helper::getLayout() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:840 14 JDPageBuilder\Builder::renderPage() JROOT/components/com_jdbuilder/views/page/tmpl/default.php:12 13 include JROOT/components/com_jdbuilder/views/page/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_jdbuilder/views/page/view.html.php:69 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.64 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.009 MB mémoire avant requête : 13.779 MB Rangées retournées : 1 SELECT * FROM `josiv_jdbuilder_pages` WHERE `id`='1' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_jdbuilder_pages const PRIMARY PRIMARY 4 const 1 Profil Status Duration starting 0.04 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.02 ms init 0.03 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms Unlocking tables 0.02 ms executing 0.02 ms Sending data 0.03 ms end 0.02 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Helper.php:135 15 JDPageBuilder\Helper::getPage() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:841 14 JDPageBuilder\Builder::renderPage() JROOT/components/com_jdbuilder/views/page/tmpl/default.php:12 13 include JROOT/components/com_jdbuilder/views/page/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_jdbuilder/views/page/view.html.php:69 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 5.41 ms Après la dernière requête : 84.66 ms Mémoire de requête : 0.011 MB mémoire avant requête : 19.101 MB Rangées retournées : 0 SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM josiv_fields AS a LEFT JOIN `josiv_languages` AS l ON l.lang_code = a.language LEFT JOIN josiv_users AS uc ON uc.id=a.checked_out LEFT JOIN josiv_viewlevels AS ag ON ag.id = a.access LEFT JOIN josiv_users AS ua ON ua.id = a.created_user_id LEFT JOIN josiv_fields_groups AS g ON g.id = a.group_id WHERE a.context = 'com_jdbuilder.page' AND a.access IN (1,1,5) AND (a.group_id = 0 OR g.access IN (1,1,5)) AND a.state = 1 AND (a.group_id = 0 OR g.state = 1) ORDER BY a.ordering ASC Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref idx_state,idx_access,idx_context idx_state 1 const 1 Using where; Using temporary; Utilisation du tri complet de type filesort 1 SIMPLE l eq_ref idx_langcode idx_langcode 28 romayepk_vess616.a.language 1 Using where 1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 romayepk_vess616.a.checked_out 1 1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 romayepk_vess616.a.access 1 Using where 1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 romayepk_vess616.a.created_user_id 1 Using where 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 romayepk_vess616.a.group_id 1 Using where Profil Status Duration starting 0.39 ms checking permissions 0.04 ms checking permissions 0.04 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.03 ms checking permissions 0.03 ms Opening tables 2.43 ms After opening tables 0.05 ms System lock 0.03 ms Table lock 0.03 ms init 0.09 ms optimizing 0.08 ms statistics 0.34 ms preparing 0.13 ms Creating tmp table 0.21 ms Sorting result 0.05 ms executing 0.02 ms Sending data 0.69 ms Creating sort index 0.09 ms removing tmp table 0.19 ms Creating sort index 0.06 ms end 0.03 ms query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.03 ms Pile d'appels # Appel Fichier et numéro de ligne 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:187 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/plugins/system/jdbuilder/libraries/jdpagebuilder/Builder.php:902 14 JDPageBuilder\Builder::renderPage() JROOT/components/com_jdbuilder/views/page/tmpl/default.php:12 13 include JROOT/components/com_jdbuilder/views/page/tmpl/default.php JROOT/libraries/src/MVC/View/HtmlView.php:701 12 Joomla\CMS\MVC\View\HtmlView->loadTemplate() JROOT/libraries/src/MVC/View/HtmlView.php:230 11 Joomla\CMS\MVC\View\HtmlView->display() JROOT/components/com_jdbuilder/views/page/view.html.php:69 10 JdbuilderViewPage->display() JROOT/libraries/src/MVC/Controller/BaseController.php:672 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_jdbuilder/controller.php:36 8 JdbuilderController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:710 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_jdbuilder/jdbuilder.php:20 6 require_once JROOT/components/com_jdbuilder/jdbuilder.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 1.94 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.006 MB mémoire avant requête : 19.173 MB Rangées retournées : 6 SHOW FULL COLUMNS FROM `josiv_template_styles` Explication EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `josiv_template_styles` Profil Status Duration starting 0.08 ms checking permissions 0.03 ms closing tables 0.03 ms Opening tables 0.49 ms After opening tables 0.03 ms System lock 0.03 ms Table lock 0.03 ms init 0.04 ms optimizing 0.03 ms statistics 0.06 ms preparing 0.04 ms executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms checking permissions 0.08 ms checking permissions 0.05 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.04 ms closing tables 0.04 ms executing 0.02 ms Sending data 0.06 ms end 0.03 ms query end 0.03 ms closing tables 0.02 ms removing tmp table 0.21 ms closing tables 0.03 ms Unlocking tables 0.02 ms freeing items 0.03 ms updating status 0.03 ms cleaning up 0.04 ms Pile d'appels # Appel Fichier et numéro de ligne 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 12 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 11 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 10 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_templates/tables/style.php:30 9 TemplatesTableStyle->__construct() JROOT/libraries/src/Table/Table.php:312 8 Joomla\CMS\Table\Table::getInstance() JROOT/plugins/system/helix3/helix3.php:37 7 plgSystemHelix3->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 0.80 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.006 MB mémoire avant requête : 19.198 MB Rangées retournées : 1 SELECT * FROM josiv_template_styles WHERE `id` = '9' Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_template_styles const PRIMARY PRIMARY 4 const 1 Profil Status Duration starting 0.08 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.03 ms Table lock 0.03 ms init 0.05 ms optimizing 0.03 ms statistics 0.07 ms preparing 0.02 ms Unlocking tables 0.06 ms executing 0.02 ms Sending data 0.03 ms end 0.02 ms query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.03 ms updating status 0.04 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/plugins/system/helix3/helix3.php:38 7 plgSystemHelix3->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [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 : 0.27 ms Mémoire de requête : 0.005 MB mémoire avant requête : 19.202 MB Rangées retournées : 3 SELECT language,id FROM `josiv_menu` WHERE home = 1 AND published = 1 AND client_id = 0 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE josiv_menu ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 45 Using where Profil Status Duration starting 0.06 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms Table lock 0.03 ms init 0.04 ms optimizing 0.04 ms statistics 0.08 ms preparing 0.06 ms executing 0.02 ms Sending data 0.31 ms end 0.04 ms query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.02 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] Temps de requête : 2.05 ms Après la dernière requête : 2.56 ms Mémoire de requête : 0.005 MB mémoire avant requête : 19.297 MB Rangées retournées : 2 SELECT `c2`.`language`,`c2`.`id` FROM `josiv_menu` AS `c` INNER JOIN `josiv_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `josiv_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `josiv_menu` AS `c2` ON a2.id = c2.`id` WHERE c.id = 142 Explication id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Using index 1 SIMPLE a const PRIMARY,idx_key PRIMARY 206 const,const 1 1 SIMPLE a2 ref idx_key idx_key 128 const 2 Using index 1 SIMPLE c2 eq_ref PRIMARY PRIMARY 4 romayepk_vess616.a2.id 1 Profil Status Duration starting 0.14 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.02 ms checking permissions 0.02 ms Opening tables 0.92 ms After opening tables 0.04 ms System lock 0.02 ms Table lock 0.02 ms init 0.06 ms optimizing 0.07 ms statistics 0.17 ms preparing 0.04 ms Unlocking tables 0.06 ms executing 0.03 ms Sending data 0.10 ms end 0.03 ms query end 0.04 ms closing tables 0.02 ms Unlocking tables 0.03 ms freeing items 0.02 ms updating status 0.03 ms cleaning up 0.02 ms Pile d'appels # Appel Fichier et numéro de ligne 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Associations.php:115 9 Joomla\CMS\Language\Associations::getAssociations() JROOT/administrator/components/com_menus/helpers/menus.php:321 8 MenusHelper::getAssociations() JROOT/plugins/system/languagefilter/languagefilter.php:768 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:203 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers] 29 types de requêtes exécutées, triées par occurrences. Tables sélectionnées : 4 × SELECT `data` FROM `josiv_session` 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `josiv_extensions` 2 × SELECT `id`,`name`,`rules`,`parent_id` FROM `josiv_assets` 1 × SELECT * FROM `josiv_jdbuilder_configs` 1 × SELECT language,id FROM `josiv_menu` 1 × SELECT * FROM josiv_template_styles 1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM josiv_fields AS a LEFT JOIN `josiv_languages` AS l ON l.lang_code = a.language LEFT JOIN josiv_users AS uc ON uc.id=a.checked_out LEFT JOIN josiv_viewlevels AS ag ON ag.id = a.access LEFT JOIN josiv_users AS ua ON ua.id = a.created_user_id LEFT JOIN josiv_fields_groups AS g ON g.id = a.group_id 1 × SELECT * FROM `josiv_jdbuilder_pages` 1 × SELECT * FROM `josiv_jdbuilder_layouts` 1 × SELECT `title` FROM `josiv_categories` 1 × SELECT * FROM josiv_jdbuilder_pages 1 × SELECT id, home, template, s.params FROM josiv_template_styles as s LEFT JOIN josiv_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id 1 × SELECT * FROM `josiv_users` 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 josiv_menu AS m LEFT JOIN josiv_extensions AS e ON m.component_id = e.extension_id 1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `josiv_extensions` 1 × SELECT * FROM josiv_languages 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM josiv_extensions 1 × SELECT b.id FROM josiv_usergroups AS a LEFT JOIN josiv_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt 1 × SELECT id, rules FROM `josiv_viewlevels 1 × SELECT `session_id` FROM `josiv_session` 1 × SELECT `g`.`id`,`g`.`title` FROM `josiv_usergroups` AS g INNER JOIN `josiv_user_usergroup_map` AS m ON m.group_id = g.id 1 × SELECT `c2`.`language`,`c2`.`id` FROM `josiv_menu` AS `c` INNER JOIN `josiv_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNER JOIN `josiv_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNER JOIN `josiv_menu` AS `c2` ON a2.id = c2.`id` Autres tables : 2 × DELETE FROM `josiv_session` 1 × SHOW FULL COLUMNS FROM `josiv_users 1 × UPDATE `josiv_session` SET `data` = '' , `time` = 1619312619 1 × INSERT INTO `josiv_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3131356434653338343435346562343261666264643134616431363463353234', 1, 1619312619, 0, '', 0 1 × UPDATE `josiv_extensions` SET `params` = '{\"mediaversion\":\"687600a8a7df37903cdce494f44b6380\"}' 1 × SHOW FULL COLUMNS FROM `josiv_jdbuilder_pages 1 × SHOW FULL COLUMNS FROM `josiv_template_styles