Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
108:09:48.154
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
208:09:48.155
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
308:09:48.156
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
408:09:48.156
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
508:09:48.156
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
608:09:48.156
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
708:09:48.156
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
808:09:48.165
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
908:09:48.166
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1008:09:48.166
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1108:09:48.167
< 0ms >
infoyii\web\Session::openSession started
1208:09:48.167
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1308:09:48.167
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1408:09:48.167
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1508:09:48.175
< 7ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1608:09:48.176
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1708:09:48.176
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1808:09:48.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1908:09:48.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2008:09:48.177
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2108:09:48.178
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2208:09:48.178
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2308:09:48.179
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2408:09:48.179
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2508:09:48.179
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2608:09:48.180
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2708:09:48.180
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2808:09:48.181
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2908:09:48.181
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3008:09:48.182
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3108:09:48.182
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3208:09:48.182
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3308:09:48.183
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3408:09:48.183
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3508:09:48.184
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3608:09:48.184
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3708:09:48.185
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3808:09:48.185
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3908:09:48.185
< 0ms >
infoyii\db\Connection::openOpening DB connection: pgsql:host=private-postgresql-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com;port=25060;dbname=defaultdb
4008:09:48.202
< 16ms >
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;
4108:09:48.217
< 15ms >
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
4208:09:48.224
< 6ms >
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;
4308:09:48.232
< 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
4408:09:48.238
< 5ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4508:09:48.239
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4608:09:48.241
< 2ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-16') AND ("end_date" >= '2025-05-16') AND ("start_time" <= '08:09') AND ("end_time" >= '08:09') AND ("is_active"=1) AND ("is_deleted"=0)
4708:09:48.245
< 3ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-05-16') AND ("end_date" >= '2025-05-16') AND ("start_time" <= '08:09') AND ("end_time" >= '08:09') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4808:09:48.247
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4908:09:48.248
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5008:09:48.249
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5108:09:48.250
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5208:09:48.250
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5308:09:48.251
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5408:09:48.251
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5508:09:48.252
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5608:09:48.252
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5708:09:48.253
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5808:09:48.253
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5908:09:48.254
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6008:09:48.254
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6108:09:48.255
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6208:09:48.255
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6308:09:48.256
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6408:09:48.256
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6508:09:48.257
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6608:09:48.257
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6708:09:48.258
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6808:09:48.258
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6908:09:48.259
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7008:09:48.259
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7108:09:48.259
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7208:09:48.260
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7308:09:48.260
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7408:09:48.261
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7508:09:48.261
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7608:09:48.262
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7708:09:48.263
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7808:09:48.263
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7908:09:48.263
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8008:09:48.264
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8108:09:48.265
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8208:09:48.265
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8308:09:48.266
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8408:09:48.266
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8508:09:48.267
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8608:09:48.268
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8708:09:48.268
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8808:09:48.269
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8908:09:48.269
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9008:09:48.270
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9108:09:48.271
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9208:09:48.271
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9308:09:48.272
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9408:09:48.272
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9508:09:48.273
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9608:09:48.273
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9708:09:48.274
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9808:09:48.275
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9908:09:48.275
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10008:09:48.276
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10108:09:48.276
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10208:09:48.277
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10308:09:48.277
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10408:09:48.278
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10508:09:48.279
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10608:09:48.279
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10708:09:48.280
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10808:09:48.280
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10908:09:48.281
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11008:09:48.282
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11108:09:48.282
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11208:09:48.283
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11308:09:48.283
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11408:09:48.284
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11508:09:48.284
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11608:09:48.285
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11708:09:48.285
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11808:09:48.286
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11908:09:48.286
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12008:09:48.287
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12108:09:48.288
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12208:09:48.288
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12308:09:48.289
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12408:09:48.289
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12508:09:48.290
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12608:09:48.290
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12708:09:48.291
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12808:09:48.291
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12908:09:48.292
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13008:09:48.292
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13108:09:48.293
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13208:09:48.294
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13308:09:48.294
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13408:09:48.295
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13508:09:48.295
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13608:09:48.296
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13708:09:48.296
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13808:09:48.297
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13908:09:48.297
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14008:09:48.298
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14108:09:48.299
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14208:09:48.299
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14308:09:48.300
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14408:09:48.300
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14508:09:48.301
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14608:09:48.301
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14708:09:48.302
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14808:09:48.302
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14908:09:48.303
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15008:09:48.303
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15108:09:48.304
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15208:09:48.304
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15308:09:48.305
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15408:09:48.306
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15508:09:48.306
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15608:09:48.307
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15708:09:48.307
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15808:09:48.308
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15908:09:48.308
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16008:09:48.309
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16108:09:48.310
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16208:09:48.310
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16308:09:48.311
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16408:09:48.311
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16508:09:48.312
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16608:09:48.312
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16708:09:48.313
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16808:09:48.313
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16908:09:48.315
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17008:09:48.316
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17108:09:48.317
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17208:09:48.317
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17308:09:48.318
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17408:09:48.318
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17508:09:48.318
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17608:09:48.319
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17708:09:48.319
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17808:09:48.320
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17908:09:48.321
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18008:09:48.321
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18108:09:48.322
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18208:09:48.322
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18308:09:48.323
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18408:09:48.323
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18508:09:48.324
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18608:09:48.324
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18708:09:48.325
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18808:09:48.325
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18908:09:48.326
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19008:09:48.326
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19108:09:48.327
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19208:09:48.327
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19308:09:48.328
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19408:09:48.328
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19508:09:48.329
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19608:09:48.330
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19708:09:48.330
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19808:09:48.331
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19908:09:48.331
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20008:09:48.332
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20108:09:48.333
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20208:09:48.333
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20308:09:48.334
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20408:09:48.334
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20508:09:48.335
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20608:09:48.335
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20708:09:48.336
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20808:09:48.337
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20908:09:48.337
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21008:09:48.338
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21108:09:48.339
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21208:09:48.339
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21308:09:48.340
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-05-09 00:00:00') AND ("join_date" <= '2025-05-16 23:59:59')
21408:09:48.343
< 2ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21508:09:48.343
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21608:09:48.344
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21708:09:48.344
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21808:09:48.345
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21908:09:48.345
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22008:09:48.346
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22108:09:48.346
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22208:09:48.347
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22308:09:48.348
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22408:09:48.348
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22508:09:48.349
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22608:09:48.349
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22708:09:48.350
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22808:09:48.350
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22908:09:48.351
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23008:09:48.351
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23108:09:48.352
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23208:09:48.352
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23308:09:48.355
< 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;
23408:09:48.362
< 7ms >
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
23508:09:48.367
< 5ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23608:09:48.369
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23708:09:48.370
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23808:09:48.372
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23908:09:48.372
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24008:09:48.373
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24108:09:48.373
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24208:09:48.374
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24308:09:48.374
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24408:09:48.374
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24508:09:48.375
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24608:09:48.375
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24708:09:48.376
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24808:09:48.376
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24908:09:48.377
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25008:09:48.377
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25108:09:48.378
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25208:09:48.378
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25308:09:48.379
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25408:09:48.379
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25508:09:48.380
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25608:09:48.380
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25708:09:48.380
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25808:09:48.381
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25908:09:48.381
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26008:09:48.382
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26108:09:48.382
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26208:09:48.383
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26308:09:48.383
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26408:09:48.384
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26508:09:48.384
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26608:09:48.384
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26708:09:48.385
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26808:09:48.386
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26908:09:48.387
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27008:09:48.391
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET