GESTION DE TRESORERIE

Le logiciel qui fait la comptabilité à votre place

SCENARIO DE REPRISE D'ENTREPRISE

simulation financière de la reprise

FORMATION SUR LE SCÈNARIO DE REPRISE

version scénario express

présentation du logiciel

ergonomie du logiciel

articulation du logiciel

saisie des bilans

retraitement du résultat

rachats de parts de société

montage LBO

gestion des hypothèses

version scénario approfondi

inclut les vidéos de scénario express

présentation

gestion des emprunts

gestion des investissements

prévision du BFR

le résultat prévisionnel

les professions libérales

pilotomatic

Les professions libérales ont une activité qui autorise une comptabilité allègée que peut tenir lui même le professionnel. Grâce à Pilotomatic on saisira des entrées et des sorties traduites ensuite en écritures comptables.

les associations

pilotomatic

C'est dans les associations où les compétences comptables sont absentes que Pilotomatic est le plus indiqué. Les administrateurs eux mêmes ou la secrétaire pourront faire la comptabilité au jour le jour en autonomie.

les entreprises

pilotomatic

Pilotomatic n'a pas de limites mais est plutôt adapté à une TPE , qu'elle soit en recettes/dépenses en micro entreprise , ou en comptabilité classique au réel simplifé ou au réel normal.

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1560638259,
                "last": 1560638259,
                "now": 1560638259
            },
            "client": {
                "forwarded": "54.85.162.213"
            },
            "token": "snsu4nMUVChviv04YdYW9Y7eUlXXQvxT"
        },
        "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

Occupation de la mémoire

Requêtes de base de données

39 requêtes exécutées 45.22 ms

Temps de requête : 0.79 ms Mémoire de requête : 0.018 MB mémoire avant requête : 3.004 MB Rangées retournées : 0

SELECT `data`

  FROM `hb08h_session`

  WHERE `session_id` = 'dcd9bacf98022a834914c1a891acd955'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_session	const	PRIMARY	PRIMARY	766	const	1

Profil

Status	Duration
starting	0.09 ms
Waiting for query cache lock	0.02 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.54 ms Après la dernière requête : 2.49 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.213 MB

DELETE 

  FROM `hb08h_session`

  WHERE `time` < '1560636459'

Explication

EXPLAIN impossible sur la requête : DELETE FROM `hb08h_session` WHERE `time` < '1560636459'

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.06 ms
updating	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:46

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

Temps de requête : 0.53 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.224 MB Rangées retournées : 0

SELECT `session_id`

  FROM `hb08h_session`

  WHERE `session_id` = 'dcd9bacf98022a834914c1a891acd955' 
  LIMIT 1

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.23 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.73 ms Après la dernière requête : 0.15 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.239 MB

INSERT INTO `hb08h_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('dcd9bacf98022a834914c1a891acd955', 0, 1, '1560638259', 0, '')

Explication

EXPLAIN impossible sur la requête : INSERT INTO `hb08h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('dcd9bacf98022a834914c1a891acd955', 0, 1, '1560638259', 0, '')

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.02 ms
update	0.06 ms
Waiting for query cache lock	0.01 ms
update	0.02 ms
end	0.02 ms
query end	1.25 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::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.08 ms Après la dernière requête : 5.41 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.815 MB Rangées retournées : 2

SELECT b.id

  FROM hb08h_usergroups AS a

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

  WHERE a.id = 9

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.02 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:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.71 ms Mémoire de requête : 0.015 MB mémoire avant requête : 3.891 MB Rangées retournées : 16

SELECT id, rules

  FROM `hb08h_viewlevels`

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.02 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:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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 : 16.66 ms Mémoire de requête : 0.014 MB mémoire avant requête : 5.321 MB Rangées retournées : 2

SELECT element

  FROM hb08h_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_extensions	ref	extension	extension	82	const	4	Using index condition; Using where

Profil

Status	Duration
starting	0.04 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 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.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1689
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.64 ms Après la dernière requête : 8.90 ms Mémoire de requête : 0.039 MB mémoire avant requête : 6.071 MB Rangées retournées : 43

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 hb08h_menu AS m

  LEFT JOIN hb08h_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	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	60	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pilotomatic.m.component_id	1	Using where

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.02 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.02 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.29 ms
Sending data	0.12 ms
Waiting for query cache lock	0.02 ms
Sending data	0.16 ms
Waiting for query cache lock	0.04 ms
Sending data	0.07 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
19	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
18	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
17	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
16	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
15	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
14	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
13	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
12	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
11	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
10	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.01 ms Après la dernière requête : 32.60 ms Mémoire de requête : 0.017 MB mémoire avant requête : 7.486 MB

