Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
108:00:53.391
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
208:00:53.392
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
308:00:53.392
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
408:00:53.392
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
508:00:53.392
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
608:00:53.392
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
708:00:53.392
< 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:00:53.401
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
908:00:53.403
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1008:00:53.404
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1108:00:53.404
< 0ms >
infoyii\web\Session::openSession started
1208:00:53.405
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1308:00:53.405
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1408:00:53.405
< 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:00:53.415
< 10ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1608:00:53.417
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1708:00:53.418
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1808:00:53.418
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1908:00:53.419
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2008:00:53.419
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2108:00:53.420
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2208:00:53.421
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2308:00:53.421
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2408:00:53.422
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2508:00:53.422
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2608:00:53.423
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2708:00:53.423
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2808:00:53.424
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2908:00:53.424
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3008:00:53.425
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3108:00:53.426
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3208:00:53.426
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3308:00:53.427
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3408:00:53.427
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3508:00:53.428
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3608:00:53.428
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3708:00:53.429
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3808:00:53.430
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3908:00:53.430
< 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:00:53.489
< 58ms >
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:00:53.506
< 17ms >
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:00:53.514
< 8ms >
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:00:53.524
< 9ms >
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:00:53.530
< 6ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4508:00:53.531
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4608:00:53.535
< 3ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-27') AND ("end_date" >= '2025-06-27') AND ("start_time" <= '08:00') AND ("end_time" >= '08:00') AND ("is_active"=1) AND ("is_deleted"=0)
4708:00:53.540
< 5ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-27') AND ("end_date" >= '2025-06-27') AND ("start_time" <= '08:00') AND ("end_time" >= '08:00') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4808:00:53.543
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4908:00:53.544
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5008:00:53.545
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5108:00:53.546
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5208:00:53.547
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5308:00:53.548
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5408:00:53.548
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5508:00:53.549
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5608:00:53.549
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5708:00:53.550
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5808:00:53.551
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5908:00:53.551
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6008:00:53.552
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6108:00:53.553
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6208:00:53.553
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6308:00:53.554
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6408:00:53.555
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6508:00:53.555
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6608:00:53.556
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6708:00:53.557
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6808:00:53.557
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6908:00:53.558
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7008:00:53.559
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7108:00:53.560
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7208:00:53.560
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7308:00:53.561
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7408:00:53.562
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7508:00:53.562
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7608:00:53.563
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7708:00:53.564
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7808:00:53.564
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7908:00:53.565
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8008:00:53.566
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8108:00:53.566
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8208:00:53.567
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8308:00:53.568
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8408:00:53.569
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8508:00:53.569
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8608:00:53.570
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8708:00:53.570
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8808:00:53.571
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8908:00:53.572
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9008:00:53.573
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9108:00:53.573
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9208:00:53.574
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9308:00:53.575
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9408:00:53.575
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9508:00:53.576
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9608:00:53.576
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9708:00:53.577
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9808:00:53.578
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9908:00:53.578
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10008:00:53.579
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10108:00:53.580
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10208:00:53.580
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10308:00:53.581
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10408:00:53.582
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10508:00:53.582
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10608:00:53.583
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10708:00:53.584
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10808:00:53.584
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10908:00:53.585
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11008:00:53.586
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11108:00:53.587
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11208:00:53.587
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11308:00:53.588
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11408:00:53.588
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11508:00:53.589
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11608:00:53.590
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11708:00:53.590
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11808:00:53.591
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11908:00:53.591
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12008:00:53.592
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12108:00:53.592
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12208:00:53.593
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12308:00:53.594
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12408:00:53.595
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12508:00:53.596
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12608:00:53.597
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12708:00:53.597
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12808:00:53.598
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12908:00:53.599
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13008:00:53.601
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13108:00:53.601
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13208:00:53.602
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13308:00:53.603
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13408:00:53.603
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13508:00:53.604
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13608:00:53.605
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13708:00:53.606
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13808:00:53.606
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13908:00:53.607
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14008:00:53.608
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14108:00:53.608
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14208:00:53.609
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14308:00:53.610
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14408:00:53.610
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14508:00:53.611
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14608:00:53.611
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14708:00:53.612
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14808:00:53.613
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14908:00:53.613
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15008:00:53.614
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15108:00:53.615
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15208:00:53.615
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15308:00:53.616
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15408:00:53.616
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15508:00:53.617
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15608:00:53.618
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15708:00:53.618
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15808:00:53.619
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15908:00:53.620
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16008:00:53.621
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16108:00:53.622
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16208:00:53.622
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16308:00:53.623
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16408:00:53.623
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16508:00:53.624
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16608:00:53.625
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16708:00:53.625
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16808:00:53.626
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16908:00:53.627
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17008:00:53.627
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17108:00:53.628
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17208:00:53.629
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17308:00:53.630
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17408:00:53.631
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17508:00:53.631
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17608:00:53.632
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17708:00:53.633
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17808:00:53.634
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17908:00:53.635
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18008:00:53.635
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18108:00:53.636
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18208:00:53.636
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18308:00:53.638
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18408:00:53.638
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18508:00:53.639
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18608:00:53.640
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18708:00:53.641
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18808:00:53.645
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18908:00:53.659
< 14ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19008:00:53.663
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19108:00:53.665
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19208:00:53.666
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19308:00:53.667
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19408:00:53.668
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19508:00:53.669
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19608:00:53.669
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19708:00:53.670
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19808:00:53.671
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19908:00:53.672
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20008:00:53.672
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20108:00:53.673
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20208:00:53.674
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20308:00:53.676
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20408:00:53.676
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20508:00:53.679
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20608:00:53.680
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20708:00:53.681
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20808:00:53.681
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20908:00:53.683
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21008:00:53.684
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21108:00:53.685
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21208:00:53.686
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21308:00:53.688
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-06-20 00:00:00') AND ("join_date" <= '2025-06-27 23:59:59')
21408:00:53.702
< 13ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21508:00:53.702
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21608:00:53.703
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21708:00:53.706
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21808:00:53.707
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21908:00:53.708
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22008:00:53.708
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22108:00:53.709
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22208:00:53.709
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22308:00:53.710
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22408:00:53.710
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22508:00:53.711
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22608:00:53.711
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22708:00:53.712
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22808:00:53.713
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22908:00:53.713
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23008:00:53.714
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23108:00:53.714
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23208:00:53.715
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23308:00:53.719
< 4ms >
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:00:53.764
< 44ms >
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:00:53.778
< 14ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23608:00:53.786
< 7ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23708:00:53.787
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23808:00:53.789
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23908:00:53.790
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24008:00:53.791
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24108:00:53.792
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24208:00:53.792
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24308:00:53.793
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24408:00:53.794
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24508:00:53.794
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24608:00:53.795
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24708:00:53.795
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24808:00:53.796
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24908:00:53.796
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25008:00:53.797
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25108:00:53.797
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25208:00:53.798
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25308:00:53.798
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25408:00:53.800
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25508:00:53.801
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25608:00:53.803
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25708:00:53.804
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25808:00:53.805
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25908:00:53.805
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26008:00:53.806
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26108:00:53.807
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26208:00:53.807
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26308:00:53.808
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26408:00:53.808
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26508:00:53.810
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26608:00:53.811
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26708:00:53.812
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26808:00:53.815
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26908:00:53.815
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27008:00:53.840
< 24ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET