Application Log
Timestamp Level Category Message
18:24:51.075826 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.087480 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.088710 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.15456s, Memory: 6,349KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
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.00961 0.00961 0.00961 0.00961
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (user_id IS NULL)) 3 0.00819 0.00273 0.00128 0.00560
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.00609 0.00609 0.00609 0.00609
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.00509 0.00170 0.00134 0.00227
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.00502 0.00502 0.00502 0.00502
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.00371 0.00371 0.00371 0.00371
system.db.CDbCommand.execute(DELETE FROM "tom_session" WHERE expire<:expire. Bound with :expire=1729614291) 1 0.00281 0.00281 0.00281 0.00281
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE "t"."id" IS NULL LIMIT 1) 2 0.00272 0.00136 0.00130 0.00142
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1) 2 0.00266 0.00133 0.00127 0.00139
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.00241 0.00241 0.00241 0.00241
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.00238 0.00238 0.00238 0.00238
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.00223 0.00223 0.00223 0.00223
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE ("t".global_user_id=-1) AND ("t"."id" IS NULL) LIMIT 1) 1 0.00178 0.00178 0.00178 0.00178
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.00150 0.00150 0.00150 0.00150
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.00143 0.00143 0.00143 0.00143
system.db.CDbCommand.query(SELECT "data" FROM "tom_session" WHERE expire>:expire AND id=:id. Bound with :expire=1729614291, :id='0uid73fehku050lh9nfotc5ncm') 1 0.00132 0.00132 0.00132 0.00132
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1 ORDER BY order_num) 1 0.00131 0.00131 0.00131 0.00131
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.00130 0.00130 0.00130 0.00130