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

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1733796635,
                "last": 1733796635,
                "now": 1733796635
            },
            "token": "5kmVw7sNnhkWWXCxcNfvN4JuzGHGj2NH"
        },
        "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: 14.84 ms / 14.84 ms Mémoire: 1.906 MB / 2.28 MB Application: afterLoad

Temps: 72.42 ms / 87.26 ms Mémoire: 5.495 MB / 7.77 MB Application: afterInitialise

Temps: 37.61 ms / 124.86 ms Mémoire: 3.679 MB / 11.45 MB Application: afterRoute

Temps: 0.85 ms / 125.71 ms Mémoire: 0.089 MB / 11.54 MB Application: beforeRenderComponent com_fwgallery

Temps: 136.92 ms / 262.64 ms Mémoire: 2.801 MB / 14.34 MB Application: Before Access::preloadComponents (all components)

Temps: 2.87 ms / 265.50 ms Mémoire: 0.067 MB / 14.41 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 265.53 ms Mémoire: -0.003 MB / 14.41 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.49 ms / 266.02 ms Mémoire: 0.026 MB / 14.43 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 819.51 ms / 1085.54 ms Mémoire: 1.051 MB / 15.48 MB Application: afterRenderComponent com_fwgallery

Temps: 4.12 ms / 1089.66 ms Mémoire: 0.296 MB / 15.78 MB Application: afterDispatch

Temps: 5.18 ms / 1094.84 ms Mémoire: 0.306 MB / 16.09 MB Application: Before Access::getAssetRules (id:293 name:com_jfbconnect)

Temps: 0.02 ms / 1094.86 ms Mémoire: 0.002 MB / 16.09 MB Application: After Access::getAssetRules (id:293 name:com_jfbconnect)

Temps: 1.84 ms / 1096.70 ms Mémoire: 1.030 MB / 17.12 MB Application: beforeRenderModule mod_fwg_latest (Dernier module FWG)

Temps: 160.82 ms / 1257.52 ms Mémoire: 11.468 MB / 28.59 MB Application: afterRenderModule mod_fwg_latest (Dernier module FWG)

Temps: 12.85 ms / 1270.36 ms Mémoire: -0.268 MB / 28.32 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 5.69 ms / 1276.05 ms Mémoire: 0.373 MB / 28.69 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 25.83 ms / 1301.88 ms Mémoire: -0.266 MB / 28.42 MB Application: beforeRenderModule mod_menu (Menu Haut)

Temps: 1.00 ms / 1302.88 ms Mémoire: 0.035 MB / 28.46 MB Application: afterRenderModule mod_menu (Menu Haut)

Temps: 19.07 ms / 1321.95 ms Mémoire: -0.837 MB / 27.62 MB Application: afterRender

Total de requêtes base de données : 1020.72 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'6163333762303535383339633130343930623465333562636333373165336630', 1, 1733796635, 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.57 ms Après la dernière requête : 5.14 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.530 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.56 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.544 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.15 ms Après la dernière requête : 12.04 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	108	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.50 ms Après la dernière requête : 25.77 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.698 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.53 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.705 MB Rangées retournées : 1

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

  WHERE time + '86400'<'1733796635'

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 : 2.89 ms Après la dernière requête : 33.70 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.272 MB

UPDATE `dm4t9_extensions`

  SET `params` = '{\"mediaversion\":\"9242044605ce05f445122a5e08e71bb7\"}'

  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.35 ms Après la dernière requête : 1.93 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.448 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 : 7.12 ms Après la dernière requête : 5.38 ms Mémoire de requête : 0.036 MB mémoire avant requête : 11.981 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/fwgallery.php:85
10	fwGalleryModelFwGallery->loadCategory()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:24
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 107.79 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.051 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 = 16

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
9	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	1	100.00	Using index condition; Using where
10	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
10	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
7	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	74	100.00	Using index condition; Using where
8	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
8	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
6	DEPENDENT SUBQUERY	ft	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
6	DEPENDENT SUBQUERY	t	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.ft.tag_id	1	100.00	Using index
4	DEPENDENT SUBQUERY	f	ALL	type,published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	9210	90.94	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	index_merge	published,parent	parent,published	4,1	NULL	5	80.00	Using intersect(parent,published); Using where; Using index
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/fwgallery.php:87
10	fwGalleryModelFwGallery->loadCategory()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:24
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.91 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.008 MB mémoire avant requête : 12.073 MB

UPDATE dm4t9_fwsg_category

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

  WHERE `id` = '16'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dm4t9_fwsg_category	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/fwgallery.php:88
