CulteBox - Ressources : faites votre choix

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1743418469,
                "last": 1743418469,
                "now": 1743418469
            },
            "token": "ZOQEpW0WlyJIpcj5fg9upE7Zy2Hr6EgE"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 9.76 ms / 9.76 ms Mémoire: 2.017 MB / 2.42 MB Application: afterLoad

Temps: 91.00 ms / 100.76 ms Mémoire: 8.615 MB / 11.04 MB Application: afterInitialise

Temps: 8.50 ms / 109.26 ms Mémoire: 1.686 MB / 12.73 MB Application: Before Access::preloadComponents (all components)

Temps: 1.04 ms / 110.30 ms Mémoire: 0.064 MB / 12.79 MB Application: After Access::preloadComponents (all components)

Temps: 0.01 ms / 110.32 ms Mémoire: -0.005 MB / 12.79 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Temps: 1.21 ms / 111.53 ms Mémoire: 0.014 MB / 12.80 MB Application: After Access::preloadPermissions (com_dpcalendar)

Temps: 0.01 ms / 111.54 ms Mémoire: 0.001 MB / 12.80 MB Application: Before Access::getAssetRules (id:1475 name:com_dpcalendar.category.76)

Temps: 0.25 ms / 111.78 ms Mémoire: 0.026 MB / 12.83 MB Application: After Access::getAssetRules (id:1475 name:com_dpcalendar.category.76)

Temps: 0.06 ms / 111.84 ms Mémoire: 0.017 MB / 12.84 MB Application: Before Access::getAssetRules (id:1484 name:com_dpcalendar.category.77)

Temps: 0.02 ms / 111.86 ms Mémoire: 0.008 MB / 12.85 MB Application: After Access::getAssetRules (id:1484 name:com_dpcalendar.category.77)

Temps: 0.04 ms / 111.90 ms Mémoire: 0.017 MB / 12.87 MB Application: Before Access::getAssetRules (id:1472 name:com_dpcalendar.category.75)

Temps: 0.01 ms / 111.91 ms Mémoire: 0.002 MB / 12.87 MB Application: After Access::getAssetRules (id:1472 name:com_dpcalendar.category.75)

Temps: 0.04 ms / 111.95 ms Mémoire: 0.017 MB / 12.89 MB Application: Before Access::getAssetRules (id:1464 name:com_dpcalendar.category.74)

Temps: 0.01 ms / 111.95 ms Mémoire: 0.002 MB / 12.89 MB Application: After Access::getAssetRules (id:1464 name:com_dpcalendar.category.74)

Temps: 0.03 ms / 111.98 ms Mémoire: 0.017 MB / 12.91 MB Application: Before Access::getAssetRules (id:1491 name:com_dpcalendar.category.78)

Temps: 0.01 ms / 111.99 ms Mémoire: 0.002 MB / 12.91 MB Application: After Access::getAssetRules (id:1491 name:com_dpcalendar.category.78)

Temps: 4.56 ms / 116.55 ms Mémoire: 0.604 MB / 13.51 MB Application: afterRoute

Temps: 1.75 ms / 118.30 ms Mémoire: 0.150 MB / 13.66 MB Application: beforeRenderComponent com_flexicontent

Temps: 12.17 ms / 130.47 ms Mémoire: 3.509 MB / 17.17 MB Application: Before Access::getAssetRules (id:113 name:com_flexicontent)

Temps: 0.06 ms / 130.53 ms Mémoire: 0.032 MB / 17.20 MB Application: After Access::getAssetRules (id:113 name:com_flexicontent)

Temps: 25.56 ms / 156.09 ms Mémoire: 1.573 MB / 18.78 MB Application: afterRenderComponent com_flexicontent

Temps: 3.45 ms / 159.54 ms Mémoire: 0.565 MB / 19.34 MB Application: afterDispatch

Temps: 13.09 ms / 172.63 ms Mémoire: 1.534 MB / 20.88 MB Application: beforeRenderModule mod_custom (matomo /!\ ne pas éditer ni enregistrer avec éditeur actif /!\)

