145 Express

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 4,
            "timer": {
                "start": 1765160445,
                "last": 1765160447,
                "now": 1765160448
            },
            "token": "bwfNmQoka5q7ZWxOzyXxJxgZ1LJnuPhS"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "fr-FR"
        },
        "gtag": false,
        "com_contentbuilderformsd_id": 25
    },
    "__easycalccheckplus": {
        "redirectUrl": null,
        "eccLoaded": null
    },
    "__com_contentbuilder": {
        "permissions_fe": {
            "published": true,
            "limit_edit": true,
            "limit_add": true,
            "verify_view": true,
            "verify_new": true,
            "verify_edit": true,
            "1": {
                "listaccess": true,
                "view": true
            },
            "2": {
                "listaccess": true,
                "view": true
            },
            "6": {
                "listaccess": true,
                "view": true
            },
            "8": {
                "listaccess": true,
                "view": true,
                "new": true,
                "edit": true,
                "delete": true,
                "state": true,
                "publish": true
            },
            "9": {
                "listaccess": true,
                "view": true
            },
            "3": {
                "listaccess": true,
                "view": true
            },
            "16": {
                "listaccess": true,
                "view": true
            },
            "4": {
                "listaccess": true,
                "view": true
            },
            "12": {
                "listaccess": true,
                "view": true
            },
            "13": {
                "listaccess": true,
                "view": true
            },
            "5": {
                "listaccess": true,
                "view": true
            },
            "7": {
                "listaccess": true,
                "view": true
            },
            "14": {
                "listaccess": true,
                "view": true
            },
            "15": {
                "listaccess": true,
                "view": true
            }
        }
    }
}

Profil d'information

Occupation de la mémoire

Requêtes de base de données

68 requêtes exécutées 113.69 ms

23 doubles découverts!

6 requêtes dupliquées: #8 #16 #18 #63 #64 #67

5 requêtes dupliquées: #28 #44 #47 #51 #56

5 requêtes dupliquées: #29 #45 #48 #52 #57

5 requêtes dupliquées: #30 #46 #49 #53 #58

2 requêtes dupliquées: #33 #54

Temps de requête : 0.76 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.184 MB Rangées retournées : 40

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

  FROM `VCD_extensions`

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

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 0.35 ms Après la dernière requête : 2.61 ms Mémoire de requête : 0.020 MB mémoire avant requête : 4.425 MB Rangées retournées : 10

SELECT id, rules

  FROM `VCD_viewlevels`

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT b.id

  FROM VCD_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 1.29 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.038 MB mémoire avant requête : 4.504 MB Rangées retournées : 122

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

  FROM VCD_extensions

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

  ORDER BY ordering

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT *

  FROM `VCD_nextend2_section_storage`

  WHERE `application` = 'smartslider' 
  AND `section` = 'settings'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_nextend2_section_storage	NULL	ref	application,application_2	application	214	const,const	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182
12	Nextend\Framework\Database\Joomla\JoomlaConnectorTable->setQuery()	JROOT/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:56
11	Nextend\Framework\Database\Joomla\JoomlaConnectorTable->findByAttributes()	JROOT/libraries/smartslider3/src/Framework/Model/ApplicationSection.php:44
10	Nextend\Framework\Model\ApplicationSection->get()	JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:17
9	Nextend\SmartSlider3\Settings::getAll()	JROOT/libraries/smartslider3/src/SmartSlider3/Settings.php:25
8	Nextend\SmartSlider3\Settings::get()	JROOT/plugins/system/smartslider3/smartslider3.php:16
7	require_once JROOT/plugins/system/smartslider3/smartslider3.php	JROOT/libraries/src/Plugin/PluginHelper.php:251
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `VCD_extensions`

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:17
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 4.72 ms Après la dernière requête : 0.12 ms Mémoire de requête : 0.005 MB mémoire avant requête : 8.652 MB

UPDATE `VCD_extensions`

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

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

Explication

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

Profil

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.14 ms
updating	0.23 ms
end	0.03 ms
query end	3.88 ms
closing tables	0.04 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:17
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.66 ms Après la dernière requête : 1.71 ms Mémoire de requête : 0.023 MB mémoire avant requête : 8.819 MB Rangées retournées : 175

Requêtes dupliquées: #16 #18 #63 #64 #67

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431
8	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:18
7	plgSystemJomclassifiedsLocationManager->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.80 ms Après la dernière requête : 15.59 ms Mémoire de requête : 0.020 MB mémoire avant requête : 10.131 MB Rangées retournées : 4

SELECT *

  FROM VCD_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.62 ms Après la dernière requête : 0.25 ms Mémoire de requête : 0.020 MB mémoire avant requête : 10.141 MB Rangées retournées : 10

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `VCD_extensions`

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.25 ms Après la dernière requête : 9.56 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.611 MB

Update
                        VCD_contentbuilder_articles As articles,
                        VCD_content As content, 
                        VCD_contentbuilder_forms As forms,
                        VCD_contentbuilder_registered_users As cbusers,
                        VCD_users As users
                    
  Set 
                        content.state = 0
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 1
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                      (
                        (
                            users.id = cbusers.user_id
                          
  And
                            users.block = 1
                        )
                      )

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cbusers	NULL	index	user_id	user_id	16	NULL	1	100.00	Using index
1	SIMPLE	forms	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.cbusers.form_id	1	33.33	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	db715876307.cbusers.user_id	1	11.76	Using where
1	UPDATE	content	NULL	ref	PRIMARY,idx_state,idx_createdby	idx_createdby	4	db715876307.cbusers.user_id	6	100.00	Using where
1	SIMPLE	articles	NULL	ref	article_id	article_id	4	db715876307.content.id	1	10.00	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.08 ms
init	0.04 ms
updating main table	0.02 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.07 ms
executing	0.01 ms
Sending data	0.03 ms
updating reference tables	0.01 ms
end	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:417
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.88 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.005 MB mémoire avant requête : 10.617 MB

