Application Log
Timestamp Level Category Message
19:21:38.334055 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)
19:21:38.337222 info application 
Changed CJuiDatePicker language to: en
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.13467s, Memory: 6,363KB)
Procedure Count Total (s) Avg. (s) Min. (s) Max. (s)
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.00592 0.00197 0.00148 0.00292
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.00551 0.00551 0.00551 0.00551
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.00456 0.00456 0.00456 0.00456
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.00444 0.00444 0.00444 0.00444
system.db.CDbCommand.query(SELECT * FROM "tom_settings" "t" WHERE ("t".global_user_id=-1) AND (user_id IS NULL)) 3 0.00416 0.00139 0.00116 0.00152
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1) 3 0.00367 0.00122 0.00111 0.00139
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.00311 0.00311 0.00311 0.00311
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.00307 0.00307 0.00307 0.00307
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE ("t".global_user_id=-1) AND ("t"."id" IS NULL) LIMIT 1) 1 0.00282 0.00282 0.00282 0.00282
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.00258 0.00258 0.00258 0.00258
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.00253 0.00253 0.00253 0.00253
system.db.CDbCommand.query(SELECT * FROM "tom_users" "t" WHERE "t"."id" IS NULL LIMIT 1) 2 0.00245 0.00123 0.00111 0.00134
system.db.CDbCommand.execute(DELETE FROM "tom_session" WHERE expire<:expire. Bound with :expire=1742494898) 1 0.00240 0.00240 0.00240 0.00240
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.00201 0.00201 0.00201 0.00201
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.00144 0.00144 0.00144 0.00144
system.db.CDbCommand.query(SELECT * FROM "tom_languages" "t" WHERE valid = 1 ORDER BY order_num) 1 0.00128 0.00128 0.00128 0.00128
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.00128 0.00128 0.00128 0.00128
system.db.CDbCommand.query(SELECT "data" FROM "tom_session" WHERE expire>:expire AND id=:id. Bound with :expire=1742494898, :id='f8mhue6i35fii31g2rk8e8valr') 1 0.00120 0.00120 0.00120 0.00120