Liens rapides

Foire aux questions

Pour une meilleure expérience, merci d'orienter votre écran en mode paysage.

L'équipe T2 Area —

Cross Triathlon de Vioreau (44)

Découvrez les éditions de l'épreuve

Fiche épreuve consultée : 367 fois, dont 367 fois en 2021

Site internet Organisateur: http://www.triathlon-ancenis.fr/

Facebook Organisateur

Cross Triathlon de Vioreau (44) - M
Dernière édition le 23 mai 2021 Distances : 1184 m / 23 km / 10.2 km D+ : 504 m (22 m au km)

2019 2018

Aucune épreuve

Pas de connexion Internet

A propos des cookies

Ce site web stocke les cookies sur votre ordinateur. Ces cookies sont utilisés pour collecter des informations sur la manière dont vous interagissez avec notre site web et nous permettent de nous souvenir de vous. Nous utilisons ces informations afin d'améliorer et de personnaliser votre expérience de navigation, ainsi que pour l'analyse et les indicateurs concernant nos visiteurs à la fois sur ce site web et sur d'autres supports. Pour en savoir plus sur les cookies que nous utilisons, consultez notre politique de confidentialité.

OK, Je donne mon accord

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1627478987,
                "last": 1627478987,
                "now": 1627478987
            },
            "token": "t7gVr9FGaEy6yTZYUDZldVXCSM6sWHmL"
        },
        "registry": {
            "com_t2rank": {
                "edit": {
                    "epreuve": {
                        "id": "45"
                    }
                }
            }
        },
        "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: 27.41 ms / 27.41 ms Mémoire: 0.400 MB / 0.75 MB Application: afterLoad

Temps: 91.47 ms / 118.87 ms Mémoire: 1.811 MB / 2.56 MB Application: afterInitialise

Temps: 11.59 ms / 130.47 ms Mémoire: 0.140 MB / 2.70 MB Application: afterRoute

Temps: 8.25 ms / 138.72 ms Mémoire: 0.049 MB / 2.75 MB Application: beforeRenderComponent com_t2rank

Temps: 10.38 ms / 149.10 ms Mémoire: 0.148 MB / 2.89 MB Application: Before Access::preloadComponents (all components)

Temps: 2.06 ms / 151.16 ms Mémoire: 0.064 MB / 2.96 MB Application: After Access::preloadComponents (all components)

Temps: 0.05 ms / 151.21 ms Mémoire: -0.004 MB / 2.95 MB Application: Before Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 0.99 ms / 152.20 ms Mémoire: 0.009 MB / 2.96 MB Application: After Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 9.22 ms / 161.42 ms Mémoire: 0.066 MB / 3.03 MB Application: Before Access::preloadPermissions (com_t2rank)

Temps: 15.48 ms / 176.90 ms Mémoire: 4.061 MB / 7.09 MB Application: After Access::preloadPermissions (com_t2rank)

Temps: 5.62 ms / 182.52 ms Mémoire: -0.197 MB / 6.89 MB Application: Before Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 0.04 ms / 182.57 ms Mémoire: 0.002 MB / 6.89 MB Application: After Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 4.11 ms / 186.68 ms Mémoire: 0.034 MB / 6.93 MB Application: Before Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 0.04 ms / 186.71 ms Mémoire: 0.001 MB / 6.93 MB Application: After Access::getAssetRules (id:16411 name:com_t2rank)

Temps: 100.88 ms / 287.59 ms Mémoire: 0.180 MB / 7.11 MB Application: afterRenderComponent com_t2rank

Temps: 18.13 ms / 305.72 ms Mémoire: 0.014 MB / 7.12 MB Application: afterDispatch

Temps: 7.15 ms / 312.87 ms Mémoire: 0.224 MB / 7.35 MB Application: beforeRenderModule mod_menu (Calendrier Région)

Temps: 6.58 ms / 319.46 ms Mémoire: 0.076 MB / 7.42 MB Application: afterRenderModule mod_menu (Calendrier Région)

Temps: 0.09 ms / 319.55 ms Mémoire: -0.003 MB / 7.42 MB Application: beforeRenderModule mod_menu (Calendrier FFTRI)

Temps: 2.34 ms / 321.89 ms Mémoire: 0.035 MB / 7.46 MB Application: afterRenderModule mod_menu (Calendrier FFTRI)

Temps: 0.08 ms / 321.97 ms Mémoire: -0.003 MB / 7.45 MB Application: beforeRenderModule mod_menu (Liens rapides)

Temps: 2.06 ms / 324.03 ms Mémoire: 0.036 MB / 7.49 MB Application: afterRenderModule mod_menu (Liens rapides)

Temps: 0.08 ms / 324.11 ms Mémoire: -0.002 MB / 7.49 MB Application: beforeRenderModule mod_miniteklivesearch (Minitek Live Search)

Temps: 4.96 ms / 329.07 ms Mémoire: 0.060 MB / 7.55 MB Application: afterRenderModule mod_miniteklivesearch (Minitek Live Search)

Temps: 368.83 ms / 697.91 ms Mémoire: 1.293 MB / 8.84 MB Application: afterRender

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

Occupation de la mémoire

Requêtes de base de données

53 requêtes exécutées 136.07 ms

6 doubles découverts!

2 requêtes dupliquées: #16 #21

4 requêtes dupliquées: #19 #20 #22 #23

Temps de requête : 0.66 ms Mémoire de requête : 0.023 MB mémoire avant requête : 1.031 MB Rangées retournées : 0

SELECT `data`

  FROM `zfv71_session`

  WHERE `session_id` = X'7266393361366b6d6171713135316c72633061616d39396c7563'