10	fwGalleryModelFwGallery->loadCategory()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:24
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.16 ms Après la dernière requête : 5.11 ms Mémoire de requête : 0.384 MB mémoire avant requête : 12.477 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	205	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:997
11	fwgHelper::loadCategories()	JROOT/components/com_fwgallery/helpers/helper.php:1342
10	fwgHelper::getParentGalleries()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:39
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php: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 : 4.38 ms Mémoire de requête : 0.026 MB mémoire avant requête : 14.233 MB Rangées retournées : 1

Requêtes dupliquées: #26 #29 #32 #35 #38

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

Explication

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

Profil

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:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
10	fwgHelper::loadCategoriesPath()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:44
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.42 ms Après la dernière requête : 0.85 ms Mémoire de requête : 0.026 MB mémoire avant requête : 14.269 MB Rangées retournées : 0

Requêtes dupliquées: #27 #30 #33 #36 #39 #45 #48 #50 #53 #56 #59 #62 #65 #68 #71 #74 #77 #80 #83 #86 #89 #92 #95 #98 #101 #104 #107 #110 #113 #116 #119 #122 #125 #128 #131 #134 #137 #141 #144 #147 #150 #153

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
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
10	fwgHelper::loadCategoriesPath()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:44
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.65 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.035 MB mémoire avant requête : 14.353 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	360	11.39	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/fwgallery.php:34
11	fwGalleryModelFwGallery->_getSubcategoriesWhere()	JROOT/components/com_fwgallery/models/fwgallery.php:121
10	fwGalleryModelFwGallery->loadSubcategories()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:102
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 559.83 ms Après la dernière requête : 0.73 ms Mémoire de requête : 0.039 MB mémoire avant requête : 14.431 MB Rangées retournées : 5

SELECT
    c.*,
    u.name 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.category_id = c.id 
  AND f.published = 1 
  AND f.`type` = 'image')  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
    
  LEFT JOIN `dm4t9_users` AS u 
  ON u.id = c.user_id
    
  LEFT JOIN `dm4t9_viewlevels` AS ca 
  ON ca.id = c.`access`

  WHERE c.published = 1 
  AND (c.`access` = 0 OR c.access IN (1,3)) 
  AND c.parent IN (16)

  ORDER BY c.parent, c.ordering 
  LIMIT 0, 12

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	ref	published,parent,access	parent	4	const	5	100.00	Using where; Utilisation du tri complet de type filesort
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.user_id	1	100.00	Using where
1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
8	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	1	100.00	Using index condition; Using where
9	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	bxv_canoeclubgenevech13_2.c.id	1	100.00	NULL
9	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
6	DEPENDENT SUBQUERY	f	ref	type,published	type	1	const	74	100.00	Using index condition; Using where
7	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	bxv_canoeclubgenevech13_2.c.id	1	100.00	NULL
7	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
5	DEPENDENT SUBQUERY	ft	ref	category_id,tag_id	category_id	4	bxv_canoeclubgenevech13_2.c.id	1	100.00	NULL
5	DEPENDENT SUBQUERY	t	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.ft.tag_id	1	100.00	Using index
3	DEPENDENT SUBQUERY	f	ALL	type,published	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	9210	90.94	Using where
4	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	bxv_canoeclubgenevech13_2.c.id	1	100.00	NULL
4	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
2	DEPENDENT SUBQUERY	cc	ref	published,parent	parent	4	bxv_canoeclubgenevech13_2.c.id	7	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/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/fwgallery.php:126
10	fwGalleryModelFwGallery->loadSubcategories()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:102
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.67 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.029 MB mémoire avant requête : 14.492 MB Rangées retournées : 0

SELECT DISTINCT
    t.id,
	t.published,
    t.name,
	t.alias,
    ft.category_id

  FROM
    dm4t9_fwsg_category_tag AS ft,
    `dm4t9_fwsg_tag` AS t

  WHERE
    t.id = ft.tag_id
    
  AND t.published = 1
    
  AND
    ft.category_id IN (39,104,88,173,92)

  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	category_id,tag_id	tag_id	4	bxv_canoeclubgenevech13_2.t.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
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/tag/tag.php:455
14	plgFwGalleryTag->oncalculateCategoryListExtraFields()	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/fwgallery.php:132
10	fwGalleryModelFwGallery->loadSubcategories()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:102
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.66 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.032 MB mémoire avant requête : 14.505 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
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:1534
17	fwgHelper::loadPlugins()	JROOT/components/com_fwgallery/helpers/helper.php:1550
16	fwgHelper::pluginEnabled()	JROOT/plugins/fwgallery/featured/featured.php:83
15	plgFwGalleryFeatured->ongetFilesListExtraOrdering()	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/components/com_fwgallery/models/fwgallery.php:252
11	fwGalleryModelFwGallery->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/fwgallery.php:299
10	fwGalleryModelFwGallery->loadFiles()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:110
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

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

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	9210	91.68	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/fwgallery.php:304
10	fwGalleryModelFwGallery->loadFiles()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:110
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 120.42 ms Après la dernière requête : 1.50 ms Mémoire de requête : 0.026 MB mémoire avant requête : 14.620 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 IN (16) OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (16) 
  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	9210	91.68	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/fwgallery.php:334
