Résultats Compétition

D4M - 14ème et dernière journée

D4M - 13ème journée

D4M - 12ème journée

Nous retiendrons simplement la citation de Gilles de St Jean, encourageant poétiquement ses coéquipiers :

"Ce n'est pas parce qu'on joue en rose, qu'il faut s'enculer sur le terrain."

D4M - 11ème journée

D1H - 10ème journée

D1H J10 Luçon VS Coex

TAVUKOI captain?

-J'ai vu le manque de motivation pour aller jouer Luçon. Merci keke, sans toi on serait restés à Coex.

-J'ai vu la désertion de Fucce pour des prétextes obscurs.

-J'ai vu que Luçon nous attendaient de pied ferme: pas question pour eux de perdre comme au match aller.

-J'ai vu tous nos simples perdus en deux sets, ouille!

-J'ai vu tous nos doubles perdus en deux sets aussi, aïe!

-J'ai vu une cuisante défaite 6-0

-J'ai vu une raquette cassée, ça devait arriver keke depuis le temps.

-J'ai vu notre empressement à quitter la salle

-J'ai vu aller terminer la soirée avec notre D4H qui jouait St Jean de Monts à domicile

-J'ai vu que la bière est meilleure quand on discute et on rigole

-J'ai vu par le passé que les Luçonnais lisent notre modeste chronique Coexienne

A bon entendeur, Salut.

1 commentaire

Sous-catégories

Challenge Vendée 2016-2017 Nombre d'articles : 1

Coupe de Vendée 2016-2017 Nombre d'articles : 1

Hommes 2016-2017 Nombre d'articles : 9

Equipe 1 Nombre d'articles : 9

Mixtes 2016-2017 Nombre d'articles : 14

Page 1 sur 5

Début
Précédent
1
2
3
4
5
Suivant
Fin

Console de débogage Joomla!

Session

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

Profil d'information

Temps

Mémoire

Temps: 30.76 ms / 30.76 ms Mémoire: 1.657 MB / 2.06 MB Application: afterLoad

Temps: 141.60 ms / 172.36 ms Mémoire: 5.125 MB / 7.18 MB Application: afterInitialise

Temps: 30.20 ms / 202.55 ms Mémoire: 1.536 MB / 8.72 MB Application: afterRoute

Temps: 1.52 ms / 204.08 ms Mémoire: 0.025 MB / 8.74 MB Application: beforeRenderComponent com_content

Temps: 6.92 ms / 211.00 ms Mémoire: 0.512 MB / 9.26 MB Application: Before Access::preloadComponents (all components)

Temps: 2.21 ms / 213.21 ms Mémoire: 0.064 MB / 9.32 MB Application: After Access::preloadComponents (all components)

Temps: 0.05 ms / 213.26 ms Mémoire: 0.000 MB / 9.31 MB Application: Before Access::preloadPermissions (com_content)

Temps: 2.45 ms / 215.71 ms Mémoire: 0.218 MB / 9.53 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.05 ms / 215.76 ms Mémoire: 0.000 MB / 9.52 MB Application: Before Access::getAssetRules (id:414 name:com_content.category.59)

Temps: 0.66 ms / 216.42 ms Mémoire: 0.029 MB / 9.55 MB Application: After Access::getAssetRules (id:414 name:com_content.category.59)

Temps: 6.00 ms / 222.42 ms Mémoire: 0.332 MB / 9.88 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.09 ms / 222.51 ms Mémoire: 0.007 MB / 9.89 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 106.98 ms / 329.49 ms Mémoire: 2.213 MB / 12.10 MB Application: afterRenderComponent com_content

Temps: 0.48 ms / 329.97 ms Mémoire: 0.005 MB / 12.11 MB Application: afterDispatch

Temps: 5.47 ms / 335.44 ms Mémoire: 0.216 MB / 12.32 MB Application: beforeRenderModule mod_symp_facebook_like (Like button.)

Temps: 1.52 ms / 336.96 ms Mémoire: 0.111 MB / 12.43 MB Application: afterRenderModule mod_symp_facebook_like (Like button.)

Temps: 0.13 ms / 337.09 ms Mémoire: 0.000 MB / 12.43 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 1.21 ms / 338.30 ms Mémoire: 0.026 MB / 12.46 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 0.12 ms / 338.43 ms Mémoire: 0.000 MB / 12.46 MB Application: beforeRenderModule mod_menu (Menu principal)

