petites annonces - Esthétique

Annonces
Manucure > Soins (mixte)
Coiffure > Mise en plis
Coiffure > Brushing, mise en plis, couleur

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675492108,
                "last": 1675492108,
                "now": 1675492108
            },
            "token": "tbPjaDwjLRH3gn0hyYEBj2cHtxPTrkw4"
        },
        "registry": {
            "jevents": {
                "moduleid103": {
                    "shownEventIds": [],
                    "page": 0,
                    "firstEventDate": false
                }
            },
            "published_fv_ses": "0"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "search_fields": "",
        "searchfieldssql": " 1 ",
        "searchfieldscatid": 0
    },
    "__adsmanager": {
        "tsearch": "",
        "list_type": "category",
        "list_value": 10
    }
}

Profil d'information

Temps

Mémoire

Temps: 13.44 ms / 13.44 ms Mémoire: 2.017 MB / 2.39 MB Application: afterLoad

Temps: 56.38 ms / 69.82 ms Mémoire: 4.223 MB / 6.61 MB Application: afterInitialise

Temps: 32.69 ms / 102.52 ms Mémoire: 2.456 MB / 9.06 MB Application: afterRoute

Temps: 0.96 ms / 103.47 ms Mémoire: 0.013 MB / 9.08 MB Application: beforeRenderComponent com_adsmanager

Temps: 52.13 ms / 155.60 ms Mémoire: 4.256 MB / 13.33 MB Application: afterRenderComponent com_adsmanager

Temps: 1.27 ms / 156.87 ms Mémoire: 0.097 MB / 13.43 MB Application: afterDispatch

Temps: 4.21 ms / 161.08 ms Mémoire: 0.800 MB / 14.23 MB Application: beforeRenderModule mod_custom (Footer Blé)

Temps: 6.48 ms / 167.56 ms Mémoire: 0.518 MB / 14.75 MB Application: afterRenderModule mod_custom (Footer Blé)

Temps: 0.07 ms / 167.63 ms Mémoire: 0.000 MB / 14.75 MB Application: beforeRenderModule mod_simplecontact (Gardez contact avec le SEL !)

Temps: 1.90 ms / 169.53 ms Mémoire: 0.152 MB / 14.90 MB Application: afterRenderModule mod_simplecontact (Gardez contact avec le SEL !)

Temps: 0.05 ms / 169.58 ms Mémoire: -0.000 MB / 14.90 MB Application: beforeRenderModule mod_adsmanager_ads (Dernières annonces)

Temps: 18.19 ms / 187.77 ms Mémoire: 0.295 MB / 15.20 MB Application: afterRenderModule mod_adsmanager_ads (Dernières annonces)

Temps: 0.09 ms / 187.86 ms Mémoire: -0.047 MB / 15.15 MB Application: beforeRenderModule mod_adsmanager_menu (Annonces)

Temps: 19.39 ms / 207.25 ms Mémoire: 0.357 MB / 15.51 MB Application: afterRenderModule mod_adsmanager_menu (Annonces)

Temps: 0.08 ms / 207.32 ms Mémoire: -0.054 MB / 15.45 MB Application: beforeRenderModule mod_custom (Catalogue papier)

Temps: 0.36 ms / 207.68 ms Mémoire: 0.003 MB / 15.46 MB Application: afterRenderModule mod_custom (Catalogue papier)

Temps: 0.03 ms / 207.71 ms Mémoire: 0.008 MB / 15.46 MB Application: beforeRenderModule mod_jevents_latest (Nos rendez-vous)

Temps: 12.20 ms / 219.92 ms Mémoire: 1.302 MB / 16.77 MB Application: Before Access::preloadComponents (all components)

Temps: 1.41 ms / 221.33 ms Mémoire: 0.062 MB / 16.83 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 221.36 ms Mémoire: -0.003 MB / 16.83 MB Application: Before Access::getAssetRules (id:49 name:com_jevents)

