Sie haben % dieser Umfrage fertiggestellt.
Achtung: Javascript ist in Ihrem Browser für diese Webseite deaktiviert. Es kann sein, dass Sie daher die Umfrage nicht abschließen werden können. Bitte überprüfen Sie Ihre Browser-Einstellungen.

Kerndatensatz Pflege

Diese Umfrage findet im Rahmen des vom BMBF geförderten Projektes PFLIP statt. Weitere Information über das Projekt finden Sie unter pflip-pflegedaten.de oder auf https://www.isst.fraunhofer.de/de/geschaeftsfelder/gesundheitswesen/projekte/PFLIP.html.

Bei Fragen kontatktieren Sie uns gerne unter pflip-umfrage@isst.fraunhofer.de

 

              


 

Darum geht es:

 

PFLIP ist ein Projekt zum Aufbau eines Systems, in dem Pflegedaten einrichtungsübergreifend zusammengebracht werden, um neue Erkenntnisse zu pflegerelevanten Themen wie z.B. Stürzen zu gewinnen. Wir sind ein Team aus wissenschaftlichen Einrichtungen (HS Gesundheit und Fraunhofer ISST) und Praxispartnern (Diakonie Michaelshoven und Connext), die in einem Forschungsprojekt zusammenarbeiten.

 

Das möchten wir herausfinden:

 

  1. Welche Faktoren sind maßgeblich, um das Sturzrisiko von Bewohnenden, Patienten oder Kunden zu ermitteln?

 

  1. Welche Maßnahmen und Informationen sind wichtig um Stürze in Zukunft besser verhindern zu können?

 

Die Ergebnisse der Umfrage nutzen wir dazu ein System aufzubauen, welches Informationen aus verschiedenen Einrichtungen anonym sammelt, um neue Erkenntnisse über Sturzrisiken und Sturzprävention zu bekommen. Dieses neue Wissen kann bei Fertigstellung dieses Systems von Pflegenden im Pflegealltag eingesetzt werden.

 

  • Dieser Fragebogen ist kein Test ihrer Kompetenz, Qualifikation oder Arbeitsleistung. 

 

  • Uns ist Ihre persönliche Einschätzung aus der Pflegepraxis zum Thema Sturz wichtig. Sie haben praktische Expertise über Stürze im Pflegealltag, dieses Erfahrungswissen ist sehr interessant für uns. 

 

  • Die Umfrage ist anonym. Es können von uns keine Rückschlüsse auf Ihre Person gezogen werden. Wir geben Ihre Antworten nicht weiter. Ihr Arbeitgeber erfährt nicht, ob Sie an der Umfrage teilgenommen haben oder welche Antworten Sie gegeben haben. 

 

Durch die Teilnahme an dieser Umfrage helfen Sie uns bei der Forschung zur Sturzprävention. So können wir Sie als Pflegende in Zukunft bei der Sturzprävention mit neuem Wissen unterstützen.


Die Umfrage dauert ca. 30min über vier Seiten und besteht überwiegend aus Fragen zum Ankreuzen. Die Umfrage wird anonymisiert ausgewertet.

Die folgende Datenschutzinformation informiert Sie über die Verarbeitung Ihrer personenbezogenen Daten, die wir von Ihnen bei der Teilnahme an der wissenschaftlichen Online-Umfrage „Kerndatensatz Pflege“ erheben. Die Befragung findet im Rahmen eines vom Bundesministerium für Bildung und Forschung geförderten Forschungsprojektes statt. Die Verarbeitung Ihrer personenbezogenen Daten erfolgt unter Beachtung der geltenden datenschutzrechtlichen Bestimmungen. Mehr Informationen über das Projekt finden Sie unter https://www.isst.fraunhofer.de/de/geschaeftsfelder/gesundheitswesen/projekte/PFLIP.html .

1. Name und Kontaktdaten des für die Verarbeitung Verantwortlichen sowie des betrieblichen Datenschutzbeauftragten

Verantwortlicher für die Datenverarbeitung ist:

Fraunhofer-Gesellschaft
zur Förderung der angewandten Forschung e.V.
Hansastraße 27 c,
80686 München

(im Folgenden »Fraunhofer«)

Email:       info@zv.fraunhofer.de
Telefon:    +49 (0)89 1205- 0
Fax:           +49 (0)89 1205-7531


für ihr Fraunhofer-Institut für Software- und Systemtechnik
(im Folgenden »Fraunhofer ISST«)

E-Mail:    info@isst.fraunhofer.de
Telefon:   +49 (0) 231 97677-0

Der betriebliche Datenschutzbeauftragte von Fraunhofer ist unter der o.g. Anschrift, zu Hd. Abteilung Datenschutz, bzw. unter datenschutz@zv.fraunhofer.de erreichbar. Sie können sich jederzeit bei Fragen zum Datenschutzrecht oder Ihren Betroffenenrechten direkt an unseren Datenschutzbeauftragten wenden oder an die Projektleiterin Anja Burmann über Anja.Burmann@isst.fraunhofer.de.

2. Verarbeitung Ihrer personenbezogenen Daten und Zwecke der Verarbeitung

Die Teilnahme an der Umfrage ist freiwillig. Alle Angaben werden vertraulich behandelt.

Bei Beantwortung der Fragen unserer Umfrage werden personenbezogene Daten erhoben. Sofern durch die Wahl oder Formulierung der Antworten ein Rückschluss auf die Person des Teilnehmenden möglich ist, erfolgt die Datenverarbeitung zur Wahrung unserer berechtigten Interessen nach Art. 6 Abs. 1 S. 1 lit. f DSGVO. Die Umfrage dient dazu, Informationen zu Information über die Relevanz von Sturzrisiken, Interventionen und der Dokumentation von Sturzereignissen in verschiedenen gesundheitsbezogenen Einrichtungen zu sammeln und daraus ein System zur Erschließung neuer Erkenntnisse in der Sturzprävention zu sammeln. Darin sind berechtigte Interessen im Sinne der vorgenannten Vorschrift zu sehen.

Wir speichern die Fragen und Antworten der Umfrage. Darüber hinaus werden die Ergebnisse durch Mitarbeiter von Fraunhofer ausgewertet und analysiert. Ihre Antworten werden spätestens nach Ablauf des Forschungsprojektes am 01.03.2025 anonymisiert oder gelöscht. Es sei denn, dass Gründe vorliegen, die eine längere Speicherung (zum Beispiel, wenn Sie nach Art. 6 Abs. 1 S. 1 lit. a DSGVO Ihre Einwilligung gegeben haben) rechtfertigen.

Die Dokumentation und etwaige Veröffentlichung der Umfrageergebnisse erfolgten ausschließlich in anonymisierter Form und ohne Angabe von Informationen, die einen Rückschluss auf Ihre Person zulassen.

 3. Weitergabe der Daten

Wir geben Ihre Daten grundsätzlich nicht weiter. Eine Weitergabe an Dritte kommt allenfalls in Betracht, wenn:

  • Sie gem. Art. 6 Abs. 1 S.1 lit. a DSGVO Ihre ausdrückliche Einwilligung dazu erteilt haben;
  • dies gemäß Art. 6 Abs. 1 S.1 lit. b DSGVO für die Erfüllung eines Vertrags mit Ihnen erforderlich ist oder
  • für den Fall, dass für die Weitergabe nach Art. 6 Abs. 1 S. 1 lit. c DSGVO eine gesetzliche Verpflichtung besteht.
    Eine Übermittlung von personenbezogenen Daten in ein Drittland (außerhalb der EU) oder eine internationale Organisation ist ausgeschlossen.


