|
Profiling Summary Report
(Time: 0.09315s,
Memory: 6,527KB)
|
| Procedure |
Count |
Total (s) |
Avg. (s) |
Min. (s) |
Max. (s) |
| system.db.CDbCommand.query(SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS adsrc,
a.attnotnull,
a.atthasdef,
pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_settings_global', :schema='public') |
1 |
0.00330 |
0.00330 |
0.00330 |
0.00330 |
| 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.00217 |
0.00217 |
0.00217 |
0.00217 |
| system.db.CDbCommand.query(SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS adsrc,
a.attnotnull,
a.atthasdef,
pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_plugins', :schema='public') |
1 |
0.00101 |
0.00101 |
0.00101 |
0.00101 |
| system.db.CDbCommand.query(SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname=:schema)). Bound with :table='lime_plugins', :schema='public') |
1 |
0.00113 |
0.00113 |
0.00113 |
0.00113 |
| system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t" WHERE stg_name=:name LIMIT 1. Bound with :name='DBVersion') |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SELECT * FROM "lime_templates" "t" WHERE "t"."name"='fruity_twentythree' LIMIT 1) |
2 |
0.00059 |
0.00029 |
0.00019 |
0.00040 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_settings_global', :schema='public') |
1 |
0.00045 |
0.00045 |
0.00045 |
0.00045 |
| 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.00104 |
0.00104 |
0.00104 |
0.00104 |
| system.db.CDbCommand.query(SELECT * FROM "lime_settings_global" "t") |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| 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.00086 |
0.00086 |
0.00086 |
0.00086 |
| 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.00065 |
0.00065 |
0.00065 |
0.00065 |
| system.db.CDbCommand.query(SELECT * FROM "lime_plugins" "t" WHERE "t"."active"=:yp0 ORDER BY priority DESC. Bound with :yp0=1) |
1 |
0.00043 |
0.00043 |
0.00043 |
0.00043 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_templates', :schema='public') |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| system.db.CDbCommand.query(SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname=:schema)). Bound with :table='lime_template_configuration', :schema='public') |
1 |
0.00079 |
0.00079 |
0.00079 |
0.00079 |
| 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.00075 |
0.00075 |
0.00075 |
0.00075 |
| 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.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_plugins', :schema='public') |
1 |
0.00030 |
0.00030 |
0.00030 |
0.00030 |
| 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.00135 |
0.00135 |
0.00135 |
0.00135 |
| 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.00078 |
0.00078 |
0.00078 |
0.00078 |
| 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.00045 |
0.00045 |
0.00045 |
0.00045 |
| system.db.CDbCommand.query(SELECT * FROM "lime_template_configuration" "t" WHERE template_name=:template_name AND sid IS NULL AND gsid IS NULL LIMIT 1. Bound with :template_name='fruity_twentythree') |
1 |
0.00041 |
0.00041 |
0.00041 |
0.00041 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_template_configuration', :schema='public') |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| system.db.CDbCommand.query(SELECT "template"."id" AS "t1_c0", "template"."name" AS "t1_c1", "template"."folder" AS "t1_c2", "template"."title" AS "t1_c3", "template"."creation_date" AS "t1_c4", "template"."author" AS "t1_c5", "template"."author_email" AS "t1_c6", "template"."author_url" AS "t1_c7", "template"."copyright" AS "t1_c8", "template"."license" AS "t1_c9", "template"."version" AS "t1_c10", "template"."api_version" AS "t1_c11", "template"."view_folder" AS "t1_c12", "template"."files_folder" AS "t1_c13", "template"."description" AS "t1_c14", "template"."last_update" AS "t1_c15", "template"."owner_id" AS "t1_c16", "template"."extends" AS "t1_c17" FROM "lime_templates" "template" WHERE ("template"."name"=:ypl0). Bound with :ypl0='fruity_twentythree') |
1 |
0.00023 |
0.00023 |
0.00023 |
0.00023 |
| 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.00023 |
0.00023 |
0.00023 |
0.00023 |
| 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.00066 |
0.00066 |
0.00066 |
0.00066 |
| system.db.CDbCommand.query(SELECT "t"."sid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."active" AS "t0_c3", "t"."expires" AS "t0_c4", "t"."startdate" AS "t0_c5", "t"."adminemail" AS "t0_c6", "t"."anonymized" AS "t0_c7", "t"."faxto" AS "t0_c8", "t"."format" AS "t0_c9", "t"."savetimings" AS "t0_c10", "t"."template" AS "t0_c11", "t"."language" AS "t0_c12", "t"."additional_languages" AS "t0_c13", "t"."datestamp" AS "t0_c14", "t"."usecookie" AS "t0_c15", "t"."allowregister" AS "t0_c16", "t"."allowsave" AS "t0_c17", "t"."autonumber_start" AS "t0_c18", "t"."autoredirect" AS "t0_c19", "t"."allowprev" AS "t0_c20", "t"."printanswers" AS "t0_c21", "t"."ipaddr" AS "t0_c22", "t"."refurl" AS "t0_c23", "t"."datecreated" AS "t0_c24", "t"."publicstatistics" AS "t0_c25", "t"."publicgraphs" AS "t0_c26", "t"."listpublic" AS "t0_c27", "t"."htmlemail" AS "t0_c28", "t"."sendconfirmation" AS "t0_c29", "t"."tokenanswerspersistence" AS "t0_c30", "t"."assessments" AS "t0_c31", "t"."usecaptcha" AS "t0_c32", "t"."usetokens" AS "t0_c33", "t"."bounce_email" AS "t0_c34", "t"."attributedescriptions" AS "t0_c35", "t"."emailresponseto" AS "t0_c36", "t"."emailnotificationto" AS "t0_c37", "t"."tokenlength" AS "t0_c38", "t"."showxquestions" AS "t0_c39", "t"."showgroupinfo" AS "t0_c40", "t"."shownoanswer" AS "t0_c41", "t"."showqnumcode" AS "t0_c42", "t"."bouncetime" AS "t0_c43", "t"."bounceprocessing" AS "t0_c44", "t"."bounceaccounttype" AS "t0_c45", "t"."bounceaccounthost" AS "t0_c46", "t"."bounceaccountpass" AS "t0_c47", "t"."bounceaccountencryption" AS "t0_c48", "t"."bounceaccountuser" AS "t0_c49", "t"."showwelcome" AS "t0_c50", "t"."showprogress" AS "t0_c51", "t"."questionindex" AS "t0_c52", "t"."navigationdelay" AS "t0_c53", "t"."nokeyboard" AS "t0_c54", "t"."alloweditaftercompletion" AS "t0_c55", "t"."googleanalyticsstyle" AS "t0_c56", "t"."googleanalyticsapikey" AS "t0_c57", "t"."gsid" AS "t0_c58", "t"."showsurveypolicynotice" AS "t0_c59", "t"."tokenencryptionoptions" AS "t0_c60", "t"."ipanonymize" AS "t0_c61", "languagesettings"."surveyls_survey_id" AS "t1_c0", "languagesettings"."surveyls_language" AS "t1_c1", "languagesettings"."surveyls_title" AS "t1_c2", "languagesettings"."surveyls_description" AS "t1_c3", "languagesettings"."surveyls_welcometext" AS "t1_c4", "languagesettings"."surveyls_endtext" AS "t1_c5", "languagesettings"."surveyls_url" AS "t1_c6", "languagesettings"."surveyls_urldescription" AS "t1_c7", "languagesettings"."surveyls_email_invite_subj" AS "t1_c8", "languagesettings"."surveyls_email_invite" AS "t1_c9", "languagesettings"."surveyls_email_remind_subj" AS "t1_c10", "languagesettings"."surveyls_email_remind" AS "t1_c11", "languagesettings"."surveyls_email_register_subj" AS "t1_c12", "languagesettings"."surveyls_email_register" AS "t1_c13", "languagesettings"."surveyls_email_confirm_subj" AS "t1_c14", "languagesettings"."surveyls_email_confirm" AS "t1_c15", "languagesettings"."surveyls_dateformat" AS "t1_c16", "languagesettings"."surveyls_attributecaptions" AS "t1_c17", "languagesettings"."email_admin_notification_subj" AS "t1_c18", "languagesettings"."email_admin_notification" AS "t1_c19", "languagesettings"."email_admin_responses_subj" AS "t1_c20", "languagesettings"."email_admin_responses" AS "t1_c21", "languagesettings"."surveyls_numberformat" AS "t1_c22", "languagesettings"."attachments" AS "t1_c23", "languagesettings"."surveyls_policy_notice" AS "t1_c24", "languagesettings"."surveyls_policy_error" AS "t1_c25", "languagesettings"."surveyls_policy_notice_label" AS "t1_c26", "languagesettings"."surveyls_alias" AS "t1_c27" FROM "lime_surveys" "t" LEFT OUTER JOIN "lime_surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (((active = 'Y') AND ((startdate <= :now1 OR startdate IS NULL) AND (expires >= :now2 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now1='2025-04-03 02:52:29', :now2='2025-04-03 02:52:29') |
1 |
0.01816 |
0.01816 |
0.01816 |
0.01816 |
| 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.00164 |
0.00164 |
0.00164 |
0.00164 |
| 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.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_surveys_groups', :schema='public') |
1 |
0.00079 |
0.00079 |
0.00079 |
0.00079 |
| 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.00073 |
0.00073 |
0.00073 |
0.00073 |
| 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.00062 |
0.00062 |
0.00062 |
0.00062 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_surveys_groupsettings', :schema='public') |
1 |
0.00027 |
0.00027 |
0.00027 |
0.00027 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_surveys_groups', :schema='public') |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| system.db.CDbCommand.query(SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS adsrc,
a.attnotnull,
a.atthasdef,
pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_users', :schema='public') |
1 |
0.00071 |
0.00071 |
0.00071 |
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_users', :schema='public') |
1 |
0.00076 |
0.00076 |
0.00076 |
0.00076 |
| system.db.CDbCommand.query(SELECT
a.attname,
LOWER(format_type(a.atttypid, a.atttypmod)) AS type,
pg_get_expr(adbin, adrelid) AS adsrc,
a.attnotnull,
a.atthasdef,
pg_catalog.col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attnum > 0 AND NOT a.attisdropped
AND a.attrelid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace WHERE nspname = :schema))
ORDER BY a.attnum. Bound with :table='lime_asset_version', :schema='public') |
1 |
0.00076 |
0.00076 |
0.00076 |
0.00076 |
| system.db.CDbCommand.query(SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype::char,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname=:table
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname=:schema)). Bound with :table='lime_asset_version', :schema='public') |
1 |
0.00081 |
0.00081 |
0.00081 |
0.00081 |
| system.db.CDbCommand.query(SELECT "t"."sid" AS "t0_c0", "t"."owner_id" AS "t0_c1", "t"."admin" AS "t0_c2", "t"."active" AS "t0_c3", "t"."expires" AS "t0_c4", "t"."startdate" AS "t0_c5", "t"."adminemail" AS "t0_c6", "t"."anonymized" AS "t0_c7", "t"."faxto" AS "t0_c8", "t"."format" AS "t0_c9", "t"."savetimings" AS "t0_c10", "t"."template" AS "t0_c11", "t"."language" AS "t0_c12", "t"."additional_languages" AS "t0_c13", "t"."datestamp" AS "t0_c14", "t"."usecookie" AS "t0_c15", "t"."allowregister" AS "t0_c16", "t"."allowsave" AS "t0_c17", "t"."autonumber_start" AS "t0_c18", "t"."autoredirect" AS "t0_c19", "t"."allowprev" AS "t0_c20", "t"."printanswers" AS "t0_c21", "t"."ipaddr" AS "t0_c22", "t"."refurl" AS "t0_c23", "t"."datecreated" AS "t0_c24", "t"."publicstatistics" AS "t0_c25", "t"."publicgraphs" AS "t0_c26", "t"."listpublic" AS "t0_c27", "t"."htmlemail" AS "t0_c28", "t"."sendconfirmation" AS "t0_c29", "t"."tokenanswerspersistence" AS "t0_c30", "t"."assessments" AS "t0_c31", "t"."usecaptcha" AS "t0_c32", "t"."usetokens" AS "t0_c33", "t"."bounce_email" AS "t0_c34", "t"."attributedescriptions" AS "t0_c35", "t"."emailresponseto" AS "t0_c36", "t"."emailnotificationto" AS "t0_c37", "t"."tokenlength" AS "t0_c38", "t"."showxquestions" AS "t0_c39", "t"."showgroupinfo" AS "t0_c40", "t"."shownoanswer" AS "t0_c41", "t"."showqnumcode" AS "t0_c42", "t"."bouncetime" AS "t0_c43", "t"."bounceprocessing" AS "t0_c44", "t"."bounceaccounttype" AS "t0_c45", "t"."bounceaccounthost" AS "t0_c46", "t"."bounceaccountpass" AS "t0_c47", "t"."bounceaccountencryption" AS "t0_c48", "t"."bounceaccountuser" AS "t0_c49", "t"."showwelcome" AS "t0_c50", "t"."showprogress" AS "t0_c51", "t"."questionindex" AS "t0_c52", "t"."navigationdelay" AS "t0_c53", "t"."nokeyboard" AS "t0_c54", "t"."alloweditaftercompletion" AS "t0_c55", "t"."googleanalyticsstyle" AS "t0_c56", "t"."googleanalyticsapikey" AS "t0_c57", "t"."gsid" AS "t0_c58", "t"."showsurveypolicynotice" AS "t0_c59", "t"."tokenencryptionoptions" AS "t0_c60", "t"."ipanonymize" AS "t0_c61", "languagesettings"."surveyls_survey_id" AS "t1_c0", "languagesettings"."surveyls_language" AS "t1_c1", "languagesettings"."surveyls_title" AS "t1_c2", "languagesettings"."surveyls_description" AS "t1_c3", "languagesettings"."surveyls_welcometext" AS "t1_c4", "languagesettings"."surveyls_endtext" AS "t1_c5", "languagesettings"."surveyls_url" AS "t1_c6", "languagesettings"."surveyls_urldescription" AS "t1_c7", "languagesettings"."surveyls_email_invite_subj" AS "t1_c8", "languagesettings"."surveyls_email_invite" AS "t1_c9", "languagesettings"."surveyls_email_remind_subj" AS "t1_c10", "languagesettings"."surveyls_email_remind" AS "t1_c11", "languagesettings"."surveyls_email_register_subj" AS "t1_c12", "languagesettings"."surveyls_email_register" AS "t1_c13", "languagesettings"."surveyls_email_confirm_subj" AS "t1_c14", "languagesettings"."surveyls_email_confirm" AS "t1_c15", "languagesettings"."surveyls_dateformat" AS "t1_c16", "languagesettings"."surveyls_attributecaptions" AS "t1_c17", "languagesettings"."email_admin_notification_subj" AS "t1_c18", "languagesettings"."email_admin_notification" AS "t1_c19", "languagesettings"."email_admin_responses_subj" AS "t1_c20", "languagesettings"."email_admin_responses" AS "t1_c21", "languagesettings"."surveyls_numberformat" AS "t1_c22", "languagesettings"."attachments" AS "t1_c23", "languagesettings"."surveyls_policy_notice" AS "t1_c24", "languagesettings"."surveyls_policy_error" AS "t1_c25", "languagesettings"."surveyls_policy_notice_label" AS "t1_c26", "languagesettings"."surveyls_alias" AS "t1_c27" FROM "lime_surveys" "t" LEFT OUTER JOIN "lime_surveys_languagesettings" "languagesettings" ON ("languagesettings"."surveyls_survey_id"="t"."sid") WHERE (((active = 'Y') AND (allowregister = 'Y' AND startdate > :now3 AND (expires < :now4 OR expires IS NULL))) AND (listpublic = 'Y' or listpublic = 'I')). Bound with :now3='2025-04-03 02:52:30', :now4='2025-04-03 02:52:30') |
1 |
0.00055 |
0.00055 |
0.00055 |
0.00055 |
| 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_asset_version', :schema='public') |
1 |
0.00025 |
0.00025 |
0.00025 |
0.00025 |
| 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 * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/fruity_twentythree/files/favicon.ico') |
1 |
0.00024 |
0.00024 |
0.00024 |
0.00024 |
| 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.00062 |
0.00062 |
0.00062 |
0.00062 |
| system.db.CDbCommand.query(SELECT * FROM "lime_asset_version" "t" WHERE path = :path LIMIT 1. Bound with :path='/var/www/html/themes/survey/fruity_twentythree/files/poweredby.png') |
1 |
0.00060 |
0.00060 |
0.00060 |
0.00060 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1). Bound with :table='lime_users', :schema='public') |
1 |
0.00027 |
0.00027 |
0.00027 |
0.00027 |
| 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.00041 |
0.00041 |
0.00041 |
0.00041 |
| system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
attrelid=(
SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
)
)
AND attnum IN (1, 2). Bound with :table='lime_surveys_languagesettings', :schema='public') |
1 |
0.00026 |
0.00026 |
0.00026 |
0.00026 |