Temps: 0.37 ms / 221.73 ms Mémoire: 0.026 MB / 16.85 MB Application: After Access::getAssetRules (id:49 name:com_jevents)

Temps: 20.28 ms / 242.00 ms Mémoire: 1.433 MB / 18.29 MB Application: afterRenderModule mod_jevents_latest (Nos rendez-vous)

Temps: 0.04 ms / 242.05 ms Mémoire: -0.004 MB / 18.28 MB Application: beforeRenderModule mod_cblogin (Connexion adhérents)

Temps: 48.34 ms / 290.38 ms Mémoire: 3.771 MB / 22.05 MB Application: afterRenderModule mod_cblogin (Connexion adhérents)

Temps: 0.10 ms / 290.49 ms Mémoire: -0.008 MB / 22.04 MB Application: beforeRenderModule mod_custom (Richesses titre)

Temps: 0.31 ms / 290.79 ms Mémoire: 0.003 MB / 22.05 MB Application: afterRenderModule mod_custom (Richesses titre)

Temps: 0.06 ms / 290.85 ms Mémoire: 0.001 MB / 22.05 MB Application: beforeRenderModule mod_menu (Menu secondaire)

Temps: 2.57 ms / 293.42 ms Mémoire: 0.067 MB / 22.11 MB Application: afterRenderModule mod_menu (Menu secondaire)

Temps: 3.03 ms / 296.46 ms Mémoire: 0.231 MB / 22.34 MB Application: afterRender

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

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

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

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

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

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.72 ms Après la dernière requête : 2.02 ms Mémoire de requête : 0.040 MB mémoire avant requête : 4.446 MB Rangées retournées : 42

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

  FROM `sel3_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	sel3_extensions	NULL	ref	extension	extension	82	const	42	1.00	Using where

Profil

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

Pile d'appels

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

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

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

SELECT id, rules

  FROM `sel3_viewlevels`

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT b.id

  FROM sel3_usergroups AS a

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

  WHERE a.id = 1

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	1	100.00	Using where; Using index

Profil

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

Pile d'appels

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

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

Temps de requête : 0.98 ms Après la dernière requête : 0.57 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.794 MB Rangées retournées : 85

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

  FROM sel3_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sel3_extensions	NULL	ref	extension	extension	82	const	119	0.40	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)

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.19 ms Après la dernière requête : 14.83 ms Mémoire de requête : 0.054 MB mémoire avant requête : 6.405 MB Rangées retournées : 30

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

  FROM sel3_menu AS m

  LEFT JOIN sel3_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	47	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs3816154.m.component_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/communitybuilder/communitybuilder.php:300
8	plgSystemCommunityBuilder->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.65 ms Après la dernière requête : 9.57 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.514 MB Rangées retournées : 6

SELECT id, home, template, s.params

  FROM sel3_template_styles as s

  LEFT JOIN sel3_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	s	NULL	ALL	idx_template,idx_client_id,idx_client_id_home	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	9	66.67	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	dbs3816154.s.template,const	1	4.49	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
9	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/components/com_adsmanager/lib/core.php:106
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.74 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.080 MB mémoire avant requête : 7.546 MB Rangées retournées : 1

Requêtes dupliquées: #15 #55

SELECT * 
  FROM sel3_adsmanager_config

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/configuration.php:26
10	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
9	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.36 ms Après la dernière requête : 0.45 ms Mémoire de requête : 0.022 MB mémoire avant requête : 7.624 MB Rangées retournées : 0

Requêtes dupliquées: #16 #56

SELECT group_id 
  FROM sel3_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
12	JDatabaseDriver->loadColumn()	JROOT/components/com_adsmanager/helpers/usergroups.php:28
11	JHTMLAdsmanagerUserGroups::getUserGroup()	JROOT/administrator/components/com_adsmanager/models/configuration.php:62
10	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/lib/tconf.php:18
9	TConf::getConfig()	JROOT/components/com_adsmanager/lib/core.php:116
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.41 ms Après la dernière requête : 3.41 ms Mémoire de requête : 0.028 MB mémoire avant requête : 8.024 MB Rangées retournées : 1

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

  FROM `sel3_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	sel3_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)

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
27	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
25	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/juloalib/Lib.php:23
9	JuloaLib::loadJquery()	JROOT/components/com_adsmanager/lib/core.php:164
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 6.39 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.011 MB mémoire avant requête : 8.021 MB

