PHP notice

Undefined variable: iSurveyId

/usr/share/nginx/html/lsurveymaster/application/controllers/admin/surveyadmin.php(1058)

1046 
1047             $aData['questions'] = $oResult;
1048             $aData['display']['menu_bars']['surveysummary'] = "editsurveysettings";
1049             $tempData = $aData;
1050             $aData['settings_data'] = $tempData;
1051 
1052             $aData['sidemenu']['state'] = false;
1053             $surveyinfo = Survey::model()->findByPk($iSurveyID)->surveyinfo;
1054             $aData['title_bar']['title'] = $surveyinfo['surveyls_title']."(".gT("ID").":".$iSurveyID.")";
1055 
1056             $aData['surveybar']['savebutton']['form'] = 'globalsetting';
1057             $aData['surveybar']['savebutton']['useformid'] = 'true';
1058             if (Permission::model()->hasSurveyPermission($iSurveyId, 'surveycontent', 'update'))
1059             {
1060                 $aData['surveybar']['saveandclosebutton']['form'] = true;
1061             }
1062             else
1063             {
1064                 unset($aData['surveybar']['savebutton']['form']);
1065             }
1066 
1067             $aData['surveybar']['closebutton']['url'] = 'admin/survey/sa/view/surveyid/'.$iSurveyID;  // Close button
1068 
1069             $aViewUrls[] = 'editLocalSettings_main_view';
1070         }

Stack Trace

#2
+
 /usr/share/nginx/html/lsurveymaster/application/core/Survey_Common_Action.php(101): CAction->runWithParamsInternal(SurveyAdmin, ReflectionMethod, array("q" => "/lsurveymaster/index.php/admin/survey/sa/editlocalsettings/surve...", "surveyid" => "821877", "sa" => "editlocalsettings", "iSurveyId" => "821877", ...))