Explication

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 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
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:832
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:392
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.50 ms Après la dernière requête : 2.37 ms Mémoire de requête : 0.020 MB mémoire avant requête : 1.045 MB Rangées retournées : 0

SELECT `session_id`

  FROM `zfv71_session`

  WHERE `session_id` = X'7266393361366b6d6171713135316c72633061616d39396c7563' 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.04 ms
Checking permissions	0.02 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.02 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	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
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:834
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:392
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.05 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.004 MB mémoire avant requête : 1.050 MB

INSERT INTO `zfv71_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'7266393361366b6d6171713135316c72633061616d39396c7563', 1, 1627478987, 0, '', 0)

Explication

EXPLAIN impossible sur la requête : INSERT INTO `zfv71_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7266393361366b6d6171713135316c72633061616d39396c7563', 1, 1627478987, 0, '', 0)

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.01 ms
Init for update	0.03 ms
Update	0.15 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.54 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
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:834
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:392
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.07 ms Après la dernière requête : 4.42 ms Mémoire de requête : 0.040 MB mémoire avant requête : 1.082 MB Rangées retournées : 46

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

  FROM `zfv71_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	zfv71_extensions	ref	extension	extension	82	const	48	Using index condition; 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.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.51 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 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
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 : 0.49 ms Après la dernière requête : 3.44 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.125 MB Rangées retournées : 5

SELECT id, rules

  FROM `zfv71_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.04 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.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 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: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.62 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.137 MB Rangées retournées : 2

SELECT b.id

  FROM zfv71_usergroups AS a

  LEFT JOIN zfv71_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	12	Using where; Using index

Profil

Status	Duration
Starting	0.06 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.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 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: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.56 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.046 MB mémoire avant requête : 1.159 MB Rangées retournées : 122

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

  FROM zfv71_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	zfv71_extensions	ref	extension	extension	82	const	287	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.03 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.89 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.05 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: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: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.08 ms Après la dernière requête : 12.30 ms Mémoire de requête : 0.117 MB mémoire avant requête : 1.527 MB Rangées retournées : 92

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

  LEFT JOIN zfv71_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	97	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	t2area.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.08 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.04 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	1.45 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:423
13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
11	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
10	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:539
9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jmap/jmap.php:1083
7	plgSystemJMap->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:673
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.53 ms Après la dernière requête : 42.75 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.716 MB Rangées retournées : 1

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

  FROM `zfv71_extensions`

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

Explication

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

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.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.05 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:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.21 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.707 MB

UPDATE `zfv71_extensions`

  SET `params` = '{\"mediaversion\":\"108d6891368d729fde599bbadca9830a\"}'

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.12 ms
Updating	0.12 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.56 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1131
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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.62 ms Après la dernière requête : 2.80 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.730 MB Rangées retournées : 2

SELECT *

  FROM zfv71_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_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.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.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 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: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.79 ms Après la dernière requête : 0.47 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.741 MB Rangées retournées : 4

SELECT id, home, template, s.params

  FROM zfv71_template_styles as s

  LEFT JOIN zfv71_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	t2area.e.element	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.07 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.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.04 ms
