|
|
SodiumException
Invalid MAC
/opt/bitnami/apps/limesurvey/htdocs/third_party/paragonie/sodium_compat/src/Crypto.php(1058)
1046 );
1047 $verified = ParagonIE_Sodium_Core_Poly1305::onetimeauth_verify(
1048 $mac,
1049 $c,
1050 ParagonIE_Sodium_Core_Util::substr($block0, 0, 32)
1051 );
1052 if (!$verified) {
1053 try {
1054 ParagonIE_Sodium_Compat::memzero($subkey);
1055 } catch (SodiumException $ex) {
1056 $subkey = null;
1057 }
1058 throw new SodiumException('Invalid MAC');
1059 }
1060
1061 / @var string $m - Decrypted message */
1062 $m = ParagonIE_Sodium_Core_Util::xorStrings(
1063 ParagonIE_Sodium_Core_Util::substr($block0, self::secretbox_xsalsa20poly1305_ZEROBYTES),
1064 ParagonIE_Sodium_Core_Util::substr($c, 0, self::secretbox_xsalsa20poly1305_ZEROBYTES)
1065 );
1066 if ($clen > self::secretbox_xsalsa20poly1305_ZEROBYTES) {
1067 // We had more than 1 block, so let's continue to decrypt the rest.
1068 $m .= ParagonIE_Sodium_Core_Salsa20::salsa20_xor_ic(
1069 ParagonIE_Sodium_Core_Util::substr(
1070 $c,
Stack Trace
#0
– /opt/bitnami/apps/limesurvey/htdocs/third_party/paragonie/sodium_compat/src/Compat.php(2343): ParagonIE_Sodium_Crypto::secretbox_open()
2338 return call_user_func('\Sodium\crypto_secretbox_open', $ciphertext, $nonce, $key);
2339 }
2340 if (PHP_INT_SIZE === 4) {
2341 return ParagonIE_Sodium_Crypto32::secretbox_open($ciphertext, $nonce, $key);
2342 }
2343 return ParagonIE_Sodium_Crypto::secretbox_open($ciphertext, $nonce, $key);
2344 }
2345
2346 /*
2347 Return a secure random key for use with crypto_secretbox
2348
#1
– /opt/bitnami/apps/limesurvey/htdocs/application/core/LSSodium.php(139): ParagonIE_Sodium_Compat::crypto_secretbox_open()
134 /
135 public function decrypt($sEncryptedString, $bReturnFalseIfError = false): string
136 {
137 if ($this->bLibraryExists === true) {
138 if (!empty($sEncryptedString) && $sEncryptedString !== 'null') {
139 $plaintext = ParagonIE_Sodium_Compat::crypto_secretbox_open(base64_decode($sEncryptedString), $this->sEncryptionNonce, $this->sEncryptionSecretBoxKey);
140 if ($plaintext === false) {
141 throw new SodiumException(sprintf(gT("Wrong decryption key! Decryption key has changed since this data were last saved, so data can't be decrypted. Please consult our manual at %s.", 'unescaped'), 'https://manual.limesurvey.org/Data_encryption#Errors'));
142 } else {
143 return $plaintext;
144 }
#2
– /opt/bitnami/apps/limesurvey/htdocs/application/models/LSActiveRecord.php(355): LSSodium->decrypt("v8JqaG6pvxHkn6mMmHUFUh0P70DyhIx1CoE32g==")
350 {
351 // if $value is provided, it would decrypt
352 if (!empty($value)) {
353 // load sodium library
354 $sodium = Yii::app()->sodium;
355 return $sodium->decrypt($value);
356 }
357 return '';
358 }
359
360 /
#3
- /opt/bitnami/apps/limesurvey/htdocs/application/core/LimeMailer.php(131): LSActiveRecord::decryptSingle("v8JqaG6pvxHkn6mMmHUFUh0P70DyhIx1CoE32g==")
#4
- /opt/bitnami/apps/limesurvey/htdocs/application/core/LimeMailer.php(230): LimeMailer->__construct()
#5
- /opt/bitnami/apps/limesurvey/htdocs/application/helpers/frontend_helper.php(455): LimeMailer::getInstance(2)
#6
- /opt/bitnami/apps/limesurvey/htdocs/application/helpers/SurveyRuntimeHelper.php(1244): sendSubmitNotifications("474593")
#7
- /opt/bitnami/apps/limesurvey/htdocs/application/helpers/SurveyRuntimeHelper.php(217): SurveyRuntimeHelper->moveSubmitIfNeeded()
#8
- /opt/bitnami/apps/limesurvey/htdocs/application/controllers/survey/index.php(610): SurveyRuntimeHelper->run("474593", array("surveyid" => "474593", "thissurvey" => array("htmlemail" => "Y", "format" => "G", "tokenencryptionoptions" => "{ "enabled":"Y","columns":{ "firstname":"N","lastname":"N","emai...", "template" => "PP_bootswatch", ...), "thisstep" => "6", "tokensexist" => 0, ...))
#9
- /opt/bitnami/apps/limesurvey/htdocs/application/controllers/survey/index.php(26): index->action()
#10
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/actions/CAction.php(76): index->run()
#11
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/CController.php(308): CAction->runWithParams(array("sid" => "474593"))
#12
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/CController.php(286): CController->runAction(index)
#13
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/CController.php(265): CController->runActionWithFilters(index, array())
#14
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/CWebApplication.php(282): CController->run("index")
#15
- /opt/bitnami/apps/limesurvey/htdocs/framework/web/CWebApplication.php(141): CWebApplication->runController("survey/index/sid/474593")
#16
- /opt/bitnami/apps/limesurvey/htdocs/framework/base/CApplication.php(185): CWebApplication->processRequest()
#17
- /opt/bitnami/apps/limesurvey/htdocs/index.php(192): CApplication->run()
2021-11-16 06:48:31 Apache Yii Framework/1.1.24-dev
Profiling Summary Report (Time: 0.16901s, Memory: 8,311KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14547', :code='5') 22 0.00450 0.00020 0.00019 0.00025
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14549', :code='5') 22 0.00425 0.00019 0.00019 0.00021
system.db.CDbCommand.query(SELECT FROM lime_surveys_groups t WHERE t.gsid=1 LIMIT 1) 22 0.00411 0.00019 0.00018 0.00022
system.db.CDbCommand.execute(UPDATE lime_survey_474593 SET id=:yp0, submitdate=:yp1, lastpage=:yp2, startlanguage=:yp3, seed=:yp4, startdate=:yp5, datestamp=:yp6, refurl=:yp7, 474593X1141X14547Q1=:yp8, 474593X1141X14547Q2=:yp9, 474593X1141X14547Q3=:yp10, 474593X1141X14547Q4=:yp11, 474593X1141X14547Q5=:yp12, 474593X1141X14547Q6=:yp13, 474593X1141X14547Q7=:yp14, 474593X1141X14547Q8=:yp15, 474593X1141X14547Q9=:yp16, 474593X1141X14547Q10=:yp17, 474593X1141X14547Q11=:yp18, 474593X1141X14548Q12=:yp19, 474593X1141X14548Q13=:yp20, 474593X1141X14548Q14=:yp21, 474593X1141X14548Q15=:yp22, 474593X1142X14549Q16=:yp23, 474593X1142X14549Q17=:yp24, 474593X1142X14549Q18=:yp25, 474593X1142X14549Q19=:yp26, 474593X1142X14549Q20=:yp27, 474593X1142X14549Q21=:yp28, 474593X1142X14549Q22=:yp29, 474593X1142X14549Q23=:yp30, 474593X1142X14549Q24=:yp31, 474593X1142X14549Q25=:yp32, 474593X1142X14549Q26=:yp33, 474593X1142X14550Q27=:yp34, 474593X1142X14550Q28=:yp35, 474593X1142X14550Q29=:yp36, 474593X1142X14550Q30=:yp37, 474593X1151X14576=:yp38, 474593X1151X14577=:yp39, 474593X1151X14578=:yp40, 474593X1151X14579=:yp41, 474593X1151X14580=:yp42, 474593X1151X14581=:yp43, 474593X1143X14551A1=:yp44, 474593X1143X14551A2=:yp45, 474593X1143X14551A3=:yp46, 474593X1143X14552A1=:yp47, 474593X1143X14553A1=:yp48, 474593X1143X14553A2=:yp49, 474593X1143X14554A1=:yp50, 474593X1143X14554A2=:yp51, 474593X1143X14554A3=:yp52, 474593X1143X14574A1=:yp53, 474593X1143X14574A2=:yp54, 474593X1143X14574A3=:yp55, 474593X1143X14575A1=:yp56, 474593X1143X14575A2=:yp57, 474593X1140X14543=:yp58, 474593X1140X14539=:yp59, 474593X1140X14542=:yp60, 474593X1140X14541=:yp61, 474593X1140X14538=:yp62, 474593X1140X14540=:yp63, 474593X1150X14545=:yp64, 474593X1150X14544=:yp65, 474593X1150X14546SQ01=:yp66, 474593X1150X14555=:yp67, 474593X1150X14659=:yp68 WHERE lime_survey_474593.id=42. Bound with :yp0=42, :yp1=NULL, :yp2=6, :yp3='en', :yp4='95995297', :yp5='2021-11-16 06:47:18', :yp6='2021-11-16 06:48:31', :yp7=NULL, :yp8='5', :yp9='5', :yp10='5', :yp11='5', :yp12='5', :yp13='5', :yp14='5', :yp15='5', :yp16='5', :yp17='5', :yp18='5', :yp19='1', :yp20='1', :yp21='1', :yp22='1', :yp23='5', :yp24='5', :yp25='5', :yp26='5', :yp27='5', :yp28='5', :yp29='5', :yp30='5', :yp31='5', :yp32='5', :yp33='5', :yp34='1', :yp35='1', :yp36='1', :yp37='1', :yp38='2', :yp39='2', :yp40='-2', :yp41='-2', :yp42='0.093333333333333', :yp43='0.073333333333333', :yp44='A7', :yp45='A7', :yp46='A7', :yp47='A7', :yp48='A7', :yp49='A7', :yp50='A7', :yp51='A7', :yp52='A7', :yp53='A7', :yp54='A7', :yp55='A7', :yp56='A7', :yp57='A7', :yp58='A4', :yp59='56.0000000000', :yp60='A4', :yp61='A3', :yp62='A3', :yp63='A5', :yp64='Kbcgg', :yp65='Dqzjn@gmail.com', :yp66='Y', :yp67='', :yp68='') 1 0.00312 0.00312 0.00312 0.00312
system.db.CDbCommand.execute(UPDATE lime_survey_474593 SET submitdate=:yp0 WHERE lime_survey_474593.id=42. Bound with :yp0='2021-11-16 06:48:31') 1 0.00262 0.00262 0.00262 0.00262
system.db.CDbCommand.execute(UPDATE lime_survey_474593_timings SET interviewtime = (CASE WHEN interviewtime IS NULL THEN 0 ELSE interviewtime END) + 41.12,474593X1150time = (CASE WHEN 474593X1150time IS NULL THEN 0 ELSE 474593X1150time END) + 41.12 WHERE id = 42) 1 0.00242 0.00242 0.00242 0.00242
system.db.CDbCommand.query(SELECT FROM lime_saved_control t WHERE (srid=:srid) AND (sid=:sid) LIMIT 1. Bound with :srid='42', :sid='474593') 1 0.00241 0.00241 0.00241 0.00241
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_survey_474593) 1 0.00227 0.00227 0.00227 0.00227
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys) 1 0.00221 0.00221 0.00221 0.00221
system.db.CDbCommand.query(SHOW TABLES) 1 0.00213 0.00213 0.00213 0.00213
system.db.CDbCommand.query(SELECT FROM lime_assessments t WHERE sid = :sid and language = :language ORDER BY scope,id. Bound with :sid='474593', :language='en') 1 0.00187 0.00187 0.00187 0.00187
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_groupsettings) 1 0.00175 0.00175 0.00175 0.00175
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='PP_bootswatch') 7 0.00170 0.00024 0.00023 0.00026
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14548', :code='1') 8 0.00163 0.00020 0.00019 0.00027
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14550', :code='1') 8 0.00157 0.00020 0.00019 0.00022
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_survey_474593_timings) 1 0.00152 0.00152 0.00152 0.00152
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) 4 0.00142 0.00035 0.00034 0.00037
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.ipanonymize AS t0_c17, t.refurl AS t0_c18, t.showsurveypolicynotice AS t0_c19, t.publicstatistics AS t0_c20, t.publicgraphs AS t0_c21, t.listpublic AS t0_c22, t.htmlemail AS t0_c23, t.sendconfirmation AS t0_c24, t.tokenanswerspersistence AS t0_c25, t.assessments AS t0_c26, t.usecaptcha AS t0_c27, t.bounce_email AS t0_c28, t.attributedescriptions AS t0_c29, t.emailresponseto AS t0_c30, t.emailnotificationto AS t0_c31, t.tokenlength AS t0_c32, t.showxquestions AS t0_c33, t.showgroupinfo AS t0_c34, t.shownoanswer AS t0_c35, t.showqnumcode AS t0_c36, t.showwelcome AS t0_c37, t.showprogress AS t0_c38, t.questionindex AS t0_c39, t.navigationdelay AS t0_c40, t.nokeyboard AS t0_c41, t.alloweditaftercompletion 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)) 4 0.00141 0.00035 0.00034 0.00037
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_languagesettings) 1 0.00139 0.00139 0.00139 0.00139
system.db.CDbCommand.query(SELECT FROM lime_surveys_groupsettings t WHERE t.gsid=0 LIMIT 1) 4 0.00132 0.00033 0.00021 0.00064
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_question_themes) 1 0.00130 0.00130 0.00130 0.00130
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_settings_global) 1 0.00126 0.00126 0.00126 0.00126
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') 5 0.00124 0.00025 0.00024 0.00025
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_users) 1 0.00122 0.00122 0.00122 0.00122
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') 5 0.00119 0.00024 0.00023 0.00025
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14574', :code='A7') 6 0.00119 0.00020 0.00019 0.00022
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_templates) 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14554', :code='A7') 6 0.00118 0.00020 0.00019 0.00021
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_questions) 1 0.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14551', :code='A7') 6 0.00116 0.00019 0.00019 0.00020
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_template_configuration) 1 0.00114 0.00114 0.00114 0.00114
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_question_attributes) 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_surveys_groups) 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_permissions) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_saved_control) 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_groups) 1 0.00105 0.00105 0.00105 0.00105
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_assessments) 1 0.00105 0.00105 0.00105 0.00105
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_plugins) 1 0.00103 0.00103 0.00103 0.00103
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_quota_languagesettings) 1 0.00101 0.00101 0.00101 0.00101
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') 4 0.00098 0.00024 0.00023 0.00027
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_quota) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_answers) 1 0.00097 0.00097 0.00097 0.00097
system.db.CDbCommand.query(SHOW FULL COLUMNS FROM lime_quota_members) 1 0.00095 0.00095 0.00095 0.00095
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, 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.faxto AS t1_c9, survey.format AS t1_c10, survey.savetimings AS t1_c11, survey.template AS t1_c12, survey.language AS t1_c13, survey.additional_languages AS t1_c14, survey.datestamp AS t1_c15, survey.usecookie AS t1_c16, survey.allowregister AS t1_c17, survey.allowsave AS t1_c18, survey.autonumber_start AS t1_c19, survey.autoredirect AS t1_c20, survey.allowprev AS t1_c21, survey.printanswers AS t1_c22, survey.ipaddr AS t1_c23, survey.ipanonymize AS t1_c24, survey.refurl AS t1_c25, survey.datecreated AS t1_c26, survey.showsurveypolicynotice AS t1_c27, survey.publicstatistics AS t1_c28, survey.publicgraphs AS t1_c29, survey.listpublic AS t1_c30, survey.htmlemail AS t1_c31, survey.sendconfirmation AS t1_c32, survey.tokenanswerspersistence AS t1_c33, survey.assessments AS t1_c34, survey.usecaptcha AS t1_c35, survey.usetokens AS t1_c36, survey.bounce_email AS t1_c37, survey.attributedescriptions AS t1_c38, survey.emailresponseto AS t1_c39, survey.emailnotificationto AS t1_c40, survey.tokenlength AS t1_c41, survey.showxquestions AS t1_c42, survey.showgroupinfo AS t1_c43, survey.shownoanswer AS t1_c44, survey.showqnumcode AS t1_c45, survey.bouncetime AS t1_c46, survey.bounceprocessing AS t1_c47, survey.bounceaccounttype AS t1_c48, survey.bounceaccounthost AS t1_c49, survey.bounceaccountpass AS t1_c50, survey.bounceaccountencryption AS t1_c51, survey.bounceaccountuser AS t1_c52, survey.showwelcome AS t1_c53, survey.showprogress AS t1_c54, survey.questionindex AS t1_c55, survey.navigationdelay AS t1_c56, survey.nokeyboard AS t1_c57, survey.alloweditaftercompletion AS t1_c58, survey.googleanalyticsstyle AS t1_c59, survey.googleanalyticsapikey AS t1_c60, survey.tokenencryptionoptions AS t1_c61 FROM lime_surveys_languagesettings t LEFT OUTER JOIN lime_surveys survey ON (t.surveyls_survey_id = survey.sid) WHERE (t.surveyls_survey_id=474593 AND t.surveyls_language='en')) 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT FROM lime_users t WHERE t.uid=1 LIMIT 1) 4 0.00081 0.00020 0.00019 0.00022
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14553', :code='A7') 4 0.00080 0.00020 0.00019 0.00022
system.db.CDbCommand.query(SELECT COUNT() FROM lime_questions t WHERE t.sid=:yp0 AND t.parent_qid=:yp1. Bound with :yp0='474593', :yp1=0) 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14575', :code='A7') 4 0.00077 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_assessments) 1 0.00074 0.00074 0.00074 0.00074
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 =474593 and qid is not null) 2 0.00073 0.00036 0.00033 0.00040
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.faxto AS t1_c9, survey.format AS t1_c10, survey.savetimings AS t1_c11, survey.template AS t1_c12, survey.language AS t1_c13, survey.additional_languages AS t1_c14, survey.datestamp AS t1_c15, survey.usecookie AS t1_c16, survey.allowregister AS t1_c17, survey.allowsave AS t1_c18, survey.autonumber_start AS t1_c19, survey.autoredirect AS t1_c20, survey.allowprev AS t1_c21, survey.printanswers AS t1_c22, survey.ipaddr AS t1_c23, survey.ipanonymize AS t1_c24, survey.refurl AS t1_c25, survey.datecreated AS t1_c26, survey.showsurveypolicynotice AS t1_c27, survey.publicstatistics AS t1_c28, survey.publicgraphs AS t1_c29, survey.listpublic AS t1_c30, survey.htmlemail AS t1_c31, survey.sendconfirmation AS t1_c32, survey.tokenanswerspersistence AS t1_c33, survey.assessments AS t1_c34, survey.usecaptcha AS t1_c35, survey.usetokens AS t1_c36, survey.bounce_email AS t1_c37, survey.attributedescriptions AS t1_c38, survey.emailresponseto AS t1_c39, survey.emailnotificationto AS t1_c40, survey.tokenlength AS t1_c41, survey.showxquestions AS t1_c42, survey.showgroupinfo AS t1_c43, survey.shownoanswer AS t1_c44, survey.showqnumcode AS t1_c45, survey.bouncetime AS t1_c46, survey.bounceprocessing AS t1_c47, survey.bounceaccounttype AS t1_c48, survey.bounceaccounthost AS t1_c49, survey.bounceaccountpass AS t1_c50, survey.bounceaccountencryption AS t1_c51, survey.bounceaccountuser AS t1_c52, survey.showwelcome AS t1_c53, survey.showprogress AS t1_c54, survey.questionindex AS t1_c55, survey.navigationdelay AS t1_c56, survey.nokeyboard AS t1_c57, survey.alloweditaftercompletion AS t1_c58, survey.googleanalyticsstyle AS t1_c59, survey.googleanalyticsapikey AS t1_c60, survey.tokenencryptionoptions AS t1_c61 FROM lime_surveys survey WHERE (survey.sid=:ypl0). Bound with :ypl0='474593') 2 0.00072 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT FROM lime_survey_474593 t WHERE t.id=42 LIMIT 1) 2 0.00059 0.00029 0.00024 0.00035
system.db.CDbCommand.query(SELECT FROM lime_question_attributes t WHERE qid=:qid. Bound with :qid='14546') 2 0.00055 0.00027 0.00027 0.00028
system.db.CDbCommand.query(SELECT t.id AS t0_c0, t.sid AS t0_c1, t.name AS t0_c2, t.qlimit AS t0_c3, t.action AS t0_c4, t.active AS t0_c5, t.autoload_url AS t0_c6, languagesettings.quotals_id AS t1_c0, languagesettings.quotals_quota_id AS t1_c1, languagesettings.quotals_language AS t1_c2, languagesettings.quotals_name AS t1_c3, languagesettings.quotals_message AS t1_c4, languagesettings.quotals_url AS t1_c5, languagesettings.quotals_urldescrip AS t1_c6, quotaMembers.id AS t2_c0, quotaMembers.sid AS t2_c1, quotaMembers.qid AS t2_c2, quotaMembers.quota_id AS t2_c3, quotaMembers.code AS t2_c4, question.qid AS t3_c0, question.parent_qid AS t3_c1, question.sid AS t3_c2, question.gid AS t3_c3, question.type AS t3_c4, question.title AS t3_c5, question.preg AS t3_c6, question.other AS t3_c7, question.mandatory AS t3_c8, question.encrypted AS t3_c9, question.question_order AS t3_c10, question.scale_id AS t3_c11, question.same_default AS t3_c12, question.relevance AS t3_c13, question.modulename AS t3_c14, question.question_theme_name AS t3_c15 FROM lime_quota t LEFT OUTER JOIN lime_quota_languagesettings languagesettings ON (languagesettings.quotals_quota_id=t.id) LEFT OUTER JOIN lime_quota_members quotaMembers ON (quotaMembers.quota_id=t.id) LEFT OUTER JOIN lime_questions question ON (quotaMembers.qid=question.qid) WHERE (t.sid=:yp0). Bound with :yp0='474593') 1 0.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT FROM lime_question_themes t WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multiplechoice', :extends='M') 2 0.00052 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT FROM lime_question_themes t WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='M', :extends='') 2 0.00050 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t.name='vanilla' LIMIT 1) 2 0.00046 0.00023 0.00022 0.00024
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t.name='bootswatch' LIMIT 1) 2 0.00042 0.00021 0.00021 0.00022
system.db.CDbCommand.query(SELECT FROM lime_templates t WHERE t.name='PP_bootswatch' LIMIT 1) 2 0.00042 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT FROM lime_questions t WHERE qid=:qid LIMIT 1. Bound with :qid=14546) 2 0.00040 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14541', :code='A3') 2 0.00039 0.00019 0.00019 0.00020
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14540', :code='A5') 2 0.00039 0.00019 0.00019 0.00020
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14543', :code='A4') 2 0.00039 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_survey_474593) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14538', :code='A3') 2 0.00038 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14542', :code='A4') 2 0.00038 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT code,assessment_value FROM lime_answers t WHERE qid = :qid and code = :code LIMIT 1. Bound with :qid='14552', :code='A7') 2 0.00038 0.00019 0.00019 0.00019
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='bootswatch') 1 0.00034 0.00034 0.00034 0.00034
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys) 1 0.00030 0.00030 0.00030 0.00030
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.00030 0.00030 0.00030 0.00030
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='474593', :template_name='PP_bootswatch') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT FROM lime_settings_global t) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT FROM lime_surveys t WHERE t.sid=474593 LIMIT 1) 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_groupsettings) 1 0.00026 0.00026 0.00026 0.00026
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='PP_bootswatch') 1 0.00025 0.00025 0.00025 0.00025
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='PP_bootswatch') 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.last_login AS t1_c12, owner.created AS t1_c13, owner.modified AS t1_c14, owner.validation_key AS t1_c15, owner.validation_key_expiration AS t1_c16, owner.last_forgot_email_password AS t1_c17 FROM lime_users owner WHERE (owner.uid=:ypl0). Bound with :ypl0='1') 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT FROM lime_plugins t WHERE t.active=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SHOW CREATE TABLE lime_survey_474593_timings) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_languagesettings) 1 0.00022 0.00022 0.00022 0.00022
system.db.CDbCommand.query(SHOW CREATE TABLE lime_question_themes) 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.00020 0.00020 0.00020 0.00020
system.db.CDbCommand.query(SHOW CREATE TABLE lime_template_configuration) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_questions) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_templates) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_settings_global) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_users) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_quota) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SHOW CREATE TABLE lime_permissions) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE lime_question_attributes) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE lime_saved_control) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE lime_plugins) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE lime_surveys_groups) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SHOW CREATE TABLE lime_groups) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE lime_quota_languagesettings) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE lime_answers) 1 0.00017 0.00017 0.00017 0.00017
system.db.CDbCommand.query(SHOW CREATE TABLE lime_quota_members)
|