11	fwGalleryModelFwGallery->loadFilesQty()	JROOT/components/com_fwgallery/models/fwgallery.php:353
10	fwGalleryModelFwGallery->getFilesPagination()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:118
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.55 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.026 MB mémoire avant requête : 14.628 MB Rangées retournées : 1

SELECT
    COUNT(*)

  FROM
    `dm4t9_fwsg_category` AS c
    
  LEFT JOIN `dm4t9_users` AS u 
  ON u.id = c.user_id
    
  LEFT JOIN `dm4t9_viewlevels` AS ca 
  ON ca.id = c.`access`

  WHERE c.published = 1 
  AND (c.`access` = 0 OR c.access IN (1,3)) 
  AND c.parent IN (16)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	published,parent,access	parent	4	const	5	100.00	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.user_id	1	100.00	Using where; Using index
1	SIMPLE	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/fwgallery.php:146
11	fwGalleryModelFwGallery->loadSubcategoriesQty()	JROOT/components/com_fwgallery/models/fwgallery.php:161
10	fwGalleryModelFwGallery->getSubcategoriesPagination()	JROOT/components/com_fwgallery/views/fwgallery/view.html.php:119
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php: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 : 2.19 ms Mémoire de requête : 0.059 MB mémoire avant requête : 14.778 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	205	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:456
27	plgFwGallerySeoBooster->getCategoryData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:320
26	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
22	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
14	fwgHelper::route()	JROOT/plugins/fwgallery/seobooster/seobooster.php:117
13	plgFwGallerySeoBooster->onbeforeCategoryDisplay()	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/fwgallery/view.html.php:129
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.40 ms Après la dernière requête : 2.71 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.071 MB Rangées retournées : 1

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

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.30 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.097 MB Rangées retournées : 1

Requêtes dupliquées: #15 #29 #32 #35 #38

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

Explication

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

Profil

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:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.24 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.124 MB Rangées retournées : 0

Requêtes dupliquées: #16 #30 #33 #36 #39 #45 #48 #50 #53 #56 #59 #62 #65 #68 #71 #74 #77 #80 #83 #86 #89 #92 #95 #98 #101 #104 #107 #110 #113 #116 #119 #122 #125 #128 #131 #134 #137 #141 #144 #147 #150 #153

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.38 ms Après la dernière requête : 1.56 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.158 MB Rangées retournées : 1

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

Explication

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

Profil

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:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.34 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.184 MB Rangées retournées : 1

Requêtes dupliquées: #15 #26 #32 #35 #38

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

Explication

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

Profil

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:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.23 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.211 MB Rangées retournées : 0

Requêtes dupliquées: #16 #27 #33 #36 #39 #45 #48 #50 #53 #56 #59 #62 #65 #68 #71 #74 #77 #80 #83 #86 #89 #92 #95 #98 #101 #104 #107 #110 #113 #116 #119 #122 #125 #128 #131 #134 #137 #141 #144 #147 #150 #153

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.42 ms Après la dernière requête : 1.66 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.240 MB Rangées retournées : 1

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

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.266 MB Rangées retournées : 1

Requêtes dupliquées: #15 #26 #29 #35 #38

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

Explication

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

Profil

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:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #16 #27 #30 #36 #39 #45 #48 #50 #53 #56 #59 #62 #65 #68 #71 #74 #77 #80 #83 #86 #89 #92 #95 #98 #101 #104 #107 #110 #113 #116 #119 #122 #125 #128 #131 #134 #137 #141 #144 #147 #150 #153

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 1.49 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.330 MB Rangées retournées : 1

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

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
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
37	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1134
36	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:353
35	plgFwGallerySeoBooster->onbuildRoute()	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:41
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:627
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/category.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/listing/category.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/grids/standard.php:27
20	include JROOT/plugins/fwgallerytmpl/classic/grids/standard.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php:30
18	include JROOT/plugins/fwgallerytmpl/classic/listing/categories_list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
17	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/categories.php:16
16	include JROOT/plugins/fwgallerytmpl/classic/listing/categories.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:81
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1476
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/fwgallery/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/fwgallery/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/fwgallery/view.html.php:169
9	fwGalleryViewFwGallery->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:26
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.26 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.044 MB mémoire avant requête : 15.357 MB Rangées retournées : 1

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

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

155 requêtes exécutées 1020.72 ms

86 doubles découverts!