{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1722067379,
                "last": 1722067389,
                "now": 1722067400
            },
            "token": "1l2hoPETySa1Woi2SQrGSYKaBBlGP6sz"
        },
        "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
        },
        "phpbb_page": "https://canoe-club-geneve.ch/forums/user/login?sid=1bcdd0718dc8643d8b629f13058f2e17",
        "phpbb_page_real": "https://canoe-club-geneve.ch/forumphpBB_3/ucp.php?sid=1bcdd0718dc8643d8b629f13058f2e17&mode=login",
        "phpbb_user": false
    }
}

Temps

Mémoire

36 requêtes exécutées 498.68 ms

1. Temps de requête : 0.46 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.872 MB Rangées retournées : 1

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

   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.02 ms
   init	0.02 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.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
   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.50 ms Après la dernière requête : 12.02 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.511 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.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 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.03 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
   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]

   ---

3. Temps de requête : 0.57 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.525 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.02 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.03 ms
   end	0.01 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
   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]

   ---

4. Temps de requête : 1.13 ms Après la dernière requête : 19.86 ms Mémoire de requête : 0.075 MB mémoire avant requête : 5.957 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	157	100.00	NULL

   Profil

   Status	Duration
   starting	0.03 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.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.36 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.01 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]

   ---

5. Temps de requête : 0.52 ms Après la dernière requête : 24.81 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.574 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.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.01 ms
   preparing	0.01 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
   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]

   ---

6. Temps de requête : 0.40 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.581 MB Rangées retournées : 1

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

   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.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.02 ms
   end	0.03 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
   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]

   ---

7. Temps de requête : 5.59 ms Après la dernière requête : 61.68 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.203 MB

   UPDATE `dm4t9_extensions`
   
     SET `params` = '{\"mediaversion\":\"036b7179cb3f710e3534f0402103fd75\"}'
   
     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.10 ms
   updating	0.05 ms
   end	4.93 ms
   query end	0.23 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Pile d'appels

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

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

   ---

8. Temps de requête : 0.33 ms Après la dernière requête : 3.24 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.394 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.01 ms
   System lock	0.01 ms
   optimizing	0.03 ms
   statistics	0.02 ms
   executing	0.01 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
   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]

   ---

9. Temps de requête : 1.05 ms Après la dernière requête : 7.59 ms Mémoire de requête : 0.035 MB mémoire avant requête : 11.827 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.18 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.03 ms
   Opening tables	0.03 ms
   checking permissions	0.02 ms
   checking permissions	0.02 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.03 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.02 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   removing tmp table	0.07 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/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]

   ---

10. Temps de requête : 2.25 ms Après la dernière requête : 0.96 ms Mémoire de requête : 0.040 MB mémoire avant requête : 11.897 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 = 309817498) 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 = 2355

    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.05 ms
    init	0.14 ms
    System lock	0.03 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.07 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.03 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    executing	0.01 ms
    optimizing	0.02 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.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.00 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.01 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.06 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/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]

    ---

11. Temps de requête : 0.44 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.928 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 = 2355
    
      ORDER BY
        t.name

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 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.01 ms
    removing tmp table	0.01 ms
    end	0.00 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
    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]

    ---

12. Temps de requête : 0.72 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.008 MB mémoire avant requête : 11.929 MB

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

    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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.05 ms
    updating	0.04 ms
    end	0.01 ms
    query end	0.32 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/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]

    ---

13. Temps de requête : 1.07 ms Après la dernière requête : 1.20 ms Mémoire de requête : 0.036 MB mémoire avant requête : 11.980 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.01 ms
    Opening tables	0.17 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.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.04 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    removing tmp table	0.07 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
    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]

    ---

14. Temps de requête : 94.06 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.035 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 = 104

    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	8208	75.00	Using where
    5	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    5	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    3	DEPENDENT SUBQUERY	cc	ref	published,parent	parent	4	const	1	100.00	Using where
    2	DEPENDENT SUBQUERY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profil

    Status	Duration
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.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.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.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.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.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.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.02 ms
    statistics	0.06 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.02 ms
    freeing items	0.08 ms
    cleaning up	0.05 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_fwgallery/tables/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]

    ---

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	2.82 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php: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]

    ---

