{"success":true,"updated":null,"DEBUG":{"POST":{"YII_CSRF_TOKEN":"NmtwdmJocEp0THBVUXhTSEdZY3R1a0JSdW5lMVd0MkOvNrNwB1Ce0IXIiIKnAV7KgMVBm-5uOZCzNACbKZQzIA==","startdate":"","expires":"","listpublic":"I","usecookie":"I","usecaptcha_surveyaccess":"I","usecaptcha_registration":"I","usecaptcha_saveandload":"I","action":"updatesurveylocalesettings","sid":"757579","surveyid":"757579","responsejson":"1"},"reloaded":[],"aURLParams":"","initial":"","afterApply":""}}
Sommaire du rapport de profilage (Durée: 1.06121s, Memoire: 21,780KB)
Fonction Nb Total (s) Moy. (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.00275 0.00275 0.00275 0.00275
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.00202 0.00202 0.00202 0.00202
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='fr') 1 0.00119 0.00119 0.00119 0.00119
system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=1 LIMIT 1) 3 0.00087 0.00029 0.00012 0.00049
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.00086 0.00086 0.00086 0.00086
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.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE ((expires > :now OR expires IS NULL) AND (user_status = :active)) AND ("t"."uid"=1) LIMIT 1. Bound with :now='2025-01-08 08:26:23', :active='1') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t") 1 0.00047 0.00047 0.00047 0.00047
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.00035 0.00035 0.00035 0.00035
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.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', :schema='public') 1 0.00137 0.00137 0.00137 0.00137
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.00131 0.00131 0.00131 0.00131
system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=757579 LIMIT 1) 2 0.00113 0.00056 0.00038 0.00075
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.00108 0.00108 0.00108 0.00108
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_survey_url_parameters', :schema='public') 1 0.00106 0.00106 0.00106 0.00106
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.00091 0.00091 0.00091 0.00091
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.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00051 0.00051 0.00051 0.00051
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.00043 0.00043 0.00043 0.00043
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 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_surveys', :schema='public') 1 0.00028 0.00028 0.00028 0.00028
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.00082 0.00082 0.00082 0.00082
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"."ipanonymize" AS "t0_c17", "t"."refurl" AS "t0_c18", "t"."showsurveypolicynotice" AS "t0_c19", "t"."publicstatistics" AS "t0_c20", "t"."publicgraphs" AS "t0_c21", "t"."listpublic" AS "t0_c22", "t"."htmlemail" AS "t0_c23", "t"."sendconfirmation" AS "t0_c24", "t"."tokenanswerspersistence" AS "t0_c25", "t"."assessments" AS "t0_c26", "t"."usecaptcha" AS "t0_c27", "t"."bounce_email" AS "t0_c28", "t"."attributedescriptions" AS "t0_c29", "t"."emailresponseto" AS "t0_c30", "t"."emailnotificationto" AS "t0_c31", "t"."tokenlength" AS "t0_c32", "t"."showxquestions" AS "t0_c33", "t"."showgroupinfo" AS "t0_c34", "t"."shownoanswer" AS "t0_c35", "t"."showqnumcode" AS "t0_c36", "t"."showwelcome" AS "t0_c37", "t"."showprogress" AS "t0_c38", "t"."questionindex" AS "t0_c39", "t"."navigationdelay" AS "t0_c40", "t"."nokeyboard" AS "t0_c41", "t"."alloweditaftercompletion" AS "t0_c42", "SurveysGroups"."gsid" AS "t1_c0", "SurveysGroups"."name" AS "t1_c1", "SurveysGroups"."title" AS "t1_c2", "SurveysGroups"."template" AS "t1_c3", "SurveysGroups"."description" AS "t1_c4", "SurveysGroups"."sortorder" AS "t1_c5", "SurveysGroups"."owner_id" AS "t1_c6", "SurveysGroups"."parent_id" AS "t1_c7", "SurveysGroups"."alwaysavailable" AS "t1_c8", "SurveysGroups"."created" AS "t1_c9", "SurveysGroups"."modified" AS "t1_c10", "SurveysGroups"."created_by" 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.00164 0.00164 0.00164 0.00164
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.00023 0.00023 0.00023 0.00023
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.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_surveys_groups', :schema='public') 1 0.00058 0.00058 0.00058 0.00058
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.00128 0.00128 0.00128 0.00128
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.00089 0.00089 0.00089 0.00089
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.00086 0.00086 0.00086 0.00086
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_permissions', :schema='public') 1 0.00085 0.00085 0.00085 0.00085
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_permissions', :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_survey_url_parameters', :schema='public') 1 0.00102 0.00102 0.00102 0.00102
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 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.00067 0.00067 0.00067 0.00067
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.00055 0.00055 0.00055 0.00055
system.db.CDbCommand.query(SELECT * FROM "lime_permissions" "t" WHERE "t"."entity_id"=:yp0 AND "t"."entity"=:yp1 AND "t"."uid"=:yp2 AND "t"."permission"=:yp3 LIMIT 1. Bound with :yp0=0, :yp1='global', :yp2=1, :yp3='superadmin') 1 0.00045 0.00045 0.00045 0.00045
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.00035 0.00035 0.00035 0.00035
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.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_permissions', :schema='public') 1 0.00024 0.00024 0.00024 0.00024
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.00023 0.00023 0.00023 0.00023
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groupsettings" "t" WHERE "t"."gsid"=0 LIMIT 1) 1 0.00021 0.00021 0.00021 0.00021
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_groups', :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_surveys_groups', :schema='public') 1 0.00088 0.00088 0.00088 0.00088
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.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_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_groups', :schema='public') 1 0.00036 0.00036 0.00036 0.00036
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_survey_links', :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_groups', :schema='public') 1 0.00035 0.00035 0.00035 0.00035
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_survey_links', :schema='public') 1 0.00106 0.00106 0.00106 0.00106
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_saved_control', :schema='public') 1 0.00074 0.00074 0.00074 0.00074
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_archived_table_settings', :schema='public') 1 0.00073 0.00073 0.00073 0.00073
system.db.CDbCommand.query(SELECT "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_policy_notice" AS "t1_c6", "languagesettings"."surveyls_policy_error" AS "t1_c7", "languagesettings"."surveyls_policy_notice_label" AS "t1_c8", "languagesettings"."surveyls_url" AS "t1_c9", "languagesettings"."surveyls_urldescription" AS "t1_c10", "languagesettings"."surveyls_email_invite_subj" AS "t1_c11", "languagesettings"."surveyls_email_invite" AS "t1_c12", "languagesettings"."surveyls_email_remind_subj" AS "t1_c13", "languagesettings"."surveyls_email_remind" AS "t1_c14", "languagesettings"."surveyls_email_register_subj" AS "t1_c15", "languagesettings"."surveyls_email_register" AS "t1_c16", "languagesettings"."surveyls_email_confirm_subj" AS "t1_c17", "languagesettings"."surveyls_email_confirm" AS "t1_c18", "languagesettings"."surveyls_dateformat" AS "t1_c19", "languagesettings"."surveyls_attributecaptions" AS "t1_c20", "languagesettings"."surveyls_alias" AS "t1_c21", "languagesettings"."email_admin_notification_subj" AS "t1_c22", "languagesettings"."email_admin_notification" AS "t1_c23", "languagesettings"."email_admin_responses_subj" AS "t1_c24", "languagesettings"."email_admin_responses" AS "t1_c25", "languagesettings"."surveyls_numberformat" AS "t1_c26", "languagesettings"."attachments" AS "t1_c27" FROM "lime_surveys_languagesettings" "languagesettings" WHERE ("languagesettings"."surveyls_survey_id"=:ypl0). Bound with :ypl0=757579) 1 0.00055 0.00055 0.00055 0.00055
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_archived_table_settings', :schema='public') 1 0.00049 0.00049 0.00049 0.00049
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.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_archived_table_settings', :schema='public') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_languagesettings" "t" WHERE surveyls_survey_id=:surveyid AND surveyls_language=:langname LIMIT 1. Bound with :surveyid=757579, :langname='fr') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT ls.id from lime_answer_l10ns ls JOIN lime_answers a on ls.aid=a.aid JOIN lime_questions q on a.qid=q.qid WHERE sid=757579 AND language <> 'fr' ) 1 0.00176 0.00176 0.00176 0.00176
system.db.CDbCommand.query(SELECT ls.id from lime_question_l10ns ls JOIN lime_questions q on ls.qid=q.qid WHERE sid=757579 AND language <> 'fr' ) 1 0.00076 0.00076 0.00076 0.00076
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_questions', :schema='public') 1 0.00098 0.00098 0.00098 0.00098
system.db.CDbCommand.execute(UPDATE "lime_surveys" SET "sid"=:yp0, "owner_id"=:yp1, "gsid"=:yp2, "admin"=:yp3, "active"=:yp4, "expires"=:yp5, "startdate"=:yp6, "adminemail"=:yp7, "anonymized"=:yp8, "format"=:yp9, "savetimings"=:yp10, "template"=:yp11, "language"=:yp12, "additional_languages"=:yp13, "datestamp"=:yp14, "usecookie"=:yp15, "allowregister"=:yp16, "allowsave"=:yp17, "autonumber_start"=:yp18, "autoredirect"=:yp19, "allowprev"=:yp20, "printanswers"=:yp21, "ipaddr"=:yp22, "ipanonymize"=:yp23, "refurl"=:yp24, "datecreated"=:yp25, "publicstatistics"=:yp26, "publicgraphs"=:yp27, "listpublic"=:yp28, "htmlemail"=:yp29, "sendconfirmation"=:yp30, "tokenanswerspersistence"=:yp31, "assessments"=:yp32, "usecaptcha"=:yp33, "usetokens"=:yp34, "bounce_email"=:yp35, "attributedescriptions"=:yp36, "emailresponseto"=:yp37, "emailnotificationto"=:yp38, "tokenlength"=:yp39, "showxquestions"=:yp40, "showgroupinfo"=:yp41, "shownoanswer"=:yp42, "showqnumcode"=:yp43, "bouncetime"=:yp44, "bounceprocessing"=:yp45, "bounceaccounttype"=:yp46, "bounceaccounthost"=:yp47, "bounceaccountpass"=:yp48, "bounceaccountencryption"=:yp49, "bounceaccountuser"=:yp50, "showwelcome"=:yp51, "showprogress"=:yp52, "questionindex"=:yp53, "navigationdelay"=:yp54, "nokeyboard"=:yp55, "alloweditaftercompletion"=:yp56, "googleanalyticsstyle"=:yp57, "googleanalyticsapikey"=:yp58, "tokenencryptionoptions"=:yp59, "showsurveypolicynotice"=:yp60 WHERE "lime_surveys"."sid"=757579. Bound with :yp0=757579, :yp1=1, :yp2=1, :yp3='inherit', :yp4='N', :yp5=NULL, :yp6=NULL, :yp7='inherit', :yp8='N', :yp9='I', :yp10='I', :yp11='inherit', :yp12='fr', :yp13='', :yp14='I', :yp15='I', :yp16='I', :yp17='I', :yp18=0, :yp19='I', :yp20='I', :yp21='I', :yp22='I', :yp23='I', :yp24='I', :yp25='2025-01-03 22:02:31', :yp26='I', :yp27='I', :yp28='I', :yp29='I', :yp30='I', :yp31='I', :yp32='I', :yp33='E', :yp34='N', :yp35='inherit', :yp36=NULL, :yp37='inherit', :yp38='inherit', :yp39=-1, :yp40='I', :yp41='I', :yp42='I', :yp43='I', :yp44=NULL, :yp45='N', :yp46=NULL, :yp47=NULL, :yp48=NULL, :yp49=NULL, :yp50=NULL, :yp51='I', :yp52='I', :yp53=-1, :yp54=-1, :yp55='I', :yp56='I', :yp57=NULL, :yp58=NULL, :yp59='', :yp60=0) 1 0.00091 0.00091 0.00091 0.00091
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_questions', :schema='public') 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT ls.id from lime_group_l10ns ls JOIN "lime_groups" g on ls.gid=g.gid WHERE sid=757579 AND language <> 'fr' ) 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_questions', :schema='public') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groups" "t" ORDER BY title ASC) 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=:ycp2 LIMIT 2. Bound with :ycp2=757579) 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_question_attributes', :schema='public') 1 0.00082 0.00082 0.00082 0.00082
system.db.CDbCommand.query(SELECT * FROM "lime_questions" "t" WHERE sid=:sid and parent_qid=0. Bound with :sid=757579) 3 0.00074 0.00025 0.00022 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_question_attributes', :schema='public') 1 0.00062 0.00062 0.00062 0.00062
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_question_attributes', :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_question_themes', :schema='public') 1 0.00089 0.00089 0.00089 0.00089
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='T', :extends='') 12 0.00312 0.00026 0.00016 0.00051
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='longfreetext', :extends='T') 12 0.00283 0.00024 0.00016 0.00042
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='S', :extends='') 9 0.00194 0.00022 0.00013 0.00031
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='shortfreetext', :extends='S') 6 0.00131 0.00022 0.00014 0.00034
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=1) 3 0.00090 0.00030 0.00018 0.00055
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_saved_control', :schema='public') 1 0.00069 0.00069 0.00069 0.00069
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_question_themes', :schema='public') 1 0.00032 0.00032 0.00032 0.00032
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=2) 3 0.00074 0.00025 0.00021 0.00031
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='U', :extends='') 3 0.00084 0.00028 0.00021 0.00038
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='hugefreetext', :extends='U') 3 0.00092 0.00031 0.00018 0.00052
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='Q', :extends='') 6 0.00143 0.00024 0.00021 0.00030
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='browserdetect', :extends='S') 3 0.00091 0.00030 0.00023 0.00039
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=6) 3 0.00081 0.00027 0.00022 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=5) 3 0.00079 0.00026 0.00016 0.00042
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multipleshorttext', :extends='Q') 3 0.00074 0.00025 0.00022 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=3) 3 0.00072 0.00024 0.00020 0.00031
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='inputondemand', :extends='Q') 3 0.00064 0.00021 0.00019 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=4) 3 0.00061 0.00020 0.00018 0.00022
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multiplenumeric', :extends='K') 6 0.00192 0.00032 0.00016 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='N', :extends='') 3 0.00065 0.00022 0.00016 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='numerical', :extends='N') 3 0.00061 0.00020 0.00016 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=7) 3 0.00051 0.00017 0.00013 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='K', :extends='') 6 0.00136 0.00023 0.00016 0.00034
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_question_themes', :schema='public') 1 0.00084 0.00084 0.00084 0.00084
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8) 3 0.00102 0.00034 0.00017 0.00061
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1, 2, 3). Bound with :table='lime_survey_links', :schema='public') 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='F', :extends='') 3 0.00104 0.00035 0.00021 0.00043
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='A', :extends='') 6 0.00131 0.00022 0.00016 0.00033
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/5point', :extends='A') 6 0.00118 0.00020 0.00016 0.00026
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=17) 3 0.00087 0.00029 0.00022 0.00043
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/array', :extends='F') 3 0.00073 0.00024 0.00021 0.00026
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/10point', :extends='B') 3 0.00089 0.00030 0.00016 0.00048
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=11) 3 0.00078 0.00026 0.00016 0.00044
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type=':', :extends='') 3 0.00064 0.00021 0.00015 0.00033
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='list_dropdown', :extends='!') 3 0.00064 0.00021 0.00015 0.00031
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=9) 3 0.00060 0.00020 0.00018 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type=';', :extends='') 3 0.00093 0.00031 0.00016 0.00045
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/texts', :extends=';') 3 0.00057 0.00019 0.00016 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='O', :extends='') 3 0.00063 0.00021 0.00016 0.00026
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=10) 3 0.00057 0.00019 0.00015 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='B', :extends='') 3 0.00064 0.00021 0.00017 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/dualscale', :extends='1') 3 0.00079 0.00026 0.00017 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=14) 3 0.00074 0.00025 0.00016 0.00031
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='5', :extends='') 3 0.00069 0.00023 0.00020 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='equation', :extends='*') 3 0.00066 0.00022 0.00020 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='arrays/multiflexi', :extends=':') 3 0.00052 0.00017 0.00016 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='1', :extends='') 3 0.00050 0.00017 0.00013 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=12) 3 0.00048 0.00016 0.00014 0.00018
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='L', :extends='') 6 0.00099 0.00017 0.00012 0.00029
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='5pointchoice', :extends='5') 3 0.00050 0.00017 0.00015 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='!', :extends='') 6 0.00120 0.00020 0.00015 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=27) 3 0.00076 0.00025 0.00023 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='bootstrap_buttons', :extends='L') 3 0.00069 0.00023 0.00013 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=18) 3 0.00054 0.00018 0.00016 0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='listradio', :extends='L') 3 0.00051 0.00017 0.00012 0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=16) 3 0.00049 0.00016 0.00013 0.00022
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='bootstrap_dropdown', :extends='!') 3 0.00071 0.00024 0.00014 0.00039
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='*', :extends='') 3 0.00066 0.00022 0.00012 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=20) 3 0.00066 0.00022 0.00019 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='R', :extends='') 6 0.00139 0.00023 0.00017 0.00032
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='Y', :extends='') 6 0.00137 0.00023 0.00013 0.00033
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='yesno', :extends='Y') 6 0.00126 0.00021 0.00012 0.00038
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='ranking_advanced', :extends='R') 3 0.00096 0.00032 0.00022 0.00050
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='X', :extends='') 3 0.00090 0.00030 0.00022 0.00044
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='ranking', :extends='R') 3 0.00076 0.00025 0.00023 0.00028
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='boilerplate', :extends='X') 3 0.00076 0.00025 0.00021 0.00030
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=22) 3 0.00063 0.00021 0.00017 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=23) 3 0.00063 0.00021 0.00018 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=21) 3 0.00057 0.00019 0.00018 0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=24) 3 0.00052 0.00017 0.00015 0.00022
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=25) 3 0.00056 0.00019 0.00014 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='list_with_comment', :extends='O') 3 0.00050 0.00017 0.00013 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=15) 3 0.00040 0.00013 0.00012 0.00015
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=19) 3 0.00048 0.00016 0.00011 0.00020
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=13) 3 0.00047 0.00016 0.00013 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=26) 3 0.00058 0.00019 0.00016 0.00023
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_policy_notice" AS "t0_c6", "t"."surveyls_policy_error" AS "t0_c7", "t"."surveyls_policy_notice_label" AS "t0_c8", "t"."surveyls_url" AS "t0_c9", "t"."surveyls_urldescription" AS "t0_c10", "t"."surveyls_email_invite_subj" AS "t0_c11", "t"."surveyls_email_invite" AS "t0_c12", "t"."surveyls_email_remind_subj" AS "t0_c13", "t"."surveyls_email_remind" AS "t0_c14", "t"."surveyls_email_register_subj" AS "t0_c15", "t"."surveyls_email_register" AS "t0_c16", "t"."surveyls_email_confirm_subj" AS "t0_c17", "t"."surveyls_email_confirm" AS "t0_c18", "t"."surveyls_dateformat" AS "t0_c19", "t"."surveyls_attributecaptions" AS "t0_c20", "t"."surveyls_alias" AS "t0_c21", "t"."email_admin_notification_subj" AS "t0_c22", "t"."email_admin_notification" AS "t0_c23", "t"."email_admin_responses_subj" AS "t0_c24", "t"."email_admin_responses" AS "t0_c25", "t"."surveyls_numberformat" AS "t0_c26", "t"."attachments" AS "t0_c27", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."gsid" AS "t1_c2", "survey"."admin" AS "t1_c3", "survey"."active" AS "t1_c4", "survey"."expires" AS "t1_c5", "survey"."startdate" AS "t1_c6", "survey"."adminemail" AS "t1_c7", "survey"."anonymized" 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"."ipanonymize" AS "t1_c23", "survey"."refurl" AS "t1_c24", "survey"."datecreated" AS "t1_c25", "survey"."showsurveypolicynotice" AS "t1_c26", "survey"."publicstatistics" AS "t1_c27", "survey"."publicgraphs" AS "t1_c28", "survey"."listpublic" AS "t1_c29", "survey"."htmlemail" AS "t1_c30", "survey"."sendconfirmation" AS "t1_c31", "survey"."tokenanswerspersistence" AS "t1_c32", "survey"."assessments" AS "t1_c33", "survey"."usecaptcha" AS "t1_c34", "survey"."usetokens" AS "t1_c35", "survey"."bounce_email" AS "t1_c36", "survey"."attributedescriptions" AS "t1_c37", "survey"."emailresponseto" AS "t1_c38", "survey"."emailnotificationto" AS "t1_c39", "survey"."tokenlength" AS "t1_c40", "survey"."showxquestions" AS "t1_c41", "survey"."showgroupinfo" AS "t1_c42", "survey"."shownoanswer" AS "t1_c43", "survey"."showqnumcode" AS "t1_c44", "survey"."bouncetime" AS "t1_c45", "survey"."bounceprocessing" AS "t1_c46", "survey"."bounceaccounttype" AS "t1_c47", "survey"."bounceaccounthost" AS "t1_c48", "survey"."bounceaccountpass" AS "t1_c49", "survey"."bounceaccountencryption" AS "t1_c50", "survey"."bounceaccountuser" AS "t1_c51", "survey"."showwelcome" AS "t1_c52", "survey"."showprogress" AS "t1_c53", "survey"."questionindex" AS "t1_c54", "survey"."navigationdelay" AS "t1_c55", "survey"."nokeyboard" AS "t1_c56", "survey"."alloweditaftercompletion" AS "t1_c57", "survey"."googleanalyticsstyle" AS "t1_c58", "survey"."googleanalyticsapikey" AS "t1_c59", "survey"."tokenencryptionoptions" AS "t1_c60" FROM "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=757579 AND "t"."surveyls_language"='en')) 2 0.00080 0.00040 0.00036 0.00044
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=28) 3 0.00051 0.00017 0.00016 0.00019
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.00193 0.00193 0.00193 0.00193
system.db.CDbCommand.query(SELECT g.*, q.*, gls.*, qls.* FROM "lime_groups" g JOIN lime_questions q on q.gid=g.gid JOIN lime_group_l10ns gls on gls.gid=g.gid JOIN lime_question_l10ns qls on qls.qid=q.qid WHERE qls.language='fr' and gls.language='fr' AND g.sid=757579 AND q.parent_qid=0 ORDER BY group_order, question_order) 2 0.00163 0.00082 0.00081 0.00082
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='multiplechoice', :extends='M') 6 0.00157 0.00026 0.00013 0.00045
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid JOIN lime_questions as b ON a.qid = b.qid AND al10.language = 'fr' AND b.same_default=0 AND b.sid = 757579) 2 0.00145 0.00072 0.00047 0.00098
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE question_type = :question_type AND extends = :extends LIMIT 1. Bound with :question_type='M', :extends='') 6 0.00121 0.00020 0.00016 0.00027
system.db.CDbCommand.query(SELECT sq.*, ls.question, q.other FROM lime_questions as sq JOIN lime_questions as q on sq.parent_qid=q.qid JOIN lime_question_l10ns as ls on ls.qid=sq.qid WHERE sq.parent_qid=q.qid AND ls.language='fr' AND q.sid=757579 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order) 1 0.00087 0.00087 0.00087 0.00087
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_answers', :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_answers', :schema='public') 1 0.00076 0.00076 0.00076 0.00076
system.db.CDbCommand.query(SELECT a.qid, a.sqid, a.scale_id, a.specialtype, al10.defaultvalue FROM lime_defaultvalues as a JOIN lime_defaultvalue_l10ns as al10 ON a.dvid = al10.dvid JOIN lime_questions as b ON a.qid = b.qid AND al10.language = 'fr' AND b.same_default=1 AND b.sid = 757579) 2 0.00068 0.00034 0.00032 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=34) 3 0.00065 0.00022 0.00018 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=32) 3 0.00063 0.00021 0.00017 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE "t"."extends"=:yp0. Bound with :yp0='') 2 0.00062 0.00031 0.00023 0.00039
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=33) 3 0.00054 0.00018 0.00016 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=29) 3 0.00050 0.00017 0.00013 0.00024
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_policy_notice" AS "t0_c6", "t"."surveyls_policy_error" AS "t0_c7", "t"."surveyls_policy_notice_label" AS "t0_c8", "t"."surveyls_url" AS "t0_c9", "t"."surveyls_urldescription" AS "t0_c10", "t"."surveyls_email_invite_subj" AS "t0_c11", "t"."surveyls_email_invite" AS "t0_c12", "t"."surveyls_email_remind_subj" AS "t0_c13", "t"."surveyls_email_remind" AS "t0_c14", "t"."surveyls_email_register_subj" AS "t0_c15", "t"."surveyls_email_register" AS "t0_c16", "t"."surveyls_email_confirm_subj" AS "t0_c17", "t"."surveyls_email_confirm" AS "t0_c18", "t"."surveyls_dateformat" AS "t0_c19", "t"."surveyls_attributecaptions" AS "t0_c20", "t"."surveyls_alias" AS "t0_c21", "t"."email_admin_notification_subj" AS "t0_c22", "t"."email_admin_notification" AS "t0_c23", "t"."email_admin_responses_subj" AS "t0_c24", "t"."email_admin_responses" AS "t0_c25", "t"."surveyls_numberformat" AS "t0_c26", "t"."attachments" AS "t0_c27", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."gsid" AS "t1_c2", "survey"."admin" AS "t1_c3", "survey"."active" AS "t1_c4", "survey"."expires" AS "t1_c5", "survey"."startdate" AS "t1_c6", "survey"."adminemail" AS "t1_c7", "survey"."anonymized" 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"."ipanonymize" AS "t1_c23", "survey"."refurl" AS "t1_c24", "survey"."datecreated" AS "t1_c25", "survey"."showsurveypolicynotice" AS "t1_c26", "survey"."publicstatistics" AS "t1_c27", "survey"."publicgraphs" AS "t1_c28", "survey"."listpublic" AS "t1_c29", "survey"."htmlemail" AS "t1_c30", "survey"."sendconfirmation" AS "t1_c31", "survey"."tokenanswerspersistence" AS "t1_c32", "survey"."assessments" AS "t1_c33", "survey"."usecaptcha" AS "t1_c34", "survey"."usetokens" AS "t1_c35", "survey"."bounce_email" AS "t1_c36", "survey"."attributedescriptions" AS "t1_c37", "survey"."emailresponseto" AS "t1_c38", "survey"."emailnotificationto" AS "t1_c39", "survey"."tokenlength" AS "t1_c40", "survey"."showxquestions" AS "t1_c41", "survey"."showgroupinfo" AS "t1_c42", "survey"."shownoanswer" AS "t1_c43", "survey"."showqnumcode" AS "t1_c44", "survey"."bouncetime" AS "t1_c45", "survey"."bounceprocessing" AS "t1_c46", "survey"."bounceaccounttype" AS "t1_c47", "survey"."bounceaccounthost" AS "t1_c48", "survey"."bounceaccountpass" AS "t1_c49", "survey"."bounceaccountencryption" AS "t1_c50", "survey"."bounceaccountuser" AS "t1_c51", "survey"."showwelcome" AS "t1_c52", "survey"."showprogress" AS "t1_c53", "survey"."questionindex" AS "t1_c54", "survey"."navigationdelay" AS "t1_c55", "survey"."nokeyboard" AS "t1_c56", "survey"."alloweditaftercompletion" AS "t1_c57", "survey"."googleanalyticsstyle" AS "t1_c58", "survey"."googleanalyticsapikey" AS "t1_c59", "survey"."tokenencryptionoptions" AS "t1_c60" FROM "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=757579 AND "t"."surveyls_language"='fr')) 2 0.00094 0.00047 0.00036 0.00058
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=30) 3 0.00050 0.00017 0.00011 0.00023
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_group_l10ns', :schema='public') 1 0.00128 0.00128 0.00128 0.00128
system.db.CDbCommand.query(SELECT COUNT(*) FROM "lime_answers" "t" WHERE "t"."qid"=:yp0. Bound with :yp0=22) 2 0.00048 0.00024 0.00021 0.00027
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=31) 3 0.00048 0.00016 0.00014 0.00017
system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='fruity_twentythree' LIMIT 1) 2 0.00057 0.00029 0.00026 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_answers', :schema='public') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(select count(DISTINCT "lime_groups".gid) from "lime_groups" left join lime_questions on "lime_groups".gid=lime_questions.gid where "lime_groups".sid =757579 and qid is not null) 4 0.00125 0.00031 0.00028 0.00037
system.db.CDbCommand.query(SELECT "owner"."uid" AS "t1_c0", "owner"."users_name" AS "t1_c1", "owner"."password" AS "t1_c2", "owner"."full_name" AS "t1_c3", "owner"."parent_id" AS "t1_c4", "owner"."lang" AS "t1_c5", "owner"."email" AS "t1_c6", "owner"."htmleditormode" AS "t1_c7", "owner"."templateeditormode" AS "t1_c8", "owner"."questionselectormode" AS "t1_c9", "owner"."one_time_pw" AS "t1_c10", "owner"."dateformat" AS "t1_c11", "owner"."last_login" AS "t1_c12", "owner"."created" AS "t1_c13", "owner"."modified" AS "t1_c14", "owner"."validation_key" AS "t1_c15", "owner"."validation_key_expiration" AS "t1_c16", "owner"."last_forgot_email_password" AS "t1_c17", "owner"."expires" AS "t1_c18", "owner"."user_status" AS "t1_c19" FROM "lime_users" "owner" WHERE ("owner"."uid"=:ypl0). Bound with :ypl0=1) 2 0.00045 0.00023 0.00021 0.00024
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid = :qid AND attribute = 'max_subquestions' LIMIT 1. Bound with :qid=22) 2 0.00040 0.00020 0.00019 0.00022
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_group_l10ns', :schema='public') 1 0.00045 0.00045 0.00045 0.00045
system.db.CDbCommand.query(SELECT COUNT(*) FROM "lime_answers" "t" WHERE "t"."qid"=:yp0. Bound with :yp0=23) 2 0.00037 0.00018 0.00015 0.00022
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_group_l10ns', :schema='public') 1 0.00054 0.00054 0.00054 0.00054
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid = :qid AND attribute = 'max_subquestions' LIMIT 1. Bound with :qid=23) 2 0.00043 0.00022 0.00016 0.00028
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.00021 0.00021 0.00021 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_template_configuration" "t" WHERE (gsid=:gsid) AND (template_name=:template_name) LIMIT 1. Bound with :gsid=1, :template_name='fruity_twentythree') 1 0.00025 0.00025 0.00025 0.00025
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.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT DISTINCT c.*, q.sid, q.type FROM lime_conditions AS c LEFT JOIN lime_questions q ON c.cqid=q.qid LEFT JOIN lime_questions qa ON c.qid=qa.qid WHERE qa.sid = 757579 AND 1=1 UNION SELECT DISTINCT c.*, q.sid, NULL AS TYPE FROM lime_conditions AS c LEFT JOIN lime_questions q ON c.cqid=q.qid LEFT JOIN lime_questions qa ON c.qid=qa.qid WHERE qa.sid = 757579 AND c.cqid = 0 order by qid, scenario, cqid, cfieldname, value) 1 0.00121 0.00121 0.00121 0.00121
system.db.CDbCommand.query(SELECT COUNT(*) FROM "lime_questions" "t" WHERE "t"."sid"=:yp0 AND "t"."parent_qid"=:yp1. Bound with :yp0=757579, :yp1=0) 2 0.00038 0.00019 0.00019 0.00020
system.db.CDbCommand.query(SELECT a.qid, a.code, l.answer, a.scale_id, a.assessment_value FROM lime_answers AS a JOIN lime_questions q on a.qid=q.qid JOIN lime_answer_l10ns l on l.aid=a.aid WHERE 1=1 and a.qid = q.qid and q.sid = 757579 and l.language='fr' ORDER BY a.qid, a.scale_id, a.sortorder) 2 0.00094 0.00047 0.00045 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_template_configuration" "t" WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=757579, :template_name='fruity_twentythree') 1 0.00024 0.00024 0.00024 0.00024
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=1) 1 0.00019 0.00019 0.00019 0.00019
system.db.CDbCommand.query(SELECT * FROM "lime_groups" "t" WHERE "t"."sid"=:yp0. Bound with :yp0=757579) 1 0.00018 0.00018 0.00018 0.00018
system.db.CDbCommand.query(SELECT "groups"."gid" AS "t1_c0", "groups"."sid" AS "t1_c1", "groups"."group_order" AS "t1_c2", "groups"."randomization_group" AS "t1_c3", "groups"."grelevance" AS "t1_c4" FROM "lime_groups" "groups" WHERE ("groups"."sid"=:ypl0) ORDER BY groups.group_order ASC. Bound with :ypl0=757579) 1 0.00016 0.00016 0.00016 0.00016
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=2) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=4) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=6) 1 0.00015 0.00015 0.00015 0.00015
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=7) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=3) 1 0.00014 0.00014 0.00014 0.00014
system.db.CDbCommand.query(SELECT "questiongroupl10ns"."id" AS "t1_c0", "questiongroupl10ns"."gid" AS "t1_c1", "questiongroupl10ns"."group_name" AS "t1_c2", "questiongroupl10ns"."description" AS "t1_c3", "questiongroupl10ns"."language" AS "t1_c4" FROM "lime_group_l10ns" "questiongroupl10ns" WHERE ("questiongroupl10ns"."gid"=:ypl0). Bound with :ypl0=5) 1 0.00014 0.00014 0.00014 0.00014