UPDATE `hb08h_extensions`

  SET `params` = '{\"mediaversion\":\"1f8b2dbf6140343dcfbe971248fad4cf\"}'

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

Explication

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

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.12 ms
updating	0.08 ms
end	0.02 ms
Waiting for query cache lock	0.98 ms
end	0.30 ms
query end	1.85 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
14	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
13	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
12	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
11	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
10	JFactory::getDocument()	JROOT/plugins/system/jcomments/jcomments.php:111
9	plgSystemJComments->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.96 ms Après la dernière requête : 33.54 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.063 MB Rangées retournées : 8

SELECT s.id, e.extension_id, s.template AS name, s.title, s.params

  FROM hb08h_template_styles AS s

  LEFT JOIN hb08h_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 
  AND e.state = 0

  ORDER BY s.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	index	idx_template	PRIMARY	4	NULL	10	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	pilotomatic.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.05 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.02 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:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:142
15	Gantry\Admin\ThemeList::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:70
14	Gantry\Admin\ThemeList::getStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:37
13	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:242
12	Gantry\Framework\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:109
11	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:170
10	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:60
9	plgSystemGantry5->onAfterRoute()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.96 ms Après la dernière requête : 17.40 ms Mémoire de requête : 0.029 MB mémoire avant requête : 11.269 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `hb08h_assets`

Explication

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

Profil

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.16 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
18	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
17	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
16	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
15	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.91 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.341 MB Rangées retournées : 1

SELECT *

  FROM hb08h_assets

  WHERE `id` = '1'

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 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:1453
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
15	JTable->load()	JROOT/libraries/joomla/access/access.php:697
14	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT a.rules

  FROM hb08h_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 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:1538
14	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
13	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.73 ms Après la dernière requête : 0.77 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.415 MB Rangées retournées : 40

SELECT element

  FROM hb08h_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_extensions	ref	extension	extension	82	const	40	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.22 ms Mémoire de requête : 0.023 MB mémoire avant requête : 11.446 MB Rangées retournées : 40

SELECT a.name, a.rules

  FROM hb08h_assets AS a

  WHERE (a.name IN ('com_acymailing','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_chronoforms5','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_gantry5','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_wrapper') OR a.name = 'root.1')

Explication

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

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 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:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 1.18 ms Après la dernière requête : 2.20 ms Mémoire de requête : 0.025 MB mémoire avant requête : 11.795 MB Rangées retournées : 30

SHOW FULL COLUMNS 
  FROM `hb08h_content`

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.10 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	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
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 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:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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 : 3.86 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.153 MB Rangées retournées : 1

SELECT *

  FROM hb08h_content

  WHERE `id` = '98'

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.02 ms
init	0.02 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	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.03 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 7.29 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.014 MB mémoire avant requête : 12.172 MB

UPDATE hb08h_content

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

  WHERE `id` = '98'

Explication

EXPLAIN impossible sur la requête : UPDATE hb08h_content SET `hits` = (`hits` + 1) WHERE `id` = '98'

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.04 ms
updating	0.08 ms
end	0.01 ms
Waiting for query cache lock	1.07 ms
end	3.02 ms
query end	1.48 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.03 ms Après la dernière requête : 13.36 ms Mémoire de requête : 0.029 MB mémoire avant requête : 12.406 MB Rangées retournées : 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM hb08h_content AS a

  LEFT JOIN hb08h_categories AS c 
  on c.id = a.catid

  LEFT JOIN hb08h_users AS u 
  on u.id = a.created_by

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.language in ('fr-FR','*') 
  AND a.id = 98 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-15 22:37:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-15 22:37:39') 
  AND (a.state = 1 OR a.state =2)

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	21	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.07 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.06 ms
init	0.09 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.08 ms
statistics	0.16 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Copying to tmp table	0.33 ms
Copying to tmp table	0.08 ms
Sorting result	0.03 ms
Sending data	0.01 ms
removing tmp table	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.02 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1650
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
13	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
12	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.39 ms Après la dernière requête : 3.06 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.703 MB Rangées retournées : 2

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 hb08h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hb08h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=13

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	21	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	pilotomatic.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	21	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
14	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
13	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
12	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.12 ms Après la dernière requête : 1.00 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.747 MB Rangées retournées : 0

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

  FROM `hb08h_contentitem_tag_map` AS m 

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

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	43	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	pilotomatic.t.id	1	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.23 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.15 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
11	ContentViewArticle->display()	JROOT/libraries/joomla/cache/controller/view.php:95
10	JCacheControllerView->get()	JROOT/libraries/legacy/controller/legacy.php:660
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.43 ms Après la dernière requête : 32.69 ms Mémoire de requête : 0.016 MB mémoire avant requête : 14.490 MB Rangées retournées : 0

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `hb08h_content` AS `c`

  INNER JOIN `hb08h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

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

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

  INNER JOIN `hb08h_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 101