Closing tables	0.02 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
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: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.74 ms Après la dernière requête : 11.79 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.898 MB Rangées retournées : 46

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

  FROM `zfv71_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_api','com_associations','com_cache','com_categories','com_checkin','com_comprofiler','com_config','com_content','com_contenthistory','com_cpanel','com_easyfrontendseo','com_fields','com_finder','com_gsd','com_hikamarket','com_hikashop','com_imagerecycle','com_installer','com_jce','com_jch_optimize','com_jmap','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_miniteklivesearch','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_t2rank','com_tags','com_templates','com_users','com_wrapper')

Explication

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

Profil

Status	Duration
Starting	0.10 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.10 ms
Optimizing	0.02 ms
Statistics	0.24 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.88 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 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
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_t2rank/models/epreuve.php:60
13	T2rankModelEpreuve->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_t2rank/views/epreuve/view.html.php:48
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.65 ms Après la dernière requête : 1.79 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.961 MB Rangées retournées : 1

SELECT a.*

  FROM `zfv71_t2rank_manifestation` AS a

  WHERE a.alias='triathlon-de-vioreau'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	I_alias_manif	I_alias_manif	767	const	1	Using index condition

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.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_t2rank/helpers/t2rank.php:1257
14	T2rankHelpersT2rank::getEpreuveIdByAlias()	JROOT/components/com_t2rank/models/epreuve.php:69
13	T2rankModelEpreuve->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_t2rank/views/epreuve/view.html.php:48
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.12 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.028 MB mémoire avant requête : 2.973 MB Rangées retournées : 20

SHOW FULL COLUMNS 
  FROM `zfv71_t2rank_manifestation`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `zfv71_t2rank_manifestation`

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.15 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
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_t2rank/tables/epreuve.php:31
15	T2rankTableepreuve->__construct()	JROOT/libraries/src/Table/Table.php:312
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_t2rank/models/epreuve.php:304
13	T2rankModelEpreuve->getTable()	JROOT/components/com_t2rank/models/epreuve.php:110
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.45 ms Après la dernière requête : 4.49 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.014 MB Rangées retournées : 1

Requêtes dupliquées: #21

SELECT *

  FROM zfv71_t2rank_manifestation

  WHERE `id` = '45'

Explication

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

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.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	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
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_t2rank/models/epreuve.php:113
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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 : 8.29 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.581 MB mémoire avant requête : 3.033 MB Rangées retournées : 4604

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

  FROM `zfv71_assets`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5094	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.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	7.67 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.03 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
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_t2rank/tables/epreuve.php:109
14	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_t2rank/models/epreuve.php:113
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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 : 8.20 ms Mémoire de requête : 0.028 MB mémoire avant requête : 7.166 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `zfv71_assets`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `zfv71_assets`

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.02 ms
Closing tables	0.02 ms
Opening tables	0.44 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.04 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
Checking permissions	0.12 ms
Closing tables	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
19	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
18	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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_t2rank/tables/epreuve.php:109
14	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_t2rank/models/epreuve.php:113
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.65 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.188 MB Rangées retournées : 0

Requêtes dupliquées: #20 #22 #23

SELECT *

  FROM zfv71_assets

  WHERE `name` = 'com_t2rank.epreuve.45'

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.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
19	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
18	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
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_t2rank/tables/epreuve.php:109
14	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_t2rank/models/epreuve.php:113
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.59 ms Après la dernière requête : 1.51 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.198 MB Rangées retournées : 0

Requêtes dupliquées: #19 #22 #23

SELECT *

  FROM zfv71_assets

  WHERE `name` = 'com_t2rank.epreuve.45'

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.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.05 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	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:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
16	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/administrator/components/com_t2rank/tables/epreuve.php:114
14	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
13	Joomla\CMS\Table\Table->load()	JROOT/components/com_t2rank/models/epreuve.php:113
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.71 ms Après la dernière requête : 0.49 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.891 MB Rangées retournées : 1

Requêtes dupliquées: #16

SELECT *

  FROM zfv71_t2rank_manifestation

  WHERE `id` = '45'

Explication

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

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.03 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 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:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Helper/TagsHelper.php:890
16	Joomla\CMS\Helper\TagsHelper->preStoreProcess()	JROOT/libraries/src/Table/Observer/Tags.php:107
15	Joomla\CMS\Table\Observer\Tags->onBeforeStore()	JROOT/libraries/joomla/observer/updater.php:159
14	JObserverUpdater->update()	JROOT/libraries/src/Table/Table.php:783
13	Joomla\CMS\Table\Table->store()	JROOT/components/com_t2rank/models/epreuve.php:154
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.62 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.027 MB mémoire avant requête : 7.221 MB Rangées retournées : 0

Requêtes dupliquées: #19 #20 #23

SELECT *

  FROM zfv71_assets

  WHERE `name` = 'com_t2rank.epreuve.45'

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.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_t2rank/tables/epreuve.php:109
18	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
17	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Helper/TagsHelper.php:890
16	Joomla\CMS\Helper\TagsHelper->preStoreProcess()	JROOT/libraries/src/Table/Observer/Tags.php:107
15	Joomla\CMS\Table\Observer\Tags->onBeforeStore()	JROOT/libraries/joomla/observer/updater.php:159
14	JObserverUpdater->update()	JROOT/libraries/src/Table/Table.php:783
13	Joomla\CMS\Table\Table->store()	JROOT/components/com_t2rank/models/epreuve.php:154
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.61 ms Après la dernière requête : 1.25 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.232 MB Rangées retournées : 0

Requêtes dupliquées: #19 #20 #22

SELECT *

  FROM zfv71_assets

  WHERE `name` = 'com_t2rank.epreuve.45'

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.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
22	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
21	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
20	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/administrator/components/com_t2rank/tables/epreuve.php:114
18	T2rankTableepreuve->bind()	JROOT/libraries/src/Table/Table.php:741
17	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Helper/TagsHelper.php:890
16	Joomla\CMS\Helper\TagsHelper->preStoreProcess()	JROOT/libraries/src/Table/Observer/Tags.php:107
15	Joomla\CMS\Table\Observer\Tags->onBeforeStore()	JROOT/libraries/joomla/observer/updater.php:159
14	JObserverUpdater->update()	JROOT/libraries/src/Table/Table.php:783
13	Joomla\CMS\Table\Table->store()	JROOT/components/com_t2rank/models/epreuve.php:154
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.75 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.923 MB Rangées retournées : 0

SELECT `t`.`id`

  FROM `zfv71_tags` AS t 

  INNER JOIN `zfv71_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_t2rank.epreuve' 
  AND `m`.`content_item_id` IN ( 45)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where
1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	t2area.m.tag_id	1	Using index

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.03 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 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:1550
18	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Helper/TagsHelper.php:506
17	Joomla\CMS\Helper\TagsHelper->getTagIds()	JROOT/libraries/src/Helper/TagsHelper.php:892
16	Joomla\CMS\Helper\TagsHelper->preStoreProcess()	JROOT/libraries/src/Table/Observer/Tags.php:107
15	Joomla\CMS\Table\Observer\Tags->onBeforeStore()	JROOT/libraries/joomla/observer/updater.php:159
14	JObserverUpdater->update()	JROOT/libraries/src/Table/Table.php:783
13	Joomla\CMS\Table\Table->store()	JROOT/components/com_t2rank/models/epreuve.php:154
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.15 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.007 MB mémoire avant requête : 6.931 MB

UPDATE `zfv71_t2rank_manifestation` 
  SET `ordering`='0',`state`='1',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`created_by`='492',`modified_by`='492',`title`='Cross Triathlon de Vioreau (44)',`alias`='triathlon-de-vioreau',`organizer`='502',`website_url`='http://www.triathlon-ancenis.fr/',`facebook_url`='',`banniere`='images/epreuve/44-Cross-Triathlon-de-Vioreau.png',`place_id`='76936',`hits`='367',`hits_2021`='367',`hits_2022`='0',`labels_fftri`='',`fftri_event_id`='0',`epr_filter`='cross-triathlon distance-m cross-triathlon-m' 
  WHERE `id` = '45'

