Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
102:17:07.900
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
202:17:07.901
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
302:17:07.901
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
402:17:07.902
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
502:17:07.902
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
602:17:07.902
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
702:17:07.902
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
802:17:07.910
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
902:17:07.912
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1002:17:07.912
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1102:17:07.912
< 0ms >
infoyii\web\Session::openSession started
1202:17:07.913
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1302:17:07.913
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1402:17:07.913
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1502:17:07.921
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1602:17:07.923
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1702:17:07.923
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1802:17:07.924
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1902:17:07.924
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2002:17:07.925
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2102:17:07.925
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2202:17:07.926
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2302:17:07.926
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2402:17:07.927
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2502:17:07.927
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2602:17:07.928
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2702:17:07.928
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2802:17:07.929
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2902:17:07.929
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3002:17:07.930
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3102:17:07.930
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3202:17:07.931
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3302:17:07.931
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3402:17:07.932
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3502:17:07.932
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3602:17:07.933
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3702:17:07.933
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3802:17:07.934
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3902:17:07.936
< 2ms >
infoyii\db\Connection::openOpening DB connection: pgsql:host=private-postgresql-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com;port=25060;dbname=defaultdb
4002:17:07.951
< 15ms >
infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'promotion' AND d.nspname = 'public' ORDER BY a.attnum;
4102:17:07.965
< 13ms >
infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='promotion' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
4202:17:07.996
< 31ms >
infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'promotion_ongoing' AND d.nspname = 'public' ORDER BY a.attnum;
4302:17:08.005
< 8ms >
infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='promotion_ongoing' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
4402:17:08.010
< 5ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4502:17:08.018
< 7ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4602:17:08.027
< 9ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-09') AND ("end_date" >= '2025-05-09') AND ("start_time" <= '02:17') AND ("end_time" >= '02:17') AND ("is_active"=1) AND ("is_deleted"=0)
4702:17:08.031
< 4ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-09') AND ("end_date" >= '2025-05-09') AND ("start_time" <= '02:17') AND ("end_time" >= '02:17') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4802:17:08.033
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4902:17:08.035
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5002:17:08.035
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5102:17:08.036
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5202:17:08.037
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5302:17:08.037
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5402:17:08.038
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5502:17:08.038
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5602:17:08.039
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5702:17:08.040
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5802:17:08.041
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5902:17:08.042
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6002:17:08.042
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6102:17:08.043
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6202:17:08.044
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6302:17:08.044
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6402:17:08.045
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6502:17:08.045
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6602:17:08.048
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6702:17:08.048
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6802:17:08.049
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6902:17:08.049
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7002:17:08.050
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7102:17:08.050
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7202:17:08.051
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7302:17:08.051
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7402:17:08.052
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7502:17:08.053
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7602:17:08.054
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7702:17:08.055
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7802:17:08.055
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7902:17:08.056
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8002:17:08.056
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8102:17:08.057
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8202:17:08.058
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8302:17:08.058
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8402:17:08.059
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8502:17:08.059
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8602:17:08.060
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8702:17:08.060
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8802:17:08.061
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8902:17:08.062
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9002:17:08.062
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9102:17:08.063
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9202:17:08.063
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9302:17:08.064
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9402:17:08.064
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9502:17:08.065
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9602:17:08.066
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9702:17:08.066
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9802:17:08.067
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9902:17:08.067
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10002:17:08.068
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10102:17:08.069
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10202:17:08.069
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10302:17:08.070
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10402:17:08.071
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10502:17:08.072
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10602:17:08.072
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10702:17:08.073
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10802:17:08.073
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10902:17:08.074
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11002:17:08.075
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11102:17:08.075
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11202:17:08.076
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11302:17:08.077
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11402:17:08.077
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11502:17:08.078
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11602:17:08.078
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11702:17:08.079
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11802:17:08.079
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11902:17:08.080
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12002:17:08.081
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12102:17:08.081
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12202:17:08.082
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12302:17:08.083
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12402:17:08.084
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12502:17:08.084
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12602:17:08.085
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12702:17:08.085
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12802:17:08.086
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12902:17:08.087
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13002:17:08.088
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13102:17:08.088
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13202:17:08.089
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13302:17:08.090
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13402:17:08.090
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13502:17:08.091
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13602:17:08.091
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13702:17:08.092
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13802:17:08.092
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13902:17:08.093
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14002:17:08.093
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14102:17:08.094
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14202:17:08.094
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14302:17:08.095
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14402:17:08.096
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14502:17:08.096
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14602:17:08.097
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14702:17:08.097
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14802:17:08.098
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14902:17:08.098
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15002:17:08.099
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15102:17:08.100
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15202:17:08.100
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15302:17:08.101
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15402:17:08.102
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15502:17:08.102
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15602:17:08.103
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15702:17:08.103
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15802:17:08.104
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15902:17:08.105
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16002:17:08.105
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16102:17:08.106
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16202:17:08.107
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16302:17:08.107
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16402:17:08.108
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16502:17:08.108
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16602:17:08.109
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16702:17:08.109
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16802:17:08.110
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16902:17:08.111
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17002:17:08.111
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17102:17:08.112
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17202:17:08.112
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17302:17:08.113
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17402:17:08.113
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17502:17:08.114
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17602:17:08.114
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17702:17:08.115
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17802:17:08.115
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17902:17:08.118
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18002:17:08.118
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18102:17:08.119
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18202:17:08.119
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18302:17:08.120
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18402:17:08.120
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18502:17:08.121
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18602:17:08.121
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18702:17:08.122
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18802:17:08.122
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18902:17:08.123
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19002:17:08.124
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19102:17:08.124
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19202:17:08.125
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19302:17:08.125
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19402:17:08.126
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19502:17:08.126
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19602:17:08.127
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19702:17:08.127
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19802:17:08.128
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19902:17:08.128
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20002:17:08.129
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20102:17:08.129
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20202:17:08.130
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20302:17:08.130
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20402:17:08.131
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20502:17:08.131
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20602:17:08.132
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20702:17:08.133
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20802:17:08.133
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20902:17:08.134
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21002:17:08.134
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21102:17:08.135
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21202:17:08.135
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21302:17:08.137
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-05-02 00:00:00') AND ("join_date" <= '2025-05-09 23:59:59')
21402:17:08.139
< 2ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21502:17:08.139
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21602:17:08.140
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21702:17:08.140
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21802:17:08.141
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21902:17:08.141
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22002:17:08.142
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22102:17:08.143
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22202:17:08.143
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22302:17:08.144
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22402:17:08.144
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22502:17:08.144
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22602:17:08.145
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22702:17:08.145
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22802:17:08.146
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22902:17:08.146
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23002:17:08.147
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23102:17:08.147
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23202:17:08.148
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23302:17:08.150
< 2ms >
infoyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, COALESCE(td.typname, tb.typname, t.typname) AS data_type, COALESCE(td.typtype, tb.typtype, t.typtype) AS type_type, (SELECT nspname FROM pg_namespace WHERE oid = COALESCE(td.typnamespace, tb.typnamespace, t.typnamespace)) AS type_scheme, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) OR attidentity != '' AS is_autoinc, pg_get_serial_sequence(quote_ident(d.nspname) || '.' || quote_ident(c.relname), a.attname) AS sequence_name, CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',') ELSE NULL END AS enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey, COALESCE(NULLIF(a.attndims, 0), NULLIF(t.typndims, 0), (t.typcategory='A')::int) AS dimension FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_type tb ON (a.attndims > 0 OR t.typcategory='A') AND t.typelem > 0 AND t.typelem = tb.oid OR t.typbasetype > 0 AND t.typbasetype = tb.oid LEFT JOIN pg_type td ON t.typndims > 0 AND t.typbasetype > 0 AND tb.typelem = td.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT JOIN pg_constraint ct ON ct.conrelid = c.oid AND ct.contype = 'p' WHERE a.attnum > 0 AND t.typname != '' AND NOT a.attisdropped AND c.relname = 'agent_setting' AND d.nspname = 'public' ORDER BY a.attnum;
23402:17:08.156
< 5ms >
infoyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='agent_setting' and ns.nspname='public' order by fns.nspname, fc.relname, a.attnum
23502:17:08.161
< 4ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23602:17:08.162
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23702:17:08.164
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23802:17:08.165
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23902:17:08.166
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24002:17:08.166
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24102:17:08.167
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24202:17:08.168
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24302:17:08.168
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24402:17:08.168
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24502:17:08.169
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24602:17:08.169
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24702:17:08.170
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24802:17:08.170
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24902:17:08.171
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25002:17:08.171
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25102:17:08.172
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25202:17:08.172
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25302:17:08.173
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25402:17:08.173
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25502:17:08.174
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25602:17:08.174
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25702:17:08.175
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25802:17:08.175
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25902:17:08.176
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26002:17:08.176
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26102:17:08.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26202:17:08.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26302:17:08.178
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26402:17:08.178
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26502:17:08.178
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26602:17:08.179
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26702:17:08.180
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26802:17:08.181
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26902:17:08.181
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27002:17:08.185
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET