/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 }
#0 |
unknown(0): SurveyAdmin->editlocalsettings("821877")
|
#1 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/actions/CAction.php(109): ReflectionMethod->invokeArgs(SurveyAdmin, array("821877")) 104 elseif($param->isDefaultValueAvailable()) 105 $ps[]=$param->getDefaultValue(); 106 else 107 return false; 108 } 109 $method->invokeArgs($object,$ps); 110 return true; 111 } 112 } |
#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 |
#3 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(308): Survey_Common_Action->runWithParams(array("q" => "/lsurveymaster/index.php/admin/survey/sa/editlocalsettings/surve...", "surveyid" => "821877", "sa" => "editlocalsettings")) 303 { 304 $priorAction=$this->_action; 305 $this->_action=$action; 306 if($this->beforeAction($action)) 307 { 308 if($action->runWithParams($this->getActionParams())===false) 309 $this->invalidActionParams($action); 310 else 311 $this->afterAction($action); 312 } 313 $this->_action=$priorAction; |
#4 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(286): CController->runAction(SurveyAdmin) 281 * @see runAction 282 */ 283 public function runActionWithFilters($action,$filters) 284 { 285 if(empty($filters)) 286 $this->runAction($action); 287 else 288 { 289 $priorAction=$this->_action; 290 $this->_action=$action; 291 CFilterChain::create($this,$action,$filters)->run(); |
#5 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/CController.php(265): CController->runActionWithFilters(SurveyAdmin, array()) 260 { 261 if(($parent=$this->getModule())===null) 262 $parent=Yii::app(); 263 if($parent->beforeControllerAction($this,$action)) 264 { 265 $this->runActionWithFilters($action,$this->filters()); 266 $parent->afterControllerAction($this,$action); 267 } 268 } 269 else 270 $this->missingAction($actionID); |
#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 * |
#7 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php(282): AdminController->run("survey") 277 { 278 list($controller,$actionID)=$ca; 279 $oldController=$this->_controller; 280 $this->_controller=$controller; 281 $controller->init(); 282 $controller->run($actionID); 283 $this->_controller=$oldController; 284 } 285 else 286 throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".', 287 array('{route}'=>$route===''?$this->defaultController:$route))); |
#8 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/web/CWebApplication.php(141): CWebApplication->runController("admin/survey/sa/editlocalsettings") 136 foreach(array_splice($this->catchAllRequest,1) as $name=>$value) 137 $_GET[$name]=$value; 138 } 139 else 140 $route=$this->getUrlManager()->parseUrl($this->getRequest()); 141 $this->runController($route); 142 } 143 144 /** 145 * Registers the core application components. 146 * This method overrides the parent implementation by registering additional core components. |
#9 |
+
–
/usr/share/nginx/html/lsurveymaster/framework/base/CApplication.php(185): CWebApplication->processRequest() 180 public function run() 181 { 182 if($this->hasEventHandler('onBeginRequest')) 183 $this->onBeginRequest(new CEvent($this)); 184 register_shutdown_function(array($this,'end'),0,false); 185 $this->processRequest(); 186 if($this->hasEventHandler('onEndRequest')) 187 $this->onEndRequest(new CEvent($this)); 188 } 189 190 /** |
#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 */ |
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 |