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

Temps

Mémoire

40 requêtes exécutées 593.73 ms

1. Temps de requête : 0.42 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.919 MB Rangées retournées : 0

   SELECT `data`
   
     FROM `dm4t9_session`
   
     WHERE `session_id` = X'3631363931636465383230303234633731336663653466656266633138613364'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dm4t9_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.05 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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

2. Temps de requête : 0.41 ms Après la dernière requête : 1.35 ms Mémoire de requête : 0.023 MB mémoire avant requête : 4.024 MB Rangées retournées : 0

   SELECT `session_id`
   
     FROM `dm4t9_session`
   
     WHERE `session_id` = X'3631363931636465383230303234633731336663653466656266633138613364' 
     LIMIT 1

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

3. Temps de requête : 6.84 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.005 MB mémoire avant requête : 4.031 MB

   INSERT INTO `dm4t9_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   (X'3631363931636465383230303234633731336663653466656266633138613364', 1, 1742785255, 0, '')

   Explication

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

   Profil

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	6.05 ms
   end	0.03 ms
   query end	0.46 ms
   closing tables	0.04 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:47

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

4. Temps de requête : 0.56 ms Après la dernière requête : 6.54 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.641 MB Rangées retournées : 5

   SELECT id, rules
   
     FROM `dm4t9_viewlevels`

   Explication

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

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.03 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

5. Temps de requête : 0.70 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.656 MB Rangées retournées : 1

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

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	20.00	Using where; Using index

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

6. Temps de requête : 1.18 ms Après la dernière requête : 14.02 ms Mémoire de requête : 0.076 MB mémoire avant requête : 6.026 MB Rangées retournées : 143

   SELECT setting,value 
     FROM dm4t9_jfbconnect_config

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dm4t9_jfbconnect_config	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	179	100.00	NULL

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.40 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:306
   14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:344
   13	JFBConnectModelConfig->get()	JROOT/administrator/components/com_jfbconnect/models/config.php:391
   12	JFBConnectModelConfig->getSetting()	JROOT/components/com_jfbconnect/libraries/provider.php:33
   11	JFBConnectProvider->__construct()	JROOT/components/com_jfbconnect/libraries/provider/amazon.php:20
   10	JFBConnectProviderAmazon->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:55
   9	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:76
   8	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:40
   7	plgSystemJFBCSystem->__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:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

7. Temps de requête : 0.52 ms Après la dernière requête : 25.25 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.747 MB Rangées retournées : 1

   SELECT count(*)
   
     FROM `dm4t9_cwgears_schedule`

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dm4t9_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	100.00	Using index

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

8. Temps de requête : 0.47 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.755 MB Rangées retournées : 1

   SELECT count(*)
   
     FROM `dm4t9_cwgears_schedule`
   
     WHERE time + '86400'<'1742785255'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dm4t9_cwgears_schedule	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where

   Profil

   Status	Duration
   starting	0.04 ms
   checking permissions	0.02 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

9. Temps de requête : 0.94 ms Après la dernière requête : 37.63 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.321 MB

   UPDATE `dm4t9_extensions`
   
     SET `params` = '{\"mediaversion\":\"69963b2e992d1571e6c478f315d690e0\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explication

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	dm4t9_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profil

   Status	Duration
   starting	0.06 ms
   checking permissions	0.05 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.08 ms
   updating	0.06 ms
   end	0.02 ms
   query end	0.33 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Pile d'appels

   #	Appel	Fichier et numéro de ligne
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
   8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
   4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
   3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

   [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

   ---

10. Temps de requête : 0.35 ms Après la dernière requête : 1.96 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.497 MB Rangées retournées : 1

    SELECT count(*)
    
      FROM `dm4t9_extensions`
    
      WHERE `element` = 'cwgears' 
      AND `extension_id` = ''

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
    9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

11. Temps de requête : 5.05 ms Après la dernière requête : 5.12 ms Mémoire de requête : 0.035 MB mémoire avant requête : 11.929 MB Rangées retournées : 19

    SHOW FULL COLUMNS 
      FROM `dm4t9_fwsg_file`

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	2.62 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.28 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	1.38 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_fwgallery/tables/file.php:52
    12	TableFile->__construct()	JROOT/libraries/src/Table/Table.php:328
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_fwgallery/models/item.php:58
    10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

12. Temps de requête : 5.34 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.040 MB mémoire avant requête : 11.999 MB Rangées retournées : 1

    SELECT
        f.*,
    	fi.file_id AS _image_exists,
    	fi.filename AS `_filename`,
    	fi.sys_filename AS _sys_filename,
        fi.alt AS _alt,
        fi.width AS _width,
        fi.height AS _height,
        fi.size AS _size,
    
        u.name AS _user_name,
        p.name AS _category_name,
    	p.params AS params,
        (SELECT g.title 
      FROM `dm4t9_viewlevels` AS g 
      WHERE g.id = f.`access`) AS _group_name
    
        , (SELECT fl.address 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _address, (SELECT fl.longitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _longitude, (SELECT fl.latitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _latitude,'' AS _tags, (
      CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
        (SELECT SUM(v.value) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _rating_sum,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.ipaddr = 308349357) AS _is_ip_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.user_id = 0) AS _is_user_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value < 0) AS _negative_rating_count,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _positive_rating_count,
    	EXISTS(SELECT * 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id) AS _video_exists,
    	(SELECT fv.`sys_filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_sys_filename,
    	(SELECT fv.`filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_filename,
    	(SELECT fv.`media` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_media,
    	(SELECT fv.`code` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_code,
    	(SELECT fv.`width` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_width,
    	(SELECT fv.`height` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_height,
    	(SELECT fv.`duration` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_duration,
    	(SELECT fv.`size` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1	) AS _video_size,
    	EXISTS(SELECT * 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id) AS _audio_exists,
    	(SELECT fau.`sys_filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_sys_filename,
    	(SELECT fau.`filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_filename,
    	(SELECT fau.`duration` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_duration,
    	(SELECT fau.`size` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_size
    
      FROM
        `dm4t9_fwsg_file` AS f
        
      LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
      ON fi.file_id = f.id
        
      LEFT JOIN `dm4t9_fwsg_category` AS p 
      ON f.category_id = p.id
        
      LEFT JOIN `dm4t9_users` AS u 
      ON u.id = f.user_id
    
      WHERE
        f.id = 5166

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	f	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	fi	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    24	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    23	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    22	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    21	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    20	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    19	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    18	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    17	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    16	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    15	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    14	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    13	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    12	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    11	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    10	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
    9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
    8	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
    7	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	const	1	100.00	Using where
    6	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
    5	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    4	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    3	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	DEPENDENT SUBQUERY	g	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	3.33 ms
    init	0.10 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.05 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.05 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_fwgallery/tables/file.php:86
    11	TableFile->load()	JROOT/components/com_fwgallery/models/item.php:62
    10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

13. Temps de requête : 2.85 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.029 MB mémoire avant requête : 12.030 MB Rangées retournées : 0

    SELECT DISTINCT
        t.id,
    	t.published,
        t.name,
    	t.alias
    
      FROM
        `dm4t9_fwsg_file_tag` AS ft,
        `dm4t9_fwsg_tag` AS t
    
      WHERE
        t.id = ft.tag_id
    	
      AND t.published = 1
        
      AND
        ft.file_id = 5166
    
      ORDER BY
        t.name

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ft	ref	file_id,tag_id	file_id	4	const	1	100.00	Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	t	eq_ref	PRIMARY,published	PRIMARY	4	bxv_canoeclubgenevech13_2.ft.tag_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	2.27 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.02 ms
    end	0.02 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/tag/tag.php:534
    15	plgFwGalleryTag->oncalculateFileExtraFields()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_fwgallery/tables/file.php:98
    11	TableFile->load()	JROOT/components/com_fwgallery/models/item.php:62
    10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

14. Temps de requête : 0.56 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.008 MB mémoire avant requête : 12.031 MB

    UPDATE dm4t9_fwsg_file
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '5166'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_fwsg_file	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.03 ms
    updating	0.04 ms
    end	0.01 ms
    query end	0.26 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    11	Joomla\CMS\Table\Table->hit()	JROOT/components/com_fwgallery/models/item.php:63
    10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

15. Temps de requête : 1.36 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.036 MB mémoire avant requête : 12.082 MB Rangées retournées : 22

    SHOW FULL COLUMNS 
      FROM `dm4t9_fwsg_category`

    Explication

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

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.44 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.20 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_fwgallery/tables/category.php:47
    12	TableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_fwgallery/models/item.php:47
    10	fwGalleryModelItem->loadCategory()	JROOT/components/com_fwgallery/views/item/view.html.php:36
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

16. Temps de requête : 116.57 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.137 MB Rangées retournées : 1

    SELECT
        c.*,
    	(SELECT u.name 
      FROM `dm4t9_users` AS u 
      WHERE u.id = c.user_id 
      LIMIT 1) AS _user_name,
    	(SELECT COUNT(*) 
      FROM `dm4t9_fwsg_category` AS cc 
      WHERE cc.parent = c.id 
      AND cc.published = 1) AS _qty,
    	(SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file` AS f 
      WHERE (f.type = 'image' 
      AND f.published = 1 
      AND f.category_id = c.id)  OR (f.type = 'image' 
      AND f.published = 1 
      AND EXISTS(SELECT * 
      FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.tag_id = ft.tag_id 
      AND ct.category_id = c.id 
      AND ft.file_id = f.id))) AS _images_qty
        ,'' AS _tags,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_category_tag` AS ft, `dm4t9_fwsg_tag` AS t 
      WHERE t.id = ft.tag_id 
      AND ft.category_id =  c.id) AS _tags_qty,(SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file` AS f 
      WHERE (f.category_id = c.id 
      AND f.`type` = 'video' 
      AND f.published = 1) OR (f.type = 'video' 
      AND f.published = 1 
      AND EXISTS(SELECT * 
      FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.tag_id = ft.tag_id 
      AND ct.category_id = c.id 
      AND ft.file_id = f.id))) AS _videos_qty,(SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file` AS f 
      WHERE (f.category_id = c.id 
      AND f.`type` = 'audio' 
      AND f.published = 1) OR (f.type = 'audio' 
      AND f.published = 1 
      AND EXISTS(SELECT * 
      FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.tag_id = ft.tag_id 
      AND ct.category_id = c.id 
      AND ft.file_id = f.id))) AS _audios_qty
    
      FROM
        `dm4t9_fwsg_category` AS c
    
      WHERE
        c.id = 155

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
    9	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	1	100.00	Using index condition; Using where
    10	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    10	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    7	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	74	100.00	Using index condition; Using where
    8	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    8	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    6	DEPENDENT SUBQUERY	ft	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    6	DEPENDENT SUBQUERY	t	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.ft.tag_id	1	100.00	Using index
    4	DEPENDENT SUBQUERY	f	ALL	type,published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8333	75.00	Using where
    5	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    5	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    3	DEPENDENT SUBQUERY	cc	ref	published,parent	parent	4	const	1	100.00	Using where
    2	DEPENDENT SUBQUERY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.03 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_fwgallery/tables/category.php:68
    11	TableCategory->load()	JROOT/components/com_fwgallery/models/item.php:49
    10	fwGalleryModelItem->loadCategory()	JROOT/components/com_fwgallery/views/item/view.html.php:36
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

17. Temps de requête : 4.08 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.385 MB mémoire avant requête : 12.152 MB Rangées retournées : 215

    SELECT
        c.id,
    	c.parent,
    	c.published,
    	c.name,
    	c.params
    
      FROM
        `dm4t9_fwsg_category` AS c
    
      ORDER BY
        `parent`,
        ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	224	100.00	Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	2.20 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 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/components/com_fwgallery/helpers/helper.php:997
    11	fwgHelper::loadCategories()	JROOT/components/com_fwgallery/helpers/helper.php:1342
    10	fwgHelper::getParentGalleries()	JROOT/components/com_fwgallery/views/item/view.html.php:56
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

18. Temps de requête : 15.61 ms Après la dernière requête : 7.69 ms Mémoire de requête : 2.093 MB mémoire avant requête : 13.917 MB Rangées retournées : 8451

    SELECT
    	f.id,
    	f.name,
    	f.alias,
    	f.category_id,
    	c.name AS _cat_name,
    	c.alias AS _cat_alias
    
      FROM
    	`dm4t9_fwsg_file` AS f
    	
      LEFT JOIN `dm4t9_fwsg_category` AS c 
      ON f.category_id = c.id

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	f	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8333	100.00	NULL
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	14.82 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:477
    27	plgFwGallerySeoBooster->getImageData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:289
    26	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
    25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
    22	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    15	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    14	fwgHelper::route()	JROOT/plugins/fwgallery/social/social.php:101
    13	plgFwGallerySocial->onbeforeFileDisplay()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/views/item/view.html.php:57
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

19. Temps de requête : 1.95 ms Après la dernière requête : 14.76 ms Mémoire de requête : 0.035 MB mémoire avant requête : 22.814 MB Rangées retournées : 40

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `dm4t9_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_eventbooking','com_finder','com_fwgallery','com_installer','com_jfbconnect','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_p8pbb','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_visforms','com_weblinks','com_wrapper')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	345	11.88	Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.20 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	1.03 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_fwgallery/models/item.php:87
    11	fwGalleryModelItem->_getFilesWhere()	JROOT/components/com_fwgallery/models/item.php:209
    10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

20. Temps de requête : 0.84 ms Après la dernière requête : 2.20 ms Mémoire de requête : 0.033 MB mémoire avant requête : 23.080 MB Rangées retournées : 19

    SELECT
        `element`,
        `enabled`,
    	`folder`
    
      FROM
        `dm4t9_extensions`
    
      WHERE
        `type` = 'plugin'
        
      AND
        `folder` IN ('fwgallery', 'fwgallerytype', 'fwgallerytmpl')

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_extensions	ref	extension	extension	82	const	180	100.00	Using index condition

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.31 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.06 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/components/com_fwgallery/helpers/helper.php:1534
    18	fwgHelper::loadPlugins()	JROOT/components/com_fwgallery/helpers/helper.php:1550
    17	fwgHelper::pluginEnabled()	JROOT/plugins/fwgallery/featured/featured.php:83
    16	plgFwGalleryFeatured->ongetFilesListExtraOrdering()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/models/fwgallery.php:252
    12	fwGalleryModelFwGallery->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/item.php:111
    11	fwGalleryModelItem->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/item.php:210
    10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

21. Temps de requête : 145.43 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.048 MB mémoire avant requête : 23.107 MB Rangées retournées : 32

    SELECT
        f.id
        , (SELECT fl.address 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _address, (SELECT fl.longitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _longitude, (SELECT fl.latitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _latitude,'' AS _tags, (
      CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
        (SELECT SUM(v.value) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _rating_sum,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.ipaddr = 308349357) AS _is_ip_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.user_id = 0) AS _is_user_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value < 0) AS _negative_rating_count,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _positive_rating_count,
    	EXISTS(SELECT * 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id) AS _video_exists,
    	(SELECT fv.`sys_filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_sys_filename,
    	(SELECT fv.`filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_filename,
    	(SELECT fv.`media` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_media,
    	(SELECT fv.`code` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_code,
    	(SELECT fv.`width` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_width,
    	(SELECT fv.`height` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_height,
    	(SELECT fv.`duration` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_duration,
    	(SELECT fv.`size` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1	) AS _video_size,
    	EXISTS(SELECT * 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id) AS _audio_exists,
    	(SELECT fau.`sys_filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_sys_filename,
    	(SELECT fau.`filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_filename,
    	(SELECT fau.`duration` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_duration,
    	(SELECT fau.`size` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_size
    
      FROM
        `dm4t9_fwsg_file` AS f
        
      LEFT JOIN `dm4t9_viewlevels` AS fa 
      ON fa.id = f.`access`
        
      LEFT JOIN `dm4t9_fwsg_category` AS c 
      ON c.id = f.category_id
        
      LEFT JOIN `dm4t9_viewlevels` AS ca 
      ON ca.id = c.`access`
        
      LEFT JOIN `dm4t9_users` AS u 
      ON u.id = f.user_id
        
      LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
      ON fi.file_id = f.id
        
    	
      LEFT JOIN dm4t9_fwsg_file_video AS fv 
      ON fv.file_id = f.id
    	
      LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
      ON fau.file_id = f.id
    
      WHERE f.published = 1 
      AND c.published = 1 
      AND f.`type` IN ('image','video','audio') 
      AND (c.`access` = 0 OR c.access IN (1,3)) 
      AND (f.`access` = 0 OR f.access IN (1,3)) 
      AND (f.category_id = 155 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (155) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))
    
      ORDER BY _tags_orderng,f.featured DESC, f.ordering

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8333	75.00	Using where; Utilisation du tri complet de type filesort
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
    6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.02 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/components/com_fwgallery/models/item.php:212
    10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

22. Temps de requête : 135.99 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.063 MB mémoire avant requête : 23.119 MB Rangées retournées : 30

    SELECT
        f.*,
        fi.alt AS _alt,
        fi.width AS _width,
        fi.height AS _height,
        fi.size AS _size,
    	fi.sys_filename AS _sys_filename,
        c.name AS _category_name,
        u.name AS _user_name
        , (SELECT fl.address 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _address, (SELECT fl.longitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _longitude, (SELECT fl.latitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _latitude,'' AS _tags, (
      CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
        (SELECT SUM(v.value) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _rating_sum,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.ipaddr = 308349357) AS _is_ip_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.user_id = 0) AS _is_user_voted,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value < 0) AS _negative_rating_count,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _positive_rating_count,
    	EXISTS(SELECT * 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id) AS _video_exists,
    	(SELECT fv.`sys_filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_sys_filename,
    	(SELECT fv.`filename` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_filename,
    	(SELECT fv.`media` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_media,
    	(SELECT fv.`code` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_code,
    	(SELECT fv.`width` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_width,
    	(SELECT fv.`height` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_height,
    	(SELECT fv.`duration` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1) AS _video_duration,
    	(SELECT fv.`size` 
      FROM dm4t9_fwsg_file_video AS fv 
      WHERE fv.file_id = f.id 
      LIMIT 1	) AS _video_size,
    	EXISTS(SELECT * 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id) AS _audio_exists,
    	(SELECT fau.`sys_filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_sys_filename,
    	(SELECT fau.`filename` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_filename,
    	(SELECT fau.`duration` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_duration,
    	(SELECT fau.`size` 
      FROM `dm4t9_fwsg_file_audio` AS fau 
      WHERE fau.file_id = f.id 
      LIMIT 1) AS _audio_size
    
      FROM
        `dm4t9_fwsg_file` AS f
        
      LEFT JOIN `dm4t9_viewlevels` AS fa 
      ON fa.id = f.`access`
        
      LEFT JOIN `dm4t9_fwsg_category` AS c 
      ON c.id = f.category_id
        
      LEFT JOIN `dm4t9_viewlevels` AS ca 
      ON ca.id = c.`access`
        
      LEFT JOIN `dm4t9_users` AS u 
      ON u.id = f.user_id
        
      LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
      ON fi.file_id = f.id
        
    	
      LEFT JOIN dm4t9_fwsg_file_video AS fv 
      ON fv.file_id = f.id
    	
      LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
      ON fau.file_id = f.id
    
      WHERE f.published = 1 
      AND c.published = 1 
      AND f.`type` IN ('image','video','audio') 
      AND (c.`access` = 0 OR c.access IN (1,3)) 
      AND (f.`access` = 0 OR f.access IN (1,3)) 
      AND (f.category_id = 155 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (155) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))
    
      ORDER BY _tags_orderng,f.featured DESC, f.ordering 
      LIMIT 2, 30

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8333	75.00	Using where; Utilisation du tri complet de type filesort
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
    6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/item.php:145
    10	fwGalleryModelItem->loadFiles()	JROOT/components/com_fwgallery/views/item/view.html.php:67
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

23. Temps de requête : 0.76 ms Après la dernière requête : 0.38 ms Mémoire de requête : 0.029 MB mémoire avant requête : 23.399 MB Rangées retournées : 0

    SELECT DISTINCT
        t.id,
        t.name,
    	t.alias,
    	t.published,
        t.ordering,
        ft.file_id
    
      FROM
        `dm4t9_fwsg_file` AS f,
        `dm4t9_fwsg_file_tag` AS ft,
        `dm4t9_fwsg_tag` AS t
    
      WHERE
        t.id = ft.tag_id
        
      AND t.published = 1
        
      AND
        f.id = ft.file_id
        
      AND
        ft.file_id IN (5149,5150,5151,5152,5153,5154,5155,5156,5157,5158,5159,5160,5161,5162,5163,5164,5165,5166,5167,5168,5169,5170,5171,5172,5173,5174,5175,5176,5177,5178)
    
      ORDER BY
        t.name

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	ref	PRIMARY,published	published	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
    1	SIMPLE	ft	ref	file_id,tag_id	tag_id	4	bxv_canoeclubgenevech13_2.t.id	1	100.00	Using where
    1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.ft.file_id	1	100.00	Using index; Distinct

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.06 ms
    statistics	0.14 ms
    preparing	0.02 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    removing tmp table	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.04 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/plugins/fwgallery/tag/tag.php:498
    14	plgFwGalleryTag->oncalculateFileListExtraFields()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/models/item.php:150
    10	fwGalleryModelItem->loadFiles()	JROOT/components/com_fwgallery/views/item/view.html.php:67
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

24. Temps de requête : 124.76 ms Après la dernière requête : 1.92 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.490 MB Rangées retournées : 1

    SELECT
        COUNT(*)
    
      FROM
        `dm4t9_fwsg_file` AS f
        
      LEFT JOIN `dm4t9_viewlevels` AS fa 
      ON fa.id = f.`access`
    
        
      LEFT JOIN `dm4t9_fwsg_category` AS c 
      ON c.id = f.category_id
        
      LEFT JOIN `dm4t9_viewlevels` AS ca 
      ON ca.id = c.`access`
    
        
      LEFT JOIN `dm4t9_users` AS u 
      ON u.id = f.user_id
        
      LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
      ON fi.file_id = f.id
        
    	
      LEFT JOIN dm4t9_fwsg_file_video AS fv 
      ON fv.file_id = f.id
    	
      LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
      ON fau.file_id = f.id
    
    
      WHERE f.published = 1 
      AND c.published = 1 
      AND f.`type` IN ('image','video','audio') 
      AND (c.`access` = 0 OR c.access IN (1,3)) 
      AND (f.`access` = 0 OR f.access IN (1,3)) 
      AND (f.category_id = 155 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (155) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8333	75.00	Using where
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    2	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    2	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/item.php:175
    11	fwGalleryModelItem->loadFilesQty()	JROOT/components/com_fwgallery/models/item.php:180
    10	fwGalleryModelItem->getFilesPagination()	JROOT/components/com_fwgallery/views/item/view.html.php:69
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

25. Temps de requête : 2.20 ms Après la dernière requête : 3.61 ms Mémoire de requête : 0.038 MB mémoire avant requête : 23.612 MB Rangées retournées : 0
    Requêtes dupliquées: #30

    SELECT mm.menuid, m.params, e.element 
      FROM `dm4t9_modules` AS m, `dm4t9_modules_menu` AS mm, `dm4t9_menu` AS me, `dm4t9_extensions` AS e 
      WHERE e.extension_id = me.component_id 
      AND me.published = 1 
      AND me.id = mm.menuid 
      AND mm.moduleid = m.id 
      AND m.published = 1 
      AND m.module = 'mod_fwgallery'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	newsfeeds	204	const,const	1	100.00	Using index condition
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.m.id	1	100.00	Using index
    1	SIMPLE	me	eq_ref	PRIMARY,idx_componentid	PRIMARY	4	bxv_canoeclubgenevech13_2.mm.menuid	1	100.00	Using where
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.me.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	1.60 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:208
    30	plgFwGallerySeoBooster->getItemId()	JROOT/plugins/fwgallery/seobooster/seobooster.php:238
    29	plgFwGallerySeoBooster->ongetRouteItemId()	JROOT/libraries/joomla/event/event.php:70
    28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:21
    25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

26. Temps de requête : 0.77 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.062 MB mémoire avant requête : 23.633 MB Rangées retournées : 215

    SELECT
    	c.id,
    	c.name,
    	c.alias
    
      FROM
    	`dm4t9_fwsg_category` AS c

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	224	100.00	NULL

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.29 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:456
    30	plgFwGallerySeoBooster->getCategoryData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:350
    29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
    28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
    25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

27. Temps de requête : 0.28 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.780 MB Rangées retournées : 1

    SELECT id, parent, name 
      FROM `dm4t9_fwsg_category` 
      WHERE id = 155

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_fwsg_category	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
    29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
    28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
    25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

28. Temps de requête : 0.31 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.801 MB Rangées retournées : 1

    SELECT id, parent, name 
      FROM `dm4t9_fwsg_category` 
      WHERE id = 5

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_fwsg_category	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
    29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
    28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
    25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

29. Temps de requête : 0.24 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.038 MB mémoire avant requête : 23.822 MB Rangées retournées : 0

    SELECT id, parent, name 
      FROM `dm4t9_fwsg_category` 
      WHERE id = 0

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
    29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
    28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
    25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

30. Temps de requête : 0.47 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.043 MB mémoire avant requête : 23.875 MB Rangées retournées : 0
    Requêtes dupliquées: #25

    SELECT mm.menuid, m.params, e.element 
      FROM `dm4t9_modules` AS m, `dm4t9_modules_menu` AS mm, `dm4t9_menu` AS me, `dm4t9_extensions` AS e 
      WHERE e.extension_id = me.component_id 
      AND me.published = 1 
      AND me.id = mm.menuid 
      AND mm.moduleid = m.id 
      AND m.published = 1 
      AND m.module = 'mod_fwgallery'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	newsfeeds	204	const,const	1	100.00	Using index condition
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.m.id	1	100.00	Using index
    1	SIMPLE	me	eq_ref	PRIMARY,idx_componentid	PRIMARY	4	bxv_canoeclubgenevech13_2.mm.menuid	1	100.00	Using where
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.me.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    37	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:208
    36	plgFwGallerySeoBooster->getItemId()	JROOT/plugins/fwgallery/seobooster/seobooster.php:238
    35	plgFwGallerySeoBooster->ongetRouteItemId()	JROOT/libraries/joomla/event/event.php:70
    34	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    33	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    32	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:21
    31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
    23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/plugins/social/awesome.php:19
    22	include JROOT/plugins/fwgallerytmpl/classic/plugins/social/awesome.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallery/social/social.php:92
    20	plgFwGallerySocial->onshowFileExtraFields()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:63
    16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
    14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
    13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
    12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
    6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

31. Temps de requête : 1.34 ms Après la dernière requête : 10.02 ms Mémoire de requête : 0.029 MB mémoire avant requête : 24.444 MB Rangées retournées : 3

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM dm4t9_modules AS m
    
      LEFT JOIN dm4t9_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN dm4t9_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-03-24 03:00:56') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-03-24 03:00:56') 
      AND m.access IN (1,3) 
      AND m.client_id = 0 
      AND (mm.menuid = 0 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explication

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

    Profil

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.05 ms
    statistics	0.09 ms
    preparing	0.06 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.55 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/joomspirit_76/index.php:107
    7	require JROOT/templates/joomspirit_76/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

32. Temps de requête : 0.47 ms Après la dernière requête : 72.98 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.831 MB Rangées retournées : 0

    SELECT uikit
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/activites-club/paques-en-ardeche-2015/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-ardeche-anouk-2015-p4040025-custom-text-f5166'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_cwgears	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:417
    12	plgSystemCwgears->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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

33. Temps de requête : 0.43 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.028 MB mémoire avant requête : 24.847 MB Rangées retournées : 0

    SELECT uikit_plus
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/activites-club/paques-en-ardeche-2015/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-ardeche-anouk-2015-p4040025-custom-text-f5166'

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_cwgears	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:426
    12	plgSystemCwgears->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:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

34. Temps de requête : 0.29 ms Après la dernière requête : 4.87 ms Mémoire de requête : 0.006 MB mémoire avant requête : 25.040 MB

    LOCK TABLES `dm4t9_extensions` WRITE

    Explication

    EXPLAIN impossible sur la requête : LOCK TABLES `dm4t9_extensions` WRITE

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    System lock	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:551
    8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/ebreminder/ebreminder.php:43
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

35. Temps de requête : 0.91 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.005 MB mémoire avant requête : 25.047 MB

    UPDATE dm4t9_extensions
    
      SET params='{\"number_registrants\":\"15\",\"bcc_email\":\"\",\"last_run\":1742785256}'
    
      WHERE `element`="ebreminder" 
      AND `folder`="system"

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_extensions	range	element_clientid,element_folder_clientid	element_clientid	402	const	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.12 ms
    updating	0.12 ms
    end	0.02 ms
    query end	0.38 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ebreminder/ebreminder.php:54
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

36. Temps de requête : 0.20 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.006 MB mémoire avant requête : 25.055 MB

    UNLOCK TABLES

    Explication

    EXPLAIN impossible sur la requête : UNLOCK TABLES

    Profil

    Status	Duration
    starting	0.02 ms
    query end	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:926
    8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/ebreminder/ebreminder.php:66
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

37. Temps de requête : 2.36 ms Après la dernière requête : 3.84 ms Mémoire de requête : 0.043 MB mémoire avant requête : 25.522 MB Rangées retournées : 173

    SELECT `config_key`,`config_value`
    
      FROM dm4t9_eb_configs

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_eb_configs	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	173	100.00	NULL

    Profil

    Status	Duration
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	1.65 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	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/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
    10	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:95
    9	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:61
    8	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/plugins/system/ebreminder/ebreminder.php:80
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

38. Temps de requête : 1.98 ms Après la dernière requête : 3.00 ms Mémoire de requête : 0.029 MB mémoire avant requête : 25.810 MB Rangées retournées : 48

    SELECT `message_key`,`message`
    
      FROM dm4t9_eb_messages

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	dm4t9_eb_messages	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	48	100.00	NULL

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	1.28 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.03 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/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
    10	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:296
    9	EventbookingHelper::getMessages()	JROOT/components/com_eventbooking/helper/mail.php:1369
    8	EventbookingHelperMail::sendReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:83
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

39. Temps de requête : 7.03 ms Après la dernière requête : 8.06 ms Mémoire de requête : 0.046 MB mémoire avant requête : 26.592 MB Rangées retournées : 0

    SELECT a.*, c.id AS location_id, c.name AS location_name, c.address as location_address,b.id as event_id,b.event_date,b.title,b.reminder_email_body
    
      FROM dm4t9_eb_registrants AS a
    
      INNER JOIN dm4t9_eb_events AS b 
      ON a.event_id = b.id
    
      LEFT JOIN dm4t9_eb_locations AS c 
      ON b.location_id = c.id
    
      WHERE (a.published = 1 OR (a.payment_method LIKE "os_offline%" 
      AND a.published = 0)) 
      AND a.is_reminder_sent = 0 
      AND b.send_first_reminder != 0 
      AND IF(b.send_first_reminder > 0, b.send_first_reminder >= DATEDIFF(b.event_date, NOW()) 
      AND DATEDIFF(b.event_date, NOW()) >= 0, DATEDIFF(NOW(), b.event_date) >= ABS(b.send_first_reminder) 
      AND DATEDIFF(NOW(), b.event_date) <= 40) 
      AND b.published = 1
    
      ORDER BY b.event_date, a.register_date 
      LIMIT 15

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	6.24 ms
    init	0.12 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.04 ms
    executing	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/mail.php:1445
    8	EventbookingHelperMail::sendReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:83
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---

40. Temps de requête : 0.92 ms Après la dernière requête : 0.89 ms Mémoire de requête : 0.046 MB mémoire avant requête : 26.625 MB Rangées retournées : 0

    SELECT a.*, c.id AS location_id, c.name AS location_name, c.address AS location_address,b.id as event_id,b.event_date,b.title,b.second_reminder_email_body
    
      FROM dm4t9_eb_registrants AS a
    
      INNER JOIN dm4t9_eb_events AS b 
      ON a.event_id = b.id
    
      LEFT JOIN dm4t9_eb_locations AS c 
      ON b.location_id = c.id
    
      WHERE (a.published = 1 OR (a.payment_method LIKE "os_offline%" 
      AND a.published = 0)) 
      AND a.is_second_reminder_sent = 0 
      AND b.send_second_reminder != 0 
      AND IF(b.send_second_reminder > 0, b.send_second_reminder >= DATEDIFF(b.event_date, NOW()) 
      AND DATEDIFF(b.event_date, NOW()) >= 0, DATEDIFF(NOW(), b.event_date) >= ABS(b.send_second_reminder) 
      AND DATEDIFF(NOW(), b.event_date) <= 40) 
      AND b.published = 1
    
      ORDER BY b.event_date, a.register_date 
      LIMIT 15

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profil

    Status	Duration
    starting	0.14 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.11 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/mail.php:1647
    8	EventbookingHelperMail::sendSecondReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:86
    7	plgSystemEBReminder->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: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:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:50

    [Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

    ---