096             $oMethod = new ReflectionMethod($this, $sDefault);
097         }
098 
099         // We're all good to go, let's execute it
100         // runWithParamsInternal would automatically get the parameters of the method and populate them as required with the params
101         return parent::runWithParamsInternal($this, $oMethod, $params);
102     }
103 
104     /**
105     * Some functions have different parameters, which are just an alias of the
106     * usual parameters we're getting in the url. This function just populates
#6
+
 /usr/share/nginx/html/lsurveymaster/application/controllers/AdminController.php(161): CController->run("survey")
156                     $this->redirect(array('/admin/authentication/sa/login'));
157                 }
158 
159             }
160 
161             return parent::run($action);
162     }
163 
164     /**
165     * Routes all the actions to their respective places
166     *
#10
+
 /usr/share/nginx/html/lsurveymaster/index.php(211): CApplication->run()
206         die (sprintf('%s should be writable by the webserver (766 or 776).', $runtimePath));
207     }
208 }
209 
210 Yii::$enableIncludePath = false;
211 Yii::createApplication('LSYii_Application', $config)->run();
212 
213 /* End of file index.php */
214 /* Location: ./index.php */
2016-04-19 18:07:17 nginx/1.4.6 Yii Framework/1.1.17
Profiling Summary Report (Time: 0.31795s, Memory: 5,242KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='surveys', :schema='public') 1 0.00270 0.00270 0.00270 0.00270
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='settings_global', :schema='public') 1 0.00263 0.00263 0.00263 0.00263
system.db.CDbCommand.query(SELECT "questions".*, "q"."qid" AS "sqid", "q"."title" AS "sqtitle", "q"."question" AS "sqquestion", "groups".* FROM "questions" LEFT JOIN "questions" "q" ON q.parent_qid = questions.qid AND q.language = questions.language JOIN "groups" ON groups.gid = questions.gid AND questions.language = groups.language WHERE (questions.sid = :iSurveyID AND questions.language = :sLanguage AND questions.parent_qid = 0) AND (questions.type = 'T' OR questions.type = 'Q' OR questions.type = 'T' OR questions.type = 'S'). Bound with :iSurveyID='821877', :sLanguage='en') 1 0.00253 0.00253 0.00253 0.00253
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='surveys_languagesettings', :schema='public') 1 0.00249 0.00249 0.00249 0.00249
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='templates', :schema='public') 1 0.00234 0.00234 0.00234 0.00234
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='permissions', :schema='public') 1 0.00234 0.00234 0.00234 0.00234
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='surveys', :schema='public') 1 0.00232 0.00232 0.00232 0.00232
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='plugins', :schema='public') 1 0.00229 0.00229 0.00229 0.00229
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='questions', :schema='public') 1 0.00229 0.00229 0.00229 0.00229
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='plugin_settings', :schema='public') 1 0.00225 0.00225 0.00225 0.00225
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END AS consrc, contype, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='settings_global', :schema='public') 1 0.00203 0.00203 0.00203 0.00203
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='surveys_languagesettings', :schema='public') 1 0.00196 0.00196 0.00196 0.00196
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_attributecaptions" 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_numberformat" AS "t0_c22", "t"."attachments" AS "t0_c23", "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"."sendconfirmation" AS "t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30", "survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32", "survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34", "survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS "t1_c36", "survey"."emailnotificationto" AS "t1_c37", "survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39", "survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41", "survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43", "survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS "t1_c45", "survey"."bounceaccounthost" AS "t1_c46", "survey"."bounceaccountpass" AS "t1_c47", "survey"."bounceaccountencryption" AS "t1_c48", "survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS "t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS "t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS "t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55", "survey"."googleanalyticsstyle" AS "t1_c56", "survey"."googleanalyticsapikey" AS "t1_c57" FROM "surveys_languagesettings" "t" LEFT OUTER JOIN "surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=821877 AND "t"."surveyls_language"='en')) 1 0.00187 0.00187 0.00187 0.00187
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='questions', :schema='public') 1 0.00175 0.00175 0.00175 0.00175
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='permissions', :schema='public') 1 0.00157 0.00157 0.00157 0.00157
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='plugins', :schema='public') 1 0.00154 0.00154 0.00154 0.00154
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='templates', :schema='public') 1 0.00152 0.00152 0.00152 0.00152
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='plugin_settings', :schema='public') 1 0.00140 0.00140 0.00140 0.00140
system.db.CDbCommand.query(SELECT "t"."sid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."active" AS "t0_c3", "t"."expires" AS "t0_c4", "t"."startdate" AS "t0_c5", "t"."adminemail" AS "t0_c6", "t"."anonymized" AS "t0_c7", "t"."faxto" AS "t0_c8", "t"."format" AS "t0_c9", "t"."savetimings" AS "t0_c10", "t"."template" AS "t0_c11", "t"."language" AS "t0_c12", "t"."additional_languages" AS "t0_c13", "t"."datestamp" AS "t0_c14", "t"."usecookie" AS "t0_c15", "t"."allowregister" AS "t0_c16", "t"."allowsave" AS "t0_c17", "t"."autonumber_start" AS "t0_c18", "t"."autoredirect" AS "t0_c19", "t"."allowprev" AS "t0_c20", "t"."printanswers" AS "t0_c21", "t"."ipaddr" AS "t0_c22", "t"."refurl" AS "t0_c23", "t"."datecreated" AS "t0_c24", "t"."publicstatistics" AS "t0_c25", "t"."publicgraphs" AS "t0_c26", "t"."listpublic" AS "t0_c27", "t"."htmlemail" AS "t0_c28", "t"."sendconfirmation" AS "t0_c29", "t"."tokenanswerspersistence" AS "t0_c30", "t"."assessments" AS "t0_c31", "t"."usecaptcha" AS "t0_c32", "t"."usetokens" AS "t0_c33", "t"."bounce_email" AS "t0_c34", "t"."attributedescriptions" AS "t0_c35", "t"."emailresponseto" AS "t0_c36", "t"."emailnotificationto" AS "t0_c37", "t"."tokenlength" AS "t0_c38", "t"."showxquestions" AS "t0_c39", "t"."showgroupinfo" AS "t0_c40", "t"."shownoanswer" AS "t0_c41", "t"."showqnumcode" AS "t0_c42", "t"."bouncetime" AS "t0_c43", "t"."bounceprocessing" AS "t0_c44", "t"."bounceaccounttype" AS "t0_c45", "t"."bounceaccounthost" AS "t0_c46", "t"."bounceaccountpass" AS "t0_c47", "t"."bounceaccountencryption" AS "t0_c48", "t"."bounceaccountuser" AS "t0_c49", "t"."showwelcome" AS "t0_c50", "t"."showprogress" AS "t0_c51", "t"."questionindex" AS "t0_c52", "t"."navigationdelay" AS "t0_c53", "t"."nokeyboard" AS "t0_c54", "t"."alloweditaftercompletion" AS "t0_c55", "t"."googleanalyticsstyle" AS "t0_c56", "t"."googleanalyticsapikey" AS "t0_c57", "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_url" AS "t1_c6", "languagesettings"."surveyls_urldescription" AS "t1_c7", "languagesettings"."surveyls_email_invite_subj" AS "t1_c8", "languagesettings"."surveyls_email_invite" AS "t1_c9", "languagesettings"."surveyls_email_remind_subj" AS "t1_c10", "languagesettings"."surveyls_email_remind" AS "t1_c11", "languagesettings"."surveyls_email_register_subj" AS "t1_c12", "languagesettings"."surveyls_email_register" AS "t1_c13", "languagesettings"."surveyls_email_confirm_subj" AS "t1_c14", "languagesettings"."surveyls_email_confirm" AS "t1_c15", "languagesettings"."surveyls_dateformat" AS "t1_c16", "languagesettings"."surveyls_attributecaptions" AS "t1_c17", "languagesettings"."email_admin_notification_subj" AS "t1_c18", "languagesettings"."email_admin_notification" AS "t1_c19", "languagesettings"."email_admin_responses_subj" AS "t1_c20", "languagesettings"."email_admin_responses" AS "t1_c21", "languagesettings"."surveyls_numberformat" AS "t1_c22", "languagesettings"."attachments" AS "t1_c23" FROM "surveys" "t" LEFT OUTER JOIN "surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (sid = :surveyid) AND (surveyls_language=language). Bound with :surveyid=821877) 1 0.00139 0.00139 0.00139 0.00139
system.db.CDbCommand.query(SELECT * FROM "surveys" "t" WHERE "t"."sid"=821877 LIMIT 1) 1 0.00127 0.00127 0.00127 0.00127
system.db.CDbCommand.query(SELECT * FROM "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.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SELECT * FROM users ORDER BY uid) 1 0.00112 0.00112 0.00112 0.00112
system.db.CDbCommand.query(SELECT * FROM "surveys_languagesettings" "t" WHERE "t"."surveyls_survey_id"=821877 AND "t"."surveyls_language"='en' LIMIT 1) 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.query(SELECT * FROM "settings_global" "t") 1 0.00085 0.00085 0.00085 0.00085
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1, 2). Bound with :table='surveys_languagesettings', :schema='public') 1 0.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT "defaultlanguage"."surveyls_survey_id" AS "t1_c0", "defaultlanguage"."surveyls_language" AS "t1_c1", "defaultlanguage"."surveyls_title" AS "t1_c2", "defaultlanguage"."surveyls_description" AS "t1_c3", "defaultlanguage"."surveyls_welcometext" AS "t1_c4", "defaultlanguage"."surveyls_endtext" AS "t1_c5", "defaultlanguage"."surveyls_url" AS "t1_c6", "defaultlanguage"."surveyls_urldescription" AS "t1_c7", "defaultlanguage"."surveyls_email_invite_subj" AS "t1_c8", "defaultlanguage"."surveyls_email_invite" AS "t1_c9", "defaultlanguage"."surveyls_email_remind_subj" AS "t1_c10", "defaultlanguage"."surveyls_email_remind" AS "t1_c11", "defaultlanguage"."surveyls_email_register_subj" AS "t1_c12", "defaultlanguage"."surveyls_email_register" AS "t1_c13", "defaultlanguage"."surveyls_email_confirm_subj" AS "t1_c14", "defaultlanguage"."surveyls_email_confirm" AS "t1_c15", "defaultlanguage"."surveyls_dateformat" AS "t1_c16", "defaultlanguage"."surveyls_attributecaptions" AS "t1_c17", "defaultlanguage"."email_admin_notification_subj" AS "t1_c18", "defaultlanguage"."email_admin_notification" AS "t1_c19", "defaultlanguage"."email_admin_responses_subj" AS "t1_c20", "defaultlanguage"."email_admin_responses" AS "t1_c21", "defaultlanguage"."surveyls_numberformat" AS "t1_c22", "defaultlanguage"."attachments" AS "t1_c23" FROM "surveys_languagesettings" "defaultlanguage" WHERE ("defaultlanguage"."surveyls_language"=:ypl0) AND ("defaultlanguage"."surveyls_survey_id"=:ypl1). Bound with :ypl0='en', :ypl1=821877) 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1, 13). Bound with :table='questions', :schema='public') 1 0.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT * FROM "plugin_settings" "t" WHERE "t"."plugin_id"=:yp0 AND "t"."model"=:yp1 AND "t"."model_id"=:yp2 AND "t"."key"=:yp3. Bound with :yp0=2, :yp1='Survey', :yp2='821877', :yp3='auditing') 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='permissions', :schema='public') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='plugins', :schema='public') 1 0.00065 0.00065 0.00065 0.00065
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='plugin_settings', :schema='public') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='surveys', :schema='public') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='templates', :schema='public') 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT * FROM "plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1) 1 0.00058 0.00058 0.00058 0.00058
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='settings_global', :schema='public') 1 0.00043 0.00043 0.00043 0.00043