Ruhi, Cahier 8, unité 1

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1730419883,
                "last": 1730419883,
                "now": 1730419883
            },
            "token": "vrXeIBjopRG7OSJWUN6BerRXaHXgvc5Q"
        },
        "registry": {
            "justmine_fv_ses": "0"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "fr-CA"
        },
        "com_mailto": {
            "links": {
                "f51e7e8f4379cb54e9d93e2fb2439573680ec2a5": {
                    "link": "http://bahaimontreal.org/fr-ca/calendriers/icalrepeat.detail/2021/07/12/4375/-/-",
                    "expiry": 1730419883
                }
            }
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 1.46 ms / 1.46 ms Mémoire: 0.421 MB / 0.75 MB Application: afterLoad

Temps: 10.58 ms / 12.04 ms Mémoire: 1.242 MB / 2.00 MB Application: afterInitialise

Temps: 3.35 ms / 15.39 ms Mémoire: 0.269 MB / 2.26 MB Application: afterRoute

Temps: 0.23 ms / 15.62 ms Mémoire: 0.043 MB / 2.31 MB Application: beforeRenderComponent com_jevents

Temps: 2.42 ms / 18.04 ms Mémoire: 0.399 MB / 2.71 MB Application: Before Access::preloadComponents (all components)

Temps: 0.92 ms / 18.97 ms Mémoire: 0.064 MB / 2.77 MB Application: After Access::preloadComponents (all components)

Temps: 0.02 ms / 18.99 ms Mémoire: -0.003 MB / 2.77 MB Application: Before Access::getAssetRules (id:151 name:com_jevents)

Temps: 0.09 ms / 19.07 ms Mémoire: 0.008 MB / 2.77 MB Application: After Access::getAssetRules (id:151 name:com_jevents)

Temps: 14.54 ms / 33.62 ms Mémoire: 0.842 MB / 3.62 MB Application: Before Access::preloadPermissions (com_jevents)

Temps: 0.53 ms / 34.15 ms Mémoire: 0.024 MB / 3.64 MB Application: After Access::preloadPermissions (com_jevents)

Temps: 0.01 ms / 34.16 ms Mémoire: -0.000 MB / 3.64 MB Application: Before Access::getAssetRules (id:427 name:com_jevents.category.50)

Temps: 0.01 ms / 34.17 ms Mémoire: 0.002 MB / 3.64 MB Application: After Access::getAssetRules (id:427 name:com_jevents.category.50)

Temps: 7.96 ms / 42.13 ms Mémoire: 0.204 MB / 3.85 MB Application: afterRenderComponent com_jevents

Temps: 1.91 ms / 44.04 ms Mémoire: 0.041 MB / 3.89 MB Application: afterDispatch

Temps: 9.18 ms / 53.21 ms Mémoire: 0.805 MB / 4.69 MB Application: beforeRenderModule mod_s5_box (S5 Box)

Temps: 0.51 ms / 53.73 ms Mémoire: 0.011 MB / 4.70 MB Application: afterRenderModule mod_s5_box (S5 Box)

Temps: 0.33 ms / 54.06 ms Mémoire: 0.023 MB / 4.73 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 0.36 ms / 54.42 ms Mémoire: 0.011 MB / 4.74 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Temps: 0.31 ms / 54.73 ms Mémoire: -0.001 MB / 4.74 MB Application: beforeRenderModule mod_search (Search)

Temps: 0.40 ms / 55.12 ms Mémoire: 0.010 MB / 4.75 MB Application: afterRenderModule mod_search (Search)

Temps: 1.30 ms / 56.42 ms Mémoire: 0.102 MB / 4.85 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_session	const	PRIMARY	PRIMARY	194	const	1

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

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

EXPLAIN impossible sur la requête : INSERT INTO `ux026_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3533643365616631313266396438663462613339336564656362316563643334', 1, 1730419883, 0, '', 0)

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.06 ms
Waiting for query cache lock	0.00 ms
Update	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.02 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 0.32 ms Après la dernière requête : 0.53 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.102 MB Rangées retournées : 3

SELECT id, rules

  FROM `ux026_viewlevels`

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_viewlevels	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.01 ms
Reset for next command	0.00 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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.32 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.113 MB Rangées retournées : 1

SELECT b.id

  FROM ux026_usergroups AS a

  LEFT JOIN ux026_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	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.49 ms Après la dernière requête : 6.44 ms Mémoire de requête : 0.006 MB mémoire avant requête : 2.186 MB

UPDATE `ux026_extensions`

  SET `params` = '{\"mediaversion\":\"9c0a3e8ad281da3537a8612998509f09\"}'

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

Explication

EXPLAIN impossible sur la requête : UPDATE `ux026_extensions` SET `params` = '{\"mediaversion\":\"9c0a3e8ad281da3537a8612998509f09\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init for update	0.13 ms
Updating	0.05 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 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/k2/k2.php:374
8	plgSystemK2->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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.81 ms Après la dernière requête : 4.00 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.711 MB Rangées retournées : 39

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

  FROM `ux026_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_vertexupdate','com_weblinks','com_wrapper','com_zhgooglemap')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_assets	range	idx_asset_name	idx_asset_name	202	NULL	40	Using index condition

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.33 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 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_jevents/libraries/helper.php:1428
11	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1386
10	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:50
9	JEventsDataModel->__construct()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:46
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'Tag'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'Category'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.20 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.831 MB Rangées retournées : 1

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'Contact'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.21 ms Après la dernière requête : 0.18 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.845 MB Rangées retournées : 1

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'Article'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.23 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.007 MB mémoire avant requête : 2.860 MB Rangées retournées : 1

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'News Feed'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.03 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT `id`

  FROM `ux026_finder_types`

  WHERE `title` = 'Web Link'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_finder_types	const	title	title	402	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.00 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:729
12	FinderIndexerAdapter->getTypeId()	JROOT/administrator/components/com_finder/helpers/indexer/adapter.php:142
11	FinderIndexerAdapter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
10	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
9	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/administrator/components/com_jevents/controllers/icalrepeat.php:49
8	AdminIcalrepeatController->__construct()	JROOT/components/com_jevents/controllers/icalrepeat.php:30
7	ICalRepeatController->__construct()	JROOT/components/com_jevents/jevents.php:311
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.68 ms Après la dernière requête : 0.99 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.005 MB Rangées retournées : 18

SHOW FULL COLUMNS 
  FROM `ux026_jev_users`

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.24 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.00 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.06 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.07 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.00 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/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
15	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1851
14	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:2423
13	JEVHelper::isEventPublisher()	JROOT/components/com_jevents/libraries/dbmodel.php:599
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.34 ms Après la dernière requête : 0.54 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.069 MB Rangées retournées : 17

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

  FROM ux026_modules AS m

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

  LEFT JOIN ux026_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-11-01 00:11:23') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-11-01 00:11:23') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 412 OR mm.menuid <= 0) 
  AND m.language IN ('fr-CA','*')

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	118	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	petitsv_jooMont.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	petitsv_jooMont.m.id	2	Using where; Using index

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.83 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/components/com_jevents/libraries/jevmodulehelper.php:25
15	JevModuleHelper::getVisibleModules()	JROOT/components/com_jevents/libraries/filters.php:67
14	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:257
13	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:627
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.50 ms Après la dernière requête : 0.73 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.149 MB Rangées retournées : 3

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `ux026_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND c.language IN ('fr-CA','*')

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	4	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 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/Categories/Categories.php:324
16	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
15	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:422
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:633
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.53 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.178 MB Rangées retournées : 2

SELECT c.id

  FROM ux026_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('fr-CA','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	cat_idx,idx_access,idx_language	cat_idx	207	const,const,const	3	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.14 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:558
13	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:633
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.60 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.185 MB Rangées retournées : 1

SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.rawdata as evrawdata, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn 
 , ev.state as state 
 
  FROM (ux026_jevents_vevent as ev )
 
  INNER JOIN ux026_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN ux026_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id
 
  INNER JOIN ux026_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  WHERE ev.catid IN(-1,34,50)
 
  AND ev.access IN (1,1) 
  AND icsf.access IN (1,1)
 
  AND rpt.rp_id = '4375'
 
  GROUP BY rpt.rp_id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	icsf	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1
1	SIMPLE	rpt	const	PRIMARY,eventid,eventstart,eventend,eventdetail	PRIMARY	8	const	1
1	SIMPLE	det	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ev	const	PRIMARY,icsid,evaccess	PRIMARY	4	const	1
1	SIMPLE	rr	ref	eventid	eventid	4	const	1

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:680
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.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.15 ms Mémoire de requête : 0.007 MB mémoire avant requête : 3.308 MB Rangées retournées : 0

SELECT *, summary as title, description as content 
  FROM ux026_jevents_translation 
  WHERE evdet_id IN(40) 
  AND language='fr-CA'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_jevents_translation	ref	evdet_id,langdetail	evdet_id	4	const	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:776
13	JEventsDBModel::translateEvents()	JROOT/components/com_jevents/libraries/dbmodel.php:702
12	JEventsDBModel->listEventsById()	JROOT/components/com_jevents/libraries/datamodel.php:835
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug  
 
  FROM ux026_users AS ju
 
  LEFT JOIN ux026_contact_details AS cd 
  ON cd.user_id = ju.id 
 
  LEFT JOIN ux026_categories AS cat 
  ON cat.id = cd.catid 
 
  WHERE block ='0'
 
  AND cd.published =1 
 
  AND cd.access   IN (1,1)
 
  AND cat.access   IN (1,1)
 
  AND ju.id = 15844

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/helper.php:2989
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:786
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:873
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT `id`

  FROM `ux026_users`

  WHERE `id` = '15844' 
  LIMIT 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_users	const	PRIMARY	PRIMARY	4	const	1	Using index

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 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/components/com_jevents/libraries/helper.php:3048
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2994
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:786
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:873
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.60 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.334 MB Rangées retournées : 22

SHOW FULL COLUMNS 
  FROM `ux026_users`

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.17 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
checking permissions	0.07 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.06 ms
closing tables	0.02 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3055
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2994
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:786
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:873
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.23 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.380 MB Rangées retournées : 1

SELECT *

  FROM `ux026_users`

  WHERE `id` = 15844

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_users	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3055
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2994
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:786
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:873
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.27 ms Après la dernière requête : 0.21 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.394 MB Rangées retournées : 2

SELECT `g`.`id`,`g`.`title`

  FROM `ux026_usergroups` AS g

  INNER JOIN `ux026_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 15844

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.m.group_id	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_jevents/libraries/helper.php:3055
14	JEVHelper::getUser()	JROOT/components/com_jevents/libraries/helper.php:2994
13	JEVHelper::getContact()	JROOT/components/com_jevents/libraries/jeventshtml.php:786
12	JEventsHTML::getUserMailtoLink()	JROOT/components/com_jevents/libraries/datamodel.php:873
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.35 ms Après la dernière requête : 0.97 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.446 MB

UPDATE ux026_jevents_vevdetail 
  SET hits=(hits+1) 
  WHERE evdet_id='40'

Explication

EXPLAIN impossible sur la requête : UPDATE ux026_jevents_vevdetail SET hits=(hits+1) WHERE evdet_id='40'

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.03 ms
Updating	0.06 ms
End of update loop	0.00 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
Waiting for query cache lock	0.00 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/jicaleventdb.php:1128
12	jIcalEventDB->updateHits()	JROOT/components/com_jevents/libraries/datamodel.php:975
11	JEventsDataModel->getEventData()	JROOT/components/com_jevents/views/geraint/icalevent/view.html.php:41
10	GeraintViewICalevent->detail()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:94
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.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 : 0.71 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.588 MB Rangées retournées : 2

SELECT a.id, a.parent_id

  FROM ux026_categories AS a

  WHERE a.parent_id > 0 
  AND a.extension = "com_jevents" 
  AND a.published = 1 
  AND a.language in ('fr-CA','*')

  ORDER BY a.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	cat_idx,idx_language	cat_idx	203	const,const	3	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.00 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/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:46
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.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.03 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.599 MB Rangées retournées : 0

SELECT * 
  FROM ux026_jev_defaults 
  WHERE state=1 
  AND name= 'icalevent.detail_body' 
  AND value<>'' 
  AND language in ('fr-CA','*')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_jev_defaults	ref	name,langcodename	name	152	const	12	Using index condition; Using where

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 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/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:46
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.46 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.620 MB Rangées retournées : 9

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

  FROM `ux026_assets`

  WHERE `name` LIKE 'com_jevents.%' OR `name` = 'com_jevents' OR `parent_id` = 0

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_assets	ALL	idx_asset_name,idx_parent_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	620	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
23	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
22	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:2377
18	JEVHelper::authoriseCategories()	JROOT/components/com_jevents/libraries/helper.php:2579
17	JEVHelper::canDeleteEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1040
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:46
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.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.27 ms Mémoire de requête : 0.010 MB mémoire avant requête : 3.646 MB Rangées retournées : 1

SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ux026_jevents_repetition  as rpt
			 
  LEFT JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=39 
  AND rpt.rp_id <> 4375 
  AND rpt.startrepeat<='2021-07-12 19:30:00' 
  ORDER BY rpt.startrepeat DESC 
  limit 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	9	NULL	44	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.rpt.eventdetail_id	1

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.07 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:448
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:419
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:394
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1620
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:46
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ux026_jevents_repetition  as rpt
			 
  LEFT JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id 
  WHERE rpt.eventid=39 
  AND rpt.rp_id <> 4375 
  AND rpt.startrepeat>='2021-07-12 19:30:00' 
  ORDER BY rpt.startrepeat ASC 
  limit 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	PRIMARY,eventid,eventstart,eventend,startrepeat,startend	eventstart	9	NULL	46	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.rpt.eventdetail_id	1

Profil

Status	Duration
Starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:464
19	jIcalEventRepeat->getAdjacentRepeats()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:419
18	jIcalEventRepeat->prevRepeat()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:394
17	jIcalEventRepeat->previousnextLinks()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:1620
16	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php:46
14	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:5
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.80 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.011 MB mémoire avant requête : 3.702 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `ux026_content`

Explication

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

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.00 ms
closing tables	0.00 ms
checking permissions	0.00 ms
Opening tables	0.22 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
checking permissions	0.12 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.09 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
23	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
22	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
21	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
20	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
19	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.90 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.013 MB mémoire avant requête : 3.783 MB Rangées retournées : 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM ux026_fields AS a

  LEFT JOIN `ux026_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN ux026_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN ux026_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN ux026_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN ux026_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	petitsv_jooMont.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	petitsv_jooMont.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.20 ms
Creating sort index	0.04 ms
Removing tmp table	0.10 ms
Creating sort index	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
26	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
25	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
24	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
23	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
22	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
18	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
16	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
15	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
14	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
13	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.php:8
12	include JROOT/components/com_jevents/views/geraint/icalevent/tmpl/detail.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/administrator/components/com_jevents/views/abstract/abstract.php:133
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/icalrepeat.php:171
8	ICalRepeatController->detail()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:365
6	require_once JROOT/components/com_jevents/jevents.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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.35 ms Après la dernière requête : 2.75 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.858 MB Rangées retournées : 3

SELECT language,id

  FROM `ux026_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.28 ms Après la dernière requête : 0.35 ms Mémoire de requête : 0.006 MB mémoire avant requête : 3.873 MB Rangées retournées : 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `ux026_menu` AS `c`

  INNER JOIN `ux026_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `ux026_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `ux026_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 412

Explication

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
10	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
9	MenusHelper::getAssociations()	JROOT/components/com_jevents/helpers/association.php:99
8	JEventsHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.28 ms Après la dernière requête : 0.02 ms Mémoire de requête : 0.005 MB mémoire avant requête : 3.875 MB Rangées retournées : 0

SELECT t.* 
  FROM ux026_jevents_repetition as r  
  INNER JOIN ux026_jevents_translation as t 
  ON t.evdet_id = r.eventdetail_id 
  WHERE r.rp_id = 4375

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	const	PRIMARY,eventdetail	PRIMARY	8	const	1
1	SIMPLE	t	ref	evdet_id,langdetail	evdet_id	4	const	1

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/helpers/association.php:112
8	JEventsHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT d.* 
  FROM ux026_jevents_repetition as r  
  INNER JOIN ux026_jevents_vevdetail as d 
  ON d.evdet_id = r.eventdetail_id 
  WHERE r.rp_id = 4375

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	r	const	PRIMARY,eventdetail	PRIMARY	8	const	1
1	SIMPLE	d	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_jevents/helpers/association.php:128
8	JEventsHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT * 
  FROM ux026_template_styles 
  WHERE template = 'oasis';

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	ux026_template_styles	ref	idx_template	idx_template	202	const	1	Using index condition

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:20
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:169
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:33
7	require JROOT/templates/oasis/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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

SELECT * 
  FROM ux026_menu 
  WHERE template_style_id IN (13) 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:45
9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:169
8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:33
7	require JROOT/templates/oasis/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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

Requêtes dupliquées: #40

SELECT menutype  
  FROM  ux026_menu 
  WHERE language = 'fr-CA' 
  AND home = 1

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
Sending data	0.07 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.05 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:284
10	include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:169
9	require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12
8	require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php	JROOT/templates/oasis/index.php:276
7	require JROOT/templates/oasis/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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.32 ms Après la dernière requête : 2.67 ms Mémoire de requête : 0.006 MB mémoire avant requête : 4.188 MB Rangées retournées : 1

Requêtes dupliquées: #39

SELECT menutype  
  FROM  ux026_menu 
  WHERE language = 'fr-CA' 
  AND home = 1

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.04 ms
Updating status	0.01 ms
Reset for next command	0.00 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/templates/oasis/vertex/s5flex_menu/default.php:89
8	include JROOT/templates/oasis/vertex/s5flex_menu/default.php	JROOT/templates/oasis/index.php:300
7	require JROOT/templates/oasis/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 xdebogue.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

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

Tables sélectionnées :

6 × SELECT `id` 
  FROM `ux026_finder_types`

2 × SELECT menutype  
  FROM  ux026_menu

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `ux026_assets`

1 × SELECT a.id, a.parent_id 
  FROM ux026_categories AS a

```
1 × SELECT * 
  FROM ux026_menu