UPDATE `sel3_extensions`

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

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	sel3_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)

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
21	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
20	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/HTML/HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/juloalib/Lib.php:23
9	JuloaLib::loadJquery()	JROOT/components/com_adsmanager/lib/core.php:164
8	require_once JROOT/components/com_adsmanager/lib/core.php	JROOT/components/com_adsmanager/router.php:13
7	require_once JROOT/components/com_adsmanager/router.php	JROOT/libraries/src/Router/SiteRouter.php:779
6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:131
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.55 ms Après la dernière requête : 11.58 ms Mémoire de requête : 0.020 MB mémoire avant requête : 9.067 MB Rangées retournées : 2

SELECT *

  FROM sel3_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	sel3_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)

Pile d'appels

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

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

Temps de requête : 0.66 ms Après la dernière requête : 7.70 ms Mémoire de requête : 0.077 MB mémoire avant requête : 9.850 MB Rangées retournées : 1

Requêtes dupliquées: #10 #55

SELECT * 
  FROM sel3_adsmanager_config

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/configuration.php:26
9	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/controller.php:70
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #11 #56

SELECT group_id 
  FROM sel3_user_usergroup_map
                            
  WHERE user_id = 0

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/components/com_adsmanager/helpers/usergroups.php:28
10	JHTMLAdsmanagerUserGroups::getUserGroup()	JROOT/administrator/components/com_adsmanager/models/configuration.php:62
9	AdsmanagerModelConfiguration->getConfiguration()	JROOT/components/com_adsmanager/controller.php:70
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM sel3_adsmanager_categories 
  WHERE id = 10

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	sel3_adsmanager_categories	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)

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_adsmanager/models/category.php:42
13	AdsmanagerModelCategory->getCategory()	JROOT/components/com_adsmanager/views/list/view.html.php:65
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.39 ms Après la dernière requête : 0.16 ms Mémoire de requête : 0.032 MB mémoire avant requête : 9.958 MB Rangées retournées : 28

SELECT c.* 
  FROM sel3_adsmanager_categories as c 
  WHERE  1   
  ORDER BY c.parent,c.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/category.php:106
15	AdsmanagerModelCategory->getCategories()	JROOT/components/com_adsmanager/lib/tpermissions.php:41
14	TPermissions::getAuthorisedCategories()	JROOT/administrator/components/com_adsmanager/models/category.php:180
13	AdsmanagerModelCategory->getSubCats()	JROOT/components/com_adsmanager/views/list/view.html.php:161
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT c.* 
  FROM sel3_adsmanager_categories as c 
  WHERE c.parent = 10 
  AND c.published = 1  
  AND c.id IN (1,58,3,4,5,6,7,8,11,9,22,10,12,13,14,15,16,57,42,17,53,18,49,59,60,61,62,63)  
  ORDER BY c.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/category.php:207
13	AdsmanagerModelCategory->getSubCats()	JROOT/components/com_adsmanager/views/list/view.html.php:161
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.42 ms Après la dernière requête : 0.03 ms Mémoire de requête : 0.031 MB mémoire avant requête : 9.975 MB Rangées retournées : 28

Requêtes dupliquées: #82

SELECT c.* 
  FROM sel3_adsmanager_categories as c 
  WHERE  c.published = 1   
  AND c.id IN (1,58,3,4,5,6,7,8,11,9,22,10,12,13,14,15,16,57,42,17,53,18,49,59,60,61,62,63)  
  ORDER BY c.parent,c.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/category.php:106
