Log Messages

Total 270 item.
#TimeSince previousLevelCategoryMessage
   
107:02:06.723
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\bootstrap5\i18n\TranslationBootstrap::bootstrap()
207:02:06.725
< 1ms >
traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
307:02:06.725
< 0ms >
traceyii\base\Module::getModuleLoading module: debug
407:02:06.725
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
507:02:06.725
< 0ms >
traceyii\base\Module::getModuleLoading module: gii
607:02:06.725
< 0ms >
traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
707:02:06.725
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=1
807:02:06.735
< 9ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
907:02:06.736
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1007:02:06.737
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1107:02:06.737
< 0ms >
infoyii\web\Session::openSession started
1207:02:06.737
< 0ms >
traceyii\web\Application::handleRequestRoute requested: 'promotion/index'
1307:02:06.738
< 0ms >
traceyii\base\Controller::runActionRoute to run: promotion/index
1407:02:06.738
< 0ms >
traceyii\redis\Connection::openOpening redis DB connection: tcp://private-redis-agent-staging-do-user-13748639-0.b.db.ondigitalocean.com:25061, database=0
1507:02:06.747
< 8ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: AUTH
1607:02:06.748
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
1707:02:06.748
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1807:02:06.749
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
1907:02:06.749
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2007:02:06.750
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2107:02:06.751
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2207:02:06.751
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2307:02:06.752
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2407:02:06.752
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2507:02:06.753
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2607:02:06.753
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2707:02:06.754
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2807:02:06.754
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
2907:02:06.755
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3007:02:06.755
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3107:02:06.756
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3207:02:06.756
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3307:02:06.757
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3407:02:06.757
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3507:02:06.758
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3607:02:06.758
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3707:02:06.759
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
3807:02:06.760
< 0ms >
traceyii\base\InlineAction::runWithParamsRunning action: app\controllers\PromotionController::actionIndex()
3907:02:06.760
< 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
4007:02:06.780
< 20ms >
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;
4107:02:06.810
< 30ms >
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
4207:02:06.819
< 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;
4307:02:06.829
< 10ms >
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
4407:02:06.837
< 7ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/promotion/index.php
4507:02:06.837
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4607:02:06.839
< 2ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-19') AND ("end_date" >= '2025-06-19') AND ("start_time" <= '07:02') AND ("end_time" >= '07:02') AND ("is_active"=1) AND ("is_deleted"=0)
4707:02:06.847
< 7ms >
infoyii\db\Command::querySELECT * FROM "promotion" WHERE ("is_deleted"=0) AND ("start_date" <= '2025-06-19') AND ("end_date" >= '2025-06-19') AND ("start_time" <= '07:02') AND ("end_time" >= '07:02') AND ("is_active"=1) AND ("is_deleted"=0) ORDER BY "index", "current_join_count" DESC LIMIT 20
4807:02:06.851
< 3ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
4907:02:06.852
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5007:02:06.853
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5107:02:06.854
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5207:02:06.854
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5307:02:06.855
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5407:02:06.855
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5507:02:06.856
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5607:02:06.857
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5707:02:06.857
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5807:02:06.858
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
5907:02:06.858
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6007:02:06.859
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6107:02:06.859
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6207:02:06.860
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6307:02:06.862
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6407:02:06.863
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6507:02:06.864
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6607:02:06.864
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6707:02:06.865
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6807:02:06.865
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
6907:02:06.866
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7007:02:06.868
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7107:02:06.868
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7207:02:06.869
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7307:02:06.870
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7407:02:06.870
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7507:02:06.871
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7607:02:06.871
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7707:02:06.873
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7807:02:06.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
7907:02:06.874
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8007:02:06.875
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8107:02:06.875
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8207:02:06.876
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8307:02:06.877
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8407:02:06.877
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8507:02:06.878
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8607:02:06.878
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8707:02:06.880
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8807:02:06.881
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
8907:02:06.881
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9007:02:06.882
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9107:02:06.883
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9207:02:06.884
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9307:02:06.884
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9407:02:06.885
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9507:02:06.885
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9607:02:06.887
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9707:02:06.887
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9807:02:06.888
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
9907:02:06.888
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10007:02:06.890
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10107:02:06.890
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10207:02:06.891
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10307:02:06.892
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10407:02:06.892
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10507:02:06.893
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10607:02:06.894
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10707:02:06.894
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10807:02:06.895
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
10907:02:06.895
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11007:02:06.896
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11107:02:06.897
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11207:02:06.897
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11307:02:06.898
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11407:02:06.899
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11507:02:06.900
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11607:02:06.900
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11707:02:06.901
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11807:02:06.901
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
11907:02:06.902
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12007:02:06.904
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12107:02:06.904
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12207:02:06.905
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12307:02:06.905
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12407:02:06.906
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12507:02:06.907
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12607:02:06.907
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12707:02:06.908
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12807:02:06.909
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
12907:02:06.909
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13007:02:06.910
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13107:02:06.911
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13207:02:06.911
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13307:02:06.912
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13407:02:06.912
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13507:02:06.913
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13607:02:06.914
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13707:02:06.914
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13807:02:06.915
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
13907:02:06.915
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14007:02:06.916
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14107:02:06.916
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14207:02:06.917
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14307:02:06.917
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14407:02:06.918
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14507:02:06.918
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14607:02:06.919
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14707:02:06.920
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14807:02:06.920
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
14907:02:06.921
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15007:02:06.921
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15107:02:06.922
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15207:02:06.922
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15307:02:06.923
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15407:02:06.924
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15507:02:06.924
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15607:02:06.925
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15707:02:06.925
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15807:02:06.926
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
15907:02:06.927
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16007:02:06.927
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16107:02:06.928
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16207:02:06.929
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16307:02:06.929
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16407:02:06.930
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16507:02:06.931
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16607:02:06.931
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16707:02:06.932
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16807:02:06.932
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16907:02:06.933
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17007:02:06.933
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17107:02:06.934
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17207:02:06.934
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17307:02:06.935
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17407:02:06.936
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17507:02:06.936
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17607:02:06.937
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17707:02:06.937
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17807:02:06.938
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17907:02:06.938
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18007:02:06.939
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18107:02:06.939
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18207:02:06.940
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18307:02:06.941
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18407:02:06.941
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18507:02:06.942
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18607:02:06.942
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18707:02:06.943
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18807:02:06.944
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
18907:02:06.944
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19007:02:06.945
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19107:02:06.945
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19207:02:06.946
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19307:02:06.946
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19407:02:06.947
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19507:02:06.947
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19607:02:06.948
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19707:02:06.949
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19807:02:06.949
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
19907:02:06.950
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20007:02:06.950
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20107:02:06.951
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20207:02:06.952
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20307:02:06.953
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20407:02:06.953
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20507:02:06.954
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20607:02:06.954
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20707:02:06.955
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20807:02:06.956
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
20907:02:06.956
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21007:02:06.957
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21107:02:06.958
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21207:02:06.958
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21307:02:06.959
< 1ms >
infoyii\db\Command::querySELECT COUNT(*) FROM "promotion_ongoing" WHERE ("join_date" >= '2025-06-12 00:00:00') AND ("join_date" <= '2025-06-19 23:59:59')
21407:02:06.973
< 13ms >
traceyii\base\View::renderFileRendering view file: /var/www/member-area/views/layouts/main.php
21507:02:06.973
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21607:02:06.974
< 1ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21707:02:06.974
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21807:02:06.975
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21907:02:06.975
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22007:02:06.976
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22107:02:06.976
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22207:02:06.977
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22307:02:06.977
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22407:02:06.978
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22507:02:06.978
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22607:02:06.979
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22707:02:06.979
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22807:02:06.980
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
22907:02:06.980
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23007:02:06.981
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23107:02:06.981
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23207:02:06.982
< 0ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='menu_order'
23307:02:06.985
< 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;
23407:02:07.002
< 16ms >
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
23507:02:07.013
< 10ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='language'
23607:02:07.015
< 2ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23707:02:07.016
< 1ms >
infoyii\db\Command::querySELECT * FROM "agent_setting" WHERE "key"='active_qris'
23807:02:07.021
< 5ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
23907:02:07.022
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24007:02:07.023
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24107:02:07.023
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24207:02:07.024
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24307:02:07.024
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24407:02:07.025
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24507:02:07.025
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24607:02:07.026
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24707:02:07.026
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24807:02:07.027
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
24907:02:07.027
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25007:02:07.028
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25107:02:07.028
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25207:02:07.029
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25307:02:07.029
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25407:02:07.030
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25507:02:07.030
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25607:02:07.031
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25707:02:07.031
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25807:02:07.032
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
25907:02:07.032
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26007:02:07.033
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26107:02:07.033
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26207:02:07.034
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26307:02:07.034
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26407:02:07.035
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26507:02:07.035
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26607:02:07.036
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26707:02:07.036
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: HGET
26807:02:07.037
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
26907:02:07.038
< 0ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
27007:02:07.042
< 4ms >
traceyii\redis\Connection::executeCommandExecuting Redis Command: SET