Galerie photos

Console de débogage Joomla!

Session

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

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

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

#	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'3433356463613436663865333339383334316335653763353762353235373530', 1, 1713303803, 0, '')

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	0.42 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.51 ms Après la dernière requête : 8.40 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.528 MB Rangées retournées : 5

SELECT id, rules

  FROM `dm4t9_viewlevels`

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.74 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.543 MB Rangées retournées : 1

SELECT b.id

  FROM dm4t9_usergroups AS a

  LEFT JOIN dm4t9_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.96 ms Après la dernière requête : 16.10 ms Mémoire de requête : 0.076 MB mémoire avant requête : 5.975 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	133	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.49 ms Après la dernière requête : 25.30 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.697 MB Rangées retournées : 1

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

  WHERE time + '86400'<'1713303803'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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 : 1.18 ms Après la dernière requête : 42.51 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.320 MB

UPDATE `dm4t9_extensions`

  SET `params` = '{\"mediaversion\":\"f2053882b1fc0a77985cc20a177f2da1\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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.45 ms Après la dernière requête : 1.94 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.496 MB Rangées retournées : 1

SELECT count(*)

  FROM `dm4t9_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 2.59 ms Après la dernière requête : 6.14 ms Mémoire de requête : 0.036 MB mémoire avant requête : 12.038 MB Rangées retournées : 22

SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_category`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 92.60 ms Après la dernière requête : 0.72 ms Mémoire de requête : 0.037 MB mémoire avant requête : 12.109 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 = 242

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.80 ms Après la dernière requête : 0.30 ms Mémoire de requête : 0.008 MB mémoire avant requête : 12.125 MB

UPDATE dm4t9_fwsg_category

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

  WHERE `id` = '242'

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

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 5.12 ms Après la dernière requête : 5.88 ms Mémoire de requête : 0.380 MB mémoire avant requête : 12.468 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	209	100.00	Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:960
11	fwgHelper::loadCategories()	JROOT/components/com_fwgallery/helpers/helper.php:1299
10	fwgHelper::getParentGalleries()	JROOT/components/com_fwgallery/views/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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #29

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #27 #30

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

Explication

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

Profil

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

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:1095
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28 #31

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `dm4t9_assets`

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.68 ms Après la dernière requête : 1.11 ms Mémoire de requête : 0.036 MB mémoire avant requête : 14.379 MB Rangées retournées : 0

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 (242)

  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	1	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	73	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	8363	98.84	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	8	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.26 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.032 MB mémoire avant requête : 14.390 MB Rangées retournées : 19

SELECT
    `element`,
    `enabled`,
	`folder`

  FROM
    dm4t9_extensions

  WHERE
    `type` = 'plugin'
    
  AND
    `folder` IN ('fwgallery', 'fwgallerytype', 'fwgallerytmpl')

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:1491
17	fwgHelper::loadPlugins()	JROOT/components/com_fwgallery/helpers/helper.php:1507
16	fwgHelper::pluginEnabled()	JROOT/plugins/fwgallery/featured/featured.php:84
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:254
11	fwGalleryModelFwGallery->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/fwgallery.php:301
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 136.88 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.217 MB mémoire avant requête : 14.416 MB Rangées retournées : 172

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

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

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/fwgallery.php:306
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT DISTINCT
    t.id,
    t.name,
	t.alias,
	t.published,
    t.ordering,
    ft.file_id

  FROM
    `dm4t9_fwsg_file` AS f,
    `dm4t9_fwsg_file_tag` AS ft,
    `dm4t9_fwsg_tag` AS t

  WHERE
    t.id = ft.tag_id
    
  AND t.published = 1
    
  AND
    f.id = ft.file_id
    
  AND
    ft.file_id IN (8164,8165,8166,8167,8168,8169,8170,8171,8172,8173,8174,8175,8176,8177,8178,8179,8180,8181,8182,8183,8184,8185,8186,8187,8188,8189,8190,8191,8192,8193,8194,8195,8196,8197,8198,8199,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8212,8213,8214,8215,8216,8217,8218,8219,8220,8221,8222,8223,8224,8225,8226,8227,8228,8229,8230,8231,8232,8233,8234,8235,8236,8237,8238,8239,8240,8241,8242,8243,8244,8245,8246,8247,8248,8249,8250,8251,8252,8253,8254,8255,8256,8257,8258,8259,8260,8261,8262,8263,8264,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8277,8278,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8294,8295,8296,8297,8298,8299,8300,8301,8302,8303,8304,8305,8306,8307,8308,8309,8310,8311,8312,8313,8314,8315,8316,8317,8318,8319,8320,8321,8322,8323,8324,8325,8326,8327,8328,8329,8330,8331,8332,8333,8334,8335)

  ORDER BY
    t.name

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/tag/tag.php:483
14	plgFwGalleryTag->oncalculateFileListExtraFields()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/models/fwgallery.php:311
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/fwgallery.php:336
11	fwGalleryModelFwGallery->loadFilesQty()	JROOT/components/com_fwgallery/models/fwgallery.php:355
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.58 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.026 MB mémoire avant requête : 16.099 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 (242)

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	1	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

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/fwgallery.php:148
11	fwGalleryModelFwGallery->loadSubcategoriesQty()	JROOT/components/com_fwgallery/models/fwgallery.php:163
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.89 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.059 MB mémoire avant requête : 16.226 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	209	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:457
27	plgFwGallerySeoBooster->getCategoryData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:321
26	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
22	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
14	fwgHelper::route()	JROOT/plugins/fwgallery/seobooster/seobooster.php:118
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.41 ms Après la dernière requête : 3.52 ms Mémoire de requête : 0.037 MB mémoire avant requête : 16.452 MB Rangées retournées : 1