Temps: 7.38 ms / 345.81 ms Mémoire: 0.170 MB / 12.63 MB Application: afterRenderModule mod_menu (Menu principal)

Temps: 73.98 ms / 419.79 ms Mémoire: 3.734 MB / 16.36 MB Application: Before Access::getAssetRules (id:206 name:com_autotweet)

Temps: 0.07 ms / 419.85 ms Mémoire: 0.007 MB / 16.37 MB Application: After Access::getAssetRules (id:206 name:com_autotweet)

Temps: 10.60 ms / 430.45 ms Mémoire: 0.153 MB / 16.52 MB Application: afterRender

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

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

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
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 `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3762393031636566653833373835333962333461656530366330636264393037', 1, 1574197145, 0, '', 0)

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.12 ms
end	0.00 ms
query end	62.92 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 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:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 1.11 ms Après la dernière requête : 3.89 ms Mémoire de requête : 0.040 MB mémoire avant requête : 4.276 MB Rangées retournées : 46

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	82	const	46	100.00	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.71 ms Après la dernière requête : 3.50 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.500 MB Rangées retournées : 3

SELECT id, rules

  FROM `j25_viewlevels`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT b.id

  FROM j25_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.42 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.581 MB Rangées retournées : 102

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM j25_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	ref	extension	extension	82	const	165	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.35 ms Après la dernière requête : 47.73 ms Mémoire de requête : 0.052 MB mémoire avant requête : 7.387 MB Rangées retournées : 30

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM j25_menu AS m

  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	49	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.m.component_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `j25_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
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/jcomments/jcomments.php:111
8	plgSystemJComments->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.44 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.006 MB mémoire avant requête : 8.364 MB

UPDATE `j25_extensions`

  SET `params` = '{\"mediaversion\":\"409e592f4faf221915115b034628d5a4\"}'

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

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.06 ms
end	0.01 ms
query end	1.94 ms
closing tables	0.02 ms
freeing items	0.15 ms
cleaning up	0.01 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/jcomments/jcomments.php:111
8	plgSystemJComments->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.01 ms Après la dernière requête : 4.15 ms Mémoire de requête : 0.032 MB mémoire avant requête : 8.706 MB Rangées retournées : 91

SELECT *

  FROM `j25_jcomments_settings`

  WHERE `lang` = '' 
  AND `component` = ''

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jcomments/classes/config.php:140
14	JCommentsCfg::_load()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/components/com_jcomments/classes/config.php:159
11	JCommentsCfg->load()	JROOT/components/com_jcomments/classes/config.php:47
10	JCommentsCfg::getInstance()	JROOT/components/com_jcomments/helpers/system.php:39
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.04 ms Après la dernière requête : 0.46 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.711 MB Rangées retournées : 16

SELECT id, home, template, s.params

  FROM j25_template_styles as s

  LEFT JOIN j25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	28	89.29	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	badmint1_joomla.s.template,const	1	100.00	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_jcomments/helpers/system.php:46
9	JCommentsSystemPluginHelper::getCSS()	JROOT/plugins/system/jcomments/jcomments.php:139
8	plgSystemJComments->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.68 ms Après la dernière requête : 0.61 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.731 MB Rangées retournées : 1

SELECT *

  FROM j25_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.80 ms Après la dernière requête : 7.72 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.260 MB Rangées retournées : 46

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

  FROM `j25_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_akeeba','com_allevents','com_associations','com_autotweet','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gmapfp','com_hdwplayer','com_installer','com_jcomments','com_jevents','com_joomgallery','com_joomlaupdate','com_kunena','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_weblinks','com_webplayer','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_assets	range	idx_asset_name	idx_asset_name	202	NULL	47	100.00	Using index condition

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.22 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.11 ms
cleaning up	0.01 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/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.60 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.060 MB mémoire avant requête : 9.315 MB Rangées retournées : 246

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

  FROM `j25_assets`

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

Explication

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

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	1.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 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/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.87 ms Après la dernière requête : 2.80 ms Mémoire de requête : 0.032 MB mémoire avant requête : 9.674 MB Rangées retournées : 9

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,(
SELECT COUNT(i.`id`)

  FROM `j25_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.published = 1 
  AND s.id = 59

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	PRIMARY	c	ALL	cat_idx,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	61.29	Using where
2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	badmint1_joomla.c.id	3	100.00	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.76 ms Après la dernière requête : 2.94 ms Mémoire de requête : 0.049 MB mémoire avant requête : 9.888 MB Rangées retournées : 9

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM j25_content AS a

  LEFT JOIN j25_categories AS c 
  ON c.id = a.catid

  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN j25_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN j25_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN j25_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 59 OR a.catid IN (
SELECT sub.id

  FROM j25_categories as sub

  INNER JOIN j25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 59)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-11-19 20:59:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-11-19 20:59:05')

  ORDER BY    
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
  LIMIT 9

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	179	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	badmint1_joomla.a.catid	1	100.00	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.a.created_by	1	100.00	Using where
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.a.modified_by	1	100.00	Using where
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.c.parent_id	1	100.00	Using where
1	PRIMARY	v	ALL	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where; Using join buffer (Block Nested Loop)
2	SUBQUERY	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	29	100.00	Using where; Using index

Profil

Status	Duration
starting	0.29 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.62 ms
init	0.12 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	2.61 ms
Creating sort index	0.18 ms
end	0.01 ms
removing tmp table	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
removing tmp table	0.01 ms
freeing items	2.59 ms
cleaning up	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/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.27 ms Après la dernière requête : 2.37 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.112 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 196 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.49 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.132 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 195 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 193 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.46 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.173 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 192 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.46 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.193 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 190 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 189 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.49 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.234 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 191 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 188 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.49 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.274 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 187 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT COUNT(*)

  FROM j25_content AS a

  LEFT JOIN j25_categories AS c 
  ON c.id = a.catid

  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN j25_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN j25_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN j25_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.catid = 59 OR a.catid IN (
SELECT sub.id

  FROM j25_categories as sub

  INNER JOIN j25_categories as this 
  ON sub.lft > this.lft 
  AND sub.rgt < this.rgt

  WHERE this.id = 59)) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-11-19 20:59:05') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-11-19 20:59:05')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	c	ALL	PRIMARY,idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	100.00	Using where
1	PRIMARY	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	badmint1_joomla.c.id	3	100.00	Using index condition; Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.a.created_by	1	100.00	Using where; Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.a.modified_by	1	100.00	Using where; Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.c.parent_id	1	100.00	Using where; Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	badmint1_joomla.a.id	1	100.00	Using where; Using index
2	SUBQUERY	this	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
2	SUBQUERY	sub	range	PRIMARY,idx_left_right	idx_left_right	4	NULL	29	100.00	Using where; Using index

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.09 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	1.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
removing tmp table	0.01 ms
freeing items	0.54 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.52 ms Après la dernière requête : 0.37 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.380 MB Rangées retournées : 0

SELECT `m`.`tag_id`,`t`.*

  FROM `j25_contentitem_tag_map` AS m 

  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 59 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ALL	idx_tag_type	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	badmint1_joomla.m.tag_id	1	100.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	8.95 ms
cleaning up	0.01 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/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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 `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 68

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	62.90	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	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/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jcomments/jcomments.php:94
14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
13	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.86 ms Après la dernière requête : 3.30 ms Mémoire de requête : 0.031 MB mémoire avant requête : 11.054 MB Rangées retournées : 5

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 `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 69

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	59.68	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	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/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jcomments/jcomments.php:94
14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
13	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT count(*)

  FROM j25_jcomments AS c

  WHERE c.object_id = 190 
  AND c.object_group = 'com_content' 
  AND c.published = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
15	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
13	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT count(*)

  FROM j25_jcomments AS c

  WHERE c.object_id = 191 
  AND c.object_group = 'com_content' 
  AND c.published = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	idx_object	idx_object	772	const,const,const	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_jcomments/models/jcomments.php:35