14	AdsmanagerModelCategory->getCategories()	JROOT/administrator/components/com_adsmanager/models/category.php:120
13	AdsmanagerModelCategory->getPathList()	JROOT/components/com_adsmanager/views/list/view.html.php:162
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id,language 
  FROM sel3_menu 
  WHERE link LIKE '%option=com_adsmanager&view=list%' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/components/com_adsmanager/lib/route.php:221
15	TRoute::_getViewItemid()	JROOT/components/com_adsmanager/lib/route.php:93
14	TRoute::_()	JROOT/administrator/components/com_adsmanager/models/category.php:138
13	AdsmanagerModelCategory->getPathList()	JROOT/components/com_adsmanager/views/list/view.html.php:162
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 0.42 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.057 MB Rangées retournées : 1

Requêtes dupliquées: #38 #40 #46 #48 #50 #52

SELECT name 
  FROM sel3_adsmanager_categories 
  WHERE id = 10

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/router.php:20
23	getAdsmanagerRouteCategory()	JROOT/components/com_adsmanager/router.php:100
22	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_adsmanager/lib/route.php:187
14	TRoute::_()	JROOT/administrator/components/com_adsmanager/models/category.php:138
13	AdsmanagerModelCategory->getPathList()	JROOT/components/com_adsmanager/views/list/view.html.php:162
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.027 MB mémoire avant requête : 10.096 MB Rangées retournées : 1

SELECT name 
  FROM sel3_adsmanager_categories 
  WHERE id = 1

Explication

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

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.02 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/router.php:20
23	getAdsmanagerRouteCategory()	JROOT/components/com_adsmanager/router.php:100
22	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
21	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
20	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
19	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/components/com_adsmanager/lib/route.php:187
14	TRoute::_()	JROOT/administrator/components/com_adsmanager/models/category.php:152
13	AdsmanagerModelCategory->getPathList()	JROOT/components/com_adsmanager/views/list/view.html.php:162
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT f.title,f.fieldid,f.catsid 
  FROM sel3_adsmanager_fields AS f 
  WHERE f.sort = 1 
  AND f.published = 1 
  ORDER BY f.ordering ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:59
13	AdsmanagerModelField->getOrderFields()	JROOT/components/com_adsmanager/views/list/view.html.php:170
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.35 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.090 MB Rangées retournées : 2

SELECT * 
  FROM sel3_adsmanager_fields as f 
  WHERE  f.published = 1  
  ORDER by f.ordering ASC

Explication

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

Profil

Status	Duration
starting	0.02 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.01 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:88
13	AdsmanagerModelField->getFields()	JROOT/components/com_adsmanager/views/list/view.html.php:191
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.30 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.026 MB mémoire avant requête : 10.102 MB Rangées retournées : 28

SELECT c.id, c.name,c.parent  
  FROM sel3_adsmanager_categories as c  
  WHERE c.published = 1 
  ORDER BY c.parent,c.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/content.php:261
15	AdsmanagerModelContent->getAllSubCatids()	JROOT/administrator/components/com_adsmanager/models/content.php:306
14	AdsmanagerModelContent->_getSQLFilter()	JROOT/administrator/components/com_adsmanager/models/content.php:493
13	AdsmanagerModelContent->getNbContents()	JROOT/components/com_adsmanager/views/list/view.html.php:209
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.89 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.111 MB Rangées retournées : 3

