Canoë Club de Genève : kayak et eaux-vives sont notre plaisir !

Console de débogage Joomla!

Session

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

Profil d'information

Temps

Mémoire

Temps: 25.97 ms / 25.97 ms Mémoire: 1.906 MB / 2.28 MB Application: afterLoad

Temps: 102.57 ms / 128.54 ms Mémoire: 5.496 MB / 7.78 MB Application: afterInitialise

Temps: 40.30 ms / 168.84 ms Mémoire: 3.661 MB / 11.44 MB Application: afterRoute

Temps: 0.97 ms / 169.81 ms Mémoire: 0.091 MB / 11.53 MB Application: beforeRenderComponent com_fwgallery

Temps: 155.94 ms / 325.75 ms Mémoire: 11.041 MB / 22.57 MB Application: Before Access::preloadComponents (all components)

Temps: 2.40 ms / 328.14 ms Mémoire: 0.064 MB / 22.63 MB Application: After Access::preloadComponents (all components)

Temps: 0.04 ms / 328.18 ms Mémoire: -0.003 MB / 22.63 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.79 ms / 328.97 ms Mémoire: 0.033 MB / 22.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 296.10 ms / 625.07 ms Mémoire: 0.836 MB / 23.50 MB Application: afterRenderComponent com_fwgallery

Temps: 4.37 ms / 629.44 ms Mémoire: 0.296 MB / 23.80 MB Application: afterDispatch

Temps: 6.21 ms / 635.65 ms Mémoire: 0.244 MB / 24.04 MB Application: Before Access::getAssetRules (id:293 name:com_jfbconnect)

Temps: 0.03 ms / 635.68 ms Mémoire: 0.002 MB / 24.04 MB Application: After Access::getAssetRules (id:293 name:com_jfbconnect)

Temps: 1.08 ms / 636.76 ms Mémoire: 0.075 MB / 24.12 MB Application: beforeRenderModule mod_fwg_latest (Dernier module FWG)

Temps: 159.65 ms / 796.40 ms Mémoire: 3.012 MB / 27.13 MB Application: afterRenderModule mod_fwg_latest (Dernier module FWG)

Temps: 2.38 ms / 798.78 ms Mémoire: -0.206 MB / 26.92 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 16.14 ms / 814.92 ms Mémoire: 0.230 MB / 27.15 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 24.43 ms / 839.36 ms Mémoire: 0.064 MB / 27.22 MB Application: beforeRenderModule mod_menu (Menu Haut)

Temps: 3.02 ms / 842.37 ms Mémoire: 0.022 MB / 27.24 MB Application: afterRenderModule mod_menu (Menu Haut)

Temps: 22.37 ms / 864.74 ms Mémoire: 0.164 MB / 27.40 MB Application: afterRender

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

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

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

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

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

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

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

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

Temps de requête : 0.52 ms Après la dernière requête : 9.44 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.531 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

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

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

Temps de requête : 0.61 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.545 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

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

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

Temps de requête : 1.26 ms Après la dernière requête : 23.88 ms Mémoire de requête : 0.076 MB mémoire avant requête : 5.977 MB Rangées retournées : 143

SELECT setting,value 
  FROM dm4t9_jfbconnect_config

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.47 ms Après la dernière requête : 26.87 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.700 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.29 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.708 MB Rangées retournées : 1

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

  WHERE time + '86400'<'1728757123'

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.71 ms Après la dernière requête : 38.36 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.256 MB

UPDATE `dm4t9_extensions`

  SET `params` = '{\"mediaversion\":\"5c31cc03fe58b88816b6b3f05d3b753d\"}'

  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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.39 ms Après la dernière requête : 2.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.432 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 2.33 ms Après la dernière requête : 7.52 ms Mémoire de requête : 0.035 MB mémoire avant requête : 11.863 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 3.65 ms Après la dernière requête : 0.87 ms Mémoire de requête : 0.040 MB mémoire avant requête : 11.933 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 = 751328918) 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 = 6667

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.41 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.964 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 = 6667

  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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.61 ms Après la dernière requête : 0.27 ms Mémoire de requête : 0.008 MB mémoire avant requête : 11.965 MB

