/usr/share/nginx/html/limesurvey/application/helpers/frontend_helper.php(78)
66 } 67 else 68 { 69 //A match has been found. Let's load the values! 70 //If this is from an email, build surveysession first 71 $_SESSION['survey_'.$surveyid]['LEMtokenResume']=true; 72 73 // If survey come from reload (GET or POST); some value need to be found on saved_control, not on survey 74 if (Yii::app()->request->getParam('loadall') == "reload") 75 { 76 $oSavedSurvey=SavedControl::model()->find("identifier=:identifier AND access_code=:access_code",array(":identifier"=>$sLoadName,":access_code"=>md5($sLoadPass))); 77 // We don't need to control if we have one, because we do the test before 78 $_SESSION['survey_'.$surveyid]['scid'] = $oSavedSurvey->scid; 79 $_SESSION['survey_'.$surveyid]['step'] = ($oSavedSurvey->saved_thisstep>1)?$oSavedSurvey->saved_thisstep:1; 80 $thisstep=$_SESSION['survey_'.$surveyid]['step']-1;// deprecated ? 81 $_SESSION['survey_'.$surveyid]['srid'] = $oSavedSurvey->srid;// Seems OK without 82 $_SESSION['survey_'.$surveyid]['refurl'] = $oSavedSurvey->refurl; 83 } 84 85 // Get if survey is been answered 86 $submitdate=$oResponses->submitdate; 87 $aRow=$oResponses->attributes; 88 foreach ($aRow as $column => $value) 89 { 90 if ($column == "token")
#0 |
+
–
/usr/share/nginx/html/limesurvey/application/controllers/survey/index.php(318): loadanswers() 313 } 314 315 if ($errormsg == "") { 316 LimeExpressionManager::SetDirtyFlag(); 317 buildsurveysession($surveyid); 318 if (loadanswers()){ 319 Yii::app()->setConfig('move','reload'); 320 $move = "reload";// veyRunTimeHelper use $move in $arg 321 } else { 322 $errormsg .= gT("There is no matching saved survey"); 323 } |
#1 |
+
–
/usr/share/nginx/html/limesurvey/application/controllers/survey/index.php(46): index->action() 41 App()->getClientScript()->render($buffer); 42 App()->getClientScript()->reset(); 43 return $buffer; 44 }); 45 ob_implicit_flush(false); 46 $this->action(); 47 ob_flush(); 48 } 49 50 function action() 51 { |
#2 |
+
–
/usr/share/nginx/html/limesurvey/framework/web/actions/CAction.php(76): index->run() 71 { 72 $method=new ReflectionMethod($this, 'run'); 73 if($method->getNumberOfParameters()>0) 74 return $this->runWithParamsInternal($this, $method, $params); 75 else 76 return $this->run(); 77 } 78 79 /** 80 * Executes a method of an object with the supplied named parameters. 81 * This method is internally used. |
#3 |
+
–
/usr/share/nginx/html/limesurvey/framework/web/CController.php(308): CAction->runWithParams(array("q" => "/limesurvey/index.php/993657", "sid" => "993657")) 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/limesurvey/framework/web/CController.php(286): CController->runAction(index) 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/limesurvey/framework/web/CController.php(265): CController->runActionWithFilters(index, 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/limesurvey/framework/web/CWebApplication.php(282): CController->run("index") 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))); |
#7 |
+
–
/usr/share/nginx/html/limesurvey/framework/web/CWebApplication.php(141): CWebApplication->runController("survey/index/sid/993657") 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. |
#8 |
+
–
/usr/share/nginx/html/limesurvey/framework/base/CApplication.php(180): CWebApplication->processRequest() 175 public function run() 176 { 177 if($this->hasEventHandler('onBeginRequest')) 178 $this->onBeginRequest(new CEvent($this)); 179 register_shutdown_function(array($this,'end'),0,false); 180 $this->processRequest(); 181 if($this->hasEventHandler('onEndRequest')) 182 $this->onEndRequest(new CEvent($this)); 183 } 184 185 /** |
#9 |
+
–
/usr/share/nginx/html/limesurvey/index.php(211): CApplication->run() 206 die (sprintf('%s should be writable by the webserver (755 or 775).', $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 (Tiempo: 1.32795s, Memoria: 5,343KB) | |||||
---|---|---|---|---|---|
Procedimiento | Cuenta | Total (es) | Promedio (s) | Min. (s) | Máx. (s) |
system.db.CDbCommand.query(SELECT table_name, table_schema FROM information_schema.tables WHERE table_schema=:schema AND table_type='BASE TABLE'. Bound with :schema='public') | 1 | 0.00955 | 0.00955 | 0.00955 | 0.00955 |
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='lime_surveys', :schema='public') | 1 | 0.00531 | 0.00531 | 0.00531 | 0.00531 |
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='lime_settings_global', :schema='public') | 1 | 0.00519 | 0.00519 | 0.00519 | 0.00519 |
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='lime_surveys', :schema='public') | 1 | 0.00471 | 0.00471 | 0.00471 | 0.00471 |
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='lime_survey_993657', :schema='public') | 1 | 0.00464 | 0.00464 | 0.00464 | 0.00464 |
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='lime_plugins', :schema='public') | 1 | 0.00452 | 0.00452 | 0.00452 | 0.00452 |
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='lime_settings_global', :schema='public') | 1 | 0.00430 | 0.00430 | 0.00430 | 0.00430 |
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 "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=993657 AND "t"."surveyls_language"='es')) | 1 | 0.00403 | 0.00403 | 0.00403 | 0.00403 |
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='lime_surveys_languagesettings', :schema='public') | 1 | 0.00400 | 0.00400 | 0.00400 | 0.00400 |
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='lime_saved_control', :schema='public') | 1 | 0.00379 | 0.00379 | 0.00379 | 0.00379 |
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='lime_survey_url_parameters', :schema='public') | 1 | 0.00378 | 0.00378 | 0.00378 | 0.00378 |
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='lime_surveys_languagesettings', :schema='public') | 1 | 0.00364 | 0.00364 | 0.00364 | 0.00364 |
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='lime_groups', :schema='public') | 1 | 0.00318 | 0.00318 | 0.00318 | 0.00318 |
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='lime_permissions', :schema='public') | 1 | 0.00318 | 0.00318 | 0.00318 | 0.00318 |
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='lime_saved_control', :schema='public') | 1 | 0.00312 | 0.00312 | 0.00312 | 0.00312 |
system.db.CDbCommand.query(SELECT "t"."id", "t"."token", "t"."submitdate", "t"."lastpage", "t"."startlanguage", "t"."993657X10X37", "t"."993657X11X38" FROM "lime_survey_993657" "t" LEFT JOIN lime_saved_control ON t.id=lime_saved_control.srid WHERE ((lime_saved_control.sid=:sid) AND (lime_saved_control.identifier=:identifier)) AND ((lime_saved_control.access_code=:md5_code OR lime_saved_control.access_code=:sha256_code)) LIMIT 1. Bound with :sid='993657', :identifier='alfredo', :md5_code='b1b79eb0bc0a6569bf58dfb2458f6d03', :sha256_code='563803ed2de926fb4ff44cf9307a68a13dfff381a4e3d5ecae4a2d21e3a2829c') | 1 | 0.00283 | 0.00283 | 0.00283 | 0.00283 |
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='lime_plugins', :schema='public') | 1 | 0.00271 | 0.00271 | 0.00271 | 0.00271 |
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='lime_survey_993657', :schema='public') | 1 | 0.00262 | 0.00262 | 0.00262 | 0.00262 |
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='lime_groups', :schema='public') | 1 | 0.00235 | 0.00235 | 0.00235 | 0.00235 |
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'es' AND b.same_default=0 AND b.sid = 993657) | 1 | 0.00233 | 0.00233 | 0.00233 | 0.00233 |
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='lime_survey_url_parameters', :schema='public') | 1 | 0.00218 | 0.00218 | 0.00218 | 0.00218 |
system.db.CDbCommand.query(SELECT * FROM lime_groups WHERE sid=993657 AND language='es' ORDER BY group_order) | 1 | 0.00217 | 0.00217 | 0.00217 | 0.00217 |
system.db.CDbCommand.query(SELECT * FROM lime_questions as questions, lime_groups as groups WHERE questions.gid=groups.gid AND questions.sid=993657 AND questions.language='es' AND questions.parent_qid=0 AND groups.language='es' ORDER BY group_order, question_order) | 1 | 0.00214 | 0.00214 | 0.00214 | 0.00214 |
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='lime_permissions', :schema='public') | 1 | 0.00206 | 0.00206 | 0.00206 | 0.00206 |
system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=993657 LIMIT 1) | 1 | 0.00182 | 0.00182 | 0.00182 | 0.00182 |
system.db.CDbCommand.query(SELECT count(*) FROM lime_groups INNER JOIN lime_questions ON lime_groups.gid = lime_questions.gid WHERE lime_questions.sid=993657 AND lime_groups.language='es' AND lime_questions.language='es' AND lime_questions.parent_qid=0 ) | 1 | 0.00171 | 0.00171 | 0.00171 | 0.00171 |
system.db.CDbCommand.query(SELECT attr.qid, value FROM lime_question_attributes as attr right join lime_questions as quests on attr.qid=quests.qid WHERE attribute='random_group' and value <> '' and sid=993657 GROUP BY attr.qid, value) | 1 | 0.00160 | 0.00160 | 0.00160 | 0.00160 |
system.db.CDbCommand.query(SELECT count(*) FROM lime_questions WHERE type in ('X','*') AND sid=993657 AND language='es' AND parent_qid=0) | 1 | 0.00130 | 0.00130 | 0.00130 | 0.00130 |
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='lime_plugins', :schema='public') | 1 | 0.00128 | 0.00128 | 0.00128 | 0.00128 |
system.db.CDbCommand.query(select '' as act, up.*,q.title, sq.title as sqtitle, q.question, sq.question as sqquestion from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid. Bound with :surveyid='993657') | 1 | 0.00127 | 0.00127 | 0.00127 | 0.00127 |
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, a.defaultvalue FROM lime_defaultvalues as a, lime_questions as b WHERE a.qid = b.qid AND a.language = b.language AND a.language = 'es' AND b.same_default=1 AND b.sid = 993657) | 1 | 0.00126 | 0.00126 | 0.00126 | 0.00126 |
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='lime_surveys_languagesettings', :schema='public') | 1 | 0.00124 | 0.00124 | 0.00124 | 0.00124 |
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='lime_survey_993657', :schema='public') | 1 | 0.00121 | 0.00121 | 0.00121 | 0.00121 |
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t") | 1 | 0.00119 | 0.00119 | 0.00119 | 0.00119 |
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='lime_permissions', :schema='public') | 1 | 0.00117 | 0.00117 | 0.00117 | 0.00117 |
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='lime_surveys', :schema='public') | 1 | 0.00116 | 0.00116 | 0.00116 | 0.00116 |
system.db.CDbCommand.query(SELECT * FROM "lime_groups" "t" WHERE (sid=:ycp0 AND language=:ycp1) AND (randomization_group != ''). Bound with :ycp0='993657', :ycp1='es') | 1 | 0.00111 | 0.00111 | 0.00111 | 0.00111 |
system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0. Bound with :yp0=1) | 1 | 0.00109 | 0.00109 | 0.00109 | 0.00109 |
system.db.CDbCommand.query(select count(*) from lime_groups left join lime_questions on lime_groups.gid=lime_questions.gid where qid is null) | 1 | 0.00108 | 0.00108 | 0.00108 | 0.00108 |
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='lime_survey_url_parameters', :schema='public') | 1 | 0.00106 | 0.00106 | 0.00106 | 0.00106 |
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='lime_saved_control', :schema='public') | 1 | 0.00100 | 0.00100 | 0.00100 | 0.00100 |
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, 6). Bound with :table='lime_groups', :schema='public') | 1 | 0.00095 | 0.00095 | 0.00095 | 0.00095 |
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='lime_settings_global', :schema='public') | 1 | 0.00089 | 0.00089 | 0.00089 | 0.00089 |
system.db.CDbCommand.query(SELECT * FROM "lime_saved_control" "t" WHERE identifier=:identifier AND access_code=:access_code LIMIT 1. Bound with :identifier='alfredo', :access_code='b1b79eb0bc0a6569bf58dfb2458f6d03') | 1 | 0.00067 | 0.00067 | 0.00067 | 0.00067 |