SELECT a.id  
  FROM sel3_adsmanager_ads as a  
  INNER JOIN sel3_adsmanager_adcat as adcat 
  ON adcat.adid = a.id  
  LEFT JOIN sel3_users as u 
  ON a.userid = u.id  
  LEFT JOIN sel3_comprofiler as cb 
  ON cb.user_id = a.userid  
  INNER JOIN sel3_adsmanager_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN sel3_adsmanager_categories as p 
  ON c.parent = p.id  
  WHERE  a.published = 1 
  AND c.published = TRUE  
  AND c.id IN (10)  
  AND c.id IN (1,58,3,4,5,6,7,8,11,9,22,10,12,13,14,15,16,57,42,17,53,18,49,59,60,61,62,63)  
  GROUP BY a.id

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	p	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	adcat	NULL	index	PRIMARY	PRIMARY	8	NULL	223	10.00	Using where; Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs3816154.adcat.adid	1	10.00	Using where
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs3816154.a.userid	1	100.00	Using where; Using index
1	SIMPLE	cb	NULL	eq_ref	user_id	user_id	4	dbs3816154.a.userid	1	100.00	Using where; Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/content.php:532
13	AdsmanagerModelContent->getNbContents()	JROOT/components/com_adsmanager/views/list/view.html.php:209
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.95 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.119 MB Rangées retournées : 3

SELECT a.*, p.name as parent, p.id as parentid, c.name as cat, c.id as catid,u.username as user,u.name as fullname  
  FROM sel3_adsmanager_ads as a  
  INNER JOIN sel3_adsmanager_adcat as adcat 
  ON adcat.adid = a.id  
  LEFT JOIN sel3_comprofiler as cb 
  ON cb.user_id = a.userid  
  LEFT JOIN sel3_users as u 
  ON a.userid = u.id  
  INNER JOIN sel3_adsmanager_categories as c 
  ON adcat.catid = c.id  
  LEFT JOIN sel3_adsmanager_categories as p 
  ON c.parent = p.id  
  WHERE  a.published = 1 
  AND c.published = TRUE  
  AND c.id IN (10)  
  AND c.id IN (1,58,3,4,5,6,7,8,11,9,22,10,12,13,14,15,16,57,42,17,53,18,49,59,60,61,62,63)  
  GROUP BY a.id 
  ORDER BY a.date_created DESC ,a.id  DESC 
  LIMIT 0, 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	p	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	adcat	NULL	index	PRIMARY	PRIMARY	8	NULL	223	10.00	Using where; Using index
1	SIMPLE	a	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs3816154.adcat.adid	1	10.00	Using where
1	SIMPLE	cb	NULL	eq_ref	user_id	user_id	4	dbs3816154.a.userid	1	100.00	Using where; Using index
1	SIMPLE	u	NULL	eq_ref	PRIMARY	PRIMARY	4	dbs3816154.a.userid	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/content.php:453
13	AdsmanagerModelContent->getContents()	JROOT/components/com_adsmanager/views/list/view.html.php:210
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT c.* 
  FROM sel3_adsmanager_columns as c 
  ORDER BY c.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/column.php:32
13	AdsmanagerModelColumn->getColumns()	JROOT/components/com_adsmanager/views/list/view.html.php:243
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT c.* 
  FROM sel3_adsmanager_fields AS c 
  WHERE c.columnid != -1 
  AND c.published = 1  
  ORDER by c.columnorder,c.fieldid

Explication

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

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.03 ms
preparing	0.01 ms
Sorting result	0.00 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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:164
13	AdsmanagerModelField->getFieldsbyColumns()	JROOT/components/com_adsmanager/views/list/view.html.php:244
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT * 
  FROM sel3_adsmanager_field_values 
  ORDER by ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:277
13	AdsmanagerModelField->getFieldValues()	JROOT/components/com_adsmanager/views/list/view.html.php:268
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.24 ms Après la dernière requête : 0.04 ms Mémoire de requête : 0.023 MB mémoire avant requête : 10.159 MB Rangées retournées : 2

SELECT fieldid,cbfieldvalues 
  FROM sel3_adsmanager_fields as f 
  WHERE published = 1 
  ORDER by f.ordering ASC

Explication

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

