Application Log
Timestamp Level Category Message
18:24:51.317974 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)
18:24:51.328757 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)
18:24:51.330105 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.13146s, Memory: 6,576KB)
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, 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.00924 0.00924 0.00924 0.00924
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.00672 0.00672 0.00672 0.00672
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.00561 0.00561 0.00561 0.00561
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (user_id IS NULL)) 3 0.00502 0.00167 0.00126 0.00213
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.00425 0.00142 0.00120 0.00177
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.00400 0.00400 0.00400 0.00400
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.00312 0.00312 0.00312 0.00312
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.00294 0.00294 0.00294 0.00294
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE "t"."id" IS NULL LIMIT 1) 2 0.00240 0.00120 0.00119 0.00120
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE ("t".global_user_id=-1) AND ("t"."id" IS NULL) LIMIT 1) 1 0.00230 0.00230 0.00230 0.00230
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.00188 0.00188 0.00188 0.00188
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='button.resetPassword', :language='sl', :global_user_id=-1) 1 0.00177 0.00177 0.00177 0.00177
system.db.CDbCommand.query(SELECT "data" FROM "tom_session" WHERE expire>:expire AND id=:id. Bound with :expire=1729614291, :id='8hbejbukqm4it67647lltc8m8g') 1 0.00171 0.00171 0.00171 0.00171
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.00166 0.00166 0.00166 0.00166
system.db.CDbCommand.execute(DELETE FROM "tom_session" WHERE expire<:expire. Bound with :expire=1729614291) 1 0.00156 0.00156 0.00156 0.00156
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1) 1 0.00153 0.00153 0.00153 0.00153
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1 ORDER BY order_num) 1 0.00144 0.00144 0.00144 0.00144
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.00137 0.00137 0.00137 0.00137
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.00133 0.00133 0.00133 0.00133