{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1728087624,
                "last": 1728087624,
                "now": 1728087624
            },
            "token": "DrDeydz2rXX7PH3AR0ACs7ysvJh4rxMa"
        },
        "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

35 requêtes exécutées 399.74 ms

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

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

   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.04 ms
   checking permissions	0.01 ms
   Opening tables	0.03 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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

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

   SELECT `session_id`
   
     FROM `dm4t9_session`
   
     WHERE `session_id` = X'3962376131303161643933303334636663323363336264333337356238613163' 
     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.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.02 ms
   freeing items	0.02 ms
   cleaning up	0.01 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:46

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

   ---

3. Temps de requête : 0.59 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.983 MB

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

   Explication

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

   Profil

   Status	Duration
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.02 ms
   update	0.11 ms
   end	0.01 ms
   query end	0.22 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
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Temps de requête : 1.19 ms Après la dernière requête : 6.84 ms Mémoire de requête : 0.108 MB mémoire avant requête : 4.272 MB Rangées retournées : 40

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `dm4t9_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explication

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

   Profil

   Status	Duration
   starting	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.02 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.01 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/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Temps de requête : 0.42 ms Après la dernière requête : 2.75 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.558 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.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.02 ms
   query end	0.01 ms
   closing tables	0.01 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:49

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

   ---

6. Temps de requête : 0.44 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.573 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.05 ms
   checking permissions	0.01 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.08 ms
   preparing	0.01 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
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Temps de requête : 1.03 ms Après la dernière requête : 15.01 ms Mémoire de requête : 0.065 MB mémoire avant requête : 6.005 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	144	100.00	NULL

   Profil

   Status	Duration
   starting	0.09 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.01 ms
   preparing	0.02 ms
   executing	0.02 ms
   Sending data	0.35 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
   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:49

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

   ---

8. Temps de requête : 0.48 ms Après la dernière requête : 26.33 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.717 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.04 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.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
   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:49

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

   ---

9. Temps de requête : 0.30 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.725 MB Rangées retournées : 1

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

   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.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.00 ms
   Sending data	0.02 ms
   end	0.01 ms
   query end	0.02 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
   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:49

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

   ---

10. Temps de requête : 1.63 ms Après la dernière requête : 4.83 ms Mémoire de requête : 0.073 MB mémoire avant requête : 7.980 MB Rangées retournées : 50

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM dm4t9_menu AS m
    
      LEFT JOIN dm4t9_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	112	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.m.component_id	1	100.00	Using where

    Profil

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.80 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Temps de requête : 0.60 ms Après la dernière requête : 38.74 ms Mémoire de requête : 0.030 MB mémoire avant requête : 11.241 MB Rangées retournées : 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `dm4t9_extensions`
    
      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	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

    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.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/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:49

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

    ---

12. Temps de requête : 0.80 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.236 MB

    UPDATE `dm4t9_extensions`
    
      SET `params` = '{\"mediaversion\":\"ba1626e3d644b7090a2adf52b99e25b6\"}'
    
      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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.15 ms
    end	0.01 ms
    query end	0.28 ms
    closing tables	0.02 ms
    freeing items	0.02 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:49

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

    ---

13. Temps de requête : 0.32 ms Après la dernière requête : 2.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.412 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.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.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.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:49

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

    ---

14. Temps de requête : 3.52 ms Après la dernière requête : 1.12 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.504 MB Rangées retournées : 9

    SELECT id, home, template, s.params
    
      FROM dm4t9_template_styles as s
    
      LEFT JOIN dm4t9_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explication

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	12	75.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	bxv_canoeclubgenevech13_2.s.template,const	1	100.00	Using index condition; Using where

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	2.92 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.09 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
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Temps de requête : 0.95 ms Après la dernière requête : 5.51 ms Mémoire de requête : 0.035 MB mémoire avant requête : 11.848 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	0.21 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 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.03 ms
    checking permissions	0.02 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
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.04 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:24
    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:49

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

    ---

16. Temps de requête : 2.36 ms Après la dernière requête : 0.76 ms Mémoire de requête : 0.040 MB mémoire avant requête : 11.918 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 = 752781050) 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 = 7153

    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.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.52 ms
    init	0.12 ms
    System lock	0.04 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 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.00 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.02 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.01 ms
    executing	0.02 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.00 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.03 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 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/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:24
    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:49

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

    ---

17. Temps de requête : 0.44 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.030 MB mémoire avant requête : 11.951 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 = 7153
    
      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.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.02 ms
    end	0.02 ms
    removing tmp table	0.01 ms
    end	0.00 ms
    query end	0.01 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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/tag/tag.php:519
    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:24
    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:49

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

    ---

18. Temps de requête : 0.56 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.008 MB mémoire avant requête : 11.953 MB

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

    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.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.03 ms
    updating	0.07 ms
    end	0.02 ms
    query end	0.22 ms
    closing tables	0.01 ms
    freeing items	0.04 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:24
    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:49

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

    ---

19. Temps de requête : 1.23 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.036 MB mémoire avant requête : 12.004 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.03 ms
    checking permissions	0.01 ms
    checking permissions	0.05 ms
    Opening tables	0.16 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.03 ms
    Opening tables	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	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.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.06 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.02 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.10 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:24
    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:49

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

    ---

20. Temps de requête : 84.66 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.058 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 = 230

    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	73	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	8404	98.36	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.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.04 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:24
    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:49

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

    ---

21. Temps de requête : 3.74 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.381 MB mémoire avant requête : 12.072 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	207	100.00	Utilisation du tri complet de type filesort

    Profil

    Status	Duration
    starting	0.06 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
    Sorting result	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	1.59 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 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:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:960
    11	fwgHelper::loadCategories()	JROOT/components/com_fwgallery/helpers/helper.php:1299
    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:24
    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:49

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

    ---

22. Temps de requête : 13.61 ms Après la dernière requête : 9.03 ms Mémoire de requête : 2.056 MB mémoire avant requête : 13.781 MB Rangées retournées : 8340

    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	8404	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.05 ms
    checking permissions	0.01 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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	12.61 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.01 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:478
    27	plgFwGallerySeoBooster->getImageData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:290
    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:593
    14	fwgHelper::route()	JROOT/plugins/fwgallery/social/social.php:102
    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:24
    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:49

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

    ---

23. Temps de requête : 2.04 ms Après la dernière requête : 27.44 ms Mémoire de requête : 0.035 MB mémoire avant requête : 22.562 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	414	9.90	Using where

    Profil

    Status	Duration
    starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.21 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	1.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 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:24
    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:49

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

    ---

24. Temps de requête : 0.82 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.033 MB mémoire avant requête : 22.828 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.05 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.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.32 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:1491
    18	fwgHelper::loadPlugins()	JROOT/components/com_fwgallery/helpers/helper.php:1507
    17	fwgHelper::pluginEnabled()	JROOT/plugins/fwgallery/featured/featured.php:84
    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:254
    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:24
    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:49

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

    ---

25. Temps de requête : 93.38 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.032 MB mémoire avant requête : 22.855 MB Rangées retournées : 2

    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 = 752781050) 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 = 230 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (230) 
      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	8404	99.17	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
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 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.06 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:24
    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:49

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

    ---

26. Temps de requête : 91.84 ms Après la dernière requête : 0.40 ms Mémoire de requête : 0.040 MB mémoire avant requête : 22.867 MB Rangées retournées : 2

    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 = 752781050) 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 = 230 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (230) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))
    
      ORDER BY _tags_orderng,f.featured DESC, f.ordering 
      LIMIT 0, 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	8404	99.17	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
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.02 ms
    statistics	0.01 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 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:24
    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:49

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

    ---

27. Temps de requête : 0.53 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.029 MB mémoire avant requête : 22.893 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 (7153,7154)
    
      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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.00 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.05 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    executing	0.00 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.02 ms
    cleaning up	0.01 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:483
    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:24
    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:49

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

    ---

28. Temps de requête : 88.49 ms Après la dernière requête : 2.24 ms Mémoire de requête : 0.026 MB mémoire avant requête : 22.986 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 = 230 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (230) 
      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	8404	99.17	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.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 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: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:24
    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:49

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

    ---

29. Temps de requête : 0.79 ms Après la dernière requête : 6.30 ms Mémoire de requête : 0.062 MB mémoire avant requête : 23.101 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	207	100.00	NULL

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.02 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.28 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 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:457
    30	plgFwGallerySeoBooster->getCategoryData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:351
    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:593
    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:1433
    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:1433
    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:24
    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:49

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

    ---

30. Temps de requête : 0.27 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.248 MB Rangées retournées : 1

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

    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.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.04 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:1095
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
    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:593
    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:1433
    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:1433
    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:24
    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:49

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

    ---

31. Temps de requête : 0.26 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.269 MB Rangées retournées : 1

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

    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.02 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 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:1095
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
    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:593
    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:1433
    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:1433
    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:24
    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:49

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

    ---

32. Temps de requête : 0.33 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.038 MB mémoire avant requête : 23.290 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.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
    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.03 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:1095
    30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
    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:593
    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:1433
    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:1433
    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:24
    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:49

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

    ---

33. Temps de requête : 0.67 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.044 MB mémoire avant requête : 23.349 MB Rangées retournées : 0

    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.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.03 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.11 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
    38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    37	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:209
    36	plgFwGallerySeoBooster->getItemId()	JROOT/plugins/fwgallery/seobooster/seobooster.php:239
    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:593
    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:1433
    21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallery/social/social.php:93
    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:1433
    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:1433
    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:24
    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:49

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

    ---

34. Temps de requête : 0.40 ms Après la dernière requête : 25.32 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.023 MB Rangées retournées : 0

    SELECT uikit
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/ecole-de-la-pagaie-jeunes/slalom-de-bienne-2019/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-slalom-de-bienne-24-25-08-2019-capture-custom-text-f7153?files_order=ordering&Itemid=1065'

    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.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.03 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:49

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

    ---

35. Temps de requête : 0.34 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.033 MB Rangées retournées : 0

    SELECT uikit_plus
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/ecole-de-la-pagaie-jeunes/slalom-de-bienne-2019/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-slalom-de-bienne-24-25-08-2019-capture-custom-text-f7153?files_order=ordering&Itemid=1065'

    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.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.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
    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:49

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

    ---