Site officiel de la ville de Figuig

In order to view this object you need Flash Player 9+ support!

projets réalisés

Liste des articles dans la catégorie projets réalisés
Titre
Création de la Fondation LES AMIS DE FIGUIG
Le programme prévisionnel des marchés 2016 البرنامج التوقعي للصفقات
AVIS D’APPELS D’OFFRES OUVERTS 2014
AVIS D’APPELS D’OFFRES OUVERTS 2014 (2)
projets programmés 2013-2014
المركب الاجتماعي للمقاومة و جيش التحرير بفجيج

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1614830220,
                "last": 1614830220,
                "now": 1614830220
            },
            "client": {
                "forwarded": "3.239.33.139"
            },
            "token": "jPj7N7Z53LC4M54lZJks8EzAkBna2zbC"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3ZpbGxlLWZpZ3VpZy5pbmZvL2luZGV4LnBocC8yMDEzLTA4LTAzLTEwLTA4LTIzL3Byb2pldHMvcHJvamV0cy1yZWFsaXNlcz8%3D"
            }
        },
        "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
        },
        "vvisit_counter": {
            "lastlog": 1614830400
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 3.96 ms / 3.96 ms Mémoire: 0.517 MB / 0.89 MB Application: afterLoad

Temps: 45.93 ms / 49.88 ms Mémoire: 0.920 MB / 1.81 MB Application: afterInitialise

Temps: 6.67 ms / 56.55 ms Mémoire: 0.463 MB / 2.27 MB Application: afterRoute

Temps: 6.15 ms / 62.70 ms Mémoire: 0.070 MB / 2.34 MB Application: beforeRenderComponent com_content

Temps: 4.86 ms / 67.57 ms Mémoire: 0.149 MB / 2.49 MB Application: Before Access::preloadComponents (all components)

Temps: 1.83 ms / 69.40 ms Mémoire: 0.059 MB / 2.55 MB Application: After Access::preloadComponents (all components)

Temps: 0.06 ms / 69.46 ms Mémoire: 0.000 MB / 2.55 MB Application: Before Access::preloadPermissions (com_content)

Temps: 2.43 ms / 71.89 ms Mémoire: 0.421 MB / 2.97 MB Application: After Access::preloadPermissions (com_content)

Temps: 0.07 ms / 71.96 ms Mémoire: 0.000 MB / 2.95 MB Application: Before Access::getAssetRules (id:237 name:com_content.category.94)

Temps: 0.29 ms / 72.25 ms Mémoire: 0.009 MB / 2.96 MB Application: After Access::getAssetRules (id:237 name:com_content.category.94)

Temps: 2.83 ms / 75.08 ms Mémoire: 0.043 MB / 3.00 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.06 ms / 75.13 ms Mémoire: 0.007 MB / 3.01 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 14.32 ms / 89.45 ms Mémoire: 0.412 MB / 3.42 MB Application: Before Access::getAssetRules (id:530 name:com_content.article.356)

Temps: 0.03 ms / 89.48 ms Mémoire: 0.002 MB / 3.42 MB Application: After Access::getAssetRules (id:530 name:com_content.article.356)

Temps: 0.34 ms / 89.82 ms Mémoire: 0.080 MB / 3.50 MB Application: Before Access::getAssetRules (id:359 name:com_attachments)

Temps: 0.05 ms / 89.87 ms Mémoire: 0.007 MB / 3.51 MB Application: After Access::getAssetRules (id:359 name:com_attachments)

Temps: 0.03 ms / 89.89 ms Mémoire: 0.001 MB / 3.51 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Temps: 0.02 ms / 89.91 ms Mémoire: 0.008 MB / 3.52 MB Application: After Access::getAssetRules (id:1 name:root.1)

Temps: 4.75 ms / 94.66 ms Mémoire: 0.027 MB / 3.54 MB Application: Before Access::getAssetRules (id:364 name:com_content.article.218)

Temps: 0.07 ms / 94.73 ms Mémoire: 0.007 MB / 3.55 MB Application: After Access::getAssetRules (id:364 name:com_content.article.218)

Temps: 15.71 ms / 110.45 ms Mémoire: 0.149 MB / 3.70 MB Application: Before Access::getAssetRules (id:312 name:com_content.article.167)

Temps: 0.03 ms / 110.47 ms Mémoire: 0.002 MB / 3.70 MB Application: After Access::getAssetRules (id:312 name:com_content.article.167)

Temps: 3.48 ms / 113.96 ms Mémoire: 0.040 MB / 3.74 MB Application: Before Access::getAssetRules (id:313 name:com_content.article.168)

Temps: 0.03 ms / 113.98 ms Mémoire: 0.002 MB / 3.74 MB Application: After Access::getAssetRules (id:313 name:com_content.article.168)

Temps: 3.26 ms / 117.24 ms Mémoire: 0.048 MB / 3.79 MB Application: Before Access::getAssetRules (id:249 name:com_content.article.124)

Temps: 0.03 ms / 117.27 ms Mémoire: 0.002 MB / 3.79 MB Application: After Access::getAssetRules (id:249 name:com_content.article.124)

Temps: 3.19 ms / 120.46 ms Mémoire: 0.035 MB / 3.83 MB Application: Before Access::getAssetRules (id:246 name:com_content.article.122)

Temps: 0.03 ms / 120.49 ms Mémoire: 0.002 MB / 3.83 MB Application: After Access::getAssetRules (id:246 name:com_content.article.122)

Temps: 6.97 ms / 127.46 ms Mémoire: 0.104 MB / 3.93 MB Application: Before Access::getAssetRules (id:209 name:com_content.article.94)

Temps: 0.10 ms / 127.56 ms Mémoire: 0.007 MB / 3.94 MB Application: After Access::getAssetRules (id:209 name:com_content.article.94)

Temps: 7.44 ms / 135.00 ms Mémoire: 0.102 MB / 4.04 MB Application: afterRenderComponent com_content

Temps: 0.54 ms / 135.54 ms Mémoire: 0.017 MB / 4.06 MB Application: afterDispatch

Temps: 11.00 ms / 146.54 ms Mémoire: 0.063 MB / 4.12 MB Application: beforeRenderModule mod_menu ()

Temps: 10.42 ms / 156.96 ms Mémoire: 0.407 MB / 4.53 MB Application: afterRenderModule mod_menu ()

Temps: 0.75 ms / 157.71 ms Mémoire: 0.000 MB / 4.53 MB Application: beforeRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 0.61 ms / 158.33 ms Mémoire: 0.013 MB / 4.54 MB Application: afterRenderModule mod_breadcrumbs (Fil de navigation)

Temps: 0.05 ms / 158.38 ms Mémoire: 0.007 MB / 4.55 MB Application: beforeRenderModule mod_rsflashmatic (صور بمناسبة وضع الحجر الأساسي للمركب الاجتماعي للمقاومة و جيش التحرير بفجيج)

Temps: 5.75 ms / 164.13 ms Mémoire: 0.086 MB / 4.63 MB Application: afterRenderModule mod_rsflashmatic (صور بمناسبة وضع الحجر الأساسي للمركب الاجتماعي للمقاومة و جيش التحرير بفجيج)

Temps: 0.93 ms / 165.06 ms Mémoire: 0.042 MB / 4.68 MB Application: afterRender

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

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

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

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

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

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init for update	0.03 ms
Update	0.12 ms
Waiting for query cache lock	0.20 ms
Update	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.05 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

Temps de requête : 1.04 ms Après la dernière requête : 0.82 ms Mémoire de requête : 0.006 MB mémoire avant requête : 1.266 MB Rangées retournées : 34

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

  FROM `dvrex_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvrex_extensions	ref	extension	extension	62	const	41	Using index condition; Using where

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.37 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

Temps de requête : 0.69 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.368 MB Rangées retournées : 4

SELECT id, rules

  FROM `dvrex_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

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

SELECT b.id

  FROM dvrex_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

Temps de requête : 1.75 ms Après la dernière requête : 0.17 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.402 MB Rangées retournées : 66

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

  FROM dvrex_extensions

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

  ORDER BY ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvrex_extensions	ref	extension	extension	62	const	131	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.88 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.10 ms
Reset for next command	0.02 ms

Pile d'appels

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

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

Temps de requête : 19.05 ms Après la dernière requête : 8.62 ms Mémoire de requête : 0.005 MB mémoire avant requête : 1.736 MB

UPDATE dvrex_vvisit_counter

  SET visits=visits+1
	, guests=guests+1

  WHERE time=1614830400

Explication

EXPLAIN impossible sur la requête : UPDATE dvrex_vvisit_counter SET visits=visits+1 , guests=guests+1 WHERE time=1614830400

Profil

Status	Duration
Starting	0.32 ms
Checking permissions	0.04 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init for update	0.04 ms
Updating	18.08 ms
End of update loop	0.07 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:109
10	plgSystemVVisit_Counter::_updateRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:75
9	plgSystemVVisit_Counter::_insertRecord()	JROOT/plugins/system/vvisit_counter/vvisit_counter.php:43
8	plgSystemVVisit_Counter->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:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.36 ms Après la dernière requête : 1.39 ms Mémoire de requête : 0.009 MB mémoire avant requête : 1.840 MB Rangées retournées : 71

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

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

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

  ORDER BY m.lft

Explication

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.62 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.08 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvrex_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.25 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.96 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.005 MB mémoire avant requête : 2.282 MB

UPDATE `dvrex_extensions`

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

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

Explication

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

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.27 ms
Updating	0.08 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.16 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 1.13 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.003 MB mémoire avant requête : 2.314 MB Rangées retournées : 2

SELECT *

  FROM dvrex_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.90 ms Après la dernière requête : 0.32 ms Mémoire de requête : 0.003 MB mémoire avant requête : 2.329 MB Rangées retournées : 2

SELECT id, home, template, s.params

  FROM dvrex_template_styles as s

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

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	adidjuyo_nctest.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.15 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.19 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.35 ms Après la dernière requête : 5.87 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.495 MB Rangées retournées : 34

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

  FROM `dvrex_assets`

  WHERE `name` IN ('root.1','com_admin','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_cpanel','com_default-icagendatheme','com_extplorer','com_finder','com_icagenda','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_redirect','com_search','com_templates','com_users','com_weblinks','com_wmt_compact_gallery','com_wrapper')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	dvrex_assets	range	idx_asset_name	idx_asset_name	152	NULL	35	Using index condition

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.68 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.25 ms Après la dernière requête : 0.31 ms Mémoire de requête : 0.009 MB mémoire avant requête : 2.547 MB Rangées retournées : 431

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

  FROM `dvrex_assets`

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

Explication

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.57 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.08 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.49 ms Après la dernière requête : 2.05 ms Mémoire de requête : 0.008 MB mémoire avant requête : 2.963 MB Rangées retournées : 3

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

  FROM `dvrex_content` AS `i`

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

  FROM `dvrex_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

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

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.23 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.15 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.04 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.05 ms
Starting cleanup	0.02 ms
Freeing items	0.01 ms
Removing tmp table	0.02 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 1.35 ms Après la dernière requête : 0.86 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.008 MB Rangées retournées : 6

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

  FROM dvrex_content AS a

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 94 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 03:57:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 03:57:01')

  ORDER BY  c.path,   a.created  DESC ,  a.created   
  LIMIT 10

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.13 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.46 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

Temps de requête : 0.47 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.008 MB mémoire avant requête : 3.146 MB Rangées retournées : 0

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

SELECT COUNT(*)

  FROM dvrex_content AS a

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

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

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

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

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 94 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-03-04 03:57:01') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-03-04 03:57:01')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	Using where

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

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

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

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

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

  FROM `dvrex_contentitem_tag_map` AS m 

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

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

Explication

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

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.02 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">Le Dimanche 2 février 2020, (02/02/2020) la Chambre de commerce et d\'industrie d\'Oujda a accueilli les travaux de l\'assemblée générale fondatrice de la <span style=\"color: #0000ff;\">Fondation AMIS DE FIGUIG</span>, au cours de laquelle sa loi fondamentale a été ratifiée, et son conseil d\'administration et son bureau exécutif dirigé par M. Mustafa Al-Madarsi, le descendant d\'une des plus anciennes familles Figuiguiennes connues pour leurs contributions au mouvement national, ont été élus. Il est bien connu pour ses causes caritatives et ses œuvres caritatives aux niveaux local et national.</span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">Il convient de noter que la Fondation AMIS DE FIGUIG aspire à contribuer au décollage économique et social de la province de Figuig en promouvant un travail de solidarité ancré dans la culture des habitants de cette région, en développant ses mécanismes et en poussant vers l\'automaticité et le partenariat entre les associations de la société civile dans la région et ses extensions humaines à travers le sol national et à l\'extérieur pour servir les citoyens et en particulier dans les régions isolées et éloignées.</span></p>\r\n<p><img style=\"display: block; margin-
  left: auto; margin-right: auto;\" src=\"images/figuig/darfiguig.jpg\" alt=\"\" width=\"475\" height=\"356\" /></p>\r\n<p><img style=\"display: block; margin-
  left: auto; margin-right: auto;\" src=\"images/figuig/darfiguig2.jpg\" alt=\"\" width=\"477\" height=\"268\" /></p>\r\n<p><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">  </span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">Les participants ont tenu à souligner la coïncidence de la création de la Fondation AMIS DE FIGUIG avec le débat national sur le modèle de développement que Sa Majesté a appelé à faire, ce qui le place au premier plan des initiatives populaires pour inclure la dimension régionale comme pilier principal du succès de ce modèle souhaité pour notre pays.</span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">Le rassemblement fondateur a connu une présence notable qui a dépassé les attentes du comité préparatoire, le nombre de participants, selon les estimations préliminaires, dépassant 400 participants, parmi lesquels un groupe d\'intellectuels et d\'académiques dans des spécialisations précises au niveau mondial, ainsi qu\'un groupe de propriétaires financiers et commerciaux de grands entrepreneurs au niveau national. La réunion a également été marquée par la participation de plus de 10 associations travaillant dans les domaines du développement économique et social, et d\'autres concernées par le travail culturel, sportif et de santé.</span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">Tous les participants ont exprimé leur souhait que la Fondation AMIS DE FIGUIG joue le rôle de locomotive dans les domaines du développement durable, du renforcement des capacités, du formation des compétences, des startups d\'accompagnement, du soutien aux projets créateurs d\'emplois et de l\'inclusion des jeunes et des femmes en plus des domaines traditionnels du travail caritatif et philanthropique en santé, éducation et accès aux services de base destinés aux individus et aux familles qui sont dans une position de précarité, toutes, dans les limites des pouvoirs que la constitution accorde à la société civile en tant que sympathisant, soutiennent et complètent le travail effectué par les institutions étatiques.</span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">À la fin de la réunion, le siège de la Fondation a été inauguré, il a appelé «Dar Figuig», qui est une villa de grande superficie, a été présenté par le président de la Fondation au nom de ses frères, sœurs et mère de la famille Al-Madarsi Al-Salami, un don et une dotation pour la Fondation. Cette maison est considérée comme un lieu de grande charge nationale car elle a été témoin des préparatifs de la naissance de «l\'Union nationale des forces populaires» et de plusieurs réunions des dirigeants de l\'Armée de libération et du mouvement national avant l\'indépendance.</span></p>\r\n<p style=\"text-align: justify;\"><span style=\"font-family: \'comic sans ms\', sans-serif; font-size: 12pt; color: #000000;\">A l\'issue des travaux de l\'assemblée générale fondatrice de la Fondation Figuig, les participants ont envoyé un télégramme de fidélité à Sa Majesté le Roi Mohammed VI, que Dieu le glorifie.</span><br /><br /></p>' 
  AND id = 356 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.31 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.12 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 356

Explication

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

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.02 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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.46 ms Après la dernière requête : 0.62 ms Mémoire de requête : 0.009 MB mémoire avant requête : 3.515 MB Rangées retournées : 0

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=356 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	1.71 ms
After opening tables	0.06 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<p><span style=\"color: #000000;\">البرنامج التوقعي للصفقات التي يعزم صاحب المشروع جماعة فجيج طرحها برسم السنة المالية 2016. (الأشغال)<img src=\"images/symboles/new_ar.gif\" border=\"0\" alt=\"\" /></span><br /><br /><span style=\"color: #000000;\"><img src=\"images/symboles/nouveau_02.gif\" border=\"0\" alt=\"\" />Le programme prévisionnel des marchés de la commune de Figuig envisage de lancer pour l\'année budgétaire 2016. (Les travaux</span></p>\r\n<p> <img src=\"images/symboles/ici-best.gif\" border=\"0\" alt=\"\" width=\"88\" height=\"49\" /></p>' 
  AND id = 218 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 218

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=218 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.02 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.42 ms Après la dernière requête : 4.88 ms Mémoire de requête : 0.012 MB mémoire avant requête : 3.610 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `dvrex_assets`

Explication

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

Profil

Status	Duration
Starting	0.18 ms
Checking permissions	0.03 ms
Closing tables	0.02 ms
Opening tables	0.26 ms
After opening tables	0.03 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
Checking permissions	0.10 ms
Closing tables	0.02 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.09 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.09 ms
Updating status	0.09 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
26	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
25	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
24	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
23	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1008
18	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #34

SELECT *

  FROM dvrex_assets

  WHERE `name` = 'edit'

Explication

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

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:1008
18	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT/components/com_attachments/models/attachments.php:462
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #33

SELECT *

  FROM dvrex_assets

  WHERE `name` = 'edit'

Explication

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
23	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
22	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
21	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
20	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
19	Joomla\CMS\User\User->authorise()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:915
18	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT/components/com_attachments/models/attachments.php:463
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_content

  WHERE id=218 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
20	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:648
19	AttachmentsPlugin->parentExists()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:344
18	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
17	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
16	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:132
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT title

  FROM dvrex_content

  WHERE id=218

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
19	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:359
18	AttachmentsPlugin->getTitle()	JROOT/components/com_attachments/models/attachments.php:254
17	AttachmentsModelAttachments->getParentTitle()	JROOT/components/com_attachments/views/attachments/view.html.php:152
16	AttachmentsViewAttachments->display()	JROOT/components/com_attachments/controllers/attachments.php:132
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<p style=\"text-align: center;\"><img src=\"documents/marches_publics/logo-M-publics-Maroc.jpg\" border=\"0\" alt=\"\" width=\"341\" height=\"93\" /> </p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #003300;\"><img src=\"images/symboles/nouveau_02.gif\" border=\"0\" alt=\"\" /></span></p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #003300;\">Il sera procédé, dans les bureaux du Président du conseil municipal de Figuig, à l’ouverture des plis relatifs   aux appels d’offres sur offres des prix  pour  :</span><br /><br /><span style=\"color: #003300;\"><strong>1-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Renouvellement du réseau d’eau potable du Ksar Zénaga ville de FIGUIG.</a></span>  <a href=\"documents/marches_publics/AEP%20INDH%20%20F2014.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a><br /><span style=\"color: #003300;\"><strong>2-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%20%20CARBURANT%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Achat de carburant et lubrifiant pour véhicules de la Commune urbaine de Figuig.</a></span> <a href=\"documents/marches_publics/Carburant%202014.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a><br /><span style=\"color: #003300;\"><strong>3-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%20%20camion%20%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Achat d’un camion à benne tasseuse pour collecte des déchets ménagers au profit  de la Commune urbaine de Figuig.</a></span>  <a href=\"documents/marches_publics/achat_camion.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a></p>\r\n<p><a href=\"documents/marches_publics/programme%20previsionnel%202014-FR.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\"><strong><img src=\"images/symboles/info.gif\" border=\"0\" alt=\"\" width=\"29\" height=\"29\" />Le programme prévisionnel des marchés que la commune urbaine de Figuig envisage de lancer pour l’année budgétaire  2014</strong></a></p>\r\n<p style=\"text-align: center;\"><strong>***************************<br /></strong></p>\r\n<p style=\"text-align: right;\"><span style=\"color: #003300;\"> <img src=\"images/symboles/jadid.gif\" border=\"0\" alt=\"\" width=\"37\" height=\"20\" /><img src=\"images/symboles/e3lan2.gif\" border=\"0\" alt=\"\" /><br /></span></p>\r\n<p style=\"text-align: right;\" dir=\"rtl\"><strong>1-</strong> <a href=\"documents/marches_publics/أشغال%20تجديد%20شبكة%20الماء%20الصالح%20للشرب%20بقصر%20زناقة%20فجيج.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">أشغال تجديد شبكة الماء الصالح للشرب بقصر زناقة فجيج في إطار المبادرة الوطنية للتنمية البشرية البرنامج الأفقي 2012 .</a><a href=\"documents/marches_publics/AEP%20INDH%20%20F2014.zip\"><span style=\"background-color: #00ff00;\"> أنقر هنا للتحميل</span></a><br /><strong>2-</strong> <a href=\"documents/marches_publics/اقتناء%20الوقود%20والزيوت%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">اقتناء الوقود والزيوت الخاصة بعربات  الجماعة الحضرية لفجيج.</a><a href=\"documents/marches_publics/Carburant%202014.zip\" target=\"_blank\"> <span style=\"background-color: #00ff00;\">أنقر هنا للتحميل</span></a><br /><strong>3-</strong> <a href=\"documents/marches_publics/اقتناء%20شاحنة%20لنقل%20النفايات%20المنزلية%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">اقتناء شاحنة لنقل النفايات المنزلية لفائدة   الجماعة الحضرية لفجيج.</a> <a href=\"documents/marches_publics/achat_camion.zip\" target=\"_blank\"><span style=\"background-color: #00ff00;\">أنقر هنا للتحميل</span></a></p>\r\n<p dir=\"RTL\"><a href=\"documents/marches_publics/programme%20pr%C3%A9visionnel-2014-AR%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثيقة\"><img src=\"images/symboles/info.gif\" border=\"0\" alt=\"\" width=\"35\" height=\"35\" /><strong>البرنامج التوقعي للصفقات التي يعزم صاحب المشروع  الجماعة الحضرية لفجيج  طرحها برسم  السنة المالية 2014</strong></a></p>\r\n<p dir=\"RTL\"><strong> </strong></p>' 
  AND id = 167 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 167

Explication

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.03 ms
Reset for next command	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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=167 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<p style=\"text-align: center;\"><img src=\"documents/marches_publics/logo-M-publics-Maroc.jpg\" border=\"0\" alt=\"\" width=\"341\" height=\"93\" /> </p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #003300;\"><img src=\"images/symboles/nouveau_02.gif\" border=\"0\" alt=\"\" /></span></p>\r\n<p style=\"text-align: justify;\"><span style=\"color: #003300;\">Il sera procédé, dans les bureaux du Président du conseil municipal de Figuig, à l’ouverture des plis relatifs   aux appels d’offres sur offres des prix  pour  :</span><br /><br /><span style=\"color: #003300;\"><strong>1-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Renouvellement du réseau d’eau potable du Ksar Zénaga ville de FIGUIG.</a></span>  <a href=\"documents/marches_publics/AEP%20INDH%20%20F2014.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a><br /><span style=\"color: #003300;\"><strong>2-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%20%20CARBURANT%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Achat de carburant et lubrifiant pour véhicules de la Commune urbaine de Figuig.</a></span> <a href=\"documents/marches_publics/Carburant%202014.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a><br /><span style=\"color: #003300;\"><strong>3-</strong> <a href=\"documents/marches_publics/appel%20d\'offres%20%20camion%20%202014.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\">Achat d’un camion à benne tasseuse pour collecte des déchets ménagers au profit  de la Commune urbaine de Figuig.</a></span>  <a href=\"documents/marches_publics/achat_camion.zip\" target=\"_blank\"><span style=\"color: #0000ff; background-color: #00ff00;\"><strong><span style=\"color: #0000ff; background-color: #00ff00;\">cliquez ici</span></strong></span></a></p>\r\n<p><a href=\"documents/marches_publics/programme%20previsionnel%202014-FR.doc\" target=\"_blank\" title=\"Cliquez pour télécharger\"><strong><img src=\"images/symboles/info.gif\" border=\"0\" alt=\"\" width=\"29\" height=\"29\" />Le programme prévisionnel des marchés que la commune urbaine de Figuig envisage de lancer pour l’année budgétaire  2014</strong></a></p>\r\n<p style=\"text-align: center;\"><strong>***************************<br /></strong></p>\r\n<p style=\"text-align: right;\"><span style=\"color: #003300;\"> <img src=\"images/symboles/jadid.gif\" border=\"0\" alt=\"\" width=\"37\" height=\"20\" /><img src=\"images/symboles/e3lan2.gif\" border=\"0\" alt=\"\" /><br /></span></p>\r\n<p style=\"text-align: right;\" dir=\"rtl\"><strong>1-</strong> <a href=\"documents/marches_publics/أشغال%20تجديد%20شبكة%20الماء%20الصالح%20للشرب%20بقصر%20زناقة%20فجيج.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">أشغال تجديد شبكة الماء الصالح للشرب بقصر زناقة فجيج في إطار المبادرة الوطنية للتنمية البشرية البرنامج الأفقي 2012 .</a><a href=\"documents/marches_publics/AEP%20INDH%20%20F2014.zip\"><span style=\"background-color: #00ff00;\"> أنقر هنا للتحميل</span></a><br /><strong>2-</strong> <a href=\"documents/marches_publics/اقتناء%20الوقود%20والزيوت%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">اقتناء الوقود والزيوت الخاصة بعربات  الجماعة الحضرية لفجيج.</a><a href=\"documents/marches_publics/Carburant%202014.zip\" target=\"_blank\"> <span style=\"background-color: #00ff00;\">أنقر هنا للتحميل</span></a><br /><strong>3-</strong> <a href=\"documents/marches_publics/اقتناء%20شاحنة%20لنقل%20النفايات%20المنزلية%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثائق\">اقتناء شاحنة لنقل النفايات المنزلية لفائدة   الجماعة الحضرية لفجيج.</a> <a href=\"documents/marches_publics/achat_camion.zip\" target=\"_blank\"><span style=\"background-color: #00ff00;\">أنقر هنا للتحميل</span></a></p>\r\n<p dir=\"RTL\"><a href=\"documents/marches_publics/programme%20pr%C3%A9visionnel-2014-AR%20.doc\" target=\"_blank\" title=\"أنقر هنا لتحميل الوثيقة\"><img src=\"images/symboles/info.gif\" border=\"0\" alt=\"\" width=\"35\" height=\"35\" /><strong>البرنامج التوقعي للصفقات التي يعزم صاحب المشروع  الجماعة الحضرية لفجيج  طرحها برسم  السنة المالية 2014</strong></a></p>\r\n<p dir=\"RTL\"><strong> </strong></p>' 
  AND id = 168 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 168

Explication

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=168 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<div align=\"
  left\">\r\n<table style=\"width: 568px; height: 522px;\" dir=\"rtl\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">\r\n<tbody>\r\n<tr>\r\n<td colspan=\"3\" width=\"236\">\r\n<p dir=\"LTR\" align=\"center\"><strong><em>contribution</em></strong></p>\r\n<p dir=\"LTR\" align=\"center\"><strong><em>Des partenaires</em></strong></p>\r\n<p dir=\"LTR\" align=\"center\"><strong><em>(</em></strong><strong><em>DH</em></strong><strong><em>)</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p dir=\"LTR\" align=\"center\"><strong><em>budget de r</em></strong><strong><em>é</em></strong><strong><em>ali</em></strong><strong><em>sation</em></strong></p>\r\n<p dir=\"LTR\" align=\"center\"><strong>(</strong><strong><em>DH</em></strong><strong>)</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p style=\"text-align: center;\" dir=\"LTR\" align=\"center\"><strong><em>Le projet</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\"top\" width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>200000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>La commune </em></strong></p>\r\n</td>\r\n<td rowspan=\"2\" width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>600000.00</strong></p>\r\n</td>\r\n<td rowspan=\"2\" width=\"262\">\r\n<p dir=\"LTR\"><strong><em>1. les travaux  de construction du réseau d’assainissement liquide à ksar L’Oudaghir</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\"top\" width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>400000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Conseil régional</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\"top\" width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em>240000.00</em></strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune </em></strong></p>\r\n</td>\r\n<td rowspan=\"2\" valign=\"top\" width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>540000.00</strong></p>\r\n</td>\r\n<td rowspan=\"2\" width=\"262\">\r\n<p dir=\"LTR\"><strong><em>2.réalisation du système d’épuration des eaux usées de l’abattoir </em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\"top\" width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em> 300000.00</em></strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>SIAAP</em></strong></p>\r\n<p dir=\"LTR\"><strong><em>CGSS DENIS</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td valign=\"top\" width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>500000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>500000.00</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p dir=\"LTR\"><strong><em>3. Travaux de construction de la deuxième tranche du centre commercial</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>500000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>500000.00</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p dir=\"LTR\"><strong><em>4. Travaux de construction de la deuxième tranche du souk hebdomadaire</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>30000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>30000.00</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p dir=\"LTR\"><strong><em>5.Acquisition du matériel et de mobilier pour les bureaux administratifs</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>100000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>100000.00</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p dir=\"LTR\"><strong><em>6.l’elaboration des études et l\'assistance technique</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>200000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td rowspan=\"4\" width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>1200000.00</strong></p>\r\n</td>\r\n<td rowspan=\"4\" width=\"262\">\r\n<p dir=\"LTR\"><strong><em>7. Construction d\'un centre et un musée éducatif et culturel</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>400000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Initiative Nationale pour le Développement Humain</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>300000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Conseil provincial</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong>300000.00</strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Agence de développement de l’oriental </em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em>200000.00</em></strong></p>\r\n</td>\r\n<td colspan=\"2\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td rowspan=\"3\" width=\"113\">\r\n<p dir=\"LTR\" align=\"right\"><strong>800000.00</strong></p>\r\n</td>\r\n<td rowspan=\"3\" width=\"262\">\r\n<p dir=\"LTR\"><strong><em>8.les travaux  de renouvellement du réseau d\'eau potable</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em>200000.00</em></strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Initiative Nationale pour le Développement Humain</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td width=\"92\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em>400000.00</em></strong></p>\r\n</td>\r\n<td colspan=\"2\" valign=\"top\" width=\"144\">\r\n<p dir=\"LTR\"><strong><em>Conseil provincial</em></strong></p>\r\n</td>\r\n</tr>\r\n<tr>\r\n<td colspan=\"2\" width=\"112\">\r\n<p dir=\"LTR\" align=\"right\"><strong>950000.00</strong></p>\r\n</td>\r\n<td width=\"124\">\r\n<p dir=\"LTR\" align=\"right\"><strong><em>la commune</em></strong></p>\r\n</td>\r\n<td width=\"113\">\r\n<p style=\"text-align: right;\" dir=\"LTR\" align=\"center\"><strong>950000.00</strong></p>\r\n</td>\r\n<td width=\"262\">\r\n<p dir=\"LTR\"><strong><em>9. l’acquisition d’un camion pour les déchets solides</em></strong></p>\r\n</td>\r\n</tr>\r\n</tbody>\r\n</table>\r\n</div>' 
  AND id = 124 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.07 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 124

Explication

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

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=124 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.07 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='<p style=\"text-align: right;\"><span style=\"font-size: medium;\">في إطار توطيد وتعميق الذاكرة الوطنية للأمجاد والاماجد وترسيخها للتنويه بنضالات الوطنيين المجاهدين، والاشادة بانجازات المقاومين الابطال قام السيد مصطفى الكثيري المندوب السامي لقدماء المقاومين و أعضاء جيش التحرير بزيارة الى مدينة فجيج مع السيد عامل صاحب الجلالة على إقليم فجيج و الوفد المرافق لهما يومه الجمعة 25 أكتوبر 2013 على الساعة الحادية عشرة صباحاً وذلك لوضع الحجر الأساسي لبناء المركب الاجتماعي للمقاومة و جيش التحرير بالمدينة على مساحة مغطاة 226 متر مربع.</span><br /><span style=\"font-size: medium;\">يتم بناء هذا المشروع في مدة 9 أشهر ، وتقدر قيمته الإجمالية لأشغال هذا المشروع بـ 946.146.00 درهم.</span><br /><span style=\"font-size: medium;\">يتكون هذا المركب من بهو و مكتبة و مكتبين و قاعة للمعلوميات و قاعة العرض و قاعة الاعلاميات و قاعة الانتظار و مرافق صحية.</span><br /><br /><span style=\"color: #008000; font-size: medium;\">البطاقة التقنية للمشروع:</span><br /><span style=\"font-size: medium;\">المهندسة المعمارية: حجيبة عمار - وجدة</span><br /><span style=\"font-size: medium;\">المقاولة : أنفراكو  INFRACO   </span><br /><span style=\"font-size: medium;\">صاحب المشروع : عمالة فجيج</span><br /><br /><span style=\"color: #008000; font-size: medium;\">الشركاء في المشروع :</span><br /><br /><span style=\"font-size: medium;\">عمالة إقليم فجيج كحصة المبادرة الوطنية للتنمية البشرية برنامج محاربة الهشاشة بمساهمة مادية 400.000.00 درهم. </span><br /><span style=\"font-size: medium;\">المجلس الإقليمي، بمساهمة مادية 300.000.00 درهم.</span><br /><span style=\"font-size: medium;\">وكالة الإنعاش والتنمية الإقتصادية و الاجتماعية لعمالة وأقاليم الجهة الشرقية بمساهمة مادية 300.000.00 درهم.</span><br /><span style=\"font-size: medium;\">الجماعة الحضرية لفجيج بمساهمة مادية 200.000.00 درهم.</span><br /><span style=\"font-size: medium;\">المجموع لهذه المساهات: 1.200.000.00 درهم.</span></p>\r\n<p style=\"text-align: right;\"> </p>' 
  AND id = 122 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
13	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 122

Explication

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

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.04 ms
Updating status	0.04 ms
Reset for next command	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/plugins/attachments/attachments_for_content/attachments_for_content.php:811
14	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=122 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	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_attachments/models/attachments.php:436
17	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
16	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
15	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
14	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:302
13	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:121
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT id

  FROM dvrex_categories

  WHERE description='' 
  AND id = 94 
  LIMIT 1

Explication

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

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.07 ms
Freeing items	0.07 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
22	JDatabaseDriver->loadResult()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:792
21	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:180
20	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT a.*, u.name as creator_name

  FROM dvrex_attachments AS a

  LEFT JOIN dvrex_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=94 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='category' 
  AND a.access IN (1)

  ORDER BY filename

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	Using where; Utilisation du tri complet de type filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	adidjuyo_nctest.a.created_by	1

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.14 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.06 ms
Reset for next command	0.07 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/components/com_attachments/models/attachments.php:436
24	AttachmentsModelAttachments->getAttachmentsList()	JROOT/components/com_attachments/models/attachments.php:514
23	AttachmentsModelAttachments->someVisible()	JROOT/components/com_attachments/controllers/attachments.php:98
22	AttachmentsControllerAttachments->displayString()	JROOT/plugins/attachments/attachments_plugin_framework/attachments_plugin.php:911
21	AttachmentsPlugin->insertAttachmentsList()	JROOT/plugins/content/attachments/attachments.php:196
20	plgContentAttachments->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT created_by, catid

  FROM dvrex_content

  WHERE id = 94

Explication

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.02 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/plugins/attachments/attachments_for_content/attachments_for_content.php:811
21	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT/plugins/content/attachments/attachments.php:296
20	plgContentAttachments->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:31
17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/components/com_content/views/category/tmpl/default.php:20
14	include JROOT/components/com_content/views/category/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

55 requêtes exécutées 73.77 ms

2 doubles découverts!