LimeSurvey

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

Change language

The following surveys are available:

Please contact ISST Limesurvey ( iti@isst.fraunhofer.de ) for further assistance.

Profiling Summary Report (Time: 0.10039s, Memory: 6,027KB)
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.00460	0.00460	0.00460	0.00460
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.00338	0.00338	0.00338	0.00338
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.00117	0.00117	0.00117	0.00117
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.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_plugins', :schema='public')	1	0.00091	0.00091	0.00091	0.00091
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')	1	0.00060	0.00060	0.00060	0.00060
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.00041	0.00041	0.00041	0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1)	1	0.00039	0.00039	0.00039	0.00039
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")	1	0.00036	0.00036	0.00036	0.00036
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.00028	0.00028	0.00028	0.00028
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.00174	0.00174	0.00174	0.00174
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.00072	0.00072	0.00072	0.00072
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.00095	0.00095	0.00095	0.00095
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.00070	0.00070	0.00070	0.00070
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.00046	0.00046	0.00046	0.00046
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_template_configuration', :schema='public')	1	0.00028	0.00028	0.00028	0.00028
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.00021	0.00021	0.00021	0.00021
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.00057	0.00057	0.00057	0.00057
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.00094	0.00094	0.00094	0.00094
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.00029	0.00029	0.00029	0.00029
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.00027	0.00027	0.00027	0.00027
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.00073	0.00073	0.00073	0.00073
system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='fruity_twentythree' LIMIT 1)	2	0.00064	0.00032	0.00023	0.00041
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.00091	0.00091	0.00091	0.00091
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-26 05:55:58', :now2='2025-04-26 05:55:58')	1	0.01997	0.01997	0.01997	0.01997
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.00180	0.00180	0.00180	0.00180
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.00115	0.00115	0.00115	0.00115
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.00088	0.00088	0.00088	0.00088
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.00083	0.00083	0.00083	0.00083
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.00076	0.00076	0.00076	0.00076
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.00068	0.00068	0.00068	0.00068
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.00059	0.00059	0.00059	0.00059
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, 2). Bound with :table='lime_surveys_languagesettings', :schema='public')	1	0.00031	0.00031	0.00031	0.00031
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.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). Bound with :table='lime_surveys_groups', :schema='public')	1	0.00027	0.00027	0.00027	0.00027
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.00027	0.00027	0.00027	0.00027
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.00098	0.00098	0.00098	0.00098
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.00081	0.00081	0.00081	0.00081
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-26 05:55:58', :now4='2025-04-26 05:55:58')	1	0.00055	0.00055	0.00055	0.00055
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.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/favicon.ico')	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.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groupsettings" "t" WHERE "t"."gsid"=0 LIMIT 1)	1	0.00020	0.00020	0.00020	0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=46 LIMIT 1)	1	0.00018	0.00018	0.00018	0.00018
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

Profiling Summary Report (Time: 0.10039s, Memory: 6,027KB)

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')

0.00460

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')

0.00338

0.00117

0.00096

0.00091

system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion')

0.00060

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')

0.00041

system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1)

0.00039

system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t")

0.00036

0.00028

0.00174

0.00072

0.00095

0.00070

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')

0.00046

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')

0.00042

0.00028

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')

0.00021

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))

0.00057

0.00094

0.00029

0.00027

0.00073

system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='fruity_twentythree' LIMIT 1)

0.00064

0.00032

0.00023

0.00041

0.00091

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-26 05:55:58', :now2='2025-04-26 05:55:58')

0.01997

0.00180

0.00115

0.00088

0.00083

0.00076

0.00068

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))

0.00059

system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=32 LIMIT 1)

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, 2). Bound with :table='lime_surveys_languagesettings', :schema='public')

0.00031

0.00028

0.00027

0.00098

0.00081

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-26 05:55:58', :now4='2025-04-26 05:55:58')

0.00055

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/favicon.ico')

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')

0.00020

system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groupsettings" "t" WHERE "t"."gsid"=0 LIMIT 1)

0.00020

system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=46 LIMIT 1)

0.00018

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')

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')

0.00012