15	JCommentsModel::getCommentsCount()	JROOT/plugins/content/jcomments/jcomments.php:186
14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
13	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.90 ms Après la dernière requête : 0.48 ms Mémoire de requête : 0.031 MB mémoire avant requête : 11.248 MB Rangées retournées : 4

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 `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 64

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	54.84	Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.14 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	12.58 ms
cleaning up	0.02 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/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/jcomments/jcomments.php:94
14	plgContentJComments->onPrepareContent()	JROOT/plugins/content/jcomments/jcomments.php:307
13	plgContentJComments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.05 ms Après la dernière requête : 31.65 ms Mémoire de requête : 0.031 MB mémoire avant requête : 12.100 MB Rangées retournées : 4

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 `j25_categories` AS `s`

  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 65

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Utilisation du tri complet de type filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	62	56.45	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
28	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
27	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
26	ContentRouter->getCategorySegment()	Même appel que celui de la ligne ci-dessous.
25	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
24	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
23	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
22	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
21	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/category/tmpl/blog_children.php:46
16	include JROOT/components/com_content/views/category/tmpl/blog_children.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
15	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/templates/bad_bleu_smash/html/com_content/category/blog.php:87
14	include JROOT/templates/bad_bleu_smash/html/com_content/category/blog.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.27 ms Après la dernière requête : 6.79 ms Mémoire de requête : 0.024 MB mémoire avant requête : 12.308 MB Rangées retournées : 4

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

  FROM j25_modules AS m

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

  LEFT JOIN j25_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 <= '2019-11-19 20:59:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-19 20:59:05') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 14 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

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

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.39 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.25 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.10 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
12	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
11	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
10	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
9	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/bad_bleu_smash/library/Artx/Page.php:42
8	ArtxPage->containsModules()	JROOT/templates/bad_bleu_smash/index.php:68
7	require JROOT/templates/bad_bleu_smash/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.02 ms Après la dernière requête : 20.65 ms Mémoire de requête : 0.033 MB mémoire avant requête : 13.322 MB Rangées retournées : 155

SELECT * 
  FROM j25_acymailing_config

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
7	plgSystemRegacymailing->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.80 ms Après la dernière requête : 27.53 ms Mémoire de requête : 0.040 MB mémoire avant requête : 15.128 MB Rangées retournées : 366

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:502
18	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/f0f/database/driver/joomla.php:251
17	F0FDatabaseDriverJoomla->getTableList()	JROOT/libraries/f0f/table/table.php:2070
16	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
15	F0FTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
14	AutotweetTableAutomator->__construct()	JROOT/libraries/f0f/table/table.php:433
13	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
12	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
11	F0FModel->getTable()	JROOT/administrator/components/com_autotweet/models/automators.php:91
10	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.66 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.025 MB mémoire avant requête : 15.173 MB Rangées retournées : 3

SHOW FULL COLUMNS 
  FROM `j25_autotweet_automator`

Explication

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

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.48 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.41 ms
checking permissions	0.23 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.07 ms
cleaning up	0.01 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:445
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
17	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
16	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
15	F0FTable->__construct()	JROOT/administrator/components/com_autotweet/tables/automator.php:33
14	AutotweetTableAutomator->__construct()	JROOT/libraries/f0f/table/table.php:433
13	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
12	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
11	F0FModel->getTable()	JROOT/administrator/components/com_autotweet/models/automators.php:91
10	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.43 ms Après la dernière requête : 1.27 ms Mémoire de requête : 0.022 MB mémoire avant requête : 15.239 MB Rangées retournées : 1

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`plugin` = 'automator'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
12	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
11	F0FTable->load()	JROOT/administrator/components/com_autotweet/models/automators.php:94
10	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #41

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`id` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
13	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
12	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
11	F0FModel->getItem()	JROOT/administrator/components/com_autotweet/models/automators.php:100
10	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #40

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`id` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
13	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
12	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1357
11	F0FModel->save()	JROOT/administrator/components/com_autotweet/models/automators.php:131
10	AutotweetModelAutomators->_updateLastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:50
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 17.10 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.007 MB mémoire avant requête : 15.260 MB

UPDATE `j25_autotweet_automator` 
  SET `plugin`='automator',`lastexec`='2019-11-19 20:59:05' 
  WHERE `id` = '1'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
15	JDatabaseDriver->updateObject()	JROOT/libraries/f0f/database/driver/joomla.php:435
14	F0FDatabaseDriverJoomla->updateObject()	JROOT/libraries/f0f/table/table.php:1291
13	F0FTable->store()	JROOT/libraries/f0f/table/table.php:3552
12	F0FTable->save()	JROOT/libraries/f0f/model/model.php:1450
11	F0FModel->save()	JROOT/administrator/components/com_autotweet/models/automators.php:131
10	AutotweetModelAutomators->_updateLastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:50
9	AutotweetModelAutomators->lastRunCheck()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:102
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.65 ms Après la dernière requête : 13.00 ms Mémoire de requête : 0.029 MB mémoire avant requête : 16.391 MB Rangées retournées : 19

SHOW FULL COLUMNS 
  FROM `j25_autotweet_requests`

Explication

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

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.41 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.09 ms
closing tables	0.01 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/f0f/database/driver/joomla.php:229
19	F0FDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/f0f/table/table.php:2155
18	F0FTable->getTableFields()	JROOT/libraries/f0f/table/table.php:536
17	F0FTable->__construct()	JROOT/administrator/components/com_autotweet/tables/request.php:33
16	AutotweetTableRequest->__construct()	JROOT/libraries/f0f/table/table.php:433
15	F0FTable::getAnInstance()	JROOT/libraries/f0f/model/model.php:2037
14	F0FModel->_createTable()	JROOT/libraries/f0f/model/model.php:1994
13	F0FModel->getTable()	JROOT/administrator/components/com_autotweet/models/requests.php:134
12	AutotweetModelRequests->buildQuery()	JROOT/libraries/f0f/model/model.php:1219
11	F0FModel->getItemList()	JROOT/administrator/components/com_autotweet/helpers/request.php:338
10	RequestHelp::getRequestList()	JROOT/administrator/components/com_autotweet/helpers/autotweetposthelper.php:99
9	AutotweetPostHelper->postQueuedMessages()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:128
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `j25_autotweet_requests`

  WHERE `publish_up` <= '2019-11-19 20:58:05' 
  AND `published` = '0'

  ORDER BY priority, publish_up ASC 
  LIMIT 0, 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	j25_autotweet_requests	index	NULL	req_publish_up	7	NULL	1	15100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/f0f/database/driver/joomla.php:321
13	F0FDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/f0f/model/model.php:1953
12	F0FModel->_getList()	JROOT/libraries/f0f/model/model.php:1225
11	F0FModel->getItemList()	JROOT/administrator/components/com_autotweet/helpers/request.php:338
10	RequestHelp::getRequestList()	JROOT/administrator/components/com_autotweet/helpers/autotweetposthelper.php:99
9	AutotweetPostHelper->postQueuedMessages()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:128
8	PlgSystemAutotweetAutomator->_onAfterRender()	JROOT/plugins/system/autotweetautomator/autotweetautomator.php:214
7	PlgSystemAutotweetAutomator->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.20 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.005 MB mémoire avant requête : 16.433 MB


  SET sql_big_selects=1

Explication

EXPLAIN impossible sur la requête : SET sql_big_selects=1

Profil

Status	Duration
starting	0.07 ms
Opening tables	0.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.05 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:236
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`plugin` = 'content'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
13	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
12	F0FTable->load()	JROOT/administrator/components/com_autotweet/models/automators.php:94
11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
10	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
9	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #48

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`id` = '2'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
13	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1154
12	F0FModel->getItem()	JROOT/administrator/components/com_autotweet/models/automators.php:100
11	AutotweetModelAutomators->lastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:35
10	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
9	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #47

SELECT j25_autotweet_automator.*

  FROM j25_autotweet_automator

  WHERE `j25_autotweet_automator`.`id` = '2'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/libraries/f0f/database/driver/joomla.php:291
14	F0FDatabaseDriverJoomla->loadAssoc()	JROOT/libraries/f0f/table/table.php:949
13	F0FTable->load()	JROOT/libraries/f0f/model/model.php:1357
12	F0FModel->save()	JROOT/administrator/components/com_autotweet/models/automators.php:131
11	AutotweetModelAutomators->_updateLastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:50
10	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
9	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.35 ms Après la dernière requête : 0.50 ms Mémoire de requête : 0.008 MB mémoire avant requête : 16.477 MB

UPDATE `j25_autotweet_automator` 
  SET `plugin`='content',`lastexec`='2019-11-19 20:59:05' 
  WHERE `id` = '2'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
16	JDatabaseDriver->updateObject()	JROOT/libraries/f0f/database/driver/joomla.php:435
15	F0FDatabaseDriverJoomla->updateObject()	JROOT/libraries/f0f/table/table.php:1291
14	F0FTable->store()	JROOT/libraries/f0f/table/table.php:3552
13	F0FTable->save()	JROOT/libraries/f0f/model/model.php:1450
12	F0FModel->save()	JROOT/administrator/components/com_autotweet/models/automators.php:131
11	AutotweetModelAutomators->_updateLastRun()	JROOT/administrator/components/com_autotweet/models/automators.php:50
10	AutotweetModelAutomators->lastRunCheck()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:648
9	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.08 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.021 MB mémoire avant requête : 16.483 MB Rangées retournées : 0

SELECT c.* 
  FROM `j25_content` AS `c` 
  LEFT 
  OUTER JOIN `j25_autotweet_requests` AS `r` 
  ON r.`plugin` = 'autotweetcontent' 
  AND r.`ref_id` = c.`id` 
  LEFT 
  OUTER JOIN `j25_autotweet_posts` AS `p` 
  ON p.`plugin` = 'autotweetcontent' 
  AND p.`ref_id` = c.`id` 
  WHERE r.`ref_id` IS NULL 
  AND p.`ref_id` IS NULL 
  AND c.`state` = 1  
  AND (c.`created` > '2019-11-18 20:59:05' 
  AND c.`created` < '2019-11-19 20:54:05' ) 
  AND (c.`modified` = '0000-00-00 00:00:00' OR c.`modified` IS NULL)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ref	idx_state	idx_state	1	const	179	100.00	Using where
1	SIMPLE	r	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	151	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	p	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	48	100.00	Using where; Using join buffer (Block Nested Loop)

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:677
9	PlgAutotweetBase->executeContentPolling()	JROOT/administrator/components/com_autotweet/helpers/autotweetbase.php:238
8	PlgAutotweetBase->onContentPolling()	JROOT/plugins/system/autotweetcontent/autotweetcontent.php:446
7	PlgSystemAutotweetContent->onAfterRender()	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/CMSApplication.php:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

10 × SELECT `m`.`tag_id`,`t`.* 
  FROM `j25_contentitem_tag_map` AS m  
  INNER JOIN `j25_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