Explication

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

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.11 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.54 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 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:1689
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
9	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/cookiesck/cookiesck.php:84
8	plgSystemCookiesck->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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 : 0.31 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.509 MB Rangées retournées : 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM hb08h_content AS a

  LEFT JOIN hb08h_categories AS c 
  on c.id = a.catid

  LEFT JOIN hb08h_users AS u 
  on u.id = a.created_by

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 101 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-15 22:37:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-15 22:37:39')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	1	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	21	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.04 ms
init	0.08 ms
optimizing	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.07 ms
statistics	0.12 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Copying to tmp table	0.02 ms
Copying to tmp table	0.03 ms
Sorting result	0.02 ms
Sending data	0.01 ms
removing tmp table	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.02 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.51 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
10	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
9	ContentModelArticle->getItem()	JROOT/plugins/system/cookiesck/cookiesck.php:94
8	plgSystemCookiesck->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.37 ms Après la dernière requête : 0.44 ms Mémoire de requête : 0.023 MB mémoire avant requête : 14.552 MB Rangées retournées : 2

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 hb08h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hb08h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=2

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	21	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	pilotomatic.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	21	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
11	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
10	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
9	ContentHelperRoute::getArticleRoute()	JROOT/plugins/system/cookiesck/cookiesck.php:98
8	plgSystemCookiesck->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.29 ms Après la dernière requête : 3.33 ms Mémoire de requête : 0.015 MB mémoire avant requête : 14.735 MB Rangées retournées : 1

SELECT language,id

  FROM `hb08h_menu`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	61	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 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:1689
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
9	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
8	PlgSystemLanguageFilter->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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.54 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.020 MB mémoire avant requête : 14.754 MB Rangées retournées : 1

SELECT alias

  FROM hb08h_content

  WHERE id=98

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	1.02 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
14	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
13	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
12	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
11	JRouter->build()	JROOT/libraries/cms/router/site.php:147
10	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
9	JRoute::_()	JROOT/plugins/system/languagefilter/languagefilter.php:709
8	PlgSystemLanguageFilter->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `hb08h_content` AS `c`

  INNER JOIN `hb08h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

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

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

  INNER JOIN `hb08h_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 98

Explication

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

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.03 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.06 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	2.39 ms
Waiting for query cache lock	0.02 ms
updating status	0.01 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT/components/com_content/helpers/association.php:43
10	ContentHelperAssociation::getAssociations()	Même appel que celui de la ligne ci-dessous.
9	call_user_func()	JROOT/plugins/system/languagefilter/languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->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 : 226.58 ms Mémoire de requête : 0.053 MB mémoire avant requête : 19.119 MB Rangées retournées : 8

SELECT a.menutype

  FROM hb08h_menu_types AS a

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index	NULL	idx_menutype	98	NULL	8	Using index

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
43	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
42	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:131
41	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
40	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
39	Gantry\Component\Menu\AbstractMenu->instance()	Même appel que celui de la ligne ci-dessous.
38	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/da/dab551c25ce8067a9e7faaac9eea37192b31c81868121f5df9472a5d3cebac82.php:20
36	__TwigTemplate_b7b9128658fe9bc858eb213ab0b6e39ed9dc28e4b293252d01de6bce5f770e84->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.19 ms Après la dernière requête : 18.73 ms Mémoire de requête : 0.063 MB mémoire avant requête : 20.556 MB Rangées retournées : 1

SHOW TABLES LIKE "hb08h_virtuemart_configs"

Explication