UPDATE dm4t9_fwsg_file

  SET `hits` = (`hits` + 1)

  WHERE `id` = '6667'

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 1.00 ms Après la dernière requête : 1.07 ms Mémoire de requête : 0.036 MB mémoire avant requête : 12.016 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 83.42 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.071 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 = 213

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	8418	98.19	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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 4.15 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.381 MB mémoire avant requête : 12.086 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	221	100.00	Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 14.40 ms Après la dernière requête : 9.25 ms Mémoire de requête : 2.056 MB mémoire avant requête : 13.796 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	8418	100.00	NULL
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 1.99 ms Après la dernière requête : 27.41 ms Mémoire de requête : 0.035 MB mémoire avant requête : 22.577 MB Rangées retournées : 40

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

  FROM `dm4t9_assets`

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

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.87 ms Après la dernière requête : 3.13 ms Mémoire de requête : 0.033 MB mémoire avant requête : 22.843 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 91.15 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.040 MB mémoire avant requête : 22.870 MB Rangées retournées : 17

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 = 751328918) 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 = 213 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (213) 
  AND ct.tag_id = ft.tag_id 
  AND ft.file_id = f.id))

  ORDER BY _tags_orderng,f.featured DESC, f.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8418	99.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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 90.91 ms Après la dernière requête : 0.43 ms Mémoire de requête : 0.055 MB mémoire avant requête : 22.882 MB Rangées retournées : 17

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 = 751328918) 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 = 213 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (213) 
  AND ct.tag_id = ft.tag_id 
  AND ft.file_id = f.id))

  ORDER BY _tags_orderng,f.featured DESC, f.ordering 
  LIMIT 0, 30

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8418	99.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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.58 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.029 MB mémoire avant requête : 23.044 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 (6667,6668,6669,7184,7185,7186,7187,7188,7189,7190,7191,7192,7193,7194,7195,7196,7197)

  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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 89.33 ms Après la dernière requête : 1.64 ms Mémoire de requête : 0.026 MB mémoire avant requête : 23.136 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 = 213 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (213) 
  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	8418	99.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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.81 ms Après la dernière requête : 10.26 ms Mémoire de requête : 0.062 MB mémoire avant requête : 23.268 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	221	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

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

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

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.35 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.039 MB mémoire avant requête : 23.436 MB Rangées retournées : 1

Requêtes dupliquées: #35 #71 #104 #153

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

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 0.29 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.038 MB mémoire avant requête : 23.457 MB Rangées retournées : 0

Requêtes dupliquées: #34 #36 #39 #42 #45 #48 #51 #54 #57 #60 #63 #66 #69 #72 #75 #78 #81 #84 #87 #90 #93 #96 #99 #102 #105 #108 #111 #114 #117 #120 #123 #126 #129 #132 #135 #138 #141 #145 #148 #151 #154

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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 2.39 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.043 MB mémoire avant requête : 23.509 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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]

Temps de requête : 1.63 ms Après la dernière requête : 10.76 ms Mémoire de requête : 0.030 MB mémoire avant requête : 24.097 MB Rangées retournées : 4

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

  FROM dm4t9_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-10-12 18:18:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-12 18:18:43') 
  AND m.access IN (1,3) 
  AND m.client_id = 0 
  AND (mm.menuid = 1065 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Pile d'appels

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

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

Temps de requête : 24.81 ms Après la dernière requête : 5.32 ms Mémoire de requête : 0.076 MB mémoire avant requête : 24.187 MB Rangées retournées : 44

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 = 751328918) 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 f.category_id IN (5,48,35,17,26,29,43,32,16,46,49,259,260,258,254,252,248,247,36,219,158,152,157,262,263,155,156,226,220,120,105,225,106,97,94,82,89,93,83,84,77,74,76,73,66,172,185,189,208,204,205,193,160,184,165,166,167,164,177,281,283,39,104,88,173,92,250,38,230,37,41,47,223,221,232,116,103,211,212,95,98,85,70,27,203,159,154,108,101,178,192,233,124,122,123,121,145,128,113,109,102,86,67,69,68,174,175,186,176,163,171,188,187,170,237,234,228,231,227,229,115,153,150,224,149,148,264,265,143,267,142,139,127,126,125,114,111,107,210,87,91,90,75,190,191,206,236,72,213,215,214,169,147,146,141,140,138,137,136,135,134,133,132,131,249,130,129,119,117,112,110,100,99,81,80,78,161,71,198,197,179,201,194,202,196,182,181,200,199,183,180,235,151,144,246,216,162,79,168,207,209,217,251,261,238,239,241,242,243,244) 
  AND (c.access = 0 OR c.access IN (1,3))

  ORDER BY
	f.featured DESC, f.hits DESC 
  LIMIT 0, 44

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8418	99.03	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
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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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/models/fwgallery.php:596
11	fwGalleryModelFwGallery->loadModuleData()	JROOT/modules/mod_fwg_latest/mod_fwg_latest.php:25
10	include JROOT/modules/mod_fwg_latest/mod_fwg_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:500
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]

Temps de requête : 0.71 ms Après la dernière requête : 0.52 ms Mémoire de requête : 0.030 MB mémoire avant requête : 24.597 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 (8986,324,7153,8930,4966,7175,8961,6520,410,2619,8985,1012,6169,7156,3425,5628,3088,821,1444,7155,313,2160,6590,5623,5445,8913,6670,17,2148,7165,117,2183,6656,3780,4232,4501,221,5645,1,6667,8336,720,4070,7178)

  ORDER BY
    t.name

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

156 requêtes exécutées 478.44 ms

84 doubles découverts!