Nous sommes désolés, mais le questionnaire a expiré et n’est plus disponible.

Pour plus d'information, veuillez contacter Gabriel JALAM
gabriel.jalam@agrocampus-ouest.fr

Sommaire du rapport de profilage (Durée: 1.15396s, Memoire: 48,932KB)
Fonction Nb Total (s) Moy. (s) Min. (s) Max. (s)
system.db.CDbCommand.execute(DELETE FROM `lime_sessions` WHERE expire<:expire. Bound with :expire=1790448579) 2 0.31255 0.15627 0.15622 0.15633
system.db.CDbCommand.query(SHOW TABLES) 1 0.01383 0.01383 0.01383 0.01383
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) 2 0.01080 0.00540 0.00464 0.00617
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) 1 0.00276 0.00276 0.00276 0.00276
system.db.CDbCommand.query(SELECT * FROM `lime_groups` WHERE sid=535865 AND language='fr' ORDER BY group_order) 1 0.00269 0.00269 0.00269 0.00269
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='22', :yp1='multiAccessTime') 2 0.00218 0.00109 0.00024 0.00194
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='22', :yp1='dbVersion') 1 0.00213 0.00213 0.00213 0.00213
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model` IS NULL AND `t`.`model_id` IS NULL AND `t`.`key`=:yp1. Bound with :yp0='19', :yp1='dbversion') 1 0.00202 0.00202 0.00202 0.00202
system.db.CDbCommand.query(SELECT `t`.`surveyls_survey_id` AS `t0_c0`, `t`.`surveyls_language` AS `t0_c1`, `t`.`surveyls_title` AS `t0_c2`, `t`.`surveyls_description` AS `t0_c3`, `t`.`surveyls_welcometext` AS `t0_c4`, `t`.`surveyls_endtext` AS `t0_c5`, `t`.`surveyls_url` AS `t0_c6`, `t`.`surveyls_urldescription` AS `t0_c7`, `t`.`surveyls_email_invite_subj` AS `t0_c8`, `t`.`surveyls_email_invite` AS `t0_c9`, `t`.`surveyls_email_remind_subj` AS `t0_c10`, `t`.`surveyls_email_remind` AS `t0_c11`, `t`.`surveyls_email_register_subj` AS `t0_c12`, `t`.`surveyls_email_register` AS `t0_c13`, `t`.`surveyls_email_confirm_subj` AS `t0_c14`, `t`.`surveyls_email_confirm` AS `t0_c15`, `t`.`surveyls_dateformat` AS `t0_c16`, `t`.`surveyls_numberformat` AS `t0_c17`, `t`.`email_admin_notification_subj` AS `t0_c18`, `t`.`email_admin_notification` AS `t0_c19`, `t`.`email_admin_responses_subj` AS `t0_c20`, `t`.`email_admin_responses` AS `t0_c21`, `t`.`surveyls_attributecaptions` AS `t0_c22`, `t`.`attachments` AS `t0_c23`, `t`.`surveyls_policy_notice` AS `t0_c24`, `t`.`surveyls_policy_error` AS `t0_c25`, `t`.`surveyls_policy_notice_label` AS `t0_c26`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`admin` AS `t1_c2`, `survey`.`active` AS `t1_c3`, `survey`.`expires` AS `t1_c4`, `survey`.`startdate` AS `t1_c5`, `survey`.`adminemail` AS `t1_c6`, `survey`.`anonymized` AS `t1_c7`, `survey`.`faxto` AS `t1_c8`, `survey`.`format` AS `t1_c9`, `survey`.`savetimings` AS `t1_c10`, `survey`.`template` AS `t1_c11`, `survey`.`language` AS `t1_c12`, `survey`.`additional_languages` AS `t1_c13`, `survey`.`datestamp` AS `t1_c14`, `survey`.`usecookie` AS `t1_c15`, `survey`.`allowregister` AS `t1_c16`, `survey`.`allowsave` AS `t1_c17`, `survey`.`autonumber_start` AS `t1_c18`, `survey`.`autoredirect` AS `t1_c19`, `survey`.`allowprev` AS `t1_c20`, `survey`.`printanswers` AS `t1_c21`, `survey`.`ipaddr` AS `t1_c22`, `survey`.`refurl` AS `t1_c23`, `survey`.`datecreated` AS `t1_c24`, `survey`.`publicstatistics` AS `t1_c25`, `survey`.`publicgraphs` AS `t1_c26`, `survey`.`listpublic` AS `t1_c27`, `survey`.`htmlemail` AS `t1_c28`, `survey`.`tokenanswerspersistence` AS `t1_c29`, `survey`.`assessments` AS `t1_c30`, `survey`.`usecaptcha` AS `t1_c31`, `survey`.`usetokens` AS `t1_c32`, `survey`.`bounce_email` AS `t1_c33`, `survey`.`attributedescriptions` AS `t1_c34`, `survey`.`emailresponseto` AS `t1_c35`, `survey`.`emailnotificationto` AS `t1_c36`, `survey`.`tokenlength` AS `t1_c37`, `survey`.`showxquestions` AS `t1_c38`, `survey`.`showgroupinfo` AS `t1_c39`, `survey`.`shownoanswer` AS `t1_c40`, `survey`.`showqnumcode` AS `t1_c41`, `survey`.`bouncetime` AS `t1_c42`, `survey`.`bounceprocessing` AS `t1_c43`, `survey`.`bounceaccounttype` AS `t1_c44`, `survey`.`bounceaccounthost` AS `t1_c45`, `survey`.`bounceaccountpass` AS `t1_c46`, `survey`.`bounceaccountencryption` AS `t1_c47`, `survey`.`bounceaccountuser` AS `t1_c48`, `survey`.`showwelcome` AS `t1_c49`, `survey`.`showprogress` AS `t1_c50`, `survey`.`navigationdelay` AS `t1_c51`, `survey`.`nokeyboard` AS `t1_c52`, `survey`.`alloweditaftercompletion` AS `t1_c53`, `survey`.`googleanalyticsstyle` AS `t1_c54`, `survey`.`googleanalyticsapikey` AS `t1_c55`, `survey`.`sendconfirmation` AS `t1_c56`, `survey`.`questionindex` AS `t1_c57`, `survey`.`gsid` AS `t1_c58`, `survey`.`showsurveypolicynotice` AS `t1_c59` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=535865 AND `t`.`surveyls_language`='fr')) 1 0.00152 0.00152 0.00152 0.00152
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugin_settings`) 1 0.00132 0.00132 0.00132 0.00132
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) 1 0.00129 0.00129 0.00129 0.00129
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) 1 0.00129 0.00129 0.00129 0.00129
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity' LIMIT 1) 2 0.00111 0.00056 0.00043 0.00068
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) 1 0.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='iara') 3 0.00106 0.00035 0.00029 0.00039
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='iara' LIMIT 1) 2 0.00105 0.00052 0.00028 0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 1 0.00104 0.00104 0.00104 0.00104
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=535865 LIMIT 1) 1 0.00102 0.00102 0.00102 0.00102
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='agrocampusEtudiant' LIMIT 1) 2 0.00101 0.00050 0.00044 0.00057
system.db.CDbCommand.query(SELECT `id` FROM `lime_sessions` WHERE id=:id. Bound with :id='8d2d6667af983ae6078ae616ba52b1f2') 1 0.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='vanilla' LIMIT 1) 2 0.00084 0.00042 0.00034 0.00051
system.db.CDbCommand.query(SELECT * FROM `lime_plugin_settings` `t` WHERE `t`.`plugin_id`=:yp0 AND `t`.`model`=:yp1 AND `t`.`model_id`=:yp2 AND `t`.`key`=:yp3. Bound with :yp0='22', :yp1='Survey', :yp2=535865, :yp3='multiAccessTime') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='vanilla') 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`) 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`) 1 0.00075 0.00075 0.00075 0.00075
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (gsid=:gsid) AND (template_name=:template_name) ORDER BY `t`.`template_name` LIMIT 1. Bound with :gsid='1', :template_name='iara') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='iara') 1 0.00071 0.00071 0.00071 0.00071
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE name = :name LIMIT 1. Bound with :name='renderMessage') 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`) 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT `data` FROM `lime_sessions` WHERE expire>:expire AND id=:id. Bound with :expire=1790448580, :id='8d2d6667af983ae6078ae616ba52b1f2') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT `data` FROM `lime_sessions` WHERE expire>:expire AND id=:id. Bound with :expire=1790448579, :id='8d2d6667af983ae6078ae616ba52b1f2') 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_asset_version`) 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE (sid=:sid) AND (template_name=:template_name) ORDER BY `t`.`template_name` LIMIT 1. Bound with :sid=535865, :template_name='iara') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.execute(UPDATE `lime_sessions` SET `data`=:data, `expire`=:expire WHERE id=:id. Bound with :id='8d2d6667af983ae6078ae616ba52b1f2', :data='', :expire=1790455779) 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugin_settings`) 1 0.00053 0.00053 0.00053 0.00053
system.db.CDbCommand.query(SELECT * FROM `lime_template_configuration` `t` WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL ORDER BY `t`.`template_name` LIMIT 1. Bound with :template_name='fruity') 1 0.00051 0.00051 0.00051 0.00051
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0. Bound with :yp0=1) 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT `templateModel`.`id` AS `t1_c0`, `templateModel`.`name` AS `t1_c1`, `templateModel`.`folder` AS `t1_c2`, `templateModel`.`title` AS `t1_c3`, `templateModel`.`creation_date` AS `t1_c4`, `templateModel`.`author` AS `t1_c5`, `templateModel`.`author_email` AS `t1_c6`, `templateModel`.`author_url` AS `t1_c7`, `templateModel`.`copyright` AS `t1_c8`, `templateModel`.`license` AS `t1_c9`, `templateModel`.`version` AS `t1_c10`, `templateModel`.`api_version` AS `t1_c11`, `templateModel`.`view_folder` AS `t1_c12`, `templateModel`.`files_folder` AS `t1_c13`, `templateModel`.`description` AS `t1_c14`, `templateModel`.`last_update` AS `t1_c15`, `templateModel`.`owner_id` AS `t1_c16`, `templateModel`.`extends` AS `t1_c17` FROM `lime_templates` `templateModel` WHERE (`templateModel`.`name`=:ypl0). Bound with :ypl0='iara') 1 0.00046 0.00046 0.00046 0.00046
system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='fruity') 1 0.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groups` `t` WHERE `t`.`gsid`=1 LIMIT 1) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `owner`.`uid` AS `t1_c0`, `owner`.`users_name` AS `t1_c1`, `owner`.`password` AS `t1_c2`, `owner`.`full_name` AS `t1_c3`, `owner`.`parent_id` AS `t1_c4`, `owner`.`lang` AS `t1_c5`, `owner`.`email` AS `t1_c6`, `owner`.`htmleditormode` AS `t1_c7`, `owner`.`templateeditormode` AS `t1_c8`, `owner`.`questionselectormode` AS `t1_c9`, `owner`.`dateformat` AS `t1_c10`, `owner`.`created` AS `t1_c11`, `owner`.`modified` AS `t1_c12`, `owner`.`one_time_pw` AS `t1_c13` FROM `lime_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0='80') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT `template`.`id` AS `t1_c0`, `template`.`name` AS `t1_c1`, `template`.`folder` AS `t1_c2`, `template`.`title` AS `t1_c3`, `template`.`creation_date` AS `t1_c4`, `template`.`author` AS `t1_c5`, `template`.`author_email` AS `t1_c6`, `template`.`author_url` AS `t1_c7`, `template`.`copyright` AS `t1_c8`, `template`.`license` AS `t1_c9`, `template`.`version` AS `t1_c10`, `template`.`api_version` AS `t1_c11`, `template`.`view_folder` AS `t1_c12`, `template`.`files_folder` AS `t1_c13`, `template`.`description` AS `t1_c14`, `template`.`last_update` AS `t1_c15`, `template`.`owner_id` AS `t1_c16`, `template`.`extends` AS `t1_c17` FROM `lime_templates` `template` WHERE (`template`.`name`=:ypl0). Bound with :ypl0='vanilla') 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_asset_version`) 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`) 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT * FROM `lime_asset_version` `t` WHERE path = :path LIMIT 1. Bound with :path='/var/www/enquete.agrocampus-ouest.fr/themes/survey/fruity/files/favicon.ico') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`) 1 0.00025 0.00025 0.00025 0.00025