Update 
                        VCD_contentbuilder_articles As articles,
                        VCD_content As content, 
                        VCD_contentbuilder_forms As forms,
                        VCD_contentbuilder_records As records,
                        VCD_contentbuilder_registered_users As cbusers,
                        VCD_users As users
                    
  Set 
                        content.state = forms.auto_publish
                    
  Where 
                        articles.article_id = content.id
                    
  And
                        content.state = 0
                    
  And
                        articles.form_id = forms.id
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        content.created_by = cbusers.user_id
                    
  And
                        users.id = cbusers.user_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        users.block = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cbusers	NULL	index	user_id	user_id	16	NULL	1	100.00	Using index
1	SIMPLE	forms	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.cbusers.form_id	1	33.33	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	db715876307.cbusers.user_id	1	100.00	Using where
1	SIMPLE	records	NULL	ref	record_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	db715876307.cbusers.record_id	1	50.00	Using where
1	UPDATE	content	NULL	ref	PRIMARY,idx_state,idx_createdby	idx_createdby	4	db715876307.cbusers.user_id	6	6.75	Using where
1	SIMPLE	articles	NULL	ref	article_id	article_id	4	db715876307.content.id	1	10.00	Using where

Profil

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.04 ms
updating main table	0.02 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.02 ms
updating reference tables	0.01 ms
end	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
10	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:450
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select 
                    form.id As form_id,
                    form.act_as_registration,
                    form.default_category,
                    form.registration_name_field, 
                    form.registration_username_field, 
                    form.registration_email_field, 
                    form.registration_email_repeat_field, 
                    form.`last_update`,
                    article.`article_id`,
                    form.`title_field`,
                    form.`create_articles`,
                    form.`name`,
                    form.`use_view_name_as_title`,
                    form.`protect_upload_directory`,
                    form.`reference_id`,
                    records.`record_id`,
                    form.`type`,
                    form.`published_only`,
                    form.`own_only`,
                    form.`own_only_fe`,
                    records.`last_update` As record_last_update,
                    article.`last_update` As article_last_update
                
  From
                    VCD_contentbuilder_records As records
                    
  Left Join VCD_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )
                    
  Left Join VCD_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                    
  Left Join VCD_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )
                
  Where 
                    form.`published` = 1
                
  And
                    form.create_articles = 1
                
  And
                    form.`type` = records.`type`
                
  And 
                    form.reference_id = records.reference_id
                
  And
                   (
                     (
                        article.form_id = form.id 
                      
  And 
                        article.record_id = records.record_id
                      
  And 
                        article.article_id = content.id 
                      
  And 
                        ( content.state = 1 Or content.state = 0 )
                      
  And
                      (
                        form.`last_update` > article.`last_update`   
                       Or
                        records.`last_update` > article.`last_update`
                      )
                     )
                     Or
                     (
                        form.id Is Not Null 
  And records.id Is Not Null 
  And content.id Is Null 
  And article.id Is Null
                     )
                   )
                
  Limit 50

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	form	NULL	ALL	PRIMARY,reference_id	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	3	33.33	Using where
1	SIMPLE	records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	reference_id	4	db715876307.form.reference_id	253	50.00	Using where
1	SIMPLE	article	NULL	ref	record_id,record_id_2	record_id	12	db715876307.records.record_id,db715876307.form.id	1	60.00	Using where
1	SIMPLE	content	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.article.article_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
10	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:516
9	plgSystemContentbuilder_system->onAfterInitialize()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:362
8	plgSystemContentbuilder_system->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 7.40 ms Après la dernière requête : 2.79 ms Mémoire de requête : 0.089 MB mémoire avant requête : 11.506 MB Rangées retournées : 63

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

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

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

  ORDER BY m.lft

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	133	10.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.85 ms
Sending data	0.04 ms
Creating sort index	2.26 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.09 ms
cleaning up	0.03 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/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM `VCD_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '11'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_template_styles	NULL	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:58
10	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/helixultimate.php:215
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.58 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.023 MB mémoire avant requête : 13.103 MB Rangées retournées : 175

Requêtes dupliquées: #8 #18 #63 #64 #67

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431
9	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:137
8	plgSystemJomclassifiedsLocationManager->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.87 ms Après la dernière requête : 1.88 ms Mémoire de requête : 0.071 MB mémoire avant requête : 13.230 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM VCD_template_styles as s

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

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

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
18	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
17	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
16	Joomla\CMS\HTML\HTMLHelper::script()	Même appel que celui de la ligne ci-dessous.
15	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
14	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
13	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
12	JHtmlJquery::framework()	Même appel que celui de la ligne ci-dessous.
11	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
10	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
9	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:143
8	plgSystemJomclassifiedsLocationManager->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.94 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.024 MB mémoire avant requête : 13.281 MB Rangées retournées : 175

Requêtes dupliquées: #8 #16 #63 #64 #67

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:431
10	plgSystemJomclassifiedsLocationManager->getCfg()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:112
9	plgSystemJomclassifiedsLocationManager->JomclRegisterRedirect()	JROOT/plugins/system/jomclassifiedslocationmanager/jomclassifiedslocationmanager.php:151
8	plgSystemJomclassifiedsLocationManager->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:236
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.78 ms Après la dernière requête : 1.71 ms Mémoire de requête : 0.005 MB mémoire avant requête : 14.202 MB


  SET SESSION group_concat_max_len = 9999999

Explication

EXPLAIN impossible sur la requête : SET SESSION group_concat_max_len = 9999999

Profil

Status	Duration
starting	0.04 ms
Opening tables	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
11	JDatabase->query()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:22
10	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select * 
  From VCD_facileforms_forms 
  Where id = 22 
  And published = 1 
  Order By `ordering`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:25
10	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.86 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.022 MB mémoire avant requête : 14.286 MB Rangées retournées : 20

Select * 
  From VCD_facileforms_elements 
  Where `type` <> 'Sofortueberweisung' 
  And `type` <> 'PayPal' 
  And `type` <> 'Static Text/HTML' 
  And `type` <> 'Rectangle' 
  And `type` <> 'Image' 
  And `type` <> 'Tooltip' 
  And `type` <> 'Query List' 
  And `type` <> 'Icon' 
  And `type` <> 'Graphic Button' 
  And `type` <> 'Regular Button' 
  And `type`<> 'Unknown' 
  And `type` <> 'Summarize' 
  And `type` <> 'ReCaptcha' 
  And form = 22 
  And published = 1 
  Order By `ordering`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:29
10	contentbuilder_com_breezingforms->__construct()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:998
9	contentbuilder::getForm()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:241
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select r.`id` 
                
  From 
                (
                    VCD_facileforms_records As r,
                    VCD_contentbuilder_forms As f
                )
                
  Left Join 
                (
                    VCD_contentbuilder_records As cr
                ) 
                
  On 
                (
                    r.form = '22' 
  And
                    f.`reference_id` = r.form 
  And
                    cr.`type` = 'com_breezingforms' 
  And
                    cr.`reference_id` = r.form 
  And
                    cr.record_id = r.id
                )
                
  Where
                f.`type` = 'com_breezingforms' 
  And
                f.`reference_id` = '22' 
  And
                r.form = f.`reference_id` 
  And
                cr.`record_id` Is Null

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f	NULL	ref	reference_id	reference_id	4	const	2	33.33	Using where
1	SIMPLE	r	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	10.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	cr	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	db715876307.r.id	1	100.00	Using where; Not exists

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:77
9	contentbuilder_com_breezingforms->synchRecords()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:243
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 5.82 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.004 MB mémoire avant requête : 14.356 MB

Update VCD_contentbuilder_records 
  Set published = 1 
  Where is_future = 1 
  And publish_up <> '0000-00-00 00:00:00' 
  And publish_up <= '2025-12-08 02:20:48'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	VCD_contentbuilder_records	NULL	index	NULL	PRIMARY	8	NULL	1772	100.00	Using where; Not exists

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:256
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 6.20 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.004 MB mémoire avant requête : 14.361 MB

Update VCD_contentbuilder_records 
  Set published = 0 
  Where publish_down <> '0000-00-00 00:00:00' 
  And publish_down <= '2025-12-08 02:20:48'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	VCD_contentbuilder_records	NULL	index	NULL	PRIMARY	8	NULL	1772	100.00	Using where; Not exists

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:259
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.52 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.004 MB mémoire avant requête : 14.366 MB

Update 
                        VCD_contentbuilder_records As records,
                        VCD_contentbuilder_forms As forms,
                        VCD_contentbuilder_registered_users As cbusers,
                        VCD_users As users
                    
  Set 
                        records.published = 0
                    
  Where
                        records.reference_id = forms.reference_id
                    
  And
                        records.published = 1
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                      (
                        (
                            users.id = cbusers.user_id
                          
  And
                            users.block = 1
                        )
                      )

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cbusers	NULL	index	user_id	user_id	16	NULL	1	100.00	Using index
1	UPDATE	records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	db715876307.cbusers.record_id	1	10.00	Using where
1	SIMPLE	forms	NULL	eq_ref	PRIMARY,reference_id	PRIMARY	4	db715876307.cbusers.form_id	1	33.33	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	db715876307.cbusers.user_id	1	11.76	Using where

Profil

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
updating main table	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.00 ms
Sending data	0.01 ms
updating reference tables	0.00 ms
end	0.01 ms
end	0.00 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:329
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.59 ms Après la dernière requête : 0.14 ms Mémoire de requête : 0.004 MB mémoire avant requête : 14.371 MB

Update 
                        VCD_contentbuilder_records As records,
                        VCD_contentbuilder_forms As forms,
                        VCD_contentbuilder_registered_users As cbusers,
                        VCD_users As users
                    
  Set 
                        records.published = forms.auto_publish
                    
  Where
                        records.reference_id = forms.reference_id
                    
  And
                        records.published = 0
                    
  And
                        records.`type` = forms.`type`
                    
  And
                        forms.act_as_registration = 1
                    
  And
                        forms.id = cbusers.form_id
                    
  And
                        records.record_id = cbusers.record_id
                    
  And
                        users.id = cbusers.user_id
                    
  And
                        users.block = 0

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cbusers	NULL	index	user_id	user_id	16	NULL	1	100.00	Using index
1	UPDATE	records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	db715876307.cbusers.record_id	1	10.00	Using where
1	SIMPLE	forms	NULL	eq_ref	PRIMARY,reference_id	PRIMARY	4	db715876307.cbusers.form_id	1	33.33	Using where
1	SIMPLE	users	NULL	eq_ref	PRIMARY,idx_block	PRIMARY	4	db715876307.cbusers.user_id	1	100.00	Using where

Profil

Status	Duration
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
updating main table	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.01 ms
updating reference tables	0.01 ms
end	0.01 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/plugins/system/contentbuilder_system/contentbuilder_system.php:356
8	plgSystemContentbuilder_system->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #44 #47 #51 #56

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:108
7	ContentbuilderControllerDetails->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #45 #48 #52 #57

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From VCD_facileforms_records 
  Where form = 22 
  And user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,contentbuilder_records.edited
            
  From 
                VCD_contentbuilder_forms As forms
                
  Left Join 
                    VCD_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
  Left Join 
                    VCD_contentbuilder_records As contentbuilder_records
                
  On ( contentbuilder_records.`type` = 'com_breezingforms' 
  And contentbuilder_records.reference_id = forms.reference_id 
  And contentbuilder_records.record_id = '1564' )
                
            
  Where 
                forms.id = 25
            
  And
                forms.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	contentbuilder_users	NULL	const	userid	userid	8	const,const	0	0.00	unique row not found
1	PRIMARY	contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	100.00	Using where
2	SUBQUERY	VCD_facileforms_records	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
9	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:108
7	ContentbuilderControllerDetails->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.29 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.020 MB mémoire avant requête : 14.785 MB Rangées retournées : 14

Requêtes dupliquées: #46 #49 #53 #58

Select id 
  From VCD_usergroups

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	14	100.00	Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
8	contentbuilder::setPermissions()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:108
7	ContentbuilderControllerDetails->__construct()	JROOT/components/com_contentbuilder/contentbuilder.php:167
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select SQL_CALC_FOUND_ROWS * 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1 
  LIMIT 0, 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_contentbuilder/models/details.php:169
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select Distinct `label`, reference_id 
  From VCD_contentbuilder_elements 
  Where form_id = 25 
  And reference_id In ('1993','1940','1994','1995','1996','1997','1948','1949','2031','2057','1999','2000','2001','2096','2101','1941') 
  And published = 1 
  Order By ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_contentbuilder_elements	NULL	range	reference_id,form_id	form_id	8	NULL	16	10.00	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
13	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/models/details.php:198
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #54

Select id, `title`, `name`, `type` 
  From
                VCD_facileforms_elements
                
  Where
                form = 22
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
13	contentbuilder_com_breezingforms->getRecord()	JROOT/administrator/components/com_contentbuilder/models/details.php:254
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '1940' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1940Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1941' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1941Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1948' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1948Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1949' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1949Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1993' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1993Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1994' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1994Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1995' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1995Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1996' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1996Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1997' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1997Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1999' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1999Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2000' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2000Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2001' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2001Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2031' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2031Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2057' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2057Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2096' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2096Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2101' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2101Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                VCD_facileforms_subrecords As s,
                VCD_facileforms_records As r
                 
  Left Join VCD_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '1564' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                 
  And joined_records.published = 1 
            
  And
                r.form = 22
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	5.00	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	7859	10.00	Using where; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.11 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.33 ms
preparing	1.68 ms
executing	0.01 ms
Sending data	8.12 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.14 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.00 ms
removing tmp table	0.04 ms
query end	0.00 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
13	contentbuilder_com_breezingforms->getRecord()	JROOT/administrator/components/com_contentbuilder/models/details.php:254
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From VCD_contentbuilder_forms 
  Where id = 25

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1080
13	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/models/details.php:396
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select `label`,`reference_id`,`options` 
  From VCD_contentbuilder_elements 
  Where form_id = 25

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_contentbuilder_elements	NULL	ref	form_id	form_id	4	const	16	100.00	NULL

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
14	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:1096
13	contentbuilder::getTemplate()	JROOT/administrator/components/com_contentbuilder/models/details.php:396
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select metakey, metadesc, author, robots, rights, xreference 
  From VCD_contentbuilder_records 
  Where `type` = 'com_breezingforms' 
  And reference_id = '22' 
  And record_id = '1564'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	5.00	Using index condition; Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:174
13	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/administrator/components/com_contentbuilder/models/details.php:404
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select * 
  From VCD_facileforms_records 
  Where id = 1564

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:193
13	contentbuilder_com_breezingforms->getRecordMetadata()	JROOT/administrator/components/com_contentbuilder/models/details.php:404
12	ContentbuilderModelDetails->getData()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:24
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select articles.`article_id` 
  From VCD_contentbuilder_articles As articles, VCD_content As content 
  Where content.id = articles.article_id 
  And (content.state = 1 Or content.state = 0) 
  And articles.form_id = 25 
  And articles.record_id = '1564'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	articles	NULL	ref	record_id,article_id,record_id_2	record_id	12	const,const	1	100.00	Using index condition
1	SIMPLE	content	NULL	eq_ref	PRIMARY,idx_state	PRIMARY	4	db715876307.articles.article_id	1	100.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:44
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 1.55 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.024 MB mémoire avant requête : 15.341 MB Rangées retournées : 31

SHOW FULL COLUMNS 
  FROM `VCD_content`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
12	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
11	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:46
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM VCD_content

  WHERE `id` = '397'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
11	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:60
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `VCD_categories` AS `s`

  INNER JOIN `VCD_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

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

  ORDER BY c.lft

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM VCD_fields AS a

  LEFT JOIN `VCD_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN VCD_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN VCD_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN VCD_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN VCD_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `VCD_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (35,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	3	28.36	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db715876307.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	db715876307.a.id	1	38.78	Using where; Using index; Distinct

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28 #47 #51 #56

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_download/contentbuilder_download.php:243
13	plgContentContentbuilder_download->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #29 #48 #52 #57

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From VCD_facileforms_records 
  Where form = 22 
  And user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,contentbuilder_records.edited
            
  From 
                VCD_contentbuilder_forms As forms
                
  Left Join 
                    VCD_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
  Left Join 
                    VCD_contentbuilder_records As contentbuilder_records
                
  On ( contentbuilder_records.`type` = 'com_breezingforms' 
  And contentbuilder_records.reference_id = forms.reference_id 
  And contentbuilder_records.record_id = '1564' )
                
            
  Where 
                forms.id = 25
            
  And
                forms.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	contentbuilder_users	NULL	const	userid	userid	8	const,const	0	0.00	unique row not found
1	PRIMARY	contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	100.00	Using where
2	SUBQUERY	VCD_facileforms_records	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_download/contentbuilder_download.php:243
13	plgContentContentbuilder_download->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.34 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.725 MB Rangées retournées : 14

Requêtes dupliquées: #30 #49 #53 #58

Select id 
  From VCD_usergroups

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	14	100.00	Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_download/contentbuilder_download.php:243
13	plgContentContentbuilder_download->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28 #44 #51 #56

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_image_scale/contentbuilder_image_scale.php:236
13	plgContentContentbuilder_image_scale->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #29 #45 #52 #57

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From VCD_facileforms_records 
  Where form = 22 
  And user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,contentbuilder_records.edited
            
  From 
                VCD_contentbuilder_forms As forms
                
  Left Join 
                    VCD_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
  Left Join 
                    VCD_contentbuilder_records As contentbuilder_records
                
  On ( contentbuilder_records.`type` = 'com_breezingforms' 
  And contentbuilder_records.reference_id = forms.reference_id 
  And contentbuilder_records.record_id = '1564' )
                
            
  Where 
                forms.id = 25
            
  And
                forms.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	contentbuilder_users	NULL	const	userid	userid	8	const,const	0	0.00	unique row not found
1	PRIMARY	contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	100.00	Using where
2	SUBQUERY	VCD_facileforms_records	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_image_scale/contentbuilder_image_scale.php:236
13	plgContentContentbuilder_image_scale->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.96 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.747 MB Rangées retournées : 14

Requêtes dupliquées: #30 #46 #53 #58

Select id 
  From VCD_usergroups

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	14	100.00	Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_image_scale/contentbuilder_image_scale.php:236
13	plgContentContentbuilder_image_scale->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From VCD_contentbuilder_articles As article, VCD_contentbuilder_forms As form 
  Where form.`published` = 1 
  And form.id = article.`form_id` 
  And article.`article_id` = '397'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	article	NULL	ref	article_id	article_id	4	const	1	100.00	NULL
1	SIMPLE	form	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.article.form_id	1	33.33	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:67
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28 #44 #47 #56

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:79
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #29 #45 #48 #57

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From VCD_facileforms_records 
  Where form = 22 
  And user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,contentbuilder_records.edited
            
  From 
                VCD_contentbuilder_forms As forms
                
  Left Join 
                    VCD_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
  Left Join 
                    VCD_contentbuilder_records As contentbuilder_records
                
  On ( contentbuilder_records.`type` = 'com_breezingforms' 
  And contentbuilder_records.reference_id = forms.reference_id 
  And contentbuilder_records.record_id = '1564' )
                
            
  Where 
                forms.id = 25
            
  And
                forms.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	contentbuilder_users	NULL	const	userid	userid	8	const,const	0	0.00	unique row not found
1	PRIMARY	contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	100.00	Using where
2	SUBQUERY	VCD_facileforms_records	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:79
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #30 #46 #49 #58

Select id 
  From VCD_usergroups

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	14	100.00	Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_permission_observer/contentbuilder_permission_observer.php:79
13	plgContentContentbuilder_permission_observer->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #33

Select id, `title`, `name`, `type` 
  From
                VCD_facileforms_elements
                
  Where
                form = 22
                
  And
                published = 1
                
  And
                `name` <> 'bfFakeName'
                
  And
                `name` <> 'bfFakeName2'
                
  And
                `name` <> 'bfFakeName3'
                
  And
                `name` <> 'bfFakeName4'
                
  And
                `name` <> 'bfFakeName5'
                
  And
                `name` <> 'bfFakeName6'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:245
14	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Select
                GROUP_CONCAT( ( 
  Case When s.`element` = '1940' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1940Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1941' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1941Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1948' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1948Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1949' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1949Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1993' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1993Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1994' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1994Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1995' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1995Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1996' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1996Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1997' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1997Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1999' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1999Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2000' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2000Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2001' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2001Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2031' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2031Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2057' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2057Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2096' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2096Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2101' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2101Value`,
                joined_records.rating_sum / joined_records.rating_count As colRating,
                joined_records.rating_count As colRatingCount,
                joined_records.rating_sum As colRatingSum
            
  From
                VCD_facileforms_subrecords As s,
                VCD_facileforms_records As r
                 
  Left Join VCD_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form ) 
                
            
  Where
                r.id = '1564' 
  And
                joined_records.`type` = 'com_breezingforms'
                
                 
  And ( joined_records.id is Null Or joined_records.id Is Not Null ) 
                
                
            
  And
                r.form = 22
            
  And
                s.record = r.id
            
  And
                r.archived = 0
            
  Group By s.record

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	joined_records	NULL	ref	PRIMARY,record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	5.00	Using index condition; Using where
1	SIMPLE	s	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	7859	10.00	Using where; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	1.38 ms
executing	0.01 ms
Sending data	7.05 ms
end	0.02 ms
query end	0.02 ms
removing tmp table	0.13 ms
query end	0.01 ms
removing tmp table	0.06 ms
query end	0.02 ms
removing tmp table	0.05 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.07 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.04 ms
query end	0.01 ms
removing tmp table	0.05 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/types/com_breezingforms.php:291
14	contentbuilder_com_breezingforms->getRecord()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:162
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #28 #44 #47 #51

Select `type`, `reference_id` 
  From VCD_contentbuilder_forms 
  Where id = 25 
  And published = 1

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2677
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:174
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #29 #45 #48 #52

Select 
                forms.config,
                forms.verification_required_view,
                forms.verification_required_new,
                forms.verification_required_edit,
                forms.verification_days_view,
                forms.verification_days_new,
                forms.verification_days_edit,
                forms.verification_url_view,
                forms.verification_url_new,
                forms.verification_url_edit,
                contentbuilder_users.userid,
                forms.limit_add,
                forms.limit_edit,
                (Select count(id) 
  From VCD_facileforms_records 
  Where form = 22 
  And user_id = 0)  As amount_records,
                contentbuilder_users.verified_view,
                contentbuilder_users.verified_new,
                contentbuilder_users.verified_edit,
                contentbuilder_users.verification_date_view,
                contentbuilder_users.verification_date_new,
                contentbuilder_users.verification_date_edit,
                contentbuilder_users.limit_add As user_limit_add,
                contentbuilder_users.limit_edit As user_limit_edit,
                contentbuilder_users.published
                ,contentbuilder_records.edited
            
  From 
                VCD_contentbuilder_forms As forms
                
  Left Join 
                    VCD_contentbuilder_users As contentbuilder_users
                
  On ( contentbuilder_users.form_id = forms.id 
  And contentbuilder_users.userid = 0 )
                
  Left Join 
                    VCD_contentbuilder_records As contentbuilder_records
                
  On ( contentbuilder_records.`type` = 'com_breezingforms' 
  And contentbuilder_records.reference_id = forms.reference_id 
  And contentbuilder_records.record_id = '1564' )
                
            
  Where 
                forms.id = 25
            
  And
                forms.published = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	forms	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	contentbuilder_users	NULL	const	userid	userid	8	const,const	0	0.00	unique row not found
1	PRIMARY	contentbuilder_records	NULL	ref	record_id,reference_id,type,type_2,type_3,type_4,type_5,type_6,type_7	record_id	8	const	1	100.00	Using where
2	SUBQUERY	VCD_facileforms_records	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1778	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:2759
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:174
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.27 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 17.824 MB Rangées retournées : 14

Requêtes dupliquées: #30 #46 #49 #53

Select id 
  From VCD_usergroups

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_usergroups	NULL	index	NULL	idx_usergroup_adjacency_lookup	4	NULL	14	100.00	Using index

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_contentbuilder/classes/contentbuilder.php:3146
14	contentbuilder::setPermissions()	JROOT/plugins/content/contentbuilder_rating/contentbuilder_rating.php:174
13	plgContentContentbuilder_rating->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT `alias`

  FROM `VCD_content`

  WHERE id = '397'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
26	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
25	ContentRouter->getArticleSegment()	Même appel que celui de la ligne ci-dessous.
24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:317
15	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:110
14	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:52
13	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT alias

  FROM VCD_content

  WHERE id=397

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
24	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
23	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
22	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/plugins/content/addtoany/addtoany.php:317
15	plgContentAddToAny->getArticleUrl()	JROOT/plugins/content/addtoany/addtoany.php:110
14	plgContentAddToAny->createAddToAny()	JROOT/plugins/content/addtoany/addtoany.php:52
13	plgContentAddToAny->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/administrator/components/com_contentbuilder/views/details/view.html.php:92
10	ContentbuilderViewDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/administrator/components/com_contentbuilder/controllers/details.php:123
8	ContentbuilderControllerDetails->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_contentbuilder/contentbuilder.php:170
6	require_once JROOT/components/com_contentbuilder/contentbuilder.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT language,id

  FROM `VCD_menu`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	VCD_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	134	1.00	Using where

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 2.96 ms Après la dernière requête : 22.10 ms Mémoire de requête : 0.258 MB mémoire avant requête : 20.052 MB Rangées retournées : 20

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

  FROM VCD_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-08 02:20:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-08 02:20:48') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 278 OR mm.menuid <= 0) 
  AND m.language IN ('fr-FR','*')

  ORDER BY m.position, m.ordering

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:994
11	HelixUltimate\Framework\Core\HelixUltimate->count_modules()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:728
10	HelixUltimate\Framework\Core\HelixUltimate->get_current_row()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:630
9	HelixUltimate\Framework\Core\HelixUltimate->get_recursive_layout()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:596
8	HelixUltimate\Framework\Core\HelixUltimate->render_layout()	JROOT/templates/h4/index.php:153
7	require JROOT/templates/h4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.91 ms Après la dernière requête : 5.18 ms Mémoire de requête : 0.029 MB mémoire avant requête : 20.482 MB Rangées retournées : 175

Requêtes dupliquées: #8 #16 #18 #64 #67

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomclassifieds/etc/utils.php:110
22	JomclUtils::getCfg()	JROOT/components/com_jomclassifieds/router.php:72
21	JomClassifiedsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
13	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
12	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
11	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php:65
10	include JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php	JROOT/libraries/src/Layout/FileLayout.php:125
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1634
8	HelixUltimate\Framework\Core\HelixUltimate->getOffcanvasStyle()	JROOT/templates/h4/index.php:163
7	require JROOT/templates/h4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.58 ms Mémoire de requête : 0.029 MB mémoire avant requête : 20.504 MB Rangées retournées : 175

Requêtes dupliquées: #8 #16 #18 #63 #67

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomclassifieds/etc/utils.php:110
22	JomclUtils::getCfg()	JROOT/components/com_jomclassifieds/router.php:72
21	JomClassifiedsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
13	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
12	include JROOT/modules/mod_menu/mod_menu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
11	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php:65
10	include JROOT/templates/h4/offcanvas/3-CenterAlign/canvas.php	JROOT/libraries/src/Layout/FileLayout.php:125
9	Joomla\CMS\Layout\FileLayout->render()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1634
8	HelixUltimate\Framework\Core\HelixUltimate->getOffcanvasStyle()	JROOT/templates/h4/index.php:163
7	require JROOT/templates/h4/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT params

  FROM VCD_extensions

  WHERE `type` = 'plugin' 
  AND `element` = 'jlsitemap_cron' 
  AND `folder` = 'system'

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:197
8	PlgSystemJLSitemap_Cron->checkCacheTime()	JROOT/plugins/system/jlsitemap_cron/jlsitemap_cron.php:52
7	PlgSystemJLSitemap_Cron->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM VCD_fields AS a

  LEFT JOIN `VCD_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN VCD_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN VCD_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN VCD_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN VCD_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_context	766	const	1	8.51	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	db715876307.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	db715876307.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	1.42 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.14 ms
System lock	0.03 ms
optimizing	0.06 ms
statistics	0.33 ms
preparing	0.10 ms
Creating tmp table	0.15 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.55 ms
Creating sort index	0.06 ms
end	0.01 ms
query end	0.03 ms
removing tmp table	0.15 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.11 ms
cleaning up	0.04 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/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Même appel que celui de la ligne ci-dessous.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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 : 2.30 ms Mémoire de requête : 0.028 MB mémoire avant requête : 20.757 MB Rangées retournées : 175

Requêtes dupliquées: #8 #16 #18 #63 #64

SELECT name,value 
  FROM VCD_jomcl_options

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jomclassifieds/etc/utils.php:110
20	JomclUtils::getCfg()	JROOT/components/com_jomclassifieds/router.php:72
19	JomClassifiedsBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
18	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
17	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
16	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_breadcrumbs/helper.php:61
11	ModBreadCrumbsHelper::getList()	JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16
10	include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 7.31 ms Après la dernière requête : 7.04 ms Mémoire de requête : 0.003 MB mémoire avant requête : 20.924 MB

DELETE 

  FROM `VCD_session`

  WHERE `time` < 1765156848

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	VCD_session	NULL	range	time	time	4	const	34	100.00	Using where

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.08 ms
updating	1.48 ms
end	0.05 ms
query end	4.17 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:150
6	Joomla\CMS\Session\MetadataManager->deletePriorTo()	JROOT/plugins/system/sessiongc/sessiongc.php:74
5	PlgSystemSessionGc->onAfterRespond()	JROOT/libraries/joomla/event/event.php:70
4	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
3	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
2	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:247
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]

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

Tables sélectionnées :

6 × SELECT name,value 
  FROM VCD_jomcl_option

6 × Select `type`, `reference_id` 
  From VCD_contentbuilder_forms

5 × Select                  forms.config,                 forms.verification_required_view,                 forms.verification_required_new,                 forms.verification_required_edit,                 forms.verification_days_view,                 forms.verification_days_new,                 forms.verification_days_edit,                 forms.verification_url_view,                 forms.verification_url_new,                 forms.verification_url_edit,                 contentbuilder_users.userid,                 forms.limit_add,                 forms.limit_edit,                 (Select count(id) 
  From VCD_facileforms_records

```
5 × Select id 
  From VCD_usergroup
```

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

2 × Select id, `title`, `name`, `type` 
  From                 VCD_facileforms_elements

2 × Select                 GROUP_CONCAT( ( 
  Case When s.`element` = '1940' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1940Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1941' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1941Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1948' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1948Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1949' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1949Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1993' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1993Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1994' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1994Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1995' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1995Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1996' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1996Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1997' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1997Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '1999' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col1999Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2000' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2000Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2001' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2001Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2031' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2031Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2057' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2057Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2096' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2096Value`,GROUP_CONCAT( ( 
  Case When s.`element` = '2101' Then s.`value` End ) 
  Order By s.`id` SEPARATOR ', ' ) As `col2101Value`,                 joined_records.rating_sum / joined_records.rating_count As colRating,                 joined_records.rating_count As colRatingCount,                 joined_records.rating_sum As colRatingSum             
  From                 VCD_facileforms_subrecords As s,                 VCD_facileforms_records As r                  
  Left Join VCD_contentbuilder_records As joined_records 
  On ( joined_records.`type` = 'com_breezingforms' 
  And joined_records.record_id = r.id 
  And joined_records.reference_id = r.form )

1 × SELECT id, rules 
  FROM `VCD_viewlevels

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

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

1 × SELECT * 
  FROM `VCD_nextend2_section_storage`

```
1 × SELECT * 
  FROM VCD_languages
```

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `VCD_extensions`

1 × Select                      form.id As form_id,                     form.act_as_registration,                     form.default_category,                     form.registration_name_field,                      form.registration_username_field,                      form.registration_email_field,                      form.registration_email_repeat_field,                      form.`last_update`,                     article.`article_id`,                     form.`title_field`,                     form.`create_articles`,                     form.`name`,                     form.`use_view_name_as_title`,                     form.`protect_upload_directory`,                     form.`reference_id`,                     records.`record_id`,                     form.`type`,                     form.`published_only`,                     form.`own_only`,                     form.`own_only_fe`,                     records.`last_update` As record_last_update,                     article.`last_update` As article_last_update                 
  From                     VCD_contentbuilder_records As records                     
  Left Join VCD_contentbuilder_forms As form 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id )                     
  Left Join VCD_contentbuilder_articles As article 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )                     
  Left Join VCD_content As content 
  On ( form.`type` = records.`type` 
  And form.reference_id = records.reference_id 
  And article.article_id = content.id 
  And article.form_id = form.id 
  And article.record_id = records.record_id )

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

1 × SELECT * 
  FROM `VCD_template_styles`

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

1 × Select * 
  From VCD_facileforms_forms

1 × Select * 
  From VCD_facileforms_elements

1 × Select r.`id`                  
  From                  (                     VCD_facileforms_records As r,                     VCD_contentbuilder_forms As f                 )                 
  Left Join                  (                     VCD_contentbuilder_records As cr                 )                  
  On                  (                     r.form = '22' 
  And                     f.`reference_id` = r.form 
  And                     cr.`type` = 'com_breezingforms' 
  And                     cr.`reference_id` = r.form 
  And                     cr.record_id = r.id                 )

1 × Select SQL_CALC_FOUND_ROWS * 
  From VCD_contentbuilder_forms

1 × Select Distinct `label`, reference_id 
  From VCD_contentbuilder_elements

1 × Select `type`,reference_id,details_template, details_prepare, edit_by_type, act_as_registration, registration_name_field, registration_username_field, registration_email_field, registration_email_repeat_field, registration_password_field, registration_password_repeat_field 
  From VCD_contentbuilder_forms

1 × Select `label`,`reference_id`,`options` 
  From VCD_contentbuilder_elements

1 × Select metakey, metadesc, author, robots, rights, xreference 
  From VCD_contentbuilder_records

1 × Select * 
  From VCD_facileforms_records

1 × Select articles.`article_id` 
  From VCD_contentbuilder_articles As articles, VCD_content As content

```
1 × SELECT * 
  FROM VCD_content
```

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `VCD_categories` AS `s` 
  INNER JOIN `VCD_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('fr-FR','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM VCD_fields AS a 
  LEFT JOIN `VCD_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN VCD_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN VCD_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN VCD_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN VCD_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `VCD_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × Select form.`reference_id`,article.`record_id`,article.`form_id`,form.`type`,form.`published_only`,form.`own_only`,form.`own_only_fe` 
  From VCD_contentbuilder_articles As article, VCD_contentbuilder_forms As form

1 × SELECT `alias` 
  FROM `VCD_content`

```
1 × SELECT alias 
  FROM VCD_content
```

1 × SELECT language,id 
  FROM `VCD_menu`

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

1 × SELECT params 
  FROM VCD_extensions

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM VCD_fields AS a 
  LEFT JOIN `VCD_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN VCD_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN VCD_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN VCD_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN VCD_fields_groups AS g 
  ON g.id = a.group_id

Autres tables :

1 × UPDATE `VCD_extensions` 
  SET `params` = '{\"mediaversion\":\"b5143f0d6b224c9e5979f720c9e4bb04\"}'

1 × Update                         VCD_contentbuilder_articles As articles,                         VCD_content As content,                          VCD_contentbuilder_forms As forms,                         VCD_contentbuilder_registered_users As cbusers,                         VCD_users As users                     
  Set                          content.state = 0

1 × Update                          VCD_contentbuilder_articles As articles,                         VCD_content As content,                          VCD_contentbuilder_forms As forms,                         VCD_contentbuilder_records As records,                         VCD_contentbuilder_registered_users As cbusers,                         VCD_users As users                     
  Set                          content.state = forms.auto_publish

1 × 
  SET SESSION group_concat_max_len = 999999

1 × Update VCD_contentbuilder_records 
  Set published = 1

1 × Update VCD_contentbuilder_records 
  Set published = 0

1 × Update                          VCD_contentbuilder_records As records,                         VCD_contentbuilder_forms As forms,                         VCD_contentbuilder_registered_users As cbusers,                         VCD_users As users                     
  Set                          records.published = 0

1 × Update                          VCD_contentbuilder_records As records,                         VCD_contentbuilder_forms As forms,                         VCD_contentbuilder_registered_users As cbusers,                         VCD_users As users                     
  Set                          records.published = forms.auto_publish

1 × SHOW FULL COLUMNS 
  FROM `VCD_content

```
1 × DELETE  
  FROM `VCD_session`
```