Profil

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:296
13	AdsmanagerModelField->getFieldValues()	JROOT/components/com_adsmanager/views/list/view.html.php:268
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.30 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.025 MB mémoire avant requête : 10.174 MB Rangées retournées : 2

SELECT f.* 
  FROM sel3_adsmanager_fields AS f 
  WHERE f.searchable = 1 
  AND f.published = 1 
  ORDER by f.ordering

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.00 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.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/field.php:34
13	AdsmanagerModelField->getSearchFields()	JROOT/components/com_adsmanager/views/list/view.html.php:284
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.41 ms Après la dernière requête : 0.05 ms Mémoire de requête : 0.031 MB mémoire avant requête : 10.186 MB Rangées retournées : 28

Requêtes dupliquées: #80

SELECT c.* 
  FROM sel3_adsmanager_categories as c 
  WHERE  c.published = 1   
  AND c.id IN (1,58,3,4,5,6,7,8,11,9,22,10,12,13,14,15,16,57,42,17,53,18,49,59,60,61,62,63)   
  ORDER BY c.parent,c.ordering,c.id

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
Sorting result	0.00 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_adsmanager/models/category.php:329
13	AdsmanagerModelCategory->getCatTree()	JROOT/components/com_adsmanager/views/list/view.html.php:285
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id,language 
  FROM sel3_menu 
  WHERE link LIKE '%option=com_adsmanager&view=search%' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.17 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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_adsmanager/lib/route.php:221
17	TRoute::_getViewItemid()	JROOT/components/com_adsmanager/lib/route.php:93
16	TRoute::_()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:137
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id 
  FROM sel3_menu 
  WHERE link = 'index.php?option=com_adsmanager&view=front' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/lib/route.php:453
17	TRoute::_getDefaultItemid()	JROOT/components/com_adsmanager/lib/route.php:116
16	TRoute::_()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:137
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id 
  FROM sel3_menu  
  WHERE link LIKE '%option=com_adsmanager%' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/lib/route.php:463
17	TRoute::_getDefaultItemid()	JROOT/components/com_adsmanager/lib/route.php:116
16	TRoute::_()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:137
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #22 #40 #46 #48 #50 #52

SELECT name 
  FROM sel3_adsmanager_categories 
  WHERE id = 10

Explication

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

Profil

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	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

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/router.php:20
25	getAdsmanagerRouteCategory()	JROOT/components/com_adsmanager/router.php:152
24	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
23	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
22	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
21	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
20	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
19	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
18	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
17	Joomla\CMS\Router\Route::_()	JROOT/components/com_adsmanager/lib/route.php:187
16	TRoute::_()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:137
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id,language 
  FROM sel3_menu 
  WHERE link LIKE '%option=com_adsmanager&view=edit%' 
  AND published ='1' 
  AND type ='component'

Explication

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

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.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.17 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_adsmanager/lib/route.php:221
18	TRoute::_getViewItemid()	JROOT/components/com_adsmanager/lib/route.php:93
17	TRoute::_()	JROOT/components/com_adsmanager/helpers/general.php:42
16	JHTMLAdsmanagerGeneral->showGeneralLink()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:171
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #22 #38 #46 #48 #50 #52

SELECT name 
  FROM sel3_adsmanager_categories 
  WHERE id = 10

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
27	JDatabaseDriver->loadResult()	JROOT/components/com_adsmanager/router.php:20
26	getAdsmanagerRouteCategory()	JROOT/components/com_adsmanager/router.php:189
25	AdsmanagerBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
24	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
23	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
22	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/components/com_adsmanager/lib/route.php:187
17	TRoute::_()	JROOT/components/com_adsmanager/helpers/general.php:42
16	JHTMLAdsmanagerGeneral->showGeneralLink()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:171
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `params`
 
  FROM `sel3_comprofiler_plugin`
 
  WHERE `id` = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