```

1 × SELECT * 
  FROM ux026_template_styles

1 × SELECT d.* 
  FROM ux026_jevents_repetition as r  
  INNER JOIN ux026_jevents_vevdetail as d 
  ON d.evdet_id = r.eventdetail_id

1 × SELECT t.* 
  FROM ux026_jevents_repetition as r  
  INNER JOIN ux026_jevents_translation as t 
  ON t.evdet_id = r.eventdetail_id

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `ux026_menu` AS `c` 
  INNER JOIN `ux026_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `ux026_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `ux026_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT language,id 
  FROM `ux026_menu`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM ux026_fields AS a 
  LEFT JOIN `ux026_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN ux026_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN ux026_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN ux026_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN ux026_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT rpt.*,det.summary as title, YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ux026_jevents_repetition  as rpt     
  LEFT JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT rpt.*,det.summary as title , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup 
  FROM ux026_jevents_repetition  as rpt     
  LEFT JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id

1 × SELECT * 
  FROM ux026_jev_defaults

1 × SELECT `data` 
  FROM `ux026_session`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `ux026_usergroups` AS g 
  INNER JOIN `ux026_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT `session_id` 
  FROM `ux026_session`

```
1 × SELECT `id` 
  FROM `ux026_users`
```

1 × SELECT ju.id, ju.name, ju.username, ju.sendEmail, ju.email, cd.name as contactname,  
  CASE WHEN CHAR_LENGTH(cd.alias) THEN CONCAT_WS(':', cd.id, cd.alias) ELSE cd.id END as slug,  
  CASE WHEN CHAR_LENGTH(cat.alias) THEN CONCAT_WS(':', cat.id, cat.alias) ELSE cat.id END AS catslug    
  FROM ux026_users AS ju  
  LEFT JOIN ux026_contact_details AS cd 
  ON cd.user_id = ju.id   
  LEFT JOIN ux026_categories AS cat 
  ON cat.id = cd.catid

