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

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1722053628,
                "last": 1722053648,
                "now": 1722053659
            },
            "token": "e99C7uy6wVIhZxycRzxcIMono3RFueH4"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "phpbb_page": "https://canoe-club-geneve.ch/forums/post/quote?f=3&p=5136",
        "phpbb_page_real": "https://canoe-club-geneve.ch/forumphpBB_3/posting.php?f=3&p=5136&mode=quote",
        "phpbb_user": false
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

31 requêtes exécutées 422.97 ms

2 doubles découverts!

2 requêtes dupliquées: #23 #28

Temps de requête : 0.42 ms Mémoire de requête : 0.029 MB mémoire avant requête : 3.871 MB Rangées retournées : 1

SELECT `data`

  FROM `dm4t9_session`

  WHERE `session_id` = X'3761306634313330643633336335653436666163666438383230663662366131'

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.48 ms Après la dernière requête : 7.21 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.509 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.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Pile d'appels

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

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

Temps de requête : 0.45 ms Après la dernière requête : 0.13 ms Mémoire de requête : 0.025 MB mémoire avant requête : 4.523 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.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

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

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

Temps de requête : 1.14 ms Après la dernière requête : 12.92 ms Mémoire de requête : 0.075 MB mémoire avant requête : 5.956 MB Rangées retournées : 143

SELECT setting,value 
  FROM dm4t9_jfbconnect_config

Explication

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

Profil

Status	Duration
starting	0.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.34 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Pile d'appels

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

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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.02 ms
freeing items	0.05 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.44 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.579 MB Rangées retournées : 1

SELECT count(*)

  FROM `dm4t9_cwgears_schedule`

  WHERE time + '86400'<'1722053659'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 6.73 ms Après la dernière requête : 34.28 ms Mémoire de requête : 0.009 MB mémoire avant requête : 11.201 MB

UPDATE `dm4t9_extensions`

  SET `params` = '{\"mediaversion\":\"79b10171b62cb7cae37b99817f009749\"}'

  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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.05 ms
updating	0.04 ms
end	5.89 ms
query end	0.37 ms
closing tables	0.03 ms
freeing items	0.04 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.82 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.392 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.01 ms
optimizing	0.02 ms
statistics	0.04 ms
executing	0.01 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
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 : 1.24 ms Après la dernière requête : 4.49 ms Mémoire de requête : 0.035 MB mémoire avant requête : 11.825 MB Rangées retournées : 19

SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_file`

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.25 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
Opening tables	0.10 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_fwgallery/tables/file.php:52
12	TableFile->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_fwgallery/models/item.php:58
10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.10 ms Après la dernière requête : 0.63 ms Mémoire de requête : 0.040 MB mémoire avant requête : 11.895 MB Rangées retournées : 1

SELECT
    f.*,
	fi.file_id AS _image_exists,
	fi.filename AS `_filename`,
	fi.sys_filename AS _sys_filename,
    fi.alt AS _alt,
    fi.width AS _width,
    fi.height AS _height,
    fi.size AS _size,

    u.name AS _user_name,
    p.name AS _category_name,
	p.params AS params,
    (SELECT g.title 
  FROM `dm4t9_viewlevels` AS g 
  WHERE g.id = f.`access`) AS _group_name

    , (SELECT fl.address 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _address, (SELECT fl.longitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _longitude, (SELECT fl.latitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _latitude,'' AS _tags, (
  CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
    (SELECT SUM(v.value) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _rating_sum,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.ipaddr = 59838979) AS _is_ip_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.user_id = 0) AS _is_user_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value < 0) AS _negative_rating_count,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _positive_rating_count,
	EXISTS(SELECT * 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id) AS _video_exists,
	(SELECT fv.`sys_filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_sys_filename,
	(SELECT fv.`filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_filename,
	(SELECT fv.`media` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_media,
	(SELECT fv.`code` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_code,
	(SELECT fv.`width` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_width,
	(SELECT fv.`height` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_height,
	(SELECT fv.`duration` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_duration,
	(SELECT fv.`size` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1	) AS _video_size,
	EXISTS(SELECT * 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id) AS _audio_exists,
	(SELECT fau.`sys_filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_sys_filename,
	(SELECT fau.`filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_filename,
	(SELECT fau.`duration` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_duration,
	(SELECT fau.`size` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_size

  FROM
    `dm4t9_fwsg_file` AS f
    
  LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
  ON fi.file_id = f.id
    
  LEFT JOIN `dm4t9_fwsg_category` AS p 
  ON f.category_id = p.id
    
  LEFT JOIN `dm4t9_users` AS u 
  ON u.id = f.user_id

  WHERE
    f.id = 2343

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	fi	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	p	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
24	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
23	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
22	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
21	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
20	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
19	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
18	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
17	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
16	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
15	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
14	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
13	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
12	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
11	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
10	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
8	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
7	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	const	1	100.00	Using where
6	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	const	1	100.00	Using where
5	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
4	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
3	DEPENDENT SUBQUERY	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
2	DEPENDENT SUBQUERY	g	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil

Status	Duration
checking permissions	0.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.75 ms
init	0.15 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
optimizing	0.02 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
executing	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_fwgallery/tables/file.php:86
11	TableFile->load()	JROOT/components/com_fwgallery/models/item.php:62
10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

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

  WHERE
    t.id = ft.tag_id
	
  AND t.published = 1
    
  AND
    ft.file_id = 2343

  ORDER BY
    t.name

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/tag/tag.php:519
15	plgFwGalleryTag->oncalculateFileExtraFields()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/administrator/components/com_fwgallery/tables/file.php:98
11	TableFile->load()	JROOT/components/com_fwgallery/models/item.php:62
10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.73 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.008 MB mémoire avant requête : 11.927 MB

UPDATE dm4t9_fwsg_file

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

  WHERE `id` = '2343'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	dm4t9_fwsg_file	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
11	Joomla\CMS\Table\Table->hit()	JROOT/components/com_fwgallery/models/item.php:63
10	fwGalleryModelItem->loadFile()	JROOT/components/com_fwgallery/views/item/view.html.php:21
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_category`

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 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
Opening tables	0.02 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_fwgallery/tables/category.php:47
12	TableCategory->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_fwgallery/models/item.php:47
10	fwGalleryModelItem->loadCategory()	JROOT/components/com_fwgallery/views/item/view.html.php:36
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT
    c.*,
	(SELECT u.name 
  FROM `dm4t9_users` AS u 
  WHERE u.id = c.user_id 
  LIMIT 1) AS _user_name,
	(SELECT COUNT(*) 
  FROM `dm4t9_fwsg_category` AS cc 
  WHERE cc.parent = c.id 
  AND cc.published = 1) AS _qty,
	(SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file` AS f 
  WHERE (f.type = 'image' 
  AND f.published = 1 
  AND f.category_id = c.id)  OR (f.type = 'image' 
  AND f.published = 1 
  AND EXISTS(SELECT * 
  FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.tag_id = ft.tag_id 
  AND ct.category_id = c.id 
  AND ft.file_id = f.id))) AS _images_qty
    ,'' AS _tags,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_category_tag` AS ft, `dm4t9_fwsg_tag` AS t 
  WHERE t.id = ft.tag_id 
  AND ft.category_id =  c.id) AS _tags_qty,(SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file` AS f 
  WHERE (f.category_id = c.id 
  AND f.`type` = 'video' 
  AND f.published = 1) OR (f.type = 'video' 
  AND f.published = 1 
  AND EXISTS(SELECT * 
  FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.tag_id = ft.tag_id 
  AND ct.category_id = c.id 
  AND ft.file_id = f.id))) AS _videos_qty,(SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file` AS f 
  WHERE (f.category_id = c.id 
  AND f.`type` = 'audio' 
  AND f.published = 1) OR (f.type = 'audio' 
  AND f.published = 1 
  AND EXISTS(SELECT * 
  FROM `dm4t9_fwsg_category_tag` AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.tag_id = ft.tag_id 
  AND ct.category_id = c.id 
  AND ft.file_id = f.id))) AS _audios_qty

  FROM
    `dm4t9_fwsg_category` AS c

  WHERE
    c.id = 104

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_fwgallery/tables/category.php:68
11	TableCategory->load()	JROOT/components/com_fwgallery/models/item.php:49
10	fwGalleryModelItem->loadCategory()	JROOT/components/com_fwgallery/views/item/view.html.php:36
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.77 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.381 MB mémoire avant requête : 12.046 MB Rangées retournées : 215

SELECT
    c.id,
	c.parent,
	c.published,
	c.name,
	c.params

  FROM
    dm4t9_fwsg_category AS c

  ORDER BY
    `parent`,
    ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	211	100.00	Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	2.74 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 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:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:960
11	fwgHelper::loadCategories()	JROOT/components/com_fwgallery/helpers/helper.php:1299
10	fwgHelper::getParentGalleries()	JROOT/components/com_fwgallery/views/item/view.html.php:56
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 11.08 ms Après la dernière requête : 4.59 ms Mémoire de requête : 2.056 MB mémoire avant requête : 13.755 MB Rangées retournées : 8340

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:478
27	plgFwGallerySeoBooster->getImageData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:290
26	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
25	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
24	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
23	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
22	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
14	fwgHelper::route()	JROOT/plugins/fwgallery/social/social.php:102
13	plgFwGallerySocial->onbeforeFileDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
10	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/views/item/view.html.php:57
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.97 ms Après la dernière requête : 13.73 ms Mémoire de requête : 0.035 MB mémoire avant requête : 22.538 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.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.19 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	1.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_fwgallery/models/item.php:87
11	fwGalleryModelItem->_getFilesWhere()	JROOT/components/com_fwgallery/models/item.php:209
10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.87 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.033 MB mémoire avant requête : 22.734 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.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.43 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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/helpers/helper.php:1491
18	fwgHelper::loadPlugins()	JROOT/components/com_fwgallery/helpers/helper.php:1507
17	fwgHelper::pluginEnabled()	JROOT/plugins/fwgallery/featured/featured.php:84
16	plgFwGalleryFeatured->ongetFilesListExtraOrdering()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/models/fwgallery.php:254
12	fwGalleryModelFwGallery->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/item.php:111
11	fwGalleryModelItem->_getFilesOrderClause()	JROOT/components/com_fwgallery/models/item.php:210
10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 135.92 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.107 MB mémoire avant requête : 22.761 MB Rangées retournées : 174

SELECT
    f.id
    , (SELECT fl.address 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _address, (SELECT fl.longitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _longitude, (SELECT fl.latitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _latitude,'' AS _tags, (
  CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
    (SELECT SUM(v.value) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _rating_sum,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.ipaddr = 59838979) AS _is_ip_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.user_id = 0) AS _is_user_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value < 0) AS _negative_rating_count,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _positive_rating_count,
	EXISTS(SELECT * 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id) AS _video_exists,
	(SELECT fv.`sys_filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_sys_filename,
	(SELECT fv.`filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_filename,
	(SELECT fv.`media` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_media,
	(SELECT fv.`code` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_code,
	(SELECT fv.`width` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_width,
	(SELECT fv.`height` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_height,
	(SELECT fv.`duration` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_duration,
	(SELECT fv.`size` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1	) AS _video_size,
	EXISTS(SELECT * 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id) AS _audio_exists,
	(SELECT fau.`sys_filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_sys_filename,
	(SELECT fau.`filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_filename,
	(SELECT fau.`duration` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_duration,
	(SELECT fau.`size` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_size

  FROM
    dm4t9_fwsg_file AS f
    
  LEFT JOIN `dm4t9_viewlevels` AS fa 
  ON fa.id = f.`access`
    
  LEFT JOIN `dm4t9_fwsg_category` AS c 
  ON c.id = f.category_id
    
  LEFT JOIN `dm4t9_viewlevels` AS ca 
  ON ca.id = c.`access`
    
  LEFT JOIN `dm4t9_users` AS u 
  ON u.id = f.user_id
    
  LEFT JOIN `dm4t9_fwsg_file_image` AS fi 
  ON fi.file_id = f.id
    
	
  LEFT JOIN dm4t9_fwsg_file_video AS fv 
  ON fv.file_id = f.id
	
  LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
  ON fau.file_id = f.id

  WHERE f.published = 1 
  AND c.published = 1 
  AND f.`type` IN ('image','video','audio') 
  AND (c.`access` = 0 OR c.access IN (1,3)) 
  AND (f.`access` = 0 OR f.access IN (1,3)) 
  AND (f.category_id = 104 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (104) 
  AND ct.tag_id = ft.tag_id 
  AND ft.file_id = f.id))

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8208	75.00	Using where; Utilisation du tri complet de type filesort
1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_fwgallery/models/item.php:212
10	fwGalleryModelItem->getFilePosition()	JROOT/components/com_fwgallery/views/item/view.html.php:60
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 91.54 ms Après la dernière requête : 0.63 ms Mémoire de requête : 0.063 MB mémoire avant requête : 22.774 MB Rangées retournées : 30

SELECT
    f.*,
    fi.alt AS _alt,
    fi.width AS _width,
    fi.height AS _height,
    fi.size AS _size,
	fi.sys_filename AS _sys_filename,
    c.name AS _category_name,
    u.name AS _user_name
    , (SELECT fl.address 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _address, (SELECT fl.longitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _longitude, (SELECT fl.latitude 
  FROM `dm4t9_fwsg_file_location` AS fl 
  WHERE fl.file_id = f.id 
  LIMIT 1) AS _latitude,'' AS _tags, (
  CASE WHEN f.category_id IN (0) THEN 0 ELSE 1 END) AS _tags_orderng,
    (SELECT SUM(v.value) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _rating_sum,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.ipaddr = 59838979) AS _is_ip_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.user_id = 0) AS _is_user_voted,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value < 0) AS _negative_rating_count,
    (SELECT COUNT(*) 
  FROM `dm4t9_fwsg_file_vote` AS v 
  WHERE v.file_id = f.id 
  AND v.value > 0) AS _positive_rating_count,
	EXISTS(SELECT * 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id) AS _video_exists,
	(SELECT fv.`sys_filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_sys_filename,
	(SELECT fv.`filename` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_filename,
	(SELECT fv.`media` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_media,
	(SELECT fv.`code` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_code,
	(SELECT fv.`width` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_width,
	(SELECT fv.`height` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_height,
	(SELECT fv.`duration` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1) AS _video_duration,
	(SELECT fv.`size` 
  FROM dm4t9_fwsg_file_video AS fv 
  WHERE fv.file_id = f.id 
  LIMIT 1	) AS _video_size,
	EXISTS(SELECT * 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id) AS _audio_exists,
	(SELECT fau.`sys_filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_sys_filename,
	(SELECT fau.`filename` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_filename,
	(SELECT fau.`duration` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_duration,
	(SELECT fau.`size` 
  FROM `dm4t9_fwsg_file_audio` AS fau 
  WHERE fau.file_id = f.id 
  LIMIT 1) AS _audio_size

  FROM
    dm4t9_fwsg_file AS f
    
  LEFT JOIN dm4t9_viewlevels AS fa 
  ON fa.id = f.`access`
    
  LEFT JOIN dm4t9_fwsg_category AS c 
  ON c.id = f.category_id
    
  LEFT JOIN dm4t9_viewlevels AS ca 
  ON ca.id = c.`access`
    
  LEFT JOIN dm4t9_users AS u 
  ON u.id = f.user_id
    
  LEFT JOIN dm4t9_fwsg_file_image AS fi 
  ON fi.file_id = f.id
    
	
  LEFT JOIN dm4t9_fwsg_file_video AS fv 
  ON fv.file_id = f.id
	
  LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
  ON fau.file_id = f.id

  WHERE f.published = 1 
  AND c.published = 1 
  AND f.`type` IN ('image','video','audio') 
  AND (c.`access` = 0 OR c.access IN (1,3)) 
  AND (f.`access` = 0 OR f.access IN (1,3)) 
  AND (f.category_id = 104 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (104) 
  AND ct.tag_id = ft.tag_id 
  AND ft.file_id = f.id))

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8208	75.00	Using where; Utilisation du tri complet de type filesort
1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where
1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
24	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
24	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
23	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
22	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
21	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
20	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
19	DEPENDENT SUBQUERY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
18	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
17	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
16	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
15	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
14	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
13	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
12	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
11	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
10	DEPENDENT SUBQUERY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
9	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
8	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
7	DEPENDENT SUBQUERY	v	ref	user_id,file_id	user_id	4	const	1	100.00	Using where
6	DEPENDENT SUBQUERY	v	ref	file_id,ipaddr	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
5	DEPENDENT SUBQUERY	v	ref	file_id,value	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where
4	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
3	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL
2	DEPENDENT SUBQUERY	fl	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/components/com_fwgallery/models/item.php:145
10	fwGalleryModelItem->loadFiles()	JROOT/components/com_fwgallery/views/item/view.html.php:67
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

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

  WHERE
    t.id = ft.tag_id
    
  AND t.published = 1
    
  AND
    f.id = ft.file_id
    
  AND
    ft.file_id IN (2356,2349,2350,2351,2352,2353,2354,2355,2342,2343,2344,2345,2346,2347,2348,2336,2337,2338,2339,2340,2341,2329,2330,2331,2332,2333,2334,2335,2323,2324)

  ORDER BY
    t.name

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.02 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.02 ms
end	0.00 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/item.php:150
10	fwGalleryModelItem->loadFiles()	JROOT/components/com_fwgallery/views/item/view.html.php:67
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT
    COUNT(*)

  FROM
    dm4t9_fwsg_file AS f
    
  LEFT JOIN dm4t9_viewlevels AS fa 
  ON fa.id = f.`access`

    
  LEFT JOIN dm4t9_fwsg_category AS c 
  ON c.id = f.category_id
    
  LEFT JOIN dm4t9_viewlevels AS ca 
  ON ca.id = c.`access`

    
  LEFT JOIN dm4t9_users AS u 
  ON u.id = f.user_id
    
  LEFT JOIN dm4t9_fwsg_file_image AS fi 
  ON fi.file_id = f.id
    
	
  LEFT JOIN dm4t9_fwsg_file_video AS fv 
  ON fv.file_id = f.id
	
  LEFT JOIN `dm4t9_fwsg_file_audio` AS fau 
  ON fau.file_id = f.id


  WHERE f.published = 1 
  AND c.published = 1 
  AND f.`type` IN ('image','video','audio') 
  AND (c.`access` = 0 OR c.access IN (1,3)) 
  AND (f.`access` = 0 OR f.access IN (1,3)) 
  AND (f.category_id = 104 OR EXISTS(SELECT * 
  FROM dm4t9_fwsg_category_tag AS ct, `dm4t9_fwsg_file_tag` AS ft 
  WHERE ct.category_id IN (104) 
  AND ct.tag_id = ft.tag_id 
  AND ft.file_id = f.id))

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	f	ALL	type,published,access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8208	75.00	Using where
1	PRIMARY	fa	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.access	1	100.00	Using index
1	PRIMARY	c	eq_ref	PRIMARY,published,access	PRIMARY	4	bxv_canoeclubgenevech13_2.f.category_id	1	100.00	Using where
1	PRIMARY	ca	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.c.access	1	100.00	Using index
1	PRIMARY	u	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.user_id	1	100.00	Using where; Using index
1	PRIMARY	fi	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
1	PRIMARY	fv	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
1	PRIMARY	fau	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using index
2	DEPENDENT SUBQUERY	ct	ref	category_id,tag_id	category_id	4	const	1	100.00	NULL
2	DEPENDENT SUBQUERY	ft	ref	file_id,tag_id	file_id	4	bxv_canoeclubgenevech13_2.f.id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_fwgallery/models/item.php:175
11	fwGalleryModelItem->loadFilesQty()	JROOT/components/com_fwgallery/models/item.php:180
10	fwGalleryModelItem->getFilesPagination()	JROOT/components/com_fwgallery/views/item/view.html.php:69
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28

SELECT mm.menuid, m.params, e.element 
  FROM `dm4t9_modules` AS m, `dm4t9_modules_menu` AS mm, `dm4t9_menu` AS me, `dm4t9_extensions` AS e 
  WHERE e.extension_id = me.component_id 
  AND me.published = 1 
  AND me.id = mm.menuid 
  AND mm.moduleid = m.id 
  AND m.published = 1 
  AND m.module = 'mod_fwgallery'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	newsfeeds	204	const,const	1	100.00	Using index condition
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.m.id	1	100.00	Using index
1	SIMPLE	me	eq_ref	PRIMARY,idx_componentid	PRIMARY	4	bxv_canoeclubgenevech13_2.mm.menuid	1	100.00	Using where
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.me.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.14 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:209
30	plgFwGallerySeoBooster->getItemId()	JROOT/plugins/fwgallery/seobooster/seobooster.php:239
29	plgFwGallerySeoBooster->ongetRouteItemId()	JROOT/libraries/joomla/event/event.php:70
28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:21
25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.65 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.062 MB mémoire avant requête : 23.389 MB Rangées retournées : 215

SELECT
	c.id,
	c.name,
	c.alias

  FROM
	dm4t9_fwsg_category AS c

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.21 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
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:457
30	plgFwGallerySeoBooster->getCategoryData()	JROOT/plugins/fwgallery/seobooster/seobooster.php:351
29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
31	JDatabaseDriver->loadObject()	JROOT/components/com_fwgallery/helpers/helper.php:1095
30	fwgHelper::loadCategoriesPath()	JROOT/plugins/fwgallery/seobooster/seobooster.php:354
29	plgFwGallerySeoBooster->onbuildRoute()	JROOT/libraries/joomla/event/event.php:70
28	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
27	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
26	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:41
25	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
17	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:36
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.48 ms Après la dernière requête : 0.65 ms Mémoire de requête : 0.043 MB mémoire avant requête : 23.630 MB Rangées retournées : 0

Requêtes dupliquées: #23

SELECT mm.menuid, m.params, e.element 
  FROM `dm4t9_modules` AS m, `dm4t9_modules_menu` AS mm, `dm4t9_menu` AS me, `dm4t9_extensions` AS e 
  WHERE e.extension_id = me.component_id 
  AND me.published = 1 
  AND me.id = mm.menuid 
  AND mm.moduleid = m.id 
  AND m.published = 1 
  AND m.module = 'mod_fwgallery'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	newsfeeds	204	const,const	1	100.00	Using index condition
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.m.id	1	100.00	Using index
1	SIMPLE	me	eq_ref	PRIMARY,idx_componentid	PRIMARY	4	bxv_canoeclubgenevech13_2.mm.menuid	1	100.00	Using where
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	bxv_canoeclubgenevech13_2.me.component_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
38	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
37	JDatabaseDriver->loadObjectList()	JROOT/plugins/fwgallery/seobooster/seobooster.php:209
36	plgFwGallerySeoBooster->getItemId()	JROOT/plugins/fwgallery/seobooster/seobooster.php:239
35	plgFwGallerySeoBooster->ongetRouteItemId()	JROOT/libraries/joomla/event/event.php:70
34	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
33	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
32	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_fwgallery/router.php:21
31	fwGalleryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
30	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
29	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
28	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
27	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
26	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
25	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
24	Joomla\CMS\Router\Route::_()	JROOT/components/com_fwgallery/helpers/helper.php:593
23	fwgHelper::route()	JROOT/plugins/fwgallerytmpl/classic/plugins/social/awesome.php:19
22	include JROOT/plugins/fwgallerytmpl/classic/plugins/social/awesome.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
21	fwgHelper::loadTemplate()	JROOT/plugins/fwgallery/social/social.php:93
20	plgFwGallerySocial->onshowFileExtraFields()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
17	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/fwgallerytmpl/classic/item/right.php:63
16	include JROOT/plugins/fwgallerytmpl/classic/item/right.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
15	fwgHelper::loadTemplate()	JROOT/plugins/fwgallerytmpl/classic/item/item.php:59
14	include JROOT/plugins/fwgallerytmpl/classic/item/item.php	JROOT/components/com_fwgallery/helpers/helper.php:1433
13	fwgHelper::loadTemplate()	JROOT/components/com_fwgallery/views/item/tmpl/default.php:11
12	include JROOT/components/com_fwgallery/views/item/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_fwgallery/views/item/view.html.php:75
9	fwGalleryViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
8	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_fwgallery/fwgallery.php:24
6	require_once JROOT/components/com_fwgallery/fwgallery.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM dm4t9_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-07-27 04:14:19') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 04:14:19') 
  AND m.access IN (1,3) 
  AND m.client_id = 0 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT uikit

  FROM `dm4t9_cwgears`

  WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/expeditions-voyages/turquie-2006/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-turquie-elizabeth-04-2006-imgp1340-custom-text-f2343'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.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: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.10 ms Mémoire de requête : 0.027 MB mémoire avant requête : 24.292 MB Rangées retournées : 0

SELECT uikit_plus

  FROM `dm4t9_cwgears`

  WHERE url = 'https://canoe-club-geneve.ch/component/fwgallery/item/expeditions-voyages/turquie-2006/canoe-club-de-geneve-kayak-et-eaux-vives-sont-notre-plaisir-turquie-elizabeth-04-2006-imgp1340-custom-text-f2343'

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.03 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]

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

Tables sélectionnées :

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

2 × SELECT mm.menuid, m.params, e.element 
  FROM `dm4t9_modules` AS m, `dm4t9_modules_menu` AS mm, `dm4t9_menu` AS me, `dm4t9_extensions` AS e

1 × SELECT `data` 
  FROM `dm4t9_session`

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

1 × SELECT uikit 
  FROM `dm4t9_cwgears`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM dm4t9_modules AS m 
  LEFT JOIN dm4t9_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN dm4t9_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

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

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
     f.id
     , (SELECT fl.address 
  FROM `dm4t9_fwsg_file_location` AS fl

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

1 × SELECT id, rules 
  FROM `dm4t9_viewlevels

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.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 DISTINCT
     t.id,
  t.published,
     t.name,
  t.alias
 
  FROM
     `dm4t9_fwsg_file_tag` AS ft,
     `dm4t9_fwsg_tag` AS t

1 × SELECT
     f.*,
  fi.file_id AS _image_exists,
  fi.filename AS `_filename`,
  fi.sys_filename AS _sys_filename,
     fi.alt AS _alt,
     fi.width AS _width,
     fi.height AS _height,
     fi.size AS _size,
 
     u.name AS _user_name,
     p.name AS _category_name,
  p.params AS params,
     (SELECT g.title 
  FROM `dm4t9_viewlevels` AS g

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 uikit_plus 
  FROM `dm4t9_cwgears`

Autres tables :

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

1 × SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_file

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

1 × SHOW FULL COLUMNS 
  FROM `dm4t9_fwsg_category