EXPLAIN impossible sur la requête : SHOW TABLES LIKE "hb08h_virtuemart_configs"

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
checking permissions	0.53 ms
executing	0.02 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
51	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/models/config.php:507
50	VirtueMartModelConfig::checkConfigTableExists()	JROOT/administrator/components/com_virtuemart/helpers/config.php:809
49	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:779
48	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
47	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
46	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
45	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
44	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
43	JRouter->build()	JROOT/libraries/cms/router/site.php:147
42	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
41	JRoute::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:365
40	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:154
39	Gantry\Component\Menu\AbstractMenu->instance()	Même appel que celui de la ligne ci-dessous.
38	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/da/dab551c25ce8067a9e7faaac9eea37192b31c81868121f5df9472a5d3cebac82.php:20
36	__TwigTemplate_b7b9128658fe9bc858eb213ab0b6e39ed9dc28e4b293252d01de6bce5f770e84->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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 : 0.22 ms Mémoire de requête : 0.061 MB mémoire avant requête : 20.619 MB Rangées retournées : 1

SELECT `config` 
  FROM `hb08h_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_virtuemart_configs	system	PRIMARY	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
51	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
50	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_virtuemart/helpers/config.php:861
49	VmConfig::loadConfig()	JROOT/components/com_virtuemart/router.php:779
48	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
47	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
46	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
45	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
44	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
43	JRouter->build()	JROOT/libraries/cms/router/site.php:147
42	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
41	JRoute::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:365
40	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:154
39	Gantry\Component\Menu\AbstractMenu->instance()	Même appel que celui de la ligne ci-dessous.
38	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/da/dab551c25ce8067a9e7faaac9eea37192b31c81868121f5df9472a5d3cebac82.php:20
36	__TwigTemplate_b7b9128658fe9bc858eb213ab0b6e39ed9dc28e4b293252d01de6bce5f770e84->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.37 ms Après la dernière requête : 1.04 ms Mémoire de requête : 0.068 MB mémoire avant requête : 20.745 MB Rangées retournées : 1

SELECT * 
  FROM `hb08h_menu`  
  where `link` like "index.php?option=com_virtuemart%" 
  and client_id=0 
  and published=1 
  and (language="*" or language = "fr-FR"  )

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hb08h_menu	ref	idx_client_id_parent_id_alias_language,idx_language	idx_client_id_parent_id_alias_language	1	const	61	Using index condition; Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
51	JDatabaseDriver->loadObjectList()	JROOT/components/com_virtuemart/router.php:1094
50	vmrouterHelper->setMenuItemId()	JROOT/components/com_virtuemart/router.php:757
49	vmrouterHelper->__construct()	JROOT/components/com_virtuemart/router.php:781
48	vmrouterHelper::getInstance()	JROOT/components/com_virtuemart/router.php:27
47	virtuemartBuildRoute()	JROOT/libraries/cms/component/router/legacy.php:68
46	JComponentRouterLegacy->build()	JROOT/libraries/cms/router/site.php:496
45	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
44	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
43	JRouter->build()	JROOT/libraries/cms/router/site.php:147
42	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
41	JRoute::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:365
40	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:154
39	Gantry\Component\Menu\AbstractMenu->instance()	Même appel que celui de la ligne ci-dessous.
38	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
37	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/da/dab551c25ce8067a9e7faaac9eea37192b31c81868121f5df9472a5d3cebac82.php:20
36	__TwigTemplate_b7b9128658fe9bc858eb213ab0b6e39ed9dc28e4b293252d01de6bce5f770e84->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT cat.id AS id

  FROM hb08h_categories AS cat

  LEFT JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  AND cat.published < 1

  GROUP BY cat.id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	cat	ALL	idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	21	Using where; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
47	JDatabaseDriver->loadColumn()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Category/CategoryFinder.php:150
46	Gantry\Joomla\Category\CategoryFinder::getUnpublished()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Category/CategoryFinder.php:99
45	Gantry\Joomla\Category\CategoryFinder->authorised()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:387
44	Gantry\Framework\Platform->finder()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:77
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

SELECT a.id

  FROM hb08h_categories AS a

  WHERE `a`.`id` IN (12) 
  AND `a`.`extension` = 'com_content' 
  AND `a`.`access` IN (1,1,5) 
  AND `a`.`published` IN (1) 
  AND `a`.`language` IN ('fr-FR','*')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,cat_idx,idx_access,idx_language	PRIMARY	4	const	1

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
46	JDatabaseDriver->loadColumn()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Finder.php:206
45	Gantry\Joomla\Object\Finder->find()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Category/CategoryFinder.php:35
44	Gantry\Joomla\Category\CategoryFinder->find()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:77
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.29 ms Après la dernière requête : 6.04 ms Mémoire de requête : 0.069 MB mémoire avant requête : 21.435 MB Rangées retournées : 27

SHOW FULL COLUMNS 
  FROM `hb08h_categories`

Explication

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

Profil

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.15 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.05 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
54	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
53	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
52	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
51	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
50	JTable->__construct()	JROOT/libraries/legacy/table/category.php:30
49	JTableCategory->__construct()	JROOT/libraries/joomla/table/table.php:308
48	JTable::getInstance()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:427
47	Gantry\Joomla\Object\Object::getTable()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:435
46	Gantry\Joomla\Object\Object::getQuery()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:395
45	Gantry\Joomla\Object\Object::getInstances()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Category/CategoryFinder.php:41
44	Gantry\Joomla\Category\CategoryFinder->find()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:77
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.064 MB mémoire avant requête : 21.562 MB Rangées retournées : 1

SELECT a.*

  FROM hb08h_categories AS a

  WHERE id IN (12)

  ORDER BY lft

Explication

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

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
47	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:456
46	Gantry\Joomla\Object\Object::loadInstances()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:397
45	Gantry\Joomla\Object\Object::getInstances()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Category/CategoryFinder.php:41
44	Gantry\Joomla\Category\CategoryFinder->find()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:77
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.08 ms Après la dernière requête : 4.89 ms Mémoire de requête : 0.057 MB mémoire avant requête : 21.691 MB Rangées retournées : 3

SELECT a.id

  FROM hb08h_content AS a

  INNER JOIN hb08h_categories AS c 
  ON c.id = a.catid

  WHERE (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-15 22:37:39') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-15 22:37:39') 
  AND a.state >= 1 
  AND `a`.`access` IN (1,1,5) 
  AND `c`.`access` IN (1,1,5) 
  AND `a`.`state` IN (1) 
  AND `a`.`language` IN ('fr-FR','*') 
  AND `a`.`id` IN (36,37,38)

  ORDER BY a.`publish_up` ASC 
  LIMIT 3

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	NULL	3	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	pilotomatic.a.catid	1	Using where

Profil

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.07 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.17 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
47	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
46	JDatabaseDriver->loadColumn()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Finder.php:206
45	Gantry\Joomla\Object\Finder->find()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Content/ContentFinder.php:38
44	Gantry\Joomla\Content\ContentFinder->find()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:123
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->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.91 ms Après la dernière requête : 1.47 ms Mémoire de requête : 0.066 MB mémoire avant requête : 21.786 MB Rangées retournées : 3

SELECT a.*

  FROM hb08h_content AS a

  WHERE id IN (36,37,38)

  ORDER BY id

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	4	NULL	3	Using where

Profil

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.03 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.02 ms
After opening tables	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.02 ms
Sending data	0.09 ms
Waiting for query cache lock	0.01 ms
Sending data	0.81 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.08 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.01 ms
updating status	0.02 ms
storing result in query cache	1.40 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
48	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
47	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:456
46	Gantry\Joomla\Object\Object::loadInstances()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Object/Object.php:397
45	Gantry\Joomla\Object\Object::getInstances()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Content/ContentFinder.php:44
44	Gantry\Joomla\Content\ContentFinder->find()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:123
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.75 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.066 MB mémoire avant requête : 21.935 MB Rangées retournées : 2

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 hb08h_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hb08h_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('fr-FR','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=12

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	21	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	pilotomatic.c.id	4	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	203	NULL	2	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	21	Using where; Using index; Using join buffer (flat, BNL join)

Profil

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
49	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
48	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
47	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
46	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
45	ContentHelperRoute::getArticleRoute()	JROOT/libraries/gantry5/classes/Gantry/Joomla/Content/Content.php:79
44	Gantry\Joomla\Content\Content->route()	Même appel que celui de la ligne ci-dessous.
43	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:208
41	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:203
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/g5_hydrogen/twig/bc/bc6155f6b2f3380eb3d74a1447d788dc24ff4f9b540af030cb2183b951d4575a.php:62
39	__TwigTemplate_88b1aef804c69cb80ebb4d030eab3628627e3b52b21b04f81d1be32447bc7298->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
37	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/77/776a612d2fdf00a66097b88ba150a025398564c4d259b2fc51222e566408bd48.php:48
36	__TwigTemplate_7754a09d32502f91f4e13689880fa2dd2d948618b9b9fa777799baf5d59d5213->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
34	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/49/495ac2cbd93b8cb4d3a19821b6ae85be4f5ec659e2492154ccab83c7b275b568.php:54
33	__TwigTemplate_9560cbe3f467ccd4407a445ffc039a650f724a8bb02cd98efe8aa9642071e3ed->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:596
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:524
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:510
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:353
22	Gantry\Framework\Theme->segments()	Même appel que celui de la ligne ci-dessous.
21	call_user_func_array()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:613
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/g5_hydrogen/twig/4d/4d961dd49d00c72e6aefab46f6e8e42dd0266e169bb64316834bb70b6a44cda2.php:32
19	__TwigTemplate_3cbae2527f9f28a757680f9bcbba5e76fcebc8332e541e93ac9ddeb5138d19ef->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
17	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/21/213f140d5c220e5f850140f5dc46d7456b0d8f086a2c148d2cde8c64578a980b.php:24
16	__TwigTemplate_583d2a5732d9047dc7ca422febf25fca5be3b7d9e55fadc541f7a42f5005da1c->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
14	Twig_Template->display()	JROOT/cache/gantry5/g5_hydrogen/twig/39/398d31c543f1eafc2a3dd1a406d88a64441996c099e05d6c6472bb49e7eb74e2.php:24
13	__TwigTemplate_a5ef2ab031dda0437e2f8315882204858b7aa6e50d76d706c1a60c6d9fcb47ec->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:396
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:364
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:375
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:357
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:162
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:26
7	require JROOT/templates/g5_hydrogen/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

Temps de requête : 0.45 ms Après la dernière requête : 292.70 ms Mémoire de requête : 0.020 MB mémoire avant requête : 25.103 MB Rangées retournées : 129

SELECT * 
  FROM hb08h_acymailing_config

Explication

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

Profil

Status	Duration
starting	0.08 ms
Waiting for query cache lock	0.01 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.04 ms
updating status	0.01 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:468
10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1236
9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
8	plgSystemRegacymailing->onAfterRender()	Même appel que celui de la ligne ci-dessous.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:49

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

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

Tables sélectionnées :

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

2 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM hb08h_content AS a 
  LEFT JOIN hb08h_categories AS c 
  on c.id = a.catid 
  LEFT JOIN hb08h_users AS u 
  on u.id = a.created_by 
  LEFT JOIN hb08h_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hb08h_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hb08h_categories AS cat JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT element 
  FROM hb08h_extensions

2 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `hb08h_content` AS `c` 
  INNER JOIN `hb08h_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `hb08h_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `hb08h_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `hb08h_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `config` 
  FROM `hb08h_virtuemart_configs`

1 × SELECT a.menutype 
  FROM hb08h_menu_types AS

```
1 × SELECT * 
  FROM `hb08h_menu`
