Caution: JavaScript execution is disabled in your browser or for this website. You may not be able to answer all questions in this survey. Please, verify your browser parameters.
LimeSurvey
The following surveys are available:
Please contact ISST Limesurvey ( iti@isst.fraunhofer.de ) for further assistance.
LimeSurvey Survey Software
The Online Survey Tool - Free & Open Source
Online Surveytool
Profiling Summary Report (Time: 0.09385s, Memory: 6,515KB)
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, pg_get_expr(adbin, adrelid) AS 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.00315 0.00315 0.00315 0.00315
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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.00222 0.00222 0.00222 0.00222
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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.00101 0.00101 0.00101 0.00101
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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.00111 0.00111 0.00111 0.00111
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='fruity_twentythree' LIMIT 1) 2 0.00058 0.00029 0.00020 0.00038
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.00049 0.00049 0.00049 0.00049
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_templates', :schema='public') 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t") 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_templates', :schema='public') 1 0.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_template_configuration', :schema='public') 1 0.00062 0.00062 0.00062 0.00062
system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00041 0.00041 0.00041 0.00041
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_templates', :schema='public') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_template_configuration', :schema='public') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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.00074 0.00074 0.00074 0.00074
system.db.CDbCommand.query(SELECT "t1"."message" AS "message", "t2"."translation" AS "translation" FROM "lime_source_message" "t1", "lime_message" "t2" WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='en') 1 0.00042 0.00042 0.00042 0.00042
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.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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.00145 0.00145 0.00145 0.00145
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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.00079 0.00079 0.00079 0.00079
system.db.CDbCommand.query(SELECT * FROM "lime_template_configuration" "t" WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL LIMIT 1. Bound with :template_name='fruity_twentythree') 1 0.00047 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT "t"."template_name" AS "t0_c1", "t"."id" AS "t0_c0", "template"."id" AS "t1_c0", "template"."folder" AS "t1_c2", "template"."name" AS "t1_c1" FROM "lime_template_configuration" "t" LEFT OUTER JOIN "lime_templates" "template" ON ("template"."name"="t"."template_name") WHERE (sid IS NULL AND gsid IS NULL AND template.folder IS NOT NULL)) 1 0.00046 0.00046 0.00046 0.00046
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_template_configuration', :schema='public') 1 0.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT "template"."id" AS "t1_c0", "template"."name" AS "t1_c1", "template"."folder" AS "t1_c2", "template"."title" AS "t1_c3", "template"."creation_date" AS "t1_c4", "template"."author" AS "t1_c5", "template"."author_email" AS "t1_c6", "template"."author_url" AS "t1_c7", "template"."copyright" AS "t1_c8", "template"."license" AS "t1_c9", "template"."version" AS "t1_c10", "template"."api_version" AS "t1_c11", "template"."view_folder" AS "t1_c12", "template"."files_folder" AS "t1_c13", "template"."description" AS "t1_c14", "template"."last_update" AS "t1_c15", "template"."owner_id" AS "t1_c16", "template"."extends" AS "t1_c17" FROM "lime_templates" "template" WHERE ("template"."name"=:ypl0). Bound with :ypl0='fruity_twentythree') 1 0.00025 0.00025 0.00025 0.00025
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.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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.00065 0.00065 0.00065 0.00065
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", "t"."gsid" AS "t0_c58", "t"."showsurveypolicynotice" AS "t0_c59", "t"."tokenencryptionoptions" AS "t0_c60", "t"."ipanonymize" AS "t0_c61", "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", "languagesettings"."surveyls_policy_notice" AS "t1_c24", "languagesettings"."surveyls_policy_error" AS "t1_c25", "languagesettings"."surveyls_policy_notice_label" AS "t1_c26", "languagesettings"."surveyls_alias" AS "t1_c27" FROM "lime_surveys" "t" LEFT OUTER JOIN "lime_surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (((active = 'Y') AND ((startdate <= :now1 OR startdate IS NULL) AND (expires >= :now2 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now1='2025-04-04 03:45:55', :now2='2025-04-04 03:45:55') 1 0.01785 0.01785 0.01785 0.01785
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_groupsettings', :schema='public') 1 0.00184 0.00184 0.00184 0.00184
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_groupsettings', :schema='public') 1 0.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SELECT "t"."gsid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."adminemail" AS "t0_c3", "t"."anonymized" AS "t0_c4", "t"."format" AS "t0_c5", "t"."savetimings" AS "t0_c6", "t"."template" AS "t0_c7", "t"."datestamp" AS "t0_c8", "t"."usecookie" AS "t0_c9", "t"."allowregister" AS "t0_c10", "t"."allowsave" AS "t0_c11", "t"."autonumber_start" AS "t0_c12", "t"."autoredirect" AS "t0_c13", "t"."allowprev" AS "t0_c14", "t"."printanswers" AS "t0_c15", "t"."ipaddr" AS "t0_c16", "t"."refurl" AS "t0_c17", "t"."showsurveypolicynotice" AS "t0_c18", "t"."publicstatistics" AS "t0_c19", "t"."publicgraphs" AS "t0_c20", "t"."listpublic" AS "t0_c21", "t"."htmlemail" AS "t0_c22", "t"."sendconfirmation" AS "t0_c23", "t"."tokenanswerspersistence" AS "t0_c24", "t"."assessments" AS "t0_c25", "t"."usecaptcha" AS "t0_c26", "t"."bounce_email" AS "t0_c27", "t"."attributedescriptions" AS "t0_c28", "t"."emailresponseto" AS "t0_c29", "t"."emailnotificationto" AS "t0_c30", "t"."tokenlength" AS "t0_c31", "t"."showxquestions" AS "t0_c32", "t"."showgroupinfo" AS "t0_c33", "t"."shownoanswer" AS "t0_c34", "t"."showqnumcode" AS "t0_c35", "t"."showwelcome" AS "t0_c36", "t"."showprogress" AS "t0_c37", "t"."questionindex" AS "t0_c38", "t"."navigationdelay" AS "t0_c39", "t"."nokeyboard" AS "t0_c40", "t"."alloweditaftercompletion" AS "t0_c41", "t"."ipanonymize" AS "t0_c42", "SurveysGroups"."gsid" AS "t1_c0", "SurveysGroups"."name" AS "t1_c1", "SurveysGroups"."title" AS "t1_c2", "SurveysGroups"."description" AS "t1_c3", "SurveysGroups"."sortorder" AS "t1_c4", "SurveysGroups"."owner_id" AS "t1_c5", "SurveysGroups"."parent_id" AS "t1_c6", "SurveysGroups"."created" AS "t1_c7", "SurveysGroups"."modified" AS "t1_c8", "SurveysGroups"."created_by" AS "t1_c9", "SurveysGroups"."template" 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)) 1 0.00091 0.00091 0.00091 0.00091
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_groups', :schema='public') 1 0.00090 0.00090 0.00090 0.00090
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_users', :schema='public') 1 0.00087 0.00087 0.00087 0.00087
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_users', :schema='public') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_groups', :schema='public') 1 0.00076 0.00076 0.00076 0.00076
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_groupsettings', :schema='public') 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='lime_surveys_groups', :schema='public') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=32 LIMIT 1) 1 0.00040 0.00040 0.00040 0.00040
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_users', :schema='public') 1 0.00028 0.00028 0.00028 0.00028
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.00026 0.00026 0.00026 0.00026
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, 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_asset_version', :schema='public') 1 0.00096 0.00096 0.00096 0.00096
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS 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_asset_version', :schema='public') 1 0.00085 0.00085 0.00085 0.00085
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", "t"."gsid" AS "t0_c58", "t"."showsurveypolicynotice" AS "t0_c59", "t"."tokenencryptionoptions" AS "t0_c60", "t"."ipanonymize" AS "t0_c61", "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", "languagesettings"."surveyls_policy_notice" AS "t1_c24", "languagesettings"."surveyls_policy_error" AS "t1_c25", "languagesettings"."surveyls_policy_notice_label" AS "t1_c26", "languagesettings"."surveyls_alias" AS "t1_c27" FROM "lime_surveys" "t" LEFT OUTER JOIN "lime_surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (((active = 'Y') AND (allowregister = 'Y' AND startdate > :now3 AND (expires < :now4 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now3='2025-04-04 03:45:56', :now4='2025-04-04 03:45:56') 1 0.00075 0.00075 0.00075 0.00075
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_asset_version', :schema='public') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/fruity_twentythree/files/favicon.ico') 1 0.00027 0.00027 0.00027 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groupsettings" "t" WHERE "t"."gsid"=0 LIMIT 1) 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/fruity_twentythree/files/poweredby.png') 1 0.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/node_modules/decimal.js') 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/vendor/yiisoft/yii/framework/web/js/source') 1 0.00012 0.00012 0.00012 0.00012