1 × SELECT *, summary as title, description as content 
  FROM ux026_jevents_translation

1 × SELECT ev.*, ev.state as published, rpt.*, rr.*, det.* , ev.rawdata as evrawdata, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn   , ev.state as state   
  FROM (ux026_jevents_vevent as ev )  
  INNER JOIN ux026_jevents_repetition as rpt 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN ux026_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN ux026_jevents_rrule as rr 
  ON rr.eventid = ev.ev_id  
  INNER JOIN ux026_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid

1 × SELECT c.id 
  FROM ux026_categories AS c

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `ux026_categories` AS `c`

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

1 × SELECT b.id 
  FROM ux026_usergroups AS a 
  LEFT JOIN ux026_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `ux026_viewlevels

```
1 × SELECT * 
  FROM `ux026_users`
```

Autres tables :

1 × INSERT INTO `ux026_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3533643365616631313266396438663462613339336564656362316563643334', 1, 1730419883, 0, '', 0

1 × UPDATE `ux026_extensions` 
  SET `params` = '{\"mediaversion\":\"9c0a3e8ad281da3537a8612998509f09\"}'

1 × SHOW FULL COLUMNS 
  FROM `ux026_jev_users

1 × SHOW FULL COLUMNS 
  FROM `ux026_users

1 × UPDATE ux026_jevents_vevdetail 
  SET hits=(hits+1)

1 × SHOW FULL COLUMNS 
  FROM `ux026_content

Calendriers

Events Calendar

S5 Box

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

40 requêtes exécutées 16.51 ms

2 doubles découverts!

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

Tables sélectionnées :

Autres tables :