43	JDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CBLib/Database/Driver/CmsDatabaseDriver.php:353
42	CBLib\Database\Driver\CmsDatabaseDriver->loadResult()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:43
41	CB\Application\CBConfig::getConfig()	JROOT/libraries/CBLib/CB/Application/CBApplication.php:47
40	CB\Application\CBApplication::CB\Application\{closure}()	Même appel que celui de la ligne ci-dessous.
39	call_user_func_array()	JROOT/libraries/CBLib/CBLib/Application/Config.php:38
38	CBLib\Application\Config::setMainConfig()	JROOT/libraries/CBLib/CBLib/Core/CBLib.php:78
37	CBLib\Core\CBLib::CBLib\Core\{closure}()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:607
36	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
35	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/Application/Application.php:212
34	CBLib\Application\Application::__callStatic()	JROOT/libraries/CBLib/CB/Application/CBConfig.php:77
33	CB\Application\CBConfig::loadLegacyCBueConfig()	JROOT/libraries/CBLib/CB/Legacy/LegacyFoundationFunctions.php:102
32	CB\Legacy\LegacyFoundationFunctions->__construct()	Même appel que celui de la ligne ci-dessous.
31	ReflectionClass->newInstanceArgs()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:645
30	CBLib\DependencyInjection\Container->build()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:498
29	CBLib\DependencyInjection\Container->make()	JROOT/libraries/CBLib/CBLib/DependencyInjection/Container.php:134
28	CBLib\DependencyInjection\Container->get()	JROOT/administrator/components/com_comprofiler/plugin.foundation.php:34
27	include_once JROOT/administrator/components/com_comprofiler/plugin.foundation.php	JROOT/components/com_comprofiler/router.php:75
26	ComprofilerRouter->loadCB()	JROOT/components/com_comprofiler/router.php:125
25	ComprofilerRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
24	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
23	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
22	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
21	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
20	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
19	Joomla\CMS\Router\Route::_()	JROOT/components/com_adsmanager/lib/route.php:41
18	TRoute::_()	JROOT/components/com_adsmanager/lib/link.php:36
17	TLink::getProfileLink()	JROOT/components/com_adsmanager/helpers/general.php:44
16	JHTMLAdsmanagerGeneral->showGeneralLink()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:171
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.58 ms Après la dernière requête : 9.16 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.238 MB Rangées retournées : 0

SELECT id,language 
  FROM sel3_menu 
  WHERE link LIKE '%option=com_adsmanager&view=rules%' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_adsmanager/lib/route.php:221
18	TRoute::_getViewItemid()	JROOT/components/com_adsmanager/lib/route.php:93
17	TRoute::_()	JROOT/components/com_adsmanager/helpers/general.php:47
16	JHTMLAdsmanagerGeneral->showGeneralLink()	JROOT/components/com_adsmanager/views/list/tmpl/default.php:171
15	include JROOT/components/com_adsmanager/views/list/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
13	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_adsmanager/views/list/view.html.php:295
12	AdsmanagerViewList->display()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
9	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_adsmanager/controller.php:137
8	AdsManagerController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_adsmanager/adsmanager.php:29
6	require_once JROOT/components/com_adsmanager/adsmanager.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.58 ms Après la dernière requête : 0.67 ms Mémoire de requête : 0.026 MB mémoire avant requête : 13.291 MB Rangées retournées : 0

Requêtes dupliquées: #58 #65 #70 #75

SELECT id,language 
  FROM sel3_menu 
  WHERE link LIKE '%option=com_adsmanager&view=details%' 
  AND published ='1' 
  AND type ='component'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
21

Répertoire des Richesses

Manucure > Soins (mixte)

Coiffure > Mise en plis

Coiffure > Brushing, mise en plis, couleur

Annonces

Catalogue papier

Nos rendez-vous

Connexion adhérents

Dernières annonces

Gardez contact avec le SEL !

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

116 requêtes exécutées 73.11 ms

36 doubles découverts!