Application Log
Timestamp Level Category Message
08:14:44.222362 info application
Language from browser
in /var/www/html/protected/modules/settings/components/SettingsManager.php
(34)
in /var/www/html/index.php (9)
08:14:44.225681 info application
Using default langauge: en
in /var/www/html/protected/modules/settings/components/SettingsManager.php
(48)
in /var/www/html/index.php (9)
08:14:44.226738 info application
Changed CJuiDatePicker language to: en
in /var/www/html/protected/modules/settings/components/SettingsManager.php
(66)
in /var/www/html/index.php (9)
Profiling Summary Report (Time: 0.05110s, Memory: 5,782KB)
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='tom_settings', :schema='public') 1 0.00289 0.00289 0.00289 0.00289
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, 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='tom_settings', :schema='public') 1 0.00209 0.00209 0.00209 0.00209
system.db.CDbCommand.query(SELECT t1.message AS message, CASE WHEN t3.translation IS NOT NULL THEN t3.translation ELSE t2.translation END AS translation FROM tom_source_message t1 LEFT OUTER JOIN tom_translated_message t2 ON t1.id=t2.source_id AND t2.language=:language LEFT OUTER JOIN tom_translated_message_user t3 ON t3.source_id = t1.id AND t3.language=:language AND t3.global_user_id = :global_user_id WHERE t1.category=:category AND (t2.translation IS NOT NULL OR t3.translation IS NOT NULL). Bound with :category='app', :language='en', :global_user_id=-1) 1 0.00185 0.00185 0.00185 0.00185
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, 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='tom_users', :schema='public') 1 0.00113 0.00113 0.00113 0.00113
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, pg_catalog.pg_get_constraintdef(oid) AS consrc, contype, 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='tom_languages', :schema='public') 1 0.00109 0.00109 0.00109 0.00109
system.db.CDbCommand.execute(DELETE FROM "tom_session" WHERE expire<:expire. Bound with :expire=1751523284) 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='tom_users', :schema='public') 1 0.00093 0.00093 0.00093 0.00093
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (group_id IS NULL AND user_id IS NULL)) 3 0.00084 0.00028 0.00022 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='tom_languages', :schema='public') 1 0.00072 0.00072 0.00072 0.00072
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (user_id IS NULL)) 3 0.00067 0.00022 0.00022 0.00023
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE ("t".global_user_id=-1) AND ("t"."id" IS NULL) LIMIT 1) 1 0.00057 0.00057 0.00057 0.00057
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1) 2 0.00054 0.00027 0.00021 0.00033
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE "t"."id" IS NULL LIMIT 1) 2 0.00041 0.00021 0.00020 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 (4). Bound with :table='tom_settings', :schema='public') 1 0.00036 0.00036 0.00036 0.00036
system.db.CDbCommand.query(SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE attrelid=( SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=( SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema ) ) AND attnum IN (1). Bound with :table='tom_languages', :schema='public') 1 0.00035 0.00035 0.00035 0.00035
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1 ORDER BY order_num) 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='tom_users', :schema='public') 1 0.00031 0.00031 0.00031 0.00031
system.db.CDbCommand.query(SELECT "data" FROM "tom_session" WHERE expire>:expire AND id=:id. Bound with :expire=1751523284, :id='a5q2b54idlnlhrhdajrolqvc0j') 1 0.00028 0.00028 0.00028 0.00028