Cabinets des thérapeutes en Aix-en-Provence

Console de débogage Joomla!

Session

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

Profil d'information

Temps

Mémoire

Temps: 32.18 ms / 32.18 ms Mémoire: 2.150 MB / 2.36 MB Application: afterLoad

Temps: 321.41 ms / 353.60 ms Mémoire: 10.248 MB / 12.60 MB Application: afterInitialise

Temps: 141.71 ms / 495.30 ms Mémoire: 2.284 MB / 14.89 MB Application: afterRoute

Temps: 28.13 ms / 523.43 ms Mémoire: 0.465 MB / 15.35 MB Application: beforeRenderComponent com_medecinedouce

Temps: 467.41 ms / 990.84 ms Mémoire: 9.055 MB / 24.41 MB Application: afterRenderComponent com_medecinedouce

Temps: 4.54 ms / 995.38 ms Mémoire: 0.213 MB / 24.62 MB Application: afterDispatch

Temps: 55.46 ms / 1050.84 ms Mémoire: 0.416 MB / 25.04 MB Application: beforeRenderModule mod_easysociallist (Suivez-nous sur les réseaux sociaux! )

Temps: 1.57 ms / 1052.41 ms Mémoire: 0.082 MB / 25.12 MB Application: afterRenderModule mod_easysociallist (Suivez-nous sur les réseaux sociaux! )

Temps: 0.15 ms / 1052.56 ms Mémoire: 0.000 MB / 25.10 MB Application: beforeRenderModule mod_medecinedouce_new (Derniers Thérapeutes inscrits)

Temps: 220.67 ms / 1273.24 ms Mémoire: 1.052 MB / 26.15 MB Application: afterRenderModule mod_medecinedouce_new (Derniers Thérapeutes inscrits)

Temps: 0.28 ms / 1273.52 ms Mémoire: 0.000 MB / 26.07 MB Application: beforeRenderModule mod_medecinedouce_map (Localisez un thérapeute)

Temps: 1.68 ms / 1275.20 ms Mémoire: 0.019 MB / 26.09 MB Application: afterRenderModule mod_medecinedouce_map (Localisez un thérapeute)

Temps: 0.10 ms / 1275.30 ms Mémoire: 0.000 MB / 26.09 MB Application: beforeRenderModule mod_bullewidget (Publicité AdSense)

Temps: 0.57 ms / 1275.87 ms Mémoire: 0.011 MB / 26.10 MB Application: afterRenderModule mod_bullewidget (Publicité AdSense)

Temps: 0.19 ms / 1276.06 ms Mémoire: 0.000 MB / 26.10 MB Application: beforeRenderModule mod_medecinedouce_slideshow (Restaurant Guide Slideshow)

Temps: 521.87 ms / 1797.93 ms Mémoire: 0.289 MB / 26.38 MB Application: afterRenderModule mod_medecinedouce_slideshow (Restaurant Guide Slideshow)

Temps: 123.30 ms / 1921.22 ms Mémoire: 0.863 MB / 27.25 MB Application: afterRender

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

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

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Temps de requête : 8.47 ms Après la dernière requête : 5.87 ms Mémoire de requête : 0.028 MB mémoire avant requête : 5.136 MB Rangées retournées : 48

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

  FROM `wol7j_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wol7j_extensions	NULL	ref	extension	extension	82	const	48	1.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 10.21 ms Après la dernière requête : 17.73 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.467 MB Rangées retournées : 5

SELECT id, rules

  FROM `wol7j_viewlevels`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.54 ms Après la dernière requête : 0.41 ms Mémoire de requête : 0.015 MB mémoire avant requête : 5.492 MB Rangées retournées : 2

SELECT b.id

  FROM wol7j_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.30 ms Après la dernière requête : 1.57 ms Mémoire de requête : 0.019 MB mémoire avant requête : 5.594 MB Rangées retournées : 101

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

  FROM wol7j_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wol7j_extensions	NULL	ref	extension	extension	82	const	153	0.60	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 7.76 ms Après la dernière requête : 64.40 ms Mémoire de requête : 0.013 MB mémoire avant requête : 7.046 MB Rangées retournées : 1

SELECT `enabled`

  FROM `wol7j_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wol7j_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.01 ms Après la dernière requête : 145.61 ms Mémoire de requête : 0.030 MB mémoire avant requête : 12.950 MB Rangées retournées : 12

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

  LEFT JOIN wol7j_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	34	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs262569.m.component_id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 13.75 ms Après la dernière requête : 79.31 ms Mémoire de requête : 0.018 MB mémoire avant requête : 14.619 MB Rangées retournées : 6