Requêtes dupliquées: #17 #30

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
28	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
27	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
23	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
15	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:66
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.39 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.037 MB mémoire avant requête : 16.472 MB Rangées retournées : 0

Requêtes dupliquées: #18 #31

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
28	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
27	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
23	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
15	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:66
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #16

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
28	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
27	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
23	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
15	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:66
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.50 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.037 MB mémoire avant requête : 16.512 MB Rangées retournées : 1

Requêtes dupliquées: #17 #27

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
28	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
27	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
23	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
15	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:66
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #28

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
29	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
28	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
27	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
26	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
25	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
24	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
23	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
15	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:66
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 12.63 ms Après la dernière requête : 2.12 ms Mémoire de requête : 2.062 MB mémoire avant requête : 16.605 MB Rangées retournées : 8340

SELECT
	f.id,
	f.name,
	f.alias,
	f.category_id,
	c.name AS _cat_name,
	c.alias AS _cat_alias

  FROM
	dm4t9_fwsg_file AS f
	
  LEFT JOIN dm4t9_fwsg_category AS c 
  ON f.category_id = c.id

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
36	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
35	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:478
34	plgFwGallerySeoBooster->getImageData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:381
33	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
32	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
31	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
30	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
29	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
28	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
27	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
26	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
25	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
24	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
23	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
22	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
21	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/plugins/slideshowview/listing_top_info.php:88
20	include JROOT/plugins/fwgallerytmpl/classic/plugins/slideshowview/listing_top_info.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
19	fwgHelper::loadTemplate()	JROOT/plugins/fwgallery/slideshowview/slideshowview.php:152
18	plgFwGallerySlideshowview->onshowListingTopInfo()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/fwgallerytmpl/classic/listing/list.php:79
14	include JROOT/plugins/fwgallerytmpl/classic/listing/list.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
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:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.54 ms Après la dernière requête : 566.74 ms Mémoire de requête : 0.028 MB mémoire avant requête : 25.234 MB Rangées retournées : 0

SELECT uikit

  FROM `dm4t9_cwgears`

  WHERE url = 'https://canoe-club-geneve.ch/galerie-photos/galerie-photos/competition/slalom-d-etrembieres-2020/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-competiteurs-dossards-01-39-custom-text-c242'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:417
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT uikit_plus

  FROM `dm4t9_cwgears`

  WHERE url = 'https://canoe-club-geneve.ch/galerie-photos/galerie-photos/competition/slalom-d-etrembieres-2020/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-competiteurs-dossards-01-39-custom-text-c242'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:426
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

26 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

9 × SELECT id, parent, name 
  FROM `dm4t9_fwsg_category`

1 × SELECT `data` 
  FROM `dm4t9_session`

1 × SELECT
     c.*,
     u.name AS _user_name,
     (SELECT COUNT(*) 
  FROM dm4t9_fwsg_category AS cc

1 × SELECT uikit 
  FROM `dm4t9_cwgears`

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

1 × SELECT  c.id,  c.name,  c.alias 
  FROM  dm4t9_fwsg_category AS

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`

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

1 × SELECT DISTINCT
     t.id,
     t.name,
  t.alias,
  t.published,
     t.ordering,
     ft.file_id
 
  FROM
     `dm4t9_fwsg_file` AS f,
     `dm4t9_fwsg_file_tag` AS ft,
     `dm4t9_fwsg_tag` AS t

1 × 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

1 × SELECT
     `element`,
     `enabled`,
  `folder`
 
  FROM
     dm4t9_extensions

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `dm4t9_assets`

1 × SELECT `session_id` 
  FROM `dm4t9_session`

1 × SELECT
     c.id,
  c.parent,
  c.published,
  c.name,
  c.params
 
  FROM
     dm4t9_fwsg_category AS c

1 × SELECT
     c.*,
  (SELECT u.name 
  FROM `dm4t9_users` AS u

1 × SELECT count(*) 
  FROM `dm4t9_extensions`

1 × SELECT count(*) 
  FROM `dm4t9_cwgears_schedule`

1 × SELECT count(*) 
  FROM `dm4t9_cwgears_schedule

1 × SELECT setting,value 
  FROM dm4t9_jfbconnect_confi

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

1 × SELECT id, rules 
  FROM `dm4t9_viewlevels

1 × SELECT uikit_plus 
  FROM `dm4t9_cwgears`

Autres tables :

1 × INSERT INTO `dm4t9_session` (`session_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  (X'3433356463613436663865333339383334316335653763353762353235373530', 1, 1713303803, 0, ''

1 × UPDATE `dm4t9_extensions` 
  SET `params` = '{\"mediaversion\":\"f2053882b1fc0a77985cc20a177f2da1\"}'

1 × SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_category

1 × UPDATE dm4t9_fwsg_category 
  SET `hits` = (`hits` + 1)

Compétiteurs (01-39)

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

34 requêtes exécutées 358.02 ms

8 doubles découverts!

26 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

Autres tables :