```

1 × SELECT alias 
  FROM hb08h_content

1 × SELECT a.id 
  FROM hb08h_categories AS a

1 × SELECT a.* 
  FROM hb08h_content AS a

1 × SELECT * 
  FROM hb08h_acymailing_confi

1 × SELECT a.id 
  FROM hb08h_content AS a 
  INNER JOIN hb08h_categories AS c 
  ON c.id = a.catid

1 × SELECT a.* 
  FROM hb08h_categories AS a

1 × SELECT language,id 
  FROM `hb08h_menu`

1 × SELECT cat.id AS id 
  FROM hb08h_categories AS cat 
  LEFT JOIN hb08h_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `hb08h_contentitem_tag_map` AS m  
  INNER JOIN `hb08h_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params 
  FROM hb08h_template_styles AS s 
  LEFT JOIN hb08h_extensions AS e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

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 hb08h_menu AS m 
  LEFT JOIN hb08h_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, rules 
  FROM `hb08h_viewlevels

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

```
1 × SELECT * 
  FROM hb08h_assets
```

1 × SELECT a.rules 
  FROM hb08h_assets AS a

1 × SELECT `data` 
  FROM `hb08h_session`

```
1 × SELECT * 
  FROM hb08h_content
```

1 × SELECT a.name, a.rules 
  FROM hb08h_assets AS a

1 × SELECT `session_id` 
  FROM `hb08h_session`

Autres tables :

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

1 × SHOW TABLES LIKE "hb08h_virtuemart_configs

1 × SHOW FULL COLUMNS 
  FROM `hb08h_categories

1 × SHOW FULL COLUMNS 
  FROM `hb08h_content

1 × SHOW FULL COLUMNS 
  FROM `hb08h_assets

1 × INSERT INTO `hb08h_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('dcd9bacf98022a834914c1a891acd955', 0, 1, '1560638259', 0, ''

1 × UPDATE `hb08h_extensions` 
  SET `params` = '{\"mediaversion\":\"1f8b2dbf6140343dcfbe971248fad4cf\"}'

```
1 × DELETE  
  FROM `hb08h_session`
```