16. Temps de requête : 12.42 ms Après la dernière requête : 7.24 ms Mémoire de requête : 2.056 MB mémoire avant requête : 13.757 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	8208	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.07 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.01 ms
    Sending data	11.68 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
    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]

    ---

17. Temps de requête : 2.15 ms Après la dernière requête : 24.02 ms Mémoire de requête : 0.035 MB mémoire avant requête : 22.540 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	358	11.45	Using where

    Profil

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.20 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	1.26 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
    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]

    ---

18. Temps de requête : 0.83 ms Après la dernière requête : 2.24 ms Mémoire de requête : 0.033 MB mémoire avant requête : 22.736 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.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.39 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
    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]

    ---

19. Temps de requête : 138.95 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.107 MB mémoire avant requête : 22.763 MB Rangées retournées : 174

    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 = 309817498) 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 = 104 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (104) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))
    
      ORDER BY _tags_orderng,f.featured DESC, f.updated DESC

    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	8208	75.00	Using where; Utilisation du tri complet de type filesort
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
    6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.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.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.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.02 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.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.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.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.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.05 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]

    ---

20. Temps de requête : 116.10 ms Après la dernière requête : 1.05 ms Mémoire de requête : 0.063 MB mémoire avant requête : 22.776 MB Rangées retournées : 30

    SELECT
        f.*,
        fi.alt AS _alt,
        fi.width AS _width,
        fi.height AS _height,
        fi.size AS _size,
    	fi.sys_filename AS _sys_filename,
        c.name AS _category_name,
        u.name AS _user_name
        , (SELECT fl.address 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _address, (SELECT fl.longitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _longitude, (SELECT fl.latitude 
      FROM `dm4t9_fwsg_file_location` AS fl 
      WHERE fl.file_id = f.id 
      LIMIT 1) AS _latitude,'' AS _tags, (
      CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
        (SELECT SUM(v.value) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.value > 0) AS _rating_sum,
        (SELECT COUNT(*) 
      FROM `dm4t9_fwsg_file_vote` AS v 
      WHERE v.file_id = f.id 
      AND v.ipaddr = 309817498) 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 = 104 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (104) 
      AND ct.tag_id = ft.tag_id 
      AND ft.file_id = f.id))
    
      ORDER BY _tags_orderng,f.featured DESC, f.updated DESC 
      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	8208	75.00	Using where; Utilisation du tri complet de type filesort
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
    6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
    4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
    2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 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.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.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.02 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.03 ms
    executing	0.01 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.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.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.01 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.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.02 ms
    Sending data	0.02 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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]

    ---

21. Temps de requête : 0.69 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.029 MB mémoire avant requête : 23.055 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 (2356,2349,2350,2351,2352,2353,2354,2355,2342,2343,2344,2345,2346,2347,2348,2336,2337,2338,2339,2340,2341,2329,2330,2331,2332,2333,2334,2335,2323,2324)
    
      ORDER BY
        t.name

    Explication

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

    Profil

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.11 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.04 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]

    ---

22. Temps de requête : 106.32 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.211 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 = 104 OR EXISTS(SELECT * 
      FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
      WHERE ct.category_id IN (104) 
      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	8208	75.00	Using where
    1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
    1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
    1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
    1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
    1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
    2	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
    2	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where

    Profil

    Status	Duration
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.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.01 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.01 ms
    executing	0.01 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.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.03 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.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/item.php:175
    11	fwGalleryModelItem->loadFilesQty()	JROOT/components/com_fwgallery/models/item.php:180
    10	fwGalleryModelItem->getFilesPagination()	JROOT/components/com_fwgallery/views/item/view.html.php:69
    9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php: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 : 0.90 ms Après la dernière requête : 20.22 ms Mémoire de requête : 0.062 MB mémoire avant requête : 23.358 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	211	100.00	NULL

    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.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.33 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php: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]

    ---