Explication

EXPLAIN impossible sur la requête : UPDATE `zfv71_t2rank_manifestation` SET `ordering`='0',`state`='1',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`created_by`='492',`modified_by`='492',`title`='Cross Triathlon de Vioreau (44)',`alias`='triathlon-de-vioreau',`organizer`='502',`website_url`='http://www.triathlon-ancenis.fr/',`facebook_url`='',`banniere`='images/epreuve/44-Cross-Triathlon-de-Vioreau.png',`place_id`='76936',`hits`='367',`hits_2021`='367',`hits_2022`='0',`labels_fftri`='',`fftri_event_id`='0',`epr_filter`='cross-triathlon distance-m cross-triathlon-m' WHERE `id` = '45'

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.07 ms
Updating	0.09 ms
End of update loop	0.02 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.52 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
14	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:801
13	Joomla\CMS\Table\Table->store()	JROOT/components/com_t2rank/models/epreuve.php:154
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.26 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.029 MB mémoire avant requête : 6.942 MB Rangées retournées : 16

SHOW FULL COLUMNS 
  FROM `zfv71_users`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `zfv71_users`

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.32 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
Checking permissions	0.16 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.12 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
20	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
19	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
18	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
17	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_t2rank/models/epreuve.php:168
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.76 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.971 MB Rangées retournées : 1

SELECT *

  FROM `zfv71_users`

  WHERE `id` = 492

Explication

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

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.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_t2rank/models/epreuve.php:168
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.83 ms Après la dernière requête : 1.76 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.987 MB Rangées retournées : 1

SELECT `g`.`id`,`g`.`title`

  FROM `zfv71_usergroups` AS g

  INNER JOIN `zfv71_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 492

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	t2area.m.group_id	1

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.04 ms
Closing tables	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_t2rank/models/epreuve.php:168
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.69 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.025 MB mémoire avant requête : 6.997 MB Rangées retournées : 1

SELECT *

  FROM `zfv71_users`

  WHERE `id` = 502

Explication

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

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.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.02 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 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:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_t2rank/models/epreuve.php:176
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.74 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.008 MB Rangées retournées : 2

SELECT `g`.`id`,`g`.`title`

  FROM `zfv71_usergroups` AS g

  INNER JOIN `zfv71_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 502

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	t2area.m.group_id	1

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 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:1506
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
17	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
16	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
15	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
14	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
13	Joomla\CMS\Factory::getUser()	JROOT/components/com_t2rank/models/epreuve.php:176
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.96 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.016 MB Rangées retournées : 1

SELECT *,IFNULL(pays, "FR") place_pays

  FROM `zfv71_t2rank_places`

  WHERE id = 76936

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_t2rank_places	const	PRIMARY,place_titre	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.01 ms
Table lock	0.02 ms
Init	0.09 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 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:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_t2rank/models/epreuve.php:192
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.91 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.027 MB Rangées retournées : 1

SELECT zfv71_t2rank_departments.name department_name, zfv71_t2rank_departments.code department_code, zfv71_t2rank_regionalligues.name regionalligue_name, zfv71_t2rank_regionalligues.alias regionalligue_alias

  FROM `zfv71_t2rank_departments`

  INNER JOIN zfv71_t2rank_regionalligues  
  on zfv71_t2rank_regionalligues.id = zfv71_t2rank_departments.id_regionalligue

  WHERE code = "44"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_t2rank_departments	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	103	Using where
1	SIMPLE	zfv71_t2rank_regionalligues	eq_ref	PRIMARY	PRIMARY	4	t2area.zfv71_t2rank_departments.id_regionalligue	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.20 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.03 ms
Updating status	0.02 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:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_t2rank/models/epreuve.php:212
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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 : 21.44 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.040 MB Rangées retournées : 5

SELECT loc.id,
 3956 * 2 * ASIN(SQRT(POWER(SIN((47.5092437538-ABS(latitude)) * PI()/180/2),2) + COS(47.5092437538 * PI()/180) * COS(ABS(latitude) * PI()/180) * POWER(SIN(( -1.42943494948-longitude) * PI()/180/2),2))) AS distance
 
  FROM zfv71_t2rank_places AS loc
 
  WHERE longitude BETWEEN ( -1.42943494948-60 / ABS(COS(RADIANS(47.5092437538))*69)) 
  AND ( -1.42943494948+60 / ABS(COS(RADIANS(47.5092437538)) * 69))
 
  AND latitude BETWEEN (47.5092437538-(60/69)) 
  AND (47.5092437538+(60/69))
 
  and loc.id in (select place_id 
  from zfv71_t2rank_manifestation)
 
  GROUP BY loc.id
 
  HAVING distance < 60
 
  ORDER BY distance ASC
 
  LIMIT 5

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<subquery2>	ALL	distinct_key	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	837	Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	loc	eq_ref	PRIMARY,place_titre	PRIMARY	4	t2area.zfv71_t2rank_manifestation.place_id	1	Using where
2	MATERIALIZED	zfv71_t2rank_manifestation	index	FK_place_id	FK_place_id	4	NULL	837	Using index

Profil

Status	Duration
Starting	0.22 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.09 ms
Optimizing	0.09 ms
Statistics	0.08 ms
Preparing	0.12 ms
Creating tmp table	0.05 ms
Sorting result	0.05 ms
Executing	0.01 ms
Sending data	20.15 ms
Creating sort index	0.07 ms
Removing tmp table	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Removing tmp table	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.02 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/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_t2rank/models/epreuve.php:238
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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 : 14.43 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.051 MB Rangées retournées : 0

