ArgumentCountError

8 arguments are required, 6 given

/media/shnoulle/data/webdev/master/application/views/surveyAdministration/stopSurvey_view.php(67)

55                 </div>
56             </div>
57         </div>
58         <div class="col-12 col-sm-6 col-xl-5">
59             <div class="card card-primary h-100">
60                 <div class="card-header ">
61                     <i class="ri-stop-fill text-danger fs-4"></i>
62                     <h5 class="card-title text-danger"><?php eT("Deactivation"); ?></h5>
63                 </div>
64                 <div class="card-body px-0  d-flex">
65                     <ul>
66                         <li><?php printf(gT('Responses are %sno longer accessible.%s Your response table will be renamed to: %s%s%s'),
67                                 '<b>', '</b><br>','<b>', $sNewSurveyTableName,'</b>'); ?></li>
68                         <li><?php printf(gT("All %sparticipant information will be lost%s."), '<b>', '</b>'); ?></li>
69                         <li><?php printf(gT("%sCannot%s be %saccessed%s by %sparticipants%s. A message will be displayed stating that the survey has been closed."),
70                                 '<b>', '</b>','<b>', '</b>', '<b>', '</b>'); ?></li>
71                         <li><?php printf(
72                             gT(
73                             "%sQuestions%s, %sgroups%s and %ssettings%s can be %sedited%s again."),
74                                 '<b>', '</b>','<b>', '</b>', '<b>', '</b>', '<b>', '</b>'
75                             ); ?></li>
76                         <p class="mt-4">
77                             <?php et('Important: Export your responses before deactivating your survey.') ?>
78                             <a href='<?php echo $this->createUrl('admin/export/sa/exportresults/surveyid/' . $surveyid) ?>'>
79                                 <?php eT("See details.") ?>

Stack Trace

#0
+
 /media/shnoulle/data/webdev/master/application/views/surveyAdministration/stopSurvey_view.php(67): printf()