6 × SELECT j25_autotweet_automator.* 
  FROM j25_autotweet_automator

4 × 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 `j25_categories` AS `s` 
  INNER JOIN `j25_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `j25_extensions`

2 × SELECT count(*) 
  FROM j25_jcomments AS c

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

1 × SELECT `data` 
  FROM `j25_session`

1 × SELECT * 
  FROM `j25_autotweet_requests`

1 × SELECT * 
  FROM j25_acymailing_confi

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

1 × SELECT COUNT(*) 
  FROM j25_content AS a 
  LEFT JOIN j25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN j25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN j25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN j25_content_rating AS v 
  ON a.id = v.content_id

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,( SELECT COUNT(i.`id`) 
  FROM `j25_content` AS `i`

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM j25_content AS a 
  LEFT JOIN j25_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN j25_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN j25_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN j25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN j25_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `j25_session`

```
1 × SELECT * 
  FROM j25_languages
```

1 × SELECT id, home, template, s.params 
  FROM j25_template_styles as s 
  LEFT JOIN j25_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT * 
  FROM `j25_jcomments_settings`

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM j25_menu AS m 
  LEFT JOIN j25_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM j25_extensions

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

1 × SELECT id, rules 
  FROM `j25_viewlevels

1 × SELECT c.* 
  FROM `j25_content` AS `c` 
  LEFT 
  OUTER JOIN `j25_autotweet_requests` AS `r` 
  ON r.`plugin` = 'autotweetcontent' 
  AND r.`ref_id` = c.`id` 
  LEFT 
  OUTER JOIN `j25_autotweet_posts` AS `p` 
  ON p.`plugin` = 'autotweetcontent' 
  AND p.`ref_id` = c.`id`