SELECT
event.alias,
epr.banniere event_banniere,
epr.banniere image,
event.category_name,
event.event_titre,
event.event_date,
'' event_link,
pl.titre place_titre,
pl.codepostal place_codepostal,
pl.ville place_ville,
event.event_canonical

  FROM  zfv71_t2rank_epreuve event

  inner join zfv71_t2rank_manifestation epr 
  on event.epreuve_id = epr.id

  inner join zfv71_t2rank_places pl 
  on epr.place_id = pl.id

  where event_date > now()
  
  and epr.state=1
  
  and event.state=1

  and event.epreuve_id <> 45

  and pl.id in (76936,88244,99659,93903,88243)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	epr	range	PRIMARY,FK_place_id	FK_place_id	4	NULL	5	Using index condition; Using where
1	SIMPLE	pl	eq_ref	PRIMARY,place_titre	PRIMARY	4	t2area.epr.place_id	1
1	SIMPLE	event	ALL	state,I_optim_req_calendrier	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2755	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.05 ms
Statistics	0.53 ms
Preparing	0.08 ms
Executing	0.01 ms
Sending data	13.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 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/components/com_t2rank/models/epreuve.php:272
12	T2rankModelEpreuve->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:49
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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 : 44.40 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.055 MB Rangées retournées : 1