Temps: 0.39 ms / 173.02 ms Mémoire: 0.030 MB / 20.91 MB Application: afterRenderModule mod_custom (matomo /!\ ne pas éditer ni enregistrer avec éditeur actif /!\)

Temps: 0.03 ms / 173.05 ms Mémoire: -0.001 MB / 20.90 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 1.74 ms / 174.79 ms Mémoire: 0.085 MB / 20.99 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 0.03 ms / 174.82 ms Mémoire: -0.018 MB / 20.97 MB Application: beforeRenderModule mod_custom (logo EERV)

Temps: 0.10 ms / 174.93 ms Mémoire: 0.003 MB / 20.97 MB Application: afterRenderModule mod_custom (logo EERV)

Temps: 0.01 ms / 174.94 ms Mémoire: -0.001 MB / 20.97 MB Application: beforeRenderModule mod_custom (copyleft)

Temps: 0.09 ms / 175.03 ms Mémoire: 0.003 MB / 20.98 MB Application: afterRenderModule mod_custom (copyleft)

Temps: 0.02 ms / 175.05 ms Mémoire: -0.000 MB / 20.98 MB Application: beforeRenderModule mod_contented_pdf (Votre choix d'éléments liturgiques)

Temps: 0.17 ms / 175.22 ms Mémoire: 0.007 MB / 20.98 MB Application: afterRenderModule mod_contented_pdf (Votre choix d'éléments liturgiques)

Temps: 6.07 ms / 181.28 ms Mémoire: 0.352 MB / 21.34 MB Application: afterRender

Total de requêtes base de données : 32.15 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_session	const	PRIMARY	PRIMARY	194	const	1

#	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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	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:828
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN impossible sur la requête : INSERT INTO `ct8bx2_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'3261386535623666623932396635646439376232306261663762663236623062', 1, 1743418469, 0, '')

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.02 ms
Update	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.16 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 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:828
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:386
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.85 ms Après la dernière requête : 2.48 ms Mémoire de requête : 0.072 MB mémoire avant requête : 4.485 MB Rangées retournées : 47

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

  FROM `ct8bx2_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	ct8bx2_extensions	ref	extension	extension	82	const	48	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.40 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	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:225
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.42 ms Après la dernière requête : 2.40 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.774 MB Rangées retournées : 5

SELECT id, rules

  FROM `ct8bx2_viewlevels`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 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:318
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:225
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.48 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.786 MB Rangées retournées : 2

SELECT b.id

  FROM ct8bx2_usergroups AS a

  LEFT JOIN ct8bx2_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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	11	Using where; Using index

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 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:318
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:225
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.41 ms Après la dernière requête : 0.73 ms Mémoire de requête : 0.072 MB mémoire avant requête : 4.855 MB Rangées retournées : 198

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

  FROM ct8bx2_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	ct8bx2_extensions	ALL	extension	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	331	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.97 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	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:351
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:356
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:225
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.45 ms Après la dernière requête : 16.56 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.801 MB Rangées retournées : 1

SELECT lft,rgt 
  FROM ct8bx2_categories 
  WHERE id=1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_categories	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_flexicontent/defineconstants.php:100
8	require_once JROOT/administrator/components/com_flexicontent/defineconstants.php	JROOT/plugins/system/flexisystem/flexisystem.php:19
7	require_once JROOT/plugins/system/flexisystem/flexisystem.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
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:667
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:225
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.58 ms Après la dernière requête : 46.51 ms Mémoire de requête : 0.021 MB mémoire avant requête : 10.702 MB Rangées retournées : 1

SELECT `template`

  FROM `ct8bx2_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	6	Using where

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:247
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:41
8	plgSystemHelix3->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:668
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:225
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.55 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 10.927 MB Rangées retournées : 1

SELECT `params`

  FROM `ct8bx2_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_engage'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	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/fof40/Params/Params.php:55
13	FOF40\Params\Params->reload()	JROOT/libraries/fof40/Params/Params.php:40
12	FOF40\Params\Params->__construct()	JROOT/libraries/fof40/Container/Container.php:281
11	FOF40\Container\Container->FOF40\Container\{closure}()	JROOT/libraries/fof40/Pimple/Container.php:115
10	FOF40\Pimple\Container->offsetGet()	JROOT/libraries/fof40/Container/ContainerBase.php:27
9	FOF40\Container\ContainerBase->__get()	JROOT/plugins/system/engagecache/engagecache.php:57
8	plgSystemEngagecache->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:668
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:225
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.02 ms Après la dernière requête : 1.48 ms Mémoire de requête : 0.131 MB mémoire avant requête : 11.226 MB Rangées retournées : 33

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

  LEFT JOIN ct8bx2_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	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	yp4wn_cultebox.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.55 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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:225
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.86 ms Après la dernière requête : 5.36 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.663 MB Rangées retournées : 6

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

  FROM `ct8bx2_categories` AS `s`

  INNER JOIN `ct8bx2_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 76

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	8	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.15 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 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/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:76
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:88
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:82
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.95 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.729 MB Rangées retournées : 47

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

  FROM `ct8bx2_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contented_pdf','com_contenthistory','com_convertforms','com_cpanel','com_djimageslider','com_dpcalendar','com_engage','com_fields','com_finder','com_flexicontent','com_gavoting','com_installer','com_jce','com_joomlaupdate','com_joompassswap','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_regularlabsmanager','com_search','com_sexypolling','com_sppolls','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_assets	range	idx_asset_name	idx_asset_name	202	NULL	48	Using index condition

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.12 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.41 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:94
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:88
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:82
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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 : 0.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.786 MB Rangées retournées : 8

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

  FROM `ct8bx2_assets`

  WHERE `name` LIKE 'com_dpcalendar.%' OR `name` = 'com_dpcalendar' OR `parent_id` = 0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1234	Using where

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.77 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
15	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:94
10	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Rules/DPCalendarRules.php:88
9	DPCalendar\Router\Rules\DPCalendarRules->buildLookup()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:50
8	Joomla\CMS\Component\Router\Rules\MenuRules->__construct()	JROOT/components/com_dpcalendar/router.php:82
7	DPCalendarRouter->__construct()	JROOT/libraries/src/Router/SiteRouter.php:789
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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:225
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.49 ms Après la dernière requête : 3.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.284 MB Rangées retournées : 1

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

  FROM `ct8bx2_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:251
8	plgSystemFlexisystem->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:1190
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:225
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.39 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.006 MB mémoire avant requête : 13.277 MB

UPDATE `ct8bx2_extensions`

  SET `params` = '{\"mediaversion\":\"07ec893d5dbe6b030a5b0effe3d71c3b\"}'

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

Explication

EXPLAIN impossible sur la requête : UPDATE `ct8bx2_extensions` SET `params` = '{\"mediaversion\":\"07ec893d5dbe6b030a5b0effe3d71c3b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.06 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Writing to binlog	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/flexisystem/flexisystem.php:251
8	plgSystemFlexisystem->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:1190
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:225
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.42 ms Après la dernière requête : 0.98 ms Mémoire de requête : 0.020 MB mémoire avant requête : 13.568 MB Rangées retournées : 2

SELECT *

  FROM ct8bx2_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ct8bx2_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.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.59 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.081 MB mémoire avant requête : 13.583 MB Rangées retournées : 4

SELECT id, home, template, s.params

  FROM ct8bx2_template_styles as s

  LEFT JOIN ct8bx2_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	yp4wn_cultebox.e.element	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.74 ms Après la dernière requête : 12.74 ms Mémoire de requête : 0.040 MB mémoire avant requête : 17.204 MB Rangées retournées : 4

SELECT c.*, u.name as author, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'fr-FR' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assigneditems 
  FROM ct8bx2_categories AS c 
  LEFT JOIN ct8bx2_users AS u 
  ON u.id = c.created_user_id 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 48 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title 
  LIMIT 0, 200

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where; Utilisation du tri complet de type filesort
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	yp4wn_cultebox.c.created_user_id	1	Using where
2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	yp4wn_cultebox.c.id	1	Using where
2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	yp4wn_cultebox.c.id	16	Using where; Using index
2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	yp4wn_cultebox.rel.itemid	1	Using index condition; Using where
2	DEPENDENT SUBQUERY	ty	eq_ref	PRIMARY,access	PRIMARY	4	yp4wn_cultebox.i.type_id	1	Using where

Profil

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Optimizing	0.06 ms
Statistics	0.18 ms
Preparing	0.09 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.42 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_flexicontent/models/flexicontent.php:139
12	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.87 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.082 MB mémoire avant requête : 17.253 MB Rangées retournées : 23

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'fr-FR' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM ct8bx2_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM ct8bx2_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 21 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where; Utilisation du tri complet de type filesort
3	DEPENDENT SUBQUERY	sc	ALL	idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	83	Using where
2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	yp4wn_cultebox.c.id	1	Using where
2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	yp4wn_cultebox.c.id	16	Using where; Using index
2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	yp4wn_cultebox.rel.itemid	1	Using index condition; Using where
2	DEPENDENT SUBQUERY	ty	eq_ref	PRIMARY,access	PRIMARY	4	yp4wn_cultebox.i.type_id	1	Using where

Profil

Status	Duration
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.13 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.10 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.13 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
13	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
12	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.85 ms Après la dernière requête : 0.07 ms Mémoire de requête : 0.046 MB mémoire avant requête : 17.371 MB Rangées retournées : 9

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'fr-FR' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM ct8bx2_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM ct8bx2_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 14 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where; Utilisation du tri complet de type filesort
3	DEPENDENT SUBQUERY	sc	ALL	idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	83	Using where
2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	yp4wn_cultebox.c.id	1	Using where
2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	yp4wn_cultebox.c.id	16	Using where; Using index
2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	yp4wn_cultebox.rel.itemid	1	Using index condition; Using where
2	DEPENDENT SUBQUERY	ty	eq_ref	PRIMARY,access	PRIMARY	4	yp4wn_cultebox.i.type_id	1	Using where

Profil

Status	Duration
Starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.08 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.38 ms
Executing	0.01 ms
Sending data	0.17 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.08 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.27 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.09 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
13	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
12	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.69 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.057 MB mémoire avant requête : 17.430 MB Rangées retournées : 6

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'fr-FR' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM ct8bx2_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM ct8bx2_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 41 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where; Utilisation du tri complet de type filesort
3	DEPENDENT SUBQUERY	sc	ALL	idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	83	Using where
2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	yp4wn_cultebox.c.id	1	Using where
2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	yp4wn_cultebox.c.id	16	Using where; Using index
2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	yp4wn_cultebox.rel.itemid	1	Using index condition; Using where
2	DEPENDENT SUBQUERY	ty	eq_ref	PRIMARY,access	PRIMARY	4	yp4wn_cultebox.i.type_id	1	Using where

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.07 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.36 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.56 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.86 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.16 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
13	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
12	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.96 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.109 MB mémoire avant requête : 17.489 MB Rangées retournées : 16

SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid 
  WHERE cc.published = 1 
  AND c.id = cc.id 
  AND (i .language = 'fr-FR' OR i.language = '*') 
  AND ( i.state IN (1, -5) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ( ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= UTC_TIMESTAMP() ) OR ( i.created_by = 0 
  AND i.created_by != 0 ) ) 
  AND ty.access IN (0,1,1,5) 
  AND cc.access IN (0,1,1,5) 
  AND  i.access IN (0,1,1,5) ) AS assignedsubitems, ( SELECT COUNT( sc.id ) 
  FROM ct8bx2_categories AS sc 
  WHERE c.id = sc.parent_id 
  AND sc.published = 1 
  AND sc.access IN (0,1,1,5) ) AS assignedcats 
  FROM ct8bx2_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 8 
  AND  c.access IN (0,1,1,5) 
  ORDER BY c.lft ASC, c.title

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where; Utilisation du tri complet de type filesort
3	DEPENDENT SUBQUERY	sc	ALL	idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	83	Using where
2	DEPENDENT SUBQUERY	cc	eq_ref	PRIMARY,idx_access	PRIMARY	4	yp4wn_cultebox.c.id	1	Using where
2	DEPENDENT SUBQUERY	rel	ref	PRIMARY,catid,itemid	PRIMARY	4	yp4wn_cultebox.c.id	16	Using where; Using index
2	DEPENDENT SUBQUERY	i	eq_ref	PRIMARY,state,access,language,type_id	PRIMARY	4	yp4wn_cultebox.rel.itemid	1	Using index condition; Using where
2	DEPENDENT SUBQUERY	ty	eq_ref	PRIMARY,access	PRIMARY	4	yp4wn_cultebox.i.type_id	1	Using where

Profil

Status	Duration
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.08 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.07 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.37 ms
Executing	0.01 ms
Sending data	0.15 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	1.70 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.12 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.11 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.09 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.03 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.07 ms
Executing	0.01 ms
Sending data	0.01 ms
Executing	0.01 ms
Sending data	0.05 ms
Executing	0.01 ms
Sending data	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_flexicontent/models/flexicontent.php:449
13	FlexicontentModelFlexicontent->_getsubs()	JROOT/components/com_flexicontent/models/flexicontent.php:147
12	FlexicontentModelFlexicontent->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:54
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.72 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 17.620 MB Rangées retournées : 4

SELECT c.id 
  FROM ct8bx2_categories AS c 
  WHERE c.published = 1 
  AND c.extension="com_content"  
  AND c.parent_id = 48 
  AND c.access IN (0,1,1,5)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx,idx_access	cat_idx	203	const,const	67	Using index condition; Using where

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_flexicontent/models/flexicontent.php:326
12	FlexicontentModelFlexicontent->getTotal()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_flexicontent/views/flexicontent/view.html.php:55
10	FlexicontentViewFlexicontent->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_flexicontent/controller.php:1361
8	FlexicontentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_flexicontent/flexicontent.php:265
6	require_once JROOT/components/com_flexicontent/flexicontent.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:225
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.26 ms Après la dernière requête : 17.32 ms Mémoire de requête : 0.027 MB mémoire avant requête : 20.537 MB Rangées retournées : 18

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

  FROM ct8bx2_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-03-31 10:54:30') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-31 10:54:30') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 130 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	35	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	yp4wn_cultebox.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	yp4wn_cultebox.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.55 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:591
10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:538
9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:329
8	Helix3::generatelayout()	JROOT/templates/shaper_helix3/index.php:139
7	require JROOT/templates/shaper_helix3/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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]

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

Tables sélectionnées :

4 × SELECT c.*, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid

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

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ct8bx2_assets`

1 × SELECT `data` 
  FROM `ct8bx2_session`

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `ct8bx2_categories` AS `s` 
  INNER JOIN `ct8bx2_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT c.id 
  FROM ct8bx2_categories AS c

1 × SELECT c.*, u.name as author, 
  CASE WHEN CHAR_LENGTH( c.alias ) THEN CONCAT_WS( ':', c.id, c.alias ) ELSE c.id END AS slug, ( SELECT COUNT( DISTINCT rel.itemid ) 
  FROM ct8bx2_flexicontent_cats_item_relations AS rel JOIN ct8bx2_flexicontent_items_tmp AS i 
  ON rel.itemid = i.id JOIN ct8bx2_flexicontent_types AS ty 
  ON i.type_id = ty.id JOIN ct8bx2_categories AS cc 
  ON cc.id = rel.catid

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

```
1 × SELECT * 
  FROM ct8bx2_languages
```

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

1 × SELECT `session_id` 
  FROM `ct8bx2_session`

1 × SELECT `params` 
  FROM `ct8bx2_extensions`

1 × SELECT `template` 
  FROM `ct8bx2_template_styles`

1 × SELECT lft,rgt 
  FROM ct8bx2_categories

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

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

1 × SELECT id, rules 
  FROM `ct8bx2_viewlevels

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

Autres tables :

1 × INSERT INTO `ct8bx2_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'3261386535623666623932396635646439376232306261663762663236623062', 1, 1743418469, 0, ''

1 × UPDATE `ct8bx2_extensions` 
  SET `params` = '{\"mediaversion\":\"07ec893d5dbe6b030a5b0effe3d71c3b\"}'

Ressources : faites votre choix

Catégories

Moment du culte (0)

Temps cultuel (0)

Style (0)

Temps liturgique (0)

Votre choix d'éléments liturgiques

Menu principal

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

25 requêtes exécutées 32.15 ms

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

Tables sélectionnées :

Autres tables :