Laboccf

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1701331393,
                "last": 1701331393,
                "now": 1701331393
            },
            "token": "KhpcwxEmTMtnCwyQRTM44wMLC5zmRXpX"
        },
        "registry": {
            "com_communitysurveys": {
                "response": {
                    "0": {
                        "id": "6",
                        "title": "Enqu\u00eate de satisfaction pr\u00e9leveur",
                        "alias": "enquete-de-satisfaction-preleveur",
                        "description": "",
                        "endtext": "",
                        "custom_header": "<p>Enqu\u00eate de satisfaction PRELEVEUR</p>\r\n<p>Afin de comprendre et d\u2019am\u00e9liorer la prise en compte de vos attentes, nous vous invitons \u00e0 renseigner ce questionnaire. Et nous vous remercions de votre implication dans notre d\u00e9marche qualit\u00e9.</p>",
                        "responses": "6",
                        "metakey": "",
                        "metadesc": "",
                        "access": "1",
                        "metadata": {
                            "robots": "",
                            "author": "",
                            "rights": ""
                        },
                        "language": "fr",
                        "ip_address": "82.234.243.112",
                        "published": "1",
                        "private": "0",
                        "max_responses": "0",
                        "survey_key": "N3NBD6AjPfCO6dK4",
                        "redirect_url": "",
                        "restrictions": "",
                        "state": "1",
                        "catid": "100",
                        "created": "2017-08-24 14:20:56",
                        "created_by": "52",
                        "modified": "2017-08-24 14:20:56",
                        "modified_by": "0",
                        "checked_out": "0",
                        "checked_out_time": "0000-00-00 00:00:00",
                        "publish_up": "2017-05-07 21:36:48",
                        "publish_down": "0000-00-00 00:00:00",
                        "attribs": "{\"ui_layout\":\"\",\"points\":\"0\",\"send_notifications\":\"\",\"attach_pdf_report\":\"\",\"anonymous\":\"\",\"enable_captcha\":\"1\",\"show_confidentiality\":\"\",\"show_intro\":\"0\",\"show_template\":\"\",\"show_report\":\"\",\"show_notice\":\"\",\"show_jumptopage\":\"\",\"show_pagination\":\"\",\"show_save_button\":\"\",\"show_prev_button\":\"\",\"show_cancel_button\":\"\",\"show_title\":\"\",\"link_titles\":\"\",\"show_tags\":\"\",\"info_block_position\":\"\",\"social_sharing\":\"0\",\"show_category\":\"0\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"0\",\"link_author\":\"\",\"show_create_date\":\"0\",\"show_modify_date\":\"0\",\"show_publish_date\":\"0\",\"show_item_navigation\":\"\",\"show_hits\":\"0\",\"show_noauth\":\"\",\"survey_layout\":\"\",\"show_publishing_options\":\"\",\"show_survey_options\":\"\"}",
                        "ordering": "0",
                        "category_title": "Enqu\u00eate satisfaction",
                        "category_alias": "enquete-satisfaction",
                        "category_access": "1",
                        "author": "Fran\u00e7oise LONG",
                        "author_email": "long@selarlccf.com",
                        "parent_title": "ROOT",
                        "parent_id": "1",
                        "parent_route": "",
                        "parent_alias": "root",
                        "params": {
                            "survey_layout": "_:default",
                            "theme": "info",
                            "survey_avatar_size": "40",
                            "hide_template": "0",
                            "anonymous": "0",
                            "enable_captcha": "1",
                            "send_notifications": "1",
                            "show_confidentiality": "0",
                            "show_intro": "0",
                            "show_template": "1",
                            "show_report": "0",
                            "show_jumptopage": "0",
                            "show_pagination": "1",
                            "show_save_button": "1",
                            "show_prev_button": "1",
                            "show_cancel_button": "1",
                            "show_notice": "1",
                            "attach_pdf_report": "0",
                            "show_title": "1",
                            "link_titles": "1",
                            "show_category": "0",
                            "link_category": "0",
                            "show_parent_category": "1",
                            "link_parent_category": "1",
                            "show_author": "0",
                            "link_author": "1",
                            "show_create_date": "0",
                            "show_modify_date": "0",
                            "show_publish_date": "0",
                            "show_tags": "1",
                            "show_hits": "0",
                            "social_sharing": "0",
                            "show_publishing_options": "1",
                            "show_survey_options": "1",
                            "category_layout": "_:default",
                            "show_category_heading_title_text": "0",
                            "show_category_title": "0",
                            "show_description": "1",
                            "show_description_image": "1",
                            "show_subcategory_content": "0",
                            "maxLevel": "-1",
                            "show_empty_categories": "0",
                            "show_no_surveys": "1",
                            "show_subcat_desc": "0",
                            "show_cat_num_surveys": "0",
                            "show_base_description": "0",
                            "maxLevelcat": "-1",
                            "show_empty_categories_cat": "0",
                            "show_subcat_desc_cat": "0",
                            "show_cat_num_surveys_cat": "0",
                            "list_avatar_size": "40",
                            "filter_field": "hide",
                            "date_format": "",
                            "list_description_limit": "180",
                            "list_show_date": "1",
                            "list_show_description": "1",
                            "list_show_avatar": "1",
                            "list_show_hits": "1",
                            "list_show_parent": "1",
                            "list_show_author": "1",
                            "list_show_category_list": "1",
                            "list_show_search_form": "1",
                            "allowed_uploadfile_types": "jpg,png,gif,zip,gz,tar,doc,docx,xls,xlsx,ppt,pptx,txt",
                            "max_attachment_size": "2048",
                            "cookie_lifetime": "260000",
                            "chart_colors": "#3366CC,#DC3912,#FF9900,#109618,#0099C6,#DD4477,#66AA00,#AAAA11,#994499,#E67300",
                            "pdf_fontname": "freesans",
                            "orderby_pri": "none",
                            "orderby_sec": "rdate",
                            "order_date": "published",
                            "user_display_name": "name",
                            "skip_email_queue": "1",
                            "show_pagination_results": "1",
                            "show_toolbar": "0",
                            "show_feed_link": "1",
                            "feed_summary": "0",
                            "feed_show_readmore": "0",
                            "load_bootstrap_css": "0",
                            "debug_mode": "0",
                            "ui_layout": "default",
                            "default_editor": "tinymce",
                            "profile_component": "none",
                            "avatar_component": "gravatar",
                            "points_component": "none",
                            "stream_component": "none",
                            "points": "0",
                            "access-view": true
                        },
                        "isEditorLoaded": false,
                        "sheets_integrated": false,
                        "key": null,
                        "response_id": 0,
                        "curr_page": 0
                    }
                }
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 13.48 ms / 13.48 ms Mémoire: 0.414 MB / 0.75 MB Application: afterLoad

Temps: 39.96 ms / 53.44 ms Mémoire: 0.829 MB / 1.58 MB Application: afterInitialise

Temps: 14.53 ms / 67.97 ms Mémoire: 0.437 MB / 2.01 MB Application: afterRoute

Temps: 6.60 ms / 74.57 ms Mémoire: 0.062 MB / 2.07 MB Application: beforeRenderComponent com_communitysurveys

Temps: 42.02 ms / 116.59 ms Mémoire: 0.478 MB / 2.55 MB Application: Before Access::preloadComponents (all components)

Temps: 0.96 ms / 117.54 ms Mémoire: 0.058 MB / 2.61 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 117.58 ms Mémoire: -0.003 MB / 2.61 MB Application: Before Access::getAssetRules (id:375 name:com_communitysurveys)

Temps: 0.76 ms / 118.33 ms Mémoire: 0.011 MB / 2.62 MB Application: After Access::getAssetRules (id:375 name:com_communitysurveys)

Temps: 8.26 ms / 126.60 ms Mémoire: 0.201 MB / 2.82 MB Application: Before Access::preloadPermissions (com_communitysurveys)

Temps: 0.74 ms / 127.33 ms Mémoire: 0.020 MB / 2.84 MB Application: After Access::preloadPermissions (com_communitysurveys)

Temps: 0.02 ms / 127.36 ms Mémoire: -0.000 MB / 2.84 MB Application: Before Access::getAssetRules (id:415 name:com_communitysurveys.survey.6)

Temps: 0.04 ms / 127.40 ms Mémoire: 0.008 MB / 2.85 MB Application: After Access::getAssetRules (id:415 name:com_communitysurveys.survey.6)

Temps: 38.98 ms / 166.38 ms Mémoire: 0.494 MB / 3.34 MB Application: afterRenderComponent com_communitysurveys

Temps: 2.35 ms / 168.73 ms Mémoire: 0.007 MB / 3.35 MB Application: afterDispatch

Temps: 8.16 ms / 176.89 ms Mémoire: 0.124 MB / 3.47 MB Application: beforeRenderModule mod_menu (Informations)

Temps: 3.20 ms / 180.09 ms Mémoire: 0.059 MB / 3.53 MB Application: afterRenderRawModule mod_menu (Informations)

Temps: 0.01 ms / 180.10 ms Mémoire: -0.001 MB / 3.53 MB Application: beforeRenderModule mod_menu (Informations)

Temps: 1.07 ms / 181.17 ms Mémoire: 0.004 MB / 3.53 MB Application: afterRenderModule mod_menu (Informations)

Temps: 0.04 ms / 181.21 ms Mémoire: -0.002 MB / 3.53 MB Application: beforeRenderModule mod_custom (Footer Info)

Temps: 0.98 ms / 182.18 ms Mémoire: 0.004 MB / 3.53 MB Application: afterRenderRawModule mod_custom (Footer Info)

Temps: 0.01 ms / 182.19 ms Mémoire: -0.000 MB / 3.53 MB Application: beforeRenderModule mod_custom (Footer Info)

Temps: 0.80 ms / 182.99 ms Mémoire: 0.002 MB / 3.54 MB Application: afterRenderModule mod_custom (Footer Info)

Temps: 0.04 ms / 183.02 ms Mémoire: 0.002 MB / 3.54 MB Application: beforeRenderModule mod_jamasshead (JA Masthead)

Temps: 2.12 ms / 185.14 ms Mémoire: 0.008 MB / 3.55 MB Application: afterRenderRawModule mod_jamasshead (JA Masthead)

Temps: 0.01 ms / 185.15 ms Mémoire: -0.001 MB / 3.55 MB Application: beforeRenderModule mod_jamasshead (JA Masthead)

Temps: 0.76 ms / 185.91 ms Mémoire: 0.002 MB / 3.55 MB Application: afterRenderModule mod_jamasshead (JA Masthead)

Temps: 0.03 ms / 185.94 ms Mémoire: -0.002 MB / 3.55 MB Application: beforeRenderModule mod_custom (Nous transmettre des documents)

Temps: 0.60 ms / 186.54 ms Mémoire: 0.001 MB / 3.55 MB Application: afterRenderRawModule mod_custom (Nous transmettre des documents)

Temps: 0.00 ms / 186.54 ms Mémoire: 0.001 MB / 3.55 MB Application: beforeRenderModule mod_custom (Nous transmettre des documents)

Temps: 0.79 ms / 187.33 ms Mémoire: 0.002 MB / 3.55 MB Application: afterRenderModule mod_custom (Nous transmettre des documents)

Temps: 0.03 ms / 187.36 ms Mémoire: 0.000 MB / 3.55 MB Application: beforeRenderModule mod_custom (Résultats Patients)

Temps: 0.54 ms / 187.90 ms Mémoire: 0.001 MB / 3.55 MB Application: afterRenderRawModule mod_custom (Résultats Patients)

Temps: 0.00 ms / 187.90 ms Mémoire: 0.001 MB / 3.55 MB Application: beforeRenderModule mod_custom (Résultats Patients)

Temps: 0.77 ms / 188.68 ms Mémoire: 0.005 MB / 3.56 MB Application: afterRenderModule mod_custom (Résultats Patients)

Temps: 0.03 ms / 188.70 ms Mémoire: 0.000 MB / 3.56 MB Application: beforeRenderModule mod_menu (Off Canvas)

Temps: 12.93 ms / 201.63 ms Mémoire: 0.084 MB / 3.64 MB Application: afterRenderRawModule mod_menu (Off Canvas)

Temps: 0.01 ms / 201.64 ms Mémoire: -0.002 MB / 3.64 MB Application: beforeRenderModule mod_menu (Off Canvas)

Temps: 0.90 ms / 202.54 ms Mémoire: 0.002 MB / 3.64 MB Application: afterRenderModule mod_menu (Off Canvas)

Temps: 19.77 ms / 222.31 ms Mémoire: 0.144 MB / 3.79 MB Application: afterRender

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

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

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

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

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

EXPLAIN impossible sur la requête : INSERT INTO `db57y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'71666f3667636473357039686338336a32726273307262616537', 1, 1701331393, 0, '', 0)

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.01 ms
Update	0.26 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	3.22 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.00 ms

Pile d'appels

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

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

Temps de requête : 1.87 ms Après la dernière requête : 2.37 ms Mémoire de requête : 0.040 MB mémoire avant requête : 1.083 MB Rangées retournées : 38

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

  FROM `db57y_extensions`

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

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.16 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	1.27 ms
Reset for next command	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.27 ms Après la dernière requête : 1.87 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.118 MB Rangées retournées : 4

SELECT id, rules

  FROM `db57y_viewlevels`

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.26 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.021 MB mémoire avant requête : 1.130 MB Rangées retournées : 1

SELECT b.id

  FROM db57y_usergroups AS a

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

  WHERE a.id = 1

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	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 : 0.48 ms Après la dernière requête : 0.20 ms Mémoire de requête : 0.030 MB mémoire avant requête : 1.151 MB Rangées retournées : 85

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

  FROM db57y_extensions

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

  ORDER BY ordering

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.24 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.03 ms
Reset for next command	0.00 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.73 ms Après la dernière requête : 16.08 ms Mémoire de requête : 0.068 MB mémoire avant requête : 1.602 MB Rangées retournées : 38

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

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

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

  ORDER BY m.lft

Explication

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

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.34 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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.66 ms Après la dernière requête : 7.40 ms Mémoire de requête : 0.038 MB mémoire avant requête : 1.907 MB Rangées retournées : 15

SELECT id, home, template, s.params

  FROM db57y_template_styles as s

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

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	7	Using index condition; Using where
1	SIMPLE	s	ref\|filter	idx_template,idx_client_id,idx_client_id_home	idx_template\|idx_client_id	152\|1	laboccf.e.element	1 (88%)	Using index condition; Using where; Using rowid filter

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	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/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
8	plgSystemT3->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.50 ms Après la dernière requête : 3.96 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.030 MB Rangées retournées : 1

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

  FROM `db57y_extensions`

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

Explication

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

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

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

UPDATE `db57y_extensions`

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

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.00 ms
init for update	0.06 ms
Updating	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.32 ms Après la dernière requête : 1.54 ms Mémoire de requête : 0.019 MB mémoire avant requête : 2.050 MB Rangées retournées : 1

SELECT *

  FROM db57y_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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 : 45.56 ms Mémoire de requête : 0.029 MB mémoire avant requête : 2.556 MB Rangées retournées : 38

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

  FROM `db57y_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_cjlib','com_communityanswers','com_communitysurveys','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

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

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.00 ms
Sending data	0.17 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 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/libraries/src/Access/Access.php:429
20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
16	Joomla\CMS\User\User->authorise()	JROOT/components/com_communitysurveys/models/survey.php:30
15	CommunitySurveysModelSurvey->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_communitysurveys/models/survey.php:329
13	CommunitySurveysModelSurvey->getUser()	JROOT/components/com_communitysurveys/models/survey.php:41
12	CommunitySurveysModelSurvey->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_communitysurveys/views/survey/view.html.php:24
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.79 ms Après la dernière requête : 1.71 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.624 MB Rangées retournées : 1

Requêtes dupliquées: #19

SELECT a.id, a.title, a.alias, a.description, a.endtext, a.custom_header, a.responses, a.metakey, a.metadesc, a.access, a.metadata,a.language, a.ip_address, a.published, a.private, a.max_responses, a.survey_key, a.redirect_url, a.restrictions,
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.ordering,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM db57y_survey_surveys AS a

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

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

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

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

  WHERE a.id = 6 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 08:03:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 08:03:13') 
  AND (a.published = 1 OR a.published =2)

Explication

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

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.03 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Statistics	0.08 ms
Preparing	0.02 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
Creating sort index	0.02 ms
Removing tmp table	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_communitysurveys/models/survey.php:124
12	CommunitySurveysModelSurvey->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_communitysurveys/views/survey/view.html.php:24
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.26 ms Après la dernière requête : 1.67 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.667 MB Rangées retournées : 0

Requêtes dupliquées: #20 #23 #25 #29

SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published

  FROM db57y_survey_translations a

  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

  WHERE l.survey_id = 6 
  AND l.sef = 'fr' 
  AND a.published = 1 
  AND l.published = 1

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/language.php:175
13	CommunitySurveysModelLanguage->getSurveyTranslations()	JROOT/components/com_communitysurveys/models/survey.php:237
12	CommunitySurveysModelSurvey->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_communitysurveys/views/survey/view.html.php:24
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.19 ms Après la dernière requête : 0.06 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.668 MB Rangées retournées : 1

Requêtes dupliquées: #21

SELECT count(*)

  FROM db57y_survey_questions

  WHERE id = 6 
  and question_type = 10

Explication

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

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_communitysurveys/models/survey.php:279
12	CommunitySurveysModelSurvey->getItem()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:425
11	Joomla\CMS\MVC\View\_JHtmlView->get()	JROOT/components/com_communitysurveys/views/survey/view.html.php:24
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.64 ms Après la dernière requête : 2.68 ms Mémoire de requête : 0.024 MB mémoire avant requête : 2.734 MB Rangées retournées : 2

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

  FROM `db57y_categories` AS `s`

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

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

  ORDER BY c.lft

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	157	NULL	3	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
13	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
12	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_communitysurveys/helpers/route.php:26
11	CommunitySurveysHelperRoute::getSurveyRoute()	JROOT/components/com_communitysurveys/views/survey/view.html.php:67
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.60 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.025 MB mémoire avant requête : 2.818 MB Rangées retournées : 15

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

  FROM `db57y_assets`

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

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.27 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.04 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
15	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
11	Joomla\CMS\User\User->authorise()	JROOT/components/com_communitysurveys/views/survey/view.html.php:142
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.80 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.873 MB Rangées retournées : 1

Requêtes dupliquées: #14

SELECT a.id, a.title, a.alias, a.description, a.endtext, a.custom_header, a.responses, a.metakey, a.metadesc, a.access, a.metadata,a.language, a.ip_address, a.published, a.private, a.max_responses, a.survey_key, a.redirect_url, a.restrictions,
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.ordering,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM db57y_survey_surveys AS a

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

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

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

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

  WHERE a.id = 6 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-11-30 08:03:13') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-11-30 08:03:13') 
  AND (a.published = 1 OR a.published =2)

Explication

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

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.07 ms
Optimizing	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.01 ms
Sorting result	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
Creating sort index	0.01 ms
Removing tmp table	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Removing tmp table	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_communitysurveys/models/survey.php:124
12	CommunitySurveysModelSurvey->getItem()	JROOT/components/com_communitysurveys/models/response.php:176
11	CommunitySurveysModelResponse->createOrUpdateResponse()	JROOT/components/com_communitysurveys/views/survey/view.html.php:164
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #15 #23 #25 #29

SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published

  FROM db57y_survey_translations a

  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

  WHERE l.survey_id = 6 
  AND l.sef = 'fr' 
  AND a.published = 1 
  AND l.published = 1

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/language.php:175
13	CommunitySurveysModelLanguage->getSurveyTranslations()	JROOT/components/com_communitysurveys/models/survey.php:237
12	CommunitySurveysModelSurvey->getItem()	JROOT/components/com_communitysurveys/models/response.php:176
11	CommunitySurveysModelResponse->createOrUpdateResponse()	JROOT/components/com_communitysurveys/views/survey/view.html.php:164
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #16

SELECT count(*)

  FROM db57y_survey_questions

  WHERE id = 6 
  and question_type = 10

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.00 ms
Executing	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/components/com_communitysurveys/models/survey.php:279
12	CommunitySurveysModelSurvey->getItem()	JROOT/components/com_communitysurveys/models/response.php:176
11	CommunitySurveysModelResponse->createOrUpdateResponse()	JROOT/components/com_communitysurveys/views/survey/view.html.php:164
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.16 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.904 MB Rangées retournées : 1

Requêtes dupliquées: #24

SELECT id, title, sort_order

  FROM db57y_survey_pages

  WHERE sid = 6

  ORDER BY sort_order ASC, id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	db57y_survey_pages	ref	idx_survey_sid	idx_survey_sid	4	const	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_communitysurveys/helpers/pagination.php:119
13	SurveyPagination->build()	JROOT/components/com_communitysurveys/helpers/pagination.php:39
12	SurveyPagination->__construct()	JROOT/components/com_communitysurveys/models/response.php:1310
11	CommunitySurveysModelResponse->getPagination()	JROOT/components/com_communitysurveys/views/survey/view.html.php:166
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.10 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.916 MB Rangées retournées : 0

Requêtes dupliquées: #15 #20 #25 #29

SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published

  FROM db57y_survey_translations a

  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

  WHERE l.survey_id = 6 
  AND l.sef = 'fr' 
  AND a.published = 1 
  AND l.published = 1

Explication

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

Profil

Status	Duration
Starting	0.05 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/language.php:175
14	CommunitySurveysModelLanguage->getSurveyTranslations()	JROOT/components/com_communitysurveys/helpers/pagination.php:136
13	SurveyPagination->build()	JROOT/components/com_communitysurveys/helpers/pagination.php:39
12	SurveyPagination->__construct()	JROOT/components/com_communitysurveys/models/response.php:1310
11	CommunitySurveysModelResponse->getPagination()	JROOT/components/com_communitysurveys/views/survey/view.html.php:166
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.21 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.022 MB mémoire avant requête : 2.921 MB Rangées retournées : 1

Requêtes dupliquées: #22

SELECT id, title, sort_order

  FROM db57y_survey_pages

  WHERE sid = 6

  ORDER BY sort_order ASC, id ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	db57y_survey_pages	ref	idx_survey_sid	idx_survey_sid	4	const	1	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_communitysurveys/helpers/pagination.php:119
12	SurveyPagination->build()	JROOT/components/com_communitysurveys/helpers/pagination.php:39
11	SurveyPagination->__construct()	JROOT/components/com_communitysurveys/views/survey/view.html.php:175
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.07 ms Mémoire de requête : 0.023 MB mémoire avant requête : 2.933 MB Rangées retournées : 0

Requêtes dupliquées: #15 #20 #23 #29

SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published

  FROM db57y_survey_translations a

  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

  WHERE l.survey_id = 6 
  AND l.sef = 'fr' 
  AND a.published = 1 
  AND l.published = 1

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/language.php:175
13	CommunitySurveysModelLanguage->getSurveyTranslations()	JROOT/components/com_communitysurveys/helpers/pagination.php:136
12	SurveyPagination->build()	JROOT/components/com_communitysurveys/helpers/pagination.php:39
11	SurveyPagination->__construct()	JROOT/components/com_communitysurveys/views/survey/view.html.php:175
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.92 ms Mémoire de requête : 0.027 MB mémoire avant requête : 2.949 MB Rangées retournées : 17

SELECT a.id, a.title, a.description, a.survey_id, a.question_type, a.page_number, a.sort_order, p.sort_order AS page_order,a.custom_choice, a.mandatory, a.orientation, 0 as total_votes, a.min_selections, a.max_selections, a.params

  FROM db57y_survey_questions AS a

  INNER JOIN db57y_survey_pages p 
  on p.id = a.page_number

  WHERE a.survey_id = 6 
  AND a.page_number = 6

  ORDER BY p.sort_order asc, a.sort_order asc

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	a	ref	FK_SURVEY_QUESTIONS_SURVEY_ID	FK_SURVEY_QUESTIONS_SURVEY_ID	4	const	17	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 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/libraries/src/MVC/Model/ListModel.php:194
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:247
11	CommunitySurveysModelQuestionsBase->getItems()	JROOT/components/com_communitysurveys/views/survey/view.html.php:189
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.33 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.007 MB Rangées retournées : 35

SELECT a.id, a.answer_label as title, a.question_id, a.answer_type, a.sort_order, a.image

  FROM db57y_survey_answers AS a

  WHERE a.question_id IN (89,90,91,107,92,97,93,98,99,94,100,101,95,105,106,96,160)

  ORDER BY a.sort_order ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	FK_SURVEY_QUESTIONS_QUESTION_ID	FK_SURVEY_QUESTIONS_QUESTION_ID	4	NULL	40	Using index condition; Utilisation du tri complet de type filesort

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.06 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:318
12	CommunitySurveysModelQuestionsBase->initSurveyQuestions()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:255
11	CommunitySurveysModelQuestionsBase->getItems()	JROOT/components/com_communitysurveys/views/survey/view.html.php:189
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.30 ms Mémoire de requête : 0.024 MB mémoire avant requête : 3.039 MB Rangées retournées : 0

SELECT id, rulecontent, question_id

  FROM db57y_survey_rules AS a

  WHERE a.survey_id = 6

  ORDER BY a.id ASC

Explication

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

Profil

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_communitysurveys/models/rules.php:114
13	CommunitySurveysModelRules->getItems()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:449
12	CommunitySurveysModelQuestionsBase->processRules()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:256
11	CommunitySurveysModelQuestionsBase->getItems()	JROOT/components/com_communitysurveys/views/survey/view.html.php:189
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.25 ms Après la dernière requête : 0.08 ms Mémoire de requête : 0.023 MB mémoire avant requête : 3.048 MB Rangées retournées : 0

Requêtes dupliquées: #15 #20 #23 #25

SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published

  FROM db57y_survey_translations a

  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

  WHERE l.survey_id = 6 
  AND l.sef = 'fr' 
  AND a.published = 1 
  AND l.published = 1

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.00 ms
Executing	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_communitysurveys/models/language.php:175
13	CommunitySurveysModelLanguage->getSurveyTranslations()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:810
12	CommunitySurveysModelQuestionsBase->laodSurveyLanguage()	JROOT/administrator/components/com_communitysurveys/models/questionsbase.php:259
11	CommunitySurveysModelQuestionsBase->getItems()	JROOT/components/com_communitysurveys/views/survey/view.html.php:189
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `db57y_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_communitysurveys.survey' 
  AND `m`.`content_item_id` = 6 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explication

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

Profil

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.06 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_communitysurveys/views/survey/view.html.php:208
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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.18 ms Après la dernière requête : 3.11 ms Mémoire de requête : 0.025 MB mémoire avant requête : 3.170 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 db57y_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_communitysurveys.survey' 
  AND (fc.category_id IS NULL OR fc.category_id IN (100,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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	laboccf.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	laboccf.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	laboccf.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	laboccf.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	laboccf.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.00 ms
Sending data	0.40 ms
Creating sort index	0.04 ms
Removing tmp table	0.08 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 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/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_communitysurveys/views/survey/view.html.php:213
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Temps de requête : 0.89 ms Après la dernière requête : 9.72 ms Mémoire de requête : 0.027 MB mémoire avant requête : 3.300 MB Rangées retournées : 8

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

  FROM db57y_modules AS m

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

  LEFT JOIN db57y_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 <= '2023-11-30 08:03:13') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-11-30 08:03:13') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 687 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	43	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	laboccf.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	laboccf.m.id	1	Using where; Using index

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.36 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	Même appel que celui de la ligne ci-dessous.
19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:441
17	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:371
16	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
15	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/components/com_cjlib/framework/functions.php:881
14	CJFunctions::load_module_position()	JROOT/components/com_communitysurveys/views/survey/tmpl/default.php:25
13	include JROOT/components/com_communitysurveys/views/survey/tmpl/default.php	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:701
12	Joomla\CMS\MVC\View\_JHtmlView->loadTemplate()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:230
11	Joomla\CMS\MVC\View\_JHtmlView->display()	JROOT/components/com_communitysurveys/views/survey/view.html.php:253
10	CommunitySurveysViewSurvey->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_communitysurveys/controller.php:189
8	CommunitySurveysController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_communitysurveys/communitysurveys.php:25
6	require_once JROOT/components/com_communitysurveys/communitysurveys.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]

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

Tables sélectionnées :

5 × SELECT a.id, a.language_id, a.item_id, a.item_type, a.parent_id, a.translation, a.created_by, a.created, a.published 
  FROM db57y_survey_translations a 
  INNER JOIN db57y_survey_languages l 
  on l.id = a.language_id

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

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `db57y_assets`

2 × SELECT a.id, a.title, a.alias, a.description, a.endtext, a.custom_header, a.responses, a.metakey, a.metadesc, a.access, a.metadata,a.language, a.ip_address, a.published, a.private, a.max_responses, a.survey_key, a.redirect_url, a.restrictions,
  CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.attribs, a.ordering,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,u.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM db57y_survey_surveys AS a 
  LEFT JOIN db57y_categories AS c 
  on c.id = a.catid 
  LEFT JOIN db57y_users AS u 
  on u.id = a.created_by 
  LEFT JOIN db57y_categories as parent 
  ON parent.id = c.parent_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM db57y_categories AS cat JOIN db57y_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

2 × SELECT count(*) 
  FROM db57y_survey_questions

2 × SELECT id, title, sort_order 
  FROM db57y_survey_pages

1 × SELECT `data` 
  FROM `db57y_session`

1 × SELECT `session_id` 
  FROM `db57y_session`

1 × SELECT id, rules 
  FROM `db57y_viewlevels

1 × SELECT b.id 
  FROM db57y_usergroups AS a 
  LEFT JOIN db57y_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 db57y_extensions

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

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

```
1 × SELECT * 
  FROM db57y_languages
```

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 `db57y_categories` AS `s` 
  INNER JOIN `db57y_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT a.id, a.title, a.description, a.survey_id, a.question_type, a.page_number, a.sort_order, p.sort_order AS page_order,a.custom_choice, a.mandatory, a.orientation, 0 as total_votes, a.min_selections, a.max_selections, a.params 
  FROM db57y_survey_questions AS a 
  INNER JOIN db57y_survey_pages p 
  on p.id = a.page_number

1 × SELECT a.id, a.answer_label as title, a.question_id, a.answer_type, a.sort_order, a.image 
  FROM db57y_survey_answers AS a

1 × SELECT id, rulecontent, question_id 
  FROM db57y_survey_rules AS a

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

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 db57y_fields AS a 
  LEFT JOIN `db57y_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN db57y_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN db57y_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN db57y_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN db57y_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `db57y_fields_categories` AS fc 
  ON fc.field_id = a.id

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

Autres tables :

1 × INSERT INTO `db57y_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'71666f3667636473357039686338336a32726273307262616537', 1, 1701331393, 0, '', 0

1 × UPDATE `db57y_extensions` 
  SET `params` = '{\"mediaversion\":\"af7e004a749c4a12e0120b2ef03bd83b\"}'

Main Menu

Enquête de satisfaction

Enquête de satisfaction préleveur

Please wait..

Informations

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

32 requêtes exécutées 19.19 ms

11 doubles découverts!

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

Tables sélectionnées :

Autres tables :