select cat.id,
       cat.alias,
       cat.event_titre,
       cat.category_name,
       manif.banniere event_banniere,
       cat.event_format,
       cat.event_ligue,
       rgt_event_elevation,
       rgt_event_distance,
       '' event_link,
       year(cat.event_date) start_year,
       month(cat.event_date) start_month,
       day(cat.event_date) start_day,
       cat.event_cancelled cancelled,
      (
  CASE WHEN DATE_FORMAT(cat.event_date,'%Y%m%d') < DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') THEN 1 ELSE 0 END) AS event_in_past,
      cat.njuko_registrationurl,
      cat.njuko_participantLimit,
      (select count(1) 
  from `zfv71_t2rank_enrolments` b 
  where b.event_id=cat.id 
  and b.published=1 
  and b.enroltype=0) nb_enrolyes,
      cat.listcanonicalurl listcanonicalurl,
      0 bike_elevation_positive,
      0 bike_distance,
      0 swim_distance,
      0 run_distance,
      0 run1_distance,
      0 run2_distance,
      cat.category_type category_type

  from zfv71_t2rank_epreuve cat

  inner join  zfv71_t2rank_manifestation manif 
  on manif.id = cat.epreuve_id

  where cat.state = 1

  and cat.epreuve_id = 45

  order by (
  CASE WHEN DATE_FORMAT(cat.event_date,'%Y%m%d') < DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') THEN 1 ELSE 0 END), cat.event_date asc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	manif	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	cat	ref	state,I_optim_req_calendrier	I_optim_req_calendrier	1	const	1739	Using where; Utilisation du tri complet de type filesort
2	DEPENDENT SUBQUERY	b	ref	UI_enrol,ndx_published,fky_event,ndx_enroltype	UI_enrol	4	t2area.cat.id	112	Using index condition; Using where

Profil

Status	Duration
Starting	0.23 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.16 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.08 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	43.01 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
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.01 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.01 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_t2rank/helpers/t2rank.php:127
13	T2rankHelpersT2rank::getEditionsByEpreuve()	JROOT/components/com_t2rank/models/epreuve.php:39
12	T2rankModelEpreuve->getEditionsByEpreuve()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:50
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.87 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.064 MB Rangées retournées : 1

SELECT e.alias 
  FROM zfv71_t2rank_epreuve c 
  inner join zfv71_t2rank_manifestation e 
  on c.epreuve_id = e.id 
  where c.alias = "cross-triathlon-de-vioreau-44--format-m"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	i_alias_epreuve	i_alias_epreuve	1002	const	1	Using where
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	t2area.c.epreuve_id	1	Using where

Profil

Status	Duration
Starting	0.06 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.03 ms
Optimizing	0.03 ms
Statistics	0.16 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.01 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/components/com_t2rank/helpers/route.php:147
14	T2RankHelperRoute::getEpreuveRoute()	JROOT/components/com_t2rank/helpers/t2rank.php:135
13	T2rankHelpersT2rank::getEditionsByEpreuve()	JROOT/components/com_t2rank/models/epreuve.php:39
12	T2rankModelEpreuve->getEditionsByEpreuve()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:50
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.88 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.072 MB Rangées retournées : 1

SELECT event_format 
  FROM zfv71_t2rank_epreuve 
  WHERE alias = "cross-triathlon-de-vioreau-44--format-m"

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_t2rank_epreuve	ref	i_alias_epreuve	i_alias_epreuve	1002	const	1	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.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.19 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 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/components/com_t2rank/helpers/route.php:150
14	T2RankHelperRoute::getEpreuveRoute()	JROOT/components/com_t2rank/helpers/t2rank.php:135
13	T2rankHelpersT2rank::getEditionsByEpreuve()	JROOT/components/com_t2rank/models/epreuve.php:39
12	T2rankModelEpreuve->getEditionsByEpreuve()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:50
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.21 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.078 MB Rangées retournées : 1

select AVG(NULLIF(swim_distance ,0)) swim_distance, AVG(NULLIF(bike_distance ,0)) bike_distance, AVG(NULLIF(bike_elevation_gain ,0)) bike_elevation_positive, AVG(NULLIF(bike_elevation_gain ,0)) / AVG(NULLIF(bike_distance ,0)) bike_ratio, AVG(NULLIF(run_distance ,0)) run_distance, AVG(NULLIF(run1_distance ,0)) run1_distance, AVG(NULLIF(run2_distance ,0)) run2_distance 
  FROM `zfv71_t2rank_results_metadata` as dist 
  inner join zfv71_t2rank_edition as course 
  on dist.course_fk = course.id 
  where  course.categorie_fk = 16416 
  group by year(course_date) 
  ORDER BY year(course_date) ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	course	ref	PRIMARY,I_cat_fk	I_cat_fk	4	const	2	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	dist	ref	course_fk	course_fk	4	t2area.course.id	1	Using index condition

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.06 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.17 ms
Creating sort index	0.08 ms
Removing tmp table	0.02 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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_t2rank/helpers/t2rank.php:161
13	T2rankHelpersT2rank::getEditionsByEpreuve()	JROOT/components/com_t2rank/models/epreuve.php:39
12	T2rankModelEpreuve->getEditionsByEpreuve()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:50
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.77 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.086 MB Rangées retournées : 2

select year(course_date) annee 
  from zfv71_t2rank_edition 
  where categorie_fk=16416 
  order by course_date desc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_t2rank_edition	ref	I_cat_fk	I_cat_fk	4	const	2	Using where; Utilisation du tri complet de type filesort

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.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.05 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_t2rank/helpers/t2rank.php:183
13	T2rankHelpersT2rank::getEditionsByEpreuve()	JROOT/components/com_t2rank/models/epreuve.php:39
12	T2rankModelEpreuve->getEditionsByEpreuve()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_t2rank/views/epreuve/view.html.php:50
10	T2rankViewEpreuve->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_t2rank/controller.php:52
8	T2rankController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_t2rank/t2rank.php:25
6	require_once JROOT/components/com_t2rank/t2rank.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.35 ms Après la dernière requête : 26.81 ms Mémoire de requête : 0.023 MB mémoire avant requête : 7.347 MB Rangées retournées : 5

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

  FROM zfv71_modules AS m

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

  LEFT JOIN zfv71_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 <= '2021-07-28 13:29:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-07-28 13:29:48') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 8021 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	12	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	t2area.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	t2area.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.09 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.36 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
10	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
9	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
8	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:45
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.63 ms Après la dernière requête : 13.02 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.517 MB Rangées retournées : 1

SELECT *  
  FROM `zfv71_minitek_live_search_instances` 
  WHERE `module_id` = '6' 
  AND `state` = '1' 
  ORDER BY `ordering`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_minitek_live_search_instances	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	4	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.05 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.02 ms
Init	0.04 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.03 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_miniteklivesearch/helper.php:25
11	modDLSHelper::getInstances()	JROOT/modules/mod_miniteklivesearch/mod_miniteklivesearch.php:34
10	include JROOT/modules/mod_miniteklivesearch/mod_miniteklivesearch.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.82 ms Après la dernière requête : 3.44 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.538 MB Rangées retournées : 0

SELECT *
 
  FROM zfv71_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.t2area.com/calendrier/triathlon-de-vioreau.html'
 
  AND `published` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_jmap_metainfo	ref	linkurl,published	linkurl	766	const	1	Using where

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.06 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.02 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:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:429
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.52 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.544 MB Rangées retournées : 0

SELECT *
 
  FROM zfv71_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.t2area.com/calendrier/triathlon-de-vioreau.html'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_jmap_canonicals	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	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.02 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
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.04 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:508
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.67 ms Après la dernière requête : 1.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.557 MB Rangées retournées : 0

SELECT * 
  FROM `zfv71_plg_easyfrontendseo` 
  WHERE `url` = 'index.php?format=html&option=com_t2rank&view=epreuve&epreuve_alias=triathlon-de-vioreau&Itemid=8021'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_plg_easyfrontendseo	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	48	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.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/easyfrontendseo/easyfrontendseo.php:513
12	PlgSystemEasyFrontendSeo->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.69 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.564 MB Rangées retournées : 1

SELECT *

  FROM `zfv71_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_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.03 ms
Optimizing	0.02 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.06 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:124
18	NRFramework\Extension::get()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:166
17	NRFramework\Extension::isEnabled()	JROOT/plugins/system/nrframework/NRFramework/Extension.php:149
16	NRFramework\Extension::componentIsEnabled()	JROOT/plugins/system/gsd/gsd.php:484
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.38 ms Après la dernière requête : 1.55 ms Mémoire de requête : 0.026 MB mémoire avant requête : 7.578 MB Rangées retournées : 2

SHOW FULL COLUMNS 
  FROM `zfv71_gsd_config`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `zfv71_gsd_config`

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Closing tables	0.01 ms
Opening tables	0.45 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.09 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.13 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	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
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
20	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
19	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
18	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:312
17	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:412
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.24 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.594 MB Rangées retournées : 1

SELECT *

  FROM zfv71_gsd_config

  WHERE `name` = 'config'

Explication

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

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
17	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:413
16	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:496
15	plgSystemGSD->setup()	JROOT/plugins/system/gsd/gsd.php:527
14	plgSystemGSD->getHelper()	JROOT/plugins/system/gsd/gsd.php:65
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.12 ms Après la dernière requête : 11.65 ms Mémoire de requête : 0.029 MB mémoire avant requête : 7.641 MB Rangées retournées : 16

SELECT a.*

  FROM zfv71_gsd a

  WHERE a.state = 1 
  AND a.plugin = 'menus'

  ORDER BY a.id desc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	state,plugin	plugin	152	const	16	Using where

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.24 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.04 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_gsd/models/items.php:158
20	GSDModelItems->getItems()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220
19	GSD\PluginBase->getSnippets()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.24 ms Après la dernière requête : 16.87 ms Mémoire de requête : 0.028 MB mémoire avant requête : 7.676 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 zfv71_fields AS a

  LEFT JOIN `zfv71_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN zfv71_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN zfv71_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN zfv71_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN zfv71_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_t2rank.menus' 
  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_context	766	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	t2area.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	t2area.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	t2area.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	t2area.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	t2area.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.23 ms
Checking permissions	0.02 ms
Opening tables	0.09 ms
After opening tables	0.06 ms
System lock	0.02 ms
Table lock	0.03 ms
Init	0.11 ms
Optimizing	0.07 ms
Statistics	0.21 ms
Preparing	0.09 ms
Creating tmp table	0.11 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.61 ms
Creating sort index	0.07 ms
Removing tmp table	0.10 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
22	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
21	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:832
20	GSD\PluginBase->prepareText()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:374
19	GSD\PluginBase->preparePayload()	JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171
18	GSD\PluginBase->onGSDBeforeRender()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_gsd/GSD/Helper.php:451
14	GSD\Helper::event()	JROOT/plugins/system/gsd/gsd.php:85
13	plgSystemGSD->init()	JROOT/plugins/system/gsd/gsd.php:54
12	plgSystemGSD->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
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:209
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.73 ms Après la dernière requête : 12.17 ms Mémoire de requête : 0.020 MB mémoire avant requête : 7.973 MB Rangées retournées : 0

SELECT *
 
  FROM zfv71_jmap_headings
 
  WHERE `linkurl` = 'https://www.t2area.com/calendrier/triathlon-de-vioreau.html'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	zfv71_jmap_headings	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	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.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.02 ms
Closing tables	0.03 ms
Unlocking tables	0.02 ms
Closing tables	0.03 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
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:824
7	plgSystemJMap->onAfterRender()	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/CMSApplication.php:1124
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:209
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.16 ms Après la dernière requête : 5.46 ms Mémoire de requête : 0.039 MB mémoire avant requête : 8.106 MB Rangées retournées : 258

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

Status	Duration
Starting	0.05 ms
Checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Checking permissions	1.26 ms
Executing	0.02 ms
Sending data	0.23 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
14	JDatabaseDriverMysqli->getTableList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:552
13	acymailing_getTableList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:18
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:523
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:25
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1124
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:209
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.07 ms Après la dernière requête : 0.29 ms Mémoire de requête : 0.034 MB mémoire avant requête : 8.146 MB Rangées retournées : 185

SELECT * 
  FROM zfv71_acymailing_config

Explication

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

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.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.48 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 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
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:478
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:23
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:523
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:840
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:25
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1124
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:209
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.97 ms Après la dernière requête : 22.81 ms Mémoire de requête : 0.024 MB mémoire avant requête : 8.718 MB Rangées retournées : 1

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

  FROM zfv71_extensions

  WHERE element = 'jch_optimize' 
  AND type = 'plugin' 
  AND folder = 'system'

Explication

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.09 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.03 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.04 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.05 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/plugins/system/jch_optimize/src/Plugin.php:74
17	JchOptimize\Platform\Plugin::loadjch()	JROOT/plugins/system/jch_optimize/src/Plugin.php:47
16	JchOptimize\Platform\Plugin::getPlugin()	JROOT/plugins/system/jch_optimize/src/Plugin.php:91
15	JchOptimize\Platform\Plugin::getPluginParams()	JROOT/plugins/system/jch_optimize/src/Cache.php:110
14	JchOptimize\Platform\Cache::getLifetime()	JROOT/plugins/system/jch_optimize/src/Cache.php:92
13	JchOptimize\Platform\Cache::getCacheObject()	JROOT/plugins/system/jch_optimize/src/Cache.php:127
12	JchOptimize\Platform\Cache::getCache()	JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Html/Callbacks/CombineJsCss.php:54
11	JchOptimize\Core\Html\Callbacks\CombineJsCss->__construct()	JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Html/Processor.php:135
10	JchOptimize\Core\Html\Processor->processCombineJsCss()	JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Optimize.php:108
9	JchOptimize\Core\Optimize->process()	JROOT/plugins/system/jch_optimize/vendor/jchoptimize/core/src/Optimize.php:90
8	JchOptimize\Core\Optimize::optimize()	JROOT/plugins/system/jch_optimize/jch_optimize.php:95
7	plgSystemJCH_Optimize->onAfterRender()	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/CMSApplication.php:1124
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:209
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]

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