24. Temps de requête : 0.41 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.505 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 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.03 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]

    ---

25. Temps de requête : 0.39 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.526 MB Rangées retournées : 1

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 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]

    ---

26. Temps de requête : 0.36 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.547 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.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.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.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]

    ---

27. Temps de requête : 0.68 ms Après la dernière requête : 1.06 ms Mémoire de requête : 0.043 MB mémoire avant requête : 23.600 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.06 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.03 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.06 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]

    ---

28. Temps de requête : 0.50 ms Après la dernière requête : 25.95 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.287 MB Rangées retournées : 0

    SELECT uikit
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/expeditions-voyages/turquie-2006/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-turquie-elizabeth-04-2006-imgp1368-custom-text-f2355?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.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.01 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 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]

    ---

29. Temps de requête : 0.44 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.297 MB Rangées retournées : 0

    SELECT uikit_plus
    
      FROM `dm4t9_cwgears`
    
      WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/expeditions-voyages/turquie-2006/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-turquie-elizabeth-04-2006-imgp1368-custom-text-f2355?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.04 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.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.05 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]

    ---

30. Temps de requête : 0.32 ms Après la dernière requête : 7.95 ms Mémoire de requête : 0.006 MB mémoire avant requête : 24.613 MB

    LOCK TABLES `dm4t9_extensions` WRITE

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:551
    8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/ebreminder/ebreminder.php:43
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Temps de requête : 0.65 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.005 MB mémoire avant requête : 24.620 MB

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

    Explication

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

    Profil

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.10 ms
    updating	0.05 ms
    end	0.01 ms
    query end	0.21 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ebreminder/ebreminder.php:54
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Temps de requête : 0.24 ms Après la dernière requête : 0.79 ms Mémoire de requête : 0.006 MB mémoire avant requête : 24.629 MB

    UNLOCK TABLES

    Explication

    EXPLAIN impossible sur la requête : UNLOCK TABLES

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:926
    8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/ebreminder/ebreminder.php:66
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Temps de requête : 0.72 ms Après la dernière requête : 6.35 ms Mémoire de requête : 0.044 MB mémoire avant requête : 25.039 MB Rangées retournées : 173

    SELECT `config_key`,`config_value`
    
      FROM dm4t9_eb_configs

    Explication

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

    Profil

    Status	Duration
    starting	0.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.02 ms
    executing	0.00 ms
    Sending data	0.25 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
    10	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:95
    9	EventbookingHelper::getConfig()	JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:61
    8	require_once JROOT/administrator/components/com_eventbooking/libraries/rad/bootstrap.php	JROOT/plugins/system/ebreminder/ebreminder.php:80
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Temps de requête : 0.71 ms Après la dernière requête : 5.14 ms Mémoire de requête : 0.029 MB mémoire avant requête : 25.329 MB Rangées retournées : 48

    SELECT `message_key`,`message`
    
      FROM dm4t9_eb_messages

    Explication

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

    Profil

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 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.08 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.04 ms

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_eventbooking/libraries/rad/config/config.php:39
    10	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:296
    9	EventbookingHelper::getMessages()	JROOT/components/com_eventbooking/helper/mail.php:1369
    8	EventbookingHelperMail::sendReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:83
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Temps de requête : 1.05 ms Après la dernière requête : 12.89 ms Mémoire de requête : 0.046 MB mémoire avant requête : 26.173 MB Rangées retournées : 0

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

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/mail.php:1445
    8	EventbookingHelperMail::sendReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:83
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Temps de requête : 1.03 ms Après la dernière requête : 1.17 ms Mémoire de requête : 0.046 MB mémoire avant requête : 26.207 MB Rangées retournées : 0

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

    Explication

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

    Profil

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

    Pile d'appels

    #	Appel	Fichier et numéro de ligne
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/mail.php:1647
    8	EventbookingHelperMail::sendSecondReminder()	JROOT/plugins/system/ebreminder/ebreminder.php:86
    7	plgSystemEBReminder->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---