SELECT id, home, template, s.params

  FROM wol7j_template_styles as s

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	8	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	dbs262569.e.element	1	77.78	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
10	T3::detect()	JROOT/plugins/system/t3/t3.php:81
9	plgSystemT3->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `wol7j_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	wol7j_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 3.24 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.013 MB mémoire avant requête : 14.982 MB

UPDATE `wol7j_extensions`

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	wol7j_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.57 ms Après la dernière requête : 4.26 ms Mémoire de requête : 0.014 MB mémoire avant requête : 15.306 MB Rangées retournées : 2

SELECT *

  FROM wol7j_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.20 ms Après la dernière requête : 87.80 ms Mémoire de requête : 0.068 MB mémoire avant requête : 17.219 MB Rangées retournées : 1

SELECT * 
  FROM wol7j_md_settings 
  WHERE id = 1

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
8	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_medecinedouce/classes/util.php:81
7	RGUtil::config()	JROOT/components/com_medecinedouce/medecinedouce.php:65
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.18 ms Après la dernière requête : 57.98 ms Mémoire de requête : 0.022 MB mémoire avant requête : 19.136 MB Rangées retournées : 10

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

  FROM wol7j_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-01-19 19:07:24') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-19 19:07:24') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 103 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	15	1.60	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	dbs262569.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	dbs262569.m.id	3	40.00	Using where; Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/components/com_medecinedouce/controller.php:250
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM wol7j_md_cities 
  WHERE published = 1 
  AND id = 758

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:309
11	medecinedouceModelCity->getCity()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:64
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 9.49 ms Après la dernière requête : 0.39 ms Mémoire de requête : 0.048 MB mémoire avant requête : 19.307 MB Rangées retournées : 10

SELECT DISTINCT i.*, (i.rate_sum / i.rate ) AS votes, t.name AS restauranttype, c.name AS cityname, 
  CASE WHEN CHAR_LENGTH(i.alias) THEN CONCAT_WS(':', i.id, i.alias) ELSE i.id END as slug, (SELECT GROUP_CONCAT( tag.tid 
  ORDER BY tag.tid ASC SEPARATOR ', ') 
  FROM wol7j_md_tags_item_relations AS tag 
  WHERE tag.itemid IN(i.id) ) AS tags 
  FROM wol7j_md_restaurantitems AS i 
  LEFT JOIN wol7j_md_restauranttypes AS t 
  ON t.id = i.tid 
  LEFT JOIN wol7j_md_cities AS c 
  on c.id = i.city 
  WHERE i.published = 1 
  AND IF (i.parent_id = 758, i.parent_id = 758, i.city = 758) 
  ORDER BY i.title ASC 
  LIMIT 0, 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	i	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1802	10.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	t	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs262569.i.tid	1	100.00	Using where
1	PRIMARY	c	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs262569.i.city	1	100.00	NULL
2	DEPENDENT SUBQUERY	tag	NULL	ref	itemid	itemid	4	dbs262569.i.id	18	100.00	Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_medecinedouce/models/city.php:102
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 7.86 ms Après la dernière requête : 0.95 ms Mémoire de requête : 0.018 MB mémoire avant requête : 19.539 MB Rangées retournées : 1

Requêtes dupliquées: #21 #24 #27 #30 #33 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.44 ms Après la dernière requête : 0.33 ms Mémoire de requête : 0.018 MB mémoire avant requête : 19.581 MB Rangées retournées : 0

Requêtes dupliquées: #22 #25 #28 #31 #34 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 1186 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #24 #27 #30 #33 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #19 #25 #28 #31 #34 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 636 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #21 #27 #30 #33 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #19 #22 #28 #31 #34 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 2254 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #21 #24 #30 #33 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #19 #22 #25 #31 #34 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 677 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #21 #24 #27 #33 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.38 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.018 MB mémoire avant requête : 20.014 MB Rangées retournées : 0

Requêtes dupliquées: #19 #22 #25 #28 #34 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 632 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #21 #24 #27 #30 #36 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #19 #22 #25 #28 #31 #37 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 1011 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #18 #21 #24 #27 #30 #33 #39 #42 #45

SELECT GROUP_CONCAT(DISTINCT name 
  ORDER BY name ASC SEPARATOR ', ') AS cuisines 
  FROM wol7j_md_cuisines 
  WHERE published = 1 
  AND id = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_medecinedouce/models/city.php:124
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #19 #22 #25 #28 #31 #34 #40 #43 #46

SELECT DISTINCT name, 
  CASE WHEN CHAR_LENGTH(alias) THEN CONCAT_WS(':', id, alias) ELSE id END as slug 
  FROM wol7j_md_tags 
  WHERE published = 1 
  AND id = 0 
  ORDER BY name ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	NULL	NULL	no matching row in const table

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:143
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT o.* 
  FROM wol7j_md_specialoffers AS o 
  LEFT JOIN wol7j_md_restaurantitems AS i 
  ON i.id = o.resto 
  WHERE o.published = 1 
  AND o.resto = 1023 
  ORDER BY o.startdates DESC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	o	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	8	12.50	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	i	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index

Profil

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/components/com_medecinedouce/models/city.php:154
11	medecinedouceModelCity->getData()	JROOT/plugins/system/t3/includes/joomla4/HtmlView.php:423
10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_medecinedouce/views/city/view.html.php:65
9	medecinedouceViewCity->display()	JROOT/components/com_medecinedouce/controller.php:268
8	medecinedouceController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_medecinedouce/medecinedouce.php:82
6	require_once JROOT/components/com_medecinedouce/medecinedouce.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Cabinets des thérapeutes en Aix-en-Provence

Trouver des cabinets des thérapeutes sur la carte

Aix-en-Provence

Localisez un thérapeute

Derniers Thérapeutes inscrits

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

117 requêtes exécutées 519.58 ms

50 doubles découverts!