{"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 |