4. Betroffenenrechte

Sie haben das Recht:

  • gemäß Art. 7 Abs. 3 DSGVO Ihre einmal erteilte Einwilligung jederzeit gegenüber uns zu widerrufen. Dies hat zur Folge, dass wir die Datenverarbeitung, die auf dieser Einwilligung beruhte, für die Zukunft nicht mehr fortführen dürfen;
  • gemäß Art. 15 DSGVO Auskunft über Ihre von uns verarbeiteten personenbezogenen Daten zu verlangen. Insbesondere können Sie Auskunft über die Verarbeitungszwecke, die Kategorie der personenbezogenen Daten, die Kategorien von Empfängern, gegenüber denen Ihre Daten offengelegt wurden oder werden, die geplante Speicherdauer, das Bestehen eines Rechts auf Berichtigung, Löschung, Einschränkung der Verarbeitung oder Widerspruch, das Bestehen eines Beschwerderechts, die Herkunft ihrer Daten, sofern diese nicht bei uns erhoben wurden, sowie über das Bestehen einer automatisierten Entscheidungsfindung einschließlich Profiling und ggf. aussagekräftigen Informationen zu deren Einzelheiten verlangen;
  • gemäß Art. 16 DSGVO unverzüglich die Berichtigung unrichtiger oder Vervollständigung Ihrer bei uns gespeicherten personenbezogenen Daten zu verlangen;
  • gemäß Art. 17 DSGVO die Löschung Ihrer bei uns gespeicherten personenbezogenen Daten zu verlangen, soweit nicht die Verarbeitung zur Ausübung des Rechts auf freie Meinungsäußerung und Information, zur Erfüllung einer rechtlichen Verpflichtung, aus Gründen des öffentlichen Interesses oder zur Geltendmachung, Ausübung oder Verteidigung von Rechtsansprüchen erforderlich ist;
  • gemäß Art. 18 DSGVO die Einschränkung der Verarbeitung Ihrer personenbezogenen Daten zu verlangen, soweit die Richtigkeit der Daten von Ihnen bestritten wird, die Verarbeitung unrechtmäßig ist, Sie aber deren Löschung ablehnen und wir die Daten nicht mehr benötigen, Sie jedoch diese zur Geltendmachung, Ausübung oder Verteidigung von Rechtsansprüchen benötigen oder Sie gemäß Art. 21 DSGVO Widerspruch gegen die Verarbeitung eingelegt haben;
  • gemäß Art. 20 DSGVO Ihre personenbezogenen Daten, die Sie uns bereitgestellt haben, in einem strukturierten, gängigen und maschinenlesebaren Format zu erhalten oder die Übermittlung an einen anderen Verantwortlichen zu verlangen und
  • gemäß Art. 77 DSGVO sich bei einer Aufsichtsbehörde zu beschweren. In der Regel können Sie sich hierfür an die Aufsichtsbehörde ihres üblichen Aufenthaltsortes oder Arbeitsplatzes oder unseres Unternehmenssitzes wenden.

 

3. Widerspruchsrecht

Sofern Ihre personenbezogenen Daten auf Grundlage von berechtigten Interessen gemäß Art. 6 Abs. 1 S. 1 lit. f DSGVO verarbeitet werden, haben Sie das Recht, gemäß Art. 21 DSGVO Widerspruch gegen die Verarbeitung Ihrer personenbezogenen Daten einzulegen, soweit dafür Gründe vorliegen, die sich aus Ihrer besonderen Situation ergeben oder sich der Widerspruch gegen Direktwerbung richtet. Im letzteren Fall haben Sie ein generelles Widerspruchsrecht, das ohne Angabe einer besonderen Situation von uns umgesetzt wird.
Möchten Sie von Ihrem Widerspruchsrecht Gebrauch machen, genügt eine E-Mail an
datenschutz@zv.fraunhofer.de.

 

4. Datensicherheit

Wir bedienen uns geeigneter technischer und organisatorischer Sicherheitsmaßnahmen, um Ihre Daten gegen zufällige oder vorsätzliche Manipulationen, teilweisen oder vollständigen Verlust, Zerstörung oder gegen den unbefugten Zugriff Dritter zu schützen. Unsere Sicherheitsmaßnahmen werden entsprechend der technologischen Entwicklung fortlaufend verbessert.

 

 