Tables sélectionnées :

```
4 × SELECT * 
  FROM zfv71_assets
```

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

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `zfv71_usergroups` AS g 
  INNER JOIN `zfv71_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
2 × SELECT * 
  FROM `zfv71_users`
```

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

2 × SELECT * 
  FROM zfv71_t2rank_manifestation

1 × SELECT `data` 
  FROM `zfv71_session`

1 × select year(course_date) annee 
  from zfv71_t2rank_edition

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

1 × SELECT *  
  FROM `zfv71_minitek_live_search_instances`

1 × SELECT *  
  FROM zfv71_jmap_metainfo

1 × SELECT *  
  FROM zfv71_jmap_canonicals

1 × SELECT * 
  FROM `zfv71_plg_easyfrontendseo`

1 × SELECT event_format 
  FROM zfv71_t2rank_epreuve

1 × SELECT * 
  FROM `zfv71_extensions`

```
1 × SELECT * 
  FROM zfv71_gsd_config
```
```
1 × SELECT a.* 
  FROM zfv71_gsd a
```

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 zfv71_fields AS a 
  LEFT JOIN `zfv71_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN zfv71_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN zfv71_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN zfv71_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN zfv71_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT *  
  FROM zfv71_jmap_headings

1 × SELECT * 
  FROM zfv71_acymailing_confi

1 × select AVG(NULLIF(swim_distance ,0)) swim_distance, AVG(NULLIF(bike_distance ,0)) bike_distance, AVG(NULLIF(bike_elevation_gain ,0)) bike_elevation_positive, AVG(NULLIF(bike_elevation_gain ,0)) / AVG(NULLIF(bike_distance ,0)) bike_ratio, AVG(NULLIF(run_distance ,0)) run_distance, AVG(NULLIF(run1_distance ,0)) run1_distance, AVG(NULLIF(run2_distance ,0)) run2_distance 
  FROM `zfv71_t2rank_results_metadata` as dist 
  inner join zfv71_t2rank_edition as course 
  on dist.course_fk = course.id

1 × SELECT loc.id,
  3956 * 2 * ASIN(SQRT(POWER(SIN((47.5092437538-ABS(latitude)) * PI()/180/2),2) + COS(47.5092437538 * PI()/180) * COS(ABS(latitude) * PI()/180) * POWER(SIN(( -1.42943494948-longitude) * PI()/180/2),2))) AS distance
  
  FROM zfv71_t2rank_places AS loc

1 × SELECT e.alias 
  FROM zfv71_t2rank_epreuve c 
  inner join zfv71_t2rank_manifestation e 
  on c.epreuve_id = e.id

1 × select cat.id,
        cat.alias,
        cat.event_titre,
        cat.category_name,
        manif.banniere event_banniere,
        cat.event_format,
        cat.event_ligue,
        rgt_event_elevation,
        rgt_event_distance,
        '' event_link,
        year(cat.event_date) start_year,
        month(cat.event_date) start_month,
        day(cat.event_date) start_day,
        cat.event_cancelled cancelled,
       (
  CASE WHEN DATE_FORMAT(cat.event_date,'%Y%m%d') < DATE_FORMAT(UTC_TIMESTAMP(),'%Y%m%d') THEN 1 ELSE 0 END) AS event_in_past,
       cat.njuko_registrationurl,
       cat.njuko_participantLimit,
       (select count(1) 
  from `zfv71_t2rank_enrolments` b

1 × SELECT
 event.alias,
 epr.banniere event_banniere,
 epr.banniere image,
 event.category_name,
 event.event_titre,
 event.event_date,
 '' event_link,
 pl.titre place_titre,
 pl.codepostal place_codepostal,
 pl.ville place_ville,
 event.event_canonical
 
  FROM  zfv71_t2rank_epreuve event
 
  inner join zfv71_t2rank_manifestation epr 
  on event.epreuve_id = epr.id
 
  inner join zfv71_t2rank_places pl 
  on epr.place_id = pl.id

1 × SELECT `session_id` 
  FROM `zfv71_session`

1 × SELECT zfv71_t2rank_departments.name department_name, zfv71_t2rank_departments.code department_code, zfv71_t2rank_regionalligues.name regionalligue_name, zfv71_t2rank_regionalligues.alias regionalligue_alias 
  FROM `zfv71_t2rank_departments` 
  INNER JOIN zfv71_t2rank_regionalligues  
  on zfv71_t2rank_regionalligues.id = zfv71_t2rank_departments.id_regionalligue

1 × SELECT *,IFNULL(pays, "FR") place_pays 
  FROM `zfv71_t2rank_places`

1 × SELECT `t`.`id` 
  FROM `zfv71_tags` AS t  
  INNER JOIN `zfv71_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_t2rank.epreuve' 
  AND `m`.`content_item_id` IN ( 45

1 × SELECT a.* 
  FROM `zfv71_t2rank_manifestation` AS a

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

```
1 × SELECT * 
  FROM zfv71_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 zfv71_menu AS m 
  LEFT JOIN zfv71_extensions AS e 
  ON m.component_id = e.extension_id

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

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

1 × SELECT id, rules 
  FROM `zfv71_viewlevels

1 × SELECT folder AS type, element AS name, params, extension_id 
  FROM zfv71_extensions

Autres tables :

1 × INSERT INTO `zfv71_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'7266393361366b6d6171713135316c72633061616d39396c7563', 1, 1627478987, 0, '', 0

1 × UPDATE `zfv71_extensions` 
  SET `params` = '{\"mediaversion\":\"108d6891368d729fde599bbadca9830a\"}'

1 × SHOW FULL COLUMNS 
  FROM `zfv71_t2rank_manifestation

1 × SHOW FULL COLUMNS 
  FROM `zfv71_assets

1 × UPDATE `zfv71_t2rank_manifestation` 
  SET `ordering`='0',`state`='1',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`created_by`='492',`modified_by`='492',`title`='Cross Triathlon de Vioreau (44)',`alias`='triathlon-de-vioreau',`organizer`='502',`website_url`='http://www.triathlon-ancenis.fr/',`facebook_url`='',`banniere`='images/epreuve/44-Cross-Triathlon-de-Vioreau.png',`place_id`='76936',`hits`='367',`hits_2021`='367',`hits_2022`='0',`labels_fftri`='',`fftri_event_id`='0',`epr_filter`='cross-triathlon distance-m cross-triathlon-m'

1 × SHOW FULL COLUMNS 
  FROM `zfv71_users

1 × SHOW FULL COLUMNS 
  FROM `zfv71_gsd_config

```
1 × SHOW TABLE
```

Cross Triathlon de Vioreau (44)

Cross Triathlon de Vioreau (44) - M

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

53 requêtes exécutées 136.07 ms

6 doubles découverts!

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

Tables sélectionnées :

Autres tables :