Application Log
Timestamp Level Category Message
05:32:20.264092 info application
Language from browser
in
/var/www/html/tomas_prod/protected/modules/settings/components/SettingsManager.php
(34)
in /var/www/html/tomas_prod/index.php (9)
05:32:20.274379 info application
Using default langauge: sl
in
/var/www/html/tomas_prod/protected/modules/settings/components/SettingsManager.php
(48)
in /var/www/html/tomas_prod/index.php (9)
05:32:20.275917 info application
Changed CJuiDatePicker language to: sl
in
/var/www/html/tomas_prod/protected/modules/settings/components/SettingsManager.php
(66)
in /var/www/html/tomas_prod/index.php (9)
Profiling Summary Report (Time: 0.23075s, Memory: 6,200KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END 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.03403 0.03403 0.03403 0.03403
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.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.02321 0.02321 0.02321 0.02321
system.db.CDbCommand.execute(DELETE FROM "tom_session" WHERE expire<:expire. Bound with :expire=1743737540) 1 0.01303 0.01303 0.01303 0.01303
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.01097 0.01097 0.01097 0.01097
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.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.01035 0.01035 0.01035 0.01035
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE ("t".global_user_id=-1) AND ("t"."id" IS NULL) LIMIT 1) 1 0.00845 0.00845 0.00845 0.00845
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.00703 0.00703 0.00703 0.00703
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END 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.00505 0.00505 0.00505 0.00505
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (user_id IS NULL)) 3 0.00470 0.00157 0.00104 0.00234
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='sl', :global_user_id=-1) 1 0.00414 0.00414 0.00414 0.00414
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.00394 0.00131 0.00115 0.00162
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1) 2 0.00263 0.00132 0.00107 0.00156
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE "t"."id" IS NULL LIMIT 1) 2 0.00230 0.00115 0.00106 0.00124
system.db.CDbCommand.query(SELECT a.attname, LOWER(format_type(a.atttypid, a.atttypmod)) AS type, d.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.00224 0.00224 0.00224 0.00224
system.db.CDbCommand.query(SELECT conname, consrc, contype, indkey FROM ( SELECT conname, CASE WHEN contype='f' THEN pg_catalog.pg_get_constraintdef(oid) ELSE 'CHECK (' || consrc || ')' END 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.00203 0.00203 0.00203 0.00203
system.db.CDbCommand.query(SELECT "data" FROM "tom_session" WHERE expire>:expire AND id=:id. Bound with :expire=1743737540, :id='3sftg8hocja6bfb5l130ur8snr') 1 0.00179 0.00179 0.00179 0.00179
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.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1 ORDER BY order_num) 1 0.00137 0.00137 0.00137 0.00137