Ergebnis der Perfomance-Analyse (Zeit: 1.21018s, Speicher: 16,551KB)
Prozedur Anzahl Gesamt (s) Durschn. (s) Min. (s) Max. (s)
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='') 44 0.01703 0.00039 0.00023 0.00078
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.00379 0.00379 0.00379 0.00379
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.00212 0.00212 0.00212 0.00212
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.00097 0.00097 0.00097 0.00097
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.00077 0.00077 0.00077 0.00077
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(SELECT * FROM "lime_groups" "t" WHERE "t"."sid"=:yp0 ORDER BY group_order ASC. Bound with :yp0=543986) 2 0.00058 0.00029 0.00026 0.00032
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.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_surveys', :schema='public') 1 0.00166 0.00166 0.00166 0.00166
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.00127 0.00127 0.00127 0.00127
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.00095 0.00095 0.00095 0.00095
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.00094 0.00094 0.00094 0.00094
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.00067 0.00067 0.00067 0.00067
system.db.CDbCommand.query(SELECT * FROM "lime_surveys" "t" WHERE "t"."sid"=543986 LIMIT 1) 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_surveys_groupsettings', :schema='public') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_surveys', :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_template_configuration', :schema='public') 1 0.00137 0.00137 0.00137 0.00137
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.00097 0.00097 0.00097 0.00097
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.00092 0.00092 0.00092 0.00092
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.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_users', :schema='public') 1 0.00078 0.00078 0.00078 0.00078
system.db.CDbCommand.query(SELECT "t"."gsid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."adminemail" AS "t0_c3", "t"."anonymized" AS "t0_c4", "t"."format" AS "t0_c5", "t"."savetimings" AS "t0_c6", "t"."template" AS "t0_c7", "t"."datestamp" AS "t0_c8", "t"."usecookie" AS "t0_c9", "t"."allowregister" AS "t0_c10", "t"."allowsave" AS "t0_c11", "t"."autonumber_start" AS "t0_c12", "t"."autoredirect" AS "t0_c13", "t"."allowprev" AS "t0_c14", "t"."printanswers" AS "t0_c15", "t"."ipaddr" AS "t0_c16", "t"."refurl" AS "t0_c17", "t"."showsurveypolicynotice" AS "t0_c18", "t"."publicstatistics" AS "t0_c19", "t"."publicgraphs" AS "t0_c20", "t"."listpublic" AS "t0_c21", "t"."htmlemail" AS "t0_c22", "t"."sendconfirmation" AS "t0_c23", "t"."tokenanswerspersistence" AS "t0_c24", "t"."assessments" AS "t0_c25", "t"."usecaptcha" AS "t0_c26", "t"."bounce_email" AS "t0_c27", "t"."attributedescriptions" AS "t0_c28", "t"."emailresponseto" AS "t0_c29", "t"."emailnotificationto" AS "t0_c30", "t"."tokenlength" AS "t0_c31", "t"."showxquestions" AS "t0_c32", "t"."showgroupinfo" AS "t0_c33", "t"."shownoanswer" AS "t0_c34", "t"."showqnumcode" AS "t0_c35", "t"."showwelcome" AS "t0_c36", "t"."showprogress" AS "t0_c37", "t"."questionindex" AS "t0_c38", "t"."navigationdelay" AS "t0_c39", "t"."nokeyboard" AS "t0_c40", "t"."alloweditaftercompletion" AS "t0_c41", "t"."ipanonymize" AS "t0_c42", "SurveysGroups"."gsid" AS "t1_c0", "SurveysGroups"."name" AS "t1_c1", "SurveysGroups"."title" AS "t1_c2", "SurveysGroups"."description" AS "t1_c3", "SurveysGroups"."sortorder" AS "t1_c4", "SurveysGroups"."owner_id" AS "t1_c5", "SurveysGroups"."parent_id" AS "t1_c6", "SurveysGroups"."created" AS "t1_c7", "SurveysGroups"."modified" AS "t1_c8", "SurveysGroups"."created_by" AS "t1_c9", "SurveysGroups"."template" AS "t1_c10", "SurveysGroups"."alwaysavailable" AS "t1_c11" FROM "lime_surveys_groupsettings" "t" LEFT OUTER JOIN "lime_surveys_groups" "SurveysGroups" ON ("SurveysGroups"."gsid"="t"."gsid") WHERE ("t"."gsid"=1)) 1 0.00059 0.00059 0.00059 0.00059
system.db.CDbCommand.query(SELECT "t1"."message" AS "message", "t2"."translation" AS "translation" FROM "lime_source_message" "t1", "lime_message" "t2" WHERE t1.id=t2.id AND t1.category=:category AND t2.language=:language. Bound with :category='', :language='en') 1 0.00041 0.00041 0.00041 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_users" "t" WHERE "t"."uid"=32 LIMIT 1) 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.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groupsettings" "t" WHERE "t"."gsid"=0 LIMIT 1) 1 0.00022 0.00022 0.00022 0.00022
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=440) 3 0.00095 0.00032 0.00026 0.00038
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_template_configuration', :schema='public') 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_surveys_groups', :schema='public') 1 0.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_templates', :schema='public') 1 0.00077 0.00077 0.00077 0.00077
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.00119 0.00119 0.00119 0.00119
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.00099 0.00099 0.00099 0.00099
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='shortfreetext', :extends='S') 44 0.02012 0.00046 0.00031 0.00084
system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t") 1 0.00039 0.00039 0.00039 0.00039
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.00117 0.00117 0.00117 0.00117
system.db.CDbCommand.query(SELECT "t"."surveyls_survey_id" AS "t0_c0", "t"."surveyls_language" AS "t0_c1", "t"."surveyls_title" AS "t0_c2", "t"."surveyls_description" AS "t0_c3", "t"."surveyls_welcometext" AS "t0_c4", "t"."surveyls_endtext" AS "t0_c5", "t"."surveyls_url" AS "t0_c6", "t"."surveyls_urldescription" AS "t0_c7", "t"."surveyls_email_invite_subj" AS "t0_c8", "t"."surveyls_email_invite" AS "t0_c9", "t"."surveyls_email_remind_subj" AS "t0_c10", "t"."surveyls_email_remind" AS "t0_c11", "t"."surveyls_email_register_subj" AS "t0_c12", "t"."surveyls_email_register" AS "t0_c13", "t"."surveyls_email_confirm_subj" AS "t0_c14", "t"."surveyls_email_confirm" AS "t0_c15", "t"."surveyls_dateformat" AS "t0_c16", "t"."surveyls_attributecaptions" AS "t0_c17", "t"."email_admin_notification_subj" AS "t0_c18", "t"."email_admin_notification" AS "t0_c19", "t"."email_admin_responses_subj" AS "t0_c20", "t"."email_admin_responses" AS "t0_c21", "t"."surveyls_numberformat" AS "t0_c22", "t"."attachments" AS "t0_c23", "t"."surveyls_policy_notice" AS "t0_c24", "t"."surveyls_policy_error" AS "t0_c25", "t"."surveyls_policy_notice_label" AS "t0_c26", "t"."surveyls_alias" AS "t0_c27", "survey"."sid" AS "t1_c0", "survey"."owner_id" AS "t1_c1", "survey"."admin" AS "t1_c2", "survey"."active" AS "t1_c3", "survey"."expires" AS "t1_c4", "survey"."startdate" AS "t1_c5", "survey"."adminemail" AS "t1_c6", "survey"."anonymized" AS "t1_c7", "survey"."faxto" AS "t1_c8", "survey"."format" AS "t1_c9", "survey"."savetimings" AS "t1_c10", "survey"."template" AS "t1_c11", "survey"."language" AS "t1_c12", "survey"."additional_languages" AS "t1_c13", "survey"."datestamp" AS "t1_c14", "survey"."usecookie" AS "t1_c15", "survey"."allowregister" AS "t1_c16", "survey"."allowsave" AS "t1_c17", "survey"."autonumber_start" AS "t1_c18", "survey"."autoredirect" AS "t1_c19", "survey"."allowprev" AS "t1_c20", "survey"."printanswers" AS "t1_c21", "survey"."ipaddr" AS "t1_c22", "survey"."refurl" AS "t1_c23", "survey"."datecreated" AS "t1_c24", "survey"."publicstatistics" AS "t1_c25", "survey"."publicgraphs" AS "t1_c26", "survey"."listpublic" AS "t1_c27", "survey"."htmlemail" AS "t1_c28", "survey"."sendconfirmation" AS "t1_c29", "survey"."tokenanswerspersistence" AS "t1_c30", "survey"."assessments" AS "t1_c31", "survey"."usecaptcha" AS "t1_c32", "survey"."usetokens" AS "t1_c33", "survey"."bounce_email" AS "t1_c34", "survey"."attributedescriptions" AS "t1_c35", "survey"."emailresponseto" AS "t1_c36", "survey"."emailnotificationto" AS "t1_c37", "survey"."tokenlength" AS "t1_c38", "survey"."showxquestions" AS "t1_c39", "survey"."showgroupinfo" AS "t1_c40", "survey"."shownoanswer" AS "t1_c41", "survey"."showqnumcode" AS "t1_c42", "survey"."bouncetime" AS "t1_c43", "survey"."bounceprocessing" AS "t1_c44", "survey"."bounceaccounttype" AS "t1_c45", "survey"."bounceaccounthost" AS "t1_c46", "survey"."bounceaccountpass" AS "t1_c47", "survey"."bounceaccountencryption" AS "t1_c48", "survey"."bounceaccountuser" AS "t1_c49", "survey"."showwelcome" AS "t1_c50", "survey"."showprogress" AS "t1_c51", "survey"."questionindex" AS "t1_c52", "survey"."navigationdelay" AS "t1_c53", "survey"."nokeyboard" AS "t1_c54", "survey"."alloweditaftercompletion" AS "t1_c55", "survey"."googleanalyticsstyle" AS "t1_c56", "survey"."googleanalyticsapikey" AS "t1_c57", "survey"."gsid" AS "t1_c58", "survey"."showsurveypolicynotice" AS "t1_c59", "survey"."tokenencryptionoptions" AS "t1_c60", "survey"."ipanonymize" AS "t1_c61" FROM "lime_surveys_languagesettings" "t" LEFT OUTER JOIN "lime_surveys" "survey" ON (t.surveyls_survey_id = survey.sid) WHERE ("t"."surveyls_survey_id"=543986 AND "t"."surveyls_language"='de')) 1 0.01722 0.01722 0.01722 0.01722
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.00033 0.00033 0.00033 0.00033
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.00383 0.00383 0.00383 0.00383
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.00101 0.00101 0.00101 0.00101
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.00097 0.00097 0.00097 0.00097
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.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_groups', :schema='public') 1 0.00086 0.00086 0.00086 0.00086
system.db.CDbCommand.query(SELECT * FROM "lime_surveys_groups" "t" WHERE "t"."gsid"=1 LIMIT 1) 3 0.00080 0.00027 0.00020 0.00039
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.00065 0.00065 0.00065 0.00065
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.00063 0.00063 0.00063 0.00063
system.db.CDbCommand.query(SELECT "owner"."uid" AS "t1_c0", "owner"."users_name" AS "t1_c1", "owner"."full_name" AS "t1_c2", "owner"."parent_id" AS "t1_c3", "owner"."lang" AS "t1_c4", "owner"."email" AS "t1_c5", "owner"."htmleditormode" AS "t1_c6", "owner"."templateeditormode" AS "t1_c7", "owner"."questionselectormode" AS "t1_c8", "owner"."dateformat" AS "t1_c9", "owner"."created" AS "t1_c10", "owner"."modified" AS "t1_c11", "owner"."password" AS "t1_c12", "owner"."one_time_pw" AS "t1_c13", "owner"."last_login" 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=32) 1 0.00050 0.00050 0.00050 0.00050
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.00040 0.00040 0.00040 0.00040
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.00084 0.00084 0.00084 0.00084
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=441) 3 0.00065 0.00022 0.00019 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.00030 0.00030 0.00030 0.00030
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=442) 3 0.00054 0.00018 0.00014 0.00021
system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1) 1 0.00039 0.00039 0.00039 0.00039
system.db.CDbCommand.query(SELECT "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=439) 3 0.00054 0.00018 0.00013 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_groups', :schema='public') 1 0.00029 0.00029 0.00029 0.00029
system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='vanilla' LIMIT 1) 2 0.00075 0.00037 0.00025 0.00049
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='de') 1 0.00055 0.00055 0.00055 0.00055
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='vanilla') 1 0.00050 0.00050 0.00050 0.00050
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.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_template_configuration" "t" WHERE (sid=:sid) AND (template_name=:template_name) LIMIT 1. Bound with :sid=543986, :template_name='vanilla') 1 0.00029 0.00029 0.00029 0.00029
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='vanilla') 3 0.00072 0.00024 0.00022 0.00026
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='de' and gls.language='de' AND g.sid=543986 AND q.parent_qid=0 ORDER BY group_order, question_order) 3 0.00460 0.00153 0.00122 0.00171
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.00138 0.00138 0.00138 0.00138
system.db.CDbCommand.query(SELECT * FROM "lime_questions" "t" WHERE "t"."qid" IN (0, 8355, 8310, 8324, 8335, 8316, 8325, 8327, 8317, 8326, 8328, 8318, 8329, 8330, 8319, 8332, 8331, 8320, 8495, 8321, 8337, 8338, 8339, 8340, 8341, 8342, 8343, 8344, 8345, 8346, 8347, 8348, 8349, 8350, 8351, 8352, 8354, 8353, 8309, 8311, 8312, 8315, 8336, 8313, 8322, 8323, 8333, 8334, 8314, 8452)) 3 0.00189 0.00063 0.00056 0.00071
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.00163 0.00163 0.00163 0.00163
system.db.CDbCommand.query(SELECT COUNT(*) FROM "lime_questions" "t" WHERE "t"."sid"=:yp0 AND "t"."parent_qid"=:yp1. Bound with :yp0=543986, :yp1=0) 3 0.00162 0.00054 0.00029 0.00084
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 = 'de' AND b.same_default=0 AND b.sid = 543986) 3 0.00158 0.00053 0.00040 0.00062
system.db.CDbCommand.query(SELECT COUNT(DISTINCT t.qid) as count FROM "lime_questions" "t" LEFT JOIN "lime_question_attributes" "qa" ON qa.qid = t.qid AND qa.attribute = :hidden WHERE (t.sid = :sid AND t.parent_qid = 0) AND (qa.value IS NULL OR qa.value != :hidden_value). Bound with :hidden='hidden', :sid=543986, :hidden_value='1') 1 0.00148 0.00148 0.00148 0.00148
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE "t"."extends"=:yp0. Bound with :yp0='') 3 0.00136 0.00045 0.00035 0.00052
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 = 'de' AND b.same_default=1 AND b.sid = 543986) 3 0.00110 0.00037 0.00031 0.00044
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.00092 0.00092 0.00092 0.00092
system.db.CDbCommand.query(select count(*) from "lime_groups" left join lime_questions on "lime_groups".gid=lime_questions.gid where "lime_groups".sid=543986 and qid is null) 1 0.00067 0.00067 0.00067 0.00067
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.00042 0.00042 0.00042 0.00042
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='de' AND q.sid=543986 ORDER BY sq.parent_qid, q.question_order,sq.scale_id, sq.question_order) 1 0.00129 0.00129 0.00129 0.00129
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.00101 0.00101 0.00101 0.00101
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 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_543986', :schema='public') 1 0.00215 0.00215 0.00215 0.00215
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_survey_543986', :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_question_attributes', :schema='public') 1 0.00061 0.00061 0.00061 0.00061
system.db.CDbCommand.query(select '' as act, up.*,q.title, sq.title as sqtitle from lime_survey_url_parameters up left join lime_questions q on q.qid=up.targetqid left join lime_questions sq on q.qid=up.targetsqid where up.sid=:surveyid. Bound with :surveyid=543986) 1 0.00037 0.00037 0.00037 0.00037
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.00030 0.00030 0.00030 0.00030
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_543986', :schema='public') 1 0.00030 0.00030 0.00030 0.00030
system.db.CDbCommand.query(SELECT * FROM "lime_groups" "t" WHERE (sid=:ycp0) AND (randomization_group != ''). Bound with :ycp0=543986) 1 0.00029 0.00029 0.00029 0.00029
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.00085 0.00085 0.00085 0.00085
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.00028 0.00028 0.00028 0.00028
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_plugins', :schema='public') 1 0.00027 0.00027 0.00027 0.00027
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='vanilla') 1 0.00026 0.00026 0.00026 0.00026
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 =543986 and qid is not null) 4 0.00306 0.00077 0.00064 0.00093
system.db.CDbCommand.query(SELECT "t"."qid" AS "t0_c0", "t"."parent_qid" AS "t0_c1", "t"."sid" AS "t0_c2", "t"."gid" AS "t0_c3", "t"."type" AS "t0_c4", "t"."title" AS "t0_c5", "t"."preg" AS "t0_c6", "t"."other" AS "t0_c7", "t"."mandatory" AS "t0_c8", "t"."question_order" AS "t0_c9", "t"."scale_id" AS "t0_c10", "t"."same_default" AS "t0_c11", "t"."relevance" AS "t0_c12", "t"."modulename" AS "t0_c13", "t"."encrypted" AS "t0_c14", "t"."question_theme_name" AS "t0_c15", "t"."same_script" AS "t0_c16", "questionattributes"."qaid" AS "t1_c0", "questionattributes"."qid" AS "t1_c1", "questionattributes"."attribute" AS "t1_c2", "questionattributes"."value" AS "t1_c3", "questionattributes"."language" AS "t1_c4" FROM "lime_questions" "t" LEFT OUTER JOIN "lime_question_attributes" "questionattributes" ON ("questionattributes"."qid"="t"."qid") WHERE (attribute='random_group' and value <>'' and sid=543986)) 1 0.00055 0.00055 0.00055 0.00055
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=543986) 1 0.00032 0.00032 0.00032 0.00032
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 * FROM "lime_questions" "t" WHERE sid=:sid and parent_qid=0. Bound with :sid=543986) 2 0.00112 0.00056 0.00049 0.00064
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='longfreetext', :extends='T') 8 0.00351 0.00044 0.00029 0.00063
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='') 8 0.00305 0.00038 0.00025 0.00047
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='image_select-multiplechoice', :extends='M') 4 0.00174 0.00044 0.00035 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8324) 2 0.00081 0.00041 0.00032 0.00049
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') 28 0.01244 0.00044 0.00028 0.00065
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='') 28 0.01144 0.00041 0.00024 0.00063
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='') 12 0.00537 0.00045 0.00030 0.00079
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='image_select-listradio', :extends='L') 8 0.00415 0.00052 0.00044 0.00085
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8334) 2 0.00100 0.00050 0.00048 0.00052
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8314) 2 0.00098 0.00049 0.00043 0.00055
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8329) 2 0.00092 0.00046 0.00042 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8347) 2 0.00080 0.00040 0.00040 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8351) 2 0.00078 0.00039 0.00035 0.00044
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8338) 2 0.00078 0.00039 0.00037 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8495) 2 0.00059 0.00029 0.00029 0.00030
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8316) 2 0.00058 0.00029 0.00028 0.00029
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8327) 2 0.00094 0.00047 0.00047 0.00047
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8333) 2 0.00092 0.00046 0.00045 0.00047
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8332) 2 0.00089 0.00045 0.00040 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8320) 2 0.00070 0.00035 0.00032 0.00038
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8342) 2 0.00086 0.00043 0.00041 0.00045
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='listradio', :extends='L') 4 0.00182 0.00046 0.00036 0.00056
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8325) 2 0.00053 0.00026 0.00025 0.00028
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8346) 2 0.00094 0.00047 0.00045 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8348) 2 0.00093 0.00046 0.00044 0.00049
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8350) 2 0.00090 0.00045 0.00044 0.00045
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8344) 2 0.00089 0.00045 0.00041 0.00048
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8331) 2 0.00087 0.00043 0.00043 0.00044
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8341) 2 0.00085 0.00042 0.00033 0.00052
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8317) 2 0.00073 0.00036 0.00036 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8349) 2 0.00072 0.00036 0.00033 0.00039
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8352) 2 0.00071 0.00036 0.00035 0.00036
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8318) 2 0.00085 0.00043 0.00038 0.00047
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8321) 2 0.00075 0.00037 0.00035 0.00040
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8335) 2 0.00076 0.00038 0.00031 0.00045
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8311) 2 0.00087 0.00044 0.00030 0.00057
system.db.CDbCommand.query(SELECT * FROM "lime_question_themes" "t" WHERE name = :name AND extends = :extends LIMIT 1. Bound with :name='numerical', :extends='N') 2 0.00075 0.00037 0.00031 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='N', :extends='') 2 0.00072 0.00036 0.00029 0.00043
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8340) 2 0.00067 0.00034 0.00026 0.00041
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8309) 2 0.00060 0.00030 0.00025 0.00035
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8337) 2 0.00057 0.00029 0.00024 0.00033
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='') 4 0.00157 0.00039 0.00030 0.00046
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8312) 2 0.00085 0.00043 0.00036 0.00050
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8328) 2 0.00090 0.00045 0.00039 0.00050
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8315) 2 0.00098 0.00049 0.00047 0.00051
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8330) 2 0.00087 0.00043 0.00042 0.00045
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8336) 2 0.00083 0.00042 0.00040 0.00043
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8345) 2 0.00071 0.00035 0.00034 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8319) 2 0.00069 0.00035 0.00032 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8339) 2 0.00067 0.00034 0.00033 0.00034
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8310) 2 0.00070 0.00035 0.00034 0.00037
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8313) 2 0.00091 0.00045 0.00043 0.00047
system.db.CDbCommand.execute(INSERT INTO "lime_survey_543986" ("startlanguage", "datestamp", "startdate", "seed", "lastpage") VALUES (:yp0, :yp1, :yp2, :yp3, :yp4). Bound with :yp0='de', :yp1='2025-04-18 10:37:30', :yp2='2025-04-18 10:37:30', :yp3='1732971170', :yp4=NULL) 1 0.01433 0.01433 0.01433 0.01433
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 = 543986 and l.language='de' ORDER BY a.qid, a.scale_id, a.sortorder) 2 0.00826 0.00413 0.00356 0.00470
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8323) 2 0.00097 0.00048 0.00044 0.00052
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8354) 2 0.00097 0.00049 0.00045 0.00053
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8322) 2 0.00096 0.00048 0.00046 0.00050
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8355) 2 0.00086 0.00043 0.00039 0.00048
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8353) 2 0.00074 0.00037 0.00036 0.00038
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8343) 2 0.00071 0.00036 0.00034 0.00038
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_543986_timings', :schema='public') 1 0.00332 0.00332 0.00332 0.00332
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_543986_timings', :schema='public') 1 0.00296 0.00296 0.00296 0.00296
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_543986_timings', :schema='public') 1 0.00080 0.00080 0.00080 0.00080
system.db.CDbCommand.query(SELECT * FROM "lime_survey_543986" "t" WHERE "t"."id"=4773 LIMIT 1) 2 0.01001 0.00501 0.00155 0.00847
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8326) 2 0.00060 0.00030 0.00027 0.00033
system.db.CDbCommand.execute(INSERT INTO "lime_survey_543986_timings" ("id", "interviewtime") VALUES (:yp0, :yp1). Bound with :yp0=4773, :yp1=0) 1 0.00790 0.00790 0.00790 0.00790
system.db.CDbCommand.execute(UPDATE "lime_survey_543986" SET "id"=:yp0, "token"=:yp1, "submitdate"=:yp2, "lastpage"=:yp3, "startlanguage"=:yp4, "seed"=:yp5, "startdate"=:yp6, "datestamp"=:yp7, "refurl"=:yp8, "543986X440X8355"=:yp9, "543986X440X8310SQ001#0"=:yp10, "543986X440X8310SQ001#1"=:yp11, "543986X440X8310SQ002#0"=:yp12, "543986X440X8310SQ002#1"=:yp13, "543986X440X8310SQ003#0"=:yp14, "543986X440X8310SQ003#1"=:yp15, "543986X440X8310SQ004#0"=:yp16, "543986X440X8310SQ004#1"=:yp17, "543986X440X8324"=:yp18, "543986X440X8335"=:yp19, "543986X440X8316SQ001#0"=:yp20, "543986X440X8316SQ001#1"=:yp21, "543986X440X8316SQ002#0"=:yp22, "543986X440X8316SQ002#1"=:yp23, "543986X440X8316SQ003#0"=:yp24, "543986X440X8316SQ003#1"=:yp25, "543986X440X8316SQ004#0"=:yp26, "543986X440X8316SQ004#1"=:yp27, "543986X440X8316SQ005#0"=:yp28, "543986X440X8316SQ005#1"=:yp29, "543986X440X8316SQ006#0"=:yp30, "543986X440X8316SQ006#1"=:yp31, "543986X440X8316SQ007#0"=:yp32, "543986X440X8316SQ007#1"=:yp33, "543986X440X8316SQ008#0"=:yp34, "543986X440X8316SQ008#1"=:yp35, "543986X440X8316SQ009#0"=:yp36, "543986X440X8316SQ009#1"=:yp37, "543986X440X8316SQ010#0"=:yp38, "543986X440X8316SQ010#1"=:yp39, "543986X440X8316SQ011#0"=:yp40, "543986X440X8316SQ011#1"=:yp41, "543986X440X8316SQ012#0"=:yp42, "543986X440X8316SQ012#1"=:yp43, "543986X440X8316SQ013#0"=:yp44, "543986X440X8316SQ013#1"=:yp45, "543986X440X8316SQ014#0"=:yp46, "543986X440X8316SQ014#1"=:yp47, "543986X440X8316SQ015#0"=:yp48, "543986X440X8316SQ015#1"=:yp49, "543986X440X8316SQ016#0"=:yp50, "543986X440X8316SQ016#1"=:yp51, "543986X440X8325"=:yp52, "543986X440X8327"=:yp53, "543986X440X8317SQ001#0"=:yp54, "543986X440X8317SQ001#1"=:yp55, "543986X440X8317SQ002#0"=:yp56, "543986X440X8317SQ002#1"=:yp57, "543986X440X8317SQ003#0"=:yp58, "543986X440X8317SQ003#1"=:yp59, "543986X440X8317SQ004#0"=:yp60, "543986X440X8317SQ004#1"=:yp61, "543986X440X8317SQ005#0"=:yp62, "543986X440X8317SQ005#1"=:yp63, "543986X440X8317SQ006#0"=:yp64, "543986X440X8317SQ006#1"=:yp65, "543986X440X8317SQ007#0"=:yp66, "543986X440X8317SQ007#1"=:yp67, "543986X440X8317SQ008#0"=:yp68, "543986X440X8317SQ008#1"=:yp69, "543986X440X8317SQ009#0"=:yp70, "543986X440X8317SQ009#1"=:yp71, "543986X440X8317SQ010#0"=:yp72, "543986X440X8317SQ010#1"=:yp73, "543986X440X8317SQ011#0"=:yp74, "543986X440X8317SQ011#1"=:yp75, "543986X440X8317SQ012#0"=:yp76, "543986X440X8317SQ012#1"=:yp77, "543986X440X8317SQ013#0"=:yp78, "543986X440X8317SQ013#1"=:yp79, "543986X440X8317SQ014#0"=:yp80, "543986X440X8317SQ014#1"=:yp81, "543986X440X8317SQ015#0"=:yp82, "543986X440X8317SQ015#1"=:yp83, "543986X440X8317SQ016#0"=:yp84, "543986X440X8317SQ016#1"=:yp85, "543986X440X8317SQ017#0"=:yp86, "543986X440X8317SQ017#1"=:yp87, "543986X440X8326"=:yp88, "543986X440X8328"=:yp89, "543986X440X8318SQ001#0"=:yp90, "543986X440X8318SQ001#1"=:yp91, "543986X440X8318SQ002#0"=:yp92, "543986X440X8318SQ002#1"=:yp93, "543986X440X8318SQ003#0"=:yp94, "543986X440X8318SQ003#1"=:yp95, "543986X440X8318SQ004#0"=:yp96, "543986X440X8318SQ004#1"=:yp97, "543986X440X8318SQ005#0"=:yp98, "543986X440X8318SQ005#1"=:yp99, "543986X440X8318SQ006#0"=:yp100, "543986X440X8318SQ006#1"=:yp101, "543986X440X8329"=:yp102, "543986X440X8330"=:yp103, "543986X440X8319SQ001#0"=:yp104, "543986X440X8319SQ001#1"=:yp105, "543986X440X8319SQ002#0"=:yp106, "543986X440X8319SQ002#1"=:yp107, "543986X440X8319SQ003#0"=:yp108, "543986X440X8319SQ003#1"=:yp109, "543986X440X8319SQ004#0"=:yp110, "543986X440X8319SQ004#1"=:yp111, "543986X440X8319SQ005#0"=:yp112, "543986X440X8319SQ005#1"=:yp113, "543986X440X8319SQ006#0"=:yp114, "543986X440X8319SQ006#1"=:yp115, "543986X440X8319SQ007#0"=:yp116, "543986X440X8319SQ007#1"=:yp117, "543986X440X8319SQ008#0"=:yp118, "543986X440X8319SQ008#1"=:yp119, "543986X440X8319SQ009#0"=:yp120, "543986X440X8319SQ009#1"=:yp121, "543986X440X8332"=:yp122, "543986X440X8331"=:yp123, "543986X440X8320SQ001#0"=:yp124, "543986X440X8320SQ001#1"=:yp125, "543986X440X8320SQ002#0"=:yp126, "543986X440X8320SQ002#1"=:yp127, "543986X440X8320SQ003#0"=:yp128, "543986X440X8320SQ003#1"=:yp129, "543986X440X8320SQ004#0"=:yp130, "543986X440X8320SQ004#1"=:yp131, "543986X440X8320SQ005#0"=:yp132, "543986X440X8320SQ005#1"=:yp133, "543986X440X8495"=:yp134, "543986X440X8321"=:yp135, "543986X441X8337SQ001#0"=:yp136, "543986X441X8337SQ001#1"=:yp137, "543986X441X8337SQ002#0"=:yp138, "543986X441X8337SQ002#1"=:yp139, "543986X441X8337SQ003#0"=:yp140, "543986X441X8337SQ003#1"=:yp141, "543986X441X8337SQ004#0"=:yp142, "543986X441X8337SQ004#1"=:yp143, "543986X441X8337SQ005#0"=:yp144, "543986X441X8337SQ005#1"=:yp145, "543986X441X8338"=:yp146, "543986X441X8339SQ001#0"=:yp147, "543986X441X8339SQ001#1"=:yp148, "543986X441X8339SQ002#0"=:yp149, "543986X441X8339SQ002#1"=:yp150, "543986X441X8340"=:yp151, "543986X441X8341SQ001#0"=:yp152, "543986X441X8341SQ001#1"=:yp153, "543986X441X8341SQ002#0"=:yp154, "543986X441X8341SQ002#1"=:yp155, "543986X441X8341SQ003#0"=:yp156, "543986X441X8341SQ003#1"=:yp157, "543986X441X8341SQ004#0"=:yp158, "543986X441X8341SQ004#1"=:yp159, "543986X441X8341SQ005#0"=:yp160, "543986X441X8341SQ005#1"=:yp161, "543986X441X8341SQ006#0"=:yp162, "543986X441X8341SQ006#1"=:yp163, "543986X441X8342"=:yp164, "543986X441X8343SQ001#0"=:yp165, "543986X441X8343SQ001#1"=:yp166, "543986X441X8343SQ002#0"=:yp167, "543986X441X8343SQ002#1"=:yp168, "543986X441X8344"=:yp169, "543986X441X8345SQ001#0"=:yp170, "543986X441X8345SQ001#1"=:yp171, "543986X441X8345SQ002#0"=:yp172, "543986X441X8345SQ002#1"=:yp173, "543986X441X8345SQ003#0"=:yp174, "543986X441X8345SQ003#1"=:yp175, "543986X441X8345SQ004#0"=:yp176, "543986X441X8345SQ004#1"=:yp177, "543986X441X8346"=:yp178, "543986X441X8347SQ001#0"=:yp179, "543986X441X8347SQ001#1"=:yp180, "543986X441X8347SQ002#0"=:yp181, "543986X441X8347SQ002#1"=:yp182, "543986X441X8347SQ003#0"=:yp183, "543986X441X8347SQ003#1"=:yp184, "543986X441X8347SQ004#0"=:yp185, "543986X441X8347SQ004#1"=:yp186, "543986X441X8348"=:yp187, "543986X441X8349SQ001#0"=:yp188, "543986X441X8349SQ001#1"=:yp189, "543986X441X8349SQ002#0"=:yp190, "543986X441X8349SQ002#1"=:yp191, "543986X441X8349SQ003#0"=:yp192, "543986X441X8349SQ003#1"=:yp193, "543986X441X8349SQ004#0"=:yp194, "543986X441X8349SQ004#1"=:yp195, "543986X441X8349SQ005#0"=:yp196, "543986X441X8349SQ005#1"=:yp197, "543986X441X8349SQ006#0"=:yp198, "543986X441X8349SQ006#1"=:yp199, "543986X441X8350"=:yp200, "543986X441X8351"=:yp201, "543986X442X8352SQ001#0"=:yp202, "543986X442X8352SQ001#1"=:yp203, "543986X442X8352SQ002#0"=:yp204, "543986X442X8352SQ002#1"=:yp205, "543986X442X8352SQ003#0"=:yp206, "543986X442X8352SQ003#1"=:yp207, "543986X442X8352SQ004#0"=:yp208, "543986X442X8352SQ004#1"=:yp209, "543986X442X8352SQ005#0"=:yp210, "543986X442X8352SQ005#1"=:yp211, "543986X442X8352SQ006#0"=:yp212, "543986X442X8352SQ006#1"=:yp213, "543986X442X8352SQ007#0"=:yp214, "543986X442X8352SQ007#1"=:yp215, "543986X442X8352SQ008#0"=:yp216, "543986X442X8352SQ008#1"=:yp217, "543986X442X8352SQ009#0"=:yp218, "543986X442X8352SQ009#1"=:yp219, "543986X442X8352SQ010#0"=:yp220, "543986X442X8352SQ010#1"=:yp221, "543986X442X8352SQ011#0"=:yp222, "543986X442X8352SQ011#1"=:yp223, "543986X442X8354"=:yp224, "543986X442X8353"=:yp225, "543986X439X8309"=:yp226, "543986X439X8311"=:yp227, "543986X439X8312SQ001"=:yp228, "543986X439X8312SQ002"=:yp229, "543986X439X8312SQ003"=:yp230, "543986X439X8312SQ004"=:yp231, "543986X439X8312SQ005"=:yp232, "543986X439X8312SQ006"=:yp233, "543986X439X8312SQ007"=:yp234, "543986X439X8312SQ008"=:yp235, "543986X439X8312SQ009"=:yp236, "543986X439X8312SQ010"=:yp237, "543986X439X8312other"=:yp238, "543986X439X8315"=:yp239, "543986X439X8336"=:yp240, "543986X439X8313SQ002"=:yp241, "543986X439X8313SQ001"=:yp242, "543986X439X8313SQ003"=:yp243, "543986X439X8313SQ004"=:yp244, "543986X439X8313SQ005"=:yp245, "543986X439X8313other"=:yp246, "543986X439X8322"=:yp247, "543986X439X8323"=:yp248, "543986X439X8333"=:yp249, "543986X439X8334"=:yp250, "543986X439X8314"=:yp251, "543986X439X8314other"=:yp252, "543986X439X8452"=:yp253 WHERE "lime_survey_543986"."id"=4773. Bound with :yp0=4773, :yp1=NULL, :yp2=NULL, :yp3=-1, :yp4='de', :yp5='1732971170', :yp6='2025-04-18 10:37:30', :yp7='2025-04-18 10:37:30', :yp8=NULL, :yp9='link', :yp10=NULL, :yp11=NULL, :yp12=NULL, :yp13=NULL, :yp14=NULL, :yp15=NULL, :yp16=NULL, :yp17=NULL, :yp18=NULL, :yp19=NULL, :yp20=NULL, :yp21=NULL, :yp22=NULL, :yp23=NULL, :yp24=NULL, :yp25=NULL, :yp26=NULL, :yp27=NULL, :yp28=NULL, :yp29=NULL, :yp30=NULL, :yp31=NULL, :yp32=NULL, :yp33=NULL, :yp34=NULL, :yp35=NULL, :yp36=NULL, :yp37=NULL, :yp38=NULL, :yp39=NULL, :yp40=NULL, :yp41=NULL, :yp42=NULL, :yp43=NULL, :yp44=NULL, :yp45=NULL, :yp46=NULL, :yp47=NULL, :yp48=NULL, :yp49=NULL, :yp50=NULL, :yp51=NULL, :yp52=NULL, :yp53=NULL, :yp54=NULL, :yp55=NULL, :yp56=NULL, :yp57=NULL, :yp58=NULL, :yp59=NULL, :yp60=NULL, :yp61=NULL, :yp62=NULL, :yp63=NULL, :yp64=NULL, :yp65=NULL, :yp66=NULL, :yp67=NULL, :yp68=NULL, :yp69=NULL, :yp70=NULL, :yp71=NULL, :yp72=NULL, :yp73=NULL, :yp74=NULL, :yp75=NULL, :yp76=NULL, :yp77=NULL, :yp78=NULL, :yp79=NULL, :yp80=NULL, :yp81=NULL, :yp82=NULL, :yp83=NULL, :yp84=NULL, :yp85=NULL, :yp86=NULL, :yp87=NULL, :yp88=NULL, :yp89=NULL, :yp90=NULL, :yp91=NULL, :yp92=NULL, :yp93=NULL, :yp94=NULL, :yp95=NULL, :yp96=NULL, :yp97=NULL, :yp98=NULL, :yp99=NULL, :yp100=NULL, :yp101=NULL, :yp102=NULL, :yp103=NULL, :yp104=NULL, :yp105=NULL, :yp106=NULL, :yp107=NULL, :yp108=NULL, :yp109=NULL, :yp110=NULL, :yp111=NULL, :yp112=NULL, :yp113=NULL, :yp114=NULL, :yp115=NULL, :yp116=NULL, :yp117=NULL, :yp118=NULL, :yp119=NULL, :yp120=NULL, :yp121=NULL, :yp122=NULL, :yp123=NULL, :yp124=NULL, :yp125=NULL, :yp126=NULL, :yp127=NULL, :yp128=NULL, :yp129=NULL, :yp130=NULL, :yp131=NULL, :yp132=NULL, :yp133=NULL, :yp134=NULL, :yp135=NULL, :yp136=NULL, :yp137=NULL, :yp138=NULL, :yp139=NULL, :yp140=NULL, :yp141=NULL, :yp142=NULL, :yp143=NULL, :yp144=NULL, :yp145=NULL, :yp146=NULL, :yp147=NULL, :yp148=NULL, :yp149=NULL, :yp150=NULL, :yp151=NULL, :yp152=NULL, :yp153=NULL, :yp154=NULL, :yp155=NULL, :yp156=NULL, :yp157=NULL, :yp158=NULL, :yp159=NULL, :yp160=NULL, :yp161=NULL, :yp162=NULL, :yp163=NULL, :yp164=NULL, :yp165=NULL, :yp166=NULL, :yp167=NULL, :yp168=NULL, :yp169=NULL, :yp170=NULL, :yp171=NULL, :yp172=NULL, :yp173=NULL, :yp174=NULL, :yp175=NULL, :yp176=NULL, :yp177=NULL, :yp178=NULL, :yp179=NULL, :yp180=NULL, :yp181=NULL, :yp182=NULL, :yp183=NULL, :yp184=NULL, :yp185=NULL, :yp186=NULL, :yp187=NULL, :yp188=NULL, :yp189=NULL, :yp190=NULL, :yp191=NULL, :yp192=NULL, :yp193=NULL, :yp194=NULL, :yp195=NULL, :yp196=NULL, :yp197=NULL, :yp198=NULL, :yp199=NULL, :yp200=NULL, :yp201=NULL, :yp202=NULL, :yp203=NULL, :yp204=NULL, :yp205=NULL, :yp206=NULL, :yp207=NULL, :yp208=NULL, :yp209=NULL, :yp210=NULL, :yp211=NULL, :yp212=NULL, :yp213=NULL, :yp214=NULL, :yp215=NULL, :yp216=NULL, :yp217=NULL, :yp218=NULL, :yp219=NULL, :yp220=NULL, :yp221=NULL, :yp222=NULL, :yp223=NULL, :yp224=NULL, :yp225=NULL, :yp226=NULL, :yp227=NULL, :yp228=NULL, :yp229=NULL, :yp230=NULL, :yp231=NULL, :yp232=NULL, :yp233=NULL, :yp234=NULL, :yp235=NULL, :yp236=NULL, :yp237=NULL, :yp238=NULL, :yp239=NULL, :yp240=NULL, :yp241=NULL, :yp242=NULL, :yp243=NULL, :yp244=NULL, :yp245=NULL, :yp246=NULL, :yp247=NULL, :yp248=NULL, :yp249=NULL, :yp250=NULL, :yp251=NULL, :yp252=NULL, :yp253=NULL) 1 0.00423 0.00423 0.00423 0.00423
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype::char, conrelid AS relid, NULL AS indkey FROM pg_catalog.pg_constraint WHERE contype IN ('f', 'c') UNION ALL SELECT pc.relname, NULL, CASE WHEN indisprimary THEN 'p' ELSE 'u' END, pi.indrelid, indkey FROM pg_catalog.pg_class pc, pg_catalog.pg_index pi WHERE pc.oid=pi.indexrelid AND EXISTS ( SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c ON (d.refclassid = c.tableoid AND d.refobjid = c.oid) WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p') ) ) AS sub WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema)). Bound with :table='lime_asset_version', :schema='public') 1 0.00320 0.00320 0.00320 0.00320
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_quota', :schema='public') 1 0.00293 0.00293 0.00293 0.00293
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_quota', :schema='public') 1 0.00223 0.00223 0.00223 0.00223
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_quota_members', :schema='public') 1 0.00133 0.00133 0.00133 0.00133
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_quota_languagesettings', :schema='public') 1 0.00126 0.00126 0.00126 0.00126
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_quota_members', :schema='public') 1 0.00106 0.00106 0.00106 0.00106
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_quota', :schema='public') 1 0.00085 0.00085 0.00085 0.00085
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_quota_languagesettings', :schema='public') 1 0.00166 0.00166 0.00166 0.00166
system.db.CDbCommand.query(SELECT "t"."id" AS "t0_c0", "t"."sid" AS "t0_c1", "t"."name" AS "t0_c2", "t"."qlimit" AS "t0_c3", "t"."action" AS "t0_c4", "t"."active" AS "t0_c5", "t"."autoload_url" AS "t0_c6", "languagesettings"."quotals_id" AS "t1_c0", "languagesettings"."quotals_quota_id" AS "t1_c1", "languagesettings"."quotals_language" AS "t1_c2", "languagesettings"."quotals_name" AS "t1_c3", "languagesettings"."quotals_message" AS "t1_c4", "languagesettings"."quotals_url" AS "t1_c5", "languagesettings"."quotals_urldescrip" AS "t1_c6", "quotaMembers"."id" AS "t2_c0", "quotaMembers"."sid" AS "t2_c1", "quotaMembers"."qid" AS "t2_c2", "quotaMembers"."quota_id" AS "t2_c3", "quotaMembers"."code" AS "t2_c4", "question"."qid" AS "t3_c0", "question"."parent_qid" AS "t3_c1", "question"."sid" AS "t3_c2", "question"."gid" AS "t3_c3", "question"."type" AS "t3_c4", "question"."title" AS "t3_c5", "question"."preg" AS "t3_c6", "question"."other" AS "t3_c7", "question"."mandatory" AS "t3_c8", "question"."question_order" AS "t3_c9", "question"."scale_id" AS "t3_c10", "question"."same_default" AS "t3_c11", "question"."relevance" AS "t3_c12", "question"."modulename" AS "t3_c13", "question"."encrypted" AS "t3_c14", "question"."question_theme_name" AS "t3_c15", "question"."same_script" AS "t3_c16" FROM "lime_quota" "t" LEFT OUTER JOIN "lime_quota_languagesettings" "languagesettings" ON ("languagesettings"."quotals_quota_id"="t"."id") LEFT OUTER JOIN "lime_quota_members" "quotaMembers" ON ("quotaMembers"."quota_id"="t"."id") LEFT OUTER JOIN "lime_questions" "question" ON ("quotaMembers"."qid"="question"."qid") WHERE ("t"."sid"=:yp0). Bound with :yp0=543986) 1 0.00110 0.00110 0.00110 0.00110
system.db.CDbCommand.query(SELECT "lime_surveys"."sid" FROM "lime_surveys" WHERE lime_surveys.sid = :sid. Bound with :sid=543986) 1 0.00044 0.00044 0.00044 0.00044
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_quota_members', :schema='public') 1 0.00042 0.00042 0.00042 0.00042
system.db.CDbCommand.query(SELECT "submitdate" FROM "lime_survey_543986" WHERE id=:id. Bound with :id='4773') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, pg_get_expr(adbin, adrelid) AS adsrc, a.attnotnull, a.atthasdef, pg_catalog.col_description(a.attrelid, a.attnum) AS comment FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum WHERE a.attnum > 0 AND NOT a.attisdropped AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema)) ORDER BY a.attnum. Bound with :table='lime_asset_version', :schema='public') 1 0.00230 0.00230 0.00230 0.00230
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_quota_languagesettings', :schema='public') 1 0.00048 0.00048 0.00048 0.00048
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='lime_asset_version', :schema='public') 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/vanilla/files/favicon.ico') 1 0.00066 0.00066 0.00066 0.00066
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/vanilla/files/logo.png') 1 0.00025 0.00025 0.00025 0.00025
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/node_modules/decimal.js') 1 0.00068 0.00068 0.00068 0.00068
system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/vendor/yiisoft/yii/framework/web/js/source') 1 0.00060 0.00060 0.00060 0.00060
system.db.CDbCommand.query(SELECT * FROM "lime_question_attributes" "t" WHERE qid=:qid. Bound with :qid=8452) 2 0.00045 0.00023 0.00021 0.00024