Autres tables :

1 × INSERT INTO `j25_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3762393031636566653833373835333962333461656530366330636264393037', 1, 1574197145, 0, '', 0

1 × UPDATE `j25_extensions` 
  SET `params` = '{\"mediaversion\":\"409e592f4faf221915115b034628d5a4\"}'

```
1 × SHOW TABLE
```

1 × SHOW FULL COLUMNS 
  FROM `j25_autotweet_automator

1 × UPDATE `j25_autotweet_automator` 
  SET `plugin`='automator',`lastexec`='2019-11-19 20:59:05'

1 × SHOW FULL COLUMNS 
  FROM `j25_autotweet_requests

```
1 × 
  SET sql_big_selects=
```

1 × UPDATE `j25_autotweet_automator` 
  SET `plugin`='content',`lastexec`='2019-11-19 20:59:05'

D4M - 14ème et dernière journée

D4M - 13ème journée

D4M - 12ème journée

D4M - 11ème journée

D1H - 10ème journée

Sous-catégories

Challenge Vendée 2016-2017 Nombre d'articles : 1

Coupe de Vendée 2016-2017 Nombre d'articles : 1

Hommes 2016-2017 Nombre d'articles : 9

Equipe 1 Nombre d'articles : 9

Mixtes 2016-2017 Nombre d'articles : 14

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

50 requêtes exécutées 144.63 ms

4 doubles découverts!

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

Tables sélectionnées :

Autres tables :