62                     <h5 class="card-title text-danger"><?php eT("Deactivation"); ?></h5>
63                 </div>
64                 <div class="card-body px-0  d-flex">
65                     <ul>
66                         <li><?php printf(gT('Responses are %sno longer accessible.%s Your response table will be renamed to: %s%s%s'),
67                                 '<b>', '</b><br>','<b>', $sNewSurveyTableName,'</b>'); ?></li>
68                         <li><?php printf(gT("All %sparticipant information will be lost%s."), '<b>', '</b>'); ?></li>
69                         <li><?php printf(gT("%sCannot%s be %saccessed%s by %sparticipants%s. A message will be displayed stating that the survey has been closed."),
70                                 '<b>', '</b>','<b>', '</b>', '<b>', '</b>'); ?></li>
71                         <li><?php printf(
72                             gT(
#4
+
 /media/shnoulle/data/webdev/master/application/views/surveyAdministration/deactivateSurvey_view.php(6): CController->renderPartial()
01 
02 <div class='side-body <?php echo getSideBodyClass(false); ?>'>
03 <?php if (isset($step1)) {
04 
05     $this->renderPartial('stopSurvey_view', [
06         'surveyid' => $surveyid,
07         'dbprefix' => $dbprefix,
08         'date'     => $date,
09         'sNewSurveyTableName' => $sNewSurveyTableName ?? null
10     ]);
11 } elseif (isset($nostep)) { //todo: why no step? at least a message would be nice...?>
#9
+
 /media/shnoulle/data/webdev/master/application/controllers/SurveyAdministrationController.php(1743): CController->render()
1738 
1739             $aData['sidemenu']['state'] = false;
1740         }
1741 
1742         $this->aData = $aData;
1743         $this->render('deactivateSurvey_view', $aData);
1744     }
1745 
1746     /**
1747      * fixes the numbering of questions
1748      * This can happen if question 1 have subquestion code 1 and
2023-11-21 15:24:13 nginx/1.22.1 Yii Framework/1.1.28
Sommaire du rapport de profilage (Durée: 0.15549s, Memoire: 5,393KB)
Fonction Nb Total (s) Moy. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT * FROM `lime_surveys_groupsettings` `t` WHERE `t`.`gsid`=0 LIMIT 1) 7 0.00061 0.00009 0.00007 0.00011
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_settings_global`) 1 0.00040 0.00040 0.00040 0.00040
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_settings_global`) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t`) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_users`) 1 0.00033 0.00033 0.00033 0.00033
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_plugins`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT * FROM `lime_plugins` `t` WHERE `t`.`active`=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT `t1`.`message` AS `message`, `t2`.`translation` AS `translation` FROM `lime_source_message` `t1`, `lime_message` `t2` WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='fr') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM `lime_settings_global` `t` WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_permissions`) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT `languagesettings`.`surveyls_survey_id` AS `t1_c0`, `languagesettings`.`surveyls_language` AS `t1_c1`, `languagesettings`.`surveyls_title` AS `t1_c2`, `languagesettings`.`surveyls_description` AS `t1_c3`, `languagesettings`.`surveyls_welcometext` AS `t1_c4`, `languagesettings`.`surveyls_endtext` AS `t1_c5`, `languagesettings`.`surveyls_policy_notice` AS `t1_c6`, `languagesettings`.`surveyls_policy_error` AS `t1_c7`, `languagesettings`.`surveyls_policy_notice_label` AS `t1_c8`, `languagesettings`.`surveyls_url` AS `t1_c9`, `languagesettings`.`surveyls_urldescription` AS `t1_c10`, `languagesettings`.`surveyls_email_invite_subj` AS `t1_c11`, `languagesettings`.`surveyls_email_invite` AS `t1_c12`, `languagesettings`.`surveyls_email_remind_subj` AS `t1_c13`, `languagesettings`.`surveyls_email_remind` AS `t1_c14`, `languagesettings`.`surveyls_email_register_subj` AS `t1_c15`, `languagesettings`.`surveyls_email_register` AS `t1_c16`, `languagesettings`.`surveyls_email_confirm_subj` AS `t1_c17`, `languagesettings`.`surveyls_email_confirm` AS `t1_c18`, `languagesettings`.`surveyls_dateformat` AS `t1_c19`, `languagesettings`.`surveyls_attributecaptions` AS `t1_c20`, `languagesettings`.`email_admin_notification_subj` AS `t1_c21`, `languagesettings`.`email_admin_notification` AS `t1_c22`, `languagesettings`.`email_admin_responses_subj` AS `t1_c23`, `languagesettings`.`email_admin_responses` AS `t1_c24`, `languagesettings`.`surveyls_numberformat` AS `t1_c25`, `languagesettings`.`attachments` AS `t1_c26`, `languagesettings`.`surveyls_alias` AS `t1_c27` FROM `lime_surveys_languagesettings` `languagesettings` WHERE (`languagesettings`.`surveyls_survey_id`=:ypl0). Bound with :ypl0=33944) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_users`) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SELECT `t`.`gsid` AS `t0_c0`, `t`.`owner_id` AS `t0_c1`, `t`.`admin` AS `t0_c2`, `t`.`adminemail` AS `t0_c3`, `t`.`anonymized` AS `t0_c4`, `t`.`format` AS `t0_c5`, `t`.`savetimings` AS `t0_c6`, `t`.`template` AS `t0_c7`, `t`.`datestamp` AS `t0_c8`, `t`.`usecookie` AS `t0_c9`, `t`.`allowregister` AS `t0_c10`, `t`.`allowsave` AS `t0_c11`, `t`.`autonumber_start` AS `t0_c12`, `t`.`autoredirect` AS `t0_c13`, `t`.`allowprev` AS `t0_c14`, `t`.`printanswers` AS `t0_c15`, `t`.`ipaddr` AS `t0_c16`, `t`.`refurl` AS `t0_c17`, `t`.`showsurveypolicynotice` AS `t0_c18`, `t`.`publicstatistics` AS `t0_c19`, `t`.`publicgraphs` AS `t0_c20`, `t`.`listpublic` AS `t0_c21`, `t`.`htmlemail` AS `t0_c22`, `t`.`sendconfirmation` AS `t0_c23`, `t`.`tokenanswerspersistence` AS `t0_c24`, `t`.`assessments` AS `t0_c25`, `t`.`usecaptcha` AS `t0_c26`, `t`.`bounce_email` AS `t0_c27`, `t`.`attributedescriptions` AS `t0_c28`, `t`.`emailresponseto` AS `t0_c29`, `t`.`emailnotificationto` AS `t0_c30`, `t`.`tokenlength` AS `t0_c31`, `t`.`showxquestions` AS `t0_c32`, `t`.`showgroupinfo` AS `t0_c33`, `t`.`shownoanswer` AS `t0_c34`, `t`.`showqnumcode` AS `t0_c35`, `t`.`showwelcome` AS `t0_c36`, `t`.`showprogress` AS `t0_c37`, `t`.`questionindex` AS `t0_c38`, `t`.`navigationdelay` AS `t0_c39`, `t`.`nokeyboard` AS `t0_c40`, `t`.`alloweditaftercompletion` AS `t0_c41`, `t`.`ipanonymize` AS `t0_c42`, `SurveysGroups`.`gsid` AS `t1_c0`, `SurveysGroups`.`name` AS `t1_c1`, `SurveysGroups`.`title` AS `t1_c2`, `SurveysGroups`.`template` AS `t1_c3`, `SurveysGroups`.`description` AS `t1_c4`, `SurveysGroups`.`sortorder` AS `t1_c5`, `SurveysGroups`.`owner_id` AS `t1_c6`, `SurveysGroups`.`parent_id` AS `t1_c7`, `SurveysGroups`.`created` AS `t1_c8`, `SurveysGroups`.`modified` AS `t1_c9`, `SurveysGroups`.`created_by` AS `t1_c10`, `SurveysGroups`.`alwaysavailable` AS `t1_c11` FROM `lime_surveys_groupsettings` `t` LEFT OUTER JOIN `lime_surveys_groups` `SurveysGroups` ON (`SurveysGroups`.`gsid`=`t`.`gsid`) WHERE (`t`.`gsid`=1)) 7 0.00111 0.00016 0.00014 0.00019
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE `t`.`uid`=1 LIMIT 1) 14 0.00079 0.00006 0.00004 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_users` `t` WHERE (expires > :now OR expires IS NULL) AND (`t`.`uid`=1) LIMIT 1. Bound with :now='2023-11-21 15:24:13') 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys`) 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groupsettings`) 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_groups`) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_templates`) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_groups`) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SELECT * FROM `lime_templates` `t` WHERE `t`.`name`='fruity_twentythree' LIMIT 1) 2 0.00017 0.00008 0.00007 0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_surveys` `t` WHERE `t`.`sid`=33944 LIMIT 1) 1 0.00012 0.00012 0.00012 0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_permissions` `t` WHERE `t`.`entity_id`=:yp0 AND `t`.`entity`=:yp1 AND `t`.`uid`=:yp2 AND `t`.`permission`=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys`) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_templates`) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_template_configuration`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groupsettings`) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_plugins`) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_permissions`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_groups`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT `t`.`id`, `t`.`template_name`, `t`.`sid`, `t`.`gsid`, `t`.`uid`, `t`.`files_css`, `t`.`files_js`, `t`.`files_print_css`, `t`.`options`, `t`.`cssframework_name`, `t`.`cssframework_css`, `t`.`cssframework_js`, `t`.`packages_to_load`, `t`.`packages_ltr`, `t`.`packages_rtl` FROM `lime_template_configuration` `t` INNER JOIN lime_templates AS template ON `t`.`template_name` = template.name WHERE ((t.sid IS NULL) AND (t.gsid IS NULL)) AND (template.name IS NOT NULL) ORDER BY `t`.`template_name`) 16 0.00527 0.00033 0.00029 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='bootswatch') 16 0.00183 0.00011 0.00010 0.00015
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_twentythree') 17 0.00142 0.00008 0.00007 0.00015
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') 16 0.00139 0.00009 0.00007 0.00014
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') 16 0.00126 0.00008 0.00006 0.00015
system.db.CDbCommand.query(SHOW TABLES) 1 0.00035 0.00035 0.00035 0.00035
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_policy_notice` AS `t0_c6`, `t`.`surveyls_policy_error` AS `t0_c7`, `t`.`surveyls_policy_notice_label` AS `t0_c8`, `t`.`surveyls_url` AS `t0_c9`, `t`.`surveyls_urldescription` AS `t0_c10`, `t`.`surveyls_email_invite_subj` AS `t0_c11`, `t`.`surveyls_email_invite` AS `t0_c12`, `t`.`surveyls_email_remind_subj` AS `t0_c13`, `t`.`surveyls_email_remind` AS `t0_c14`, `t`.`surveyls_email_register_subj` AS `t0_c15`, `t`.`surveyls_email_register` AS `t0_c16`, `t`.`surveyls_email_confirm_subj` AS `t0_c17`, `t`.`surveyls_email_confirm` AS `t0_c18`, `t`.`surveyls_dateformat` AS `t0_c19`, `t`.`surveyls_attributecaptions` AS `t0_c20`, `t`.`email_admin_notification_subj` AS `t0_c21`, `t`.`email_admin_notification` AS `t0_c22`, `t`.`email_admin_responses_subj` AS `t0_c23`, `t`.`email_admin_responses` AS `t0_c24`, `t`.`surveyls_numberformat` AS `t0_c25`, `t`.`attachments` AS `t0_c26`, `t`.`surveyls_alias` AS `t0_c27`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` 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`.`showsurveypolicynotice` AS `t1_c25`, `survey`.`publicstatistics` AS `t1_c26`, `survey`.`publicgraphs` AS `t1_c27`, `survey`.`listpublic` AS `t1_c28`, `survey`.`htmlemail` AS `t1_c29`, `survey`.`sendconfirmation` AS `t1_c30`, `survey`.`tokenanswerspersistence` AS `t1_c31`, `survey`.`assessments` AS `t1_c32`, `survey`.`usecaptcha` AS `t1_c33`, `survey`.`usetokens` AS `t1_c34`, `survey`.`bounce_email` AS `t1_c35`, `survey`.`attributedescriptions` AS `t1_c36`, `survey`.`emailresponseto` AS `t1_c37`, `survey`.`emailnotificationto` AS `t1_c38`, `survey`.`tokenlength` AS `t1_c39`, `survey`.`showxquestions` AS `t1_c40`, `survey`.`showgroupinfo` AS `t1_c41`, `survey`.`shownoanswer` AS `t1_c42`, `survey`.`showqnumcode` AS `t1_c43`, `survey`.`bouncetime` AS `t1_c44`, `survey`.`bounceprocessing` AS `t1_c45`, `survey`.`bounceaccounttype` AS `t1_c46`, `survey`.`bounceaccounthost` AS `t1_c47`, `survey`.`bounceaccountpass` AS `t1_c48`, `survey`.`bounceaccountencryption` AS `t1_c49`, `survey`.`bounceaccountuser` AS `t1_c50`, `survey`.`showwelcome` AS `t1_c51`, `survey`.`showprogress` AS `t1_c52`, `survey`.`questionindex` AS `t1_c53`, `survey`.`navigationdelay` AS `t1_c54`, `survey`.`nokeyboard` AS `t1_c55`, `survey`.`alloweditaftercompletion` AS `t1_c56`, `survey`.`googleanalyticsstyle` AS `t1_c57`, `survey`.`googleanalyticsapikey` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=33944 AND `t`.`surveyls_language`='fr')) 1 0.00024 0.00024 0.00024 0.00024
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`.`one_time_pw` AS `t1_c10`, `owner`.`dateformat` AS `t1_c11`, `owner`.`created` AS `t1_c12`, `owner`.`modified` AS `t1_c13`, `owner`.`last_login` AS `t1_c14`, `owner`.`validation_key` AS `t1_c15`, `owner`.`validation_key_expiration` AS `t1_c16`, `owner`.`last_forgot_email_password` AS `t1_c17`, `owner`.`expires` AS `t1_c18` FROM `lime_users` `owner` WHERE (`owner`.`uid`=:ypl0). Bound with :ypl0=1) 2 0.00019 0.00010 0.00007 0.00012
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=1299) 1 0.00006 0.00006 0.00006 0.00006
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_template_configuration`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_surveys_languagesettings`) 1 0.00005 0.00005 0.00005 0.00005
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_policy_notice` AS `t0_c6`, `t`.`surveyls_policy_error` AS `t0_c7`, `t`.`surveyls_policy_notice_label` AS `t0_c8`, `t`.`surveyls_url` AS `t0_c9`, `t`.`surveyls_urldescription` AS `t0_c10`, `t`.`surveyls_email_invite_subj` AS `t0_c11`, `t`.`surveyls_email_invite` AS `t0_c12`, `t`.`surveyls_email_remind_subj` AS `t0_c13`, `t`.`surveyls_email_remind` AS `t0_c14`, `t`.`surveyls_email_register_subj` AS `t0_c15`, `t`.`surveyls_email_register` AS `t0_c16`, `t`.`surveyls_email_confirm_subj` AS `t0_c17`, `t`.`surveyls_email_confirm` AS `t0_c18`, `t`.`surveyls_dateformat` AS `t0_c19`, `t`.`surveyls_attributecaptions` AS `t0_c20`, `t`.`email_admin_notification_subj` AS `t0_c21`, `t`.`email_admin_notification` AS `t0_c22`, `t`.`email_admin_responses_subj` AS `t0_c23`, `t`.`email_admin_responses` AS `t0_c24`, `t`.`surveyls_numberformat` AS `t0_c25`, `t`.`attachments` AS `t0_c26`, `t`.`surveyls_alias` AS `t0_c27`, `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` 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`.`showsurveypolicynotice` AS `t1_c25`, `survey`.`publicstatistics` AS `t1_c26`, `survey`.`publicgraphs` AS `t1_c27`, `survey`.`listpublic` AS `t1_c28`, `survey`.`htmlemail` AS `t1_c29`, `survey`.`sendconfirmation` AS `t1_c30`, `survey`.`tokenanswerspersistence` AS `t1_c31`, `survey`.`assessments` AS `t1_c32`, `survey`.`usecaptcha` AS `t1_c33`, `survey`.`usetokens` AS `t1_c34`, `survey`.`bounce_email` AS `t1_c35`, `survey`.`attributedescriptions` AS `t1_c36`, `survey`.`emailresponseto` AS `t1_c37`, `survey`.`emailnotificationto` AS `t1_c38`, `survey`.`tokenlength` AS `t1_c39`, `survey`.`showxquestions` AS `t1_c40`, `survey`.`showgroupinfo` AS `t1_c41`, `survey`.`shownoanswer` AS `t1_c42`, `survey`.`showqnumcode` AS `t1_c43`, `survey`.`bouncetime` AS `t1_c44`, `survey`.`bounceprocessing` AS `t1_c45`, `survey`.`bounceaccounttype` AS `t1_c46`, `survey`.`bounceaccounthost` AS `t1_c47`, `survey`.`bounceaccountpass` AS `t1_c48`, `survey`.`bounceaccountencryption` AS `t1_c49`, `survey`.`bounceaccountuser` AS `t1_c50`, `survey`.`showwelcome` AS `t1_c51`, `survey`.`showprogress` AS `t1_c52`, `survey`.`questionindex` AS `t1_c53`, `survey`.`navigationdelay` AS `t1_c54`, `survey`.`nokeyboard` AS `t1_c55`, `survey`.`alloweditaftercompletion` AS `t1_c56`, `survey`.`googleanalyticsstyle` AS `t1_c57`, `survey`.`googleanalyticsapikey` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60` FROM `lime_surveys_languagesettings` `t` LEFT OUTER JOIN `lime_surveys` `survey` ON (t.surveyls_survey_id = survey.sid) WHERE (`t`.`surveyls_survey_id`=33944 AND `t`.`surveyls_language`='en')) 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(select count(DISTINCT `lime_groups`.gid) from `lime_groups` left join lime_questions on `lime_groups`.gid=lime_questions.gid where `lime_groups`.sid =33944 and qid is not null) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_questions`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_group_l10ns`) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT DISTINCT qid FROM `lime_questions` `t` WHERE sid=:sid and parent_qid=0 GROUP BY qid. Bound with :sid=33944) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_attributes`) 1 0.00022 0.00022 0.00022 0.00022
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_twentythree') 1 0.00011 0.00011 0.00011 0.00011
system.db.CDbCommand.query(SELECT `groups`.`gid` AS `t1_c0`, `groups`.`sid` AS `t1_c1`, `groups`.`group_order` AS `t1_c2`, `groups`.`randomization_group` AS `t1_c3`, `groups`.`grelevance` AS `t1_c4` FROM `lime_groups` `groups` WHERE (`groups`.`sid`=:ypl0) ORDER BY groups.group_order ASC. Bound with :ypl0=33944) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT `questiongroupl10ns`.`id` AS `t1_c0`, `questiongroupl10ns`.`gid` AS `t1_c1`, `questiongroupl10ns`.`group_name` AS `t1_c2`, `questiongroupl10ns`.`description` AS `t1_c3`, `questiongroupl10ns`.`language` AS `t1_c4` FROM `lime_group_l10ns` `questiongroupl10ns` WHERE (`questiongroupl10ns`.`gid`=:ypl0). Bound with :ypl0=126) 1 0.00009 0.00009 0.00009 0.00009
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=1296) 1 0.00008 0.00008 0.00008 0.00008
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_group_l10ns`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_questions`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_question_themes`) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=1299) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_groups`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_attributes`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT `survey`.`sid` AS `t1_c0`, `survey`.`owner_id` AS `t1_c1`, `survey`.`gsid` AS `t1_c2`, `survey`.`admin` AS `t1_c3`, `survey`.`active` AS `t1_c4`, `survey`.`expires` AS `t1_c5`, `survey`.`startdate` AS `t1_c6`, `survey`.`adminemail` AS `t1_c7`, `survey`.`anonymized` 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`.`showsurveypolicynotice` AS `t1_c25`, `survey`.`publicstatistics` AS `t1_c26`, `survey`.`publicgraphs` AS `t1_c27`, `survey`.`listpublic` AS `t1_c28`, `survey`.`htmlemail` AS `t1_c29`, `survey`.`sendconfirmation` AS `t1_c30`, `survey`.`tokenanswerspersistence` AS `t1_c31`, `survey`.`assessments` AS `t1_c32`, `survey`.`usecaptcha` AS `t1_c33`, `survey`.`usetokens` AS `t1_c34`, `survey`.`bounce_email` AS `t1_c35`, `survey`.`attributedescriptions` AS `t1_c36`, `survey`.`emailresponseto` AS `t1_c37`, `survey`.`emailnotificationto` AS `t1_c38`, `survey`.`tokenlength` AS `t1_c39`, `survey`.`showxquestions` AS `t1_c40`, `survey`.`showgroupinfo` AS `t1_c41`, `survey`.`shownoanswer` AS `t1_c42`, `survey`.`showqnumcode` AS `t1_c43`, `survey`.`bouncetime` AS `t1_c44`, `survey`.`bounceprocessing` AS `t1_c45`, `survey`.`bounceaccounttype` AS `t1_c46`, `survey`.`bounceaccounthost` AS `t1_c47`, `survey`.`bounceaccountpass` AS `t1_c48`, `survey`.`bounceaccountencryption` AS `t1_c49`, `survey`.`bounceaccountuser` AS `t1_c50`, `survey`.`showwelcome` AS `t1_c51`, `survey`.`showprogress` AS `t1_c52`, `survey`.`questionindex` AS `t1_c53`, `survey`.`navigationdelay` AS `t1_c54`, `survey`.`nokeyboard` AS `t1_c55`, `survey`.`alloweditaftercompletion` AS `t1_c56`, `survey`.`googleanalyticsstyle` AS `t1_c57`, `survey`.`googleanalyticsapikey` AS `t1_c58`, `survey`.`tokenencryptionoptions` AS `t1_c59`, `survey`.`ipanonymize` AS `t1_c60` FROM `lime_surveys` `survey` WHERE (`survey`.`sid`=:ypl0). Bound with :ypl0=33944) 4 0.00060 0.00015 0.00014 0.00016
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='date', :extends='D') 4 0.00037 0.00009 0.00008 0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_themes` `t` WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='D', :extends='') 4 0.00035 0.00009 0.00007 0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=1296) 1 0.00013 0.00013 0.00013 0.00013
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=1297) 1 0.00010 0.00010 0.00010 0.00010
system.db.CDbCommand.query(SELECT * FROM `lime_questions` `t` WHERE qid=:qid LIMIT 1. Bound with :qid=1298) 1 0.00007 0.00007 0.00007 0.00007
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=1297) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SELECT * FROM `lime_question_attributes` `t` WHERE qid=:qid. Bound with :qid=1298) 1 0.00005 0.00005 0.00005 0.00005
system.db.CDbCommand.query(SHOW CREATE TABLE `lime_question_themes`) 1 0.00004 0.00004 0.00004 0.00004
system.db.CDbCommand.query(SELECT a.qid, a.code, l.answer, a.scale_id, a.assessment_value FROM lime_answers AS a JOIN lime_questions q on a.qid=q.qid JOIN lime_answer_l10ns l on l.aid=a.aid WHERE 1=1 and a.qid = q.qid and q.sid = 33944 and l.language='fr' ORDER BY a.qid, a.scale_id, a.sortorder) 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM `lime_surveys_languagesettings`) 1 0.00026 0.00026 0.00026 0.00026